Information Technology Data Analyst

Prasanna Kailash Warad

469-***-**** ***************.*****@********.*** Dallas, TX http://www.linkedin.com/in/prasannawarad EDUCATION

The University of Texas at Dallas, Dallas, TX August 2024 - May 2026 Master of Science, Information Technology & Management, Dean’s Excellence Scholar GPA 4.0/4.0 Coursework: Python, Database, Advanced Statistics, Business Analytics with R, Big Data, Data Visualization Savitribai Phule Pune University, Pune, India August 2018 - May 2022 Bachelor of Engineering, Electrical GPA 3.8/4.0

Coursework: Fundamentals of Programming Language, Numerical Methods & Computer Programming TECHNICAL SKILLS

Programming & Languages: Python (Pandas, NumPy, Matplotlib, Seaborn), SQL (Advanced), R, C++, C, PL/SQL, C# Databases: MySQL, SQL Server, Oracle, NoSQL

Data Platforms: AWS (Lambda, Redshift), GCP (BigQuery), Azure (Synapse, Databricks, Purview), Snowflake Analytics & Visualization: Tableau, Power BI, Advanced Excel, EDA, Feature Engineering, Time-Series Analysis Data Engineering: ETL, ELT, Airflow, Spark, Hadoop, Data Modeling, Lambda/Kappa Architecture, Classification Models PROFESSIONAL EXPERIENCE

HCLTech Ltd, Noida, India February 2023 - July 2024 Data Analyst

• Diagnosed Oracle database bottlenecks and implemented advanced indexing and PL/SQL tuning, boosting throughput by 30% and supporting 10K+ seamless daily transactions.

• Optimized critical data pipelines through caching and partitioning strategies, reducing query latency by 28% and ensuring real-time reporting during peak operations.

• Analyzed 2M+ customer transaction records using Python and SQL, uncovering anomalies that refined data quality and strengthened predictive model reliability.

• Designed and deployed Tableau dashboards for executives and analysts, reducing manual reporting by 40% and expediting data-driven business decisions.

• Supported cross-functional teams in diagnosing system performance issues, delivering engineering insights that improved platform stability and reduced downtime incidents by 15%. PROJECTS

Instacart Customer Behavior Dashboard January 2025 – February 2025

• Analyzed over 3 million Instacart grocery orders using SQL to uncover peak shopping hours, frequently reordered items, and behavioral trends across customer segments through cohort-based analysis.

• Engineered a Tableau story across 10+ interactive sheets, delivering real-time insights into product demand, customer engagement, and campaign ROI to drive optimized staffing, inventory, and marketing decisions. Heart Disease Prediction & Analysis with R September 2024 - November 2024

• Developed health features and balanced 301K+ patient records to improve classification accuracy and ensure model generalizability.

• Attained 91.44% accuracy by evaluating and tuning Random Forest and Neural Network models, contributing to explainable predictions for clinical interpretation. Insurance Database Design & Analytics Project September 2024 - October 2024

• Constructed a normalized 10-table relational schema to manage 50K+ customer, policy, and claim records, simulating scalable enterprise-level data architecture.

• Optimized query performance by 30% through strategic indexing and automated fraud detection workflows using stored procedures and triggers, streamlining backend operations. LEADERSHIP & COMMUNITY INVOLVEMENT

UTD Marathi Mitra Mandal, Events Chair January 2025 - Present UTD Infinity Lions Club, Vice President January 2025 - Present

Contact this candidate