We provide IT Staff Augmentation Services!

Sr. Oracle Hcm Functional Consultant Resume

4.00/5 (Submit Your Rating)

Lexington, KY

SUMMARY:

  • Experienced professional with 8 years of hands on in HR and HR Information Systems and implementation of Oracle EBS HRMS and Cloud HCM Fusion applications by facilitating sessions, workshops, developing and delivering end - user training, project management, and preparing and presenting project briefings to executives.
  • Helped and supported new HR end users, to maintain the employee's information effectively in Oracle HCM Cloud application.
  • Coordinated the redesign of client's business processes where possible, allowing for better utilization of the functionality of the Benefits Administration and Payroll module.
  • Experience around product design, development and project execution around every HCM process area including all transactional Core ERP processes, Workforce Management, Talent Management, Compensation Management, Self Service Portals, Analytics, Scorecards, and Metrics.
  • Experience in developing functional and technical design and documentation for Oracle HCM Cloud using data conversions, interfaces, custom reporting.
  • Gathered business requirements from high level client executives and transferring said requirements to feasible Oracle Fusion HCM tools.
  • Experience in Design, Development, Administration and Implementation of Oracle HCM Cloud (R10, R11) and Oracle Applications both 11i & R12 HRMS modules.
  • End to end implementation experience in Global HR, Payroll, Absence management, Talent Management, Profile Management and Compensation modules.
  • Experience around product design, development and project execution around every HCM process area including all transactional Core ERP processes, Workforce Management, Talent Management, Compensation Management, Self Service Portals, Analytics, Scorecards, and Metrics.
  • Knowledge of various Oracle Cloud HCM modules in areas like Workforce Administration, Benefit, Talent Management, Compensation Administration, Security and Reporting.
  • Currently working as an Sr. Oracle Cloud HCM Consultant in various HCM process areas like Workforce Management, Talent Development, and Compensation Administration.
  • Specialized in Oracle Taleo version 7 to 14A, B, 15A TEE and TBE Talent Management, implementations, System Administration, Configurations, Software as a Service (SAAS), PMO, Business Process Re-engineering for domestic and international clients.
  • Work cross-functionally with IT and LOB teams to ensure effective execution of Oracle HCM software such as Oracle HCM Fusion & Taleo Applications.
  • Configured Legal Employers, Tax Reporting Units, Payroll Statutory units, Payrolls, Earning Elements, Supplemental Earnings, Voluntary & Involuntary Deductions, Pre-Tax elements, Employer Liabilities, etc.
  • Migrated existing reports and developed new reports and dashboards for Oracle E-Business Suite upgrade.
  • Expertise in implementing the Oracle BI /Security Setup (groups, data access/query privileges), Metadata Objects and Web CatLog Objects (Dashboard, Pages, Folders, Reports).
  • Expert in identifying business requirements and map them to the Oracle Fusion Cloud functionality.
  • Configuring the product based on the customer's business requirement and simulating the functional set up. Implementation of the enhancement requirements on the simulated environment and evaluating the functionality.
  • Extensive experience in Oracle Back-end (server-side) PL/SQL Development I.e. Packages, Stored procedures, Functions & Triggers using SQL Developer and Toad as development tools.

TECHNICAL SKILLS:

Oracle HCM Cloud (Release 4 - Release 11) Functional: Global Human Resources, Benefits, Payroll, Performance Management, Goal Management, Absence Management, Talent Review & Succession Planning, Compensation Management and Security

Oracle EBS HCM: Human Resources, Payroll, Self Service HR (Manager/Employee) Advanced Benefits, Standard Benefits, Time and Labour, iLearning, iRecruitment, Compensation Workbench, Performance Management, and Application

Database & Tools: Oracle 11.X, 10.X, Oracle 9.X, Oracle 8.X, Oracle 7.X, Oracle Discoverer, PL*SQL

Operating Systems: UNIX, Linux, Windows NT, XP, Vista, 7, Windows 8

Office Automation Software: MS Office, Access, Project, Outlook, Visio

PROFESSIONAL EXPERIENCE:

Sr. Oracle HCM Functional Consultant

Confidential, Lexington, KY

