Jonathan T. Kleinhans

** ***** *******, *********, ** 14420

abqhpw@r.postjobfree.com 716-***-**** Cell

Objective

Seasoned Developer with over ten years programming experience, seeking Data Architect/ETL Developer position in a

fast-paced and productive environment that best utilizes my diverse experience, communication and analytical skills.

Professional Profile

ETL/Database Programmer recognized by Microsoft, Oracle and Informatica Corp., specializing in SQL logical Architecture

and ETL development, database design, optimization, troubleshooting, and implementation. Experience with application

development and deployment, database administration, reporting, analysis and monitoring. Extensive background in

SSIS, TSQL, DTS, SSRS, Informatica PowerCenter 8.5 and Microsoft Operating Systems. Proficient in SSAS, Oracle

Databases, WCF 4.0 Web Services, LINQ, EF, OOP, ASP.Net, VS2010 C# and Visual Basic, TFS, VSS and Crystal Reports.

Experience and Accomplishments

Baxter, Medina, NY 2011 to Present

Baxter is a healthcare leader, assisting medical professionals and their patients with treatment of complex medical

conditions.

DATA ARCHITECT: Supervised an outsourced development effort, modeled internal data warehouse and

designed a multi-protocol EDI mechanism for communication with remote Gateway 2.0 servers.

SQL SERVER SUBJECT MATTER EXPERT: Assisted outsourcing company in leveraging new features of

o

SQL 2008 to help meet business requirements. Identified Microsoft licensing channel that granted

over $5M/year price savings on MS SQL Server 2008 licensing. Created and updated data mappings,

ERDs and other design documents for FDA compliance and best practice.

Paychex Inc., Rochester, NY 2009 to 2011

Paychex is a recognized leader in the payroll and human resource industry, serving over a half million businesses

nationwide.

DATA ARCHITECT: Accountable for performance, scalability, and logical design of SQL 2008 databases with over

14,000 simultaneous users.

ARCHITECTURE LIAISON: Represented Architecture business entity, bridging the gap between DBAs,

o

Developers and the Business Unit. Involved with all database projects from design to post-

implementation; script reviews, SSIS packages and database objects throughout the SDLC.

SQL 2008 UPGRADE: Coordinated and scheduled enhancement efforts resulting in a seamless

o

upgrade. Performed necessary changes and unit tests to all database objects and SSIS packages to

accommodate split database instances in a side-by-side implementation, and offloading of ETL and

report processing. Upgraded existing packages for SQL 2008 compatibility and new logical

infrastructure.

ETL DEVELOPER: Developed and enhanced many SSIS packages to support change requests and project goals.

Jonathan T. Kleinhans Page 2

CDC TRIGGER REPLACEMENT: Designed an efficiency project to offload CPU usage from an application

o

database to ETL server by creating an SSIS package to poll CDC change tables at dynamic intervals,

transforming data into staging tables picked up from enterprise services.

PAS IMPORT AND EAO CHECKIMAGE PROCESS: Replaced sequential execution of stored procedures

o

with SSIS dataflows to reduce linked server usage, allowing for efficient and rapid package executions.

SQL SERVER SUBJECT MATTER EXPERT: Reworked legacy code, applications and SSIS packages causing

performance issues in production environment due to overload from unprecedented product growth. Assisted

in retaining high-value clients by providing extremely fast turnaround in code changes and initiation of redesign

proposals to leverage available technologies when necessary.

Lakeshore Capital, Buffalo, NY 2009

Lakeshore Capital is an investment management company specializing in debt and asset trading.

DATABASE/INFRASTRUCTURE CONSULTANT: Reported to company executives and investors on infrastructure

technology enhancements.

SQL 2008 UPGRADE: Performed an in-place upgrade to existing SQL Server which served as a back-

o

end for the Latitude software suite.

ACTIVE DIRECTORY DEPLOYMENT: Promoted two domain controllers and configured an active

o

directory 2008 environment to meet centralization needs of the organization.

MedRecovery Management, Buffalo, NY 2008 to 2009

MedRecovery is a healthcare collection company focused on workers compensation claim payments and facilities

contracts.

SQL/ETL DEVELOPER: Responsible for ETL processes, data integrity, and VB.Net/SQL programming to support

and improve MRM business processes among over 28TB of data.

ICD9/PROC CODE ALGORYTHMS: Developed methods to reduce NYS file processing costs by

o

performing filtering and retention based on ICD9, procedure codes and other criteria observed from

submission of previous files. Presented proposal to investors, executives and managers for

standardization of data types and universal treatment of data, introducing efficiencies yielding cost

savings to justify the expense of extended storage capacity.

SQL 2008 UPGRADES: Assisted in planning and implementation of a side-by-side upgrade of OLTP data

o

warehouse and an in-place upgrade on an application server. Leveraged SSIS to upgrade and enhance

over 50 existing DTS packages.

AETNA/PACIFICARE GROUP EXCLUSIONS: Discovered an average of $1.6 million/month in

o

unnecessary claims and member removals while enhancing process with cacheable dynamic SQL logic;

implemented revised logic to correct issues, optimize queries and indexes for reduced runtime.

UHC VPO AUTOMATION: Created an SSIS Package to load 22 daily files based on existence and email

o

users statistics from the operation. Identified and corrected truncation issues with legacy DTS

Jonathan T. Kleinhans Page 3

package and updated data modeling documentation to resolve inconsistencies.

CLIENT REFRESH VALIDATION: Consolidated numerous scripts and revised validation logic to conform

o

