Post Job Free

Resume

Sign in

Customer Service Reporting Analyst

Location:
Hyderabad, Telangana, India
Posted:
December 09, 2022

Contact this candidate

Resume:

RESUME

Name:- Mahesh.Challagunda Contact:- +91-628*******,

Email:- adtx4d@r.postjobfree.com.

PROFESSIONAL SUMMARY:

Highly focused and detail-oriented Reporting Analyst with 5 years career experience in Software, legal research and Finance environments. Dedicated professional with exceptional skill in data collection, analysis, and reporting. Deadline-driven and budget-conscious team leader with excellent problem-solving and written and verbal communication skills.

EXPERIENCE PROFILE: -

Name of Company : Resilient Innovations Private Limited(Bharatpe)

Period : Feb 2022 to Till Now

Designation : PowerBI Analyst.

Name of Company : GUS Education India LLP

Period : 07 Months (Aug 2021 to Feb 2022)

Designation : PowerBI Analyst.

Name of Company : TELEBU COMMUNICATIONS LLP

Period : 1.5 Years (Aug 2019 to Dec 2020)

Designation : Operations Analyst.

Name of Company : Quislex legal services

Period : 1.9 years (Dec 2017 to Aug 2019)

Designation : Information analyst.

Key Roles & Responsibilities: -

Created reports to users in Power BI by connecting various data sources (Google Sheets, Internal servers, MS Excel).

Designed near-real time monitoring Dashboards for Tableau server and Visualization users.

Monitoring Usage Report of their Workbooks and Data Sources.

Analyzed data and reporting requirements and designed marketing dashboards in Tableau Desktop that tracks letter performance.

Monitoring Usage Report of their Workbooks and Data Sources.

Ensure key trends, issues, watch items are brought forward from MIS into Management Summaries clearly and accurately.

Research, update, and validate data underlying spreadsheet production; strategically fill gaps.

Handling & Analyzing Huge Raw data and creating a simple report based on requirement.

Supporting team by continuous learning and accepting challenging tasks.

Preparing Gantt charts, Dashboards for better understanding of process.

Develop and implemented standard operating procedures to bridge data gaps and resolve related issues.

Responsible for assigned HR Reports and sales targets (monthly, quarterly, and annually).

Goals set for centers month on month, maintaining relationship with target customers, customer service, ensuring high rate of return on investment, sales support, and sales.

Coordination with sales managers and HR Manager for HR reports and sales report (Revenue and Sales Accounts).

Importing & exporting data from various data sources.

SKILL SET: -

Power BI: -

Identify key performance indicators (KPIs) with clear objectives and consistently monitor those

Analyzing data and present data through reports that aid decision-making

Convert business requirements into technical specifications and decide timeline to accomplish

Create relationships between data and develop tabular and other multidimensional data models

Chart creation and data documentation explaining algorithms, parameters, models, and relations

Developed profit analysis reports and dashboards by products and customers

Worked on all types of transformations that are available in Power bi query editor.

Scheduled Automatic refresh and scheduling refresh in power bi service.

Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.

Created reports using time intelligence calculations and functions.

Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps

Explore data in a variety of ways and across multiple visualizations using Power BI

Used Power BI Gateways to keep the dashboards and reports up to date.

Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.

Published reports and dashboards using Power BI.

SQL: -

Downloading Data from Metabase.

Table creating and updating.

SQL Table connect to Power Bi and Google data studio for report automation.

Query Edit for old table’s

Google Data Studio: -

Create relationships between data and develop tabular and other multidimensional data models.

Filter creation in the dashboards

Connecting various data sources (Google sheets, internal servers, PostgreSQL and Ms excel)

Creating Blonde data

Security creation user wise data source.

Dashboards creating and editing.

Metric creation.

ADVANCED EXCEL: -

Advanced formulas: - Vlookup, Hlookup, Sum, Sumif, Sumifs, Count, Countifs, Condition formats and References, Data validation.

Preparing the Dashboards.

Charts: - Column, Line, Bar, Charts.

Merging different sheets in a workbook.

Pivot tables-pivot charts.

Advanced filtering, data validation.

Conditional formatting with formulas.

INTERESTS & VISION: -

To work in global environment.

To become expert in reporting and data management.

To work in different environments in different verticals.

Project management skills.

ACADEMIC CREDENTIALS: -

MBA from RK College of engineering technology, Kethanakonda, under JNTU Kakinada University with the 68% during 2013-2015.

Degree from Narayana memorial Degree College, kanchikacherla under Krishna University with 58% during 2010-2013.

Intermediate from sai sidharda junior college, kanchikacherla under Board of Intermediate Education 63% during 2009-2010.

S.S.C from z.p.h School, Paritala. Under Board of Secondary Education with 64% during 2007-2008.

Academic projects: -

A study on capital budgeting with refers to kcp sugar private limited from 05th May 2015 to 07th June 2015.

Project description: -

The main objective is to study the technique of capital budgeting for decision- making.

PERSONNEL DETAILS: -

Name : Mahesh.Challagunda

Father’s Name : Nageswara Rao. Challagunda

Dob : 01-01-1993

Marital Status : Married

Nationality/Religion : India/Hindu

DECLARATION: -

I am here by informed that the information given by me is true with the best of my knowledge.

Place: - Hyderabad

Date: - (Mahesh. Challagunda)



Contact this candidate