PROFESSIONAL SUMMARY
More than 8 years of experience in implementing working with various business applications which includes requirements gathering, Design, Development, Customizations, Testing, Integration and Support for Business Applications.

BACKGROUND

• 8+ years experience focused on implementing the Oracle Supply Chain Management SCM, Inventory Management (INV), WIP, BOM, Purchasing (PR/PO), Supply Chain Planner (MRP), Order Management (OM), Oracle Quality, Pricing (QP).
• Good knowledge on Order to Cash and Procure to pay business life cycle.
• Commendable experience in complete project life cycle implementation involving Pre-Implementation Analysis and Planning, Business Requirement Analysis, Gap Analysis and Resolution, Solution Design and Development, Systems Configuration and Data Migration, Production Systems Roll-Out, Multi-Org, System Testing, User Training Programs, Post-Implementation Support, and Documentation with Oracle applications.
• Good communication and accustomed to work in a team environment with tight schedules. Capable of working efficiently under pressure, manage multiple projects, and cross train subordinates in other Functional areas.
• Has broad experience in all phases of design, development and implementation of Oracle supply chain modules focusing on basic components PLAN, SOURCE, MAKE, DELIVER and RETURN. Also have broad experience with Oracle Application’s technical architecture and Oracle tools.
• Proven problem solving skills. Self-starter who works well individually as well as adapting to rapid changes in team environments and priorities.

SKILLS

ERP: Oracle Applications R12, 11.5.x
Oracle Applications: INV, WIP, BOM, PR/PO, SCP, WMS, Mobile Applications, OM, AOL/System Admin
Oracle Tools: Oracle Forms 6i, Toad, SQL Developer, Agile
Operating Systems: Windows, UNIX, Linux
Languages: PL/SQL, Java
Web Technologies: HTML, XML, JSP, JAVA
Reports tools: Oracle Reports 6i, XML Publisher, Oracle BI Discoverer 10g

PROFESSIONAL EXPERIENCE

June 2009 – till date Confidential, Hayward, CA
Oracle Apps EBS Analyst
Synopsis: EPOD Solar is a developer and manufacturer of cost-effective PV solar panels, based on own proprietary thin-film amorphous silicon technology.

