Frederick H. Shepphird

Newport Beach, CA ***** Cell 949-***-**** ad42rc@r.postjobfree.com

Summary

Qualified as an excellent candidate for the Business Intelligence opportunity. Here is a synopsis of recent SQL Server Reporting Services implementation and development. Deserving of mention over 15+ years of Business Intelligence design and development projects.

Over 20+ years developing MS SQL Server and Oracle stored procedures, view, functions,, Azure Managed Instance SQL Server. Azure ADF, SSRS, DTS/SSIS packages, SSAS objects and SQL Agent jobs. Utilizing environment Server 2000–2019, SSMS, Azure Managed Instance SQL Server, Azure Data Factory.

20+ Years’ experience developing SSRS complex reports and merge letters. To include developing SSRS complex code functions, VS Studio C# libraries and custom XML and PDF render method classes. An area of great expertise is SSRS subscriptions services to include website, eMail, PDF and repository delivery methods. Oversaw the implementation and management for SSRS data driven subscriptions services, and User security configurations. 10 Years developing Power BI reports and dashboards.

The complexity of report design experience includes very interactive reports, including Cube drilldown, complex pivot tables, rendering of data driven stored images, mobile device deliverables. Have a substantial portfolio to present.

SQL Server Database, Oracle ERP and Business Intelligence Development

Member of data warehouse team developing Star Schema database architecture, stored procedures, views, triggers, functions, OLAP Cubes with platforms Visual Studio .NET and Microsoft SQL Server Enterprise Manager 2000 – 2019, Azure Data Factory and Azure SQL Managed instance.

Develop enterprise Data Mart and Web Reporting Services in SQL Server SSRS, SSIS, SSAS, C #, VB.Net, Azure Data Factory, Data Lake, Amazon Web Services, Tableau Report Server.

Research and design Business Intelligence strategies and deliverables identifying key performance indicators and measures, Power BI & Tableau Dashboards.

Develop Electronic Data Interchange applications and reporting solutions for finance, marketing, Supply chain,operations and analysis. Develop Web Service API’s for Cloud Based Application Interface.

Design and develop Executive Information System, Digital Dashboards, OLAP Cubes, eMail and mobile device deliverables.

Client Server, Internet/ Intranet, Enterprise Resource Planning Application Development

Design financial analysis and business intelligence reports with SQL Server SSRS/SSIS/SSAS, Excel Power Pivot, Power BI, Tableau & Cognos, AWS.

Enhance enterprise reporting and marketing web site utilizing ASP/ASP.NET/C#/ JQuery, HTML5, SharePoint, Power BI Server, Tableau Server.

Develop Internet applications in ASP/ASP.NET/C#/Java Script/JQuery, XHTML/DHTML/HTML5 CSS, and SQL Server.

Extensive application development utilizing platforms Visual Studio.NET in C# / VB.NET, Oracle/JDE native code & APEX

Create automated graphical Web reporting capabilities utilizing SQL SSRS, Power BI, Business Objects 11, Tableau, Cognos, Azure, Amazon AWS.

Research and develop data mapping and interface for ERP accounting systems Oracle / PeopleSoft / JD Edwards Enterprise One, Epicor, In Four, IFS, MAS90, MS Dynamics AX.

Business Analyst and Project Management

Develop project scope and requirement specifications through research, client interview, focus groups, workflow and business analysis.

Document detailed technical and functions specifications incorporating MS Project, Visio flowcharts, Data Dictionaries.

Design and implementation change control standards, Source Safe storage protocols, system requirements documentation, quick start guides, system and end user training documentation. Provide software application technical support.

Focus group with project shareholders identifying data element dimensions, facts and metrics for OLAP cube objects.

