SUMMARY

• Worked as Oracle Fusion HCM R13 (Human Capital Management) and Oracle EBS HRMS R12 (E - Business Services) consultant.
• Experience in all phases of implementation of Oracle Fusion HCM using offerings like Workforce Deployment (Global HR, Payroll, and Absence Management), Workforce Development (Performance Management, Goal Management) and Fusion Security in version R8 to R13.
• Hands on experience on customizing the security, by creating data roles, security profiles andeffectively using job roles and duty roles.
• Experience in creating Table type value sets for fast formulae.
• Experience in HCM Extracts, PBL, HDL and mass data updates/uploads.
• Knowledge on configuring Transaction Approvals, also customize the approval flow based on Locations, Employee Job, New Person creation and many more.
• Knowledge on various types of fast formulas includingPayroll Calculations, Accrual Plans, Validation of Element Inputs or User Tables, Assignment Sets, Absence Duration, Extract Rule
• Conducted CRP for requirement gathering, application demo and gap analysis.
• Experience in creating and publishing sandboxes for page personalization
• Built Complex inbound and outbound interfaces forHR, Payroll, Absence, T&L modules and Taleo.
• Expertisein payroll configurations related to earnings, deductions, information elements and maintaining system balances in different dimensions.
• Experience in working on Calculation cards for involuntary deductions.
• Strong Knowledge in end to end payroll cycle starting from payroll pre-processing to costing and transfer to GL.
• Handled 40 odd payroll processing along with post payroll activities such as costing, transfer to GL and data analysis using oracle provided seeded reports.
• Pro skills and handled projects with a combination of technologies - Oracle PLSQL, AME, Oracle Forms and Reports, Oracle workflow, Oracle transactional Business Intelligence (OTBI) and BI reporting.
• Extensive experience in executing end-to-end projects in domains like Insurance, Airline, Retail and properties, ERP HRMS, Self Service Portals (Employee, Customer, Supplier), Bespoke Application Development etc. as per quality & time norms
• Total of 9+ yrs. experience in managing major enhancements delivers. During this phase handled a team of 25+ members covering all phases of the SDLC cycle.
• Experience in Oracle EBS 11i & R12HR modules like OLM, Oracle Advance Benefits, OTL, HR, Payroll, and Absence Management.
• Proficient in business process study (As Is & To Be), gap analysis, cost benefit analysis, business process modelling, process flow & interface design to suit business requirements
• Adept in pre-project studies, project effort estimations, and customer demos/ customer trainings.
• Skilled in managing and negotiating with stakeholders having diverse cultural environments with the accountability of informing them on current and future scenarios, by acquiring feedback on critical issues and taking suitable actions to ensure positive experience and increase in user adoption.
• Expertise in building teams and developing skillsets across technologies, domains and functions in accordance to the business development strategy and sales pipeline / forecast.
• Strong experience of leading & implementing all phases of Software Development Life Cycle using waterfall / agile/devops methodologies.
• Proficient at HRMS User Hooks, fast formula, Conversions, Interfaces, Data migration API and Alerts.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL.
• Focused & committed team player having an Entrepreneurial bend of mind, with an interest in innovative ideas which can turn into excellent projects.
• Appreciated for cordial relationship maintained with customers and ensuring customer satisfaction without comprising on the any quality parameters.

TECHNICAL SKILLS:

Technologies: Oracle Fusion HCM Cloud R13: Global HR, Payroll, Absence Management, Performance Management Oracle EBS R12, 11i: HRMS, Payroll, GL, AP, AR, Web Service (SOAP, REST) Taleo Connect Client 17.4

Tools: BI Publisher, Forms/ Reports 10g, Taleo Connect Client 17.4, TOAD,Informatica 8.6/8.1, Workflow Builder, Eclipse IDE, HCM Desktop Integrator, SOAP UI

Languages: SQL, PL/SQL, C, Core Java, Python

Database: Oracle 12c/11g, MS SQL Server 2008/2005

PROFESSIONAL EXPERIENCE

Oracle Fusion Cloud HCM Technical Consultant

Confidential

Responsibilities:

• Identify business requirements and align them to Oracle Cloud/Fusion HCM functionality
• Worked on Core HR, Absence Management, Talent Management, Benefits, Payroll modules.
• Understanding the Business requirements to be a part of the FUD (Functional Upgrade Doc), and FDD (Functional Design Doc)
• Use Oracle Fusion Functional Setup Manager (FSM) to implement Global HR/Core HR.
• Data migration using HDL - HCM data loaders.
• Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Configured the Absence Management module to enable the Vacation and Sick plans.
• Written Accrual fast formulas to support the vacation and sick absence plans.
• Developed new BI reports to extract the absence details and related other reports.
• Developed and configured new roles (Job, Duty and Data roles) using the Fusion Security model.
• Developed complex person security profiles, organization security profiles to support the complex custom criteria while configuring the job and data roles.
• Written a Payroll Batch Loader transformation formula to load the Element Entries.
• Element Configuration using Payroll Batch Loader.
• Element Input Values load.
• Element Eligibility Profiles load using Payroll Batch loader.
• Developed HCM Extracts to extract the data from Oracle Cloud systems
• Developed BI publisher reports in Absence, Core HR and Payroll area and developed full profile and changes only HCM extracts.
• Configured Fusion Applications for the End-to End Performance Cycle
• Tested Core HR, Interfaces and Reports for Release upgrade.
• Conducted extensive testing cycles and solution design workshops
• Designed custom reporting and interfaces to meet client and audit requirements
• Supported client in Oracle Cloud UI personalization's and customizations for end users
• Configured custom security and data roles for different employee populations
• Part of business process workshops/CRPs and requirements gathering sessions and support clients in defining relevant processes.
• Configured HR and Absence management modules.
• Coordinating with Oracle for SRs, new product releases, upgrades/patches/fixes.
• Set up and Maintained Enterprise HCM structure and Workforce structures.
• Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Fusion with Workforce Deployment (Global HR), Workforce Development (Talent Management).
• Configuring custom Workflow routing rules for all Manager Self-services and Employee Self-services with help of Area Responsibilities.
• Developing HCM Extracts for Global HR, Payroll Interface and Fusion Benefits.
• Perform Starter steps like Create Implementation Users; View all data roles, Load/Manage Geographies.
• Implemented Workforce Compensation in Oracle Cloud for a global company
• Manage Enterprise HCM Information.
• Set up and Maintained Enterprise structure and Workforce structures.
• Creating eligibility profiles, rate definitions, absence plans, reasons and categories.
• Configured absence plans and absence categories and assigned those to employees using eligibility profile.
• Enabled the vacation and sick plan in the existing absence plan set up.
• Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Extensively used Payroll Batch Loader(PBL) for Create, update, and delete data for supported objects
• Build Custom Security to Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles
• Developed HCM Extract for Global HR, Payroll Interface
• Working on developing inbound and outbound Scripts for Taleo Connect Client 17.4.(SmartOrg, Recruiting, Transitions).
• Experience in creating the payroll definitions and proficiency in payroll process &writing fast formulas for proration and retropay.
• Worked on custom payroll costing solution and labor distribution
• Performed various individual balance adjustment for scenario such as, Bonus Overpayment, Vacation Payout, and employee getting paid even after termination, recording off cycle payments in Oracle.
• Configured elements for Year-end balance adjustments for United States such as Health Savings Account ER and Gross-ups (Awards/Gift Cards).
• Built complex layouts using e-text and rtf templates.
• Designed and developed several custom reports in XML using BI Publisher applications
• Worked on HCM Fusion REST and SOAP API’s to push the data from EBS to HCM Cloud
• Involved in full life cycle implementation of Taleo, Oracle HCM cloud Global HR, Benefits modules.
• Played significant role in Oracle HCM Cloud pre-project phase, data conversion and project sprint sessions, development with data mapping templates for Oracle EBS to Core HR Cloud transformation.
• Wrote custom PL/SQL code for data conversions for work structures, person, assignment and payroll information from legacy EBS to Oracle HCM Cloud.
• Designed and Developed Taleo to EBS integration to bring in the data in to Oracle EBS using person, assignment, address, SIT, EIT API’s
• Played a key role in writing lean spec documents for legacy applications, reengineered and optimized the processes for value addition and efficiency.
• Developed Complex inbound and outbound custom interfaces to send/bring in data from third party applications using PL/SQL
• Involved in preparation of Test Cases, Test Scripts for the Core HR, Benefits, Talent and Global Compensation.
• Ensure that the application meets the business requirements and system goals fulfil end user requirements, and to identify and resolve system issues.

Oracle Fusion HCM Technical Consultant

Confidential

Responsibilities:

• Implemented Oracle Fusion Cloud Performance Management in Co-Existence Model with Oracle E-Business Suite
• Developed HDL for Data loading into Oracle Fusion Cloud HCM.
• Written Accrual fast formulas to support the vacation and sick absence plans.
• Developed PBL for Data loading into Oracle Fusion Cloud Payroll
• Developed HCM Extracts to interface with external applications
• Developed BIP reports to cater custom Oracle E-Business Suite requirements in Oracle Fusion Cloud
• Developed fastformula for HCM Extracts, PBL batch processing, Performance Management Templates, Payroll Calculations
• Worked on designing and developing RICE (Reports, Interfaces, Customizations and Extensions) objects to as per the custom business process within Oracle HRMS implementation
• Configured HR and Absence management modules.
• Coordinating with Oracle for SRs, new product releases, upgrades/patches/fixes.
• Provided business consulting support and facilitates discovery workshops.
• Perform Starter steps like Create Implementation Users; View all data roles, Load/Manage Geographies.
• Set up and Maintained Enterprise structure and Workforce structures.
• Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Fusion with Workforce Deployment (Global HR), Workforce Development (Talent Management).
• Configuring custom Workflow routing rules for all Manager Self-services and Employee Self-services with help of Area Responsibilities.
• Developing HCM Extracts for Global HR, Payroll Interface and Fusion Benefits.
• Coordinate with QA team and ensure the product is bug free and ensure all test cases and scenarios are covered.
• Creating Oracle Fusion BI Reports and Analytics.
• Streamline Recruiting & On boarding processes with Core HR applications.
• Build Custom Security for Fusion HCM which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Ensure that the application meets the business requirement and system goals fulfil end user requirements, and to identify and resolve system issues.
• Customized Oracle XML Templates in Core HR module.
• Defined Security profiles according to the requirement.
• Integration of oracle apps with FMW in high level Architecture
• Developed OTBI reports for End User Requirements
• Developed custom payroll registers to view employee earning, gross pay details
• Developed complex custom logics in Oracle PL/SQL
• Experience in invoking SOAP/REST Web services using UTL HTTP API in PLSQL
• Developed D2k Forms and Reports
• Extensively worked on Performance tuning
• Liaise with business users to identify cost effective and productive areas of improvement to current operational procedures.
• Customized Oracle EBS Flex fields according to the requirement.
• Prepare/Review solution design and implement modular, extendable and accurate solutions.
• Collaborate with customers in outlining business processes and recommend/implement process improvement case studies.
• Gather user requirement on system enhancements.
• Track and manage deliverables from development team. Ensure no slippage of deliverables.
• Accountable for Quality deliverables.
• Document Standard operational procedures and user manuals.
• Conduct training sessions for business units on all application across HR landscape.
• Head and manage various teams across the SDLC phase of the enhancements/projects.
• Manage the second level user support for the end user community on functional clarifications. SLO tracking for all applications.
• Held presentations to Business users on prototypes, conduct meetings, convert requirements and solution into IT documents, engage users for testing (User Acceptance testing), deliver quality applications to users and train the users.
• Involved in both functional and technical analysis which enables effective gap analysis and propose effective solution.
• Develop effective relationships with clients and partners to exchange information and meet business & operational objectives.

Oracle APPS/Fusion Technical Consultant,

Confidential

Responsibilities:

• Developed complex queries, joins, stored procedures, functions, triggers, packages in PLSQL for various business requirements.
• Experience with masking, unmasking of data.
• Participate in peer-reviews, identify and encourage areas for growth and improvement within the team.
• Reviewing the requirements, design, and code for the changes and the new capability enhancements in accordance with established standards.
• Conduct POC and submit proposal to further translate them into projects.
• Coordinating with the Business users to understand the enhancements required and issues faced.
• Carrying out Operational Acceptance for all projects going live.
• Guiding the team towards requirement understanding and resolution of issues
• Ensuring smooth run of period closure activities.
• Implementing critical code and data fixes.
• Invoking SOAP/REST Web services using UTL HTTP API in PLSQL
• En-queue and De-queue from Oracle Advance Queue
• Designed and developed interface programs to extract data from custom web application objects, populate to staging table, validate the data in staging table and send to interface tables
• Worked on PL/SQL objects such as stored procedures, functions, packages for development.
• Designed and developed the custom reports using XML publisher.
• Extracted data from different sources such as Oracle, SQL Server, and Flat files to load into staging area and then load into Oracle base tables.
• Involved with Data migration activities of Core HR/Payroll through conversion scripts (like personal, assignment, job, position, grade, qualifications, phones, SIT's, initial balance, bank details, element entry, pay proposals etc.)
• Worked on design and development of custom complex oracle forms using Oracle forms builder 11g.
• Defined value sets, menus, concurrent programs, report sets, registering custom build forms, reports and PL/SQL procedures, triggers and packages and creating executable using Application Object Library in the development environment.
• Develop data integration workflows and load processes, ensure adherence to internal standards for all developed components and provided technical documentation of source and target mappings.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Developed and Scheduled jobs for the daily load data that invoked Informatica workflows & sessions associated with the mappings, SQL scripts to drop & recreate the indexes on source and target tables.
• Worked on error resolutions faced in GL cross validation rules used in requisition account generator validation process.