OBJECTIVE:

• Looking for a challenging position in the ERP Industry where I can make a contribution by utilizing and refining my current skills, as well as to learn new skills to upgrade my knowledge while working as Oracle Applications eAM, Manufacturing and Supply Chain professional.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Applications Consultant

Responsibilities:

• One of the largest producers of fertilizer in State of Gujarat wanted to implement oracle EBS for their manufacturing plant mainly Oracle EBS R12.1.1 EAM, Inventory, BOM and WIP for the maintenance of the facility and other maintainable assets.
• I was part of the implementation team who performed initial requirement analysis, gap analysis and prepared documents. Also performed information collection on client’s current business processes and prepared AS IS Process documents. Using Clients requirement prepared TO BE documents for the business processes. Prepare process mapping documents for functional requirements.
• Performed basic setup for EAM, Inventory, BOM and WIP modules for CRP and performed knowledge transfer to other consultants on this project. Maintain KT documentation & deliver them to every team member.

Confidential, Naperville - IL

Oracle Applications Consultant (eAM and Supply Chain)

Responsibilities:

• I Was a team member in the core USPS Implementation team for the SEAM (Solution for Enterprise Asset Management) project. SEAM consists of Oracle Applications 12.1.1 (Retail and Service Management Verticals), Oracle Demantra 7.3, OBIEE and Oracle Content Database Management Suite.
• I was responsible as Functional Consultant in SEAM for Service Management (Oracle Enterprise Asset Management (eAM), Inventory, Purchasing, Content DB, Bills of Materials (BOM), Work in Process (WIP).
• I was involved in preparing the BR30 for functional requirements and work closely with Oracle Consulting to formalize the BR100s. I was involved in the setup of eAM, Purchasing and Inventory modules.
• I was responsible as functional consultant in SEAM project to setup to setup purchasing options, receiving options, requisitions templates, documents types, center-Led procurement, supplier item catalog, automatic sourcing and sourcing rules, supplier and buyer.
• Setup asset BOM and activity BOM for various scheduled and non scheduled activities which explodes on the work order for faster work order execution.
• Setup Work order forecasting and activity BOM to forecast material requirement based on min max setup for the item.
• Setup sub-inventories, catalog category, cost, min-max, locator control, transaction defaults, shipping network, consigned vendors, consigned inventory management in inventory modules to fit client’s requirements.
• Prepared majority of MD50s for RICEW for Service Management vertical.
• Working exclusively to map reports, data conversion and business process from legacy system to Oracle Applications.
• Work in tandem with Inventory and Purchasing teams for eAM integration.
• Setup eAM Application to manage over 300,000 mobile assets, schedule and unscheduled maintenance plans, material, labor and overhead cost.
• Setup inventory module to manage 317 inventory orgs (Vehicle Maintenance Facilities) to fit client’s requirements for manageability and reporting purpose. Involved in overall Inventory Organization design structure to fit in VMF needs in a total of 40000 inventory organizations.
• Setup resources, departments, KPIs, operations, activities, failure analysis and asset tracking, asset transfer, rebuild able maintenance and overhead.
• I was actively involved in preparing test scripts and conducting CRP and UAT.
• I was part of the team who worked very closely with SMEs on finalizing modifications/personalization on Self Service applications and defining the roles and responsibilities for the Maintenance Organization.

Oracle Applications Consultant (eAM and Manufacturing)

Confidential, San Diego, CA

Responsibilities:

• I was part of the upgrade team for Oracle Applications which included Financials and Manufacturing modules.
• Performed Requirement Analysis, Mapping existing process with Oracle Distribution modules
• Analyzing gaps between the existing process and the Oracle applications’ modules.
• Setting up the Inventory, Purchase, WIP, BOM and Engineering.
• To prepare Road-map for KT (Knowledge transfer) to entire ITR Support team.
• Prepare KT Methodology after going through BP80 (Business process), BR100 (setups), MD50 (Functional Document), MD70 (Technical document), TE40 (test cases) documents (AIM methodology)
• Worked closely with Business team & understood the requirements in details.
• Worked closely with Technical implementation teams and guide them in Oracle CEMLI (Customizations, Extensions, Modification, and Localization & Integrations) & RICE (Reports, Interfaces, Customizations & Extensions) Components of the Project.
• Prepared Shadow process among teams & organized Internal KT sessions (recorded all sessions so they are available for Internal KT ).
• Maintain KT documentation & deliver them to every team member.
• I also worked exclusively on Oracle eAM set up before the upgrade and was responsible from start up to go live of this module. I was responsible for conducting and managing the CRP, UAT and post go live support with my team and peers.

Environment: Oracle Applications 11.5.10.2 (FIN, OM, AP, AR, PO, GL, INV, BOM, FA, WIP, WMS, SCM), J2EE, Unix, SOA, BPEL, ESB, Networking, LAN, WAN, VAN, XML, XSLT, PL/SQL, Shell Scripting, Ant Scripting

Confidential, Phoenix, AZ

Responsibilities:

• I was part of a global upgrade team which involved deploying the upgrade solution to 20 countries. This project included setup of modules like WIP and BOM and initiates the process of deploying Order to Cash cycle in the long term.
• Worked on Modules Inventory, BOM, WIP, Cost Management, Supply Chain Planning, Capacity Planning and Purchasing.
• Gathered Current Business Baseline, Business Volume, Business Requirements. Prepared Current Business Process flows (As Is) based on present business process. Visio Professional for process flows.
• Analyzed High Level Gaps, Business Requirements Mapping, Integration Fit Analysis, Business Mapping Test Results.
• Setup and Configured Oracle manufacturing 11i (11.5.9) Inventory, WIP, BOM, Supply Chain Planning, Capacity Planning and Cost modules.
• Defined Bill of Materials, Routings & Operations that model the manufacturing process.
• Implemented mix of Discrete and Repetitive Manufacturing based on manufacturing processes.
• Implemented Min-Max Planning Process for Bulk Supply type Items for Replenishment.
• Implemented Engineering Change Order and Mass Change Process for change in Bills / Routings.
• Implemented CRP (Capacity Requirement Planning) for resource requirement, availability and planning.
• Performed Unit Test, System Test, Integration Level Testing and User Acceptance Test with multiple Business Scenarios.
• Worked with technical team on Customization of Reports, Interfaces with WHICS and DEMAND SOLUTION (third party software).
• Conducted End-user of the implemented modules, which encompasses Navigation, Functionality and Business Processes.
• Providing ongoing and Post Production support to client departmental personnel throughout the engagement.

Confidential, Chicago - IL

Oracle Applications Consultant

Responsibilities:

• As part of functional implementation team I had responsibility as team member to implement Inventory, BOM and eAM modules. I was instrumental in conducting CRPs, UATs and user . I performed fit-gap analysis and prepared documents as per Oracle Applications Implementation methodology. (AIM Documents).
• Worked on setting up eAM Assets, Maintenance Plans, Maintenance Activities, BOM Items and other required setup items.
• Client had about 1500 eAM Assets.

Confidential, Fairfield - NJ

Sr. SQL Server DBA / Oracle Applications, And

Responsibilities:

• Installation of SQL Server 2000 on Windows 2000. Managed network connectivity between clients and servers. Created databases, tables. Performed Data imports, validation, modification and export from various data sources and data destinations.
• Supported ERP (Power Cerv) from the database side. Installed clients giving them rights for views, insert, updates and also delete. Also keeping the log of their activities. Created databases, tables and populated them using different data source. Designed reports based on various needs using GUI Report Writer. Also hands-on working with Crystal Reports.
• Installation, configuration and management of EDI Application Integrator, which also makes fully, automated systems which takes EDI documents (invoice order), process them and stores in the database as a new order (Processing Inbound Documents). Also managing the EDI Outbound data, this processes them and sends it to proper mailboxes to the respected companies.
• Trained on Oracle Manufacturing modules which included Inventory, WIP, BOM, eAM our organization decided to implement Oracle Applications.
• Became part of the Oracle Implementation group and was involved in implementation of Oracle Inventory and Oracle eAM.

Confidential, Phoenix - AZ

SQL Server DBA / Network Administrator

Responsibilities:

• Planned, designed and developed SQL Server 6.5 over Windows NT 4.0 server. Also created and maintained client-server connectivity by installing SQL Server 6.5 client utility over 16-bit MS DOS and Windows and 32-bit Windows operating system.
• Configured Windows NT scheduling, threading and performance services for SQL Server. Also configured SQL Server performance monitor within Windows NT performance monitor for I/O subsystem bottleneck, processor performance, disk media performance.
• Configured SQL Server for various server, security and configuration options. Also configured the advanced server configuration parameters to maximize the server performance for client-server network.