Jim Horn - Microsoft SQL Server Database developer and architect

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 TFS, Access with VBA, Oracle, Informix, DB2

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

Training & Familiarization AWS, PostgreSQL, 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

Rates

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, PASS Summit 2015, SQL Saturday events in Minnesota (I even presented classes at SQL Saturday #238 and SQL Saturday #453 and was on the Board of Directors that ran SQL Saturday #557), and attended various PASS-Minnesota SQL Server User Group events.

Certification

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

70-762 Developing SQL Databases (2020, MCSA status)
70-761 Querying Data with Transact-SQL (2018)
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.