gowthami pemmadi

Business Data Analyst

Hyderabad 6+ yrs exp 90 · Outstanding

About

Business Data Analyst with 4+ years of experience in IT Reporting, Business Intelligence, SQL Server, Python ETL, Power BI, Spotfire, Salesforce CRM Analytics, and ServiceNow Analytics. Experienced in developing enterprise dashboards, automating reporting pipelines, integrating ITSM data, and delivering KPI-driven insights to business stakeholders. Skilled in stakeholder collaboration, reporting automation, dashboard optimization, and data-driven decision making.

Skills & Expertise (15)

Excel Advanced

8.5/10

Years Exp

SQL Advanced

8.0/10

Years Exp

SQL Server Advanced

8.0/10

Years Exp

Dashboard Development Advanced

8.0/10

Years Exp

Python Pandas Intermediate

7.5/10

Years Exp

Power BI Intermediate

7.5/10

Years Exp

MySql Intermediate

7.0/10

Years Exp

KPI Reporting Intermediate

7.0/10

Years Exp

ServiceNow Intermediate

7.0/10

Years Exp

NumPy Intermediate

6.5/10

Years Exp

Data Modelling Intermediate

6.5/10

Years Exp

Matplotlib Intermediate

6.0/10

Years Exp

Data Validation Intermediate

6.0/10

Years Exp

Azure Intermediate

5.0/10

Years Exp

AWS Intermediate

5.0/10

Years Exp

Work Experience

Data Analyst

TCS

Nov 2021 - Present

As a Data Analyst at TCS, I worked on a ServiceNow analytics and automation initiative focused on Incident, Change Request, Problem Request, and RITM ticket data to improve operational visibility and SLA performance tracking. I was responsible for daily data extraction, transformation, and refresh by integrating ServiceNow data into SQL Server, where I developed optimized SQL queries and Python automation scripts to eliminate manual reporting. I designed and maintained dashboards that provided insights into ticket trends, SLA breaches, aging analysis, workload distribution, and overall team performance. Through continuous analysis of historical and real-time data, I supported stakeholders with actionable insights that improved monitoring efficiency, data accuracy, and decision-making.

Salesforce Admin & Data Analyst

TCS

Feb 2022 - May 2023

As a Business/Data Analyst at TCS, I worked on Salesforce-focused engagements for clients including Ericsson and Proximus, supporting license optimization, CRM analytics, and reporting initiatives. The objective of the project was to improve Salesforce license utilization visibility, support cost optimization efforts, and enhance data-driven decision-making through dashboards and analytics. I contributed to building and maintaining Power BI and Salesforce Einstein Analytics dashboards to track license usage trends, user activity, and adoption metrics. In parallel, I supported Salesforce administrative activities and collaborated with stakeholders on story creation, requirements analysis, and reporting enhancements.