Aditya Charan

Data & Analytics Analyst · BI and Technology Consulting

Gurgaon, India

@aditya_charan

0 followers

🎓 B.E. in Computer Science and Engineering at KIIT University · Graduating 2026

About

Data & analytics and technology consulting analyst with hands-on experience in BI, MIS, business development, and process improvement. Built SQL- and DAX-driven Power BI solutions on large datasets for international clients, translating stakeholder requirements into KPIs, dashboards, and automated workflows.

Experience

BI Developer Analyst Intern

Publicis Re:sources (Publicis Groupe) · Gurgaon

Apr 2026 – Jul 2026

Gathered reporting requirements and built end-to-end Power BI dashboards for booking SLA compliance and contract approval workflows. Engineered DAX measures, developed Power Query transformations, validated records with Excel, and automated recurring reports with SQL and Power Query.
Data Analyst Intern

SalesPyper · Gurugram

Oct 2025 – Mar 2026

Analyzed call, lead and conversion data to identify trends in sales performance. Built Excel and Power BI MIS reports tracking AI agent performance, campaign KPIs and lead funnels to optimize calling campaigns and improve conversion.
Business Development & MIS Executive

Internwave

Aug 2025 – Oct 2025

Drove month-over-month growth through structured outbound outreach, analyzed sales funnel data to find pipeline inefficiencies, and authored process SOPs for outreach and lead handling.

Education

2026

B.E.

KIIT University

Computer Science and Engineering (CSE) · 2022 – 2026

Computer Science and Engineering (CSE) · 2022 – 2026

Skills

3 to 6 months

SQL DAX

<3 months

R ETL Python PySpark Streamlit MS SQL Server Data Modeling LLM evaluation Business Analysis Prompt Engineering Azure Data Factory Process Improvement Workflow Automation Generative AI (ChatGPT, Copilot, Gemini)

Tools / apps / platforms

6 to 12 months

Microsoft Excel Microsoft Power BI

<3 months

MySQL AWS S3 Tableau Snowflake Databricks PostgreSQL Power Apps Power Query Atlassian JIRA Microsoft Fabric Microsoft SQL Server Microsoft Power Automate

Projects

Cloud ETL Pipeline & Sales Dashboard

AWS S3, PySpark, Snowflake, Power BI

Ingested, transformed and loaded sales data to power KPI monitoring.
GenAI KPI Assistant

Python, LLM API, SQL, Streamlit

Built natural-language question answering over a sales database with query guardrails and source-table citations.
Credit Card Customer Intelligence Dashboard

Power BI, SQL, DAX

Analyzed usage patterns, spend categories and customer segments on large transactional data to surface high-value customer behavior and risk indicators.
Procure-to-Pay Process Improvement

BPMN, Python, Power BI, Power Automate

Mapped As-Is and To-Be processes from an event log, identified bottlenecks and rework loops, and automated an approval workflow.
Microsoft Fabric Lakehouse - Sales Analytics

Fabric, Data Factory, PySpark, Power BI

Built a medallion pipeline on OneLake with an automated refresh, Direct Lake semantic model and role-based dashboard with row-level security.

Courses & certifications

Business Analysis Fundamentals · Alison · 2025
Corporate Governance · Coursera · 2025
Data Visualization with Power BI · Microsoft · 2025
Lean Six Sigma Yellow Belt
AZ-900 Azure Fundamentals · Microsoft
DP-600 Fabric Analytics Engineer · Microsoft
Microsoft PL-300 Power BI Data Analyst · Microsoft

Explore the Broxer community

💬 Q&A Ask about roles, salaries and interviews — and help others. 👥 Circles Join discussions on skills, companies and industries. 📰 Feed Follow updates and insights from the community.