Jim Horn
SQL Server Data Dude
  • Harbor Springs,
  • Michigan,
  • United States of America
Member Since: 2004/06/22
Industry: Computer & IT
Top Skills:
Tech Certifications:
View All
CERTIFIED EXPERT

Microsoft SQL Server database developer, architect, and author specializing in Business Intelligence, ETL, and Data Warehousing.

More bio
Full Biography

SQL Server database developer and architect | MCSA Certified

*** Please read before sending me messages ***
I am only entertaining >95% remote contracts and employment, so please do not send me emails regarding any positions that require local residence.

*** Q&A Full disclosure ***
I reserve the right to not respond to questions that are much more than the scope of a single EE question, homework assignments, poorly worded, or asked by Anonymous Members.  Thanks in advance.

*** My Profile ***
Microsoft SQL Server Database - BI - ETL Developer, Architect, and Author working remotely while snowbirding between Harbor Springs, Michigan, and Clearwater, Florida USA.  Website and resume at http://www.jimhorn.biz. Email jim at jimhorn dot biz.  Feel free to connect to me on LinkedIn at https://www.linkedin.com/in/jimhorn/ with a message that you met me through Experts Exchange.

*** Skillsets
Databases: Microsoft SQL Server, SSIS, SSRS, Oracle, Database Development, Dashboards, Data Warehousing, Access.

Business Intelligence:  Power Pivot, Power Query, Power View, Power Map, Excel VBA.

Emerging: SSAS Tabular, SSAS Multidimensional, Big Data, Hadoop, Data Mining, DAX, MDX, XML, VB.NET Scripting, C# Scripting, Power Shell, Data Modeling, Master Data Services, Data Quality Services, Change Data Capture, Full Text Search, Service Broker, Talend, Salesforce.com, SOQL, Informix, DB2, Erwin.

*** Microsoft Exams Passed
70-762 Developing SQL Databases (2020, MCSA status)
70-761 Querying Data with Transact-SQL (2018)
70-461 Querying Microsoft SQL Server 2012 (2013)
70-069 Microsoft Access for Windows 95 (2000, MCP status)
70-051 Microsoft Access Application Development (1998)

*** Awards
Experts Exchange Most Valuable Expert (MVE) (2013)
Experts Exchange Author of the Year (2015)
Nominated for Microsoft MVP awards in SQL Server and Access.

*** Volunteer work
Page Editor and Topic Adviser on the website Experts Exchange.
Board of directors, PASSMN.org,and was the lead in running SQL Saturday #557

*** Education
Various SQL Server training such as PASS Summit, PASS Business Analytics conference, and Pragmatic Works seminars.
MBA in Service Operations Management, University of Minnesota, 1997.
BA in Accounting and Army ROTC, Michigan State University, 1991.
Various U.S. Army and Boy Scouts of America adult leader training.

More
Professional Background
Volunteer SQL Server Expert
Experts Exchange
2004 – Present
2004 to Present.  Answered questions and solved problems for website membership holders as a volunteer.

2015 to 2017.   Page Editor, which involves reviewing technical articles from other experts for publication, and determining various award statuses.

2013 to 2017.   Topic advisor in the SQL Server zones.

2005 to 2007   Co-Page Editor of Visual Basic, VB Databases, VB Controls, and Microsoft Access TA, which involves leadership duties of the TA.
Data Architect
Ernst & Young (EY)
January 2020 – October 2020
SQL Server Data Modeler and Architect at EY supporting multiple App Dev teams with various SQL Server related needs such as requirements analysis, design analysis, development, and data modeling. Visual Studio, Git, Erwin, Azure DevOps (ADO), Redgate SQL Change Automation (SCA), Scaled Agile Framework (SAFe).
Data Architect
cxLoyalty
November 2016 – December 2019
Eden Prairie, MN, USA
SQL Server architect for a credit card loyalty rewards company with 30+ clients and 100+ databases. SQL Agent jobs / table partitioning that handle archiving and deleting data, PCI compliance, Applications Development support, project estimating, mentoring junior developers, offshore development creation and review.
Freelance Microsoft SQL Server Database Developer
Horn Enterprises
March 2003 – November 2016
Twin Cities area, Minnesota, USA
Freelance Microsoft SQL Server - SSIS - SSRS consultant and contractor in the Twin Cities of Minnesota area working various W2 and 1099 engagements from 2003-2006, 2011-2012, and 2013 to present.

