CAREER PROFILE:

Self-motivated individual with over 25+ year’s experience.

Experience in Consumer Package Goods (CPG) Industry managing teams and leading projects in Demand Management, Supply Chain, Manufacturing, Distribution & Finance, implementing Demantra Promotion Planning, Deduction and Settlement Management & Demand Management, Exceedra Enterprise and JD Edwards EnterpriseOne ERP.

Experience in Information Technology industry managing and leading ERP projects, with project management, requirement analysis, design and implementing of application software.

Willing to telecommute and/or travel domestically or internationally.

CORE COMPETENCIES:

Demantra

Oracle

Exceedra/AFS

Oracle JDE E1 (ERP)

SQL Server

BI

Interfaces

Oracle Data Integrator

Azure Cloud

JIRA

Visual Studio

SSIS/SSRS/SSAS

INDUSTRY:

CPG Manufacturing

Wholesaler

Retailing

Logistics

Oil Industry

Air Travel

Government

University

EMPLOYMENT

Senior Business/Technical Consultant

Exceedra/AFS (Apr 2019 – May 2020)

Involved with gathering user requirements for the Exceedra trade promotion management and settlement management modules for clients and documenting the customer requirements document and the interface document for the ERP system.

Working closely with the project manager on planning the project timeline with various deliverables and critical milestones using the Agile methodologies.

Working with the technical team and creating templates so that they can use it to customize the package according to the customer requirements

Frontending with various clients of Exceedra including Agropur and Massimo Zanetti Beverages (MZB)

Involved in the interfaces testing, train to trainer, user acceptance testing and implementing the project in a timely manner.

Managing Partner

AbbaTek Solutions LLC (Nov 2016 – Aug 2019)

Worked as Oracle Demantra Techno/Functional and ERP interface lead with various clients, such as Pinnacle Foods, Michael Foods, ConAgra & Darigold on implementation of Demantra PTP, DM & DSM from Nov 2016 to March 2019

Involved in the documenting the complete integration between Demantra and the BPCS (Infor) ERP system for migration of the new JD Edwards Enterprise One ERP system at Pinnacle.

Worked on a two month project with Inspirage at their client Michael Foods in Minnesota on implementing a new module for running events within the Predictive Trade Planning (PTP) module of Demantra and interface with SAP ERP.

Worked on transitioning Demantra to SAP ERP TPM systems of ConAgra when Pinnacle Foods were acquired by ConAgra

Worked on a two month project with Avata at their client Darigold in Seattle on implementing the Deductions and Settlement Management (DSM) module of Demantra.

Oracle Demantra Project Lead/Technical Analyst

Pinnacle Foods Group LLC (Mar 2014 – Oct 2016)

Involved in the day-to-day operations of the Demantra PTP and DSM modules at Pinnacle from the beginning of the project

Working with the off-shore managed services team to streamline the various job streams for daily and weekly loads and engine runs, trouble shooting various issues.

Managing the project with the Demantra solution architects and other developers and systems integrators to integrate with the Infor BPCS ERP system.

User Acceptance testing, implementation of predictive trade promotion (PTP) and Deduction and Settlement Management system and going live

Streamlining the reporting interface and design of output tables from Demantra to the obiee tool.

Involved in the debugging, on-going support and user training, trouble shooting of Demantra

Designed and implemented various functionalities for Demantra

oItem or customer realignment, when downsizing of UPC’s moving from one promote group to another, one size to another, across volume, promotions etc.

oIntegrating new companies or brands purchased by Pinnacle to the existing Demantra modules

oCopy base volume, historical or statistical volumes from current year to next year’s base case overrides

oSupport on the DSM functionalities for multiple split by promote groups, items or other customized features

oSupport of various worksheet changes, interfaces, workflows, methods, client and server expressions etc.

oAssisting in various project related work and migration of codes from staging to production

oInvolved as a liaison between the business and IT, translating the business requirements to IT solutions through design workshop and presenting prototypes to the business

Oracle Demantra Consultant

PepsiCo Canada (Dec 2013 – Mar 2014)

Development, unit testing, user acceptance testing, implementation, training of the Deduction and Settlement Management system and going live

Involved in the debugging, on-going support and user training, trouble shooting of the predictive trade promotion (PTP) module of Demantra

Systems Integrator / Project Leader

