Ruby Eswara
Tableau developer · NSF INTERNATIONAL
NoviWork Experience
Tableau developer
NSF INTERNATIONAL2016 – 2021
NSF International Inc. is one of the largest Public health and safety company in product testing, inspection and certification organization based in Ann Arbor, Michigan.
• Analyzed business requirements, system requirements, and data mapping requirement specifications interacting with client, developers and QA team. • Interacted effectively with the business team to get clarified on requirements questions. • Developed and executed test cases based on the requirements signed off. • Experienced in creating and setting up the test data for the different use cases in the functional spec. • Prepared the Test Plan and Testing Strategies for various projects. • Developed Tableau Reports and Customize the reports accordingly. • Validated the data in the reports by writing SQL queries. • Created and implemented Tableau best-practices on migrating and governing the dashboards in multiple environments. • Created and managed Sites, Users, Groups and Projects in Dev/QA/PROD environments. • Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop. Projects Details: Project 1: Material database: Where materials that are ingredients or inputs into other products or processes is certified. Many of these materials are used repeatedly by different customers in different products or processes. Currently these materials are used in new products and processes, and they do not have a system in place to track the review of these ingredients to avoid re-review each time the material is used again. Project 2: SAM (Super allocation machine) is an audit scheduling tool and may be 20 people across the company will be scheduling the audit from this tool on daily basis. The admin will schedule the work for the auditors across the country.
Tools/Technologies: Tableau Desktop (2020.3, 10.3 & 9.3), TOAD, Oracle 12c, MS Office, Windows, MS Excel
Tableau Consultant
IT AMERICA2014 – 2016
• Consulted with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle. • Working End-To-End between business and IT. • Assist development teams to maintain all data sources and data storage options. • Coordinate with application team and develop all ETL processes. • Provide an efficient interface with brand for all processes across various platforms. • Design all program specifications and perform required tests in same. • Prepare codes for all modules according to require specification and client requirements and prepare all required test plan. • Prepare all program and system implementation for all informatics programs. • Monitor all production issues and inquiries and provide efficient resolution for same. • Evaluate all functional requirements and map documents and perform troubleshoot on all development processes. • Collaborate with application groups to prepare effective solutions for all programs. • Documents all technical specifications and associate project deliverables. • Design all test cases to provide support to all systems and perform unit tests • Gives presentations and demoes the projects to the business, outside providers and offshore consultant. • Expert in communicating with the business, gathering the requirement, refining it and making them way more explicit to understand. • Updating the stories and writing the requirement in SQL. Creating the view/store proc then engineering the reports in Tableau. • Correctly working on Operational and Audit reporting where the requirement is to make the comparison reports between source and target systems and find out the fallouts of providers and networks and report to business via tableau reporting and SQL. reporting. • Overall, expert in coordinating the project and handling the complicated/high priority items. • Well versed in ad-hoc requests to get done. • Advance knowledge and experience on security related to any means of Tableau. • Have written the Unit Test Cases of the dashboards for users. • Written the User Manual for developed dashboards. • Expertise in live data testing with the data team to keep the project on track and move it in fast-track mode. Tools/Technologies: Oracle 10g/11g, Oracle 9i, DB2, MS Office, Windows, MS Excel, Windows 2000/XP, SQL, TOAD, Flat Files, XML.
Functional Consultant
NOVATEUR ELECTRICAL & DIGITAL SYSTEMS2009 – 2012
Novateur is fast emerging as a first-choice global supplier for high quality electrical equipment.
• Analyzed reports and fixed bugs in stored procedures using SQL. • Conducted performance tuning of complex SQL queries and stored procedures by using SQL using Toad. • Designed and developed Tables, Stored procedures, Triggers and SQL scripts for enhancements and maintenance of various database module. • Performed Unit Testing. • Performed for System Integration Testing. • Incident management and bugs fixation during User Acceptance Testing.
Tools/Technologies: SAP, ABAP, MS Office, Windows, MS Excel, Windows 2000/XP, SQL.
Education
Bachelor of Engineering in Electronics
Anna University2003 – 2007
Bachelor of Engineering in Electronics