Sr. ETL/Data Warehouse/Reports QA Tester

• Over 6+ years of experience in Quality Assurance in Information Technology, involving analysis, both Manual and Automation testing of client server and web applications.
• Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing.
• Strong knowledge of Software Development Life Cycle (SDLC - Feasibility Requirements Analysis, Design, Testing, Implementation, Support).
• As a QA Analyst – Worked on various industry verticals – Supply Chain, Financials, Telecommunications andRetail.
• Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements.
• Experience in preparing test reports from Quality Center and prepared daily test status reports to communicate the test status with the team.
• Experience in using Automation Tool: Quick Test Professional (QTP) and Quality Center (QC) in Client/Server.
• Actively involved in User Acceptance Testing (UAT) and Training of the end users. Participated in cross-functional teams to reengineer and improve business processes.
• Extensive testing ETL experience using Informatica 8.1/7.1/6.2 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Excellent Knowledge of Database Systems – Oracle 10g, SQL server, DB2 and Data ware house concepts.
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
• Proficient in troubleshooting database issues and experienced in using performance monitor/profiler to solve dead locks/ long running queries.
• Experience in RDBMS, Microsoft SQL Server (T-SQL), Oracle (PL/SQL), MS Access and associated SQL Programming Knowledge.
• Extensive Working experience in applying Relational Database Concepts, Entity Relation diagrams and Normalization concepts.
• Experience in Business Intelligence testing in various reports using Cognos, Business Objects, Crystal Reports and Crystal Dashboards (Xcelsius).
• Excellent Knowledge in Ms-Office (Word, Excel, PowerPoint), Ms-Access, MS Visio.
• A very good team player with excellent Communication (Verbal and Technical), Presentation and reporting skills.

TECHNICAL SKILLS

Testing Tools: HP Quality Center 9.0/11.0 (ALM), QTP 9.0
Databases: Oracle 8i/9i/10g/11g, DB2 8.0/7.0, SQL Server 2005/2008, Teradata MS Access
Utility Tools: SQL Developer, TOAD and SQL Assistant
ETL Tools: Informatica 8.1, Abinitio, and Datastage 7.0 and 8.0
Reporting Tools: Business Objects 3.1 and Cognos reports
Web services: SOAPUI
Operation Systems: Windows XP/2000/2007, Linux and UNIX
Microsoft Office: Word, PPT, Excel and Visio
Programming: PL/SQL, C, and C++

Experience: 

Client: Confidential, Colorado Springs Colorado
Duration: May 2011 – March 2012
Role: SR. ETL/ SAP Business Objects Reports Tester
Responsibilities:

• Developed Test Plans, test scripts and executed the test scripts for FedEx Freight – OPM DW Project.
• Thorough out the project in various iterations/Sprints – conducted system testing, integration testing, functional testing and integration testing.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted with developers, business& management teams to understand the OPM project business requirements and ETL design document specifications.
• Participated in regular project status meetings and QA status meetings.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Written test cases to test the application in Quality Center 9.0 and 11.0(ALM)
• Defects identified in testing environment are communicated to the developers using Quality Center – Defects module.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support
• Setting up, monitoring and using Job Control System in Development/QA/Prod
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases,
• Scheduling and automating jobs to be run in a batch process
• Effectively communicate testing activities and findings in oral and written formats
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files and DB2 server.
• Worked on issues with migration of Data from development to QA-Test Environment
• Extensively tested several Business Objects Reports – Crystal’s reports and Dashboards to validate the reports the data and cosmetics of the report.

Environment: Oracle 10g/11g, Informatica Power Center 8.1(Power Center Designer, workflow manager, workflow monitor), SAP Business Objects 3.1 – Crystal Reports and Dashboard, HP QC 9.0/11.0, SQL developer, TOAD, SQL and PL/SQL, Web Services.

