About
Highly analytical and results-driven Analyst with 3+ years of experience transforming complex data into actionable insights and streamlined reporting solutions using Excel, SQL, and Power BI. Proven ability to define key performance indicators (KPIs), automate reporting pipelines, and ensure data integrity, consistently driving strategic decision-making and operational efficiencies across cross-functional teams.
Work
Not specified, Not specified, India
→
Summary
Currently serving as an Analyst, focusing on developing performance reports, defining KPIs, and ensuring data quality to drive operational improvements and efficiency.
Highlights
Developed comprehensive business performance reports in Excel and Power BI utilizing DAX and Time Intelligence functions, leading to the development and measurement of key performance indicators (KPIs) and saving 10% in manual audit time.
Collaborated cross-functionally with IT and other teams to ensure robust data quality and facilitate effective business requirements gathering for enhanced reporting solutions.
Conducted weekly performance audits for multiple mills, leveraging Advanced Excel to generate critical metrics and share insightful dashboards/reports, identifying a 5% year-over-year increase in wastages and enabling targeted interventions.
Not specified, Not specified, India
→
Summary
Contributed as an Analyst, optimizing operational processes, designing interactive dashboards, and automating reporting pipelines to enhance efficiency and accuracy.
Highlights
Streamlined manual audit processes by strictly adhering to Amazon's Standard Operating Procedures (SOPs), including analysis of delivery routes and geocodes, which reduced delivery time by 10%.
Designed and maintained interactive Power BI dashboards, incorporating DAX and Time Intelligence functions, and implemented monthly row-level security (RLS) across 4 Weekly Business Review (WBR) tracks.
Automated 20% of weekly and monthly reporting pipelines using Power Query, eliminating 80 hours per month of manual effort, and wrote complex SQL queries for ETL operations, significantly improving reporting accuracy.
Collaborated with diverse stakeholders to translate business requirements into actionable Key Performance Indicators (KPIs), publishing and sharing critical reports via Power BI.
Skills
Programming Languages
SQL, Basic Python.
Databases
PostgreSQL, Oracle.
Data Visualization & BI Tools
Power BI, Excel (Advanced Formulas, Pivot Tables), DAX, Time Intelligence.
Data Analysis & ETL
Data Analysis, KPI Development, Business Requirements Gathering, Data Quality, ETL Operations, Power Query, Performance Analysis, Metrics Generation.
Process Improvement & Operations
Standard Operating Procedures (SOPs), Manual Audits, Outlier Detection, Operational Efficiency, Process Automation.
Reporting & Communication
Business Performance Reports, Interactive Dashboards, Row-Level Security (RLS), Stakeholder Collaboration, Report Publishing.