SUMMARY

• Around 8 years of focused experience in IT Industry with a strong back ground in testing of Client Server and Web based applications in various verticals such as Health, Insurance, Finance, Banking and Pharmacy.
• Having good knowledge in Software Development Life Cycle SDLC Software Testing Life Cycle STLC which includes Requirement Gathering, Data Analysis, Application Design, Implementation and Testing of various applications.
• Strong knowledge in life cycle of Data Warehouse using Data Extraction, Data Transformation and Data Loading processes ETL and having profound knowledge in Dimensional modeling techniques Kimball and Inmon , Star and Snowflake schema addressing Slowly Changing Dimensions SCDs .
• Experience with structured QA Methodology and QA Process to ensure the Quality Assurance Control.
• Experience in ETL testing using tools like Informatica Power Center 9.0.1/8.6.1 and reporting tools like SAP Business Objects X1 3.1, IBM Cognos 8.4.
• Experience in integration of various data sources like Oracle, IBM UDB DB2, MS SQL Server, XML and Flat files.
• Worked on Test tools like Mercury HP Quality Center/Test Director and having knowledge on automated tools like QTP 9.2, HP Load Runner 9.5, Win Runner, Quick Test Professional QTP and Rational Clear Quest.
• Experience in creating Traceability Matrix, Test plans, Test design, Use cases, Test cases, Test procedures, Test log, Test Scenarios, Automated Test scripts, Defect reporting and Documentation for both Manual and Automated Testing.
• Having hands on experience in client/server and web applications using White Box, Black Box, Functional, Unit, Integration, End to End, UAT Acceptance testing, Smoke Testing, Deployment Testing, Performance Testing and Regression Testing.
• Expertise in RDBMS backend testing for data validation of the business rules to ensure data integrity using SQL Assistant.
• Experience in writing simple and complex SQL queries using TOAD, Squirrel SQL and Oracle SQL Developer/Navigator.
• Experience in design/testing and implementation of stored procedures, triggers and functions at database level using PL/SQL.
• Executed negative and positive test cases to test application functionality against user requirements.
• Experience in creating and scheduling jobs using Autosys, TWS Scheduler and Control-M.
• Experience in executing shell scripts for testing in UNIX environment.
• An excellent team member with an ability to perform individually with strong verbal, interpersonal and written communication skills.

TECHNICAL SKILLS

WORK EXPERIENCE

Confidential

Test Analyst

Confidential is one of the leading HealthCare companies which contribute to the systemic improvement of health care delivery and the health of the communities. creating solutions to optimize processes for health care organizations ranging from single-doctor practices to entire countries, for the pharmaceutical and medical device industries, and for the field of health care as a whole. Successfully developed and maintained ETL maps to Extract, Transform and Load data from Millennium to the Data warehouse. The data warehouse contained person's healthcare information including but not limited to demographic, clinical and medical history. The project aims end users for reporting and thereby helping them to make decisions for new product improvements, analysis of existing products.

Responsibilities:

• Involved in Gathering requirements from Business Analysts and preparation of test scenarios and Test cases.
• Used Informatica Power Center 8.6.1/9.0.1 as an ETL Tool for extraction, transformation and loading ETL of data into the Data Warehouse.
• Responsible for testing Business Reports by running the SQL Queries on the database by reviewing the report requirement documentation.
• Validated the Business Objects reports to ensure the quality of data being presented to the clients and did the regression testing for various scenarios on Designer, DeskI, QaaWS, Rich Client and Webi on BO XI 3.1 SP6.
• Exported the results through SQL and documented the test results for test cases, suites executed.
• Worked in creating test cases/ test scripts for Inbound and Outbound ETL processes and interfaces with other systems and streams.
• Validated graphs/charts on ClinicOps Dashboard and trend charts and tested each chart thoroughly in different formats like PDF and CSV.
• Experience in writing JUnits for inserting the data into the database tables for automated testing.
• Performed data quality gaps and data cleansing Scrubbing to ensure no missing data/duplicate data is found.
• Validated the load process of ETL to ensure the target tables are populated according to the data mapping provided that satisfies the business rules.
• Prepared Test Plan, Estimation and Overall project tracking for every release.
• Managed and conducted White box testing, Engineering Black Box Testing, Certification Testing, Non-Prod Testing, Smoke Testing, Integration Testing, System testing, User acceptance testing, Prod Testing, Deployment Testing and Regression Testing to meet the business requirements.
• Migrated Unix/Informatica application releases from development to QA and to UAT environments as required.
• Configured servers VM's on Linux box for Sandbox and Prod environments to facilitate Non-Prod and Prod Testing.
• Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
• Worked exclusively with HP Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, and Defect Reporting.