Responsibilities:

  • Currently working as a Sr. Oracle HCM Consultant in various HCM process areas like Workforce Management, Talent Development, and Compensation Administration.
  • Designed Conversion Strategy and Conversion Data Mapping Documents for HR/OAB, OTL modules and wrote conversion programs using API's.
  • Developed integration points between Taleo - PeopleSoft HCM & Taleo - EBS, Taleo- Fusion (Currently ongoing) by using Import, Export, and Netchange.
  • Perform End to End Regression testing on Fusion Core HR, Employee Self Service (ESS), Manager Self Service (MSS), Talent management module such as Goal management and Performance management, Fusion Benefits modules on every patch bundle application and new Releases.
  • Interacted with client and involved in Requirement gathering, preparing process requirement documents, Business requirement documents, and mapping with Oracle Cloud HCM, and GAP analysis.
  • Compared existing environment with the new fusion environment and provided demo session on the fields for better understanding of the end user.
  • Designed HCM Extracts for Inbound & Outbound Interfaces using FBL and HDL familiar with Fusion Cloud data model and build various BIP in fusion cloud environment.
  • Interpreted various geographies, action reasons, content types, context, flex fields, jobs and department setups.
  • 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.
  • Setup Fusion Compensation plans, budget, worksheet, Total Compensation Statement and budget sheet customization
  • Setup approvals, Individual compensation plans, Plan Eligibility, Plan Cycles, Compensation Budgets, Compensation components, performance ratings, Workforce compensation approvals and Total Compensation Statements.
  • Supporting testing activities including downstream payroll deductions and benefits interfaces.
  • Restructured and developed HR Transformation of Oracle HCM application structure and integration points with third party systems.
  • Supported other teams, Payroll, Self Service, OTL, and Benefits to provide continuity between all teams on all modules.
  • Led annual performance program enhancement by providing consultation & analysis and recommending and implementing solutions to meet dynamic business needs by leveraging ePerf module of PeopleSoft HCM.
  • Developed work plan, follow and deliver in line with Oracle HCM Cloud Implementation Roadmap and Methodology.
  • Setup Self Service OTL, OTL Timekeeper groups, Alternate names, Rotation plans, earning policies, Holiday calendar, Work plan etc.
  • Addressed systems issues or opportunities with Oracle/Taleo and other integrated partners or vendors; managed follow-up to ensure timely resolution.
  • Maintained integrations between Oracle/Taleo Recruiting and internal/external partners including background check, assessment, tax credit, CRM, and virtual interview.
  • Implemented Cloud HR and SSHR for oil and energy client migration from Oracle HCM application.
  • Addressed systems issues or opportunities with Oracle/Taleo and other integrated partners or vendors; managed follow-up to ensure timely resolution.
  • Implement Workday HCM Core HR, Talent Module, Onboarding & Recruiting modules testing. Review, test, and implement system upgrades or patches.
  • Implemented Core HR, SSHR, Payroll, Benefits, Compensation, Talent Management and Taleo Learn in a SAAS on - premise and Cloud environments.

Oracle HCM Consultant

Confidential, Purchase, NY

Responsibilities:

  • Developed custom reports using Business Objects in Oracle-Taleo for leadership, human resources, and talent acquisition teams.
  • Build Custom Security to Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
  • Customized management self-service for viewing and updating multiple employee status data. RMS modules HR, Advance Benefits, OTL and Payroll.
  • Worked on Oracle HCM modules Core HR, SSHR, Performance Management, iRecruitment and Compensation Workbench.
  • Involved in data conversion effort to facilitate superior quality of data from Oracle EBS to Oracle Fusion HCM.
  • Developed the Fast formulas for Applaud time entry, Accrual plans and Input validations- Approval setup for the leaves based on the leave types.
  • Designed programs to upload time from Time force to OTL data conversion including time and attributes for OTL module.
  • Work cross-functionally with different teams to ensure effective execution of Oracle HCM Software such as Oracle HCM Fusion & Taleo Applications.
  • Functional, Integration, Technical and Transitions lead for Oracle Taleo/ Fusion implementations.
  • Performed active role in analyzing, designing, testing and implementing several interfaces/ customizations to implement core HR.
  • Mainly involved in upgrading the system by performing the pre-upgrade and post upgrade steps.
  • Involved in feasible analysis and setup for Standard and Customized workflow as per business requirement.
  • Strong Exposure to Data Conversion and migration include HRMS, Payroll, Oracle Advanced Benefits (OAB), Oracle Time & Labor (OTL), modules to Oracle Applications using Oracle API.
  • Implemented Performance Management by creating roles for eligible participants to access the performance document to provide feedback.
  • An Outbound interface from Oracle HRMS to the Oracle Taleo. The interface primary handles all candidate data who are hired with different nationality.
  • Analyzed and implemented several Oracle provided patches provided to fix the bugs in Production Environment and upgrade instances.
  • Tested and maintained Oracle payroll module software for enhancements and complete new conversions.
  • Hands on experience in Fusion HCM Applications (Core HR, payroll, Talent Management, Compensation and performance management).
  • Configured eligibility profile/rules in OAB, developed test cases and executed specific test scenarios, wrote test scripts and guided users through testing cycles.
  • Work cross-functionally with IT and LOB teams to ensure effective execution of Oracle HCM software such as Oracle HCM Fusion & Taleo Applications.
  • Maintained integrations between Oracle/Taleo Recruiting and internal/external partners including background check, assessment, tax credit, CRM, and virtual interview.
  • Performed benefits and work structures data population within Fusion HCM using spreadsheet based loaders.
  • Perform Configurations as per the design for HR, Payroll, Self Service, Learning Management, Approvals Management and OAB modules.
  • Developed multiple HCM Extracts for outbound interfaces to integrate with other systems and designed some extracts for Payroll Interface.
  • Experience in Oracle HCM (EBS/Fusion), including workflow and alerts; PL/SQL and Fusion Middleware Object Design, Development & Testing.
  • Performed gap analysis between business requirements and Fusion Compensation and Benefits functionality.
  • Working as Oracle Fusion subject matter expert providing best-practice guidance on HCM business processes on OTL and Payroll integrations and mass updates.
  • Gather requirements and deliver information using Oracle Business Intelligence (OBIEE) and Oracle Noetix reporting software.
  • Configuring custom Workflow routing rules for all Manager Self-services and Employee Self-services with help of Area Responsibilities.

