SUMMARY

• 7+ years of IT experience in the Analysis, Design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Experienced DWH and BI Tester/QA Analyst with strong background in design, development, and support of databases and information products as well as data analysis / reporting / Testing.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Experienced in Functional testing, System testing, Application testing, Performance testing, Integration testing, Regression testing, Black Box testing, Stress Testing, Smoke testing, Recovery testing, Reports testing, browser compatibility testing, UAT and GUI testing.
• Experience in end - to-end ETL process including Data Extraction, Transformation and Loading from source systems.
• Proficient in validating Source to Target mapping documents including the transformation rules.
• Good skills and understanding of SQA methodologies and practice
• Effectively manage multiple work assignments and priorities.
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back-end testing.
• Experience in SQL and PL/SQL scripting.
• Expertise in EDI transactions used inhealthcareindustry and good knowledge ofHIPAA X12.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting and AutoSys.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica.
• Well-versed using UNIX commands for shell scripting.
• Execute batch processing and verify the jobs status and data in database tables.
• Extensively used ETL methodology for supporting data extraction, transformations and loading, in a corporate-wide-ETL Solution using Data Stage andInformatica.
• Expertise in testing complex Business rules by creating mapping and various transformations using Informatica.
• Archived and retired several applications using Informatica ILM and DVO to archive the data and backload into the data warehouse.
• Worked with wide variety of sources like Relational Databases, Flat Files, Teradata, Netezzaand DB2.
• Worked with HP Quality Center and Clear Quest for Test Management and defect tracking.
• Good experience in testing SOA & web services project.
• Excellent experience in developing Business Intelligence Applications using Business Objects and Crystal Reports.
• Extensive experience in manual testing the ETL and Business Intelligence Applications.
• Developing and Delivering System Documentation and UAT Test scripts and auditing documentation for maintaining ITIL.
• Excellent problem solving, interpersonal, and communication skills.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x/7.x, Data Stage 7.5, Ab Initio GDE>C0-op 3.0.2

Testing Tools: Quality Center, ALM 11.0,Load Runner, QTP, Win Runner, Manual Testing

Database: Oracle 8i/9i/10g, SQL Server 2000/2005, MySQL, ODBC, DB2, TOAD 8.5, MS Access, Teradata V2R5/V2R6,Netezza

Reporting Tools: Business Objects 5.1/XIR2, Cognos 10.x, 8.0, Microstrategy 9.x

Operating Systems: Window 2003 Server, Windows 2000 Advanced Server, Windows 98, Windows XP, Linux and UNIX(AIX).

Version control: Visual Source safe, WINCVS,PVC

Languages: XML, SQL, UNIX Shell Scripting, PL SQL.

SDLC/STLC: Agile, Scrum, Waterfall, V model.

PROFESSIONAL EXPERIENCE

Confidential, Rancho Cucamonga, CA

Sr. ETL/Backend Tester

Responsibilities:

• Analyzed Business Requirement Document, Software Design Document, Software Requirement Specification and Functional Requirement Document.
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing.
• Created and maintained requirements traceability matrix (RTM) to ensure that all requirements are traceable from top to bottom and to provide a basis for test plan.
• Tested the ETL Informatica mappings and other ETL Processes (DW Testing).
• Extensively written SQL to confirm the data transfer from source to target.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Involved in User Acceptance Testing, GUI Testing, and Regression testing, on different versions of the application.
• Involved in System Integration Testing with external/Internal interface and understood overall customer business functionalities.
• Tested all the 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 in closing the defects by coordinating with the dev team.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• 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 co-ordinated with integration testing and regression testing.
• Worked with the team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
• Prepared test data to cover all the test scenarios.
• Prepared UNIX scripts to run the informatica ETL jobs from command line.
• Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.
• Tested the migration of reports from Business objects XIR2 to XIR3.

Environment: Informatica 9.1, Quality Center(QC)10.0/ALM11.0,Teradata,V2R6,VB script, SQLQTP 9.2 TOAD, Microsoft Visio, MS Access, Windows XP/2003/2007, Oracle 10gSOAP UI, Autosys jobs, Business Objects

Confidential, Foster City, CA

Sr. Backend Tester

Responsibilities:

• Tested all the ETL processes built for fetching various source data into datawarehouse.
• Performed data validations on the loaded data by comparing against source data through complex SQL queries.
• Prepared test data files in UNIX box for testing purpose.
• Tested the all the transformation as per the source to target mapping document.
• Tested the UNIX scripts that were developed for moving the used source files into archive location.
• Tested the reports generated from the data warehouse according to the requirement specifications.
• Compared the data in the reports against the data warehouse using SQL.
• Tested the format of the report and compared against the model provided in the requirements specification.
• Prepared Test Cases for the mappings developed through the ETL Informatica tool and executed those Test Cases.
• Participated in unit testing and verified entrance criteria of QA and set up configuration data with developer and updated release notes.
• Performed sanity testing using post installation check using release notes and identified installation or code initial problems.
• Used the Informatica monitor to schedule the jobs, validating and debugging its components, and monitoring the resulting executable versions.
• Communicated with Project Management to establish LOE of each phase of SDLC and prioritized QA task.
• Developed SQL Script to validate Data Transaction in Front End Testing. Developed complicated and execute via Toad and saved Test Result.
• Delegated work to offshore team and helped them understand the requirements and changes happening in the code.
• Written test strategy and all the important test scenarios to be covered and shared across the QA team.
• Written test cases and maintained them in HP Quality Center.
• Raised defects and tracked them to closure by coordinating with dev team.

