SUMMARY:

• Over 8 years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Expert in writing complex SQL queries and Unix to execute the back end jobs.
• Expertise in defining Test Strategies, writing detailed Test Plan and Test Cases, Defect Tracking and Defect Reporting using Mercury Test Director and Quality Center.
• Extensive experience in Database Testing in Oracle, SQL Server and DB2 SQL .
• Expertise in Data Mover scripts for Data Export and Import.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, and Teradata, Ms Access, Flat files into a staging area.
• Extensive experience in Data validation and verification in all ETL Stages (Source, Staging and Target environments)
• Created manual Test Cases in HP QC/HP ALM for various User Stories based on Release and Sprint Plan.
• Good knowledge on Automation Tool Selenium and Quick Test Professional.
• Working experience in Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS) and Integration Services (SSIS)
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations were using Data stage, Informatica, Ab initio and Auto sys tools.
• Analyzed and tested Data Stage jobs with OLTP source data, staging and target data.
• Experience on different types of Testing like Black Box, White Box, Integration, System, Functional and Regression Testing.
• Generated automated Scripts in QTP and designed Automated Test Suites for regression testing in Quick Test Pro.
• Prepare and monitor testing scope and requirement changes, assess the impact of requirement changes on test deliverables.
• Manage functional testers, automated testers and test coordinators assigned to work on the project.
• Mentor junior tester/analysts as appropriate during a project and provide them proper KT for the project workflow.
• Tackles difficult problems and takes personal responsibility for reaching solutions.
• Seek ways to improve overall performance levels of the team in the pursuit of targets / goals.
• Knowledge of and ability to apply a wide range of software test engineering concepts: testing principles (Testing Methodology) and concepts, building a test environment, tracking defects n Quality Center
• Hands on expertise with test automation tools such as HP QTP (Quick Test Pro)
• Experience in assisting the customer in User Acceptance Testing (UAT)
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP and SDLC methodology environments.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
• Excellent skills in TeraData, DB2, SQL Server and Oracle RDBMS and Sybase.

TECHNICAL SKILLS:

Testing Tools: ALM, Quality Center 10/9.2, JIRA, Clear Quest

Databases: Oracle 11g/10g/9i, Teradata 14/13, V2R6, SQL Server 2008/2005, MySQL, Hadoop

Utility Tools: TOAD 8.5, SQL Assistant, BTEQ, Fast Load, Multi Load, SQL Server Management Studio, SQL* Plus, SQL* Loader, SQL Developer

ETL Tools: Informatica 9/8, Data Stage 8

Other Tools: Informatica Metadata Manager, Informatica IDQ, Power Exchange, Toad, PLSQL Developer, Putty, WinSCP

Reporting Tools: Cognos, Business Objects XIR2, OBIEE

Operating Systems: Windows, Linux and UNIX.

Programming: SQL, Hive, PL/SQL, T - SQL, C, Java

PROFESSIONAL EXPERIENCE:

ETL Test Lead

Confidential, MN

Responsibilities:

• Work with the test executive management in evolving methodologies and procedures in retaining skilled testing personnel.
• Work closely with Business Team on requirement gathering and Test Planning.
• Look Confidential the current scope to define/identify potential risks and comes up with a suitable mitigation plan.
• Provide interfaces between Mass Mutual and Cognizant onsite & offshore QA team to lead and manage a matrix team of IT QA testers being responsible for day to day execution.
• Integrate working with the test executive team, the project management deliverables for the test component of the project activity.
• Prepare and monitor testing scope and requirement changes, assess the impact of requirement changes on test deliverables.
• Manage functional testers, automated testers and test coordinators assigned to work on the project.
• Mentor junior tester/analysts as appropriate during a project and provide them proper KT for the project workflow.
• Tackles difficult problems and takes personal responsibility for reaching solutions.
• Seek ways to improve overall performance levels of the team in the pursuit of targets / goals.
• Prepare and manage master test plan and continuously provide improvement of test management standards and procedures.
• Prepare test estimates and sizing of the test object.
• Plan, organize, direct and execute the test process and manage test releases.
• Prepare test execution metrics and use the metrics to derive "best practices" and suggest / recommend improvements to test processes and methodologies.
• Implement and evolve appropriate test measurements and metrics to be applied against test release and to be applied against the QA team.
• Define, prepare, monitor and adjust test - level plans and manage scope changes.
• Provide support for identification and management of Risks and Issues relating to testing activities and escalate any concerns to the appropriate stakeholders for resolution.
• Prepare the Daily dashboard and customize it based on client comments.
• Deploy and manage the appropriate testing framework to meet the testing mandate.
• Delegate test activities and monitor compliancy with and applicability of test standards.
• Ensure all governance mandated deliverables are created, processes are followed, relevant standards are integrated and all required signoffs and authorizations are obtained as defined in the Quality Plan.
• Participate in the review of requirements definition deliverables looking gaps in the requirements from a testing perspective and for traceability and transformability of the requirements into test strategy, test plans and test cases.
• Work closely with the IT team and Business Users to support the development of test cases in conjunction with testing level requirements.
• Create / collate project status reports and prepare client briefings on a weekly and on a need basis so that all the testing stakeholders are up to date on testing status.
• Document and obtain approval for Test Completion Report, which will include lessons to be taken from this project.

