SUMMARY

• Over all 11+ Years of Experience in Oracle HCM and HR Information Systems and implementation of Oracle EBS HRMS and Cloud HCM Fusion applications.
• Expert in identifying business requirements and map them to the Oracle Fusion functionality.
• Experience in Creating HCM Extracts and Delivery Options for Extracts.
• Experience in Creating Reports and Analytic using Fusion HCM BI.
• Experience in Creating custom reports and analytics using OBIEE.
• Strong understanding of Software Development Life Cycle (SDLC). Knowledge of both Agile and Waterfall Software development methodology.
• Good experience coordinating with Oracle team on SR's and critical issues during the HCM Cloud implementation and ongoing Support for quick resolutions.
• Proficient 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).
• Proficient in Inventory, Purchasing, Order Management, BOM, WIP, ASCP Modules and Knowledge in GL, Advanced Pricing, AME Modules.
• Experience in Oracle to SAP Ariba and Success Factors conversion and implementation.
• Expertise 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 developing functional, technical design and documentation for Oracle HCM Cloud conversions, and interfaces.
• Experience in developing functional and technical design and documentation for Oracle HCM Cloud using data conversions, interfaces, custom reporting.
• Involved in end to end implementation, customization, conversion, interface, extension, development, production support and testing in Oracle E - Business Suite (EBS) 11i and R12.
• Worked on Implementing and Testing Oracle Fusion applications Procurement, SCM and Supply Chain Financial Orchestration modules on Premise and on Cloud.
• Expertise in working with the Business Analysts and Functional Consultants to gather requirements for reports, interfaces, extensions and integration.
• Configured Legal Employers, Tax Reporting Units, Payroll Statutory units, Payrolls, Earning Elements, Supplemental Earnings
• Strong experience in Manufacturing, Procurement and Supply Chain modules of Oracle EBS working with Discrete, Distributions and Process Manufacturing Clients
• Incorporated an effective supply chain management to include inventory procurement, and sales forecasting
• Especially on items involving short life cycle and high demand volatility by integrating Oracle EBS Procure-to-Pay module.
• Configured Voluntary & Involuntary Deductions, Pre - Tax elements, Employer Liabilities, etc.
• Extensively worked on API's, Alerts, and RICE, Workflow, XML Publisher Reports, SQL Loader utility scripts and PL/SQL in writing stored procedures, functions, reports, fast formulas.
• Full Life Cycle implementations of Global HR and Talent Modules and support experience for Benefits and Payroll modules.
• Good knowledge of the Oracle EBS R12 data model for the modules OE, AR, AP, PO, GL, OKS, MTL, FND, CS.
• Expertise in identifying functionality gaps and builds extensions.
• Experience in developing functional and technical design and documentation for Oracle Applications using data conversions, interfaces, custom reporting.
• Experience in functional and technical consulting services by acting as subject matter expert and leading clients through the entire cloud application services implementation lifecycle for Oracle Fusion projects.
• Handled Fusion HCM Cloud Implementation, HCM Cloud Upgrade/Patch updates, Cloud Testing, Support & Maintenance.
• Excellent skills in Back-end testing using SQL Queries. Experience interacting with Business Analyst/Leads/Developers to analyse the user requirements, functional specifications and also for missing Functionality.
• Excellent analytical skills, documentation skills, communication skills, presentation skills, strong problem solving skills and a very good team player in both independent and large team environments.
• 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 managing HR data requests and Assemble, analyse and format data into useable reports.
• 4 Full life cycle implementation of Oracle E - Business Suite (MFG, SCM & ASCP modules) including design, setup, development, implementation and support of manufacturing systems, with excellent knowledge on MFG/SCM/ASCP modules.
• Involved in conversion requirements, converting people data, assignment data and salary data.
• Experienced in configuring Workflow routing rules for all Manager Self-services and Employee Self-services.
• Compile the statistical information and prepare reports relating to payroll, recruiting, compensation, training, employment etc. utilizing the HRIS systems.
• Experience in developing HCM interfaces within the modules of HR, Payroll and Benefits.
• Excel in interacting with the project team members responsible for developing reports, interfaces, data conversion programs, and application extensions and be able to lead discussions during business requirement meetings.
• Experience in Data loading into Oracle HCM Cloud using SQL Loader, FBL, HCM Data Loader (HDL) and PBL.

TECHNICAL SKILLS

Operating Systems: Windows, Linux, UNIX and Mac and Linux.

Databases: Oracle, DB2 and MS SQL Server.

Languages: SQL, PL/SQL and UNIX Confidential script.

