KAIVALYA PATKAR

Chicago, IL 414-***-**** www.linkedin.com/in/kaivalyap ad4148@r.postjobfree.com

Dynamic Data professional with a proven track record in leveraging SQL, Power BI, and Python for Data Visualizations for comprehensive data analysis. Experienced in identifying key metrics, uncovering insights, and enabling data-driven decision-making.

EDUCATION

•M.S. Information Technology Management- AI & Data Analytics, GPA - 3.83 May 2024

University of Wisconsin, Milwaukee

Coursework: Database Management Systems, Business Intelligence Technologies, Web Mining & Analysis

PROFESSIONAL EXPERIENCE

Data Analyst Intern at Jagemann Stamping Company Manitowoc, WI Oct 2023-Dec 2023

•Scripted queries in SQL for data processing from 2 million rows & reporting using MS Excel for informed decision making.

•Enhanced operational efficiency through Power BI dashboards, resulting in an 8% improvement in quarterly revenue.

•Developed ETL pipelines in SSIS, efficiently processing data using Databricks distributed environment leading to 6% less errors.

•Collaborated with cross-functional teams, reducing inventory stockpile by almost 6% through trend analysis using Python.

Graduate Student Services Consultant at University of Wisconsin, Milwaukee May 2023-Sep 2023

•Discovered an increase of 4% intake by leveraging MS Excel formulae & VBA to analyze & automate dataset of 5000 records.

•Employed SQL queries for robust data analytics and provided ad-hoc query support for analytics of 5 different departments.

•Teamed up with administration to develop Power BI reports to facilitate actionable insights & recommendations.

•Utilized Normal Distribution Charts to analyze performance across domains to recommend actionable insights.

Junior Data Scientist at Bytes Arena, India Jan 2022-Jan 2023

•Improved performance of datasets by indexing the schema in SQL, resulting in improved query execution & result retrieval time.

•Analyzed and cleaned data using Pandas and NumPy in Python, developing Power BI Dashboards for ROI visualizations.

•Spearheaded the Python programming team in predictive models, increasing 4% revenue through new opportunities.

•Designed and implemented SSIS ETL solutions to seamlessly integrate data from flat files and databases into data warehouses.

•Documented important findings, modifications & enhancements to abide quality assurance policies & procedures using GitHub.

Data Analyst at Shivvijay Enterprises, India Oct 2019-Sep 2021

•Conducted a thorough requirements definition process based on customer requirements identifying key finance metrics.

•Capitalized on MS Excel formulae, nested logics & lookups for financial data reporting revealing a 6% increase in demand.

•Engineered continuous monitoring and reporting systems using Shell scripts combined with Python for complex data analysis.

•Examined user trends analysis through complex queries in SQL, revealing valuable seasonal business insights.

•Designed and developed Power BI Dashboards enabling dynamic KPI tracking for executive decisions of product launches.

TECHNICAL SKILLS

Data Visualization Tools: Tableau, Power BI, Looker, SSRS

Programming Languages: SQL, PL/SQL, T-SQL, SAS, Python

Database Technologies: SSMS, PostgreSQL, MySQL

Microsoft Tools: MS Excel, MS Word, MS PowerPoint, Visio

Project Management: Jira, ServiceNow, Confluence

Methodologies: Agile, SDLC, Waterfall

Version Control: GIT, GitHub

Other: ETL, Prompt Engineering, Machine Learning, Alteryx

ACADEMIC PROJECTS

Financial Fraud Detection using Machine Learning & Deep Learning

•Developed a comprehensive machine learning solution for identifying fraudulent transactions among European credit card holders using a PCA-transformed, highly imbalanced dataset which contained 492 frauds in 284,807 transactions.

•Implemented SMOTE for removing imbalance and optimized various models including Random Forest, Logistic Regression, and Artificial Neural Networks, achieving high precision and recall rates; notably, through Random Forest with an F1-score of 0.853 with nearly perfect accuracy, proving efficacy in handling the highly imbalanced dataset. Deployed the model on web.

Azure Data Engineering Project

•Conducted in-depth analysis on a dataset containing 11,000 rows of Tokyo Olympics data, employing Azure Data Factory to construct efficient ETL pipelines using Azure Databricks to populate Azure Data Lake Gen 2 storage containers.

COVID-19 Power BI Analysis

•Conducted comprehensive analysis of global COVID-19 data using Power BI, identifying trends in infection rates, mortality rates, and vaccination coverage, while tracking KPIs such as daily new cases, mortality rate, and vaccine distribution efficiency; executed 15 DAX calculations and implemented 20 measures to deliver insightful findings.

CERTIFICATIONS

•Microsoft Certified: Azure Data Engineer Associate

•Complete SQL Bootcamp using PostgreSQL by Udemy

•ChatGPT Prompt Engineering by DeepLearning.AI & OpenAI

Contact this candidate