Oracle Techno-functional Consultant Resume
Castle Rock, CO
TECHNICAL SKILLS
Oracle Service Line Experience: Implement Oracle HCM (Payroll and Human Resources emphasis), SSHR, OAB, OTL, iRecruitment, Payables, Purchasing, Projects, General Ledger, Receivables, Workflow and Web Applications.
Oracle Applications Experience: Human Resources, Payroll, SSHR, OAB, OTL, iRecruitment, Payables, Receivables, General Ledger, Projects, Web Applications, Workflow, Purchasing
Oracle Tools Experience: SQL, PL/SQL, Discover, Developer, SQL*Forms, SQL*Reports writer, SQL*Loader, PL/SQL Developer and TOAD
Oracle Software Experience: RDBMS
Languages: C, Pascal, COBOL, SQL, PL/SQL, Pro*C, PERL & Shell Script
Operating System Experience: Unix, Solaris, Dos, Windows & Linux
PROFESSIONAL EXPERIENCE
Confidential, Castle Rock, CO
Oracle Techno - functional Consultant
Responsibilities:
- Benefits Open enrollment for the School Year.
- Salary appraisals, Grades and Tracks updates.
- Yearly Salary Band updates and moved the existing bands to SIT’s for future reference.
- PTO Accrual Balance Transfer and Current Year PTO Balances.
- Payroll Year-end, Balance adjustments and Production support.
- Resolved Taleo to HR Interface issues.
- Overlap Position Setup and bypass existing Budget approval on Position transactions.
- Resolved outstanding Garnishment element issues.
- Resolved Pre Tax 457 Catch-up element issue, and Setup new Elements and modified Fast Formulas.
- Designed and develop Benefit Third party Interfaces.
- Resolved Kronos issues.
- Time to time Cora Reports.
- Daily and Weekly scrum meetings.
- Production Support.
Confidential
Oracle Techno-functional Consultant for HRMS, OTL and OAB
Responsibilities:
- Gather business requirements for Payroll and OAB conversions.
- Resolved OAB and Payroll Accrual conversions issues.
- Legacy to Oracle elements mapping.
- Setup elements and modified Payroll Fast formulas.
- Defined custom regions for web time cards using AK Developer.
- Developed custom packages to migrate the AK Regions to the Repository.
- Modify Timekeeper templates to accommodate unique business requirements. Created custom Timecard views.
- Setup several OTL Time Entry Rule Fast Formulas, Created Fast formula functions and Setup OTL Preferences for Supervisor approvals.
- Modified Oracle Workflows for timecards escalation process based on Supervisor approval hierarchies.
- Production Support.
Confidential, Thousand Oaks, CA
Oracle HRMS Implementation
Responsibilities:
- Gather business requirements for the BPO implementation.
- HR, Payroll and OSB Data conversions including historical data.
- Develop several custom and ad-hoc reports.
- Modified workflows to meet the business requirements.
- Developed Third-party interfaces.
- Self Service HR to enter Time Entry for all Employees and time keepers
- Created Shifts, Holiday calendar, Overtime Rules, Rotation plans, and Rules for the Time entry, and successfully implemented Timecard Layouts and Timekeeper layouts.
Confidential, Louisville KY
Oracle HRMS acquisitions and Costing
Responsibilities:
- Gathered Project requirements for HR/Payroll Acquisitions
- Fit gap analysis on the initial balance mapping issues.
- Legacy to Oracle elements mapping.
- HR/Payroll conversions including Initial Balance loads.
- Provided various reports to validate the conversions before and after.
- Designed and developed Conversion Documentation
- Gather business requirements for Custom Costing Transfer to GL
- Designed and developed custom Oracle Payroll to GL Costing transfer
- Setup required EIT’s to calculate Costing accruals.
- Setup Elements to calculate custom Employee Funded benefits.
- Document all setups and training issues for knowledge transfer and future reference.