Clients include Optum/Humedica, brightpeak financial,  Optum Health, Sun Country Airlines, Cenex Harvest States (CHS), OptumInsight, Verizon Wireless, Insignia Health / C2 IT Solutions, GMAC-RFC, Target, American Express (now Ameriprise), Chronimed (now BioScrip), Integris Metals (now Ryerson).

Built ETL packages using SSIS, reporting solutions using SSRS and Power BI, and decision support systems and financial services applications.

Presented at SQL Saturday #238 and #453, presented at PASS local user group meetings, taught Microsoft programming classes at Benchmark Learning and ExecuTrain of Minnesota, Microsoft Office classes at Academy College, and provided part-time mentoring to other developers.
More
Activity
Points this month796
Total points9,722,944
Questions: 508
Solutions: 7763
Articles: 20
Videos:
Tutorials:
Posts: 11
Group Discussions: 625
Education
University of Minnesota
MBA
Service Operations Management
1993 – 1997
Michigan State University
BA
Accounting, Army ROTC
1985 – 1989
Mackinac Island Public School
High School Diploma
1981 – 1985
More
Languages
Sarcasm
Full Professional Proficiency

Level Progress

Current: Level 69
Jim needs 77,056 points to level up.
LVL 70
  • Overall
    69
  • Microsoft Access
    42
  • Microsoft SQL Server
    42
  • Microsoft SQL Server 2008
    31
  • SQL
    26
  • Microsoft SQL Server 2005
    20
  • Databases
    16
  • SSIS
    15
  • Visual Basic Classic
    15
  • SSRS
    14
  • Microsoft Excel
    11
  • Microsoft Development
    10
  • Technical Writing
    7
  • Programming
    7
  • Visual Basic.NET
    7
  • MySQL Server
    7
  • .NET Programming
    7
  • Project Management
    6
  • Microsoft Office
    6
  • IT Administration
    6
  • Project Management Software
    6
  • Microsoft Applications
    6
  • C#
    5
  • Microsoft Server OS
    5
  • Experts Exchange
    5
  • ASP.NET
    5
  • Power BI
    5
  • Oracle Database
    5
  • DB Reporting Tools
    4
  • XML
    4
  • VBA
    4
  • SSAS
    4
  • ASP
    4
  • Consulting
    3
  • Miscellaneous
    3
  • VB Script
    3
  • Web Development
    3
  • Software
    2
  • Crystal Reports
    2
  • Web Languages and Standards
    2
  • Installation
    2
  • Microsoft Visual Studio
    2
  • Windows Server 2012
    2
  • Fonts Typography
    2
  • Windows XP
    2
  • PHP
    2
  • Microsoft Server Apps
    2
  • Java
    2
  • Microsoft Dynamics
    2
  • Programming Languages-Other
    2
  • Windows 7
    2
  • Microsoft SharePoint
    2
  • PostgreSQL
    2
  • Microsoft Legacy OS
    1
  • Programming Theory
    1
  • Powershell
    1
  • JavaScript
    1
  • Windows Server 2008
    1
  • Active Directory
    1
  • Remote Access
    1
  • Microsoft Word
    1
  • Microsoft
    1
  • Exchange
    1
  • Enterprise Software
    1
  • Windows OS
    1
  • Editors IDEs
    1
  • Web Applications
    1
  • Outlook
    1
  • COBOL
    1
  • DB Dev Tools
    1
  • Microsoft DOS
    1
  • PayPal
    1
  • Windows Server 2003
    1
  • Productivity Apps
    1
  • Analytics
    1
  • ColdFusion Language
    1
  • LINQ Query
    1
  • Azure
    1
  • Spreadsheets
    1
  • Golang
    1
  • Sales
    1
  • Internet Marketing
    1
  • E-Commerce
    1
  • Adobe Acrobat
    1
  • FoxPro
    1
  • Delphi
    1
  • Regular Expressions
    1
  • Apache Flex
    1
  • R
    1
  • Statistical Packages
    1
  • Troubleshooting
    1
  • Application Servers
    1
  • Email Servers
    1
  • File Sharing Software
    1
  • HTML
    1
  • Hardware
    1
  • IBM System i
    1
  • LibreOffice
    1
  • Office Productivity
    1
  • Paessler
    1
  • SBS
    1
  • Security
    1
  • Statistical Analysis System (SAS)
    1
  • Web Frameworks
    1
  • Web Servers
    1
  • WordPress
    1