[+] | [-]

Resume of Ray Schelp

10/2004–12/2005     American Century Investments      Kansas City, MO

Senior IT Consultant / Project Lead

  • Developed Apache ASP websites using: Javascript, DHTML/DOM, CSS, SSI, Perl, and DBI.

  • DA group Data Dictionary website:  made all metadata/diagrams information available to entire corporation.

  • Managed multi-department project to upgrade ER/Studio to new version - rollout to corporate users - conversion of all metadata.

  • Security group TARM website: made all user/role/resource data available to entire corporation for inquiry and update.

  • Security group Firecall website: allow corporate users to maintain/track emergency firecall id checkout/checkin/authorization.

  • Security group Securetrack website: add enhancements to give entire corporation ability to inquire and update security dept requests.

  • Created a Perl Program Module ACI::LDAP.pm to consolidated access/updates to LDAP user/group data on three platforms.

  • Developed ER/Studio VB macro's. Ability to 'publish' meta data directly from ER/Studio diagrams to Oracle tables via an ADO connection.

10/1995–09/2004     Sony Electronics      San Jose, CA

Senior IT Consultant / Project Lead

  • Develop/maintain: mainframe, client server, and web application systems.

  • Legacy systems: Supply Chain, Inventory, Customer Service, Sales, Billing, Financial reporting, and G/L feeds.

  • Liaison between Sony Professional Parts (Users) and ISSA (IT) departments. 

  • Translated user requirements into systems specifications and developed application systems.

  • Developed .Net website for B-to-B order entry using: ASP.Net, VB.Net, Web Services, and CICS.

  • Developed and enhanced multiple ASP and CGI websites running on IIS and Apache servers.

  • Developed VB 6.0, VB.Net, C, Perl, and VBScript applications.

  • Developed and enhanced C and Perl applications running on AIX (Unix).

  • Provided desktop, network , and PC software support.

  • Provided DBA support for Oracle, and Access databases.

07/1992–07/1995    Student Loan Marketing Asc.     Herndon, VA

Manager Applications

  • Hands on role managing 3 project teams (fifteen people).

  • Project lead for developing companies first website.

  • Developed several VB 3.0 applications.

  • Developed three new student loan programs on mainframe.

  • Maintained legacy mainframe systems handling loan amortization, account maintenance, and loan repayment.

  • Participated in migration of legacy systems to DB2 from VSAM.

  • Project lead in migration of legacy systems to client/server from mainframe architecture.

  • Participated in effort to "privatize" all student loan accounts by transfer into a trust.

  • Provided DBA support for all Oracle databases used in my projects.

  • Recipient three years running of MIS VP discretionary bonus.

02/1990–07/1992    Zone Technologies    Overland Park, KS

Owner / Project Lead

  • Magaged startup of "S" corporation providing consulting services.

  • Fortune 500 companies accounted for 85% of revenue.

  • Specializations: Design and implementation of database/online systems -included database administration, tuning, and software installation/configuration.

  • Services provided: project management, data modeling, database design, and online application systems design and implementation.

Clients:

  • Sante Fe Railroad, Topeka, KS

  • Utilicorp United Inc, Kansas City, MO

  • Yellow Freight, Overland Park, KS

  • DST/Midland Systems, Kansas City, MO

11/1984–02/1990    Utilicorp United, Inc.     Kansas City, MO

Manager Technical Support

  • Managed: Database, Systems Software, Network/LAN, Data Security, Desktop Support, Help Desk/Call Center, and End User Training.

  • Spearheaded Steering Committee composed of companies senior officers.

  • Spearheaded re-engineering of MIS organization moving from punch card equipment to mainframe and client server environment.

  • Performed evaluation, recommendation, and selection of all: mainframe hardware/systems/networks; legacy application packages; LAN hardware/software; and Data Center layout, environmental, and operation support applications.

  • Implemented: Departmental standards and procedures, Help Desk, Problem Management, Scheduling, Tape Library, Disk Archival and Backup, Disaster Recovery, Contingency Planning, Source Change Management, Console Message Automation.

  • The sole DBA – performed all database administration, and related duties for IDMS and SQL database systems.

  • Recipient five years running of CEO discretionary bonus.

08/1979–10/1984    Cal Bay Software Inc.    Scotts Valley, CA

Owner / Project Lead

  • Managed startup of a "C" corporation that provided consulting services.

  • Key to growing firm to 35 employees.

  • Fortune 500 companies accounted 70% of revenue.

  • Managed client marketing and relationship building.

  • Specializations: Design and install mainframe database online systems.

  • Services provided: project management, data modeling, database design, application systems design/development/implementation.

Clients:

  • National Semiconductor, Sunnyvale, CA

  • Teledyne Inc, Sunnyvale, CA

  • Four Phase Computer, Cupertino, CA

  • Memorex, San Jose, CA

  • Computer Usage Corp, Sunnyvale, CA

  • Network Database Systems, San Jose, CA

02/1977–07/1979    Gap Stores Inc.    San Bruno, CA

Senior Systems Analyst / Manager Database & Online Systems

  • Designed/implemented major rewrite of distributed inventory/pick systems.

  • Developed Merchandise Performance Reporting System.  Used by senior officers to grade the buyers performance in managing retail merchandise levels.

  • Managed all online applications and database administration

  • Published Online and Database shop standards.

  • Performed all database administration duties.

 

06/1976–01/1977    TWA       Kansas City, MO

Programmer/Analyst - PARS Reservation Systems

  • Designed/maintained PARS reservation systems programs.
  • Maintained Joint Fares database. Managed applying published CAB fare increases.

 

10/1974–05/1976    City of Kansas City     Kansas City, MO

Programmer

  • Developed and maintained: IBM COBOL/CICS mainframe systems as follows:

    • Uniform Fire Information Reporting

    • Information Center Systems

    • Office of Finance and Accounting Systems

    • Water Department Accounts and Billing

07/1973–08/1974     Penn Valley Junior College     Kansas City, MO

Senior Computer Operator

  • Maintain student enrollment and schedule systems.

  • Manage scheduled runs of production systems.

08/1972–06/1973 Hallmark Cards Inc. Kansas City, MO

Computer Operator

  • Operated and managed tape drives, printers, and consoles.

10/1968–07/1972    US Navy. (CVA-66/NAS)    Glenview, IL

Computer Operator / Programmer/Analyst

  • Maintained shipboard and air supply systems.

  • Maintained Air Base supplies systems.

 

08/1967–10/1968 Hallmark Cards Inc. Kansas City, MO

Unit Record Operator

  • Programmed (wired) and operated unit record card machines.