SUMMARY:

• 9+ years of diversified expertise in Oracle Applications R12/11i HRMS and Fusion HCM R10/R11/R12/R13/19A experience and Oracle Taleo (Recruiting, Onboarding, Learn, Reports), with extensive exposure in Design, Configuration, Implementations, Production Support and Upgrades.
• Expertise in HCM cloud Modules - Core HR, Compensation Management, Performance Management, Talent management, Payroll, Advance Benefits, Time and Labor, Absence Management.
• Proficient in all phases of Oracle Applications R12/11i implementation with major focus in Human Resource Management System (HRMS) of Oracle Applications including Oracle Human Resources (HR), Self Service Human Resource (SSHR), Oracle Time and Labor (OTL).
• Devised Solution strategy, Facilitated Functional, Infrastructure and Technical Assessments, provided detailed analysis for adopting Oracle HCM
• Authored various AIM documentation including Functional Design (MD.050), Fit/GAP Analysis (BR.040), Conversion Design (CV.040), CRP and Go-Live Test Scripts (TE.040) for various EBS HRMS and Fusion HCM modules.
• Extensively worked on Oracle Fusion Security, FBL, HCM extracts, HCM data loader (HDL), BI publisher and OTBI Reports
• Extensively performed Business Process analysis and re-engineering, configuring the applications, leading fit and gap product review sessions, creating business requirements documentation, writing detailed specifications, development of change management procedures and policies.
• Analyzed complex cross functional business processes and defines integrated requirements.
• Facilitated meetings with the user and management community to gather on-going requirements, production support incident/issue tracking and have worked on trouble shooting the issues and identifying root causes and fixing them at the core.
• Expert at configuring the application, ad-hoc client reporting and user trainings.
• Excel in Oracle HRMS business process mapping for Hiring, payroll administration, absence management, performance management, Talent management benefits administration, time management, termination processes.
• Expertise in Oracle Payroll configuration with Oracle Time and Labor and Oracle Benefit modules in Multi-Org environments.
• Expertise in designing of payroll inbound and outbound interfaces and which and related to non-Oracle Payroll entrainments like ADP, Integral or Ceridian payroll as well and Oracle Payroll base environment.
• Expertise in writing and modification of Fast formulas used in Oracle Payroll, Oracle Advanced Benefits and Oracle Time and Labor for US, Canada and UK legislation.
• Expertise in Oracle Payroll compensation management, Salary review, designing of especial earning rules using Fast formulas.
• Good experience in creating various foundation objects including Concurrent program registration, Custom forms, functions, menus, Responsibilities, Value sets, application registration, profiles and customizing Descriptive flex-fields.
• Excellent knowledge of AOL (Application Object Library) and System Administration Modules.
• Good experience customizing and personalizing approvals using Oracle Approval Management (AME).
• Good experience in creating Reports and Analytics using Oracle Cloud BI.
• Trained the super users and users on the application and conducting Pilot testing, integrated testing, design validations, setups of the Distributed ERP applications and coordination of UAT.
• Experience with round-trip business methods using Function-point and Use Case estimation methods using well-defined workflow (Project and Initiatives proposal presentation techniques).
• Strong analytical skills with ability to follow project standards and decision-making capability.
• Self-motivated, creative team player with effective communication and leadership qualities.

TECHNICAL SKILLS:

• R12 Upgrade and Implementation Experience
• Expert in Core Hr and Benefits Process Design
• Implemented Oracle Fusion HCM R11, R12, R13, 19A Core modules
• AIM Methodology & Documentation
• Extensively worked on Compensation Planning and Incentive Management
• Extensive System Development Life Cycle
• Implemented Core HR, Absence Management at various clients
• Expert in Application Object Library and AME

PROFESSIONAL EXPERIENCE:

Confidential, Corcoran, CA

Lead Oracle Cloud HCM Consultant (SME)

Responsibilities:

