Blue Yonder Professonal Service Consultant - JDA Software Consultant


Blue Yonder Technical Architect - JDA Technical Architect

PEN127

Blue Yonder Solution Architect – ESP – SparQ - Order Promiser – Demand Planning

SUMMARY: 

Over 20 years of hands-on experience in analyzing, designing, developing and implementing Supply Chain applications in Manufacturing, Distribution and Retail Domain

Worked for Blue Yonder, Inc as Techno-Functional Solution Architect for multiple clients for Solutioning, Construct, Integration and implementation of Demand, Demand Classification, Demand 360, Fulfillment, ESP and Order Promiser modules

Techno Functional Expertise in Blue Yonder Demand, Demand 360, Luminate Demand, Demand Classification, Fulfillment, Dynamic Deployment, ESP and Order Promiser

Solutioning of Demand module Processes – Calculate Model, Reconcile Forecast, Cleanse History, Map DFUs, Store Forecast, Store Derived Tables

Solutioning of Fulfillment Module Processes and Tables – Level SKUs, Calculate Plan, Optimize Orders, Project Optimized Orders, Store SKU Projections etc.

Technical Design Docs from Functional Specifications, Installs, Patching, SCPOMGR & ABPPMGR Schema Configurations, SRE configuration and troubleshooting, UDTs/UDCs, IGP, FEs, CSM grants & roles, Unix and Windows Batch setup - Oracle, SQL, PL/SQL, Unix, Shell Scripting, SQL Optimization and Debugging

 

Skills:

ERP/SCM: Blue Yonder 2022 in Azure, SAP, Manhattan, Dynamics 365

UML Tools: MS Visio, PowerPoint

BY Modules: Demand Planning, D360, Demand Classification, Fulfillment, Dynamic Allocation, ESP, Order Promiser

Database: Oracle 19c, Exadata

Design Tools: Loop, Miro

Application server: WebLogic 12

IDE: Eclipse

Webserver: Apache

Methodologies: Agile Scrum, Waterfall

Database Tools: TOAD, SQL Developer, TKProf, Query Analyzer, Explain Plan, Oracle Enterprise Manager

 

Programming Languages: C, C++, Python, Java, SQL, PL/SQL

Project Management: JIRA

Scripting Languages: Shell Scripting, JavaScript Awk, Sed

Test Case/Defect Tracking Tools: ALM, Jira, Zephyr, QTest

Job Schedulers: Control-M, Automic

ETL: Informatica, Snowflake

EDUCATION:

• Bachelor of Engineering in Industrial & Production Engineering

 

Certifications:

• Blue Yonder-Connect from Blue Yonder
• Blue Yonder- Fundamentals of Demand & Fulfillment
• Basics of Supply Chain Management - CPIM

 

WORK EXPERIENCE 

 

Techno Functional Architect 

Peningo Systems / Blue Yonder/ JDA Software Group, Inc    January 2019 to Present 

Environment: AIX, Oracle 12, SQL, PL/SQL & Shell Scripting

Responsibilities: Blue Yonder - JDA SCPO Implementation & Custom Development using Oracle

• Blue Yonder / JDA Applications - Demand, ESP, Order Promiser 
• Binary Silent Installs & Configuration of JDA Foundation, SCPO & SRE Thin Installs, DB Migration, SQL & PL/SQL Interfaces for Data and User Functionality 
• Understand Functional Specifications specified by Requirements from Business Users and create Technical Specifications 
• Validate Functional Use cases and configure for UAT 
• Implement UDTs & FEs to interface business user inputs for calendar Horizon, Batch, UI and Process parameters. 
• Implement Batch Development 
• Good understanding of demand and supply planning tools both from a configuration and process standpoint 
• Good knowledge of systems integration points for demand and supply planning systems required 

 

 

Techno-Functional Solution Architect, Blue Yonder, Inc (Consultant)                                      

Client:  Yokohama  Tires                                                                                    July 2024 – Current

Blue Yonder Modules: Demand Planning, ESP (SPARQ Solver), Order Promiser

