Peningo Systems,
Inc.
Contact: info@peningo.com
PEN19
WORK EXPERIENCE:
November 1998 -
Present: Client Name Withheld
Perform project based consulting on various Client/Server and Web based systems. Projects have included various infrastructure related planning and implementations. The majority of my clients have been medium-sized businesses that required me to be architect, administrator and developer for creating systems from the ground up. This included platform selection, capacity planning, performance tuning, network integration, data modeling, database design, system integration and full lifecycle development duties.
My list of successful projects include:
DB2 UDB
Contracted to provide DBA support for multiple V7 .2 and V8.1 UDB databases for WebSphere Application Server, WebSphere Portal and EDW systems. Heavily involved in performance tuning, SQL optimization, upgrade activities, and EDW implementation.
DB2
UDB/Websphere/MQSeries
Contracted to provide DBA and Data Architect support for
Windows and Linux databases for development, testing and production
environments. This included physical
design, logical design, performance tuning, SQL optimization, and server
management processes and scripting. The client wa
Siebel CRM Upgrade V6
to V7
Contracted to provide UDB DBA EE support and development working converting a 1200 seat Siebel CRM installation from v6 to v7. This includes converting from UDB v6.1 to v7.2 on AIX. Duties include database tuning, SQL tuning, SQL/PL stored procedures, federated database integration, table and index design and storage management. . Duties included modifying performance parameters and registry items to match Siebel/IBM recommendations, analyzing disk requirements for using an IBM ESS (Shark) storage area network (SAN). Created complex scheduling/monitoring environment to ensure highest level of availability and performance. Coordinated database environment for use in an HACMP fail-over cluster. Heavily involved in Loads/Imports of IBM mainframe data.
PeopleSoft
Upgrade/Conversion
Contracted to provide UDB DBA EEE support and development
work converting PeopleSoft Financials from Oracle to DB2 (V7.2) in an AIX
environment. This included SQL tuning, table and index design, database tuning,
and storage management. Project went live on
Siebel eCRM Project
9/12/01 to 11/16/01 – Blue Cross/Blue Shield of Illinois, Chicago, Il.
Contracted to provide design, implementation and administration (DBA) services for Siebel eCRM on DB2 UDB database running on AIX for a regional Blue Cross organization. Project included a single AIX server to run three instances (Test-Integration/Cycle-User Acceptance/Training) and one production server.
Enterprise Reporting
Project 8/1/01 to 8/31/01 – Vestax, Inc (division of IMG),
Contracted to convert SQLServer DTS packages to IBM SQL scripts and SQL Stored procedures for an Financial Services company in order to migrate the database to DB2 UDB v7.2 on AIX. After the conversion, a DTS process that took nearly 4 hours was reduced to one and a half. In the process of tuning the queries and database to enhance the overall performance I was able to determine index needs (via the Visual Explain tool) and reduce timeron counts by 50 to 75 percent.
Online Banking
Project 4/01 to 6/01 – Keybank,
Hired as UDB DBA to assist in the creation of dynamic web banking application using UDB to store indexed page text and graphics. Duties included data modeling, table design and implementation view, index, security and constraint creation. Created the environment to support JDBC (Websphere integration) and backend interfaces to Lotus Notes workflow application.
Online BillPay
Project 8/00 to 4/01 – First Energy,
Hired as UDB DBA to migrate proof-of-concept online bill paying service (IBM Websphere – UDB) from NT to AIX. Performed migration and established production level services for transaction logging, backup/recovery, and performance monitoring. Provided daily support for troubleshooting SQL statements, file reorgs, and tablespace management. Administered Websphere /UDB on Sun Solaris platform.
e-Commerce Project
11/98 to 8/00 – Arrow International, Inc.,
Hired to create dynamic web e-commerce system based on integrating data between DB2 UDB and an AS/400, Lotus Domino based HR workflow application, Seagate Info based data-warehousing system back ended with DB2 UDB. Duties included UDB backup/recovery, performance monitoring and tuning, data modeling, table design (logical and physical), applying fixpaks, user management and security. Other responsibilities included view and index creation, query optimization, and SQL code review. Tools included Notes DECS (for sharing data between Domino and UDB) and DB2 Connect (for sharing data with the AS/400). Recently performed an upgrade from v5.2 to v7.1 for this client.
One side project included converting a job shop application from Clipper to DB2.
Apr.1997-Nov.1998: Deloitte
Consulting/DRT Systems International,
Managing Consultant
Responsible for the Infrastructure Technology Group. Company duties included technical sales support, project planning, training, business development, and in-house technology maintenance. This included WAN and email integration and migration. Client duties included desktop standardization, SNA server integration for PC to DB2/UDB access, MQSeries implementation, Lotus Notes programming, Websphere and DB2 UDB administration, Network and Operations audits, and interim Client/Server tech support department management (RS/6000 and DB2 UDB) that included installation, configuration and administration of the platform and the RDBMS. Performed several Oracle installs (NT, Novell, Unix) and performed troubleshooting/performance tuning duties.
April 1996 - April 1997: Arrow
International, Inc.,
Technical Services
Manager
Projects included equipping the sales staff with notebook computers along with an electronic catalogue and inventory system I designed and created, and the creation of a Data Warehousing system using VB/Access, Topspeed’s Clarion, Dbase/Clipper, Cognos products and ODBC.
November 1995 - April 1996: Imperial
Wallcoverings, Inc.,
Manager - Network
Administration
Created two-year plan for upgrading LAN, initiating Wide Area Network with plants and distribution centers, and the installation of Lotus Notes for E-mail, database sharing, and sales force automation. I also introduced a computerized incident tracking and help desk system to assist in resolving problems more accurately and efficiently. Recent projects include the creation of a computer-based-training (CBT) lab for office productivity and network application instruction, and the integration of an IBM RS/6000 inventory system with the current AS/400 business systems using Oracle and IBM’s MQSeries transaction messaging middleware.
August 1994 - October 1995: OneNet
ICI,
Management Consultant
Information systems design, programming, integration, and implementation for several clients in the retail, manufacturing, transportation, financial and insurance industries. Systems have included Novell Netware and IBM LANServer network administration and upgrading, enterprise E-mail and Lotus Notes workgroup systems, SCO Unix maintenance and troubleshooting, Microsoft Access database design and programming, Dbase/Clipper 5 programming, and integrating Novell LANs with AS/400 and SCO Unix systems.
April, 1991 - August, 1994:
Systems and Computer Technology, Corp.,
Manager, Technical
Services -
Installation, configuration, administration and training for a growing PC wide area network. Environment includes RS/6000, AIX, Informix database, 4GL development, Novell Netware 4.01, TCP/IP, electronic mail, and workgroup software.
Lead
Programmer/Analyst - Tooele/Wasatch Counties, Tooele and Heber,
Responsible for conversion activities from a Motorola Four Phase system to an IBM AS/400. Designed and coded data file conversion routines for integration with purchased accounting and tax systems using SQL/400, RPGIII and CL. Designed and installed a 50-user Novell network, and integrated system with the AS/400. Designed and coded Motor Vehicle tax system working primarily with ProGen CASE tool for data dictionary and program generation. Designed and coded PC-based property system for public distribution.
System Administrator
-
Online SQL database design, system administration, trouble shooting, and user support. Designed a very successful PELL Grant state-wide applicant tracking system. Integrated Onet with the Internet. Integrated Onet with the in-house Novell network.
May, 1990 - October, 1990: Duramax, Inc.,
MIS Manager
IBM System/38 and AS/400 environment. Complete administrative, technical, and strategic responsibility for corporate MIS activities that included project planning, implementation, user support, and daily operations.
May, 1987 - April, 1990:
The BFGoodrich Company,
Computer
Operations/Technical/PC Specialist
IBM System/38 environment. Duties include complete responsibility for computer operations, security, telecommunications, disaster recovery planning, and hardware/software evaluation. End-user PC configuration, support, Dbase/Clipper programming, and training.
Jun., 1986 - Apr., 1987: Jb Robinson Jewelers, Inc.,
Computer Operations
Manager
IBM System/38 and IBM Series/1 environment. Administrative duties included equipment purchasing, salary administration, work scheduling, and operator training. Technical duties included performance tuning, system configuration, programming, and system security.
Oct., 1983 - June, 1986:
REVCO D.S., INC.,
Computer Operations
Shift Manager
Responsible for the operation and control of a state-of-the-art computer complex involving an IBM 3083 running MVS/XA, Burroughs mainframes, and IBM System/38 minicomputers.
Dec., 1979 - Aug., 1983:
HUNTINGTON BANK,
Computer Operations
Shift Supervisor
Responsible for computer operations, data entry, production control, tape library, and COM lab operations in a Burroughs B4800 data center.
Sep., 1975 - Sep., 1979: UNITED STATES AIR FORCE
Burroughs Computer
Operator
Operated Burroughs Medium Systems mainframes
CERTIFICATIONS: MQSeries System Engineer June 1997
DB2 UDB Administration Nov. 2000
Oracle 8I In Progress
EDUCATION: Total Quality Management (TQM)
Kepner-Tregoe, October, 1993
Problem Analysis/Decision Analysis
Kepner-Tregoe, April, 1986
Associates of Business Degree in Computer Studies.
Graduated June, 1975
SKILLS
HARDWARE:
IBM 43XX, IBM 3083, AS/400, RS/6000, Unisys A Series, Unisys B Series (Burroughs) PC, Apple Macintosh, Routers, Bridges, Hubs, Ethernet, Token Ring, Print servers, Communications
OPERATING SYSTEMS:
MVS/XA, OS/400, AIX, MCP, DOS, Windows 3.x, Windows 95, Windows NT/2000, OS/2, System 7, SCO Unix/Xenix, Netware 3.x-4.x-5.x, IBM Warp Server, MS Lan Manager
COMMUNICATIONS:
TCP/IP, SNMP, SMTP, Telnet, FTP, IPX/SPX, APPC, APPN, SNA, VTAM, RJE, Remote Access, Communications Manager/2, Client Access/400, RUMBA, NetSoft Router
SOFTWARE:
Lotus Notes/Domino v4 and v5, Visual Basic, MS Access, Clarion for Windows, Seagate Info 7, SQLServer 6.5, Pervasive SQL, Btrieve Database, Delphi, Paradox, dBase III, dBase IV, Clipper 5, MS Office Suite, Lotus SmartSuite, Borland Object Pascal, Quattro Pro, Informix 5.5 Informix 4GL, Oracle 7, PL/SQL, RPG III, SYNON, Progen Plus, DB2/2, DB2 UDB EE/EEE, Query/400, VX-REXX, Visual Age for Basic, Visual Age for Java, Groupwise 4, Novell MHS, MQSeries (AS/400, RS/6000, Windows NT), Windows API, PC Anywhere, Close UP, Procomm Plus, MS Project, Scitor Project Scheduler 6, Visio Pro 5, ABT Project Workbench/Team Workbench, Microsoft ASP, Cisco PIX.
OTHER:
Yourdon Systems Method, Project Planning, Project Management, System Analysis and Design, Leadership Skills, TQM, PC and LAN Security, Object Oriented Development, Configuration Management, Technical Writing
AFFILIATIONS:
Member – Greater
IBM Partner in Development
Lotus Development Partner