Sr. Oracle Hcm Consultant Resume
2.00/5 (Submit Your Rating)
NJ
OBJECTIVE
Having 6+ years of Oracle Fusion Applications Suite (R10/R11) experience in supporting applications development configuration enhancements, setups, process design of HCM - Core HR, Payroll, compensation, Absence Management, Talent management
SUMMARY:
- Experience includes full lifecycle implementations of Oracle Applications release 12 covering HRMS modules: Core HRMS, Absence Management & Self Service and HCM Fusion Implementation for Workforce Deployment, Workforce Development, and Talent Management strong experience in oracle HCM modules like Core HR, SSHR, Payroll, Oracle advance benefits (OAB), Oracle time and labor (OTL), Compensation workbench (CWB), performance management system (PMS), I-recruitment and Oracle learning management (OLM) Modules.
- Experience in building new reports and troubleshooting the existing reports using Fusion reposting tool OTBI (Oracle Transactional Business Intelligence).
- Knowledge on fast formulas and wrote fast formulas for absence management module and in creating the payroll definitions and proficiency in payroll process.
- Experience in setting up enterprise structure, workforce structure and span business process like understanding and interpreting fast formulas, profile and workforce directory management and Security (Security Profiles, Data, Job and Duty Roles), FBL, HCM Data Loader (HDL), HCM Extracts.
- Hand on Experience in Configurations, Personalization, and fusion role-based Security, HCM Data loaders (HDL), Spreadsheet loader, OTBI Reports, BI Publisher reports, HCM Extracts, Workflows and approval configuration, Fast Formulas for Absence Management and Payroll modules.
- Experience in all phases of Oracle Applications R12/11i implementation with major focus in HRMS of Oracle Applications including Oracle HR, Oracle Payroll, Self Service Human Resource (SSHR), Oracle Time and Labor (OTL).
- Experience in Setting up Fusion Compensation plans, budget, worksheet, Total Compensation Statement and budget sheet customization.
- Experience in time deliveries, multi-tasking and assisting clients in the selection, implementation planning, fit/gap analysis, conference room pilots, configuration, testing, training to diversified users, rollout, post-implementation support of Oracle Fusion HCM cloud/SaaS solutions at various customer sites, POC's and CRP.
- Expertise and implementation experience on Fusion HCM Offerings: Talent Management, Workforce Deployment (Core HR), Workforce Development (Goal Management, Performance Management, Talent Review and Succession), Absence Management, and, Security.
- Excellent experience in Data loading into Fusion HCM using HCM Data Loader Tool which includes the Workforce structure data, Worker data, Work relationships data, and Salary info.
- Experience in Configuration Legal Employers, Tax Reporting Units, Payroll Statutory units, Payrolls, Earning Elements, Supplemental Earnings, Voluntary & Involuntary Deductions, Pre-Tax elements, Employer Liabilities, etc.
- Experience in Configurations, Personalization, and fusion role-based Security, HCM Data loaders (HDL), Spreadsheet loader, OTBI Reports, BI Publisher reports, HCM Extracts, Workflows and approval configuration, Fast Formulas for Absence Management and Payroll modules.
- Experience in building new reports and troubleshooting the existing reports using Fusion reposting tool OTBI (Oracle Transactional Business Intelligence) and Strong understanding in Performance Management set ups like Performance Process Flows, Talent Eligibility Profiles, configuring Performance Document.
- Experience in developing fast formulas, writing Oracle SQL/PLSQL code, BI Publisher, OTBI, XML Publisher, HDL.
PROFESSIONAL EXPERIENCE
Sr. Oracle hcm Consultant
Confidential - NJ
Responsibilities:
- Implemented Talent Management and Compensation Management in R12 including Employee Self Service, Manager Self Service, Security Administration, Workflows & approvals, Reports & Analytics, Email Alerts/Notifications, Application Customization and Data Migration, etc.
- Interacted with client during the Implementation process, Involved in Requirement gathering, preparing process requirement documents, Business requirement documents, understanding current business process and mapping with Oracle Cloud HCM.
- Collaborated in designing and testing a custom OTL Timecard Approval Workflow that allowed timecard approval by PAC external customers/approvers.
- Designed Functional specifications for extensions and customizations for I-recruitment, Payroll, OAB and Performance Management
- Worked on developing HCM extracts as part of outbound interfaces and worked on creating BI publisher reports and developed HCM Extracts/OBI Reports for Global HR and Debug and enhance workflows, reports/modules/alerts.
- Defined setups of Core HR, Self Service HR, Payroll, Oracle Time and Labor -OTL, i-Recruitment and Performance Management (PMS) modules to map the business requirements into Product functionality.
- Prepared functional specifications for the Carrier Extracts and designed/configured/tested the Extracts in OAB using System Extracts
- Conducted requirement gathering sessions for Global HR, Performance, Compensation modules. Sessions for Technical objects like Conversions, Reports, HCM Extracts and Integrations/Interfaces.
- Involved in the Integration & support to ADP applications used by client (e-TIME and Payforce) with Oracle (11i and R12) and Functioned with Fast Formulas, reports and extracts needed for the client.
- Identified business requirements for Core HCM, Absence, compensation, Performance and map them to Oracle HCM Cloud Application functionality.
- Performed troubleshooting and resolved issues found in parallel tests scripts, validated payroll setup, payroll elements and payroll fast formulas.
- Used AIM Methodology for OAB Project Plan documents/deliverables.
- Prepared several OTBI reports including customized reports for most HCM modules and Involved in raising SR with oracle & interacting with oracle team to solve SR related issues.
- Wrote custom reports in Cloud HCM BI Publisher that are also used as outbound files for data exchange from the Cloud HCM system to other systems.
- Build Custom Security to Fusion HCM which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles at APM, OIM and Security Console.
- Developed an OTL report to identify missing time cards and approve them using a custom program.
- Worked on payroll balance configuration and conversion, year-end and mid-year balance adjustment, execution of payroll processes, generation of Pay slip, W2 and government reports for Oracle Payroll.
- Managed configurations, process mapping, and issue remediation for Core HR, Employee/Manager Self Service, and Absence Management in an implementation and Provided functional design for all Absence Management Fast Formulas.
- Worked on Log Service Requests (SR/TAR) and implemented solutions by Oracle support and Involved in resolving Production Support issues relating to creation of Characteristic Fields, Value Fields, and assigning value to Value Fields.
- Created File Based Loader & OTBI reports with HCM Extracts integration in HCM Cloud and responsible for requirement analysis, design and architect of the business processes in Oracle Cloud and transition from 2 existing legacy applications for Compensation.
Oracle HCM Consultant
Confidential, NY
Responsibilities:
- Performed Configurations as per the design for HR, Payroll, Self Service, Learning Management, Approvals Management and OAB modules.
- Designed Functional specifications for extensions and customizations for i-recruitment, Payroll, OAB and Performance Management
- Developed BI Reports/OTBI in Oracle Fusion Cloud and scheduled the reports with to be delivered to Email and FTP sites.
- Worked on Fusion R10 and R9 configuration (workflows, DFF, EFF, KFF, Business unit, LE, Compensation
- Created Multiple OTBI Reports and worked on BI Reports and HCM extracts and Designed, developed reports using the OBIEE BI Publisher data sets and charts.
- Developed fast formulas for Benefit and Payroll requirement and worked on Changes to the existing Fast Formula (Accrual Plans), Alerts and other business logics according to recent changes.
- Involved in the Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
- Worked on RICE (Reports, Interfaces, Conversions and Extensions) objects to as per the custom business process within Oracle HRMS implementation.
- Prepared several OTBI reports including customized reports for most HCM modules and Involved in raising SR with oracle & interacting with oracle team to solve SR related issues.
- Effectively used ETL Informatica tool to debug, modify and to build Informatica workflows.
- Worked as Oracle HCM Analyst and provided best-practice guidance on HCM business processes on OTL and Payroll integrations and mass updates.
- Developed BI publisher reports in Absence, HR and Payroll area and developed 2 HCM extracts, one of them is a change only extract.
- Created Oracle Fusion BI Reports and Analytics and Involved in testing existing BI Reports and creation of ad-hoc OTBI reports.
- Worked on Oracle Payroll compensation management, Salary review, and designing of especial earning rules using Fast formulas.
- Setup and maintained enterprise and workforce structures and involved in the designing of payroll inbound and outbound interfaces.
- Involved in resolving Production Support issues relating to creation of Characteristic Fields, Value Fields, and assigning value to Value Fields.
- Developed HCM Extracts Reports and responsible for transferring the data to third party systems on daily basis.
- Identified Core HR, Absence Management requirements configured necessary solutions and conducted knowledge transfer sessions with client to support ongoing maintenance.
- Helped and supported new HR end users, to maintain the employee's information effectively in Oracle HCM Cloud application.
Oracle Business analyst
Confidential - IL
Responsibilities:
- Worked on Oracle HCM modules Core HR, SSHR, Performance Management, recruitment and Compensation Workbench and implemented Oracle Fusion HCM, Talent Management, Compensation Management, Employee Self Service, Manager Self Service, Security Administration, Workflows etc.
- Worked on upgrade and support of Oracle HRMS, SSHR, PMS modules.
- Fix issues in Oracle Payroll, Core HR and i-Recruitment and AME as part of HRMS R12 RUP Releases like RUP4, RUP5, RUP6 and RUP7.
- Created File Based Loader & OTBI reports with HCM Extracts integration in HCM Cloud.
- Prepared several OTBI reports including customized reports for most HCM modules and Involved in raising SR with oracle & interacting with oracle team to solve SR related issues.
- Configure new HR and Payroll whenever there's new benefits (i.e. new CBA benefits) including writing fast formulas.
- Configured HRMS, SSHR, Payroll, MSS, PMS Modules, SSHR and MSS Personalization.
- Responsible for requirement analysis, design and architect of the business processes in Oracle Cloud and transition from 2 existing legacy applications for Compensation.
- Created File Based Loader & OTBI reports with HCM Extracts integration in HCM Cloud.
- Worked on Absence Integrations with Payroll, OTL and Workforce scheduling and Organized the testing process and Bug Reporting using ALM.
- Implemented Core HR-HCM, Performance, profile, Goal, Time and Labor & Benefits module and Taleo Recruit related all the transaction like Transfer, Termination, Promotion etc.
- Developed BI Reports/OTBI in Oracle Fusion Cloud and scheduled the reports with to be delivered to Email and FTP sites.
- Analyzed current Time and Labor rules, eliminated those not needed anymore, and provided guidance for change or consolidation for those currently not producing desired results.
- Involved in payroll balance configuration and conversion, year-end and mid-year balance adjustment, execution of payroll processes, generation of Pay slip, for Oracle Payroll.
Business analyst
Confidential, OH
Responsibilities:
- Developed the Different type of Project Document like Wireframe Screen, SRS, FRD, Business Process Flow BPMN and Collaboration Diagram, RTM, Database Table and Form, Fields & validation, Estimation of Project.
- Possessed Analytical skills, Technical skills to understand the Business process and Functionality requirements and to translate them to system requirement specifications.
- Worked on Document project artifacts such as Business Requirements Document (BRD), Software Requirement Specification (SRS), Functional Requirement Documents (FRD), Requirement Traceability Matrix (RTM), use cases, Issues Log, and training manuals.
- Worked on different areas of software technologies including MS Excel, MS Word, MS Power point, MS Office Suite and SQL server.
- Developed business process models in Scrum environment. Helped to create and translate user stories to define the functions the system must provide, and to facilitate requirements management.
- Actively involved in brainstorming and JAD session with the client to identify all the business requirements for property and casualty project development.
- Involved in developing & automating reports, iteratively build & prototype BI dashboards using Tableau to provide insights at scale, solving for analytical needs of business team and was Involved in GUI testing, Functionality Testing, Regression testing, System Testing, Unit Testing, Integration Testing, Performance Testing, and Stress Testing.
- Wrote SQL and Access queries for data extraction and reporting purposes and learned User Acceptance Testing (UAT), GUI Interface testing, Functionality Testing, System testing including Integration, Performance, Stress, Load and Regression Testing of Web and Client/Server based applications.