Technical Skills: Effective communications and understanding of marketing, business intelligence, strategic planning, operations, project management and life cycle system design methodologies. Fluent ability with computer programming software including MS SQL Server 2019, Azure Environment, Data Lake, Data Factory, Amazon AWS, SSIS, SSAS, SSRS, TFS, XML Web Services, Sales Force, DB Amp, SharePoint, Layer2 Web Services, Visual Studio .NET, ASP.NET, C#, VB.NET, JQuery, HTML5, Java Script, Visual Basic 6.0, VB Script, VBA, ASP Classic, SharePoint, Excel, Power Pivot, Power View, Power Shell, Power BI, Tableau, Alteryx, Business Objects 11, Oracle 10.x, Cognos 8.0, FoxPro 8.0, Oracle 11.x, MAS 90, Oracle / PeopleSoft / JDEdwards Enterprise One, Oracle's JD Edwards Configurable Network Computing, MS Dynamics 365, SAP, ArcGIS pro and S.A.S.

Education

Bachelor of Science in Meteorology (Weather), Metropolitan State University of Denver, CO, June 1986.

Major course requirements in Computer Science, Mathematics, Communications and Atmospheric Science.

Summer Internship for the Nation Center For Atmospheric Research, Boulder CO, 1986.

Orange Coast College, Costa Mesa, CA. Major course requirements in Science & Art.

Professional Experience

Virgin Galactic Holdings Inc., Tustin, CA 08/2021 – 01/2024

Business Intelligence Solutions Developer, Full Time Employee

Responsibilities

Develop On Prem and Azure Managed SQL Server Data Warehouse with 5 Desperate Data Marts.

Develop ETL process in Visual Studio SQL SSIS and Azure Data Factory Pipelines.

Develop Dashboards & Reports in Power BI, Report Builder, Excel Power Pivot.

Develop Documentation, Project Scopes, Feasibility Treatises and Cost Analysis

Conduct informative meetings through Microsoft TEAMS sharing visuals and project milestones.

Participate in weekly TEAMs Agile meetings observing project and data requirements.

Train staff on ETL, Dimensional Data Modelling, Business Intelligence OLAP database development, Power BI, DAX, Azure Data Factory & Pipeline Development, Azure cloud based Analytics.. Advised on enhancements to migrating objects to Azure environment optimizing performance and efficiency.

Advised Management on the database migration efforts of Microsoft BI Stack implementation, Power BI development, DAX data model development.

Develop Tabular and Multi-Dimensional Cubes in Power BI and SQL SSAS Environments.

Train staff on MS BI Stack development (SSIS,SSAS), Azure Data Factory, business intelligence OLAP database development DAX, Azure cloud based Analytics.

Participate in modification/development of Oracle / PeopleSoft / JDEdwards Enterprise One ERP system.

Southern California Edison, CA 09/2020 – 07/2021

Governess & Reporting, Consultant

Responsibilities

Develop mid-tier ETL applications with SAS, Oracle, ArcGIS Pro, Excel VBA

Develop ArcGIS thematic maps and point layers for field observations and reporting

Develop Dashboards & Reports in Power BI, SAS Viya and VBA Access

Develop Documentation, Project Scopes, Feasibility Treatises and Cost Analysis

Conduct informative meetings through Microsoft TEAMS sharing visuals and project milestones

Participate in weekly TEAMs Agile meetings observing project and data requirements

Train staff on SAS ETL, Dimensional Data Modelling, Business Intelligence OLAP database development, Power Pivot, DAX, Azure, Data Factory and Data Bricks

Advised on enhancements to migrating objects optimizing performance and efficiency.

Advised Management on the database migration efforts, uses of SAS in large scale data modelling and analysis, Microsoft BI Stack implementation, Power BI development, DAX data model development

Train staff on MS BI Stack development (SSRS,SSIS,SSAS), business intelligence OLAP database development, MSX, DAX, Azure cloud based Analytics.

NTT Data, Irvine, CA 09/2018 – 08/2020

Providence/St Josephs Health Care

Business Intelligence Developer, Consultant

Responsibilities

Complete Business Intelligence project for Revenue Cycle Vendor Management for a large Health Care Services entity Providence / St Joseph

