SUMMARY

• Over 7+ years of IT experience as QA Analyst/Backend Tester/ETL Tester/BI Tester
• Expert in Designing & Developing of Test Plans, Test Scenarios & Test Cases and Execution of Test cases
• Extensively used HP Quality Center for test management and defect tracking purposes.
• Strong knowledge and experience in SQL with ability to write complex SQL queries which can combine data from multiple tables.
• Sound working knowledge on UNIX in writing UNIX shell scripts, File management, Running Large volume Data loads & batch jobs
• Expert in Waterfall Lifecycle, AGILE, Scrum project SDLC methodologies
• Excellent experience in RDBMS technologies like Oracle, DB2, Teradata 12.0/V2R6/V2R5/V2R4/V2R3, MS SQL Server 2008/2005/2000/7.0/6.5 , Dbase, Excel and MYSQL. SQL Developer, TOAD, DB2.
• Extensively used SQL, PL/SQL to create complex queries, SQL Stored Procedures, Triggers.
• Expert in setting up Test environments which includes Configuration, data, builds and batch job installation & execution
• Expert in Unit testing, Integration testing, System Testing, Regression Testing, GUI Testing, Performance Testing, Load Testing, Stress Testing, Smoke Testing, Functional Testing, End to End Testing, Backend Testing
• Expertise in presenting and conducting UAT’s with Business team
• Extensive working knowledge on QTP for automation requirements.
• Participation of Defect Review Meeting with business & IT team
• Familiar with ICD 9 - ICD 10 conversion project
• Familiar with ICD 9 - ICD 10 code structure
• Strong knowledge of programming language C/C++, OOP’s concepts Encapsulation, Polymorphism, Inheritance, Virtual Functions.
• Ability to debug the code written in C/C++ languages.
• Strong trouble shooting, learning and problem solving skills with ability to work independently and as a team member.

TECHNICAL SKILLS

Operating Systems: Windows 7,Windows NT/98/2000, Windows XP, UNIX (Sun, AIX, HP), and MS DOS

Servers: IBM Web sphere 2.0, BEA Web Logic Server 8.1, Java Web Server, ActuateServer

Languages: C, C++, Visual C++, SQL and PL/SQL

Database: IBM DB2, Oracle9i, Oracle10g, SQL Server 2000, Sybase, Teradata and MS-Access

Testing Tools: Quick Test Pro and Quality Center.

Utilities: Toad, Citrix server, Oracle SQL Developer, Putty, VPN and Ipswitch WS FTP 12UltraEdit, Beyond Compare 3

ETL: Datastage 8, Informatica 8.6.1, 9.0, Ab Initio, DMExpress

Reporting Tools: Business Objects Xi R2, Cognos 8

Scheduling: TWS

PROFESSIONAL EXPERIENCE

Confidential, PA

Sr. ETL/ QA Analyst

Responsibilities:

• Reviewed the business requirements for Data Warehouse ETL process and working with business and requirements team for gaps found during the review.
• Designed & Created Test Cases based on the Business requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Created Requirement Traceability Matrix for various projects.
• Performed complex data validation usingSQLqueries.
• Responsible to verify data completeness, data transformation, data quality, unit testing, integration testing, Interface testing, UAT & regression testing.
• Created test data required for new project eCommunication (eRegistry, eInquiry).
• Validated the design meets requirements and function according to technical and functional specifications.
• Performed monitoring of the ETL jobs (Extraction, Transformation and Loading) with the help of DMExpress.
• Written several complexSQLqueries for data verification and data quality checks.
• Used HP Quality Center 9.2 to state requirements, business components, test cases, and test runs for every iterations, defects.
• Performed data warehouse validation of source to target transformations usingSQLqueries.
• Used TOAD & SQL Developer GUI tools for Querying Database.
• Developed a detailed Test Plan, Test strategy, Test Data Management Plan, Test Summary Report based on Business requirements specifications.
• Executed DMExpress jobs to test the ETL processes.
• Developed Strategies for Data Analysis and Data Validation.
• Validated data flow from Source through to FACT tables and Dimension tables using complex queries (left outer Joins, sub queries etc).
• Envolved in preparing Testplan for the needs of the business segment for the ICD-10 Enterprise testing efforts implantation in Insurance Solutions Data Warehouse(ISDW)

Environment: DMExpress 6.7, Oracle 10g, TOAD for DB2 4.7, SQL Developer, IBM DB2 8.1, UNIX, HP Quality Center 10.0, TWS, Beyond Compare, Ipswitch WS FTP 12, UltraEdit 17.1

Confidential, Nashville, TN

Sr.ETL/ QA Analyst

Responsibilities:

• Reviewed the business requirements for Data Warehouse ETL process and working with business and requirements team for gaps found during the review.
• Designed & Created Test Cases based on the Business requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Created Requirement Traceability Matrix for various projects.
• Performed complex data validation usingSQLqueries.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Validated the design meets requirements and function according to technical and functional specifications.
• Performed monitoring of the ETL jobs (Extraction, Transformation and Loading) with the help of Informatica.
• Written several complexSQLqueries for data verification and data quality checks.
• Used HP Quality Center 9.2 to state requirements, business components, test cases, and test runs for every iterations, defects.
• Performed data warehouse validation of source to target transformations usingSQLqueries.
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• Automating the manual test cases using QTP scripts for regression testing.
• Developed a detailed Test Plan, Test strategy, Test Data Management Plan, Test Summary Report based on Business requirements specifications.
• Wrote extensive SQL and PL/SQL scripts to test the ETL flow.
• Executed Informatica workflows to test the ETL processes.
• Developed Strategies for Data Analysis and Data Validation.
• Used the Informatica Designer to develop various workflows for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Involved in DATA validation using SQL queries and back-end testing.
• Validated data flow from Source through to FACT tables and Dimension tables using complex queries (left outer Joins, sub queries etc).
• Validated FK failures and data integrity checks for all the tables.

