SUMMARY

• 10+ years of total IT experience and very good knowledge QA of Software Applications and Testing. Extensive experience in testing of data warehouse / data marts for business applications with Health Care, Retail, Financial, Communication, Retail - Manufacturing & Pharmaceuticals.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Extensive testing ETL experience using Ab Initio, Informatica 8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager), SQL Server (SSIS,SSAS, SSRS), Data stage 8.1 and SAS
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Experience in Performance Tuning of sources, targets, mappings and sessions.
• Automated and scheduled the Abinitio graphs, Informatica jobs using UNIX Shell Scripting.
• Expert in testing Mainframes environment using TSO, ISPF, JCL, COBOL II, VSAM and Copy Books.
• Experience in Microstrategy, OBIEE, Cognos, Business Objects as Reporting Systems within a wide variety of database environments in a diverse range of industries
• Experienced in Data Modeling, Erwin, Star/Snow Flake Schema Designs, Logical Data Modeling, Normalization, Physical Design, Data Analysis, Data Modeling, Reports and Report Design.
• Extensively strong on databases including Ms-Access, Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 DB2 8, Netezza and Teradata 13.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Teradata, OBIEE (Siebel Analytics), Ms Access, Flat files into a staging area. Knowledge on the APEX SQL
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Expertise in utilizing Oracle utility tool like SQL* Loader, SQL Developer and expertise in using Toad for Oracle.
• Experience in utilizing Utility tools BCP (Bulk copy process) for DB2, Import & Export wizard for the SQL Server and Import and Export utility for Teradata
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming and stored procedures.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• Good knowledge on PeopleSoft HRMS (Payroll, Compensation, Time & Labor), Oracle HRMS, Oracle Financials (GL, AP, AR) & Siebel Analytics/OBIEE HR Analytics 7.9.6.
• Worked and tested the OBIEE HR Subject Areas like Workforce, Core HR, Learning and Compensation.
• Excellent programming and problem solving skills having worked on C, C++, VB, SQL, PL/SQL
• Extensive knowledge in regression testing and design documentation.
• Good experience in data sources, data profiling, data validation, developing Low Level design patterns based on the business and functional requirements.
• Good analytical skills, presentation skills with strong communication skills.

TECHNICAL SKILLS

OS: Sun Solaris 2.7/2.6, HP-UX, IBM AIX 4.3/4.2, MS DOS 6.22, Win NT/2000/98/95

ETL Tools: Informatica Power Center 8/7.1/6.x, Power Connect, Power Analyzer, and Power Exchange tools, Datastage 7.5x,SAS

BI Tools: Cognos Impromptu 7.0, Cognos Reportnet 1.1, Business Objects, SAS and Siebel Analytics/OBIEE 10.3.0.1.6

Languages: SQL, PL/SQL, VB, C, C++, COBOL

Databases: Oracle 10g/9i/8i, MS Access, SQL Server, DB2, Teradata

Other Tools: Erwin 4.5/4.0/3.5.5/3.5.2

Testing Tools: Win Runner 8.2, Load Runner 7.8, QTP 8.2, Microsoft Test Manager, H.P Quality Center, Test Director

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Onsite ETL/BI QA Lead

Responsibilities:

