Summary
Overview
Work History
Education
Accomplishments
Additional Information
Certification
Software
Interests
Declaration
Timeline
Generic

BHANU TEJA NITTALA

Data Analyst
Hyderabad,TELANGANA

Summary

Detail-oriented, organized and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team player ready to contribute to company success.

Overview

1
1
year of professional experience
5
5
years of post-secondary education
1
1
Certification
2
2
Languages

Work History

Data Analyst

LEGATO HEALTH
HYDERABAD, TELANGANA
03.2021 - 04.2022

• Creating dashboards, volume reports, operating summaries, and presentations and graphs in Power BI Desktop.

• Injected records from Flat file sources to SQL Server using Direct and Import Mode.

• Implementation RLS in Power bi reports Dynamic and Static,

• Creating reports using Dynamic with slicer and hierarchical visuals.

• Import custom visuals and developed the Power BI Reports.

• Created various objects using built in functions like prompt, select, where, and aggregate, complex report level filters and contexts and complex SQL queries and joins involving case statements etc.

• Worked with different transformations like Data conversion, derived column, Conditional Split, lookup transformations.

• Implemented error handling, created checkpoints, configuration files, log files in the packages.

• Developed the Power BI reports and deployed the reports on Power BI app portal.

Education

Bachelor of Computer Applications - Computer Applications

Rajiv Gandhi Degree College
RAJAMHUNDRY
07.2016 - 03.2021

Accomplishments

  • Awarded with the Best Employee of the Quarter for excellence in making accurate reports.
  • Used Microsoft Excel to develop inventory tracking spreadsheets.
  • Supervised team of 3 staff members.
  • Made recommendations on business intelligence tools to cut processing time by 10-20%.

Additional Information

  • Having around 1 year of professional experience with Business Intelligence as well as (Power BI and SQL).
  • Good Experience with Power BI tools Like Data visualizations, Power Query, Power Pivot and DAX Functions.
  • Thorough Knowledge on Data Warehouse concepts like Star Schema, Snow Flake, Dimension and Fact Tables.
  • Having great experience to work with Creating Book marks, Buttons, and Selection pane as well.
  • Good Experience with creating Drill through, Drill down and Drill up. Great Experience to work with Conditional formatting.
  • Good Experience to work with the Visualization like tacked Column chart, Stacked bar chart, Donut chart, Pie chart, Tree map, gauge Card, Combo chart, Funnel chart.
  • Worked on Custom Visualizations like multi slicer and Hierarchy slicer.
  • Worked on DAX expressions like Time intelligent Functions like QTD, MTD, YTD, and also all the aggregation Functions.
  • Comfortable in working with filters/calculated columns/measures/relationships and transformations of Edit Query section.
  • Published/shared the reports by creating Content Pack/Sharing the pbix file.
  • Worked on Both the gateways like On Premises and Personal Gate way.
  • Implemented RLS For Securing the data link. Dynamic and Static Level.
  • Understand and fix data quality issues, handle special characters in data from source data through transformations and SQL queries.
  • Having great experience to Build Relationship the mean while having great experience with all the cardinality Functions.
  • Expertise in implementing business logic using Views and Stored Procedures etc.
  • Writing the Stored Procedures which meet the requirements.
  • As per requirements developed the reports in the form of Matrix, Table and Chart.
  • Good in writing SQL Queries & SQL Joins, Union, Union all , Intersect, Except, Merge, Case statements, Set Operators Constraints.
  • Good Experience in writing SQL Functions like Aggregate Functions, String Functions & Date Functions.
  • Experience in the implementation of Common Table Expressions (CTE), implementation of Rank Functions, Temporary Tables, Table Variables and String Functions. Very good knowledge in SQL programming skills and Experience in creating indexes & views using SQL. Understanding the reports requirements and experience in working on power bi design and developing

Certification

  • Rata Fast Typing

Software

  • MS-Office
  • Power BI
  • Tableau
  • SQL

Interests

  • Cricket
  • Reading Spiritual Books

Declaration

I hereby declare that all the information given above is true and correct to the best of my knowledge.

Timeline

  • Rata Fast Typing
05-2022

Data Analyst

LEGATO HEALTH
03.2021 - 04.2022

Bachelor of Computer Applications - Computer Applications

Rajiv Gandhi Degree College
07.2016 - 03.2021
BHANU TEJA NITTALAData Analyst