Mahendran Chellamuthu

Sr Retail & Supply Chain Consultant at TCS (Mar 2009 – Current)

Career Objective

Obtain a challenging role in a dynamic organization to utilize my skills, knowledge, and experience to make a positive impact on the company's growth and success, while advancing my career.

Work Experience Summary

• 15+ years of IT experience in working on Retail & Supply Chain applications specific to Merchandising, Purchase Order Management, PI Management, Demand & Fulfillment, Store POS, JDA WMS, Oracle Demantra - RMS, & Pricing systems.

• Areas of expertise include Demand Planning, Forecast Analysis, Perpetual Inventory Management, PLSQL and good knowledge of Oracle Applications like ASCP, Purchase Order Management, Allocations/Transfers, Store & Sales Operations.

• Well-versed in integrating Oracle Demantra with diverse enterprise applications and data sources, ensuring seamless data flow and accuracy.

• Experience in developing Stored Procedures, Packages, Triggers, Materialized Views, Functions in PL/SQL.

• 6 years of Production Support and Development experience at onsite client location (Texas, USA, Period 2013 - 2019)

• Hands on experience with Oracle EBS, RMS – Item, Purchase Order, PISL, Demantra, JDA SCPO & JDA Allocation Integrations, GK POS solutions.

• Hands on working experience with ETL tools like Informatica, Oracle BI publisher.

• Enhanced and supported multiple in-house build applications in Merchandising, warehouse management and order fulfillment areas.

• Designed and developed various solutions using Oracle PL/SQL, Oracle Forms, C, Unix Shell scripting, PERL, SQL, Mainframe COBOL, JCL, IMS for Production bug fixes, Automation.

• Basic knowledge on AWS, GCP and IBM Chat bots

• Worked with various stakeholders like EDI, DCM, JDA, UPS.

• Played various roles like Support Analyst, Developer, Production Support lead, Technical Lead and Project lead.

• Hands on experience with ServiceNow, Remedy, Summit for incident, change and service request management.

• Hands on experience with Scheduling tools namely Control-M, CA Workstation, ESP.

• Used tools like Teradata, Oracle Toad, Putty, SQL developer, Hummingbird, Splunk, JIRA ad36ja@r.postjobfree.com +1-562-***-****

• Handled 10+ Peak seasons wrt Production Support for large US Retail clients in Supply Chain area.

• Extensive functional knowledge in Merchandising, PO, PI, DNF, Picking, Packing, Replenishment, Store Fulfilment, Store Receiving.

• End to End Project cycle experience with Water Fall and Agile methodologies. Project Details

Project JDA SCPO Implementation & Setting up - conglomerate new DC(RCDC) Description Implement JDA SCPO Demand & Fulfillment & Integrations – DSD Vendors Client Chedraui Group, USA

Duration/Location Sep 2023 – Current, USA

Role Sr Techno Functional Analyst/Consultant

Responsibilities

Understand facility design, create test plan, and execute system, integration and E2E testing. Lead UAT testing with Ops and Training teams.

Execute configuration tasks needed to support testing. Work with training, engineering, ops on defining scope of work instructions and SOPs. Log and track system issues in HP ALM system.

Create cutover plans for production Go-live.

Release Management

Skills/Tools JDA – SCPO, Oracle R12, 11I, JIRA, MS office, Oracle, Shell scripts, Summit, Control-M, SQL Optimizer, SVN

Project JDA SCPO Implementation

Description Implement JDA SCPO Demand & Fulfillment & Integrations – Warehouse Client Chedraui Group, USA

Duration/Location Aug 2022 – Sep 2023, Bangalore - India Role Techno Functional Lead Consultant

Responsibilities

Review FSD, TDD, CFD, BRD documents.

Work with tests leads to design test cases.

Clarify functional queries while executing test cases for ST, SIT and E2E Review test results and make sure it meets functional requirements Assist business users while executing UAT.

Prepare status report and report during client calls Skills/Tools Oracle Demantra V 7.3.1, JIRA, MS office, Oracle, Shell scripts, Summit, Control-M, SQL Optimizer, SVN

Project Application Stabilization and Enhancements Description

