Kunal Chhatrapati

Kunal Chhatrapati

About

Detail

Looking for Job Opportunity in Data Domains | A.I & Data | U.S. Citizen | SQL | Python, Power BI | Turning Complex Data Into Clear Insights
Fullerton, California, United States

Timeline


work
Job
school
Education
folder
Project
flag
Award
auto_stories
Publication

Résumé


Jobs verified_user 0% verified
  • Plaid
    Data Analyst
    Plaid
    Oct 2023 - Current (3 years 1 month)
    • Partnered with Product and Marketing managers to define retention KPIs through requirement gathering and documentation; queried AWS Athena, Redshift, and Snowflake with advanced SQL (window functions, CTEs) and delivered KPI dashboards in Power BI, enabling a 12% uplift in 3-month retention.
    • Validated user activity data with Engineering teams by auditing ETL outputs and lineage breaks across JSON/Parquet logs; applied Python (Pandas, NumPy) for data checks, root cause analysis, process capability analysis, and first-pass yield (FPY) reviews; reduced reporting inconsistencies by 18% and strengthened data governance.
    • Developed self-service analytics by designing Power BI dashboards with DAX, drill-throughs, bookmarks, heat map
  • SP Global
    Data Analyst
    SP Global
    Jan 2020 - Dec 2021 (2 years)
    • Partnered with Credit Risk and Product stakeholders to prepare structured datasets from Capital IQ (vendor coordination) and internal SQL databases optimized queries to accelerate retrieval by 30% while aligning deliverables with requirements documentation.
    • Conducted credit risk analyses with Data Science teams using Python (Pandas) and R (dplyr, ggplot2); applied regression models, cohort analysis, ANOVA, correlation studies, and time series analysis to highlight risk indicators, improving model accuracy by 15%.
    • Led data governance and quality reviews with Compliance & Audit teams using Azure Data tools, Excel validations, and histogram/distribution checks (familiarity with Informatica DQ) reduced quarterly reporting errors
Education verified_user 0% verified
  • California State University Fullerton
    Master of Science - MS, Computer Science
    California State University Fullerton
    Jan 2022 - Dec 2024 (3 years)
  • I
    Bachelor of Engineering - BE, Computer Engineering
    INSTITUTE OF TECHNOLOGY MANAGEMENT UNIVERSITY TECHNICAL CAMPUS PALADI VADODARA
    Jan 2018 - Dec 2021 (4 years)
  • Maharaja Sayajirao University of Baroda Vadodara
    Diploma of Education, Computer Engineering
    Maharaja Sayajirao University of Baroda Vadodara
    Jan 2015 - Dec 2018 (4 years)
  • t
    10th
    tree house high schoolvadodara
    Jan 2002 - Dec 2015 (14 years)
Projects (professional or personal) verified_user 0% verified
  • T
    Taxi_Data_Analysis
    Aug 2024 - Oct 2024 (3 months)
    In this Project,our goal is to compute Data Analysis of based on the dropoff datapoints where we would be loading the data from Excel, transforming the data through Python along with it's libaries and extracting the cleaned data to SQL Server and integrate the data stored in SQL Server with visualization tool through Power BI to create dashboards. Primary goal:- To display the dropoff location datapoints in readable manner we would be filtering it with AI such that even Non-technical people can also able to identify the data.
  • H
    Human Activity Detection using Ambient Sensor
    Mar 2023 - May 2023 (3 months)
    • Project aimed to detect human activity and identify individuals who face difficulty using conventional monitoring equipment.
    • Analyzed ambient data from PIR motion sensor using machine learning models like KNN, Naive Bayes, Random-Forest, SVM, and Decision Tree, and tools like Pandas, Jupyter Notebook, Seaborn, NumPy, Matplotlib, and Google Collab.
  • F
    Flight Prediction
    Oct 2022 - Dec 2022 (3 months)
    • Developed a Web-Application to predict flight data and identify factors affecting flight delays, based on cancellations and delays.
    • Deployed the application on EC-2 instance cluster with a technology stack that includes React JS, HTML-5, CSS-3, JavaScript, AWS EMR, S3 Bucket, EC-2 instances, and PySpark, and extracted data using Apache Spark and Hadoop through APIs.
  • M
    Monster Video
    Apr 2022 - May 2022 (2 months)
    • Created a web-based application for a theater company that intended to fulfill customer requirements based on their requirements.
    • Developed different forms on Frontend part using HTML, CSS, Bootstrap, and Angular 11, with Data maintained in SQL Database accessed through a RESTFUL web service developed using Nodejs for CRUD Operations.
    • Constructed Database for Monster Video which included ER Diagram, Class Diagram, Normalization, and 10+ Tables with join queries to Optimize data retrieval.
  • F
    Flight Delay Prediction
    Proposed a solution to predict flight delays by analyzing the datasets from Kaggle. Organized the infrastructure and created a Hadoop cluster on AWS. Deployed it on the EC2 instance cluster created by Elastic MapReduce.
Awards verified_user 0% verified
  • f
    first prize
    Feb 2017
    first prize in treasure hunt event held at all over MSU
Publications verified_user 0% verified
  • I
    Human Activity Recognition using Ambient Sensors
    ISNCC International Symposium on Networks Computers and Communications
    Oct 2023
    + This project involves analyzing a dataset comprising ambient data gathered from residents' homes. The data collection occurs continuously while residents engage in their daily activities. + Various sensors, including PIR motion sensors, door/temperature sensors, and light switch sensors, are strategically placed throughout the residents' homes. These sensors are positioned to detect specific activities of daily living, capturing relevant information. + The main objective of the project is to develop ML models using various techniques and analyse the results using performance metrics. Based on the results of the model we will used optimization techniques to improve the efficiency of the model. rephrase above