Gary A. Solberg, PMP

W*** N***** Jamestree Road

Germantown, WI 53022

Cell 414-***-****

ablab5@r.postjobfree.com

Professional Summary

Results oriented, organized, analytical and proactive Information

Technology professional with experience in a variety of industries and

roles including Project Manager, Application Developer, Systems Analyst,

Business Analyst, Data Analyst, Interface Analyst, Operations Analyst,

Disaster Recovery Coordinator, and Mainframe Scheduler. Certified through

the Project Management Institute as a Project Management Professional

(PMP). Experienced with the management of all stages of the system

development life cycle. Proficient with the development of SQL Server

database objects and SQL Reporting Services reports as well as T-SQL to

query data from SQL Server databases for analysis and problem resolution.

Professional Certifications: Project Management Professional (PMP), SQL

Server 2008, Business Intelligence Development and Maintenance (SSIS, SSAS,

SSRS) Implementing a Database Design on Microsoft SQL Server 6.5

Professional Experience

Consultant - Children's Hospital of Wisconsin

March 2010 to August 2010

Jell-Tech Consulting, LLC

o Developed T-SQL statements, stored procedures and user defined

functions in SQL Server 2008.

o Incorporated the SQL objects into the management reports I developed

in SQL Server Reporting Services 2008 for inclusion in the VPS

application utilized by the National Outcomes Center and the user

community.

o Enhanced existing reports for performance improvements and corrected

logic based on the results of audits I performed on the reports that

were previously implemented in the application.

Legion Insurance Company (In Liquidation), Milwaukee WI.

2001 to 2009

Property and casualty insurance company with over $1.6 billion in written

premium. Organization went into liquidation in July of 2003 per a court

order issued by the state of Pennsylvania Insurance Commissioner.

Project Manager

Managed a variety of projects that ranged in size from large scale

application development, 3rd party software implementations, existing

application enhancements and support to legacy applications.

o Managed multiple projects simultaneously including the prioritization

and resource allocation to meet objectives. These projects involved

cross functional teams within the organization between locations in

Wisconsin, Pennsylvania and South Carolina.

o Created biweekly project status reports to stakeholders, developed

project plans, presented application integration overviews to senior

executives and followed project methodology as defined by the Project

Management Office.

o Held responsibility for the budgeting, expense management and project

prioritization with external vendors.

o Participated in strategic long term planning and decision making for

the entire IT organization.

o Worked with the internal and external designees of the Pennsylvania

Department of Insurance to develop applications to assist with the

liquidation of this organization.

o Resolved all outstanding IT issues associated with the liquidation as

well as retired applications and processes no longer needed for the

ongoing operations.

o Successfully managed the largest system implementation and data

migration project ever undertaken by the organization. This project

consolidated all policy and claim financial transactions into one

application. The project was one of the top five corporate goals for

two years running and received high success ratings both years from

senior executives.

o Managed the full life cycle development of applications developed in

.NET with SQL Server databases.

Gary A. Solberg

Page Two

o Lead the design, development and implementation of a Data Warehouse

application. This application then interfaced to all downstream

financial and reporting applications in the organization as well as to

external parties.

o Created reports utilizing SQL Server Reporting Services as well as

developed the SQL Server stored procedures that the reports used as

the data source.

o Proactively identified risks and issues within applications as well as

developing strategic directions to alleviate these situations from

occurring in the future.

Sr. Business Analyst

Responsible for working with business experts and IT team members to

elicit, analyze, specify and validate business needs and problems.

Facilitate the establishment of specifications and other documents for

use in the development of applications and processes to fulfill business

needs.

o Developed new electronic system interface specifications to

incorporate better processes to meet the reporting requirements of the

organization and insurance bureaus.

o Gathered business requirements obtained from multiple sources

including interviews with key stakeholders as well as the analysis of

regulatory reporting requirements.

o Developed testing criteria for new application development. Executed

test plans, reporting the test results and updating associated

documentation.

o Authored system user documentation. Served as trainer to the user

community on application usage with the training materials developed.

o Mentored a team of Business Analysts that were responsible for the

interaction with agents performing business transactions on behalf of

the organization.

o Initiated automated processes to improve data integrity and timeliness

of posting policy transactions for the monthly, quarterly and annual

financials of the organization.

o Developed positive working relationships with external Managing

General Agents. Received positive feedback from senior level

executives for the working relationships developed among all the

business units.

Computer Consultants of America, Inc., Southfield, MI.

1995 to 2001

(Formerly Starting Point Technologies, Inc., Brookfield, WI.)

A service provider specializing in program development and computer

education

Programmer Consultant

Perform application development and support assignments as required by

the clients of the organization.

o Consulted with clients in a variety of business environments including

health insurance, manufacturing, internet service provider, automotive

industry software vendor and retail grocery chain.

o Developed an application for a client to have the ability to analyze

the performance of their internally manufactured products based on

reported product failures.

o Developed and implemented applications in the mainframe environment

utilizing COBOL and DYL280 as well as client server applications

utilizing Visual Basic, SQL Server, Microsoft Access and Visual Fox

Pro.

o Managed a project to convert a claims entry system from an outside

service bureau to an existing policy management system in order to

eliminate excessive annual usage fees.

Software: SQL Server, SQL Reporting Services, Access, Project, Excel,

Visual Fox Pro, Mainframe COBOL

Education

Bachelor of Science, Business Administration, Carroll College, Waukesha, WI

Associate Degree, Retailing, Waukesha County Technical College, Pewaukee,

WI

Contact this candidate