Senior Data Analyst & BI Developer with Power BI Expertise

Sneha G

+1-704-***-**** *****************@*****.*** LinkedIn

Professional Summary:

Results-driven Senior Data Analyst and BI Developer with over 5 years of extensive experience designing, developing, and deploying data-driven solutions using Power BI, Tableau, and advanced ETL tools such as SSIS and Talend. Proven expertise in building robust data models, crafting complex DAX and MDX calculations, and implementing row-level security to deliver secure, interactive, and insightful dashboards for diverse business stakeholders. Skilled in integrating multiple data sources, including on-premises and cloud platforms, and leveraging advanced analytics with Python and R to drive actionable business insights and forecasting.

Demonstrated ability to collaborate effectively across cross-functional teams, translating business requirements into scalable technical solutions following Agile methodologies. Adept at automating workflows and data refreshes with Power Automate and Azure Data Factory, ensuring timely and reliable delivery of analytics. Strong background in data warehousing concepts, multidimensional modeling with SSAS, and performance tuning of BI environments, complemented by hands-on experience in Tableau Server administration and predictive analytics integration. Committed to empowering organizations with self-service BI capabilities and fostering data-driven decision-making.

Category Tools & Technologies

BI & Visualization Power BI (Desktop, Service, Report Builder, Embedded), Tableau (Desktop, Server),DAX,

MDX, Power Query, Excel Dashboards, SSRS, Paginated Reports, Power Pivot, Power View,

Power Map, Drill-through, Bookmarks, LOD Expressions, Custom Visuals, Row-Level Security (RLS).

ETL & Data Integration SSIS, DTS, Talend, Azure Data Factory (ADF), Power Automate, Python (Pandas, Matplotlib,

NumPy), JavaScript,HTML,CSS, KNIME,Looker R (Rserve), EazyBI,REST APIs, XML, JSON, M Language, SQL Queries, Databricks, MySQL, CDC (Change Data Capture), Custom Scripting, Data Extracts.

Databases & Data Modeling SQL Server, Azure SQL Database, Oracle, SharePoint, Star Schema, Snowflake Schema, Fact & Dimension Tables, QlikView OLAP Cubes, Tabular & Multidimensional SSAS Models, Data Warehousing, Data Normalization.

Cloud & DevOps Microsoft Azure (Blob Storage, Data Lake, Synapse Analytics), Power BI Gateways (Enterprise & Personal), Tableau Server, Azure DevOps, CI/CD Pipelines, Power BI REST API.

Security & Authentication Row-Level Security (RLS), SAML, OAuth, LDAP, Enterprise Identity Providers Integration.

Project & Collaboration Jira, Git, Agile/Scrum, Confluence, Documentation, Stakeholder Communication, UAT Support, Training, Best Practices Implementation.

Educational Details:

University of North Carolina at Charlotte - Aug 2023 to Dec 2024

●Master's degree in Information Technology

MLR Institute of Technology, Hyderabad - Jun 2016 to Jul 2020

●Bachelor's degree in Electronics and Communication Engineering.

Certifications:

●Certified Power BI developer

●Certified Scrum Master.

●Certified associate project Manager (CAPM)

●Microsoft azure Fundamentals (AZ-900) certification (In progress)

Professional Experience:

Humana Jan 2025 – Current

Sr. Data Analyst Charlotte, NC

●Designed and deployed interactive dashboards using Power BI by transforming raw data into insightful reports, incorporating drill-throughs, slicers, bookmarks, and page-level navigation for intuitive user experience.

●Created robust data models by importing and transforming data using Power Query, establishing relationships, and performing data cleansing to ensure consistency and accuracy across reports.

●Built calculated columns and custom measures using DAX to implement complex business logic, including dynamic KPIs, year-over-year comparisons, rolling averages, and conditional formatting in visuals.

●Developed scheduled and event-driven data pipelines using Azure Data Factory, integrating structured and semi-structured data from Azure SQL Database, Blob Storage, and REST APIs into Power BI datasets.

