Data Analyst Power Bi

DEEKSHITHA S

BI Developer / Data Analyst

Email ID: **********.****@*****.***

Phone: 469-***-****

Sample work: https://github.com/Pinky812/Reports

Power BI Tableau SQL ETL Data Analyst MS SQL AZURE Snowflake T-SQL POWER APPS POWER AUTOMATE Power BI Services Python Gateways

Highly motivated, detail-oriented BI Developer, Data Analyst with 6 years of IT experience, Media experience possessing a diverse skill set in data warehousing, Business Intelligence technologies, cybersecurity. Expertise in SQL Server development, MSBI stack (SQL, T-SQL, SSIS, SSAS, SSRS), Azure, Power BI, Tableau, Python for building, deploying, managing applications, services across global Microsoft-managed data centers. Proficient in designing, implementing, integrating, maintaining, testing various web-based, enterprise, client/server, distributed applications using Python, PyTorch. Additionally skilled in modern cloud platforms, AI/ML frameworks, data engineering tools (Databricks, Snowflake), cybersecurity practices including threat intelligence, penetration testing, security-driven data analytics. Passionate about automation, leveraging data to drive business, security insights.

PROFESSIONAL SUMMARY:

Power BI Developer and Data Analyst:

SQL Server development, MSBI stack (T-SQL, SSIS, SSAS, SSRS), Azure, I specialize in creating data-driven solutions for both cloud on-premises environments. I have extensive experience in building, deploying, and managing solutions through Microsoft-managed technologies, with a focus on Power BI development, data integration, advanced analytics.

Power BI Development: Proficient in developing interactive reports, dashboards using Power BI, with data blending from multiple sources.

Expertise in writing complex SQL queries, stored procedures, CTEs, temporary tables, to support data modeling optimize Power BI reporting.

experience in creating dynamic reports dashboards using Power BI Desktop Power BI Service, automating scheduled refreshes.

Skilled in using Power Query Editor for data transformation, clean-up, building data models.

Experience with various Power BI visualizations: Bar Charts, Pie Charts, Line Charts, Cards, Slicers, Maps, custom visuals to enhance reporting, filtering options (report-level, page-level, visual-level) for detailed insights performance optimization.

SQL & Data Transformation: proficiency in SQL for writing complex queries, stored procedures, data transformation processes to optimize performance in Power BI reports, SSIS (SQL Server Integration Services) for ETL processes: data extraction, transformation, loading.

Data Integration & ETL: Hands-on experience in SSIS for seamless integration of multiple data sources performing data cleansing aggregation tasks as part of ETL processes.

Power BI Service & Automation: Expertise in publishing reports to Power BI Service, configuring automated scheduled refreshes, optimizing report performance for scalability.

Managing user access, security roles, implementing governance policies in Power BI Service.

Tableau:

Skilled in Tableau data visualization to analyze large datasets, extract insights, create interactive reports, dashboards.

Proficient in building interactive dashboards in Tableau to answer key business questions.

Expert in designing, developing Tableau dashboards using Tableau Desktop, incorporating Cross Maps, Scatter Plots, Geographic Maps, Pie Charts, Bar Charts, Page Trails, Density Charts.

Experienced in data blending, calculations, LOD expressions, advanced filtering techniques to create dynamic reports.

Strong knowledge of Tableau Server, Tableau Prep for data preparation, governance, collaboration.

SQL:

Proficient in writing packages, stored procedures, functions, views, database triggers using SQL, PL/SQL.

Experienced in all phases of the Software Development Life Cycle (SDLC) including analysis, specification, database administration, development, maintenance, testing, documentation.

Strong expertise in writing simple, complex SQL queries using DML, DDL, Group functions, Grouping Sets (CUBE, ROLLUP), Grouping functions, Analytical functions, CONNECT BY for hierarchical queries, PARTITION BY clause for reporting, application development.

Python:

Experienced in leveraging Python libraries such as Pandas, NumPy, Matplotlib, Seaborn, and Plotly to build insightful dashboards and data pipelines.

Proficient Data Analyst with hands-on experience in leveraging Python for data cleaning, transformation, analysis, and visualization to drive data-driven decision-making.

TECHNICAL SKILLS:

Databases / data Warehouses

