SUMMARY

• 10 years of rich experience in IT Industry in Data Warehousing and Integration Projects
• Experience in Quality Assurance and Software Testing of various business applications inClient/Server environmentsand Data Warehousing solutions.
• Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing.
• Excellent Knowledge of Database Systems - Oracle, SQL server, and Data ware house concepts.
• Experience DataAnalyst/Data Quality Analystwith solid Data Analysis, Data Validation, Data Profiling, Data Quality Assessment using SQL, Excel, MS Visio etc.,
• Strong knowledge of SDLC and Software Test Life Cycle and highly proficient inSQAmethodologies for Waterfall, Agile.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases.
• Have solid experience on database query tools such as TOAD, SQL Navigator, and SQL Assistant.
• Experience on UNIX commands
• Experienced in Functional testing, Performance testing, Load testing, Integration testing, System Testing, Regression testing, Black Box testing, Stress Testing, Smoke Testing, Recovery Testing and GUI Testing.
• Strong experience in preparing documentation, preparing test environments, executing and analyzing the results.
• Have experience in testing reconcile (initial) and delta (daily) loads.
• Have tested several complex reports generated by Tableau and Business Objects including dashboards, summary reports, master detailed, drill down and score cards.
• End to end experience in designing and deploying data visualizations using Tableau
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Reports, and Weekly Status Reports.
• End to end experience in designing and deploying data visualizations using Tableau
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center, Clear Quest, TFS - Team Foundation Server.
• Expert in writing complexSQL queries for back-end testing.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
• Knowledge on the phases of agile methodology and scrum Methodology.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS

Languages: C, Sql, PLSql

Databases and Tools: Oracle, MS-SQL Server, DB2, Teradata, Sql Developer, Toad, ERWIN

Operating Systems: MS-DOS, IBM AIX, Windows, Red Hat Linux

Scheduling tools: Control-M, Autosys

ETL Tools: Informatica9.0/8.6, SSIS, Datastage

BI Tools: Business Objects xi, Tableau

Testing Tools: HP ALM(QC), TFS

Management Tools: MS Excel, MS Visio, MS Word, MS Power Point

PROFESSIONAL EXPERIENCE

QA Lead

Confidential, NJ

Technologies Used: Oracle 11g, SQL Tools 7.2, Erwin 9.7, Business Objects, SQL Server 2012, Unix

Responsibilities:

• Work closely with the Data Architect / Data Modeler to understand the functional requirements and subsequently to build the test cases
• Managing QA team to assign daily task and activities
• Analyzed the business requirements specification documents and source to target mapping documents and identified the test requirements.
• Did extensive work with ETL testing including data completeness, data transformation and data quality for various data feeds coming from source
• Extensively used SQL queries for data validation and backend testing
• Validating data files from source to make sure correct data has been captured to be loaded to target tables
• Analyzed test results and identified areas where regression tests could be conducted.
• Involved in understanding logical and physical data model using Erwin tool
• Tested the source data for data completeness and data correctness.
• Tracking the defects to closure by interacting with the dev team.
• Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements.
• Writing complex SQL queries for checking the counts and for validating the data at field level.
• Prepared all the test scenarios and shared across the team.
• Provided testing training to Junior QA’s and transferred business knowledge.
• Involved in testing all the reports that were generated through Business Objects
• Tested the format of the reports according to the specifications provided and also compared the data in the reports with the backend DataMart through SQL and also using excel for data comparison.
• Involved in end to end testing of the entire process flow starting from the source database to the target DataMart to the reports by considering all possible scenarios.

QA Analyst

Confidential, NJ

Technologies Used: SQL Server, Toad, QTP, RFT, QC, Informatica, Oracle, JIRA, Tableau, HP ALM, UNIX

Responsibilities:

• Strong knowledge of SDLC, Software Test Life Cycle and highly proficient in Agile methodology.
• Expertise in writing, executing and maintaining test plans, test strategy, test procedures and test cases.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Reports, and Weekly Status Reports.
• Proficiency in defect management, including defect creation, modification, tracking, and reporting using industry standard tools like Quality Center
• Work closely with the architects and business analysts to understand the functional requirements and subsequently to build test cases and test plan
• Create sample set of data in prepared environment that helps with the testing process.
• Coordinate with offshore team on the testing needs as well as for defect reviews.
• Create all documentation to fulfill mandatory compliance process before signing off the application to production
• Involved in BCP, Microsoft synchronization framework and SQL-ON testing
• Writing SQL scripts to validate the data from source to target.
• Tracking the defects to closure by interacting with the dev team.
• Worked with SQL Server Management Studio for SQL Server 2012/2014
• Used SQL browser to write very complex SQL queries for validating constraints, indexes and also to check the characteristics of the schema browser i.e., tables, synonyms, views.
• Provide production support by validating the tickets raised by the users and also by reproducing the defects.
• Extensively used automated test tools like RFT and QTP for functional and regression testing
• Experience in preparation of automated testes within the keyword driven automation framework
• Good exposure in using of QTP integrated environment (Conversion, synchronization, Q&M enhancements, Check in Check, etc.)
• Involved in testing the ETL process for data validation before and after the load process.
• Extensively worked in Data Extraction, Transformation and Loading (ETL) process of the data.
• Tested Tableau dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Tested on the Data Validation rules of various input data files through the generic conditioning graph ensuring the integrity of data used for processing based on the rule

