Hello!

I'm Pragati Divekar



Data Analytics Engineer

LinkedIn Tableau Github Usecases



Name: Pragati Divekar

Interested Roles: Data Analyst/ Business Intelligence Analyst / Analytics Engineer / Business Intelligence Engineer

Experience: 4 Years FullTime (India) & 6 Months FullTime (United States)

Address: United States

Skills

Data Visualization
PYTHON
SQL
Statistical Analysis
Cloud

About

About Me

Hello! I'm Pragati, an Analytics Engineer based in California, United States, with over four years of professional experience in data analytics and business intelligence. I specialize in building scalable data solutions and transforming raw datasets into impactful insights that empower strategic decision-making across organizations. Currently, I’m working as an Analytics Engineer, where I design and implement robust data pipelines, automate reporting workflows, and develop analytics dashboards that support cross-functional teams. My work bridges the gap between engineering and analysis, ensuring data is not only accurate and accessible but also actionable. I hold a Master of Science in Information Technology and Management from the University of Texas at Dallas, and I’m passionate about continuous learning—always exploring new technologies and modern data practices to stay ahead in this ever-evolving field.

  • Profile: Business Intelligence & Analytics
  • Domain: Revenue & Sales,Inventory Management, Supply Chain & Retail Operations
  • Education: MS Information Technology & Management
  • BI Tools: Microsoft Power BI,Tableau,Google Analytics, Adobe Analytics & Excel
  • Databases: MS SQL Server, PostgreSQL, MongoDB, BigQuery, HDFS & IBM DB2
  • Programing: Python, R, SQL & HiveQL
  • Statistics: Hypothesis Testing, A/B Testing, T-test, Chi-square, Regression, Time Series, ANOVA & Classification
  • Certifications:IBM Data Analyst Professional Certification, Alteryx, AWS Cloud Practitioner & Google Analytics

Resume

Resume

Experienced Data Analytics Professional with 4+ years of experience designing and implementing data analytics solutions using Python, SQL, Tableau, and Power BI. Proficient at translating business requirements into scalable data pipelines, ad hoc reports, and dashboards that support operational efficiency and strategic decision-making. Proven expertise in data quality, data integrity, governance, ETL development, and stakeholder collaboration across cross-functional teams.

Check My Resume

Experience


Dec 2024-Present

Analytics Engineer

Fluent Inc
  • Leading cloud data migration from on-prem systems using Python, Docker, GCS, and BigQuery.
  • Built automated ELT pipelines and validation scripts to ensure >99% data accuracy across 20+ datasets.
  • Designed analytical data models and ER diagrams using star schema principles in BigQuery.
  • Developed 10+ Tableau dashboards for Retail, Supply Chain, Inventory and Revenue teams.

Aug 2023-Dec 2023

Business Intelligence Intern

Motorola Solutions
  • Implemented Financial Dashboards integrating Tableau with AWS Redshift Datawarehouse,to visualize impactful financial KPIs,resulting 25% enhancement in data-driven decision-making within the PMO team.
  • Leveraged advanced SQL techniques (Window Functions, CTEs, and Joins) to extract precise data of fleet and driver performance for data analysis.
  • Developed Regression models to forecast budgets and risks for the upcoming four quarters,achieving 15% reduction in budget variances & project risks.
  • Designed a scalable automation script to synchronize data between Google Sheets and Docs via Google App Script. This innovative solution minimized consolidation tasks by an impressive 60%.

Jun 2020- Jun 2022

Business Intelligence Analyst

Larsen & Toubro Infotech

Larsen & Toubro Infotech is a global technology consulting and digital solutions company which has merged with Mindtree, forming LTIMindtree, providing end-to-end IT services to clients across various industries.

  • Collaborated with stakeholders for requirements gathering across 6 business units for a data migration project.
  • Led data modeling and validation of 10M+ records, employing Python, SQL, and Alteryx for ETL operations to seamlessly integrate terabytes of datasets, ensuring 99% data quality and integrity, streamlining migration processes by 40%.

Aug 2018- May 2020

Data Analyst

Larsen & Toubro Infotech
  • Converted 30+ static Excel reports into real-time Tableau dashboards, reducing manual effort by 50%.
  • Transformed and cleansed data from SQL, APIs, and Excel using Python (Pandas), improving reporting accuracy by 20%.
  • Developed a Python-based Time Series Forecasting model to predict monthly ticket closure rates, leading to a substantial 45% improvement in operational efficiency.
  • Automated data refresh and report generation using Power Automate, cutting turnaround time by 50% and enabling real-time dashboard updates.



