PROFILE SUMMARY:

• 5 years of hands - on experience developing and maintaining SQL Databases
• 5 years of hands-on experience in data modelling and SQL development
• 5 years of hands-on experience in ETL Process Development
• 5 years of hands-on experience with ANSI SQL scripts for DDL, DML
• 10 years of experience with data integration ETL tools such as Informatica, BODS (SAP)
• 5 years of hands-on experience with Informatica Mapping, Workflow package development
• Strong understanding of MS SQL Server, Oracle and other relational databases
• Experience in SQL development tools, TOAD, T-SQL, SQL Developer, IBM Netezza, Teradata
• Strong Powercenter Informatica development experience
• Experience in UNIX script development
• Strong SQL knowledge in DDL, DML query development as well as an understanding of database structure
• Knowledge of data modeling principles
• 7 years of experience in creating technical documentation and specs
• Experience in developing and executing ETL and data conversion methods for the migration of data from multiple existing modern and legacy systems into Enterprise Data Warehouse.
• Strong knowledge of the business process related to Financial Institutions, mutual funds, CRM, Lending, Credit Cards and Portfolio Risk Management.
• Experience in the planning and execution of large-scale critical data conversion and migration initiatives
• Experience performing data conversion/migration from legacy systems to Salesforce, eCOM sites.
• Have worked on Multiple Parallel Projects with offshore-onsite mix.
• Have worked extensively with Test Management Tools, HPQC, JIRA, Star Team.
• Experienced in ETL Batch Job Run Planning and Executing.
• Thorough understanding & experience on SDLC Models, Waterfall & Agile.
• Hands on Technical skills with Project/Program Management Tools, MS-Project, MS Visio, MS Office, JIRA, Microsoft Sharepoint.
• Strong Interpersonal, Problem solving skills
• Self-starter, continuous leaner paying attention to details.
• Strong experience working with Architects, Business Teams, QA, BA Teams.

SKILLS SUMMARY:

SQL Scripting: Oracle SQL Developer, MS SQL Server, IBM Netezza, Teradata

ETL Development: Informatica Power center, Data Validation Option

DETAILS OF EXPERIENCE:

Data Warehouse ETL Specialist

Confidential

Technology: Informatica Powercenter, MS SQL Server, T-SQL, Oracle, MS APS Data warehouse, Unix

Responsibilities:

• Analyze and understand complex databases and multiple systems of data.
• Understand and implement logical and physical data models and solutions to support reporting systems and analysis.
• Develop data integration and ETL packages between our various databases and business systems.
• Maintain and enhance database views used in our enterprise data warehouse and other reporting databases.
• Troubleshoot issues with Data warehouse databases, views and query performance.
• Operational support and troubleshooting of data integration and ETL processes.
• Follow guidance and recommendations on data integration and best practices.
• Collaborate with other teams and departments to ensure excellent levels of internal customer service.
• Responsible for understanding spec. and development and maintenance of SQL Server databases, ETL processes.
• Maintaining and supporting existing ETL applications
• Create T-SQL scripts to implement business logic for ETL processes
• Analyze and troubleshoot ETL processes
• Create and maintain technical and functional design documents for projects
• Communicate with architects, business users, managers and team members
• Continuously learning new innovative technologies and upgrading knowledge on existing ones
• Development and execution of data mapping packages
• Conversion, migration and ETL procedures to effectively migrate data from legacy systems to the new target Data Warehouse
• Develop high quality ETL code on time and on target
• Perform ETL by developing various Informatica objects to extract and transform data; scheduling workflow sessions, jobs and executing them in workflow manager
• Work closely with the Informatica Administrators to support the deployment of changes to higher environments
• Work in a dynamic Agile/Scrum/Waterfall team environment
• Applying DevOps best practices
• Documenting work as required following development standards
• Working with the Data warehouse architect in Identifying, documenting and validating data conversion/migration scope, risks, constraints, dependencies and assumptions
• Scripting and executing of ETL packages to enable automation and less manual intervention
• Ability to build modular, parameter based code to help reusability
• Prepare pre-load and post-load SQL scripts
• Prepare data comparison procedures to test the transformed data
• Working with analysts and testing team to resolve any data related issues
• Monitor service desk work queue and responds to support issues within agreed service levels
• Works with key users and stakeholders to identify and resolve data issues
• Conducts post implementation review of ETL, data conversion and migration exercises

