SUMMARY:

• 16+ Years of experience in IT
• Experience in Quality Assurance Management, Program Management, DW - (ETL & BI) Management mainly in Pharma, Banking domains
• Performed the Portfolio manager role. Team size was around 35 members.
• Working as a Test Manager for the Data warehousing - ETL & BI Project for 8+ years
• Technical abilities complemented by sound communication skills, user interaction abilities, requirement gathering and analysis, and skills in data migration and conversion strategies
• Experienced in managing projects in waterfall and in Agile/Scrum project management methodology
• Have Global Experience of working in Europe (Netherlands), Asia (India) and North America (US) with several financial domain clients
• Expertise in Technologies such as Oracle, Teradata, SQL Server, Sybase, Power Builder ETL Tools: Informatica, AbInitio, Datastage PL/SQL Reporting Tools: Tableau, QlikView, Cognos, Quality Center/ALM, JIRA, UNIX Basics, And Excel Marcos for Automation.
• Knowledge about Big Data, Hadoop, Pig-Hive
• Worked as a Test Manager to design Test Strategy and approach for DW&BI - (ETL & BI) solution for a leading financial company. The Project involved testing a Data warehouse and Validating analytical reports and dashboards on top of the Warehouse. Was single handedly looking after complete Delivery from testing side
• As DW Test Manager my responsibilities include End2End Test Management, Status reporting to Client Program Management, Develop, High Level Test Strategy and Master Test Plans, Defect management, chairing the Triage calls and ALM (QC) Management
• Worked as a Test Manager in conversion and Migration of Large Databases at both Customer locations in US/Europe and also from Offshore (India).
• Managed multiple projects and testing teams 20-25 members responsible for whole project quality delivery and implementation. Proficient in establishing and managing global teams of high performing IT professionals.

CORE COMPETENCIES:

• Data Warehousing Testing - ETL & BI
• DWBI Development
• Program/Portfolio Management
• Business Intelligence
• GUI Testing
• Project Management
• Defect Management
• Mentoring/Training
• Experience in Banking, Life Science & Communication domain

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Informatica, Oracle, Tableau

ETL & BI Test Manager

Responsibilities:

• Understanding the Business Requirements and Project scope
• Test Estimations
• Test Planning
• Defect Management
• Test Execution, Test case reviews, Test Closure
• Onshore Offshore co-ordination

Confidential, Mellon

Environment: Informatica, Oracle, SQL Server

ETL Test Manager

Responsibilities:

• Managing the Delivery of different DW projects across Confidential Mellon
• Understanding the Business Requirements and Project scope
• Managed data warehouse enhancements and defects (requirements, estimation, prioritization, development, testing, and implementation).
• Responsible for managing client expectations about project details.
• Responsible for ensuring that the delivery of entire release is as per schedule.
• Provide leadership and directions to the team on quality standards and testing best practices
• Ensured that reporting was accurate and met the business requirements.
• Provided metrics, statistics, scope of work estimates, project plans that facilitated decision making for corporate initiatives.
• Participate in technical working sessions such as requirements definition, functional walkthroughs, technical design reviews, change control sessions and stakeholder meetings.
• Established consistent processes for code reviews and quality assurance

Confidential

Environment: Informatica, Tableau, Oracle

ETL & BI Test Manager

Responsibilities:

• Managing QA Delivery of different projects across Sanofi
• Understanding the Business Requirements and Project scope
• Test Planning and Estimation
• Single Point of Contact for all the QA deliverables from Cognizant side
• Involve in Tableau Dashboard development
• Responsible for ensuring that the delivery of entire release is as per schedule.
• Provide leadership and directions to the team on quality standards and testing best practices
• Streamlining business processes and providing automation where possible
• GUI & Performance Testing

Confidential

Environment: Informatica, Ab Initio, Cognos, Tableau, Oracle

DW Manager/ ETL & BI Test Manager/ Portfolio Manager

Responsibilities:

• Plans and manages the testing activities
• Portfolio Management
• Designed Skill assessment, ON/OFF rotation plans, Knowledge retention and knowledge up skill programs for QA Engineers
• Define level of effort for project and maintenance activities
• Participated in governance process, reported testing progress/test results, conducted triage meetings with business/BAs, development, project management and test teams to prioritize & close defects in a timely manner
• Raising issues that can lead to potential delays, frequent customer interaction and client meetings for understanding the existing functionality and processes.
• Responsible for managing client expectations about project details.
• Configuration management and change management of all project artifacts
• Test Execution Automation via Cognizant in-house tool
• Involve in responding to new proposals, estimation
• Involve in Tableau Dashboard development
• Conducting Project Management Review at a Program Level and publish finding for remediation

Confidential

Environment: Informatica, Obiee, TeraData

ETL & BI Test Manager

Responsibilities:

• Plans and manages the testing activities
• UAT Planning & Co-ordination
• Define level of effort for project and maintenance activities
• Raising issues that can lead to potential delays
• Frequent customer interaction and client meetings for understanding the existing functionality and processes
• Test Data Management
• Responsible for managing client expectations about project details.
• Bring the testing team up to the speed in providing the technical knowledge and business knowledge through classroom sessions
• Reviews and approves all test cases prior to execution
• Onsite/Offshore team management, knowledge management across the programs and resource mentoring
• Responsible for ensuring that the delivery of entire release is as per schedule
• Involved in Test Execution Automation

Confidential

Environment: DataStage, Obiee, Oracle

ETL & BI Test Manager

Responsibilities:

• Plans and manages the testing activities
• Defect Management and Weekly & Monthly Test report Generation
• Provide leadership and directions to the team on quality standards and testing best practices
• Ensured that project deliverables are produced, including, but not limited to: quality assurance plans, test plans, testing priorities, status reports, user documentation, online help, etc. Managed and motivated teams to accomplish significant deliverables within tight deadlines.
• Reviews and approves all test cases prior to execution
• Test Data Management
• Coordinates and reviews offshore work efforts for projects and maintenance activities

Confidential

Environment: Informatica, DB2, Unix, Microstrategy

Offshore Lead, ETL Test Lead & Onsite Co-ordinator

Responsibilities:

• Preparation of test plan & test strategy.
• Creation of SI Test Scripts using mapping documents.
• Implementation of Test scripts.
• UAT Support
• Defect Tracking
• Onsite point of contact
• Review of code developed by offshore team.
• Execute & Monitor Production Runs.
• Make enhancement to the Mart.
• Code & Test Cases Reviews.
• SIT & UAT support.
• Quality Processes - Maintaining Process Metrics, Facing internal external audits for ISO etc.

Confidential

Environment: Power Builder, Sybase, Unix, Db2, Mainframe

Project Lead, Team Lead, Onsite Co-ordinator

Responsibilities:

• Analysis & Design
• Technical specification creation
• Coding &Testing
• Code & Test case Reviews
• Work allocation & Status reporting
• Estimations & Planning