Jim Kearns by Design

Minimum recommended resolution 1280X720 px. This window is unknownXunknown px.

SQL Server, Reporting Services, Visual Studio, Access

Software Design, Definition and Specification • Core implementation • Installation, Configuration, Customization, Integration, Data Migration • Requirements Analysis • Development and Refinement of Simulations and/or Prototypes to confirm requirements • Defining/Supporting Acceptance Testing from Pre-release Users • Software Release and Post-release Activities (e.g. developing demonstrations and/or samples) and Analysis for Subsequent Product Build/Release Cycles • Product Maintenance

Core Competencies

dotExpert/Can Lead Others   dot_blueSignificant Job Experience   dot-OrangeKnowledge/Some Experience   dot-YellowCertified   dot_PurpleStudying for Cert.

MS Access VBA ADO Visual Studio 2012 MS Expression Studio 4 VB.NET ADO.NET ASP/ASP.NET HTML CSS jQuery JavaScript SSMS SSRS SSIS T-SQL MS Office Suite Adobe Photoshop AutoCad/Mechanical Desktop MS Exchange Server WAN/LAN Support • Windows Desktop Deployment and Support • Windows Server Deployment and Support • AD • DFSR • DNS • DHCP • TCP/IP

Professional Experience

ASP/VB.NET and Reporting Services DeveloperLewiston, ID3/2013-3/2015
Clearwater Paper Corp. (contract position)

IT/IS DirectorSunrise FL1994-12/2015
J&L Automotive Industries Inc.
Designed, developed and implemented a business management system using the best concepts from ERP methodology and solution stacks to integrate planning, manufacturing, sales, and marketing as well as inventory control, order tracking, CRM and finance.

Information Technology ProfessionalSpokane, WA1994-Present
Developing Applications, UI and Databases for small to large businesses
SQL Server • Visual Studio • MS Access • MS Reporting Services

  • MS Access, Word, Excel (VB/VBA/ADO), Visual Studio (VB.net/ADO.net/ASP.net) MS Expression (HTML/CSS/JavaScript/jQuery) as primary front end development tools and SQL Server as primary back-end development environment.
  • Extensive background in analyzing operational requirements and developing solutions for manufacturing, distribution, purchasing and international trade in the USA, Brazil and Mexico.
  • Logical Database Design, create Relationships, Indexes/Keys, Constraints and where necessary Triggers to maintain data integrity. Maintain SQL Server databases with active and failover servers in multiple offices using both transactional and merge replication.
  • Database Development, create stored procedures, views and UDFs to manipulate data and populate forms and reports. Create packages using DTS and SSIS to copy non-replicated objects between databases and to import and export flat file databases (i.e. Excel) or CSV files using ETL capabilities. Extensive use of SQL Reporting Services to facilitate data conversion into useful information and dispense reports to customers and employees using ad hoc reporting and scheduled subscriptions.

Work Samples

Recent Website Projects

Spokane by Design


Sample portfolio

Form, Report and Code Samples

SSIS Project

Recommendations and Testimonials

October 17, 2012

To Whom It May Concern,

Jim Kearns has been the IS/IT Department as well as Product Engineer/Manager for J&L Automotive Industries, Inc. for over 15 years. During that time he has developed and supported our SQL database which is the backbone program of this company. He is a very dedicated individual putting much of his personal time into making sure the program is running properly and training the staff to use this and most other programs used at J&L. He has developed all forms and reports in the database necessary for the company as the needs arise. He is the person we all go to when any computer issue arises.

Jim has also built the desktop and server computers we use on a daily basis and is our support for these computers as well. He also built and maintains our network in Florida, Washington and Brazil. Jim would be an asset to any company. He works well with all levels of employees and management and is very dedicated professional.

If you would like to speak with me personally I may be reached at the numbers below.


Barbara F
Contact Information on Request

October 17, 2012

November 06, 2013

To Whom It May Concern:

I am a Project Manager at Clearwater Paper Corporation in Lewiston, Idaho. Earlier this year we needed to supplement our report development staff with someone who has a current technical skill set, could learn new material quickly, work independently, and get a lot of work done fast in order to meet a very aggressive project deadline. Jim rapidly learned what he need to know about our system (an application he had never seen before) so that he could design and develop reports to meet our needs. He worked with technical staff as well as our business partners to ensure that their needs were met. His ability to work with end users, understand their processes and ‘speak their language’ was extremely valuable. He was a major contributor to the success of this project.

After the project was completed our technical staff member who was responsible for developing and maintaining reports moved to another position within the company. This was a very hectic time with many requests for new reports and adjustments to existing reports. Jim took over coordination of the entire report development and support effort and successfully met the needs of our business. We have since hired a new staff member and Jim is helping train that person.

I can recommend Jim without reservation and would be happy to discuss his contributions here.

Jack U
Project Manager
Contact Information on Request