Business Analyst Data

Ganesh Kamasani

Financial Business Analyst/Data Analyst

Pennsylvania, USA +1-272-***-**** ****************@*****.*** LinkedIn SUMMARY:

Results-driven Data Analyst / Business Analyst around 4 years of experience transforming complex data into actionable insights to support business decision-making. Skilled in data extraction, cleaning, visualization, and reporting using tools like SQL, Excel, and Tableau/Power BI. Adept at collaborating with cross-functional teams to gather business requirements, identify performance trends, and recommend process improvements. Strong knowledge of KPIs, business intelligence, and statistical analysis. Proven ability to improve reporting efficiency and deliver insights that enhance business outcome

TECHNICAL SKILLS:

Data Querying SQL (MySQL, PostgreSQL, Oracle, SQL Server) Data Handling Microsoft Excel (Advanced), Power Query Data Visualization Power BI, Tableau, Google Data Studio, Looker Studio Programming for Analysis Python (pandas, numpy, matplotlib, seaborn, scikit-learn) Statistical Tools R, Python (statsmodels, scipy)

ETL & Data Integration Alteryx, Talend, Informatica Business Intelligence Power BI, Tableau, Looker Studio Documentation Tools MS Word, Excel, Visio, Lucidchart Agile Tools JIRA, Confluence, Trello

Data Warehousing Snowflake, BigQuery, Amazon Redshift Workflow Automation Power Automate, Zapier

Version Control Git, GitHub

CRM/ERP Tools Salesforce, SAP, Oracle Fusion

API & Web Data REST APIs, JSON

EDUCATION:

MBA in Business Analytics Aug 2023 - May2025

University of Scranton

Bachelor's Degree Business Analytics Aug 2019 - Sept2022 National College Jayanagar, Bengaluru

PROFESSIONAL EXPERIENCE:

Financial Business Analyst Dec 2024 – Present

McKinsey & Company, USA

Collaborated with cross-functional teams to gather and document business requirements (BRDs, FRDs) for new product features and enhancements and SDLC; Created financial models, pivot tables, and data summaries using advanced formulas and charts; Automated routine data validation and reporting using VBA and macros; Used Excel for trend analysis, budgeting, and dashboarding in monthly reviews.

Conducted in-depth data analysis using SQL and Excel to identify customer trends and operational inefficiencies; Queried large datasets for analytics, report generation, and business rule validation; Built materialized views and indexing strategies to improve query efficiency.

Integrated PostgreSQL with ETL tools and visualization platforms for seamless data access; Created dashboards and reports using Power BI and Tableau to track KPIs and business performance. Used Python (Pandas, NumPy) for data wrangling, and feature engineering.

Supported Agile teams by writing user stories, maintaining JIRA boards, and participating in daily stand-ups and sprint planning; Generated weekly and monthly reports on financial performance, operational KPIs, and revenue; Designed automated reporting pipelines using SQL and Excel/BI tools; Delivered insights to stakeholders via scheduled emails and executive dashboards.

Facilitated stakeholder meetings to present findings, gather feedback, and align solutions with business goals; improved reporting accuracy and reduced ad hoc requests by 30% through the automation of weekly reports.

Used shell scripts to automate data extracts and transfers from secure sources; Scheduled and managed corn jobs for ETL and log maintenance tasks; Navigated the Linux environment for file operations, log analysis, and server checks. Developed test cases and scenarios for validating dashboards and SQL outputs.

Data Analyst June 2020 – July 2023

Logic Race, India

Followed SDLC principles to build data models, test reports, and deploy production-ready dashboards; Documented requirements, development, testing, change logs for reporting projects; Worked on UAT, and production environments for solution lifecycle management.

Queried and analyzed cloud-based data in Snowflake for reporting and ad hoc analysis; Built secure data sharing pipelines and scheduled tasks using Snowflake features. Tuned performance using clustering keys and role-based access controls.

Analyzed business processes and assisted in identifying automation opportunities using Excel and Power Query; Helped build interactive dashboards in Google Data Studio and Excel; Documented user requirements, change requests, and supported UAT activities.

Conducted financial modeling and scenario analysis to support strategic decision-making and capital planning. Ensured data integrity across Snowflake, PostgreSQL, and Excel sources, streamlining ETL processes and reducing data discrepancies.

Performed competitor analysis and presented market research insights to the product team; Created flowcharts and process maps using Lucidchart and Visio to support develoEpment and QA teams; Assisted in CRM (Salesforce) data cleanup and standardization project.

Contact this candidate