Home

P Gong - HCM technical Consultant

[email protected]

Location: Remote, Remote, USA

Relocation: NO (Local to Dallas, TX)

Visa: H1B

Resume file: PG_Resume_HYR_1753717945802.doc Please check the file(s) for viruses. Files are checked manually and then made available for download.

P Gong [email protected] +1 (214) 444-9239 Overview: About 8 years of experience in design and development of Oracle cloud HCM fast formulas, reports (OTBI/BIP), and integrations (HCM Extracts, OIC) across Oracle cloud HCM (Core HR, Payroll, Benefits, Absence management and Oracle EBS HRMS suite and HR to HR coexistence with EBS and Fusion Cloud HCM 8+ years of proven hands-on experience in writing SQL/PLSQL across Oracle EBS HRMS and Oracle Cloud HCM and well versed with Oracle HCM underlaying base tables. Experienced with Oracle HCM BPM workflows and configured workflow BPM work lists for new hire, salary changes, benefits life even changes and promotions. Written fast formulas and used data base item, formula functions, custom SQL using value sets and used in fast formulas. Part of implementation of open enrollments of benefits and provided technical solutions including reports, integrations, and security. Experience in building new reports and troubleshooting the existing reports using Fusion reposting tool OTBI (Oracle Transactional Business Intelligence), BIP (custom RTF, e-text, XML templates) and HCM/Payroll/Benefits Extracts Developed major integrations between Kronos WFC/WFD and Oracle Cloud HCM integrations using HDL and web services using OIC and loaded timecard data to Oracle Payroll element entry values. Part of implementation of open enrollments of benefits and provided technical solutions including reports, integrations, and security. Experience in building new reports and troubleshooting the existing reports using Fusion reposting tool OTBI (Oracle Transactional Business Intelligence), BIP (custom RTF, e-text, XML templates) and HCM/Payroll/Benefits Extracts Well versed with Fast formulas, value sets and used HCM Extracts and BIP Extracts across core HR, Payroll and OAB Well familiar with fusion payroll reporting subject areas, job roles, customizing security by creating custom job roles and BIP secured list views. Expertise in designing compensation plans, eligibility profiles and Compensation Worksheet configuration as per the client requirement. Worked with payroll and core HR users and customize security by creating custom roles for BIP extracts. Extensively worked on HCM integrations, which includes research, design and develop HCM integrations including HDL, HCM Extracts, Web services using OIC Extensively worked on OTL/Absence management implementation, which includes understanding of OTL and Absence management implementation requirements and configuration of Absence types, categories, patterns, plans, reasons, and certifications and development of fast formulas as needed across OTL and Absence management including fast formulas for Absence types and Accrual Plan Rules (Global Absence Type Duration, Global Absence Entry Validation, Global Absence Plan Enrollment Start, Global Absence Ceiling and Global Absence Accrual).Extensively used OIC as part of file-based integrations and web services across Benefits, core HR and Payroll Worked as an HCM functional data integration expert and worked on designing and configuration of inbound and outbound interfaces with Oracle Taleo, ADP, Health care Providers and 401 financial institutions. Worked on building outbound interfaces using HCM extracts/ BIP extracts across Payroll and Talent management. Create custom data base items using balance dimensions for time/PTO balances and used them in the OTL/Absence fast formulas. Recent hands-on experience in PeopleSoft to Oracle Fusion Payroll conversions and involved in end-to-end implementation of Oracle Fusion Payroll including data extraction strategies from PeopleSoft to Fusion Payroll, configuration of Oracle Fusion payroll setups including Legislative Data Groups, Statutory Units, Legal Employers, and Tax Reporting Units, configuration of Payroll Fast Formulas, using data loaders like FBL, HDL, PBL and SSL and security profiles. Worked on troubleshooting and fixing Fast formula performance issues including replacing or removing database items in the formulas, which causing performance issues Proven hands-on experience in designing of Fusion HCM test plan, test case creation, running UAT/SIT, production cut over planning and defect management. Extensively worked Fusion HCM security modules and created various custom roles (data roles, functional roles, abstract roles) based on two-tier/ Three-tire employment model and based on customer HRMS security requirements. Involved in end-to-end testing of Fusion HCM including monthly payroll patch testing and new version upgrade testing. Designed and developed Fusion payroll outbound interface process using fusion global payroll interface and ADP Pay Force period extract. Participated in various open enrollment implementations and designed and developed various benefits interfaces, fast formulas, XML reports, OAF extensions, SSHR extensions, notification alerts using Oracle Alerts and AME configurations. Rock solid experience in design and development of HRMS data conversions including both inbound and outbound interfaces and well versed with APIS and underlying base tables. Good Expertise and implementation experience in Fusion HCM Offerings: Talent Management, Workforce Deployment (Core HR), Workforce Development (Goal Management, Performance Management, Talent Review and Succession), Absence Management, and Security. Proven hands-on experience in using various fusion data loader tools including FBL, HDL, PBL and SSL Experience includes full lifecycle implementations of Oracle Applications release 12 covering HRMS modules: Core HRMS, Absence Management & Self Service and HCM Fusion Implementation for Compensation Management, Workforce Deployment, Workforce Development, and Talent Management. Strong Knowledge on Fusion Functional Setup Manager. Excellent analytical skills in Analysis and business requirements gathering from end users to the client and experience in design using MD70 documents. Excel at translating business needs into application requirements. Assisting clients in the selection, implementation planning, fit/gap analysis, conference room pilots, configuration, testing, training, rollout and post-implementation support of Oracle Fusion HCM cloud/SaaS solutions at various customer sites Skill Set: Operating systems: Windows, NT/ XP, Linux, UNIX Fusion HCM Cloud: Oracle HCM Payroll, Workforce Deployment, Cloud Payroll Talent Management and Compensation Management and Security ERPs: Oracle Applications R-12, (HRMS, HR, OAB, Payroll, CWB, Absence Management iRecruitment and AME) Lang/ Tech: SQL, PL/SQL, Alerts, Java, Web Services, HTML and SML Tools: OTBI, BIP, HCM Extracts, OIC, TOAD, Eclipse, SQL Developer, and jDeveloper, HP ALM and Jira Keywords: rlang hewlett packard procedural language Keywords: rlang hewlett packard procedural language