Client: Confidential, Charlotte, NC 
Duration: May 2010 – April 2011
Role: QA Analyst/ETL/SQL Tester 
Analyzed the business process workflows and mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types.
Responsibilities: 

• 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 andDataMarts.
• 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.

Environment: Datastage 7.0, Oracle 9i, DB2, SQL Server, Business Objects, MS Office Suite.

Client: Confidential, Denver, CO
Duration: July 09 – March 2010
Role: Sr.ETL Tester
Responsibilities:

• Reviewed Business Requirement Document (BRD) for accuracy and Completeness.
• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging Written ETL test specifications including test source data preparation, writing test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations− match aggregated data against staging tables and/or ODS, and Granularity of data is as per specifications
• Created the use cases, activity diagrams and sequence diagrams.
• Created detail Test cases for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions.
• Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage.
• Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and TestData.
• Worked with IT Development team to ensure feasibility of design and clarify user requirements.
• Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
• Performed Data Analysis and developed Data Mapping documents for ETL (SSIS) projects.
• Developed Test Cases and SQL Queries to perform various Validations.
• Performed Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Performed Unit Testing, Integration Testing, User Acceptance Testing and Requirement Testing.
• Executed Test Cases with respect to Source and Target database tables.
• Written SQL queries tovalidate reports against the database.
• Extensive SQL querying on Staging,Datawarehouse andDataMarts.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Validated reports based on Functional Requirements.
• Analyzed various reports generated by SSRS.
• Checked the reports for any naming inconsistencies and to improve user readability.
• Used Mercury Quality Center for Bug Tracking, Reporting and Analysis.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Server Integration Services 2005, Flat Files, DB2, TOAD 9.5, MS Office, XML, Windows Server 2003, Mercury Quality Center 9.2, Lotus Notes 7.0.3, Agile Scrum, Web services, HTML and JavaScript

Client: Confidential St.Paul,MN
Duration: September 2008 – June 2009
Role: Sr. SQL/QA Tester 
Responsibilities:

• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document
• Written complex SQL queries for querying data against different data bases for data verification process
• Designed the data flow diagrams using VISIO
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Preparation of technical specifications and Source to Target mappings
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads
• Creating test cases for ETL mappings and design documents for production support
• Setting up, monitoring and using Job Control System in Development/QA/Prod
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
• Scheduling and automating jobs to be run in a batch process
• Effectively communicate testing activities and findings in oral and written formats
• Worked with ETL group for understating mappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files and SQL Server
• Worked on issues with migration from development to testing
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic

Environment: Oracle, Informatica Power Center (Power Center Designer, workflow manager, workflow monitor), Mercury Test Director 7.0, SQL, Cognos 7.0 Series, Oracle8i, , TOAD, PL/SQL

Client: Confidential, Rockville, MD
Duration: September 07 – September 08 
Role: QA and Business Analyst
Responsibilities:

• Worked closely with application development teams to ensure adherence to design specifications, proposed procedures, practices and standards.
• Participated in Joint Application Design/Development (JAD) sessions.
• Extensively involved in requirement analysis
• Created the conceptual diagrams and data flow diagrams based on the analysis of requirements
• Designed the relational data model ie ERD to acquire the transactional data and database snapshots.
• Identified the process which were to be associated with FACT tables.
• Tested ETL process to push the transactional data from the normalized data structure into the data marts.
• Defined the data cleansing strategy based on the exploratory data analysis reports which to be applied on the staging data base and then pushed to the Operational data store.
• Developed SQL scripts for verification of data at extraction phase to ensure ,transformation phase and loading phase of the data to ensure correctness of the data and also verifying the ETL mapping rules
• Assisted the UAT sessions with the users which were not just limited to flow of transactional data, through the system, performance test and updating the defect tracking list for with UAT feed backs.

Environment: Oracle 10g, Informatica Power Center, Business Objects, WindowsXP/2000 and UNIX.

Education
Bachelor of Technology: Electrical and Electronics Engineering