SUMMARY

Innovative and dynamic Manager, Architect and Administrator of IT with 20 years of experience across industries encompassing software, financial, government, insurance and manufacturing organizations. Excellence in database administration, system administration, application development and project management.

CORE COMPETENCIES

• Database Administration Application Development
• Project Management SDLC Management
• Staff Management Vendor Negotiation

DATABASE ADMINISTRATION APPLICATION DEVELOPMENT

• Developed and tested online database reorganizations to improve system availability.
• Checked implementation of tables of client systems verifying structures of Tables, Indexes, Stored Procedures, etc. against the design.
• Performed space management and reorganizations of partitioned tablespaces.
• Reviewed DB2 subsystem DASD capacity and added volumes when necessary.
• Performed Database, Tablespace, Table and View definitions and configuration.
• Provided DBA services for migrating and installing application systems from customer sites.
• Provided DB2 Database support to System Administration Team during upgrades.
• Conducted database maintenance with DB2 System Administration Tools.
• Developed JCL for running utilities for Loads, Unloads, Image Copies, Reorgs, Runstats, etc.
• Maintained ISV software associated with DB2. Products included DB2 Connect, Data Propagator, Omegamon and Mainview for DB2, Platinum / CA DB2 utilities, Insight for DB2, Proedit for DB2 and Fileaid for DB2.
• Performed Database Administration and Systems Programming duties associated with DB2 versions 2.3 through 9.1, CICS versions 1.7 through Transaction Server 4.2, IMS versions 1.3 through 9.1 and IDMS versions 10.2 through 16.0. Maintained DB2, CICS, IMS and IDMS software using SMP/E.
• Performed massive data loads and database subsystem refreshes in order to implement new data repositories.
• Customized DB2 subsystems to customer requirements. Modified various DB2 assembler exits to enable userid translation from one business environment to another. Modifying these exits enabled users to have single sign-on capability.

DATABASE ADMINISTRATION

Confidential

• Performed DB2-RACF administration along with DB2 native security administration.
• Performed DB2 performance and tuning. Created Omegamon and Mainview performance reports. Performed Explains and DB2 system traces when necessary. Reviewed various hit ratios and tuned the environments accordingly to improve performance.
• Implemented DB2 reports that analyzed the overall DB2 environments which were reviewed daily and acted upon accordingly.
• Designed and implemented proactive database monitoring on key application performance indicators. Proactively notified customer of potential problems and provided a recommended resolution. Reduced potential application performance issues by 100 .
• Performed Database, Tablespace, Table and View definitions and configuration.
• Reviewed DB2 subsystem DASD capacity and added volumes when necessary.
• Assured all DB2 subsystems were properly backed up and recoverable.
• Interfaced with customers providing assistance with debugging, coding, application design and tuning of DB2, CICS, IMS and IDMS subsystems.
• Participated in quarterly Disaster Recovery exercises assuring Operating System, CICS and Database system recoverability. Developed and executed disaster recovery processes for all participating customers.
• Maintained IDMS/COBOL based ERP and financial applications.
• Assisted in determining shop programming standards.
• Performed software evaluation and provided cost-benefit analysis.
• Developed and maintained MRP, Insurance and Financial DB2 based applications.
• Assisted in designing and converting RCA's Inventory Management System from a batch COBOL environment to an online Database environment.
• Provided 24 x 7 on-call support for all DB2 Database systems and affiliated software.

PROJECT MANAGEMENT

Confidential

• Managed full project lifecycle: planning, development, testing and user acceptance.
• Drove strategy, standards and implementation of technology solutions that enabled SunGard to achieve operational, financial and exceptional customer service goals.
• Managed testing and implementation of new technologies, including methods, policies and procedures for installation, management, monitoring and support.
• Oversaw key milestones and managed technical expectations during project implementation.
• Escalated technical challenges encountered by the project team to executive sponsor.
• Led and matrix managed personnel from hardware, network, engineering, system administration, storage management, database, security, customer service and application teams.
• Ensured all technical team members were contributing effectively to their designated projects. Prioritized staff responsibilities based on project significance.
• Mentored staff by promoting active engagement which facilitated a cohesive project team.

SOFTWARE DEVELOPMENT LIFECYCLE SDLC MANAGEMENT

Confidential

• Managed full software development lifecycle: requirements, design, implementation, verification and maintenance. Oversaw key milestones and managed technical expectations during life cycle.
• Functioned as the technical lead responsible for all technical aspects on multiple projects. Assessed the business requirements and planned budget to effectively implement solutions that adhered to fiscal, technical and vendor best practices.

STAFF MANAGEMENT

Confidential

• Managed global staff of 20 administrators and programmers across 7 Data Centers. Maintained 1000 OLTP and Database Systems as well as providing backup for 1500 client nodes.
• Systems based in CICS, DB2, MQSeries, IMS, UNIKIX, ORACLE, SQL SERVER and MYSQL.
• Successfully combined Mainframe and Midrange team members to support all online, database, MQ and network environments independent of the operating system platform. Streamlined the support group and produced 100 capability with 30 less staff.

VENDOR NEGOTIATION

Confidential

• Negotiated system software contract. Worked with numerous Vendors and SunGard entities, developed business requirements, evaluated software and negotiated the product suite and cost of software. Saved 1M earned SunGard Top Performance Bonus Award.

TECHNICAL PROFICIENCIES

• PLATFORMS: z/OS, z/VM, ESX, VMWare, AIX, SOLARIS, LINUX, HP-UX, Windows, AS/400
• DATABASES: DB2, IMS, IDMS, ORACLE, SQL Server, MySQL, Sybase
• OLTP: CICS, UNIKIX
• MIDDLEWARE: MQSeries, NDM, DB2 Connect, DB2 Gateway, CICS Gateway
• MONITORING: MAINVIEW, OMEGAMON, TMON, PATROL, Netview, DB2 PM
• SECURITY: RACF, Top Secret, ACF2, Active Directory
• BACKUP: Tivoli Storage Manager TSM , NetBackup, CommVault
• LANGUAGES: COBOL, Assembler, PL/SQL, T-SQL, FORTRAN, SAS, ADS/O, RPG-II, BASIC
• STORAGE DEVICES - SAN: EMC, HDS, 3PAR
• SOFTWARE: SMP/E, IBM Utilities, TSO/ISPF, SDSF, FDR, DADS, Hiperstation
• MICROSOFT PRODUCT SUITE: Word, Excel, PowerPoint, Project, Visio