Environment: Informatica Power Center 8.6.1/9.0.1, SAP Business Objects XI 3.1 Designer, DeskI, WEBI, CMC, Info View, Import Wizard , Java 1.6, Maven 3.0.5, Maven 2 Tools 2.0.1, CCL, Filezilla 3.6, JIRA, Flat Files, Crucible 3.0, Oracle 11g, Oracle SQL Developer 3.1, Eclipse IDE 2.0.1, Feature Tracker, SVN, HP Quality Center 11.0/10.0 and UNIX Shell Scripting.

Confidential

Sr ETL Testing Consultant

Confidential is one of the world's largest banks which offer current accounts, savings, mortgages, loans, credit cards and much more. It has bought Sovereign Bank. This project is an Integration of Sovereign Bank with the Santander Bank. Informent is the current enterprise data warehouse for Sovereign Bank. It receives data from host applications mainly Fiserv's Source One and provides output for management, regulatory and operational reporting.

• Worked with Business Analysts and analyzed business requirements, system requirements, data mapping requirement specifications, HLD and LLD.
• Created ETL test data for Personal Accounts, Installment Loans, Online Banking, BDP, Online Collections, Product Catalog, and Line of Credits in Oracle Database as per the requirements and written SQL queries to validate the data.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Extensively tested several ETL Mappings developed using Informatica.
• Executed Test Cases and Tested Warehouse metadata, naming standards and warehouse standards for future application development.
• Prepared several complex SQL Queries for testing the Business rules for testing the ETL functionalities.
• Validated fact and dimension mappings and performed data cleansing, sanity checks and purging process.
• Logged issues in Quality Center and tracked them to see whether the bug is fixed in the next version.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Worked on creating UNIX scripts for file transfer, file manipulation and log verifications.
• Performed regression testing on every build to check if the defects identified in the previous release are corrected according to the business requirements.
• Generated Daily and weekly Status Reports to the team manager participated in weekly status meeting with Team members, Business analysts Development team.
• Having exposure on conducting the internal audits and external audits for various projects and departments ensuring the Quality of the work done.

Environment: Informatica Power Center 8.6.1, Business Objects XIR2, Oracle 11g, Flat files, UNIX Shell Scripting, Windows 2003, Toad 9.7 for Oracle, PL/SQL, HP Quality Center 10.0, WinSCP 4.2.8.

Confidential

ETL Test Engineer

Confidential works on behalf of government and private healthcare programs to make sure that claims are paid accurately, and by the responsible party. The project can be broadly classified into Commercial Confidential information is received from Carriers on a monthly or less frequent basis. Often times, an individual will have more than one of these types of coverage. The States pay HMS to recover money from Commercial and/or Medicare Insurance Companies when they have paid for something that they should not have paid for.

• Analyzed business requirements, system requirements, data mapping requirement specifications and responsible for documenting/creating functional test plans and supplementary requirements in Quality Center.
• Involved in developing detailed test plans, test cases and test scripts using Quality Center for UAT tests.
• Executing test scripts to verify actual results against expected results by using Informatica Power Center for different source validations.
• Used UNIX shell scripts as a part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• 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.
• Validated the daily and monthly reports against the data in the DB2 Database.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Written several complex SQL queries for validating/verifying the business rules for Data.
• Created test cases on Cognos Report studio reports based on the report requirement documents and created test cases on the Cognos Framework Manager model by writing queries to compare the results with the results generated by Meta data model in Report Studio.
• Involved in raising bugs and bug tracking analysis to resolve issues.
• Prepared status summary reports with details of executed, passed and failed test cases.
• Worked closely with users and application developers to ensure that the application development meets to user's expectations.
• Co-ordinated with the offshore team on a regular basis.

Environment: Informatica Power Center 8.6.1., IBM UDB DB2, PL/SQL, HP Quality Center 9.2, Cognos 8, Quest Central for DB2, Autosys, Toad for DB2, UNIX Scripting and Windows 2003.

Confidential

ETL Test Consultant

Confidential offers a wide range of personal property and casualty P C insurance, including automobile insurance, homeowner insurance, renters insurance as well as umbrella and personal property insurance. USAA issues the insurance policies specifically for the US Federal employee's. This project mainly deals with the P C insurance policies data for different line of business. Cleansing of data is done in Mainframes to some extent and then the data flows through Staging Data store Claims analytical Data store - CADS , Packaging and finally loaded into Data Mart, Policies are processed weekly and monthly.

