Sponsored by

John Andrew Hornsten

abo4xe@r.postjobfree.com

EXPERIENCE:

Thomson Reuters: Eagan, MN

Senior Data Center Power Forecasting Engineer : July 2010 - Present

. Use SQL to mine data out of Microsoft SQL Server 2008 databases

. Architect SQL Server database and related loads for SAP Business Objects reporting

repository

. Build WebI reports to replace existing Excel reports

. Scored RFP responses to choose a DCIM solution

. Manipulate weekly and monthly Excel reports for data center power forecasting

. Advance common power reporting and forecasting methodology and metrics

. Create documentation on existing processes and procedures

. Author business and technical requirements and create swim lane diagrams in Visio

. Authored data center recommendations for network and mainframe hardware derating

metrics

. Extract and export data from an international pool of servers

. Coordinated hardware/software configuration and readings automation for remote data

center UPS

. Author VB and PowerShell scripts to perform Excel functions and manage files

. Added automation resulting in 200+ resources hours saved per year

. Code and compile VB.NET application to automate data extraction from a vendor appliance

. Troubleshoot international production server issues

. Provide support on software, security and networking on Windows Server 2008 operating

system

. Manage HP Service Manager v7 asset and change information

. Plan and oversee common metrics propagation across asset repositories

. Administrator for team's SharePoint site

. Attended Microsoft SharePoint Saturday and SQL Server Saturday in 2011

. Attended Microsoft SQL Server Reporting Services training in 2011

.

Senior Systems Engineer role

. Mentored by

team managerStayWell Health Management: Eagan, MN

Product Development Manager : July 2007 - June 2010

Manage and lead multiple projects to enhance web applications and products. Cycle through

iterative testing cycles of waterfall development for quality assurance (QA). Manage staff

of QA consultants and full time business analyst employees.

. Product owner for client-facing web site and incentives offerings

. Interview and hire candidates

. Act as a liaison between business and IT

. Assist Sales staff in RFP responses and finalist presentations

. Author business requirements, functional specifications and create wire frames in Visio

. Design and implement website enhancements that follow HIPAA and Section 508 Compliance

. Train staff on products and enhancements

. Manage over 130 maintenance updates to our website in 2009 with internal IT and our

sister IT company in Utah

. Participate in Lean Production and value-stream mapping

. Coordinate after-hours website rollouts and QA testing with 100% deployment success

rate

. Author test case scenarios and regression test websites

. Core team member producing 45% of our pursuit for NCQA Accreditation in 2009

. Resolve production support issues

. Maintain third party vendor relationships, including Microsoft, Alere and Health

Enhancement Systems

. Enable single sign on (SSO) to a third-party vendor for multiple campaigns

. Led project to integrate health assessment data with Microsoft HealthVault

. Attended Microsoft SharePoint Camps in 2009

Securian Financial Group: St. Paul, MN

Senior Analyst : December 2002 - July 2007

Consult with strategic business units to architect new systems. Implement vendor

applications by customizing them to the existing environment, and lead various projects to

enhance existing architectures across entire company, along with related policies and

documentation.

. Support application developers across strategic business units

. Passion to mentor, train, and work direct new associates on team

. Project Manager on 3000 hour project with 50+ associates to select Web Conent

Management (WCM) solution; built RFP and scored results

. Project Manager on 5000 hour project with 50+ associates to implement Vignette's Portal

application for WCM

. Chairman of Microcomputer User Group (MUG) Board for three years

. Leader of Middleware Team (middle-teir database applications like MQ Series, IMS

Connect, and DB2 Connect) for two years

. Setup and Implement Architecture for Informatica PowerCenter, FileNet IS, Vignette

Portal, and Autonomy Ultraseek

. Attended ITIL Overview, and assist in the setup of Service Desk frameworks

. Member of Peregrine ServiceCenter advisory board, reviewing all corporate IT Service

Management activity

. Create packages, programs and advertisements for software installations via Microsoft

Systems Management Server

. Maintain Cognos Impromptu reports for management on staff workload

. Manage summer intern s quarterly plan and weekly workload

. Member of the IT contracts negotiations team

. Gained entrepreneurship skills via coursework at the University of St. Thomas

Securian Financial Group (formerly Minnesota Life)

Technical Analyst : December 2000 - November 2002

Develop advanced applications for use in the client/server realm and construct systems to

intertwine mainframe programs with client/server applications. Consult on broad range of

applications, and lead various projects to enhance existing architectures.

. Train new developers on migration applications

. Design layout, security and team processes for incident management in Peregrine Service

Center

. Manage summer intern s quarterly plan and weekly workload

Securian Financial Group (formerly Minnesota Life)

Programmer Analyst : August 1999 - November 2000

