Mihir Bharat Limbachia

College Station, Texas 979-***-**** advetf@r.postjobfree.com

EDUCATION

Texas A&M University, Mays Business School College Station, Texas, USA Master of Science in Management Information Systems May 2024 Dhirubhai Ambani Institute of Info and Comm Technology Gandhinagar, Gujarat, India Bachelor of Technology in Information and Communication Tech May 2018 EXPERIENCE

Amazon Bengaluru, Karnataka, India

Solutions Engineer, Amazon Advertising March 2021 - July 2022

Developed ETL jobs to analyze API usage events data and delivered data views to reduce ad-hoc query costs by 35%

Built a QuickSight dashboard to visualize API usage metrics and help Technical Account Managers provide proactive support to over 100 enterprise partners

Performed adhoc data analytics for program managers resulting in effective client engagements of over 30 advertising partners

Amazon Web Services Bengaluru, Karnataka, India

Cloud Engineer, AWS Analytics July 2018 - March 2021

Provided technical consultation to over 200 customers on building scalable, fault tolerant and high performing cloud infrastructure

Optimized an enterprise client's data pipelines architecture and reduced end-to-end latency by 60% through effective data partitioning strategy and improved configuration of consumer applications

Authored 20+ internal articles and public-facing video to deflect support cases worth over $5000

Mentored 7 new hires and conducted training sessions to improve customer satisfaction score by over 15% LEADERSHIP

Dhirubhai Ambani Institute of Info and Comm Technology Gandhinagar, Gujarat, India Student July 2014 - May 2018

Organized coding competition during college technical fest in 2015; Participation of over 100 students TECHNICAL SKILLS & CERTIFICATIONS

Languages: Java, C, Python, R, JavaScript

Frameworks: NodeJS, AngularJS, ReactJS, Spring Boot

Databases: MySQL, PostgreSQL, MongoDB, DynamoDB

Big Data Tools: Spark, Kafka, Airflow, Flink

AWS Cloud Services: Kinesis, RedShift, Athena, Glue, Elasticsearch, MSK, DynamoDB, EMR, RDS

Data Visualization Tools: Tableau, QuickSight

Certifications: AWS Data Analytics Specialty, Udacity Data Engineer Nanodegree PROJECTS

Advertising API Usage Statistics Dashboard

Developed PySpark ETL jobs to generate minute level aggregated API usage metrics and cut costs by 35%

Created QuickSight Dashboard to visualized errors rates for each partner, identified API clients with high error rates and collaborated with TAMs to ensure below 1% error for enterprise partners Music Streaming Application Data Warehouse

Devised a star schema data model consisting of a fact table and 4 dimension tables with optimal distribution strategy to minimize query workload execution time

Built an ETL pipeline using Apache Airflow to load data incrementally on a daily basis from the S3 bucket to the tables created in Redshift data warehouse

Twitter Sentiment Analysis Pipeline

Devised a ETL pipeline to extract real time tweets mentioning specific user accounts, conducted sentiment analysis and stored results in Kafka

Generated minute level average sentiment score in spark streaming application and identified negative tweets to enhance social media monitoring

Contact this candidate