Joe Gakenheimer

You do not have JavaScript enabled on your browser. otherwise you would be redirected to my updated content. I knowlonger update these pages, please visit my updated site at My Updated Site or choose a link of your choice:

If you have not been redirected, then please click on one of these links to visit my new redesigned and enhance web site and blog.
home | me | faq | resume | portfolio | pics | site | asp | asp.net | java | javascript | sql | xml
algorithms | dbms | html | j2ee | mis | networking | os | se

Actively Looking.

6637 McVey Blvd. Columbus, Ohio 43235-2815;
(614) 889-5179
via e-mail: joegakenheimer@columbus.rr.com
printable resume: Full College version
printable resume: Web Developer version

Education

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

Skills

Languages & Technologies :

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

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

DBMS: SQL Server, Oracle 8i, Oracle 9i, MySQL

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

Some Experience with: C++, C, C++ in the Unix Environment and TCP

Software:

Macromedia MX, Adobe Photoshop 7.0, MS Office, MS Visual Studio 6.0, Visual Studio .Net, MS FrontPage 2002, Vi, SmartDraw

Methodologies:

Object-oriented design (Rambaugh & Booch), Version/Change Control, RAD

Interests:

Web Applications, Software Engineering, DBMS

Current Projects and Research:

ASP.NET: MCAD, Mail and Spiders, DTS

Experience

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

• Created 30+ 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, 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. 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, 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

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