Sangya Dhillon
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.
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.
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.
Assistant System Engineer
Tata Consultancy Services · Aug 2021 – Aug 2022
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
Skills 0 proven through work
Also works with
Proof of Work
Proof of Work
Sangya shares this with people who ask. You'll hear back either way.
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
Contact details
Contact details
Sangya shares this with people who ask. You'll hear back either way.
Ask about this candidate
AI responses may contain errors. Proof status and source information are provided by Proof of Skill.
A Proof CV — one profile, kept current, with the proof attached. Back to the portal