Jonathan T. Kleinhans
Resume 06 Feb 2011
381 Lenora Lane
Webster NY 14580
716.622.1159 Voice
jonathan.kleinhans@gmail.com
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 Informatica Corp., Microsoft and CompTIA, specializing in SQL logical Architecture and ETL development, design, optimization, troubleshooting, and implementation. Experience with application development and deployment, database administration, desktop support and related reporting, analysis and monitoring. Extensive background in SSIS, TSQL, DTS, SSRS, Informatica PowerCenter 8.5, Crystal Reports and all Microsoft Operating Systems. Proficient in SSAS, VB 2010, ADO.Net, VB6, XML, C#.
Experience and Accomplishments
Paychex Inc., Rochester, NY
August 2009 - Present
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, 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 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.
- CDC TRIGGER REPLACEMENT: Designed an efficiency project to offload CPU usage from an application 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 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
July 2009 - August 2009
DATABASE/INFRASTRUCTURE CONSULTANT: Reported to company executives and key business investors infrastructure enhancements possible with new Microsoft technologies.
- SQL 2008 UPGRADE: Performed an in-place upgrade to existing SQL Server which served as a back-end for the Latitude software suite.
- ACTIVE DIRECTORY DEPLOYMENT: Promoted two domain controllers and configured an active directory 2008 environment to meet centralization needs of the organization.
MedRecovery Management, Buffalo, NY
April 2008 - July 2009
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 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 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 unnecessary claims and member removals while enhancing process with cacheable dynamic SQL logic; implemented revised logic to both correct issue and optimize queries and indexes for reduced runtime.
- UHC VPO AUTOMATION: Created an SSIS Package to load 22 daily files based on existence and email users statistics from the operation. Identified and corrected truncation issues with legacy DTS package and updated data modeling documentation to resolve inconsistencies.
- CLIENT REFRESH VALIDATION: Consolidated numerous scripts and revised validation logic to conform 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
October 2007 - April 2008
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 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 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
May 2005 - October 2007
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 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.
- RESOLVER ALIGNMENT UTILITY: Allowed production personnel ease in aligning motor resolvers during the assembly process by extracting positioning information from a microcontroller rather than using a voltmeter.
- SERVOLOC CONFIGURATION APPLICATION: Developed in Visual Studio 2005 and Orcas 2008 environments to replace an older application and add aesthetic appeal for clients. Communicated with a microcontroller via an-house protocol created in the 1970’s. Permitted Serial, Serial-TCP/IP Redirected and TCP/IP interaction methods with the product.
- ROTATING INERTIA CALCULATOR: Calculated shaft rotating inertia from blueprint specifications 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 including DNS, Active Directory and multi-subnet TCP/IP configuration. Developed Disaster Recovery, Business Continuity and fail-safe policies to protect mission-critical data by over six layers of redundancy. Provide CEO with business analysis, reports and recommendations to best suit both the present and future needs of the company.
Prosodie Interactive, Buffalo, NY
August 2004 - May 2005
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 adhoc 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.
QUALITY ASSURANCE SPECIALIST: Designed testing matrix derived from every possible route within an IVR to ensure proper application testing that reduced deployed application errors significantly. Modified internally developed MS-Excel Macro to accommodate the matrix, provide ease in operation for the user and statistical figures for measuring development productivity.
Buffalo Lube Associates, Buffalo, NY
July 2003 - August 2004
STORE MANAGER Responsible for day to day operations, including customer relations, inventory management, performance statistic reporting, and labor supervision.
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
Nov 2002 - Jul 2003
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.
United States Marine Corps, Camp Pendleton, CA
Dec 1998 - Dec 2002
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
Microsoft Certified Information Technology Professional:
SQL Server 2008 Business Intelligence Developer, January 2011
SQL Server 2008 Database Developer, December 2010
SQL Server 2008 Database Administrator, December 2010
High Performance SQL Server Databases – Learning Tree International, May 2010
Associate of Applied Sciences – Computer Information Systems
Erie Community College, May 2009
HOTT Training – MSSQL Server 2005 Development and Administration, August 2008
Informatica Certified Designer, January 2008
300+ Hour Applications Development Internship – Introl Design, Inc., Spring 2007
US Patent Application #20080109320 – RFID Transaction Automation, November 2006
Microsoft Certified Systems Administrator - Messaging on Windows Server 2003, March 2006
CompTIA Network+ Certified, October 2005
Microsoft Certified Desktop Support Technician – Windows XP, May 2005
Honors
Honorable Discharge - U.S. Marine Corps, December 2002
Good Conduct Medal - U.S. Marine Corps, December 2001
Certificate of Commendation – US Marine Corps, June 2001