PROFESSIONAL SUMMARY:

• 5+ years progressive expertise in analyzing the requirements, application development, testing and a comprehensive background in Database development and Data warehousing.
• 5 years of ETL Informatica testing. Also coordinated testing effort with the project team.
• Strong experience in entire life cycle of Data warehouse/Data mart using Informatica Power Center (Designer, Repository manager, Workflow manager and workflow monitor).
• Experience in testing the applications using automated tools like Test Director, HP Quality Center, and Quick Test Professional, Win Runner.
• Strong technical exposure with good degree of competence in domains such as Financial, Healthcare and Retail.
• Implementation of Data warehouse and strong understanding of Data warehouse concepts, Data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, Physical & logical data modeling, Star Schema, Snow schema.
• Experience in working with various heterogeneous databases which include Oracle, Mainframe DB2, Sybase and Flat files.
• Performed all dimensions of development including Extraction, Transformation and Loading data from various sources into Data Warehouses and Data Marts using Power Center (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Good programming experience in Unix Shell Scripting, SQL, PL/SQL, complex Stored Procedures, Triggers.
• Test case preparation using HP Quality Center.
• Hosting weekly bug review meetings and setting expectations for QA Methodology execution within a newly adopted software process flow.
• Good expertise in documentation of test results and designing DDS documents.
• Experience in OBIEE DAC 10g Client for scheduling the tasks, and unit testing the ordered tasks.
• Experience in performance tuning of sources, mappings, targets and sessions.
• Strong knowledge of Software Development Life Cycle (SDLC) including requirement analysis, design, development, testing, and implementation. Provided End User Training and Support.

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: QTP, 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

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

PROFESSIONAL EXPERIENCE:

Confidential, NY

ETL Test Lead/Test Manager

• 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, Eden Prairie, MN

ETL Test Lead/Test Manager

Responsibilities:

• 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, Cranston, RI/Medford, MA

ETL Test Lead/Test Manager

Responsibilities:

• Initiated the Test Activity Planning and Test Resource Management on the project.
• Created Test Plan and Test Strategy documents for the project.
• Worked with the SMEs of various source systems to understand the project requirements.
• Involved in the creation of use cases and verifying them with the project team.
• Worked with the onsite and offshore testing teams to identify gaps and resolve them to closure.
• 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 DataMart testing.
• 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.
• Facilitate 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.
• Attended daily status meetings for Data quality issues and also technical review meetings.
• Schedule UAT readiness meetings and Production readiness meeting to mitigate issues and outline defect deferral process to facilitate progress.

Environment: Data Stage 8.5 / 9.1, Teradata, SQL Server 2008 / 2010, MDM, Informix, Flat Files, XML Files, SAS, Teradata SQL Assistant, TOAD, SQL, PL/SQL, HP Application Lifecycle Management ( ALM ), QTP, UNIX, Microsoft Office Suite 2010, Windows 7, MS Outlook.