SUMMARY

• Over 5+ years of experience as ETL/ BI Analyst with strong background in Analysis and Testing of Business Intelligence solutions, Data Warehouses, Data Marts, ETL, OLAP, Client/Server applications, Web - based applications.
• Strong expertise in all phases of software test management: defining requirements, test planning process, test execution, analyzing and reporting results, tracking and managing defects.
• Experienced with Waterfall and Agile process.
• Experienced in SQL Server 2008/2012 Business Intelligence Tools using SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS) and SQL Server Integration Service (SSIS).
• Experienced in writing T-SQL stored Procedure, Triggers, Constraints, views, User defined functions, Cursors, Indexes using various Data Definition Language (DDL) and Data Manipulation Language (DML) Commands to facilitate efficient Data Manipulation and Data Consistency.
• Extensive experience in testing packages using SSIS to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Experienced working in important phases of Testing Life Cycle like GUI Testing, Integration Testing, Regression Testing, and Functional Testing/Black box Testing, System Testing, Acceptance Testing, Performance and Load/Stress Testing.
• Experienced in defect tracking and test management tools like HP Quality Center & Clear Quest
• Extensive knowledge in gathering and understanding BRDs (Business Requirements Document), FRDs (Functional Requirements Document), SRS (System Requirement Specifications) and Used Cases
• Extensive experience in preparing test plans, test cases, test scripts and test reports
• Tracked bugs and created reports using test management/defect tracking tools like Quality Center and documented Test Documents Using MS Office Tools - Word, Excel, Power Point.
• Have worked with Informatica and Autosys for ETL run.
• Expertise in testing complex Business rules created by mapping and various transformations using Informatica and other ETL tools.
• Extensive knowledge in writing SQL queries based on the transformation logic present in Source to Target mapping document to compare the Source data with that of target data to make the data accurate.
• Good Understanding of creating MDX queries for SQL Server Analysis Service.
• Sound Knowledge and experience in Star schema/Snowflake schema 
• Proficient in Testing methodologies, Test Matrices and Trace matrix
• Strong working testing experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica, SQL Server SSIS.
• Expertise in testing complex Business rules created by mapping and various transformations using Informatica and other ETL tools.
• Excellent communication, interpersonal and organizational skills. An experienced team player, bringing enthusiasm and energy into group efforts.

TECHNICAL SKILLS

Databases: MS SQL Server 2008/2012 (SSRS/SSAS/SSIS), Oracle 9i/10g, Teradata

Tools: HP ALM Quality Center 11.0, HP Quality Center 10.0, SQL Server Management Studio 2012/2014 (SSMS), SQL Server Data Tools, SQL Query Analyzer, SQL Profiler, Visual Studio 2010 Shell, Visual Studio 2014, Test Director, Rational Clear Quest, Bugzilla, and JIRA, MS Word, MS Excel, Power point, MS Works, and Outlook

Programming Languages: SQL, PL/SQL, T-SQL, MDX, VBScript

Operating Systems: Windows 98/2000, XP, 7 and 8, Unix/Linux, Mac OS

PROFESSIONAL EXPERIENCE

Confidential, Towson, MD

ETL/BI Tester

• Worked as ETL tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project. 
• Prepared Test Plans for each release, written Test Cases and executed them as part of Functional Testing.
• Prepared Test Reports and Deliverables and submitted for version releases.
• Involved in validating various SSIS and SSRS packages according to functional requirements.
• Involved in preparation and maintenance of the Requirement Traceability Matrix (RTM) to measure the progress, test matrix and test script review.
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server 2012 and Oracle to load into the Oracle data warehouse.
• Created well detail Manual Test scripts in HP ALM to test application Functionality, End to End, GUI, Look & Feel, and Content. 
• Evaluated software development procedures used to verify that programs function according to user requirements and conform to establishment guidelines.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Developed Test Cases for Deployment Verification, ETL Data Validation and Data Report testing in SSRS report testing.
• Performed DA -DI with DB Fitnesse and loaded the flat file into QIP.
• Analyzed the data on facility level then patient level.
• Performed validation on 9 clinical measures and 3 reporting measures end to end.
• Used SQL heavily and wrote complex queries in SQL Developer.
• Collaborated with other ETL experts in evaluating the efficiency of load processes and transactional data.
• Setup meetings with BA to Analyze the Acceptance criteria.
• Perform ETL run through AutoSYS job and validated the run after it gets completed.
• Monitored the ETL jobs through Informatica and defect were raised when there was a performance issue.
• Created the Framework in Excel and extracted data from Database and did manual validation.
• Did validation on the Aggregation table and made sure each component met with the requirement.
• Worked in Agile Methodology and updated task every day.
• Reviewed the Mapping documents and verified and validated the DDL checks.
• Logged Defects in ARM and updated the defect after Retested and Verified Again.
• Worked with Optum team on comparative testing by Automating in DBFitnesse.

Environment: Informatica Power Center 9.1/8.6, SQL Server 2014, SSIS, SSRS, Oracle, DBFitnesse, Serena Dimension, Visual Studio 2014, SQL Server Management Studio 2014, UNIX, Flat files, Xml, Autosys, HP ALM Quality Center 11.0, SharePoint

