We provide IT Staff Augmentation Services!

Senior It Consultant Resume

2.00/5 (Submit Your Rating)

UsA

Professional Certifications:
IBM Advanced DB2 DBA for LINUX, UNIX, and Windows
IBM DB2 DBA for Z/OS
IBM COBOL/CICS Applications Developer
IBM AIX System Administrator
PMI Project Management Professional

Formal Training:

Database Management Systems
Structured Systems Design
Structured Systems Analysis
Systems Analysis & Design
Principles of Economics (Macro & Micro)
Principles of Accounting
COBOL Programming
Advanced COBOL Programming
CICS Programming
JCL Programming
Small Business Computing
FORTRAN Programming
C Language Programming on VAX/VMS system
Practice of Management
Database Programming Development
Decision Support Systems
Distributed Data Processing
Software & Hardware Concepts

Other pertinent training:

Websphere Commerce
Oracle 10g/11g Database Admnistration
Micsosoft SQL Server 2000/2005
Microsoft Project, Microsoft Visio
Microsoft Word, Microsoft Excel, 
Microsoft Access, Microsoft Publisher
Microsoft Powerpoint
Microsoft A+ Fundamentals
Microsoft Net+ Fundamentals
Microsoft Windows NT Administration
XML Database Storage
Object-oriented Software Engineering
IBM Fundamentals of DataWarehousing and Business Intelligence for Knowledge Management
BMC Utilities, CA UniCenter
FileAid/AbendAid
DB2 SQL Workshop/DB2 Advanced SQL
DB2 Family Fundamentals
DB2 Stored Procedures Programming
DB2 Content Manager
DB2 Database Administration
DB2 Advanced Database Administration
DB2 Content/Records Manager
Lotus Notes Basic
Lotus Notes Application Development
Lotus Domino Server Administration
Intro to Local Area Networking
Data Modeling with ErWin
Data Mining
Data Warehousing 
EPIC Medical Systems Cache Relational Database
AIX System Administration
LINUX System Administration
UNIX Fundamentals
Informatica Power Center
Cognos Powerplay
Microstrategy
Ab Initio
Teradata
IBM VSAM File Structures
Rational Data Architect, RUP
Tivoli Storage Manager
Websphere Application Server
Websphere MQ
MySql/PHP
TOAD for DB2
Quest Central
Spotlight for DB2

Professional Background

2006 present
Confidential
Senior IT Consultant - Business Intelligence/Data Warehousing Consultant/Analytical Data Modeling
This position encompasses the time after I retired from Seaboard and took time off in between. I have summarized my tenure here. The complete details are listed, below. This was a continuation of the work I was performing at Seaboard after the company was sold. This position concentrates on the modeling, construction, and maintenance of large-scale data warehouses based on the Kimball/IBM design principles and re-designing standard relational database models into dimensional models used for OLAP/BI purposes.

  • DB2 DBA for Z/OS, Solaris, Linux, UNIX, and Windows
  • Cube/Dimensional design and development
  • Testing all BI/TSQL queries for accuracy on SQL Server and Oracle
  • Development of OLAP cubes, star schemas, and data marts
  • Data Warehouse/Data Mining development
  • Analytical/Statistical data modeling
  • ETL Management
  • Analytical reporting management
  • Designing and implementing database system security protocols
  • Applications performance enhancement
  • Database performance and tuning expert
  • Disaster recovery planning and verification
  • Backup and recovery planning and verification
  • 3rd party vendor product evaluation and verification
  • Help Desk management

Wright & Associates (2006 - present) Completed projects

10/2007 - present
As the senior DB2 DBA/Consultant for the Infrastructure Support Group at the Internal Revenue Service, my duties are to provide senior-level DB2 database administration strategies to the Enterprise Operations management. Currently, I provide strategic support for V8 and V9 of DB2 UDB as well as serve as an advisor to production support on performance enhancements to the existing systems. Installation and maintenance of DB2 UDB V9.5 for Windows and AIX platforms as well as DB2 Data Studio and DB2 Management Console products. This includes research on DB2 products to enhance production support, planning disaster recovery strategy, failover configuration, review and recommend changes to existing database systems, and testing of new DB2 versions to deploy in the common operating environment. I am leading the effort to develop and deploy a High Availability Disaster Recovery (HADR) system for the IRS DB2 systems on middle-tier servers. I am also leading the testing of new DB2 database versions to be deployed in the Common Operating Environment (COE). Also, evaluate performance of JAVA applications interfacing to databases. Use of SQL Server 2005/2008 as well as Oracle 10g databases

