SUMMARY

• Over 12+ years of experience in Extracting, Transforming and Loading of Data, Tracking Efficiency and Speed of Data, Expertise in writing SQL queries and carrying out different type of tests Primary Key, defaults and keep a check on the other functionality of the process, fully proficient in carrying out quality check as Quality Assurance Analyst. Expert in analyzing, Validation, Planning & Designing and Execution of the test. Very professional in Report Generation.
• Very professional in gathering business requirement and Verification of Data
• Expert in Data ware housing and Data Mining
• Fully conversant in defining various types of Facts such as Additive, Semi - additive & Non-additive Facts.
• Good in conducting Cubes & OLAP.
• Very professional in debugging process. (Calculation Bug, User Interface Bug, Source Bugs, Load condition bug, ECP related bug etc..)
• Proficient in Manual/Automation Testing of Client/Server and Web based applications using Mercury Interactive Test Suite-Test Director, Win Runner, Quick Test Pro and Load Runner.
• Experience in business analytics and optimization, data management and integration, enterprise data warehouse management (EDW), data warehousing and business intelligence domain and master data management concepts.
• Responsible for managing ETL delivery, estimation, solutioning and design, providing technical leadership and expertise in managing enterprise data warehouses.
• Sound knowledge of data warehousing tools and technologies involving Informatica Powercenter, Data Quality (IDQ), Master data management, Teradata, Oracle, SQL Server 2000 and 2005, DTS and SSIS and agile delivery concepts.
• Extensive experience with analysis, design, development, customizations and implementation of large scale data warehousing projects focusing primarily on master data management, data integration, extraction, transformation and loading (ETL) concepts and SQL. Proficient in analyzing and translating business requirements to technical requirements and architecture. Actively involved in client facing lead roles, ETL architecture and solutioning and project implementation.
• Executed software projects for Automotive, Healthcare Insurance and FMCG (Fast moving Consumer Goods) industries
• Domain competency includes Healthcare, Finance, Mortgage and Insurance sectors.
• Experience leading teams on various projects including Onsite and Offshore teams.
• Expertise in writing Test Plans, Test Strategies, Test Cases, Test Scripts, Test Scenarios, Test Reports and Defect Metrics.
• Involved in various stages of Software Development Life Cycle (SDLC) implementing Waterfall, V-Model and Agile methodologies.
• Strong understanding of QA Principles, QA Process, Use Cases, and Software Development Life Cycle.
• Extensive experience in developing Test Procedures and Test Strategy for Web and Client/Server applications.
• Sound knowledge of Black Box, White Box, System, Regression, Integration, Functionality and User Acceptance Testing.
• Experience in testing on enterprise wide applications with multiple databases.
• Proven experience with the development, and implementation of large-scale, enterprise data warehouse and reporting solutions.
• Extensive experience in HP Test Suite, Rational Clear Quest, Clear case and Remedy.
• Good Knowledge of ETL tools like Informatica 9.1 / 8.6.1/7.1.2 , Data Stage, SSIS.
• Experience in Business Intelligence in generating various reports using business Intelligence tools like Cognos 10 / 8, SAS, SSRS, Micro strategy, Business Objects XI R2/XI/6.5.
• Interacted with the developers on various technical issues and resolved the reported bugs.
• Excellent understanding of the Software Development Life Cycle and role of QA.
• Extensive experience performing ETL/Data warehouse and database testing.
• Worked with all stages of testing namely Integration Testing, System Testing and User Acceptance testing manually as well as using automated test tools.
• Back-end testing using SQL, PL-SQL, Unix.
• Conducted review sessions with the Business Analysts and Subject Matter Experts to understand the systems, process and impacts.
• Set up best practices across projects for QA.
• Created Center Of Excellence for QA on multiple projects.
• Well versed in testing Methodologies, Web testing, and software Deployment/Release processes.
• Very Strong skills, including the use of nested table expressions, unions, Multi-table joins and outer joins.
• Experience facilitating meetings, war room sessions with Users during UAT.
• Supported the defect resolution process by prioritizing the severity level of defects.
• Assisted managements in Talent Acquisition and Resource Management.
• Self-Motivated, Team Oriented with ability to handle multiple tasks and efficient in meeting deadlines.
• Possess excellent communication skills along with verbal and written skills.

TECHNICAL SKILLS

Operating Systems: Windows 2003/2000/XP, UX-HP, Solaris, MS DOS

Internet: ASP, HTML DHTML, XML, Web Services

