sanjay pranesh

Data Analyst

India (Coimbatore, Chennai) 4+ yrs exp 90 · Outstanding

About

Results-driven Data Analyst with 4+ years of experience transforming complex data into actionable business insights. Proficient in Power BI, SQL, Python, Excel, Power Automate, and VBA, with a proven track record of building end-to-end analytical solutions—from automated data pipelines to interactive dashboards. Passionate about leveraging data to drive strategic decisions and operational efficiency.

Skills & Expertise (27)

Power BI Advanced

8.5/10

Years Exp

SQL Advanced

8.0/10

Years Exp

DAX Advanced

7.5/10

Years Exp

Power Query Advanced

7.5/10

Years Exp

Python Advanced

7.5/10

Years Exp

Data Transformation Advanced

7.0/10

Years Exp

Data Cleaning Advanced

7.0/10

Years Exp

ETL Processes Advanced

7.0/10

Years Exp

VBA Advanced

7.0/10

Years Exp

Flows Report Design Drill-through Pivot Tables Data Modeling SQL Server process automation Excel Macros Pandas Matplotlib Power Automate Optimization Stored Procedures CTEs Joins NumPy Jupyter Notebooks Seaborn

Work Experience

Data Analyst

Geodis India Private Limited

Oct 2025 - Present

Develop and maintain Power BI dashboards providing real-time visibility into logistics KPIs, reducing manual reporting effort by ~40%. Write and optimize complex SQL queries to extract, transform, and load data from multiple operational databases for analysis. Automate end-to-end reporting workflows using Power Automate, eliminating repetitive tasks and improving data delivery timelines. Build Python scripts (Pandas/NumPy) for advanced data analysis, trend identification, and anomaly detection across supply chain data. Design and maintain Excel-based tools with advanced VBA macros, enabling non-technical stakeholders to run self-service reports.

Software Developer (Data & Analytics)

HCLTech

Sep 2021 - Oct 2025

Designed and deployed 15+ Power BI reports and dashboards across business units, enabling data-driven decision-making at all levels. Engineered automated data workflows using Power Automate, integrating SharePoint, Teams, and third-party apps to streamline operations. Wrote optimized SQL queries and stored procedures to support reporting needs, cutting data extraction time by up to 60%. Developed robust VBA macros and Excel solutions to automate manual processes, saving teams 10+ hours per week in manual work. Collaborated with cross-functional stakeholders to gather requirements, define KPIs, and translate business needs into analytical solutions. Conducted data quality checks and built data validation frameworks ensuring accuracy of dashboards and analytical reports.