Yokohama Tire Corporation is the North American manufacturing and distribution arm of Tokyo, Japan-based The Yokohama Rubber Co., Ltd. Yokohama has Consumer (OE and RE) and Commercial divisions and distributes to over 400 retailers in the US.

• Gathered business requirements and prepared solution design document
• Drove Data Mapping and configured processes accordingly
• Created Functional Specs and assisted in Technical Design, Development and customization
• Created business scenarios for Test Plan for SIT and UAT
• Analysed and resolved pre and post live issues by providing process alternatives and workarounds to minimize code changes and by coordinating with Client’s Business and IT teams and Blue Yonder’s Product Development team and documenting the same.
• Provided KPIs to track System efficiency for Inventory and Orders

 

Client:  Southeast Toyota                                                                                  Aug 2023 – Jun 2024

Blue Yonder 2019.1.2.0 - Demand, Fulfillment, Dynamics 365, Manhattan

Southeast Toyota Distributors (SET) is the world’s largest independent distributor of Toyotas and distributes vehicles, parts and accessories to Toyota dealerships. SET needs forecast vehicles and vehicle part demand across 200 dealers and plan procurement from Toyota and Vendors.

• Solutioning for DFU & DFUView Creation, Lew Params, Transfer Forecast, Demand Reconciliation, Fulfillment - Build Transmodes, Slow movers, Supply Fcst Projections, Product Discontinuation, Order Optimization for implementation
• Design for Blue Yonder requirements to be integrated with Dynamics 365 and Manhattan
• Design Build Loads and interface Manhattan keeping view of requirements for picking, packing, shipping, cycle counting, Waves for stock, backorder, etc.

 

Solution Architect (Blue Yonder Products), Wipro Ltd.                                                Jun 2022 – Aug 2023

Client: TJX Inc

Blue Yonder -Demand 2022.1, Oracle RPAS, Oracle Exadata

• Merchandising Data and feed it as Promotions into Demand Planning for Forecast Generation
• Create User Stories per User Requirement and Develop, Build, Test and Deploy code
• Implemented Workbenches, UDTs and FEs to interface business user inputs for calendar Horizon

Integrate with Oracle RPAS with in-house application for Merchandising projections

Develop Custom code using PL/SQL and Shell Scripts in Oracle Exadata to process

Client: Alticore

Blue Yonder -Demand, Fulfillment 2019.1.2.0, Oracle, Oracle Data Integrator (ODI), SQL, PL/SQL, Automic

Requirements gathering with Business users for Demand and FF – Demand Mapping, Demand Maintenance, FCST, Hist, CustOrder, Planned Orders, Planned Arrivals, VL & VLLs

Participated in Design for Order Optimization includes – SKU Params, Multi-drop, multi-pick and sub-sourcing flows, Order Groups, Transportation modes and constraints

Develop scenarios and execution for UAT

Solution Architect, Blue Yonder, Inc (contract)                                                          Feb 2022 – Jun 2022

Clients: Clif Bar, Macys , McKesson

Blue Yonder -Demand, ESP, 2019.1.2.0

• Clif Bar- Design and Solutioning of ESP – Supply Solve, Minimum and Incremental quantities, Micro-hold at Co-Packer, Export Expedite Lanes, NPI and Planner Assignment, Dynamic SS
• Macys – Resolve Functional issues in Production in Demand and Fulfillment – Order Opt, SuperSession, Slowmovers, DFUView failures
• McKesson – D360 Worksheets, Daily Demand Inputs, Demand Classification, Reconcile Forecast Process – resolve issues

Techno Functional Architect                                                                Jan 2021 – Dec 2021      

Client –  Sephora

Blue Yonder 2019 Demand Planning, Fulfillment, Inventory Optimization

• Customization and Rollout of Demand Planning and Fulfillment
• Design of CRs and Enhancements to requirements to existing implementation for Go-Live
• Design of Dynamic Allocation, Allocation Workbench configuration, Order Opt
• Create UAT Scenarios and Acceptance Criteria for User Stories to be incorporated in Agile Env
• Design and implement Demand Planning – Demand Forecast Streams, Newness Planning, Promotional Events, Measures, Demand Classification, Targets/Locks/Overrides and Flexible Allocation
• 
  

