Summary
Overview
Work History
Education
Skills
Timeline
Generic

Dipali Mhamunkar

Network operation Associate (SQL Analyst)
Dombivali

Summary

Dynamic Network Operation Analyst with a proven track record at Accenture, specializing in SQL and database management. Expert in process enhancement and root-cause analysis, successfully identifying revenue leakages and implementing cost-effective solutions. Adept at collaborating with cross-functional teams to drive operational efficiency and deliver high-quality results under tight deadlines.

Overview

10
10
years of professional experience

Work History

Network Operation Analyst

Accenture
04.2021 - Current
  • Working with the U.S.'s largest telecom company, AT&T.
  • Part of the Revenue Assurance team, handling billing operations.
  • Creation of SQL queries in the Snowflake database to perform different audits identifying revenue leakages.
  • Part of the process involves migrations from Azure Databricks to AWS Databricks in terms of cloud platforms, and from MSSQL to Snowflake in terms of databases.
  • Created and managed operational databases to store and track data and maintain accurate information.
  • Developed custom scripts for enhanced performance monitoring capabilities tailored to specific business requirements.
  • Collaborated with cross-functional teams to identify potential areas of revenue loss and develop corrective action plans.
  • Increased cost savings by identifying areas for process improvement and implementing cost-effective solutions.
  • Managed multiple projects simultaneously, delivering results within tight deadlines while maintaining high-quality standards.
  • Analyzed trend data to forecast operational needs and plan the next course of action using the POWRBI database.
  • Assisted in the development of annual budgets by projecting revenues based on historical trends and anticipated business growth drivers.

SQL Analyst

Trigent Software Ltd. - IT Services Division
01.2020 - 04.2021
  • Worked as a contract employee for Accenture Solutions Pvt. Ltd., serving the client AT&T.
  • Backend support and maintenance of the application named YETI, which is used for billing operations.
  • Created and maintained stored procedures and functions to perform different tasks.
  • Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
  • Administered, supported, and monitored the database by proactively resolving database issues.


Junior SQL Developer

Caresoft Consultancy Pvt Ltd
01.2019 - 01.2020


  • Developed, implemented and optimized stored procedures and functions using T-SQL.
  • Create queries and stored procedures for software enhancement.
  • Pull data from the database as per client requirements.
  • Fix any issues related to database performance, and provide corrective measures.
  • Supporting the creation of complex functions, scripts, stored procedures, and triggers to support application development.
  • Take regular database backups, and coordinate with Caresoft clients.
  • Test databases, and perform bug fixes.

Network Engineer

Orient Technologies
04.2015 - 03.2019
  • Provided network support services for devices such as Access Point, CPE, routers, and other hardware.
  • Monitoring the client network for ILL, broadband, P2P corporate circuits, and handling the fault incident in the Siebel tool.
  • Troubleshooting the access core routers installed in different respective cities, like Cisco ASR 9K, 7600, and Cisco 6524, 2960, and 3400 switches.
  • Monitoring and troubleshooting all wireless devices, like (Zonal Director, Access Point, CPE), and radio (AirOS, Ubiquiti PS5, Radwin).
  • Providing advanced technical support to O&M engineers, eATS engineers.
  • Handling the escalation issues received from clients and teams, taking necessary action, and assigning them to the appropriate team.
  • Coordinating with the different internal and external teams, such as the POP Team, RFNOC, NNOC, and O&M Desk, for resolving the clients' network and escalation issues.

Education

Bachelor of Science - Computer Science

S.K.Somaiya College, Mumbai University
Mumbai
04.2001 -

Skills

Snowflakes

MS SQL

Data Bricks

Teradata SQL Assistant

MS Excel, Word, Powerpoint

POWERBI

Revenue Assurance

Data Analysis

AWS

Timeline

Network Operation Analyst

Accenture
04.2021 - Current

SQL Analyst

Trigent Software Ltd. - IT Services Division
01.2020 - 04.2021

Junior SQL Developer

Caresoft Consultancy Pvt Ltd
01.2019 - 01.2020

Network Engineer

Orient Technologies
04.2015 - 03.2019

Bachelor of Science - Computer Science

S.K.Somaiya College, Mumbai University
04.2001 -

Similar Profiles

CREATE PROFILE
Dipali MhamunkarNetwork operation Associate (SQL Analyst)