Resume of Blue Yonder Technical Architect

 PEN191

Summary

• Over 16+ years of consulting experience implementing Supply Chain solutions –Blue Yonder SCPO [Supply Chain Planning & Optimization].
• For the last 1.5 years has been working exclusively with Kinaxis RapidResponse as a Technical/Integration Consultant.
• Extensively worked on the Technical Design, Technical Specifications, development of the Oracle PLSQL Scripts and Shell scripts, BY SCPO Upgrades.
• Managed customer relationships very well by leading the technical activities of projects.
• Led the Technical Team for various implementations.
• Actively worked in all phases of the project – Design sessions, Building Prototypes, conduct Data Mapping sessions, Writing Technical specifications, developing the Oracle PLSQL scripts, Testing – (Unit testing, System Integration Testing, Performance Testing and UAT), Designing of Nightly Batch Jobs, Deployment Strategy for the production environment, Go-Live activities & Post Go-Live support.
• Acted as a liaison for coordinating various project activities with cross functional teams.
• Upgraded the BY (Blue Yonder) SCPO through BY provided Batch scripts, PLSQL scripts and related utilities.
• Modified the Custom PLSQL scripts & updates to Batch design to be compatible with the latest version/ solution design of the (upgraded) SCPO.
• Knowledge and experience   with                    Installation,          Post-Installation, Patch                    install and Configuration of BY SCPO in Windows, UNIX and Linux platforms
• Designed and Implemented the Batch Scheduling
• Proficient in automating jobs using Windows batch scripting and Unix shell scripting
• Working knowledge of enhancing the performance of PLSQL Scripts by tuning and following best practices
• Proficiently used Toad, SQL PLUS, SQL Developer for interacting with database
• Good communication, team, interpersonal and judging skills, which facilitate effective communication with functional and technical teams.
• Conducted SCPO Technical Training session in Poland to train JDA Poland CoE (Centre of Excellence) Team.

Technical Skills

Operating System: Windows, UNIX AIX, Linux

Programming Languages: Oracle PLSQL, Java

Scripting Languages: UNIX Shell Scripting, Windows Batch scripting, Perl

Database: Oracle – 19c, 12c, 11g & MYSQL

 BY Products:

• SCPO v2022, v2019, v2018, v2016, v9, v82, v81, v8, v78, v77, v76, v751, v742
• Foundation/Platform v2022, v2019, v2018, v2016, v9, v82, v81, v8, v78, v77, v76, v751, v742
• Demand v2022, v2019, v2018, v2016, v9, v82, v81, v8, v78, v77, v76, v751, v742
• Fulfillment v2019, v2018, v2016, v9, v82, v81, v8, v78, v77, v76, v751, v742
• Enterprise Supply Planning v2022, v2016, v9
• Demand 360 v2019, v9
• Dynamic Allocation v2019
• Sequencing v2017
• Monitor v78, v77, v76
• Collaborate v82, v78, v74
• Inventory Optimization v2016, v78

 

Tools: Toad, Putty, SQL Developer, WinSCP, WinCVS, Tortoise SVN, HPALM, Control-M, IBM TWS, Automator and Eclipse

Hands on Experience: Perl Scripting

Project Summary:

Tree House Foods – BY Demand & ESP Implementation v2022

Tree House Foods is a multinational food processing company specializing in producing private label packaged foods headquartered in Oak Brook, Illinois.

Description: BY SCPO Implementation v2022 (Demand, Enterprise Supply Planning).

Role: BY SCPO Technical Architect / Technical Delivery Lead

Responsibilities:

• Lead the technical delivery of the implementation of Blue Yonder Demand & Supply.
• Reviewing User stories with business team and provided technical inputs wherever needed.
• Delivered the Technical design document for the implementation.
• Conducted the data mapping session to identify the data needs, data source from THS enterprise systems and mapping it to BY target fields.
• Review of the development of scripts, batch framework and provided necessary feedback from optimum solution & performance perspective.
• Lead through the System Integration Testing – liaising among THS Analytics, THS Business, THS IT, BY Cloud & BY Implementation Teams.
• Preparation & execution of the cut-over strategy for the go-live.