• Managing a team size of three and responsible for planning activities, creating Test Plan, requirements Traceability Matrix and standard templates (Daily status, defect status, defect process etc.).
• Review requirements and design documentation to ensure traceability and testability, review deliverables for adequacy and completeness prior to systems implementation into production
• As a member of the Scrum team participated in daily standup meetings, project status meetings, grooming sessions, backlog meeting, Sprint planning meeting as well as retrospective meetings and iteration reviews.
• Preparing detailed Test plan, Test scripts and test cases by understanding the business logic and user requirements.
• Expertise in Functional testing, System testing, Integration testing and Smoke testing.
• Tested several ab initio graphs for inbound and outbound files from various external vendors.
• Experience running the ab initio psets from command prompt using air command.
• Experience running the ETL jobs from Control M scheduler.
• Responsible for defect tracking, defect reporting and defect reproducing
• Developed complex SQL queries in Teradata during End-to-End testing stage.
• Good testing experience on various flat files, source conditioning files.
• Good experience on validating the slowly changing dimension tables (Type 1,Type 2 & Type 3)
• Tested and validated, data cleansing, XML Data verification, XML Elements Verification, DTD Validations, XML Schema validation (XSD Files).
• Validated various EDI transacations sets like 834,820.
• Experience working on the PHMS systems which process the claims.
• Experience working on the PHMS systems migrations to FACETS.
• Expert in writing Teradata SQL queries to validate the test case results for back-end test cases.
• Tested various reports in the Business Objects.
• Validated and good knowledge on Claims, Providers, Members, enrollments, policy member demographic, disease management data.
• Well exposed to Software Development Life Cycle and Test methodologies.
• Tested the data and data integrity among various sources and targets.
• Validated and Tested Business Objects reports for the care advancement and disease management.
• Involved in testing to verify that all data were synchronized after the data is troubleshoot, and also used complex SQL to verify/validate my test cases.
• Created the test data & Coordinating with Developers/Leads in resolving bugs.
• Worked with data validation, data cleansing, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Responsible for validating the transferred data in Ms-SQL Server 2008, Procedures and functions etc.
• Worked on the UNIX for the running the Abinitio graph in the HP UX environment.

Environment: Abnitio2.15, Teradata V13, Ms-SQL Server 2008, Facets, Care Radius, Business Objects Trizetto CCA, XML,PL/SQL UNIX Shell Scripting,PHMS,FACETS, Control M, Share Point, Business Objects & Quality Center 9.2.

Confidential, Atlanta, GA

ETL/BI QA Module Lead

Responsibilities:

• Analyzed the Business requirements, Functional requirements and Design Specifications in order to write the Test Plans and Tests cases in Quality Center
• Developed Master Test Plan, Test Plans, Test Strategy, Test Scripts and Test Cases in Quality Center, Microsoft Test Manager and executed them.
• Tested several Abnitio graphs used to load data from Manhattan WMS System, flat files, SAP BW, Siebel UCM (Universal Customer Master), third party marketing vendor data (Ephinany, Exact Target, Acxiom, Tandem, Maps etc) into Customer DW core tables, Ms-SQL Server 2008, Sterling eCommerce (OMS) Application and POS Systems
• Tested and validated, data cleansing, XML Data verification, XML Elements Verification, DTD Validations, XML Schema validation (XSD Files).
• Tested and Validated Logistics data cleansing loaded from Manhattan WMS System to POS Systems
• Independently leaded various modules for the Project releases and Phases.
• Worked on the Siebel UCM DB2 DB for data setup during Integration Testing and good knowledge on Siebel Base Tables.
• Done various testing phases like White box Testing, Integration Testing, Functional Testing, System Integration Testing, Validation Testing, Static, User Acceptance Testing, Performance Testing and Regression Testing.
• Used various SQL queries to validate the test case results for back-end test cases.
• Tested various reports in the BI - Micro strategy 9.1 and compared the reports from Hyperion to Microstrategy (migration).
• Tested and Validated the data cleansing rules for Sterling eCommerce (OMS) application. Good knowledge on distributed order management, global inventory visibility, reverse logistics and delivery and service scheduling subject areas.
• Well exposed to Software Development Life Cycle and Test methodologies.
• Tested the data and data integrity among various sources and targets.
• Involved in testing to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases.
• Worked on Excel Pivoting tables for the summarize, analysis and presentation of the data in the Symantec layer (Reporting Layer)
• Reviewed Abnitio mappings/graph and test cases before delivering to Client.
• Responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Tested the BTEQ scripts for data loading and knowledge on the utilities like TPUMP, MLOAD, and FLOAD.
• Created the test data & Coordinating with Developers/Leads in resolving bugs.
• Testing has been done based on RFC (Request for Change) and Defect Requests.
• Prepared QA Test Results after Test case execution.
• Stimulated several production cycles. Worked with data validation, data cleansing, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Providing testing inputs to the Project team (Project manager, Planner and the Development lead) during the Planning sessions to finalize the Work Breakdown structure.
• Responsible for validating the transferred data in Ms-SQL Server 2008, Procedures and functions etc.
• Tested the Dash Board application on First Phone device and I-pad.
• Good knowledge on the Abnitio components and micro strategy(MSTR)
• Worked on the UNIX for the running the Abnitio graph in the HP UX environment.
• Tested the Dash Board application on First Phone device and I-pad.
• Providing testing inputs to the Project team (Project manager, Planner and the Development lead) during the Planning sessions to finalize the Work Breakdown structure (WBS).
• Good knowledge and scheduling the jobs in the Austosys

