Jonathan Reed Email & Phone Number

Seattle, WA

• Create data flows and data marts from SQL Server in Power BI to populate Power BI dashboards
• Build, maintain, and curate code for shared datasets in SSRS
• Modify data service products as necessary to keep pace with evolving client needs

Greater Seattle Area

• Performed requirements gathering with customers to ensure solutions, reports, and measures meet customers' needs
• Created, automated, and managed KPIs and care quality measures using MSSQL to consolidate data across large healthcare datasets like enrollment, claims, and demographics
• Prepared and constructed vizualizations in PowerBI and Tableau driven by automated KPIs
• Generated ad hoc reports using MSSQL for delivery to customers in a formatted Excel report

Plantation, FL

• Leverage patient data to create and manage outreach programs to increase desired patient behavior and divert costly behaviors to more efficient alternatives through e-mail, text message, and phone using Twilio and.
• Generate dashboards to end-user spec using PowerBI to track outreach program messaging volume, success, revenue generated, and other metrics
• Transform manual reporting processes into automated reports using SSRS to be delivered by e-mail on a schedule, or into dashboards with live data using PowerBI
• Perform requirements gathering to create ad hoc reports and ensure the reports answer theoriginating question and provide appropriate context for the information provided
• Cultivate cross-disciplinary partnerships between departments to identify new growth initiatives and create new projects, reports, and campaigns to better serve and manage the client population
• Clean, format and import a wide variety of datasets using SSMS to ensure continuity of chronological data sources and general data concordance between related tables

Plantation, Florida

• Created and implemented methodology for Abaca candidate identification to improve e-mail stream inboxing by up to 80%
• Collaborated with development team to create and troubleshoot tools to assist in Abaca candidate identification, reducing man hours spent per week on the process from 5 hours to 1 hour
• Generated and maintained dashboards and visualizations to direct attention to advertising vertical and client performance, allowing sales and management personnel to direct efforts into improving CPM/CPC/CPA rates
• Created KPI monitoring dashboard to flag Advertiser/Publisher combinations for potential fraud over various geographical profiles, leading to investigations into instances of potential fraudulent activity
• Performed query optimization to reduce network load during execution of frequently used queries, reducing Abaca primary query execution time from 45 minutes to 15 minutes
• Collaborated on data analysis problems to improve development of more versatile, robust dashboards and streamline acquisition and verification of incoming data streams

Government Of Newfoundland & Labrador, Department Of Finance

• Project description: trend healthcare data over six decades to predict healthcare needs for long-term care facility residents
• Cleaned and analyzed health and long-term care data to align with international MDS standard by using Excel VLOOKUP and INDEX/MATCH fuctions
• Validated data through use of dynamic concordance tables in Excel
• Reconciled data with known discrepancies to ensure validity and integrity
• Reduced error rate from 8% to less than 3% through research and application of the Luhn Algorithm (mod 10 checksum formula)

Gatineau, Quebec, Canada

• Created reports using procedural programming in SAS (primarily PROC SQL)
• Prepared pre-formatted report templates using Microsoft Excel for Dynamic Data Extraction
• Extracted datasets from main data warehouse using Cognos Impromptu
• Responded to requests for information from client departments with ad hoc reports
• Programmed task tracking module using Microsoft Access which is used to track the progress of projects internal to the unit
• Generated daily, weekly, and monthly reports, changing report parameters as requested

St. John's, Newfoundland And Labradror, Canada

• Assisted with SharePoint portal design, upkeep, and list development and data conversion
• Created internal company social forum (Slip Forum), drafted terms of use
• Managed computer deployment information, including serial numbers, installed memory, and deployed peripheral assets
• Provided instructional seminar on how to use the new SharePoint mobilization list
• Assumed responsibility of the Kværner PC mobilization process, developed a database to track user and asset information

Gatineau, Quebec, Canada

• Created reports using procedural programming in SAS (primarily PROC SQL)
• Prepared pre-formatted report templates using Microsoft Excel for Dynamic Data Extraction
• Extracted datasets from main data warehouse using Cognos Impromptu
• Responded to requests for information from client departments with ad hoc reports
• Generated daily, weekly, and monthly reports, changing report parameters as requested

Programmer Analyst, Information Technology

Activities and Societies: Peer TutoringProgrammer-Analyst

Master Of Music, Vocal Performance, Dean'S List

Activities and Societies: Opera Workshop, Opera StudioMusic (Voice performance)

Bachelor Of Music, Vocal Performance, Director'S List

Activities and Societies: MUN Chamber Choir, MUN Opera Workshop, MUN Opera Outreach ProgramMusic (Voice performance)