Bheemagani S

Data Analyst

Calgary, Alberta, Canada7 yrs 10 mos experience

Highly Stable

Key Highlights

Expert in Power BI dashboard development and data visualization.
Strong SQL skills for data analysis and reporting.
Proven experience in business intelligence solutions.

Stackforce AI infers this person is a Business Intelligence Developer specializing in SaaS analytics and data visualization.

Contact

Skills

Core Skills

Power BiData AnalysisData VisualizationBusiness Intelligence

Other Skills

SQL ServerDAXETLData IntegrationSQLData CleansingData TransformationData PresentationBusiness Intelligence ReportingData ValidationCommunicationKPI DashboardsPowerViewBusiness RequirementsEasily Adaptable

Experience

7 yrs 10 mos

Total Experience

2 yrs 8 mos

Average Tenure

2 yrs 5 mos

Current Experience

Cisco

Power BI Developer

Jan 2024 – Present · 2 yrs 5 mos

● Translate business logic into dashboards, charts, reports, and presentations in support of the Sales & Marketing department.
● Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
Designing Microsoft Power BI dashboards and managing the power BI gateways with a focus on usability, performance, flexibility, testability, and standardization.
● Designing OTLP, OLAP databases and creating ETL packages, tabular models, and dashboards.
● Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
● Using Power BI, and Power Pivot to develop data analysis prototypes, and used Power View a Power Map to visualize reports available in Web clients and mobile apps.
● Utilizing Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management.
● Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
● Designed SSAS Cube and developed MDX queries for Analysis.
● Document steps needed to migrate database objects between environments including Development, UAT, Staging and production
● Meet with the business for defined requirements of the project.
● Provide production support of existing ETL process and develop cross-validation rules to ensure mapping accuracy for newly added business rules.
● Develop SQL queries or use available data profiling applications to perform data analysis based on the business requirement and created data profiling reports for data discovery.
● Develop new data integration and support existing datasets for BI teams.

Power BISQL ServerDAXETLData VisualizationData Integration+1

Cognizant

Power BI Developer

Oct 2021 – Dec 2023 · 2 yrs 2 mos

● Expertise in Data Cleansing using Power Query in Power BI Desktop Editor.
● Worked on all types of transformations that are available in the power bi query editor.
● Wrote DAX expressions to create new measures, and calculations per business requirements.
● Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
● Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.
● Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.
● Hands-on expertise in SQL reporting, development, analytics, or BI.
● Created Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database.
● Scheduled Automatic refresh and scheduling refresh in power bi service.
● 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.
● Wrote complex SQL queries in database Access and created various joins (inner, outer joins) to fetch the desired output for Data Analysis.

Power BIDAXSQLData CleansingData TransformationData Analysis

Accenture

Business Intelligence Developer

May 2016 – Aug 2019 · 3 yrs 3 mos

● Designed, developed, and tested solutions for business user-specified requirements to achieve desired business results.
● Participated in the daily standup with business teams to resolve business issues and Data challenges.
● Hands-on experience in the design, and development of end-user applications for data presentation and analytics, including scorecards, dashboards, reports, monitors, and graphic presentation (Information Visualization &Analysis) using BI.
● Experience using formula languages such as Data Analysis Expressions (DAX).
● Create reports in BI Desktop and Service utilizing the connectors and content pack.
● Expertise in creating reports from importing, Direct Query, and Live data from several data sources.
● Expertise in data transformations such as adding calculated columns, managing relationships, creating different measures, removing rows, replacing values, split columns, Date & Time Column, etc.
● Created different reports in BI Desktop and publish to Power BI online.
● Skilled at querying relational databases (SQL) and the ability to pull data from various sources.