Bharathi Sriramulu

Bharathi Sriramulu

Sr.Power BI Developer
United Arab Emirates

About Me

• Possess 5+ years of experience in Power BI, DAX (Data Analysis Expression), and

Microsoft BI Tools - SSIS, SSRS with SQL Server

• Experienced in SSIS for ETL Tasks, SSRS for report deployment on Report Server
• …

Experience

Sr BI Developer

GLITZ TECHNOLOGIES PRIVATE LIMITED
Nov 2016 - Present · 9 years 8 months

Conducted ETL Operations in SSIS for Data Flow Tasks, Aggregation, Data Conversion
Involved in the Design of Reports like Drill Through, Tabular, Drill Down, Matrix and Sub Reports in SSRS
Implemented business functionality using DAX functions
Created analytical dashboard with insight on history, trends, time series, charts
Created reports with highlights, drilldown, cascading prompts, descriptive and analytical charts
Worked on different native visualizations and custom visualizations
Scheduled data refresh, managing groups, datasets, reports, and dashboards
Used Filters are for specific visuals, entire pages, or whole workbook
Implemented Row Level Security by defining various constraints for each defined role.
Experienced with Power BI Cloud Configurations and Workspace Creations & Settings.
Worked on On-Premises Gateway and deployed Power BI Service, setting up App Workspaces, Subscriptions
Involved in creating, designing packages, deploying and scheduling by using the Existing tasks and transformations in SSIS.
Develop Tabular Reports, List Report, and Matrix Reports in multiple forms using SSDT in SQL Server Reporting Services (SSRS) Environment.
Creating reports with various visualizations required and implementing business logics.
Used analytics protocols and time intelligence functions in DAX for analytical comparisons.
Implemented drill down and book-marking options and parameters wherever required.
Constructing or ensuring appropriate Data Model before report development.
Created calculated columns and measures using DAX based on business need.
Working on data preparation by converting, changing data formats and eliminating
Worked on On-Premises Gateway to refresh the data sources.
Participated in dash board creation and content pack usages.
Creating database objects like procedures, tables, triggers.
Implementing Slowly Changing Dimensions to maintain historical data in required Dimension Tables.
Building analytical dashboards using Power BI to help business partners in better decision making.
Created multiple dashboards with Power BI Desktop for data visualization through various charts such as bar charts, line charts, scatter plots, pie charts and custom charts.
Experience in creating calculated measures and columns with DAX.
Creating different type of reports including Cross-tab, Master Detail reports using Power BI.
Involved in loading historical, incremental data loads.
Creating a drill down and drill up through reports.
Experience in Custom visuals and creating custom Groups and Expert in using advanced calculations using power BI desktop.

Sr BI Developer

GLITZ TECHNOLOGIES PRIVATE LIMITED
Nov 2016 - Present · 9 years 8 months

Conducted ETL Operations in SSIS for Data Flow Tasks, Aggregation, Data Conversion
Design of Reports like Drill Through, Tabular, Drill Down, Matrix and Sub Reports in SSRS
Implemented business functionality using DAX functions
Created analytical dashboard with insight on history, trends, time series, charts
Created reports with highlights, drilldown, cascading prompts, descriptive and analytical charts
Scheduled data refresh, managing groups, datasets, reports, and dashboards
Implemented Row Level Security by defining various constraints for each defined role
Experienced with Power BI Cloud Configurations and Workspace Creations & Settings
Worked on On-Premises Gateway and deployed Power BI Service, setting up App Workspaces, Subscriptions

Sr. Power BI Developer

Glitz Technologies Pvt Ltd
Nov 2016 - Mar 2022 · 5 years 4 months

