Connect with Me via Social Media
Hi, I’m Jake
I'm an IT Professional experienced in Business Data Analytics and Software Engineering located in Delray Beach, Flordia. I am well versed in HTML/CSS/JS, Python, Power BI, SQL, and Microsoft Excel.
Things I've Made
Florida Ocean Water Temps Animator
Animation of Florida's ocean water temperatures. Built by webscraping an image off of Surfline daily and then stitiching each image together to make a GIF, all through Python.
The first half of the file is the webscraper, which uses the PIL and imageio libraries to write the date/time on each image, while the second half of the file turns the folder of images into a GIf using the moviepy.editor and PIL libraries.
Download the file by clicking here:
The first half of the file is the webscraper, which uses the PIL and imageio libraries to write the date/time on each image, while the second half of the file turns the folder of images into a GIf using the moviepy.editor and PIL libraries.
Download the file by clicking here:
Python
PNG to JPG to Webp Converter
This program takes any image found in a folder that has the ending file types: JPEG, JPG, and PNG and converts them all to the web-friendly Webp format. The program can be easily adjusted to convert any of the file types to one another by changing the first function to what file type they want and then alter the second function to select which file types to convert. When building sites, this helped me immensely in speeding up load times.
Download the file by clicking here:
Download the file by clicking here:
Python
Realtor.com Realtor Webscraper
A friend of mine is a drone pilot and he wanted to reach out to all the local realtors and offer his services to take pictures of their property. I built this webscraper for him so he can mass message them instantly!
This works by changing the base url to the wanted city and it then grabs every realtor's name and phone number on that page to the 50th page and exports both columns into a CSV file.
Download the file by clicking here:
This works by changing the base url to the wanted city and it then grabs every realtor's name and phone number on that page to the 50th page and exports both columns into a CSV file.
Download the file by clicking here:
Excel
Python
E-Commerce Dashboard
Dashboard detailing the sales performance of an Amazon-based e-Commerce. Data was downloaded via Seller Central, imported to a running report in Excel via Power Query, and finally brought in for Data Visualization in PowerBI.
Download the files by clicking them here:
Download the files by clicking them here:
Excel
Power BI
My Resume
2016 - 2020
Education
Masters of Science: Information Technology Management
Florida Atlantic University (2018 - 2020)Courses:
- Web Based Business Development
- Data Mining and Predictive Analysis
- Business Data Communications
- Information Technology Fundamentals
- Database Management Systems
- Advanced Systems Analysis and Design
- Management Information Systems and Technology
- IT Sourcing Management
- IT Project and Change Management
- Enterprise Information Technology Service Management
- Intro to Data Science
- Information Retrieval
- Information Theory
- Graduate Business Communications Applications
- Data Management and Analysis with Excel
- Management of Information Assurance and Security
- Information Theory
Programs/Languages Used:
Graduate Certificate: Big Data Analytics
Florida Atlantic University (2018 - 2020)Courses:
- Database Management Systems
- Introduction to Business Analytics and Big Data
- Data Mining and Predictive Analytics
- Advanced Business Analytics
- Social Media and Web Analytics
- Data Analysis for Managers
- Data Management & Analysis with Excel
- Business Innovation with Artificial Intelligence
Bachelors of Arts: Mathematics
Florida Atlantic University (2016 - 2018)- Published Research with the Florida Atlantic Undergrad Research Journal of my team's
work modeling cancer cells in 2D and 3D environments and studying the effects of increased drug toxicity vs increased
absorption rate.
Models were built in MatLab.
2019 - 2023
Experience
UKG
Sr. Business Data Analyst 2023 - Present- • Played a crucial role in driving data-driven decision-making and optimizing business processes within the organization.
- • Gathered, analyzed, and interpreted complex data sets, providing actionable insights that support strategic initiatives and enhance operational efficiency.
- • Collaborated with cross-functional teams to identify, prioritize, and define business requirements and objectives.
- • Designed and implemented data models, ETL processes, and analytical workflows to collect, organize, and validate data from various sources.
- • Performed advanced data analysis using statistical techniques and tools to uncover patterns, trends, and correlations.
- • Developed and maintained dashboards, reports, and visualizations to present data-driven insights and key performance indicators (KPIs) to stakeholders and management.
- • Identify opportunities for process improvement and optimization by analyzing existing workflows, data flows, and business operations.
- • Worked closely with stakeholders to understand their needs, provide recommendations, and ensure alignment with business goals.
- • Conducted thorough data validation and quality assurance checks to ensure accuracy and reliability of data outputs.
- • Collaborated with development teams to translate business requirements into technical specifications and ensure the successful implementation of data solutions.
- • Stayed up to date with industry trends, emerging technologies, and best practices in data analysis and agile methodologies.
- • Mentored and guided junior analysts, providing technical expertise and support as needed.
Mix Wholesale
Data Analyst & Website Developer Tamarac, FL (2019 - Present)- • Created and maintained fully-automated Excel PowerQuerey reports.
- • Helped launch 4 Shopify-based e-commerce websites within 3 months.
- • Maintained those Shopify sites, regularly making updates based on changes ownership wanted.
- • Documented and published Standard Operating Procedures for employees to learn how to operate reports.
- • Connected Excel-based reports to PowerBI and created customized dashboards for each department.
- • Built inventory management dashboards in PowerBI for reordering inventory and ensuring constant stock.
- • Lead team trainings, teaching coworkers how to use Excel, PowerBI, and NetSuite.
- • Created custom SQL-based formulas and reports in NetSuite for coworkers and management.
- • Generated KPI measurement tools in both NetSuite and PowerBI.
- • Designed and launched automated measures in PowerBI that determine quantities to purchase and out-of-stock dates.
- • Provided consistent support to Sr. IT technician in the company, helping put out fires that take multiple people.
- • Designed and built Python automated scripts to collect daily inventory reports from multiple websites.
- • Managed Amazon Pay-Per-Click advertising campaigns that spanned over 40 products.
- • Built master data files that contain all descriptive and categorical data for every SKU in the company’s database.