Data Tableau

Neha Thakkar

Email: *********@*****.***

Phone: +1-908-***-****

Professional Summary:

•Experienced IT professional in testing Client Application, Database, ETL and Automation testing for various industry verticals.

•Experienced in working in Agile and Waterfall SDLC methodology environments.

•Expertise in designing Test strategy, Test scenarios and Test cases in order to test the application.

•Implemented various testing strategies, effectively logged defects and performed Root Cause Analysis (RCA) on the defects.

•Experience in writing and executing simple to complex SQL Queries using Joins, Subqueries, inline views and stored procedures required for Database/ETL/BI Testing.

•Extensive Experience in Black Box Testing which includes Functional Testing, Regression Testing, System Testing, GUI Testing, Integration Testing.

•Strong interpersonal, written and verbal communication skills.

•Hands on Automation testing.

•Multilingual, highly organized, detail-oriented professional with strong technical skills.

•Experience in working with onshore-offshore business model

•Plan and manage own workload to ensure product release deadlines are met

Education:

Master’s in Business Administration from Gujarat University, India

Bachelor’s in Business Administration from Gujarat University, India

Diploma in Computer Application from Gujarat University, India

Technical Skills / Tools:

Operating Systems: Windows

Databases: Oracle 8.1/9i/10g/11i, SQL Server 2016

ETL Tools: Informatica, Talend

Reporting Tools: Tableau

Query Tools: Toad and SQL Plus

QA Tools: HP ALM, TFS and Jira

Languages: SQL, PL/SQL

Automation tool: Selenium

Desktop Application: MS Office

Professional Experience:

General Atlantic, NYC Nov ’19- Aug ‘20

Profile: Sr. QA – Datawarehouse ETL Testing

General Atlantic is a private equity firm providing portfolio management, financial planning and investment advisory services. The project involves developing LP Performance Report Dashboard for GA’s Finance and Capital Partner Team, which enables them to develop self-service Analytics and reporting tools for company’s performance on their investments. This enables the users to generate IRR’s, TVPI, DPI, Gain and other KPI’s to reflect the performance of their investment for an investor.

Description: Tableau Dashboard Testing, ETL and Database testing.

Roles and Responsibilities:

●Developed a clear understanding of the Business requirements from both functional and technical perspectives

●Developed and designed Test cases and Test scripts for testing ETL process and Tableau Dashboard.

●Performed QA testing of ETL processes, Source Data files, Source to Target, Dashboard Reports and incremental data loads by writing advanced SQL Queries.

●Aggregated the data at the source and compared with the Target to validate Transformations

●Performed End to End BI testing activities on Tableau by writing complex SQL queries to validate the data on the report and comparing with data from the Datawarehouse.

●Functional testing of Tableau Dashboard charts like pie chart, bar chart, heat maps.

●Functional Testing of Tableau report by using various combinations like slicing and dicing of the report on different attributes, filters, metrices for historical loads as well as incremental loads

●Ensured the user experience of the Dashboard is smooth on Mobile and I-pad devices.

●Developed dashboard validation excel sheets by using complex excel functions and formulas

●Proficient in using Jira for Agile project management, to log and track defects, execute test scripts.

●Reported and got the defects resolved within the timelines and ensured the functionality is working as expected.

●Performed end to end functional testing (similar to end users) in UAT based on data restored from PROD

●Documented functional testing as part of UAT testing

●Updated UAT test scripts to cover new functionality

Environment: SQL Server 2016, Tableau, Salesforce, Talend, Jira

KPMG, NJ Mar’16 – Aug‘18

Profile: Sr. Quality Analyst

Project:

KPMG is a professional service company and one of the Big Four auditors worldwide. The project involves integration of TaxGopher with KPMG's PartnerTrack to help hedge funds with their Tax Compliance needs. TaxGopher is a tax analysis engine for cost basis adjustments that provides information on taxable gains and losses on Investments; regulatory software solutions; and data warehouse solutions. PartnerTrack is a KPMG proprietary solution to help streamline passthrough tax planning, compliance and reporting. PartnerTrack provides a frontend UI solution to TaxGopher's analysis engine.

Description: UI, Database and functional manual testing

Roles and Responsibilities:

●Responsible for analysis of requirements. Preparation of test plan and test data, review and execution of test cases/scripts.

●Functional testing includes data validation for various analysis as Constructive Sales, Wash Sales, Straddles, Dividend, Accruals, Corporate Actions such as stock split, dividends, return of capital.

●Functional testing of KPMG’s inhouse web Application-PartnerTrack.

●Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle using SSIS.

●Used SQL tools to run SQL queries and validate the data loaded in to the target tables.

●Validated the data of SSRS reports by developing SQL queries in SQL Developer against Data Mart tables and ODS.

●Providing updates in daily scrum and tri-weekly sprint review meetings, as part of the Agile project management strategy.

●Coordination with development team for bug fixes using Jira tool.

●Daily status update and coordination of pending test scripts with offshore team.

●Successfully tested and provided documentation on critical bug fixes whilst adhering to tight release schedules.

●Performed defect tracking, review, analysis and status updates of pending defects.

●Demonstrated new features developed to the critical audience (of client) tested as part of UAT during sprint calls.

●Performed end to end functional testing in UAT and created run book for ends users

●Updated UAT test scripts with new functionality covered during UAT testing

●Successfully performed testing during deployment of critical updates to production environment within short time frames.

Environment: Jira, TFS, Microsoft SQL Server, SSIS, SSAS, SSRS, Selenium.

Burlington Coat Factory, NJ May’15-Nov’15

Role: Quality Analyst

Burlington Coat Factory is Off price retailer with its headquarters in Burlington Township, New Jersey. The project involved Migration from the legacy system to Oracle database and enhancement of existing Order management system to simultaneously generate vendor orders in conjunction with internal allocation of stock. Project involved testing of enhancements made to PO forms, ASN, Invoicing and Warehouse system.

Roles and Responsibilities:

●Analyzing the business requirements and technical specification documents,

●Developed high level test matrix based on business requirements, functional and technical specifications, and development standards for assigned projects/applications

●Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.

●Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.

●Performed data quality analysis using advanced SQL skills.

●Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.

●Extensive SQL querying on Staging, Datawarehouse and Data Marts.

●Ensured Error logs and audit tables are generated and populated properly

●Performed UAT and Regression Testing.

●Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.

●Tracking and reporting the issues to project team and management during test cycles.

●Updating and maintaining existing test Matrix and test cases based on code changes and enhancements to assigned applications.

●Contribute in the development of knowledge transfer documentation.

●Compare EDI files with and without enhancements. Verified results using EDI 850 and EDI 860 output files generated by the system.

Environment: Oracle10g/11g, PL/SQL, TOAD, UNIX, OBIEE10g/11g, Quality Center 9.1, QTP, Jira, Informatica

Contact this candidate