MS SQL Server, Oracle, MY SQL, MongoDB, AWS, Azure, GCP, Snowflake.

ETL Tools

SSIS, Azure Data Factory, Informatica, Talend, AWS Glue, Power Query

BI Tools

Power BI, Tableau, Cognos, looker.

Power BI Eco system

Power Desktop, Power Query, Services, Gateways, DAX Studio, Power BI Report Builder, Power Automate, Power APPS, Power Platforms, Copilot, Fabric.

Languages

SQL, PL/SQL, T-SQL, DAX, Python, Power Shell.

Version Control

GitHub, Git bash

Methodologies / tools

Agile, Waterfall, Share point, Jira software, SDLC.

Web Analytics

Google Analytics.

Data Modeling

Star Schema, Snowflake Schema, Logical & Physical, Dimensional Modelling.

Enterprise Software

MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), MS SQL Server Integration Services (SSIS), Data Transformation Services (DTS), ODBC, OLTP, OLAP, SQL Server Management Studio (SSMS), MS SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler.

CERTIFICATIONS:

Foundations of Data Science Certification.

EDUCATION DETAILS:

Master’s (Business Analytics), from Texas A&M University – Dec 2022.

MBA( Multi Media Management-MMM), from Sri Padmavathi Mahila Vishwavidyalayam– June 2017.

Bachelor’s (Computer Science & engineering), from JNTU-Anantapur – June 2014.

PROFESSIONAL EXPERIENCE:

Power BI Developer/Data Analyst, Northern Trust, IL Nov 2024 – Till

Project Description: The project aimed to enhance the financial reporting and analytics capabilities by leveraging advanced business intelligence (BI) tools. This initiative focused on improving data accessibility, accuracy, and visualization to support strategic decision-making across investment management, wealth management, and asset servicing functions.

Roles & Responsibilities:

Followed the Agile principles, attended stand-up meetings, sprint reviews, retrospectives and worked on Jira software to monitor the project.

Worked with Snowflake to Analyze, Validate, manipulate data simultaneously written many complex queries like sub queries using window functions, clauses and join operations for data performance tuning.

creating sophisticated Power BI solutions that extract useful insights from a variety of datasets by leveraging intricate data models, DAX expressions, and unique visualizations.

Worked on views according to the requirements to generate the reports for fast, accurate results.

Working on Git hub, Git bash to raise the PR for data migration after creating views from one environment to another environment.

Managed parameters in power query for source connection, reduce the latency of refreshments, data transformations.

Designed and developed paginated reports using Power BI Report Builder to meet specific business requirements.

Integrated data from diverse sources like Snowflake, and Power BI datasets to create comprehensive reports in Power BI Report Builder.

Implemented advanced expressions and calculated fields in Report Builder for dynamic content customization.

Automated Contract Expiration Notification System using Microsoft Power Automate.

Generated API’s for Power automate flows using HTTP request action to collaborate workflow with airflow for automatic email setup.

enhance data collecting and reporting systems using SharePoint and the Microsoft Office 365 Power Platform, which includes Power Apps, Power Automate (Flow), and Power BI.

Optimizing the performance of the migrated database by fine-tuning SQL Server settings, optimizing queries, and implementing indexing strategies to enhance query performance and overall database efficiency.

worked with different types of filters like report level, Visual Level and Page Level filters.

Creating different chart types including KPI’s, Custom Visuals, Column charts, Pie Charts, Bar Charts, Funnel charts and Waterfall charts as per the data type.

Extensive knowledge of complex Tableau functionalities, such as joins, data blending, row-level security, parameters, calculated fields, and dashboard actions.

published and distributed the reports to business users via Tableau Server.

In charge of handling all aspects of Power BI service administration, including creating, monitoring, and troubleshooting data sources, managing users, workspaces, and gateways.

Designed DAX measures to create custom aggregations for KPIs and metrics not readily available in source data.

Designed and implemented complex DAX calculations, including time intelligence functions, dynamic measures, and calculated columns, to deliver actionable insights.

Worked on both Import, direct query mode for data extraction from Snowflake.

Extract creation, data source publication to the Tableau server, extract refresh scheduling in Tableau, failure extract monitoring, and troubleshooting.

Generated reported using URL’s, REST API’s as a proof of concept.

Created Gateways for the database on premise to refresh and schedule the reports/dashboards and datasets.

