SUMMARY:

• Over 15 years of hands - on experience in analyzing, designing, implementing Supply Chain Products
• Over 5 years of experience in Product Development of Confidential Supply Chain Products - SCPO- Demand, Fulfillment, Webworks and SRE
• Technical Architect for SCPO Implementations - Technical Design Docs from Functional Specifications, Installs, Patching, STSC & ABPPMGR Schema Configurations, UDTs/UDCs, IGP, FEs, CSM grants & roles, Batch setup - Oracle, SQL, PL/SQL, Unix, Shell Scripting, SQL Optimization
• Solution Configuration for Demand & Fulfillment and Order Promiser Products
• Hands-on Experience in debugging Confidential Processes - SCPO, SRE logs and Database tables, Oracle Tuning using Hints, Indexes, Explain Plan, SQL*Trace, TKProf
• Led Offshore Developments teams in Product Implementation with Design, Interfaces, Data flow and end to end nightly and Weekly Batch Flow Processing of Jobs

TECHNICAL SKILLS:

Operating Systems: Solaris 10, HP-UX 11x, AIX 4.x, Linux Ubuntu 16.04, Windows

Databases: Oracle12c

Languages: SQL, PL/SQL, Java, C, C++, Shell, Awk, Sed, PERL, Python

SCM: Confidential 7.x/8.x

Others: Toad, Oracle Enterprise Manager, TkProf, Query Analyser, Explain Plan

PROFESSIONAL EXPERIENCE:

Techno Functional Architect

Confidential, Chicago

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

Responsibilities:

• Confidential Applications - Demand, ESP, Order Promiser
• Binary Silent Installs & Configuration of Confidential 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

Technical Architect - Client Implementations

Confidential, Irving

Environment: Unix, Oracle 12c, SQL, PL/SQL, PERL & Shell Scripting

Responsibilities:

• Confidential Applications - Binary Silent Installs & Configuration of Confidential 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
• Confidential Application & Database Migrations including creation of Custom Tables & Columns
• Custom process to Extract, Transform & Load data from propriety enterprise application into Confidential
• Confidential 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

Confidential, Lowes, NC

Senior Technical Architect

Responsibilities:

Environment: HP-UX Unix, Oracle 11g, PL/SQL, Shell Scripting

Responsibilities:

• Develop Integration programs using Oracle PL/SQL Stored Procedures, SQL and Shell Scripts
• SQL & PL/SQL Tuning using Hints, Indexes, Explain Plan
• Design and Development of nightly and weekly Batch processing of Confidential Demand and Fulfillment Processes integrated with Custom processes using Shell Scripting
• Create High level and Low Level Technical Design Documents based on Functional Specifications and Design Documents
• Part of Performance tuning team for Confidential and Oracle to process few Million Skus during nightly Batch
• Confidential Schema Migrations, Creation of custom tables in Confidential schema and UI Configuration for FEs of Custom Tables.
• Confidential UI security configuration by creation of Roles and assigning to appropriate users.
• Training and Transfer of Knowledge to Confidential Offshore teams in India Supporting Lowes from Offshore.

Confidential, FL

Technical Consultant - Supply Chain Implementation

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

Responsibilities:

• Part of the Core team to implement Supply Chain strategy over six phases
• Managed scope and time of Confidential projects in each phase to implement demand forecasting and fulfillment planning
• Defined Use Cases for 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 Confidential warehouse Fulfillment to match the integration with store supply chain
• Technical duties involved - Managing Confidential 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, PERL & Shell programming
• Developed custom process for QA Team for Extracting Data from Text, CSV, Excel & XML files and importing to Database and Retrieving Data from Database to similar Files to test Core functionality of Demand and Fulfillment Processes.
• Functional tasks involved - Configuring Confidential 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 Confidential for establishing Supply Chain for products from Publix Manufacturing Plants supplied to Warehouses and Stores
• Developed Custom Process to substitute Confidential -Truck Load Building for building optimized Truck Loads
• Worked in liaison with Confidential for performance tuning of Confidential jobs

Confidential, Rockville

Software Analyst

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

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

Responsibilities:

• Designed and developed technical and functional specifications for major product releases
• Worked with clients for trailblazer activities involving migrating Confidential 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 Confidential SCPO and Meta Data schemas for Demand and Fulfillment modules for 7.x and 6.x versions
• Performance tuning including SRE tuning of Confidential 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 Confidential 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

Confidential, Annapolis Junction

Software Engineer

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

Responsibilities:

• 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.

Software Analyst

Confidential

Environment: C, Oracle 7.3, Solaris

Responsibilities:

• 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