Summary
Overview
Work History
Education
Skills
Timeline
Generic

Shyam Pavuluri

Irving,TX

Summary

Highly skilled Data Analyst with 3 years of experience leveraging data-driven insights to support strategic business decisions. Proficient in database management (MySQL, PostgreSQL, SQL Server), advanced data visualization (Tableau, Power BI), and statistical analysis techniques (regression, hypothesis testing, predictive modeling). Experienced in data cleaning and transformation (ETL processes, Python), and data modeling (R). Demonstrated ability to identify and interpret complex data patterns, providing actionable recommendations to drive organizational growth and efficiency. Strong communicator, adept at presenting data findings to both technical and non-technical audiences.

Overview

5
5
years of professional experience

Work History

DATA ANALYST/POWER BI

SUCCESS TECH SOLUTIONS INC.
07.2023 - Current
  • Conducted comprehensive data analysis using SQL and Python to identify trends, patterns, and correlations in sales and customer datasets, providing actionable insights
  • Developed and maintained dynamic dashboards with Tableau and Power BI to visualize key performance metrics, enhancing decision-making for stakeholders
  • Built predictive models using Python and machine learning algorithms to forecast sales and customer behaviors, improving customer retention by 15% through targeted strategies
  • Optimized data extraction and analysis processes with SQL, reducing reporting time by 20% and delivering timely business insights
  • Created advanced DAX formulas to support dynamic data calculations and aggregations in Power BI dashboards
  • Designed and implemented end-to-end ETL processes to integrate data from diverse sources into data warehouses or analytical systems
  • Collaborated with cross-functional teams to define data needs and ensure data integrity across multiple databases, including SQL Server and SAP
  • Proficient in writing complex SQL queries to retrieve and manipulate data from relational databases, including sub queries, joins, and aggregations
  • Utilized DAX to optimize data models for efficient querying and improved performance in Power BI reports
  • Automated data collection processes using Python scripts and ETL tools, saving 10 hours of manual labor weekly and increasing workflow efficiency
  • Implemented data warehousing solutions and managed cloud data storage on AWS, enhancing data accessibility and system performance
  • Performed advanced statistical analysis with R, providing in-depth insights and supporting data-driven decision-making
  • Leveraged big data technologies such as Hadoop and Spark to efficiently process and analyze large datasets
  • Designed and executed ETL processes to streamline data extraction, transformation, and loading, enhancing data quality
  • Managed data integration and migration projects, ensuring seamless data flow and minimizing downtime
  • Trained team members on using Tableau and Power BI, and established best practices in data analysis, boosting team productivity and fostering a data-driven culture
  • Enhanced cloud-based data storage and processing solutions using AWS, Azure, and Google Cloud, improving scalability and performance

DATA ANALYST/POWER BI

SLESHA INC.
01.2023 - 07.2023
  • Supported data cleaning and transformation efforts with ETL processes and tools like Microsoft Power Query and Python, ensuring data accuracy and consistency for analysis
  • Developed comprehensive reports and presentations with Excel and PowerPoint, incorporating data visualizations and key metrics to present findings to management
  • Leveraged DAX to perform in-depth data analysis, enabling the creation of comprehensive and insightful reports for stakeholders
  • Conducted statistical analysis with R to enhance marketing campaigns, resulting in a 10% improvement in campaign performance through targeted, data-driven strategies
  • Created dynamic dashboards with Tableau and Power BI to visualize data insights, track key performance metrics, and support strategic decision-making
  • Oversaw and maintained database systems, including MySQL, PostgreSQL, and Microsoft SQL Server, ensuring data security and adherence to company policies
  • Assisted in developing and automating data pipelines using tools like Apache Airflow and Databricks, enhancing data accessibility and workflow efficiency
  • Performed A/B testing and experimental designs to optimize website performance, leading to a 5% increase in conversion rates by identifying effective changes
  • Evaluated customer feedback and survey data using statistical methods to pinpoint areas for product enhancement and customer satisfaction improvement
  • Created and executed data validation frameworks with Python and SQL to enhance data quality and reliability, ensuring accurate insights
  • Built personalized scripts to automate data processing tasks using Python and R, reducing manual workload by 30% and freeing up time for strategic initiatives
  • Collaborated with the IT department to identify and resolve data-related challenges, ensuring seamless data operations and integration across systems
  • Implemented data integration solutions for merging disparate data sources using tools like Talend and Microsoft Azure Data Factory

DATA ANALYST

BHILVA TECH SOLUTIONS
01.2020 - 07.2021
  • Supported the data analytics team in collecting, cleaning, and analyzing extensive datasets for diverse projects, ensuring data accuracy and readiness for analysis
  • Assisted in creating dashboards and reports using Tableau to visualize crucial performance indicators, aiding in data-driven decision-making
  • Conducted market research and competitor analysis to bolster business development strategies, providing valuable insights into market trends and competitive positioning
  • Utilized SQL to query databases and generate tailored reports for senior management, streamlining access to key business metrics
  • Played a role in designing and implementing data collection systems, resulting in a 15% improvement in data accuracy and efficiency
  • Contributed to documenting data analysis processes and methodologies for future use, ensuring consistency and reliability in data handling practices
  • Developed Python scripts to automate data extraction and preprocessing, enhancing data handling efficiency and reducing manual workload
  • Assisted in crafting data models aimed at predicting customer behavior, facilitating strategic planning efforts, and supporting targeted marketing initiatives
  • Collaborated closely with marketing and product teams to ensure data insights aligned with business objectives, driving informed decision-making across departments

Education

Masters in Computer Science -

UMKC Kansas City
12.2022

Bachelor of Technology - ECE

VIT India
06.2021

Skills

  • Data Analysis & Visualization
  • SQL
  • Python
  • R
  • Tableau
  • Power BI
  • Microsoft Power Query
  • Looker
  • Database Management
  • MySQL
  • PostgreSQL
  • Oracle
  • Apache Hadoop
  • MongoDB
  • Google BigQuery
  • Microsoft SQL Server
  • SAP
  • Statistical Analysis
  • Regression
  • Hypothesis Testing
  • Predictive Modeling
  • Time Series Analysis
  • Advanced Statistical Analysis (R)
  • Data Cleaning & Transformation
  • ETL processes
  • Data Wrangling
  • Data Munging
  • Data Integration
  • Data Migration
  • Tools & Technologies
  • Excel
  • Hadoop
  • SAS
  • SPSS
  • Jupyter Notebook
  • Microsoft Azure
  • AWS
  • Databricks
  • Google Cloud
  • Big Data Technologies
  • Spark
  • Version Control
  • Git
  • Soft Skills
  • Problem-Solving
  • Critical Thinking
  • Communication
  • Team Collaboration
  • Training
  • Mentoring

Timeline

DATA ANALYST/POWER BI

SUCCESS TECH SOLUTIONS INC.
07.2023 - Current

DATA ANALYST/POWER BI

SLESHA INC.
01.2023 - 07.2023

DATA ANALYST

BHILVA TECH SOLUTIONS
01.2020 - 07.2021

Masters in Computer Science -

UMKC Kansas City

Bachelor of Technology - ECE

VIT India

Similar Profiles

CREATE PROFILE
Shyam Pavuluri