Massimo Zanetti Beverages USA, Inc, Suffolk, VA. (Nov 2006 – Nov 2013)

JD Edwards EnterpriseOne – Part of the team that migrated from JD Edwards World to JD Edwards EnterpriseOne, interface with PLC's, production, work orders on blended & roaster events. Created item specifications forms & interface with demantra promotions, deductions, settlements, forecasting etc. Extensively used the various tools provided by JD Edwards for development – OMW, FDA, RDA, GH9015, BV, BSFN, NER, BSVW, UBE etc.

oI created the item specifications which we previously had in VB/ASP as the out of the box item master information was not sufficient for the specification sheets used on the floor. This was developed using Form Aid (FDA) and all the development tools within JDE.

oRoaster Batches Events also was migrated from ASP.Net to JD Edwards EnterpriseOne using the Form Aid (FDA), NER and Business functions. The data was interfaced with the roasted batches that were running in the plant on the Wonderware (MES) / PLC’s system; the application created Work Orders for manufacturing and had the option to issue or back flushes raw materials based on the type of product manufactured.

oUBE was developed to push the Work Orders schedule for production for next week using the Z-file concept in JD Edwards EnterpriseOne from F4801Z1 & F3111Z1.

oCreated other forms, UBE’s, reports and have knowledge with applying ESU’s, debugging tools etc.

oThis helped the company to migrate all the in-house developed applications to the JD Edwards EnterpriseOne environment thus reducing approx. $200,000/- per year on personnel, software and hardware expenditures.

JD Edwards EnterpriseOne ERP - Sales Order, Supply Chain - Planning (DRP/MPS/MRP), Purchase Orders, Procurement, Work Orders, Bill of Materials, Inventory, Financials (GL, AR, AP).

Oracle Demantra - Demand Management, Predictive Trade Promotion & Deductions and Settlement Management.

oProject Lead for upgrading the software from 7.3.1.2 to 7.3.1.4 version which had various new features. This helped the company to manage their trade spend dollars in a more efficient manner, there was increase in productivity by more than 50% due to speeding up entering promotions using dashboard and promotion calendar features, there was a particular feature in the upgrade which increased the speed of matching the settlements with promotion from 1 to 3 minutes to just few seconds increasing productivity by more than 90% in the deduction team thus freeing them to spend time on analysis and management reporting.

oExtensive experience using PL/SQL in the backend procedures, series, methods, interface, workflow and all Demantra features.

oCreated complex SQL Server views in JD Edwards EnterpriseOne ERP in a few days to interface with Demantra through the Oracle Data Interchange (ODI) software as the consultants spend more than a month attempting to load using the Process Integration Pack (PIP) and were unsuccessful. This helped in saving the company from going over 30% of the budgeted cost and completing the project on time.

Sales Discovery, AFS - project management and development on the proof of concept.

oThis helped the company to decide on software to pull all their numbers from one source rather than folks bringing in different numbers during meetings.

Developed E-commerce backend interface between SQL Server & JD Edwards’s enterprise one ERP.

oThis was extremely profitable for the company as more people became aware of the products and since some of our products are regional the customer who had moved to different parts of the country was able to still order the items they like on-line. The overall turnover from this venture for the company is well over $500,000/- annually.

SQL Server Database & Business Intelligence, SSIS, SSRS & SSAS on sales, finance & production cubes. Created various complex reports, dashboard, graphics and KPI using the SQL server SSRS.

oProject lead on conversion from TM1 Cognos to the SQL Server Business Intelligence suite the commercial finance module, this helped the company to consolidate on Microsoft SQL Server and saving over $50,000/- per year on software, hardware and support from consultants.

MEI - Trade Promotion Management interface with JD Edwards ERP on sales, promotions, deduction & settlements.

SQL Specialist / Project Leader

Sara Lee Coffee & Tea Company, Harrison, New York. (Nov 2000 – Nov 2006)

Streamlined the Deductions process which was being done manually, part of the team which developed an in-house solution for Contracting, Deduction Management and Settlements Systems using SQL Server, ASP, JavaScript & VB Script. Systems were interfaced with the JD Edwards ERP system (AR, GL, and Sales Orders).

oThis helped the company to get a better visibility of 25 million dollars of deductions and handling it better.

Comprehensive database management and migration from Unix/Sybase to SQL Server 2000. Created the Data Marts for Sales & Financial analysis, using the JD Edwards World ERP software and developed the reports & charts, etc. using the Crystal reports.

