Sushmit Richard Email & Phone Number

Toronto, Ontario, Canada

• Developed a Power BI Reorder Report Dashboard: Built an interactive dashboard that integrates multiple data sources to generate reorder recommendations for client stores. This tool automated the analysis of slow-moving products and produced PDF reports, significantly reducing manual reporting time and improving reorder decision accuracy across all product categories.• Created a Reconciliation Report for Financial and Sales Metrics: Automated the reconciliation of key financial and sales data, such as units sold, units purchased, and total sales using Power BI. Integrated producer discount data into the analysis, enhancing client decision-making processes regarding product sales, pricing, and purchasing strategies.• Built a Competitor Analysis Dashboard for Real-Time Market Insights: Designed a dynamic competitor analysis dashboard that scrapes, cleans and transforms SKU data from major cannabis stores in Ontario and other Canadian provinces. The dashboard provides real-time updates on price changes, new product launches, and market positioning, empowering clients to stay competitive with live insights visualized in Power BI.

Toronto, Ontario, Canada

• Set up and architected a flexible PostgreSQL server on Azure, transitioning from manual Excel-based data management to a centralized database system, which streamlined the collection, storage, and processing of client data, improving the efficiency of downstream analysis and reporting, reducing processing times from hours to minutes.• Utilized Python and its ML libraries for in-depth data analysis which enhanced strategic decision-making by replacing manual analysis methods, improving the inventory management and sales strategy formulation.• Automated the extraction, cleaning, and transformation of data using Python, and integrated with Tableau for live data updates, cutting down the time to generate detailed weekly reports on sales, inventory, and reorder data from several hours to mere seconds, enhancing report accuracy and timeliness by over 75%.

Toronto, Ontario, Canada

• Developed a data preprocessing pipeline using Python and OpenCV for Hyperspectral Images and masks, handling 11GB of Image Data, ensuring noise removal, image alignment, and spectral normalization.• Designed and trained 29 CNN models for mineral classification using TensorFlow and Keras, achieving classification accuracies between 72-89% through hyperparameter tuning and regularization techniques.• Led project management tasks including drafting Statement of Work (SOW), managing project timelines using Gantt charts, developing communication plans, risk mitigation strategies, and providing regular status reports to stakeholders.

Kolkata, West Bengal, India

• Technical Work (in SAP Master Data Governance): - System Integration Testing with External Business systems like Salesforce, GTS, PLM Teamcenter and other client-specific 3rd party systems- Data and Process Modelling- Configuration of Data Replication Framework (DRF) for Finance, Customer and Supplier Master Data- BRF+ (Business Rules Framework Plus) configuration to trigger Rule-Based Workflow Approval processes for data creation and maintenance- Data Migration for Financial Accounting and Controlling Master Data- Configuration of Data Consolidation processes for Customer, Supplier and Product(Materials) Master Data.• Client-facing Role:- Organized weekly workshops to understand the data architecture of the business and identify and gather requirements to address the key pain-points followed by technical feasibility assessment of the requirements- Engaged with key stakeholders by organizing End-to-End playback sessions. The feedback received from them helped to identify the gaps in the build and resulted in change requests improving the quality of deliverables and proving to be a crucial step in de-risking the Business Validation Testing- Liaised with the client throughout the Business Validation testing facilitating the resolution of 40+ defects critical for go-live- Delivered knowledge transfer sessions to the client super users ensuring that they understand the solution design and functionalities of all the key deliverables• Functional Role:- Sprint planning and resource allocation for build, testing and mock data loads- Drafting Solution Design Documents for all Master Data Governance Processes- Drafting Functional Specification Documents for Custom Objects (workflows, code enhancements, interfaces and reports)- Drafting Configuration Rationale Documents for all config changes- Preparing decks to present status reports and progress trackers.

Kolkata, West Bengal, India

Technical Work -1. ABAP Development for multiple client specific SAP reports.2. Configuration of SAP Fiori Apps.3. Drafting Technical Specifications for code enhancements and reports.

Jamshedpur, Jharkhand, India

Steam Boiler Operations and Mechanical Maintenance.

Master Of Management, Artificial Intelligence, 7.47/9.00

Activities and Societies: GBC Athletics Running Club AI EarthHack Competition 2024 Microsoft RAG HackTogether 2024Major Courses Taken.

Bachelor Of Engineering, Mechanical Engineering, 8.62 Cgpa

Activities and Societies: • Core Member of Events team, Bitotsav, the Annual Cultural Fest of BIT Mesra. • Workshop Head at Dhwani, Music.

High School, 93.2% (Isc 2016) & 94% (Icse 2014)

Education record