Oracle HCM Analyst

Confidential, Seattle, WA

Responsibilities:

  • Hands-on configuration working with functional set up manager across Oracle HCM Cloud modules.
  • Worked on Eligibility Profiles, Eligibility Criteria, Utilized all six types of Derived Factors for HR, Absence, OAB and workforce development modules as per the client requirements.
  • Worked as Oracle functional consultant as part of Oracle HRMS implementation for Oracle Core HR, CWB and OAB.
  • Strong configuration and design skills including experience with benefits interfaces, reports and processes.
  • Generated bug reports and test reports. Worked closely with the developers in recreating the bugs and in verifying the bug fixes.
  • Understanding and knowledge of Oracle Cloud Services coordination requirements for implementations, My Oracle Support use, and Service Request issue identification, escalation and resolution processes.
  • Experience with developing system requirements, defining and documenting procedures, and implementing a practical sustainable business solution.
  • Working with OBIEE to perform detailed data analysis to identify appropriate data sources, key facts, and dimensions that support the business requirements. Performed needed tasks to support the standardization of facts and dimensions.
  • Responsible for Oracle Fusion HCM configuration for global OAB, Payroll, HR/ performance/ Goals/ Talent Review - hands-on full life cycle project delivery and go-live experience.
  • Helped and supported new HR end users, to maintain the employee's information effectively in Oracle HCM Cloud application.
  • Involved in preparation of Test Cases, Test Scripts for the Core HR, Benefits, Talent and Global Compensation.
  • Customized management self-service for viewing and updating multiple employee status data. RMS modules HR, Advance Benefits, OTL and Payroll.
  • Designed training program for new consultants to learn methodology and Oracle HCM Cloud basics.
  • Developed and customized reports in Oracle Reports 6i, Oracle Discoverer Reports for Oracle Timesheets (OTL), XML Publisher Reports.
  • Gathered requirements from HR stakeholders such as Travel, HR Operations, Clearance and Payroll and streamlined them into operational reports, interfaces and notifications to be implemented in Oracle Fusion Applications.
  • Developed PLSQL stored packages and UNIX shell scripts for loading legacy data from old system to new system. Created of staging tables to load data using Informatica (ETL) tool and/or SQL loader into staging tables and then using custom built PL/ SQL stored procedures to validate and call the Oracle Public APIs to populate Oracle Applications tables.
  • Designed reports and dashboards on Oracle Business Intelligence and BI Publisher platform.
  • Implementing Workforce Deployment, Compensation management, Talent Management (Goal management, Performance management, talent Review and Succession) and Security.
  • Configure Workflow routing rules for all Employee Self Service actions and Manager Self Service actions.
  • Conducted qualitative and quantitative analysis and creating reports of data via ad-hoc requests and provided business insights in an accelerated environment.
  • Work closely with clients to identify needs and provide best practices and solutions based on knowledge and previous experience.

Business Analyst

Confidential, Cincinnati, OH

Responsibilities:

  • Involved in Scrum development process and prepared Sprint burn down chart, product catalog and sprint backlog contain Business Requirements and supporting documents that contain the essential business elements and definitions as well as the tasks to be completed.
  • Created and/or enhanced mock-ups, prototypes, wireframe, technical design documents, business(user) requirements documents, test documents, source to target mapping documents, etc. to deliver data integration and DW/BI solutions.
  • Documented the requirements in the form of detailed Use Cases and created Use Case Diagrams and Process Flow Diagrams using MS Visio.
  • Working with clients to better understand their needs and present solutions using structured SCRUM approach.
  • Bridged gap between AS-IS and TO-BE business process flows, integration of process flow diagrams to show end-to-end business model, and process mapping exercise by including swim lanes to distinguish roles and responsibilities.
  • Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
  • Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
  • Created mock-ups, prototypes, technical design documents, source to target mapping documents, etc. from the business (user) requirements documents received form the business users or Data Analysts or DMO.
  • Facilitated Scrum of scrums across teams and coordinating with other Scrum Teams for identifying, tracking and resolving dependencies.
  • Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
  • Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.
  • Involved in extensive Data validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues.
  • Utilize database, SQL and Excel/Google sheets skills to collect, organize, and analyze data to support forecasting efforts.
  • Created UML Diagrams to show business process flows of business requirements like Use Case Diagrams, Class\ Diagrams, Activity Diagrams, Sequence Diagrams, and wireframe using MS Visio.
  • Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
  • Created Mock-up forms in MS word for better visualization and understanding of the software solution.

We'd love your feedback!