Environment: Data warehouse ETL Informatica 8.1, BI Cognos, Teradata V2R6, MS Access, MS Excel, MS Word, XML, Oracle 10g, SQL, TOAD 10, SQL Developer, SQL Assistant, SQL Plus, Unix, Quality Center 9.0.

Sr. ETL QA Analyst

Confidential, Overland Park, KS

Responsibilities:

• Documented the business requirements, developed test plans, test cases created for the database backend testing and to test database functionality.
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Different Data Stage components especially are used effectively to develop and maintain the database
• Developed ETL test cases for various lines of businesses based on ETL mapping document.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and SQL Server database.
• Expertise in validating SSIS and SSRS packages according to functional requirements.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System (End to End) and Backend (Database)
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded.
• Involved in Test plan, Test case preparation and assigning defects through TFS
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate - wide-ETL Solution.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS packages.
• Used SQL for Querying the SQL Server database in UNIX environment
• Written Complex SQL Queries. To do Manual testing in my feature for every release and check the configurations
• Validated SSRS dashboard reports by writing several complex SQL queries based on reporting logic.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS packages.
• Tested several different types of reports including Report Layout, Naming Conventions, Totals, and Sub-Totals, Drilling options, prompts, metric calculations, drill maps and security filters.
• Ran several jobs in data stage from both command line and front-end.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Raised defects in HP Quality Center defect tracking system.
• Good experience in writing SQL in order to data validation in migration as part of backend testing Worked with ETL group for understating mappings for dimensions and facts.
• Assisted in promotion of Data stage code and UNIX from UAT to Production.

Environment: SQL, PL/SQL, TOAD, Data warehouse ETL IBM Data Stage 8.1, SQL Server, SSIS, SSRS, SSAS, Quality Center/ALM 11.0, .Net, Visual studio, MS Access,, DB2, SDLC, TSYS, SQL Developer, QTP, UNIX, PERL, DB Visualizer, EMWE WEBSITE, Flat Files, Pivot Tables, Pivot Tables.

Sr. ETL QA Tester

Confidential. Overland Park, KS

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0.
• Experienced in configuration management using Visual Studio Team System (VSTS), Team Foundation Server (TFS), VSS and Subversion.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata.
• Designed the Load Runner scenarios with various user - mix i Confidential ementing in constant ratios, till the peak load is achieved.
• Compared the data sets resulted from the databases Oracle and SQL Server using the tool, Toad for Data Analysts.
• Worked with SOAPUI for testing Web Services
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing
• Extensively used AUTOSYS to schedule the jobs and run the scheduled jobs at specific time.
• Developed TSL (Test Script Language) for automated Testing using Win Runner. Worked with business team to test the reports developed in Cognos.
• Understanding Source Systems used by State Farm Insurance to populate Data Mart.
• Working on defining mapping requirements sources systems used by State Farm Insurance to populate data mart.
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica
• Tested SOA security with limited access to communicate between the services
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports.
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with data validation, constraints, source to target row counts.
• Used data conversion to protect the data and prevent data loss.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs
• Experienced in working with DB2, Terada.
• As Data warehouse ETL Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica.
• Written Test Cases for Data warehouse ETL to compare Source and Target database systems
• Extensively used Data warehouse ETL Informatica Debugger to validate maps and to gain trouble-shooting information about date and error conditions.
• Tested several Data warehouse ETL Informatica Mappings to validate the business conditions.
• Involved in the error checking and testing of the Data warehouse ETL procedures and programs Informatica session log.
• Used Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Strong in writing SQL queries and makes table queries to profile and analyze the data in MS Access.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Monitored the Informatica workflows using Power Center monitor. Checked session logs in case of aborted/failed sessions
• Performed Web Services testing and Validated XML request/response data using SOAPUI.
• Perform Functional, Data Validation, Integration, regression and User Acceptance testing.
• Used TOAD, DB Artisan tools to connect to Oracle Database to validate data that was populated by ETL applications
• Worked with business team to test the reports developed in Cognos.
• Involved in testing Unix Korn Shell wrappers to run various ETL Scripts to load the data into Target Database (Oracle)
• Created test cases and executed test scripts using Quality Center.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables

