Sandeep Solanki

About Sandeep Solanki

As a data enthusiast, I’ve had the privilege of developing and deploying machine learning models, constructing robust data pipelines, and designing insightful dashboards that significantly impacted business outcomes. My educational background includes a Master of Business Administration (MBA) with a specialization in data analytics and big data, as well as a Nano degree in Data Engineering with a focus on Microsoft Azure.Currently, at Reetech USA, I’m deeply engaged in several exciting projects. These include web scraping, reverse engineering, and dimensional modeling tasks, where I skillfully utilize tools such as Python, Beautiful Soup, SQL, and PostgreSQL. My previous role at Walgreens allowed me to enhance prescription refill predictions, leveraging the power of Azure Databricks and PySpark. Additionally, I crafted an insightful dashboard using Spark SQL. During my tenure at BDA, I conducted customer segmentation analysis using Gaussian mixture models and K Means Clustering, employing both R and Python and Snowflake.My proficiency extends to various technologies. I’ve also worked extensively with diverse data sources and platforms, such as Azure, AWS, GCP and Snowflake. My true passion lies in harnessing data to create innovative strategies and drive business growth.

Experience

1. Data Engineer

   Reetech

   Aug 2023 — Present · Dallas, TX, US

   Developed SSIS ETL pipeline for migrating data from BIM360 to eBuilder, enabling seamless data transfer from CSV files using ETL processes and data warehousing.• Demonstrated expertise in building robust and scalable SSIS package integrations using C# scripts, ensuring smooth data flow, automation, and synchronization.• Designed a custom API to facilitate the transfer of multiple projects from Autodesk BIM360, enhancing project management efficiency.• Designed and Implemented a Star Schema for Efficient Data Updates: Leveraged the principles of dimensional modeling to create a Star Schema• Automated Data Manipulation: Engineered Python scripts leveraging Pandas and Glob libraries for automated data manipulation and extraction to CSV, Text, and Excel formats.• Developed a web scraper using Python and the Beautiful Soup library to extract desired data from specific URLs.• Reverse engineered web technologies like JSON & HTML to provide organized data collection exporting to csv and excel.• Utilized the scraped data to generate insights and support decision-making processes.• Designed and Implemented a Star Schema for Efficient Data Updates: Leveraged the principles of dimensional modeling to create a Star Schema• Leveraged big data tools like Hadoop or Spark to process large datasets.• Developed ETL pipelines using Python and SQL for automated data extraction, transformation, and loading into a PostgreSQL database.• Automated Data Manipulation: Engineered Python scripts leveraging Pandas and Glob libraries for automated data manipulation and extraction to CSV, Text, and Excel formats.• Implemented software testing methodologies to ensure the robustness and reliability of products.Environment: Python, SSIS, Visual Studio, C#, SQL, Autodesk BIM360, PySpark, MS Excel, and Azure Databricks.

Education

• Delhi International School

  High School, Science and Computers

  2009 — 2010

• Udacity

  Nanodegree Program, Data Engineering with Microsoft Azure

• University of Michigan-Flint

  Bachelor's degree, Mechanical Engineering

• Kettering University

  Master of Science - MS, Mechanical Engineering /Automotive Systems

• Kettering University

  Master of Business Administration - MBA, Computer Science

• St. George's College

  High School, Science

  2000 — 2009

• Kettering University

  Master of Science - MS, Engineering/Industrial Management

Skills

• Microsoft Office
• Solidworks
• Ptc Creo
• Teamwork
• Public Speaking
• C++
• Social Media
• Matlab
• Mechanical Engineering
• Microsoft Excel
• Powerpoint
• Java
• Cad
• Leadership
• Pspice
• Minitab
• Research
• Microsoft Word
• Dfmea
• Fmea
• Computer-Aided Design (Cad)
• Management
• Finite Element Analysis
• Customer Service
• Project Management
• C
• Engineering
• Failure Mode and Effects Analysis (Fmea)
• Autocad
• Microsoft Powerpoint
• Team Management
• Python