Data Analyst Business Intelligence

Profile Summary

Analytical, accomplished, professional Business/Data Analyst/Developer with experience in multifaceted roles requiring business intelligence and database architecture. Skilled in the areas of data analytics and development. Motivated and eager to grow my career as an Analyst/Developer and eventually transition to an analytical minded executive role within a growing and technically advanced organization.

Skills

Experience with the following programming languages: Python, R, Stata, SQL, Java, SAS, and VBA

Experience with the following statistical/analytics packages: Tableau, Looker, Power BI, Google Analytics

Experience with creating views, stored procedures, and running queries from the following databases: Microsoft SQL Server, Oracle, Snowflake, Amazon Redshift

Mastery of Microsoft Excel/Google Sheets (Power Query, Pivot Tables and V-Lookups/H-Lookups)

Remote communication tools: Outlook, Jira, Confluence, Basecamp

Strong analytical and quantitative skills

Excellent attention to detail for providing accurate documentation, clear communication, and quality reports to agreed deadlines

Experience

YInteractive, Palmyra, PA January 2023 – Present

Tableau Developer/Analytics Consultant (Remote Part Time Freelance Role)

Develop and maintain Power BI and Tableau dashboard and/or reports for clients in the higher education and government sectors.

Work with clients to understand their data needs and translate them into visually appealing and informative dashboards.

Write SQL queries to extract data from databases.

Collaborate with cross-functional teams to ensure data accuracy and relevance.

Stay up to date on Tableau product updates and best practices

Ventera Corporation, Reston, VA January 2023 – Present

Business Analyst/Technical Project Manager Consultant (Remote Role)

As a Technical Lead, create elicitation sessions to gather and analyze Business requirements with product owners and other business stakeholders.

Worked extensively with Marketing team leads as stakeholders for the dashboard and development deliverables

Analyze new data sources of structured/semi-structured and unstructured data for integration into the application.

Analyze existing data sources to assess the impact of new requirements.

Create and document functional requirements including process flows, data movement from source to target destinations, and related table/data definitions and transformations, including addressing data governance standards.

Design and document end-to-end solutions, translating and allocating all functional requirements into an appropriate design for data integration working with the Data Architects, Developers, and QA and Ops teams.

Design dashboard mock-ups, develop SQL logic and guide engineering teams through the development of high-quality analytics dashboards.

Set up and facilitate cross-functional requirements and design sessions.

Track and drive approval of requirements and solution design documents.

Collaborate with cross-functional teams through agile development, providing insight into the functional requirements and solution design.

VF Corporation, Denver, CO September 2022 – January 2023

CLM Data Analyst (Remote Contract Role)

Developed data completeness, customer newsletter, and customer conversion Tableau dashboards for all global VF brands through Redshift SQL scripts

Created consumer insights analysis for Fiscal Year 2023 through Redshift SQL and Tableau

BJ’s Wholesale Club, Westborough, MA March 2022 – August 2022

Senior E-Commerce Data Analyst (Remote Contract Role)

Analyzed pre vs post analysis for Same Day Select program through in club and digital sales channels to analyze revenue, orders, and unit variance after program was purchased through Excel and Tableau

Forecasted digital member transactions six fiscal weeks out with a SARIMAX model utilizing time series B2B data

Developed Amazon Redshift SQL logic which improved existing and created new Tableau analytical dashboards

Built out draft versions of several regression models for member digital order data using AWS and Amazon Machine Learning

Analyzed online account registration trend for different BJ’s membership types and determined that periods of high online account creation didn’t have a strong relationship with higher average member spend and average orders per member.

Created ad-hoc analysis reports through SQL, Python, R, or Excel for digital managers.

Interpersonal Frequency, McLean, VA October 2021 – June 2022

Data Analyst (Remote Freelance Part Time)

Creating analysis using Python, R, and Tableau to show insight on standard benchmarks for city and county level clients utilizing K-Means clustering machine learning

Ran analysis on county website survey for Washington County, Oregon that showed that about 25% of their website users’ success and satisfaction with the site was due to the Sherriff departments website.

Ran Sentiment Analysis utilizing R programming on text survey response data for city, county, and other civic websites to show emotion and sentiment over different timelines and how it relates to average satisfaction and success

Data Sleek, McLean, VA October 2021 – July 2022

Tableau Analyst (Remote Freelance Part Time)

Rebuilt and created new dashboard reports within Excel and Tableau for general merchandising and healthcare companies

Built out scorecard reports through Snowflake database with Apache Superset and Excel

Created looker dashboards via LookerML and Google Query that tracked different insurer status, relationships, and demographics for Health Karma Group

Infusion Health Corp, Newport Beach, CA August 2020 – May 2022

Excel Programmer/Analytics Consultant (Remote Freelance Part Time)

Developed a fee comparison file that automates showing the higher payout between OBL and ASC procedure types for specific payers with customized payouts for different procedures

Created Excel dashboards for operations data used by multiple medical branches

Imported data, ran reports, and debugged some errors within Salesforce Health CRM platform

AMC Networks, New York, NY September 2021 – February 2022

Business Analyst (Remote Contract Role)

Automated weekly reporting for AMC Plus television series and movies utilizing Tableau, VBA, and Python.

Analyze US, Canada, and Australian streaming data for different timelines from different data sources coming from Amazon, Apple, Comcast, YouTube TV, Roku, and Direct to Consumer (DTC).

Ran an updated Stata programming scripts to automate weekly, monthly, and first streams viewing data for executives to view within executive level dashboard

Skidmore College, Saratoga Springs, NY October 2019 – September 2021

Prospect Research Analyst

Created internal RFM analytics score that scores Skidmore donors based on their giving data

Built map dashboard report in SSRS that will be used for providing data driven information for where Skidmore’s President should travel in the US

Create and send different reports for Skidmore’s Office of Advancement and other offices requesting Alumni data using Microsoft SQL, Oracle SQL, Power BI, PLSQL, SSMS, and SSRS Reporting Tools.

Created SQL scripts, views, and stored procedures utilizing PLSQL developer tool for Oracle Database Server

Built Python Jupyter Notebooks for gift officer donor pool hygiene analysis which removed insignificant donors and suggested statistically significant prospective donors

Ran predictive modeling on Skidmore Alumni donors utilizing binomial regression modeling in R programming to predict future campaign giving percentages.

Latham Pool Products, Latham, NY June 2017 – October 2019

Data Analyst

Worked as Marketing Data Analyst Intern before full time from November 2016 – June 2017

Worked cross functionally with IT, Finance, and Operations in the cleanup of 4D relational database software by redesigning price model structure which ended up removing 50% of obsolete pricing data

Analyzed sales data through Excel, R, and Python to identify trends relating customer accounts and product major types which contributed in a 22% growth in sales from June 2017 to December 2018

Analyzed pricing and customer data daily with C and SAS programming to resolve pricing related I.T. help desk tickets for customer accounts with over $1,000,000 in yearly sales

Drafted SOP documentation for pricing data models and extracting marketing data from System 21 ERP system

Education

Rochester Institute of Technology, Rochester, New York Graduated – May 2021 Master of Science: Applied Statistics

Cumulative GPA: 3.46/4.0

Siena College, Loudonville, New York Graduated – May 2016 Bachelor of Science: Actuarial Science

Cumulative GPA: 3.7/4.0

Contact this candidate