Application Tools: EBS, Cloud Fusion, Oracle Business Accelerator, Toad, SQL dev, Office Suite (Excel, Word, Project, PowerPoint, FrontPage, Publisher, Visio), OIM, File Based Loader, Spreadsheet Data Loader, Informatica.

ERP: Oracle HCM Cloud Solution (v10, 11, 12), Oracle Applications 11i./12x (Core HR, SSHR, OLM, Payroll, OAB) up to EBS R12.2.4, Multithreading, ASCP, Inventory, Purchasing, Order Management, Bills of Materials, Work in Process, General Ledger, Advanced Pricing & AME

BI: Oracle EDW, SQL Server, SQL Server 2008/2012 Analysis Services and SQL Reporting services.

Modules: SCM (OM, PO, INV), Financials (AP, FA GL, AR), Oracle process Manufacturing (OPM) SQL, PL-SQL.

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NY

Sr. Oracle Cloud HCM Consultant

Responsibilities:

• Involved in Oracle HCM cloud implementation. Interacted with client and involved in Requirement gathering, preparing process requirement documents
• Business requirement documents, understanding current business process and mapping with Oracle Cloud HCM.
• Lead the data conversion effort to facilitate good quality of data from Oracle EBS to Oracle Fusion HCM.
• Using Oracle e-Business Suite with emphasis in Oracle Process Manufacturing OPM, versions 11i R12, implemented complete manufacturing and supply chain solutions.
• Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Modeled both domestic and international supply chains using both Discrete and Process Manufacturing solutions
• Involved in performing 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.
• Involved in designing & building HCM Extracts for Inbound & Outbound Interfaces using FBL and HDL familiar with Fusion Cloud data model and build various BIP in fusion cloud environment.
• Worked with development to design data extracts for data conversion and daily FTP data feed to TPA.
• Modifying HR ADP views to prevent element entries from transferring to payroll Confidential.
• Worked as a senior Oracle R12 EBS Functional Consultant with expertise implementing, upgrading and supporting OAB (Advanced Benefits).
• Worked on requirement gathering and development of new reports in BI Publisher and OTBI and implementation consultant for Fusion HCM implementation project.
• Lead the data conversion effort to facilitate good quality of data from Oracle EBS to Oracle Fusion HCM.
• Designed Conversion Strategy and Conversion Data Mapping Documents for HR/OAB, OTL modules and wrote conversion programs using API's.
• Provided Oracle Application support in the following modules: HRMS, Self Service, PTO, Performance management, Compensation Workbench, Oracle Time and labor, Payroll
• Created an implementation project to maintain the setup of specific business processes and activities for Fusion HCM, Global HR.
• Developed HCM Data Extracts in Oracle Fusion Cloud OTBI and Oracle EBS R12 and prepared Data mapping, Design data file and migration documents for the RICE components.
• 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.
• Created Ariba reports using Purchase Orders, invoices, Requisitions, contracts workspace, Sourcing and Created Vendor Maintenance Reports for Finance, Accounting, budget, Applications and accounting departments
• Experience working in SOA methodologies, worked on SOA integration with Ariba procurement software
• Worked on requirement elicitation for PeopleSoft HCM with Ariba procurement software
• Working experience of Ariba Procurement software migration to Oracle 11g server
• Worked on HR Conversion using FBL (Person, Assignment and Work Structure) and co-coordinated activities with onsite team.
• Created fusion security profiles and creating custom job roles based out of seeded job roles for Employee Self Service (ESS) and Manager Self Service (MSS).
• Designed Conversion Strategy and Conversion Data Mapping Documents for HR/OAB, OTL modules and wrote conversion programs using API's.
• Worked as Oracle consultant as part of Oracle HRMS R12 implementation for Oracle Core HR, CWB and OAB.
• Provide support for Ariba system sourcing, supplier and spend visibility modules
• Responsible for shared modules Oracle Advanced Pricing, Oracle HR, Oracle iPayment, Oracle Order Management.
• Customized OTBI reports, Payroll Extracts, HCM Extracts to feed the information to third party systems and downstream 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 performance module of PeopleSoft HCM.
• Created multi language translation reports, analytics and dashboard using Oracle XML/BI Publisher, OTBI and OBIEE.

Confidential, Pittsburg, PA

Oracle Cloud HCM Consultant

Responsibilities:

