Data Analyst Power Bi

Jared Coffin

Hewitt, NJ ● ***@***********.*** ● linkedin.com/in/jaredcoffin

EXPERIENCE

Merck - Rahway, NJ January 2023 - February 2025

Data Analyst -

Reports include Vaccine/Parasiticides sales and dose analysis in Power BI visualizations along with KPIs, Year over Year, YTD, monthly and weekly sales, data driven by AWS Redshift. Market Share and MAT (Moving Annual Total) line graphs used DAX aggregates, Filters, and Time Intelligence functions for sales/doses analysis by manufacturer, product, and clinics.

●SQL aggregations, WITH sub-selects, Pivots, and Window functions for ranking and moving annual/monthly totals. SQL drives Power Query in Excel for summary charts showing KPIs for Nation, Zone, Region and Territory.

Product Backorders: Used Alteryx batch macros to organize hundreds of files with similar column names for aggregate analysis. Created bulk import into AWS Redshift with Alteryx iterative macros.

J.M. Rodgers - Sparta, NJ August 2021 - December 2022

Data Analyst -

SQL queries and Python analyze billing and drawback data from SQL Server and Oracle customs management databases.

●Gather invoice documents via ETL from customs management REST API.

●Alteryx to assemble reports from Oracle and SQL Server with workflows using Cross-Tab and Transpose tools, Calgary tools for large query prep for quick access. Render tools combine tables and visualization output to Excel.

●Excel reports and their PDF invoice scans generated through Python queries via REST API and SQL Server.

●Tableau Cloud reports using Tableau Prep and Desktop using multiple data sources with extract and live queries.

Jeff W. Coffin Art - Data Analyst December 2019 - July 2021

Used ETL to extract lists of art data and load into MySQL. Categorized and arranged art data by painting type, media, genre and time of creation.

KPMG, Montvale, NJ April 2017 - November 2019

Data Analyst/Web Producer -

Managed SharePoint site collection, including permissions for SharePoint and Active Directory users and applicant/instructor reports.

●Alteryx workflows built to compare Excel data with SharePoint list data using join, pivot and data cleaning tools. ETL process used a command line tool to streamline nomenclature and folder organization from Alteryx.

●Power BI visualizations were driven by complex power queries, often (un)pivoting to display results of similar columns from SharePoint lists.

●SharePoint Designer maintained workflows, web parts, edit views and forms. Workflows ranged from item column updates to multi-row updates using REST calls.

Migrated SharePoint 2007 to 2013 using migration tools for bulk list/library transfer.

●ETL by extracting web tabular data into Excel, then loading data back into SharePoint lists.

ASME, Little Falls, NJ April 2016 - April 2017

Web Producer

Chief Executive Group, Greenwich, CT March - November 2015

Wordpress Developer

Elizabeth Arden, New York, NY June 2013 – August 2015

Senior UI Developer

CERTIFICATION

Microsoft Certified: Power BI Data Analyst Associate PL-300

EDUCATION

Arizona State University – B.S. Aeronautical Management Technology

SKILLS

Analysis: Power BI, Alteryx, Power Query, Excel, Python, Tableau

Data: ETL, AWS Redshift, SQL Server, MySQL, REST API, JSON, XML, Regular Expressions

Web: SharePoint/Power BI Service.

VOLUNTEERING

Campaign Zero May 2021 - July 2021

Collected police contract data from city and townships to store for analysis.

Contact this candidate