Summary
Overview
Work History
Education
Skills
Timeline
Generic

Vivek Thakkar

Gurgaon

Summary

Analytical Data Analyst with experience in leveraging advanced analytics and data visualization to drive business insights. Skilled in Python, SQL, and Tableau, with a strong ability to interpret data patterns and translate them into actionable recommendations. Known for improving data processes and supporting cross-functional teams with strategic insights.

Overview

4
4
years of professional experience

Work History

Data Analyst

Amdocs
12.2021 - Current
  • Expertise in managing, analyzing, and interpreting large and complex datasets from telecommunication systems to improve business processes and decision-making
  • Python Proficiency: Developed and automated data pipelines using Python for data extraction, transformation, and loading (ETL)
  • Utilized libraries such as Pandas, NumPy, and SQLAlchemy for data manipulation, ensuring efficient processing of telecommunication data
  • SQL Expertise: Extensive experience in writing complex SQL queries to extract and manipulate data from relational databases
  • Skilled in optimizing queries for performance, ensuring quick access to critical data, and performing database management tasks
  • Alteryx Workflow Development: Created and optimized data workflows in Alteryx to automate ETL processes, ensuring smooth and error-free data flow from various sources
  • Integrated Alteryx with SQL databases to streamline data processing tasks for telecom-related data
  • Tableau for Data Visualization: Designed and developed interactive dashboards in Tableau to provide visual insights from telecom datasets
  • Created key performance indicator (KPI) dashboards, data trend analysis, and operational reports that assisted in business decision-making
  • Advanced Excel Skills: Proficient in Excel for data analysis and reporting
  • Utilized pivot tables, advanced formulas, and macros for data cleansing, manipulation, and visualization of telecommunication datasets
  • Telecommunication Industry Experience: Deep understanding of the telecom sector's data, including network performance metrics, customer usage patterns, and operational efficiency data
  • Leveraged data to provide insights for process optimization and business strategies
  • Data-Driven Decision-Making: Collaborated with cross-functional teams to provide actionable insights from data
  • Worked closely with operations, finance, and marketing teams to ensure that data solutions align with business goals
  • Workflow Automation and Optimization: Automated and optimized reporting processes to reduce manual efforts and increase accuracy in data delivery
  • Streamlined repetitive tasks by building automated pipelines and workflow schedules
  • Problem-Solving and Analytical Skills: Strong ability to dissect large datasets and uncover hidden trends or issues within telecom data
  • Provided solutions and recommendations based on detailed data analysis

RF Engineer

Amdocs
08.2020 - 12.2021
  • Analyse drop calls and access failures using layer-3 information, and provide recommendations for performance optimization
  • Participate in pre-launch activities, ensuring DT (Drive Test) parameters such as RSRP, RSRQ, SINR, CQI, throughput (UL/DL), and latency meet the required standards using Actix
  • Create and process KPIs from drive test logs, including RRC attempts and failures, CS/PS RAB (Radio Access Bearer) attempts and failures, accessibility, retainability, and throughput
  • Process and analyse drive test log files for data voice (DV) and (Circuit-Switched Fall Back), and perform stationary UDP and TCP upload and download tests

Education

Bachelor of Engineering - Electronics & Communications

LNCT Bhopal
Bhopal
09.2020

Skills

  • SQL
  • Oracle
  • Python
  • Tableau
  • PySpark
  • Excel
  • Data Cleaning
  • Data Wrangling
  • Data Modelling
  • ETL

Timeline

Data Analyst

Amdocs
12.2021 - Current

RF Engineer

Amdocs
08.2020 - 12.2021

Bachelor of Engineering - Electronics & Communications

LNCT Bhopal
Vivek Thakkar