Consult on designing, coding, and testing mainframe and client/server applications.

Upgrade corporate applications. Provide after-hours support for systems. Research new

client/server and web- based applications for corporate use.

. Built 25+ installation programs for entire IS staff with InstallSheild

. Quality Assurance testing on mainframe and distributed applications using Rational

TeamTest

University of Saint Thomas: St. Paul, MN

Technician for Computing and Communications Services : January 1999-August 1999

Provide installation of various software packages on networked computers, configure

Microsoft Outlook software and network capabilities for faculty and staff of the

university,

and compile computer equipment inventory.

. Assist with problem solving on campus-wide computer problems

. Upgrade operating systems to Windows NT

. Configure systems, reimage devices, and direct file transfers

. Install internal and external hardware on Dell devices

Imation Corporation: Oakdale, MN

Engineering Intern : May 1997-August 1999

Assist Senior Research Chemist in improving inkjet systems by investigation and

development of polymer systems. Provide technical support in formulating, consulting,

organizing, producing, analyzing, and reporting on product line. Work on novel inkjet

receptors including:

. Advancing image stability with novel construction of polymers

. Improving absorptivity with novel techniques

. Spreadsheet/data analysis on various software applications

. Assist with three patent applications

. Setup new hardware, install and configure software and network systems

. Provide samples for sales and marketing review

. Analysis of magnetic media for data storage

OTHER EXPERIENCE:

University of Saint ThomasResearch Assistant in Physical Chemistry : May 1996-August 1996

Chemiluminescence of TiCl4 was studied by utilizing an afterglow apparatus with He and

Ne. Experiments in laser induced fluorescence of TiCl+ were conducted using a nitrogen

pumped dye laser. Research duties included:

. Computer-aided experiments with spectroscopy equipment

. Mathematical data analysis with Igor and Lab View software

. Present unpublished results to professors and students from local colleges

University of Saint ThomasSoccer Team Manager : August 1996-December 1996

Organize team activities, keep statistics and manage team s equipment.

APPLICATION EXPERIENCE:

Mainframe: PL/I, JCL, Clist, REXX, IMS, TELON, DB2, PanAPT, File-AID, DocuMerge

Distributed: Microsoft Word, Excel, Access, PowerPoint, Visio, SharePoint, BASIC, HTML,

XML,

Visual Basic, InstallShield, SMS, Ultraseek, Lotus Notes, Informatica PowerCenter, VB

2010 Express,

FileNet, TeamTest, SQL Server, HP Service Center & Asset Manager, AutoSys, MQSeries,

PVCS, IMS Connect,

WAS, WSAD, RAD, DB2 Connect, SMS Installer, Trillium Data Quality, Cybermation ESP,

Actuate e.Report Designer, Vignette Portal, HP Quality Center, HP Service Manager,

PowerShell

Data Center: Sentry Power Manager, Eaton Intelligent Power Manager, SetPoint, Socomec

Control Vision, Geist Environet, OSIsoft PI System

. Completed certification exam for FileNet in 2001

. Currently maintain personal web page

EDUCATION:

University of St. Thomas, St. Paul, Minnesota

1999 Bachelor of Science in Chemistry Summa Cum Laude

Minor: Renaissance Program (Business Administration)

ACTIVITIES & HONORS:

Collegiate (1995-1999):

Vice President of Aquinas Scholars Honors Program

Student Alumni Council

Vice President of Chemistry Club

Delta Epsilon Sigma Academic Honor Society

Omnicron Delta Kappa Honor Society

Analytical Chemist of the Year

Instructed two credit course on Hamlet

William Larson Chemistry Scholarship Recipient

3M Business Scholarship

Latin and Ballroom Dance Association

Computer Science Club

Non-Collegiate:

Eagle Scout in Boy Scouts of America in 1993

Valedictorian at Chisago Lakes High School in 1995

Vigil Honor in Order of the Arrow in 1996

Vermilion Carriage Townhome Association Board Member in 2002

Volunteer Resident Business Leader at BestPrep's Minnesota Business Venture in 2004

Steering Committee Member for Habitat for Humanity at the Securian Financial Group in

2005 and 2006

American Red Cross Certified in First Aid, AED and CPR in 2008, 2009 & 2010

IT Technology Team volunteer for local church in 2009 - Present

University of St. Thomas Reunion Planning Committee in 2009

University of St. Thomas Society of the Arches Award for volunteerism in 2010

Thomson Reuters soccer team in 2011

BestPrep eMentor volunteer in 2012

PERSONAL SKILLS:

Strong analytical skills while being extremely detail-oriented

Technical background in computer hardware and software

Excellent written and oral communication skills

Able to work in a team environment, as well as independently

Flexible personality with strong interpersonal skills

Contact this candidate