PROFESSIONAL SUMMARY:

• Expert Functional & Technical Consultant and Solution Architect with around 14 years of experience in the Oracle HCM space in the modules Core HR, Payroll, Advanced Benefits, Self Service, Oracle Time and Labor, Compensation Workbench, Oracle Application Framework, BI Publisher, Oracle Cloud HCM, Oracle Cloud Payroll.
• Oracle Global Human Resources Cloud 2016 Certified Implementation Specialist
• Oracle E - Business Suite R12 Human Capital Management Certified Implementation Specialist
• Proven functional expertise in Oracle Payroll, OAB, OTL, CWB and Core HR.
• Expert level experience in PL/SQL, RICEW components, Workflows, WebADIs
• Experienced in Oracle Application Object Library, System Administration
• Domain expertise in multiple industries - Retail, Manufacturing, Banking, Logistics, Infrastructure and Media
• Team management experience spanning across various critical stages of the project like Assessment, Design, Build, Test and Deployment
• Worked with Fortune 500 companies globally, in different consultant/lead/managerial capacities for ERP implementations, enhancements and support
• Delivered several solutions across various industry domains and led technical/functional analyst teams to help businesses achieve their end objectives
• Performed multiple roles in implementations, enhancements and support projects in most of the Oracle HCM modules
• Active member of the Oracle HCM Users Group and regularly involves in knowledge sharing in the group. A member of the Benefits SIG (Special Interest Group) in OHUG and regularly participates in closed group usability studies conducted by Oracle

PROFESSIONAL EXPERIENCE:

Senior consultant

Confidential

Responsibilities:

• Design Benefit Structure - Programs, Plans, Options and combinations of the above
• Design and implement Consumer Driven Health Plans (CDHP)
• Design Eligibility for Compensation Objects based on various Eligibility parameters
• Design and implement Life Events, life event electability, and defaults
• Define Derived factors to enable time based temporal events and eligibility
• Define Communication Types used for sending various communications to employees like Pre-Enrollment literature, Enrollment Reminders, Confirmation Statements, Temporal Communications,
• Define Evidence Of Insurability (EOI) requirements for life insurance plan types like Employee Life Insurance, Spouse Life Insurance, Dependent Life Insurance and AD&D Insurance.
• Define Standard Rates, Actual Premiums with various components like Employee Rates, Employer Rates, ASO Premiums etc.
• Implement extra logic in Standard rates for COBRA participants and for various rate eligibility factors like Age, Bargaining Units etc.
• Design and Implement Benefit Extracts - ANSI834 carrier extracts, Literature Extracts, AP Extracts etc. (includes Full and Changes extracts)
• Capture COBRA payment information for continued COBRA coverage
• Enable Oracle Seeded Benefits self-service where employees can enroll in benefits and cover their dependents during a qualifying life event.
• Configure Self Service Benefits for Open Enrollment, so that the employees can enroll/change their benefits during the defined enrollment period.
• Configure messages that need to be displayed during the enrollment process using communication types.
• Personalization and Extension of the seeded self-service enrollment pages to customize the enrollment experience for an employee.
• Create downloadable confirmation statement using customized BI Publisher templates.
• Create analytic reporting that shows various patterns of employee enrollment during an annual enrollment cycle
• Create reports using PL/SQL and BI Publisher to get the employee enrollment data, rates and deductions from payroll
• Create costing reports for checks and balances
• Creating interfaces using PL/SQL in cases where it is not efficient to use System Extracts.

MANAGING CONSULTANT

Confidential

Responsibilities:

• Define Payrolls and Consolidation Sets
• Define Payroll Elements using Earnings and Deduction templates
• Define recurring and non-recurring elements, input values based on the element type and need
• Define Skip Rules (fast formulas) and formula results as required
• Create Balances and add payroll elements to balance feeds
• Create custom fast formulae to pay premiums like overtime / holiday pay in conjunction with the OTL setups
• Help define business processes around payroll processing for various payroll frequencies
• Work with banks to create business processes for NACHA file (Prenote and regular payroll) transmission and validation
• Create interfaces from vendors using PL/SQL to import deduction amounts for employee voluntary contributions and create deduction elements for each pay-period
• Create custom payslips based by customizing the BI Publisher templates so that employees can view the payslips using ESS
• Create costing reports and other payroll reports
• Create the initial HR Setup as a part of the implementation - Job, Position, Grade, People Group, Cost Allocation, Competency KFFs
• Create Business Groups and GRE organizations
• Set up the organization structures and hierarchies
• Set up Jobs, Locations, Positions, Grades
• Set up People Groups, Benefit Groups, Bargaining Units etc.
• Set up accrual plans (PTO etc.)
• Set up custom employee number generation code
• Create interfaces for programmatic creation of employees based on inbound interfaces from ATS systems like Taleo
• Design and implement absences and other absence management components
• Design and set up timecards using elements, and flex fields
• Map the fields on the timecard to the time attributes that get stored in the OTL tables
• Define time entry rules for validation for various time categories like Regular Time/PTO/Sick/Jury Duty etc.
• Create time entry rules to check for daily maximums and weekly maximum of a particular type of time entry. For example, an employee is not allowed to take more than 8 hours of PTO in a day
• Create approval rules and workflows using AME
• Create earning policies and deduction policies
• Set up self-service OTL where salaried employees can fill the timecards by themselves.
• Customized the self-service OTL pages to display accrual balances.
• Create inbound interface from time recording machines which capture time-in and time-out of hourly employees and import them into their timecards
• Create reports related to transferring timecards from OTL to Oracle Projects
• Create reporting around employee time to check whether the employees are taking their legally mandated lunch breaks and other breaks
• Create interfaces to third party workforce planning systems
• Help create business processes to run the Transfer time from OTL to BEE process for employees based on their payrolls and pay periods

Senior APPLICATIONS ENGINEER

Confidential

Responsibilities:

• Design and implement CWB plans and rates
• Implement Budgets for promotions and performance reviews
• Set up ratings, s, targets
• Define responsibility based access to plans
• Configure worksheet and budget sheets
• Customizing the display of the CWB user interface
• Creating employee appraisal statements
• Help create business processes around running the CWB life event and the users regarding the usage of CWB
• Customize/Extend Oracle seeded Employee Self Service and Manager Self Service pages
• Create a completely custom self-service module with multiple OAF pages where employees can enter special kinds of time-off, missed lunch/meal break and other break times and a custom workflow for processing time and paying the employees accordingly.
• Create a completely custom self-service module with multiple OAF pages where HR users can initiate termination of hourly employees and enter time information and initiate immediate payment. The pages trigger a custom process that would terminate the employee, add the time in employee time sheet, process any unprocessed time, and run a quick pay and generate a paycheck. This is primarily used in states like California where a terminated employee has to be paid immediately after his termination.
• Create a custom self-service module where employees can put in requests for special pay to their employees based on eligibility for example, an employee who has performed a specific function in the office, which otherwise is not his job description can request a premium for doing that function on a particular day.