SUMMARY:

• 10+ years of experience as Oracle Apps E - Business Suite Technical in Oracle HRMS, Payroll, SSHR, AP, AR, GL, FA, Purchasing and other modules.
• Had worked in 2 end-to-end implementations of Oracle HRMS & Payroll as Techno-Functional consultant
• Worked in 2 end-to-end implementations of Oracle Financials as a technical consultant
• Have experience of working in 6+ HRMS, 6+ Financials and 7+ other modules support projects.
• Experienced to develop technical objects in Payroll, SSHR, HRMS, Taleo, Purchasing, Order management, Projects, FA, GL, AP, AR and custommodules
• Can work efficiently on Fast Formulas, Form Personalization and User Hooks
• Performed responsibilities as a technical developer, project lead, team lead, technical lead and team member of the project
• Excellent efficiency in Oracle Forms, Oracle Reports, Oracle Workflow, RICE Components, XML Publisher, PL/SQL programming, Oracle Apex and Unix Shell Scripting
• Developed complex PLSQL objects, solution designs, test scripts and AIM methodology supported documents such as MD 50, MD70 and BR 100
• Fluent in English, Gujarati, Hindi and possess basic language skills of German too

SKILL:

Programming Tools: Oracle Forms & Reports, PLSQL, SQL, BI Publisher, RICE Components, Unix Shell Scripting, Oracle Workflow, SQL* Loader

EBS Technical: Payroll, HR, SSHR, AP, AR, GL, Purchasing, Projects, FA, SCM and other custom modules

EBS Functional: HRMS (Basic), AP (Basic), AR (Basic)

HCM Technical: Fast Formulas, User Hooks, Form Personalization, APIs, DFFs, KFFs

EBS Versions: R12, 11i

Database Tools: Toad, SQL Developer, PLSQL Developer, Data Loader

PROFESSIONAL EXPERIENCE:

EBS Technical Consultant

Confidential

Responsibilities:

• Created complex PLSQL packages to load organization and organization hierarchy using HRMS APIs, create custom payslips, updating or creating assignments, and position creation
• Developed custom Fast Formulas for employee generation, implemented User Hooks as per user requirements
• Modified custom workflow to create SIT requests of employees through backend
• Gathered user requirements for implementing new business logic or modify existing one
• Prepared MD70 documents following AIM methodology
• Create or modify complex PLSQL objects for implementing new or existing business processes
• Trained users and end users for new implementations using PPTs, documents and live sessions

EBS Techno-Functional for HR, Payroll and SSHR

Confidential

Responsibilities:

• Gathered requirements from clients for new business processes and modify existing ones
• Resolved decided support tickets in project scope before time in HR and Payroll
• Customized absence Fast Formula to exclude weekends and holidays during absence calculation
• Carried out solution designing of an enhancement project integrating it with Oracle SOA
• Acted as a coordinator between end users and development team to implement new enhancements
• Developed complex PLSQL packages to update and create assignments using HR APIs
• Carried out AIM based documentation and defect resolution
• Worked on Oracle Fusion HCM Technical for a short duration project
• Created SQL* Loader packages to update employee details

EBS HRMS/Payroll Technical (Offshore Developer)

Confidential

Responsibilities:

• Gathered requirements from clients to be added in the implementation project
• Participated in setups of organization, elements and employees
• Carried out data migration from legacy systems to Oracle HRMS using complex PLSQL packages, SQL* Loader, Unix shell scripting and customized Oracle Forms
• Created alerts for employees’ absence emails
• Carried out form personalization according to client requirements
• Carried out AIM based documentation and worked in defect resolution during post implementation support
• Developed concurrent programs, custom reports and forms for the project
• Created SQL* Loader packages to update employee details

Technical Lead for HR & Payroll

Confidential

Responsibilities:

• Developed custom Overtime module for the client from scratch in Oracle Payroll
• Created and customized complex PLSQL codes during implementation of the project
• Developed custom forms, reports and shell scripts to migrate data from legacy systems to Oracle HRMS
• Carried out AIM based documentation and defect resolution while leading the projects using custom tracking tools
• Developed BI Publisher reports as per the requirements given by customers
• Provided post implementation support and participated actively in defect resolution

Oracle Technical Developer

Confidential

Responsibilities:

• Developed custom HRMS projects using Oracle Forms, PLSQL, Oracle Reports and Unix
• Written complex PLSQL codes to create new and update existing objects in order to fulfil user requirements
• Participated in implementation of several HR projects across organization
• Responsible to gather requirements from end users, design solutions and carry out development of the same
• Trained new employees to pace them up with existing tasks and lead them during new developments
• Documented HR processes in company’s standard format in all projects
• Developed and customized matrix reports, payslips, detailed and summary reports

Oracle EBS Financials Enhancement and Support

Confidential

Responsibilities:

• Finished the project before time by completing all tasks with utmost customer satisfaction
• Gathered requirements from clients for AP/AR/GL modules enhancement and support
• Customized workflow of customer creation for a challenging client requirement
• Trained end users for new implementations and modifications
• Submitted AIM based documentation to client for the objects developed
• Developed complex PLSQL packages and code for new process development
• Modified BI Publisher reports and Oracle reports resolving bugs in existing components of objects under the scope of the project

EBS Offshore Financials Technical Developer

Confidential

Responsibilities:

• Gathered requirements from clients and mapped with standard Oracle FA module
• Responsible for tracking and leading technical developments in the team in PLSQL, Oracle Forms, Reports, SQL* Loader and RICE Components pertaining to FA
• Participated in setup activities of Oracle FA
• Implemented the project on time with up to the mark post implementation support
• Prepared MD70 documents following AIM methodology
• Trained users and end users for new implementations using PPTs, documents and live sessions

EBS Offshore Technical Consultant

Confidential

Responsibilities:

• Gathered requirements from clients for new business processes and modify existing ones
• Worked in a support project resolving tickets of AP, AR, GL and Purchasing modules
• Developed concurrent programs, form personalization to in corporate user requirements
• Acted as a coordinator between end users and development team to implement new enhancements
• Developed complex PLSQL packages and customized existing ones
• Carried out AIM based documentation and defect resolution
• Worked on inbound and outbound interfaces for data migration activities

EBS Offshore Technical Consultant

Confidential

Responsibilities:

• Developed and customized complex PLSQL packages and codes to implement business processes as suggested by client for AP, AR, SCM, and Projects module
• Developed forms from scratch to deploy new enhancements to simplify the then complex processes
• Developed concurrent programs, form personalization to in corporate user requirements
• Acted as a coordinator between end users and development team to implement new enhancements
• Designed a secure encrypted file transfer using GnuPG encryption for a support project in Unix
• Carried out AIM based documentation such as MD70 and MD50

EBS Technical Consultant

Confidential

Responsibilities:

• Gathered requirements from clients for new business processes and modify existing ones
• Worked in a support project resolving tickets of a custom engineering module
• Developed concurrent programs, form personalization to in corporate user requirements
• Acted as a coordinator between end users and development team to implement new enhancements
• Developed complex PLSQL packages and customized existing ones
• Carried out AIM based documentation
• Worked on RICE components, PLSQL codes, Forms, Reports and Unix Shell Scripting

Oracle Technical Developer

Confidential

Responsibilities:

• Developed custom Financials projects using Oracle Forms, PLSQL, Oracle Reports and Unix
• Written complex PLSQL codes to create new and update existing objects in order to fulfil user requirements
• Participated in implementation of several Finance projects across organization
• Responsible to gather requirements from end users, design solutions and carry out development of the same
• Trained new employees to pace them up with existing tasks and lead them during new developments
• Documented business processes in company’s standard format in all projects
• Developed and customized matrix reports, detailed and summary reports