Summary
Overview
Work History
Education
Skills
Responsibilities:
Timeline
Generic
Anantasai Gummadi

Anantasai Gummadi

Data analyst
Bangalore

Summary

Having 8 years of total experience as a Data Analyst and expertise in creating compelling reports and dashboards using Power BI. Also, having good working knowledge on tools like SQL Server, Advanced Excel, Google Data Studio.

Overview

9
9
years of professional experience
2
2
years of post-secondary education

Work History

Senior Data Analyst

Unisys Indian PVT LTD
Bangalore
06.2017 - 12.2023
  • Job Profile:
  • Responsible for designing, developing, and implementing business intelligence solutions using Microsoft Power BI.
  • Having experience on Advanced Excel having knowledge of VBA and working knowledge on Macros.
  • Excellent spreadsheet skills with good working knowledge of Pivot charts and tables.
  • Specialist in MS PowerPoint, Data Analytics where been involved in data management, dashboarding, reporting, and performing data analysis using analytical tools like Excel and Microsoft Power BI.
  • Having good knowledge on Google Sheets & Google Data Studio.
  • Skilled in Data analysis, Data Visualization, Data Manipulation, Modelling, Dashboards and direct connectivity to data sources in Excel and Power BI.
  • Expert in core excel with hands on experience in excel shortcuts, Logical functions (IF, AND, OR) summary (SUM IF, COUNT IF, AVERAGE IF etc.), pivot tables and other tools available in Data analysis tool pack.
  • Expert knowledge in VLOOKUP, HLOOKUP and other important & complex functions and formulas.
  • Working knowledge of Power Query- importing data and managing queries, appending queries, merge queries, filters and other row and column transformations in power query.
  • Having fundamental knowledge on SQL.
  • Proficient in writing Excel Functions, DAX Functions and Operators and understanding of M Language & Self-starter/able to work independently in Power BI projects.
  • Good in transforming data into meaningful insights and recommendations for business partners from various areas and companies.
  • Good language proficiency in English, Strong tool knowledge and functionality understanding & Strong written and verbal communication skills.

Data Analyst

Cap Gemini Business Services
Bangalore
01.2015 - 05.2017
  • Job Profile
  • * Worked in Logistics Department with Stronghold in blending different data sets including financial, operational and logistics data using various tools.
  • * Excels in creating operational, executive and analytical dashboards by using Excel interactive dashboards and Google Sheets using Macros, VBA & Slicers.
  • * Knowledge of end-to-end project planning & designing solutions. Worked on projects with Advanced MS Excel, Google Sheets, good knowledge on Power BI to create reports and Dashboards, Power Query, Data modelling and DAX.
  • * Text Function, Date & Time Function, Logical function and Conditional Formatting, Pivot Table, Macros, Charts, Dashboard and much more. Knowledge of Shrinkage, Attrition, Forecasting, Goal Seek, Utilization Scheduling WFM tools.
  • * Good Knowledge of SQL FUNDAMENTAL with its all-basics statements for reporting purpose.
  • * Experienced in Data Manipulation and Data Transformation, Aggregation.
  • * Good Knowledge on data migration and data quality check projects.
  • * Brilliant communication, organizational, leadership and interpersonal skills with ability to work with stakeholders across all levels

Education

B.Com -

Chetan Hi Tech College For Management & Studies
Davangere, India
01.2012 - 01.2014

Skills

Languages : DAX, VBA, SQL (DQL)

undefined

Responsibilities:

• Monitoring and tracking total sales figures to assess overall revenue performance and support strategic decision-making. 

• Conducting an in-depth analysis of revenue streams, including premium and claims revenue, to provide actionable insights for financial decision-making. 

• Comparing actual revenue against predefined targets to assess performance and strategize adjustments for goal attainment. 

• Currently, examining customer data to derive insights into behavior, preferences, and satisfaction levels, informing strategies for enhanced customer engagement and retention. 

• Ongoing analysis of inventory data to ensure accurate stock levels, optimize ordering processes, and prevent stockouts or overstock situations. 

• Continuously monitoring and updating the current status of inventory to facilitate efficient stock management and meet demand requirements. 

• Conducting ongoing assessment and analysis of expenses to identify cost-saving opportunities, streamline budget allocation, and enhance overall financial efficiency.

Timeline

Senior Data Analyst

Unisys Indian PVT LTD
06.2017 - 12.2023

Data Analyst

Cap Gemini Business Services
01.2015 - 05.2017

B.Com -

Chetan Hi Tech College For Management & Studies
01.2012 - 01.2014

Similar Profiles

CREATE PROFILE
Anantasai GummadiData analyst