SUMMARY

• 8+ years of experience in an exceptional track record in implementingOracle Manufacturing and Distribution applications.
• Highly experienced in Advanced Supply Chain Planning Functional design and implementation for various manufacturing business units.
• Successful delivery of Oracle ERP technology/process deliverables, specifically around Oracle's E - Business Suite for Supply Chain Management (ASCP, GOP, MRP, Forecasting, Demantra, Procurement, Inventory, WIP, BOM, and Quality).
• Proficient in creating & maintaining Application Implementation Methodology (AIM) documents- Business Process Architecture (BP 80), Business Requirement Definition & Mapping (BR 30), Module Design & Build (MD 50), Conversion (CV 40), Data Migration, Application Configuration (BR 100), User Manuals & Test Scripts (TE 40).
• Working experience on ASCP (R12i (12.1.1, 12.1.3) Setups - Planning Parameters, Demand Management. Forecasting, Scheduling and Planning Priorities.
• Hands-on experience with Oracle EBS to ASCP integrations and ASCP performance tuning
• Experienced lead for post-release and implementation for all Global customers for Oracle ASCP flagship module.
• Experienced helping customers to go-live by identifying and solving the issues in areas of SQL Performance, Plan performance and Plan memory issues.
• Exploration Phase Scheduling- Application requirement & evaluation study, Selection of Product Vendor & sourcing, Product demonstration to Project Steering Committee & Key Business Users Selection of implementation methodology.
• Highly talented and experienced consultant, team player with excellent communication andanalytical skills, able to manage changing responsibilities and priorities, delivering time criticalprojects on schedule, and proven ability to accept challenges and produce results in a multi-tasked environment
• Building and demonstrating solution concepts for Oracle VCP-based solutions for emerging needs of a company (including capacity constrained scenarios, global supplier capacity modeling, alternate sourcing, repair strategy, new buy purchases, end item substitution, supersession chain and substitute components)
• Experienced lead for post-release and implementation for all Global customers for Oracle ASCP flagship module.
• Experienced helping customers to go-live by identifying and solving the issues in areas of SQL Performance, Plan performance and Plan memory issues
• Mapped User Stories, Campaigns and Business processes with standard Oraclefunctionalities for demand to plan track as aproof of concept based on client discussions.Ability to influence and build consensus with other IT teams and leadership
• Strong Release Management knowledge & R12 full life cycle and upgrade implementation experience within the Oracle Mfg suite
• Ability to leverage data to drive business insights through sophisticated modelling, statistics, and other highly analytical methods

TECHNICAL SKILLS

Java Technologies: JSP, EJB, JDBC, Java Script, and Visual Age.

Application/Web Servers: WebSphere 7.0, WebLogic 8.1, Oracle 10g/9i, JBoss 5.0, Tomcat

Databases & DB Languages: PL/SQL, SQL

Management Tools: ALM/Quality Center, MS Project, SharePoint, JIRA

Methodologies: Oracle's Application Implementation Methodology (AIM)

UML Diagrams: Architecture Diagram, Entity Relationship Diagram, Use Cases, Class Diagram, Sequence Diagram, Activity Diagram

IDE/Tools: NetBeans 6.5, JDeveloper, Eclipse, WebLogic OracleEM

Office Suites: MS Excel, MS Access, MS Word, MS Visio, MS Outlook

Operating Systems: Solaris, Linux, UNIX, Windows

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Oracle Functional Consultant

Responsibilities:

• Implementation of R12.1.2 (Purchasing, Inventory, iProcurement, iSupplier, Sourcing, AP, WIP, BOM,PIM)
• Worked on 2 successful deployments at US Steel Plants in Pennsylvania and Texas.
• Managed conversion activity from Oracle11i to R12.
• Evaluated the usability of existing production scheduling application and assisted in providing the difference in approach of ASCP application.
• Designed and implemented rule-based inventory re-balancing for sales locations across the globe.
• Identify gaps in existing Oracle standard functionality and help support creation of functional specification document.
• Troubleshoot and resolve issues in ASCP that occur as a result of project implementation.
• Involved is ASCP subset planning, detailed scheduling support, attribute based netting, inventory points, process manufacturing features (Charges, complex routing), and support optimized planning.
• Analyzing forecast spreading and inclined forecast consumption.
• Creating sales orders from VMI (Vendor managed Inventory) engine.
• Design APS interfaces to collect data from Oracle Inventory, Bill of Materials, Work-In-Process, Shop floor management, MRP, Order Management & Purchasing.
• CTO (Configure-to-order) explosion for ODS Based ATP
• Design and implemented Automation of all the Master Data changes (Forecast, Item, BOM, Routings, Resources, Sourcing rules) to Oracle ERP modules and Mass Changes of business entities (Part attributes, Categories, Resource usages, Yields etc).
• Release/reschedule of work orders from APS to WIP and OSFM.

Confidential, Schenectady, NY

Onsite Coordinator and lead

Responsibilities:

• Managed the Project for creating manufacturing calendar application to complement OracleVCP functionalities
• Executed strategies to improve supply chain planning process for spare parts in Landline and Mobility divisions via the upgrade of existing Supply Planning (ASCP) from 11. .1.3
• Constructing evaluation matrix for Oracle Inventory Optimization and Demantra as a combined solution for store level forecasting and replenishment for service parts.
• Implemented three-way inventory synchronization process among OracleInventory, Warehouse Management System and Asset Tracking System.
• Unified User Interface for ASCP, Demantra & IO for planning multiple parts at once by using ADF technology.
• Time-phased, capacity constrained IT enabled Supply Chain planning & Demand Management Process for all the regions across the United States.
• Utilization process to minimize part purchase and maximize utilization of existing inventory.
• Implemented processes for Part Supersession and item substitution in the Supply Chain Planning process as well as Inventory Rebalancing and Inventory
• Evaluated the usability of existing production scheduling application and assisted in providing the difference in approach of ASCPapplication.

Confidential, Newark, CA

Oracle Functional Consultant

Responsibilities:

• Worked on Project Enterprise, an integrated ERP solution to establish a Supply Chain system among the different business within the group
• Implemented all the manufacturing modules
• Implemented Oracle Advanced Supply Chain Planning after establishing the MRP module
• Implemented Oracle Applications 11.5.3
• Led a team of consultants for implementing Oracle applications
• Followed the R2I implementation methodology to study and document the current process, future process, analyze, design, and implement the recommended solution in the applications
• Demonstrated the strengths and capability of the applications as a pilot model
• Built CRP/ UAT instances, and completed testing by the end users
• Developed a test plan for all testing purposes and monitor the results of testing
• Conducted regular meetings with the stakeholders to report on the progress
• Worked on APS implementation in 11.5.3 to meet the supply chain requirements across the business units in TI group
• Understood the product at the initial stages and we did a lot of testing to get them stabilize.
• Maintained Oracle application functionality and created Business Objects.
• Participated in interpretation of information as per business needs.
• Managed and executed system requirements and issues.
• Conducted functional testing and created test plans.
• Prepared test cases and scripts for overall system testing.
• Modified and updated application configurations such as setups and workflow builder.
• Installed profile options and assisted in user sessions.
• Formulated application deployment strategies and developed technical designs