Crane Consulting Inc.

Visa USA                         May 2005 - Nov 2005

• Business Analyst and Project Manager for a major data center relocation.

• Responsible for developing technical specifications as well as move day 'script' for the final two phases of the mainframe relocation effort.

Visa International             Oct 2002 - May 2004

• Gathered requirements for Visa International knowledge management and documentation repository.

• Performed detailed comparative analysis of several vendor products which resulted in the selection of the OpenText Livelink tool.

• Responsible for implementation and initial roll-out of the OpenText Livelink tool at Visa International.

Inovant (A Visa Solutions company)             Jan 2001 – Sep 2002

• Developed and coordinated technical training documents for Visa International divisions.

• Vendor analysis and selection for Visas corporate standard documentation tool. 

• Development Project manager on the Enterprise Service Desk (ESD) project using the Siebel Call Center and Peregrine Service Center products.

• Responsible for design and development of interfaces into the application as well as all customization and configuration required for the implementation of the products.

Vodafone                                                        Aug 2000 – Dec 2000

• Project manager and technical lead working on Vodafones WAP-enabled web-site for Vodafone New Zealand.
• Responsible for the migration of customer data from the current web-site onto the new web-site for approximately 40,000 customers.
• Data included customer contact data, personalization profile data and email data.  
• Work included documentation of the current and new data schemas, mapping of data from the current schema to the new schema, data scrubbing and specifications of the data transformation algorithms.
• Worked on-site in New Zealand for 3 months with the on-site technical staff.

Visa International                                            Feb 1998 – May 2000

• Technical writer responsible for all customer technical documents for the CRIS (Customer Risk Identification Service) Taiwan project. 
• Documents included hardware and software technical specifications. 
• Project manager in the Year 2000 project office.
• Project manager and lead for the VEBBS (Visa Electronic Bulletin Board) application, a Web-based application running on Visa’s Intranet which was used globally by Visa’s Year 20000 Event Management Centers to manage events during the year 2000 transition period. Gathered and consolidated the requirements from business centers located in Sydney, Singapore, London, Toronto, Miami, and San Mateo. Performed the analysis, developed the design, recruited for and built the development team, acquired the hardware, and managed the development and implementation of VEBBS. The application was developed using Cold Fusion version 4.0 and ran on a SQL server 6.5 database.
• Worked on the implementation of Visa’s Year 2000 Member Test service. The service was a test service available globally to all of Visa’s members used to certify that the member’s interface to Visa was year 2000 compliant. The service included all VIP and BASE II software and ran in a repeating 14 day cycle consisting of year 2000 transition dates as well as the leap year and the transition from 2000 to 2001. Worked on the documentation and user guides which were distributed world-wide to all Visa member banks and processors.
• Developed all technical member documentation for the CRIS (Customer Risk Identification Service) for the planned installation of the service in Taiwan. Documentation included Technical Interface specifications, Network Design specifications, and Hardware and Systems Software specifications. Documents were designed to be translated into Chinese.

AirTouch                                                          Jan 1997 – Feb 1998

• Responsible for performing data analysis and mapping of data between the ATBS application and the PRISM billing application for the Billing Convergence project, which was designed to migrate the data from the PRISM billing system into the ATBS application. Traveled extensively between Walnut Creek, Columbus and Los Angeles to interview the subject matter experts and gain an understanding of the applications.
• Developed an application using Microsoft’s Access product to track the mapping of the data elements between ATBS and PRISM. At the time, the PRISM application included 1422 data elements held in an IDMS database plus 24 permanent RMS files. The ATBS application included 4604 data elements held in an RDB database running under VMS with 209 tables, 3 Oracle databases running under UNIX, plus 20 permanent RMS files.
• Responsible for developing technical documentation for ATBS (AirTouch Billing System).

Wells Fargo                                                      Feb 1996 – Jan 1997

• Lead programmer/analyst on WEBS (Wells Electronic Banking System). WEBS is an online customer information and account management system composed of over 2000 batch jobs and over 1000 CICS modules. It is used by the entire corporation to manage customer accounts. Application was written in COBOL II using DB2 and VSAM data access methods running under CICS.
• During the merger with First Interstate bank, was responsible for mapping customer data between the First Interstate and Wells Fargo banking systems. Developed conversion programs to extract and merge customer data from First Interstate into the WEBS databases.

Visa International                                             Jul 1994 – Feb 1996

• Analyst, designer, programmer and technical writer at a large credit card corporation.
• Responsible for analysis and design of the reporting portion of the new VisaNet Settlement Service (VSS). Design constraints included ensuring that settlement reports for all 600 processors could be generated within a one hour window. Design included the use of parallel processing and the extensive use of in-core tables to meet this criteria.
• Responsible for writing the member guide which provided member banks with technical information and user interface specifications about the new settlement service. Document was translated into several languages and distributed world-wide.
• Responsible for publication of a 900-page Detail Design document and a 200-page Detail Design Summary document. Documents were written in Microsoft WORD 6.0 using Power Point and ABC Flowcharter for all charts and diagrams.

