SUMMARY

• Have over 13 years of experience in IT Industry. Experience includes Project Management, Data Analysis, Data Migration, Data Conversion, Data Mapping, Data Profiling, Data Transformation,MDM, ETL Development, Data Modeling and Test lead and Test analyst (Functional & Nonfunctional testing).
• Experienced in developing accurate business process requirements for Telecom, Healthcare, Infrastructure sector and Public sector in Motor Vehicles Domain.
• Good Data Warehousing concepts including Meta data and Data Marts.
• Development of adaptors for Data Extraction, transformation and loading as part of the UDMF (Internal Framework) tool repository.
• Developed master data management (MDM) functionality along with Data Analysis in Financial and Public sectors.
• Design and define Data Migration strategy
• Extensive experience in project planning, execution, tracking, managing risks, people management.
• Good Knowledge on Big Data and Data Analytics
• Performed root cause analysis on complex data anomalies and working closely data stewards to define best practice.
• Create and maintain project level dashboards to enable effective project management.
• Determine methodology and processes for quality planning (in concurrence with project planning), define standards to use, document quality criteria and quality measurement processes, face audits and project process monitoring.
• Experience in conducting Joint Application Development (JAD) sessions with end - users, Subject Matter Experts (SME's), Development and QA teams
• Proficient in development methodologies such as Agile, Scrum and Waterfall.
• Strong testing skills, Experience in Test planning, test execution and Defect Tracking and worked different phases like System Integration, End to End Testing and User Acceptance Testing.
• Worked on Onsite and Offshore model having 4 Years of Onsite experience for various clients in UK and 2 years in USA.
• Worked with various clients like Nation Health Care Services(UK), British Telecom (U.K) Rabo Bank (Netherlands), Balfour Beatty (U.K) and Confidential DMV(US)
• Experience in ERP Migration Projects Module like Oracle AP, AR, SCM, HRMS and Payroll.
• Good experience in defect tracking tools like Quality Centre and Jira.
• Expertise in Functional Analysis, Requirement Analysis, Process mapping, Functional specification and Testing.
• Sound knowledge of Business process orientation to diagnose RCA on data issues
• Having application testing experience with working knowledge of automatic testing tools like HP Quick Test Professional.

TECHNICAL SKILLS

Analytics Tools: R, RStudio, Python

Web Tools: Oracle APEX

Programming Languages: SQL/PLSQL, C, C++, Java, VB Script

Reporting Tools: OBIEE 11g / 10g

Test Management Tools: HP Quick Test Professional, Quality Center and JIRA

ETL Tools: Oracle Data Integrator

Database: Oracle 10g/11g/12, Cassandra

Data Modeling Tools: Erwin

EBS: Oracle EBS (AP,AR,HR & Payroll)

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Data Migration and Reconciliation Lead

Responsibilities:

• Design custom migration architecture to implement the technical requirements based on latest technologies in software industry for Confidential ’s Retail Inventory Serialization.
• Preparation of high level and detail project plan, directing and manage the Data Migration project from Initiation to end Liaise with various project stakeholders on an ongoing basis.
• Baseline Customer Data Migrations related Business requirements.
• Reviewing Data Management Strategies in line with customer Requirements for Data Migrations
• Providing solution on Reconciliation between SoA Cassandra and current SAP, PoS systems through strategic interfaces being designed for the same
• Conduct workshop for development and testing team to provide knowledge of implementation of new requirements

Confidential

Data Conversion Lead

Responsibilities:

• Design and define Migration strategy.
• Design and define Quality Analysis module of extracted data to provide exception reports
• Analysis of the specifications provided by the clients, summarizing and validating specific technical requirements.
• Implemented master functionality and analysis for existing business.
• Identified the MDM data that is scattered across range of application.
• Migrated the MDM data to UCM application.
• Analyzed and documented all client requirements and business processes
• Design and prepared Data Discovery Reports.
• Responsible for overseeing the Implementation procedures related to the overall project and provide recommendations to client to adopt best practices in Data Archival process.
• Proactively communicate to customer on technical progress of project and highlight issues if any well in advance.
• Designed Testing Data Masking module
• Designed Audit Trail module

Confidential

Data Migration and Functional Lead

Responsibilities:

• Preparation of Project plan with detailed list of activities along with highlighting dependencies and tasks on critical path to be executed till GO-LIVE.
• Ensure high customer connect for the project, building processes for all relevant team members to engage with the customer.
• Understand all sources of data and understands the Data quality state in each source for Data Pre
• Understand the existing ERP system (MENTOR) and the operations of business in the legacy
• Setting out Data Migration Strategy with the consensus of business and documentation of CV015
• Run workshops with legacy system users and SMEs to arrive at field to field mapping and transformation rules and further Documentation of CV040s.
• Developed MDM strategies and solutions utilizing UDMF tools
• Formulated and implemented master rules(MDM) in Migration Controller.
• Prepared Management reports related to data cleansing and classification tasks.
• Unit testing of files extracted and suggest for improvisations
• Setting out Reconciliation Strategy right from the Source(MENTOR) to Target (R12) and further the documentation of CV130
• Evaluation of new changes in solution to identify their impact on Data Migration and adopt necessary changes in Data Migration Strategy and Reconciliation
• Development of new reports in specific to the business in context.
• Perform pre/post migration steps and Handle reconciliation for Payroll Process run.

Environment: Oracle EBS R12, UDMF, PL/SQL

Confidential

Data Migration Lead

Responsibilities:

• Analysis of the source data for the Migration.
• Design and Development of Selection and Transformation Rules
• Tracking of data quality issues and trends on the integrated data for the respective modules/entities
• Creation of Data Profiling and Transformation rules to fix the data quality issues in coordination with the business process
• De duplication RCA and resolution of data quality issue under the respective entities
• Highlighting Project Dependencies (from Data Migration deliverable perspective) and impact of dependencies on deliverables with teams on daily basis
• Supported data governance processes and ERP system implementation.
• Implemented master functionality and analysis for existing business.
• Synchronize the master data across the enterprise.
• Identified the Golden data set for implementing MDM solutions.
• Design the Mapping design for all ERP Modules like Finance, HR & Payroll
• Responsible for overseeing the Quality procedures related to the project.
• Client site for implementation.

Environment: Oracle EBS 11i & R12, UDMF, PL/SQL