SUMMARY

• 20 years of technical and functional experience in Oracle Applications implementations and Upgrades.
• Good knowledge of business and functional processes in Oracle Applications: Financials, Order Management, Manufacturing, Supply Chain and HR & Payroll (PO, INV, WIP, BOM, GL, AP, AR, CM, OM, FA, LD, EAM, Contracts, Grants/Projects, HR/Payroll, HR Self Service, iRecruitment, iProcurement, Service Procurement, iExpense, OAB, OTA, OLM).
• Well positioned to perform Consulting and Mentoring roles in ERP implementation projects
• Involving System Configurations, Production Support, RICE Components, Migration from Legacy Systems to Oracle, Interfaces, Conversions, OAF, Mobile Framework(MSCA), Forms, Reports, Workflows, Extensions and Custom Development.
• Strong technical and leadership skills in various Commercial and Government implementation Projects.

TECHNICAL SKILLS

APPLICATIONS: Oracle Applications R10, 10.7,11,11i,11.5.x, R12, R12.2, R12.2.3, R12.2.4, R12.2.5,R12.2.6 (PO, INV, WIP, BOM, FA, OM, GL, Grants/Projects, AP, AR, CM, AOL, EAM, Contracts, HR/Payroll, OTL, OAB, OTA, OLM, iRecruitment, iProcurement, iExpense)

DBMS: ORACLE V7, 8,8i, 9i,10g,11g, Oracle 9iAS Portal

ORACLE TOOLS: Developer 2000, Forms 3.0/4.5/6/6i/10g, Reports 1.1/2.5/6/6i,10g, Discoverer

LANGUAGES: SQL*PLUS, PL SQL, PRO*C, ASSEMBLY (VAX, 8086), C, FORTRAN, PERL

OPERATING SYSTEMS: Unix, NT, VAX/VMS, Linux, AIX

HARDWARE: DG, HP9000, PC, Risc, Sun Solaris, IBM

PROFESSIONAL EXPERIENCE

Confidential

Technical Architect

Responsibilities:

• Designed and Developed Extract, Transform and Load Processes from Oracle Applications 12.2.6 into Data Warehouse for Conversion and nightly updates. Oracle modules involved were AP, PO, INV, GL, AR, HR/Payroll, OTL and Projects.
• The functional ETL Entities involved were GL Journals, GL Balances, Account Hierarchy, AP Invoices, AP Payments, AP Checks, Invoice Approval History, Requisitions, Purchase Orders, Vendors, Inventory Items, AR Customers, AR Bank Accounts, AR Invoices, AR Receipts, AR Payment Schedules, Projects, Tasks, Expenditures, Project Fundings, Project Budgets, Revenue, Actuals, HR/Payroll, Benefits, OTL and AOL objects.
• Also Worked with the Team to provide joins and mapping for various reports and assisted with Business Intelligence (BI) reports such as Standard, Interactive, Analyzer and Dashboards.
• Reports included Assets and Liability, Trial Balance, Quarterly Balance Report, Purchase Orders, Blanket Releases, Invoice Details, Receipt Register, Check Register, Project Budgets, Project Details, Payroll Costing, Run Results, Time Store Report, etc.

Confidential

Senior Principal Consultant

Responsibilities:

• Worked as a Techno - Functional Consultant for Oracle Supply Chain/Financials in an R12.2.5/11g/Linux environment using AGILE Safe methodology.
• Troubleshoot the production issues in Order to Cash/Procure to Pay Cycles replicating the issues in Test environment and tested the fix prior to apply in Production Instance.
• Implemented Oracle Time and Labor for Contingent Workers with Purchasing/Projects/AP Integration. Delivered BR100, Training and Testing documentation.
• Setup Projects, Tasks, Expenditure Types, Assignment Organization Parameters, Implementation Options needed for Timecard entry. Also, setup procedures for importing and distributing labor costs from timecard into projects.
• Worked on customizations for Financials/Supply Chain modules including Service Procurement that involved Alerts, OAF Extensions, Interfaces, BI Reports, Workflows and AME approvals.
• Assisted with Data Conversions from SAP to EBS that involved Mapping Requirements, Design and Development.

Confidential

Senior Principal Consultant

Responsibilities:

• Worked as a Consultant for R12 Implementation of Oracle Applications in an R12.2.5/11g/Linux environment. Assisted with Business Requirement Mapping, Gap Analysis, Configurations, Support and User Acceptance Testing (UAT).
• Prepare business test scripts to test Order to Cash data integrity.
• Wrote Interfaces and Performed Data Conversions for Oracle Applications. FA Capitalize CIP Assets, FA Update Mass addition, PO Capital Bulk Item Consumption, FA Scrap Disposal/Retirement, FA Group Asset Additions, Depot Systems to Oracle Inventory, EAM Asset Renumbering are some of notable Interfaces developed.
• Worked on workflow customizations for Payables and Purchasing.
• Designed and Developed custom Oracle Application Framework (OAF) extensions for iExpenses and iProcurement modules that involved Controller Extensions, View Object and Entity Object Extensions to alter business flow, add validations, assign default values, modify list of values, etc.
• Developed BI reports with Bursting functionality for HCM, INV, PO, AR, OM, iReceivables, AP, Projects and GL.

Confidential

Senior Principal Consultant

Responsibilities:

• Worked as an EBS Architect for Pentaho Performance Center Business Intelligence Cloud Solution. It is a cloud-based Solution built around Oracle Online Analytical Processing Database (OLAP), comprising of data cubes and providing Analysis tools for querying, reporting and visualizing data.
• Designed and Developed ETL processes (Extract, Transform and Load) for pulling data out of EBS and loading data into Data Warehouse. Oracle modules involved were AP, PO, HR/Payroll, INV, GL and AR.
• Designed Data Cubes as well as various Business Intelligence (BI) reports such as standard, Interactive and Analyzers.

Confidential

Senior Principal Consultant

Responsibilities:

• Worked on Oracle Supply Chain framework customizations. Some the functionalities extended were Issue Ingredient, PO Mobile Receiving, Product Completion by LPN, Physical Inventory and Cycle Counts. Issue Ingredient Mobile Customization involved adding LPN functionality to the Issue ingredient screen and incorporating the necessary logic to update LPN quantity from Inventory. PO Mobile receiving copy extension involved copying the entered values from the first pallet (LPN) of received inventory into all subsequent LPN entries of the same item being received. Physical Inventory and Cycle Counts customization involved defaulting values based on scanned LPN as well as incorporating validation logic on quantity field, Save/Next button, Details Button, Tag Number etc. Also Streamlined Product Completion by LPN mobile screen to minimize key presses on the device and also to minimize potential errors, miss-scans, etc. within the process.
• Designed and Developed custom Oracle Application Framework (OAF) extensions for Oracle Applications. Controller Extensions, View Object and Entity Object Extensions were performed to customize List of Values, navigation and business logic, data validations, defaulting custom values, etc. Modules extended were HR Self-Service, Manager Self-Service, Order Management, Oracle Compensation Workbench and Learning Management.
• Also Designed and Developed various Inbound and Outbound Interfaces for Oracle Applications for HCM, OM and INV. Also, Support Order to Cash Cycle.

Confidential

Senior Principal Consultant

Responsibilities:

• Worked as a Consultant for 11i to R12 Upgrade of Oracle Applications (GL, AP, AR, PO, INV, FA, CM, LD, Grants/Projects and HR/Payroll) in an R12.1.3/11g/Red Hat Linux x86-64 environment.
• Performed various technical and functional tasks relating to R12 Upgrade, provided production support and also worked with business users and Oracle Support to troubleshoot and resolve issues.
• Designed and Configured Sub-Ledger Accounting (SLA) to include Custom SLA Methods (SLAM), Application Accounting Definitions (AADs), Application Derivation Rules (ADRs) and Journal Line Definitions (JLDs). Customized SLA so that Liability, Cash Clearing and Cash Accounts in AP tracked the fund and funding source accounting segments of Invoice Distribution; Receivable accounts in AR invoices, Credit memos, Debit memos, Adjustments and Cash Accounts in AR receipts tracked the fund and funding source accounting segments of AR Invoice Distribution. Also configured FA SLA to generate Inter-Company Balancing Lines on Payables Generated Capitalized Asset Accounting transactions.
• Migrated Budget Revision Process from PSB to GL Journal Approval Process so that PSB can be retired. The new GL Journal Process included Web ADI templates to enter budget revisions as well as custom Journal Approval workflow process for routing Manager Approvals.
• Development work included OAF Extensions, Workflow customizations, Form and Reports development.
• Designed and Developed a custom Oracle Application Framework (OAF) workflow application to automate Personnel Action Approvals for Oracle HR/People Admin System involving New Hire, Employment Changes and Termination.

Confidential

Senior Principal Consultant

Responsibilities:

• Worked on R12 Upgrade of Oracle Applications - Financials & Procurement (GL, AP, AR, PO, iProcurement, INV, FA, CM), Grants/Projects and HR/Payroll from 11i. Assisted with Technical and Functional upgrade tasks including pre/post upgrade tasks. Performed R12 Upgrade and User Acceptance Testing (UAT) of Custom Interfaces, Discoverer and Oracle Reports, Extensions, Workflows, Alerts & Triggers, Forms, Personalizations, Custom PLL and Third Party Systems Interfaced to Oracle.
• Configured Payments that included registering AP Payment Templates, Formats, Process Profiles and Payment Documents for AP Check Processing and NACHA EFT. Developed BI Publisher XML templates for AP Checks and eText templates for NACHA EFT and also customized Payment Extension Package to provide additional XML elements for Check printing. Developed OA Framework customizations for iProcurement and also for Payment Manager Pages to enforce security. Configured Advanced Collections AR Dunning and developed three different dunning XML RTF templates using BI Publisher to generate customer dunning letters and also configured XML templates for AR Statements and AR Invoices. Other notable custom modifications to reflect R12 Impact included AP Positive Pay, PO Notifications Workflow, AP, PO & FA Account Generators, OAF Custom Extensions, AME Invoice Approvals, AR lockboxes, Credit Card Processing, Bank Statements, GL Interfaces, GL Trial Balance & Project Balance Reports, HR/Payroll Reports and Interfaces.
• Worked with Business Users to troubleshoot production issues and provided recommendations/solutions for resolving the issues. Also worked with Oracle Support for Service requests.

Confidential

Senior Principal Consultant/Lead

Responsibilities:

• Worked as a Consultant for R12 Implementation of Oracle Applications (HR/Payroll, Financials, and Manufacturing) in 11g/UNIX environment. Performed Data Conversions for Items, Item Categories, Vendors, Open Standard PO’s and Blankets, Projects, Tasks and Budgets. Also Developed Labor Costing Interface to interface project related Labor and Fringe Costs from HR/Payroll to Oracle Projects. Worked on PO, REQ and AP Account Generator workflow customizations for Projects, workflow notifications to buyer for cancelled or changed requisitions and PO approval workflow customization to auto-approve Standard PO’s that are sourced out of approved Blanket Purchase Agreement. Also Configured AME to setup approval rules for Requisitions, Change Order Requests and Invoices. Also Developed OAB Interfaces to various Benefit Carriers like United Healthcare, Ingenix, Safeguard, Eyemed Vision, Wageworks and Walgreens. Also configured OTL Templates and developed fast formulas and custom reports for OTL as well as OA Framework (OAF) Personalizatons/Customizations for HR Self-Service.
• Worked closely with business users to implement module enhancements. Also troubleshoot production issues and worked with Oracle Support to achieve timely resolution.
• Prepared detailed documentation as needed including Functional Specification, Technical designs, Updates to existing Technical Documentation, Test Scripts, and Process Flow Charts.
• Responsible for all aspects of technical/functional development within Oracle E-Business Suite applications such as requirements, analysis, design, development and delivery of RICE applications.

Confidential

Oracle Support

Responsibilities:

• Responsible for Support and Maintenance of Oracle Applications - Financials, Manufacturing, Supply Chain & HR in Unix Environment. Duties include Production Support, Debugging and Resolving various Application Issues ; Building RICE components ( Discoverer and Oracle Reports, Interfaces, Customizations and Extensions) ; Scheduling and Coordinating DBA efforts; Enforcing Data Masking/Security; Performance Monitoring and Tuning; Conduct Weekly Instance, Timeline Meetings;

Oracle Technical Lead

Confidential

Responsibilities:

• Analyzed Business requirements, Proposed and Developed various technical solutions and RICE components (Reports, Interfaces, Customizations, Extensions) for GAPS and enhancements of this Oracle Applications (Financials, Manufacturing & HR) Implementation using Oracle AIM methodology.
• One key development was a timesheet System that is integrated with Oracle Applications by interfacing approved timesheets to Oracle Projects as expenditures. Developed with Custom Screens, Reports and Packages to facilitate timesheet entry/approval by Employees and Alerts incorportated to send timesheet approved/reject notifications to Employees and Supervisors.
• Assess and Demo XML Publisher as a reporting tool for Check Printing & Invoice Generation in their E-Business Suite. Also, Customized AME Based Invoice Approval Workflow.

Oracle Technical Lead

Confidential

Responsibilities:

• Responsible for conversions, interfaces and reports for Release 11.5.10 implementation of Oracle Applications.
• Technical Requirements Definition, Gap Mapping, Custom Coding, Discoverer/Oracle Reports Development and Conversion and Interface Execution of PO, INV, OM, GL, FA, Grants/Projects, AP, AR, CM and HR/Payroll Modules of Oracle Applications; Facilitate Check Printing and Invoice Printing functions using XML Publisher; REQ and PO approval workflow customizations; Also, provided System Administration Suport.

Oracle Technical Consultant

Confidential

Responsibilities:

• Responsible for System Administration, Conversions, Interfaces and Reports for Release 11.5.10 implementation of Oracle Advanced Benefits(OAB). Performed Data Conversions involving Person Contacts, Enrollments for Employees, Cobra Employees and Retirees as well as Dependent and Beneficiary Designations.
• Developed Compensation Calculation Fast Formula to calculate benefit salary and used as a rule on derived factor for coverage calculations . Also created Postelection Edit Fast Formulas to create /update Oracle Payroll element entries based on the type of plan enrollment.

Oracle Technical Lead

Confidential

Responsibilities:

• Technical Lead for the evaluation of the existing 11.5.8 Oracle Applications environment.
• Responsible for identification and documentation of customizations and technical extensions.
• Identify and document new technical capabilities, features and other changes with respect to interfaces and business processes that should be implemented to achieve TPWD’s management’s goal and also present recommendations for elimination of customizations based upon leading technical practices.
• Responsible for creating a custom AR revenue collection interface to Oracle Applications using Oracle AR API’s and incorporating multi-fund accounting . Also developed a Sales AR Invoice Interface from external Licensing system to Oracle Applications AR.
• Also Developed Auto-Accounting rules to generate revenue and invoice accounts based on Grant/Project related Oracle AR transactions.

Oracle Technical Lead

Confidential

Responsibilities:

• Responsible for the design and development of 11.5.10 Financials/Manufacturing/HR reporting using Oracle Discoverer mapped to DISD’s Oracle Applications.
• Received high awards for the design of a Oracle Applications reporting system using Oracle Discoverer that will now allow administrators to better access oracle data without having to learn the OracleApplications.
• Developed Discover views that drilldown from GL to sub-ledgers AP, PO, INV,PA and AR as well as develop HR, Payroll Costing, Payroll Balances and Grant/Project related Labor Distribution views.
• Responsible for Conversions, Interfaces and Reporting Design and Deployment of Oracle Training Administration Module subsequently upgraded to Oracle Learning Management.

Oracle Technical Lead

Confidential

Responsibilities:

• Technical Lead for Release 11.5.9 Oracle Advanced Benefits(OAB).
• Developed OAB view customizations that will provide Oracle PSB with health insurance election information and benefit costs and facilitate accurate position budgeting.
• Responsible for creating HRMS/Payroll/OAB custom reports using Reports 6i.
• Developed a custom warrant process with custom screens, reports and packages that would facilitate register and redeem functions based on available cash balances and integrates with Cash Management Module of Oracle Applications

Confidential

Technical Consultant

Responsibilities:

• Technical Resource (Mentoring Role) for the Implementation of 11i (11.5.8) Oracle Applications in Redhat Linux Advanced Server 2.1 /Oracle 9i Environment. Performed HRMS/Payroll, OTA Data Conversions, Developed Interfaces, Fast Formulas and Assisted in Customizations for Oracle Financials including GL, FA, AP, PO, AR, INV, OM, CM, Assets and Projects, Student and HR/Payroll Modules of 11i Applications.
• Assisted with assessment of interface design and conversions of legacy data into Oracle Training Administration.
• Develop Standards and Templates for Data Conversions and Interfaces from legacy systems to Oracle Applications as part of Center of Excellence project.
• Developed AR Invoices Interface, Student Refunds Interface from Datatel to Oracle, Journal Entries Interface from Datetel to Oracle, Vendor Information to TINS Interface, Check File Interface to Bank.

Confidential

Technical Consultant

Responsibilities:

• Involved in the Implementation of 11i Oracle Applications in Unix/Oracle 8i Environment.
• Wrote Interfaces and Performed Data Conversions for HR/Payroll, GL, PO and Cash Management Modules of 11i Applications.
• Performed Data Conversions that involved loading Accounting Flexfield Values, GL Accounts, Fiscal Year Budget, Actuals and Statistical Journals.
• Developed Interfaces that loads Budgets and Actuals from Non-Oracle External Systems like Paradox, Delta and Food Services into Oracle GL on a daily basis.
• Developed Summary and Detail Custom Trial Balance reports using Oracle 6i Reports for General Ledger that drills down from Journal Entries to respective sub-ledgers namely AP, AR, INV, PO and Projects for Monthly Reconciliation and satisfy TEA and External Auditor requirements.
• Created Payroll Trial Calculation Report for Oracle Payroll that reports Employees that have Payroll Exceptions like exceeding certain gross and net limits, receiving more than one check etc. for each Payroll Run. Also, wrote Overtime Report that lists Employee Overtime in dollars and hours for each month in the fiscal year.
• Developed an Interface for Oracle HR/Payroll that maintains Special Information Type Service Record to hold fiscal year Sick and Personal Leave balances for each employee.