Senior BI Developer & Data Analyst with 6+ Years Experience

Naga Praveen Balineni

Birmingham, AL ***** +1-945-***-**** ******************@*****.***

www.linkedin.com/in/nagapraveenbalineni-72ba33232

Professional Summary:

• Data Analyst & BI Developer with 6 years of experience in designing, developing, and deploying end-to-end business intelligence solutions using Power BI, Tableau, SQL, and Azure.

• Extensive experience in data modeling, KPI design, and advanced calculations with DAX, Power Query (M language), and LOD expressions, delivering accurate and actionable insights.

• Skilled in developing scalable ETL pipelines using Azure Data Factory (ADF), SSIS, and Alteryx, integrating data from diverse sources such as SQL Server, Snowflake, APIs, and flat files.

• Strong expertise in SQL (T-SQL, Oracle), including writing complex queries, stored procedures, views, and implementing query optimization techniques to improve reporting performance.

• Proficient in Azure ecosystem tools — Azure Data Lake, Azure Synapse Analytics, and Databricks (PySpark, Python) — for data processing, warehousing, and advanced analytics.

• Implemented secure and governed BI solutions by configuring Row-Level Security (RLS), role-based permissions, and access controls in Power BI Service and Tableau Server.

• Hands-on experience migrating legacy reporting systems such as SSRS and Crystal Reports into modern BI platforms like Power BI Paginated Reports, improving usability and compliance.

• Automated workflows and recurring tasks using Power Automate, Alteryx Scheduler, and SQL Server Agent Jobs, significantly reducing manual reporting efforts.

• Designed and managed SSAS Tabular & OLAP cubes, star and snowflake schemas, and multidimensional models to enable self-service BI and enterprise-scale reporting.

• Adept at working in Agile/Scrum environments, collaborating with stakeholders, conducting requirement workshops, and applying UI/UX design best practices to deliver intuitive and user-friendly dashboards. Tools & Technologies

Business Intelligence & Visualization: Power BI, Tableau (Desktop, Server), SSRS, Excel (Power Pivot, Power Query, Power View, Power Map), Custom Visuals, KPI Scorecards, Drill-through Reports, Row-Level Security (RLS). Data Engineering & ETL: Azure Data Factory (ADF), SSIS, Alteryx Designer & Scheduler, Power Query (M language), SQL Server Agent Jobs, Data Cleansing, Data Validation, Data Profiling, Incremental Loads (CDC, SCD), Workflow Automation Databases, Cloud & Big Data: SQL Server, Oracle, Snowflake, Azure SQL Database, Azure Synapse Analytics, Azure Data Lake

(ADLS Gen1/Gen2), Azure Databricks (Python, PySpark), Azure Functions, Logic Apps, REST API Integration, SharePoint, D365 HR.

Programming, Modeling & Automation: T-SQL, DAX, MDX, Python (Pandas, PySpark), PowerShell, Star & Snowflake Schema Design, SSAS, OLAP Cubes, Git, Power Automate, Power Apps. Educational Details:

University of The Cumberlands, USA - Dec 2024

• Master’s Degree: Information Technology

Tirumala Engineering College, Andhra Pradesh – Apr 2016

• Bachelor’s Degree: Electronics and Communication Engineering Certifications:

• Udemy Certified - Microsoft azure Fundamentals (AZ-900) certification

• Certified Power BI developer

• Google Data Analytics Professional Certificate

Professional Experience:

UAB Athletics Sept 2024 – Current

Sr. Data Analyst Birmingham, AL

• Design, develop, and maintain highly interactive reports and dashboards in Power BI, using DAX for advanced calculations, KPIs, and measures to deliver meaningful insights for business stakeholders.

• Perform end-to-end data transformation and cleansing with Power Query (M language), including pivot/unpivot operations, column derivations, and data modeling for accurate reporting.

• Configure and administer Power BI Service by managing workspaces, apps, permissions, and row-level security (RLS), while ensuring proper deployment pipelines and governed access to reports.

• Install, configure, and manage Power BI Gateway to securely connect on-premises data sources with cloud services, enabling both scheduled and real-time data refreshes.

• Build and maintain scalable ETL pipelines using SSIS, integrating structured and semi-structured data from Excel, flat files, SQL Server, and external applications into centralized repositories.

• Design and orchestrate automated pipelines with Azure Data Factory (ADF) to ingest, transform, and move large datasets across multiple environments for analytical and operational reporting.

• Utilize Azure Data Lake to store, process, and manage big data in both structured and unstructured formats, ensuring scalability and integration with advanced analytics solutions.

• Develop optimized analytical solutions with Azure SQL Database and Azure Synapse Analytics, enabling high-performance querying, reporting, and enterprise-level data warehousing.

• Build and manage analytical models in SSAS (OLAP & Tabular), incorporating hierarchies, perspectives, and KPIs to support multidimensional analysis and self-service BI.

• Implement business process automation using Power Automate, developing workflows for notifications, approvals, and task automation to enhance efficiency and reduce manual effort.

• Create and deploy custom business applications in Power Apps to capture, validate, and manage data for use in analytics and operational workflows.

• Develop and consume REST APIs to integrate external systems with Power BI and Power Platform, enabling real-time reporting, mobile-friendly analytics, and seamless data flow across applications. Client: Southwest Airlines Sep 2023 – Aug 2024

Power BI Developer Dallas, TX

