SUMMARY

• Information technology professional with 7+ years experience in Requirement’s Gathering, Analysis, Documentation, Testing, Implementation and Maintenance. Specialized in Quality Assurance and testing, worked as ETL Tester, SQL Tester, BI Tester, Data Tester and QA Analyst.
• Experience with Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Experience in Data Migration, Database Transferring and related objects in SQL Server from one server into other Remote servers.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle and Teradata, Ms Access, Flat files into a staging area.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
• Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Proficient experience with SQL Server and MSBI tools like SSIS
• Strong skills in database programming using SQL, PL/SQL, T-SQL, Stored Procedures
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• 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.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Excellent communication, analytical and interpersonal skills
• Good analytical skills, presentation skills with strong communication skills.

TECHNICAL SKILLS:

Business Modeling Tools: MS Visio, Power Designer

Database Management: DB2, Oracle 9i/10g, SQL Server 2000/2005/2008, Erwin 4.0/3.5 Teradata V2R6/V2R5

Data Warehouse Tool: Informatica Power Center, Ab Initio, MS DTS Packages & Fast Load

Functional Test Tools: Win Runner 8.0, QTP 9.x

Languages: C, C++, PL/SQL, T-SQL, SQL, Visual Basic 6.0, SAS 9.1

Office Tools: MS Office Suite, MS Project

Operating System: IBM AIX, UNIX, Windows

Rational Tools: Requisite Pro, Clear Case, Clear Quest, Manual Tester, DRAT Tool

Reporting Tool: Cognos, Business Objects, Crystal Reports

Defect Tracking tool: HP Quality Center

Tools: IMS, XMLSpy, TOAD, SQL Enterprise Manager, SQL Query Analyzer, Win SQL

Web Technologies: XML, XSL, XHTML, HTML, CSS, JavaScript, VBScript

PROFESSIONAL EXPERIENCE:

Confidential, RI

ETL QA Tester

Responsibilities:

