• Proven computer engineer, with over two decades’ experience in mainframe, UNIX, DOS, and Windows operating systems. Focused on Microsoft SQL Server since the release of version 7. • Exceptional developer, crafting dozens of high-performance web sites, BI Infrastructures, and Health Care applications using SQL Server and .NET technologies. • Outstanding oral and written communicator, having won several public speaking and national teaching awards at the collegiate level. • Seasoned leader and systems analyst, creating and implementing solutions managed by departments of 80 or more down to streamlined teams of two or three engineers. • Former Naval Officer (Naval Academy graduate) and Gulf War veteran. Held top-secret clearance while on active duty. Specialties: • Microsoft SQL Server 4.2 through 2014 (all editions!) including vast experience with SSRS and SSAS • Microsoft Dynamics AX and Dyanmics CRM, with some experience in Dynamics NAV and Dynamics SL • Health Care analytics and EDI for patient and payer data • Web app/site creation using C# .NET and classic ASP/VBScript • Creation of ETL applications using SSIS and SQL • Assessing and performance tuning existing SQL Server applications • Expertise spanning industries, including Health Care, Retail, Entertainment, Insurance, and Finance

Principal Consultant @ All consulting and software development work is done corp-corp by Database Potential and its employees, either locally in the Greater Los Angeles area or remotely around the world. From April 2004 to Present (11 years 7 months) Greater Los Angeles AreaHealthcare IT Consultant @ HL7 and X12 EDI transfer of patient medical records to and from various EMR systems such as EPIC and vistA. Installed, administered, and customized Microsoft Dynamics CRM and Microsoft Dynamics AX using X++, including integration with SSRS, SSAS (for KPIs), and AIF. Performed upgrade from AX 4.0 to AX 2012. From August 2009 to Present (6 years 3 months) Greater Los Angeles AreaSQL Server Consultant @ SQL Server DBA/Developer, maintaining a custom ETL application for the Marketing Department. Recently led a team which ported the older VBScript-based ETL, which takes large flat files and finally loads them into both a SQL Server and a Teradata data warehouse, to SSIS 2012. This rework resulted in higher accuracy and dramatically improved logging while shortening load times from 35 hours to under 2 hours, then to under 30 minutes. From September 2011 to Present (4 years 2 months) San Francisco Bay AreaSQL Server and .NET developer @ Developed and currently maintain a custom .NET application written in C# to regularly extract large volumes of XML from an existing SQL Server database. From October 2009 to Present (6 years 1 month) Greater San Diego AreaConsultant @ From 2015 to 2015 (less than a year) Consultant @ From 2015 to 2015 (less than a year) Consultant @ Creating a full Microsoft stack BI implementation, including SSAS cubes, SSRS reports, and ETL. This set of reports and pivot tables focused on project management and billing, providing much of the functionality of Microsoft Dynamics SL and AX at a fraction of the cost! From 2013 to 2014 (1 year) BI Contractor @ Creating a full Microsoft stack BI implementation, including SSAS cubes, SSRS reports, and ETL. From February 2012 to August 2013 (1 year 7 months) Santa Ana, CaliforniaBI Architect, Developer, and Consultant @ Created a customized BI solution for Walt Disney Studios Home Entertainment using SQL Server 2008, Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), and SharePoint 2007 (MOSS). From May 2009 to November 2012 (3 years 7 months) BI, SQL Server Consultant @ Lead SQL Server DBA, Architect and Developer, designing BI solutions for their Commercial Business Intelligence division. Work included ETL processes with SQL Server, DB2, Neteeza, and main frames, sophisticated SSAS cubes and SSRS reports. Rearchitected the SQL Server environments and upgraded to SQL 2008. Work included EPIC HL7 integration (payer side) using Mirth and QNXT integration. Facets customization using C#.NET. From November 2009 to December 2011 (2 years 2 months) Greater Los Angeles AreaDatabase Consultant and .NET Programmer @ Created a custom ETL application and reporting infrastructure for Financial data using SSIS, SSRS, and ASP.NET while providing performance tuning for existing SQL Server processes. Created BizTalk orchestrations for financial EDI and enhanced automated feeds of electronic data from Bloomberg. From November 2008 to March 2009 (5 months) Database Consultant and .NET Programmer @ DBA, Architect, and Developer. Created a custom SQL Server ETL and secure extraction tool using SSRS. Extensive performance tuning of web-based OLTP application written in Cold Fusion, and provided customized ASP.NET code for key sections of the client's application. From June 2005 to December 2008 (3 years 7 months) Database Consultant and .NET programmer @ DBA, Architect, and Developer. Created and maintained a Data Warehouse and BI application for the Market Research Department. Created secure file transfer applications using C#.NET, allowing for FTPS file transfer and PGP decryption of sensitive customer information. Extensive use of Microsoft Dynamics CRM for Sales and Reporting and Call Center. From April 2004 to September 2008 (4 years 6 months) Database Consultant and .NET Programmer @ Principal DBA, Architect, and Developer. Created a BI infrastructure using SQL Server, SSAS, and SSRS, along with extensive development work, performance tuning, and high availability architecture. Created custom web pages using classic ASP and ASP.NET, interfacing with the SSRS web service and SSAS. Administrated Websphere, Great Plains, and Dynamics AX. From April 2004 to July 2008 (4 years 4 months) AVP, Sr. DBA and Head of Windows Server Group @ Principal DBA, Architect, and Developer. Created a BI infrastructure using SQL Server, SSAS, and SSRS, along with extensive development work, performance tuning, and high availability architecture. Installed and administrated Microsoft Dynamics GP (Great Plains). From November 2000 to March 2004 (3 years 5 months) Senior Software Engineer and Web Developer @ created dozens of major database-driven public-facing websites using SQL Server, VBScript, and classic ASP. Managed teams of up to 20 developers in creating websites for cutting-edge dot com startups. Extensive work with Axapta (now Microsoft Dynamics AX) and Navision (now Microsoft Dynamics NAV) From August 1996 to November 2000 (4 years 4 months) Greater Los Angeles AreaAssistant Professor @ taught Naval Engineering and Navigation to NROTC students. Received several national awards for innovative teaching techniques. From October 1993 to August 1996 (2 years 11 months) Greater Los Angeles AreaLieutenant @ Officer aboard USS Harry W. Hill (DD-986), homeported in San Diego, from 1989 to 1993. Duties included Acting Chief Engineer, 1st Division Officer, DCA, Submarine Warfare Officer. Assistant Professor at USC (Los Angeles) teaching NROTC from 1993 to 1996. From June 1988 to August 1996 (8 years 3 months)

B.S., Chemistry @ United States Naval Academy From 1984 to 1988 Scott Wilson is skilled in: SSIS, SSRS, ETL, Microsoft SQL Server, Business Intelligence, Databases, SQL, .NET, Software Development, Analysis Services, XML, DB2, C#, Business Objects, SQL Server, SSAS, VBScript, HL7, X12, EDI ANSI X12, QNXT, Data Warehousing