Develop mid tier ETL application with Alteryx, SQL Server, Oracle.

Develop Dashboards & Reports in Tableau, PowerPivot and Excel

Conduct Agile meeting in through Microsoft TEAMS sharing visuals and project milestones

Train staff on Tableau & Alteryx development & Dimensional Data Modelling, Business Intelligence OLAP, ETL, database development, Power Pivot, DAX, Azure, Data Factory and Amazon AWS cloud based Analytics

Perform feasibility study on migration of legacy SQL Server 2000 DTS packages to VMWare SQL 2019 environment and Visual Studio 2017 SSIS packages

Automate EDI FTP Processes with SQL Server SSIS and Visual Studio 2017

Advised on enhancements to migrating objects optimizing performance and efficiency.

Prospect Medical Systems, Orange, CA 05/2018 – 09/2018

Database and Software Applications, Consultant

Responsibilities

Member of Information Technology team developing database architecture, stored procedures, views functions. Development platforms Visual Studio .NET, Microsoft SQL Server Management Studio, SQL Tool Belt, Team Foundation Services.

Migrate 12 SQL Server instances of versions 2000 – 2008 to VMWare SQL Server 2018 environment.

Develop system reports reading the MSDB database and other SQL Server System Objects, to assist with the migration efforts.

Participated with QA efforts of migratory databases and objects.

Perform enhancements to migrating objects optimizing performance and efficiency.

Participate in Change Control Meeting and procedures for DBA support and tasks.

Conquest 24/7, Tampa, FL,100% remote 03/2017 – 4/2018 Business Intelligence and Power BI Developer, Consultant

Responsibilities

Develop enterprise Star Schema Data Mart and Web Reporting Services in SQL Server SSRS, SSIS, SSAS. Design financial analysis and business intelligence reports with SQL Server SSRS/SSIS/SSAS, Power BI, DAX, Power Pivot. Design and implement SSRS security protocols within Active Directory Groups.

Develop Power BI dashboards to read Skype database and report on Sales Team telemarketing performance and activity.

All development and production performed on Cloud based Microsoft Azure environments. Develop Data Lake & Data factory processing plans leveraging U-SQL and Azure Analytics

Agility Fuel Solutions, Irvine, CA 04/2016 – 2/2017

Business Intelligence and Power BI Developer, Consultant

Responsibilities

Member of Information Technology team developing database architecture, stored procedures, views, triggers, functions, OLAP Cubes with platforms Visual Studio .NET and Microsoft SQL Server Enterprise Management and Administration.

Develop enterprise Star Schema Data Mart and Web Reporting Services in SQL Server SSRS, SSIS, SSAS. Design financial analysis and business intelligence reports with SQL Server SSRS/SSIS/SSAS, Power BI, DAX and Excel Power Pivot. Design and implement SSRS security protocols within Active Directory Groups.

Enhance enterprise reporting and marketing web site utilizing SharePoint Cloud we pages and web services.

Emerald Expositions, San Juan Capistrano CA 9 /2015 – 3/2016

Database and Software Applications, Consultant

Responsibilities

Managed the installation and configuration of SQL Server 2008 - 2014 SSRS server.

Developed complex data source object, SQL views, Stored Procedures Functions SSRS interactive reports.

Participate in development and enhancement of Star Schema database Operational Data Store.

Develop SSRS reports and SQL Views and Web Services for SalesForce Cloud implementation.

Code complex SQL procedures, views, functions for Financial Analyst and enterprise reporting.

Develop SalesForce Cloud update/insert Web Services utilizing DB Amp utilities.

Design and begin project to store massive data storage in the Azure environment with system to system ETL processes from SaleForce Cloud to Data Factory Azure cloud environments.

Independent Consultant, Newport Beach, CA 2 /2015 – 9/2015

Database and Software Applications

Responsibilities

Develop enterprise Data Mart and Web Reporting Services in SQL Server SSRS, SSIS, SSAS, C #, JQuery.

