Summary:

• Over 8 years of experience in Oracle ERP and related products
• Extensive experience in design, development, implementation, customization and production support of ERP systems for manufacturing organizations
• Possess strong knowledge of the Oracle systems techno functionally, specifically, the modules covering order to cash cycle
• Proficient in customization/development of Reports and Forms, PL/SQL, Discoverer and Workflow

Education:

• Masters in Computer Management (MCM), University,Confidential
• Bachelor of Science, University, Confidential

Skills:

• Oracle Applications Release 12/11i/11
• Modules: Order Management, Inventory, Purchasing, Bill of Materials (BOM), Work in Process (WIP), Advance Pricing, Flow Manufacturing, AP, AR, Planning, Quality, Trade Management and CRM
• Oracle Workflow 2.6.3.5, Forms 10x/9i/6i/4.5, Reports 10x/9i/6i/2.5
• PL/SQL, SQL*Plus, SQL*Loader, Discoverer 4.1, XML Publisher, TOAD, SQL Developer
• Oracle Alert, AOL, System Administration, AIM, Forms Personalization
• Operating System Unix, Linux, SunOS, Windows 3.1/95/NT 4.0/2000
• Databases - Oracle 10g/9.x/8.x
• Kintana (PPM), Clearcase (Version control and code migration tools)

Major Assignments
August 2008- Present
Company: Confidential
Title: Sr. ERP Analyst

Masco Cabinetry manufactures, distributes, and installs home improvement and building products in North America and Europe. As a techno functional analyst I am involved in implementation and support of Oracle Applications 12, worked on Order management and manufacturing modules.

Key Accomplishments:

• Analyzed and developed WIP Reset program that adjusts WIP sub-inventory whenever there is any discrepancy between demand and WIP inventory in plants.
• Developed form that displayed drawer demand information at the drawer sub-assembly while the cabinet is being built on the main assembly. This allowed drawer sub-assembly team to build drawer box with drawer front and false front just in time for final assembly at the end of the line.
• Involved in setup of Order Management module. Examples are setup of sales order processing constraints, defaulting rules, picking rules, transaction types, shipping network etc.
• Worked with business users on requirements gathering and designing functional specifications for customizations, interfaces and reports.
• Customized Order Management Workflowsto incorporate business rules specific to Masco.
• Designed and developed PO legacy receiving interface.
• Designed and developed xml publisher reports for several plant labels like door front pick label, plywood end panel pick label, frame build label etc.
• Designed and developed cabinet label document which is sent to the customers along with the cabinet.
• Developed ship-to-address update form and used forms personalizationon the seeded sales order form to reflect the updates.
• Worked on reports such as load sheet report, packing list report and discoverer reports like in-transit report, production shortage report.
• Designed and developed mass update programs to load customer freight terms, payment terms, sales reps, collectors and credit analysts information into Accounts Receivables.
• Provided training to associates and end users.
• Worked with oracle support on several SRs for resolving issues.
• Created month end inventory closing routines that allowed timely closure of finance books at the end of each month.
• Developed APIs to be used by custom screens in MSCA.
• Performed root cause analysis on credit memo creation issue users faced in AR. Based on the findings made changes to AME (Approvals Management) setup which helped resolve the issues with the credit memo approval process. Did similar analysis for the claims processing issue in trade management module and performed needed setups in the module to rectify the issue.

October 2005- May 2008
Company: Confidential
Title: Sr. ERP Analyst

LECO manufactures analytical instruments that are used in research laboratories, government organizations and public companies. Involved in implementation of Oracle Applications 11i mainly focused on Order Management, Manufacturing, Purchasing, Planning and Quality modules.

Key Accomplishments:

• Customized Order Management Workflows and designed and developed new workflows.
• Led a group of developers for design, development of xml publisher templates and integration with Oracle 11i reports.
• Designed and Developed PO Inbound interface to exchange information with legacy system. Used external table feature of Oracle 9i database.
• Developed new reports and customized seeded reports.
• Designed and developed Discoverer reports and PDF reports.
• Designed and developed custom forms using AOL (Oracle Application Object Library) standards and integrated with Oracle 11i.
• Helped in customization and integration of HighJump software that allows real-time data collection into ERP system using hand held devices. Worked on APIs.
• Worked on sending e-mail to concerned group of people through shell script when sales orders are cancelled and when workflows are stuck in error.
• Designed and developed PO Shipper used in handling vendor returns.
• Coordinated with the DBAs to apply the necessary patches, mini packs, and worked in collaboration with Oracle Corporation in resolving several issues through TAR.
• Worked with business users on requirement gathering and designing functional specifications. Also trained the users, junior developers regarding the functionality and the Oracle technology
• Involved in CRM functionality assessment (Field Service, Teleservice, Depot Repair and Install base).
• Was also involved in Oracle Applications upgrade to 11.5.10 version.

June 2005 - Sept 2005
Client: Confidential
Title: Independent Consultant

Bradford White manufactures water heaters and hot water storage tanks. Involved in Oracle ERP upgrade from 11.0.3 to 11i version. Worked on Order Management and Receivables modules.

Key Accomplishments:

• Oracle Workflow Training to client team.
• Customized Order Header and Line Workflows to incorporate the functionality of custom order cycles.
• Developed order, shipping and receivables related reports.

Aug 2004 - Apr 2005
Client: Confidential
Title: Application Consultant

Eaton is a large diversified manufacturing company. Involved in customization and implementation of Order Management, Inventory, Purchasing and WMS modules.

Key Accomplishments:

• Customized Cost of Goods Sold Account and PO Account Generator Workflows and other Order Management Workflows.
• Designed and developed shipping reports.
• Designed and developed integration packages between oracle mobile field applications, WMS (Warehouse Management System), Order Management and Inventory.
• Data Conversion of standard PO’s into Oracle Purchasing using Purchasing Document Open Interface.
• Prepared technical design, migration documents and unit test plans.

June 2001 - April 2004
Company: Confidential

As an Application Developer involved in customization and implementation Oracle Applications 11i, worked on customizations, interfaces and reports. Also worked on design and development of client server system using Oracle development tools and database.

August 1999 - June 2001
Company: Confidential
Title: Software Engineer

Was involved in the design and development of Hospital Integration System using Oracle development tools and database.

Additional

• Oracle Certified Professional SQL, PL/SQL
• US Permanent resident