Oracle Vcp Functional Consultant Resume
Baltimore, MarylanD
SUMMARY:
- Over 14 + yearsof total experience which includes strong11+ Years of Oracle ERP and VCP IT consulting covering Oracle ASCP,GOP, Collabarative Planning, Manufacturing and Supplychain modules in Discrete and Process industries and 2 Years in a Functional role in Supply chain planning and Lean Manufacturing domain in Discrete and Process Manufacturing organizations.
- My core expertise in Oracle VCP is in ASCP(Constrained and Unconstrained), Global Order Promising, Collabarative Planning and in Oracle ERP is in Inventory, BOM, WIP, Purchasing, Order Management, Costing(Standard and Average), Warehouse Management System (WMS),Engineering and also I have worked on Inventory Optimization,Production Scheduling and Oracle Demantra .
- I have played diversified roles in Oracle ERP and VCP as Solution Architect, Functional consultant, Business Analyst, Solution Architect for custom solutions, Onsite Production Support Lead for one of the largest implementation of Oracle ERP ( Confidential ) in the world as SPOC and Delivery owner for US time zone and Project Lead for Implementation Programs and all are customer facing roles.
- My Oracle ERP and VCP Experienceincludes: Functional consulting for both Discrete(ATO, PTO, ETO, Project Manufacturing) and Process industries, Custom solution design, Designing custom interfaces with third party system integration using SOA and Web Methods, Leading Oracle ERP and ASCP Global Production Support team for Global business with the delivery ownership of US time zone, value - stream process mapping with functional and Quality team, Operational and delivery management of Oracle projects, Client engagement, project bidding-scoping, Toll gate management, Good Manufacturing Practices(GxP),IT Documentation for a Validated GxP relevant business, proposal writing. Team management and coordination, onshore-offshore engagement on service deliveries and budgeting and estimation.
- I have been part of Confidential, Confidential and Confidential projectsas a consultant and Confidential as an Employee.
- Project management activity ensuring project deliverables are met with agreed SLA, time and cost and with onsite-near shore and offshore model (TCS GNDM™) andboth in Waterfall and Agile - Scrum methodology.
- Organizing, planning and Conducting CRP’s,UAT, Cutover planning for go live..
- Worked extensively with Oracle Support and development team members in resolving issues by creating Service Requests (SR’s) and obtaining one of the solutions.
- Experienced on supporting ASCP, GOP, month end, Quarter end, Physical Inventory process.
- Strong Experience in Managing the Tollgate processes and deliverables.
- Strong Experience on Oracle Production support experience both on Op Ex, Process and Technical aspect.
- Experienced on Project go-live plan preparation, cut over activities and post-implementation support.
- Early detection and Identification of project risks and preparing mitigation plan.
- (MD050, BR-100,) preparation using Application Implementation Methodology
TECHNICAL SKILLS:
Tools: IBM PC with Pentium Technology
Operating Systems / Environments: Windows XP, Windows7 Professional and Windows8.1
Languages: SQL, PL/SQL
RDBMS: Oracle 9i, Oracle 10g
ERP: Oracle Applications R12, Oracle Value chain Planning R12, TOAD, PL/SQL Developer, Oracle SQL Developer, HP Mercury Quality centre, Rally, HP ITG Tool for Change Control and Tollgates approvals, MS - Office, Clarify, Service Now, PVCS
PROFESSIONAL EXPERIENCE:
Confidential, Baltimore, Maryland
Oracle VCP functional consultant
Solution Environment: Oracle R12.2.4 ERP in a Contract Manufacturing world, Constrained Planning.
Responsibilities:
- Lead Implementer for Oracle ASCP (Centralized) and Global Order promising.
- As a lead implementer for Oracle ASCP and GOP,Joined the project in the middle, Tested and enhanced the Planning Solution, the Solution involves the Product family ATP, Customization on ATP hook, Customizations to include the Supplies in the collections for Contract Manufactures, Omit the Supplies in the collections for different business rules and Auto release of Planned orders.
- Requirement gathering and analysis from the Business process owners and End users on Planning and Scheduling.
- Identify the Oracle System gaps and design RICEFW on ASCP Release hooks, ATP hook.
- Conducted the CRP’s and UAT to demonstrate the future state solution
- Prepared the Documents like BR100, MD 50.
- Configure the Instances and the Plans.
- Cross functional work with other teams like QTC,P2P.Supplychain execution.
Confidential, Tulsa, Oklahoma.
Solution Architect
Solution Environment: Oracle R12.1.3. ERP in a Project Manufacturing world.
Responsibilities:
- Lead Implementer for Oracle ASCP (Centralized), Manufacturing and Project contracts in a Project Manufacturing world.
- As a lead implementer for Oracle ASCP designed the Planning solution(Unconstrained Plan) and Manufacturing processes along with the projects contracts as a place holder to capture the demand
- As an architect, mapped the legacy Org Structure to Oracle Structure from Inventory Org from Inventory Org to Locator’s.
- Requirement gathering and analysis from the Business process owners and End users on Planning and Manufacturing.
- Build a future state process map and solution for various types of business scenario and product lines.
- Identify the Oracle System gaps and design RICEFW on ASCP Planning reports, Enhancements on Project Contracts and Manufacturing reports.
- Build the conversion strategy for various data elements and with the personal ownership of Items,WIP Jobs, Forecast of Items and have given the high level approach to other peers on BOM and Routing conversion.
- Conducted the CRP’s to demonstrate the future state solution
- Prepared the Documents like BR100, MD 50 and CV 40.
- During the assessment,conducted the workshops with the business process owners to understand the high-level business processes from demand to fulfilment including sourcing and procurement and came up with high-level future state solution and recommendations which were taken as base to the Original implementation.
Confidential, Houston, Texas.
Lead implementer
Solution Environment: Oracle R12.1.3.8 ERP and VCP . GOP with CTP and Capacity constraint and ASCP with Demand Constraint in an ATO Manufacturing environment.
Responsibilities:
- Lead implementer of Oracle GOP and ASCP modules.
- Requirement gathering from end users and functional owners.
- Analysis of TO-BE process requirements and creation of design models to satisfy them like ATP Rules, CTP, Sourcing rules and assignment set, ATP for Option based routing, Plan options.
- Configuration of GOP and ASCP modules.
- Execution of Proof-of-Concepts to establish proposed solutions and get sign-off from user.
- Preparation of functional design documentation (MD50) for custom objects, preparation of Setup Documents (BR 100) to be used as baseline for all setups and configuration.
- Preparation of Test scripts
- Work with Oracle for Service requests.
- Plan and Drive the Integration testing for the VCP modules.
- User support and Functional validation of ATP and ASCP during integration testing cycles.
- Defect resolution
- Work with master team to correct the data issues like BOM, Routing and Lead times etc.
Confidential, Cleveland, Ohio.
Solution Environment: Oracle R12.1.3, ASCP with Distribution Planning, GOP, Discrete Manufacturing with WMS.
Responsibilities:
- Support ASCP,GOP Modules
- Support Manufacturing Modules like BOM, WIP, Costing, Inventory and Purchasing Modules.
- Simplifying theATP and Sourcing rules for correct scheduling.
- Process Improvements on the Planning and Manufacturing functions.
- POC for Production Scheduling.
- Establish the business process for Cycle count.
- Simplifying the OSP Business process.
- Establishing the end to end (Planning to Inventory consumption to reporting) Business process for Customer provided Inventory
- Identify the Simplification of existing Design and Improve the same
Confidential
Functional Consultant
Solution Environment: Oracle R12 with Process Manufacturing, ASCP, WMS.
Responsibilities:
- Requirement gathering from end users and functional owners and identification of gaps between AS-IS and TO-BE systems
- Analysis and Categorization of Gaps and designing solutions to close the gaps
- Analysis of TO-BE process requirements and creation of design models to satisfy them
- Configuration of ASCP and Supply chain Management Modules modules(Inventory, Purchasing and Order Management)
- Mapping of various business functions in existing system with Oracle Application Supply Chain modules and existing custom solutions within the target ERP instance.
- Execution of Proof-of-Concepts to establish proposed solutions and get sign-off from user
- Preparation of functional design documentation for custom reports, notification System to be developed as a part of deployment as per business requirements and gap analysis/study
- Preparation of Setup Documents to be used as baseline for all setups and configurations at go-live
- Preparation of Test scripts to be followed by functional team and end-users during various testing phases of the project
- Facilitate Conference Room Pilot (CRP) testing and UAT with functional users and resolution of issues
Confidential
Solution Architect
Solution Environment: Oracle R12,ASCP,OAF,Project Manufacturing with Average Costing
Responsibilities:
- Requirement gathering from end users and functional owners and identification of gaps between AS-IS and TO-BE systems
- Analysis and Categorization of Gaps and designing solutions to close the gaps
- Analysis of TO-BE process requirements and creation of design models to satisfy them
- Execution of Proof-of-Concepts to establish proposed solutions and get sign-off from user
- Working with the Development team to ensure Development is as per the design.
- Preparing test cases
- Functional design document preparation
Confidential
Support Member
Solution Environment: Oracle R12,Intermec Mobile Scanners
Responsibilities:
- Post Go - live support
- User training on new System and Business process
- Preparation of SOP’s for users for all the Standard business transaction as per the new System
- Providing the break fix
- SOP preparation for recurring issues
- Working with Oracle through Service requests for go-live issues
- Sanity check of the System after go-live
- Publishing the Dashboard on various transactions status for the day to the Business and IT leads
Confidential
ERP Solution Architect
Solution Environment: Oracle Application R12,HTML5,Webservices
Responsibilities:
- Requirement gathering from end users
- Solution Design for Ontime Delivery report
- Solution design for basic framework and front end design of Mobile App UI.
- Coordination on user testing on iPhone and iPad
- Data validation of the report
Confidential
ERP Track Lead and Functional Consultant
Solution Environment: Oracle Application 11i(WIP, Inventory, Order Management Modules) eDHR(MES System),OPSM,SOA, Oracle 9i, SQL, PL/SQL
Responsibilities:
- Responsible for Delivery of the ERP Track
- As is and To be Business Process flow mapping
- Responsible for Design of the Interfaces 1) eDHR a Manufacturing Execution System(MES) to GLPROD ERP WIP Inbound Interface 2) GLPROD,ERP to eDHR(MES),WIP Outbound Interface 3) GLPROD,ERP to Oracle Pedigree and Serialization Manager(OPSM) system for Shipments and RMA Interface 4) Form personalization’s on the Item Cross reference and APC module to restrict the GTIN update.
- Preparation of Functional Design documents(MD60)
- Preparation of User requirements specification (URS) documents and getting the approval from the stakeholders.
- Lead and Plan the Tollgate approvals Deliverables as required by the GEHC Release Management team
- Authoring the System test scripts
- Co-ordination with Stakeholders, GE architects and IT leaders
- Documentation required for various milestones
- Communication with stakeholders.
- Ensuring the User stories deliverables are met as required in the Sprints.
- Sprint Planning
Confidential
Project Manager, Functional Consultant
Solution Environment: Oracle Application 11i (BOM,WIP, Inventory, Purchasing and OM Modules) Easy TMS, Web Methods,Oracle 9i, SQL, PL/SQL
Responsibilities:
- Pre Sales activity including negotiation of contract with client and preparation of Statement of Work
- Project Planning and budgeting - Estimation of effort, cost and schedule for the project and preparation of Unified Project Plan
- Preparation of Project Induction Manual, Quality procedure and Staffing
- Leading Offshore based team (peak team size of 10 members) for project execution and delivery
- Preparation and maintenance of project plan
- Responsible for designing the Real-time outbound interface from GLPROD,ERP to EasyTMS application and building 4 custom reports
- Coordinating regular status calls with Clients/Business Leads
- Preparation of Work Breakdown Structure(WBS) and assignment of roles and responsibilities within the project team members
- Monitoring the quality of deliverables and ensuring process and audit compliance
- Coordinating regular status calls and meetings within the team
- Reporting status and health of project to customer as well as TCS Leadership team
- Risk identification, qualitative and quantitative risk analysis and risk response planning to mitigate risks. Preparation of Risk Register and Risk Management Report.
- Analysing and reporting metrics related to service levels, based on the service level agreements in the statement of work
- Appraising the performance of team members, identification of training requirements and mentoring team members
Confidential
Functional consultant
Solution Environment: Oracle Application 11i(Supply chain Planning, BOM, WIP, Inventory, Costing, Engineering Modules) and, Oracle 9i, SQL, PL/SQL
Responsibilities:
- Requirements capture, Analysis and Functional Design
- Mapping of business model with Oracle Applications standard processes of Supplychain Planning
- Setting up of Supplychain Plan
- Setting up item attributes.
- End user training on Supplychain planning
- End user support during the plan runs
- Setting up the Min/Max Planning for low cost buy items
- Setting up the new Inventory org with Standard costing where all the Supplychain modules (Inventory, Costing, BOM, WIP, MPS/MRP, Engineering, Order Management and Quality) are deployed and hooking the existing interfaces as part of the global design.
- Solution design for enhancements
- Data conversion
- Implementing the Changes through Full cycle change control process of GEHC.
Confidential, Milwaukee, Wisconsin
Onsite Global Production Support Team Lead, Track Lead
Solution Environment: Oracle Application 11i, ASCP,SCP,OPM, Oracle 9i, SQL, PL/SQL,Clarify
Responsibilities:
- Lead and Coordinate with Confidential support team and other external teams of GEHC and Confidential .
- SPOC for Oracle PST for US time zone and Escalations point of contact.
- Drive till resolution any Functional and Technical issues reported.
- Module Expert for Manufacturing and Distribution Modules Change Controls.
- Support the Month end and Quarter Close
- Plan and Lead the special support events like Physical Inventory and Year end and Quarter End closes.
- Primary Support member for Oracle ASCP in OPM environment and SCP in Discrete Manufacturing.
- Ensuring the cases are updated, closed as per the SLA set by the client.
- Ensuring that defined Process followed globally by all the Production Support team members while giving the fix to a Case
- Handling Client escalations.
Confidential
Functional consultant
Solution Environment: Fourthshift ERP
Responsibilities:
- Study of existing business processes in Manufacturing and Purchasing Dept.
- Mapping the same with Fourth Shift.
- Preparation of Module Walk through Document
- End user Training in Manufacturing Modules.
- Prepared Requirement Study Document (RSD) for new Customisations.
Confidential
Industrial Engineer
Solution Environment: Lean manufacturing
Responsibilities:
- Improving the Productivity and Optimising the resource utilization.
- Value Stream mapping for major Products, Calculating ‘Takt Time’, Identifying and removing the bottlenecks through Kaizen and Designing the Work flow accordingly
- Quantifying Resources of the Company.
- Production planning & controlling through Gantt chart. & Integrating the Other Depts. To meet the Plan
- Developed the System to avoid First Sample Approval for the mass production through SMED Technique, which will reduce the Set-up time.
- Developed Working Progress Kanban (CON WIP) System, which will maintain minimum WIP based on the Capacity of the cells, thus avoiding the MUDA of over Production.
- Developed and Maintained Raw Material Kanban System, which will maintain the required Raw Material of Size, Quality and Quantity against the Production Schedules.
- Work Place Organization through ‘5S’ activities.