●Published reports to Power BI Service, configured Row-Level Security (RLS) for secure access, and set up scheduled refreshes to deliver timely insights to business units across departments.

●Automated workflows using Power Automate to trigger data alerts, approval processes, and report sharing, reducing manual tasks and streamlining data operations.

●Collaborated with data engineers and business stakeholders to gather requirements, build data definitions, validate KPIs, and iterate on dashboard wireframes to align with analytical objectives.

●Designed ETL workflows using SQL Server Integration Services (SSIS) and wrote advanced T-SQL queries and stored procedures to extract, transform, and load data from multiple relational sources.

●Created paginated and drill-down operational reports using SQL Server Reporting Services (SSRS) for print-ready and exportable business deliverables.

●Performed ad hoc data analysis using Python (Pandas, Matplotlib) and Excel, providing exploratory insights, anomaly detection, and visualization support beyond standard BI platforms.

Tech Stack: Power BI, Power Query, DAX, Azure Data Factory, Azure SQL Database, Blob Storage, REST APIs, Power BI Service, Row-Level Security (RLS), Power Automate, SSIS, T-SQL, SQL Server Reporting Services (SSRS), Python (Pandas, Matplotlib), Excel.

University of North Carolina at Charlotte Jan 2024 – Dec 2024

Technical Associate Charlotte, NC

●Collaborated with cross-functional teams including senior leadership, SMEs, and IT teams to gather and translate business objectives into detailed technical specifications for enterprise data solutions, using tools such as Jira and frameworks like Agile/Scrum.

●Designed and developed robust ETL workflows to load and transform data from Oracle, SharePoint, and websites using SSIS, Talend, implementing dynamic package configurations and incremental loading strategies.

●Created advanced stored procedures and scripts for tasks like index maintenance, metadata extraction, and data profiling using PL/SQL, T-SQL, and tools like SQL Server Management Studio.

●Applied complex data cleansing and transformation techniques using Python (Pandas) and M language within Power Query Editor, ensuring clean and standardized datasets for downstream reporting in Power BI.

●Automated data refreshes and alert notifications using Power Automate, Tableau Server, QlikView Publisher, KNIME batch scheduling, and Looker data alerts.

●Designed and delivered visually compelling and interactive dashboards in Power BI, utilizing DAX for custom calculations, KPIs, and measures, and incorporated drill-throughs, slicers, and time-series analysis for enhanced insights.

●Embedded business process automation into dashboards by integrating Power Apps and Power Automate, enabling dynamic user interactions, contextual workflows, and paginated report generation.

●Designed and developed dashboards, reports, and scorecards in Cognos using Report Studio and Workspace Advanced.

●Built data models with Framework Manager, creating star/snowflake schemas, calculated measures, and reusable metadata packages.

●Modeled high-performance data warehouse solutions using star and snowflake schemas, while leveraging SSAS (tabular and multi-dimensional models) to enable in-memory analytics and rapid dashboard rendering.

●Enabled real-time, self-service analytics by deploying and managing reports in Power BI Service, utilizing Power BI Gateway for scheduled refreshes of on-premises data, and distributing insights via Excel Power Pivot, subscriptions, and automated workflows.

Tech Stack: Jira, Agile/Scrum, SSIS, Talend, Oracle, SharePoint, PL/SQL, T-SQL, SQL Server Management Studio, Python (Pandas), M language, Power Query Editor, Power BI, DAX, Power Apps, Power Automate, SSAS (Tabular & Multidimensional), Power BI Service, Power BI Gateway, Excel Power Pivot.

LTI Mindtree Jan 2021 – Jul 2023

Senior Engineer (Tableau Data Analyst) Hyderabad, IN

●Developed complex, interactive dashboards using Tableau Desktop, incorporating advanced Level of Detail (LOD) expressions, calculated fields, parameter-driven filters, and drill-down navigation to enable multi-layered, intuitive data exploration for end users.

