We provide IT Staff Augmentation Services!

Oracle Hcm Consultant Resume

Austin, TX

SUMMARY:

  • Over 16+ years of Oracle experience, with over 11 years Oracle Applications (EBS) and 6 years of FUSION HCM experience.
  • Implementation experience (both Functional and Technical) of Oracle Fusion HCM (including workflows and security) and Oracle Apps EBS HR modules.
  • 3 Oracle EBS HRMS implementations
  • 1 Oracle Fusion HCM implementation
  • With Confidential, my team completed this entirely in - house. We were one of the biggest implementations in the Confidential to use an implementation partner.
  • Experience in creating and maintaining Oracle EBS HR to Fusion HCM interface (Oracle’s Coexistence model).
  • Used to transfer HR data from EBS to Oracle Fusion HCM to keep HR data up-to-date for Talent Management, Goals and Performance Management modules.
  • ‘Interim’ solution before the company implemented Fusion HCM fully from EBS as the master HR system.
  • Experience on managing off-shore technical resources.

FUNCTIONAL CONSULTANT ON EBS MODULES:

  • HRMS
  • Employee Self Service
  • Manager Self Service
  • Technical consultant on EBS modules
  • HRMS
  • Benefits
  • Payroll
  • Advanced Benefits
  • Payroll
  • Comp Workbench
  • OTL.
  • Techno-functional on Oracle Fusion modules:
  • HCM
  • Talent Management
  • Goals
  • Performance Management
  • Compensation
  • Benefits
  • Extensive experience in Conversions both on Oracle EBS, HR and FUSION HCM applications. Includes use of EBS APIs, HCM Data Loader (HDL) and FBL for Fusion.
  • Deep experience on Workflows and Approvals:
  • EBS HR (including AME for Approvals)
  • Fusion HCM, Absence Management and Compensation (including building custom BI email templates to display ‘extra’ data for approval notifications
  • Expertise in the design and development of Reports.
  • BI Publisher (EBS)
  • BI Publisher, Analyses and Dashboards (Fusion)
  • Expertise on Fusion HCM Extract tool.
  • Designed, developed and implemented company payroll interface to 3rd Party system (ADP)
  • Expertise in Fast Formulas:
  • EBS Compensation Workbench, Payroll and Benefits
  • Fusion HCM Compensation, Benefits and Payroll (HCM Extract)
  • 16 years PL/SQL experience.
  • 16 years UNIX scripting experience.
  • Mainly end-to-end interfaces for EBS HR and Fusion interfaces
  • Experience in XML.
  • For example, automation project to schedule Oracle Fusion HCM BI reports to place XML files onto a UNIX ftp server
  • PL/SQL programs to upload XML data into a ‘data hub’ used for internal integrations
  • Excellent understanding of business process/logic and application setup.
  • Excellent communication skills.
  • Expertise in Gap/Fit Analysis, Preparing/writing Requirement Analysis, User Training and acceptance and Customization Documents using Oracle AIM for SDLC methodology.

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g

Languages: SQL, PL/SQL, UNIX shell scripting

ERP: Oracle Applications (Oracle HR 10.x to 12.1.6), Oracle Cloud FUSION HCM (Release 5 to 12), PeopleSoft Financials (v7.5), Some Oracle Financials (11i)

Modules: Oracle Cloud HCM, Benefits, Compensation, Goal Management, Talent Management, OIM, BPM (for approval workflows), APM (Security)

Oracle Applications HR: Core HR, Advanced Benefits, Self Service, Payroll, OTLCompensation Workbench

Oracle Applications Financials: AP, GL, iProcurement Oracle Applications Project, Taleo Recruiting

Reporting: Oracle BI Publisher (on Oracle Applications and FUSION), OTBI, Oracle Cloud DashboardsEIS, Discoverer, Taleo Dashboards

Interfaces: Oracle Applications HR (inbound and outbound), Oracle Cloud HCM Extracts (inbound and outbound)

Conversions: Oracle Applications HR APIs,, Oracle Cloud HDL and FBL

Workflow: Oracle Applications Workflow tool, AME, Oracle Cloud including BPM middleware tool for approvals routing

Other: Fast Formulas (Oracle Applications and Cloud), Security Roles (Cloud), Oracle Applications Express (Apex), Oracle EBS OTL setups including Time Entry Rules (TER)

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Oracle HCM Consultant

Responsibilities:

  • My role as Onboarding Lead is managing the project to use an existing 3rd party onboarding software (Silk Road “Red Carpet”) as the onboarding tool for creating new hire and rehire records on the Oracle cloud system.
  • This is an automated integration which will run hourly given the large numbers of new hires/rehires on any given day.
  • My role is to manage the project from analysis, design, development, SIT, UAT, to implementation (5/11/19).
  • Involves design and fit-gap analysis with functional groups, managing the project and communicating to upper management
  • Writing and sign-off of Functional (MD.050) and Technical (MD.070) specs
  • In addition, my technical expertise in Fusion HCM inbound integrations is being used to develop the module to load data using HDL.
  • I also manage 2 technical resources to develop the BPEL SOA orchestration of the end-to-end automated process.

Confidential

Cloud HCM Technical Lead

Responsibilities:

  • Technical lead for post-implementation of Global Oracle HCM implementation.
  • Creating framework to automate Global Transfers using HDL (at present, Oracle Cloud does not allow this to be done in batch form outside the UI)
  • Created proof of concept for transferring all person, assignment and payroll data to a new legal entity using HDL
  • Created the HDL scripts to be used
  • Technical lead for 1 big LE transfer.
  • Involved working with 5 developers, training and monitoring progress with PM
  • Goal achieved in transferring these skills to the NOV Oracle technical skills
  • Creation of Incentive Bonus Plan approval workflow
  • Project to create email notifications showing more information than Oracle Cloud normally provide
  • Involved requirement and gap-fit analysis on functional needs, technical design of new email templates (using transaction data BI reports), creating test scripts and coordinating testing and cutover to production tasks
  • Lead for identifying, creation and implementation of FUSION HCM role-based security/

Confidential

Sr IT Applications Specialist

Responsibilities:

  • Day to day support on technical issues such as reporting, security and integrations arising from go-live of Oracle FUSION HCM as HR system of records in July 2017.
  • Performed one of the technical lead roles on FUSION HCM implementation
  • (Implementation completed in-house without assistance from 3rd party integrators)
  • Design, development and testing of custom Fusion Payroll interface to ADP using Fusion HCM Extract tool.
  • Included development of Enterprise Architecture documentation and knowledge transfer to other team members
  • Developed complete architecture design, development and testing of Fusion Cloud to internal 'data hub' (oracle database stored on Unix platform).
  • Worked with internal teams to establish requirements
  • Developed enterprise architecture documentation for current and future state which was used in helping to develop mapping and requirements.
  • Automated process scheduled twice daily using a mixture of Fusion extracts to produce XML data files, UNIX shell script to sftp from Cloud Server to on-prem server. PL/SQL script to populate base tables on the hub Oracle database.
  • Custom views provide the integration to internal systems including company P-Card (Expenses), Employee assignment and job sync with Oracle Applications Financials system, Active Directory (AD) and integration to company ECM structures.
  • Created approval workflows using Fusion BPM Middleware, and FUSION simplified tool for various HR transactions including LOA and ICD plans.
  • Conversions using FUSION FBL and some HDL
  • Developed and enhanced reports from requirement documentation. Most reports using BI Publisher with appropriate security in place to control data and functionality based on data security roles.
  • Security - creation and modification of custom roles using FUSION APM and OIM (now integrated into the Security Console for R12). Creation of auto-provisioning rules to provide correct roles for new users.
  • Helped with configuration between Fusion and Taleo Recruiting system, specifically the sync of Taleo ‘network data’.
  • Reporting Rollout - delivery of Fusion HCM dashboards to company:
  • Worked through requirements with HR group on series of dashboards
  • Design and development of up to 10 dashboards in progress by the end of the year.
  • Inbound Interfaces
  • Recently completed proof of concept on end-to-end integration of external vendor interface file.
  • Perform FTP from vendor of file Upload to Fusion content Server
  • Web API call to custom Payroll batch loader process to transform file (using custom Fast Formula) and import into Fusion
  • Configuration of Fusion notifications to provide interface results to user (in progress)
  • Fostering discussions with my team on possible value-add of moving physical storage for our 'data hub' from on-premise to the Cloud.
  • Such discussions will provide insights to bring before management and other IT teams on the advantages / disadvantages for Newfield
  • Providing proof of concept of using Oracle Applications AME tool for Oracle Financials
  • Used previous experience to work with Finance team on using AME approval rules for AP invoices and also Purchase Requisitions
  • Work included converting current simple iProcurement rules to AME versions.
  • Lead for all Oracle Applications HR technical support and projects
  • Included internal integrations
  • Creation and maintenance of custom Apex applications for HR budgeting, charity donation maintenance, Talent Profiles, Employee phone book.
  • Creation and maintenance of 3rd party benefit interfaces
  • UNIX scripts to retrieve and back up vendor files
  • Oracle SQL Loader scripts to stage data
  • Oracle PL/SQL using API’s to import data into Oracle
  • Processes created as concurrent request sets, scheduled weekly.
  • Creation and maintenance of reports using BI Publisher, EIS and Oracle Reports
  • Implementation and maintenance of Oracle Applications to FUSION interface (co-existence model using HR2HR)
  • Managed off-shore technical resources for both EBS and FUSION issues.

Confidential, Austin, TX

HCM Solutions Architect

Responsibilities:

  • Sole Oracle HRMS technical resource responsible for all aspects of Oracle HRMS elements in each company project.
  • Involved working alongside the HRMS functional resource in estimation, design, documentation and testing along with performing all coding, unit testing and completion of migration processes.

Confidential, Houston

Solutions Architect

Responsibilities:

  • UNIX shell script for Payroll NACHA files
  • Involved creating UNIX script plus related concurrent program to run from Oracle Apps.
  • HR and Payroll reports
  • Creation of 17 HR and Payroll reports using Oracle Discoverer and XML

Confidential, Missouri

Solutions Architect/Production Support

Responsibilities:

  • Development of technical specification (MD070)
  • Development of migration specifications (MD120)
  • Creation of PL/SQL packages, procedures and concurrent programs
  • Complex use of both HR and Payroll data including balances
  • Used by Payroll department to establish 401K eligibility
  • Heavy use of Payroll balances
  • Production support for all HR/Payroll technical tickets
  • Troubleshooting all HRMS related functional and technical tickets
  • Recommendation of patches where necessary
  • Fixes to existing PL/SQL interfaces
  • Fixes to existing Discoverer reports
  • Fixes to existing PL/SQL reports

Confidential, Austin, TX

Functional Oracle HRMS Lead

Responsibilities:

  • Production support for all HR/Payroll technical tickets
  • Troubleshooting all HRMS related functional and technical tickets
  • Recommendation of patches where necessary
  • Fixes to existing PL/SQL interfaces
  • Fixes to existing Discoverer reports
  • Fixes to existing PL/SQL reports

Confidential, Austin, TX

Solutions Architect/Production Support

Responsibilities:

  • De-Facto Account Manager for Activant HRMS Support
  • Provided guidance and recommendations to Activant on how to get the most of their Oracle HRMS system
  • Lead for troubleshooting all Activant Oracle HRMS technical and functional production issues of the following types:
  • Workflow
  • Self Service (Employee, Manager)
  • PL/SQL and Noetix reports
  • PL/SQL 3rd Party (ADP ProBusiness) Outbound Interface

Confidential, Austin, TX

HR Conversion Technical Lead

Responsibilities:

  • Technical lead responsible for HR conversion of employees.
  • Created CV040 document
  • Created all PL/SQL conversion programs including all related concurrent programs
  • Worked with user functional resource on testing
  • Created migration instructions (MD120) and worked through the implementation and testing in each instance.

Confidential, Houston, TX

Implementation Lead Oracle HR Technical and Functional Resource

Responsibilities:

  • Technical/Functional Lead for PTO vacation setups and conversions for acquired Michael Baker company (1200 employees)
  • Created PTO setup for Vacation, Sick, Holiday balances
  • Created PL/SQL programs to convert existing balances
  • Technical/Functional Lead Employee Data conversions for Michael Baker
  • Worked with client on Requirements gathering including data mapping
  • Created technical documentation including migration documentation
  • Created PL/SQL programs and associated concurrent programs
  • Technical/Functional Lead Employee Data conversions for Hexagon Business Group (400 employees)
  • Worked with client on Requirements gathering including data mapping
  • Created technical documentation including migration documentation
  • Created PL/SQL programs and associated concurrent programs
  • Technical/Functional Lead Employee Data conversions for Confidential International employees (700 employees, 26 countries)
  • Worked with client on Requirements gathering including data mapping
  • Created technical documentation including migration documentation
  • Created PL/SQL programs and associated concurrent programs
  • Project Manager/Oracle HRMS Functional Lead for creation of Confidential
  • Involved creation of New (foreign) Business Group and subsequent British localization.
  • Worked as functional resource configuring Oracle HRMS as per requirements.
  • Created BR100
  • Completed from Design to Implementation in Production within 5 weeks (to time and budget).
  • Project Inbound 3rd Party Benefits Interface used as part of Open Enrolment and also as a weekly feed
  • Created UNIX shell script to move and back-up data files
  • Created PL/SQL programs to read data into stage and then into Oracle tables using APIs
  • Created all concurrent programs and request sets.
  • Lead Oracle HRMS resource for Core HR support tickets

Confidential, Dallas, TX

Technical RICE Lead, Oracle Projects Implementation

Responsibilities:

  • Oracle Projects implementation
  • Conversion of legacy system projects into Oracle Projects
  • Creation of technical (MD070) and migration documentation (MD120)
  • Created PL/SQL programs and related Concurrent Programs
  • Interfaces from legacy systems into Oracle Projects
  • Creation of technical (MD070) and migration documentation (MD120)
  • Created PL/SQL programs and related Concurrent Programs

Confidential, New Orleans, LA

Oracle HR/Payroll Consultant

Responsibilities:

  • Creation of Positive Pay and NACHA UNIX scripts
  • Creation 401k outbound interface
  • Worked with client to create functional design and requirements in a MD050
  • Created technical specification (MD070)
  • Created UNIX script to move extract and back up the data file
  • Created PL/SQL program to create extract as per vendor mapping requirements
  • Created all related concurrent programs
  • Created migration documentation using MD120.
  • Commissions outbound interface
  • Worked with client to create functional design and requirements in a MD050
  • Created technical specification (MD070)
  • Created UNIX script to move extract and back up the data file
  • Created PL/SQL program to create extract as per vendor mapping requirements
  • Created all related concurrent programs
  • Created migration documentation using MD120
  • Benefits outbound interface
  • Worked with client to create functional design and requirements in a MD050
  • Created technical specification (MD070)
  • Created UNIX script to move extract and back up the data file
  • Created PL/SQL program to create extract as per vendor mapping requirements
  • Created all related concurrent programs
  • Created migration documentation using MD120
  • Custom Payroll Reports
  • Creation of complex SQL
  • Creation of PL/SQL programs
  • Conversion of ADP data into Oracle HR
  • Worked with client on Requirements gathering including data mapping
  • Created technical documentation including migration documentation
  • Created PL/SQL programs and associated concurrent programs

Confidential, Austin, TX

Functional Oracle HRMS Consultant

Responsibilities:

  • GAP/FIT Analysis for all Oracle HRMS related projects for both US and Canadian company entities.
  • Requirements gathering
  • Creation of functional and technical specs using the Oracle AIM methodology
  • Lead role in providing both functional and technical recommendations
  • Functional configurations as needed to Core HR and Self Service for both US and Canadian business groups.
  • Implementation of custom Manager Self Service functions
  • Based on Seeded MSS functions but modified using Workflow builder and Personalizations as per requirements.
  • Lead for requirements gathering, mapping and technical development for full HR conversions of 3 acquisitions during my time with the company (both US and Canadian companies)
  • In each case as a techno-functional resource:
  • Performed requirements gathering including data mapping
  • Created related functional documents
  • Created technical documentation including migration documentation
  • Created PL/SQL programs and associated concurrent programs
  • Responsible for the creation/maintenance of all custom HR reports
  • PL/SQL reports
  • Noetix reports
  • Responsible for the creation/maintenance of all existing and new Inbound and Outbound interfaces
  • Included outbound payroll interface to ProBusiness ADP.
  • Performed requirements gathering
  • Created related functional documents
  • Created technical documentation including migration documentation
  • Created PL/SQL programs and associated concurrent programs

Confidential, Irving, TX

Lead Oracle HR Analyst

Responsibilities:

  • Oracle HR, Payroll and OAB implementation
  • Oracle Employee, Manager and OAB Self Service Implementation
  • Worked with users to create requirements for each of the 3 types of Self Service functions.
  • Created all Self Service functions as necessary
  • Worked with users on testing
  • Created configuration documentation
  • Created migration documentation on each self service definition
  • Payroll NACHA and Positive Pay outbound interfaces
  • Creation of function specification (MD050)
  • Creation of technical specification (MD070)
  • Creation of UNIX scripts
  • Creation of migration documentation (MD120)
  • Creation of UNIX Batch scripts
  • 401 Outbound interface
  • Requirements gathering documented in MD050
  • UNIX shell script creation to move data file
  • Creation of PL/SQL program to create extract file as per vendor’s specification
  • Working with users to tested
  • Creating of migration documentation (MD120)

Hire Now