SIVA SAI KUMAR MOGALLURU

Dynamic Application Developer Analyst with Tata Consultancy Services, specializing in C# and SQL. Enhanced data visibility for Bank of America’s healthcare portal, optimizing integrations across 500+ hospitals. Proven collaborator in Agile environments, driving impactful system enhancements and ensuring data integrity. Passionate about leveraging technology to deliver innovative solutions.

• Python for Data Science, AI & Development, IBM (Coursera), 05/01/20
• Databases and SQL for Data Science with Python, IBM (Coursera), 10/01/20

Predictive Analytics for Bank Marketing, Fall 2023.

• Analyzed marketing campaign data from a Portuguese retail bank (4,521 records, 17 features) to predict customer responses to term deposit offers., Cleaned and pre-processed data using Python (Pandas, NumPy) and handled class imbalance with SMOTE., Built and evaluated four classification models (Logistic Regression, SVM, Decision Tree, Random Forest); Random Forest achieved 87.6% accuracy and 69.2% precision., Identified the top 3 predictors of subscription: age group 30–40, last contact month, and previous campaign success, providing insights to improve campaign targeting.

Reviving Apple Maps – Strategic Analysis Case Study, Fall 2023.

• Explored Apple Maps' historical shortcomings and recovery strategies through a competitive landscape analysis., Conducted a SWOT analysis and mapped performance against Google Maps across five key dimensions: UI/UX, accuracy, real-time updates, 3D capabilities, and user engagement., Proposed four innovative solutions including AR-powered navigation widgets, crowd-sourced reviews, and real-time traffic data loops., Presented roadmap recommendations that emphasized data transparency, third-party integration, and gamified exploration features to improve user retention.

Sales Data Analytics and Data Warehousing – US Sales Domain, Spring 2024.

• Designed an OLAP-based analytical solution for a fictitious U.S. retail firm by processing 20,000+ sales transactions., Modeled a star schema data warehouse with Fact and Dimension tables for product, customer, and region., Wrote advanced SQL queries to identify sales trends, top-performing products, and underperforming regions over time., Revealed a 22% increase in winter seasonal sales and 15% drop in electronics sales in the Midwest, leading to three data-backed strategic recommendations for inventory and promotion adjustments.

Property Value Analysis – South St. Petersburg CRA, Spring 2024.

• Evaluated real estate trends in St. Petersburg’s Community Redevelopment Area by analysing 10,000+ property records from 2015 and 2022., Used Python (Pandas, NumPy) to clean, merge, and calculate taxable value changes across zip codes and neighbourhoods., Developed interactive Tableau dashboards to visualize property value shifts, growth clusters, and redevelopment potential., Identified a 15% median value increase in areas north of 5th Avenue South, recommending targeted urban investment and zoning reform based on visual and statistical insights.

USF Community Library Hub – Web Development Project, Fall 2025.

• Led full-stack development of a university-wide learning portal to improve access to academic resources., Built a responsive web interface using HTML, CSS, JavaScript, and C#, and hosted the portal on Azure Cloud with 99.9% uptime., Enabled streamlined access to 50+ curated resources, with login-based personalization for USF students., Conducted usability testing with 20+ participants over 3 testing cycles, resulting in a 25% improvement in navigation speed and higher user satisfaction scores.