Resume

Govt. Only.

Joseph Gakenheimer
7887 Leaview Drive Columbus, Ohio 43235;
614-622-5634
614-622-JoeG
via e-mail: joegakenheimer@columbus.rr.com
printable resume: Full Version

Skills

Languages & Technologies Professional:

Web Technologies: ASP.Net, VB.Net, C#, TSQL, ASP 3.0, VBScript, VB 6, COM, DHTML, JavaScript, HTML/XHTML (hand code), XML/XSL, JS/Perl RegExpressions, CSS2, OLEDB, ODBC

DBMS: SQL Server 2000, Access

Operating Systems: MS XP Professional/Home, NT , 95, 98, 2000, IIS 6.0, 5.1, 5.0, Solaris, Vax

Languages & Technologies Cousework:

Java Technologies: Java 2 JDK 1.4, J2EE: RMI, JDBC 2.1 3.0, JSP

Other High-level Languages: C++, C,Perl, C++ in the Unix Environment and TCP

Web Technologies: ASP 3.0, VBScript, DHTML, JavaScript, HTML/XHTML, XML/DTD/XSLT, CGI/Perl, JS/Perl RegExpressions, CSS2, ODBC

DBMS: Oracle 8i, Oracle 9i, MySQL

Operating Systems: Solaris, MS XP Professional/Home, NT , 95, 98, 2000

Software:

Visual Studio .Net, Visual Studio 6.0, Visual Source Safe, FrontPage 2003, 2002, 2000, 1998, Macromedia MX, Adobe Photoshop 7.0, MS Office, MS Project, MS Viseo, Vi, SmartDraw

Methodologies:

OOAD (Rambaugh & Booch), Version/Change Control, RAD

Interests:

Enterprise Architecture, Web Applications, Software Engineering, DBMS

Current Projects and Research:

Oracle Certification, DBMS, Patterns

Experience

State of Ohio Department of Public Safety: Programmer Analyst
1-07 to Present

• Probably: ASP.Net, Oracle, SqlServer

State of Ohio Department of Public Safety, Ohio Emergency Management Agency (OEMA): Database Analyst
2-05 to 1-07