Techno Functional Architect, Capgemini                                                       Jul 2020– Dec 2020        

Client – Reyes Beer Division

Blue Yonder 2019 Fulfillment, Demand, Luminate Control Tower

• Solutioning for Demand and Fulfillment
• Master Data interface from 6 instances of ERP into Blue Yonder
• Functional and Technical design for Purging and outbound JDA interface from Cloud using SFTP
• Customization using SCPO Adaptor and implementation of BY-CONNECT
• 
  

Techno Functional Architect, Insight Global Inc                                                          Dec 2019– Jun 2020              

Client – CVS

Blue Yonder 2019, AIX, Oracle 19, SQL, PL/SQL & Unix Shell Scripting

• Analyze and upgrade existing implementation at CVS of Demand and Fulfillment on-
• Premise implementation from v9.0 to 2019.1.0.0
• Performed Binary Silent Installs and Configuration of JDA Foundation, SCPO and SRE Thin Installs, DB Migration.
• Implement Dynamic Allocation – Gather Requirements, Impact analysis on existing modules and corresponding CRs, Design and deliver TDDs from FRDs and

Developed complex Procedures and functions packaged using Oracle Analytic Functions including PARTITION, PIVOT, UNPIVOT, RANK etc.

Performance tune Batch processes using Hints and disabling and Enabling Referential Integrity constraints to process data

Technical Architect, Blue Yonder, Inc (Peningo Systems)                                       Sep 2019 – Dec 2019

Client –Pactiv

JDA 2018, ESP, Order Promiser, Oracle 12, SQL, PL/SQL & Unix Shell Scripting

Implemented enhancements to Order Promiser and ESP

Configure Order Promiser and Adaptor to SAP for Integration of Order Management System with Order Promiser

Build interfaces between ERP system and JDA

 

Technical Architect, Tech Mahindra (Tech Talenta)                                                        Jun 2019 – Aug 2019

Client – Verizon

JDA 2018, Windows, Oracle 12, SQL, PL/SQL

Maintenance and minor upgrades to JDA

Support Demand Planners and Supply Planners and Batch Processing

Mar 2018 – January 2019 

Product                        : JDA SCPO - Demand and Fulfillment

JDA Versions               : 7.x/8.x

Environment                : Solaris, Oracle 11g, SQL, PL/SQL, PERL & Shell Scripting

Responsibilities            : JDA Mexico Implementation & US Supersession

JDA SCPO Implementation  – Replicating US implementation in Mexico Remotely. JDA installs on Build/Test, QA, SIT, Training & UAT on Production Servers.

Shell Scripting for nightly, weekly and monthly Batch processing

JDA Migrations including creation of UDCs & UDTs.

Custom process to Extract, Transform & Load data from propriety enterprise application into JDA with IGP using Shell, Perl, SQL, PL/SQL & Java.

 

 

Technical Architect - Client Implementations 

  Environment: Unix, Oracle 12c, SQL, PL/SQL, PERL & Shell Scripting Responsibilities: JDA SCPO Implementation & Custom Development using Oracle

• JDA Applications - Binary Silent Installs & Configuration of JDA Foundation, SCPO & SRE Thin Installs, DB Migration
• Provide Technical Solutions per new Functional Specifications by Business Users using PL/SQL - Stored Procedures, Packages & Triggers and SQL Queries invoked by Shell/PERL.
• Created Functions, Triggers for Data Validation, Views & Sequences, Tuning of PL/SQL using Bulk Collects
• Shell Scripting for nightly, weekly and monthly Batch processing
• JDA Application & Database Migrations including creation of Custom Tables & Columns
• Custom process to Extract, Transform & Load data from propriety enterprise application into JDA
• JDA patches - Upgrades and Migrations of Oracle Schema to Application version
• Trouble shooting of Oracle code for general Coding errors and Locks
• CSM Security setup, SRE Tuning

 

 

