Oracle Cloud HCM Consultant - Global HR & Payroll Expert

Oracle Cloud HCM Consultant

Name: Ramya Pesam

Mobile: 779-***-****

Email: **************@*****.***

LinkedIn: https://www.linkedin.com/in/ramya-pesam-581b84279

Maryland, USA

PROFESSIONAL SUMMARY:

•With over 5+ years of extensive experience, I excel as an Oracle Cloud HCM/Oracle Application Core HR/Financial Functional Consultant, specializing in Oracle Fusion Cloud HCM. My expertise spans across modules such as Global HR, Payroll, Absence Management, Talent Management, and Compensation Management (benefits, Incentive, and Total Compensation).

•Proficient in the entire spectrum of HCM modules, including Oracle Human Resource (HR), Oracle Payroll, Oracle Advanced Benefits (OAB), Oracle Time and Labor (OTL), Oracle Recruitment, Oracle Learning Management, and Oracle Self-service Human.

•I have successfully managed end-to-end Fusion HCM Cloud projects, handling implementation, upgrades, patch updates, cloud testing, and ongoing support & maintenance. My skills extend to creating BI Reports, Analytics & Dashboards using Fusion HCM OBIEE. Proficiency in Payroll Fast Formulas (FF), extracts, and HCM Data Loader (HDL) in the context of Payroll.

•Demonstrated ability to engage effectively with Oracle teams on Service Requests (SRs) and critical issues during implementations, ensuring timely resolutions and project continuity.

•I possess a comprehensive understanding of all major Fusion HCM Offerings, particularly in Workforce Deployment and Workforce Development modules, enabling seamless integration and optimization of HR processes.

•Skilled in analyzing future and current process modelling, data structures, design specifications, and application mapping, complemented by thorough unit, integration, and system testing. Experience in conducting root cause analysis and implementing scalable solutions.

•My experience includes designing enterprise-level solutions for Global HR and Payroll, collaborating closely with Fusion HCM, Finance & Order Management architects to establish robust setups for multiple legal entities, business units, and geography configurations.

•Configured and customized ORC functionalities to streamline recruitment processes, including application flows, candidate selection workflows, and offer management.

•Proficient in Agile/Scrum, AIM, and OUM Methodologies, with a demonstrated ability to drive discussions with business stakeholders, gather requirements, conduct workshops, and ensure alignment between business needs and technical solutions.

•I have a proven track record of providing comprehensive end-user training and support to HR professionals, ensuring proficient usage and interpretation of reports and dashboards while staying updated with the latest Oracle Cloud HCM reporting features and best practices.

•My leadership and communication skills are evident in consistently delivering projects on time, multitasking effectively, and assisting clients across diverse phases including implementation planning, fit/gap analysis, testing, and post-implementation support across various Oracle Fusion HCM cloud/SaaS solutions at multiple customer sites.

•Proficient in utilizing Redwood Pages to create a seamless and intuitive user experience, ensuring that interfaces are user-friendly and align with business requirements.

•Experienced in leveraging Oracle Guided Learning (OGL) and Recruitment Booster to enhance recruitment processes, provide efficient onboarding solutions, and facilitate user training and adoption within Oracle Cloud HCM.

Skills:

Core Competencies: End-to-End Lifecycle Implementations, Functional and Technical Expertise, Project Management, Requirement Gathering, Configuration, Production Support

Technical Skills: EBS, Cloud Fusion, Toad, SQL dev, Office Suite (Excel, Word, Project, PowerPoint, FrontPage), OIM, OAM, Security Console, FBL, SSL, HCM, PBL, HCM Extracts, and

BPM.

Functional Skills: HR Process Design, Process Modeling, Recruitment and Onboarding, Benefits, Compensation Structures, Talent Management,

Languages: SQL, PL/SQL and UNIX Shell script, C#.

Methodologies & Operating System: Agile/Scrum, AIM and OUM, Windows and MAC

Career Summary:

Client: CSC Global / Remote

Role: Oracle Cloud HCM Technical Consultant. Duration: Aug 2024 to Current

Responsibilities:

•Assisted in the implementation of Oracle Cloud HCM application for Global HR, Talent, Absence, Benefits, BPM Enhancement Requests, Testing, Updates/Upgrades, Migrations, HCM Extracts, Custom Reports, and Design changes. Involved in several acquisitions and demerger projects. Assisted the client in entire BI Publisher and OTBI reporting for HR, Payroll, Costing, Compensation, Talent, and Absence modules, Fast Formulas, and numerous Payroll and Benefits interfaces and extracts.

•Interact with clients and involve in requirement gathering, preparing process requirement documents, Business Requirement Documents (BRDs), and mapping with Oracle Cloud HCM, and GAP analysis.

•Prepare documentation for Business Requirements, Functional Specifications, and Test Case documents. ORC HCM features a user-friendly application process and mobile access, improving the overall candidate journey.

•Developed and maintained PL/SQL scripts to support custom integrations and data transformations within Oracle HCM.

•Created dynamic OTBI dashboards and reports for key modules, improving workforce analytics accuracy and increasing user adoption

•Extensively work on the development of Oracle Fusion HCM BI reports, including BIP, OTBI, and HCM Extracts.

•Develop HCM Extracts/OBI Reports/OTBI Analytics for Global HR, Payroll, Taleo, Benefits & Performance modules.

•Proficient with subject areas in preparing Adhoc reports with OTBI for Core-HR, Payroll, & Benefits modules.

•Set up approval hierarchy, Global models, Plan Eligibility, Plan Cycles, Compensation Budgets, Compensation components, performance ratings, Workforce compensation approvals.

