Default profile banner
PT

Parag Tippannawar

@ParagT

Data Analyst - Inventory Management at India Bazaar

Navi Mumbai, Maharashtra, India

https://paragtip.wixsite.com/

India BazaarUniversity of Texas at Dallas

Parag T is a hands-on professional building SQL- and Python-based data pipelines and transforming multi-source data into modeled tables, dashboards, and KPIs across retail and tolling domains. He is proficient in SQL, Python, Snowflake, BigQuery, Tableau, and AWS/GCP, with experience optimizing queries and workflows. He holds an MS in IT Management from UT Dallas and is focused on delivering trusted, reusable datasets that power analytics and business decisions.

Experience

Data Analyst - Inventory Management

India Bazaar

Aug 2025 - Dec 2025Dallas, Texas

Reconciled vendor invoices vs NetSuite using Excel/SQL for high-volume stores, cutting mismatches 15–20%. Analyzed NetSuite aging and expiry logs to identify slow/damaged stock, enabling targeted pricing/discount actions. Consolidated NetSuite inventory, sales, and expiry data into analysis-ready tables using SQL and Python. Created shared Excel trackers for vendor contacts/pending invoices. Recommended low-traffic stock counts enabling accurate physical inventory. Streamlined processes adopted as baseline inventory workflow by other stores.

Business Data Analyst

Zifatech LLC

Jan 2025 - Jul 2025Dallas, Texas

Defined KPIs/dashboard mockups via client requirement sessions documented in JIRA/Confluence, cutting business-tech clarification loops 20%. Built Excel/Sheets dashboards with auto-pull cloud data and filters, reducing ad-hoc requests 25%. Executed SQL queries for SKU/channel extraction and shaped them into reusable query logic. Documented reporting specs with client sign-off in Confluence.

Data Analyst – BI Intern

Electronic Transactions Consultants

May 2023 - Aug 2023Richardson, Texas

Contributed to Jaspersoft to GCP Looker/BigQuery migration by mapping legacy reports to new datasets for tolling metrics, improving extraction efficiency 40%. Optimized 10+ BigQuery SQL pipelines using partitioning/indexing, reducing average query times 30%. Developed multiple Looker dashboards with alerts for tolling anomalies/maintenance.

Education

University of Texas at Dallas

Master of Science

Information Technology and Management

May 2024

University of Mumbai

Bachelor of Engineering

Mechanical Engineering

Jun 2021

Skills

Python
Pandas
NumPy
SQL
R
Advanced Excel
Tableau
Power BI
Looker Studio
Hadoop
Spark
Hive
AWS (S3, EMR)
GCP BigQuery
Azure
MySQL
PostgreSQL
Snowflake
MongoDB
Oracle
NetSuite
Python ETL
Airflow
Shell Scripting
Git
GitHub
CI/CD