Managed the installation and configuration of SQL Server 2008 - 2014 SSRS server.

Design financial analysis and business intelligence reports with SQL Server SSRS/SSIS/SSAS, Excel Power BI, Power Pivot

Work with SalesForce administrator sanitizing contact list be exporting data, running through Melissa Data zip + 4 address normalization web service with geo coding. Build queries for User export and reporting.

Implement Solar Wind Server Management studio for overseeing SSRS and SharePoint database servers.

JWC Environmental, Costa Mesa, CA 6 /2014 – 2/2015

Database and Software Applications, Consultant

Responsibilities

Managed the installation and configuration of SQL Server 2008 – 2012 SSRS server.

Developed complex data source object, SQL views, SSRS interactive reports.

Participate in development and enhancement of Star Schema database Operational Data Store.

Design and implement SSRS security protocols within Active Directory Groups.

Redevelop IFS ERP reporting screen to a data driven ASP.Net page directing requests to the SSRS Server or the IFS ERP reports engine, thereby creating a single point of reports access.

Code complex SQL Views and Procedures for Financial Analyst Excel Power Pivot workbooks.

Worked with IFS Administrator building a data dictionary and mapping schemas for ETL into data mart.

Identified User defined fields for screen modification enhancements and User Interface design.

Developed SSIS packages for ETL to IFS database for data extract and database updates from accounting systems and Excel workbooks.

Part of team member meeting when the IFS representative was in office explaining new modules and features. Participated in the IFS upgrade project.

Participated in feasibility plan to leverage Azure environment for overseas data collection and reporting

LAN International, Aliso Viejo, CA 4 /2013 – 12/2013

Database and Software Applications, Consultant

Responsibilities

Developed complex data source object, SQL views, SSRS interactive reports.

Participate in development and enhancement of Star Schema database ODS.

Design financial analysis and business intelligence reports with SQL Server SSRS/SSIS/SSAS, Excel Power BI, Cognos.

Create automated graphical Web reporting capabilities utilizing SQL SSRS, Excel Power BI, Business Objects.

Work with Sales Force Consultants in implementation efforts in creating SQL views for import.

CIG Financial LLC, Irvine, CA 10/2012 – 4/2013

Database and Software Applications, Consultant

Managed the installation and configuration of SQL Server 2008 R2 SSRS server.

Developed complex data source object, SQL views, SSRS interactive reports.

Design and implement SSRS security protocols within Active Directory Groups.

Instrumental in the implementation of new Enterprise Resource & Planning System. Configured New ERP and Data Transfer from legacy Foxpro based DOS system.

CIG Financial engaged in Automobile Loans for Classic cars and non-conventional Auto Loan funding.

WNC Inc., Irvine, CA 01/2012 –9/2012

Database and Software Applications, Consultant

Responsibilities

Managed the installation and configuration of SQL Server 2008 R2 SSRS server.

Developed complex data source object, SQL views, SSRS interactive reports.

Design and implement SSRS security protocols within Active Directory Groups.

Redevelop ERP reports screen to a data driven ASP.Net page directing requests to the SSRS Server or the ERP reports engine, thereby creating a single point of reports access.

Revolutionized WNC processes and methods to create Quarterly Investor Reports, saving staff endless hours of manual processes.

Code complex SQL Views and Procedures for Financial Analyst to call from Excel applications.

Revolutionized WNC processes and methods to create data driven Quarterly Investor Reports, saving staff endless hours of manual processes

Skilled Healthcare, Inc., Foothill Ranch, CA 7/2010 – 12/2011

Database and Software Applications, Consultant

Responsibilities

Cooperated with the implementation of SQL Server 2008 Enterprise Edition on Virtual Machines in the Data Center in Wisconsin.

Configured SQL 2008 SSRS, Security protocols and data driven subscription services.

