Management Project

SUMMARY

A dynamic result oriented professional with 8 years of experience in comprehensive understanding and workings of Oracle ERP Applications which involves setup, design, customization and testing.

Good experience as a Techno-functional consultant in implementing oracle financials, supply chain and manufacturing modules like oracle General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Fixed Assets (FA), Oracle Project Accounting (Costing, Billing, Project Management, Project Contracts) Cash Management (CA),, Purchase Orders (PO), Order entry (OM), Shipping (WSH), Advanced Pricing (QP), Inventory (INV), Bill of Materials (BOM), Work in Process (WIP), Engineering, Costing, Customer Relationship Management (CRM) and various other modules.

Good exposure on Business Processes across the E- Business Suite, Order to cash & Procure to Pay life cycles.

Expertise in design & development of RICE components.

Extensive experience in using sql*loader to import data into staging tables form legacy system.

Specialized in designing and developing Reports using Oracle reporting tools such Discoverer 10g/4i, Developer suite, Reports Builder, XML / BI Publisher for critical business requirements of various modules.

Excellent programming skills in writing SQL/PLSQL functions, stored procedures, packages and fine-tuning of code for better performance.

Extensive knowledge in creating and customizing Forms, workflows and developing alerts based on business requirements.

Good knowledge and understanding on Oracle Techstacks which includes AOL concepts, Multi-Org and TCA (Trading Community Architecture).

Well-versed in preparing User training guides and AIM documentation (MD50, MD70, MD120, CV60).

In addition to excellent technical abilities, possesses strong oral and written communication skills, humble leadership, enthusiasm on work assigned, analytical and interpersonal skills.

TECHNICAL SKILLS

ERP Oracle Applications EBS11i/R12

Modules General Ledger (GL), Accounts Payables (AP), Accounts Receivables(AR), Advanced Pricing(QP), Inventory (INV), Work in Process (WIP), Bills of material(BOM), Order Management(OM), Purchasing (PO), Material Resource Planning(MRP), Cash Management, Shipping(WSH), Application Object Library (AOL).

Processes Order to cash, Procure to Pay

Operating Systems UNIX, Windows NT/2000/2003 Server

Database Oracle 7x/ 8i / 9i / 10g/11g/R12

GUI Developer 2000/6i/10g

Tools and Utilities Discoverer, XML Publisher, SQL * Loader, Toad, SQL *plus

Languages C, C++, SQL, PL/SQL, Java

Web Languages HTML, XML, XHTML, JavaScript

PROFESSIONAL EXPERIENCE

Client: SP PLUS Corporation Chicago, IL

Project: Oracle Applications

Duration: Dec 2012 – Current Date

Designation: Techno-Functional Consultant

Responsibilities:

Worked on the global implementation of Oracle Financials modules such as General Ledger, Account Receivables with Order Management.

Worked on creation of customer statement report which is a 5 buckets report.

Worked on Auto lock box interface in AR.

Worked on Payables Invoice Interface in AP.

Worked on Purchasing Requisitions Interface in PO.

Worked on Invoice approval system IPM and also in creating attributes, conditions and writing new rules in AME.

Development of interface programs involving AR customers interface and conversion programs included GL Code combination conversion program.

Lead the off shore team in the development process for the customization of Oracle applications.

Developed approval rules based on invoice amount for the following transaction type Payables Invoice Approval using Oracle Approval Management (AME) and configured action types and actions and set up the profile option to work for Payables only and also the required setup through Payables Options form.

Responsible for functional specifications and testing on any customizations or development in the applications.

Involved in the data mapping and conversion programs for moving legacy data to Oracle Service Contracts.

Customized the Auto Renewal process in Service Contracts by listing out the reasons for service contracts not being renewed, and modifying it accordingly.

Worked on customizing FSGA reports based on business requirements.

Developed a custom Wrapper & did the necessary validations in getting the data from the Banks into oracle tables with the help of Auto Lock Box Interface in AR.

Worked on bringing suppliers onboard through iProcurement.

Setting up local catalogs, punch-out catalogs in iProcurement.

Worked on configuring XGM mapping files for posting PO’s and invoices.

Extensively worked on Auto Invoice Interface in Receivables.

Extensively worked in writing wrapper programs for Payables Invoice Interface in Payables.

Develop a customized report with instance-id, status, location and, delivery details, service details.

Worked on the auto invoice for the invoices generated from Order Management.

Environment: Oracle Applications R12 PO, AP, AR, iProcurement, Developer suite 10g, PL/SQL, Stored Procedures, UNIX, AOL.

Client: Euramax International, Inc. Atlanta, Georgia

Project: Oracle Applications

Duration: Aug 2011 – Dec 2012

Designation: Techno-Functional Consultant

Responsibilities:

Worked on resolving the technical issues related to OTC and P2P cycle.

Involved in Purchase Order Requisitions Import Program.

Worked on Supply chain management Module.

Worked on iprocurement workflows like po xml wf & po approval wf..

Developed SQL * Loader programs to load data from flat file to staging tables. Written PL/SQL procedures to validate and load the data into the Oracle Interface tables or directly into the Oracle base tables for the respective modules.

Extensively worked on customer Update in Receivables Using TCA architecture.

Configure and Setup AP Approval Processes using AME, Approval groups, Payable Groups, Vendor Types, Rules, Banks, Payment formats Approval limits, Expense Template, Expense Mileage rules, and Expense Audit setups.

Developed proof-of-concept solution to support event registration and newsletter subscriptions using standard functionality in Marketing, Service Contracts, and Telesales.

Developed customer model for TCA to support complex relationships of member organizations, customers, advisors, and board member parties. Converted legacy customers.

Worked on Billing events, Project costing, Budgeting and Project Management.

Worked on Billing Extensions to Create Event Holds.