Environment: Informatica 8.6.1, Oracle 10g, TOAD for oracle, SQL Developer, IBM DB2 8.1, Sybase 12.5, UNIX, HP Quality Center 10.0, AutoSys Jobs, Micro Strategy

Confidential, New York, NY

QA /ETL/Analyst

Responsibilities:

• Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse as part of EDW Project.
• Well exposed to SDLC (Software Development Life Cycle) and Test methodologies.
• Configured the QA Environment for Manual Testing as well as Automation through autosys.
• Designed and created the Microsoft Visio diagram which represents the workflow and execution process of all the process in the reinsurance world.
• Worked with Legacy MainFrame environment and tested the COBOL Files and Record Formats using Copy Books.
• 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
• As a Test Lead involved in gathering System and Business requirements, studying and coordinated with the Development and Business teams to prepare Test Plans and Execution Plans.
• Involved in Database testing by writing & executing SQL & PLSQL queries using TOAD to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.
• 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.
• Involved in writing the test cases and Test plans based on Informatica mappings and Data Analyst mappings, BA Visio diagrams.
• Extensively worked on handling the application response for Positive and Negative sets of data using data driven testing. Also manually tested the application for each system build, for both negative and positive testing.
• Tested complex objects to the universe to enhance the report functionality.
• Tested ad hoc and canned reports for Business objects.
• Coordinate Test Data Preparation with business users covering all necessary features for securities.
• Tested Business Objects reports and Web Intelligence reports.
• Test execution in accordance with test strategy and test schedule, review; issue identification and data mining exercises in accordance with project plan timelines.
• 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.
• Generated tractability Matrices to ensure that all the requirements are covered by the test cases.
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing. Performed unit testing, integrated testing and validated results with Business Analyst and/or customer.
• Involved in FTP process to transfer the files from one server to other.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Utilized HP Quality Center for Tracking and Reporting Defects, which are assigned to developers. Designed, developed and executed Test Plans, Test Scripts and Test Cases in HP 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).
• Participated in Daily and weekly status meeting with team members and coordinated with teams for the progress of the work done in application.

Environment: Informatica 8.6.1, Business Objects XIR3, SQL, PL/SQL, SQL Server 2008, Unix Shell Scripting, TOAD 9.2, Teradata, Oracle 10g, HP Quality Center, Autosys, Microsoft Visio

Confidential, Williamsville, NY

QA Engineer

Responsibilities:

• Analyze business requirements (e.g., business logic, Process specs, process flows). Developed test plans and test cases based on the business requirements.
• Writing the test scenarios based on business requirements and Business use cases
• Developed a detailed Test Plan & Test strategy based on Business requirements specifications
• Responsible for Backend testing with TOAD by comparing the Changes in the frontend FACETS 4.5.
• Validated ETL Workflows for Parameter.
• Experienced with automated software testing tools Quick Test Professional (QTP), WinRunner.
• Involved in using complex SQL/Joins to query the FACETS Database.
• Used various SQL queries to validate the test case results for back-end test cases. Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Tested various jobs and performed data loads and transformations using different stages of DataStage and pre-built routines, functions and macros.
• Tested DataStage jobs to allow portability and flexibility during runtime.
• Tested Datastage Hashed files for extracting and write data to an intermediate file in a job.
• Extensively worked on Facets database tables such as NCA APPS PROCESS INFO table, CMC GRGR GROUP,CMC CSPI CS PLAN,CMC SBSB SUBSC,CMC MEME MEMBER,CMC SBAD ADDR,CMC MEPE PRCS ELIG,NCA SBSE SUB ELIGIBILITY,NCA GREL GROUP ELIGIBILITY and NCA APPS PROCESS INFO.
• Extensively validated different ETL workflows such wkflw UT07 PARAMETER CREATE, wkflw UT07D ARG MEMBERS, s m ARGD MBR 02A MOVE CURR TO PREV.
• Analysis, Project planning, Status reporting, document review and defect entry verification.
• Written & execution of Test Cases for each functionality based on interfaces that interacting with workflow application.

Environment: Datastage, Windows XP, Oracle10G, Sybase, TOAD for oracle, UNIX, Reflections, Mercury Quality Center, PVCS (Dimensions), MS Project, FACETS 4.3, FACETS 4.5, NCA Main Frame for CA7 Job Scheduler.

Confidential, Hartford, CT

QA Engineer

Responsibilities:

• Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, Test Data and Traceability Matrix.
• Conducted Functional, GUI, Regression and User-Acceptance (UAT) testing
• Developed XML test files based on XML schema.
• Generated XML data files using XML Spy.
• Validated the Web Services (SOAP), both Request and Response messages.
• Tested the Source and Target databases and ETL process.
• Developed Test Cases and Test Design using Quality Center.
• Automated the scripts using QTP by developing VB scripts.
• Developed functions in QTP.
• Build upSQLqueries to get data from both source and destination and to compare them in the test bed.
• Worked with SQL, PL/SQL and functions to test the database integrity (Oracle).
• Created Traceability between Requirements and Test Cases.
• Conducted Data Driven testing to test various sets of data.
• Worked with UNIX Shell Scripts.
• Tracked the defects using Test Director and generated defect summary reports.
• Maintained Test Logs, Test Summary reports and participated in defect review / Status / GO-NOGO Meetings.
• Configuration management / Version control was done using Rational Clear Case.

Environment: Mercury Tools, QTP 8.0, VB.NET, ASP.NET, IIS, XML, SOAP, Windows XP, SQL Server, Mainframes (DB2, JCL, CICS), MS-Office.