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