Senior It Consultant Resume
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
Confidential (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
Confidential (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 (a.k.a. Websphere 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.