Deployed the workbooks, dashboards to Power BI services, worked on scheduling while publishing them to services.

Environment: Azure DevOps, One Drive, Power Platform, Power BI (Desktop, Services), Power BI Report Builder, Power Query, DAX, gateways, SQL, Power automate, Power apps, GitHub, Git bash, Snowflake, Excel.

BI Developer, Johnson & Johnson, NJ Feb 2024 – Oct 2024

Project Description: (J&J) is a global leader in healthcare, with a wide array of projects spanning pharmaceuticals, medical devices, consumer health products.

Consumer Insights: By storing customer behavior data from multiple touchpoints (website visits, purchase history, social media interactions), Snowflake allows J&J to process segment this data. The insights gained can inform product development or help identify emerging trends in consumer health preferences (e.g., growing interest in eco-friendly products).

Real-Time Analytics: Power BI is used to create interactive, dynamic dashboards that display key performance indicators (KPIs) in real-time. These can include metrics like sales performance, marketing campaign effectiveness, consumer sentiment based on real-time data from Snowflake.

Roles & Responsibilities:

Applied Data Analysis Expressions to create different measures and Calculated Columns, a range of reports, including cost-benefit analyses and time intelligence reports.

Applied DAX for creating different measures and Calculated Columns

Developed a package to load underlying data from text, excel, CSV, and XML files into tables and transport it between an OLTP and an OLAP database utilizing lookup, derived columns, condition split, aggregate, execute SQL task, data flow task, execute package task, etc.

Performed in Data gathering, Migration, data analysis and interacting with other team members like business Analysts, Team lead to understand the user requirements.

Followed the Agile principles, attended stand-up meetings, sprint reviews, retrospectives and worked on Jira software to monitor the project.

Developed dynamic and interactive dashboards in Power BI and Tableau to monitor production metrics, ensure real-time data accessibility, and support strategic decisions.

Worked with Data Architects on a Dimensional Model with both Star and Snowflake Schemas utilized.

Optimizing the performance of the migrated database by fine-tuning SQL Server settings, optimizing queries, and implementing indexing strategies to enhance query performance and overall database efficiency.

Created complex reports using custom controls and custom expressions using bars, lines, pies, maps, scatter plots, Gantt charts, bubbles, histograms, bullets, heat maps, and highlight tables. Developed Dashboard Visualizations, cross tables, Bar charts, Waterfall, and Tree maps.

Created Page Level Filters, Report Level Filters, and Visual Level Filters in Power BI according to the requirements.

Generating pixel-perfect paginated reports that can be printed or viewed digitally by leveraging Power BI's capabilities.

Created workflows on power automate for automatic emails, alter messages using triggers, recurrence actions as POC.

Established robust connections to various data sources for reliable visualizations in Power BI and Tableau, ensuring data accuracy.

Created new measurements and computations in accordance with business requirements by writing DAX expressions. Utilized Power BI's data blending, filters, actions, and hierarchies features. Practical development supporting users in the creation and editing of data visualization dashboards and worksheets.

Responsible for Developing the Dashboard and preparing ad-hoc Reporting.

Environment: Azure, Excel, Power BI (Desktop, Services), Power automate, Power apps, power platforms, Power BI Report Builder, gateways, SQL, DAX, GitHub, Jira, Agile Methodology.

BI Developer, QSC, CA Feb 2023 – Jan 2024

Project Description: Tracking product performance, including manufacturing efficiency, quality control, and inventory metrics, using Power BI and SQL queries. Analyzing customer purchasing patterns, behaviors, and feedback, enabling data-driven strategies for customer retention and product improvements.

Roles & Responsibilities:

Performed in Data gathering, Migration, data analysis and interacting with other team members like business Analysts, Team lead to understand the user requirements.

Followed the Agile principles, attended stand-up meetings, sprint reviews, retrospectives and worked on Azure DevOps software to monitor the project.

Focused on data mapping, data modeling, normalization concepts to avoid the clusters.

Worked on Azure Synapse, Data Lake, SQL Data warehouse as Data Source, data storing, Analysis, processing purpose.

Developed stored procedures and views to streamline data analysis tasks and automate recurring reports.

Performed the concepts such as Data Integration, Cleansing, Transformation, Querying, Analyzing, Performance optimization using the Power Query.