Environment: Abnitio1.15,Teradata V12,SAS, Siebel UCM 8.1, Unica CRM SQL, DB2 8,POS, WMS, Oracle10g, Ms-SQL Server 2008, XML,Ms Excel Pivot Tables, Sterling ecommerce(OMS), PL/SQL UNIX Shell Scripting, Autosys, Share Point, Hyperion 9.1,SAP DW, Data Services, Micro strategy 9.2, Windows, and Microsoft Test Manager, MS-TFS & Quality Center 9.2/10.

Confidential, NJ

Sr.ETL/BI QA Tester

Responsibilities:

• Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse
• Experience with high volume datasets from various sources like SAP DW, SAS,Ms-SQL Server 2008, Teradata, Exadata Oracle, Text Files, and Netezza Relational Tables and xml targets.
• Tested and validated XML Data verification, XML Elements Verification, DTD Validations, XML Schema validation(XSD Files)
• Performed database testing with SQL Queries.
• Involved in various phases of SLTC like White box Testing, Functional Testing, Integration Testing, Performance Testing, Regression Testing, Smoke Testing and UAT Testing.
• Prepared documentation for all the testing methodologies used to validate the Data Warehouse.
• Test execution in accordance with test strategy and test schedule, review; issue identification and data mining exercises in accordance with project plan timelines.
• Good knowledge and experience on dealing with rating agencies, due diligence, Basel II reporting, credit/underwriting process is idea.
• Compared, Verified and validated data between the Exadata and Teradata for the Cognos BI Application.
• Involved in check the data fed into Cognos 8 and OBIEE HRIS data warehousing as lifting data is from the terminal systems.
• Wrote the SQL queries & PL/SQL code on EDW tables and Cognos Data Mart Staging Tables to validate the data results.
• Tested, Compared and Validated the data of reports from Cognos 8 to Cognos 7
• Compared and tested the dashboards which were built in the OBIEE HR Analytics and Cognos reports like top performers by organization, employee performance, supervisor performance, employee performance by supervisor etc.
• Tested and validated reports like List, Group List, Cross tab Charts, Filters, Prompts, Subtotal, Calculations and Drill through reports in Cognos 8.
• Tested and Validated reports like Charts, Maps, Fonts, Styles, Header, Footer, Borders, Apply table styles, Swap Columns and rows, Sorting, grouping, conditional formatting’s, Drill up/drill down, master detail and scheduling reports in Cognos 8
• Tested the reports like top performers by organization, top performers by organization, employee transfer summary, poor performer’s terminations and transfers, head counts etc.
• Used Informatica for testing the mapping logic during Unit Testing. Performed unit testing, integrated testing and validated results with Business Analyst and/or customer.
• Used ETL Datastage ETL tool like designer, workflow and running the jobs as part of the QA execution.
• Involved in FTP process to transfer the files from one server to other.
• Performed quality control analysis and validates results of conversion programs.
• Used extensive SQL query. Evaluated actual data load results. Involved with high volume testing.
• Implemented SDLC, QA methodologies and concepts in the Project
• Completely involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts
• Extensively used Microsoft Test Manager and HP QC and created test cases in the TEST PLAN according to the specifications.
• Used TEST LAB to run the Test cases.
• Reported Defects and prioritized outstanding defects using Test Quality Center.
• Providing testing inputs to the Project team (Project manager, Planner and the Development lead) during the Planning sessions to finalize the Work Breakdown structure (WBS).
• Created the test data & Coordinating with Developers/Leads in resolving bugs.
• Ran the UNIX shell scripts to count the records for EDW Source to Staging Tables
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting and Autosys.
• Stimulated several production cycles. Worked with data validation, data cleansing, constraints, record counts, and source to target, row counts, random sampling and error processing.

