Sql Server Azure Data

Frederick H. Shepphird Newport Beach, CA ***** Cell 949-***-****

********@***.***

Summary

Qualified as an excellent candidate as Senior Software / Database Developer

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, Azure Data Lake, Azure data Bricks. Supporting production support software deployments.

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 – 2023, 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, AWS Redshift, 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, Amazon AWS, AWS Redshift.

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, AWS Redshift.

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, AWS Redshift, 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.

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

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

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

Professional Experience

Independent Consultant, Newport Beach, CA 02/2024 – Current

Database and Automations, Consultant

Responsibilities

Part time Consulting engagement for investment R.E.I.T. portfolio management firm.

Develop enterprise Data Mart and Web Reporting Services in Azure SQL Server Instance.

Managed the installation and configuration of Azure SQL Server Instance and Data Factory.

Design ETL processes from various disparate database systems and purchased investment data products.

Automate monthly ETL processes and oversee the success of each run with developed Power BI reports.

Technologies leveraged, Azure SQL Instance, Azure Data Factory (DF), Power BI, SF Pipelines, C#, .NET.

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.

ETL SalesForce application data residing AWS Redshift to on prem SQL Server and Azure SQL Server Data Warehouse.

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

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

Implement the improvement, test and deploy the change to production

Offered sporadic production support, troubleshooting, and resolving ETL-related issues based on priority and impact.

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.

Technologies leveraged SQL Server Management Studio, Oracle Data Studio, Azure SQL Instance, Azure Data Factory (DF), SF Pipelines, AWS Redshift and AWS cloud based Analytics, C#, .NET, SSIS,SSAS, SSRS, AcrInfo GIS, Power Shell, Power BI, Power Pivot.

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

On-Call/Production Support provided during daytime and off-hours.

Advised on enhancements to migrating objects optimizing performance and efficiency.

Provided support to develop the entire warehouse architecture and plan the ETL process documentation along with different test cases to smooth transfer of project and to maintain SDLC.

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

Technologies leveraged, SQL Server Management Studio, S.A.S., C#, .NET, AcrInfo GIS, Python.

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 Redshift and AWS cloud based Analytics

Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads, and Monthly loads and Developed reports based on issues related to the data warehouse.

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

Technologies leveraged, SQL Server Management Studio, Alteryx, Tableau, C#, .NET, Power Pivot .

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.

Provided production support and resolved live incidents

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.

Technologies leveraged, SQL Server Management Studio, SQL Toolbely, C#, .NET.

Conquest 24/7, Tampa, FL,100% remote 03/2017 – 04/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.

Technologies leveraged SSIS,SSRS Azure Data Factory (DF), .NET.

Agility Fuel Solutions, Irvine, CA 04/2016 – 02/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.

Technologies leveraged SQL Server Management Studio, Azure SQL Instance, Azure Data Factory (DF), SF Pipelines, C#, .NET, SSIS,SSRS, Power Shell, Power BI, Power Pivot.

Emerald Expositions, San Juan Capistrano CA 09/2015 – 03/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.

Technologies leveraged SQL Server Management Studio, Azure Data Factory (DF), AWS Redshift and AWS cloud based Analytics, C#, SSRS, AcrInfo GIS, Power Shell, Power BI, Power Pivot.

Independent Consultant, Newport Beach, CA 02/2015 – 09/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.

Technologies leveraged SQL Server Management Studio, C#, SSRS, Power Shell, Power BI, Power Pivot.

JWC Environmental, Costa Mesa, CA 06/2014 – 02/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 explaining new modules and features. Participated in the IFS upgrade project.

Technologies leveraged SQL Server Management Studio, C#, SSIS, SSRS, Power Shell, Power BI, Power Pivot.

LAN International, Aliso Viejo, CA 04/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.

Technologies leveraged SQL Server Management Studio, C#, SSIS, SSRS, Power Shell, Power BI, Power Pivot

CIG Financial LLC, Irvine, CA 10/2012 – 04/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.

Technologies leveraged SQL Server Management Studio, SSIS, SSRS, Power Shell, Power BI, Power Pivot

WNC Inc., Irvine, CA 01/2012 – 09/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.

Technologies leveraged SQL Server Management Studio, SSIS, SSRS, Power Shell.

Skilled Healthcare, Inc., Foothill Ranch, CA 07/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

Technologies leveraged SQL Server Management Studio, SSIS, SSAS, SSRS, Power Shell, Power Pivot.

Previous Database and Software Applications Consultant 08/2000 – 07/2010

UnitedHealth Group, Costa Mesa, CA.; Hanley Wood Market Intelligence, LLC, Costa Mesa, CA;

Dulcinea Farms, LLC, Ladera Ranch, CA; Citigroup, Newport Beach,CA;

Corinthian Colleges, Inc., Costa Mesa, CA; Citizens Business Bank, Costa Mesa, CA;

Fremont Investment & Loan, Anaheim, CA; SWL Corporation, LP, Tustin, CA;

Ceridian Corporation, Fountain Valley, CA; Capital Partners, LLC, Newport Beach, CA;

Toyota Material Handling, USA, Irvine, CA; RSI Home Products Inc., Fullerton, CA;

The Irvine Company, Newport Beach, CA; National Realty Trust, Inc., Mission Viejo, CA

Direct Hire Full Time Position

AMRESCO Residential Mortgage, Irvine CA 08/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 03/1996 - 07/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 06/1995 - 03/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.

Contact this candidate