Jan 2013 – Feb 2018  :   

Product                        : JDA SCPO - Demand and Fulfillment

JDA Versions               : 7.x

Environment                : Solaris, Oracle 11g, SQL, PL/SQL, PERL & Shell Scripting

Responsibilities            : Support of SCPO Demand and Fulfillment, JDA Installations, Patch Installations and Migrations

JDA SCPO patches – Upgrades and Migrations.

Create Custom processes based on Functional Specifications specified by Business Users for new Business requirements using SQL & PL/SQL Code invoked by Shell/PERL scripts, Java.

Support of Technical and Functional analysis of Demand and Fulfillment issues related to JDA processes.

Jun 2011 – Dec 2012  

Manager

Lowes is a Home Improvement retail company with over 2000 retail outlets and over 40,000 SKUS per store.

Product                        : JDA SCPO - Demand and Fulfillment

JDA Versions               : 7.x

Environment                : HP-UX, Oracle 11g, Shell Scripting

Responsibilities            : Manage Supply Chain Project, Technical analysis of SCPO, JDA Installations, Configuration and Batch setup

Installations of JDA SCPO along with version management of Cumulative patches in coordination with JDA

Design and Development of nightly and weekly Batch processing of JDA Demand and Fulfillment Processes integrated with Custom processes using Shell Scripting

Configuring custom processes to run from JDA UI.

Part of Performance tuning team for JDA and Oracle to process few Million Skus during nightly Batch

JDA Schema Migrations, Creation of custom tables in JDA schema and UI Configuration for FEs of Custom Tables.

JDA UI security configuration by creation of Roles and assigning to appropriate users.

Training and Transfer of Knowledge to Capgemini Offshore teams in India Supporting Lowes from Offshore.

Dec 2004 – Jun 2011:  Publix Super Markets, FL, USA

IT Project Manager–Supply Chain Implementation

Publix Supermarkets is a Florida based privately-held Fortune 100 Company operating over 1000 supermarkets and over 20 warehouses in USA. Implemented JDA Demand and Fulfillment for managing the Supply Chain of 20 Million SKUS.

 

Product                        : JDA SCPO - Demand and Fulfillment

JDA Versions               : 7.1x, 7.2x, 7.5x and 7.6x

Environment                : Solaris, Oracle 11g, Shell Scripting, Java, .Net, SQL Server

Responsibilities             : Manage Supply Chain Project, Functional and Technical analysis of SCPO, JDA upgrades, configuration, Integration and Maintenance

 

Implement JDA Demand & Fulfillment for Publix Supermarkets supply chain-

Project involved implementing JDA SCPO Demand and Fulfillment & rolling out over 1000 stores and 20 warehouses with 20 million SKUs using JDA 7.2.2 to cut down store Inventory levels and improve service levels at stores

Part of the Core team to implement Supply Chain strategy over six phases

Managed scope and time of JDA projects in each phase to implement demand forecasting and fulfillment planning

Defined requirements specifications, translate to Design, lead development and testing with team sizes of 10 or more, perform User Acceptance Test and resolve user issues and perform maintenance

Monitored the implementation to ensure the KPIs defined by business users are met

Performed extensive functional and technical analysis with business users for lead times, charting, shipping and receiving schedules, in transits, supply changes, case conversion factors, Lost Opportunity of Demand, History adjustments, causal factors etc

Developed proof-of concept for project initiation

Validate functionality of existing Demand and Fulfillment processes before and after implementation

Customized JDA warehouse Fulfillment to match the integration with store supply chain

Technical duties involved – Managing JDA installations and upgrades, migrations, configuring SRE Nodes, system administration, user security and Oracle performance tuning , PL/SQL coding and tuning, managing STSC and CSMMGR schemas, java and shell programming 

Functional tasks involved - Configuring JDA Demand & Fulfillment modules, analysis of new functional features for implementation, functional analysis to resolve Forecasting and Replenishment issues related Orders and safety stock in the Supply Chain