Environment: Datastage 8.5, Cognos 8, OBIEE 10.3.4, SAP DW,PeopleSoft HRMS, Mainframes, SQL, PL/SQL Netezza 6, Teradata, Exadata, Hyperion 9.1, Ms Excel Pivot, UNIX Shell Scripting,XML, JCL,VSS, Toad, XML, Autosys, Share Point, Windows, Microsoft Test Manager and Quality Center 9.2.

Confidential, GA

Sr.ETL/BI QA Tester

Responsibilities:

• Involved in writing the test cases and Test plans based on Informatica Mappings Transformation Matrix or (Traceability Matrix) for supporting Black box and White Box testing.
• Prepared documentation for all the testing methodologies used to validate the Data Warehouse.
• Developed test conditions and test scenarios according to Business Requirements in Quality Center.
• Developed detailed test plan, and responsible for writing test cases and test scripts using Quality Center for System Integration Testing, White Box Testing, User Acceptance, Functional and Regression Testing and various other testing.
• Experience in testing many multi-layer data warehouse on Unix, Windows and Teradata systems
• Involved in writing JCL and Procedures to execute programs and create generations files
• Integration of mainframe and Unix environments in Data warehousing
• Conducted the Functional, System, White Box, Regression, User Acceptance and Performance testing of the Cognos application.
• As an analyst involved in gathering System and Business requirements, studying and coordinated with the Development and Business teams to prepare Test Plans.
• Analyzed the Business requirements, Functional requirements and Design Specifications, Detail Design Specifications and Technical Specifications in order to write the Test Plans and Tests cases in Quality Center.
• Extracted data from flat files and RDBMS tables and upload into targets Oracle tables. Used Informatica as the ETL tool to extract the data from sources and loading it into targets.
• Created ETL test data for all ETL mapping rules to test the functionality of the DataStage Mapping.
• Tested and validated reports like List, Group List, Cross tab Charts, Filters, Prompts, Subtotal, Calculations and Drill through reports in Cognos 8.
• Tested and Validated reports like Charts, Maps, Fonts, Styles, Header, Footer, Borders, Apply table styles, Swap Columns and rows, Sorting, grouping, conditional formatting’s, Drill up/drill down, master detail and scheduling reports in Cognos 8
• Tested and Validated the User Security Levels Data Visibility based on Responsibilities in Cognos 8.
• Managed the testing process, bug reporting, analyze the test results, track the progress of system testing, and provide daily status to Test Manager.
• Good experience working on the Agile environment and PMO standards
• Executed and written UNIX shell scripts to check whether data import/export done correctly or not.
• Written several complex SQL queries for validating/verifying various data cleansing business rules.
• Involved in Database testing by writing & executing SQL & PLSQL queries by using TOAD to validate the data that is being populated in an appropriate tables & manually comparing the results with front-end values.
• Worked with business team to test the reports developed in OLAP. Tested whether the reports developed in OLAP are as per company standards.
• Participated in weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.