Pacific Bell                                                         Mar 1993 - Jun 1994

• Contract analyst/designer/programmer at a large telecommunications company.
• Responsible for designing the complex pricing routines of a new rate and pricing system for very large Business Customers, using historical information from large DB2 Databases.
• Coded and tested COBOL/CICS/DB2 programs, using SDFII Screen Generator, Brownstone Data Dictionary, and XPEDITER test tools.
• Developed innovative interface between the CICS mainframe application and PC workstations for downloading data and printing reports. Design requirements included being able to print reports either to a JES printer or to a local LAN HP Laserjet printer depending on the user’s preference. Design included common report modules which were callable in either the batch or CICS environment.
• Performed in-depth System and Performance Testing. Worked closely with DBAs to optimize and tune the DB2 retrievals.

Florida Power and Light Co. (FPL)                   1980 - 1991

• Responsible for the installation of the CCC librarian product, which was acquired to manage over 10,000 components of an Employee Information System. 
• Responsible for developing procedures, standards and training for use of the product.
• Responsible for all aspects of the development of a Transmission Distribution system including budgeting, scheduling, analysis and design. Systems analysis and design was completed using the Knowledgeware ADW Analysis and Design CASE tools. System was implemented using a DB2 database running under CICS.
• Traveled extensively throughout the state gathering system requirements from all levels of the client community.
• Developed innovative utility programs which enabled users to customize color attributes, function key assignments and error messages for the applications.
• Senior Development Center Specialist with primary responsibility for the support of the CICS code generator PROTON—a systems development tool, similar to TELON, used for the prototyping and code generation of all COBOL CICS applications developed by FPL programmers. 
• Worked on Development Center Help desk providing technical assistance to staff of over 200 programmers.
• Developed and taught training classes for a variety of programmer development tools.
• Responsible for evaluation, selection and installation of various programmer development tools.
• Active member of the CICS advisory committee.
• Lead analyst on rewrite of an overhaul maintenance job scheduling system. Responsibilities included project budgeting and scheduling, analysis, design and management of a team of eight (8) programmers. System was written in COBOL using the IMS and VSAM data access methods and running under CICS.
• Traveled throughout the State installing and supporting applications at other large electric utilities.

Florida International University 

• BS in Computer Science (graduated with High Honors)
• BS in Mathematics (graduated with High Honors)

Numerous technical and professional development training courses and seminars including courses in C++ and Visual Basic.

        IBM Certified Solution Expert: DB2 UDB V7.1 DBA for Unix Windows and OS/2

        IBM Certified Solution Expert: DB2 V7.1 DBA for OS/390

        IBM Certified Solution Expert: DB2 V7.1 Family Application Development

Summary 

Twenty-six years varied experience in developing and maintaining software for IBM systems. 
Instructor on all aspects of CICS and DB2 applications development and DBA techniques for clients worldwide.
IBM DB2 Certified Solution Expert (Certified DBA on both Windows/Unix and OS/390, as well as Certified Developer). Certified by IBM and many other vendors to present their most complex DB2 classes. 
Proven state-of-the-art technical skills, with particular emphasis on high-volume CICS, DB2 and IMS large systems development, tuning and maintenance.

Languages and Tools

• Languages: COBOL II, COBOL LE, MicroFocus COBOL
• Databases: DB2 (z/OS and OS/390), DB2 (Linux, Unix and Windows), IMS, VSAM, XDB
• TP Monitors: CICS Command and Macro level, IMS/TM
• Development Tools: MicroFocus Workbench and MFE, Platinum DBA suite, Xpediter, Intertest, SDF2, FileAid, Telon, Spufi, QMF, Compile/QQF
• Configuration Managers: Endevor, PVCS, Changeman, Librarian, LMF

Technical Instructor                                            Jan 1994 - current (Part-time)

• Technical Instructor of DBA and Application Programmer classes, specializing in DB2 and CICS.
• Instructed at all levels from management overview to tuning and internal processing.
• Researched and developed training materials for CICS/TS and DB2. 
• Click on Instructing Clients and Courses for a list of courses and clients.

Bank of America                                                 Mar 2005 - Nov 2005

• Designed and implemented DB2 fraud-analysis reporting system, and conducted DB2 training of offsite programming staff.
• Consolidated DB2 tables and designed data retention strategy for future bank systems.

Silver Spring Networks                                        May 2004

• Configured and performance tuned a DB2 V7.1 system on Windows 2003 Server, with particular emphasis on internal locking conflicts, on a complex proprietary system.

• Set-up Backup and Recovery plans, and regular statistics schedules.

Whirlpool                                                            Jan 2004 - Feb 2004  

• Installed, configured and tuned DB2 V7 and V8 on Windows servers for a Siebel implementation.
• Converted and Optimized SQL scripts and procedures from Oracle to DB2.

Chevron                                                              Feb 2002 - May 2002  

• Upgraded MicroFocus Workbench to the latest MFE version, as part of a Windows XP rollout.
• Development environment was Microfocus COBOL for OS390, with CICS, Screen Painter, DB2, XDB and IMS, with PVCS as the configuration manager.
• Configured and tuned the development environment, and the database replication methods.
• Developed and presented customized training to the programmers and DBAs.

