lokeshreddy y

Data Analyst | Business Intelligence Analyst

3+ yrs exp 88 · Excellent

About

Data Analyst and Business Intelligence professional with 4 years of experience using SQL, Microsoft Excel, Power BI, Python, and Snowflake to transform complex datasets into accurate reports, dashboards, KPIs, and actionable business insights. Experienced in data cleaning, validation, reconciliation, exploratory and trend analysis, forecasting, reporting automation, and stakeholder collaboration. Proven impact includes 99%+ data accuracy, 40% reduction in manual reporting effort, and 30% improvement in dashboard performance.

Skills & Expertise (56)

DAX Advanced

8.0/10

Years Exp

Data Consolidation Intermediate

7.6/10

Years Exp

Data Pipelines Intermediate

7.6/10

Years Exp

Data Transformation Intermediate

7.6/10

Years Exp

ETL Intermediate

7.6/10

Years Exp

SQL Server Intermediate

7.6/10

Years Exp

Data Cleaning Intermediate

7.6/10

Years Exp

Exploratory data analysis Intermediate

7.6/10

Years Exp

Python Intermediate

6.4/10

Years Exp

YTD Snowflake MTD Scrum ELT YoY Analysis Streams Star Schema Dimensional Modeling Fact & Dimension tables Accuracy Consistency Exception Reporting Reconciliation Row-Level Security RBAC Power Query (M Requirement gathering stakeholder communication Cross-Functional Collaboration Agile Data Extraction Trend Analysis Pattern Analysis Root-cause analysis Performance Analysis Business Insights Complex Joins CTEs Subqueries Window Functions Stored Procedures Views Query Optimization Forecasting Data Validation Power BI Desktop Power BI Service Interactive Dashboards KPI Dashboards Monthly Reporting Ad-Hoc Reporting Performance Reports Executive Reporting Microsoft Excel Data Reconciliation KPI Tracking

Work Experience

Power BI Developer & SQL

Unizen Technologies

Mar 2024 - Present

Collected, consolidated, cleaned, and analyzed multi-source clinical data across 5 departments to support accurate reporting, KPI measurement, and operational decision-making. Translated business requirements into analytical questions, measurable KPIs, Power BI dashboards, and reporting solutions for clinicians, business users, and leadership. Developed efficient and optimized SQL Server and Snowflake queries using CTEs, stored procedures, indexed views, joins, and query optimization techniques for high-volume analysis. Performed data validation, reconciliation, completeness checks, and automated exception reporting, achieving 99%+ data accuracy across reporting outputs. Investigated data discrepancies and collaborated with business and data engineering teams to identify root causes and resolve data-quality issues. Developed 50+ DAX measures and Power Query transformations for KPI tracking, trend analysis, performance measurement, and executive reporting. Created and maintained interactive Power BI dashboards and daily, weekly, monthly, and ad-hoc reports for business and operational performance monitoring. Automated recurring ETL and reporting processes, replacing static Excel reports with dynamic dashboards and reducing manual reporting effort by 40%. Improved dashboard performance by 30% through DAX optimization, Incremental Refresh, aggregation tables, and efficient dimensional data modeling. Analyzed operational trends and performance metrics and provided actionable, data-driven recommendations to support management and strategic and operational decision-making. Maintained dashboards, datasets, KPI definitions, report documentation, and data-quality checks to improve reporting consistency and traceability. Applied Row-Level Security and Dynamic Data Masking to protect sensitive PII/PHI data and support organizational data governance and security standards. Collaborated with clinicians, business stakeholders, and data engineering teams on reporting requirements, data availability, QA, and delivery milestones.

Associate Power BI Developer

Unizen Technologies

Dec 2022 - Feb 2024

Collected and analyzed transactional and cross-functional sales data across 5 business units to identify revenue trends, product performance, regional patterns, and business opportunities. Developed and maintained interactive Power BI dashboards and KPI reports for 50+ stakeholders across sales, finance, and operations. Built optimized Snowflake SQL queries, CTEs, and stored procedures for data extraction and transformation, reducing data load time by 40%. Created 30+ DAX measures covering YoY growth, rolling averages, dynamic ranking, MTD, QTD, YTD, and other time-intelligence calculations. Performed business and operational performance analysis to identify trends and support data-driven recommendations for sales and management teams. Supported sales forecasting and performance measurement initiatives, contributing to a 25% improvement in forecasting accuracy. Automated recurring analytics and reporting workflows, reducing manual reporting effort by 60%. Designed Snowflake dimensional models with fact and dimension tables, clustering keys, and materialized views to support scalable analytical reporting. Implemented Row-Level Security and RBAC to maintain role- and region-specific access to business performance data. Collaborated with data engineers and business teams in Agile/Scrum to clarify analytical requirements, validate results, and deliver dashboard enhancements.