Experienced in SSIS for ETL Tasks, SSRS for report deployment on Report Server
• Proficient in Power BI data driven tasks like analysis, extraction, cleaning, validation, summarization, manipulating, creating datasets and generating reports.
• Proficiency in SQL and Power BI for various data driven tasks like analysis, extraction, cleaning, validation, summarization, manipulating, creating datasets and generating reports.
• Good knowledge on MS Power BI concepts like Data Modelling, DAX Functions, SSIS and created various views in Power BI (Bar charts, Line charts, pie chart, Heat Maps, Bubble Charts and maps etc.,).
• Experience in creating interactive dashboards using Power BI. Designing, building and deploying, publishing data in services.
• Experience in handling large data sets to perform complex data manipulations and writing pre-processing macros.
• Experience in designing and development of MIS, business reporting and ad-hoc analysis.
• Communicate with end users, gather requirements, code/configure, maintain, test, and debug modifications to existing applications of basic to high complexity or execute the same in the development of new applications.
• Proactively communicates development status, issues and concerns to management with mitigation recommendations.
• Visualize data and information for business customers through the creation of reports and queries using Microsoft's technology stack.
• Create Power BI reports based on business requirements with linked content, drilldowns, and nested parameters.
• Optimize Microsoft Power BI dashboards with a focus on usability, performance, flexibility, testability, and standardization.
• Develop concepts of reports, analytics and visualizations development, using DAX, SQL, tuning, data models and semantic models.
• Understand cloud migration techniques (on premise to Cloud Platforms)
• Create and administer App Workspaces to control permissions and access to PBI dashboard.
• Ensure reports meet data accuracy, query performance, usability and functionality requirements.
• Leverage MS BI tools to answer questions, solve problems, and create reporting solutions.
• Create technical and maintenance documentation as needed.
• Communicate effectively with both business, technical stakeholders as well as leadership
• Pulling the data from all types of Databases in the world/ all types of flat files.
• Data cleaning and Data Mining as per the business requirements to get best visuals.

Sr Business Intelligence Developer

Oriental Bank of Commerce (Department of Information Technology)

Creating, designing packages, deploying and scheduling by using the Existing tasks and transformations in SSIS
Develop Tabular Reports, List Report, and Matrix Reports in multiple forms using SSDT in SQL Server Reporting Services (SSRS) Environment
Creating reports with various visualizations required and implementing business logics
Used analytics protocols and time intelligence functions in DAX for analytical comparisons
Implemented drill down and book-marking options and parameters wherever required
Constructing or ensuring appropriate Data Model before report development
Created calculated columns and measures using DAX based on business need
Working on data preparation by converting, changing data formats and eliminating
Worked on On-Premises Gateway to refresh the data sources
Participated in dash board creation and content pack usages
Creating database objects like procedures, tables, triggers
Implementing Slowly Changing Dimensions to maintain historical data in required Dimension Tables

Business Intelligence Developer

Qualcomm

Building analytical dashboards using Power BI to help business partners in better decision making
Created multiple dashboards with Power BI Desktop for data visualization through various charts such as bar charts, line charts, scatter plots, pie charts and custom charts
Experience in creating calculated measures and columns with DAX
Creating different type of reports including Cross-tab, Master Detail reports using Power BI
Involved in loading historical, incremental data loads
Creating a drill down and drill up through reports
Experience in Custom visuals and creating custom Groups and Expert in using advanced calculations using power BI desktop

Skills

Business Analytics Data Analysis Professional Excel SQL Server Business Intelligence SQL Server Integration Services (SSIS) Power BI DAX SSRS Data Modelling Data Analysis ETL Data Visualization Microsoft BI Tools SQL Data Cleaning Data Mining Data Manipulation Report Development Dashboard Design MIS Business Reporting Ad-hoc Analysis Requirements Gathering Debugging Query Performance Optimization Technical Documentation Communication Data Migration App Workspaces Administration Data Accuracy Problem Solving Reporting Solutions Visualizations Development Cloud Migration Row Level Security Performance Optimization R&D End-to-end Experience New Technologies Learning Microsoft BI Oracle SSAS Tabular Model Tableau JIRA Confluence SharePoint MS Office Windows SSDT
Report this Profile?