Mayur Shrotriya

Data Scientist

Zelarsoft Pvt. Ltd.•  November 2022 - Present•  Hyderabad, TS, IN

Skills Used: Data Analytics, Data Engineering, Data Visualization, Machine Learning, Cloud Ops, Microsoft Office, Presentation, Client Communication, Stakeholder Management. Tools Used: Python, SQL, Cloud Services: GCP & Azure, Power BI, Looker Studio, Tableau, Git. Major Projects: - Project 1: Designed and implemented an ETL pipeline for extracting, transforming, and transferring the data from multiple Google Sheets to BigQuery using Python as the programming language, Google Cloud Compute Instance as compute, and Apache Airflow as the Orchestration tool. Saved 12-14 Manhours daily. - Project 2: Undertook the development of WhatsApp messaging pipeline where the daily updates were sent to client's clients on an image through WhatsApp business API, using Python as programming language, Google Cloud Storage, Google Cloud Compute Instance as compute, and Mage.ai as Orchestration tool. - Project 3: Designed and developed an AI/ML algorithm to detect autism symptoms with 80% accuracy using Python as the programming language and deployed it using Google Cloud Compute Instance as compute and Prefect as Orchestration / Triggering / Monitoring tool. - Project 4: Developed a self-service Power BI Dashboard for an e-commerce company. Other Responsibilities: - Collaborated with cross-functional teams to ensure seamless integration of new technologies and solutions. - Provided technical guidance and mentorship to junior team members, fostering a culture of continuous learning and growth.

Graduate Engineer Trainee

AB Associates•  March 2021 - March 2022

Working in Business Process Excellence. Work include Designing of Lean Factory Layouts ranging from 40,000 - 5,00,000 sq. fts., Design & Development of the Excel Templates for the various processes such as Production Planning, Inventory Management, 7 QC Tools, etc., Building the VSMs, Building the Process Flow Diagrams, Applying Lean Tools in MSME Sector, Designing Workstations, etc..Working in Business Process Excellence. Work include Designing of Lean Factory Layouts ranging from 40,000 - 5,00,000 sq. fts., Design & Development of the Excel Templates for the various processes such as Production Planning, Inventory Management, 7 QC Tools, etc., Building the VSMs, Building the Process Flow Diagrams, Applying Lean Tools in MSME Sector, Designing Workstations, etc.. Skills: Data Analysis · Data Visualization · Microsoft Excel · Visual Basic for Applications (VBA)