Suma Latha

Results-oriented Data Analyst with 9 years of experience collecting, cleaning, and analyzing large and complex datasets to generate actionable insights that support business decision-making and performance improvement. Skilled in performing end-to-end data analysis including requirement gathering, data profiling, data validation, and transformation to ensure high-quality reporting outputs. Experienced in analyzing data from multiple sources including flat files (CSV, Excel), SQL Server, Snowflake, Azure SQL Database, APIs, and cloud-based data platforms to identify trends, patterns, KPIs, and business performance metrics.

Proficient in Microsoft Excel for data cleaning, transformation, analysis, and visualization, supporting high-quality reporting outputs and actionable insights. Proficient in building and maintaining analytical reports and dashboards using Power BI, enabling stakeholders to monitor operational performance and make data-driven decisions. Strong ability to perform data exploration, ad-hoc analysis, and root cause analysis to support business problem-solving and strategic initiatives.

Skilled in writing SQL queries and performing data extraction, aggregation, and transformation to support reporting and analytical requirements. Experienced in data validation, reconciliation, and quality assurance to ensure accuracy, consistency, and reliability of datasets and reporting outputs. Capable of translating business requirements into analytical solutions by collaborating with stakeholders, business users, and technical teams.

Strong understanding of data modeling concepts including joins, normalization, dimensional modeling, and relational database structures. Effective communicator with strong analytical and problem-solving skills, delivering insights and recommendations that support business performance and decision-making.

Data Analyst (BI & Reporting) - Kiranam Technologies Inc.

(2025-01 - 2025-12)

Analyzed portfolio and project management data to develop enterprise reporting solutions that provided centralized visibility into project performance, resource utilization, budget tracking, and portfolio health, enabling leadership teams to make informed, data-driven business decisions.

• Analyzed business and operational data from Jira, Jira Align, Snowflake, and Databricks to develop interactive Power BI dashboards and analytical reports that supported strategic decision-making.
• Gathered and translated business requirements into data-driven reporting solutions by collaborating with stakeholders, project managers, and cross-functional teams.
• Performed detailed data analysis to identify trends, patterns, KPIs, and performance metrics related to portfolio management, financial reporting, and operational efficiency.
• Developed complex DAX measures, calculated columns, and business metrics to deliver actionable insights and support executive-level reporting needs.
• Conducted data validation, reconciliation, and quality assurance processes to ensure the accuracy, integrity, and consistency of reporting data across multiple sources.
• Worked with large and complex datasets in Snowflake and Databricks to support enterprise analytics, ad hoc reporting, and business intelligence initiatives.
• Designed and enhanced dashboards by improving report usability, visual storytelling, performance optimization, and end-user experience.
• Created and maintained data models, relationships, and data transformations to support scalable and efficient reporting solutions in Power BI.
• Managed Power BI Service activities including report publishing, workspace administration, access management, and scheduled data refresh monitoring through Power BI Gateway.
• Delivered continuous report enhancements and analytical insights based on stakeholder feedback and evolving business requirements within an Agile environment.

Data Analyst (BI & Reporting) - Kiranam Technologies Inc.

(2023-02 - 2024-12)

• Collaborated with business stakeholders, Business Analysts, and technical teams to gather reporting requirements and translate them into actionable Power BI solutions.
• Developed and maintained interactive Power BI dashboards and reports to support business analysis, KPI tracking, and data-driven decision-making.
• Created visually compelling dashboards using charts, slicers, tables, and drill-through/drill-down functionalities to enhance user experience and analytical capabilities.
• Performed data analysis and validation using SQL and Snowflake to ensure data accuracy, consistency, and reliability across reports and dashboards.
• Designed and implemented semantic views and data models to improve reporting performance and simplify business data consumption.
• Developed advanced DAX measures, calculated columns, and KPIs to provide meaningful business insights and support analytical reporting requirements.
• Configured data relationships, managed visual interactions, and optimized dashboard performance for efficient reporting and improved usability.
• Published, scheduled, and monitored Power BI reports and dashboards through Power BI Service, ensuring timely data refreshes and report availability.
• Worked closely with QA and UAT teams to identify and resolve reporting issues, validate business logic, and ensure high-quality deliverables.
• Utilized Snowflake and Power BI integration to build scalable reporting solutions and deliver actionable insights to business users and management teams.

Data Analyst (BI & Reporting) - Kiranam Technologies Inc.

(2023-02 - 2024-12)

Migrated the on-premises Employee data to the cloud by establishing AT&T's centralized data repository, unifying data from diverse sources into a single, reliable platform for seamless analysis, reporting, and informed decision-making.

• Collaborated with multiple departments to identify and extract data from internal and external systems.
• Worked closely with planning and operations teams to understand their reporting needs and define clear, consistent performance metrics.
• Integrated diverse data formats (structured, unstructured, relational) into a unified platform, creating consumable, multi-dimensional and correlated data which functioned as single source of truth to support consistent and reliable decision-making Analytics.
• Partnered with developers and data engineers to design interactive, customized Power BI dashboards tailored to business team requirements, delivering real-time insights for stakeholders for different business groups by creating standardized DAX measures.
• Implemented data validation and reconciliation checks to improve accuracy and build confidence in reported numbers.
• Implemented row-level security (RLS) to control data access based on user roles.
• Automated data refresh schedules to enable daily reporting, ensuring timely updates with Power BI's scheduled refresh feature.

Data Analyst (BI & Reporting) - Kiranam Technologies Inc.

(2018-05 - 2022-12)

As a BI Developer, I managed data from diverse sources by formatting, curating, and loading it into databases, and developing executive level Power BI dashboards and reports to support data driven decision making with in Q squared solutions.

• Managed end-to-end reporting lifecycle including requirements gathering, model design, visualization.
• Conducted analysis, design, development, and testing of applications using MS SQL Server and SSIS.
• Built multi-dimensional data models supporting cross-functional organization reporting.
• Developed SQL Server Management Studio views and wrote complex queries for data analysis.
• Imported views into Power BI Desktop to create detailed, insightful reports.
• Utilized DAX to implement advanced calculations and support in-depth analysis.
• Designed various data visualizations, including charts, dashboards, prototypes, and demos.
• Created dynamic dashboards with visuals such as slicers, bar charts, tables, clustered columns, and donut charts, incorporating drill-through and drill-down features.
• Established and edited relationships between tables, enhancing interactive data visualizations.
• Published Power BI Desktop reports to Power BI Service, enabling broader accessibility.
• Scheduled data refreshes, both manually and automatically, with date parameters to maintain up-to-date insights.
• Applied Row Level Security (RLS) to restrict data access based on user roles.
• Delivered training sessions to business users to organize specific usage and improve dashboard adoption and reporting literacy.

Data Analyst (BI & Reporting) - Holy Name Medical Center, New Jersey - New Jersey

(2017-05 - 2018-04)

As a power BI Developer, creating reports and insights to help different business teams make data-driven decisions. Designed and built executive dashboards providing real-time analytics.

• Worked with Business Analysts, Data Modelers, and team members to understand business needs and processes.
• Designed and built interactive Power BI dashboards and reports that turned raw data into useful insights.
• Collaborated with business and IT teams to collect reporting requirements and ensure data was shown accurately.
• Performed data cleaning, transformation, and validation using Microsoft Excel and Power Query to prepare datasets for analysis and reporting.
• Created custom Power BI reports and dashboards for on-demand business needs.
• Maintained and updated Power BI dashboards to keep data accurate and relevant.
• Designed visuals and themes in Power BI that matched company branding and style guidelines.

Master of Computer Applications - Computer Applications - Sri Venkateswara University India