SUMMARY

• Overall 9+ years’ experience in Oracle Apps and out of which more TEMPthan 7 years on Oracle HRMS.
• Worked on end to end implementations for OAB and Core HR modules.
• Worked on R12 upgrade projects for Oracle HCM Module.
• Specialized in Oracle Applications (Core HRMS, OAB and Payroll, OTL, SSHR, AME etc.) with sound noledge of their integration for all modules in Oracle HRMS.
• Experience in Design and Development of Conversions, XML Reports, Workflows, Payroll Interfaces, Personalization, and Fast Formulas etc.
• Strong experience in PL/SQL.
• Designed and Developed Payroll Interfaces for ADP for various Legislations.
• Worked on complex FF for OAB, Absence Management etc.
• Worked on Oracle Business Intelligence Enterprise Edition 10g (OBIEE)Reports.
• Designed and developed dashboards and reports.
• Worked on various Requests for Proposals.
• Strong noledge of Application Object Library (AOL)
• Worked as Technical consultant on OM, INV, AP, AR, GL modules.

TECHNICAL SKILLS

ERP: Oracle Applications 11i, 12i.

Functional Skills: Core HR, Oracle Advance Benefits (OAB), Oracle Payroll, Oracle Time and Labor (OTL), Oracle Self Service HRMS (SSHR), iExpenses etc.

Technical Skills: Reports Development, Interfaces, XML Publisher, Workflows, Form Personalization, CUSTOM.pll, Alerts, AME, Data Migration, Alerts etc.

Operating Platforms: Windows NT/ 2000

DBMS/RDBMS: Oracle 10g.

Languages: SQL, PL/SQL, XML, Java ( Basic )

Tools: Developer 2000 (Forms 9i & Reports 9i), Bi Publisher, Toad 9.0, Workflow Builder OBIEE 10g etc.

PROFESSIONAL EXPERIENCE

Confidential, TX

Modules: Core HR, OAB

Environment: Oracle Applications HRMS 11.5.10.2

Functional consultant

Responsibilities:

• Involved in teh project as a Techno - Functional consultant to design and support Interfaces like Business Solver interface, ADP interface etc.
• Developed various custom reports, User hooks etc.
• Supporting Existing structure of teh client for various issues.

Confidential

Oracle HCM R12 Upgrade with Payroll Enhancements

Modules: Core HR, Oracle Payroll, Absence Management, OTL etc.

Environment: Oracle Applications HRMS 12.1.3

Responsibilities:

• Worked as a Sr. Functional for R12 upgrade project for Core HR, Payroll, OTL etc. enhancements.
• Gather requirements from UOM team based on a series of discussions with teh stakeholders.
• Analyze teh current solution and extend it to suit teh long term objectives.
• Implement various changes in Current Fast Formulas as per new element designs.
• Carrying out unit testing for all teh Payroll FF’s.
• Creating high level solution document and some detailed solution documents.
• Preparing System Integration Test Plans, UAT test plan and planning teh cutover activities.

Confidential, TX

Modules: Core HR, OTL

Environment: Oracle Applications HRMS 11.5.10.2

Sr.Consultant for rolling out Core HR and OTL

Responsibilities:

• Involved in teh project as a functional consultant to design various time sheeting processes in Oracle Time and Labor for labor capitalization in Oracle Projects.
• Creating high level solution document and some detailed solution documents.
• Various Timecard Customizations to suite Clients need.
• Writing Complex Fast Formulas for various Time Entry Rules (TERS).

Confidential

Modules: Core HR, OTL, PMS, OSB, iExpenses etc.

Environment: Oracle Applications HRMS 11.5.10.2

Lead consultant

Responsibilities:

• Gather requirements from Telenor based on a series of discussions with teh stakeholders for enhancements/issues.
• Supporting entire application for HRMS for Telenor.
• Analyze teh current solution and extend it to suit teh long term objectives and intended rollouts to other countries.
• Replicated, reviewed and analyzed teh problem on a test instance
• Found teh root cause of teh problem and find corrective actions.
• Test corrective actions on 3 different test instances before preceding teh changes to Production instance.
• Raised Change Record to keep other Oracle Apps using teams to keep them in loop of teh changes.
• Co-ordinate with business if teh change requires system down-time.
• Recommended new/relevant application features/patches to leverage teh application so as to benefit teh client.
• Creating high level solution document and some detailed solution documents.
• Updated/made BR100, MD050 to document new implementations/changes.

Confidential

Modules: Core HR, OAB, SSHR.

Environment: Oracle Applications HRMS 11.5.10.2

Responsibilities:

• Gather requirements from Confidential based on a series of discussions with teh stakeholders for Payroll Interface.
• Understand different infotypes and their fields, Date track features in SAP.
• Designing and preparing teh solution with a generic approach for reusability and presenting it to teh client for feedback.
• Creating various PL/SQL Packages, functional setups.
• Creating user guide.
• Carrying out UAT and CRP'S (Customer Room Pilots) at client side.

Confidential

Responsibilities:

• Testing all teh custom programs and functionalities before and after upgrade and documenting teh results.
• Cross verifying teh results and fixing issues.
• Modifying system as per Oracles guidelines for different legislations.
• Preparing System Integration Test Plans, UAT test plan and planning teh cutover activities.

Confidential

Responsibilities:

• Working closely with core HR for collecting data and loading HR Data into Oracle.
• Designing of teh trigger based system at OneSource side.
• Development of teh program from scratch which would interface teh payroll data to vendors system.
• Carrying out UAT and CRP'S (Customer Room Pilots) at client side.
• Carrying out payroll runs for few runs before new systems takes full charge.

Confidential

Modules: OAB

Environment: Oracle Applications HRMS 11.5.10.2

Responsibilities:

• Develop functional designs utilizing a disciplined application development and implementation methodology when required.
• Defining Benefit structure as a whole.
• Created various complex Fast Formulas for LE, PEDT, Eligibility, Extracts etc.
• Defining complex eligibilities, Life events.
• Implemented different Standard Rates and VAPRO’s.
• Implemented different Electability based on various Life Events.
• Implemented various ANSI standard carrier extract files.
• Creating Extra Information Types.
• Defining Elements and linking as a part of voluntary deductions for rates.
• Follow up all of client's Production Support processes to ensure quality solutions are implemented.
• Implemented various ANSI standard carrier extract files. Follow up all of client's Production Support processes to ensure quality solutions are implemented.

Confidential

Modules: OM, INV, AP, AR, GL etc.

Environment: Oracle Applications HRMS 11i

Responsibilities:

• Develop Inbound Interfaces for SCM modules. E.g. Item Upload, Open PO, Vendor Master Interfaces etc.
• Data Conversions for various APAC countries.
• New Report Development and Customization to existing reports using Reports 6i.