SUMMARY

• Over 18 years of IT experience as an Oracle Application Technical/Functional Consultant/Systems Analyst/Programmer/Developer, Very strong in the design and development of Confidential, University, Government, Financial, Manufacture, Commercial, Banking and Business application of industries.
• Involved in Full Lifecycle implementation of Requirement Analysis, Gap analysis, Gap Solution, Setups, Technical Design, Development, Coding, Testing, end - user training, post-implementation support, Customization, Conversion, Migration, upgrades, Patch testing, Trouble shooting Production issues and QA Testing.
• Thorough knowledge of the HR,Payroll, OAB, Manufacturing and Financials Database Schemas, HR/Payroll APIs Usage, Payroll Balance retrieval, Element Entry, Year End Process, Oracle FastFormula and Financials Open Interfaces.
• Techno functional experience in various modules in the Order to Cash (O2C) and Procure to Pay (P2P) disciplines of Oracle EBS including significant experience in the implementation, designing customizations and integrating custom applications with Oracle E-Business Suite
• Expertise in translating functional specifications into implemented technical solutions using Oracle applications supported toolsets

TECHNICAL SKILLS

Oracle Applications: R12/11.i (11.5.10/11.5.9/11.5.8/11.5.7 )/ 11.0.3/11.0.2/10.7 NCA/10.7SC

Modules: HR/Payroll (HRMS), Advance Benefits (OAB),OTA,OLM, Oracle Self Service, Accounts Receivables, Accounts Payables, General Ledger, Inventory, Oracle Purchasing, Oracle Inventory, Order Entry, Order Management, Labor Distribution, Grants, Project Accounting, Application Object Library, System Administration, Oracle Alert, Oracle Workflow, Forms Configurator

Databases: Oracle7.X/8.X /8.i/9.i/10g/11g/12c

Tools: Developer /2000 (FORMS 10g/9i/6i/4.5, REPORTS 10g/9i/6i/2.50), Oracle Discover 4i, Web ADI, OBIEE Tools

Languages: PL/SQL, SQL, C ++, C, PRO *C, JAVA, UNIX Shell Script

Oracle Utilities: SQL*LOADER 7.3

Operating Systems: UNIX (HP, Sun Solaris, AIX, SCO UNIX)

Methodologies: Applications Implementation Methodology (AIM), Agile/Scrum Methodology

Other Products: MS Access97, MS SQL Server, TOAD, SQL Navigator

PROFESSIONAL EXPERIENCE

Confidential

Oracle Application Technical/Functional Consultant

Environment: Oracle Applications R12/11.i (AR,AP,PO,GL,HR and Payroll), Oracle 11g/12C, Forms 10g, Reports 10g, SQL, PLSQL, TOAD, Web ADI

Responsibilities:

• Prepared Technical Specs using AIM Methodology with all standard documents like CV20, MD 50, MD 70 and MD 120, Code review and Code development.
• Gather technical requirements and detailed interface and conversion specifications, including data mapping.
• Involved in new 1000 HR Employee conversion from Legacy system
• Designed and developed functional and technical design documents for data conversion of Customer, Item Master, Purchase Order, Sales Order, Inventory On-Hand Quantity legacy data using Unix shell script and PLSQL routines.
• Involved in conducting CRP1, CRP2, test data preparation and test scenario preparation.
• Provided production support during and after HR/Benefits/Payroll and Financial go live

Confidential

Oracle Application Technical/Functional Consultant

Environment: Oracle Applications R12 (HR, OAB, Oracle Inventory PO, AP, GL, AR), Oracle 11g/12C, SQL, PLSQL, TOAD, Oracle OBIEE

Responsibilities:

• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Developed, customized EMSD Web base tools to create AR Customers, Profiles, Invoice setup, Invoice Groups, Billing system with complex programing logic and AR invoices in Oracle
• Involved in Design, Development, Testing, and Enhancement for HR, Payroll and Base Benefits modules.
• Was involved Tuning SQL statements to improve execution performance using TKPROF, SQL Trace, etc.
• Worked as a Member of the Production support system to address day to day issues. Daily Development Interaction with Technical leads for status and any other outstanding issues.

Confidential

Oracle Application Technical/Functional Consultant

Environment: Oracle Applications R12 (HR, OAB, Oracle Inventory PO, AP, GL, AR), Oracle 8.i/9.i/10g, SQL, PLSQL, TOAD, Oracle OBIEE

Responsibilities:

• Designed and developed Receiving Interface which creates receipts, accept, deliver and adjustment using PLSQL Packages.
• Used Oracle Standard API to Open PO lines for the day and closed at the end of the day once receipt quantity program completed.
• Involved in the design and development of inbound and outbound interface HJ third party system to oracle for items, Purchasing, Receipt Interfaces
• Involved in Designed and developed of custom reports using OBIEE tools like receiving aging, Invoice Invariance, Returns Quantity reports and various HR and OAB reports.
• Involved HR, OAB setups, Fast formula and Open enrollments process .
• Involved in OAB conversation from Legacy system and outbound interfaces for external carriers
• Trouble shooting production issues

Confidential

Oracle Application Technical/Functional Consultant

Environment: Oracle Applications R12 (HR, Payroll, OAB and AP, GL, AR), Oracle 8.i/9.i/10g, SQL, PLSQL, TOAD, Web ADI, OBIEE Tools

Responsibilities:

• Completed CV20 (data Strategy document), CV50 (data mapping document) and MD 70 (technical document) for client HRMS conversion.
• Wrote script for employee, Address, Assignment, EIT, SIT, Salary conversion.
• Configured OAB Program, Plan, enrollment requirements, eligibility profile, Standard rate, variable rates, and life events setup.
• Was involved in OSB to OAB conversion.
• Was involved in OSB De-enrollment process.
• Successfully converted Participants and their dependents Medical, dental, vision benefits.
• Wrote validation scripts to match pre conversion and post conversion data.
• Was involved on Open enrollments process.
• Developed and customized OAB Fast Formula.
• Developed outbound Interface for benefit external carrier BCBS, Delta Dental.
• Monitor new hire data interface flow into Confidential, ensuring accuracy of data.
• Customized Oracle Confidential views
• Developed OBIEE reports
• Ran CRP sessions and user training and test scripts.
• Developed test scenarios and perform functional testing and document test results.
• Experience in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions, custom PLL's, Forms Personalization's respectively
• Extensively used AOL and Sysadmin modules for set up of various concurrent programs, Request sets, Value sets and Descriptive flex fields.

Confidential

Oracle Application Technical/Functional Consultant

Environment: Oracle Applications R12 (HR and Payroll and PA, AP, GL, AR), Oracle 8.i/9.i/10g, SQL * Forms 6.i, SQL *Reports 6.i, SQL, PLSQL, TOAD, Web ADI

Responsibilities:

• Prepared Technical Specs using OUM Methodology, Code review and Code development
• Prepared Strategy documents for the conversion
• Gather technical requirements and detailed conversion specifications, including data mapping
• Converted data from production 11i instance to R12 instance using oracle APIs employee, Address, Assignment History, Secondary Assignment, Payment Method, EIT, SIT, Salary, Qualification, absence conversion.
• Design, developed and tested PLSQL package for correction/update/insert employees start date, employee’s information and assignment details. Wrote scripts for reversal rehire and reverse termination process.
• Was involved in 64 business Group implementation and knowledge about localization.
• Successfully converted Participants and their dependents Medical, dental, vision benefits
• Was involved on Open enrollments process.
• Developed outbound Interface for benefit external carrier BCBS, Delta Dental.
• SQL tuning for reports running slow and PLSQL packages using TKPROF, EXPLAIN plan, applying indexing and HINTS.
• Conducted successfully Conference Room Pilots - CRP1, CRP2, SIT, UAT
• Worked with Various Functional issues and Raising TARs whenever it requires for Oracle Standard Functionality support from Oracle.
• Extensively used AOL and Sysadmin modules for set up of various concurrent programs, Request sets, Value sets and Descriptive flex fields
• Production Support for Financial modules AR,AP, GLPA

Confidential

Oracle Application Technical/Functional Consultant

Environment: Oracle Applications R12/11.i (AR,AP,PO,GL,HR and Payroll), Oracle 8.i/9.i/10g, Forms 10g, Reports 10g, SQL, PLSQL, TOAD, Web ADI

Responsibilities:

• Analyzed documentation for functional design, technical design and Unit Test Plan
• Analyzed over 100 pieces of code (RICE) recommended Changes from R11i to R12
• Desinged, Developed and tested XML reports

Confidential

Oracle Application Technical/Functional Consultant

Environment: Oracle Applications R12/11.i (HR, Payroll, OAB, Self service, CWB), Oracle 8.i/9.i/10g, SQL * Forms 6.i, SQL *Reports 6.i, SQL, PLSQL, TOAD, Web ADI

Responsibilities:

• Prepared Technical Specs using AIM Methodology with all standard documents like CV20, MD 50, MD 70 and MD 120, Code review and Code development.
• Gather technical requirements and detailed interface and conversion specifications, including data mapping.
• Thorough Knowledge of Oracle HR/Payroll API’s, Database Items, Balance Packages (Regular and Tax Balance), Payroll Balance concepts (Element Feeds and Dimensions).
• Converted data from production 10.7 instance to 11i instance using oracle APIs and custom code to add employees, address, assignment history, create contacts and dependents, create phone entries, create positions and jobs, create SITs, load salary proposal including history, add personal payment methods load element entries and programmatically linking elements.
• Was involved in upgrading oracle 11i to R12.Retrofited custom RICE objects to R12.Upgraded forms and reports from 11i to R12.
• Developed, designed and tested EEO4 process to merged PPS and oracle data.
• Developed, designed and tested Project Account to WB interface
• Prepared Test Scenario’s and Test Scripts for Oracle Projects (Costing, Grants Mgmt. System, Integration - Purchasing, Fixed Assets, Accounts Payables)
• Modified the UIA interface, Longevity interface and BEE Interface.
• Involved in Balance Initialization upload .Developed, design and tested to load balances into oracle HRMS
• Developed, designed and tested Performance details review report, Job code class report, and various audit reports.
• Developed Batch Element Entry interface Program for the employee assignments element entries.
• Developed, designed and tested interface to cost Oracle Payroll to General ledger.
• Wrote scripts to correct Element costing information.
• Customized seed oracle reports such as Payroll register, check Writer, Deposit Advice and New Hire State Report as per the DTW requirements
• Designed employee date tracked report, New Hire report, employee jobs history, employee assignment report, organization wise summary report to show regular earnings, over timing earnings, regular hours worked.
• Wrote Fast formulas for Payroll Elements, Accrual Plans, Absence Duration and Validate Elements for an Assignment.
• Defined Eligibility profiles, Enrollment Requirements, Plans, Programs and standard rates.
• Successfully converted employee contacts information and employees OAB conversion Medical, dental, vision benefits.
• Was involved on Open enrollments process.
• Developed outbound Interface for benefit external carrier BCBS, Delta Dental.
• Developed several reports in HR, Payroll and OAB using XML Publisher.
• Developed, designed and Tested User Responsibility report and this report is view by restricted person only for security purpose.
• Wrote scripts to reset Oracle user Password and changed password after 120 days.
• Designed, developed and tested changed user password using form personalization.
• Performance Tuning of Long running queries.
• Involved in end-end testing of objects including installation scripts, Download and upload Ldt files using FNDLOAD.
• Was involved to open oracle SR/Tar and fixed issue related HR/Payroll/OAB and Financial modules.
• Was involved in reverse engineering to get data from water department reports and provided audit reports.
• Wrote scripts to purged Workflow Notifications.
• Used UNIX shell programming for converting FTP scripts and writing new scripts for oracle job scheduling and file transfer automation.
• Worked on Noetix View and developed Noetix reports.
• Involved in post-production support for HR/OTA/OLM/Benefits/Payroll and financial modules.

Confidential

Oracle Application Technical/Functional Consultant

Environment: Oracle Applications 11.i (HR, Payroll, OAB), Oracle 8.i/9.i, SQL * Forms 6.i, SQL *Reports 6.i, SQL, PLSQL, SQL *Loader, TOAD, Oracle Discoverer 4i

Responsibilities:

• Understand client requirements, studied existing customizations and Prepared Technical documents MD70 (AIM Methodology), Code review and Code development
• Developed and executed testing strategy like unit, integration, system integration Testing.
• Successfully Converted employees information from legacy system using Oracle Standard API
• Wrote scripts to load Oracle SIT and EIT information.
• Designed, developed and tested internal and external interfaces.
• Wrote Fast formulas for Payroll Elements, Accrual Plans, Absence Duration and Validate Elements for an Assignment.
• Developed and tested reports like Worker Compensation, Stock option using Reports 6i tools
• Designed, Developed and tested Oracle workflow for salary performance review and sends notification to Supervisor. Wrote script to schedule the workflow.
• Wrote script to developed Training data which has been use to give training to users.
• Experience maintaining Oracle Discoverer Administrator Edition including Business area, Table based and custom folder, with appropriate joins, and registering user define PLSQL functions which use in reports and setting access rights and privileges.
• Extensively used AOL and Sys.Admin modules for set up of various concurrent programs, Request sets, Value sets and Descriptive flex fields
• Provided production support during and after HR/Benefits/Payroll and Financial go live.
• Developed Interface for BCBS, Confidential, COBRA.
• Developed Benefit Details and Summary report to get all employees benefits information.
• OAB fastformula creation/modification

Confidential

Oracle Application Technical Consultant

