Pranay Gawas

With a Master’s in Data Analytics Engineering from Northeastern University and a comprehensive work history, including my recent role as an Analytics Engineer at Mimecast, USA, I have honed my skills in transforming raw data into actionable business metrics. I've designed and maintained modern ELT data pipelines, specifically using DBT and Snowflake. 
My proficiency in SQL is well-complemented by my hands-on experience with Python and a range of business intelligence tools, including Tableau and PowerBI. 

I have a rich background in data engineering, having served as a Data Engineer (Analytics) at Mimecast, USA, and previously as a Data Engineer at Technomax Enterprises Pvt Ltd. At Mimecast, I designed and maintained automated modern ELT data pipelines using DBT(SQL) and Snowflake, achieving a 35% boost in customer conversion rate and a 20% reduction in workload and costs. I played a pivotal role in cloud migration projects, focusing on streamlining the migration from SQL Server to Snowflake and integrating data from various sources to construct predictive data models. In my role at Technomax, I developed and applied dimensional modeling and data warehousing techniques, leading to a 25% decrease in storage costs and a 35% enhancement in data processing time. I built robust ETL pipelines using Alteryx and orchestrated them using Airflow, ensuring seamless data flow and efficient processing. Additionally, I identified and resolved issues in data quality and accuracy by communicating with multiple business end users, increasing data reliability and trust in data-driven decision-making within the organization.

I hold a Master of Science in Data Analytics Engineering from Northeastern University, where I specialized in courses such as Data Warehousing for Business Intelligence, Database Management and Design, and Machine Learning in Engineering, graduating with a GPA of 3.8. I also possess a Bachelor of Engineering degree in Mechanical Engineering from the University of Mumbai. Additionally, I have earned certifications including the AWS Solutions Architect Associate, Snowflake SnowPro Core, and dbt Fundamentals, enriching my technical acumen and enhancing my practical understanding of data analytics engineering concepts and tools.