•Ensure that the application meets business requirements and system goals, fulfills end-user requirements, and identifies and resolves system issues.

•Experience in Configurations, Personalization, Fusion role-based Security, HCM Data Loaders (HDL), Spreadsheet Loader, OTBI Reports, BI Publisher Reports, HCM Extracts, Workflows, and approval configuration, Fast Formulas for HR, Payroll, Benefits, Goals, Absence Management, and Payroll modules.

•Proficient in conversing on Redwood Pages, Oracle Guided Learning (OGL), and Recruitment Booster, leveraging these tools to enhance user experience, streamline processes, and improve recruitment strategies in Oracle Cloud HCM implementations.

•Drive and document business requirements and procedures to obtain sign-off, ensuring Client alignment with the proposed solution.

•Develop HCM Extracts/OBIEE Reports/OTBI Analytics for Global HR, OTL & Benefits modules.

•Compare the existing environment with the new fusion environment and provide demo sessions on the fields for better understanding of the end-user.

•Work on configuring alerts, rounding rules, data issues, worksheet calculations, dynamic columns from one plan to another.

•Configure various plans, plan eligibility, configure worksheet display, add OTBI reports on configure report, and transfer employees' data from compensation to HR.

•Responsible for successful testing of developed solutions, including User Acceptance Testing, and working with users to validate the solution.

•Configure Monthly and Annual Equity plans based on client requirements.

•Build custom security for Oracle HCM Cloud, including creating/modifying Data Roles and their Security Profiles, Job Roles, Application Roles, and Duty Roles.

•Involve in testing and validating Oracle Cloud patches as rolled out to different HCM cloud instances, and correct any errors discovered.

•Fix various issues in the production environment related to missing data or incorrect data generation in reports and extracts used for interfaces and integrations.

•Worked extensively with Oracle Visual Builder Studio (VBS) to support Redwood UI enablement and page extensions across Oracle Fusion HCM modules.

•Implemented UI-level customizations using VBS, including field visibility controls, layout adjustments, validations, and conditional logic aligned with business requirements.

•Partnered with HR, Payroll, Benefits, and Talent stakeholders to translate business needs into Redwood page enhancements using Visual Builder Studio.

•Acted as a functional bridge between business users and VBS/VBCS developers, reviewing UI designs, validating REST-based interactions, and ensuring Fusion compliance.

Client: Future Group India, Mumbai, India

Role: Oracle Cloud HCM Techno Functional Analyst. Duration: Jan 2021 to June 2023

Responsibilities:

•Support and maintain Human Resource Information Systems (HRIS) testing while maximizing the effectiveness of HR business operations. Identify and document test scenarios and build test cases.

•Played a key role in the upgrade and optimization of Oracle Cloud HCM Core HR system, including testing, documentation, and user acceptance training, resulting in improved system performance and user experience.

•Configured and deployed OIC integrations to connect Oracle Cloud HCM with [List of integrated systems, e.g., ERP, CRM, Payroll] using REST APIs, file-based integrations, and other protocols.

•Collaborated with HR business partners to analyze and address system enhancement requests, prioritizing based on business impact and feasibility.

•Created and maintained system documentation, including user guides, process flows, and system configuration documents, to support system governance and knowledge transfer Coordination with the Web Services team to create web services to automate the export of data to downstream systems (for both HR and non-HR) and import data to update fields into Cloud HCM and Setting the details of HCM Data Loader Scope parameters.

•Modify existing third-party vendor interfaces and develop new vendor interfaces as required.

•Identify the changes that need to be incorporated in each release and coordinate with change management and release management teams during deployment.

•Worked on Enterprise Structure one-time setups, Geography setups, Workforce Structures, ESS/MSS, Security, and approval tasks.

•Managing integration support tickets and leading an HCM OIC integration team to

•ensure timely issue resolution and system optimization.

•Developing HCM Extracts, Fast Formulas, and BIP Reports to enhance automation and reduce manual intervention in HR and Payroll processes.

•Manage and successfully implement total software testing life cycle associated with new functionality and/or enhancements to existing functionality, including requirements analysis and test documentation, design/build test plans, testing and deployment and post implementation support and transition to ongoing operations.

Client: Matrix / Hyd, Ind.

Role: Oracle HCM Analyst. Duration: June 2019 to Dec 2021

Responsibilities

•As an intern got an opportunity to work with HCM offshore leads and business users directly on various client requirements.

•Pair-program with developers to enhance current PL/SQL packages to fix production issues, build new functionality and improve processing time through code optimization.

Created SQL queries for extracting employee performance data. Implemented mass data import processes using HSDL.

•Involved in EBS HRMS to Oracle cloud HCM large implementation life cycle.

•Worked on Mass data loads, BI, OTBI reports, HCM extracts.

•Involved in the Implementation of core HR modules

•Re-configured HCM Extracts to include additional employee data fields.

•Updated dashboards to reflect the latest data and trends in HR analytics.

•Performed data mapping, data modeling, data quality checks, created class diagrams, ER diagrams, and used SQL queries to filter data.

•Worked with business analyst and developers in setting up test data.

•SQL, PL SQL, Analytics & Reporting.

•Microsoft Word, Excel, PowerPoint, and Visio.

EDUCATION:

Master of Science in Business Analytics –

University of New Haven, New Haven, Connecticut, USA

Bachelor of Technology (B.Tech) –

Sri Padmavathi Mahila University, Tirupati, Andhra Pradesh, India

Contact this candidate