Power Bi Sql Server

Chachidak Manjula Enumula

**** ********* ***, ********, **, 37363 Ph: 423-***-**** Email: ***********************@*****.***

Summary

Experienced Power BI Developer with over 5 years of experience in creating interactive and insightful dashboards and reports. Proficient in Power BI Desktop, DAX, and data modeling with a strong background in SQL and ETL processes. Adept at transforming complex data into actionable insights and collaborating with stakeholders to drive business decisions.

Skilled in performing data transfer between heterogeneous systems (Excels, Flat Files, XML File, JSON) and SQL Server as part of data migration, data maintenance.

Imported data from different data sources like SQL Server DB to Power BI for Vetting Business users and published concerned reports to BI portal.

Expertise in publishing Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server.

Developed and implemented reporting, analytics, and Data visualization solutions with Power BI

Working knowledge of Power BI and DAX.

Design and implement reporting solutions using Reporting Services, Power BI and other data visualization tools

Design and develop reporting data module for Marketing Analysis

Creating Row Level Security with Power BI desktop and integration with Power BI Service portal.

Experience in optimizing reports and setting up Power BI service, gateways, and scheduling data refresh.

Experience at creating, configuring and maintaining system database.

Collaborated in Software Development Life Cycle using different methodologies.

Skills:

BI Tools: Power BI

Languages: DAX, SQL

Databases: SQL Server, MySQL, PostgreSQL, etc.

Data Visualization: Charts, graphs, maps

Other: Excel, SharePoint

PROFESSIONAL EXPERIENCE

ESS

Feb 2024 – till date

Business Intelligence Developer

Responsibilities:

Designed and developed interactive Power BI dashboards and reports for key business metrics, resulting in a 25% improvement in decision-making speed.

Created complex DAX measures and calculations to meet business requirements and provide deep insights into sales and marketing performance.

Integrated data from multiple sources, including SQL databases and Excel spreadsheets, to provide a unified view of organizational data.

Collaborated with business stakeholders to understand their requirements and translate them into effective visualizations and reports.

Cleaned and transformed data using Power BIs Query Editor to create Dashboards.

Created and modeled datasets from SQL Server, Excel, CSV, JSON.

Developed over 20+ reports, visualizations, and dashboards.

Created technical documentation related to reports and dashboards.

Conducted training sessions for end-users, increasing the adoption rate of Power BI tools by 30%.

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

Environment: Ms SQL, Power BI Desktop, Power BI Dashboard, Azure, JIRA.

Avani Tech Solutions

Jan 2013 – Dec 2017

BI/SQL Developer

CEIPAL, an end-to-end workforce management platform, comes to the rescue of enterprises by equipping them with the capability to take care of the complete lifecycle of workforce management. It has leveraged the platform to address every strata of workforce management, starting from hiring and managing employees to collecting payroll data and sending it to payroll processing agencies

Responsibilities:

Cleaned and transformed data using Power BIs Query Editor to create Dashboards.

Created and modeled datasets from SQL Server, Excel, CSV, JSON.

Developed over 20+ reports, visualizations, and dashboards.

Created technical documentation related to reports and dashboards.

Worked with Business Analysts to understand the business rules, performed the impact analysis of implementing them

Analyzing and modeling of Data

DAX used for creating calculated columns, measures and advanced calculations.

Analyze user requirements to define business objectives

Provide regular updates on status of tasks to the supervisor.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.

Implemented both direct and import query methods in the power BI.

Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.

Optimized the performance of existing TSQL queries with utilization of query optimization techniques such as indexes, table partitions, CTE's, execution plans, and made structural changes to queries.

Implemented Row level Security

Environment: Ms SQL, Power BI Desktop, Power BI Dashboard, Java, Maven, Jira, GIT, Windows XP.

Education

Sri Padmavathi Women’s University, Andhra Pradesh, India, M.C.A (Master of Computer Applications), 2010

Kakatiya University, Warangal, Telangana, India, B.Sc (Graduation), 2006

Professional Organizations

ESS, USA, Business Intelligence Developer, Feb 2024 – till date

Avani Tech Solutions, Hyderabad, BI/SQL Developer, Jan 2013 – Dec 2017

Contact this candidate