• Analyzed the Business Requirements Document, Functional Specifications documents to prepare the Test Cases based on the Test Plans and Use Cases.
• Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix RTM .
• Used HP Quality Center to create test plans, gathering requirements, analyzing the results and reporting for different subject areas like Loss Report, Claims Legacy replacement CLR
• Extensively used Informatica to load data from Flat Files to SQL Server, SQL Server to Flat Files and SQL Server to SQL Server.
• Developed Weekly and Final Test Status reports with all the Test Metrics Such as Total Test Executed, Total Test Analyzed, Total Passed and Total Failed.
• Validated the data files from source to make sure correct data has been captured to be loaded to target tables.
• Developed parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
• Used Rational Clear quest an automation tool for defect tracking and product automation.
• Used SQL queries and UNIX Shell scripts to check the database integrity.
• Created and executed SQL queries to fetch data from database server to validate and compare expected results with those actually obtained.
• Analyze report defects Test Summary on Functional, System, and Integration, Regression issues.
• Involved with smoke testing on Production environment to verify that the applicable workflows in Informatica ran successfully.
• Performed Black box, functional testing and System testing for each release.
• Worked with SQL queries as a part of Database Testing to verify the data integrity and prepared test cases to test the backend Database by retrieving the data for the tables using TOAD.
• Written several SQL statements to confirm successful data transfers between source and target.
• Generated RTM and provided Defect Reports to the developers.
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.

Environment: Informatica Power Center 8.6.1, HP Quality Center, IBM Rational Clear Quest, XML,

MS SQL Server 2005, Main Frame COBOL Sources , Flat files, Xming, Borland Star Team 2008 R2, TOAD for SQL Server 4.0, Control-M Enterprise Manager 7.0, PL/SQL and UNIX Shell Scripting.

Confidential

DWH Testing Consultant

The project relates to the Data Warehouse that can be broadly classified into Pharmacy and Retail. Pharmacy Data Warehouse consists of DW CAP Data Warehouse Compliance Adherence Persistency system and Pharmacy Batch. Successfully tested number of ETL maps to Extract, Transform and Load data from various sources like Flat files and Relational data into the Enterprise Data warehouse called Pharmacy Data Warehouse Management system. This includes creating and running scripts, loading data into Dimension tables and Fact tables.

This consist of jobs that are used by the Pharmacy Data Warehouse for loading script, extracting and transforming, customer, doctor, third party and other information.

• This application is used to generate information about patients, prescribers for CVS to generate contacts on behalf of drug manufacturers.
• Used by Health Care Marketing department.
• CAP Compliance Adherence Persistency System is a data mart that contains subset of data from Pharmacy Data Warehouse. All CAP jobs are used to extract the data from Pharmacy Data Warehouse side and load them onto different server, replicate the table/snapshot between two databases, generate the contact files based on the business rules and FTP the files to Call Center.

• Worked with Business Analyst to gather the business requirements and involved in weekly team meetings.
• Reviewed Business Requirement Document BRD for accuracy and Completeness.
• Used the Informatica Designer to develop processes for extracting, transforming, integrating and loading data into data warehouse database.
• Involved in designing/developing all the necessary documents for QA Testing like Test scenarios, Test Strategies, Test plans, Test cases and Test data.
• Worked with IT Development team to ensure feasibility of design and clarify user requirements.
• Developed SQL Queries/Scripts and similar artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
• Performed Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysis and Data Quality Validation while Data Migration.
• Reviewed manual testing methods and created and implemented an automated test strategy and generated automation scripts.
• Performed Unit Testing, Integration Testing, User Acceptance Testing and Requirement Testing.
• Prepared test data for positive and negative test scenarios for Functional testing as documented in the test plan.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them cover important risks.
• Identified analyzed questionable functions, errors and inconsistencies in the Functionality/UI/Data in the application and documented defects using the defects.
• Checked the reports for any naming inconsistencies and to improve user readability.
• Used Mercury Quality Center for Test management - Bug Tracking, Logging defects, Reporting, and Analysis.

Environment: Informatica Power Center 8.6, ERwin 3.0, Flat Files, Oracle 9i, Squirrel SQL 2.5, MS Office 2003, Mercury Quality Center, PL/SQL, Win Runner, UNIX Scripting, WinSCP, TFS and Windows 2000.

Confidential

Data Warehouse Developer

This project is aimed at developing a single, structured and integrated Data Warehouse for Nestle Information Systems NIS , giving robust and standardized reports. Data is extracted from various OLTP systems like billing, order and provisioning etc. The data from the OLTP systems is extracted and loaded into staging tables first and after processing of these raw data, they are inserted into the target database tables.

• Experience in Data transfer from OLTP systems forming the extracted sources.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Analyzed the sources, transformed the data, mapped the data and loaded the data into targets using Power Center Designer.
• Participated in the design of Star schema data model.
• Worked on Informatica Utilities Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Worked with various transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner transformations.
• Created daily and weekly workflows and scheduled to run based on business needs.
• Designed and Developed Oracle PL/SQL Procedures, Shell Scripts for Data Import/Export, Data Conversions and Data Cleansing.
• Created Shell Scripts to automate Pre-Session and Post-Session Processes.
• Developed Sessions and Batches to schedule the loads at required frequency using Power Center Server Manager.
• Actively participated in Unit Testing, Integration Testing, and System Testing

Environment: Informatica Power Mart 5.1, Oracle 8i, PL/SQL, TOAD for Oracle 7.3, UNIX and Windows NT.