Environment: Informatica Power Center 8.1,Datastage 7,Cognos 8,Siebel eComm 7.8, SQL, PL/SQL, DB2, PL/SQL, UNIX Shell Scripting, Toad, XML, Autosys, TSO, JCL, VSS, Windows, and Quality Center 9.2.

Confidential, Beaverton, OR

Sr. ETL QA Tester

Responsibilities:

• Designed and developed Test Plans, Test Scripts and Test Cases in Quality Center and executed them.
• Involved in implementation of the Test plans, Test cases and Test scripts.
• Involved in various testing phases like White box Testing, Unit Testing, System Integration Testing, Functional Testing, User Acceptance Testing, Performance Testing and Regression Testing.
• Used various SQL queries to validate the test case results for back-end test cases.
• Well exposed to Software Development Life Cycle and Test methodologies.
• Tested the data and data integrity among various sources and targets.
• Developed and involved in both Manual Testing and Automation Test scripts based on Use cases developed.
• Involved in testing to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing, Data Cleansing and designing of the flow and the logic for the Point of Sales (POS) Data warehouse project.
• Tested and created List Reports, Cross Tab Reports and Drill Through reports.
• Tested and developed Impromptu Web Reports (IWR) and published them into Upfront.
• Used Query Studio for Ad-hoc Reporting.
• Tested and created Top ten Reports & Sort Data on Percentage Growth.
• Good experience working on the Agile environment.
• Tested the PL/SQL scripts which inserts the data into the target tablesTesting has been done based on Change Requests and Defect Requests.
• Prepared System Test Results after Test case execution.
• Created critical scenarios for each change request and defect request.
• Hands on experience with working on Autosys jobs and MQ’s. MQ’s are used for intermediate storage where the messages are stored for temporary purpose.
• Hands on experience working with SQL Server DTS Packages.

Environment: GPI (Global Pricing Integration), POS, Informatica Power Center 8.1,Neteeza 6x, Oracle9i,Cognos,Business Objects XI, SQL, PL/SQL, Unix Shell Scripting, XML, HP Quality Centre, DBArtisan 8.5.2, Autosys, MQ’s

Confidential, NJ

ETL QA Tester

Responsibilities:

• Used Informatica Power Center for Extraction, Loading and Transformation (ETL) of data into the Data Warehouse.
• Involved in developing the Test Cases, Test Plans and Test Scripts using the Business Requirement
• Developed Shell Scripts to perform pre-session and post-session operations.
• Involved in writing the Test Cases, Test Plans and Test Scripts using the Business Requirement
• Involved in Manual Testing of the Application.
• Involved in Positive and Negative Testing.
• Written SQL queries in Oracle for testing the Informatica mappings.
• Extensively involved in the Performance testing of the programs, ETL Procedures and Processes
• Coordinated with QA Testing Team to test various test scenarios involving Test Plans, Test Cases and Test Scripts.
• Used various SQL queries to validate the test case results for back-end test cases
• Extremely involved in using Test Director.

Environment: Informatica Power Center 6.x,Oracle, SQL Server, Business Objects 6, Oracle 9i, SQL, PL/SQL, Erwin 4.0, Unix Shell Scripting.

Confidential

QA Tester

Responsibilities:

• Involved in implementation of the complete test cycle for sales order processing system.
• Analyzed business functional requirements to understand the business logic of the application.
• Supported the development team to resolve the problems associated with application.
• Helped to improve existing testing process under project called quality assurance process.
• Involved in testing of various applications in sales order Processing System.
• Involved in creating test plans and writing test cases for the application.
• Involved in running various test scripts using Win Runner.
• Performed regression tests, attended meetings with teammates to evaluate the progress and performance of applications
• Tracked defects and generated reports using Test Director.
• Also Wrote and tested Database triggers, stored procedures and functions for the development of this project.

Environment: Win Runner 6.0, Test Director 6.0, Servlets 2.0, HTML, JSP 1.0, J2EE, EJB 1.0, Java Script, Web Logic 4.5, Oracle 6, SQL, Windows NT