EXPERIENCE SUMMARY

• Oracle HCM Techno - Functional Consultant having experience of around 10 years with HR and Payroll Implementations.
• Worked primarily in the domains of - Banking, Investment, Retail & Manufacturing.
• Extensive experience in Oracle Core HR & Payroll, working with versions Oracle E-Business suite R11 and R12. Strong Oracle SQL / PL SQL experience.
• Worked in both Waterfall and Agile methodologies, with projects of Data conversion, Production support and Maintenance.
• Best in class functional knowledge, technical Skills, industry know-how and good customer relationship skills.
• Quick learner with willingness to learn new areas irrespective of technical or functional.
• Also possess knowledge on Oracle HCM cloud (Fusion HR) module along with knowledge on Oracle cloud s multi-tenant architecture.

TECHNICAL SKILLS:

• PL/SQL
• SQL
• Oracle Forms 6i
• Oracle Reports 6i &10g
• Oracle Alerts and Notifications
• XML Publisher
• Fast Formulae
• UNIX Shell scripting
• SQL Loader

PROFESSIONAL EXPERIENCE

Confidential, CA

Project Lead

Responsibilities:

• Worked as a Business Analyst in initial Data conversion stage, conducting meetings with various stakeholders of the project, to create the Data Conversion Strategy & Roadmap.
• Reviewed and analyzed relevant documentation to ensure the understanding of conversion needs .
• Implemented Techno-Functional Data mappings in Oracle HRMS.
• Mapped the requirements from PeopleSoft source to Oracle target system and then managed any gaps.
• Led the data conversion team at onsite and offshore by demonstrating the clients operational policies and requirements to the team.
• Worked with Data extraction team for receiving the source data from Teradata database.
• Guided offshore for developing the SQR programs for conversion.
• Reviewed and tested the stage, translate, target and main validate SQR programs of data conversion.
• Involved in Impact analysis and deciding project deadlines.
• Performed Onsite-offshore coordination.
• Worked with US team for domestic data conversion and with APAC teams for international data conversion.
• Attained great client appreciations during conversion go-lives.

Confidential

Technology Lead for Production support

Responsibilities:

• Supported Confidential ’s SSHR application and worked on change requests and Trouble tickets.
• Developed and tested PL/SQL Interfaces and Triggers.
• Developed Concurrent programs to send E-mail Alerts and Notifications using Oracle Alerts.
• Performance Tuning of Interfaces using Oracle’s built-in Explain plans and TKProf hence optimizing the SQL statements for improving the performance.
• Worked on Cost Based Optimization (CBO).
• Worked with SQL*Loader utility to load data from external files into Oracle database tables.
• Performed Design Review & Code Review.
• Reported status of the project work that was assigned on a daily basis to offshore managers.
• Conducted Defect Prevention meetings and Knowledge sharing in the project team
• Led and mentored the offshore team.

Confidential, SEATTLE, WA

Oracle Techno-Functional Consultant

Responsibilities:

• Provided Production support for Confidential ’s HRMS system and worked on Trouble tickets and Change Requests.
• Provided technical support to the end user.
• Performed 24/7 On-call activities for Confidential ’s HR, Payroll, Benefits, Time and Labor and Incentive compensation applications in production.
• Provided consulting to the technical team on the areas of Code Tuning and Bug Fix.
• Exclusively worked on improving the structure of Control M Tool for scheduling Confidential ’s production jobs.
• Created/updated Job documents for all the Control M Jobs.
• Interacted with Business teams and did client interface.
• Performed Onsite-offshore coordination.

Confidential

Oracle Developer

Responsibilities:

• Worked in all phases of SDLC in both Waterfall and Agile models in this project.
• HR Implementation of package solutions: PL/SQL packages and Concurrent programs.
• Designed and built Outbound Interfaces from ORACLE Payroll to third party finance systems.
• Built Inbound Interfaces from external Time Entry system to Oracle Payroll.
• Developed and enhanced Oracle 6i Reports for various HR/Payroll applications.
• Developed Oracle 10g Reports for creating PAY SLIPS in Fidelity’s Payroll.
• Customized Oracle Forms for improving the run times of Pay checks for Payroll in Fidelity.
• Configured Absence Entry Elements in Fidelity’s Absence screen.
• Configured the Oracle FNDLOAD programs.
• Developed and tested F AST FORMULAE for Fidelity’s payroll.
• Developed XML reports using XML Publisher in HR.
• Tested Oracle Alerts and Notifications.
• Created UNIX Shell scripts for loading and testing the programs.
• Played the role of a DP anchor in Defect Prevention Team. Executing and maintaining the disaster recovery plans and exercises.
• Actively worked on Configuration management team including creating, closing and governance around change related processes.
• Acquired knowledge on I-Recruitment and Talent Management, while working on change requests.
• Implemented automation in Fidelity’s Off-Cycle Payroll process by developing custom Payroll Forms, which was an outstanding project for the client .
• This assignment was done in Agile methodology.
• Worked as a Business Analyst for one of Fidelity’s projects: Gathering requirements, analyzing & creating High level design documents.

Confidential

Oracle Developer

Responsibilities:

• Underwent Initial Learning Program conducted by Confidential in ERP systems.
• Gathered requirements and Co-ordinated with the Japan onsite team.
• Built the High and low level design documents for PL/SQL Interfaces.
• Developed and Tested Inbound and Outbound Interfaces in Oracle Manufacturing.
• Did Performance testing of Discoverer reports.

Confidential

Quality Control Engineer

Responsibilities:

• Quality Testing of Connecting Rods, Crank Shafts with 3D co-ordinate measuring M/c.
• Surface Roughness testing and Roundness testing.
• Preparing Control charts for QC & Cost Reduction analysis.