• Participated in Requirement gathering sessions with Business Users and Process Owners, designed solutions and authored various functional design documents for Core HR, Benefits and ORC
• Demonstrated functionalities of Core HR, Benefits and ORC to educate client during business requirement sessions
• Developed configuration matrix for Core HR and benefits based on the requirements gathered during business requirements session
• Configured Jobs, Grades, locations, departments, Business Units, Descriptive Flex Fields, Assignment status, Assignment Categories, Actions, Action Reasons, notifications etc
• Configured Benefits Programs, Plans, Plan Types, Options, Rates, Coverages, Elements, Life Events, Participant Eligibility Profile, Dependent Eligibility Profile, Enrollments, Plan years, Derived factors, Beneficiaries, Dependents, Certifications etc.
• Implemented COBRA as part of Benefits implementation for terminated employees
• Configured various Plan Types such as Medical, Dental, Vison, AD&D, STD, LTD, Basic Life and implemented Retirement plans
• Configured Candidate Profile, Requisition, Offer, Candidate selection process, Job templates, Career sites etc. as part of Oracle Cloud Recruiting
• Developed UPK materials for Core HR and Benefits to provide business users as part of core training, which makes work easy after post go live
• Developed functional specification documents for reports, interfaces and fast formulas
• Worked on Personalization’s using Sandbox and created custom job roles as part of implementation
• Participated in the train the trainers and end user training programs for the newely implemented functionalities.
• Developed requirement traceability matrix and created various test scripts and scenarios for extensively testing the implemented functionality.
• Actively worked with Oracle Support to resolve various issues and provide solutions.
• Extensively worked on OTBI reports and BI publisher reports to meet business needs

Environment: Core HR, Benefits, ORC

Confidential, Beaverton, OR

Lead Oracle HCM Consultant (SME)

Responsibilities:

• Conducted business requirement session with client core team to gather business needs and implement Core HR, Compensation and Performance management
• Configured various merit and bonus plans, plan eligibilities, work sheet display, dynamic calculations, user defined tables, alerts and developed complex custom compensation change statements
• Configured and tested Performance management review periods, questionnaires, questionnaire templates, notifications, performance templates, eligibility profiles and manage performance doc types etc.
• Configured individual compensation to implement spot bonus with various options and eligibility criteria. And configured different levels of custom approvals-based on the options
• Extensively worked on page customization in various areas of the application (ex: performance templates) using different techniques (ex: User Interface Text, Structures) by creating the sandboxes
• Extensively worked on OTBI and BI publisher reports to support client requirements
• Worked in fast spaced environment to meet project mile stones for smooth implementation by managing and coordinating with offshore team
• Developed specification design documents based on requirement gathering for reports, interfaces and fast formulas along with compensation, performance design documents
• Developed UPKs for workforce compensation, individual compensation and performance management to train users on testing the various test cases during CRP2, UAT
• Provided 24*7 production support to resolve various issues after go live and provided solutions with in the expected time

Environment: Core HR, Work Force Compensation, Individual Compensation, Performance Management, BI publisher

Confidential, Louisville, KY

Sr Oracle HCM Consultant

Responsibilities:

• Involved in client sessions for gathering business requirements, implementing, testing and training on the product
• Develop project management plans, manage tight deadlines, and coordination of project team activities, defining and agreeing on deliverable and milestones.
• Developed various complex RTF templates for generating the compensation change statements for multiple plans and provided documentation
• Extensively worked on security, created custom Job roles based upon the seeded roles, created data roles, person security profiles with custom SQL criteria as per the needs of client and provided documentation
• Worked on the configuring alerts, rounding rules, data issues, worksheet calculations, dynamic columns, cross referencing columns from one plan to the other plans and etc;
• Configured various plans, plan eligibility, configuring work sheet display, added OTBI reports on configure report and transferred the employee’s data from compensation to the HR
• Worked on configuring talent review templates to use for talent review meetings
• Developed personalization's on various screens of Talent, Core HR and Compensation modules
• Configured Talent review template and talent review meetings as per the needs of client
• Extensively worked on infolets and provided security based on user role and other criteria
• Developed OTBI/BI publisher reports and helped the team on them to meet the needs of the client and provided security to the required folders based on the roles
• Extensively worked on workforce compensation, talent and performance module
• Supported YUM on the ongoing issues during the development and Talent Zone go live
• Worked closely with Oracle on the Service Requests and resolved the issues to provide solutions
• Continued support on the issues after go live and training the users on the product by providing documentation

Environment: HR, Work Force Compensation, Talent Management, Performance Management, BI publisher

Confidential, Chicago, IL

Oracle HCM Consultant

Responsibilities:

• Developed and tested the payroll flow patterns such as payroll on cycle, off cycle, quick pay as per the needs of the client
• Provided functional specification document for the flow patterns as per recommendations
• Developed SQL queries to develop reports and trouble shoot issues, provided security to the report folders
• Coordinated with Oracle for SR, New product releases, ability to coordinate upgrades and patches

Environment: Payroll, OTBI

Confidential, Minneapolis, MN

Oracle R11 HCM Consultant

Responsibilities:

• Actively involved in gathering business requirements, designing solutions, configuring the application and testing the system in variou s phases.
• Implemented workforce compensation, Talent management, Benefits and actively worked on Payroll issues and Oracle SRs to resolve various bugs and provide production support activities.
• Responsible for designing and creating new reports, authoring documentation; troubleshoot issues and fix them
• Developed and documented OTBI reports for Compensation, Payroll and Talent management.
• Configured Manager Dashboards and Human Resource Dashboards.
• Configured folder structure and Fusion security in OTBI
• Lead the team to drive workforce compensation Go Live and supported the users by providing training sessions.
• Configured Manager Resource Dashboard and Human Resource Dashboard with required Graphs and Reports.
• Design Descriptive Flex field for data that do not fit into Oracle standard field and create, update and reviewed the user defined tables
• Involved in testing, and validating the Oracle cloud patches as rolled out to the different HCM cloud instances, and report, and correct any errors discovered.
• Proactively managed integrations to and from the HCM Cloud applications to 3rd party applications.
• Worked with KBACE support and addressed the issues by providing solutions to the users

Environment: HR, Work Force Compensation, Benefits Management, Talent Management, Performance Management, Payroll, BI publisher reports

Confidential, Pleasanton, CA

Oracle Fusion HCM SME

Responsibilities:

• Performed Feasibility Analysis and Developed Project plan, Business Requirements, Functional Specs, Test Strategy, Test Plan, and Test Scripts etc.
• Implemented Oracle Fusion HCM, Talent Management, Compensation Management, Employee Self Service, Manager Self Service, Security Administration, Workflows and approvals, Reports and Analytics, Email Alerts/Notifications, Application Customization, Data Migration, etc,.
• Work cross-functionally with IT and LOB teams to ensure effective execution of Oracle HCM software such as Oracle HCM Fusion & Taleo Applications
• Performed gap analysis between business requirements and Fusion Compensation and Benefits functionality.
• Created implementation project by selecting the offerings, options and features to implement together to manage the project as a unit throughout the implementation life cycle.
• Work with business to ensure requirements are finalized, Perform Prototype review and train them on Functionality.
• Facilitated Workshops for Business Requirement gathering, CRP and UAT.
• Fixing issues related to Setups/ Configuration, Personalization’s, Reports and Analytics, Interfaces.
• Communicate with Oracle Support and Success Manager Team to get the issues resolved on priority.
• Developing test scenarios to ensure thorough testing and reviewing all test scripts developed by IT to ensure accuracy.
• Worked on Fusion Workforce Deployment (Global HR) and Workforce Development (Talent Management).
• Analyzed Organization, Location, Job, and Grade structured and finalized decision on how these would be structured.
• Performed benefits and work structures data population within Fusion HCM using spreadsheet-based loaders.
• Extensively worked on Taleo with Recruiting and On boarding
• Configured Requisition & Candidate files, Requisition approvals, Candidate Selection Workflows (CSW), Candidate Communication Agent (CCA) in Taleo Recruiting.
• Designed Conversion Strategy and Conversion Data Mapping Documents for HR/ Confidential, OTL modules and wrote conversion programs using API's.
• Analyze employee information to setup People group flex field that would house special information type (SIT).
• Develop work plans, follow and deliver in line with Fusion Implementation Road map and Methodology.
• Train the end users on GHR, Talent Management, Compensation Management, and Security Administration
• Involved in Testing and trained the users on various modules
• Analyze the business operations and drive changes to improve Customer Experience.
• Developed test scenarios to ensure thorough testing and reviewing all test scripts developed by IT to ensure accuracy
• Delivered UPK Documentation on HR/Payroll/ Benefits processes for user training purposes

Environment: Oracle Fusion HCM R11(GHR, Talent Management, Absence Management, Performance management, Benefits, Payroll, Taleo)

Confidential, Marlborough, MA

Oracle HRMS EBS Specialist

Responsibilities:

