Employee Reimbursement Dashboard (prompted by "Perplexity labs")
Designed an interactive Power BI dashboard for employee reimbursement tracking using Perplexity Labs.
Automated data cleansing and currency conversion to streamline reporting accuracy.
Integrated dynamic visuals and filters to reveal
key spending and approval trends.
Enabled stakeholders to analyze transactions and optimize expense management decisions.
AtliQ Sales Report
Designed interactive sales performance dashboards using Power BI.
Leveraged Power Query, Pivot, and DAX for data modeling and KPIs.
Compared regional market performance against targets.
Delivered actionable insights to support
data-driven decision making.
AtliQ Finance Report
Created financial reports including Profit & Loss and variance analysis.
Demonstrated financial storytelling to improve strategic planning.
Streamlined Excel-based reporting processes with formulas and automation.
Communicated
key insights effectively to stakeholders.
Project Priority Matrix
Helps evaluate and prioritize key initiatives using a structured scoring system.
Projects are scored on Feasibility (success likelihood), Impact (business value), and Size (effort needed).
Enables identification of high-impact, low-effort
"quick wins" and high-risk, high-reward projects. with formulas and automation.
Used for strategic planning, resource allocation, and aligning projects with organizational goals.
Scenario Planning Tool
Built an Excel-based Scenario Planning Tool for financial forecasting.
Analyzed Best, Realistic, and Worst Case scenarios for product sales performance.
Automated calculations for sales, discounts, COGS, and gross margin against targets.
Enabled data-driven decision-making by comparing profitability across scenarios.
Finance & Top N Insights (SQL) (Ongoing)
Used advanced SQL to automate financial reporting in the CPG domain.
Built stored procedures, UDFs, and views for efficient data analysis.
Delivered key insights on top-performing segments and KPIs.
Strengthened SQL optimization
for large-scale reporting pipelines.
Supply Chain Analytics (Ongoing)
Conducted error analysis for demand forecasting using SQL.
Created helper tables and optimized queries with triggers.
Evaluated supply chain KPIs like forecast accuracy and fulfillment rate.
Improved model performance through
calculated absolute error metrics.
Business Insights 360(Ongoing)
Simulated real-world analytics project covering multiple business domains.
Built end-to-end dashboards in Power BI based on mock client requirements.
Practiced project environment setup, reporting, and delivery lifecycle.
Gained
exposure to stakeholder communication and agile workflows.
Telecom KPI Analysis(Ongoing)
Evaluated 5G launch impact for a telecom company (Wavecon).
Analyzed pre- and post-launch KPIs like ARPU, TAU, and churn rate.
Developed a structured KPI comparison dashboard.
Presented insights via a stakeholder-focused summary
on LinkedIn.
Insurance Industry Dashboard(Ongoing)
Created a Power BI dashboard to analyze insurance industry metrics.
Utilized DAX and data modeling to visualize customer segments.
Focused on revenue trends, risk factors, and customer retention.
Delivered insights tailored
to underwriting and strategy teams.
Microsoft Fabric Pilot Project (Ongoing)
Migrated Power BI dashboards into the Microsoft Fabric ecosystem.
Utilized Dataflows, OneLake, and Pipelines for ETL orchestration.
Gained experience with Lakehouse architecture and Fabric features.
Built scalable data workflows
tailored for enterprise analytics.
Hospitality Data Analysis(Ongoing)
Performed in-depth hotel industry analysis using Python and Pandas.
Conducted EDA, transformation, and visual storytelling for key trends.
Analyzed operational data to uncover insights on revenue and occupancy.
Applied statistical
methods to support data-driven recommendations.
Expense Tracking System(Ongoing)
Built a full-stack expense tracking app using Python, FastAPI & MySQL.
Developed a Streamlit-based UI for real-time data visualization.
Enabled users to categorize, filter, and monitor expenses efficiently.
Implemented analytics
on monthly and category-wise breakdowns.