Designed DAX measures to create custom aggregations for KPIs and metrics not readily available in source data.

Utilized Python packages such as Seaborn, Matplot, pandas, NumPy for efficient data extraction, transformation, and loading (ETL) from diverse sources like CSVs, and databases.

Built custom Python workflows for data cleansing, transformation, and validation to support analytics and reporting needs.

Came after the security mechanisms in Azure while transferring, sharing data from one system to another like generating the key vaults, assigning access to the concerned members, creating the Azure active directory.

Governed the Data Mapping, Data Profiling earlier and following the Data Migration, Analysis.

In the part of Data Visualization also generated many reports & dashboards on Power BI to predict& avoid the risks, convert the raw data to insightful visualizations.

Wrote many DAX functions for accurate and meaningful visualizations and created the new measures, new columns, Filters, Slicers for better interactive visualizations.

Created Gateways for the on-premise data sources to refresh and schedule the reports/dashboards and datasets.

Deployed the workbooks, dashboards to Power BI services, worked on scheduling while publishing them to services.

Environment: Azure, Power BI (Desktop, Services), gateways, Looker, SQL, DAX, Azure DevOps, Python, Excel.

Jr. Data Analyst, ATOS, India Dec 2018 – July 2021

Project Description: Deliver data analysis solutions to optimize financial operations and enhance healthcare service delivery, Improved decision-making for financial and healthcare clients through enhanced data visibility, regulatory compliance, and operational efficiency.

Roles & Responsibilities:

Involved in reviewing business requirements and analyzing data sources, profiling data to create Tableau Dashboards

Created business reports by understanding the significance of reporting numbers that answer top level business questions.

Stored, Analyzed, Validated, manipulated data simultaneously written many complex queries like sub queries, where conditions and join operations for data performance tuning.

Extensively involved in validating final reports to check data Integrity and consistency across various reports.

Reviewed SQL queries and refined data in Tableau Desktop by connecting live/dynamic and static datasets.

Created parameters, calculated fields, filter, groups, and data blending in Tableau to create reports as per requirements.

Involved in testing the SQL scripts for Tableau Worksheets, dashboards, scorecards, and performance issues effectively.

Scheduled data refresh on Tableau Server for daily, weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Assisted in Data collection, Data Validation process to support data Analysis.

Environment: SQL Server, SSMS, Tableau, Jira, Excel, Word.

Program Executive, RFC Jun 2017– Dec 2018

Project Description: Worked as a part of the Media Operations and Marketing Analytics team to support data-driven decision-making for advertising campaigns across digital, TV, and OTT platforms. This involved a blend of data handling, agile planning, collaboration with production teams, and campaign performance optimization to enhance viewer engagement and ROI.

Roles & Responsibilities:

Assisted in Data collection, Data Validation process to support data Analysis.

Attended Daily, Weekly, Monthly meetings with higher authorities like Department Head, Cluster Head as well as with team members.

Collaborated and coordinated with a team of five production people which are out-side of the organization to get smooth and seamless business output.

Worked on Jira software to plan, track, manage the agile methodology for easy work follow.

Board and Sprint Burndown Chart at the start of every Sprint, attend all Scrum meetings and continually work with the Team and business to find and implement improvements.

Imported data and generated reports of viewers, employees, programs, Channels, production houses using MS Excel.

Designed and developed Dynamic Dashboards which help in better understanding of Business trends.

Strategized, planned, and executed multi-platform ad campaigns across digital, TV, and OTT channels to maximize audience reach and brand impact.

Collaborated with creative and production teams to develop compelling ad content aligned with channel branding and audience preferences.

Analyzed channel performance metrics and ad engagement (CPM, CTR, viewership) to optimize ad placements and timing for peak visibility.

Managed media buying and ad inventory across regional and national channels, ensuring alignment with client objectives and budget constraints.

Utilized YouTube Studio to track ROI and performance of digital channel ads.

Created detailed post-campaign reports summarizing audience reach, impressions, and conversion metrics to inform future strategy.

Negotiated advertising rates and packages with broadcast networks, securing cost-effective spots during high-visibility time slots.

Environment : Excel, Youtube studio, Word, Adobe, PPT, Pivot tables, Jira.

Contact this candidate