Data Analyst, Data Scientist, Business analyst, BIA, ML Engineer

Amit Bhat

Durham, NC Open to relocation 347-***-**** *********@*****.*** linkedin.com/in/amitbhat-data-analyst/ EXPERIENCE

Line Leverage – Sports Analytics – Machine Learning Intern Sep 2024 – Dec 2024

• Consolidated NBA stats, injury, and news sentiment tables into a clean, ML-ready dataset, cutting data preparation time by 40%.

• Conducted EDA to verify stationarity, independence and normality across data ensuring valid inference and reliable forecasts.

• Delivered 23% lift in forecast accuracy using BiLSTM time-series model outperforming logistic regression and XGBoost baselines.

• Performed variance and sensitivity analyses to surface top error drivers, guiding feature roadmap and model explainability.

• Deployed Power BI dashboards for pilot users, improving KPI tracking by 25% and achieving 90% user satisfaction. Finvolv – Financial Technology – Data Scientist Aug 2022 – Apr 2023

• Led a team of analysts through Agile sprints to capture 50+ requirements and architect a loan lifecycle platform for L&T Finance.

• Automated credit risk monitoring through ETL pipelines on Production and UAT servers, enabling daily identification of 100+ high-risk accounts and supporting $250K+ in default prevention decisions.

• Segmented customers from repayment patterns to drive personalized offers and credit limits, increasing approvals by 15%.

• Built monthly collection forecasts with 92% accuracy, informing liquidity allocation decisions that freed $10M in idle buffers.

• Consolidated loan, repayment, and customer data with SQL (joins, window functions, CTEs) into views to power risk dashboards. Finvolv – Financial Technology – Data Analyst Aug 2021 – Aug 2022

• Deployed SQL data marts and automated KPI extracts reducing manual reporting by 25% and accelerating stakeholder decisions.

• Conducted A/B testing to optimize interest rate strategies, increasing funnel conversion by 8% with no raise in default risk.

• Built recurring Excel and Power BI reports tracking portfolio KPIs (delinquencies, approvals, roll rates) for leadership.

• Mentored 30 analysts in version control, documentation, and stakeholder communication, raising team quality and efficiency. Finvolv – Financial Technology – Associate Data Analyst Feb 2021 – Aug 2021

• Delivered interactive Power BI dashboards to monitor sprint KPIs and bug trends, boosting transparency and efficiency by 20%.

• Developed a Cox proportional hazards model in Python to predict loan delinquency, cutting past-due loans by 10%.

• Led data-storytelling workshops for 40+ stakeholders, reducing ad-hoc report requests by 50% and accelerating decision-making.

• Managed data cleaning, QA checks, and documentation (data dictionaries and SOPs) to keep reporting accurate and reproducible. Karnataka State Pollution Control Board – Environmental Technology – Data Analyst Intern Apr 2019 – Sep 2019

• Collected 250K+ multi-site air and noise data, defined sampling protocols, and captured site, device, and activity metadata.

• Explored data anomalies, segmented sites and time windows with k-means and mapped hotspots for targeted inspections.

• Validated construction and traffic impacts using ANOVA and t-tests and built regression models to quantify data spike drivers.

• Delivered Excel dashboard that spotlights spike hotspots and ranks high-risk sites, helping regulators target inspections faster. SKILLS

Programming & Visualization: Python, SQL, R, Tableau, Power BI (DAX, Power Query M), Excel (macros, pivot tables) Frameworks: NumPy, Pandas, scikit-learn, Plotly, Seaborn, Matplotlib, Statsmodels, SciPy, TensorFlow, Spark, dbt, NLTK Platforms: PostgreSQL, BigQuery, MySQL, MSSQL, MongoDB, Snowflake, AWS, GCP, VS Code, Jupyter, RStudio, Alteryx Other Tools: Apache Airflow, Redshift, SAS, Git, Docker, Google Analytics, SharePoint, Hadoop, Jira, Looker, Figma, Regex Generative AI: Pinecone, FAISS, LLMs, OpenAI, Google Gemini, Retrieval Augmented Generation, Crew Ai, Agno, Langchain PROJECTS

SQL Data Warehouse Using Medallion Architecture Apr 2025 – May 2025

• Designed a SQL Server data warehouse using Medallion Architecture to integrate 150K ERP and CRM data for unified analytics.

• Implemented automated reconciliation processes reducing data discrepancies by 95% and slashing reconciliation runtime by 90%.

• Modeled a dimensional star schema to power SQL-based sales and customer behavior reports slashing query runtimes by 60%. Retail Sales and Customer Insights Analysis May 2025 – Jun 2025

• Analyzed 1M+ sales records using CTEs, joins, window functions to uncover trends, customer profiles and product performance.

• Designed KPIs, dashboards, and reports to monitor revenue, segment customers, and track behavioral patterns.

• Crafted 20+ T-SQL scripts for in-depth data profiling, validation, and modeling of sales, customer, and product datasets.

• Identified top 5 products, subcategories, and high-value customer segments to drive targeted strategies and actionable insights. Regional Sales Analytics & Optimization Dashboard Jul 2025 – Aug 2025

• Created Balsamiq wireframes to define 12+ KPIs aligning analytics requirements with business for a large ERP and CRM dataset.

• Integrated sales, CRM, & inventory datasets into star schema using Tableau Prep and SQL boosting load performance by 35%.

• Created 20+ calculated fields and parameters (rolling averages, YoY growth), enabling trend and retention analysis.

• Presented dashboards highlighting key drivers for a 10% marketing budget reallocation and an 8% upsell revenue uplift. EDUCATION

Stevens Institute of Technology Sep 2023 – May 2025 Master of Science in Data Science - GPA 3.94 Hoboken, USA R V College of Engineering Nov 2017 – Aug 2021

B.E in Industrial Engineering and Management - GPA 3.83 Bangalore, India

Contact this candidate