Data Migration Analyst Resume

TECHNICAL SKILLS

Testing Tools: Win Runner, Test Director, QC 10,QC 11

Languages: C, C++, JAVA, HTML, TOAD, SQL and PL/SQL

Databases: Oracle 7.x, SQL Server 6.5/7.0, and MS Access 7.0,DB2,ADW,EDW,Teradata,ETL (Informatica)

Web Technologies: JAVA Web Server and IIS

GUI: Java Swing, AWT/Applets, VB and Developer 2000

Operating Systems: Windows 95/NT, Windows 2000, Main Frames, Linux server

Scripting languages: Java Script, and VB Script

Packages: Microsoft Visual Source Safe, Microsoft Out look, MS - Word, MS Excel and MS Access, MS Project 2000

PROFESSIONAL EXPERIENCE

Data Migration Analyst

Confidential

Responsibilities:

Performed Data analyst and Data testing activities for Ticket replacement data migration project.
Documented comprehensive test plans in HP ALM
Co-ordination with downstream application SME
Managing large test data sets-includes planning and partnering with others to create tickets
Liaison between IT and Development team
Created test data for full ticket life cycle testing (i.e. ticket sales, package sales, modifications, usage)
Assist the Finance Controllership in the triaging of ticket issues
Created daily status reports in support of Financial Testing
Created Reconciliation data mapping documents

Senior Consultant-ETL QA

Confidential

Responsibilities:

Involved program level testing activities for EDR and EVOLV Data ware house projects involving ETL.
Lead QA/testing teams on shore and off shore
Planning test approaches, environments, data, and defect reporting.
Experienced in using HPALM tool for Requirement management, Test case management, test execution, defect tracking and report generation.
Hands on Back end DB testing.
Developed simple to complex SQL scripts for back end testing for functional and business scenarios.
Participated in reviewing Requirements, technical Design and Mapping documents
Experienced in using Toad Data Point for executing queries, data comparison between source and Confidential tables or files.
Effectively communicating testing activities and findings in oral and written formats

Project Consultant ETL QA

Confidential

Responsibilities:

Lead the program level testing activities for BI projects involving ETL and front end Dashboards.
Planning test approaches, environments, data, and defect reporting.
Implementation of HPQC at program level tool for Test case management, test execution, defect tracking and report generation.
Participating in PLT meetings on program level discussions.
Coordinating and participated in User Acceptance Testing.
Lead QA/testing teams on shore and off shore
Risk Management.
Defect Management.
Hands on DB testing.
Conducting Gap analysis
Maintaining traceability matrix.
Validations of BI Reports.
Coordinating UAT effort.
Root Cause Analysis

Senior Consultant-Business Data Quality (ETL)

Confidential

Responsibilities:

Lead the testing activities for BI projects involving ADW, EDW and DB2 databases.
Planned testing approaches, environments, data, and defect reporting
Created and reviewed Master Test Plan.
Designed and maintained test cases and data
Executed test cases and logs results.
Participated in risk and issue management, estimating, and other activities as requested by the PM
Created and maintains requirements traceability from objectives through testing
Participated in risk and issue management, estimating, and other activities as requested by the PM
Coordinated and participated in User Acceptance Testing.
Lead QA/testing teams on shore and Off shore
Provided functional testing status reports.
Conducted and Reviewed defect status with team regularly and followed the escalation process.
Escalated/mitigated/resolved risks and issues.
Participated in Check Point Reviews