Post Job Free
Sign in

Data Science Analyst

Location:
Batavia, IL
Posted:
June 05, 2024

Contact this candidate

Resume:

Vincent Cardamone

630-***-****

***********@*****.***

OBJECTIVE:

Seeking a data science position where I can leverage my strong analytical aptitude, statistical knowledge, and business experience to drive insights and solutions. Committed to developing a career in data science and contributing positively to your company's success.

EDUCATION:

Masters of Data Science, DePaul University, Chicago, IL (GPA: 3.95)

•Related Courses: Python Programming, Fundamentals of Data Science, Advanced Data Analysis, Regression and Programming Machine Learning Applications

•Projects: MovieLens Recommender System, Predicting NFL Game Winners

Bachelor of Arts in Mathematics, Carthage College, Kenosha, WI (GPA: 3.4)

•Related Courses: Computer Science, Actuarial Science, Theory of Statistics, Security and Portfolio Analysis

•Senior Research: Football Simulation Using the Normal Distribution

PROFESSIONAL EXPERIENCE:

Senior Data Analyst, U.S. Cellular, Chicago, IL Aug. 2023 – Present

•Optimized marketing campaign metrics queries, reducing total runtime by 50%

•Developed custom SQL queries for ad-hoc reporting on large datasets, optimizing marketing campaign metrics queries.

•Develop over 100 unique SQL scripts annually, ranging from concise 10-line scripts to extensive solutions spanning thousands of lines of code

•Demonstrate adaptability and problem-solving skills in tailoring solutions to address various analytical challenges, showcasing robust technical skills

•Utilized Tableau to measure churn related to throttling, identifying key insights to improve customer retention

•Coached junior associates and reviewed their code to ensure quality and efficiency

Senior Data Analyst, Capstone Logistics, Chicago, IL Feb. 2023 – Aug. 2023

•Created custom SQL queries utilizing window functions, subqueries and case statements to communicate complex logistics data in Tableau

•Developed Tableau productivity dashboards, collaborating with carriers and carrier representatives, displaying key performance indicators for gross profit and on-time shipping percentages

•Collaborated with upper-level management to create a Tableau dashboard for gross profit comparison year over year and year-to-actuals, improving budgeting and forecasting processes by 10%

Technical Analyst, Millennium Trust Company, Oak Brook, IL Aug. 2021 – Feb 2023

•Served as a liaison between software developers and business users in an Agile format for large projects, such as the Consumer Platform

•Created Class diagrams for Salesforce and Activity diagrams for the front-end user experience related to our Consumer Platform project

•Troubleshoot user problems in Salesforce related to administrative rights, process flow and bugs

•Design low-code solutions within Salesforce utilizing Flows and Process Workflows to save time for business users

•Developed Python scripts to interact with FullStory’s API to store and manipulate data in MS SQL Server and visualize insights in Power BI

•Utilize Fullstory data and Power BI to draw insights into why users are leaving the website before claiming their account. One such example, that 12% of users were signing back into their existing account and not opening an account

Supply Chain Data Analyst, Freeosk Inc, Chicago, IL Sept. 2019 – Aug. 2021

•Constructed VBA macros to automate monthly Excel forecasting files cutting the time from 1 hour to 10 minutes

•Utilized Python Pandas, Matplotlib and Sklearn libraries to manipulate complex data and track forecasting, uptime and shipping saving 1 hour of work per user monthly for 3 users

•Created custom MySQL queries to track historical inventory scans and shipments for all Fortune 100 consumer packaged goods companies

•Developed Tableau dashboards for the supply chain team, providing a single source of truth and highlighting key performance indicators

•Forecasted sample demands and sample distributions in Excel for upcoming product promotions using historical Supply Chain data

•Collaborate cross-functionally with Engineering, Client Success, and Sales teams to accurately supply forecasts and handle issues efficiently as they arise to ensure program success

•Onboarded new members of the Inventory Analysis team, providing training on forecasting, SQL, and Python.

Operations Analyst, IMS, Kenosha, WI Oct. 2016 - Sept. 2019

•Extract data from database systems and create SQL queries and tables to identify trends and improve efficiency. One project involved optimizing warehouse production and resulted in an increased efficiency of 15%.

•Provide client services, analysis, and reporting for Fortune 100 companies

•Assist in data storage and implementation of systems to analyze data

•Utilize data analytics to measure and monitor the impact and performance of warehouse operations

•Train coworkers on Microsoft SQL Server

•Extract and analyze data to compile pricing options for utilization by upper management

•Manage multiple project goals, deadlines, and client expectations even under conflicting demands and unexpected changes

Reporting Analyst, IMS, Kenosha, WI July, 2015 - Sept. 2016

•Developed batch files, SQL scripts and VBA macros to automate daily, weekly, and monthly tasks for departments within the company

•Assisted with data storage and implementation of systems to analyze data

•Created SQL views and tables to track historical sales

•Manipulated, cleaned & processed data using Excel and SQL

•Extracted data and created SQL queries and tables based upon AS/400/JDE Edwards

TECHNOLOGICAL SKILLS:

•Strong statistical and mathematical skills (probability theory, hypothesis testing, regression analysis, machine learning - linear regression, logistic regression, decision trees, and clustering techniques)

•Proficiency in programming languages such as Python (SKlearn, Pandas, Matplotlib, TKinter) and SQL (Case Statements, Stored Procedures, Window Functions)



Contact this candidate