●Integrated Tableau with multiple data sources including SQL Server, Oracle, Excel, and REST APIs, applying both Live Connections and Extracts based on use-case needs, while building optimized data models to ensure performance and scalability.

●Embedded predictive analytics and machine learning models into dashboards using Python (via TabPy) and R (via Rserve), enabling real-time insights such as anomaly detection, forecasting, and risk scoring within Tableau’s visual environment.

●Applied robust security practices by implementing Row-Level Security (RLS), and integrating with enterprise identity providers using SAML, OAuth, and LDAP, ensuring data governance, role-based access control, and audit readiness.

●Performed workbook tuning and performance optimization using Tableau Performance Recorder, extract curation, parameter tuning, and workbook scoping techniques, significantly reducing dashboard load times and improving responsiveness across devices.

●Automated refresh schedules, alert notifications, and versioned deployments using Tableau Server, Tableau Data Extracts, and custom scripting, aligning analytics delivery with operational schedules and ensuring uninterrupted access to timely data.

●Collaborated with cross-functional teams to gather BI requirements, translate them into scalable Tableau solutions, and documented dashboard logic, data lineage, and SOPs to support maintainability and enterprise-wide reuse.

●Led quality assurance reviews, dashboard peer inspections, and internal Tableau training sessions, promoting best practices in design, performance, and self-service analytics, while mentoring junior analysts and business users.

●Developed OTBI dashboards and subject area-based ad hoc reports for Oracle Cloud HCM/ERP modules.

●Customized OTBI analyses by joining multiple subject areas, applying filters, and creating custom KPIs for HR, Finance, and Supply Chain reporting.

●Assisted business users with self-service OTBI report creation, ensuring alignment with organizational KPIs.

●Configured security in OTBI to provide role-based access while maintaining data confidentiality.

Tech Stack: Tableau Desktop, Tableau Server, LOD Expressions, SQL Server, Oracle, Excel, REST APIs, Python (TabPy), R (Rserve), Row-Level Security (RLS), SAML, OAuth, LDAP, Tableau Performance Recorder, Tableau Data Extracts, Custom Scripting.

Client: Bajaj Finance Sept 2019 – Dec 2020

Data Analyst Hyderabad, IN.

●Collaborated with business users to analyze requirements and develop interactive Power BI reports, dashboards, and scorecards using DAX, Tabular SSAS models, and diverse data sources including on-premises and cloud environments.

●Implemented row-level security (RLS) by creating user roles and groups to ensure secure data access across reports and dashboards.

●Developed and maintained complex ETL processes using SSIS to integrate data from Oracle, XML, Excel, and other sources, including migration of legacy DTS packages to SSIS with CDC for incremental loading.

●Designed and optimized T-SQL queries, user-defined functions, and MDX/DAX expressions to support multidimensional analysis, business forecasting, and enhanced report performance.

●Published and managed Power BI reports and dashboards on Power BI Service, configuring Enterprise and Personal Gateways to ensure timely data refresh and availability on web and mobile platforms.

●Created and deployed reports using SSRS, Excel Services, and Power BI integrated with SharePoint Server to meet diverse business reporting requirements.

●Designed, optimized, and maintained relational databases such as SQL Server and MySQL to support analytics, reporting, and business applications.

●Built and maintained ETL pipelines using SSIS, Talend, and Azure Data Factory for seamless data movement between heterogeneous sources (Oracle, SQL Server, Excel, SharePoint, REST APIs).

●Implemented incremental loading strategies, Change Data Capture (CDC), and automated workflows for efficient data refreshes.

●Developed and extended OLAP cubes, tabular models, and data source views to enable efficient slicing, dicing, and deep data exploration for business insights.

Tech Stack: Power BI, DAX, Tabular SSAS, SSIS, DTS, CDC, T-SQL, MDX, SSRS, Excel Services, SharePoint Server, Oracle, XML, Excel, OLAP cubes, Power BI Service, Power BI Gateways.

Contact this candidate