PROFESSIONAL SUMMARY:

• Over 8+ years of experience in designing, developing, converting, implementing and customizing of Oracle Fusion Cloud Applications and Oracle Applications (Oracle E Business Suite).
• Involved in Oracle Fusion (HCM), Oracle Applications R12 and 11iUpgrade, implementation and Support in (GL, AP, AR, PO, INV, OM and HRMS) modules.
• Involved in requirement gathering, interacted with various business stack holders across regions.
• Experience in designing and developing of complex Custom Forms, Interfaces, Reports, XML Reports, OAF Personalization and Workflow in Oracle Applications.
• Worked on AP AME Position Hierarchy and Approval workflow development.
• Created MD050 documents for high level functional designs.
• Expertise in loading the legacy information system to release 11i and R12 which includes GL,AP,AR,PO,INV and OM modules using PL/SQL and SQL*Loader.sd
• Hands on application expert and prepare project deliverables (CRP testing scenarios, business process procedures like TE040, TE20 etc.)
• Prepare understanding documents on customized business flow for end user for ease of use.
• Oracle Fusion functional module exposure includes knowledge on Core HR, Benefits, Talent Management and Payroll modules.
• Oracle Fusion technical knowledge on tools like File Based Loader, Spreadsheet Loader, Payroll Batch Loader, Page Composer.
• Worked on Oracle Identity manager for implementing security for Oracle cloud based HCM projects.
• Worked on Oracle Business Process Manager for managing approval tasks in Fusion.
• Good knowledge of report customization and development.
• Worked on fit gap analysis, retrofits, flag flipping for upgrade and ongoing enhancements.
• Worked on preparing technical design document in adherence to quality standards and procedures on development projects for multiple clients.
• Worked on preparing Unit, Integration and UAT test cases in adherence to quality procedures and carrying out the testing to ensure quality delivery.
• Worked on building an integration tool to integrate Oracle EBS and Oracle Fusion.
• Worked as functional consultant to do the requirement gatherings for configuration, conversion and enrollments in Fusion Benefits
• Worked hands on as a benefits development consultant for configuring and running conversions in Oracle Fusion
• Worked as release manager for a project during Go Live.
• Strong analytical, problem - solving, organizational, resourceful team player as well as team lead.

TECHNICAL SKILLS:

HRIS ERP: Oracle Fusion HCM Cloud (Release 7, 8, 9, 10, 11), Taleo15A, PeopleSoft HCM 9.1, 8.9.

Oracle Fusion HCM Cloud Functional: Coexistence PSFT/EBS/SAP/Taleo, Core HR, Absence, T&L, Compensation & Benefits, Performance Management, Talent, Payroll Interface, Benefits Extracts, Security OIM, APM, FSM.

Oracle Fusion HCM Cloud Technical: FBL, HDL, PBL, Fast Formulas, HCM Extracts, BI, OTBI, Custom. Integrations, Mobile App, Good Understanding/knowledge of REST/Atom based integrations.

PeopleSoft HCM Functional: Global Payroll, GP Country Extension, Recruiting, Workforce Administration, Candidate Gateway, ESS, MSS, Performance Management, Compensation & Learning.

PeopleSoft Technical: Application Designer, People Code, SQR, Application Engine (AE), CI, Data over, Application Package, File Layout, XML Publisher, Integration Broker, WSDL, LDAP, Tree Manager, PS Query.

Management: Project Management, Change Management, People Management, MPP, MS Office, Excel.

Sales & Presales: RFP, RFI, Estimation, Bid Management, Proposal, Workshops, Product Demos/ Videos, Fit Gaps, HCM Transformation, Health Checks.

Implementation Methodology: Oracle True Cloud (TCM), Oracle True Cloud Plus, Capgemini IMPACT based on OUM.

PROFESSIONAL EXPERIENCE:

Confidential, Concord -CA

Senior Fusion HCM Consultant

Responsibilities:

• Worked on Core HR, Payroll and Benefits modules.
• Configured new data roles based on the Person and Organization Security profiles.
• Rate Value Calculation Fast Formula - Written fast formulas to calculate the Employee rate for the plans enrolled in Benefits.
• Coverage Value Fast Formula - Written fast formulas to calculate the coverage value.
• Person Selection Fast Formula - To run the benefit evaluation processes.
• HCM Extract Rule Fast Formula - To identify the Pay group change.
• Developed more than 20 BI publisher reports in Benefits, HR and Payroll area and developed 2 HCM extracts, one of them is a change only extract.
• Developed new interface to generate employee information as an encrypted file to third party medical services provider via FTP.
• Developed the reports using scheduling triggers to notify the Developed OTBI reports for HR users to view and validate employee data using existing subject areas. Subject areas are functionally secured using Oracle fusion duty roles.
• Restructured the BI catalogue to enable the security to give controlled access to Benefits, compensation, payroll and Human resources teams.
• Created new eligibility profiles to assign the Individual Compensation Elements to the right groups of the employees
• Configured the workflow and approval tasks for Salary Change, Promotions, Transfers, Work relationships, Change manager, Change Location, working hours change, Termination and ICD approvals based on the business requirement to route the approvals.
• Common configurations in Core HR area like DFF, EFF and lookups. Setting up the DFFs at Job and Assignment Level to capture more information.
• Phones and Job DFF information load using FBL.
• Person email address load using the spreadsheet loader.
• Created an interface to load the element information using Payroll Batch Loader.
• Personalized the Person management, Manage Jobs and Manage Salary pages to hide the fields that are not required.
• Used Expression Builder to personalize the pages to display information specific to the roles assigned.
• Tested Core HR, Interfaces and Reports for Rel.10 Upgrade.
• Assisted end users with documenting new business procedures and test scripts for CRP & UAT

