SUMMARY:

• Around 18 years of experience in the industry that includes 13 years in the Information Technology field in Oracle Applications 11.0.3/ 11i/ R12 with multiple end - to-end successfull life cycle implementations in both Oracle Discrete-Process Manufacturing (OPM)/Distribution area and over 5 years of domain experience in the areas of Manufacturing, Supply Chain Management, Process Redesign and Project management.
• Expertise in business process integrations with different modules of both the Oracle Discrete/Process Manufacturing and Distribution suite viz, Inventory, Order Management, Shipping, advanced pricing, WMS, Release Management, Purchasing, iSupplier Portal, Bills of Material, Engineering, Work in Process, Costing, OPM Suite (Oracle Process Manufacturing).
• Well versed in Release 12 mapping ineventory Organisation strcuture as compared to 11i OPM. Good competency in OPM modules like Inventory, OPM Product Development, OPM Process Execution, OPM Quality, OPM Planning, OPM Costing & MAC(Manufacturing Accounting Controller)/SLA (Sub Ledger Accounting).
• Understanding of all phases of ERP implementation such as business process study, business requirement gathering,gap analysis with respect to the To-Be solution design, development and testing, transition, cut over, Go-Live, post production support and post implementation audit.
• Experience working with the Onsite/ Offshore delivery model, client relationship management, and project management.

SKILLS:

OPERATING SYSTEMS: Windows 95/ 98/ 2000/ NT

ERPs: Oracle Applications 11.5.10.2/ R12

Oracle Process Manufacturing Suite: (OPM PD, OPM PE, OPM Process Planning, OPM Quality, MAC/SLA, OPM Costing)

Oracle Discrete Manufacturing Suite: (INV, OM, PUR, Advanced Pricing, Shipping, RLM, iSupplier Portal, iProcurement, WIP, BOM, MRP, Costing, ASCP)

LANGUAGE/ TECH: PL/SQL

DATABASES: Oracle 9i/10g/11g

TOOLS: TOAD, SQL Developer,HPQC, Share Point

EXPERIENCE:

Confidential, Pittsburgh, PA

Responsibilities:

• Trouble shoot technical issues and problems, monitor progress against plan, and communicate status to the PMO.
• Gathering customer requirements, issues, writing and interpreting functional design documents for Oracle add-ons and extensions and working with technical developers, DBAs, and Oracle Support to meet these requirements and resolve issues.
• Established/Updated new standard cost for the Product items by defining its formula, Routing, Recipe and generated the item cost by standard cost roll up process.
• Responsible for the OPM Costing and SLA modules set up and transaction testing analysis for batch accounting.
• Part of the Accenture R12 Project team responsible for helping the client in solution designing the future road map for the implementation in the Tubular business.
• Provide support in the month end period closing by resolving errors in the Lot cost process and accounting preprocessor.
• Designed a customization to generate the correct accounting entry in SLA using the custom source capability.

Confidential, Branchburg, NJ

Responsibilities:

• Managing and Closing IT portion of Manufacturing NCRs, Deviations and CAPAs.
• Data Conversion Strategy for Manufacturing, MES and Quality track which includes Formula, Routings, Operations, Activities, Quality Tests, Quality Specifications, MES- Process Instructions.
• Implemented OPM MES (Manufacturing Execution System) and lead the transformational process of making a business case to Leadership team for moving to standard R12 Oracle Process Manufacturing and OPM MES system and use the EBR (Electronic Batch Record) instead of the paper Batch record.
• Carrying out Business Process Mapping (BR030) and Solution Design (BR010) for Process Execution (Formula, Recipe, Routings, and Operations), Inventory Management, Quality Management and OPM Costing.
• Preparing Set-up documents (BR100) and Setting up OPM modules which included Inventory, Product Development, Process Execution, OPM Quality and Esig and ERecord (ERES), AME (Approval Manegment Engine) configurations for OPM and MES events.
• Configured the quality module for the inbound logistics (PO Inspection) and work in process production sampling process.
• Used the lot genealogy functionality to have a complete tractability of the item lot from receiving till shipping in the value chain
• Defined test specifications, test methods, sampling plans, quality system parameters, enabled quality wok flows, detailed sample tracking, analysis and generate certificate of analysis and certificate of compliance.