• Involved in client meetings during implementation process and gather the requirements.
• Worked on Enterprise level designs and configurations. Mapped and solved the conversion issues related to the business units, salary basis and workforce structures.
• Involved in extracting data from EBS data mapping transformation and data migration through oracle cloud.
• Involved in data conversion from Legacy to Oracle HRMS.
• Involved in writing interfaces using HCM extract and BI publisher to move data between oracle cloud and external systems like ADP.
• Created eligibility profile, alerts, dynamic calculations, cross references while setting up the compensation plan.
• ASCP Collections programs and Plan monitoring and scheduling the concurrent requests.
• Proficient in Inventory, Purchasing, Order Management, BOM, WIP, ASCP Modules and Knowledge in GL, Advanced Pricing, AME Modules.
• Designed programs to upload time from Time force to OTL data conversion including time and attributes for OTL module.
• Involved in conversion requirements, converting people data, assignment data and salary data.
• Setup approvals, Individual compensation plans, Plan Eligibility, Plan Cycles, Compensation Budgets, Compensation components, performance ratings, Workforce compensation approvals and Total Compensation Statements.
• Closely worked with oracle support by raising HR and followed up configuration issues and supported bug fixing.
• Configured WMS to integrate with OPM Oracle Process Manufacturing and OSP Outside Processing processes.
• Complete understanding of Oracle Apps Implementation in R12 and 11i and Upgrade Projects from 11i to R12. Performed several end-to-end implementations, upgrades as well as conducting
• Tested and maintained Oracle payroll module software for enhancements and complete new conversions.
• Ensured that the application meets the business requirements and system goals fulfil end user requirements, and identify and resolve system issues.
• Reported to higher Management on progress and status for all business-related work products and deliverable.
• 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.
• Responsible for establishing and adhering to the projects communication plan and complying with all reporting requirements.
• Collaborated extensively with development team on development and customization of Oracle RICE (Reports, Interfaces, Conversions and Extensions) components as per business requirements.
• Setting up application for Fusion Benefits - Open Enrolment which includes Creating of New Benefit plans, new plan Rates, Eligibility profiles, Fast formulas, running batch processes etc.
• Train the users on core HR, compensation and talent management.
• Provided end user guides and trained user on core HR, compensation and talent management.
• Use Oracle Fusion Functional Setup manager (FSM) to implement Global HR, Payroll, Benefits and Compensation Management.
• Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Process Analysis & Requirement gathering, Configuring, Testing, Go-Live and Production Support.
• Serves as the compensation workbench analyst for support organization.
• Expertise with Human Capital Management, Benefits, Compensation Workbench applications.
• Consults with customers to determine functional business need, expected outcomes and solutions to deliver expectations.
• Collaborates with oracle development in case of application defects and assist in the creation and delivery of code fixes.
• Maintains personal knowledge of legislative policy applicable to application functionality specifically the affordable care act.
• Communicates with assigned customers to ensure service satisfaction and professional understanding.

Confidential

Oracle HCM Payroll Analyst

Responsibilities:

• Participated in the design and optimization of all global HR processes.
• Implemented Co-Existence model for migration from Oracle EBS - R12 to Oracle Fusion HCM.
• 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.
• Managed the global HCM employee record database.
• Defined setups of Core HR, Self Service HR, Payroll, Oracle Time and Labor (OTL), iRecruitment and Performance Management (PMS) modules to map the business requirements into Product functionality. Support experience in Oracle Advanced Benefits (OAB) and Oracle Learning Management (OLM).
• Worked on the Data migration activities of Core HR/Payroll through conversion scripts (like personal, assignment, job, position, grade, qualifications, pay proposals etc.).
• In affiliation with Payroll and HR, management and execution of the pay-load process to ensure quality and timeliness of paycheck distribution
• Provided roadmap document, executive summary and strategy for upgrade to current release for two modules, Absence Management and Time and Labor.
• Configured Absence Management to comply with changes in business requirement in Test and full configuration in the production environment.
• 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.
• Created roadmap document as well as migration guide for Absence and Time and Labor module to current environment.
• Captured requirements and provided recommendations to the design of Fusion Absence Management.
• Created File Based Loader & OTBI reports with HCM Extracts integration in HCM Cloud.
• Responsible for requirement analysis, design and architect of the business processes in Oracle Cloud and transition from 2 existing legacy applications for Compensation.
• Configured Absence Management according to business requirements in test and production environments
• Worked on Time and Labor rules, eliminated those not needed anymore, and provided guidance for change or consolidation for those currently not producing desired results.
• Extended and customized the OBIEE metadata repository including the physical, business model, and presentation areas.
• Analysed and Resolved production support issues in PeopleSoft HCM, custom/vanilla modules and interfaces, solved integration issues between HCM cloud and external/legacy systems to help deliver a seamless product
• Developing HCM Extracts for Global HR, Payroll Interface and Fusion Benefits.
• Provided solutions for ad hoc queries on Core HR, Benefits, Talent Management, Compensation STIP plan.
• Responsible for implementation of HCM Cloud Time and Labor.
• Technical lead for Oracle support for Oracle HR, Payroll and OTL Time and labor.
• Build Custom Security to Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Worked on Fusion R10 and R9 configuration (workflows, DFF, EFF, KFF, Business unit, LE, Compensation elements, rules, notifications, workforce management).
• Worked on Absence Integrations with Payroll, OTL and Workforce scheduling and Organized the testing process and Bug Reporting using ALM.
• Worked as Oracle HCM Analyst and provided best-practice guidance on HCM business processes on OTL and Payroll integrations and mass updates.