oThis helped the company save on investing on Unix based HP system and Sybase which is more costly to procure and maintain but instead invest on more widely used SQL Server, Windows and Crystal reports environment.

Developed the new reporting system for the newly formed company which combined various retail coffee brands such as Chock Full of Nuts, Hills Brothers, MJB, and Chase & Sanborn.

Project lead on the development of in-house Forecasting system and the CIF green coffee procurement system in Suffolk using Visual Basic & SQL Server.

Project Manager

Gulf Computers Inc., Baltimore, Maryland (1999 – 2000)

Nov 1999 to May 2000 - Widener University, Chester - PA - Technical Consultant on Datatel's Colleague and Benefactor educational software in Unidata - Transcripts, Library, Admissions, Meal plan etc. modules

Jun 2000 to Aug 2000 - Medical Economics, Montvale - NJ - Software Development project for Order fulfillment system developed on System Builder, Oracle ERP and Unidata.

Sep 2000 to Nov 2000 - Insignia / ESG, Saddle Brook - NJ - Software Consultant for Real Estate System developed using Pick systems

Software Manager

Gulf Computers LLC, Dubai, U.A.E. (1984 – 1999)

Started as a Programmer/Analyst and finished a long career as Software Manager.

Had the opportunity to work on several turnkey projects from requirement analysis to implementation on Sun Microsystems, Omron, Oracle, UniVerse, Sybase, SQL Server, SAP & UNIX environments.

Worked extensively with the off-shore project leaders, development and testing team in Mumbai, India.

oMost notable during this period was to computerize the manual system of Bhatia Brothers group a major company in U.A.E. who are involved in various business ventures including Oil & Gas. I conducted the requirements analysis & study of the distribution, inventory control, payroll and financial system (AR, AP & GL) and visited our Mumbai office and was involved with the initial design, visited in between for testing and monitor the progress of the project, implemented and trained users at Dubai as each module got completed, the project was completed in a year’s time.

Notable clients included Emirates Airlines, Schlumberger, Bhatia Brothers Group, Technical Parts Company, Dubai Water Department, Lamcy Corporation, Union Co-operative Society, Al Batha Group, Tiffany Biscuits etc.

oImplemented at Schlumberger (world's largest oilfield services company) – Windows based Computer Output to Laser Disc (COLD) on SQL Server 6.5 database a product called Greenbar from FileNet Imaging and Document Management company for reports generated on AS/400 system, this was a two months project.

PROFESSIONAL ORGANIZATIONS

PMI – Project Management Institute

EDUCATION

Bachelor of Science in Computer Information Systems

CERTIFICATION

Project Management Certification – Regent University, Virginia Beach, Virginia

AWS Developer: Building on AWS – Certification from edX

Fundamentals of SAP R/3 ERP, Material Management and ABAP/4 (Continental Informatics, Dubai, U.A.E.).

JD Edwards EnterpriseOne ERP - CNC Boot Camp, Certificate of Completion, Brij, Greensborough, North Carolina

JD Edwards EnterpriseOne ERP - Enterprise Report Writer, Certificate of Completion, Brij, Greensborough, North Carolina

JD Edwards EnterpriseOne ERP - Advanced Enterprise Report Writer, Certificate of Completion, Brij, Greensborough, North Carolina

Enterprise Web Development with ASP.NET: Hands-On at Learning Tree International, New York, NY

Visual Basic .NET: Building Object-Oriented Applications at Learning Tree International, New York, NY

XML: A Comprehensive Hands-On Introduction at Learning Tree International, New York, NY

Java for Web Application Development: Hands-On at Learning Tree International, New York, NY

Tools & Techniques for Analyst/Programmers (Keith London Associates, Dubai, U.A.E.)

Oracle Database Management System (Oracle Corporation, Dubai, U.A.E.)

Sybase: Introduction to Sybase, Fast track to Sybase, Fundamentals of System & Database administration. (Sybase Corporation, London, U.K.)

Sybase 11.X Administration Certification through examination administered by Brainbench.

Microsoft Solutions Framework (Microsoft Corporation, Dubai, U.A.E.)

Oracle Database and Developer/2000, Forms and Reports (STG, Madras, India)

Power Builder Development (Informatics, Bangalore, India)

Contact this candidate