gurbaxbarhe

• Averted costs of $75,000 per hour from potential machine downtime by developing a Grafana annotation plugin that rendered real-time fault visualizations using TypeScript and Express backend • Accelerated root cause analysis of output material discrepancies for 50+ engineers by developing a package of analytical notebooks with pre-aggregated queries and regex string matching using PySpark • Streamlined factory OEE data quality and reporting by maintaining ETL pipelines in InfluxDB and Kafka • Developed an in-house Flux library for improved time series data analytics and logging from an MQTT broker • Exceeded expectations in task quality, execution, and delivery by coordinating with a remote team using Jira

• Resolved 80% of production data discrepancies between downstream tables in the primary ClickHouse cluster by writing test comparators with NumPy and MySQL queries • Reduced post time by 184% by developing a data chunker in Pandas that parallelized datasets in Airflow. Enhanced visibility of finances by reducing endpoint latency by 90% with optimized queries using FastAPI • Contributed to an in-house factory data platform by developing in React and designing Figma wireframes • Enabled 1000+ cell engineers to use production critical data by developing REST API endpoints in Python • Saved 200 hours by automating the data storage of 10,000+ Excel rows into JSON and MySQL using Pandas

• Powered 10+ Tableau BI dashboards for the C-suite by converting and sorting 99% of tabular data from physical data sheets into PostgreSQL tables using OCR, OpenCV, Camelot, and Pandas. • Reduced data entry time by 80% by digitizing documents with Tesseract-OCR and storing data in MongoDB. • Asynchronously migrated large MySQL datasets for 10,000+ users from on-prem servers to Azure Cloud. • Achieved 100% data accuracy by mentoring interns through the SDLC with a forum scraper using Selenium.