01/2006 - 09/2007
A Senior Manager and DB2 Database Administrator on the SecureFlight project with the Transportation Security Administration holding a SECRET CLEARANCE. This is a DB2 database system spread over 40 servers utilizing a 20-terabyte IBM Shark Storage system. The servers are both AIX and Windows Server platforms and include Tivoli and Rational databases. Duties include all facets of database administration, data modeling, data security protocols, database auditing procedures, performance monitoring/tuning, installation of IBM fixpaks, and implementing structural changes to the environment. Rollout of DB2 V9 to implement use of XML in data exchange.

1974 2004 (retired)
Confidential
President/CEO IBM Business Partner

This position encompasses a 30-year period after I graduated from IBM Business Management school in 1973. I have summarized, below, the highlights of my tenure.

  • Management of a 60-employee IBM software development staff for 20 years, including the following software teams; Database Management, Applications Development, Systems Programming, Network Administration, and Corporate Administration
  • Hire, train, motivate, and mentor employees
  • Senior Computer Scientist for CSC
  • V.P. for business development for 10 years
  • Senior executive for 20 years
  • Managed the Software Development Life Cycle (SDLC)
  • Implemented SOA architecture based on ITIL principles
  • CMMI/Six Sigma/Scrum/Agile methodologies
  • Some familiarity with Federal Segment Architecture Methodology (FSAM)
  • 20 years senior executive management experience of a IBM firm
  • 35 years mainframe experience
  • Certified Advanced IBM DB2 DBA for LINUX, UNIX, and Windows
  • Oracle and SQL Server experience
  • Logical/Physical data/database design
  • 30 years Database management/Data Warehousing experience
  • 30 years DBA experience
  • 30 years applications development experience
  • Project Management Professional (PMP)
  • Expert Data Management experience
  • Federal and State government experience
  • Health insurance experience with Kaiser Permanente and Blue Cross
  • Property/Casualty insurance experience with Zurich Insurance
  • Database Server Access control and audit procedures
  • Commercial insurance and banking experience
  • DB2 programming instructor at Blue Cross
  • COBOL programming instructor at Anne Arundel Community College and Strayer University
  • Systems analysis and design instructor at Strayer University
  • 25 years experience as a mainframe COBOL/DB2 applications developer
  • Non-profit experience

Seaboard Systems (1974 - 2004) completed projects

01/2004 - 12/2004
Management of a DBA team supporting IBM Global Services clients. Providing data modeling, database administration, and application DBA support for multiple client sites for 4 years. Supported electrical component and garment manufacturers as a DBA and senior programmer/analyst. This environment was an IBM DOS/VSE and OS/390 environment utilizing both IMS and DB2. Re-engineering databases consisting of image, text, sound, and graphics data types for DB2 platform to work across a multi-platform environment.

01/2003 - 12/2003
Director of Database Architecture for Zurich Insurance Company North American operations. Directly managing database administration staff of 10 for all of insurance company database architecture/administration supporting entire insurance application spectrum. This data warehouse environment consisted of DB2 on Z/OS, DB2 UDB on Windows, and SQL Server 2000 on Windows. Also, consisted of using Quest software to manage all of the database environments from a common client interface on desktop machines.

01/2002 - 12/2002
Manager of the Mid-Atlantic Data Warehouse operations for Kaiser Permanente and an IBM-Certified Data Management expert and senior DBA managing a team of Oracle, Sybase, and DB2 DBAs. Implementation of EPIC Medical Systems (CLARITY, CHRONICALS) using Intersystems Cache relational database and web-ready development system in a MUMPS programming environment. Use of Kimball Data Warehouse principles in design of data warehouses. Implementing the ICD-10 format into our existing data structures and conversion of existing data to ICD-10 format. Managing all day-to-day production. This included developing web-based applications utilizing Cache Object-Oriented Database utilities. Instructor for use of Cache Object Script for programming. These data warehouses are in excess of 5 terabytes in size. Managed data warehouse staff for development and designed/performed ETL services, using Informatica, Cognos, and Ab Initio, to support the data warehouse and business partners for medical reporting. Worked directly with clinical and membership business partners to develop customized healthcare reporting systems. Third-party data reporting supported both HCFA/CMS data reporting and HHS functions. Developed system to feed systematic data to Johns Hopkins for the purpose of identifying potential serious disease outbreaks. The environment contained federated databases that included DB2, Oracle, Sybase, and SQL Server 2000. I became certified in HIPAA compliance measures during this tenure.

01/2002 - 12/2002
Remote DB2 DBA on OS/390, Windows, AIX, LINUX, and Solaris operating systems. DBA on Oracle, Sybase, and SQL Server 2000. Completed AIX Systems Administration training modules. Completed Lotus Notes/Domino administration and developer courses. Completed both A+ and Net+ training from the State of Maryland. Microsoft Office 2000 trainer. COBOL/DB2 programming instructor for Blue/Cross and Medicare consultants.

