PROFESSIONAL SUMMARY:

• Over 7 years of experience in health care services as well as Web Services testing, ETL testing and manual testing on web based, Client/Server and data warehousing applications. Well - versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Professional experience in Integration, Functional, Regression, Smoke and System Testing.
• Experience in Web based applications like online banking, transactions applications and ETL application like conversion, interfacing and Data warehousing.
• Expertise in Human resource management, Banking, and Financial domains etc.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica jobs.
• Experience in Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Experience in creating Requirement Traceability Matrix (RTM) documents.
• Experience in preparing Test Strategy, analyzing the Test Plan, developing detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Worked with Development team and Business Analysts to analyze the test scenarios and ensure that test requirements are correct and complete.
• Experience in using HP Quality Center, ALM for Bug Tracking and Defect Reporting.
• Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports and observed design inconsistencies.
• Expertise in querying and testing RDBMS such as Oracle, SQL server and DB2 using SQL for data integrity.
• Expertise in validating the data on AS400 Screens.
• Hands on experience in LISA and DEV Test Automation tools.
• Experience in System Testing, Integration Testing, End-to-End Testing of complex multiple Interfaces and Regression Testing on Windows and UNIX environments
• Expertise in defect analysis, planning, assessing challenges / risks, estimating and scheduling of testing tasksfor QA engineers and proficient in reporting, tracking, scheduling and managing bugs and issues to ensure commitment dates be met.
• Good experience in Water fall process and agile process.
• Having experience with automation testing tools like Quality Center (QC).
• Expertise in co-coordinating On-Site & Off-Shore teams and can handle multiple tasks.
• Clear understanding of business procedures and ability to work as an individual and as a part of a team.
• Flexible and versatile to adapt to new environment and hardworking and self-motivated.
• Highly motivated team player with excellent analytical, problem solving, interpersonal and communication skills.
• Excellent interpersonal communication skills, functional and technical documentation skills. Willing to relocate: Anywhere

WORK EXPERIENCE:

Confidential, Baltimore,MD

ETL Tester

Responsibilities:

• Analyzed the Functional requirements, Application Design Documents, Interface Specification document sand developed Test Plan, Test Cases, Test Scripts and Test Suites to cover overall quality assurance testing using HP Quality Center.
• Worked on multiple projects including Integrated Customer Experience R1, R2 and R4 Releases, Retail Script Sync, UMS Universal Medication Scheduling).
• Tested multiple SOAP and RESTFUL based Web services using SOAP UI and ITKO LISA/DEV Test(Automation) tools
• Tested multiple SOAP and Restful services consuming by applications including People Safe, CVS.com,
• Worked on multiple adjudication systems including QL, RX Claim and RECAP systems.
• Tested several services which are migrating from Enterprise Common Services (ECS) to Enterprise Service Layer (ESL) architecture.
• Gathered required Test Data from multiple teams and used them effectively in multiple types of testing including system Testing, Regression Testing and End to End Testing.
• Analyzed request and response XML 's of several operations
• Developed test cases and test suits based on WSDL's and Interface specs
• Good Understanding of XML, JSON message formats
• Good Working knowledge on Groovy Language
• Accessed and Analyzed several Data power and IIB9 Logs while trouble shooting and Test Execution.
• Developed and generated daily testing status, test traceability matrix and test coverage report for the management using Quality Center
• Performed Regression Testing with existing test cases and test scripts after fixing bugs and enhancements to the applications.
• Participated in Weekly Project status meeting and involved in improving the testing Process.
• Participated in requirements review meetings and identified the gaps in requirements.
• Performed Smoke Testing, SIT Testing, End to End Testing, User Interface Testing and Regression Testing• Participated in Test Plan, Test Cases and Test Summary Reports internal and external review meetings with clients and Project Stakeholders.
• Worked closely with software developers and business analysts on defect review, analysis and resolutionof defects.
• Worked in Onsite/Offshore model and coordinated several testing activities with offshore team.
• Expertise in using Test Utility tool to test the operations that are not migrated to ESL.

Environment: SOAP UI, Test Utility, Informatica,ITKO LISA, HP Quality Center, Main Frame, JSON, DB2, Java, Ajax, HTML, XML, XPATH, Data Power, IIB9, Web Sphere, Load runner, SOAP Web Services, RESTful, UNIX and Windows NT.

