Manas Deshmukh

Reported to SVP Technology & CTO of Citi bank's re consolation technology department,
I engendered and delivered entire dashboard layer (tableau) of re consolation reporting and analytics platform, this involved management of around 7 engineers including vendors
Key Participant in Data modeling and data architecture activities related to backend design
Performance tuned backend SQL and queries related to key use case and matrix of reporting and analysis platform
Conducted and delivered multiple POCs/MVPs on low code/ no code technologies like Apache Nifi and presented solutions to senior level Management

Technologies Used
SQL, Oracle, data modeling, Tableau server /desktop / Prep, Apache Nifi (Basic flow), Python (basic)

Interacting with Stake holders and understanding their business and requirements and translating to Team of 5 mates

Data mapping output from various tools to standard o9 Solutions Implementation Template for smooth implementation for successful implementation of 3 modules of o9 Solutions

Post implementation Analyzing and Validating various data sources streamlining business till handover to Customer Success Team

Used industry expertise, customer service skills and analytical nature to resolve customer concerns at earliest to reduce down time

Pro-track & People soft Metrics, Backlog Projection, Replenishment and Picking efficiency Dashboard, Repack Metrics, Container per order, Pick & Pass Dashboard developed in Tableau

Scorecard to evaluate individual performance in Tableau

Subscription to automated reporting and user-friendly alerts in Tableau

Automated weekly and monthly reporting in SQL / MS Access / Tableau Prep

Network Replenishment and Rebalancing model Designing Optimization

Automating & Reporting KPI for 15 DC’s dealing in Medical products with revenues of $4 Billion

Technologies Used

Excel, MS Access, SQL, WMS, LMS, Tableau Desktop / Server

Investigated processing errors and malfunctions, resolving issues with minor machine repairs.

Tested products or subassemblies for functionality or quality and troubleshot problems with equipment, devices, or products.

Standardized operating procedures to Forecast accuracy and minimize excess and obsolete.

Conducted root cause analyses for any deviations from established processes, developing action plans to prevent recurrence of issues.

Provide guidance and onboard new team mates

Technology Used

JIRA, Visio, SAP MM, SQL, Tableau

Contributed to development of annual budgets by providing accurate projections of material costs and requirements based on historical trends and anticipated future needs

Tracked placed orders to identify and resolve problems impacting OTD (on-time delivery)

Implemented cost-saving initiatives by identifying E&O and doing Network rebalancing

Presented KPI health in S&OP concuss meetings

Technology Used

Excel, MS Access, SAP MM, Tableau Desktop, In house Tools

Backlog Root Cause Analysis with corrective and preventive actions resulted in customer On-Time Delivery improvement by 12%

Analyzing historical forecast correcting Forecast method for high moving parts, resulting in improved accuracy from 62% to 67%

Coordinating with stakeholders and delivering actionable insights Dashboards on demand planning, Forecast Accuracy, MAPE & service level

Automated reports and created alerts for Excess parts redistribution to inventory deficit locations, resulted impact in constraining quarterly inventory budget achieving $0.8M saving

KPI reporting and presenting it to top management