Environment:: Informatica 8.1, Informix, DB2, Java, TFS, VSTS, Cognos 7 Series, SQL, PL/SQL, SQL Server 2000/2005, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), SOAP, SOAPUI, Web ServicesAutoSys, Teradata SQL Assistant 7.0, SSIS, XML, XSLT, XML Spy 2008, UNIX, Shell Scripting, HP QTP v5.5/6.5, HP Quality Center 9.2

ETL QA Tester

Confidential, Greenwich St - New York, NY

Responsibilities:

• Participated in all meetings with project team members on Overview and Architecture.
• Developed test plans, test scripts and build scenarios work flows according to the user requirements.
• Worked on testing data migration, data integration and data transformation.
• Written test cases to validate the ETL Informatica mappings and maplets.
• Executed SQL queries using TOAD to query Oracle database. Used Inner join, Outer Join, MINUS operations and Case statements in SQL scripts.
• Used SQL Assistant to write SQL and query the Teradata database tables.
• Created complex SQL queries to validate the initial and i Confidential emental ETL loads. Used PL/SQL function to validate some test scenarios.
• Tested both multi - protocol and multi-party processes. Worked with UNIX commands like GREP, LESS and Diff.
• Tested several Informatica Mappings to validate the business conditions. Written positive and negative test cases for Cognos reports based on report specifications.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Exported the Report data from Oracle and Teradata warehouse to Excel and validated using formulas.
• Validated several Drilldown and Pivot reports published in Cognos Scoreboard. Worked on testing report filter and view filter in Cognos reports.
• Worked with non-transactional data entities for multiple feeds of reference data using MDM
• Validated Prompts, filters, calendars and Cosmetics in reports. Participated in Project Status meetings and updated QA status and defect status.
• Used Quality Center to document and open defects and track them from time to time.
• Interacted with developers to resolve the ETL and reports defects.

Environment: Data warehouse ETL Informatica 8.1, BI Cognos, Teradata V2R6, MS Access, MS Excel, MS Word, XML, Oracle 10g, SQL, TOAD 10, SQL Developer, SQL Assistant, SQL Plus, Unix, Quality Center 9.0.

QA Tester

Confidential. Hartford, CT

Responsibilities:

• Involved in analyzing system design specifications and developed Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing.
• Tested all the ETL process that was developed to fetch the data from various feeds into the data warehouse.
• Written SQL scripts for validating the data loaded by the ETL processes.
• Tested the reports developed using Business Objects. Perform manual testing and created various test results to track the testing results.
• Export requirement, test cases into the Quality Center, run manual and automation test cases from test lab and log defects from defects module.
• Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.
• Tested request and response XML's based web services interfaces using SoapUI. Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Create standard testing life cycle flow diagram for projects and presented to test team to follow testing process.
• Participated to create Test Analysis reports (TAR) and stored them into the Quality Center. Updated RTM in daily, send status report and daily tracking report to test manager.
• Performed UAT testing in the UAT environment prior to notify to the customer to start performing UAT testing.
• Developed SQL Queries to retrieve or create test data from different Oracle Test databases.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Tested reports in report studio and query studio by using SQL.
• Met with client to present future functionality of the application, gather information from them to know about their need and send this information to test manager.
• Automated and scheduled the Data stage jobs using UNIX Shell Scripting.
• Worked closely with the application development and design and testing team to resolve technical issues and interacted with them to ensure overall quality of the software.

Environment: ETL, Business Intelligence BI, SOAPUI, SQL, Java, JSP, JDBC, XML, UNIX, Web Logic Application Server, Oracle 9i, Quality Center 8.2, SQL Server, Quick Test Professional 8.2.