Confidential, Orrville, OH

Responsibilities:

• Part of the OPM upgrade team from 11i to R12 responsible for remapping the existing customizations, redesigning the affected business processes to utilise the new R12 features, data validation and MAC to SLA migration.
• Worked extensively on sub ledger accounting setups and configured new ADR (Account Derivation Rule), JLD (journal line definitions) and AAD (Application Accounting Definition) to seeded event \classes.
• Developed Period Close procedure documents for Process manufacturing.

Confidential

Responsibilities:

• Being Part of the manufactured team implemented Oracle suite 12.1.2 (Rel 12) for multiple locations for the Confidential service centre in the southwest region.
• Stream lined the lot cost process errors, variance analysis and implemented the NCM process as a part of quality for material rejection and claim processing .
• Mostly responsible for the OPM Costing and SLA modules set up and transaction analysis.
• Provided post golive onsite production support, helpdesk ticket resolution and month end period closing support for the business users.

Confidential, Saukville, WI

Responsibilities:

• Part of the 12.0.6 to 12.1.3 upgradation team for testing the business cycles and implementing the new functionalities.
• Implemented the OPM sequence dependent set ups, batchable resource functionality for ASCP,
• Established new standard cost for the ingredient items and generated the finished goods item cost by standard cost roll up for year 2011.
• Used the lot genealogy functionality to have a complete tractability of the item parent lot from receiving till shipping in the value chain
• Defined test specifications, test methods, sampling plans, quality system parameters, sample tracking, analysis and generate certificate of analysis. redesigning the recipes/operations at the resource instance level for better capacity utilization and scheduling,
• Written the functional specification document for the OPM-MES integration.

Confidential, Grafton, WI

Functional Consultant

Responsibilities:

• Handled item conversion which was more complex due to decaded old data in the Manman legacy system and so many business rules for data extraction.Component pick list report and custom pegging solution designing for parent and sub assembly Jobs.
• Defined BOM and WIP parameters and WIP account classes.
• Conducted user traing and CRP session for the BOM and WIP modules.
• Functioning as a Senior Consultant
• Functional lead for the distribution track, worked on the complete solution design, system integration for the Repair and Managed Service Business.
• Have completely automated the process of service request creation to service request closure spanning transactions like Service Request to Repair Order, Part requirement Fulfillment by IR/ISO creation with back to back order creation.

Environment: Oracle Applications, Oracle CRM: Release 11.5.10.2 (OM, INV, PO)

Confidential, Twinsburg, OH

Senior SCM Consultant

Responsibilities:

• Functional Lead for the Order-to-Cash track.
• Worked on the project that included the implementation of Siebel as the front-end order taking system, Oracle eBusiness Suite in the back-end to process the orders/ invoice, and PKMS (Manhattan Associates) as the Warehouse Management system for handling the inventory and shipping transactions; the biggest challenge was to tightly integrate all the three systems and establish a seamless flow of data within these three systems.
• Configuration of Order Management (BR100) and Shipping by setting up Transaction type, workflow setup, processing constraints, Holds, setting up pick release rule, grouping rule, release sequence rule, document categories, document sequences, document set, defaulting rules based on the customers, ATP Rule, setup price list, pricing formula, modifier and qualifiers, shipping parameters, ship confirm rules, custom packing slip, bill of lading report, custom commercial invoice report, setting up different printers for different document printing.
• Worked on the complete solution design, system integration of Siebel, Oracle Applications, and PKMS (Manhattan Associates) with SOA as the middleware.
• Created the KIT items using the Oracle PTO item and PTO BOM feature.

Environment: Oracle Applications 12R (OTC), PKMS, Siebel

Confidential, EL Paso, TX

Responsibilities:

• Worked on the solution design for the schedule to build process and the Out Side Processing (OSP) operation using isupplier portal.
• Defined the WIP Parameter and accounting classes.
• Demonstrated the entire OSP operations using the isupplier portal, the WIP job creation, move transaction, scrap and job closure process.
• Defined BOM, Routing, and Resources for item cost roll up and lead time roll up.
• Supplier Self Registration (Profile and Address), Purchase Order Collaboration.
• Manage Order Changes, Streamline Payment with Online Invoicing, using iSuplier Portal.
• Access to Data across buyer-managed organization, ASN/ASBN to create shipment notification and invoices.

Modules Implemented: Oracle Applications: 11.5.10.2 (WIP, BOM, iSupplier)

Confidential

Onsite/ Offshore Project Manager

Responsibilities:

• Managed a cross functional team of five members that encompassed Functional and Technical Resources for the Client Implementation project
• Prepared the project plan and high-level process maps integrating multiple business processes and systems for the toll gate reviews to effectively communicate the project status upward to the client, stakeholders, and management team
• Configured the quality module for the inbound logistics (PO Inspection) and work in process production sampling process.
• Used the lot genealogy functionality to have a complete tractability of the item lot from receiving till shipping in the value chain
• Defined test specifications, test methods, sampling plans, quality system parameters, enabled quality wok flows, detailed sample tracking, analysis and generate certificate of analysis and certificate of compliance.
• Conducted the stability study plan for the various raw materials of different potency in different environmental condition.

Environment: Oracle Applications 11.5.9 (OPM, Costing, MFG, OTC)

Confidential, Charleston, SC

Onsite Order-to-Cash Functional Lead

Responsibilities:

• Worked on the project that included the implementation of the Oracle eBusiness Suite, Manufacturing, and Financial modules at Cummins, one of the major plants for high horsepower diesel engines and supported Oracle Applications for Confidential Business Unit
• Set up Order Management, Shipping, and Release Management modules that included defining transaction types, system parameters, processing constraint, defaulting rule, shipping parameters, and release rules
• Defined RLM processing rules, crated/ assign CUM Keys, resolved RLM exception messages, and defined trading partner.
• Set up supplier scheduling Bucket patterns, Scheduling Options and Supplier CUM management
• Supported the integration between apps and Clear Orbit WMS
• Customized the cost of goods sold account generator to generate the correct cogs account.
• Conducted the requirement analysis and business process mapping study of the critical business processes to identify the gaps and conceptualized the solution design process for the Order-to-Cash process
• Streamlined the flow of consigned Inventory using the standard Oracle Consignment Inventory Management feature as a part of the process improvement
• Prepared the functional specifications for the customizations, interfaces, and new requirements and helped the Offshore team in the development process.

Environment: Oracle Applications 11.5.10.2 (eBS, Financials, MFG, OTC, RLM, INV)

Confidential

Onsite Production Support

Responsibilities:

• Onsite Support Coordinator
• Provided onsite production support for the faster resolution of application issues and helped the users to use the application smoothly and derive the maximum benefit
• Resolved tickets in the modules such as Order Management, Purchasing, Inventory, BOM, Costing, and Work in Process
• Implemented the Engineering module for managing the engineering change orders for the client
• Reduced the number of issues by almost 50% for the client by following the process of Root Cause Corrective Action (RCCA) so that the same problem was not repeated again and again, thus significantly reducing the number of issues
• Prepared the functional specifications for the new requirements and helped the GDC team in the development process till testing.

Environment: Oracle Applications 11.5.10.2 (Financials, MFG, OM, PO, INV, BOM, Costing, WIP)

Confidential

Onsite Auditor

Responsibilities:

• Evaluated operational efficiency and effectiveness in terms of all relevant and usable features available in the ERP that were being used properly avoiding duplication, repetitive data entry, and non-value adding processes under Oracle Applications environment
• Ensured that the financial, operations, and compliance risks were adequately controlled, particularly for the areas that had direct impact on financial records
• Evaluated effective configuration of Oracle ERP and assessed data integrity, reliability, and consistency
• Ensured that proper access controls and segregation of duties were in place under Oracle Applications environment
• Identified areas where improvements in current practices could be done by benchmarking with good practices
• Worked for the Oracle Center of Excellence under the umbrella of GE Capital International Services (GECIS) that mainly involved in the implementation and support of eBusiness Suite Applications for various GE Businesses