EXECUTIVE SUMMARY:

• Oracle Fusion HCM Cloud Functional Consultant with 8 plus years of experience in designing enterprise applications, implementing and enhancing Oracle E - Business Suite and HCM Cloud applications with extensive skill set in Human Resources (HR), Payroll, Advanced Benefits, Time and Labor, OLM, Employee Self Service, CWB, Performance management and project accounting Workflow, Discoverer 4i/10g, Reports 10g-6i, XML Publisher, SOA,OAF and Integration technologies in the areas of Web Services Clients that I have encompassed are in a wide variety of industries including Engineering, Oil and Gas, Energy, medical.
• Accomplished a solid record of in Human Resources, Payroll, Advanced Benefits, Time and Labor, Implementation, development, maintenance, support, testing and .
• Analyzed, designed and developed successful software solutions for numerous large and diverse projects.
• Designed custom solutions, worked in coordination with developers in transforming design to a solution.
• Confidential is creative, resourceful and organized professional with a strong work ethic, hard worker with analytical and problem-solving skills, excellent communication, presentation skills and excellent team player.
• Project experience includes many full life cycle implementations which included requirements analysis, project planning, solution design, application setup, security implementation, and meticulous testing events.
• Certified Oracle Global Human Resources Implementation Specialist.
• Experience includes full lifecycle implementations of Oracle Fusion HCM Cloud Applications release 13,12 and 11 covering HCM modules: Global HR, Benefits, Pay roll, Self Service and Workflow, Security Profiles.
• Have Good Experience in Setup and Configurating Oracle Fusion HCM Cloud Global HR, Benefits, Payroll.
• Experience in Oracle E-business suite Applications release 11i & R12; Database technologies like Oracle 9i/10g, SQL, PL/SQL, SQL*PLUS, SQL*Loader.
• Good experience in Oracle HRMS, Fusion HCM Cloud, Payroll, OAB, SSHR, Forms Personalization, Oracle Discoverer, Oracle XML Publisher, Oracle Workflow, Oracle PL/SQL, Oracle API’s, Discoverer 4i and 10g, Oracle Forms, Oracle Reports 6i.
• Integration of Modules and Business rules along with Oracle Global HR, Oracle Advanced Benefits Setups, Standard and Custom Interfaces, custom reports and other customizations in Oracle Applications have been successfully implemented using strong technical and functional understanding of modules.
• Involved in Requirements gathering, Analysis, Design and Configure.
• Expertise in Interfacing, Conversion and Data Migration from legacy systems to Oracle HR, Payroll and Advanced Benefits.
• Experience in using Oracle Discoverer and XML publisher for reports generation.
• Experience includes Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, reports, concurrent programs by using Application Object Library (AOL) and having knowledge on developing and customization of forms.
• Excellent analytical skills in Analysis and business requirements gathering from end users to the client and experience in design using MD70 documents. Proficient in AIM, Agile Methodology.
• Experience in developing queries, creating Macros and VBA modules in MS-ACCESS.
• Excellent analytical skills in GAP Analysis and business requirements gathering from end users to the client and experience in design/using MD50, MD70, CV10 and CV40 documents.
• Extensively used Pivot tables and V-lookups for data manipulation in MS-EXCEL.
• Excellent verbal, written and presentation skills with outstanding communication, time management and interpersonal skills to manage and complete projects on time and within budget. Highly motivated to achieve professional and personal goals.
• Gap Analysis, Solution Design, Functional and Technical Expertise.
• Integrating Oracle HRMS product with 3rd Party Software Packages. Configuring and Integration of Oracle 11i HR to ADP Payroll Systems

FUNCTIONAL/TECHNICAL EXPERTISE:

• Extensive in-depth knowledge in Oracle Fusion HCM Cloud and Oracle apps modules and Technical architecture, Apps Tables, Oracle apps APIs, Data Flow Between Modules, Set-ups, Design, RICE Components, Data Mapping, Data Migration/Conversion, Integration/Interfaces, Customizations, Reports/Forms, Upgrades, Workaround solutions, Project Planning, Team Coordination, AIM Methodology, Performance tuning, Debugging, Data Extraction, Extensive Hands-On experience.
• I can analyze business requirements and developing innovative solutions to optimize business processes and productivity with strong Technical background and in-depth functional knowledge.
• Configured, customized, personalized and created new Responsibilities, Menus, Functions, System profiles, Security setup by security profiles request groups, Data groups, Reports, KFF and DFF Flex Fields, Validation Sets, SIT and EIT’s. Involved in Core HR setup; Business Groups, Organizations, Hierarchy, Jobs, and Grades Setup Multi Worksite Reporting. Setup EEO
• Reporting, supported the processing of payrolls, as well as post-production modifications and user .
• Prepared the technical specification documents (MD070) for several OAB Interfaces and Payroll Time interface.
• Supported user community during testing phase and involved in day to day production issues resolution, team co-ordination, setting coding standards for the best technical practices for developers, mapping documents (CV40) and Technical Design Docs (MD70)

SKILL SYNOPSIS:

Applications: Oracle Fusion HCM Cloud, Oracle Human Resources, Oracle Payroll, Oracle Advanced Benefits, Oracle Time and Labor, Self Service Benefits, Self Service Human Resources, Work flow and Compensation Workbench, OA framework

Application Versions: Oracle 10.7, 11i, R12, R13

RDBMS: Oracle 7.x, 8.x, 9i, 10g

Languages: PL/SQL, SQL, HTML, XML, .Net, JSP

Tools: SQL*Plus, SQL*Loader, TOAD, Oracle Discoverer, Data loader, Data Pump, Oracle Forms, Oracle Reports, XML Publisher, PuTTy, WinSCP, Visio, PVCS and Workflow Builder

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle Fusion HCM Cloud Applications(R13) Functional Consultant

Responsibilities:

• Responsible for gathering requirements and creating Payroll and Benefits configuration Workbooks.
• Responsible for end to end implementation of Payroll module with 8 business units.
• Responsible for creating Elements (Earnings, Deductions), Payment Methods, Lookup Types.
• Responsible for setting eligible criteria for elements.
• Responsible for configuring Security Profiles for pay roll based on business needs.
• Responsible for configuring Payroll flows.
• Responsible for configuring payroll flow tasks.
• Responsible for Setting up elements (earnings, deductions, Employer contributions 401k etc.)
• Responsible for Setting up cost allocation key flex fields.
• Responsible for converting various pay conversion objects like third party garnishments
• Configured Payroll Statutory units and tax reporting units.
• Responsible for converting various pay conversion objects like third party garnishments.
• Responsible for gathering union requirements across various business unit for payroll.
• Responsible for creating user defined tables for union elements calculations and shift element calculations.
• Documented functional design documents for various inbound interfaces from API, JBDev to oracle fusion Cloud payroll.
• Documented functional design documents for union element deduction fast formulas.
• Responsible for configuring payrolls as per client requirements.
• Responsible for preparing fast formula design specification document for different union requirements.
• Responsible for leading requirement gathering and core team sessions with vast group of business users.
• Helped in configuring Benefit Program-options, plan types, eligibility profiles, coverage rates and life events.
• Created solution design documents and configuration matrixes for Payroll.
• Responsible for creating Payroll, Benefit test cases and test scripts for users’ .
• Developed Payroll documents for the end users using UPK tool.

Confidential, Orange County, CA

Oracle Fusion HCM Cloud Applications(R12) Functional Consultant

Responsibilities:

• Responsible for gathering requirements and creating Global HR and Benefits configuration Workbooks.
• Responsible for fit-gap analysis of requirements.
• Responsible for setting up Legislative data groups, Enterprise HCM information in HCM Cloud.
• Configured Enterprise structures with custom requirements.
• Responsible for configuring Work Structures (Jobs, Grades, Departments and Locations).
• Developed HDL’s to load grades and grade rates.
• Responsible for personalization’s on Employee and manager self-service.
• Defined approval work flows and notifications for self-service tasks.
• Responsible for creating Global HR test cases and test scripts for users .
• Creation of Custom Security for oracle HCM Cloud which includes Create/Modify Data roles, Security Profiles, Job Roles.
• Responsible for creating Implementation Users, Data Roles for Implementation Users.
• Configured Benefit Program-options, plan types, eligibility profiles, coverage rates and life events.
• Documented functional design documents for Benefit integrations.
• Documented functional design documents for fast formulas.
• Configured benefits flex credits.
• Responsible for Configuring various life events as per client needs.
• Responsible for creating Global HR, Benefit test cases and test scripts for users’ .
• Developed Global HR, Benefits documents for the end users using UPK tool.

Confidential, Kalamazoo, MI

Oracle Fusion HCM Cloud Applications Functional Consultant

Responsibilities:

• Responsible for gathering requirements.
• Responsible for Set up of HR, Absence, and Payroll.
• Responsible for Setting up of Elements Entries, Calculation cards, Consolidation Groups, Salary Details Processing the Payroll, Generating Pay slips.
• Extensive knowledge on Fast formulas.
• Excellent knowledge on US tax related elements.
• Responsible for benefit enrollment conversion.
• Designed and Developed benefit, payroll and HR functional design documents.
• Responsible for Configuring Approvals, Employee Self Service Role Customizations, Manager Self Service Role Customizations.
• Responsible for configuring data roles, security profiles as per client requirements.
• Responsible for Configuring Enterprise structures, Work force structures (Jobs, Grades, locations, Departments).
• Responsible for Configuring Plans, Plan rates In Benefits.
• Responsible for Configuring Various Absence Plans.
• Responsible for configuring Employee Self Service, Manager Self Service as per client Requirements.
• Developed Various BI Publisher Reports like Absence Reports, Benefits Enrollments by region, life events Configured report, Eligibility Profile Report, Program Participation eligibility details report, User Roles report.
• Developed Various BI Publisher HR Reports W4 Tax Withholding changes report, late termination reports.
• Worked with technical team on HDL to load workers data.
• Involved in Preparation of configuration Work Books for Global HR, Benefits.
• Involved in Preparation of Test cases, Test Scripts for Global HR, Benefits, Absences.

Confidential, Kansas City, MO

Oracle Fusion HCM Cloud Applications Consultant

Responsibilities:

• Responsible for Set up of HR, Absence, and Benefits.
• Helped in documenting configuration work books for Global HR, Benefits.
• Responsible for Configuring Enterprise structures (legal entities, Business units), Work force structures.
• Responsible for configuring benefit programs, plans, rates
• Worked on BI publisher for reporting needs as per client requirements like Action item report, absence reports, enrollment reports, New Hire reports, Talent Reports.
• Worked on FBL to load Person, Work Relationship, Assignment data from Oracle EBS.
• Experienced in communicating with users and resolving the production support daily based problems.
• Responsible for testing configuration setups Core HR, Benefits.

Confidential, Tempe, AZ

Oracle HRMS Sr Consultant

Responsibilities:

• Involved in gathering requirements and formulation of business rules on employee benefits, assignment information and salary information
• In first phase of implementation done interfaces to send new hire data and changes into Oracle HR ERP and feed to ADP HR/B dedicated Benefits System via ADP Auto Import Service.
• Involved in conversions using API’s to load salary proposal, job, position and grade information.
• Worked on an interface that extracts and sends information of Benefit deductions and Taxes to ADP monthly for processing the payroll needs.
• Capture time in Oracle Time and Labor Module and feed to ADP Payroll via ADP Basic Paydata.
• Pass applicable information to carriers and payroll systems via connections.
• Analyzed needs for ADP Connection, based on OTL integration, and managed discussion on solution with Oracle development and client.
• Avoid the integration between ADP’s HR-B and ADP’s Pay-expert system which seems to be the root-cause of all the issues.
• Later we developed OAB systems for all the benefit needs. In this process migrated data from ADP’s HR-B Benefit system to Oracle Advanced Benefits in house implementation, involved in doing Life event reasons, enrollment eligibility and rate conversions.
• Responsible team member for the in-House Benefits support administration.
• Interfaced with all the Benefit vendors directly and not through ADP, the providers we interfaced data are Caremark, BCBS, Davis, MetLife and Prudential.
• Include employee benefit deductions in ADP’s Pay eXpert interface file
• Worked on automated mail system to all the employees and managers to track timecard data for any changes in OTL self-service.
• Developed inbound and outbound payroll interface reporting with ADP for company’s payroll requirements for new hire data and changes in Oracle HR and feed to ADP.
• Outbound interface to send Benefits information from OAB, OLM to various providers of (Medical, Dental, Vision, Insurance and FSA).
• Worked on fast formulas including Life Insurance and Disability Insurance.
• Worked on Oracle Web ADI in exchanging data of HR between Oracle applications and desktop.
• Gathered requirements from business users and developed number of queries to use in Oracle Discoverer reporting software.
• Development of new custom reports (RDF) based on client requirements.