Confidential, Hopkins,MN

ETL/BI Tester

Responsibilities:

• Analysis business requirements, data mapping requirement specifications, and responsible for documenting functional and supplementary requirements in Quality Centre (QC).
• Involved in reviewing Data mapping specifications document to create and execute detailed system test plans. The data mapping specifications document specifies what data will be Extracted, Transformed and Loaded into the Data Warehouse.
• Involved in writing detailed Test Cases and Test Scripts using Quality Centre (QC) for Functional and Regression Testing.
• Planned, designed and executed test cases based on requirement specifications document and developed manual test cases for Positive, Negative and Functional testing.
• Involved in setting up the test environment (in QA and UAT regions) by making the required data available forwarding the ETL Processes. Data validations are performed for the data that moves from source to staging, staging to ODS (Operational Data Store) and ODS to data warehouse.
• Used Quality Centre to perform manual testing to check the basic functionality of the modules.
• Written UNIX scripts commands which involves data validation.
• Responsible for testing ETL process based on Data Mapping Specification Document by writing complex SQL Queries.
• Compared and validated Reports Generation with Query Outputs using SQL Scripts and Cognos.
• Performed quality assurance reviews throughout System Development Life Cycle.
• Performing the manual testing on the main features of the product.
• Involved in Regression, Functional, Integration and System Testing.
• Performing the Smoke testing of the build and verifying the fixed defects.
• Used Quality Centre (QC) to track and report system defects.
• Participated in defect review meetings with the team members and improve data quality.
• Scheduled Review meetings to discuss Test Plans, Test Cases and Test Results.

Environment: & Tools Used: Quality Center, Autosys, Manual Testing, DB2, Toad 9.7.2, Sql developer, Informatica,Cognos,Linux.

Confidential, Indianapolis,IN

ETL Tester

Roles and Responsibilities:

• Actively participated in multiple review meetings including Stakeholders Scope, Functional Spec, Test Plan and Test Case.
• Create Test design estimations based on initial review scope
• Create Test strategy and review testing approach with Project management, Development, Business Analyst and Business Users to identify dependencies and make changes where it is necessary.
• Used Rational Quality manager to write test cases, analyzed the results, tracked the defects and generated the reports
• Create Test Plan and assign tasks to team based on the Development Build plan
• Prepared test scenario and review with Business Users according to Business requirement and use cases to cover business scenarios.
• Involved in White Box Testing.
• Create, debug and run the test scripts/procedures in Rational Robot.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Reported the bugs through email notifications to developers using Quality Manager
• High Level Test Plans were written by incorporating User Profiles, Configurations, Environments Risks, Test Scenarios, Schedules and Analysis and Presentation of ResultsInvolved in validating both functional and automated business processes using Quality Manager.
• Performed extensive Backend Testing by developing, modifying, and executing SQL queries for data validation and data verification on database.
• Performed front end web application testing and verified and validated defects using SQL to retrieve data from database.
• Documented all errors/defects identified and implemented their resolutions as defined by management.
• Involved in Manual and Automated testing using RQM and Robot
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Developed strategies and plans for test automation, and implemented automated test scripts.
• Worked with software testing methodologies with all phases and stages of testing desired (Functional, System, Integration, Regression, Data Validation, User Acceptance, Performance, Stress and Load).
• Inserted verification checkpoint for the validation of the functionality under stress conditions.
• Engaged in daily triage meetings and reporting.
• Written several complex SQL queries for validating Cognos Reports.
• Facilitated formal review meetings with users and developers to report, demonstrate, prioritize and suggest resolution to issues discovered during testing cycles
• Tested ETL Mappings and worked with Staging area to validate the data with SQL queries.
• Worked with Legacy and current data sources and ETL Transformations (Data cleansing validations and Matching processes)
• Provided a weekly project report that includes Test Metrics and status reports
• Developed SQL Queries and Procedures to perform database testing using SQL Plus.
• Co-ordinate with the whole testing team to ensure total quality control on all deliverables.

Environment: UNIX, Oracle 9i, SQL Server2005, Autosys, Ab Initio, VB script, Rational Quality Manager 10.0,, SQL, PL/SQL, PERL, Shell Scripting, Windows XP, MS Office Suite