SUMMARY:

• IT Professional with 17 plus years of experience out of which 15 years plus of ERP implementation and 2 years in Application and Product Development using oracle tools.
• Responsible for all aspects of full lifecycle Oracle ERP software implementations including requirements definition, gap analysis, mapping Oracle functionality to current business processes, setup/ configuration of various manufacturing modules, creating test scripts to facilitate module/ unit and end to end/ integration testing,, data conversion, production cutover and post Go Live support.
• Expertise in Implementation, Customization, Upgrade, Data Conversion, Maintenance and Production Support.
• Project Lead experience in managing multiple projects and leading functional teams and Offshore Technical team from planning to Implementation.
• Knowledge of application setups and system configuration in Oracle EBS 10.7, 11.0.3.11.5.6, 9, 10, R12 modules to effectively meet the needs of the business and technical teams.
• Skilled at Application Development in Oracle RDBMS, Developer 2000, Forms 6i, Reports 6i, UNIX, Workflow, Oracle Discoverer, SQL, PL/SQL.
• Excellent communications, both verbally and written.

TECHNICAL SKILLS:

Packages: Oracle Applications R12,11i.5,6,9,10, 11.0.3,10.7

Modules: SCM: PO, INV, OM, SHIPPING, Advanced Pricing, Cost Management. I supplier Portal, ASCP

Manufacturing: BOM, WIP,, Engineering, APC(Formerly PLM)

CRM: CRM Foundation, Install Base, Field Service, TCA, Spares Management

Development/Productivity Tools: Developer 2000, Oracle Reports, PL/SQL, SQL * LOADER, SQL*Plus, Unix Shell scripts, Work Flow, Oracle Alerts

Database: Oracle 7.3,8,8i

Operating System: Windows NT/95 and HPUX 11

Others: Oracle Workflow 2.5, Oracle 9iAS Discoverer

PROFESSIONAL EXPERIENCE:

SCM and Manufacturing Functional Lead

Confidential

Environment: Oracle Applications R12

Responsibilities:

• Build and set up of the MFG./Supply chain modules.
• Work with business stake holders in identifying the legacy data that need to be migrated to oracle and carrying out regression testing and validation of data upon migration from legacy applications on to the targeted oracle apps instance.
• Authored functional and technical specifications for reports, conversions, interfaces and extensions.
• Conducted conference room pilots with business users and walked them through the applications functionality and helped in defining business processes.
• Mapped requirements to Oracle Application features, determined business/technical fit, and documented new and change set ups, system design or detailed business and functional specifications as appropriate to achieve required results.
• Prepared test plans and end user manuals.
• Worked with oracle technical support to resolve service requests
• Performed unit testing, integrated system testing, user acceptance testing and business process testing.

SCM and Manufacturing Functional Lead

Confidential

Environment: Oracle Applications R12

Responsibilities:

• Worked with business users and ensured that all the data and setups are migrated properly.
• Test existing customizations in the R12 instance and resolve issues as and when reported.
• Participated in CRP2 and CRP3 sessions and resolved issues as and when reported.
• Coordinate with Onsite and Offshore teams on technical components .

SCM and Manufacturing Functional Lead

Confidential

Environment: Oracle Applications R12

Responsibilities:

• Working as a production support lead handling Oracle Manufacturing and Supply chain Modules. Handling multiple clients at the same time.
• Trouble shoot production issues and provide resolutions and workaround to various issues reported on Oracle Standard functionality, customizations (RICEW).
• Allocate support tickets to team members and oversee resolutions and timely closure of tickets.
• Involve and Perform Setups and prepare Functional Specification during implementation phase.

SCM and Manufacturing Functional Lead

Confidential

Environment: Oracle Applications R12

Responsibilities:

• Build and set up of the MFG./Supply chain modules.
• Work with business stake holders in identifying the legacy data that need to be migrated to oracle and carrying out regression testing and validation of data upon migration from legacy applications on to the targeted oracle apps instance.
• Authored functional and technical specifications for reports, conversions, interfaces and extensions.
• Conducted conference room pilots with business users and walkedthem through the applications functionality and helped in defining business processes.
• Mapped requirements to Oracle Application features, determined business/technical fit, and documented new and change set ups, system design or detailed business and functional specifications as appropriate to achieve required results.
• Prepared test plans and end user manuals.
• Worked with oracle technical support to resolve service requests
• Performed unit testing, integrated system testing, user acceptance testing and business process testing.
• Coordinate with offshore team on a day to day basis and provide guidance on various RICEW components and ensure unit testing of the delivered components in a timely fashion.

Confidential

SCM and Manufacturing Functional Lead

Environment: Oracle Applications R12

Responsibilities:

• Working as a production support lead handling Oracle Manufacturing and Supply chain Modules. Handling multiple clients at the same time.
• Trouble shoot production issues and provide resolutions and workaround to various issues reported on Oracle Standard functionality, customizations(RICEW).
• Allocate support tickets to team members and oversee resolutions and timely closure of tickets.
• Involve and Perform Setups and prepare Functional Specification during implementation phase.

Functional Lead

