Name: YegitiVenkate

Senior Power BI Developer+ 5 YEARS

Summary of Qualifications

Intend to build a career with a leading corporate high-tech environment with committed and dedicated people who will help me to explore myself fully and realize my potential.

I'm willing to work as a key player in a challenging and creative environment.

• Having 5 Years of progressive experience in Power BI for Business Analysis, Reporting and Dash-boarding for enterprise applications and experience on Power BI Desktop,power Query,DAX and power BI Service.
• Gathering the business requirements, analyzing and developing reports as per the requirements
• Developed different visualisations like bar chart, pie chart ,Scroller, line chart and Guage chart.
• Experienced in developing Power BI reports and dashboards from various Data Sources like Databases, Excel files
• Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design using Power BI.
• Worked on Power BI administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes.
• Strong hands-on experience implementing dash boarding, data visualizations, and analytics using Power BI desktop and Power BI Services.
• Created different KPI's using Table calculations and calculated key figures Manipulating strings, arithmetic calculations, aggregation options and Logical functions
• Sets to create detail level summary reports and Dashboard using KPI's
• Designing visualizations with functionality like Drill Down, Slice & Dice, Drop down and Parameters using Power BI
• Strong understanding of advanced Power BI features including DAX, Power Query, calculations, Table Calculations, parameters, row-level security, joins, data blending, and actions.
• Developed Power BI workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis
• Proficient in writing SQL queries in MS SQL SERVER.
• Utilized Power BI services to publish and share the reports with the business users
• Creating Users, Groups and Projects on Power Bi Services.
• Implemented role-based security as part of user level security in Power BI (RLS)

Programming Languages & Database Proficiency

Technologies

Power BI, Power Automate, DAX, Tableau, Data visualization and Reporting

Databases

MYSQL, SQL server 2012,2016,2019,DAX,M-Query(Power Query)

Integration Tool

SSAS, SSIS ( SQL Server Integration Services )

BI Tools

Power BI Desktop and Power BI

Version Control

Education

• B.SC(Chemistry )from Acharya Nagarjuna University in 2016.

 

Projects

Name: Smith & Hawken

Project Description:

Smith & Hawke was a garden lifestyle brand that operated retail stores, direct mail and e-commerce in the United States. On July 10, 2009, it was announced that all Smith & Hawke stores would cease operation. Smith & Hawke stores were located in upscale retail locations in 22 states.

Responsibilities:

Working in coordination with Clients for feasibility study of the project in Power BI and drawing up the timelines for designing the reports as per business requirement.

Utilizing capabilities of Power BI such as Data extracts, Dual axis, Data blending, Forecasting, Dashboard actions, Filters and Power BI calculations.

Designing dashboard templates as per the requirement & dashboards content which includes complex tabular reports, bar charts, water fall charts, Guage charts, Geospatial visualizations, donut charts etc.

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

Building, publishing customized interactive reports and dashboards, report scheduling using Power BI Services.

Developed Test Cases in Quality Centre for Functional and Regression Testing.

Created high level view, clubbing transactions and financials at one stage, which allows the user to drilldown from day the transaction happened till the day the transaction has been paid.

Produce standard weekly and monthly reports using Power BI.

Tools/Technologies: Power BI Services, Data Visualization and Reporting, SQL, DAX query, Charts, SSAS

Name: Flagler Global Logistics

Project Description:

Flagler Global Logistics is a Miami, Florida-based company that offers integrated third-party logistics, supply chain management solutions, and is the state's largest developer of industrial real estate.

Responsibilities:

Involved in end to end project delivery life cycle

Created Business Process Models from the requirement specifications.

Created reports to show the marketing trend between the customers showcasing their trial

Quarterly reports by creating multiple queries, sub queries, and merged dimensions, ranking features in single report

Created dashboards for business groups like finance and sales.

Developed Power BI data visualization using Donut charts, Card visuals, Slicers, Geographic Map etc.

Designed and publishing visually rich and intuitive Power BI dashboards for executive decision making.

Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.

Used Trend Lines, Reference Lines and Annotations to describe the data.

Created Data extracts for better performance and accessing data offline

 

Tools/Technologies: Power BI Services, Data Visualization and Reporting, SQL, DAX query, Charts, SSAS