CVS Pharmacy – Dynamic Allocation v2019

CVS Pharmacy is currently the largest pharmacy chain in the United States by number of locations and total prescription revenue.

Description: Dynamic Allocation Implementation.

Role: BY SCPO Technical Architect / Technical Delivery Lead

Responsibilities:

• Participated in requirement sessions and provided input wherever needed.
• Identify the inbound and outbound interfaces and worked with Informatica & Mainframe teams to review the details.
• Designed the technical aspect of the BY Dynamic Allocation
• Created the development plan & the technical specifications
• Developed the Oracle PLSQL and Shell scripts
• Reviewed the code and provided the feedback for modifications/corrections/enhancements
• Created Visio for the technical design and the batch flow to illustrate the future state
• Lead the System integration testing and supported the UAT
• Identified the gaps/modifications needed in the existing flow to accommodate DA
• Created the deployment strategy for the technical go-live
•  Prepared the plan for Performance Testing to identify tuning opportunities.

Hallmark – BY SCPO v2019 Implementation - Peningo Systems, Inc.

Hallmark is the oldest and the largest manufacturer of the greeting cards in the USA

Description: SCPO v2019 Install

Role: BY Technical Architect / Technical Delivery Lead

Responsibilities:

• Setting up the Environment: SCPO v2019 application install with 5 Managed Nodes, Cluster configuration in AWS Cloud for both DEV & Test instances.
• Verified prerequisites and worked with Hallmark IT to address the gaps identified
• Enabled WebLogic SSL and Disabled non-SSL ports
• Configured the Webserver & configured the SSO configuration
• Documentation of the steps performed & conducted the KT sessions

CVS Pharmacy – Multi-Echelon - Peningo Systems, Inc.

CVS Pharmacy is currently the largest pharmacy chain in the United States by number of locations and total prescription revenue.

Description: SCPO – Custom Build – Calendars enhancement (ShipCal, TransCal, ArrivCal)

Role: JDA Technical Architect / Technical Delivery Lead

Responsibilities:

• Converting the custom logic of building Shipment Calendars and Transportation Calendars from Informatica data maps & workflows into PLSQL code.
• Modification to the batch flow to enable the daily calendar feed
• Design and solutioning the ArrivCal solution to address the lead time variance among regular shipcal and multi-echelon shipcal. This avoided a major rework on the mainframe side and huge gain to the project.
• Developed, Unit tested and performance testing of the ArrivCal solution.

CVS Pharmacy – BY SCPO Upgrade v9 to v2019 - Peningo Systems, Inc.

CVS Pharmacy is currently the largest pharmacy chain in the United States by number of locations and total prescription revenue.

Description: SCPO Upgrade (Demand, Fulfillment & Order Optimization) from v9 to v2019.

Role: JDA Technical Architect

Responsibilities:

• Setting up the Environment: SCPO v2019 application install, Cluster configuration and post install steps.
• Migrated the v9 DB to v2019 and validation of the upgrade performed.
• Performed the metadata comparison i.e., comparison & analysis of DB objects to come up with the list of changes to be done to existing batch jobs and configuration.
• Worked with CVS IT on running the base line batch and supported the same.
• DML & DDL analysis of the migration scripts and apply performance tuning changes wherever applicable.
• Designed and developed the data sync strategy with the goal of causing least outage to Production Environment for cutover by syncing the data in the new PRD w.r.t old one.
• Configured the application to be in compliance with SSL end to end encrypted communication – WebLogic, DB TCPS, Webserver.
• Supported UAT and resolved issues wherever occurred.
• Driven the go-live strategy discussions and cut-over detailed plan.

