PROFESSIONAL SUMMARY:

• Over Twenty - Five years of Experience in Oracle with over Twenty years of Technical / Functional Oracle Applications Consulting Experience in Implementing and Customizing Oracle Applications (HRMS/Financials/Manufacturing) (Fusion/Oracle Cloud, ERP Releases 12, 11i, 11, 10.7NCA, 10.7SC) and Oracle Self Service Web Applications. Workday implementation involving in transition from Oracle to Workday.
• Worked on more than Twenty implementation of Oracle Applications for many of the fortune clients internationally
• Several full life cycle Oracle Apps implementations, with extensive experience in business requirements gathering, gap analysis, software design, development, enterprise integration, data migration, conversion, interface, Fast Formulas, development/customization of forms and reports, development of custom modules and integrating them with Oracle Applications, developing test plan and test cases, testing, implementation and support.
• Thorough understanding of Software Development Life Cycle. Familiar with Oracle’s AIM methodology in Oracle implementation projects.
• Having a rich experience in Oracle tools and technologies like Oracle DB, Oracle Forms, Oracle Reports, Oracle Designer, Developer, Discoverer, PL/SQL, SQL, SQL*Plus, Pro*C, SQL Loader, Oracle Application Object Library (AOL), AME, Workflow, Alert, PL/SQL Web Toolkit, OA Framework Personalization, JDeveloper, XML/BI Publisher and Performed Apps DBA Functions.
• Excellent Functional/Technical experience and familiarity with data model of R11 and R12 modules - Oracle HRMS, Payroll, Performance Management, Compensation Workbench (CWB), Advanced Benefits (OAB), Oracle Learning (OLM), iRecruitment, Oracle Time & Labor (OTL), Oracle Payables (AP), Oracle Receivables (AR), Oracle General Ledger (GL), Oracle Cash Management (CM), Oracle Projects (PA), Oracle Assets (FA), Oracle Purchasing (PO), Oracle Order Management (OM), Advanced Pricing (QP), Oracle Inventory (INV), Bills of Material (BOM), Oracle Federal Financials and Oracle Public Sector Financials.
• Extensive experience with data extraction, data mapping, data conversion, interfaces and writing stored procedures, functions, packages and triggers.
• Good team leading, project management and client management skills.
• Excellent communication skills (written, verbal) and strong interpersonal skills. Able to work independently and in a team.

IT SKILLS:

ERP Oracle e: Business Suite Cloud, R12,11i,11.x,10.7NCA,10.7SC

Workday: Human Resource Oracle HRMS (HR), Payroll, Performance Management, Compensation Work Bench (CWB), Oracle Advanced Benefits (OAB), Oracle Time & Labor (OTL), Labor Distribution (LD), Oracle Learning (OTA/OLM), iRecruitment Financials Payables (AP), Receivables (AR), General Ledger (GL), Assets (FA), Cash Management (CM), Projects (PA), Grants, including Federal and Public Sector Financials Distribution/ Order Management (OM), Advanced Pricing (QP)Supply Chain Order Entry (OE-11,10.7), Inventory (INV), Purchasing (PO) Manufacturing Bill of Materials (BOM), Work in Process (WIP)

Core Technology: Application Object Library (AOL), AME, Workflow, Alert, Applications System Administration, Personalization, Oracle Self Service Web Application, OA Framework

Database: Oracle DB (All Versions), Sybase 10.x

Languages: SQL, PLSQL, C, UNIX Shell Scripts

GUI Tools: Oracle Forms and Oracle Reports, XML Publisher

Oracle: Designer/Developer/Discoverer, Oracle JDeveloper, Oracle APEX, RPA Tool UiPath Studio

Other Tools: TOAD, SQL Navigator, MS Office, MS Project, UiPath

Utilities: SQL Loader, Dataload, Import/Export

Operating Systems: UNIX (HP, SUN, IBM, DEC, Linux), MS Windows, MS DOS

Methodologies: Oracle AIM

PROFESSIONAL EXPERIENCE:

