Summary
Overview
Work History
Education
Skills
Timeline
Generic

Jyothsna Maddina

Parker,USA

Summary

Results-driven Data Analyst with over 4 years of experience in data wrangling, visualization, and statistical analysis across diverse industries. Proficient in Python and SQL, with a strong command of business intelligence tools such as Tableau and Power BI. Demonstrated expertise in designing and implementing ETL processes and utilizing cloud technologies to enhance data accessibility and support informed decision-making. Proven ability to collaborate with cross-functional teams, optimize data workflows, and deliver actionable insights that drive strategic initiatives.

Overview

5
5
years of professional experience

Work History

Data Analyst

Charter Communications, Spectrum
04.2023 - Current
  • Conducted in-depth data analysis using Google BigQuery, writing complex SQL queries to extract and transform data, generating actionable insights that informed strategic decisions and enhanced overall operational efficiency.
  • Developed interactive dashboards and reports in Tableau, enhancing data accessibility for stakeholders and enabling real-time performance monitoring.
  • Performed statistical analyses using R identifying trends and patterns that informed strategic decision-making across departments.
  • Collaborated with cross-functional teams to design and implement ETL processes, integrating data from various databases and data structures to support comprehensive analysis, research, and evaluation within a centralized data warehouse. Assisted in data collection and cleaning processes, ensuring high data quality and accuracy for further analysis.
  • Utilized SQL for querying databases and generating reports, leading to the identification of critical business insights that informed sales strategies.
  • Created visualizations in ggplot2 to communicate findings to non-technical stakeholders, improving understanding of complex data trends.
  • Supported machine learning model development in BigQuery ML, contributing to enhanced predictive capabilities.
  • Created SAS dataset from tables in Database using SAS/Access and Retrieved the Sales data from flat files, oracle database and converted to SAS datasets for Analysis using SAS/Stat procedures. Wrote various queries using SAS/Base, SAS/SQL and SAS/Macro for creating reports according to the Users requirement.
  • Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools SAS/Base, SAS/Macros and SAS/Graph, SAS/SQL, SAS/Connect, SAS/Access.
  • Automated data collection and reporting processes with R scripts, reducing manual reporting time by 30 hours per month.
  • Designed and implemented a custom R package for internal use, improving efficiency and standardization of data analysis across the organization.
  • Developed strong data governance practices, ensuring compliance with data privacy regulations and maintaining data integrity across all projects.
  • Utilized advanced Excel skills, including pivot tables, VLOOKUP, and macros, for data analysis and reporting tasks.
  • Demonstrated proficiency in data storytelling, effectively translating complex analyses into clear and compelling narratives for diverse audiences.

Data Analyst

CenturyLink
02.2021 - 03.2023
  • Utilized Python libraries such as NumPy, Matplotlib, Scikit-Learn, and SciPy to develop a suite of capacity planning reports, enhancing strategic planning and decision-making processes; graphical data presentations contributed to a 15% increase in forecasting accuracy.
  • Conducted extensive data profiling, mapping, and cleansing, ensuring high data quality and integrity, which resulted in a 20% improvement in analysis and reporting accuracy.
  • Utilized SQL for data extraction and manipulation, crafting complex queries to analyze large datasets, improve data accuracy, and streamline reporting processes.
  • Employed data modeling techniques (e.g., entity-relationship modeling, normalization) to optimize database structures, ensuring efficient data storage and retrieval.
  • Developed and maintained dashboards in Tableau and Power BI, integrating real-time data for enhanced visibility into key metrics and facilitating timely decision-making processes.
  • Collaborated with stakeholders to understand business requirements and develop problem statements; effectively gathered, analyzed, and validated data, creating insightful reports and dashboards in Excel and Tableau.
  • Employed data modeling techniques (e.g., entity-relationship modeling, normalization) to optimize database structures, ensuring efficient data storage and retrieval.
  • Conducted exploratory data analysis (EDA) using Python and R to uncover underlying patterns and anomalies in data, leading to improved understanding of business challenges.
  • Utilized version control (Git) to manage code bases and ensure reproducibility of analyses, facilitating collaboration in team projects and maintaining organized project workflows.
  • Integrated machine learning models into data analysis workflows, utilizing libraries such as TensorFlow and Keras to enhance predictive accuracy and derive advanced insights from datasets.
  • Conducted sentiment analysis on customer feedback using natural language processing (NLP) techniques, providing valuable insights into customer satisfaction and product improvements.
  • Implemented A/B testing methodologies to evaluate the impact of changes in business processes and marketing strategies, providing actionable insights based on quantitative data.

Education

Bachelor of Technology - Electronics & Communication Engineering

Jawaharlal Nehru Technological University
Hyderabad, TN
05-2010

Skills

  • Specializations: Data Wrangling, Data Visualization, Statistical Analysis
  • Programming Languages: SQL, PL/SQL, Python, R, JavaScript
  • Business Intelligence Tools: Tableau, Power BI, Qlik, Looker
  • Databases: MySQL, MS SQL Server, PostgreSQL, Oracle
  • Data Libraries: Pandas, NumPy, Matplotlib, Plotly, Seaborn, Scikit-learn, ggplot2, PyTorch
  • Big Data Technologies: Hadoop, Spark, Apache Airflow
  • Cloud Technologies: AWS (S3, Glue, EC2, Redshift, Athena)
  • ETL Processes: Data Profiling, Data Integration, Data Modeling
  • Modeling & Development Tools: Git, ER/Studio, Oracle Data Modeler, SSRS, SSIS
  • Project Management Tools: Microsoft Office Suite (Project, Visio, Excel, PowerPoint), Jira, Confluence
  • Soft Skills: Critical Thinking, Written and Verbal Communication, Presentation Skills, Problem Solving, Team Collaboration, Leadership, Adaptability, Risk Management

Timeline

Data Analyst

Charter Communications, Spectrum
04.2023 - Current

Data Analyst

CenturyLink
02.2021 - 03.2023

Bachelor of Technology - Electronics & Communication Engineering

Jawaharlal Nehru Technological University

Similar Profiles

  • Tyler Henderson

    Tyler HendersonTyler Henderson

    Regional Connectivity Specialist at Charter Communications, SpectrumRegional Connectivity Specialist at Charter Communications, Spectrum

  • Fred Knobelock

    Fred KnobelockFred Knobelock

    Sr. Business Analyst, Customer Operations at Charter Communications, SpectrumSr. Business Analyst, Customer Operations at Charter Communications, Spectrum

  • Anthony Smith

    Anthony SmithAnthony Smith

    Customer Service Representative Video Repair Lead at Charter Communications, SpectrumCustomer Service Representative Video Repair Lead at Charter Communications, Spectrum

  • Keshawn Mouton

    Keshawn MoutonKeshawn Mouton

    Cust Svc Billing at Charter Communications, SpectrumCust Svc Billing at Charter Communications, Spectrum

  • Nelson D. Santaella

    Nelson D. SantaellaNelson D. Santaella

    Revenue Manager at La Nacional Holdings CorporationRevenue Manager at La Nacional Holdings Corporation

CREATE PROFILE