Implemented JDA for establishing Supply Chain for products from Publix Manufacturing Plants supplied to Warehouses and Stores

Developed Custom Process to substitute JDA-Truck Load Building for building optimized Truck Loads

Worked in liaison with JDA for performance tuning of JDA jobs

 

Jul 2001 – Nov 2004:   JDA, Rockville, USA

Software Analyst 

 

SCPO Demand and Fulfillment are part of Supply Chain suite of Manugistics software. JDA Demand has capabilities of Multi-model framework, Forecasting, Event Management, Life Cycle Management and Event Modeling. Fulfillment is used for determining optimal product, planning and scheduling manufacturing and transportation loads and replenishes and optimize inventory throughout the distribution network.

Project                         : Product Development of Networks Demand, Fulfillment and General Systems 

Environment                : C, Java, HP-UX, Solaris, AIX, NT, Oracle 8x/9x, Perl, Shell

Manugistics Versions   : 5.x, 6.x, 7.x

Responsibilities             : Lead for technical and functional aspects of various features of Product                                             development of JDA (Manugistics) Demand and Fulfillment  

Designed and developed technical and functional specifications for major product releases

Worked with clients for trailblazer activities involving migrating JDA client databases and validating the solution before the General Availability release

Led a team of over 5 off-shore members for Product releases

Installation, Upgrades, Configuration and Performance Tuning of Webworks and SCPO applications for 7.x and 6.x versions for in-house use for various teams.

Maintenance of the databases including performance tuning using Import/Export, IGP imports, SQL loader and SQL scripts and other database administrative tasks

Executed modifications for JDA SCPO and Meta Data schemas for Demand and Fulfillment modules for 7.x and 6.x versions

Performance tuning including SRE tuning of JDA at Application, Database and Operating System levels.

Responsible for the development and execution of project plans, functional test plans for web-enabled Supply Chain Management products.

Worked with the Product Support team to identify and resolve client issues and expand test coverage accordingly, leading to a closed-loop continuous improvement in the existing test processes

Analysis of Demand Algorithms and Demand classification - Fourier, Lewandowski, Holt-Winters and Crostons

Development and Maintenance of JDA Demand and Fulfillment application releases for 5.4x, 6.x and 7.x versions using C, Java, Oracle SQL and PL/SQL Procedures and shell scripts

 

April 1999 – June 2001                                   

Ameritrade Inc, Annapolis Junction, USA

Software Engineer

Project             : Wireless Applications and Tradecast Integration

Environment    : C, C++, Java, Oracle, Perl, Tuxedo, Solaris

           

Ameritrade Holding Corporation is a pioneer in the discount and online brokerage industry. The company provides brokerage services and clearing services to self-directed individual consumer investors and other financial institutions. Tuxedo serves as an e-commerce transaction platform for building scalable 3-tier client/server high-performance and reliable applications in heterogeneous and distributed environments.

Analysis of Applications Integration with the acquired company – TradeCast

Developed C, Pro*C,  PL/SQL Procedures  and Java for handling Financial transactions

Improved performance of existing applications by using Host Arrays in Pro*C 

Developed Perl and Shell scripts along with SQL for extracting and formatting data

Designed and administered Queues for the incoming transactions

Made enhancements to application using Tuxedo FML buffers for increased performance

Designed and developed Scheduler and Interpreter modules as part of Work-Flow Manager to interpret and control the flow of ILN events for Job Processing.

June 1995 - April 1999

Software Analyst          CMC Ltd., INDIA

Project             : Supervisory Control and Data Acquisition (SCADA) – Power Systems.

Environment    : C, Oracle 7.3, Solaris

The SCADA product was developed for Electric Utility companies. The product has the following functionalities - Data acquisition, data processing, data logging, report generating, alarms and events generation, automatic and supervisory control and online configuration.

• Developed Entity relationship diagrams, functional flow diagrams and dataflow diagrams
• Designed and developed data service libraries using C, Pro*C and PL/SQL, Shell scripts
• Worked on Product maintenance and enhancement releases
• Implementation and customization of application for various Electric Utility Companies