• Interact with Business Analysts to clarify the User Design and functionality of the application. Writing Test Cases corresponding to business rules and requirements..
• Prepared Test Scenarios of testing and maintaining testing standards.
• Tested the IKA GUI application for all the Medicare and Medicare advantage plans.
• Mocked data as per CMS Rules and tested the Membership Enrollment Application
• Tested the subscriber and Member enrollment in association with class, plan and product.
• Developed Ab Initio test environment for UAT testing and used all Ab Initio components while testing the graphs and ran the jobs on back ground.
• Created ETL test data for all ETL mapping rules to test the functionality of the Ab Initio graphs
• Tested the ETL Ab Initio graphs and other ETL Processes (Data Warehouse Testing
• Validate the Files from IKA that are processed in NMS(Horizon New Membership Enrollment System).
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Responsible for testing Business Reports developed by Business Objects XIR2.
• The reports that were created in Business Objects were testing by running the SQL statements
• As a Lead, was involved in weekly status, following up the development as well as the business /Testing teams, re-scoping project planning.
• Validated the Enrollment data that fed into the UCSW(Universal Customer Service Workstation - Inquiry/ Service Request Application)
• Perform Functional, Regression, UAT testing. Validate provider access (Portal) with the Legacy if there are any difference just logs the defects, Its Web base application for the Provider.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Metadata graphs from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Used Rational Clear quest for logging the Defects.
• Involved in Daily Defect Meetings with Business and Development Teams.

Environment: IBM Mainframe Systems (NMS), Mercury Quality Center 10,MS Access 2010, Rational Clear Quest 7.1.1, SQL,Oracle,Teradata,Ab Initio CO>OP 2.15, GDE 1.15, Business Objects XIR2/6.5.1/6.0/5.1.x/4.0, IKA (GUI-Web Application)

Confidential VA

ETL QA Tester

Responsibilities:

• Analyzing the requirements and understand project functionality.
• Estimating the testing scope of the project based on the requirements.
• Preparing test plan, test strategy, and risk management plan for the project.
• Preparing the test case indexes and test cases using business requirements and technical requirement documents.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9
• Tested several data validation graphs developed in Ab Initio environment.
• Worked with all kinds of components with Ab Initio including Dedup, Denormalize, Normalize, Rollup, Scan, Reformat, Redifine, Sort, Joiner, XML Read, XML Write, FBE, Partition Components
• Created and tested business processes (UAT and Integration testing) and supported end users in execution of test scripts.
• An active participant in system Regression, Integration, UAT and Implementation TestingSupported the Stabilization of the new Lines of Business after Go-Live
• Wrote Complex Sql queries in Toad which are used in test cases for test execution.
• Tested Complex web service applications based on business requirements
• Used HP Quality Center for Test case execution and Log the defects.
• Attend Daily Defect triage calls and interacting with developers and Business analysts about the issues logged.
• Responsible for testing Business Reports developed by Business Objects XIR2.
• The reports that were created in Business Objects were testing by running the SQL statements
• Provide technical and procedural support for User Acceptance Testing (UAT)
• Preparing the Test Traceability matrix for mapping the requirements against Test Case Index and Test cases.
• Run the control m jobs in UNIX server.
• Used complex SQL Queries for Data mock up.
• Tested ETL data movement from source to target.
• Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
• Performed Functional, GUI, Regression, System Integration testing.
• Tested complex market transaction applications and applications with external vendors.
• Review of the test cases written for unit and integration level.
• Writing test cases for unit level testing and functional testing based on the threads.

Environment: Ab Initio CO>OP 2.15,Oracle 10g, Business Objects XIR2/6.5.1/6.0/5.1 HP Quality Center, UNIX, VBScript, QTP, SQL, PL/SQL, UNIX, Excel

Confidential, Warren, NJ

ETL SQL/QA Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
• Written several test cases for data migration from SQL Server 2005 to Oracle 11
• Reviewed Informatica mappings and test cases before delivering to Client.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Conducted source-system data analysis to understand current state, quality and availability of existing data.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in analysis, understanding of business requirements and expertise in understanding the complete information flow and database concepts.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Reported bugs and tracked defects using Quality Center 8.2 (Test Director)
• Tested Complex ETL SSIS Packages and Sessions based on business user requirements and
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Extraction of test data from tables and loading of data into SQL tables.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Written several complex T-SQL queries for validating/verifying the business rules for Data.
• Tested several stored procedures.
• 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
• Responsible for Data mapping testing by writing complex T-SQL Queries using Query Studio
• Validating the data passed to downstream systems.
• Worked with business team to test the reports developed in OLAP
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: MS SQL Server 2000/2005, MSBI( SSIS,), Informatica Power Center 8.1/7.1, (Power Center Designer, workflow manager, workflow monitor), Quality Center, Oracle 10g, Teradata, Autosys, VB Script, XML, XSD, Test Matrix, AIX

Confidential

ETL Analyst - Data Warehousing Practice

Responsibilities:

• Reviewed the Business Requirement Documents and the Technical Specification.
• Designed Test scripts and test cases in Test Director and MS-word.
• Generated automated test cases on first build of the module using QTP, Rational Tools.
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using QTP.
• Analyzed Software Requirement Specification
• Inserted Database Checkpoints to verify consistency of the database workflow using Win Runner
• Implemented Database Checkpoints for Back-end Testing
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Performed Functional Testing and Back-end Testing using the database comparable results Manually and Interacted with the users to ensure meaningful development of the scripts and simulated real time business scenarios
• Designed and Executed Test Plans, Test Cases and Test Procedures.
• Analyzed Software Requirements documents and Business Requirements documents to get a better understanding of the system on both Technical and Business perspectives.
• Involved in writing the Test cases and Test plans based on Source to Target Mapping documents and Data Model diagrams.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables..
• Designed and documented all the issues and defects to ensure application software functionality for present and future builds.

Environment: Informatica 6.2/5.1, TOAD, SQL, Load Runner, Win Runner, Test Director, Shell Scripting, Sun Solaris 5.8, PL/SQL, Windows NT 4.0, Erwin, Test Cases, Test Plan, Test Scripts, Load Runner 6.0/7.0, Windows NT