SUMMARY:

• 9+ years of total experience in diversified technologies including ERP, Data Migration and Data Integration (ETL Tools)
• 4.0 years of techno functional experience in end to end implementation and support ofOracle Apps HRMS modules Core HR, Payroll, Oracle Advanced Benefits (OAB) and Performance Management
• 2.0 years of product development experience in developing Oracle Fusion Migration tools using Oracle Data Integrator(ODI)
• 3.0 years of experience in design and development of ETL interfaces for data migration and data integration using PL/SQL
• Oracle Apps experience includes requirements gathering, gap analysis, CRP setup, functional specifications, set ups, forms personalization, creating user manuals, writing fast formulas, API’s, conversions and reports development
• ETL experience includes data model analysis, formulating integration architecture, transformation design, interfaces development and testing
• Vast experience in handling large volumes of data, strong exposure to RDBMS, data warehousing concepts and sound skills in SQL, PL/SQL
• Experience of leading projects from client location, ability to interact with client and/or end users to solicit information and define solution requirements
• Team player, quick learner and leadership abilities with strong problem solving skills and ability to adapt to new technologies.

TECHNICAL SKILLS:

ERP: Oracle Apps HRMS (HR, Payroll, OAB, Talent Management),Oracle Fusion HCM

ETL Tools: Oracle Data Integrator

Languages: SQL, PL/SQL

Scripting: Unix Shell Scripts, Java Script

Relational Databases: Oracle 10g and 11g

EXPERIENCE:

Confidential

Project Lead

Environment: /Tools/Software: Oracle 11g, Oracle Integrational Operational Planning (IOP), UNIX

Responsibilities:

• Leading the project from client location and responsible for overall delivery
• Working with business team and other stake holders (SAP, Data Warehouse etc.) for requirements gathering, feasibility study, high level solution design and POC development.
• Responsible for technical aspects of the project like architecture design, interface design and development for data integration and data transformations
• Co - ordinate with project team and end users to chart out the project plan and testing strategy
• Closely work with end users to understand the problem statement for ongoing issues and come up with a mitigation plan
• Responsible for onsite offshore co-ordination and status reporting to higher management.

Confidential

Techno Functional Consultant

Environment: /Tools/Software: Oracle Apps R12, Fusion HCM 11g, ODI, Oracle 11g

Responsibilities:

• Worked in the role of a Techno Functional consultant and point of contact (POC) for functional issues for Benefits module.
• Data Model analysis, Gap analysis, identifying the table/column mapping from EBS to Fusion and preparation of detailed design for each of the LBOs (Logical Business Objects)
• Develop ODI interfaces and validation reports in PL/SQL
• Identify and document the pre and post migration tasks.

Confidential

Module Lead - iRecruitment

Environment: /Tools/Software: Oracle Apps R11, OAF and Oracle 10g

Responsibilities:

• Worked as module lead for iRecruitment.
• Involved in requirements gathering from client, Gap analysis-solution document, CRP Test scripts, CRP testing, functional design document for iRecruitment,
• Involved in OAF personalization’s, configuration (Functional set-up), Unit Testing and System Integration Testing
• Prepared process flow diagrams and user manuals for client.

Confidential

Developer

Environment: /Tools/Software: Oracle Apps 11i, Oracle HRMS (Core HR and OAB), Oracle 9i

Responsibilities:

• Worked in the role of Module lead for a team of five resources.
• Handled the responsibilities of Project Analyst cum Configuration analyst.
• Involved in preparing the specification requirements analysis document for the proposed enhancements and estimating the effort required.
• Involved in tracking, monitoring and planning the work in the team.
• Also took up the additional responsibilities like and mentoring the new project members of account and Defect Prevention Anchor of the project.

Confidential

Developer

Environment: /Tools/Software: Oracle Apps 11i, Oracle HRMS (HR, Payroll and OAB), Oracle 9i

Responsibilities:

• Worked as team member and involved in preparing the functional set-up documents, design specification for Fast Formulas and configuration.
• In depth analysis and set-up of work structures, payroll accruals, costing, benefit rates and premiums and system extracts.
• Involved in developing the Fast Formulas and PL/SQL functions.
• Involved in unit testing and system integration testing.
• Took the additional responsibilities as Mentor for new team members and Configuration Controller of the project.

Confidential

Developer

Environment: /Tools/Software: Oracle Apps 11i, Oracle Applications Framework (OAF)

Responsibilities:

• Worked as team member and part of functional team for Core HR, Payroll, Advanced Benefits (OAB) and iRecruitment modules.
• Involved in requirements analysis, functional set-ups, system test planning and system integration testing.
• Documented the system test results using Quality Centre (Test Director) tool.
• Involved in User Acceptance testing on behalf of client and worked on user manuals for client.

Confidential

Developer

Environment: /Tools/Software: Oracle Apps 11i, Oracle HRMS (Core HR and OAB), Oracle 9i

Responsibilities:

• Worked as a team member and handled the Life Events, Rates and Eligibility modules.
• In-depth Analysis of system requirements and thorough understanding of the existing system to analyze the impact.
• Creation of new divisions, new flex fields, Quick Codes (Look ups) and LOVs.
• Preparing the Design Changes Document, preparation of specs for new rules (Fast Formulas) or existing rule changes.
• Preparing the Unit Test plan and executing the same.
• Also took up the additional responsibility as Back up CC (Configuration Controller) for the project.
• Worked as a team member and supported the clients Eaton and Merck.
• Analyzing the issues (bugs) reported via the Pro-Support tool and preparation of specification requirements analysis (SRA) document for the bug.
• Fixing the bug and analyzing the impact, configuring, testing and documenting the same.
• Attending the production fire calls.