Confidential, Tarrytown/Sleepy Hollow, NY

Techno Functional Consultant

Responsibilities:

• Designed custom solution to manage and administer Floating Holidays in lieu of Company provided public holidays.
• Developed HR/Payroll XML/BI Publisher reports.
• Worked on Payroll and OTL Fast Formulas.
• Worked on several Interfaces to various Third-party vendors with Payroll and Benefits.
• Worked on Timecard mass upload and approval process.
• Worked on several custom Oracle process automations relating to Timecard Transfer to Projects/Payroll/GL.
• Designed and Developed several data audit reports.
• Evaluation of Fusion HCM Cloud and Workday to upgrade from R12.
• Worked on HCM Data Loader/Extract under Data Exchange.
• Assisting with Workday Data Conversions for CRP Sessions.
• Worked on RPA Tool UiPath Studio to design and develop process automations.

Confidential, Kalamazoo, MI

Techno Functional Consultant

Responsibilities:

• Worked on generating several data files to support Conversions to Workday.
• Developed custom process to reconcile data between Workday and Oracle.
• Developed HR/Payroll reports.
• Worked on several Third Party/Vendor Integrations.

Confidential, Houston, TX

Techno Functional Consultant

Responsibilities:

• Involved in Functional Setup/Configuration of the Modules.
• Designing several new Interface and Conversions.
• Developed custom process for HR Data Audit.
• Customization around Checks and Positive Pay File.
• Developed HR/Payroll XML/BI Publisher reports.
• Worked on HR Data Conversion for International People.
• Worked extensively on HCM Data Exchange using HCM Data Loader, Extract and Payroll Data Loader.

Confidential, New York, NY

Techno Functional Consultant

Responsibilities:

• Worked on Restructuring HR Organization Hierarchy.
• Worked on several HR and Payroll Interfaces.
• Worked customizing Self-Service pages that are based on OAF (Oracle Application Framework) using Oracle Jdeveloper.
• Developed several HR/Payroll XML/BI Publisher reports.
• Worked on several HR and Payroll Fast Formulas.
• Designed and Developed custom Fringe solution for Oracle Payroll Costing for client’s unique/challenging requirements.
• Worked on Integrating Oracle Cash Management for Payroll transaction reconciliation.
• Designed and Developed several Payroll BI Reports that incorporates costing level security feature to control Payroll Transactions visibility/access.
• Developed several Web ADIs (Desktop Integrators) to various data maintenance
• Worked on several HR Enhancements based on Feedback from the Field users and performing these added functionalities and enhancements using User Hooks, Workflow, AME and JDeveloper.
• Implemented/Configured International HRMS and performed Data Conversion loading HR Data from over 20 countries.
• Designed and Developed automated way to maintain these international data coming in from several countries into single Oracle SGI.
• Designed and Developed custom processes that leverages HR security profile feature but extends the functionality to facilitate Cognos security.
• Working on Design/Development/Integration of Xytech / WorkForce Time & Labor system into Oracle HR/Payroll
• Involved in several Production Support and System Enhancement activities
• Involved in Design and Implementation of Oracle Projects for specific divisions to start tracking their production of shows for better tracking by Seasons and Episodes.
• Involved in the implementation and phased rollout of Oracle HCM Cloud for specific divisions of Confidential .
• Designed and Developed several custom modules using Oracle APEX and integrated them with Oracle eBuisness Suites.

Confidential, Cleveland, OH

Technical Consultant

Responsibilities:

• Worked on several Comp Work Bench Fast Formulas.
• Developed several Comp Workbench XML/BI Publisher reports.
• Developed several Web ADIs (Integrators) to ease up several day-to-day data maintenances.
• Designed and Developed custom Document Management solution to maintain and communicate Comp Statements.

Confidential, Honolulu, HI

Techno Functional Consultant

Responsibilities:

• Prepared CV40, mapping legacy data for conversions and interfaces
• Worked on HR, Payables, Receivables and Purchasing modules Data Conversion.
• Worked on Supplier Conversion / Daily Sync of Supplier Data from the Hawaii State system
• Worked on loading Bank Accounts and External Payee Relationships
• Worked on GL/HR/Payroll/OTL/Projects Interfaces that interfaces with State Financial System.
• Automated HR Data Daily Sync up with State maintained HRMs system.
• Automated Timecard Import into OTL for islands that are still using AS/400.
• Developed several HR/Payroll/OTL Fast Formulas
• Worked on Oracle iExpense and OTL Timecard approval configurations.
• Designed and Developed Custom Waterfall Solution to support Cascading Funding of s as part of Grants module and worked on multiple sub-module touch point from Labor Distribution (LD), PO, AP and other Interfaces.

Confidential, Fort Lee, NJ

Techno Functional Consultant

Responsibilities:

• Prepared CV40, mapping legacy data for conversions and interfaces
• Worked on Payables, Assets, GL, HR and Payroll History Data Conversion
• Worked on HR/Benefits Interfaces like Pinkerton Background Check, Horizon BCBS, Cobra, 401k etc
• Developed several HR/Payroll/Benefits Fast Formulas
• Worked on Oracle Payroll Mid Quarter Balance Conversions (from ADP Quitter Files)
• Developed several Generic utility programs to assist with System Configuration like User/Responsibility maintenance, Auto Sync HR Data with external systems etc

Environment: Oracle 10g, Oracle Applications (HRMS modules - HR, OAB, OTL and Payroll), SQL, PLSQL.

Confidential, Rochester, NY

Techno Functional Consultant

Responsibilities:

• Prepared CV40, mapping legacy data for conversions and interfaces
• Worked on HR History Data Conversion
• Worked on HR/Benefits Conversions / Interfaces
• Developed several Benefits Fast Formulas and assisted with Open Enrollment
• Worked on Oracle Payroll Balance Conversion (from ADP Quitter Files), Reconciliation, FLS Reporting, Sage Wage Module Interface etc
• Designed and Implemented several PTO Accrual Plans that involves unique and challenging requirements
• Developed several Generic UNIX utility programs to assist with System Configuration

Environment: Oracle 10g, Oracle Applications (HRMS modules - HR, OAB, OTL and Payroll), SQL, PLSQL.

Confidential, Cleveland, OH

Techno Functional Consultant

Responsibilities:

• Worked on several HR and Benefits Interfaces like ADP Enterprise, Aetna HSA/FSA, ADP HMO/DMO, KRONOS, SWIM, TALX, Benefits Journals to GL etc.,
• Developed several queries and Views to support Discoverer Reporting Tool that was used to develop several HR and Benefits reports
• Developed several custom processes like User Admin Process, HR Purge Audit Process and Reporting, Generic FTP etc.,
• Developed several custom Workflows and Notifications and performed several AME Configurations in SSHR
• Developed several interfaces with ADP Enterprise Payroll to keep track of the Earnings and Deduction in GEMS and maintain several Benefits Balances
• Developed several OAB/CWB Fast Formulas to support in Open Enrollment and Year end Grade Rate and Salary revisions.
• Involved in CRP Testing to demonstrate features of Oracle Learning (OLM) and iRecruitment for future implementation.
• Worked on OLM Data Conversions converting several data components.

Environment: Oracle 10g, Oracle Applications (HRMS modules - HR, OAB), SQL, PLSQL, AME and Workflow.

Confidential, Jericho/New York

Techno Functional Consultant

Responsibilities:

• Developed several Benefits Fast Formulas
• Prepared CV40, mapping legacy data for conversions and interfaces
• Worked on HR History Data Conversion
• Worked on several HR/Benefits Interfaces like United Healthcare, Fidelity 401K, ADP integration etc.,
• Worked on several Interface in AP, AR, GL and Cash Management Modules
• Worked on OA Framework Customization in iProcurement Module
• Worked on Conversion of Historical Data for OLM Module to maintain the Course Catalog, Enrollments and External .
• Developed several queries and Views to support Noetix Reporting Tool that was used to develop several reports in HRMS, Financials and Order Management Modules
• Worked on several OTL Fast Formulas
• Worked on custom OTL Time explosion solution that bridges gap in requirement interfacing from OTL to HR Element Entries

