Data Visualization Developer

Usha Akkina

Plainfield, IL

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

Ph: 216-***-****

Professional Summary

Experienced Power BI Developer with 7 years of expertise in making data easy to understand. Skilled in creating clear reports and dashboards using Power BI and SQL. I enjoy working with teams to improve decision-making through data analysis. Known for problem-solving and excited to bring my technical skills to enhance data visualization projects.

Skills and Qualifications:

1.Data Analysis

Experience in data analysis, including cleaning, transformation, and visualization

2.Power BI Proficiency:

Advanced skills in designing and building Power BI reports and dashboards.

Proficient in using DAX (Data Analysis Expressions) for creating calculated columns, measures, and complex calculations in Power BI.

Used Power query editor to transform and model the data as needed

Demonstrated ability to optimize report performance in Power BI through efficient data modeling techniques.

3.Data Flows:

Ability to implement and optimize data flows for efficient data processing.

4.Relational Database Understanding:

Experience in connecting Microsoft Power BI to SQL Server data sources.

Proficiency in writing SQL queries to retrieve, manipulate, and analyze data from relational databases.

5.SSAS (SQL Server Analysis Services)

Experience in pulling data from Analysis Services Cubes (Tabular model).

Knowledge in writing DAX queries to query the cube.

6.Azure Cloud Skills:

Experience in connecting Azure data lake tables to Power BI.

Proficiency in writing SQL queries for data validations.

Experience with Azure Active Directory for identity and access management.

7.Python:

Knowledge of using Python for data analysis and related tasks.

8.Communication:

Strong communication skills to engage with customers, vendors, and team members.

9.Problem Solving:

Analytical mindset to address complex data and reporting challenges.

Professional Experience:

International Monetary Fund Mar 2024 – Current

Senior Power BI Developer

Gathered business requirements from stakeholders to understand their needs.

Conducted data wrangling and performed data analysis to extract insights.

Utilized Power BI's query editor to transform and model data for reporting purposes.

Created mockup reports and presented findings to stakeholders for feedback and validation.

Experienced in extracting data from Analysis Services Cubes (Tabular model) for analytical purposes.

Conducted Proof of Concept projects to evaluate the limitations of different connectivity modes with SSAS cubes.

Worked on projects involving Budget Utilization and Travel Analysis to support business decision-making.

Bright Spring Health Services Dec 2021 – Dec 2023

Data Visualization Developer

Responsible for gathering business requirements from the stakeholder.

Worked as a solo developer for new line of business acquired by the company which involves complex projects with high end user visibility.

Developed over 10+ reports and dashboards resulting in a 25% increase in operational efficiency.

Experience is pulling data from Azure data lake into Power BI.

Used Power BI's query editor to transform and model the data as needed

Experience in creating complex calculations using DAX.

Created highly user-friendly visuals like Slicers, Lines, Matrix, Bar, column charts etc.

Worked with multiple drill through and drill down reports.

Involved in Data analysis and end-to-end QA thereby providing accurate reports to the stakeholders.

Collaborated with cross-functional teams to fix data issues.

Responsible for updating existing models, which greatly improved the performance of the reports.

Implemented Row level security to restrict end user access to PHI information.

Provided Support to business users as and when required.

Capgemini Aug 2021 – Nov 2021

Sr. Consultant / Power BI Developer

Analyzed business requirements for the creation of the reports for OFFICE365 Licenses.

Worked with various data sources like Excel and CSV files, SharePoint folder, azure active directory.

Extracted the data from the flat files and transformed them into required format using Power Query.

Involved in the creation of the data model.

Created visualizations and published them into Power BI service.

Used Power BI gateway to refresh the reports for on-prem data sources.

Involved in giving POC to the client for Power BI Sybase database connectivity issue.

Guided the team in gathering requirements for the report migration.

Involved in coming up with use cases for giving POC to a new customer about how Power Bi can help solve their business needs.

Experienced in configuring and maintaining Power BI service for content sharing; and managing the Premium Capacity of Power BI service.

Created Paginated Reports using Power BI Report Builder.

Mastercard May 2019 – Mar 2021

Sr. Power BI Developer

Analyzed business user requirements, data, and designed software solutions in Power BI Desktop based on the requirements.

Created dashboards and visualizations using best practices based on business needs connecting to Azure data lake.

Used JIRA for tracking the report progress.

Built and published interactive reports and dashboards using Power bi Desktop.

Created pie and bar charts and combined them into dashboards to show top content viewed by customers in each category including interaction between the two charts for drill down analysis.

Analyzed data from various databases and formatted it into graphs using Power BI Desktop.

Restricted data for users using Row-Level security and user filter.

Created parameters, calculated tables, columns, and measures using DAX calculations to prepare detailed data visualization.

Experience working with various data source like Oracle, SQL Server

Creating basic calculations including string manipulation, basic arithmetic calculations, custom Aggregations and Ratios.

Visualize and communicate findings using reports and dashboards and provide a quantitative framework for evaluating and analyzing alternatives.

Experience in Power BI to design Interactive Reports using Power Query, Power Pivot and Power View.

Handling changes requests and providing support/maintenance for deployed projects.

Creating the data sources for the required reports.

Proficient in using different ticketing tools like BMC Remedy and ALM

Documented the reports in Confluence.

University of California Mar 2017 – Apr 2019

Sr. Power BI Developer

Imported data from SQL Server DB to Power BI to generate reports.

Reduced the dataset size to only the information needed by creating views in SQL server.

Created Dax Queries to generated computed columns in Power BI.

Working with team of developers designed, developed, and implement a BI solution for Sales, Marketing and Product KPIs.

Generated computed tables in Power BI by using Dax.

Built metric reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service.

Used Power Query to acquire data and Power BI desktop for designing rich visuals.

Created basic reports using files as source to fetch the data in Power BI. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.

Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.

Developing visual reports, dashboards and KPI scorecards using Power BI desktop.

Connecting to data sources, importing data and transforming data for Business Intelligence.

Adept in developing, publishing and scheduling Power BI reports as per the business requirements.

Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.

Independently worked on different stages of SDLC by gathering requirements, managing development, providing support and documentation processes thereby ensuring timely deliverables and uninterrupted continuity of business.

Good knowledge with Linux commands.

Used Remedy for handling change requests and customer WO’s.

Enterprise Oct 2016 – Feb 2017

Power BI Developer

Developed visual reports and KPI scorecards using Power BI desktop.

Troubleshoot performance-related issues with Power BI reports/dashboards, scheduling, and direct query.

Used time intelligence function to measure business metrics.

Implemented application security layer model using Row Level Security RLS in Power BI desktop.

Created drill-down reports and paginated reports using Report Builder

Created systems for capturing error data in a flat-file using flat-file destination, sending the error data in the flat file attached to the corresponding mail ids using Sent Mail Task, and correcting error data.

Used transformations including Derived Column, Conditional Split, Aggregate, Row Count, and sort and execute SQL Task to load data into Data Warehouse.

Created Event Handlers to Handling Errors and Debugging for the Packages.

Created Jobs and implemented it for scheduling the SSIS packages daily.

Defined data sources, data source views, dimensions, measures, hierarchies, attributes, calculations, KPI’s, perspectives, and roles.

Calculated measures and dimension members using MDX, mathematical formulas, and user-defined functions.

Education

Master’s in Computer Science at Southern Illinois University Edwardsville Dec 2008

Contact this candidate