Jim Horn
Microsoft SQL Server Developer, Architect, and Author
  • Eden Prairie,
  • Minnesota,
  • United States
Member Since: 2004/06/22
Industry: Computer & IT
Top Skills:
Tech Certifications:
View All
Prodigy
Job Seeker
Connect on Live
Hire

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

More bio
Full Biography

*** Please read before sending me messages ***
No solicitations for employment outside the Twin Cities area of Minnesota that cannot be performed at least 90% remotely.  

Microsoft SQL Server Database - BI - ETL Developer, Architect, and Author in the Twin Cities of Minnesota area.  Website and resume at http://www.jimhorn.biz. Email jim at jimhorn dot biz. Twitter @sqljimbo.

Currently employed full-time.

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

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, Java, JavaScript, IntelliJ, Maven, Tomcat, JIRA, Crucible.

*** Microsoft Exams Passed
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) (2014)
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, focusing on 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
Activity
Points this month27,255
Total points8,553,879
Questions: 480
Solutions: 7355
Articles: 20
Videos:
Courses:
Group Discussions: 614
Professional Background
Data Architect
Connexions Loyalty
November 2016 – Present
Eden Prairie, MN, USA
Volunteer SQL Server Topic Advisor, Page Editor, Group Leader, and Contributing 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.
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
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
No Languages shown

Level Progress

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

Profile Validation

LinkedIn Profile

Profile Validation

Email Verified
Expert Level Achieved
PayPal Connected