Neha Pawar

Impactful Projects and Initiatives:

1. Automated Unprocessed Orders workflow: Streamlined the unprocessed orders workflow by automation which reduced manual effort by 108 hrs./year while improving data accuracy and reporting.

2. System Glitch Impact Mitigation: Identified and addressed orders placed due to a system glitch, resulting in the prevention of $7 million in inventory loss.

3. SQL Query Optimization for Improved Efficiency: Reviewed and optimized SQL queries to reduce execution time, and enhance overall efficiency for better outcomes.

4. Power BI Reports: Developed 'In-Transit Orders,' 'All Open Orders,' 'Inventory Aging,' 'Sales,' and 'Rail Sighting for Rail Car Orders' BI reports to track key metrics across the organization, enabling leadership to visualize and monitor orders by age bucket.

5. Oracle Implementation: Supported the implementation of the Oracle Supply Chain Management ERP system, driving integration and customization that optimized operations and improved efficiency by 22% within the first quarter of deployment.

Key Responsibilities and Contributions:

• Supply Chain Optimization: Successfully analyzed and optimized end-to-end supply chain processes, resulting in a reduction in lead time and improved delivery efficiency.
• Demand Forecasting and Inventory Controls: Developed and maintained demand forecasts using historical data, achieving 85% accuracy in predicting customer needs, and ensuring optimal stock levels. Led initiatives in inventory control, improving stock turnover, while re-balancing excessive inventory.
• Cross-Functional Collaboration: Worked closely with onshore partners, procurement, and finance teams to align supply chain strategies with overall business goals. Also, I collaborated with the IT team to implement and troubleshoot SCM software systems, improving data accuracy and visibility.
• Post-Go-Live Support & System Enhancements: Drove continuous improvement initiatives by identifying bottlenecks and inefficiencies in the Oracle ERP system to better align with evolving business needs, resulting in a 60% improvement in process flow.
• UAT Testing: Executed rigorous User Acceptance Testing (UAT) on the Oracle SCM system, identifying and rectifying over 30 critical bugs before production deployment, minimizing disruptions to supply chain operations by 40%.
• ServiceNow Ticket Management for Bugs Resolution: Logged and monitored identified bugs through SN tickets (80+ Tickets). Also, coordinated with respective teams to ensure prompt resolution and system optimization.
• Process Improvement Strategies: Led process improvement initiatives that resulted in enhanced efficiency, cost savings, and streamlined operations.

• Caterpillar Ohio Site (Inventory & Finance Modules): Utilized the SDLC methodology to develop cloud-based modules for Caterpillar, enabling the maintenance and monitoring of inventory and finances in alignment with their specific requirements.
• Caterpillar Monark Site Finance Module: Developed a finance module for the Monark site to track key financial KPIs and serve as a centralized solution for monitoring all P&L transactions related to the inventory managed at the site.
• Identified, analyzed, and interpreted trends or patterns in complex data sets. Extracted data from the client's server (IMB, SQL, Data Warehouse Server), and interpreted data patterns to translate findings into actionable outcomes.
• Expertise in all phases of the Software Development Life Cycle (SDLC), from discovery to delivery, with a specialized focus on design and architecture, using data visualization tools and SQL queries.
• Managed communication with clients to update the product and implementation status at technical and functional levels. Worked closely with cross-functional teams to define and prioritize feature requests.
• Supervised deployments, providing troubleshooting, and user support. Provided support during customer implementations and applied best industry practices.

• FMCG Projects Executed: 'Hindustan Unilever,' 'Minute Maid,' and 'H-E-B.'
• Key Food Chain Sector Projects: 'Taco Bell,' 'Red Lobster,' and 'Domino's.'
• Automobile Industry Projects: 'Mazda,' 'Lexus,' and 'Toyota.'
• Additional Client Projects: 'AT&T,' 'HULU,' and 'Heineken.'
• Used various market research tools and techniques to gather, analyze, and interpret data. Developed questionnaires, and facilitated focus group discussions.
• Performed thorough data QC checks on collected market research data to ensure its accuracy, completeness, and reliability, to derive conclusions.
• Detected and flagged any inconsistencies, outliers, or errors in the data, working closely with the concerned teams to resolve issues before proceeding with the analysis.
• Provided process improvement feedback based on QC findings, leading to more accurate and efficient data capture in future projects.
• Provided analysis reports by studying consumer behavior and preferences to help businesses tailor their products, services, and marketing efforts.