Environment: Oracle Applications 11.i (HR, Payroll, OAB, PO, AP, AR), Oracle 8.i/9.i, SQL * Forms 6.i/4.5,SQL *Reports 6.i/2.5,SQL, PLSQL, SQL *Loader, TOAD

Responsibilities:

• Provided post-production support to client; resolved issues for benefits, assisted users with additional training, and supported Benefits, HR, Payroll and Confidential
• Worked on fastformula.
• Developed Interface for BCBS Alabama, Confidential, NPA Express Script, Vision Plan and Cobra.
• Developed and tested FSA Amount report using Oracle report 6i

Confidential

Oracle Application Technical Consultant

Environment: Oracle Applications 11.i (HR, Payroll, OAB, PO, AP, AR), Oracle 8.i/9.i, SQL * Forms 6.i/4.5,SQL *Reports 6.i/2.5,SQL, PLSQL, SQL *Loader, TOAD

Responsibilities:

• Successfully Converted employees, Job, Position, Address, Assignment, Salary using Oracle Standard API.
• Designed, Developed and tested Oracle HR/Payroll Reports.
• Created Oracle Alert for Job, Location and Salary Basis changed
• Involved in Production Support for HR/Payroll problems.
• Was involved in OAB setup and wrote script to load Open Enrollment benefits legacy data using OAB sequence of API.
• Wrote PLSQL script to Update Rate value for 401(k) Savings Plan, ESPP - 01/2004.

Confidential

Oracle Application Technical and Functional Consultant

Environment: Oracle Applications 11.i (HR, Payroll, PO, AP, AR), Oracle 8.i/9.i, SQL * Forms 6.i/4.5,SQL *Reports 6.i/2.5,SQL, PLSQL, SQL *Loader, TOAD

Responsibilities:

• Successfully Upgraded HR/Payroll modules from 11.0.3 to 11i.
• Designed, Developed and tested Oracle HR/Payroll Reports.
• Provided post-production support to client; resolved issues for benefits, assisted users with additional training, and supported HR and Payroll
• Customized Optio reports Printed Purchase Order, Printed Change orders, printed RFQ and Printed requisition reports.
• Developed customized database trigger that populates a custom table whenever expediting-related information is changed on a purchase order shipment.
• Production support for financial modules.

Confidential

Oracle Application Technical and Functional Consultant

Environment: Oracle Applications 11.i/11.0.3 (HR, Payroll and Financial), Oracle 8.i/9.i, SQL * Forms 6.i/4.5,SQL *Reports 6.i/2.5,SQL, PLSQL, SQL *Loader, TOAD

Responsibilities:

• Successfully Upgraded HR/Payroll modules from 11.0.3 to 11i.
• Played active role in the data conversion of all HR and payroll data from over 2 legacy systems, including: preparation of data requirements for the end-user, data cleansing, troubleshooting API loading errors, full testing of converted data and all related processes.
• PO to IBS Interface, AR to IBS Interface, IBS to AP Interface
• IBS to AR (AR Lockbox) Interface

Confidential

Oracle Application Technical and Functional Consultant

Environment: Oracle Applications 11.i/ 11.0.3/10.7 sc (HR, Payroll, LD and Financial), Oracle 8.i/9.i, SQL * Forms 6.i/4.5,SQL *Reports 6.i/2.5,SQL, PLSQL

Responsibilities:

• Successfully Upgraded HR/Payroll modules from 10.7SC to 11i.
• Involved in standard benefit setup, wrote PLSQL program to change benefit (FBMC), terminate the benefit using API.
• Involved in the setup of Vacation and Sick Accruals. Wrote a PTO accrual report to capture YTD, PTD Vacation/Sick Taken by employees along with Accrued time and net entitlement
• Wrote PLSQL script, which calls API and Unix Shell Script for “student FICA” process
• Forms Configurator to developed WVU Enter Employees info using Oracle template.
• Designed, Developed, Customized HR and Payroll Reports, Forms, Custom Library according to clients need.
• Wrote Data Cleanup scripts for HR and PAYROLL Modules.
• Customized Optio Reports in PO and AR modules to include the university Logo.
• Customized Oracle forms 6i for the Raise Process and PTN Interface.

Confidential

Senior Programmer Analyst

Environment: Oracle Applications 11.i/11.0.3 (Hr, Payroll and Financial), Oracle 8.i/9.iSQL * Forms 6.i/4.5,SQL *Reports 6.i/2.5,SQL, PLSQL, SQL *Loader

Responsibilities:

