We provide IT Staff Augmentation Services!

Demantra Consultant Resume

3.00/5 (Submit Your Rating)

CA

SUMMARY

  • Over 10 years of experience as a supply chain expert with APICS CPIM certification and played Oracle Demantra Techno Functional Consultant\Business Analyst, Production planning and control engineer roles.
  • Experience in ERP implementation, Core team member of BANN implementation in Confidential .
  • Experience in i2 demand planner, demand fulfillment, Master planner, and Oracle Demantra demand management and Oracle Demantra Sales and Operations Planning.
  • Good Knowledge on PLSQL,Extensively worked on Oracle Data base
  • Oracle Certified Demantra Demand Management 7.x Implementer, Oracle Certified Community Explorer
  • Experience on various Demantra components like Worksheets and Workflows, Series.
  • Excellent Understanding of entire Functional aspect of Demantra, Experience on Building data model.
  • Experience on Demantra system parameter, Level member, Series, worksheets
  • Excellent Knowledge on Demantra tables and Demantra workflow
  • Handling the Demantra S&OP process for JDSU,Delivered Various enhancements including creating MD50,MD70 and delivering the final solution
  • Implemented Demantra to Newly acquired two business Units of JDSU
  • Supporting Two different Implementation(Two different data Models),Worked on Two Demantra Upgrades
  • Worked on Converting Demantra Weekly Model to Monthly Model
  • Worked in Various Demantra Related Sales Process(Like Creating solution design and RFPs)
  • Rolled out Demantra to Sales Operations, Trained the JDSU Business users on Demantra
  • Process analysis, design, gap analysis, process mapping, writing functional specifications, integration testing, training and implementation documentation
  • Responsible for the Demantra Projects including creating solution design,CRP,UAT and creating user Manual
  • Strong skills in lean manufacturing techniques such as Kaizen, Kanban, Lean Manufacturing, inventory management, six sigma.
  • Has got sound knowledge in production and inventory management, material procurement, materials management, design and development process.
  • Has got good analytical, problem solving skills. Excellent domain knowledge in Telecom, Electronics Component Manufacturing as well as Semiconductors domains.
  • A team player with good communication and mentoring skills. Quick learner with ability to interact with individuals at all levels
  • Awarded Thrice By JDSU for Operational Excellence

TECHNICAL SKILLS

Databases: Oracle 10g/11g

Languages: SQL,PLSQL

Tools: BANN, Oracle Demantra, Oracle Demantra S&OP,i2 Demand planning, i2 SCP,I2FP,Oracle INV,WIP,BOM

Operating Systems: Windows XP/NT/2000/98/95,Windows vista, MS DOS, UNIX

Office Tools: MS Word, Excel, Power Point, Visio

PROFESSIONAL EXPERIENCE

Confidential, CA

Demantra Consultant

Responsibilities:

  • Responsible for the entire Support and enhancements of Two implementations
  • Configure New series,Levels,Level Members,workflows,worksheets
  • Configuring new rolling Profiles, engine Parameters, New users, Edit Lock expressions, Methods,BLE
  • Addressing work sheet related issue including Worksheet related Performance issue
  • Addressing Java related issue
  • Delivering Data fix
  • Delivering User training
  • Leading the Project team to deliver Various Project.
  • Leading the S&OP Cycle for JDSU
  • Addressing Analytical Engine and Forecast related issues
  • Responsible of rolling out Demantra to new Business units.
  • Responsible for Demantra Upgrades

Environment: demantra demand planning 7.3,Oracle 10g,SQL,PLSQL,unix

Confidential

I2 Consultant

Responsibilities:

  • Converting functional requirement as IT requirement
  • Solve all functional related issues
  • Work with technical team for new enhancements
  • Perform User acceptance test
  • Train user on the tool
  • Coordinate i2 team for any high level Functional issue
  • Helping in building data model
  • Controlling user Access
  • Preparing Business process
  • Study of Compatibility of factory planner with other applications
  • Prepare the Strategy for testing environment and documented the steps
  • Document the Strategy for Production Environment and documented the steps for upgrade
  • Business Impact Analysis on Dependencies and interfaces.
  • Definition of Volume of data required
  • Prepare the Risks and contingency for the upgrade

Environment: i2,Oracle 10g,SQL,PLSQL,unix

Confidential

I2 Business Analyst

Responsibilities:

  • Developed a process for prune Order Entry system
  • Created a process map for Excess wafer start analysis, Auto scheduling defect reduction.
  • Worked intensively on scheduling defect reduction,Pullin defect reduction
  • Performed QA for time phased OEE implementation
  • Developed a process map for Order pull - in analysis
  • Created a process map for order promising of Procured parts (Value added Resale parts), also developed a system for order promising of the same.
  • Created a Business process for lead-time reduction analysis.
  • Solving any functional issues in i2 DP, DF, SCP
  • Perform the QA test for new functional enhancement
  • Worked closely with developers and a variety of end users to ensure technical Compatibility and user satisfaction
  • Responsible for reducing I2 DF scheduling related quality related issues (Reduced from 6% to .4% in 6 months.
  • Responsible for reducing i2 SCP pull-in related issues

Environment: i2,Oracle 10g,SQL,PLSQL,unix

Confidential

Responsibilities:

  • Headed Supply chain management of component manufacturing
  • Responsible for generating daily, weekly, monthly Production plan.
  • Core member of demand planning team
  • Coordinated with cross functional team to achieve the production Targets.
  • Responsible for process improvement in the shop floor
  • Responsible to ensure the process and product Quality standards.
  • Responsible to schedule the order based on resource availability.
  • Played a key role as one point contact for international customers.
  • Responsible for quality audits, and customer qualification audits.
  • Headed cost reduction team for FCP (Frequency Control product division)
  • Headed training dept and responsible for new technicians training
  • Responsible for multi-skilling across the dept.
  • Core member of budgeting team and involved in yearly budgeting activities.
  • Headed lead free soldering transition process team.
  • Core member of quality auditors’ team of Confidential
  • Trained by IBM on Baan 5c on various modules like Enterprise Planning, Order Management, and Shop floor Control
  • Gap analysis between Baan process to existing manufacturing process.
  • Creation of masters for manufacturing process like Tasks, General Item data
  • Creation of Business partners
  • Process mapping through Baan
  • Training the users in the respective modules
  • Designed the report structures required for manufacturing for day to day transactions
  • Member of core team in implementing Baan 5c (Manufacturing Module)
  • As a key user to trouble shoot any issues with respect to Manufacturing issues in the module
  • Creation and generation of reports from Baan

Environment: BANN,Oracle 10g,SQL,PLSQL,unix

We'd love your feedback!