Confidential

Oracle HCM Analyst

Responsibilities:

• Analyzed Goodyear HR/Payroll business needs through client business users working sessions and documented new business processes and a future state design.
• 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 support 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.
• Involved in configuration of Oracle EBS R12 Financial Modules on CRP2, SIT, UAT Instances & Production Instance.
• Wrote customized fast formula for PAYROLL deduction elements.
• Identifying and addressing client needs: building solid relationships with client and 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.
• Assisted the HRIS department in timely and accurate processing of employee data and related HRIS information.
• Worked on 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 .
• Conducted CRP, Integrated Testing & User's Acceptance Testing, self-service (ESS and MSS) •
• Prepared baseline, business requirements, fit/gap analysis and application setup using AIM methodology
• Set up BR100 for Learning Management, Compensation Workbench, attendance, deductions, position management, referral rules.
• Trained client staff in setup configuration and module use, Taleo (TCC and TSS ), referral rules, referral pages, integration and XML, OAB, OLM.
• Delivered CRPs, Unit/Integration and UAT tests, data extraction, support and configuration .

Confidential

Business Analyst

Responsibilities:

• Participated in business requirement walk through, design walk through sessions with functional and technical teams to develop the design documents.
• Benefits, T&L, ELM, Student Record, Student Financials, and Campus Self Service).
• Gathered requirements, organized team meetings requirements from business users such as insurance policy managers, generated business process models, & use-case models, and created business requirements document (BRD) & functional requirements document (FRD).
• Involved in the technical Implementation of PeopleSoft HRMS modules (Core HR, Payroll and Benefits with open enrolment).
• Worked as a SME/Business Analysts for e-Performance, Successive Planning, related module like Position Management, e-Profile, e-Compensation etc.
• Created and customized new pages, records, fields and components through Application designer.
• Experienced on Oracle Functional consultant for SCM/ASCP Modules.
• Strong expertise supporting CRM, HRIS and multiple proprietary business systems
• Assist team in the implementation of Workday.
• Work with consulting partners on the Conversion tasks, Integration tasks, Security tasks, and Reporting tasks.
• Worked with Process Scheduler, Process Monitor, Edited Run Control, Granting security access and scheduled programs on recurring basis.
• Experienced on PeopleSoft HCM, HRMS and FSCM modules like HR (Human Resources), Benefits, ELM, Global Payroll, Time & Labour, Compensation, and e-Performance, FMS.
• Created SQR reports/interfaces, Crystal reports and modified custom PS objects.
• Involved in the development of SQR's and customization using People Tools based on the technical design specification given by client.
• Setup Integration Broker for HRMS and Financials for transfer data.
• Created SQR process to export data from HRMS to Financials through XML publisher.
• Designed and developed the XML publisher reports in payroll modules.
• Designed and developed the Technical and Functional specification document for Payroll Interface
• Participated in setup of the Time and Labour application for the PeopleSoft Implementation.
• Includes Reporting Elapsed Time, Approving Time, Adjusting Time, Labour Distribution and Dilution and Integration with a Global Payroll system and integration with PeopleSoft.
• Developed Component Interfaces to bring data in PeopleSoft HR tables from legacy systems.
• Developed functional and technical specifications for Compensatory Time and Schedules and Forecasting.
• Created Business Process flows based on discussions with HRIS and Business Partners.
• Participated in customization of Time and Labour that facilitates the management, planning, reporting.
• Involved in design, development, enhancement and maintenance of PeopleSoft HR, Base Benefits, e-Recruit and Payroll.
• Developed PS queries, SQR reports and Crystal Reports as per the requirements and provided support and knowledge transfer to functional team.
• Involved in setup of PeopleSoft HCM Core HR Module.
• Involved in Regression testing such as testing of application for various scenarios and ensure that it meets functional specifications for transactions pertaining to Global HR.
• Conducted every day status meetings to discuss the outstanding issues with team.
• Implemented requirement gathering & management using Rational Requisite Pro, and business intelligence tools.
• Integration Broker: Configured Local node, remote nodes and setup the services and queues.
• Used Application Engine, people code and SQR extensively to create processes, outbound files and reports. Developed Outbound files like Employee, benefits etc. using SQR.
• Designed and customized HR Payroll to GL Interface using Integration Broker.
• Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.