to data mappings and MRM data integrity requirements. Created stored procedures and over twenty

user defined functions to dynamically validate data specific to MRM clients.

Independent Health, Buffalo, NY 2007 to 2008

Independent Health is a healthcare solutions company offering a full suite of healthcare insurance products.

ETL/DATABASE DEVELOPER: Reported to the Assistant Director of IT during all phases of SDLC; implemented

document version control of software and associated literature specific to applications.

PREMIUM RATES APPLICATION: Developed SSIS packages and custom scripts to convert a legacy VB6

o

application back-end from MS Access to SQL 2005. Utilized automatic maintenance and indexing to

enhance user functionality and provide consistent performance of Cognos and Crystal Reports.

OPTUM/NIA EXTRACTS: Performed analysis and design of critical Member and Provider extracts for

o

clients using an Oracle Data Warehouse, PL-SQL and Informatica PowerCenter 8.5. Scheduled job

execution and encrypted file transport using Unix Shell Scripting, Tidal and SNG.

Introl Design, Inc., Lockport, NY 2005 to 2007

Introl Design is an industrial solutions manufacturer offering an extensive selection of custom automation products.

APPLICATIONS DEVELOPER: Constructed several internal applications for automating pricing and quoting

operations, including a rotating inertia calculator with Visual Basic 2005 and SQL Server 2005.

PRICELIST AND QUOTING APPLICATION: Employed Microsoft SQL Server 2005 to retrieve product lists

o

and customer information to reduce resources dedicated to generating both written and verbal

quotes. Dynamically adjusted price breaks in accordance with client pricing groups and allowed

editing/addition of customer information to rapidly assemble on-screen, printed and database-

recorded quotes. Saved company employees an average of one hour preparation time per quote

while eliminating redundancy and serialization issues through employment of a SSRS Server.

ROTATING INERTIA CALCULATOR: Calculated shaft rotating inertia from blueprint specifications

o

saving processing time of one hour per shaft versus traditional means. Calculator was built to

accommodate both absolute and relative measurements, stemming from blueprint inconsistencies,

for over one hundred unique motors with varying shaft segments, diameters and densities.

DATABASE ADMINISTRATOR/DEVELOPER: Deployed MSSQL 2005 Server to support the back-end of a pricelist

application and maintain accountability for quotes issued. Utilized SSIS, DTS and Bulk Import features to

migrate customer lists, pricing groups, and products from the existing Open Source MRP system. Employed

MSSQL Server as the MRP Database replica for development, testing and disaster recovery purposes.

NETWORK ENGINEER: Designed entire network infrastructure from ground-up to provide a minimum of 99.9%

availability of servers and applications; included DNS, Active Directory and multi-subnet TCP/IP configuration.

Developed disaster recovery, business continuity and fail-safe policies to protect mission-critical data with over

six layers of redundancy. Provided CEO with reports, analysis and recommendations to suit both the present

and future needs of the company.

Jonathan T. Kleinhans Page 4

Prosodie Interactive, Buffalo, NY 2004 to 2005

Prosodie Interactive, now Prosodie Voice, offers intelligent business solutions enabling customer insight to the habits and

patterns of clients.

INTERACTIVE VOICE RECORDING DESIGNER: Trained QA staff and managers to use a complex in-house IVR

testing application. Mediated between developers and QA personnel to configure a suitable IVR solution for

clients, and utilized shared IT resources to execute ad hoc SQL queries validating IVR events.

DATABASE REPORT OPERATOR: Performed SQL queries against several database platforms to generate client

reports at predetermined intervals. Validated information within reports and distributed accordingly while

conforming to HIPAA healthcare standards.

Buffalo Lube Associates, Buffalo, NY 2003 to 2004

Buffalo Lube Associates is a Valvoline Instant Oil Change franchise.

BUSINESS INTELLIGENCE REPORT DESIGNER: Designed business intelligence reports derived from reverse

detail-line processing that provided senior management with query and conditional-based reporting to better

address business needs.

Starfire Technologies, Los Angeles, CA 2002 to 2003

Starfire Technologies provides business consulting and residential support throughout the Southern California region.

CONSULTANT: Provided group of approximately 30 ESL users structured lessons enhancing their work

productivity. Performed 24x7 on-site commercial and residential technical support, customer service, training

and remote administration.

US Marines, Camp Pendleton, CA 1998 to 2002

The US Marines are the world s premier fighting force.

RECONNAISSANCE MARINE/TECHNOLOGY SPECIALIST: Successfully completed mentally and physically

challenging 12 week indoctrination. Maintained HF/UHF/VHF/Satellite communications with command and

intelligence personnel to share photographs and reports of objectives. Constructed application to calculate

BMNT, EENT and Tidal data based on information from Division Intelligence using DAO, VB6 and MS Access,

allowing team leaders to easily allocate and account for assets within their team during the mission planning

phase.

Education and Background

Bachelor of Science Information Technology Databases

Western Governors University, anticipated Fall 2012

Oracle Certified Expert - SQL, February 2012

Microsoft Certified Information Technology Professional: SQL 2008 BI DBD DBA, Spring 2011

High Performance SQL Server Databases Learning Tree International, May 2010

Associate of Applied Sciences Computer Information Systems

Erie Community College, May 2009

MSSQL Server 2005 Development and Administration HOTT Training, August 2008

Informatica Certified Designer, January 2008

US Patent Application #200******** RFID Transaction Automation, November 2006

Microsoft Certified Systems Administrator Messaging on Windows Server 2003, March 2006

Contact this candidate