Data Quality Analyst/ETL Tester

Technologies Used: ETL/IInformatica 9.0, Oracle 10g, TOAD, SQL, SQL Server 2014/2012, SSMS, DB2, Flat files, XML,XML Spy 2010, HP ALM, Tableau 8.3, Shell Scripting, Unix

Responsibilities:

• Understanding requirements by interacting with various business areas as this is a enterprise driven project
• Create sample set of data in prepared environment that helps with the testing process.
• Work closely with the Architects and business analysts to understand the functional requirements and subsequently to build test cases and test plan.
• Create all documentation to fulfill mandatory compliance process before signing off the application to production
• Performed source data analysis and validation to check with the patterns and consumption for the Datawarehouse.
• Involved in gathering customer requirements, writing test cases and partnering with BI/Tableau developers to ensure full understanding of internal/external customer needs.
• Involved in creation of test plans and test cases and testing of Business Intelligence BI Tableau tool based Reports
• Writing SQL scripts to validate the data from source to target.
• Tracking the defects to closure by interacting with the dev team.
• Testing various ETL process that were developed
• Involved in testing the ETL process for data validation before and after the load process.
• Extensively worked in Data Extraction, Transformation and Loading (ETL) process of the data.
• Worked with TOAD for Oracle and SQL Server Management Studio for SQL Server 2012/2014
• Used TOAD in SQL browser to write very complex SQL queries for validating constraints, indexes and also to check the characteristics of the schema browser i.e., tables, synonyms, views.
• Parameterized the scripts to validate the different Data Fields.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables
• Created the test environment for Staging area, loading the Staging area with data from multiple sources
• Used T-SQL for Querying the SQL server database for data validation and data conditioning

ETL/Data Warehouse Tester

Confidential, Boston, MA

Technologies Used: Informatica 8.6/9, Oracle 10g, SQL Server 2012, SSMS, Unix, HP QC, XML

Responsibilities:

• Tested the various ETL processes that were developed to fetch data from various feeds coming from Admin System
• Tested the data from flat files to the target database.
• Tested the data from XML feeds to the target data warehouse.
• Written SQL scripts for performing data validations as well as for inserting test data into the tables.
• Prepared test files in UNIX box for testing purposes.
• Prepared test strategy and various test scenarios for the benefit of team members and offshore team.
• Tested the migrated ETL mappings from Informatica 8.6 to 9.
• Worked with Oracle SQL Developer query Oracle and SQL Server Management studio for SQL Server 2012
• Worked on the issues pertaining to Migration of data from development to testing for different Environments.
• Detected the failure in the workflows, browsing the job log, looking into it and re-running it to success.
• Participated in the daily status meeting on the testing progress and other concerned issues.
• Provided a weekly project report that includes Test Metrics and status reports.
• Performed end to end testing by coordinating with various teams to make sure that the data flow was smooth starting from the source to the ultimate target.
• Tracked all the defects to closure by interacting with the development team.
• Conducted and coordinated with integration testing and regression testing.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Worked with the DSO team to understand the source to target mapping document and accordingly helped them
• Validated the production tickets assigned and once confirming the defect assigned it to the developer for fix.

Backend Data Tester

Confidential, Northbrook, IL

Responsibilities:

• Analyzed the Business Requirements Specification Documents and Source to Target Mapping Documents and identified the test requirements.
• Interacted with business users to analyze the business requirements and system functional specifications and prepared Requirements Traceability Matrix (RTM) documents to map the business requirements with the functional and technical requirements and test scenarios.
• Attended daily Scrum Stand-ups for QA updates and defect status.
• Tested the source data for data completeness and data correctness.
• Tested the PL/SQL package that loaded data into staging from the source database.
• Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements.
• Writing complex SQL queries for checking the counts and for validating the data at field level.
• Prepared sample test data by inserting data into staging tables.
• Prepared all the test scenarios and shared across the team.
• Involved in testing all the reports that were generated through Microstrategy.
• Tested the format of the reports according to the specifications provided and also compared the data in the reports with the backend datamart through SQL and also using excel for data comparison.
• Involved in end to end testing of the entire process flow starting from the source database to the target datamart to the reports by considering all possible scenarios.
• Validated the production tickets assigned and once confirming the defect assigned it to the developer for fix.
• Was involved in running the informatica jobs from UNIX box for loading the test data into the target and also modified the shell scripts for scheduling purposes.
• Co-ordinated with the offshore counter-part for testing needs and also gave KT sessions on the business requirements.
• Was responsible for maintaining all the test cases and defects in HP Quality Center for all the team members to review.
• Was the point of contact for the QA team for escalations and lead the bug triage meetings.