SUMMARY

• A distinguished senior - level Oracle Cloud & EBS Functional Time and Labor Consultant with over 18 years’ experience in analysis, design, customization, configuration, implementation and testing of Oracle Cloud and EBS Applications 11i to release 12 & Oracle Fusion Cloud HCM 20B.
• Proven ability to map clients’ requirements to Oracle applications, in order to meet project goals, demonstrated successful ability to conduct Conference Room pilot testing, and transferring knowledge to the end users.
• Experience, in interfacing Oracle HCM Applications to either third party applications or other applications in the Oracle Cloud business suite.
• Have expertise in the integration of third party applications like Ceridian Payroll, ADP, & Kronos time capturing system to Oracle Applications.
• Excellent communicator, with emphasis on building strong client relationship, and capable of making professional presentations.

TECHNICAL SKILLS

• Oracle Standard Reports.
• CEMLI (Configurations/Customization, Extension, Modification, Localization, and Integration.
• RICE (Reports, Interfaces, Conversions, Enhancements / Extensions).
• Onshore & Offshore Interaction with technical teams
• Business Analysis.
• Business Requirement Definition.
• Business Modeling.
• Gap Analysis.
• Fast Formula
• Data Conversion.
• Application of System Development Life-Cycle
• Post Implementation Support.
• Proficiency in Technical Issues Resolution using Oracle Metalink.
• Training & Project Management.
• AIM Methodology

PROFESSIONAL EXPERIENCE

Confidential, Bryan - Texas

Oracle Cloud Time and Labor Lead

Responsibilities:

• Implementation of Oracle Cloud Time and Labor for Confidential as Full Time employee of Oracle America.
• Project statement of work - Oracle Cloud Time and Labor:
• Based on the requirements gathered during the current and future Business Processes Flows analysis. These tasks were performed:
• Supervised Off-shore team in creation of several Fast Formulas for different Time Card Calculation Rules.
• Creation of both Single-Attribute and Multiple-Attribute Field Timecards for Hourly and Exempt employees respectively.
• Configured Approval Rules.
• Time Entry Rules
• Worker Time Entry Setup Profiles.
• Time Calculation Rules.
• Time Device Rules
• Worker Time Processing Profile.
• Defined Repeating Time Periods.
• Configured Web clock for Hourly employees.
• Conducted Users’ Training, Unit Testing, System Integration Testing & User Acceptance Testing.
• Production Support
• Project statement of work - Oracle Cloud Time and Labor:
• Based on the requirements gathered during the current and future Business Processes Flows analysis. These tasks were performed:
• Creation of Custom Time Attributes.
• Creation of both Single-Attribute and Multiple-Attribute Field Timecards for Hourly and Exempt employees respectively
• Time Entry Rules
• Worker Time Entry Setup Profiles.
• Time Calculation Rules.
• Time Device Rules
• Time Device Processing Profile.
• Created Nonrecurring Elements for Time Entries Procedure.
• Defined Repeating Time Periods.
• Configured and Web clock.
• Conducted Users’ Training, Unit Testing, System Integration Testing & User Acceptance Testing

Confidential, Palatine, IL

Lead Consultant

Responsibilities:

• Implementation of Oracle EBS HRMS, enhancement to Oracle Advanced Benefits, processed enrollments, setup of Affordable Care Act, Users’ Support and Maintenance.
• Project statement of work:
• Performed changes to Oracle Advanced Benefits, Self-Service HR & Compensation Workbench Programs.
• Working/resolving day-to-day Payroll, HR, & Benefits issues.
• Enabled Full Configuration of Oracle Absence Management.
• Implemented, setup and configured Oracle Compensation Workbench

Confidential

Lead Consultant

Responsibilities:

• Oracle HR, Talent Management and Absence Management
• Implementation.
• Oracle Core HR
• Setup Organization Hierarchy for HR Organizations with roll up into Sections, Sub Sections, Job Families
• Oracle Talent Management
• Conducted workshops and interviews for requirements in implementing Competency Management in Oracle.
• Setup and configure Talent Management
• Captured reporting requirements and created functional specifications for development of reports
• Conducted CRP and UAT workshops with the users and created issues logs
• Tracked and resolved CRP and UAT issues.
• Configured and setup Component Plans for Canada, US and UK Business Groups.
• Had Onshore and Offshore Interaction.

Confidential, Waukegan, Illinois

Lead Consultant

Responsibilities:

• Oracle HR/Absence Management & Oracle Time and Labor Implementation.
• Oracle Core HR
• Migration of acquired companies/employees into the parent company by way of New Business Groups (Canada & China).
• Setup/creation of locations, companies and assignments in the new business groups.
• Implemented Oracle time and labor R12.1.3
• Had Onshore and Offshore Interaction.

Confidential

Senior Oracle Fusion HCM Consultant

Responsibilities:

• Implementation of Fusion HR, Performance Management, Payroll and Absence Management.
• Release 7 ver. 11.1.7
• Oracle Fusion HR
• Enabled HCM Coexistence and integrated existing EBS Applications with hosted Oracle Fusion HCM.
• Created HCM Data Roles.
• Assigned HCM Security Profiles to the created HCM Data Roles.
• Setup Legislative Data Group
• Oracle Fusion Payroll
• Created both earnings and deductions elements.
• Configured Cost Allocation Key Flexfield Structure.
• Defined Costing Levels for Costing processes.
• Used Payroll Batch Loader to load payment methods, bank details and tax details from EBS HCM to Fusion HCM.
• Defined Payroll definitions.
• Oracle Fusion Time and Labor
• Defined Time Entry Configuration.
• Defined Time Rules.
• Defined Time and Labor Setup Profiles.
• Configured Oracle Fusion Absence Management with Oracle Fusion Time and Labor, thereby enabling workers to report absences and view accrual balances on the timecard

Confidential, Houston, TX

Senior Principal Oracle HRMS Consultant

Responsibilities:

• Implementation Oracle Fusion HR, Fusion Payroll Interface (R7 ver.11.1.7)
• Performance & Goal Management and EBS Advanced Benefits (R12.1.3).
• Oracle Fusion HR:
• Enabled HCM Coexistence and integrated existing EBS Applications with hosted Oracle Fusion HCM.
• Created HCM Data Roles.
• Assigned HCM Security Profiles to the created HCM Data Roles.
• Setup Legislative Data Group
• EBS Advanced Benefits (This is an enhancement to existing OAB System).
• Refined existing Coverage Restrictions cum Benefit and option Restrictions.
• Created new Plans and Options.
• Created new Life Events.
• Had Onshore and Offshore Interaction.

Confidential, Northbrook, IL

Senior Principal Oracle HRMS Consultant

Responsibilities:

• Implementation of Oracle Time & Labor
• Release 12.1.3
• Oracle HR
• Migration of acquired companies/employees into the parent company by way of
• New Business Groups (Canada & China).
• Setup/creation of locations, companies and assignments in the new business groups.
• Oracle Time and Labor
• Configuration and Setup Oracle Time and Labor R.12.1.3
• Configuration of Project and Payroll Timecard & Payroll Timecard Layouts.
• Implementation, configuration of Contingent Worker Timecard Layout to include Project fields.
• Modification of Timecard LDT Layouts to reflect new fields.
• EBS Compensation Workbench
• Created Global Combination Plans.
• Had Onshore and Offshore Interaction.

Confidential, Warrenville, IL

Senior Principal Oracle HRMS Consultant

Responsibilities:

• Implementation of Oracle HR, Oracle Time& Labor, Payroll, SSHR & OAB.
• Oracle HR Setups
• Client acquired three companies in both US and Canada.
• New Business Group was created for Canada.
• Setup and configured the HR Module for migrating the new acquired companies’ employees into Oracle.
• Created Locations.
• Created Organizations, grades, jobs and positions. Also Key Flexfields etc.
• Oracle Payroll
• Defined Cost Allocation Key Flexfield Segments.
• Defined Personal Analysis Key Flexfield Value Sets and Values.
• Defined People Group Key Flexfield Structures.
• Defined GRE/Legal Entity for Payroll. Created Salary Basis.
• Oracle Learning Management
• Defined descriptive flexfields
• Defined Currencies and Lookups.
• Defined Courses and Resource Structures
• Created Class and Enrollment Management
• Defined Enrollment and Class Status Types
• Setup Content and Content Servers
• Defined Finance Headers & Lines, and Pricing for Courses
• Created Reports. Letters and Configurable Folders
• Setup Menu, Enrollment and User Profiles
• Setup Self Service Class Enrollment
• Conducted Train the Trainers Sessions.

Confidential

Oracle Time & Labor Lead Consultant

Responsibilities:

• Implementation of Oracle HR, Oracle Time and Labor. R.12.1.3
• Migration/Upgrade from Oracle release 12.0.04 to R.12.1.3
• Setup all required Oracle HR objects needed for the implementation of Oracle Time and Labor.

Confidential, Oakland, CA

Team Lead

Responsibilities:

• Implementation of Oracle HR, Oracle Payroll & Oracle Time and Labor. R.12.
• Oracle Time and Labor -
• Conducted interviews to know the current process, and gathered requirements for future business process.
• Performed Fit and gap analysis, and workaround for gaps for provided and approved by the client.
• Implementation, configuration & customization of Timekeeper Timecard Layout to include Payroll, Project and Eam fields.
• Defined Cost Allocation Flexfield.
• Define Consolidation set.
• Defined Payment Methods.
• Defined Payrolls for both exempt and non-exempt employees.
• Defined required Payroll elements.
• Setup all statutory deductions.
• Configured and setup Taxability Rules.
• Defined Payroll Balances and uploaded initial balances.
• Had Onshore and Offshore Interaction.

Confidential

Team Lead

Responsibilities:

• Oracle HR: Defined Menus, Report Security Groups and created Users/Responsibilities.
• Setup User Profile Options.
• Defined and created other objects needed for the configuration of OTL.
• Oracle Payroll
• Defined Cost Allocation Flexfield.
• Defined Payment Methods and Payrolls.
• Defined Elements and Input Values.
• Setup Earnings and Deductions for Payroll Processing.
• Configured and setup Taxability Rules. And Defined Payroll Balances.
• Oracle Learning Management
• Defined descriptive flexfields
• Defined Currencies and Lookups.
• Defined Courses and Resource Structures
• Created Class and Enrollment Management
• Defined Enrollment and Class Status Types
• Setup Content and Content Servers
• Defined Finance Headers & Lines, and Pricing for Courses
• Created Reports. Letters and Configurable Folders
• Setup Menu, Enrollment and User Profiles
• Setup Self Service Class Enrollment
• Conducted Train the Trainers Sessions.

Confidential, Middleville, MI

Functional Consultant

Responsibilities:

• Implemented Oracle Payroll and OTL.
• Oracle HR
• Defined Job, Grade, Competence, People Group Key Flexfields and associated Value Sets.
• Created jobs, grades and grouped employees into different groups using People Groups Key Flexfield.
• Used Descriptive Key Flexfields, Extra and Special Information Types to accommodate other employees’ information.
• Oracle Payroll
• Defined Payment Methods.
• Defined Consolidation Set
• Defined Cost Allocation KFF
• Created Payrolls.
• Created Salary Basis.
• Defined Rates and Salaries
• Created Elements.
• Tweaked Fast Formulas.
• Balance Conversion

Confidential

Functional Consultant

Responsibilities:

• This is an add-on project- Client had OTL in place with only Projects Timecard.
• Client decided to turn-on EAM Timecard and Talent Management, with emphasis on Performance Management.
• Conducted requirements gathering/interviews to know what the client wanted to accomplish with EAM Timecard.
• I used most of the structures already defined in the system to setup and configure the EAM Timecard.
• Defined new Branch of Preferences for the EAM Timecard.
• Created Eligibility Criteria using the People Key Flexfield.
• Documented the setups and configurations in the BR100.
• Created Test Scripts and Training Materials for the users.
• Conducted Training sessions.
• Created Approvals using AME Oracle Approval Management
• Structured and defined Competence Key Flexfield.
• Defined competencies and Suitability Matching.
• Defined Rating Scales and Proficiency Levels.
• Setup Competence Requirements.
• Defined Appraisals.
• Created templates for different Appraisals.
• Created Assessment Templates, Rating Methods and Assessment.
• Created Succession Plans.
• Created Performance Management Plan, which consists of defined Objectives.
• Defined Objective-setting and Objective-tracking processes.
• Defined Appraisal-management processes.
• Created personal scorecard of Objectives.
• Defined Cost Allocation Flexfield.
• Defined Payment Methods and Payrolls.
• Defined Elements and Input Values.
• Setup Earnings and Deductions for Payroll Processing.
• Configured and setup Taxability Rules.
• Defined Payroll Balances.
• Created and Tweaked FastFormulas.
• Setup Absence Management/PTO Accruals.
• Trained End-users on Payroll Processing.

Confidential

Functional Consultant

Responsibilities:

• Conducted requirements gathering, with follow up Fit & Gap Analysis document.
• Created Time structures (Recurring Time Periods, Approval Periods, Retrieval Rules, Time Categories, Approval Styles, Alternate Names, Preferences, etc.) and Time Management Policies (Holiday Calendars, Shifts, Work Plans, Rotation Plans, Earning Groups, Shift Differential Policies, Premium Eligibility Policies and Earning Policies).
• Configured & Customized Timecard Layouts.
• Conducted Training of employees on Timecard Entry and Approval.
• Defined Preferences.
• Created Alternate Names.
• Defined OTL Element Sets.
• Used the AK Developer to create new fields in the Timecard Layouts.
• Created Time Entry Rules.
• Defined Accrual Balance on the Timecard.
• Created BR100 that contains all the setups and configurations in the production Instance, also the Fit and Gap Analysis document.
• Used AME to create to create approval chains.
• Defined Cost Allocation Flexfield.
• Defined Payment Methods and Payrolls.
• Defined Elements and Input Values.
• Setup Earnings and Deductions for Payroll Processing.
• Configured and setup Taxability Rules.
• Defined Payroll Balances.
• Created and Tweaked FastFormulas.
• Setup Absence Management/PTO Accruals.
• Trained End-users on Payroll Processing.

Confidential, Vienna, Virginia

Functional Consultant

Responsibilities:

• Being a fresh implementation, I did the requirement gathering, business analysis, Fit & Gap analysis (Mapping the requirements to Oracle Functionality).
• Carried out several training sessions with the SME’s.
• Conducted CRP, Integrated Testing & User’s Acceptance Testing.
• Documented all set ups and configuration in the BR100.
• Produced the CV40 for Data Conversion from SAP to Oracle.
• Support the system after going Life.
• Setup Competence Requirements.
• Defined Appraisals.
• Created templates for different Appraisals.
• Created Assessment Templates, Rating Methods and Assessment.
• Created Succession Plans.
• Created Performance Management Plan, which consists of defined Objectives.
• Defined Objective-setting and Objective-tracking processes.
• Defined Appraisal-management processes.
• Created personal scorecard of Objectives.
• The SME being new to iRecruitment, I did overview sessions to acquaint them to the available functions in the application.
• Conducted interviews to know the current recruitment process and how to accommodate most of the manual tasks in the new application.
• With the Fit & Gap Analysis done, workaround for the gaps finalized, the initial setups and configurations for CRP1 & 2, and Training sessions were done.
• For this implementation, part of the requirements was the configuration and definition of both seeded and custom menus/responsibilities.
• Prepared the Functional specifications for iRecruitment interface with Third party recruiting sites.
• The seeded sites (External and Employee Visitor Sites) were setup and configured for job seekers and employees logging in outside the organization’s network.
• For the client’s recruitment/staffing agencies, the iRecruitment Agency responsibility was setup and configured so that they the agencies could see vacancies in real time, and use this functionality to apply for their candidates.
• Did system integration and user acceptance testing. Recruitment process was initiated from creating a Vacancy to Hire in the Core HR.
• Surveys, Tests and questionnaires for candidates’ screening were created with the Assessment functionality provided by Oracle iRecruitment.
• AME Oracle Approval Management was used for approval chains.
• The Personalization Framework functionality was used for changes to some of the web pages, including replacement of Oracle logo with that of the client.
• Client declined the use of seeded Offer Letter. For this reason, l created custom offer letters with the XML Publisher responsibility.
• Prepared the BR100, which contained the configurations and setups done in the final instance.
• For the client to see and experience the functions available in both Manager and Employee Self Service I did a demo of the applications backed with PowerPoint presentation.
• Interviews and group discussions were held with the Subject Matter Experts (the Super Users, sometimes call SMEs) of the functionality of both manages and employees.
• Created User menus and custom Self Service responsibilities.
• Apart from the use of Supervisor Approval Hierarchy, whereby transactions initiated by reporting staff are approved by their supervisors, AME (Oracle Approval Management) was used to create custom Approval Flows.
• I used the personalization Framework to disabled unwanted fields and changed the Oracle logo with that of the client.
• Defined all required Profile Options.
• Configured the Person Search screens.
• Link both seeded and custom responsibilities to Security Profiles.
• Defined client Email Address.

Confidential

Functional Consultant

Responsibilities:

• Client outsourced Benefits Management to ADP.
• Data Mapping from Oracle Payroll to ADP Census File.
• Creating Descriptive Flexfields in Oracle Payroll to accommodate gaps (Data from ADP, needed in Oracle Payroll, but with no matching fields).
• Worked on elements’ fast formula
• Created MD.050 and CV.040, which help the technical consultants in creating the Procedures (PL/SQL Packages) to load data into the staging table.
• Reconfigured the costing for all employees to reflect combined assignments.
• Mapped the ADP Payroll file, which consists of employee’s benefits deductions into Oracle Payroll.
• Wrote the MD.50 for changes to the Oracle Payroll interface to Banner GL.
• Reconfigured the Cost Allocation Key Flexfield to reflect a new segment.
• Wrote the BR100 to reflect all changes to the initial setups.