Business Modeling Tools: Rational Rose, MS Visio

Languages: C#, C++, C, VB.Net, VBScript, JavaScript, VB 5/VB 6, SQL, PL/SQL, T-SQL, Teradata BTEQ

Testing Tools: QTP8.x/9.2/9.5/10, ALM, Quality center 10.0/9.2/8.2 , WinRunner 7.5/7.0/6.0, LoadRunner9.0/8.x, Test Director, Cognos Decision Stream, Oracle Warehouse Builder, Business Objects XI, SAS business warehouse, SAS Enterprise ETL server

Office Tools: MS Office, MS Project

Databases: MS SQL Server 2000, Oracle 8i/9i, TeradataV2R6/R5, DB2, Sybase

ETL/ Reporting Tools: Informatica, Datastage, Ab Initio, Crystal Reports, SSIS, SSRS, Teradata, IDQ, Cubes OLAP

Configuration Management: MS Visual Source Safe, SOS, Clear Case, Share Point Portal, Doors, Rational Test Manager

Technical Domain: Data warehousing & Business Intelligence, Enterprise Data warehouse

RDBMS: Teradata, Oracle 8i, 9i, 10g, SQL Server 2000 and 2005, DB2

Concepts: Data analysis, Master data management, data profiling, Agile Concepts

Industry Worked: Automotive, FMCG, Consumers Products and Many more…

PROFESSIONAL EXPERIENCE

Confidential - NY

ETL Test Lead/Test Manager

Responsibilities:

• Requirement gathering and onsite coordination with MDM team to design ETL architecture.
• Provide technical leadership and ETL Informatica expertise in implementing the ETL solution for VW Master Data Management Implementation.
• Design of ETL technical architecture for data extraction and feed to MDM Batch process.
• Design of error handling techniques to process MDM and ETL errors for further reprocessing.
• Development of functional and technical specification to implement the ETL solution.
• Development, unit testing and implementation of the ETL module.
• Interacting with the client regarding requirement gathering and providing status updates.
• ETL Performance tuning
• Leveraging Informatica Data Quality tools (IDQ) in data profiling, address validation and stand-ardization and integrating IDQ data quality rules into Powercenter.

Confidential

Responsibilities:

• Design and develop ETLs to extract data from the different source system and align them to the Standard Interface format for input to MDM.
• Design and develop ETLs for Data Quality management (DQM) reports
• Prioritized activities for the QA Team.
• Setup Testing Suite for the project.
• Create and maintain folder structure in ALM (Application Lifecycle Management).
• Defined best practices and acted as the lead for QA Center of excellence.
• Responsible for talent acquisition and resource management on the QA team
• Created Test Plan and Test Strategy documents for the project.
• Created and socialized various artifacts to help the other teams on the project.
• Responsible for training the project team and Users on required tools.
• Worked with the Subject Matter Experts to understand and analyze impacts of various data acquisitions.
• Responsible for reviewing Use cases with the Business Analysts and align the test scenarios accordingly.
• Responsible for reviewing Test Cases prepared by the QA team.
• Created the reporting module in ALM to reflect test progress, defect tracking etc.
• Reviewed test scripts (SQL) and assisted the team on test script tuning.
• Co-ordinated the onsite and offshore teams handshakes on day to day activities.
• Conducted Defect Triage calls to review and track down defects for each release.
• Responsible for leading efforts on UAT and to coordinate between the Users and the Design / Development teams on issues during UAT.
• Worked with the project teams on process improvements.
• Responsible for reporting status of various testing activities to the Management.
• Responsible for creating and maintaining the QA SharePoint for the project.
• Facilitate QA meetings with the business and source owners to mitigate risks and resolve issues.
• Organize daily triage calls with the testing team and the development teams to facilitate progress review, defect discussion and issue resolutions.
• Facilitated UAT readiness meetings and Production readiness meeting to mitigate issues and outline defect deferral process to facilitate progress.
• Provided Testing sign off documents for various deployments on the project on an as needed basis.

Environment: Informatica 9.1, SSIS, Teradata TD 12, SQL Server 2008, Cognos 10, Flat Files, Teradata SQL Assistant, TOAD, SQL, PL/SQL, HP Application Lifecycle Management ( ALM 11 ), QTP, UNIX, Microsoft Office Suite 2010, Windows 7, MS Outlook.

Confidential, Austin, TX

Data warehouse/ETL Test Lead

Responsibilities:

• Created Test Plan and Test Strategy documents for various projects..
• Worked with the business analyst to understand the requirements.
• Writing use cases and verifying them with the project team.
• Responsible for designing test scenarios for the project based on the requirements and use cases.
• Involved in base lining Test Scenarios, Test Cases and Test Scripts.
• Responsible for maintaining Test Reports and Defect Metrics.
• Developed and validated SQL scripts for both ETL and CUBE testing.
• Validated the Fact and Dimension relationship in the data warehouse.
• Designed and tested the slowly changing dimensions based on the ETL Specs.
• Conducted peer reviews with the offshore testing team to finalize the test cases, test scripts for ETL and Cube validations.
• Conducted sessions with the Development team to verify any additional testing scenarios required based on the ETL specs.
• Responsible for creating projects in Quality Center / ALM and maintaining project folders and structures.
• Used Quality Center/ ALM to load the test cases, track execution against the plan during the testing phase.
• Responsible for tracking defects in QC / ALM from validating the defect, assigning the defects to the development team and closing the defect after successful retesting.
• Verified Test cases scripts based on the functional specifications and maintained traceability with the requirements.
• Validated SSIS reports after ETL and Cube deployments to make sure the values in the database tie out to the reports.
• Responsible for maintaining repository for testing activities for future use.
• Interact with the users to walk them through the functionality of the reports that they request before UAT.
• Conduct war room sessions with the users for UAT.
• Co-ordinate the UAT efforts between the Business and Development teams for efficient defect tracking and closure.
• Conducted daily status calls during IT and UAT for test execution and defect tracking.
• Responsible for maintaining the QA SharePoint for projects.
• Conducted knowledge transfer sessions for new hires and get them to speed on the projects.
• Communicate testing activities to the project teams and high level management on a daily basis including the test execution progress, defect summary and burn down charts.
• Responsible for setting up databases for the QA environment and working with DBA’s to assign proper privileges for the testing team for testing.
• Performed debugging on stored procedures that fetch the data into the reports.
• Attended daily status meetings for Data quality issues and also technical review meetings.

Environment: Informatica 8.6.1 / 9.1, Informatica MDM, SQL Server, Teradata, SAP MM, SAP HR, SAP BW, SAS Reporting, SSIS, SSRS, TOAD, SQL, PL/SQL, HP Quality Center 10.0 / HP Application Lifecycle Management ( ALM ), QTP, Clear case, TFS, UNIX, Microsoft Office Suite 2010, Windows XP, MS Outlook.

Confidential, McLean, VA

Data warehouse/ETL Test Lead

Responsibilities:

• Worked as a System Analyst and a Data warehouse/ ETL tester.
• Worked with the business teams to understand and interpret the project requirements.
• Involved in writing Test Plan and Test Strategy for the project and getting signoffs from the relevant project members.
• Monitored the Test Scenario Creation, assisted in the Test Case and Test Script development.
• Developed SQL scripts and used Rapid Sql query tool to run the SQL scripts from Sybase and SQL Server databases.
• Monitored the activities in Quality Center including executing the test cases, track execution against the plan during testing and managing defects from inception to resolution.
• Created Test cases scripts from the functional specifications and maintained traceability with the requirements.
• Created SQL queries to fetch data and validate application against the database
• Performed functional, performance, regression and black-box testing on the payment and billing applications.
• Creating the test batch data file by FTP thru UNIX.
• Created Test execution, Defect Metrics for daily status meetings
• Validated XML files for the web services triggered by the Java based application (OUS).
• Tested reports developed using Business Objects and Crystal Reports.
• Tested web intelligence reports developed from BO Universe.
• Verified the BO reports as per the UAT document.
• Validated data between different web applications and documented the test results.
• Communicate testing activities and findings in oral and written formats.
• Ran Sql queries to check if the data is loaded correctly into the database for the backend testing.
• Responsible for maintaining RTM in DOORS.
• Trained end users on the new application and conducted knowledge transfer sessions on the project.
• Attended daily status meetings for Data quality issues and technical review meetings.

Environment: Sybase, SQL Server, Teradata V2R6, Java, .Net, Informatica 8.6.1, BO XI 3.0,Embarcadero’s Rapid SQL, XML, Lotus Notes 7.1.1, Clear case, Clear quest, UNIX, MS Excel 2007, MS word 2007, Windows XP, Unix, Quality Center 9.2, QTP 10/9.5, SOAPUI, IBM DOORS.

Confidential, McLean, VA

