Summary
Overview
Work History
Education
Skills
Certification
Roles And Responsibilities
Personal Information
Projects
Timeline
Generic
SPURTHI PRAKASH

SPURTHI PRAKASH

Bangalore

Summary

Results-oriented professional with a strong knowledge base seeking a challenging career to contribute to organizational growth.

Experienced professional with 7.5 years of expertise in Designing, Analysis, and Management within the Business Intelligence and Database industries. Specializes in Product, IT services, and Operations.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Data Eng, Mgmt & Governance Specialist

Accenture
Bangalore
10.2023 - Current
  • Developed and implemented specialized procedures for customer service operations.
  • Provided technical support for customers in resolving complex issues.
  • Analyzed data from customer surveys to identify trends in customer behavior.
  • Identified areas for improvement, narrowing focus for decision-makers in making necessary changes.

Technical Architect

Tata Consultancy Services
Bengaluru
05.2021 - 09.2022
  • Utilized Power BI to create various analytical dashboards that depict critical KPIs, such as Performance dashboard, Utilization Dashboard, etc., and worked on an ad-hoc project.
  • Expertise in writing complex DAX functions in Power BI and Power Pivot.
  • Installed and configured Enterprise gateway and Personal gateway in Power BI service.
  • Scheduled automatic refresh and scheduling refresh in Power BI service.
  • Worked on calculated columns, Measures queries in Power BI Desktop to show good data analysis techniques.
  • Developed Excel Power View, Power Query, and Power Pivot dashboards for data analysis.
  • Created Drill Down Reports, Drill-Through Report.

Data Informatics Analyst

Dimension Data Pvt Ltd. (NTT Ltd.)
Bengaluru
03.2017 - 05.2021
  • Deploying ETL Packages using SSIS 2013 and SQL server, which will be connected to Power BI, and create reporting and Dashboard for Descriptive and Diagnostic Analytics.
  • Presenting the Task, SLA, and OLA service Tickets reports and Dashboard in Power BI on a weekly and monthly basis.
  • Extracting data from ITSM using SQL scripts and preparing client reports on a monthly basis.
  • Providing utilization metrics of all the resources to their managers to monitor workload and understand over/underutilization of the resource in the team.
  • Building monthly and weekly reports for MSEN clients and customized reports as per the client's requirement in Excel and Word.

Education

Master of Business Administration (MBA) -

R.N.S Institution of Technology
Bangalore, Karnataka
12.2016

Skills

  • Power Platform - Power BI
  • Tableau
  • Alteryx-Basics
  • SQL Server
  • Data management
  • ETL Tools: SSIS

Certification

  • AZ-900: Azure Fundamentals
  • PL-300: Power BI Data Analyst Associate
  • DP-600: Fabric Analytics Engineer Associate
  • Microsoft Power BI Certification by Edureka
  • Tableau certification by Edureka

Roles And Responsibilities

  • Understand company needs to define system specifications.
  • Address technical concerns, ideas and suggestions.
  • Utilized Power BI to create various analytical dashboards.
  • Generated ad-hoc reports in Excel power pivot.
  • Expertise in writing complex DAX functions in Power BI and Power Pivot.
  • Automated Power Query refresh using power shell script.
  • Used various sources to pull data into Power BI.
  • Creating SQL queries to interact with databases.
  • Installed and configured Enterprise gateway and Personal gateway in Power BI service.
  • Scheduled Automatic refresh and scheduling refresh in Power BI service.
  • Worked on calculated columns, Measures queries in Power BI desktop.
  • Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
  • Developed Excel Power View, Power Query and Power Pivot dashboards.
  • Designed SSIS packages to import and transform data.
  • Created Drill Down Reports, Drill Through Report.

Personal Information

  • Date of Birth: 07/18/91
  • Gender: Female
  • Marital Status: Unmarried

Projects

Project 1 - NTT Ltd, Internal, Power BI Desktop, SQL server, SSIS, Support Services & Managed services, 

Project 2 - TCS, ALDI, Power Platform, Developing Power BI Complex Dashboards Data Processing, Reporting, and Analysis using Power BI Tool and Excel Features and Formulas. 

Project 3 - TCS, Bridgestone, Power Platform, Enhancing Power BI M365 usage analytics dashboard report. 

Project 4 - TCS, Santos, Power Platform, Set up a Power BI platform and Governance.

Project 5 - Accenture ASMPT - Set up a POwer BI report with change in Business rules.

Project 6 - Manulife - Preparing Reports CAS reports. Where the reports where migrated from Oracle to PBI report using Power Bi report Bulider.

Timeline

Data Eng, Mgmt & Governance Specialist

Accenture
10.2023 - Current

Technical Architect

Tata Consultancy Services
05.2021 - 09.2022

Data Informatics Analyst

Dimension Data Pvt Ltd. (NTT Ltd.)
03.2017 - 05.2021

Master of Business Administration (MBA) -

R.N.S Institution of Technology
SPURTHI PRAKASH