Ganesh Lahane

About Ganesh Lahane

Seeking a Challenging Data Analyst & BI Developer Role. Passionate and results-driven Data Analyst with 3+ years of experience specializing in Teradata SQL, Power BI, Spotfire, DAX, and Excel. Skilled in designing and implementing efficient data solutions that enhance data quality, accessibility, and insights for informed business decision-making. With hands-on expertise in Power BI report and dashboard creation, I excel at visualizing complex data to help stakeholders make data-informed decisions. Core Strengths & Contributions: SQL for Data Analysis – Proficient in writing complex SQL queries for data extraction, manipulation, and reporting. Experienced in joins, subqueries, and window functions, ensuring precise and actionable insights that drive strategic decisions. Power BI Reporting – Adept at building interactive dashboards and reports that prioritize data accuracy, relevance, and usability. I focus on clarity and aesthetics to make complex data more digestible, improving operational transparency and strategic planning. Analytical & Problem-Solving Skills – Known for my analytical mindset and ability to resolve complex data issues efficiently. I leverage my technical expertise to troubleshoot, optimize, and innovate, enhancing efficiency and adding value to every project. Committed to continuous learning and improvement, I apply best practices in data engineering and analytics to build scalable and sustainable data infrastructures. My strong foundation in data analytics principles and excellent communication skills enable me to bridge technical and business requirements effectively, fostering a data-driven culture. Certifications & Key Competencies: Microsoft Certified: Power BI Data Analyst (PL-300) Strong expertise in SQL & DAX functions Solid understanding of data warehousing & data modeling concepts Hands-on experience with Power BI, Spotfire, and Business Intelligence tools Excellent communication & interpersonal skills Technical Skills: Key Areas: Data Analysis, Data Warehousing, Data Visualization, Data Modeling, SQL Scripting, Problem-Solving. Languages & Tools: SQL, Python, Core Java, Power BI, Spotfire, Excel, IBM IDA. Databases: Teradata.

Experience

1. Senior Systems Engineer

   Infosys

   Oct 2021 — Present · Pune, IN

   Project Role : Data Analyst/BI Developer.Responsibilities-Collaborated with business teams to understand requirements related to Banking Products (PCA, Credit Cards, Personal Loans, and Mortgages) and translated them into insightful data visualizations and reports.Identified trends and patterns in large datasets to improve business performance, executing complex SQL queries in Teradata using joins, groupings, window functions, subqueries, and set operations to extract relevant data for client reports.Integrated data from diverse sources, including Teradata databases and Excel files, ensuring comprehensive analysis. Transformed, cleaned, and prepared data using Power Query for analysis and visualization.Utilized DAX to create new calculated columns and measures, optimizing Power BI data models for enhanced performance and scalability, improving data retrieval and processing efficiencies.Designed, developed, and implemented interactive reports and dashboards using various visualization elements (line charts, bar charts, pie charts, cards, matrices, slicers, etc.), simplifying complex data for business teams and improving data-driven decision-making.Published and shared reports via Power BI Service, ensuring timely delivery to clients while implementing security access control measures to protect sensitive data.

Education

• CSMSS Chh. Shahu College of Engineering

  Bachelor of Engineering - BE

  2016 — 2019