• Primary responsibility involves system study, Requirements Gathering, preparing functional specs, Conversion Design, Test script documents, User Manuals and Business Process documents.
• Documented the setup specification using AIM - BR0100 as setup document for deliverable.
• Prepared functional specification for the Historical conversion Event to transfer the benefit elections from legacy system to Confidential using Oracle API's.
• Worked on Setup Oracle Advance Benefits by establishing Elements for various Benefit Plans, Programs, Program Enrollments, Life events, Eligibility Profiles to restrict eligibility. Simplified the Customizations in Confidential and modified the Configurations at different levels to follow Oracle rules and hierarchy of Eligibility and Electability rules.
• Was involved in defining Compensation Work Bench setup like Defining Distribution Budget, Budget Reserve, Worksheet Budget, Worksheet Amount, Recommended Amount, and Eligible Salary.
• Extensively worked on 401K interface for payroll bi-weekly employees.
• Was involved in process of setting up Hiring Applicants and Terminating employees.
• Setup Self Service OTL, OTL Timekeeper groups, Alternate names, Rotation plans, earning policies, Holiday calendar, Work plan etc.
• Worked on benefits of Self-Service Personalization with communication message text changes and added text on SSHR pages to provide information about the plan which they are about elect and enroll.
• Wrote fast formulas to calculate coverage amounts, enable/disable the options programmatically and validation of options selection like he/she must select same emp/emp+1/family option across all plans (Medical/ dental/ vision/ prescription) provided.
• Employee and Manager Self Service Personalization and user creation.
• Adding new plans/options and ending existing plans, rate changes and Assisting end user training performed by key users.
• Resolving issues in production for the migrated components. Analyzing the root cause, fixing the issue and migrating the modified code to Production.
• Created Functional Design Documents as per the requirements and worked closely with development team for various deliverables.
• Designed, tested and delivered various reports using Oracle EIS in HR, Payroll and Benefits such as Payroll run verification, Interface testing, Employee Salary administration

Environment: Oracle Applications 12.1.3 (EBS), (Core HR, Confidential /CWB, HRSS, Performance Management, Talent Management, GL, AOL, EDI), SQL*Plus, TOAD.

Confidential, Houston, TX

Oracle HCM Analyst

Responsibilities:

• Responsible for Oracle Fusion HCM configuration for global Confidential, Payroll, HR / performance /Goals/Talent Review - hands-on full life cycle project delivery and go-live experience.
• 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.
• Created an implementation project by selecting the offerings, options and features to implement together to manage the project as a unit throughout the implementation life cycle.
• Designed new interfaces and maintained existing inbound and outbound interfaces to third party vendors. It included benefits and payroll among others
• Assisted the HRIS department in timely and accurate processing of employee data and related HRIS information.
• Wrote customized fast formula for PAYROLL deduction elements.
• Identifying and addressing client needs: building solid relationships with clients; developing an awareness of Firm services.
• Provided Oracle Application support in the following modules: HRMS, Self Service, PTO, Performance management, Compensation Workbench, Oracle Time and labor, Ceridian PAYROLL Created an implementation project to maintain the setup of specific business processes and activities for Fusion HCM, Global HR.
• Configured Requisition & Candidate files, Requisition approvals, Candidate Selection Workflows (CSW), Candidate Communication Agent (CCA) in Taleo Recruiting.
• Configured Source Tracking, Evaluation Management, Recruiting Center (welcome center, Theme& Logo, Communications Channel) in Taleo Recruiting
• Create a mapping document and documented the decision on mapping data.
• Make configuration changes for data mapping. Analyze the impact of these changes on interfaces.
• Deliver application design, offering configuration/setup, User acceptance testing, and End-User training.
• Developed training plans, course outlines and materials, and manages the delivery of training courses.
• Reported to higher Management on progress and status for all Business-related Work Products and Deliverables.

Environment: Oracle Fusion HCM R9/R10(GHR, Talent Management, Compensation Management, Benefits, Payroll, Taleo)

Confidential, Philadelphia, PA

Business Analyst

Responsibilities:

• Implement Oracle Payroll's core payroll engine, by adding local extensions to attain the legislative functionality and country reporting requirements.
• End-to-end responsibility for the design, development, implementation and support of the Oracle Cloud Goal Management, Performance Management, and Talent Review and Succession Planning modules.
• In affiliation with Payroll and HR, management and execution of the pay-load process to ensure quality and timeliness of paycheck distribution.
• Research and analyze payroll system issues for data-related issues. Determine and coordinate a solution.
• Defining and maintaining consolidation and assignment sets for Payroll processes.
• Worked with cross-functional teams to gather requirements and help design and develop solutions that that meet business needs, help streamline business processes and deliver as per the scope and timeline of the project.
• Involved in Design of Life Events, Eligibility, Rates and System Extracts (e.g. Carrier Extracts, AP, Payroll etc.)
• Prepared functional specifications for the Carrier Extracts and designed/configured/tested the Extracts in Confidential using System Extracts.
• Used AIM Methodology for Confidential Project Plan documents/deliverables.
• Conducting knowledge-sharing programs on every week among the team members.
• Worked on Changes to the existing fast formula (Accrual Plans), Alerts and other business logics according to recent changes.
• Worked on Solution to architect for imputed earnings gross up and same sex domestic partner benefits
• Configure and implement all major Oracle EBS Modules including Web ADI and Report Manager.
• Collaborate with internal and consulting resources to devise functional solutions that best serve the project.

Environment: Oracle EBS R12.0.6 (Core HR, Payroll, Confidential, OTM), Reports Manager, Web ADI, AME

Confidential

Oracle HRMS Analyst

Responsibilities:

• Mainly involved in upgrading the system by performing the pre upgrade and post upgrade steps. Based on the TUMS (The Upgrade Manual Script) necessary steps are done in pre upgrade and post upgrade process by eliminating the steps that are not necessary.
• Supported CoreHR, Payroll, SSHR, OTL modules.
• Worked on Changes to the existing Fast Formula (Accrual Plans), Alerts and other business logics according to recent changes.
• Worked on Solution to architect for imputed earnings gross up and same sex domestic partner benefits.
• Worked on Converting Crystal to BI Publisher reports
• Worked on Code debugging, Review, defect sheet updating and checking into Clear case.
• Prepared functional design specification for the Benefit Structure / Eligibility / Rates / Premiums /Others as per the User needs.
• Involved in Design of Life Events, Eligibility, Rates and System Extracts (e.g. Carrier Extracts, AP, Payroll etc.)
• Prepared functional specifications for the Carrier Extracts and designed/configured/tested the Extracts in Confidential using System Extracts.
• Used AIM Methodology for Confidential Project Plan documents/deliverables.
• Conducting knowledge-sharing programs on every week among the team members.
• Responsible for designing and developing various reports like sales data collection, check register, store lists etc.
• Oracle Application Object Library (AOL) features like value sets, Flex fields, Concurrent Programs, Profile Options, standard request submissions and parameters are extensively used in the process of development
• Provide on call and daily production support of APEX applications and Oracle PL/SQL ETL processes.
• Manage User Acceptance Testing of new applications and new versions of existing applications.
• Manage the packaging and release of applications to the training and production environments.

Environment: Oracle Applications 11.5.10 (CoreHR, Payroll, SSHR, OTL), APEX, Oracle Database 9i, SQL, Application Object Library (AOL), SQL DEVELOPER.

Confidential

Oracle Technical Developer

Responsibilities:

• Involved in extending the functionality of Core HRMS modules. Successfully Interacted with Functional Consultants, QA team, DBA team and development teams. Developed Technical MD70 specification.
• Customized menus, added new concurrent requests, registered the custom applications, value sets etc. using System Administrator Module.
• Involved in implementing various business process extensions of HRMS as per the business requirements.
• Personalized and extended various web pages on SSHR using Oracle Applications framework. Added Custom notes as per HR Polices.
• Designed the conversion of key HR, Payroll and Benefits systems from a Mainframe to an Oracle platform. Composed detailed specifications to serve the conversion process.
• Created PLSQL Procedures for importing year end W2 information from companies acquired.
• Customized and extended fast formulas.
• Supported a diverse variety of vendor software solutions including JAT Print view plus(W2), Apollo Space Planning/ Management and Transcentive Express Stock Options.
• Wrote complex SQL queries, Control files, Procedures, Triggers and Packages.
• Worked on Metalink to raise and track Service Requests to Oracle.
• Coordinated knowledge transfer to technical team and guided them on prevailing technical issues and general Oracle Applications issues.

Environment: Oracle Apps Release 11i (11.5.10) (Core HRMS, Payroll, Benefits)