SUMMARY:

• Over 25 Years IT experience including 17 years in enterprise - wide Oracle Applications design, development, systems analysis, defining system standards, implementation, and database administration.
• Solid expertise in functional as well as technical aspects of ERP solutions implementation using Oracle Financials. From 10.5.7 to Release 12.1.13 ver 10 years Installation and configuration of Oracle tools and databases, export, import, stored procedures, packages, functions, triggers, auditing and tuning database for performance.
• Did 7 upgardes end-to-end out which 3 upgardes on version 12 of EBS
• Followed all SLDC and SOX compliance and GAP analysis
• Over 22 Years IT experience including 15 years in enterprise-wide Oracle Applications design, development, systems analysis, defining system standards, implementation, and database administration.
• Solid expertise in functional aspects of ERP solutions implementation using Oracle Financials and Manufacturing. From 10.5.7 to Release 12.1.13 ver 10 years Installation and configuration of Oracle tools and databases, export, import, stored procedures, packages, functions, triggers, auditing and tuning database for performance.

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g

Languages: SQL,PL/SQL

ERP: Oracle Applications (Oracle Financials V 10.6 SC & V 10.7) & 11i, 11.5.10.2, R12.0.4

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. Business Analyst/Project Manager

Responsibilities:

• Production support AR/GL/AP/SLA/Vertex and Cash Management
• Secondary. Production support in Purchasing and Inventory and OPM
• Conduct Requirements Gathering Perform functional and gap analysis and Develop and document functional design.
• Work with the technical team offshore for implementation of projects and MD50 requirements.
• Project Management in implementation of accrual tax and self assessed tax on Projects and Manufacturing Inventory.
• Provide training to users and guiding them
• Implementation of Oracle Cash Management, Oracle Receivables and Oracle Payables
• Implementation and upgrade of vertex O Series for sales and use tax
• Served as team lead for the Order Management workstream with ownership of the Quoting, Order Management, Shipping Execution and Pricing modules
• Leading global requirements gathering sessions, performed Quote to Cash process anaylsis and identified key business requirements specific to several of the client’s Houston, TX locations. Facilitated map & gap analysis and identification of all custom reports and extensions.
• Designed several customer facing reports across the Order Management and Shipping modules. Facilitated testing f all Order Management workstream reports, customizations and interfaces.
• Overseeing the CRP, SIT and Production Pilot testing efforts for all Quote to Cash modules. Managing the capture and resolution of all workstream issues. Responsible for issue resolution and reviewing risks & issues with the Project Management Organization (PMO).
• Implemented the Trading Community Architecture (TCA) to best fit the client’s customer data and reporting requirements. Led cross-workstream design sessions and facilitated the execution of customer data conversion.
• Established plan for the manual entry and reconsiliation of open sales orders.
• Assisted with deployment plan creation specific to the Order Management workstream which included conversion schedule and environment preparation activities.
• AR setup for foreign currencies
• Tax lines setups
• Setting up invoice rules
• Credit Memo setups
• Account Assignment
• Exchange Rates
• Receipt setups and cross currency receipts
• Rule application sets
• Setting up Notes for Receivables
• Auto Lockbox validation
• OTC with OM
• Solid understanding of Oracle EBS Database/Table structure to enable effective data analysis, troubleshooting and report design
• Experience with Oracle System Administration, Workflow, Data Loader, Data conversion and 3rd party system integration with Oracle EBS
• Payables changing banks and CTX/Nacha setting up separate remittance advice and CTX to banks.
• Creating and Applying AR receipts using API
• Payables Vertex and on use tax and sales tax support in AR. Customization between EBS and Vertex.
• Lockbox automation.
• Working on issues from business users on the above modules.
• Working on MFAR and change of journal rules for Receivables. Also SLA on payables
• General Ledger support for users and setting of cross validation rules and balancing segment rules.
• Presently working with EBTAX and Vertex O series for integration of use tax and sales tax. Creating lookup tables in vertex and have custom integration with EBTAX.
• Payables attachments on invoices
• Get applied project using AR interfaces

Confidential

Sr. Business Analyst/Project Manager

Responsibilities:

• Key responsibilities included configuration, maintenance and testing as well as management of PA month end closing tasks.
• Responsible for the integrity of accounting journal entries generated during the Project Accounting Costing, Billing, and Invoicing and closing processes .
• Configuration of key areas in Project Costing, Project Billing Auto Accounting, suitable Business flow setups to the client.
• Defined Project related setup options, Project calendar, Project
• Period and identified Project types, Project Templates, Task related setup and Project related workflow and profiles
• Worked on setting up the Project rate Schedule for Labor and Non -
• Labor preferences for Oracle in order to facilitate the resources to enter their cost against the Project and Task number.
• Involved in customizing the Project Accounting suite for reporting activities
• Prepared integrated test cases for each setup and End User training material on the Project Accounting module
• Added Accounting Rules for Autoaccounting and creating Lookup sets.
• Defining the work structure by defining GL Calendar, GL Currency PA Calendar, PA Currency
• Worked on Project Asset Assessment and Capitalization
• Configuration of Oracle Project Costing Auto Accounting to standardize and streamline the account generation for material labor and miscellaneous transactions.
• Implementation for international branches including setup of legal entities, sets of books and other aspects of integration with US books
• Custom reports showing drill down information from payables and inventory

Confidential, Shorewood, TN

Sr. Business Analyst/Project Manager

Responsibilities:

• Customization and production support for forms and reports in the above modules.
• Month end closing in multiple sets of books, currencies and languages.
• Direct updates to tables for resolving production issues.
• Working on custom projects in GL and AP.
• Experience in Oracle E-business suite Order API and Customer API
• Guiding Business Analysts and users in the Financial SystemR12
• Setup of customers, vendors, invoice types, invoicing rules, interfaces, pcard
• Experience in designing custom components, data conversions, extensions, interfaces to 3rd party systems, workflows, integrations, patch applications, reports, etc (RICE components)
• Sub Ledger accounting setups and reconciliation
• Customization of Invoice print program to print in XML
• Auto invoice and customer interfaces
• Iexpenses upload and customization
• Customization using Oracle forms release 10 on following: AR Invoice, receipts, customer, payables invoice entry and check payments.
• Led the implementation of the Telesales, Order Management, Advanced Pricing and Shipping Execution modules.
• Conducted global requirement sessions, performed Quote to Cash process anaylsis and identified key business requirements specific to France and Germany from a process and regulatory standpoint.
• Implemented and customized Oracle’s International Trade Manager (ITM) module with Kewill for export compliance screening of sales order and shipping transactions.
• Facilated the design of client facing documentation and operational reporting across all Quote to Cash modules.
• Designed extension to the Shipping Execution module; providing capability to disassemble, package and ship large scale products based on an item’s bill of material.
• Designed OM workflow customizations to provide improved integration between the Order Management and Projects modules.
• Developed the price list conversion. Facilitated the manual sales order conversion and reconciliation effort. Facilitated CRP and UAT testing efforts for all Quote to Cash modules.

Confidential

Sr. Business Analyst/Project Manager

Responsibilities:

• Loading the Vertex Rate File.
• Define regime and taxes
• Properly defined the service subscriptions
• Tax calculation method of "Tax Regime Determination"
• Party tax profile for your Legal Entity* that owns the operating units where you will use vertex for tax calculation as well as for each operating unit.

Confidential

Sr. Business Analyst/Project Manager

Responsibilities:

• Worked on Project Asset Assessment and Capitalization
• Configuration of Oracle Project Costing Auto Accounting to standardize and streamline the account generation for material labor and miscellaneous transactions.
• Detail and Mass Additions
• Linking Captial Projects to Assets
• AR setup for foreign currencies
• Tax lines setups
• Setting up invoice rules
• Customer and invoice setups
• Auto invoice and customer load by interface
• Credit Memo setups
• Account Assignment
• Exchange Rates
• Receipt setups and cross currency receipts
• Rule application sets
• Setting up Notes for Receivables
• Auto Lockbox validation
• Collections setup
• General Ledger
• Legal entity and set of books multiple with multiple currency
• Sub Ledger Accounting reconciliation and setups
• Periods accounting and budget
• Setups for cross validation rules
• Cash Management:
• Loaded bank statements for reconciliation
• Developed custom reports