• Collaborated with business stakeholders to gather requirements and translated them into Power BI solutions by designing effective data models, defining KPIs, and implementing DAX calculations, hierarchies, and drill-through reports for actionable insights.

• Developed highly interactive dashboards in Power BI Desktop and published them to Power BI Service, configuring workspaces, apps, and Row-Level Security (RLS) to deliver secure, role-based reporting across 500+ users.

• Utilized Power Query and Alteryx Designer for advanced data preparation, cleansing, and transformations (pivot/unpivot, joins, fuzzy matching, regex, and workflow automation), enabling accurate, production-ready datasets.

• Built and orchestrated ETL pipelines using Azure Data Factory (ADF), SSIS, and Alteryx workflows to extract, transform, and load data from SQL Server, flat files, REST APIs, and Snowflake into centralized reporting models.

• Processed large and complex datasets in Azure Databricks using Python and PySpark for data enrichment and aggregation, and integrated outputs with Azure Data Lake and Power BI for downstream analytics.

• Migrated legacy systems and high-volume datasets into Snowflake and Azure Synapse Analytics, applying indexing, partitioning, and query optimization techniques to improve scalability and reduce execution times by up to 27%.

• Designed and optimized SQL queries, stored procedures, views, and functions to support BI reporting, while developing star and snowflake schemas in data warehouses to improve efficiency of analytical queries.

• Automated recurring workflows with Power Automate and Alteryx Scheduler, streamlining approval processes, notifications, and recurring ETL tasks, reducing manual intervention and cutting reporting cycle times by 50%.

• Modernized legacy SSRS and Crystal Reports into Power BI Paginated Reports, enabling faster generation of finance and operational reports while maintaining compliance and governance requirements.

• Applied BI development best practices by leveraging Git for version control, optimizing DAX and SQL performance, and applying UI/UX principles in dashboard design to deliver intuitive, user-friendly analytics that drove higher adoption across business units.

Client: Razorpay Sep 2020 – Nov 2022

Data Analyst Hyderabad, India.

• Designed and developed interactive dashboards and reports in Tableau Desktop and published them to Tableau Server, applying drill-downs, parameters, bookmarks, and tooltips to enhance user interactivity.

• Implemented advanced Tableau functionalities such as LOD expressions, sets, bins, action filters, and quick table calculations to deliver dynamic and complex analytical solutions.

• Configured and maintained row-level security (RLS), role-based permissions, and user filters in Tableau to ensure secure and governed data access.

• Authored and optimized complex SQL queries, views, and stored procedures in relational databases (SQL Server, Oracle) to extract and transform large datasets for reporting.

• Built ETL workflows using SSIS and integrated diverse data sources including Excel, flat files, and relational databases into centralized reporting models.

• Improved Tableau dashboard performance by applying query tuning, indexing strategies, and execution plan optimization, ensuring faster response times and smoother user experience.

• Conducted data profiling, validation, and cleansing to ensure data accuracy, consistency, and reliability across reporting environments.

• Administered Tableau environments by publishing dashboards, setting up user groups, configuring permissions, and scheduling automated data refreshes in Tableau Server.

• Collaborated with stakeholders to gather reporting requirements, define KPIs, and translate needs into Tableau solutions, while documenting BI workflows and following Agile methodologies using tools like JIRA. Personal time & Career Break - Nov 2018 – Aug 2020 DBS Bank Aug 2016 - Oct 2018

Associate Data Analyst Hyderabad, India

• Designed and developed highly interactive dashboards and reports in Power BI, leveraging DAX for time-series analysis, KPIs, advanced measures, and calculated fields, while optimizing data models and enhancing performance with Power Query transformations.

• Built scalable ETL pipelines using Azure Data Factory (ADF) and SSIS, orchestrating workflows to extract, transform, and load data from diverse sources (SQL Server, Azure SQL Database, flat files, REST APIs, SharePoint), ensuring consistency, reliability, and data governance.

• Utilized Azure Databricks for large-scale data transformation and cleansing of structured and unstructured datasets, enabling seamless integration with Azure Data Lake and downstream reporting solutions.

• Developed optimized T-SQL stored procedures, triggers, views, functions, and indexes to support reporting requirements, improve query performance, and enhance overall data accessibility for analysts and business stakeholders.

• Integrated Power BI with enterprise data sources including Azure SQL Database, Synapse Analytics, Databricks, REST APIs, and SharePoint, creating a unified reporting ecosystem across cloud and on-premises environments.

• Configured and administered Power BI Service features such as workspaces, apps, row-level security (RLS), role-based access control, and deployment pipelines, while setting up Power BI Gateway for real-time and scheduled data refresh.

• Automated recurring reporting workflows using Power Automate and SSRS subscriptions, streamlining notifications, approvals, CRUD operations in Azure AD, and integration with D365 HR through flows and canvas apps in Power Apps.

• Built and managed SSAS Tabular & OLAP cubes, star schemas, and multidimensional models, incorporating hierarchies, perspectives, and KPIs, while applying MDX for calculated measures and dimension members to support advanced business analysis.

• Implemented API integrations by developing and consuming REST APIs, Azure Functions, and Logic Apps, enabling mobile-friendly analytics, real-time reporting, and smooth interoperability with external applications.

• Collaborated in Agile environments with cross-functional teams, conducting requirement workshops, sprint planning, and code reviews, while continuously monitoring SQL performance bottlenecks, Power BI refresh issues, and applying optimization techniques for reliable and accurate business reporting.

Contact this candidate