Confidential, Grafton WI

Environment: Oracle Applications 11.5.10

Responsibilities:

• Responsible for creating TO BE process flows based on the current AS - IS flows and perform fit-gap analysis
• Perform data analysis of the existing legacy systems for all the three plants and lay out logic for the data that needs to be extracted, which would be brought over into oracle system
• Conducted CRP’s and demonstrated standard functionality to executive team.
• Trouble shoot issues that came during CRP phase and came with solutions/workarounds.

Functional /Support Lead

Confidential, Houston, TX

Environment: Oracle Applications 11i(11.5.10),Oracle 9i,Solaris

Responsibilities:

• Provided support on a day to day basis by interacting with end users. This involved providing support for existing customizations like Reports,interfaces,conversions,extensions,workflows(RICEW)
• Developed ad hoc sql queries which were used as metrics for reporting to management or extract data that needs cleanup.
• Worked directly with Super users and business process owners to gather requirements for new enhancements and prepare functional specifications.
• Identified and Improved some existing process
• Participate in Support calls and update management about the statusOf pending issues on a weekly basis.
• Worked with technical developers to help trouble shoot issues and guide them towards issue resolution.
• Worked with DBA’ in case of any issues relating to performance and coordinate and perform through testing of the applications after a new patch has been applied.
• Worked with oracle technical support to resolve service requests

Functional Lead

Confidential, Houston, TX

Environment: Oracle Applications 11i(11.5.10),Oracle 9i,Solaris

Responsibilities:

• Build and set up of the MFG./Supply chain modules.
• Work with business stake holders in identifying the legacy data that need to be migrated to oracle and carrying out regression testing and validation of data upon migration from legacy applications on to the targeted oracle apps instance.
• Authored functional and technical specifications for reports, conversions, interfaces and extensions.
• Conducted conference room pilots with business users and walkedthem through the applications functionality and helped in defining business processes.
• Mapped requirements to Oracle Application features, determined business/technical fit, and documented new and change set ups, system design or detailed business and functional specifications as appropriate to achieve required results.
• Prepared test plans and end user manuals.
• Worked with oracle technical support to resolve service requests
• Performed unit testing, integrated system testing, user acceptance testing and business process testing.
• Coordinate with offshore team on a day to day basis and provide guidance on various RICEW components and ensure unit testing of the delivered components in a timely fashion.

Functional Lead / Offshore Coordinator

Confidential, Saint Louis

Environment: Oracle Applications 11i,Oracle 8i,Unix

Responsibilities:

• Responsible for creating Process design document for global rollout.
• Prepared Test Scripts for CRP phase.
• Rice component identification and Functional specification for the same.
• Support onsite team during requirement gathering and mapping the requirements for the global model.
• Prepared conversion templates for all the identified legacy data that would be used for global rollouts.
• Trouble shoot issues that came during CRP phase and came with solutions/workarounds.

Techno Functional Lead / Offshore Coordinator

Confidential, Saint Louis

Environment: Oracle Applications 11i,Oracle 8i,Unix

Responsibilities:

• Responsible for assigning technical components to team members and coordinate the development work of technical components.
• Update the management team about the progress of the project.
• Responsible for preparing Technical & Functional Specifications, Test Plans and development of RICEW components.
• Responsible for review of Design documents, unit test plans, code.
• Did enhancement of Copy cost and Specific Item cost rollup programs.
• Designed and Developed Invoice price variance report.
• Designed and developed Accrual Report.
• Designed and developed reports which gives the actual resource usage rates as well as projected usage rate for Resources.
• Designed and developed Physical Inventory interface.
• Involved in Post Implementation Support
• Modified reports and Interfaces to in corporate enhancement requests.

Techno Functional Lead / Onsite Coordinator

Confidential

Responsibilities:

• Diebold has requirement to manage parts recovered from service calls on customer installed products. Recovered parts need to disposition and tracked based on repairable and returnable status. The standard Oracle debrief process currently requires the service technicians to enter used and recovered parts. This customization will create and process the recovered part line .significantly reducing the service technician’s workload. I was responsible for the entire design in terms of gathering requirements, interacting with client to understand their existing process. This customization required changes to be made to standard Debrief form, Create a workflow which will automate the entire process of creating a recovery line, automate receiving, automate write-off, create notifications to territory advisor and address detailed transactions for parts accounting, modify standard debrief update process which creates charges, update install and creates material transactions.
• Designed and developed Sales order conversion process.Diebold had the unique requirement to bring some orders in entered status this involved configuring the existing legacy order to equivalent oracle order, some in closed status if the order had already been shipped to customers but awaiting installation, some orders to be converted in a entered status and reserved against PO/Inventory if the product was already manufactured. Involved in gathering requirements, arrange client meetings, developed and tested the entire conversion process.
• Designed and developed Auto Firming of Purchase orders released from planners work bench.
• Designed and developed code hook for costing transactions.
• Designed and developed extension that would copy Engineering changes from the master org to child inventory org.During the EC transfer, the BOM for an assembly and revision will also be copied from the master org to the child inventory org only for the new items and BOMs .For an existing BOM being revised on the EC, only the changes would be carried forward to the child organizations.
• Colombia law requires that you report the inflationary effects on your inventory in your financial statements. This is handled via localization for Colombia. As part of this conversion gathered requirements/designed/developed conversion programs to load inflation adjustments index historical data into system to create a baseline for calculations.
• Enhanced and redesigned the Material price variance report. The Material price variance report allows measurement of monthly and annual accumulated Global Material price Variance price including the separation of Material purchase price variance and Material exchange rate price variance.
• Designed the legacy Freight and Installation conversion process. Legacy freight and Installation charges were converted over into oracle as Modifiers.
• Designed the Legacy Price list conversion for Diebold North America .Diebold had many legacy price list which were distinguished based on product code. The price list approach was designed in such a way that there would be one master price list for each currency and this master prices list would be attached a secondary price list per product code.
• Designed and developed Order entry backlog discoverer report which would report all the backlog orders on a daily basis.
• Was responsible for understanding the MD-50’s for rice components for SCM track and coordinate the development work with offshore. As part of this activity delivered 10 plus components rice components.
• Provided support during go live. Supported bug fixing activities/ tuning report/packages after go live.
• Was given the additional responsibility to understand/support/get transitioned SCM and manufacturing related customizations like automate creation of IR/ISO based on sourcing rule, SO/PO when a sales order is placed on distribution center. Global source document push to local operating to enable centralized purchasing etc.

Consultant

Confidential, Saint Louis

Environment: Oracle Applications 11i,Oracle 8i,Unix

Responsibilities:

• Responsible for preparing Technical Specifications, Test Plans and developing the Interfaces for Manufacturing/Non-Manufacturing.
• Responsible for review of Design documents, unit test plans, code.
• Designed and developed Customers Conversion Interface for Converting Legacy Customers Into Oracle Receivables Customers.
• Designed and developed Conversion Process To Up Load On Hand Quantities Into Oracle Inventory and into Corresponding Stock Locator If the Item Is Under Lot Control
• Designed and developed Conversion Process for Workorders.
• Designed and developed Sales Order Conversion Process
• Designed and developed Price list, Modifier and Customer Agreements conversion process.
• Designed and developed Item Creation Workflow.
• Modified RMA Workflows in OM.
• Developed and Customized Standard Reports

Consultant

Confidential, ST Louis

Environment: Oracle Applications 11i,Oracle 8i,Unix

Responsibilities:

• Responsible for preparing Technical Specifications, Test Plans and developing the Interfaces for Manufacturing/Non-Manufacturing.
• Responsible for review of Design documents, unit test plans, code.
• Developed GL Balances Conversion Program to bring the legacy GL Account balances
• Developed PO receipt conversion program to bring the outstanding receipts from Legacy system. This program was later modified as interface program to perform receiving on a daily basis. This program was developed to handle oracle supported standard receipts as well as Returns and corrections which were not supported by standard oracle program.
• Designed and developed Open Purchase order conversion program.
• Designed and developed supplier conversion program.

Consultant

Confidential

Environment: Oracle Applications 11i,Forms 6i,Reports and SQL*PLUS

Responsibilities:

• Providing Support to General Ledger Module .As part of this developed report to regularly monitor erroneous transactions resulting from any sub ledger and provided data fixes for the same.
• Developed Interfaces for the GL Module.
• Maintenance of existing Interfaces and Enhanced Various Interfaces .As part of this activity fixed bugs, tuned resource intensive queries.

Consultant

Confidential

Environment: Oracle Applications 11i,,11.0.3,10.7 Forms 6i,Reports and SQL*PLUS,AOL,PL/SQL

Responsibilities:

• OPSFI (Oracle public sector financials) is built on the top of Core Financials Modules like AP, AR, GL.
• Provided support for 16 modules like Bug Fixing, Resolution of TAR, enhancements for 10.7, 11.03.11i.
• Customized Core Forms (AP.AR,GL) to suite to OPSFI functionality
• Developed new Forms, Reports Using Application Object Library Coding Techniques.
• Developed 3 objects for The Oracle Student System which is a new Product.
• Involved In the Patch Creation
• Prepared Test Plans and Testing of The same.
• Involved in the Review and Testing of the Bug fixing activity and Development Activity

Programmer

Confidential

Environment: Oracle 7.3,Developer 2000,SQL*PLUS,PL/SQL

Responsibilities:

• Involved In the system Study of the Existing System
• Designed and Developed forms for Generating all Master Documents and Developed Exceptional Reports.
• Prepared Loader Scripts for Migrating the data from Existing System to Oracle System.
• Involved in the implementation
• Prepared Test Plans and Testing of The same.
• Provided Support and Fixed Bugs after Implementation.
• Had done the System Study of Short Shipment Note project. Designed, developed and tested the complete process

Programmer

Confidential

Environment: Oracle 7.3,Developer 2000,SQL*PLUS,PL/SQL

Responsibilities:

• Designed and Developed forms which captures all the transaction data.
• Developed custom reports for reporting purpose.
• Involved in Bug Fixing activity during go live phase