Michael Martin
Summary
Around 10+ years of experience in IT industry- design, development, implementation, testing of web applications and enterprise resource planning (ERP), which includes 8+ years of extensive experience in Oracle Fusion HCM applications in implementation, support and upgrade of Oracle HCM Cloud and Oracle Applications. Expertise in configuring Oracle Fusion Applications in modules: Core HR, Benefits, OTL and Payroll. Extensive hands-on experience in Oracle Fusion HCM cloud in SAAS implementation projects, PeopleSoft 9.0, upgrading Oracle Fusion HCM. Expertise in designing the data loading strategy and data integration (transactional data) by HDL/HSDL. Preparing design, mapping documents and HDL/HSDL templates for Fusion Applications. Hands on experience in conversion/migration, co-existence projects with Fusion HCM using HCM Data Loader Tool and legacy File Based Loader (FBL) tool. Strong experience in building complex HCM extracts/Interfaces in Payroll, Benefits and HR to build interfaces like benefits vendors, ADP Payroll, team locator. Expertise in developing complex custom reports, analysis, dashboards, alerts using Business Intelligence Publisher (BIP) and Oracle Transactional Business Intelligence OTBI. Managed onboarding and offboarding payroll adjustments through Paycom’s HR and payroll OIC integration Creating, maintaining, and troubleshooting Fast Formulas for Core HR, Benefits and Payroll. Built custom security for Oracle HCM Cloud which includes create/modify data roles and its security profiles, job roles, application roles and duty roles. Utilized SOAP and REST web services for real-time data synchronization between Oracle HCM and external systems. Aligned complex technology systems and processes with global regulatory standards, requirements, and methodologies, such as Sarbanes Oxley (SOX) Compliance, PII, GDPR, PCI Security Standards, SDLC, Oracle AIM/OUM, Agile and Waterfall.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Oracle Cloud HCM Solution Architect
Los Alamos National Laboratory
07.2022 - Current
- Implemented rapid HCM implementation of coexistence conversion processes, configuration setup including Payroll Fast Formula, data mapping, security roles, privileges, provisions, HDL loading and performance module setup for the client.
- Implemented Redwood using VBS for HCM and Supply Chain.
- Generated HCM Spreadsheet Data Loader spreadsheets and use for bulk-load data from on-perm into the Oracle HCM Cloud.
- Hands-on experience in data conversion/migration or co-existence projects with Fusion HCM using HCM Data Loader Tool which includes the workforce structure data, worker data, and relationships.
- Expertise in designing the data loading strategy and data integration (transactional data) by HDL.
- Integrated Oracle EBS R12 with SAP Cloud Ariba to import Procurement data into Oracle.
- Implemented OIC and Integration Cloud Service (OCI) for file-based integrations using Universal Content Management (UCM) Webservices for Oracle HCM Cloud integration.
- Applied supplier invoices on each relevant Purchase Order (Contract) and calculated different fields including Contract Amount, Spent Amount and Available (Remaining) Amount.
- Build Custom Security to Fusion HCM which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles at OIM.
Oracle Cloud HCM Solution Architect
Chick-fil-A
10.2020 - 07.2022
- Delivered ongoing support and enhancements for Oracle Fusion HCM modules including Core HR/Global HR, Absence Management, Payroll Management, Talent Management and Benefits.
- Involved in Payroll Setup and defining Elements, Element sets, Assignment sets, Consolidation set and Element Links.
- Manage HCM year-end payroll processing and reconciliation ran trial year-end process to validate results, reviewed legislative announcements and configured employee calculation cards.
- Created OIC integration to execute the custom BI Publisher report as a service by passing Data range for a particular PVO to validate the records.
- Developed and debugged DBI CMP_ASSIGNMENT_SALARY_ANNUAL_AMOUNT for Payroll Fast Formula.
- Manage HCM BICC jobs and migrated jobs to SaaS Object Storage bucket where Object Storage Bucket event will invoke the Oracle Function based on the Event rules defined.
- Created HCM Data Extracts (HCM Extracts) to automate HR and payroll data retrieval, reducing manual efforts and enhancing operational efficiency which helps in Integrating Oracle HCM system with different vendors.
- Manage Cloud File Based Data Import (FBDI) from Oracle EBS into SaaS cloud, wrote SQL queries to validate data, Used Data Loader in the Data Exchange work area to supply data to be bulk loaded into Oracle SaaS Cloud.
- Developed HCM Extracts/OBI Reports/OTBI Analytics for Global HR, Payroll, Taleo, Benefits & Performance modules.
Oracle Cloud HCM Solution Architect
Cleveland Clinic Hospital
03.2020 - 10.2020
- Oracle ERP cloud Financials implementation offerings included workforce deployment (Global HR, Payroll), workforce development (Talent/Performance/Goal/Management) and Compensation Management (Compensation and Benefits).
- Developed BIP reports in Benefits, HR and Payroll area and developed HCM Extracts for various interfaces and customize out of the box OTBI and BIP reports to match clients reporting specifications.
- Provided roadmap document, executive summary and strategy for upgrade to current release for two modules, Absence Management and Time and Labor.
- Involved in building Payroll ADP extract to pick employee data from HCM and pass it to ADP vendor for payroll processing.
- Created HCM Fast Formula to Calculate payrolls, Define the rules for paid time off accrual plans and Define custom calculations for benefits administration.
- Develop daily and weekly OTBI reports & Dashboards for various Financial related metric like employee headcount, terminations, salary changes, department changes, Band changes & etc.
- Implemented OCI and Integration Cloud Service (OCI) for file-based integrations using Universal Content Management (UCM) Webservices for Oracle HCM Cloud integration.
- Developed Cloud File Based Data Import (FBDI) and OIC extracts from Lawson into SaaS cloud.
- Designed end-to-end HCM solution which includes Plans, Components, Worksheets, Fast formulas, eligibility profiles, use cases, Security roles, OTBI reports and Statements.
Oracle Cloud HCM Solution Architect
University of Indiana Medical Health
01.2019 - 03.2020
- Lead implementer for moving Lawson 9 to Oracle Cloud R13 Cloud environment, Define and implement enterprise structures, ledgers, business units, and reference data sets.
- Configure and Migrate data into Oracle Fusion Payables, Fusion Receivables complete understanding of Oracle Fusion Cash Management.
- Manage Financials Extract using DBIs, criteria and connections required between UEs, identified the UEs, DBIs, work out hierarchy linkage application pass data into XML for reporting using BIP.
- Manage Cloud File Based Data Import (FBDI) from Lawson into Saas cloud, queries to validate data from source to target. Also validated data from OTBI back to FBDI.
- Team lead using CASB Cloud Service to set up Oracle Identity Cloud Service as an identity provider (SSO) single sign-on, Setup specific users to be excluded from OTBI, BIP reporting.
- Manage Financial lineage from Lawson source tables using Rel13_HCM_OTBI_Database_Mapping excel to map Financial PVO to OTBI Subject Area for report validation.
- Developed Financial Extracts for Global HCM Payroll, using OCI, SOAP, REST API.
- Extensively used Security Console to Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
- Developed BIP reports in Benefits, HR and Payroll area and developed HCM Extracts for various interfaces and customize out of the box OTBI and BIP reports to match clients reporting specifications.
Oracle Cloud HCM Solution Architect
Pioneer Natural Resources
02.2018 - 12.2018
- Implementation of Oracle Fusion HCM using offerings like Workforce Deployment (Global HR, Payroll), Workforce Development (Talent Management, Performance Management, and Global HCM) and Compensation Management (Compensation and Benefits) in version R8 to R11.
- Involved in Configuration workshops for HR, Absence, Benefits and Compensation. Gathered the requirements from business and involved in Configuring and testing the setup with the latest release.
- Involved in the Data Loading/Conversions using HCM Data loader (HDL) and Spreadsheet Loaders which includes Workforce structure data, Worker data, Contracts data, and Work Relationships data.
- Managed various functional payroll initiatives and participation in corporate projects affecting payroll.
- Developed HCM REST API for flex field operations for Improvements on atom framework, Time Events, Purge and archive support.
- Migrated HCM data from source applications in OIC using components, adapters, connections, data mappings, look-ups, pre-built integration / orchestration.
Oracle Cloud HCM Solution Architect
Land’s End
01.2017 - 02.2018
- Part of team to implement Oracle Fusion Financials in the Cloud Rel 13 including Setups and Configuration for the following Modules: Payables, Receivables (OTC), Fixed Assets, Cash Management for multiple bank accounts, General Ledger and Oracle's new OTBI and FRS (Financial Reporting Studio).
- Developed USA and Canada payroll for HCM Cloud, configured and designed Oracle Payroll Costing with GL integration.
- Responsible for Time & Labor related data mapping, conversion validation, configuration, functional design and testing of the system.
- Implement Oracle HCM Cloud Payroll Interface and developed integrations from HCM Cloud using OIC to a third-party vendor for both outbound and inbound files.
- Worked on Development of Fusion Cloud BIP and OTBI reports using different methodologies also mapping lineage from Subject Area to PVO and Base tables for accurate report development, wrote many BIP SQL queries, RTF template etc., created custom BIP reports for Financials/ SCM/HCM.
- Involved in creation of Custom Security for Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
- Responsible for HCM System maintenance including security, tax updates and patches, setup and configuration of PeopleSoft foundation/transaction tables, including Payroll tables, Benefit tables, and Time and Attendance data.
Oracle Cloud HCM Solution Architect
Snap-on
07.2016 - 01.2017
- Oracle Fusion HCM Cloud responsible for Implementation Support / Configuration of Oracle Fusion HCM Global Payroll, Absence, Performance Management and Workforce Modeling modules.
- Performed Fit Gap analysis for Oracle Cloud PAAS Solution for Oracle ERP, Configure OBIA Oracle Cloud Applications to meet client requirements and document application set-ups.
- Gather Core HR (Enterprise), Compensation, Absence business requirements (BRD) and map them to Oracle HCM Cloud functionality.
- Developed OTBI and BIP reports in Oracle Fusion Cloud and scheduled the reports with to be delivered to Email and FTP sites.
- Complete Life Cycle (Gathering Business Requirements, GAPS Analysis, identifying & analyzing the source/feeder systems, Design & Data Modeling, Development, and Testing) implementation experience of Enterprise Business Intelligence (EBI) using Oracle BI.
- Implemented Data Loading/Conversions using HCM Data loader (HDL), which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
- Assisted functional consultants to identify and resolve day-to-day issues raised during payroll Parallels and Production.
Oracle Cloud ERP Solution Architect
U.S Air Force/DEAMS Project
01.2015 - 07.2016
- Completed end to end Fusion HCM Core HR setups like Legal Entities, Business Units, Locations, Grades, Grade Ladder, Jobs and Position, Profile Management etc.
- Architected and implemented Oracle Analytics Cloud (OAC) solution and migrated analytics from on-prem PeopleSoft to OAC.
- Worked on POV lineage using Oracle BI Cloud Service (BICS) with Remote Data Connector to use on-prem data for BICS.
- Design architectural functional including technical documentation for Oracle ERP Reporting & Business Intelligence technologies, HCM BIP reports.
- Designed ETL architecture for Air Force DEAMS project, including agents, scenarios, packages, data mapping, data extractions, transformations and validations.
- Used OCI for Reverse engineering to retrieve metadata from data storage and load it to the repository.
- Customize OTBI Repository (Physical, business and presentation layer) to provide Analytical Reporting solutions for Air Force DEAMS project.
- Created BRD documentation along with various HCM workflow diagrams and functional diagram for business process on MS Visio to provide a deeper understanding of the various HCM systems involved.
Oracle Cloud ERP Solution Architect
ADT
03.2014 - 03.2014
- One Man install and implementation OBIA 11.1.1.9.1 including Financials and HCM and using ODI 11g to move data from source to target, preformed all function setup using OBIA configuration manager for Financials and HCM.
- Provided technical support 24x7 for the database and application activities in Production, Development environments that includes design, installation, implementation, operation and maintenance of Oracle 11g RDBMS and Oracle Applications 11.5.10.2 and 12.2.3.
- Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Hyperion Planning, Essbase, Relational Database.
- Implemented the install and configuration on of BPEL and SOA based applications.
- Develop data extracts from data warehouse environment using ODI and Implemented Journalizing Knowledge Module JKM for integration into Golden Gate.
- Installed, configured OBIEE 12c and supported users' adhoc queries, participated in hardware planning for all 4 environments.
- Designed OBIA RPD to provide Analytical Reporting solutions to business, also Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, as related to business needs.
ERP Applications Administrator
Walgreens Corporation
10.2013 - 03.2014
- Responsible for Oracle Fusion HCM configuration and support for core HR, Performance management, Goal management and Talent Review.
- Hands-on configuration working with functional set up manager across Oracle HCM Cloud modules.
- Helped and supported new HR end users, to maintain the employee's information effectively in Oracle HCM Cloud application.
- Involved in building Payroll ADP extract to pick employee data from HCM and pass it to ADP vendor for payroll processing.
- Accomplished Manage Enterprise HCM Info and Legal Entity HCM Information to set work hours and group people for organization using flex fields.
- Manage in data conversion effort to facilitate good quality of data from Oracle EBS to Oracle Fusion HCM.
- Created Oracle HCM Cloud privileges which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
- Developed OTBI reports, Payroll Extracts, HCM Extracts to feed the information from all third-party systems and Walgreens downstream systems.
Oracle Developer
University of Miami
05.2012 - 10.2013
- Installation and configuration of the complete Analytics platform environment OBIA 7.9.6.4 later migrating to OBIA 11.1.1.7.1 install required ODI connectivity for seamless integration into the 11g Data Warehouse.
- Developed custom OBIEE dashboards and BI publisher reports from 3th party database source including RPD development.
- Created OBIEE/RPD Dimension Hierarchies to achieve the drill down functionality as per Business Requirements.
- Integrated data from Finance and other enterprise systems and transformed data using ODI (ELT).
- Successfully Implemented Oracle HR Analytics and created separate execution plans for the daily refresh of the Data Warehouse.
- Setup OBIEE 11.1.1.7.1 security roles and groups with integration into external directory Active Directory and OIM, including SSO.
Education
Computer Science -
Southern Illinois University
Skills
- Oracle SaaS Cloud
- Oracle EBS
- Oracle ERP
- Oracle Financial Cloud
- Oracle HCM
- Oracle OIC
- Oracle FCCS
- Oracle EDMCS
- OTBI
- OBIEE
- BIP
- ESS
- Oracle Security Module
- Comptia security
Certification
- Oracle Cloud Platform Applications Certified Specialist
- (DOD) Security Clearance
<Enter your own>
Title: HCM Cloud Consultant
Timeline
Oracle Cloud HCM Solution Architect
Los Alamos National Laboratory
07.2022 - Current
Oracle Cloud HCM Solution Architect
Chick-fil-A
10.2020 - 07.2022
Oracle Cloud HCM Solution Architect
Cleveland Clinic Hospital
03.2020 - 10.2020
Oracle Cloud HCM Solution Architect
University of Indiana Medical Health
01.2019 - 03.2020
Oracle Cloud HCM Solution Architect
Pioneer Natural Resources
02.2018 - 12.2018
Oracle Cloud HCM Solution Architect
Land’s End
01.2017 - 02.2018
Oracle Cloud HCM Solution Architect
Snap-on
07.2016 - 01.2017
Oracle Cloud ERP Solution Architect
U.S Air Force/DEAMS Project
01.2015 - 07.2016
Oracle Cloud ERP Solution Architect
ADT
03.2014 - 03.2014
ERP Applications Administrator
Walgreens Corporation
10.2013 - 03.2014
Oracle Developer
University of Miami
05.2012 - 10.2013
Computer Science -
Southern Illinois University
Similar Profiles
GERALDO MENDEZGERALDO MENDEZ
Fire Protection Specialist Level 3 / Engineer Team Lead at Los Alamos National LaboratoryFire Protection Specialist Level 3 / Engineer Team Lead at Los Alamos National Laboratory
LEAH DIAZLEAH DIAZ
Administrative Assistant at Los Alamos National LaboratoryAdministrative Assistant at Los Alamos National Laboratory
Dylan BranumDylan Branum
Radiation Control Technician at Los Alamos National LaboratoryRadiation Control Technician at Los Alamos National Laboratory
Isaiah MaestasIsaiah Maestas
Nuclear and Hazardous Materials Technician 2 at Los Alamos National LaboratoryNuclear and Hazardous Materials Technician 2 at Los Alamos National Laboratory
EVAN RATHODEVAN RATHOD
Solution Architect - Oracle HCM at SofigateSolution Architect - Oracle HCM at Sofigate