01/2001 - 12/2001
Implementing Peoplesoft database structure on a DB2 database in an IBM S/390 environment. This involved a 3-tier environment using DB2 Connect on a second tier tied to a back-end mainframe DB2 database repository for a large commercial manufacturing operating many satellite production operations utilizing AS/400 I-series platforms tied back to the mainframe system.

01/2000 - 12/2000
Mentoring junior database administrators and data architects in design, deployment, and performance issues. Providing Level II remote DBA support for IBM clients across the United States. Developing JAVA-based web mall for DOD contractor utilizing IBM e-commerce product Net.Commerce. This provides a server-based suite of applications for Internet business web sites. Use of Zachman Enterprise framework process to implement automated systems within DOD.

01/1999 12/1999
Installation and configuration of IBM Net.Commerce , for the Pentagon. This entailed designing databases for the Commerce product and deploying models across the enterprise. It also involved a complete review of the JAVA applications involved in maintaining the Commerce website used in a “Web mall” fashion.

01/1998 - 12/1998
Designer of CADE DB2 database for the IRS. Designed and deployed the CADE DB2 UDB database on IBM ESS Shark storage systems. Managed integration of JAVA application programs into this system. Advised prime contractor as to monitoring and performance tools needed for production environment.

01/1997 - 12/1997
Senior DB2 DBA at the Centers for Medicare and Medicare Services (CMS) and the Social Security Administration. Installation of IBM’s Content Manager at the Social Security Administration.

01/1996 - 12/1996
Served as the Director of EDP Audits for the State of Maryland, Office of the Inspector General at the Department of Human Resources. This agency administers all social services and human resource programs for the State of Maryland.

01/1993 - 12/1995
I was the CIO for a nationwide non-profit government-funded organization providing financial services for under-served areas of the United States. These duties involved management of all facets of the data processing infrastructure including: procurement of IT hardware/software/services; design of internal database structure; implementing end-user services; maintenance of vendor contracts.

10/1990 - 12/1992
Classroom instructor at Anne Arundel Community College and Strayer University in the COBOL programming, structured systems analysis and design, and DB2 database programming. Conducted DB2 applications training for Blue Cross/Blue Shield of Pennsylvania. Conducted mainframe programming classes for the State of Maryland to include JCL, IBM Utility programs, CICS, and job entry subsystems(JES).

01/1990 09/1990
Senior Programmer/Analyst at the State of Maryland. Specifically, using the IBM Cross System Product (CSP) for COBOL code generation supporting the Maryland Unemployment Insurance (UI) system. Also, expereience as a senior integrator of the RSTARS system at the State of Maryland.

01/1987 - 12/1989
Deputy Director at the State of Maryland Department of the Health and Mental Hygiene, Environmental Programs. This contract involved the planning, organizing, and directing the design and implementation of a new data center. It involved the development of a standardized approach and creation of an infrastructure for providing IT services to a new state agency, the Department of the Environment. It also involved the recruting, hiring, and training of the necessary IT personnel to provide IT services to the agency. I was awarded State of Maryland Merit Achievement Award for IT management achievement by the secretary of the agency, the top civilian honor bestowed by State.

01/1985 - 12/1986
Adjunct professor for a non-profit agency of the United Way of Central Maryland. This was to develop and implement a classroom and laboratory environment to conduct training in Microsoft Office techniques utilizing Microsoft Word and Microsoft Excel. This project was to assist members in transitioning to newly-created white collar positions in local industry.

01/1983 - 12/1984
I was a senior Programmer/analyst, DB2 DBA, and Micro Focus COBOL instructor for CitiBank. This included development of financial systems to service the commercial lending operations. Also, was Micro Focus instructor for same division training other developers in usage of Micro Focus products to develop mainframe applications.

01/1981 - 12/1982
IT Manager for XDB Systems, a IBM DB2 research and development firm providing software development platforms for client environments that utilize COBOL/CICS/DB2 development. This company was acquired by Micro Focus and their products integrated into the Micro Focus development platform.

01/1978 - 12/1980
Director of IT for a local direct marketing firm. This position included Windows NT administration, applications development, and data center management. It also employed mailing software such as Mail Manager and AccuMail from Group 1 software.

07/1973 - 12/1977
Senior Programmer/Analyst in two different manufacturing environments. One was in the food processing business and the other was in the manufacturing of mens and womens clothing. These were IBM mainframe environments and using COBOL/CICS for development.

We'd love your feedback!