Kunal

Kunal

Data Analyst
United States of America

About Me

Data analyst with experience in Python, SQL, AWS, Tableau, Power BI, and machine learning. Experienced in building dashboards, automating queries, developing data marts and warehouses, and supporting predictive analytics…

Experience

Data Analyst

Procore Technologies
Sep 2022 - Present · 3 years 10 months

Developed a fuzzy-logic program to reduce redundant nodes in the database by 27%, and improved data quality
• Improved SQL query time by 80% and KPI dashboard performance by collaborating with cross-functional teams
• Automated SQL/NoSQL queries for 4 operational areas after communicating with all relevant stakeholders using
Lambda, EC2, and Python, improving data accessibility and dashboard refresh rates
• Architected a credit risk assessment framework for micro-loans using Python, AWS Lambda, and Excel solver,
improving risk measure accuracy by 8% and reducing processing time by 35% with data modeling
• Conducted 5 Proof of Concepts using R, Python, and AWS managed service to enhance credit-risk measures in
compliance with risk management frameworks at the company whilst employing a collaborative approach

Data Analyst

Procore Technologies – Carpinteria (California), United States
Sep 2022 - Jun 2023 · 9 months

Developed a fuzzy-logic program to reduce redundant nodes in the database by 27%, and improved data quality
Improved SQL query time by 80% and KPI dashboard performance by collaborating with cross-functional teams
Automated SQL/NoSQL queries for 4 operational areas after communicating with all relevant stakeholders using Lambda, EC2, and Python, improving data accessibility and dashboard refresh rates
Architected a credit risk assessment framework for micro-loans using Python, AWS Lambda, and Excel solver, improving risk measure accuracy by 8% and reducing processing time by 35% with data modeling
Conducted 5 Proofs of Concepts using R, Python, and AWS managed service to enhance credit-risk measures in compliance with risk management frameworks at the company whilst employing a collaborative approach

Associate Data Analyst

Videowaves – Mumbai (Maharashtra), India
Jun 2020 - Jul 2021 · 1 year 1 month

Led the architecture design and implementation of data marts/warehouse for ERP using AWS S3 and Kinesis, ensuring scalable and value-generating data management
Designed real-time equipment tracking using QR codes, SQL, and Kinesis, reducing equipment pilferage by 80%
Provided comprehensive SOPs and training, resulting in a 20% increase in overall workforce productivity
Conducted user acceptance testing and gathered feedback, resulting in user readiness and 87% adoption
Utilized company KPIs to create 4 dashboards in Tableau using analysis performed in Python, SQL, and Databricks
Facilitated project status meetings, resolved issues, and delivered project objectives within both deadline and budget, receiving recognition for operational adaptability and risk mitigation mindset

Data Analyst

Mahindra and Mahindra (Bristlecone) – Mumbai (Maharashtra), India
Nov 2019 - May 2020 · 6 months

Performed predictive data analysis using PyTorch and forecasted the demand for replacement parts based on multiple factors, reducing costs by $1.4 million annually
Collaborated with cross-functional teams on multi-echelon inventory optimization for parts required for maintenance using the o9 platform; resulting in optimal stock levels in adherence to cost-benefit analysis
Performed Network optimization with data analytics based on the feasibility of OEM supply chains and transportation networks resulting in 17% faster inventory replenishment at no additional cost
Designed and implemented a web crawler using Python, and Azure-managed services achieving 96% accuracy for extraction and 87% for abstraction-based summaries using BERT and GPT transformers for NLP
Created 3 interactive dashboards in Power BI for senior management, communicating real-time insights for strategic risk-informed decision-making whilst allowing to factor in shifting priorities

Skills

Analytics Data Analysis Professional Information Systems Management Data Mining Microsoft Access Statistical Analysis System (SAS) Structured Query Language (SQL) Data Representation Data Analysis Skills Power BI R Programming Language (R) Tableau Java Python Excel VBA SAP Matlab Alteryx NumPy SciPy Scikit-Learn Pandas PyTorch XGBoost TensorFlow Keras Spark Machine learning Regression Decision Trees Discriminant Analysis Text Mining Forecasting Model selection Cluster analysis Hypothesis testing PL/SQL MySQL Azure managed services AWS managed services Hadoop Kinesis Hive EMR EC2 IAM S3 NoSQL Sisense ggplot2 R-shiny Python Dash Looker SageMaker Agile JIRA Git
Report this Profile?