Senior Data warehouse/ETL Tester

Responsibilities:

• Worked as a Data warehouse / ETL tester.
• Worked with the business team to gather requirements.
• Used TOAD SQL browser to write SQL queries for validating constraints, indexes.
• Used TOAD schema browser to check the characteristics of the schema objects(tables, synonyms etc)
• Performed Positive testing, Negative testing, Functional testing, Navigational testing, System Testing and Regression Testing in different phases
• 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.
• Extensively worked on understanding the business requirements and designing BO applications.
• Tested reports developed using Business Objects and Crystal Reports.
• Tested web intelligence reports developed from BO Universe.
• Performed quality control analysis and validates results of conversion programs. Used extensive SQL query. Evaluated actual data load results. Involved with high volume testing.
• Developed SQL scripts and used Rapidsql query tool to run the SQL scripts from Sybase and DB2 databases.
• Performed Functional testing, System testing, Smoke testing, Regression testing and UAT.
• Documented the test results.
• Verified the BO reports as per the requirements document.
• Created and modified UNIX shell scripts
• Communicate testing activities and findings in oral and written formats.
• Ran Sql queries to check if the data is loaded correctly into the database.
• Responsible for maintaining RTM in DOORS.
• Used Quality Center for executing the test cases and defects tracking.
• Created the Naming conventions document and documented management plan.
• Attended daily status meetings for Data quality issues and technical review meetings.

Environment: Quality Center 9.2, Sybase, DB2, Rapid SQL, Data stage, BO XI R2, XML, Lotus Notes 7.1.1, Clear case, Clear quest, UNIX, MS Excel, MS word, Windows XP, Unix and DOORS.

Confidential, IL

Data warehouse/ETL Tester

Responsibilities:

• Wrote Test Plans and Test Cases pertaining to data validation and integrity testing for data loading, data validation and integrity check testing.
• Wrote test cases and executed them on the Billing System.
• Developed a detailed Test Plan for the testing effort of the User Interface
• Involved in requirement analysis
• Performed security testing manually and writing sql queries against the database
• Maintained requirement traceability matrix.
• Extensively used Mercury Quality Center (TEST DIRECTOR) and Created Test Cases in the TEST PLAN according to the specifications.
• Used TEST LAB to run the Test cases.
• Reported Defects and prioritized outstanding defects using Test Director/Quality Center.
• Ran the Informatica ETL Sessions for Claims in different stages Source to Stage & Staging to Data mart and Data mart to Business Objects and BO to Dashboard using Informatica Server Manager
• Maintain Object repository
• Created TSL Scripts files as per the test plan requirements.
• Tracked the defects in Test Director.
• Validated data feed into the data warehouse for DWH implementation and also tested front end application where massaged data was presented in report formats.
• Involved in Integration testing, UI, User Acceptance Test (UAT), Functionality testing & Performance testing.
• Performed database testing to verify the rates as per the large accounts
• Executed SQL Queries to verify the dataflow from the backend
• Involved in validating the reports, both Data and their layouts
• Bug reporting, tracking and documentation on the Bug tracking System using Test Director
• Weekly Status meeting with Development and Management teams to discuss bugs and other issues.

Environment: Test Director 7.2, QTP 8.2, Flat files, Informatica 7.1, SQL Loader, Oracle 8i/9i, TOAD, UNIX, Windows

Confidential 

BI Architect/Data Modeler

Responsibilities:

• Working closely with the business to architect the data model and develop the data model for a high performance data integration
• Worked on Integrating the complex organization source systems to Oracle/SQL server using Informatica Power Center
• Created Power BI reports for the Users and Trained users on how to create vizualizations
• Created Power BI apps and set up the workspaces for a collaborative work in each business arena
• Re-written the COGNOS cubes to the power BI reports and architected the solution for the same
• Working with the Informatica PowerCenter Client tools to create complex Transformations, mappings and workflows and schedule them accordingly
• Duties include coordination, attending meetings, and the review of requirements,task assignments and code reviews
• Developed data mapping spreadsheet/specification to present the transformation process
• As a technology lead responsible for the deliveries and time management of 4 resources under me
• Developed Data Models/ ETL Specification documents, Unit test documents and mapping documents to implement the extract, transform and load the data using Informatica transformations.

Environment: Microsoft Power BI, Informatica PowerCenter 9.5.1,TOAD for Oracle, Oracle 11g/12c, SQL Server,Flat files, DB2 Windows 7