Bank of America                                                 Mar 1999 - Nov 2001 (Part-time)

• Converted ATM fraud detection programs from BofA legacy systems to a new standard model bank platform as part of the merger with Nationsbank.
• Designed and installed DB2 interface.
• Customized and delivered 1-on-1 DB2 and IMS training.
• Participated in Y2K conversion effort and provided 24-hour support over the millennium change.

Chevron                                                               Feb 1997 - Aug 1998  

• System Architect for the online utility components of a proprietary credit-card system. System was converted to COBOL/LE with CICS and DB2 from PL/1 and VSAM.
• Responsible for configuration and support of MicroFocus Workbench and the Screen-Painter and CICS emulation options.
• Performed tuning of the DB2 database and CICS teleprocessing systems.
• Participated in the development of COBOL, CICS and DB2 standards for Chevron.
• Tools used included: MicroFocus COBOL, DB2, Omegamon CICS and DB2, Platinum DBA tools, QMF, XDB and PVCS configuration manager.

Wells Fargo Bank                                                July 1996 - Jan 1997

• Responsible for on-call 7X24 support of the bank-wide online and batch customer information system. The online component of this critical system consisted of 36 CICS MRO regions, using COBOL and Assembler programs to access VSAM and DB2 databases. Transaction volume frequently exceeded 100 transactions per second.
• Tools used included: COBOL, DB2, and Changeman configuration manager

Republic of Namibia, South Africa                      May 1996 - Jun 1996

• Developed and presented a 2 month 'hands-on' relational database class, with emphasis on Informix and Adabas databases, for programmers and DBAs from the Ministry of Finance.
• Consulted with all levels of Namibian government on the design of large databases for a proposed country-wide income-tax system.

Federal Reserve Bank                                         Dec 1994 - Apr 1996

• Designed, coded and tuned DB2 access modules for large (600 GB compressed) DB2 partitioned databases. Monitored and tuned accesses to these databases.
• Responsible for development of IMS to DB2 conversion programs that unloaded and reformatted 10 million segment IMS databases, with particular emphasis on efficient COBOL, IMS and SQL techniques.
• Tools used included: DB2 Load and Reorg, Platinum DB2 migration replication and explain tools, and the Endevor configuration manager.

Bank of America                                                  Aug 1993 - Dec 1994

• Project lead for a conversion from sequential files to DB2 Distributed Data Facility.
• Responsible for design and implementation of interfaces between ATMs and automated fraud detection systems, using COBOL with DB2 and IMS DB/DC Fastpath databases.
• Tools used included IMS BMP, Fastpath, BTS, FileAid, SPUFI and QMF.

Pacific Bell                                                           Mar 1993 - Aug 1993

• Responsible for System Architecture for a large rate and billing system for business telephone customers.
• Designed the access strategies for manipulating 100GB partitioned DB2 databases.
• Responsible for Design of interfaces between IBM and Tandem Mainframes, using LU6.2 protocols in CICS, between the PC 'Client', a Tandem 'Router' and a DB2 'Server'.

Florida Power and Light Co. (FPL)                     1981 - 1991

• Manager of a large (20+) team of employees and IBM Professional Services consultants on a project to monitor occupational radiation exposure of nuclear power plant workers.
  This system was developed on IBM 9370 mini-computers, under the VM OS, using COBOL, ISPF and DB2.
• Provided training and support of the end-users in REXX and QMF ad-hoc query tools
• Managed team of 7 Programmers and Analysts of developing interfaces between IBM 3090 corporate mainframe and CDC CYBER real-time power distribution control computers.
• DBA responsible for performance tuning and acceptance testing of large CICS, IMS and DB2 systems.
• Evaluated and selected vendor for multi-million dollar data recorder contract. These provided direct connection (via telephone lines) to electric meters at large customer accounts for billing and load control purposes.
• Quality Improvement Program (QIP) Team Leader, during FPL's successful bid to become the first non-Japanese company to win the Deming Prize for Total Quality Control.
• Technical Lead on power plant-related systems. These included work order tracking and scheduling, bill-of-materials and inventory maintenance, financial projection and budget tracking and application security.
• Active participation on Standards Committees for CICS and DB2.
• Development languages and tools included COBOL, CICS, DB2, SQL/DS, TELON, QMF, REXX, IMS, VSAM, INTERTEST, VERIFY, and LMF and Librarian configuration tools.

Various United Kingdom Companies                  1978 - 1981

• DBA and programmer on a large Aerospace Inventory and Materials Tracking system. Consisted of extremely large IMS Databases, accessed both in batch and online via CICS.
• Created database backup, recovery, integrity checking and DBD/PSB generation procedures.

Education

John Moores University, Liverpool, United Kingdom.    HND (BS degree equivalent) in Electrical and Electronic Engineering.

Numerous technical and professional development training courses and seminars.
Particular emphasis on DB2 performance tuning and administration, and statistical methods of Software Quality Control.

U.S. Citizen and U.K. Citizen.