• Mapping the Business Needs of the client to identify the areas that need customization and the set-ups required for implementation.
• Upgraded Oracle Application from 11.0.3 to 11.i and performance Tuning.
• Wrote PLSQL scripts, which calls API for Employee Atomized Process includes Create Employee, Create Address, Update Assignment, Update Assignment Criteria, Update Federal Tax Rules, Update State Tax Rules Update City Tax Rules, Update County Tax Rules, Create Salary Proposal, Create Payment Methods.
• Developed and tested interfaces like Balance Initialization process and Element Entry.
• Involved in the design and implementation of WEB Time Card application to feed Timecard entries into Oracle Payroll using Batch Element Entry (BEE), designed the interface to upload the Pay Batch Headers and Lines Tables.
• Customized the Oracle Payroll Register report.
• Designed, Developed the Reports, Forms, Custom Library according to clients need.
• Worked on Oracle Advance Benefits, Oracle Self Service modules.

Confidential

Programmer/Analyst

Environment: Oracle Applications 11.0.3(Hr, Payroll and Financial), Oracle 8.i, SQL * Forms 4.5, SQL *Reports 2.5, SQL, PLSQL, SQL *Loader

Responsibilities:

• Has worked on Data Conversions from legacy to Oracle Applications. Developed, designed, Customizations HR and Payroll Interfaces.
• Developed and tested custom reports e.g. EEO Reports, Fiscal Budget, and Accrual Report using Reports 2.5.
• Customized Fast Formula for the Oracle standard benefit element.
• Was involved in item upload

Confidential

Programmer/Analyst

Environment: Oracle Applications 10.7 NCA (Hr, Payroll and Financial), Oracle 8.i, SQL * Forms 4.5, SQL *Reports 2.5, SQL, PLSQL, SQL *Loader, SQL Navigator

Responsibilities:

• Interacting and Understanding the Client requirements
• Working as Oracle Application System administrator and giving postproduction support. This involves Setting up new users, Personal Profile Options, Responsibilities, Menus, Request Groups, Registration of new Reports and Forms etc
• Wrote a PLSQL scripts, which loads Batch Element Entry for Fringe Benefits Management Company (FBMC)
• Wrote a PLSQL Script which End dates the Supplemental and PEIA Elements and Nullifies the ATamount Freezing The Benefits salary and Changes into PEIA Coverage

Confidential

Programmer/Analyst

Environment: ORACLE APPLICATIONS 11.0.2/11.0.3 (HR/PAYROLL AR/AP/GL), ORACLE 8, Developer/2000 (Forms 4.5,Reports 2.5), SQL, PLSQL, UNIX SCRIPTS

Responsibilities:

• Upgraded Oracle Application from 10.7 to 11.0.3
• Involved in Balance Initialization Upload
• Interfaces for Merill Lynch Report, 401k related information.
• Customized Standard Oracle Reports like Payroll Register report, Checkwriter and Deposit Advise Report.
• Design, developed and tested the following Reports
• Garnishment Register Report
• Used NOETIX view to developed many reports.
• Production support for AR/AP/PO and GL modules.

Confidential

Programmer/Analyst

Environment: ORACLE APPLICATIONS 10.7(HR, Payroll and Financial), ORACLE 7.3, Developer/2000 (Forms 4.5, REPORTS 2.5), SQL, PLSQL

Responsibilities:

• Employee Upload (Nearly 30,000 Employees Loaded in Oracle Applications from Legacy system), Job Upload, Position Upload, Terminate Employees, Personal Payment Method
• Mass updates of Jobs and position
• Balance Initialization Upload
• Element Entry Upload (used Batch element Entry method to load elements)
• Reports:Third Party Payments FOC,Employees 401k Eligibility Report

Confidential

Sr. System Analyst

Environment: ORACLE APPLICATIONS 10.7, ORACLE 7.3, Developer/2000(Forms 4.5, REPORTS 2.5), SQL *LOADER, SQL, PLSQL

Responsibilities:

• Wrote PLSQL packages using API to convert legacy data to Oracle Application HR and Payroll modules.Developed and tested Oracle Payables Open interface import to load Different Methods of Submitting Concurrent Programs ( CONCSUB, FND REQUEST)

Confidential

Sr. Analyst/Programmer

Environment: PRO*C, ORACLE 7.1, Developer 2000 (Forms 4.5, REPORTS 2.5), PLSQL, SQL, SQL *Loader

Responsibilities:

• Developed, designed, tested complex forms and reports using tools developer 2000 (Forms 4.5, Reports 2.5).Wrote PLSQL packages, database triggers, performance tuning for various process.

Confidential

Analyst/Programmer

Environment: C, SQL, and PLSQL

Responsibilities:

• Involved in the analysis, designed, and development of an E-Mail System.