SUMMARY:

• 8+ years of Experience in Quality Assurance using Business Intelligence, Database, ETL, Data warehouse, DataMart, Databases, Web services, and Client - Server applications.
• Experience in Software Engineering, SDLC, STLC and Testing Methodologies to ensure industry standards.
• Experience working in Agile and Waterfall Development Methodologies.
• Vast experience in writing test plans, test cases and test execution.
• Solid experience in Black Box testing techniques, which includes, Unit, Integration, Functional, System, and Regression Testing.
• Experience on automated or manual testing in the web and client server environments.
• Experience testing functionality for Salesforce (CRM) and ALIP (Accenture Life Insurance Platform) system.
• Extensively used Data warehouse ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica, Data stage and Ab initio
• Expertise in testing complex business rules by creating mapping and various transformations
• Excellent troubleshooting and debugging skills.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, PL/SQL, MS Access and Flat Files.
• Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL Development Toad, PL/SQL Developer, Perl, and UNIX.
• Experience working with databases like Oracle, SQL Server, DB2 and MS Access.
• Experienced in programming database objects like Tables, Stored Procedures, Views, Rules, Defaults, user defined data types and functions using oracle.
• Implemented database standards and naming convention for the database objects.
• Involved in identifying/ preparing the data (test data at the source level) that needs to be moved to data warehouse.
• Experienced in understanding Dimensional Data modeling using star and snow flake schema.
• Tested the different sources such as Flat files, Excel, XML, Mainframes Legacy Flat Files, DB2 and Oracle to load into the Oracle data warehouse.
• Performed backend testing by writing SQL queries and running PL/SQL scripts in TOAD. Expertise in TOAD, SQL Developer, Microsoft SQL Server Management Studio and WinSQL tools.
• Good experience in Micro strategy, Business Objects, Cognos and Crystal Reports testing
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• Strong working experience in the Data Analysis, Design, Development, Implementation and
• Strong interpersonal skills such as ability to interact with individuals at all levels, excellent communication and presentation skills.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 8.x/7.x (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Data Stage 8.1, Ab Initio (GDE 1.15, Co>Op 2.15)

BI & Reporting: Business Objects XIR3/R 2/6.5/6.0/5.0, BO Developer Suite 6.0/5.0 (Designer, Web Intelligence, Broadcast agent, Supervisor, Module), Cognos Impromptu 8.0/7.0/6.6, SSRS, Micro Strategy

Testing Tools: Load Runner 8.1, QTP 8.2, Test Director, Quality Center 9.2.

Databases: Oracle 10g/9i/8i/7.3, MS SQL Server 2012/2008/2005/2000/7.0/6.5, IBM DB2, Teradata V2R6, MS Access 2007 and MYSQL

Job Scheduling: App worx, Autosys, BMC Control M 6.2/7.0, CA Workload Automation

Operating System: UNIX (Sun Solaris 9.0/8.0/7.0, HP-UX 11i v1.5/1.6/2.0, IBM AIX), WINDOWS 95/98/2000/NT/XP, Linux, MS-DOS

Web Service Tools: SOAP UI

Languages/Utilities: SQL, PL/SQL, SQL Developer, TOAD, Microsoft SQL Server, Quest Central for DB2, UNIX shell scripts (Cron, C),Java, Servlets, XML, HTML, DHTML, C/C++, Visual Basic

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. ETL/Functional QA Tester

Responsibilities:

• Developing test plans and test strategy for the functional testing and database functionality testing according to business requirement and technical document.
• Developing test scripts and mapping documents for data requirements.
• Developed functional test cases for various lines of businesses based on requirement document.
• Preparing/Keying test data in front end system ALIP (Accenture Life Insurance Platform ) to test various functionality of the system as per requirements.
• Running batch jobs through CA Workload Automation batch processing tool, to process and push data in downstream systems.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Writing complex SQL queries to validate data that is populated in EODS and downstream systems which are Transformed and Loaded using Informatica ETL jobs.
• Validating contents/transaction that is processed in ALIP (Accenture Life Insurance Platform) system through jobs.
• Testing the functional controls for system Integration test for every release and checking the data integration in down streams.
• Collecting evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.
• Using Rational Clear Quest for defect life cycle.
• For data keying in ALIP running automation scripts using UFT.
• Ensuring smooth onsite to offshore transition of requirements and conducting knowledge transition sessions.
• Closely working on all stages of SDLC
• For the project designing and executing Functional, Integration, Regression, System (End to End) and Backend (Database).
• Reviewing test document with team and business.
• Assisting the BA team for User acceptance testing.

Environment:: DWH Informatica Power center (ETL), HP Quality Center/ALM, Rational Clear Quest, SQL SERVER, and PL/SQL Developer for Oracle, UNIX, CA Workload Automation, and HP UFT for automation.

Confidential, PA

Sr. ETL QA Tester

Responsibilities:

• Developed test plans, test cases created for the database backend testing and testing database functionality according to business requirement and technical document.
• Developed test scripts and mapping documents as per data requirement.
• Imported and exported data using SQL Server Import and Export Wizard and ran except queries to validate data from source to target.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Wrote complex SQL queries to validate data that is populated in Data Mart / Data warehouse which are Transformed and Loaded using Data Flux.
• Developed Manual ETL test cases for various lines of businesses based on ETL mapping document.
• Prepared test data as per requirement and validate data for IDL load and then Delta processing.
• Validate contents that are populated in Veeva system through jobs.
• Tested contents that populated in different types of reports including Report Layout, Naming Conventions, Totals, Sub-Totals, Drilling options, prompts, metric calculations, drill maps and security filters.
• Wrote Complex SQL Queries to do manual testing in my feature for every release and check the configurations
• Collected evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.
• Ensured smooth onsite to offshore transition of requirements and conducted knowledge transition sessions.
• Extensively used Data warehouse ETL methodology for testing and supporting data extraction, transformations and loading processing.
• Tested reports developed by Business Objects Universes for both Adhoc and Canned Reporting users of Business Objects XI
• Assisted code promotion from QA/UAT to Production.

Environment:: DWH Informatica Power center (ETL), Business Objects XIR3, HP Quality Center/ALM, Rational Clear Quest, Rational Clear Case, QTP, SQL SERVER, SSIS, Toad for Oracle, Unix, Autosys, Windows XP.

Confidential, Wilmington, DE

Sr. ETL QA Tester

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 were used effectively to develop and maintain the database
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.
• 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.
• Collected evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.
• Extensively used Data warehouse ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution.
• Execute batch jobs using Control-M enterprise manager and check SYSOUT, ERROR LOG details.
• Used SQL for Querying the Oracle database in UNIX environment
• Reviewed the project and coordinating with onsite Clients, onsite Project Leads and local reporting managers.
• Tested several ETL job activity for data stage using Data stage designer
• 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.
• Designed Traceability Matrix to match the test scripts with the Functional design document.
• Excellent 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: DWH ETL IBM Data Stage 8.1, Quality Center 10.0, SQL,PL/SQL, DB2, SDLC, TSYS, TOAD, SQL Developer, Oracle 9i/10g/11g, UNIX, PERL, DB Visualizer, Flat Files, IVR, AVAYA, Micro strategy.

Confidential, New York, NY

ETL QA Tester

Responsibilities:

• Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are transformed and loaded using Data warehouse ETL Informatica Power Center.
• Built a library of test cases for regression testing and automated them using QTP
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata,
• Involved in validating SSIS and SSRS packages according to functional requirements.
• Involved in testing designing and development of Data warehouse environment.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for reporting purposes.
• Written and executed the functional and regression test script using Test Script QTP.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Tested reports developed by Business Objects Universes for both Adhoc and Canned Reporting users of Business Objects XI R3
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Involved in extensive DATA validation on data marts by using SQL queries.
• Developed test reports and participated in testing prioritization and archived test results and user signoff
• Used TOAD Software for Querying ORACLE.
• Validated Business Objects reports by running the SQL queries based on the business rules.
• Wrote Complex SQL queries to validate the standard reports, Dashboards and Business objects Universes.
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.
• Involved in the error checking and testing of the Data warehouse ETL procedures and programs Informatica session log.
• Performed the tests in both the SIT, QA and contingency/backup environments

Environment:: DWH Informatica Power center 8.6 (ETL), Business Objects XIR3, HP Quality Center, Rational Clear Quest, Rational Clear Case, QTP,SQL SERVER,SSIS, Toad for Oracle, ORACLE 9i, Unix, Autosys, Windows XP.