Years of experience: 14

ConsultingData EntryQuantitative AnalystBI AnalystData AnalystData Scientist

Trusted by top professionals

Trust Score

Exceptionally trusted; proven professional excellence.

90%
John's Career Path
Analytics & Reporting Consultant Apr. 2015 -
Present
Blue Cross and Blue Shield of Illinois, Montana, New Mexico, Oklahoma & TexasAnalytics & Reporting Consultant
Chicago, IL- Independently build forecast regression models as part of a three-tiered Spend Analysis to better align forecasts to actual spend using SAS, and R for data manipulation, measurement and modeling as well as Tableau for visualization - Write requirements for, and oversee, the construction of SQL Server tables, populated by a Hadoop data lake Sqoop, to house raw fact and attribute tables for T...
VBA Developer - ConsultantFeb. 2015 -
Apr. 2015
Sloan Valve CompanyVBA Developer - Consultant
Greater Chicago AreaDesign and code proprietary, automated VBA applications to the specifications of the HR department for attendance tracking and historical records Test completed versions of the applications along with end users and make coding adjustments based on user experience and functionality Migrate historical records to new applications from multiple sources to comply with collective bargaining agreeme...
Senior AnalystJul. 2014 -
Nov. 2014
Anthem Marketing SolutionsSenior Analyst
Chicago- Use PC SAS (BASE SAS, PROC SQL, SAS STAT and MACROS) to gather MS SQL Server sourced data summarize to build propensity response and optimization models to increase sales and minimize cost per acquisition - Work with a large service account to measure success for DM marketing efforts based on calculated lifts between control/treatment groups and champion/challenger messaging - Interpret sum...

John's Posts

  • 0

    How I can help you

    • Solve project & financial data questions • Optimize capacity, scheduling, & forecasting • Extensive coding & analytical skills • Presentation expertise & PhD-level stats • 20+ years in data analysis

  • 0

    People I am looking for

    • Open to organizations needing data solutions • Data development, analysis, modeling • Presentation enhancement

  • 0

    Experience & Cases

    • Propensity models boosted conversion by 25% • Developed tools reducing variance by 17% • Member segmentation increased sales by 10% • Clients: HCSC, Bank of America, USAA, Dell, USAF, US Army

  • 0

    How to contact

No responses yet
0
  • 0

    How I can help you

    I efficiently gather, clean, and manipulate data, developing insightful reports and Power BI dashboards using SQL, SAS, R, and DAX. My advanced skills in statistical inference and data visualization ensure clear storytelling and comprehensive analysis.

  • 0

    People I am looking for

    - Advanced SQL & statistical skills - Full-cycle tool design - Expertise in R, SAS, SQL, VBA, DAX - Strong data visualization abilities

  • 0

    Experience & Cases

    - Businesses needing quantitative insights - Professionals seeking predictive modeling - Clients requiring professional reporting & visualization

  • 0

    How to contact

No responses yet
0
  • 0

    About myself

    With of experience, I excel in developing analytic and reporting tools across various languages like VB, SAS, DAX, SQL, and R. Proficient in automation with Alteryx and UIPath, I create sophisticated dashboards in Power BI, specializing in healthcare data and marketing analytics.

  • 0

    Job Description

    I'm looking for a part-time, remote role that emphasizes data usage, analytics, interpretation, and presentation, allowing me to leverage my expertise in crafting data-driven insights and solutions.

  • 0

    How to contact

Responded by 1 people
0