Environment: Oracle Cloud Fusion Applications R12/R11, Oracle Applications R12 - (GL, AP, AR, HR), Oracle 11g, XML/BI Publisher, TOAD, OAF (12.1.3)

Confidential - Round Rock, TX

Oracle Techno Functional Consultant

Responsibilities:

• Responsible for File Based Loader (FBL) for worker details includes loading of person data, employment data, experience, skills & competencies, Training etc.
• Worked on developing HCM extracts as part of outbound interfaces.
• Worked on creating BI publisher reports.
• Involved in gathering requirements and prepare technical design document for development and setup documents.
• Created/Customized the reports to get data output in required format.
• Analyze business requirements, perform Fit- Gap analysis and developing effective configuration solutions.
• Configured Performance Management set ups like Performance Process Flows, Talent Eligibility Profiles, and Performance Document.
• Well versed with the setup of Work Structures - Location, Organization, Job and Grade in HR
• Implemented customized fast formula for PAYROLL deduction elements.
• Identified and addressed client needs: building solid relationships with clients, developing an awareness of Firm services.
• Involved in a full life cycle implementation of Oracle HR / Payroll.
• Conducted requirements Analysis through workshops with users at all levels.
• Documented HR and Payroll future Business processes
• Configured Oracle HR, Self Service HR and Payroll to support the to be business processes.
• Worked closely with applications technical staff to assist in design and coding of PL/SQL.
• Administration duties included creating new application users, responsibilities and menus.
• Conducted user training and wrote system and user documentation.
• Written many PL/SQL procedures, functions and packages to meet the customer requirements
• 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.

Environment: PeopleSoft, SQR Process, Oracle Applications 11i/R12 (AP, AR, PO, GL), Oracle Database 10g, Oracle Application Framework, Oracle Fusion HCM Release11, Oracle Fusion HCM 12

Confidential - Los Angeles, CA

Oracle Fusion Functional Analyst.

Responsibilities:

• 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.
• 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
• Design Descriptive Flex field for data that do not fit into Oracle standard field.
• 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.
• Coordinated with Oracle for SR, New product releases, ability to coordinate upgrades and patches
• 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 R11/R10 (GHR, Talent Management, Compensation Management, Benefits, Payroll.

Confidential

Oracle EBS Consultant

Responsibilities:

• System was designed and built to consolidate many disparate systems and move the business to a shared service model.
• Performed GAP analysis and specification of custom extensions, time entry rules, custom timecards and interfaces required by the Business.
• Involved in the design and quality assurance of elements and highly complex fast formulas.
• Worked closely with employees from the client at all levels to collect requirements through workshops and meetings to ensure that design met the business requirements.
• Worked closely with solution architect to ensure OTL information flowed correctly into Payroll and Finance and was costed and paid correctly.
• Worked with technical consultants to ensure custom extensions and reports were developed accurately.
• Customized standard Oracle Applications (EBS) reports and developed custom reports on financials (AR, AP, GL), SCM modules
• In preparation for EBS R11 to R12 Upgrade developed training guides and conducted training in the following areas:
• Common R11 code changes required for R12 SQL scripts and PL/SQL packages, procedures, functions, DB Links and other DB objects.
• BI Publisher with Oracle Reports
• Developed Java database application to automate migration of custom database object in support of Oracle EBS R11 to R12 upgrade.
• BI Publisher with XML Data Template
• Project followed the AIM methodology. Created documents including BP80s, MD50s, BR100, TE20s and TE40s.

Environment: PeopleSoft, SQR Process, Oracle Applications 11i/R12 (AP, AR, PO, GL), Oracle Database 10g, Oracle Application Framework, Oracle Fusion Release 11, SQL/PL

Confidential

ERP CONSULTANT

Responsibilities:

• Developed business architecture using requirements such as scope, processes, alternatives, and risks.
• Analyzed client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
• Involved in Leading a technical team for understanding the various technicalities and functionalities of the various customizations done in the system.
• Conducted 5+ levels of testing including functional, regression, user acceptance, integration and performance to verify the client’s needs are met.
• Communicated client’s business requirements by constructing easy-to-understand data and process models.
• Supported Oracle HCM Applications (Core HR, payroll, Talent Management, Compensation and performance management) implementation
• Assist Functional team in Business Requirement Specification for HRMS and Payroll
• Participated in implementation of ERP system and integrated with different Systems like Oracle HRMS and Oracle Payroll.
• Supported the Development of Oracle extensions and support skills
• Provided input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
• Engaged client to gather software requirements/business rules, and ensure alignment with development teams.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object types and Triggers.
• Translated stakeholder requirements into over 10 different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.
• Drafted and maintained business requirements and align them with functional and technical requirements.
• Facilitated monthly meetings with clients to document requirements and explore potential solutions.

Confidential

ERP CONSULTANT

Responsibilities:

• Developed business architecture using requirements such as scope, processes, alternatives, and risks.
• Analyzed client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
• Involved in Leading a technical team for understanding the various technicalities and functionalities of the various customizations done in the system.
• Conducted 5+ levels of testing including functional, regression, user acceptance, integration and performance to verify the client’s needs are met.
• Communicated client’s business requirements by constructing easy-to-understand data and process models.
• Involved in File Based Loader (FBL) for worker details that includes loading of person data, employment data, experience, skills & competencies, Training etc.
• Well versed with the setup of Work Structures - Location, Organization, Job and Grade in HR.
• Generated analyses using OTBI for Global HR, Goal and Performance Management subject areas.
• Configured end to end performance document life cycle.
• Production Support - Troubleshooting Production Payroll issues and solution.

Environment: Oracle, SQL/PLSQL, PeopleSoft,SQR.