Oracle Certified Professional
Certified Project Management Professional
Email: , Cell: 1.610.416.6321
Professional Summary
* Over nine years of experience in the Enterprise Resource Planning Industry.
* Strong technical background and extensive business experience.
* Over four years of experience in implementing Demantra products.
* Four end-to-end Demantra implementations.
* Led multiple Demantra gap analysis, enhancement and upgrade projects.
* Experienced in EBS 11i - Order Management and Inventory.
* Proficient in end user training.
Professional Experience
Principal Consultant, Oracle Corporation, Chicago, IL. Nov 2005 - Current
Oracle Demantra 7.3.0.1
Teva Pharmaceuticals
* Upgraded Demantra version 7.1.1 to Demantra version 7.3.0.1
* Applied upgrade patches
* Conducted Unit Testing and User Acceptance Testing
* Led production go-live and support
Oracle Demantra 7.2.0.3
J.D Irving, Paper Industry
* Led the design and development of Demand Planning and Sales & Operations
Planning solutions
* Integrated Demantra with JDE 8.10
* Designed and developed customized solutions
* Conducted end-user training sessions
Oracle Demantra 7.1
AMS, Medical Systems
* Enhanced Demand Planning application with Safety Stock functionality
* Designed and developed a custom solution to incorporate safety stock
requirements with Demantra seeded safety stock functionality
Oracle Demantra 7.1
Teva Pharmaceuticals
* Designed and developed an end-to-end Demand Planning solution
* Created integrations to import forecasts from Planning, Marketing, Sales and
Finance to enable Sales and Operations Planning.
* Integrated Demantra with EBS 11.5.10
* Designed and developed customized solutions
* Led the deployment of Demantra to facility in California
* Conducted end-user training sessions
Oracle Demantra 7.2
Green Mountain Coffee Roasters, Consumer Packaged Goods
* Worked as technical resource on Demantra DSM (Deductions and Settlement
Management)
* Designed and developed customized solutions using PL/SQL procedures, Demantra
Methods and Demantra Workflows
* Built Integrations between Oracle People Soft ERP and Demantra DSM
Oracle Demantra 7.1.0
Organic Valley, Consumer Packaged Goods
* Modified hierarchies to accommodate changing business needs
* Assisted in smoothing sales history.
* Redesigned data imports to realign sales history
* Synchronized Promotions and Demand Planning modules
Oracle Demantra 7.1.0
Welch's, Consumer Packaged Goods
Added Demand Planning functionality to existing Demantra Predictive Trade
Planning and Deductions & Settlement Management modules
* Configured Demantra to support the client's Demand Planning Process.
* Integrated Demand Planning Process with Oracle E-Business Suite 11.5.10
* Conducted thorough impact analysis on existing setups
Oracle Demantra 7.0.2
Electronic Arts, Video Gaming
Implemented Vendor Managed Inventory
* Conducted requirements gathering workshops.
* Designed and developed VMI solution
* Configured Demantra application and built customizations
* Conducted Conference Room Pilot and User Acceptance Testing
* Provided complete project documentation and end user training
Oracle Demantra DP4
Johnson Diversey, Consumer Packaged Goods
Analyzed and resolved system performance and data issues within 4 days:
* Reduced forecast engine run time from around 18 hours to less than one hour.
* Fixed data discrepancies and cleaned up sales, matrix and forecast tables
thereby reducing database table sizes to 10% of original size.
* Corrected the update of Service Levels, ABC codes and Safety Stock values
* Provided issue resolution process documentation, next steps guidance and
system maintenance suggestions.
Oracle Demantra
* Analyzed requirements and assisted in mapping/gapping, scoping and effort
estimation at multiple clients
Oracle Ebusiness Suite 11.5.10
ACCO, IL
* Developed a System Integration Test Strategy, Test Plan & Test Scripts
* Coordinated with Order-to-cash, Procure-to-Pay and Accounting-to-Finance
teams to standardize the testing process.
* Performed application module and system integration testing.
* Created and maintained system setup documents for entire project.
Systems Analyst, Resolve Corporation, PA. Aug 2003 - Nov 2005
Warehouse Management System Implementation Highjump V6.2
Warehousing and Distribution
* Successfully lead the development team through the Planning, Execution and
Completion of Warehouse Management System (WMS) implementation projects.
* Acted as liaison between IT Team members, Customer Service and Operations.
* Designed, developed and managed project timelines. Identified and allocated
corporate wide IT resources.
* Coordinated with the web-based and legacy Order Management System (OMS) teams
to integrate OMS with WMS. Identified integration points, issues & provided
solutions. Integrated WMS with Shipping Systems.
* Customized put-away, picking, packing and order validation processes for
Pharmaceutical Clients.
* Designed and developed new Wave Picking methods to improve speed and
efficiency. Configured warehouse locations to improve picking speed.
* Designed and developed reports using Crystal Reports 8.5, Active Server Pages
and HighJump Webwise Page Editor.
* Configured Teklogix RF scanners
* Designed bar-coded license plates.
Programmer Analyst, Federal Direct, NJ. Nov 2001 - Aug 2003
Business/IT Process Re-engineering
Printing
* Analyzed and redesigned label printing process. Reduced total processing
steps from 84 to 21. Created Request for Proposal. Integrated programs, MS Access
applications, SQL server and Kewill shipping software. Trained end-users and
provided documentation.
* Reengineered billing close process to reduce process time from 6 days to 2.
Miscellaneous Custom Programming
* Worked as a team on design and development of Order Management Systems.
* Designed and developed databases and User Tools to query/update databases and
flat files to provide quick retrieval of information for Customer Service.
* Created UNIX shell scripts to automate manual processes of creating
directories, identifying new files, download, unzip, validate, rename, move,
concatenate, purge and FTP files to clients.
Skills Summary
Databases
* SQL Server 2000
* Oracle 9i, 10g, 11g
* Universal Business Basic
* MS Access
Programming Languages
* HighJump WMS
* C, C++
* 9i PL/SQL
* Universal Business Basic
* UNIX Shell Scripting
* Active Server Pages
Engagement Experience
* OM, Inventory and WMS Applications Development & Implementation
* Project Management
* Testing
* End User Training
* IBM Holosofx Business Process Reengineering
* IT & Business Process Automation
* IT Process Documentation
Other Accomplishments
Education
* MBA (in progress), Kellogg School of Management, Chicago, IL
* MS Computer Science, New Jersey Institute of Technology, New Jersey
* BE Instrumentation and Electronics, Bangalore University, India
Training
* Oracle 11i Order Management & Shipping Fundamentals
* Oracle 11i Inventory Management
* Oracle 11i Purchasing Fundamentals
* Oracle 11i Warehouse Management
* Oracle 11i Implement Workflow
* Oracle 11i Financial Applications Overview
* Oracle 9i PL/SQL
* HighJump Warehouse Advantage Architect
* HighJump Configuration Fundamentals
* Project Management Training
* Demantra Demand Management
Certifications
* Oracle 11i Supply Chain Certified Professional Consultant, Order Management
* Certified Project Management Professional
|