Jed P. Email & Phone Number

Remote

- Developed, maintained, and scheduled SQL Server Integration Services (SSIS) packages to automatically extract and load data from Excel files into staging tables every 24 hours.- Wrote and executed DDL and DML SQL (Views, Tables, Stored Procedures, CTEs etc) in Microsoft SQL Server Management Studio (SSMS) for data modeling, enabling 500+ users access to daily production ready data.- Created Microsoft Power BI dataflows and star-schema semantic models for analysts, enabling a “source-of-truth” environment for 10+ internal ops teams including Go-To-Market Sales, Renewals, Information Systems, HR, and more.- Designed interactive dashboards using complex DAX (Data Analysis Expressions), power query, calculated columns, bookmarks, and KPI measures for leaders to execute data-driven decision making which has enabled a 5%+ year-over-year growth in overall revenue acquisition.- Administered Power BI user access across the org by utilizing RLS (row-level security) and audiences for over 800+ users.- Streamlined analysts' workflows by developing ad-hoc level refreshable DAX datasets, reducing manual reporting efforts from 8+ hours per week to less than 10 minutes.

Orange County, California Area

- Developed an ETL process mini-application using SQL, and VBA in Microsoft Access to extract, transform, and load 50+ different sources of payroll data, saving payroll processors up to 8 hours of time on a weekly basis.- Developed weekly and monthly reports in Power BI on data errors to assist stakeholders and executives on reducing weekly data fallout rate from 10% to 2% or lower.- Trained a small team of payroll processors via created documentation and video tutorials to use these ETL applications within their normal workflows, reducing the payroll inaccuracy data entry rate from 25% down to less than 1%.

United States

Riverside