Overall responsible for Oracle R12 Application SCM Modules performing setups, configurations, MRP Planning, Training, Documentation, Fix Issues at Purchasing, Shipping & Receiving and Opening new Work orders as well as Oracle Applications database architecture with regard to manufacturing module schemas/products, standard (API\'s) application program interfaces, data elements, tables, and views as basis for troubleshooting, data conversion and reporting.

• Performed setups/configuration for new Inventory Organization including Org Parameters, Intercompany Relations, Locations, Calendar, Sub-inventories, BOM, Items, Revisions, Categories, Purchasing and Receiving options etc.
• Setups/configurations to enable MRP including profile options, Concurrent Managers setup, launch Planning Manager, creating ad purging MRP Plans. ‘
• Demonstrated the usage of MRP planning which calculates net requirements from gross requirements by evaluating master schedule, bills of material, schedule receipts, on-hand inventory balances, lead times and order modifiers.
• Trained users and provided proper documents for Requisition import and Planning for Supply Demand for Requisitions using MRP.
• Configured/ demonstrated OSP process for tempering of glass with outside vendor to incur the cost in WIP summary and reduce the manufacturing cost.
• Setups/configurations in Oracle to contact Agile to import Items, Revisions, BOM’s and Item life cycle management.
• Performed OM and Pricing Setups and Configured Internal Sales Order process between two operating Units to ship Panels from US to CAN acquiring Transfer Price.
• Configured/demonstrated Internal Order Process, trained users to verify the Order, Pick Release, Transact Move Orders and auto generated Intercompany AP and AR Invoices.
• Created custom menus and responsibilities to meet client requirements.
• Troubleshooting SCM issues some as UOM Conversion issues, Inventory and Purchasing Period close issues, Enable Locator Control, Item Serial Number issues, Intercompany Transactions etc,
• Trained users for Update Standard Cost and Standard Cost Rollup functionalities in Cost Management so as to have Frozen Valid Standard Cost for Items
• Customized end user training reflecting specific business processes followed by the customer for BOM, WIP, and Engineering.
• Enabled Lot/ Serial numbers in Oracle INV Orgs corresponding to physical locations and thus trained shipping and receiving staff.
• Scheduled various meeting with different groups like Purchasing, Costing and thus collected weekly status and progress.
• Trained users in using Discoverer plus to access and create reports.
• Configured Oracle Mobile Applications and enabled WMS and LPN’s. License Plate numbers are used to get hold of Module and Panel Serial numbers throughout the Manufacturing line until shipping. Configured Mobile devices to Receive, Store, pick materials, view on hand balances, print labels etc which includes WIP, Inventory and OM.

Environment: Oracle Applications Release R12 (INV, BOM, WIP, WMS, PO, MRP, OM, AR, GL – Workflow builder, Alert Manager, and Sys Admin), Oracle 10g (SQL, PL/SQL), TOAD.

03/2007 – 5/2009 Confidential, Hayward, CA
Oracle Apps SCM Analyst
As a business analyst my role was to analyze current manufacturing process and operations and from various channels and perform gap analysis. Wrote functional specifications for material planning to integrate with Purchasing and Cost management and feel with current interfaces, minimizing the number of steps the business users have to take.
Responsibilities:

• Conducted GAP analysis to identify current work order process and interactions with stake holders to introduce proper methodologies like discrete manufacturing and reduce over burden.
• Analyzed functional specifications and data from various data sources like SQL server and Agile and flat files
• Conducted conference calls with business stake holders of different departments to gather information
• Authored functional specifications and communicated them to development and testing teams.
• Designed and developed oracle workflows for expected delivery schedule of the material, which would send notification to responsible person to take prompt action to have a control on back order in Order management.
• Developing test plans, conducting testing, design and development of external interfaces, working with department managers on transition plans for re-engineered business processes.
• Automation of order process by creating and registering concurrent program using PL/SQL
• Executing and scheduling the standard and custom concurrent program so that reports are generated and submitted to corresponding support team.
• Translated existing Oracle Application Reports into XML and PDF format as per the client requirement. The following seeded reports were translated in this process- Pick Slip, Packing Slip, and Mailing Label for Shipping and Orders by Item, Order Detail & Summary Reports for Order Management.
• Created functional Specification documents using AIM methodology. Scheduled status showing the Oracle Work in Process (WIP) to recognize the demand for an item or configuration and opened a work order to supply the demand. Once the work order gets completed and the finished product is received in INV, WIP transfers a reservation to sales order and status gets changed to reserve.
• Suggested customizations to Purchasing Workflows to be Auto Approved for PO’s generated from Requisitions.
• Created various responsibilities to separate users accessing Inventory according to their role and organization they belong to and trained the users respectively.
• Suggesting & Making Client understand to go for statistical forecasting
• Suggesting user to go for manual forecasting for consumables
• Creation of Planning Category for the planned items to streamline view in ASCP Workbench.
• Developing Planning Item for each Main Item for ASCP
• Running data collection (Complete Refresh and Net change) and plan
• Auto release of planned orders into purchase requisition
• Creation of Accessory Attachment Process for Creation of Planning BOM

Expertise: Purchasing, Oracle Sourcing, I-Procurement, Inventory, BOM, Advanced Pricing, Order Management and Shipping. Working Knowledge: SCM, ASCP, AP,OM
Environment: Oracle APPS R12, SQL, PL/SQL, XML Publisher

02/2006 – 2/2007 Confidential, Palmyra, NY.
Oracle Functional Analyst
Garlock Sealing Technologies has ten global manufacturing facilities which collectively produce the world’s broadest range of fluid sealing products.

My Role and Responsibilities:
Working with Oracle Install Base to track all the tangible items (manufactured, shipped and purchased), in-tangible items (services, licenses and agreements) and support for inventory transactions.

Overall responsible for Oracle 11i Application modules such as configuration, ASCP, and inventory as well as Oracle Applications database architecture with regard to manufacturing module schemas/products, standard (API\'s) application program interfaces, data elements, tables, and views as basis for troubleshooting, data conversion and reporting.

• Used Item instance query window to view the configured item instances including attributes and components that support oracle OM.
• Used Install Base component install (WIP) windows to allocate free-standing or non-allocated components (the issued quantity doesn’t match the job requirement quantity) to specific assembly configurations following WIP assembly completion.
• Created WIP jobs with valid messages so that the order management prevents the order changes to the configured items. If the order ship date is changed, appropriate message from WIP job notifies the WIP manager to process the order.
• Blanket sales agreement is defined between the customer and the supplier with date range, items included, quantity and price list. Further, it is released against blanket sales to determine current picture of demand.
• Scheduled status showing the Oracle Work in Process (WIP) to recognize the demand for an item or configuration and opened a work order to supply the demand. Once the work order gets completed and the finished product is received in INV, WIP transfers a reservation to sales order and status gets changed to reserve.
• Develop functional design specs for Item conversion, and bi-directional item interface between Oracle 11.5.9 and Oracle Product data hub.
• Strong knowledge of items as they are used in v11i and 12i, including item creation, item updates, item life cycle management.
• Created custom menus and responsibilities to meet client requirements.
• Developed and delivered customized end user training reflecting specific business processes followed by the customer for BOM, WIP, and Engineering.
• Made recommendations for process improvements that would provide for a more efficient RMA workflow using workflow builder. Client approved workflow changes, as recommended.
• Created test plan for the setup of Service, designed and authored training materials, and delivered the training.
• Worked with oracle Discoverer desktop to analyze the data, finding data that meets business requirements, comparing results from scenarios and developed reports for the analytical results and findings. Shared data with other applications like excel.

Environment: Oracle Applications Release 11i (INV, BOM, PO, WIP, IB, OM, AOL, GL – Workflow builder, Alert Manager, and Sys Admin), Oracle 9i (SQL, PL/SQL), Forms 6i, Reports 6i, TOAD.

08/2004 – 10/2005 Confidential, India
Oracle Apps resource at Shell Chemicals
Synopsis: At Shell, the current system is migrated to upgrade version of oracle applications. Find the current orders, pending orders, status of the orders and setups for order process.

My Roles and Responsibilities:
Overall responsible for project and automate the complete order to cash life cycle. I was involved in most of the setups of OM, BOM and INV like transaction types, Item Configuration (KIT-ATO, PTO) and UOM specifications.

• Importing the existing orders into oracle application using SQL Loader. Columns are identified properly before insertion. SQL Scripts are written and executed to validate the data and insert into interface tables. Worked extensively with PL/SQL cursors, functions and procedures using Toad.
• Worked with Interface Sales order which deals with RA, OE, QP, WSH and MTL tables.
• Worked with workflow builder to include certain process and attach workflow to the transaction type used to process the sales order.
• Created user holds for the item quantity not available and customer credit checks. Released the holds on proper updating.
• Setup different transaction types with standard and RMA and attach proper workflow.
• Create and Modify items required for process by identifying them as finished goods, purchased good or KIT Item type and specify the quantity required in the Inventory.
• Defining the Pricing and Advance pricing modifiers like discounts, surcharges, promotions, coupons and Qualifiers according the region specified.
• Setup prices on pricelist like unit price, percent price, formula, price breaks which includes point and range price breaks for each item in the price list.
• Executing and scheduling the concurrent programs required for invoice’s generation.
• Generated reports needed to check the orders which are pending using Discover 10g.
• Responsible for creating custom menus and functions and assigning to the responsibility
• Enabled DFF for sales order screen to enter additional information and used 4 additional attributes of OM tables.

Environment: Oracle Applications Release 11i (INV, BOM, OM, AR, AOL and Sys Admin), Oracle 9i (SQL, PL/SQL), Forms 6i, Reports 6i, TOAD.

06/2002 – 07/2004, Confidential,
Oracle Apps resource at Albertsons
Synopsis: At Albertsons, the Project Development team of Store development department is responsible for the development of new stores and remodeling old ones. This department takes care of the Store Development projects, right from the budgeting and bidding through contracts, to the construction and grand opening of the store.

My Roles and Responsibilities:
My role was oracle developer and I was involved right from the requirements gathering, design, development, integration, testing and support of the application. I was mainly working with SQL, PL/SQL, Oracle Forms, Oracle Reports and Toad.
Store Development Project creation: This is a process of creating new cabinet and folder structure for a new project with appropriate user groups assigned to each folder in the project. This is a project administrator’s task. Project administrator will be provided with user interfaces from which he/she can create new projects.

Process and Technical Challenges:

• Involved in preparing solution design document with class diagrams, ER diagrams, and Sequence diagrams using UML according to the requirements gathered.
• Creating and customizing front end screens using oracle forms for new store details according to Retail and Non Retail store category.
• Worked on PL/SQL packages, procedures, functions, database triggers.
• Creating the required order processing tables, indexes, constraints, triggers, synonyms, database links and roles.
• Developed custom reports using reports 6i to populate the details of the customers placed orders on the project date selected.
• Migration of existing order details into current application using SQL Loader with SQL scripts by validating data into interface tables.
• Analyzed and prepared Statement of Work and Requirement Definition Document.
• Designed the business logic to eliminate problems and to ensure efficient system functioning.
• Implementing basic replication using snapshots.
• Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment.
• Tested the entire application in testing environment and exported to Production.
  
  Environment: SQL, PL/SQL, Toad, SQL Loader, Forms 6i, Reports 6i, Oracle 8i, UML

EDUCATION

Masters Degree, Computer Applications (MCA)