Kevin D. Alkema
Streetsboro, OH *4241
***********@*******.***
OBJECTIVE
Looking for a long-term position that utilizes my development and leadership expertise in creating smooth flowing and easily navigated Web based applications and furthering these skills in the .NET technologies is a primary interest.
________________________________________________________________________
SUMMARY
In-depth knowledge of various military and civilian project developments including:
• Weather
• Industrial
• Marketing
• Banking
• Medical
20+ years experience in all project stages including:
• Analysis
• Design
• Development
• Testing
• Deployment
• Maintenance
• Refactoring
________________________________________________________________________
TECHNICAL QUALIFICATIONS
Worked with various systems, software, and environments including VB.Net, C#, Visual Studio 2003/2005/2008, AJAX, JavaScript, CSS, HTML, SQL SERVER, Reporting Services, SQL, DB2, CICS, COBOL, JCL, REXX/CLIST, FILEAID, EXPEDITOR.
________________________________________________________________________
EXPERIENCE
Job title: Contract Senior Systems Analyst
Organization: Parker Hannifin
Tenure: February 2006 – Present
Description: Created multiple WEB based application to automate manual process, replace legacy systems and design new systems. This reduced man hours, freed resources and provided enhanced enterprise information to management. Technologies used included AJAX, VB.Net and C#, JavaScript, WEB Services and File watchers to help create web sites that were smooth flowing and easily navigated. For additional functionality Dundas Charts, Softartisan’s OfficeWriter and other third party products were also incorporated. Worked with SharePoint, WEB Focus and various other reporting tools.
Job title: Contract Senior Systems Analyst
Organization: National City Bank
Tenure: March 2005 – December 2005
Description: Responsible for the conversion of 200 million Trust System transaction history records. Designed and developed a retrieval process allowing access to the data from WEB based applications. The retrieval process included COBOL, JCL and FTP to extract specific information and transfer data to servers. Created WEB based reporting utilizing C#, HTML,CSS and MS Reporting Services and SQL Server.
Job title: Self Employed
Organization: Rental Properties
Tenure: April 2004 – March 2005
Description: Evaluated potential rental properties to determined value based on purchase price and cost to rehab. Negotiated the financing to purchase multiple properties. Completed the tasks necessary to rehab the properties and provide adequate living space. Screened potential renters and perform ongoing maintenance.
Job title: Contract Senior Systems Analyst
Organization: Rockwell Industries
Tenure: July 2003 – April 2004
Description: Responsible for the day-to-day operation of a billing, booking and backlog system. Designing, modifying and implementing enhancements to increase functionality to customers that currently doesn’t exist. Rewriting portions of a credit memo system to streamline and improve performance using COBOL, DB2, SQL, and IMS.
Job title: Contract Senior Systems Analyst
Organization: University Hospitals Health Systems
Tenure: January 2002 – April 2003
Description: Responsible for the extraction of data in several legacy systems, including HR, Payroll and benefits using SQL embedded COBOL, MS Access, SQL. Providing validation reports to improve productivity and provide functionality during the migration process. Converted history data from legacy systems on both mainframe and non-mainframe applications with the use DB2, MS Access, SQL, Excel, VB and an ODBC link to Oracle SQL.
Job title: Contract Senior Systems Analyst
Organization: JoAnn Fabrics, Inc.
Tenure: June 1996 – September 2001
Description: Responsible for day-to-day operations of several legacy retail systems. Providing enhancements for customers to improve productivity or provide functionality that doesn’t exist currently. Documented and flow-charted several areas of critical systems enabling performance tuning and the cleanup of obsolete code. Converted history data from legacy systems on non-mainframe applications to DB2 structures. Written applications that use SQL, MS Access, Excel, VB and DB2. Self taught Clipper and other programming environments to help support and convert applications.
Job title: Senior Systems Analyst
Organization: Key Services, Inc.
Tenure: March 1994 – June 1996
Description: Responsible for developing customer transaction posting inquiry system for a banking institute requiring high-volume CICS to DB2 activity. Enhanced existing software to allow nationwide banking using multiple CPUs and several DB2 database structures. Assisted in system wide upgrades and enhancements that required seamless transition from the existing system to the new system from the customer’s perspective. Developed critical systems using embedded SQL for tellers, ATM and bank managers.
Job title: DB2 DBA
Organization: Phar-Mor, Inc.
Tenure: March 1992 – March 1994
Description: Responsible for managing the profit analysis of 300 stores resulting in a 20 percent profit margin increase on prescription drugs. Directed the development and implementation of the inventory control system for video departments. Improved inventory movement, increased profits and usable store space. Developed several businesses reporting systems for senior management resulting in improved management and cost analysis of the Corporation.
Job title: DB2 DBA/Senior Programmer
Organization: United States Air Force
Tenure: October 1986 – March 1992
Description: Responsible for creating DB2 databases containing detailed weather information collected from all over the world by military and non-military sources. Improved analysis by increased availability and speed of several tera-bytes of information in secured and non-secured environments during the Gulf War and other critical times. Assisted with the analysis of computer based training for SQL and other relational database concepts.