Confidential, Memphis, TN

Oracle Senior ERP Analyst / Support

Responsibilities:

• Working with a team of 10 developers and team of help desk support people.
• Business and technical requirements on following modules:
• Accounts payable, Inventory, Oracle Process Manufacturing, purchasing and accounts receivable. Functional support in the above modules
• Worked in functional/technical aspects of Oracle Internet Expenses and iReceivables
• Workflow notification and customization for purchasing
• Worked on various reports and forms in developer 6i
• Customer refunds - AR
• The transition process (in brief) involves payables collecting copies of all utility and solid waste bills from all locations to send to Avista.
• Positive pay
• Hierarchy in GL reports
• Designed an OM workflow customization to streamline the internal requisition and internal sales order processes
• Facilitated the manual sales order conversion and reconciliation effort implementations.
• Provided OM training, knowledge transfer and go-live support various locations.
• Practiced AIM methodology in all aspects of process analysis, requirements gathering, documentation and design
• Worked on Order to Cash life cycle implementation and integrating modules.
• Developed sales order conversions using order import interface .
• Analyze, Design and Develop Accounts Receivables Auto Invoice Interface.
• This involved data mapping and developing Conversion programs for converting Invoices, Credit Memos, Debit memos using PL/SQL script.
• Configured Oracle R12i AR and Advanced Collections as per the business needs and the user specifications. Played a major role in setting up accounting for oracle AR, Advanced Collections and GL modules of Oracle E-Business Suite
• Configured Oracle AR to setup Transactions & Receipts. Transactions include setting up the Payment terms, Invoice Line ordering rules, Transaction Types, Transaction sources, Grouping rules, Auto Accounting, batch sources etc. Receipts configuration includes Auto Cash Rule Set, Remittance Banks, Receipt Classes, Payment methods, Receipt sources, Lock box setup, Transmission Format Setup, Setup for cross currency Receipts.
• Implemented setup for GL Daily currencies. Defined currencies for all the countries that business needs. Also setup cross currency receipts to use currencies available. Used corporate currencies as cross currencies.
• Wrote a package to load the GL daily rates into oracle and use them accordingly, made use of the staging tables for initial load, validated and loaded them into the GL DAILY RATES base table. Also performed SQL tuning to improve the loading accuracy of the data.
• Used shell scripts for loading the initial data into the staging tables by using SQL*Loader.
• Played a key role in assigning the reporting set of books to primary set of books.
• Opened and closed Periods in both reporting and primary set of books.
• Used MRC to convert Functional currency into another currency at the transaction level.
• AR RECEIPT API PUB.CREATE AND APPLY API to create and apply cash
• Educated users for using Oracle AR and Advanced Collections for implementation.
• Participated and played a key role in understanding business needs and integrating them with Oracle.

Confidential, Boston, MA

Sr. Oracle Developer -Supervisor

Responsibilities:

• Managing a team of 7 developers for custom application development and support
• Developed functional and technical documentation for implementing Oracle Applications
• Used PL/SQL for developing packages and procedures using Dynamic SQL
• Did setup of the following in iProcurement:
• Document sourcing setup
• Worked on the following modules in Oracle Applications AP, PO, GL, FA, MFG, OM, Performed Q/A activities to ensure that Reports meet the functional specifications
• Created PL/SQL procedures, packages and functions used to load and verify data from vendor feeds into an Oracle Database
• Working on Pl /sql packages, procedures, functions, Created views, customized forms and reports (6I)

Confidential, Waltham, MA

Sr. Oracle Developer

Responsibilities:

• Managing a team of 10 developers
• Developed PL/SQL packages, ten SQL reports, twelve views and many triggers to support the GUI. Developed ten PL/SQL packages to integrate the Oracle Manufacturing tables and the look tables in the present system.
• Developed new Forms using Developer 2000 and Forms 4.5 to implement user requirements.
• Modules worked on include Bill Of Materials and Oracle Purchasing to integrate the current data into Oracle tables with manufacturing tables.

Environment: Database: Oracle 7.3, Oracle Manufacturing