Data Analyst with SQL, BI & Dashboards Expertise

K GANESH

Scranton, PA ************@*****.*** +1-272-***-****

Professional Summary

Data Analyst with 4+ years of experience transforming complex datasets into actionable insights for clients in financial and technology sectors. Expert in SQL, Power BI, Tableau, Python, and Excel, with a strong track record in dashboard development, data storytelling, root-cause analysis, and stakeholder collaboration. Skilled at tackling ambiguous problems, improving data quality, and delivering scalable analytics solutions that drive business decisions.

Technical Skills

Data Analysis & Visualization: SQL, Python (Pandas, NumPy), Excel, Tableau, Power BI, Looker, KPI Dashboards Data Operations: Data Cleaning, Transformation, Validation, ETL Pipelines, Query Optimization Reporting & Analytics: Dashboards, Ad-hoc Reports, Root-Cause Analysis, Trend Analysis Collaboration & Communication: Stakeholder Engagement, Documentation, Executive Reporting Methodologies: Agile, Scrum, SDLC

Professional Experience

Data Analyst Goldman Sachs – Scranton, PA Aug 2024 – Present

• Developed and maintained Power BI and Tableau dashboards to track key operational and financial KPIs for executive stakeholders.

• Conducted SQL-based data extraction, transformation, and analysis to answer complex business questions.

• Performed root-cause analysis of anomalies and trends, providing actionable insights to leadership.

• Automated repetitive reporting processes, reducing manual effort by 40% and improving delivery consistency.

• Partnered with stakeholders to translate business questions into analytical solutions, including reports and dashboards.

• Ensured data quality and integrity across multiple sources, reducing reporting errors by 30%.

• Conducted hypothesis-driven analyses to uncover hidden trends and insights in financial and operational datasets.

• Documented analytical methods, dashboards, and workflows to ensure continuity and knowledge sharing.

• Troubleshot data discrepancies and pipeline issues in real-time, minimizing downtime and improving reliability.

• Implemented scalable and repeatable reporting frameworks, improving reporting efficiency and user adoption. Data Analyst JPMorgan Chase – India Jun 2020 – Jul 2023

• Built and optimized SQL queries and ETL pipelines for large-scale banking and operational datasets.

• Created Power BI dashboards and ad-hoc reports for operational performance, sales, and customer insights.

• Performed data cleaning, transformation, and validation to maintain high-quality datasets for decision-making.

• Conducted root-cause analysis of data anomalies, reducing recurring errors by 35%.

• Supported stakeholder queries with data-driven insights, enabling informed decision-making.

• Collaborated with teams to interpret ambiguous data problems and provide actionable solutions.

• Implemented automation of recurring reports, improving reporting speed and accuracy.

• Participated in SIT/UAT testing of analytics and reporting tools, ensuring data integrity before production deployment.

• Documented workflows, dashboards, and analysis methodology to maintain operational transparency.

• Delivered insights to non-technical audiences by translating complex analyses into clear, actionable recommendations.

Project Highlights

Client-Facing Operational Dashboards Goldman Sachs Designed dashboards integrating multiple datasets, improving executive decision-making efficiency by 40%. Automated Reporting & Data Quality Framework JPMorgan Chase Developed automated validation scripts and reporting pipelines, reducing errors by 35% and improving operational reliability.

Hypothesis-Driven Analytics & Trend Identification Performed exploratory and statistical analysis on complex datasets, uncovering actionable trends for client-facing teams.

Education

MBA in Business Analytics – University of Scranton Bachelor’s Degree in Business Analytics – The National College of Jayanagar, Bengaluru

Certifications

• Microsoft Certified: Azure AI Engineer Associate

• AWS Machine Learning Specialty

• TensorFlow Developer Certificate

• Kubernetes Application Developer (CKAD)

Contact this candidate