PRIYAL BAMNIKAR

New York 315-***-**** adx2nz@r.postjobfree.com https://www.linkedin.com/in/priyalbamnikar/ EDUCATION

Syracuse University, School of Information Studies, Syracuse, NY May 2023 MS in Applied Data Science

Relevant coursework: Database Management and Administration (SQL), Introduction to Data Science (R), Scripting for Data Analysis (Python), Data Warehouse (SSIS, SSAS, ETL), Machine Learning, Statistics with R, Big Data Analytics (Spark, Hadoop, data mining), Business Analytics (Google Analytics, MS Access, SAP), Cloud Management (Saas, Docker, AWS) Maharashtra Institute of Technology, Pune University, Pune, India May 2019 Bachelor of Technology in Electronics and Telecommunication Relevant coursework: Engineering Math (Advanced Statistics, Calculus, Matrix Algebra) EXPERIENCE

Master Data Analyst Intern, Tesla Inc., Fremont, CA May 2022 - May 2023

• Utilized statistical analysis on 100,000 rows of complex financial data to provide insights and hypotheses to 60 members of Finance operations team using SAP

• Created visualizations using Tableau dashboard consisting of KPIs to monitor business metrics in vendor payments

• Built ad-hoc reports, analyses and performed data validation on VAT errors within banking entities using MS SQL Server, Advanced Excel (graphs, formulas, pivot tables), and Tableau reducing common payment failures by 43%

• Migrated data from MS SQL Server onto MySQL database using SSIS ETL optimizing system performance by 8%

• Implemented joins, subqueries, and aggregate window functions to analyze data using SQL Associate System Engineer (Analyst), IBM, Pune August 2019- June 2021

• Managed enrollment and claims data through relational databases for a USA healthcare insurance company

• Performed data cleaning and analytics on healthcare insurance datasets using SQL (window functions, pivot)

• Developed an AWS Lambda function for daily automated data collection, improving operational efficiency by 10% through timely and precise file size and row count information from the S3 bucket

• Achieved 70% reduction in quarterly manual work by automating audit report generation using Power BI, DAX, Excel macros, and VBA, improving accuracy for enrollment insights Data Analyst Intern, KGreen Consulting Technologies Private Limited, Mumbai May 2018 - August 2018

• Developed Python (pandas, numpy, skikit learn) code to build cross-sell models for a Co-operative Bank

• Created SQL queries for scenarios in MS Access to analyze data for improvement of client cross-sell PROJECTS

Retail Store Management system (Data Warehousing) January 2022 - May 2022

• Delivered an enterprise data warehouse solution that extracts sales data metrics from retail stores

• Developed SQL queries and SSIS ETL pipelines to extract data from multiple sources

• Optimized ETL processes and query performance, reducing data loading and retrieval times by 30% Analysis of Diabetic Patients October 2021 - December 2021

• Performed exploratory data analysis, JSON API Scraping on diabetes data using Scikit-learn, NumPy, Pandas

• Assessed probability of hospital readmission probability with predictive analytics, GLMs, association rules

• Presented visualizations to display trends in readmission using matplotlib and seaborn Analysis of Hotel Cancellations October 2021 - December 2021

• Conducted exploratory data analysis, data cleaning and implemented ML algorithms to identify cancellation trends on hotel customer data constituting 40000 observations and 20 features

• Applied supervised learning algorithms like SVM with association rule mining with accuracy of 86% using R

• Provided actionable insights and business recommendations that potentially solved 12.6% of cancellations TECHNICAL SKILLS

Programming languages: Advanced SQL, Python, R, Spark, C, MATLAB, C++, Java, HTML, CSS Database: MS SQL Server, IBM DB2, MySQL

Methodologies: Classification, Regression, A/B Testing, Time Series Analysis, ANOVA, t test, Frameworks & Tools: Tableau, PowerBI, JIRA, MS Excel, Git, SSIS, Google Analytics, MS PowerPoint, Salesforce