Environment: HP Quality Center 10, Oracle 10g, TOAD 10.6, Informatica 8.X, Cognos 8.4, SQL Server 2008R2, SQL server Management Studio, UNIX, Shell scripting

Confidential, MN

QA/DWH ETL Tester

Responsibilities:

• Developed unit test cases, configured environments and prepared test data for testing.
• Guided a team of five members, and experience in dealing with ONSITE-OFFSHORE model
• Wrote PL/SQL /Complex SQL queries for system testing.
• Worked with Business analysis team to prepare a detailed Business Requirement documents.
• Involved in scheduling and monitor the workflows using Datastage Director.
• Involved in writing & implementation of the test plan, various test cases & test scripts.
• Performed Functionality, Stress, Security, and GUI & REGRESSION testing of web-based applications.
• Wrote SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Experience in integration of various data sources with Multiple Relational Databases likeOracle, SQL Server, MS Excel, MS Access and Flat Files.
• Performed front-end testing on OBIEE Executive Dashboard portal
• Interacted with Users to understand the bugs in Business Reports generated from OBIEE
• Tested all OBIEE Dashboards according to the requirement
• Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
• Identifying field and data defects with required information in datastage ETL process in various jobs and one to one mapping.
• Validated the archived jobs using DVO (data validation tool).
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Written several Stored Procedures and modified existing stored procedures.
• Extensively executed SQL queries in order to view successful transactions of data and for validating data.
• Extensively used Informatica tool to extract, transform and load the data from Oracle to DB2.
• Worked on projects independently and also managed a Facets testing effort.
• Involved in testing HIPAA EDI Transactions and mainly focused on PA and Eligibility Transactions.
• Involved in analysis Health Care Claim Acknowledgement for HIPAA Version 4010.
• Involved in testing HIPAA EDI Transactions.
• Transactions focused on 837/997,835,270/271,276/277.
• Tested the Members, Claims, Providers and Services in Facets.
• Worked on DVO data validation tool to validate the data accurately.
• Developed Test Plans, Test Cases, and Test Scripts for UAT tests.
• Created checkpoints and synchronization points for functional testing using Quick Test Pro (QTP)
• Writing complex SQL and PL/SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle. Validated all the web services by testing the WSDLs using SOAP UI.
• Experience in data analysis and data testing. And verified fields present in the reports are as agreed in the ETL specifications.
• Extensively involved with backend testing by writing complex SQL queries.
• Worked closely with the development teams to replicate end user issues.

Environment: Informatica 9.x, Oracle 10g/9i, SQL Server 2000, SQL, PL/SQL, Stored Procedures, HTML, Quick Test Pro 8.0, Quality Center 8.2, Points Portal, Informatica Data Validation Option DVO 9.5,QTP,Autosys, OBIEE, MS Office Suite, Rational Clear Quest, FACETS 4.x, Clear Case, RUP, TOAD, Requisite Pro, Test Manager, Automation/Manual Testing, UNIX.

Confidential, Springfield, NJ

QA Analyst

Responsibilities:

• Involved in analyzing requirement, design and mapping documents.
• Created SQL, PL/SQL scripts using TOAD for Oracle 9.1 for source and target databases.
• Involved reviewing test scripts and providing feedback.
• Involved in clarifying the questions on transformations for offshore and onsite team.
• Prepared Data Migration test and System test plan by conducting requirements analysis.
• Analyzed Data Migration requirements based on UI mapping document and source to target documents.
• Communicated with Development team on business logic and migration logic queries.
• Worked with team members in understanding the business logic and writing queries.
• Analyzed test results (Query results) and communicated critical defects with development team.
• Performed Data Validation for the data flow from front end to back end.
• Performed Japanese Data Validation from PERCEIVE database to MARRS ARGUS database.
• Involved in Data Analysis in the ETL process and Contribute to the analysis of data requirements and data migration.
• Performed Web Service Testing using SoapUI.
• Developed test scripts for Functional, Regression and data driven tests.
• Performed regression testing by repeated execution of test cases in each build and verified the fixation of bugs and reported any new bugs that arose using the defect-tracking tool, Mercury Quality Center.
• Prepared the test automation documentation for the future reference.
• Created requirements and test cases for each project in Requirements and Test Plan modules respectively using Mercury Quality Center.
• Executed test cases in Test Lab Module using Mercury Quality Center.
• Logged defects and tracked defects till the closure in Defects module.
• Produced reports (Test execution report and Bug status report) using Analysis Graphs on weekly basis.
• Prepared reports like test activities, test execution graphs and bugs list from QC for weekly status meetings.

Environment: Quality Center 10.0, Agile, Java, .NET, XML, HTML, Windows and Unix, Shell Scripting, SQL, PL/SQL, TOAD for Oracle 9.1, Oracle 10g, MS Office, COGNOS.

Confidential, Atlanta, GA

Back end/ WebTester

Responsibilities:

• Worked with the end users and gathered information for designing the specifications.
• Performed the data analysis and data mapping and designed and documented the conversion documents.
• Supported go-live and post-go-live, which included code/process tracing for debugging and performance tuning.
• Participated in developing the file management and ftp process for transmitting the files, also scheduled the daily batch process.
• Worked on issues with migration from development to testing.
• Performed Regression testing/system integration/integration testing/ System Integration testing/ Smoke testing.
• UsedTestDirector for bug tracking and reporting, alsofollowed up with development team to verify bug fixes, and update bug status.
• Manually ran the test scripts in Test Director and documented the results.

Environment: Oracle 8i, TOAD, SQL, PL/SQL, Cognos, SQL Server 2000, SQL Navigator, Test Director, Windows, UNIX AIX