As part of Application Support and Maintenance, stabilize and enhancement supply chain, Demand & Fulfillment Oracle Demantra, Merchandising, Stores POS Applications. Client JCPenney, USA

Duration/Location Mar 2020 - Aug 2022, Bangalore - India Role Functional SME, Technical Lead

Responsibilities

Work business team to get enhancement requirements. Upgrade & Configure Demantra solution.

Create Series, Levels, worksheets for custom requirements. System setup and install Demantra to load dummy see data and perform configurations like Data Model, Series Levels, Engine Configurations.

Identify technical risks and suggest contingency / mitigation actions. Prepare Functional specifications and design requirements. Provide inputs for the design, development, and delivery of services. Lead the technical implementation and functions as a point of escalation Plan project deliverables and monitor progress against plan. Liaise with client and internal teams to identify issues and keep stakeholders updated on project.

Verify & analyzed forecast generation parameters like causal adjustments, Indicative gaps. Ensure verification of deliverables per functional specification. Skills

Unix, Informix, Perl, Splunk, Oracle, MySQL, AWS, C, PLSQL, Shell scripts, Summit, Control-M, SQL Optimizer, SVN

Projects

1. Oracle RMS Item, Demantra Implementation

2. Oracle RMS PO Implementation

3. Mainframe Modernization

4. JDA Allocation Integrations

5. Demand Chain Management (DCM – Teradata)

6. EDI Integrations.

Description Various Retail & Supply chain projects to meet OMNI Business requirements Client JCPenney, USA

Duration Dec 2015 - Mar 2020

Role Functional SME, Senior Developer

Responsibilities

Understand business requirements based on BRD.

Create FSD and TDD documents. Get sign off from all stakeholders. Work with vendors like Oracle, JDA, Vestcom, Teradata & TCS COE. Develop code as per business requirements and carrier requirements Clarify requirements to junior developers.

Perform Unit testing and assist testing teams to execute SIT, E2E Prepare status report and share it all stakeholders. Work with EDI vendors to get the new suppliers onboarded. Skills Unix, Informix, Perl, Oracle, Informix 4gl, C, ProC, PLSQL Projects Application Support and Maintenance

Description

Production Applications Support and Maintenance - L2/L3 for Merchandising & Assortment Planning & Pricing Apps

Client JCPenney, USA

Duration Oct 2009 - Nov 2015

Role Support Analyst, Support Lead

Responsibilities

Incident Management as part of L2

Problem Management as part of L3

Analyze re-occurring issues and propose fixes to stabilize the applications Identify potential issues for automation and performance improvements Get business requirements for new enhancements.

Develop as per industry standards and implement in production. Prepare applications to handle Peak volumes.

Provide daily status reports all stakeholders

Skills

Mainframe, COBOL, DB2, JCL, VSAM, IMS, CICS, Teradata, HP Non Stop, Tandem, Unix, Informix, Perl, Oracle, Informix 4gl, C, ProC, PLSQL, Remedy, JDA WMS, Sterling OMS, Oracle BI

Awards

• On the Spot Awards

• (S)miles Award

• Contextual Master Award

• Technical Excellence Award

Competencies

Name Proficiency Level

Digital : Splunk E0

Digital : Amazon Web Service(AWS) Cloud Computing E0 Digital : Machine Learning E0

Business Domain – Retail E1

Advanced Supply chain Planning E1

Digital: Amazon Connect E1

ORACLE SQL E1

Continual Learning L2

Unix Shell Scripting E2

Certifications

• Google Cloud Certified – Cloud Digital Leader

• RiO : Soft Skill for Application Operation Team Members Intermediate

• Certificate in Retail Domain

• Transcend Bachelors - Architecture Certificate

• Unix/Linux basics and commands Foundation

• Oracle Retail Intermediate.

• Mainframe Practitioner

Personnel Summary

• Full Name: Mahendran Chellamuthu

• Education: Bachelor of Engineering with Specialization in Electrical and Electronics (2004-2008), Anna University, Chennai, India

• Marital status: Married

• Current location: LA, California-USA

• US Visa Details: H1B with Approved I140

• Training Period: Mar 2009 – Sep 2009 at Trivandrum ILP Center, India

Contact this candidate