SUMMARY:

• Over 10 years of experience in Oracle Financials, Oracle Project Accounting and HRMS Modules 12.1.3./11i/ 11.0.3/10.7.
• Experience in Accounts Payable (AP), General Ledger (GL), Workflow, Project Accounting (PA), Purchasing (PO), HR, Payroll, Oracle Standard Confidential (OAB), Self Service Human Resource (SSHR) and Workflow.
• Rich experience in Oracle HRMS & Financials Full Implementation cycle by participating in design, development & implementation of various modules
• Experience in Development and Customization of WRICE (Workflow, Reports, Interfaces, Conversions and Extensions) Objects.
• Handled Data Migration, Data Conversion activities and Upgrade projects from 10.7 to 12.1.3
• Extensive experience in writing, testing and implementation of the Triggers, Functions, Packages using PL/SQL.
• Development of custom WEB Adi
• Worked on OAF customization and personalization.
• Developed Application Implementation Methodology (AIM) documents MD50, MD70, MD120 and Knowledge of BR100
• Experienced of implementing business process and life cycle of ERP systems through Workflow Builder.
• Expertise in post live production support in the areas of HRMS Modules, Financial modules and Workflow
• Strong Database tuning/optimization experience with very large databases (Explain PLANs, Indexes, Partitions, TKPROF, and Hints).
• Excellent communication skills such as Teaming and Collaboration with cross - functional, cross-organizational teams with the customer to identify, prioritize, and design solutions for business requirements.
• Working at different levels of development process having the ability to communicate with various levels of people in resolving key Functional/Technical issues.

TECHNICAL SKILLS:

Applications: Oracle Applications 12.1.3, 11.5.10, 11.5.9, 11.0.x, 10.7 SC

Oracle Tools: Forms 6i/6.0/5.0/4.5, Reports 6i/6.0/3.0/2.5, TOAD, PLSQL Developer, SQL Navigator, JDeveloper, Discoverer 4.1,OAF

Languages: C, Pro*C, UNIX command interpreter shell, SQL, PL/SQL

OS: Unix, Windows 98, Windows NT, Sun Solaris, HP-Unix, AIX

Database: Oracle 10g, 9i/8i/8.0.x/7.x/6.0

WORK EXPERIENCE:

Confidential, TN

Project Accounting (Costing & Billing)

Responsibilities:

• Worked as a technical consultant for the implementation of Oracle Project Accounting (Costing & Billing).
• Configured standard Project related setup Implementation options, burdening details related setup, and Project related workflow and profiles.
• Involved in setting up non-labor resource, billing cycle, event type etc.
• Worked on Billing events, Project costing and Budgeting.
• Worked on Billing Extensions to Create Event Holds
• Developed conversion scripts and sql codes for PA Revenues.
• Developed conversion scripts and sql codes for PA Invoices and customized the Auto Approval /Auto Release of invoices extension.
• Creation of expenditure types for interface supplier costs and miscellaneous transactions.
• Creation of projects and project status. Created various projects, tasks and sublevel tasks with in those projects.
• Did all the setups in PA like Project Class, project types and project templates etc
• Developed conversion process scripts and sql code for Projects and Tasks conversion.
• Setup of expenditure categories and expenditure types.
• Worked on resolving month end closing issues.
• Worked on resolving Priority one and show stopper issues.
• Familiar with tie-back programs and Project Status Inquiry (PSI)
• Validated the Integration with Accounts Receivable: Project related Purchase Order and Integration with Payables: Import and Review Project Expense.
• Worked on documentation of the setup requests for audit purposes.

Confidential

General Ledger

Responsibilities:

• Implemented Conversions such as Open Account Balance Conversion.
• Customized the workflow notification OAF page to add new fields and controller.
• Created new oaf framework page for users to enter email details by application group for notification of errors from different concurrent programs.
• Defined multiple currency for different currency accounts, currency conversion rates, initialized Multiple reporting currency for posting the journals from the sub ledger to the primary set of books
• Developed the interface program for GL Interface, which takes data from the Custom Tables to GL INTERFACE tables and generating Journals in Oracle General Ledger as of Clients Requirements.
• Developed numerous SQL*Loader scripts to load the legacy system data into custom staging tables and with the interface program it loads to GL INTERFACE
• Implementing journal import to load data from GL INTERFACE to base tables of Oracle General Ledger
• Worked on setting up the secondary ledger.
• Configured AAD, Accounting rules, secondary ledger mappings for SLA.
• Developed conversion script for AP Vendors (loading staging table’s data from legacy to oracle base tables).
• Developed custom 1099 process for 1099 B, 1099 Int, 1099 S, 1099 C and custom form for 1099 correction process to generate the electronic file.
• Configured custom WEB ADI for users to export and import data from system.
• Developed process to automate child support payments.
• Developed ach eText template for R12 payment process.
• Configured R12 payment setups.
• Customized supplier R12 forms to default some values for users (OA Frame Work).
• Customized the seeded api AP PO VENDORS APIS PKG for vendors so that more fields can be updated than the one s that is provided by seeded api.
• Custom Reports such as Payment Register, Invoice Review for possible Duplicates and Payment format check.
• Developed outbound interface for Payment items information from Treasury to Pass port (Legacy).
• Created lookups and values set for Deal types, deal subtypes & product types.
• Configured setups that includes customer profile class, transaction setups, auto accounting, receipts classes and receipts sources.
• Developed customer conversions scripts using party API’s.
• Developed receipts interfaces.
• Supported month end process and closing accounting periods .
• Developed custom script for converting the legacy assets data to Oracle Fixed Assets using FA MASS ADDITIONS interface table.
• Develop the custom to script to group all the stand alone assets in Oracle Fixed Assets using the FA ADJUSTMENT PUB.
• Developed a custom report to reconcile the data from legacy to Oracle that has been converted.
• Configured the Oracle iExpenses module and integrate it with Oracle Projects and Oracle Payables.
• Modified the iExpenses workflow according to the client requirements for approvals.
• Supporting Oracle iExpenses issues.
• Worked on the following interfaces that includes both Inbound and Out bound
• Output file for Loans ACH transactions used with Fed Advantage Connection
• An interface from Expense Reimbursement to feed cost for employee reimbursements to Oracle Projects
• Payment items information from Treasury to Pass port (Legacy).

Environment: Oracle Financials (GL, AP, AR, PO, PA) and Oracle Payroll (11.5.10, R12(12.1.3)), Oracle Standard Confidential (OAB), Reports, Fast Formulas.

Confidential, TX

Responsibilities:

• Developed AR invoice interface to load the Invoice information Base Tables. Developed and modified stored proc such as EDI Outbound Program and AP Check Audit Interface, Custom Payment Confirm Process, Invoice Update and Validation
• Developed custom codes for converting data from legacy to oracle for the following conversion
• Developed Customer Conversion with the standard API. APIs are used to load customer information to the base tables.
• Process labor, usages, travel, fee and vendor invoices. Validate that the processes completed successfully and documentation for audit purposes has been maintained.
• Tuned various existing reports and programs using EXPLAIN PLAN and tkprof.
• Performed Database Migration from legacy system to the Oracle data warehouse database.
• Analyze and report on Contract Engineers and provide data to Accounts Payable for invoice payment purposes and to General Ledger for booking of overhead entry.
• Developed complex SQL queries as per user requirements using TOAD.
• Create a new custom Payroll Register Report with specific sort order
• Consolidate Payrolls
• Conversion of Employee information, Assignment, and Taxes, Element Entries from legacy into oracle
• Develop Inbound and out bound Interface with FTP process for employee insurances with following companies

Environment: Oracle Human Resources and Oracle Payroll (11.5.10), Oracle Standard

Confidential, PA

Responsibilities:

• Customize Payroll Register to add summary calculations and with sort orders
• Create code combinations to achieve Balancing and Costing combinations
• Convert Element entries and create Element Links
• Interface 401k Savings Plan and build custom reports for the same
• Developed custom code for converting legacy data to oracle for the following conversion
• Create inbound and outbound interface for Medical and Dental benefits with Aetna
• Calculate Occurrence and Accruals through custom procedures
• Modify Payroll Check Report and Deposit Advice Report
• Using Discoverer Reports develop new workbooks, modify existing ones, create new business area and modify views
• Developed PL/SQL packages and procedures for the back end processing of the proposed data base design.
• Performed the set up the VSS source code architecture for the client.
• Created various database objects like functions, procedures, views, tables to meet user requirements.

Environment: Oracle Human Resources and Oracle Payroll (11.5.10), Oracle Standard

Confidential

Responsibilities:

• Develop Application Implementation Methodology (AIM) documents MD50, MD70 and MD120 for Payroll Reconciliation Report
• Developed SQL Reports using SQL*PLUS.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers.
• Analysis and design of data flow between the various components.
• Customize Vacation and Sick accrual report.
• Write Conversion and Interface programs
• Develop outbound interface for retirement data for The Teacher Retirement System of Texas (TRS) TRS Reporting and Query System (TRAQS)
• Interface HRMS Data to University of Texas (UT) and TRAQS Member Data
• Customize Paid Time Off (PTO) accrual plans according to employee classification, new hires and deductions to salary
• Load, Update and Terminate Elements using APIs

Environment: Oracle HRMS and Oracle Payroll (11.5.9), OAB, Reports & Fast Formulas