| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLEEMAIL AVAILABLEOBJECTIVE: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 ApplicationsProjects: MovieLens Recommender System, Predicting NFL Game WinnersBachelor of Arts in Mathematics, Carthage College, Kenosha, WI (GPA: 3.4)Related Courses: Computer Science, Actuarial Science, Theory of Statistics, Security and Portfolio AnalysisSenior Research: Football Simulation Using the Normal DistributionPROFESSIONAL EXPERIENCE:Senior Data Analyst, U.S. Cellular, Chicago, IL Aug. 2023 PresentOptimized 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 codeDemonstrate adaptability and problem-solving skills in tailoring solutions to address various analytical challenges, showcasing robust technical skillsUtilized Tableau to measure churn related to throttling, identifying key insights to improve customer retentionCoached junior associates and reviewed their code to ensure quality and efficiencySenior Data Analyst, Capstone Logistics, Chicago, IL Feb. 2023 Aug. 2023Created custom SQL queries utilizing window functions, subqueries and case statements to communicate complex logistics data in TableauDeveloped Tableau productivity dashboards, collaborating with carriers and carrier representatives, displaying key performance indicators for gross profit and on-time shipping percentagesCollaborated 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 2023Served as a liaison between software developers and business users in an Agile format for large projects, such as the Consumer PlatformCreated Class diagrams for Salesforce and Activity diagrams for the front-end user experience related to our Consumer Platform projectTroubleshoot user problems in Salesforce related to administrative rights, process flow and bugsDesign low-code solutions within Salesforce utilizing Flows and Process Workflows to save time for business usersDeveloped Python scripts to interact with FullStorys API to store and manipulate data in MS SQL Server and visualize insights in Power BIUtilize 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 accountSupply Chain Data Analyst, Freeosk Inc, Chicago, IL Sept. 2019 Aug. 2021Constructed VBA macros to automate monthly Excel forecasting files cutting the time from 1 hour to 10 minutesUtilized 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 usersCreated custom MySQL queries to track historical inventory scans and shipments for all Fortune 100 consumer packaged goods companiesDeveloped Tableau dashboards for the supply chain team, providing a single source of truth and highlighting key performance indicatorsForecasted sample demands and sample distributions in Excel for upcoming product promotions using historical Supply Chain dataCollaborate cross-functionally with Engineering, Client Success, and Sales teams to accurately supply forecasts and handle issues efficiently as they arise to ensure program successOnboarded new members of the Inventory Analysis team, providing training on forecasting, SQL, and Python.Operations Analyst, IMS, Kenosha, WI Oct. 2016 - Sept. 2019Extract 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 companiesAssist in data storage and implementation of systems to analyze dataUtilize data analytics to measure and monitor the impact and performance of warehouse operationsTrain coworkers on Microsoft SQL ServerExtract and analyze data to compile pricing options for utilization by upper managementManage multiple project goals, deadlines, and client expectations even under conflicting demands and unexpected changesReporting Analyst, IMS, Kenosha, WI July, 2015 - Sept. 2016Developed batch files, SQL scripts and VBA macros to automate daily, weekly, and monthly tasks for departments within the companyAssisted with data storage and implementation of systems to analyze dataCreated SQL views and tables to track historical salesManipulated, cleaned & processed data using Excel and SQLExtracted data and created SQL queries and tables based upon AS/400/JDE EdwardsTECHNOLOGICAL 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) |
