SUMMARY

• 8+ years of strong experience as an Oracle Apps functional consultant on EBS Release12 (R12 R 12.0.2) & Release 11i (R11i - 11.5.5, 11.5.7, 11.5, 10.2) financial modules General ledger, Accounts Payable, Account Receivables, Project Accounting, Procure to Pay, Cash Management and Fixed Asset.
• Financial Close/Reporting involvement with SAP BW, FICO, LIFO, FIFO.
• Project Costing, Billing, setup Project Types - Contract, Capital, Indirect, Auto Accounting, Allocations, Burden Transactions, Costing, Transactions, Projects Revenue and Billing extension
• Strong in Oracle EBS - GL, AP, AR modules with functional experience in analyzing business requirements, procedures & processes, module setup,functional design specifications, user training and post-implementation support.
• Expertise in all new features & functionalities on R12 i.e. Oracle E-Business Tax, Sub ledger Accounting Method, Multi Org Access Control (MOAC) and Advanced Global Intercompany System AGIS.
• Experience in all stages of ERP implementation including Requirement Gathering, Solution Design, GAP Analysis, Customization, Configuration, Testing and Project Coordination.
• Extensive experience in understanding and gathering client requirements, translating them in to various process alternatives, mapping into feasible solutions in Oracle Applications, managing functionalsetups related to Oracle applications.
• Involved in Implementation, Upgrade, Production Support, Migration and Customization of various domains of oracle applications.
• Involved in setup of GL and AP modules on production server, updating the test scripts.
• Exposure in preparation of high-levelfunctionaldesign documents for Custom application development, Conversions, Interfaces & Reports.
• Involved in documentation in accordance with AIM Standards (BP080, BR100 & TE040).
• Successful completion of Implementation, Upgrade and Production support.

TECHNICAL SKILLS

ERP: Oracle Applications R12 (12.0.2), Ver. 11.5.5, 11.5.7, 11.5.10.2

Oracle Apps Modules: General Ledger (GL), Project Accounting (PA),Accounts Payables (AP), Account Receivables (AR), Fixed Assets (FA), Cash Management (CM), Purchasing (PO),Costing, Inventory (INV), Order Management (OM), iExpenses, iReceivables, iProcurement, iPayments.

Databases Oracle: 9i/ 8i, MS Access

Languages: SQL, PL/SQL, C, C++, Java, JSP etc.

Oracle Tools: SQL*Plus, SQL*Loader, TOAD

Business tools: SPSS, working knowledge on Eviews.

GUI Tools: Oracle Forms and Reports, Oracle BI Publisher, Web ADI, Cognos, Oracle Discoverer and exposure to workflows. Oracle Reporting tools BIEE, Hyperion etc.

PROFESSIONAL EXPERIENCE

Lead Oracle EBS Financials Production Support

Confidential - Laurel, MD

Responsibilities:

• Worked in Oracle 11i and R12 Supply Chain Modules (SCM) and Finance (FIN) on Confidential SDP (Subscription Delivery Platform) Project.
• Worked on Billing Workbench Report that shows the AR Invoices created from the Billing Solution.
• Understanding business requirement and functional design document, Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications 11i and R12Finance (AP, AR, PO, GL, CST, SLA) and SCM Modules (OM, Inventory).
• Functional Lead Consultant for ASCP R12 upgrade project from 11i to R12 and create footprint for VCP suite for Oracle Applications Suite for over 40 Orgs spread across North America, Brazil, Europe, and Asia Pacific
• Setting up ASCP in decentralized environment - Instance linkages, Profile Options, Collections, Plan and related Setups. Analyzing collection methods and recommending to the end customer.
• Have setup and tested various ASCP Plans in various test environments for R12 Upgrade project, have executed Plans / Collections, reviewed Planners workbench, resolved various Oracle EBS Planning issues, have worked with Oracle Support teams on various Service Requests
• Have run various test cases / scenarios using Unconstraint based planning, Supplier Scheduling from ASCP planned Orders, demonstration to IT and Business Teams.
• Business Process improvements in Payables and Project Accounting areas reducing the transaction cycle time by more than 20% and increasing resource utilization/ allocation by 30%
• Maintained key Project Costing / Billing setups e.g. Project Types, Expenditure Types, Project Templates, Budget Entry Methods, Bill Rate schedule, Event Types
• Have setup MRP/DRP Plan Options and also ASCP Plans in test environments for R12 Upgrade project.
• Created and maintain Job and Bill rates for Contract Projects
• Troubleshooting issues related to Project revenue recognition, billing, Expense Report, Supplier Invoices and Fixed Assets Interface.
• Worked on XML Bursting to send emails and FTP the PDF files.
• Worked on EDI Sales Orders to load into Oracle Applications Sales Order Pagewhich comes from external source systems via raw xml files.
• Performed Inventory Costing, Surplus and Obsolete Analysis, FIFO and LIFO estimates.
• Knowledgeable with the Oracle AIM Methodology (MD050, MD060, MD070, BR100).
• Develop database clean-up strategies using Oracle standard archiving and purging processes.
• Responsible for creating clean-up scripts to remove lease and service contractdata which includes the contract, asset information, customer invoices, install base lines etc.
• Configuring Project Accounting module
• Worked on Fixed Assets module by managing assets which includes depreciation periods, summary of depreciation periods, FA Books etc.
• ASCP unconstrained plan.
• Developed a new Confidential Price Book Report, Confidential Price Book History RDF Reportsin Report Builder 10g.
• Development of SID Transfer, to change the distributor, reseller and end customers from one instance to other for the orders that are already booked in production as per the Confidential SDP Project requirements.
• Developed Self Service Pages for Sales Order Creation using Oracle Application Frame Work (OAF).
• Worked on OAF Personalization on adding links and custom pages.
• Identify and reconcile the differences between previously used Coins system opening and closing figures and Oracle Financial and Project Accounting Modules (Project Costing, Billing and Project Contracts) for the operating unit.
• Development on Workflow Customizations for sending the sales order to VCHS before provisioning the Sales Order.
• Used Workflow builder 2.6 to customize existing processes by adding new notifications.
• Coordination and Worked on daily QA Bugs and blockers after developed and fixing it.
• Working Experience on 10 releases with Business Analyst and Integration Team during CRP Testing.
• Led initiative for developing Reports in R12 ASCP environment from Planner's workbench.
• UAT and Production Support during each phase go-live.
• Developed Load statements (control files) for SQL*Loader to load legacy data from flat files in to oracle tables.
• Implemented Pl/SQL Stored Procedures to load data from staging tables to interface tables.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts
• PL/SQL coding for Exception Handling and duplicate data maintenance.
• Developed UNIX Shell Scripts and PL/SQL procedures to extract and load data for month-end batch processing.
• Developed interface for loading supplier invoices from various sources.
• Developed Auto invoice program for loading customer invoices.
• Responsible for Month Close, Quarter close process for General Ledger.
• Working with oracle support to resolve TAR and performance issues.
• Provided support for Data conversion from legacy system into oracle.

Environment: Oracle Applications 11i and R12 Finance (AP, AR, PO, GL, CST), Project Accounting (PA), Fixed Assets (FA), Installed Base, Service Contracts, Sub Ledger Accounting (SLA) and SCM (OM, INV), ASCP, PL/SQL, EDI, OAF (Oracle Application Frame Work), TOAD, XML/BI Publisher, SQL Plus, SQL Loader, Discoverer Reports, Form Personalization, Oracle Reports 10g, Workflow Mailer, UNIX Shell scripting.

Oracle EBS Financials Production Support

Confidential, Galesburg, MI

Responsibilities:

• Supported a production Oracle financial system, including modules HR, AR, GL, AP, and PO, with problems resolution, installations, and business solutions.
• Functional Lead Consultant for ASCP R12 upgrade project from 11i to R12 (12.1.3.8) and create footprint for VCP suite for Oracle Applications Suite for over 40 Orgs spread across North America, Brazil, Europe, and Asia Pacific
• Automated the Billing system using Oracle database for billing various customers. Implement solution to provide accurate billing and save lot of money for company.
• Migrating Oracle Project Accounting setups in R12 and related to DFF
• Provide FIFO layer cost and ad-hoc cost analysis to branch management as requested.
• Identified and ensured fixes for ASCP bugs in 11i where addressed, while implementing R12 ASCP
• Participated in various project management activities such as estimation using Project Estimator tool. Project costing and billing, Effort and schedule measurement/slippage using XDPortal, Creating status reports.
• Setup and implementation of Project Accounting (PA)
• Oracle R12 Implementation of Financial and Supply Chain (Oracle AR, AP, GL, CE, FA, Purchasing, Inventory, Costing Standard, Avg and FIFO and Landed Cost Management)
• Have setup and tested various ASCP Plans in various test environments for R12 Upgrade project, have executed Plans / Collections, reviewed Planners workbench, resolved various Oracle EBS Planning issues, have worked with Oracle Support teams on various Service Requests
• Have run various test cases / scenarios using Unconstraint based planning, Supplier Scheduling from ASCP planned Orders, demonstration to IT and Business Teams.
• Conducting UAT sessions with key users and Go Live with minimal issues in Post Production support
• Led initiative for developing Reports in R12 ASCP environment from Planner's workbench. Working alongside development team and interacting with end users/EATON IT team for requirement analysis, UAT, production deployment and post production validation.
• Preparation of Standard operating procedures (SOP s), end-user training material for Project Costing, Billing, Project Contracts and other customized modules.
• Have worked on Oracle Inventory modules for completing standard functional setups such as Organizations, locations, Sub-inventory, locators, Planners, Inventory Parameters.
• Customized revenue Recognition rules by using API's in Project Accounting.
• Working with users on Order Management processes like sales Order booking, Pricelist Management, Manufacturing and subsequent shipping, Setting up custom documents sets with printer preferences.
• Working along with users to setup supplier schedules, interaction with ASCP, Requisition import and creation, PO reschedules etc.
• Working with Users to use Transaction Open Interface to trigger Material transactions from within and outside Oracle sources for various transactions like Account Issue/receipt and Miscellaneous transactions.
• Working with users on setting up BOM, Routings (Discrete and Flow), Discrete and ATO manufacturing and on various transactions like Assy/Flow Completion with LPN drop. Working to setup related cost management elements like Material, material overhead etc and rollups.
• Conducting feasibility study for Oracle Process Manufacturing (OPM) module for the end customer.
• Rolling out Global Trade Management (GTM) to new Orgs in Oracle EBS system. Ensuring classification codes and setting up Shipping document sets for the new orgs.
• Oracle AIM Methodology (BR100, MD060, MD070)
• Working closely with Eaton Trade Management group on setting up Trade processes and training End users on GTM module and functionalities
• Rolled out Cost Tracking solution for users utilizing Oracle Quality module to automate Cost Calculation process.

Environment: Oracle Applications 11i & R12, Project Accounting (PA), AP, AR, PO, GL, OM, INV, TCA, ASCP, Work Flow, Oracle 10g, FIFO Costing, Inventory, Forms 6i/10g, Reports 6i/10g, Discoverer 4i, XML publisher, SQL*Loader, PL/ SQL developer, UNIX.

Oracle Functional Lead

Confidential, Jersey City, NJ

Responsibilities:

• Implemented application customizations based on fit-gap analysis and enhancements for Projects, Grants, Commitment Control Billing, Projects, AR, AP, AM,Travel & Expense, Contracts and GL modules.
• Owned monthly expense projections utilizing various methodologies that accurately communicate sensible expense management to maximize margin.
• Setup and Configuration of the AP (vouchers, payments), GL, AR, Project Costing & PO modules as per the business requirements
• Serve as Lead consultant in the Project Management Office (PMO) providing software quality oversight to projects/releases, to ensure all projects/releases are following Federal Employees Program Operations Center (FEPOC) standards and procedures.
• Upgrade of Financial and Project Accounting modules
• Worked with the client team to understand the current Business Process.
• Developed test plans and scripts and conducted testing for quality assurance.
• Performed set up for GL, AP, AR modules for R12.
• Worked on General Ledger Multi-org on an R12 implementation through initial Conference room pilot (CRP).
• Performed requirements gathering, gap mapping. Responsible for initial setups using Accounting Setup Manager.
• Assisted/reviewed Payables and Cash Management.
• Maintaining and updating BR100 documentations.
• Determine business requirements for integration, including review of Chart of accounts to ensure adequate coverage forfinancialand statutory reporting.
• Maintain document version control for entire FEP Operations Center.
• Conduct training forFEPOCassociates on new/existing processes and procedures including formal and brown bag sessions
• Collaborated with corporate matrix partners to publish monthly regional operating metrics that aggregate product-line earnings and outlook.
• MaintainFEPOCProcess Asset Library (PAL) including process, procedures and templates.
• Enhanced earnings and expense forecasting model to reduce process time to focus on expense drivers and internal management controls
• Implemented cost reduction initiatives to contain temp expense by creating a temp spend tracking database, and a regional approval process
• Fortified Senior Management understanding of key drivers and corrective action plans for monthly regional expense calls
• Prepare Test Scripts and test cases in Financial (GL, AP, GL, FA, AR) and Project Accounting modules (Project costing, billing)
• Add a new Claim paragraph toFEPOCprograms (COBOL/DB2) - if the Procedure Code is equal to A0998, and the Service Begin Date is greater than or equal to 1/1/2006 but less than or equal to 12/31/2007, one of the EOB Remark Codes must be equal to a total rejection (first position must be equal to a "T").
• RedesignedFEPOCprograms (COBOL/DB2) and (Lead) conducted software testing on revisions to existing applications to create efficient and maintainable new applications, as well as responsibility for implementation of the software.
• (Lead) Analyzed and translated functional specifications created by business analyst and change requests into Technical Specification.
• Created/Performed test cases for the Federal Employee Health Care Programs: Unit test, Integration test, System test, and Acceptances test.
• Created management reports using COGNOS and other relational database platforms to support the strategic decision-making by SMT
• Enhanced and automated existing Access databases using Visual Basic in order to increase efficiencies and improve analytical workflow
• Provided "drill-down" analysis in order to identify primary market and product specific cost and utilization drivers and suggest corrective action plans
• Created, assessed and quantified concurrent Medical Action Plans (MAP)s to reduce medical cost and drive favorable financial results

Environment: Oracle 10g/9i, Project Accounting (PA), Forms/Reports10g, SQL*PLUS, SQL*Loader, TOAD, Shell Scripting, workflow builder, UNIX, Oracle E-business suite 11i (OM, HRMS, PO, GL, INV).

Oracle Apps Techno Functional Consultant

Confidential - Sunnyvale, CA

Responsibilities:

• Customized and Developed the Quote to sales agreement process and create the new price list based on quote process dynamically.
• Developed the Payable interface process using Web ADI for purchasable and non-purchasable items.
• Actively participated in addressing post-implementation issues and errors in Financials (AP, AR, FA, CM, GL), Oracle Project Accounting (PA) (Costing, Billing, Resource Management, Oracle Time and Labor (OTL).
• Customized Blanket/ROM Release process based on the client business needs.
• Developed the Lot tagging form and calling standard order form using ZOOM functionality.
• Prepare Test Scripts and test cases in Financial (GL, AP, GL, FA, AR) and Project Accounting modules (Project costing, billing)
• Worked on XML Bursting program to send emails and FTP the PDF files.
• Developed Turnkey Engine process customized standard procure to pay process to meet the client requirements.
• Developed Turnkey Rejection form to project the rejected Purchase orders based on client requirement.
• Implemented Advanced Global Intercompany (AGIS) for Subcon intercompany process.
• To in corporate Subcon intercompany Key Automation process customized standard process and developed custom objects to meet client requirement.
• Developed the multiple process using Standard API's like Inter org transfer, DOT, Miscellaneous issue, receipts and internal order import.
• Worked on up gradation process from 11. .1.3, Retro fit 11i objects code to make sure should not disturb exiting functionality and maintain the 12i standards.
• Critical process design and validations in Procure to Purchase cycle
• Use of Sql * loader utility to load data from legacy system to interface.
• Involved in customizing reports and interfaces.

Environment: Apps Supporting Release R12 (12.1.3), 11i (11.5.10.2), Finance (FIN) and Supply Chain Management (SCM) Modules: PO, OM, INV, AP, AR, CST, SQL, PL-SQL, Forms 6i, and Reports 6i, SQL plus, Web ADI and UNIX Shell script.

Oracle Applications Techno-functional Consultant

Confidential, Hollywood, FL

Responsibilities:

• Interacted with business owners andfunctionalconsultant experts effectively to understand business requirements,functionaldesigns, process flow and data flow.
• Developed GL journal extract by using UTL FILE as data feed for mainframe system.
• Worked on PO workflow approval process and also worked with ORACLE on workflow product related issues to correctfunctionalissues.
• Coding of custom reports for Purchasing (PO) module, defining concurrent programs, value sets and parameters.
• Developed a package to import vendor information into purchasing base tables.
• Extensively worked on RICEWF objects to view, transfer and modify the data in the same or different system.
• Responsible for technical deliverables -- Reports, Data Conversions, etc including documenting the same.
• Worked on Oracle Alerts. Created Periodic and Event Based Alerts.
• Worked on modifying the custom Order workflow to restrict errors which are getting while booking the orders in other than US operating unit.
• Created PL/SQL, SQL, SQL*Plus, and SQL*Loader scripts to validate and call stored procedures to validate and populate database objects before generating Oracle Error and Status reports.
• I provided technical support to the offshore team during their business requirements, design changes and testing of the Install base interface.
• Developed new (Financeand HR) reports using Reports 10g (Xml publisher, rdf Reports 10g)
• Creation of new payrolls and data migration by using Open Interfaces and conversions.
• Worked on Data migration activities of Core HR/Payroll through conversion scripts (like personal, grade, qualifications, element entry, pay proposals etc)
• Used Bulk Collect feature to improve performance.
• Tuned Report performance by exploiting the Oracle's new built-in functions and rewriting SQL statements.
• Involved in SQL Tuning using the Explain plan and indexes.
• Developed conversion programs for Items and Service Contracts using Oracle PL/SQL and Standard APIs.
• Responsible for the development of conversions/interface programs - Barter Tax interface, Conversion of service contracts from quotes.
• Developed many new reports like Customer Order status Report, Backlog Detail Report, Backlog Summary Report, Backlog by Item Report, Cycle Status Report, Open Work Order Report, Sales Rep Commission Report, Customer Profiles Report etc.
• Used the features of BI/XML Publisher such as Sort, Group, Total, Subtotals to make data intense operations happen at the template level.
• Developed Custom reports, Customized existing reports (Bill of Lading, Customer AR Aging Report.
• Customized Order Discount Detail Report by adding up two more fields (List Price Subtotal & Selling Price Subtotal) for existing List Price & Selling Price.
• Involved in Customization of reports using Discoverer 10g.
• Customized a report 'On time Delivery Analysis Report' which gives detailed output of how many orders are shipped early, late and on time for each customer using XML publisher.

Environment: Oracle E-business suite 11i (OM, HRMS, PO, GL, INV), Project Accounting (PA), Oracle 10g/9i, Forms/Reports10g, SQL*PLUS, SQL*Loader, TOAD, Shell Scripting, workflow builder, UNIX.

Financial Planning & Analysis

Confidential, Atlanta, GA

Responsibilities:

• Reduced monthly transportation costs ($0.38 per mile over two years, a 15% reduction worth over $1.2M in EBITDA), accrual variances & related adjustments by developing complex statistical forecasting models.
• Collecting, Documenting, Designing & implementing the enhancements requested and Project Accounting (Project Costing, Billing, Oracle Time and Labor, Project Resource Management Project Intelligence Modules
• Developed innovative statistical models to forecast the highly material transportation expense accrual based on multiple data points utilizing historic trends, claims processing parameters and local market characteristics resulting in reduced forecast variance on transportation expense from ± $0.75M to ± $0.1M.
• Developed a highly efficient financial reporting system to obtain financial data from accounting system, bypassing the need to use FRX, which was slower and less flexible.
• Implemented a MOR (Monthly Operating Review) process, a platform forfinanceand operational management company wide to address and present monthly results and issues to the executive team.
• Championed creation of enterprise data warehouse. Mentored, trained and supervised analysts and accountants in modeling, automation and excel tips to fully utilize all available data to improve quality of analytics.
• Slashed time required for monthly close cycle by 2.5 days and thereby reduced number of accounting staff (1.5 FTE) required by automating several monthly accounting processes.
• Led team in analytic preparation and modeling for potential sale of company (Prepared CIM, Management Presentation and managed the Due Diligence process)
• Prepared macro-economic analysis to study the impact of gas prices on utilization and transportation expense