Professional 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 and Installation of builds on Test machines
• 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.
• Expertise using Business intelligence reports testing using: BusinessObjects XIR3.1, Cognos Series 8.x/7.0/6.0 and Microstrategy
• 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 System Testing, Regression Testing, GUI Testing, Performance Testing, Load Testing, Stress Testing, Smoke Testing, Functional Testing, End to End Testing, Compatibility Testing, Backend Testing and Security 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
• 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 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, Actuate Server
• Languages: C, C , PERL, HTML, XML, Visual C , SQL and PL/SQL
• Database: Oracle9i, Oracle10g, SQL Server 2000, IBM DB2, Sybase, Teradata and MS-Access
• Internet: JDK1.3, Servlets1.4, Java Beans, Applets, JFC/Swing, HTML, Java Script1.2, CSS
• Other Software: Web connector, EDI, PEGA, FACETS, FLEXX and TCP/IP
• Testing Tools: Quick Test Pro and Quality Center.
• Utilities: Toad, Citrix server, Oracle SQL Developer, Putty, VPN, Net meeting and CuteFtp.
• Packages: MS-Office, MS - Visio and MS-Project.
• ETL: Datastage 8, Informatica 8.6.1, 9.0, Ab Initio
• Health Care: EPIC Suite, HL-7, FACETS 4.5
• Reporting Tools: Business Objects Xi R2, Cognos 8, Verisk Health Systems, Micro strategy
• Scheduling: Autosys, Cron Tab

Project Experience:

Confidential

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 using SQL queries.
• Responsible for testing packages using SSIS ETL to verify data completeness, data transformation, data quality, integration testing, UAT regression testing.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments.
• 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 complex SQL queries 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 using SQL queries.
• Tested messaging and SOA web services using XML, Web services were tested using system-to-system and UI to system tests.
• 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, Data Reconciliation, Initialization, and Change Data Capture, Delta Processing.
• 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

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, JCL, TSO, COBOL Files, TOAD 9.2, Teradata, Oracle 10g, Mainframe, HP Quality Center, Autosys, MQ Series, Microsoft Visio, Web Focus reports

Confidential

Role: 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.