• At my current position with the State of Ohio Emergency Management Agency, my responsibilities include development of ASP.Net and ASP 3.0 Web Applications, ASP.Net and VB 6.0 Windows Forms, and SQL Server 2000 database applications. My specialized responsibility is to administer, build, and to test a state wide emergency intranet software for state representatives to communicate and aid in any disasters or hazardous situations throughout the state.
  • Developed Online Emergency Contact System in C#, SQL Server 2000, XML, XSL (XSLT/XPath), XHTML, and CSS.
    • Created an online Contact Edit application
    • Developed encrypted login and change credentials utilizing Microsoft loaded SHA series algorithm through Role-based Forms Authentication.
    • Created Completely Editable DataGrid bound through SQL Server 2000 for dynamic editing.
      • Validated data with Dynamic Web Controls
    • Implemented dynamic Role-based navigation through XML Intelligent Caching formatted with XSL and CSS.
    • Wrote XHTML and CSS to meet levels 1 to 3 of Web Accessibility.
    • Wrote 80+ Stored Procedures.
    • Created small denormalized 3NF relational add on database.
    • Handled multiple transactions through ADO.Net with Exemption handeling and single transactions through TSQL.
    • Web.Config Error Pages.
  • Developed Upload System to upload scheduled data through DTS
    • Wrote Stored Procedure to dissect Excel Spreadsheets and create uniqueness through two unrelated tables for agency system.
    • Used DTS to run Stored Procedure and to update data.
  • Redesign and Enhanced ASP/SQLServer site (http://emaweb.ema.state.oh.us/training/)
    • Rewrote about half of the VBScript, added 50% more ASP pages.
    • Converted inline SQL into TSQL Stored Procedures.
    • Wrote 30+ additional Stored Procedures.
    • XTHML, CSS, Graphic Design (designed the header, based on the state's).
  • Redesigned Entire and Compacted OEMA Web Site (http://www.ema.ohio.gov/ema.asp)
    • Converted and compacted 450+ FrontPage HTML pages in to ASP 3.0 XHTML driven and CSS formatted pages: with dynamic cascading menus, wrote dynamically updating navigation for robots and handicapped users, and wrote new querries against ghost database. Excludes, the front portal page (the link).
  • Developed Entire Web Site (http://ocswa.ohio.gov/)
    • XHTML, CSS, Web Controls for Menus, Graphic Design (designed the logo), Web.Config Error Pages.
  • Migrated Legacy VB 3 Window Forms to VB 6
    • First step was to migrate VB 3.0 16 bit application to VB 6.0 32 bit window form
  • Miscelaneous or Short Projects
    • Wrote C# Completely Scrollable Datagrid.
      • Used the ViewState.
    • Wrote several C#, XML, XSLT, XPath applications for displaying Intelligently Cached data through DataGrids.
      • The project included several nearly static schemas migrated to XML.
      • Wrote the caching mechanisms in C#.
      • Used XSL to transform, structure, and delineate the XML documents.
    • Wrote C# Alphabetical Datagrid for fast record searching.
      • Wrote SP to gather the results.
      • Also wrote HTML Component/DHTML to highlight MouseOver row.
    • Wrote VB.Net Alphabetical Datagrid for fast record searching.
      • Wrote SP to gather the results.
      • Also wrote HTML Component/DHTML to highlight MouseOver row.
    • Compacted 150+ HTML documents to XHTML driven by Strict DTD and CSS
      • Folder size was approximately 2900% larger before migration
      • Meets levels 1 to 3 of W3C Web Accessibility.
    • Wrote ASP 3.0 to upgrade database calls in legacy software.
  • Operational Administrator of State-wide Emergency Alert System
    • Add Users
    • Change Roles
    • Add Categories
    • Add External Links
    • Use Case: Q & A

Information Control Corporation(ICC): Web Developer Consultant
HTP-INC.
12-04 to 2/05

• At HTP-INC., I worked on several Microsoft based intranet projects for HIPPA standards. The first project is the migration of a classic ASP/HTML/SQL Server site to ASP.Net/XHTML/SQL Server site in a team environment. Another project I worked on exclusively was a simple migration of a classic ASP/HTML/SQL intranet site to XHTML Transitional and Strict specifications, including extensive CSS2 usage, VBS 5.0 functions for enhancements, testing and debugging classic ASP and ADO 2.5 codes. Also I wrote some Stored Procedures from a SQL Server 2000 in Third Normal Form HIPPA standard database for use in various hospitals for insurance claims and eligibility statuses.
  • Created GUI Web Screens in Strict and Transitional XHTML abiding to all user needs for classic ASP intranet site.
  • Wrote VBS Functions for ASP site for general modifications.
  • Wrote VBS to create dynamic page headers and labels through SQL Server 2000 utilizing the Application Object.
  • Created GUI Web Screens in Transitional and Strict XHTML abiding to all user needs for ASP.Net intranet site.
  • Tested and debugged ADO 2.5 calls for classic ASP site.
  • Wrote and deployed Web Forms for ASP.Net intranet site, including binding Web Form elements to SQL Server 2000 through ADO.Net onto Datagrid form elements.
  • Wrote various Stored Procedures for Search screens Hospital type usages in a HIPPA development environment.
  • Called various Stored Procedures for Search screen documents.

Pillar Technologies: Web Developer Consultant
Exel Logistics
11-04 to 1-05

• At Exel Logistics I worked with another developer developing a 2-tiered web search site in HTML, CSS, JavaScript, and Flash though an Oracle Portal. I developed the front-end work comprising from cascading menus (up, down, side-to-side) to creating search forms with values toggles between twin Select Lists as well as the User Interface utilizing I-frames, DHTML, CSS, and HTML.
  • Create a User Interface for a new search service for Exel Logistics (screen shot). Used extensive CSS in conjunction with HTML implementations of up to five IFrames per page for basic main page layout.
  • Create complex search forms with DHTML holding similar groups in arrays for specific searching.
  • Created at least eight Cascading Menus, with attributes such as: cascade side ways, cascade up, cascade down, rollover images, within IFrames.

Agile Techologies: IT Consultant
Nationwide Insurance
Columbus, Ohio 6-04 to 8-04
Web Applications and Development:

• Wrote 30+ complex Stored Procedures and User Defined Functions for Agent Intranet Site. The Stored Procedures were for an Agent Intranet Site so they may insert, update, or delete any information for their respected agencies. The database format is that of IBM IAA specifications and data redundancy is thwarted by the design in Third Normal Form (3NF) format.
  • SQLServer 2000
    • Stored Procedures
      • Wrote Select, Insert, Update, and Delete Transact-SQL Statements for Stored Procedures.
      • Wrote User Defined Functions to implementing the Date function to validate current years agent reimbursement data.
      • Calculations
      • Error Checking Validation
      • DBMS Concentrated, minute COM layer
      • Error Checking Validation
    • Tested Stored Procedures through SQL Server 2000 and through company testing Intranet application.
    • Planning, Documentation, Specifications

American Insurance Administrators
Upper Arlington, Ohio 10-01 to 6-04
Web Developer:

• Designed, developed, and maintained 2 and 3-tier web sites (15+), comprising of Active Server Pages, SQL Server or Access data tier and COM business rules tier when needed. The sites relied on SQL Server and Access databases for large accounting of zip codes, area rates, and other insurance data. The sites are heavy in ASP front-end scripting because of the delicate nature of the materials. And serve insurance policies and investments through e-commerce business activities. I also developed a migration project involving one of the web sites to the ASP.net architecture.
  • Developed and Implemented Active Server Pages for marketing products on National Alumni Associations. Implemented VB Script and JavaScript for individual state and insurance specifications, in regards to state and policy requirements. All sites comprised of selling insurance products to individuals based on state and policy specifications.
  • Extensive and interactive use of session and non-session cookies
  • Created prototype cookie menu for users as an alternate page for users who left the site and came back at another recent time. Allowed the user to change or modify data all on alternate page, if they had previous browser data. Used hash key type ASP cookies and query string to extract pertinent data to free SQL Server transactions.
    • Implemented hash key type ASP cookies on forms pages for users to save data on the client for possible return visits
  • Created several JavaScript Calculators for figuring investment from client for particular investing products. Also have created small Access databases for usages pertaining to more complex calculators.
• Designed and implemented SQL Server 2000 database via non DNS connection for pertinent web sites. Wrote and tested Stored Procedures to replace inline SQL statements. Also, periodically made updates to database through Enterprise Manager and created DTS packages.
  • Created Data Transformation Services (DTS) through Enterprise Manager Wizard. This involved a migration of Access database to SQL Server 2000 database. Most notable changes were to change field names to appropriate names.
  • Created DTS package containing OLEDB driver and Active X script task to extract data as a text file and be used as an email attachment.
  • Create / Update Database; MS SQLServer 2000, MS Access
  • Designed and implemented Access database via OLEDB ADO connection for pertinent web sites in First and Second Normal Form. Made quarterly updates to database through Datasheet View.
  • Designed and created relational databases with Access, primarily for small web applications and marketing data. Created Access Reports and Queries for upper level management for extracting marketing data and related needs. Designed and implemented Access databases for several Intranet applications, normally saving employee public data, passwords, and logins.
  • Wrote Stored Procedures for querying and inserting data for e-commerce web sites.
  • Migrate Inline SQL Queries to Stored Procedures to save database processing.
  • Created state of residence validation through comparing first three integers with form and cookie values against SQL Server and before that Access databases, respectively.
  • Created simple 2-tier ASP 3.0 and Access intranet bulletin board (Page2) utilizing session cookies and logins; via OLEDB database connections.
• Wrote both client-side (JavaScript) and server-side (VBScript) code for form validation and implemented necessary matches with Regular Expressions. My form validation also included client side Credit Card Validation using Lund's Algorithm for a first step check in the user's final application requirements.
  • Implematations using Regular Expressions
  • Credit Card Validation using Lund's Algorithm
• ASP 3.0 to ASP.Net Migration of one of the web sites, primarily on form pages and Data Grid database call. The migration was not fully complete to deploy for e-commerce usages, but was well beyond prototype stage utilizing, VB.Net, ADO.Net, SQL Server, JavaScript, CSS, and HTML.
  • Wrote Stored Procedure to replace COM Component for individual user state premiums for ASP.Net migration project.
  • Utilized ASP.Net cookies and query string Request and Response objects, respectively to save data to client software to unload web server resources. And used ASP.Net Literal controls and Panel controls to delineate sensitive and uncommon data.
  • Implemented ASP.Net Web Controls to create and valdidate web forms. Validated user data with the typical validation tools:; RequiredFieldValidator, CompareValidator, RangeValidator, and RegExpressionValidator; respectively.
• Created and designed COM VB components for individual state rates for premium calculations. As well, used and modified various commercial COM components (i.e. CDONTS and Content Links). Also, created simple COM components utilizing Windows Script Component, for simplifying complex VBScript functions.
  • Created several VB COM components for premium calculations
  • Created Simple COM components utilizing Windows Script Component
  • Implemented and Modified various Commercial COM components, i.e. CDONTS and Content Links
• Used extensive CSS and other HTML document resources to simplify and reuse of HTML data (My Old ReadyMed Site). Received Gold Metal from PIMA in lieu of GradMed.com, for Ergonomic Design, for outstanding web site for marketing purposes.
  • Created several custom DHTML Interactive Dropdown menus for various Intranet and Internet usages.
  • Related DHTML development was an on click photo gallery created primarily for Intranet usages such as staff photos at given functions
  • Strict Usage of CSS and HTML 4.0
  • Received Gold Metal from PIMA in lieu of gradmed.com (note, that is nolonger my design, though most of the ASP and JavaScript is), for Ergonomic Design
• Created and administered marketing data using Web Trends Report Data and also created multi-tabled Excel spread sheets displaying pie charts and other useful marketing data from the Web Trends Report Data.
• Also published Statistical data into various Excel charts and data for browser based client-side downloading through Active Server Pages.

Consul Tech, IT Consultant
Westerville, Ohio, 12-00 to 6-01
Computer Operator II:

Interliant

• Run Daily, Weekly, Monthly, Yearly Backups (Unix, Windows NT, Vax,)
• Analyze Operations
• Configure & Execute Scripts
• Maintain Equipment
• Create / Maintain Excel Based Backup Query
• Customer Service
• Update Daily Shift Security Tests

Education

DePaul University, 1 E. Jackson Chicago, Illinois
Master of Science in Information Systems, Expected 2009 (because my tuition reimbursement was cut)

Franklin University, 201 S. Grant Ave., Columbus, Ohio;
Bachelor of Science in Computer Science, April 2004, 3.44 GPA; Honors: President's List, Dean's List

Franklin University, 201 S. Grant Ave., Columbus, Ohio
Bachelor of Science, dual major of Business Management & Marketing; December 1994, 3.0 GPA in major

Certifications and Training

Professionalism

Information Technology

• Oracle 1 PL/SQL: 10 hours
• Oracle 2 PL/SQL: 10 hours
• Oracle 3 PL/SQL: 10 hours
• Oracle 4 PL/SQL: 7 hours

• Introduction to Incident Command System (ICS): IS-100
• Single Resources and Initial Action Incidents (ICS): IS-200
• Continuity of Operations (COOP): IS-546
• National Incident Management System (NIMS): IS-700
• National Response Plan (NPR): IS-800

Professionalism

• Ethics
• Workplace Diversity

Other Experience

Administrative Assistant:

• Office Team, Worthington, 11-98 to 7-00
• Dawson Personnel Ohio,
• Martha Vance & Associates Inc.
• Worthington Industries
• Quest Communications
• Creating Flowcharts
• Creating Memos
• Editing
• Scanning

Customer Service:

• Submit Order.Com
• Placing Orders
• Resolving Product or Shipping Problems
• Resolving Pricing Discrepancies
• Clerical:
• Filing
• Accounting
• Data Entry
• Mail Merge

Irrevlevant Experiences

Restuarant Manager:

• Franco's Pizza
• Worthington Mall, Worthington, Ohio
• 5 Years

Also:

• Plumber - 1 year
• Landscaping/Lawncare - 3 years
• Bowler, on and off