Jim Horn

Freelance Microsoft SQL Server database developer, architect, and trainer specializing in Business Intelligence, ETL, and Data Warehouse solutions.  Currently available for full-time contract assignments, part-time consulting and mentoring in the Minneapolis, Minnesota USA area or remote.  

Click here for a current resume

 
 

SQL Server Skillsets Database Development, SSIS, SSRS, Dashboards, Data Warehousing

Data Sources SQL Server, Oracle, Informix, DB2, XML, Salesforce.com with SOQL, Facebook API, Twitter API, Hubspot API.

Other Databases Access with VBA, Oracle, Informix, DB2

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

Training & Familiarization SSAS, Big Data, Hadoop, Data Mining, DAX, MDX, XML, JSON, VB.NET Scripting, C# Scripting, Power Shell, Data Modeling, Master Data Services, Data Quality Services, Change Data Capture, Full Text Search, Service Broker, Talend, IBM DataStage.  . 

Skillsets SQL Server SSIS, SSRS, Database Development, Dashboards, Data Warehousing.Other Databases Access with VBA, Oracle, Informix, DB2. Business Intelligence   Power Pivot, Power Query, Power View, Power Map, Excel VBA.EmergingSSAS 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, Facebook API, Twitter API, HubSpot. 
SQL Server Skillsets SQL Server SSIS, SSRS, Database Development, Dashboards, Data Warehousing.
Other Databases Access with VBA, Oracle, Informix, DB2. 
Business Intelligence   Power Pivot, Power Query, Power View, Power Map, Excel VBA.
Other Emerging Skills 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, Facebook API, Twitter API, HubSpot

 

Community Activity

I spend some available time on Experts Exchange where I answer technical questions, write articles, help run the site.  This enables me to help others with similar needs and reinforce my own skillsets, with points awarded for answers, which earn certificates.  The ones I’m most proud of is my Ace certificate in the Microsoft Access zone earned in 2008, and Genius certificate in SQL Server zone earned in 2013.  In 2013 I was awarded a Most Valuable Expert (MVE) Award with many other excellent experts.

I also attend PASS events such as PASS Summit 2012, SQL Saturday events in Minnesota (I even presented a class at SQL Saturday #238), and attend various PASS-Minnesota SQL Server User Group events.

Certification

In terms of official certification I passed the following Microsoft certification exams:

  • 70-461 Querying Microsoft SQL Server 2012 (2013, MSP status)
  • 70-069 Microsoft Access for Windows '95 (2000, MCP status)
  • 70-051 Microsoft Access Application Development (1998)

My personal computer history

I started playing with computers while growing up on Mackinac Island, Michigan at 13 years old on Atari 400 and Commodore 64 computers, learning BASIC programming from both for both classroom assignments and as a personal hobby. 

I started college at Michigan State University as a Computer Science major, but eventually graduated with a degree in Accounting and moved to Minnesota.  After five years’ experience as an Accountant and an MBA from the University of Minnesota I realized that I had it right when I was 13, and began a five-year, two-job transition back to Computer Science as a Microsoft Access database developer, which eventually led to SQL Server and Visual Basic. 


 
 

 

 
 

Email jim@jimhorn.biz, Cell 612.910.5236, Twitter @sqljimbo