Sayantan Ganguly

About Sayantan Ganguly

As a Data Analyst at SynergisticIT, I design and create custom SQL queries to improve the performance and accuracy of the property price prediction dashboard, a key product for the company. With my skills in Python, Power BI, and Apache Spark, I extract, manipulate, and visualize large datasets, reducing query time and execution time by up to 25%. I also develop forecasting models to support accurate property price predictions, resulting in a 15% increase in prediction accuracy.I\'m pursuing a Master\'s degree in Analytics from Northeastern University, where I\'m learning advanced techniques in data science, statistical modeling, and machine learning. My education background also includes a Bachelor of Engineering in Civil Engineering from Birla Institute of Technology and multiple certifications in data analytics and data science from Cognitive Class and Coursera. Previously, I worked as a Data Analyst intern at Novelis and a Data Analyst at KPMG India, where I automated processes, enhanced customer loyalty, optimized inventory management, and produced reliable and insightful reports, among other achievements.I\'m passionate about turning raw data into valuable insights and driving data-driven strategies for better decision-making. I\'m eager to take on new challenges and contribute my expertise to your organization. Let\'s connect and discuss how we can leverage the power of data to achieve your business goals.

Experience

1. Data Analyst

   SynergisticIT

   Jan 2023 — Present · US

   Designed custom SQL queries to improve the performance of the property price prediction dashboard, resulting in a ~20% reduction in query time• Created forecasting models to support accurate property price predictions, resulting in a 15% increase in prediction accuracy• Wrote complex SQL queries to extract and manipulate large datasets, leveraging advanced query optimization techniques using Apache Spark, resulting in a 25% reduction in query execution time

Education

• Birla Institute of Technology, Mesra

  Bachelor of Engineering - BE, Civil Engineering

  2017 — 2021

• Northeastern University

  Master's degree, Analytics

• St. Xavier's School , Ranchi

  Secondary School Certificate , Matriculation Exam (Std 10)

  2004 — 2015

• Delhi Public School, Ranchi

  Middle School, Science

  2015 — 2017