Sangram Sawant

Results-driven Data Analyst with 1.4+ years of experience transforming raw datasets into actionable business insights. Proficient in SQL, Power BI, Excel, and ETL workflows with a demonstrated track record of building dashboards, and reducing manual effort. Adept at stakeholder communication, cross-functional collaboration, and translating complex data findings into clear recommendations. Seeking a Data Analytics role to apply skills in data visualization, statistical analysis, and reporting.

Technical Support Engineer at Pharmarack Technology Pvt. Ltd. (2022-01 – 2023-03)

Designed and maintained interactive Power BI dashboards, automated reporting workflows, executed SQL queries, and conducted root cause analysis on data anomalies.

• Designed and maintained 5+ interactive Power BI dashboards tracking KPIs such as ticket resolution rate, SLA compliance, and agent performance, enabling data-driven decisions for 3 team leads.
• Automated weekly and monthly reporting workflows using Excel (pivot tables, VLOOKUP), reducing manual report preparation time by ~40%.
• Executed SQL queries to diagnose backend data inconsistencies and resolve distributor order failures, improving first-response resolution rate by 25%.
• Conducted root cause analysis on data anomalies across distributor datasets, documenting findings in structured SOPs and process flowcharts used to onboard 17+ new Employees.
• Collaborated with development, QA, and sales teams to validate data integrity during UAT for 3+ product releases, ensuring zero data regression post-deployment.
• Analyzed support ticket patterns using Freshdesk data exports, identifying top recurring issues and contributing to a 20% reduction in repeat escalations.
• Engineered 900+ Regex patterns to automate data extraction from unstructured text files — recognized as Employee of the Month for this achievement.

Back Office Executive at Pharmarack Technology Pvt. Ltd. (2021-11 – 2022-01)

Ingested, cleansed, and standardized distributor stock and sales data from multiple formats into structured datasets for downstream analytics.

• Ingested, cleansed, and standardized distributor stock and sales data from 6 formats (PDF, Excel, HTML, Word, CSV, Text) into structured Excel datasets for downstream analytics.
• Maintained 100% accuracy on a daily work tracker with structured logging, supporting audit trails and data quality reviews.
• Reduced manual data entry effort by building reusable regex templates, cutting average processing time per dataset by an estimated 30%.

Bachelor of Engineering (B.E.) in Engineering – Keystone School of Engineering, Handewadi (2021-07 – 2025-06)

Diploma (MSBTE) in Engineering – Chh. Abhaysinhraje Bhonsale Institute of Technology, Satara (2019-07 – 2021-07)