Was involved in setups related to Project Class, Project types and Project templates etc.

Involved in setting up project billing module auto-accounting, event type, implementation options, and bill rate schedule.

Implemented Budgeting like creation of project budget and draft budget.

Worked on costing related to capturing cost, distribute cost and cost budget etc

Extensively worked on customizing and creating aging 7 buckets, Inventory On hand quantity, standard cost report.

Configured the functional setups in for General Ledger and Account Receivables.

Involved in deciding the design and structure of the accounts and GL Code Combinations for all the operation units.

Setup Pricelists in Service Contract items..

Used AOL and System Administrator modules for registering Concurrent programs, concurrent requests Request sets, and request groups for reports, Values sets and Descriptive flex fields.

Worked with different shipping APIs for pick release Sales orders and ship confirm deliveries based on ship confirm rules, creating trips, update delivery details.

Involved with study of existing system, preparing the Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables. Used AOL and System Administrator modules for registering the developed and customized reports.

Environment: Oracle Applications R12 PO, AP, INV, OM, Developer suite 10g, PL/SQL, Stored Procedures, UNIX, AOL.

Client: Tempurpedic, Lexington, KY

Project: Oracle Applications

Duration: Oct 2010 – Aug 2011

Designation: Techno-Functional Consultant

Responsibilities:

Worked on P- card implementation.

Worked on writing Interface programs for inserting data from legacy system related to P- Card implementation.

Worked on creating conversions and interfaces for entering invoices from legacy system into Oracle.

Developed Wrapper for Payables Invoice Interface in Payables.

Imported BOM data from Legacy system to Oracle through Open BOM Interface. This process includes loading data from flat file to temporary table using the SQL * Loader, validated the temporary table data and moved to the Interface table.

Validated Setup steps for Shipping like Organization Parameters, Shipping Parameters, Defined Exceptions, Defined Pick Slip Picking Rule, Defined Release Sequence Rules, Define Release Rule Form, Auto Ship Confirm Rule, etc.

Involved actively in business process like procure to pay and order to cash.

Also WMS which mainly includes setups like product, warehouse, warehouse organization, inventory, sub inventory and locators.

Worked on customization of WMS reports like material status change history report, ASN discrepancy report and Space Utilization report.

Successfully designed and implemented the Purchase Orders Open Interface. Activities involved creation of control file, porting PO_HEADERS, PO_LINES into the PO_HEADERS_INTERFACE and PO_LINES_INTERFACE tables and then used Import Standard Purchase orders concurrent program to port the data into the Oracle base tables

Worked on Customer Party Relationship in Receivables using TCA Architecture.

Configuring AP, AR, GL and Cash Management module based on Clients requirement.

Worked on Snag reports like Item position report, Item On hand Quantity reports.

Extensively worked on creating Non-Conforming Material report (NCMR), Corrective Action Required report (CAR), Sales Order Acknowledgment Report, Packing Slip Report and Commercial Invoice Report reports using XML publisher and also worked on customizing various reports.

Customizing and personalizing approvals using Oracle Approval Management (AME).

Used AOL and System Administrator modules for registering Concurrent programs, concurrent requests Request sets, and request groups for reports, Values sets and Descriptive flex fields.

Writing Functional (Md50), Technical (MD70) based on the business requirements.

Worked on the Oracle Inbound Ship Confirm Interface, which perform actions on Deliveries, Updating shipping attributes, updating the Freight costs by calling an API.

Execute testing phases with users and play key role in Go/ No Go decisions

Environment: Oracle Applications 11.5.10.2 PO, AP, INV, OM Developer suite 10g, PL/SQL, Stored Procedures, UNIX, AOL.

Client: Clavib Inc. Hyderabad, India

Project: Oracle Applications

Duration: Aug 2008 – May 2010

Designation: Oracle Developer

Description:

Clavib is top ranking Offshore Outsourcing Company for software solutions with software development center in India. We provides cost-effective quality technology solutions. We create value for our clients by providing a comprehensive set of services and solutions. We mostly focus on building reliable business systems and enterprise solutions that are architected for the competitive future.

Responsibilities:

Used Application Implementation Methodology (AIM) for documenting the technical and functional specifications in MD 70 and MD 50.

In Fixed Assets (FA) module, loaded the data from a Flat File to the FA_TAX_INTERFACE table using SQL*Loader to update financial information into tax books. Uploaded the data into the tables Tax Book Upload interface program in applications.

Worked on GL budgets interface to load the budgets data into the base tables using the budgets upload program.

Worked on OM Interface programs to resolve interface issues between OM and a third party shipping support system.

Involved in Conversion of AP Invoices, using SQL*Loader to load legacy open Invoices data in to the staging tables and PL/SQL Program to validate and load in to Payables Standard Tables. Developed Generic Packages using PL/SQL to build flat files to manage transmissions across Legacy and Oracle Systems.

Worked on the Lead Import Interfaces in Oracle Sales. Involved in creating and updating the Quotes Using API’s.

Involved in Development of import and Validation Program of Journal Import & Budget Upload Interfaces (GL).

Developed Invoices & Payments for the suppliers. Checking the holds & PO Matching.

Worked with Period end closing reports like Invoice Validation process & Transfer the Invoices to GL.

Involved in the setup of Customers, Invoices, Receipts, Dunning letters, etc.

Developed the Script for Receipts Conversion using API s and successfully executed for various subsidiaries.

Developed Internal Requisition Status Report to print the status information for internal requisitions.

Environment: oracle applications 11.5.10.2, AP, GL, AR UNIX OS, Oracle SQL, PL/SQL, SQL*Loader, TOAD Java, JavaScript.

EDUCATION

Bachelors in Computer Science & engineering.

Masters in Computer Science & engineering

Contact this candidate