(480) 951-2686
PROFESSIONAL OBJECTIVE
More than twenty years of information technology expertise in client/server environments using project management, systems analysis, and applications programming.
Seasoned technical systems integrator, administrator, coordinator, manager, developer, and analyst with expertise in enterprise application process and data modeling, cross-platform migrations and conversions, relational database design and normalization, and software reengineering.
Hybrid mainframe/client-server interfacing skills, with expertise in Oracle, DB2, UNIX, and Java.
HONEYWELL, Phoenix, AZ 2002-2005
Keane Senior Consultant
USA Keane focal point for supporting the Tucson Online Tracking System (TOTS) with Keane India offshore resources 7/24/365. TOTS is an in-house developed systems that collects labor, attendance, payroll, test, and inspection information for manufacturing and repair and overall. It consists of about 90 batch reports and 80 batch scripts on unix and about 170 Oracle 6I forms and reports with 400 users.
Systems administration support for DataStream, an asset performance management system, with reporting, work management, and auditing functionality for 200 users. It consists of J2EE (Java), EJB, JSP, and XML, Oracle Discoverer, Oracle 9iAS, and tomcat/apache web methods server.
PL/SQL and UNIX korn shell scripting to support Aerospace Services data warehousing CPU mainframe reduction effort, resulting in savings of $400,000 in three months. Developed Oracle stored procedures to facilitate data warehousing processing. Utilized FilePort, AWK, and C scripting to data-cleanse downloaded IMS mainframe files prior to loading the rows into Oracle tables on UNIX/AIX.
Environment: Oracle 8, 9i, and 10G, Oracle Web Server, Oracle forms and reports 6i, Quest/TOAD, UNIX/AIX, Korn Shell, Erwin, Informatica, AWK/SED, EXTRA Personal Client , TSO, JCL, WS-FTP, IMS DB, ERP/SAP.
UNIVERSITY OF PHOENIX, Phoenix, AZ 2002
Senior Systems Analyst
Developed, modified, and tuned Pro*C reports, Oracle forms, and PL/SQL stored procedures.
Maintained Osiris and Campus Tracking Oracle database systems with troubleshooting, optimization, and production support.
Environment: Oracle 9i, Pro*C, UNIX/Solaris, Korn Shell, Quest/TOAD, Oracle Developer, Forms/Reports Builder 6i, Quest/SQL Impact, StarTeam 5, HEAT, XML, Crystal Reports, MS/Office, PeopleSoft.
WELLS FARGO, Tempe, AZ 1999-2002
Systems Engineer
Automated Clearing House History Integration Project. Coded, tested, and installed Oracle packages on a UNIX/HP platform to accommodate 15 partition table split of the database.
Data center closure support. Migrated Wells Fargo Automated Clearing House NDM returns Connect Enterprise/Mailbox jobs, files, and schedules from Arizona to Minneapolis.
Created process to download 14 DB2 tables to NDM load to Unix Oracle tables. Created MS/Access canned procedures, forms, and views to access Oracle tables with daily downloaded data.
Environment: Oracle RDBMS, UNIX/HP, PL/SQL, Korn Shell, C, OCI, iPlanet Web Server, JavaScript, Java, MVS, PacBase, COBOL, JCL, MS Office.
NDC HEALTH INFORMATION SYSTEMS, Phoenix, AZ 1999
Lead Programmer Analyst
Managed the successful installation of Data Warehousing Engines aggregations using Oracle, PL/SQL, and UNIX, reducing monthly production time by 70 percent. Managed upgrades and 7 x 24 pager production support of web-enabled Territory Analyzer marketing system, generating annual revenues of $6 million. Managed direction of developers, analysts, consultants, and DBAs.
Environment: Oracle RDBMS, UNIX, PL/SQL, Visual Basic, C++, MicroStrategy DSS Agent, MVS, COBOL, JCL, MS Office.
AMERICAN EXPRESS, Phoenix, AZ 1998-1999
Consultant/Modis
Performed technical lead activities. Created new CICS/DB2 programs for World Wide Central Submission project. Coded CICS stack navigation subroutine, error detail program and suspends program with pop-up displays. Coded batch/DB2 reports. Created test case suites. Supported global financial capture Y2K testing using Method/1 system development life cycle methodology.
Environment: COBOL/IMS/DB2 transaction-based processing with client-server interfaces. Librarian, Changeman, REXX, HourGlass, Xpeditor, ConnectDirect, AbendAid, EZYEDIT, Word/Visio, and File-Aid products utilized.
ARIZONA PUBLIC SERVICE, Phoenix, AZ 1997-1998
Consultant/Interim Technology
Rewrote multi-program COBOL/IMS benefits statement system to read DB2 tables.
Environment: COBOL/IMS/DB2 with client server interfaces.
FIRST CHICAGO/NBD, Elgin, IL 1981-1997
Lead Programmer Analyst
Results oriented. Managed full life cycle development and implementation of baseline and mission-critical concurrent projects of more than 5,000 hours, such as Euro conversion, Y2K compliance, and major marketing initiatives.
Managed Davox Unison call center system integration using UNIX/C++ binaries/Sybase.
Technically versatile. Expanding development responsibilities using PL/SQL, Perl scripting, COBOL, PL/1, CICS, SAS, BAL, HOGAN, JCL, VSAM, IBM utilities, TSO/ISPF, DB2/SQL/QMF, Access, Excel, Panvalet, Endevor, File-AID, XPEDITOR on IBM ES9000/MVS, UNIX, Tandem, LAN/WAN/Windows operating systems and platforms.
CERTIFICATIONS
