Praneeth Voruganti

United States

@cancodeXD

NoSQL

Badges

Sql

Certifications

Work Experience

  • ML Data Engineer

    ThinkLabs AI•  April 2024 - Present

    Designed and implemented machine learning models using AWS, PyTorch, and TensorFlow to analyze consumer data, achieving a boost in client acquisition efficiency and a 15% improvement in engagement strategy effectiveness. Built optimized data pipelines for real-time consumer data processing, leveraging SQL and Tableau for data aggregation, cleaning, and visualization, ensuring data readiness and transparency for model insights. Developed predictive algorithms to identify potential clients and engagement patterns, resulting in a 20% increase in new customer acquisitions and improved retention metrics. Conducted A/B tests on personalized engagement campaigns, deep-diving into customer interactions to drive more effective targeting strategies.

  • Senior Data Analyst

    Nemo IT Solutions•  August 2023 - March 2024

    Conducted A/B Testing to optimize promotional strategies, resulting in a 20% increase in repeat purchase rates and improved merchandising effectiveness through targeted purchase frequency analysis for a major retail business. Implemented complex SQL queries in BigQuery for ETL processes to integrate large clickstream datasets, ensuring data quality standards and scalability, to support business intelligence and performance analysis. Developed Marketing Mix Model to analyze customer responses to product features in marketing campaigns, leading to a 15% increase in campaign effectiveness. Deployed solutions to CRM systems and created interactive dashboards in Power BI, providing stakeholders with real-time insights into business performance, customer behavior, and merchandising success.

  • Senior Data Analyst

    American Covenant•  January 2023 - June 2023

    Led a team of 6 in assessing the finance company's customer policy data to determine the most effective policies for acquiring new customers using SQL and Python (NumPy, Pandas, Matplotlib, Seaborn, Scikit-learn). Utilized Google’s Geocoding API to extract the Geographical Coordinates and created impactful visualizations using Tableau for over 80+ counties. Using Python, built a multi-target pricing model using a deep learning model to determine the competitive insurance premium per policy for a given property. Redesigned marketing strategies to target audience belonging to low-and medium-income communities by performing customer segmentation using K-Means Clustering, promising business boost 30% of counties.

  • Data Analyst

    WIPRO Ltd.•  November 2020 - November 2021

    Leveraged Azure to integrate sales, inventory, and customer data via ETL pipelines, enhancing data streaming and cost management in the retail domain. Utilized Python for data manipulation and statistics, and Tableau for visualizations, uncovering critical sales trends and customer behaviour patterns, thereby enhancing decision-making. Applied NLP techniques to build predictive models that accurately forecast customer demand and shopping trends, improving the company's inventory management and marketing strategies. Developed analytical strategies that reduced stockouts by 30% and improved resource utilization efficiency.

  • Business Data Analyst

    Lawrent Club•  December 2017 - October 2020

    Enhanced supply chain management (SCM) by analysing historical retail data from branch outlets, optimizing deliveries, and reducing inventory shortages by 18%, resulting in improved delivery times. Analyzed customer demographics using cloud technologies, while collaborating with cross-functional teams and helped in performing site suitability analysis (ArcPy) to identify 10+ suitable locations for opening new branch outlet. Utilized data-driven insights by tracking customer behavior, including purchase types, frequency, and transaction amounts, to develop effective marketing strategies and showcased the KPIs to stakeholders using BI tools.

Education

  • University of Connecticut

    Data Science, Master of Science in Data Science•  January 2022 - May 2023•  CGPA: 3.4

Skills

Tableau
Power BI
Alteryx
JIRA
Snowflake
Service Now
ASP .Net
Jupyter NB
MS Excel
Looker
AWS
Kafka
GitHub
VS Code
Spark
Airflow
Databricks
SAP
SQL
NoSQL
MySQL
BigQuery
SQL Server
Hadoop
Hive
Scikit-learn
NumPy
Pandas
Matplotlib
Seaborn
Python
R
SAS
VBA
JAVA