Sangya Dhillon

Sangya Dhillon

+•• ••••• •••••••••••@•••••.com

Data Analyst · Bolsterbiz India LLP · 5 yrs

  • Open to Delhi · Noida · Gurgaon
  • Remote, Hybrid
  • In 30 days

Ask about Sangya

Skills

Claimed

Client FocusTransportation ManagementAzure SQL UsageReceiving and Incorporating FeedbackBusiness AcumenTeamworkStakeholder ManagementAdaptabilityRoot Cause AnalysisTechnical TroubleshootingKPI AnalysisInventory Management

Proof of Experience

Data Analyst

Bolsterbiz India LLP · Dec 2023 – Present

  • Built and delivered interactive Power BI reports tracking the customer order lifecycle with insights into orders, deliveries and invoicing.
  • Integrated, cleaned, and validated data from multiple internal and external sources and load into SQL database.
  • Achieved 98% data classification accuracy by categorizing merchant and product attributes, enabling faster retrieval and downstream reporting.
  • Enabled the business to optimize inventory and sales strategies, resulting in 12% increase in overall revenue and a 20% increase in sales of top-performing products.
  • Retail Sales data analyzed to identify consumer trends and purchasing behaviors leading to marketing strategies that boosted customer engagement by 15%.
  • Developed a Python-based solution to extract job data from 100+ company career websites using web scraping libraries.
  • Designed and implemented an SSMS schema for structured storage and easy querying of extracted data.
  • Automated the data pipeline to transform and load CSV files into SQL Server (SSMS) for centralized data.
  • Improved efficiency by eliminating manual data collection and ensuring up-to-date job information.
BolsterBiz

Data Analyst

BolsterBiz · Dec 2023 – Present

  • ➔ Streamlined data processes using advanced SQL, Achieved 98% accuracy in classifying merchant and product data, improving data retrieval efficiency.
  • ➔ Built and managed interactive dashboards in Power BI to support strategic decisions.
  • ➔ Delivered insights through clear and impactful reports, earning high client satisfaction and retention rates.
Tata Consultancy Services

Data Analyst

Tata Consultancy Services · Aug 2022 – Jul 2023

  • ➔ Developed end-to-end business intelligence solutions using Power BI to create impactful ETL processes and interactive dashboards.
  • ➔ Implemented data cleansing and validation processes to maintain high data quality standards, resolving inconsistencies.
  • ➔Created data models and analyses in Excel, integrating DAX and M Query for dynamic reporting, resulting in a 15% improvement in report accuracy.

Data Analyst

Tata Consultancy Services (TCS) · Aug 2021 – Jul 2023

  • Designed and maintained Power BI dashboards tracking supply chain KPIs (inventory, fulfillment, lead time), enabling evidence-based decisions for stakeholders.
  • Designed Expedites and Returns Dashboards to track premium shipments and associated costs optimizing shipping strategies.
  • Developed dynamic Excel-based MIS reports leveraging DAX formulas and M Query transformations, reducing manual reporting effort significantly.
  • Led cross-functional collaboration to identify process bottlenecks, driving a 15% improvement in supply chain operational efficiency.
  • Utilized Power BI, SQL & Excel to transform large datasets into meaningful insights, improving data accuracy and reporting quality.
Tata Consultancy Services

Assistant System Engineer

Tata Consultancy Services · Aug 2021 – Aug 2022

NETCAMP SOLUTIONS PRIVATE LIMITED

Student Intern

NETCAMP SOLUTIONS PRIVATE LIMITED · Jun 2020 – Jul 2020

  • At Netcamp| Gain experience in the concepts like :-
  • 1.Network Management
  • 2.Web development
  • 3.Android with core java

Proof-of-Work

No completed sessions yet. Anything Sangya finishes shows up here with the evidence behind it.

Proof of Education

Bachelor of Technology, Information Technology

Raj Kumar Goel Institute of Technology, Ghaziabad · 2017 — 2021

Advanced Certification, Data Analytics for Business

IIT Madras & Intellipaat · 2023 — 2024

Course, Microsoft Fabric

Grow Data Skills · 2025 — 2025

A Proof CV — one profile, kept current, with the proof attached. Back to the portal