Pranav Belmannu

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.