SUMMARY

• I have over 6+ years of diverse experience in Information Technology with an emphasis on Software Quality Assurance in industries like Healthcare, Banking, and Finance. My ambition is to take up a challenging position in the area of Software Quality Assurance and Testing in a progressive, fast - paced dynamic environment that will allow me to align my skills in the organization in the most efficient manner.
• Over 6+ years of Experience in Data warehousing Analyst, Quality Assurance and 5+ years of ETL/BI testing experience with extensive backend testing Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
• Extensive experience in testing of Financial, Healthcare, Banking and Telecommunication clients.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application.
• Experience in developing the Manual Test Suites and Automated test suites.
• Expertise in QA process and different levels of testing like unit, Functional, Regression, and Integration testing with business scenarios.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in testing and writing SQL and PL/SQL statements.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Strong experience in testing tools like Test Director, Quality Center & RQM and RTC
• Expertise in writing SQL and PL/SQL statements.
• Good expertise in using TOAD, SQL Developer and SQL Management Studio.
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements.
• Experience in all aspects of project development life cycle.
• Expert level skills in testing Enterprise Data Warehouses using Informatica Power Center, Data Stage, Ab Initio and SSIS ETL tools.
• Experience in debugging the issues.
• Proficient in working with UNIX shell scripts putty Environment.
• Involved in jobs scheduling, monitoring and application support in a 24/7 environment.
• Excellent communication skills and Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
• Application Data warehousing experience in Banking, Financial, HealthCare, Retail and Consumer.

PROFESSIONAL EXPERIENCE

Confidential, Spark, MD

Sr. ETL Tester/ Quality Analyst

Responsibilities:

• Involved in gathering business scope and technical requirements.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Involved in developing detailed test plan, test cases and test script for Functional and Regression Testing.
• Interacted with Management to identify key Dimensions and Measures for business performance.
• Completed Data Migration test cases as well as web based test scripts.
• SQL queries were written to verify the data in both source and target schemas to validate the data migration.
• Mapping Data Items from Source System to the Target System.
• Validate SSRS Report.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SSIS/ Informatica to move data to the warehouse using the stored Procedure thereby enabling faster moment of data.
• Validating the Target data based on the test cases.
• Preparing the process flow diagram for ETL Jobs.
• Validated all the applications and successfully executed and unit tested the jobs with RQM.
• Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD
• Tested T-SQL queries scripts to validate the data and performance of the database.
• Validate the reports by running SQL Queries against the source system(s).
• Compare the new reports to the original requirements for complete functionality.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Created ETL execution scripts for automating jobs.
• Creation of jobs sequences and job schedules to automate the ETL process.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.
• Environment: Informatica, ORACLE, RTC, TERADATA, SQL/PLSQL, TOAD, SSRS 2012

Confidential, Richardson, TX

ETL tester/ Quality Analyst

Responsibilities:

• Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Tested the entire compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Tested different reports including detail, summary reports and on demand reports developed by SSRS Report Studio.
• Extensively worked on designing various output and management reports Using SQL Server Reporting Services (SSRS)
• Tested the XMLs feeds received from another source, which is a third party for data consistency.
• Tested the ETL with XML as source and tables in the data warehouse as target.
• Monitored the UNIX andSybaseservers and collect Performance Testing Metrics.
• Tracked defects to closure by coordinating with the dev team.
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Conducted and coordinated integration testing and regression testing.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Maintained the entire test cases in HP Quality Center and logged all the defects into the defects module.
• Provided the management with weekly QA documents like Test metrics, Daily status reports, Test schedules and Test Exit Report.
• Environment: Oracle 9i, SQL Developer, SQL Server 2008, TOAD, Ab Initio 2.13, HP Quality Center 9.2, UNIX, Putty, Session log files, Flat files, XML files, Remedy, Snagit, Compare IT, MS Office etc

Confidential, WI

Sr. ETL Quality Assurance Analyst- EDI Transactions

Responsibilities:

• Worked on Agile SDLC approach implementation for the whole testing life cycle.
• Reviewed Functional requirements documents, High level design requirement documents and finalize the testing in scoops and scenarios for Integration testing for each project.
• Gathered requirements and created, executed and documented Test Cases as per requirements in Quality Center.
• Tested HIPAA EDI Transactions and Code Sets Standards such as 837/835 and 834 transactions.
• Interacted with the team member to ensure meaningful development of the scripts and simulated real time business scenarios.
• Maintained QA lab standards, documentation review assisted in establishing and maintaining best practices for QA.
• Acting as liaison between end user and Facets for user problems, outstanding issues, training needs and new software releases.
• Maintaining knowledge of Medicare and Medicaid rules and regulations pertaining to the Xcelys configuration and evaluating the impact of proposed changes in rules and regulations.
• Created test scripts for Security, Positive, Negative and System Integration Testing (SIT).
• Worked with team manager in supervising, guiding, and supporting their testing efforts for Integration.
• Worked with Claims, enrollment, eligibility verification for members and providers and benefits setup.
• Experienced with batch processing system for claims electronic and manual transaction.
• Well known with frontend processing for the Claims, Subscriber/Family and with Providers.
• Experienced with External claim editing system on frontend system of Xcelys6.3.
• Responsible for writing the Test Cases and Test Scenarios based on the Functional Specification and technical Specification and documented in Mercury Quality Center.
• Executed test cases for the existing market’s various lines of business. (The test cases covered: Authorization of claims, Accumulator, Benefits, Claim Payment and Pricing, as well as member and provider data updates)
• Created transactions in the Mainframe and verified them in the web and vice versa.
• Worked on Quality Center for bug status tracking and maintained and created status reports for the application.
• Involved in weekly defect review meetings to review the status of defect fixes and upcoming build releases.
• Used Quality Center for version control, tracking defects, enhancement requests, assign work activities, and assess the real status of project throughout the life cycle.
• Identifying Test Cases to be run for Regression Testing and conducting Regression testing as and when new builds were made.
• Documented the test execution summary results and reported the status of assigned test tasks and issues to project manager for approvals.
• Environment: Informatica 8.6.1/8.1, Xcelys 6.3, ORACLE 10g, HP ALM/Quality Center 11, SQL/PLSQL, Business Objects XIR2, QTP, TOAD, XML, Korn Shell Scripts, UNIX, Windows XP

Confidential, St. Petersburg, Florida

Sr. ETL Tester- Morgan-Keegan migration project

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 10.0
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Extracted Data using AB- Inito Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• 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.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Tested the ETL Ab- initio Jobs and other ETL Processes (Data Warehouse Testing)
• Written several complex SQL queries for validating Cognos Reports.
• Tested several stored procedures.
• Involved in the error checking and testing of the ETL procedures and programs Ab-initio session log.
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server based data warehouse.
• Worked with business team to test the reports developed in Cognos
• Tested whether the reports developed in Cognos are as per company standards.
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Environment: Ab Initio BRE, DB2, Java, Cognos, SQL, XML, IBM AIX 5.5, UNIX, Shell Scripting, WINSQL, Ultra Edit, HP Quality Center 10.0

Confidential

Quality Analyst / ETL tester

Responsibilities:

• Gathered business scope and technical requirements
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Mapping Data Items from Source System to the Target System.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Writing Jill file for Auto sys daily schedules.
• Validating the Target data based on the test cases.
• Involved in Oracle SQL Development, Unit Testing and Performance Tuning
• Involved in creating both positive and negative test data to cover all business scenarios
• Involved in developing detailed test plan, test cases and test scripts for Functional, Security and
• Environment: Windows, SQL Server 2000, Microsoft Visio 2003, MS Access, Flat Files.