Supply Chain Project

RESUME

Debashree Sinha

Email: *****.*********@*****.***

Mobile: +1-408-***-****

Current Location: Santa Clara, CA

Visa Status: H1

7.5+ years of overall experience in the IT industry with hands-on experience in executing multiple

projects, as a Techno-Functional Analyst/Technology Lead

Working with Apple in Sunnyvale, California as Techno-Functional Analyst from Infosys Technologies

Worked with Kraft Foods Inc at Chicago, Illinois as a Techno Functional Consultant from Infosys

Technologies.

Co-ordination with various Business/OEM/Supply Demand Planners/Material Managers/Global

Supply Managers across geographies.

Rich development experience in customization of various ERP like JDA Manugistics 7.4 SCPO,

Kinaxis RapidResponse 9.5.1, 10.2

Strong experience on QlikView reporting tool to develop, design dashboards and scorecards.

Proficient in using Autosys and Control M.

Extensive experience in Unix Shell Scripting, PL/SQL programming, Perl programming

Performance Tuning using Oracle Query Tuning.

Data acquisition, data ETL, data cleansing, data mining, data integration and analytical programming.

Implemented Business Process Impact Analysis using SDLC best practices.

Demonstrated ability in identifying best practices of various Source Code Control systems, involved in

suggesting them to the customer.

Excellent team handling skills. Have extensive experience of organizational/project management skills

and managing cross-functional teams.

Consistently rated as a top team player, Infosys SPOT Award.

ERP : JDA Manugistics 7.4 SCPO, Kinaxis RR 9.5.1, Oracle IOP

Database/Environment : Oracle 8i / 9i / 10g / 11g, AIX Unix Server

Programming Languages : PL/SQL, Oracle Query Tuning, XML, HTML

Scripting Languages : Unix

Tools : TOAD 10.5, SQL Developer, Autosys, Control M, Vi editor

Source Control : Visual Source Safe, Sub-Version

Domains : Retail, Manufacturing, Supply Chain Management

1

Debashree Sinha

Project 1: Supplier Portal

Scope: Build a Supplier Portal to grant access to OEM Supplier and Buyers for demand notification and supply

commit.

The business logic resides at the backend system based on Unix and Pl Sql whereas the front end Portal is a Java

application.

Project 2: Clear To Build

Scope: Build a Supply Chain Visibility solution to enable Apple to collaborate with their manufacturing and

material supply partners.

At the core of this solution is the tool, Kinaxis, that will generate a Clear-To-Build forecast for Apple Material

Management and Procurement teams.

Functional Domain : Procurement, Sales and Operation, Supply Chain Management

Role : Techno-Functional Analyst, Technology Lead

Environment : AIX Unix Server, Oracle 10g/11g

Responsibilities:

Understand the business requirements and legacy systems of Apple, involving interaction with

business teams from Apple.

Coordination with the OEMs and Suppliers in China to get the transactional data for further

processing in Back end system for the report generation.

Rich Experience with extracting and generating reports with data mining capabilities.

Design and development of architectural enhancements

Applied various performance tuning methods to speed up the data retrieval process like using bulk

collect mechanisms, hints, distinguishing between driving tables in joins, function based indexes.

Worked on data migration activities like invoking Export, Import and Data pump from the UNIX shell

script.

Wrote UNIX shell scripts to automate database activities like deploying schema objects and validating

the same.

Suggested various alternatives to improve Business Processes.

Excellent experience in Debugging, Bug fixing and enhancement of existing module.

Guided QA Team for Test Case preparation

Review deliverables from the offshore/onsite team and mentoring them

Creation of training materials and troubleshooting guides after each release for Support team as well as

Apple Procurement team.

Conducting Defect Prevention meeting and Knowledge management sessions for the team.

Environment:

Oracle Database 11g, PL/SQL, Unix /AIX, Vi Editor, SQL*Loader, SQL*Plus, OmniGraffle, OmniPlan,

Subversion, Kinaxis RR 9.5.1, Windows Remote Desktop, Mac OS, AGILE, Splunk, Oracle IOP, Autosys

2

Debashree Sinha

Project : KIDS Supply Chain

Scope: Enable the utilization of customer direct data within Kraft’s supply chain to enhance forecasting

capabilities and generate a more accurate customer forecast.

For this multi-vendor PoC (first time in Kraft Foods history), JDA Manugistics generated the most accurate

forecase, and hence was the chosen tool for this implementation.

Functional Domain : Fulfillment/Demand forecasting, Supply Chain Management

Role : Techno-Functional Analyst/Technology Lead

Environment/Technology : Manugistics 7.4 SCPO, AIX Unix Server, Oracle 9i

Responsibilities:

Perform Business Requirement Analysis with Business Owners within Kraft Foods Inc.

Understand Legacy Systems and other interconnected systems within Kraft from where data has been

extracted.

Architected various optimal solutions on various design and technical issues.

Extensive customization of JDA Manugistics 7.4 SCPO.

Rich experience on analyzing Plan Analysis Sheet.

Excellent experience in Debugging, Bug fixing and enhancement of existing module.

Used QlikView reporting tool to generate forecast reports, which was later used in Data Analysis.

Created pivot tables in MS excel for generating reports for each vendor

Maintenance of Control M jobs.

Conducting Defect Prevention meeting and Knowledge management sessions for the team, including

mentoring/onboarding newer team members

Environment:

Oracle Database 10g, SQL, PL/SQL, Unix /AIX, Vi Editor, TOAD, SQL*Loader, SQL*Plus, MS Visio, Excel

Pivot tables, Qlikview reporting, Control M, Visual Source Safe, JDA Manugistics 7.4, Windows XP.

Project : Customer Demand Replenishment

Scope: Integrate Customer Demand Signal Information, which is a key enabler to the Kraft’s demand driven

Supply Network Strategy, to increase Kraft’s forecast accuracy.

Functional Domain : Fulfillment/Demand forecasting, Supply Chain Management

Role : Software Developer

Environment/Technology : JDA Manugistics 7.4, AIX Unix Server, Oracle 9i

3

Debashree Sinha

Responsibilities:

Design and development of architectural enhancements

Customization of JDA Manugistics 7.4 SCPO

Preparation of LLD documents

Resolving various issues at various phases of the project within the defined SLA

Guiding the QA team in test case preparation for my developed modules.

Created the DML scripts to populate sample data in Dev and Test environment to support the needs of

the DEV and QA teams.

Developed Stored Procedures for carrying out transformations on data and loading target tables.

Creation of database objects like tables, indexes, stored procedures and views etc.

Suggesting technical improvements to the onsite team for implementation

Organizing Peer to Peer review sessions and KM sessions.

Environment:

JDA Manugistics 7.2, Oracle Database 8i, SQL, PL/SQL, Unix /AIX, TOAD, SQL*Loader, SQL*Plus, MS Visio,

Windows NT/ 2000 Server.

Bachelor of Technology, National Institute of Technology, India (2002-2006)

Debashree Sinha

4

Contact this candidate