KOHL’S – BY Demand & Fulfillment Implementation v2018 - Peningo Systems, Inc.

Kohl's is an American department store retail chain with 1000+ locations, it is one of the largest department store chains in the United States

Description: Implementation of Demand & Fulfillment v2018.

 Role: JDA Technical Architect

Responsibilities:

• Participated in the detail design sessions
• Worked with Kohl’s IT on System integration strategy and JDA Data needs for the solution
• Conducted data mapping sessions, discussed with various Kohl’s team on business rules for data extractions.
• Acted as a liaison between Kohl’s and JDA cloud.
• Prepared the Technical Design Document and wrote Technical Specifications.
• Development of the Custom Scripts and working with the functional team for the testing.
• Reviewed the code developed by the offshore team

MARS – Orion Pet Care

Mars, American global manufacturer of confectionery, pet food, and other food products  Description: Deployment of Orion Global Template for SCPO v2016 and deploying global template for JDA Sequencing v2017 for Pet Care business.

Role: JDA Technical Architect

Responsibilities:

• Reviewed the existing JDA Fulfillment v8.1 solution, identifying gaps w.r.t existing template, designed and wrote specifications for the same.
• Deployment of the Orion Global template (JDA SCPO v2016) for Pet Care business
• Participated in Mapping, Design sessions for the implementation of Demand Sensing signal and integration with E2O (MDS, MIO) systems.
• Wrote specifications and developed the interfaces between JDA FF and E2O systems.
• Performed testing and supported the system integration and business integration testing.
• Modified template batch as per new technical design to include the E2O integration.
• Upgraded JDA Sequencing from v8.0 to v2017 for the Pet Care Sequencing models.
• Deployment of Orion SEQ template for sequencing application.

MARS – Orion Sequencing

Mars, American global manufacturer of confectionery, pet food, and other food products  Description: SCPO Upgrade v8.1 to v2016. Develop a global template for JDA Sequencing v2017.

Role: JDA Technical Architect

Responsibilities:

• Performed the SCPO upgrade v8.1 to v2016. Resolved the referential integrity, orphan data issues and cleanup of application objects as part of the migration.
• Reviewed the legacy v8.0 Sequencing – technical design, interfaces, custom code and identify the opportunities for improvements and enhancements.
• Analysis of SEQ v2016 vs v2017: Platform based vs Citrix based
• Installation and configuration of SEQ v2017 and performed the migration of JDA SEQ v8.0 to v2017.
• Worked with Business to define the inbound & outbound interfaces
• Wrote the Technical Specifications for the interfaces, custom functionality defined by business.
• Performed the Model Imports, troubleshooting the errors reported by Schedulers & worked with JDA support to resolve the application bugs.
• Coordinated with multiple teams to prepare the cutover plan with dependencies and prerequisites.

 MARS – ATLAS Pet Care

Mars, American global manufacturer of confectionery, pet food, and other food products  Description: Conversion of the existing locations from legacy ERP system – PRMS to new ERP system – SAP.

Role: Deployment Analyst

Responsibilities:

• Perform the Location Conversion to convert the existing master data and all the downstream data from old PRMS location to new SAP location.
• Wrote Technical Specifications for the functional requirements identified as gaps.
• Supported the end-to-end validation: inbound data validation, existing custom logic and outbound data transfers to external systems.
• Supported the System Integration Testing & Business Integration Testing.
• Resolved the data related issues wherever occurred.
• Supported the environment, user configuration and nightly batch.
• Actively lead the Production Deployment planning – analyzing various dependencies, sequence of tasks & coordination among the teams
• Conduct Knowledge transfer sessions to core services team.

HEB – BY Inventory Optimization

HEB Grocery Company is an American privately held supermarket chain based in San Antonio, Texas, with more than 350 stores throughout the U.S. state of Texas, as well as in Mexico.

Description: BY Inventory Optimization v2016 Proof of Concept

Role: Technical Architect