Develop Star Schema Data Mart, SSIS ETL services and complex SQL View and Stored Procedure data objects, SSAS cubes, MDX and DAX data models and analytical tools.

Managed the SSRS reporting server and created numerous interactive reports and cubes for Skilled Healthcare Hallmark Division.

Set up Regional report security protocols, Active Directory groups and virtual Users.

Develop client API screens, web services, document imaging API in MS Dynamics GP

Previous Database and Software Applications Consultant 8/2000 – 7/2010

UnitedHealth Group, Costa Mesa, CA 6/09 – 6/10

Hanley Wood Market Intelligence, LLC, Costa Mesa, CA 4/09 – 6/09

Dulcinea Farms, LLC, Ladera Ranch, CA 7/08 – 3/09

Citigroup, Newport Beach, CA 8/07 – 12/07

Corinthian Colleges, Inc., Costa Mesa, CA 2/07 – 09/07, 2/08 – 05/08

Citizens Business Bank, Costa Mesa, CA 2/06 – 6/06

Fremont Investment & Loan, Anaheim, CA 5/05 – 12/05

SWL Corporation, LP, Tustin, CA 1/05 – 5/05

Ceridian Corporation, Fountain Valley, CA 6/04 - 9/04

CWS Capital Partners, LLC, Newport Beach, CA 1/04 – 05/04

Toyota Material Handling, USA, Irvine, CA 11/02 - 11/03

RSI Home Products Inc., Fullerton, CA 05/02 - 11/02

The Irvine Company, Newport Beach, CA 9/01 - 12/01

National Realty Trust, Inc., Mission Viejo, CA 08/00 - 07/01, 01/02 - 08/02

Direct Hire Full Time Position

AMRESCO Residential Mortgage, Irvine CA 8/1998 – 12/1999

Programmer Analyst / Developer reporting to the Director of Information Technology

Responsibilities

Develop project scope and requirement specifications through research, client interview, workflow and business analysis.

Program code development in Visual Basic 6.0, Access 97/VBA, Excel 97, Cognos Impromtu, IBM AS400, Oracle, PL/SQL, MS SQL Server 6.5, creating custom departmental software application modules for Customer Relation Management, Document Control, Quality Assurance, File Room Management, Code Library, Marketing Promotion, Corporate Reporting, Business Intelligence and Executive Information Systems. Perform system documentation and user training.

Westcorp, Western Financial Mortgage, Information Systems Department, Irvine, CA 3/1996 - 7/1998

Systems Analyst / Developer reporting to the Chief Information Officer and S.V.P. Mortgage Production

Responsibilities

Develop project scope and requirement specifications through research, client interview, workflow and business analysis.

Design, program and implement client/server applications in FoxPro, Visual Basic 5.x, Access, Excel /VBA and MS SQL.

Create Secondary Marketing rate/price national fax broadcast advertising and telephony systems (VB, ODBC, Excel OLE)

Program Visual Basic applications utilizing VB 5.x and Access/VBA delivering performance applications.

WestMark Mortgage Corporation, Management Information Systems, Costa Mesa, CA 6/1995 - 3/1996

Data Systems Analyst / Network Administrator reporting to Chief Information Officer and Manager of Operations

Responsibilities

Develop application systems for operations reporting in MAS 90 accounting, FoxPro, Access, Excel, and Data flex.

Program Mortgage Flex loan origination system data interfaces, screen enhancements and report development.

Provide Novell 3.x network administration and program voice mail, paging and telephony system.

Project manage computer system Florida relocation and establish correspondent LAN server.

Century 21 Corporation, International Headquarters, Marketing and Advertising, Irvine, CA 7/1989 - 6/1995

Market Research Programmer Analyst reporting to the VP of Marketing Research and Information Services

Responsibilities

Project manage marketing studies and opinion surveys on national advertising and corporate promotion.

Design database applications for customer quality service survey, National Advertising Fund and Gallup Poll studies.

Research and develop customer demographic profile, relational database and mapping application.

Contact this candidate