Pranav Belmannu

United States

@belmanupranav

Marketing Insights through Data Analytics

Badges

Sql

Certifications

belmanupranav has not earned any certificates yet.

Work Experience

  • Data Analyst Intern

    Rel8ted.to Analytics•  July 2024 - November 2024•  New York, United States

    Conducted in-depth quantitative analysis of donor contributions, utilizing Pandas and Scikit-learn for efficient data cleaning and manipulation, resulting in a 30% projected increase in donor revenue. Conducted strategic analysis of donor engagement patterns using NLTK, enhancing mid-tier donor targeting and decision-making processes, aligned with organizational goals. Developed visual reports on donor trends leveraging Seaborn, Matplotlib, and Excel, facilitating strategic decision-making processes for the CIO and the data operations manager. Partnered with CIO and data operations manager to integrate data-driven insights into tactical decisions, optimizing campaign results and increasing overall donor participation by 25%.

  • Data Projects Volunteer

    Goodwill Finger Lakes•  May 2024 - July 2024•  Rochester, United States

    Optimized data collection methodologies for the last five years of electricity, water, and gas bills using Microsoft Forms related to the Sustainability department to ensure data consistency for the Power BI dashboard. Engineered comprehensive dashboards featuring 12 diverse graphs over three extensive pages, delivering insightful performance analytics for Goodwill Finger Lakes' Financial and Leadership teams. Utilized R programming to evaluate the viability of two potential retail store locations, providing data-driven insights for strategic expansion decisions.

  • Research Data Analyst

    Rochester Institute of Technology•  September 2022 - May 2023•  Rochester, United States

    Collected and analyzed data from the top 100 NYSE financial firms' financial data for data modeling using Python and Excel which helped us achieve research as per requirements. Extracted, transformed, and loaded tweets for five financial years using Tweepy with Python scripting for the above firms resulting in 53.5 million records. Created dashboards and reports with Tableau for AI-generated NFT data from Opensea with twenty graphs that helped in 3 research papers.

  • Analyst

    Tata Consultancy Services PVT. LTD•  December 2018 - July 2022•  Hyderabad, India

    Led a team of five & worked with agile cross-functional teams using JIRA to deliver insightful solutions as per business requirements, reducing claim deductibles by 20%. Implemented ETL processing using Oracle SQL developer and Informatica ETL developer to implement data warehousing for MDM policy and claim data, improving data requirements by 25%. Improved claims financial data quality assurance by 56% through financial reconciliation processes using Oracle SQL and Informatica ETL developer. Enhanced data exchange efficiency by implementing advanced JSON processing techniques and utilizing Postman, resulting in a 20% improvement in claims data transaction speed.

Education

  • Rochester Institute of Technology

    Computer Information Systems, M.S. in Business Analytics•  August 2022 - November 2023•  GPA: 3.9

  • Osmania University

    Computer Science, BE•  September 2014 - May 2018•  GPA: 3.5

Skills

Power BI
Tableau
Pivot Tables
Microsoft Visio
Microsoft Fabric
SSIS
SSRS
Qliksense
Pandas
Scikit-learn
Seaborn
Matplotlib
Excel
Tweepy
Postman
JIRA
Oracle SQL Developer
Informatica ETL Developer
Adobe Illustrator
Canva
Snowflake
Oracle OLAP
Microsoft SQL Server
T-SQL
Azure Data Lake
NLTK
Java
Python
R
SQL
CSS
HTML
JavaScript