Education


2022-2024

Master of Science, Information Technology & Management

University of Texas at Dallas

GPA: 3.8

2014-2018

Bachelor of Engineering, Electronics

University of Mumbai

GPA: 3.7


Projects

Projects

Below are data analytics projects briefly describing the technology stack used to solve cases.

Data Visualization

Below are data analytics projects developed using Tableau.

Steps: data loading, data cleaning and preprocessing, and EDA (exploratory data analysis) & building Tableau Dashboard.

Skills: Calculated fields, LOD operations

Covid 19 Analysis

Analyzed Covid 19 data using Tableau to identify pandemic trends, geographical spread, and healthcare resource allocation.

Description: The dataset contains records of Covid-19 cases, deaths, and vaccine records by country in 2020-2021.

Customer Sales Data Analysis

Developed Tableau dashboard to perform customer sales data analysis using butterfly chart, a donut chart, a scatter plot and Histogram.

Description: The dataset contains records of Revenue, Region, Age,Gender,Discount and Category.

Tech Company Layoffs: United States

Showcased insights of recent layoffs happened in Big Tech Companys in United States..

Description: The dataset contains records of Layoffs by Month,sectors,industry and location.

Below are data analytics projects developed using Power BI.

Pizza Sales Report

The Pizza Sales Report provides insights into the busiest days and times, as well as sales performance, in addition to other relevant information.

Description: This dataset encompasses records of pizza categories, sizes, prices, orders, dates, and additional pertinent details.

Airbnb Insights

Delve into our comprehensive Airbnb dataset analysis,exploring key metrics such as Average Reviews Per Month,Room Types,total bookings, average prices, top hosts, and average prices by neighborhood and room type.

Description: The dataset contains records of Host details,Region,Price,Neighbourhood & Number of Reviews.

Superstore Sales

ABC Superstore operates across various locations in the United States, serving consumers, corporate clients, and home offices.

Their product range includes furniture, technology products, and office supplies, which are distributed from their stores to customers nationwide.

This project focuses on analyzing the sales performance of a fictional superstore, ABC Superstore, spanning the years 2014 to 2017 using Microsoft Power BI.

Python & R

Below are data analytics projects developed using Python & R.

Skills: data cleaning, data analysis, data visualization,Prediction Analysis

Technology: Python,Jupyter Notebook,Pandas,Seaborn,Matplotlib,R Studio

Diwali Shopping Analysis

Unlocking the secrets of Diwali shopping through Python analysis,delving deep into data to see the consumer behavior

Description: The dataset contains records of gender, age group, state,product category,marriatal status and profession.

Stroke Prediction Analysis

The primary goal of this project is to develop a prediction model that can accurately determine whether a patient is likely to suffer a stroke based on various input parameters.

Description: The data source include 12 input parameters and over 5000 observations.

Food Delivery Time Prediction

Aim of this project is to predict the delivery time (in minutes) for a food delivery app using regression models applied to the Food Delivery Dataset from Kaggle

Description: The data source include 20 input parameters and over 56992 observations.

SQL

Below are SQL projects for data querying and analysis.

Skills: MySQL, MS SQL Server, Pgadmin4

Pizza Sales Analysis

Analyzed Pizza Sales data by running PostgreSQL queries in Pgadmin4 to identify Pizza sales KPIs, (Daily,monthly & quarterly ) orders , Pizza sales by category & size

Description: The dataset contains records of Pizza name,size,category,revenue,order date & price.

Big Data

Below are HDFS projects for data querying and analysis.

Skills: Hive, Impala,HDFS,Tableau

Truck Fleet Data Analysis

As the fleet manager of AZ National Trucking, our foremost challenge is to ensure adherence to company regulations, aiming to reduce insurance risks. This encompasses tackling issues such as speeding, unsafe following distances, lane departure incidents, and other hazardous driving practices among our fleet drivers.

Description: The dataset contains 7 different data files such as Truck ,Truck mileage,Geolocation and more

Leadership & Awards

ITM Impact Award 0 Mentored Students

More projects on Github

I love to solve business problems & uncover hidden data stories


GitHub

Contact

Contact Me

Address

California, USA

Contact Number

+ 1 4692375682

Email Address

divekarpragati77@gmail.com