Data Warehouse Analyst

Confidential

Technology: IBM Netezza, SAP Powerbuilder, UNIX

Responsibilities:

• To read and interpret the technical specification in the SAP Powerbuilder.
• To participate in spec. review and technical design meetings.
• To develop SQL scripts based on the Specifications transforming input file data into Data Mart Tables.
• To develop Test SQL scripts to compare target tables with Test Tables.
• To investigate and analyze defects and troubleshoot.
• To identify test data requirements and develop Test Dictionary scripts.
• Review Test cases and provide sign off.
• Prepare Deployment package for migrating the ETL code to Production.

QA Lead

Confidential

Technology: Teradata, Informatica Power Center, Oracle(Unix)/SQL Developer, QTP, SAS, JIRA

Responsibilities:

• To evolve Test Strategy considering that the platforms are new to the organization.
• To plan & design Test Environment.
• To identify QA elements to be taken care of in the Agile Kanban method of Project Execution.
• To plan for data inputs in source systems in Java, SAP & SharePoint Platforms using QTP Automation.
• To estimate the resource need and arrange recruiting & onboarding.
• To train & mentor testers, review performance on continual basis.
• Prepare & Review Test cases for Dimension & Fact Tables of DW.
• Develop Test Cases for user stories & write SQL Scripts.
• To guide Testers at offshore in Test Execution.
• To plan for Informatica WF Batch Running in Test Tiers.
• To coordinate and support UAT.
• To get Sign off for QA Artifacts.
• To Admin JIRA for the project & generate daily & weekly Status reports.
• Test Strategy developed for Relational Model Data Warehouse using Agile Method.
• Innovative Test Environment & Test Data Management Process evolved.
• Developed Framework for SQL Script Development.
• Developed & Reviewed SQL Scripts for 100 User Stories.

Test Lead

Confidential

Technology: Informatica Power Center, .net, MS-SQL2008, Sybase, SharePoint, XML, Saleforce.com, HP QC, JIRA, HPIM

Responsibilities:

• To identify the elements in Test Environments & publish periodic notification on status of the Environment.
• Monitor, control and Gate Keep Test Data configuration in all Test Tiers.
• To Identify/Prepare Test Data in source systems, CDS, SharePoint, Mainframe.
• Develop SQL Scripts for Data Mapping Rules.
• Plan & implement deployment of SW packages to higher levels of Test Tiers & arrange for Validation.
• To guide Testers at offshore in Test Execution.
• To plan for Informatica ETL Batch Running in Test Tiers.
• To coordinate and support UAT.
• To get Sign off for QA Artifacts.
• To Admin ALM for the project & generate daily & weekly Status reports.
• Developed & Implemented Templates for monitoring Status of Test Tiers.
• Guided, motivated offshore team & efficiency improved by 50%.
• Framework for Database Testing introduced.

Sr. QA Consultant

Confidential

Technology: IBM Curam (SOA), Java, Oracle database, QTP, HP QC, Ab Initio

Responsibilities:

• To review Strategize testing different Services in the system.
• To work with the dev team and develop Build Plan & Smoke Testing Process.
• To writes SQL Scripts to validate data in Target system (Curam).
• Unit Testing of Services in the SOA.
• To strategize Test Data Management
• To provide requirements for Test Environment and ensure the Environment is Validated.
• To schedule and monitor Test Execution for Integration, System & UAT Phases.
• Prepared Data Driven Test cases for the complicated Monthly Benefits calculations.
• Successfully evolved & implemented quick and easy approach to carry out Integration Testing.
• Prepared Framework for Automating Monthly Benefits Testing in QTP .

QA Lead

Confidential

Technology: Java, SAP, PeopleSoft, Oracle, ETL tool - BODS, COGNOS Reports, Quality Center & QTP Java, xml & flat file interfaces, Oracle SQL Developer, SharePoint, Sub Version

Responsibilities:

• Architect Test Solution for the Data Warehouse.
• Develop Test Plan, Test Strategy for the Warehouse development involving all stakeholders.
• Identify Test Environment Requirements & prepare business cases for acquisition.
• Work with DBA Team in laying out the layers of Test Tiers & sharing arrangement between Development & UAT Teams.
• Maintain configurations of Test Tiers for each system elements.
• Gate keep configuration changes to Test Tiers & keep the project teams notified.
• Ensure coordination of Test Tier updates for downstream development teams periodically.
• Develop and review SQL scripts for Data Mapping Spec.
• Publish daily status report on Test Tiers indicating Data Version & Code Version.
• Plan for code merge across Test Tiers to ensure Production Environment is simulated for Testing.
• Monitor & Track Environment Issues in HPIM. Escalate critical issues to ensure minimum downtime.
• Plan ETL Batch running for different Test Tiers in line with Test Execution Plan.
• Set up Test Data Input in source systems, PeopleSoft, Java based portal QTP Automation.
• Implement Test Process & methodology for Data Warehouse. Review of Business Requirements, Creation of Test Plans, Test cases & Test SQL Scripts and getting Sign off. Manage Test data creation & review. Manage Defect Tracking and Defect Triages.
• Make Periodic Project Status update presentation to Governance Team using MS Visio, MS Powerpoint.
• Manage System Testing, End-To-End Testing, Regression Testing, Conversions Testing. Manage 5 team testers from offshore.
• Conduct Defect Triages; Participate in Production warranty issue management team. Provide detailed investigation report on issues with a view to prioritize, fix and re test.
• Developed Test Tiers Tracking Dashboard.
• Developed & executed SQL Scripts for about 1100 Test Cases covering 55 Dimension & Fact Tables.
• Managed successful rollout of initial release & the subsequent 5 major releases.
• Developed Process for Periodic Refreshment of Test Tiers.
• Developed Test Tiers Version Control Mechanism in Sub Version.

QA Lead Consultant

Confidential

Technology: .net, Unix DB2, Mainframe(COBOL), JCL, COGNOS, IBI Webfocus, Abinito (ETL Tool)Quality Center, QTP, Lotus Notes, Toad, Loadrunner

Responsibilities:

• Lead QA for multiple projects with onsite-offshore teams.
• Plan for HW & SW System Requirements for Test Environment catering to the needs of all the ongoing projects.
• Maintain Test Tiers allocation for projects based on the individual release schedule.
• Plan for code merge for Test Tiers shared by multiple projects having staggered release schedule.
• Maintain versions for SW elements of Test Tiers & release status report.
• Develop specific test cases for covering data range in GDS, Airline Travel Booking System.
• Implement Model Test Database to generate Test Data. Develop and review Test cases & Test scripts. Conduct Team review of Business Requirements and provided sign off. Manage Test execution & defect tracking.
• Implement Functional Testing, End to End System Interface Testing, Testing for Data conversions, Automated Regression Testing using QTP.
• Coordinate about 50 Team members from different locations across the globe.
• Train and develop SQL skills in Testers. Review SQL Scripts for test cases.
• Use Quality Center for Test cases, Defects.
• Analyze issues found in software enhancements, provide data and suggested solutions to development team to fix the issue, participate in defect triages.
• Discuss Requirements and UAT Plan with Business SMEs & Business Analysts. Work with System Analyst to set up Test Data. Interact with Developers to resolve defects. Interact with PM to provide status reports.
• Developed Lotus Notes Utility for Tracking & Reporting Environment Availability.
• Developed Test Data Dictionary & Test Data maintenance process.
• Developed Process for Test Data Loading & Production Data Refresh for Projects.

Lead, QA

Confidential

Technology: Java/XML, Websphere, Data Repository in Unix DB2, CICS, JCL, Inhouse ETL tool MS SQL server 7.0, Quality Center, QTP, MS Project, Toad Java based web applications, SharePoint, Oracle Database application

Responsibilities:

• Manage QA for projects under Auto Enrollment program.
• Review Projects’ Test Artifacts & conduct project audits.
• Work with Infrastructure team in managing Test Environment.
• Allocate Test Tiers & Test Data for projects.
• Prepare QTP Automation scripts for golden test cases to add to Regression suite.
• Work with Release Management Team & plan for Pre Prod Staging Validation & Rollout.
• Resource maintenance, development & deployment.
• Develop SQL Scripts for Database Validation.
• Evolve & implement TCOE processes.
• Set Processes & Norms for Quality Center, plan for customizing.
• Coordinate Trouble shooting, cross functional teams, Production rollouts.
• Mentor & train QA resources. Manage new recruitments.