Confidential, Edinburg, TX

Oracle HRMS AR, AP, GL Consultant

Responsibilities:

• Interact with the Functional and End users to discuss the Business Rules and come up with MD050 and MD070 Design Documents.
• Responsible for doing Data mapping from legacy system to Oracle HRMS system.
• Involved in Design, Development and Testing of Conversions, Interfaces and Reports.
• Review the Code developed by the Technical Team and make sure that the programs are as per standards and error free.
• Involved in Conversions like Elements links, Salary, Taxes, Payment methods, Extra Information Types, Balances etc.
• Involved in Interfaces like Prior Pay Adjustments (Retro Pay), Positive Pay, Employee Weekly Data and Teachers Retirement.
• Involved in OAB conversions like Person Life Events, Potential Life Event Reason for Person, Participant Rate Value and Participant Enrollment Results.
• Design and Developed Labor Distribution Conversions, LD Interfaces like Encumbrances for Non-recurring elements, Non-Sponsored Projects, Modified seeded User Hooks etc.
• Done conversion process using Data pump.
• Responsible for developing value sets and for segments in flex field design.
• Customized various transactions in Accounts Receivables like Invoices, Receipts, Credit Memos and Debit Memos.
• Designed Journal Import Interface Program to import data with specific validations for each of the above modules.
• Involved in financial conversions, which included data gathering from the client, validation and upload into Oracle.
• Designed FSG Reports in GL to get balance sheet for each entity within the organization to help month-end reconciliation.
• Design and Developed LD Reports like Payroll Distribution by Project, Employee, Suspense Report, GMS to GL Reconciliation, Payroll-LD-GMS-GL Reconciliation.
• Customized multiple reports and forms in AR, AP and OE modules according to the requirements
• Data file and loads the standard Oracle Payables invoice tables
• Customized reports like company income statement, company balance sheet and trial balance reports for GL module using FSG (Financial Statement generator).
• Involved in Vacation and Sick Accrual Design.
• Created Mainframe Data Inbound Interface which is getting data from Mainframe (RACFID, USERID and WORKPHONE data) and load data into staging tables and from staging tables update the PER PHONES oracle table.
• Created ANTHEM, CIGNA and VISION Benefits Outbound Interfaces as per 834-EDI specifications.
• Created an Outbound interface to send an ASCII output file to Huntington trust regarding pre-tax Employee and Employer contribution amounts (401K, 401K ER, 401K Catch up, Loan 401K deduction etc.) per assignment run dimension and SQL*Plus report to create text file
• Created an Outbound Interfaces to create an output file for Living Person Disaster Recovery System (LPDRS), Accounts Reconciliation Process (ARP), Vinum Services, Kenexa Services.
• Resolved many technical Issues in Conversion Programs from TOPPS to Oracle specifically in Benefits (LIFE, FSA), Employee and assignment costing conversions.
• Created corresponding staging tables, Control files and registered them as request set from Applications
• Registered all interfaces as concurrent programs and scheduled them as per the requirements
• Created various PL/SQL procedures and Functions.
• Created staging tables to load data from mainframe
• Worked with SQL*Loader utility for loading data from legacy system to Oracle.