Responsibilities:

• Worked with the HEB Business to identify the data source for building the JDA IO environment for Proof Of Concept
• Performed the Data Load of files extracted from external systems into JDA IO and worked with Business to resolve the data discrepancies wherever occurred
• Installed, configured and supported the JDA IO v2016 application.
• Executed the IO related SRE Processes and resolved the issues wherever occurred
• Wrote one-off custom SQL scripts.
• Supported the UAT.

Mattel – BY Demand 360 and ESP Implementation

Mattel is an American multinational toy manufacturing company with headquarters in El Segundo, CA. The products & brands it produces include Fisher-Price, Barbie, Hot Wheels etc.  Description: JDA Demand 360 v9 and JDA ESP v9 Implementation

Role: Technical Architect

Responsibilities:

• Designed the Technical aspect of the Implementation and delivered the Technical Design Document
• Prepared the Development Plan and acted as a liaison for various Technical Tasks
• Developed the custom PLSQL scripts and Shell wrapper scripts
• Reviewed the code developed by offshore and provided the feedback to enhance them.
• Coordinated with Mattel IT, Business & JDA Cloud teams to configure the application
• Worked on Scenario Management: Defined the Scenarios, required Custom Processes and Process Chains and performed unit testing of the same.
• Designed the Batch Scheduling based on various inputs and worked with Control-M team to configure the required scheduling.
• Supported the UAT and Nightly Batch.
• Worked on production deployment strategy and go-live check list.

 Exide Technology – BY SCPO & Collaborate v82 Upgrade

Exide Technologies is a global provider of stored electrical energy solutions—batteries and associated equipment and services for transportation and industrial markets  Description: JDA SCPO and JDA Collaborate Upgrade from v76 to v82

Role: Technical Architect

Responsibilities:

• Participated in the Design sessions for the upgrade.
• Performed the Application Install and Migration of the Database from v76 to v82.
• Wrote the Technical Specifications for new JDA Demand design and enhancements as per the latest solution design for v82.
• Developed and unit tested the PLSQL, SQL scripts and windows BAT scripts.
• Redesigned the Batch Schedule for the nightly and monthly batch jobs.
• Worked closely with the Business team to support the data validation and resolved the defects.
• Provided the Batch support for the scheduled jobs and worked on resolving the Batch errors.
• Prepared the Deployment plan for production environment built and cut-over activities.

Cabela’s – JDA SCPO v81 Implementation

Cabela's Incorporated is a direct marketer and specialty retailer of hunting, fishing, camping, shooting, and related outdoor recreation merchandise, based in Sidney, Nebraska.

Description: Implementation of JDA SCPO v8.1

Role: Senior Technical Consultant – Onsite / Technical Lead

Responsibilities:

• Involved in gathering the requirements using functional specifications and client specified documentation
• Worked with Functional teams and Customer’s Business to address any gaps and obtain clarification on the requirements wherever needed
• Lead the Project Technical Activities
• Acted as a liaison for various project activities
• Wrote the Technical Specifications for the Functional modules
• Developed the Oracle PLSQL scripts, Packages, Procedures, Functions, Triggers, Sequences, Synonyms and other DB objects
• Created test cases and performed unit testing and integration testing
• Designed the JDA Nightly Batch jobs by identifying the sequence, dependencies and frequency of run
• Worked with customer’s IT, Business, QA, DBA, App Admin teams for various project activities.
• Supported the Nightly Batch and resolved issues wherever occurred
• Tuned the SRE Jobs and long running SQL jobs
• Planned the deployment strategy for building the production environment

Airgas – JDA SCPO Upgrade

Airgas, Inc., is the largest U.S. distributor of industrial, medical and specialty gases (delivered in packaged or cylinder form), and hard goods (welding, safety and related products).

Description: JDA SCPO Upgrade – v742 to v81

Role: Senior Technical Consultant – Onsite / Technical Lead

Responsibilities:

• Performed the migration of JDA SCPO v742 to v8.1 through JDA provided SQL and Batch Scripts.
• Acted as a Liaison coordinating various activities with the off-shore team
• Modification of the existing Oracle PLSQL scripts and Shell scripts of SCPO v742 as per the new technical design and performed the testing of the same.
•  Performed the System Integration Testing and supported the User Acceptance Testing.
• Coordinated with Customer’s IT, Business teams and worked with JDA Cloud Services for various activities and resolving environmental issues.
• Designed the production deployment plan – incorporated various steps involved, right from building the environment to post go-live activities.
• Developed the shell scripts for maintenance of the environment.

MARS - JDA SCPO NA Consolidation

Mars, American global manufacturer of confectionery, pet food, and other food products

Description: Consolidation of the two JDA SCPO v76 environments into one i.e. Consolidating Mars’ North America Chocolate JDA Instance & US Pet related JDA instance into one JDA Instance

Role: Senior Technical Consultant – Onsite / Technical Lead

Responsibilities:

• Gathered the requirements for merging the NA Chocolate and US Pet JDA instances and designed the technical aspect of the Database Consolidation
• Developed the consolidation scripts to merge the data using DB Links from both the databases into one respecting the business rules, integrity constraints & other business provided criteria
• Analysis of the common Database Objects, Application Objects and reconciled the differences based on the inputs from Business users
• Actively lead the Production Deployment planning – analyzing various dependencies, sequence of tasks & coordination among the teams
• Designed the Nightly Batch Jobs for the consolidated environment
• Executed the Batch through IBM - TWS and supported the same.

ACE Hardware - JDA SCPO Upgrade

ACE, Leading Hardware stores in the USA

Description: Upgrade of the JDA SCPO from v742 to v78. Addition of new functional modules involving PLSQL Scripting

Role: Senior Technical Consultant - Onsite

Responsibilities:

• Worked on Installation and Configuration of JDA SCPO 7.8
• Migrated the Oracle Database from SCPO v742 to v78 through JDA provided PLSQL and Shell scripts by resolving the data issues wherever occurred
• Wrote the Technical Specifications for the new functional modules
• Developed the PLSQL Scripts for the new custom functionality.
• Modifications of the existing PLSQL, Shell scripts as per latest Technical Design and to make it compatible with v78
• Developed interface related scripts – shell scripts & SQL Loader scripts
• Performed the Unit Testing, System Integration testing and supported the UAT
• Actively participated in designing the day-end batch processing and supported the same.
• Prepared the production deployment strategy with the migration and master data load.
• Planned and executed the Go-Live activities and provided post Go-Live support

McKesson (Formerly PSS World Medical) - JDA SCPO v78 Implementation

PSS World Medical is a leading national distributor of medical supplies and equipment to office-based physicians and long-term health care providers.

Description: JDA SCPO v78 suite Implementation Role: Technical Consultant – Onsite

 

Responsibilities:

• Participated in the Design sessions, Data Mapping sessions and requirement gathering
•  Wrote the Technical Specifications as per the functional specifications and customer provided documentation
• Onsite Coordinator for Managing and Delegating Tasks to offshore
• Was responsible for preparation of the unit test cases.
• Worked as a development lead at the client end coordinating the onshore and offshore activities.
• Performed code review of PL/SQL scripts delivered by off-shore team
• Developed the PLSQL Scripts for the custom requirements
• Developed the Shell Scripts for Interface related jobs and automation of the custom and standard jobs
• Performed the Unit testing, System Integration testing, Quality Assurance testing by working with various teams: Offshore development team, Onsite Functional team, PSS IT Team, PSS Business Team
• Designed the Batch scheduling for configuring the nightly jobs
• Supported the nightly batch jobs and resolved the issues wherever occurred.
• Worked on building the Production Environment and loading the initial master data
• Worked on Go-Live activities and provided the Post Go-Live support.