Environment: Oracle 10g, Oracle Applications (HRMS modules - HR, OAB. Financial Modules - GL, AP, AR, CM. Distribution Modules - OM, PO etc.), SQL, PLSQL, AME, Workflow.

Confidential, Michigan/Tennessee

Techno Functional Consultant

Responsibilities:

• Performing several AME & Workflow configurations in SSHR, iRec and Performance Management
• Performing OA Framework Personalization & Extensibility on Manager Self Service HR
• Prepared CV40, mapping legacy data for conversions and interfaces
• Working on several Mexico HR Data Conversions using various Oracle APIs
• Working on Mexico Payroll Balance Conversion
• Working on Oracle Learning Management Conversion which includes Courses, Offerings, Classes, Resource Bookings, Enrollments and External
• Developing Fast Formula for MX Payroll and CWB
• OA Framework Customizations using Oracle JDeveloper in OLM, PM, CWB and iRecruitment modules
• Production Support for modules implemented in Phase 1

Environment: Oracle 9.2.0.3, Oracle Applications (HRMS modules - PM, CWB, OLM, iRec and Mexico HR/Payroll), SQL, PLSQL, AME, Workflow, Self-Service OA Framework.

Confidential, Jericho/New York

Techno Functional Consultant

Responsibilities:

• Developed several Fast Formulas in Accruals, Absences and PTO calculations and several Benefits Fast Formulas
• Prepared CV40, mapping legacy data for conversions
• Worked on Benefits Data Conversion
• Worked on HR/Benefits/Financials Interfaces
• Developed several queries and Views to support Noetix Reporting Tool that was used to develop several reports

Environment: Oracle 10g, Oracle Applications (HRMS modules - HR, OAB. Financial Modules - GL, AP, AR, CM. Distribution Modules - OM, PO etc.), SQL, PLSQL, Workflow.

Confidential, Michigan/Tennessee

Techno Functional Consultant

Responsibilities:

• Prepared Solution Design(SD70) and Technical Design(TD70) Docs as per AIM
• Developed several scripts that compares the HR Payroll Setups across multiple instances like Elements, Links, Input Values, Balance Feeds etc
• Setup of SIT, EIT, Value Sets, Cross Validation Rules in HRMS Modules
• Accrual of Absence Occurrences, Notifying manager or HR at different levels
• Performed several AME & Workflow configurations in SSHR
• Performed OA Framework Personalization & Extensibility on Self Service HR
• Prepared CV40, mapping legacy data for conversions and interfaces
• Worked on several HR Data Conversions using various Oracle APIs
• Worked on Benefits Conversion creating Life Events, Election Enrollments etc
• Worked on Payroll Balance Conversion
• Designed/Developed several Payroll, Benefits and OTL Interfaces
• Developed Fast Formula for Payroll, OTL and OAB

Environment: Oracle 9.2.0.3, Oracle Applications (HRMS modules - HR, Payroll, OAB, OTL), SQL, PLSQL, AME, Workflow, Self-Service OA Framework.

Confidential, Georgia

Technical Consultant

Responsibilities:

• Performed Workflow configurations in SSHR
• Configured Oracle Approval Management using AME
• Performed OA Framework Personalization & Extensibility on Self Service HR
• Developed Fast Formula for Compensation Workbench

Environment: Oracle 9.0.2, Oracle Applications (HRMS modules - HRMS, CWB), HP-UX Server, SQL, PLSQL, Self-Service OA Framework 5.7.

Confidential, New Jersey

Techno Functional Lead

Responsibilities:

• Setup of SIT, EIT, Value Sets, Cross Validation Rules in HRMS Modules
• Performed several Workflow configurations in SSHR
• Configured Oracle Approval Management using AME
• Performed OA Framework Personalization & Extensibility on Self Service HR
• Setup Appraisal/Assessment Templates, Rating Scales and Personalized Appraisal Forms
• Designed/Developed Questionnaires
• Designed/Developed new functionalities like Appraisal Re-Route, Unapprove Functionality, HR Professional Workflow etc.,
• Developed Fast Formula for Compensation Workbench

Environment: Oracle 8.1.7, Oracle Applications (HRMS modules - HRMS, CWB), Sun Solaris Server, SQL, PLSQL, Self-Service OA Framework 5.7, Alert and PLSQL Web Toolkit.

Confidential, New York

Functional/Technical Lead

Responsibilities:

• Requirement Study and Gap Analysis of Financials/Distribution Modules
• Project Planning and Scheduling
• Prepared Solution Design(SD70) and Technical Design(TD70) Docs as per AIM
• Functional Setup of Financials/Distribution Modules
• Performed Data Mapping and Migration from Legacy system
• Implemented several Applications Open Interfaces like Payables Open Interface Import, Receivables Auto Invoice Import, Customer Interface, GL Journal Import and Budget Upload, Fixed Assets Mass Additions Interface, Cash Management’s Bank Statement Import and Auto Reconciliation, Purchasing Requisition Import, Order Management’s Order Import, Inventory’s Open Item Interface, HR Conversions and Interface with ADP Payroll etc.,
• Developed/Customized several Forms, Reports, FSG Reports and Processes
• Performed several Workflow customizations/configurations
• Performed Customization on Self Service Web Applications
• Designed/Developed the model of maintaining each Case Files that is being handled in Oracle Projects Module
• Designed/Developed Automatic Emailing of FSG and other standard reports based of user defined rules and schedule.
• Apps DBA Functions including Installation/Upgrades of 11i and other sysadmin tasks like applying Patches, Oracle TAR follow-up etc.,
• Production Support and User

Environment: Oracle 9.0.2, Oracle Applications 11.5.9 (Financials Modules - AP, AR, GL, FA, CM Distribution modules - OM, Inventory, PO), Windows 2000 Advanced Server, SQL, PLSQL, SQL*Loader, Developer 6i (Forms 6i, Reports 6i), Discoverer 6i, Workflow, Alert and PLSQL Web Toolkit.

Confidential

Senior Consultant

Responsibilities:

• Requirement Study and Implementation of Project Accounting, Web Expense and Web Requisition modules
• Prepared Solution Design(SD70) and Technical Design(TD70) Docs as per AIM
• Customization of Project and Budget Approval Workflow
• Performed Web Customizations like Web Expense, Web Requisitions etc.,
• Implemented several Oracle Alerts
• Worked on several HR Conversions and Interfaces

Environment: Oracle Applications Rel.11 (Modules - AP, AR, GL, CM, FA, PA, PO and HR), Oracle Self Service Web Applications, HP-UX, SQL, PLSQL, SQL*Loader, Developer 2000, Workflow, Alert and PLSQL Web Toolkit.

Confidential

Functional/Technical Lead Employer: Oracle Consulting, Singapore

Responsibilities:

• Requirement Study and Scope/Gap Analysis of Financials/Distribution Modules
• Overall Project Planning and Scheduling
• Prepared Solution Design(SD70) and Technical Design(TD70) Docs as per AIM
• Functional Setup of Financials/Distribution Modules
• Performed Data Mapping and Migration from Legacy system
• Analysis/Design of Custom module Automated Billing System that interfaces with Payables and Receivables
• Designed/Developed Cash Management customization to support many-many reconciliation
• Analysis/Design of EDI Invoice and PO Matching
• Designed/Developed several Interfaces like Item Interface, Order Import, Ship Confirm Interface, Auto Invoice, Payables Interface etc.,
• Developed/Customized several Financials and Distribution Forms and Reports

Environment: Oracle Applications 11.0.3 (Financials Modules - AP, AR, GL, CM, FA Distribution modules - PO, OE and Inventory), SQL, PLSQL, SQL*Loader, Oracle Developer 2000