Confidential, Atlanta, GA

ETL/BI Tester

• Worked with Business Analysts, SME, QA Manager, QA LEAD and analyzed the requirement and review the BRD and TDD documents and design test plan.
• Developed test scripts based upon business requirements and processes, in line with defined workflows and use cases.
• Analyzed business requirements, data mapping specifications and developed Test Plans, Test Cases, expected Results and Prioritized tests for the applications for various modules using HP QC 10.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Mapping.
• Analyzed and created the bug tracking reporting and summary report in the Quality Center
• Tested Complex ETL SSIS and SSRS Packages and Sessions based on business user requirements and business rules to load data from different source.
• Performed Verification, Validation, and Transformations on the Source data before loading into target database.
• Written complicated of SQL queries for data validation and data verification based on data mapping document.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Developed User-Acceptance Test cases and assisted users in conducting UAT
• Designing the star schema for the data mart.
• Tested the reports generated by (SSRS) SQL Server reporting services and checked as they are as per the Organization standards.
• Clearly communicated and documented test results and defect resolution during all phases of testing.
• Used Quality Center/ALM for execution, tracking and reporting for Internal High Level access and also to create reports and update bug status.
• Involved in testing designing and development of Data warehouse environment.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity.
• Tested the ETL SSIS mappings and other ETL Processes (Data Warehouse Testing)
• Involved in fixing the defects and data validation of reports for Partially Converted and Fully Converted Reports.

Environment: HP Quality Center 10.0, Informatica 8.6, SQL Server 2012, SSIS, SSRS, Visual Studio 2012, MS Office, JIRA, XML Files, SQL Assistant, PL-SQL, Unix, SharePoint, SQL Server Data Tools (SSDT), SQL Server Management Studio 2012

Confidential, Los Angeles, CA

ETL/BI Tester

• Worked with Business Analysts, SME, QA Manager, QA LEAD and analyzed the requirement and review the BRD and TDD documents and design test plan
• Analyzed business requirements, data mapping specifications and developed Test Plans, Test Cases, Expected Results and Prioritized tests for the applications for various modules using TFS
• Developed the detail ETL Test Plan, Test Resource Utilization and Close Down document for multiple products.
• Created the test cases for source and target systems for data validations
• Created Test cases for Data Acquisition and Data Delivery and tested the data accuracy for all the transformations.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Packages
• Tested the created SSIS packages to transfer data from various sources like Oracle, Db2, MS Access, Excel, Flat files
• Tested Complex ETL SSIS Packages and Sessions based on business user requirements and business rules to load data from different source
• Performed Verification, Validation, and Transformations on the Source data before loading into target database.
• Written complicated of SQL queries for data validation and data verification based on data mapping document.
• Wrote SQL queries in Toad and SQL server Management studio 2012 to validate the source and target systems
• Extensively executed T-SQL queries in order to view successful transactions of data between sources
• Tested the reports generated by (SSRS) SQL Server reporting services and checked as they are as per the Organization standards
• Clearly communicated and documented test results and defect resolution during all phases of testing.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity

Environment: HP Quality Center, Oracle 10g, SQL, TOAD, SQL Server 2012, T-SQL, SQL Server integration services (SSIS), SQL server reporting services (SSRS), Visual Studio 2012, SQL Server Management Studio 2012

Confidential, Charlotte, NC

Manual Tester

• Analyzed the Requirements from client and developed Test cases based on functional requirements, general requirements and system specifications provided as JIRA Ticket Number.
• Prepared Test Plans and Test Approach for each JIRA Requirements after analysis and review with BAs.
• Created test requirements and test cases using standard template. Reviewed test cases in excel with tech lead, BSA and UAT resources and obtain sign off before execution.
• Imported test cases to QC and executed test cases in QC and logged defects.
• Effectively coordinated with the development team for closing a defect.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Assign work to offshore and follow up on the issues or road blocks faced by the team.
• Conduct status call with offshore and coordinate among team members.
• Conducted KT (knowledge transfer) session and training to off-shore.
• Communicated to delivery team and QA. manager about issues, concerns and risks.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Performed functional testing (Count Verification, data validation, referential integrity test, transformation validation and various constraints check).
• Used MAT (Manual adjustment tool) to perform database insert, update and delete.
• Wrote Complex SQL queries to validate reports and the calculators maintained by BoA.
• Performed UI/Web testing for BOA Control Panel (BoA in-house tool) changes.
• Involved in INTEGRATION and UAT Testing.
• Delivered various test matrix documents like UAT defect analysis report, root cause analysis, Project test effectiveness, Prod defect analysis report, and defect acceptance report as a part of test deliverables.
• Extensively documented test artifacts so as to keep testing history and to avoid miss understanding and confusion.

Environment: Control Panel (BoA in-house tool for UI), MAT (Manual adjustment tool), Quality Center, JIRA, Subversion, Teradata, Teradata SQL Assistant, Oracle, SQL developer, Sybase, Unix, Flat files, log files, Xml files, PL/SQL