Robert McAninch
21088 Lake Rd.
Rocky River, Ohio 44116
Phone:  [Send email to request phone number] 76-0632
[Send email using form at bottom]

Technologies:	COBOL II, DB2, MVS, CICS, JCL, CA-7, TSO, VSAM, Xpeditor,
File-Aid, Oracle, Sybase, Ab Initio, SQL Server, webMethods Enterprise
Integration, webMethods Business Partner Integration, Microsoft Access, Visual
Basic, Siebel EIM, DDF, QMF, SPUFI, BMC Catalog Manager, BMC Change Manager,
File-Aid for HPS, CTI, SourceSafe, Unix, Autosys, Java, XML

Education:	Miami University, Oxford, Ohio
		Bachelor of Applied Science in Systems Analysis, May 1986

Employment:

12/04 – present	Key Bank 
Applications Systems Senior Consultant
		Key Bank
Work as the Data Architect for the Key Education Resource (KER) Group.  This
group supports all student loan activity at Key.  There are four Agile Teams that
work using the Scrum Methodology to build a new customer facing web application
to support student loan application submission.  As the Data Architect, I worked
with the Student Loan Application  User Group and IT management to build seven
new schemas to support the loan application submission process.  I then designed
and helped build new Oracle environments to house these new schemas.  To support
concurrent, agile development and testing, I helped build five Development Oracle
environments, two System Test environments, a Quality Verification environment, a
Performance Testing environment and two production environments.  I designed and
wrote detailed specifications for the conversion of an existing Sybase Database
to the new Oracle environment and I was responsible for managing the developers
who constructed the conversion programs.  I work with all of the Agile teams to
make sure any on-going enhancements to the database fit properly into the
existing schemas or to make sure any new schemas are created meeting our database
standards.

I also developed an Ab Initio environment to support all batch processing that
occurred in the new Student Loan system.  I wrote all of the Ab Initio
Specifications and I was responsible for managing the developers who constructed
any Ab Initio programs.  

As one of a small group of Data Architects at Key, I also had the responsibility
of managing and enhancing the corporate wide data model and determining
authoritative sources for all of our data objects at Key.  I reviewed changes to
the Corporate Logical Model as well as changes to various existing and new
physical data models.  I also work with senior line of business personnel to
better understand business data needs and how to support these needs.

2/03 – 11/04	Tek Systems 
Senior Consultant
		Key Bank
Responsible for application design and construction of the integration of 10
legacy systems into a Siebel CRM application.  These 10 legacy applications
(ACAPS, KER, PLAID, TCS OBI, MAX, EDW, ACT, CID & AOM) contained information that
was loaded into the Siebel Activity Tables.  Some of these applications
interfaced to Siebel via batch loads using Ab Initio.  Some of the applications
interfaced to Siebel via an online MQ interface to webMethods.  Responsible for
all interface design, and use case development.  Also, responsible for
coordinating development of these programs with a staff of 10 developers.  

Lead analyst performing application design and construction on an overdraft fund
recovery system that Websphere front end to connect to a DB2 database.  Original
system was a Visual Basic application with an Oracle database that communicated
with trading partners via email.  
Information on past due accounts was collected by the front end and stored in
DB2.  This data was then interfaced to eight collection agencies using webMethods
Integration Server.  Files were encrypted using PGP encryption with the RSA
algorithm and sent to trading partners via ftp.  Payments collected by the
agencies were then sent back to webMethods using the same design.  Responsible
for communicating with all of the trading partners and coordinating testing. 
Also responsible for designing a database conversion from Oracle to DB2 and for
designing a DB2/Visual Basic reporting system.

 

4/02 – 2/03	Summit Software Development
Senior Consultant
		Hoover/Maytag
Senior analyst performing application design and construction on a customer
service system that  needed to integrate data from  an AS/400 DB2 system, a
Siebel system and a Broadvision system using webMethods Enterprise Integration. 
This was a very large webMethods integration requiring over fifty documents to
move data among the three systems.  Responsible for developing webMethods data
requirements with technical teams from Siebel and the AS/400 as well as reporting
design to management.

6/00 – 2/02	Maxim Group
Senior Consultant
		Key Bank
Responsible for application design and construction on a project to convert an
application from HPS (a case tool) to Visual Basic.  The new version of the
application consisted of a Visual Basic front end with over 250 DLLs that
communicated with mainframe CICS/DB2 programs.  Responsible for guiding a team of
10 Visual Basic developers to complete this system.  Responsible for assigning
work and tracking progress of the developers as well as reporting project status
to management.

2/00 – 6/00	Ajilon Corp.
Senior Consultant
		First Energy Corp.
Senior analyst on a project to merge the billing of all of First Energy’s
Companies into one system.  Responsible design and coding of online COBOL, DB2,
CICS programs and batch COBOL DB2 programs.

6/97 – 1/00	Renaissance Worldwide, Inc
System Consultant
		Jo Ann Fabrics, Inc.
Senior analyst on a project to convert mainframe retail systems to SAP.  
Developed extracts to load initial SAP database tables.

Technical lead on mainframe Year 2000 project.  Lead a team of six people
responsible for testing process to certify online applications as year 2000
compliant.  Designed testing procedures for online CICS DB2 environments using
Compuware’s Data Ager, Hiperstation and HourGlass 2000.  

Senior analyst on a project to improve the reconciliation of purchase orders,
invoices and receipts for Jo-Ann Fabrics, Inc.  Responsible for analysis, design,
coding and implementation of changes to the purchase order system.  Designed and
coded online COBOL, DB2, CICS programs and batch COBOL DB2 programs.

7/90 – 6/97	Key Bank
		Senior Database Analyst
As a DBA supported a number of DB2 databases including the Customer Warehouse,
Teller System and Internet Banking.  Performed database modeling and design. 
Created, modified and maintained databases using BMC Change Manager.  

Responsible for initial design of a client/server application to support four
large call centers.   This application was written in a client/server tool called
HPS.  Responsible for design of large DB2 Contact Management Database containing
over fifty tables with over twenty million rows.  Responsible for analysis,
design and construction of on-line infrastructure including system flow, logging
facilities, access paths and telephony interface.  Responsible for coding over
100 programs in the HPS language.  Responsible for analysis and design of TCS
batch flow including DB2 log pulls, database maintenance programs, reporting
structure and external interfaces.    

Responsible for analysis, design, coding and implementation of Customer
Retention System.  This was an on-line CICS system with a DB2 database that
tracked account closings in an attempt to retain good customers.

Senior programmer on a project to develop a new teller system (OLDS).  Performed
data mapping from existing legacy systems to DB2, wrote conversion programs and
DB2 utilities and supported initial production install.  Designed, coded and
supported a large portion of the teller batch system including DB2 log pulls, DB2
refresh programs and batch interfaces to existing legacy systems.
 

6/88 -  7/90	RB&W Inc.
Senior Programmer/Analyst
Responsible for analysis, design, construction and implementation of Electronic
Data Interchange (EDI) projects in a COBOL, CICS and DL/1 environment.  Worked to
establish JIT warehouses for two Navistar manufacturing facilities and a Kodak
facilities.  Also, worked on EDI projects for Westinghouse, Union Pacific, AT&T
and Georgia Power.

8/87 -  6/88	Software Alternatives Inc.
Consultant
Designed, coded and implemented mainframe systems for National City Bank,
Owens-Illinois and The Cleveland Clinic.  These projects included the use of DB2,
SQL, COBOL and SAS.

11/86 -  8/87	Anacomp Inc. 
Applications Programmer
Responsible for coding and testing COBOL programs in an on-line purchasing
system.