xwebi

William A.Phillips___________________ Summary • Over 8 years of experience as a project lead on systems from 2 people to 25 people • Over 12 years of experience as a Database/Systems Administrator on IBM mainframes in DB2, IMS DB/DC, Datacom, ADABAS, CICS, and Work stations UDB, SQL2000, ORACLE • Over 15 years of COBOL, IMS, and DB2/UDB Analysis and development • Proficient in WINDOWS, DOS, AIX, MAC OS, UDB, DB2 Connect, SQL2000, Windows 2000, HASM, HTML, PERL, PHP, JAVA, VB, C++, C#, .NET, WEBSPHERE, ECLIPSE • Senior level in project lead, application, systems, and Database design Technical Skills Languages: COBOL, SQL, JCL, EZTREV, PASCAL, HASM, C++, JAVA/ SERVLETS, VB, C#, .NET, HTML, Javascript, Perl, PHP, Clist, ISPF Dialogue, REXX, CLIST, PASCAL, ECLIPSE Environment: MVS, S390, VM, VAX, Windows 2000 (server), IBM PC Compatibles, AIX, RS6000, MAC Databases: IMS, DB2, UDB, SQL2000, ORACLE, DATACOM, ADABAS Tools/Applications: ERWIN, DB2 FILE AID, IMS DB/DC/BMP, CICS, JCL, VSAM, QMF, TELON, CSP, NETRON, SPUFI, MFC, XPEDITER, BMC, MFS, BMS, FILEAID, STROBE, INTUNE, CHANGEMAN, OMEGAMON, PANVALET, AIX, DB2 Connect, Move for DB2, WEBSPHERE, Mercury Test Director Education/Training/Certification • Associate degree in Pre-Engineering, Lincoln Land Community College, Springfield, IL • Accumulated over 100 hours toward Electrical Engineering degree at SIU, Carbondale, IL • JAVA Lincoln Land Community College, Springfield, IL • IBM UDB Certified Solutions Expert at Novanis, Springfield, IL • DB2 programming and database design Certified at Lomas and Nettleton • COBOL, VSAM, and IMS Advanced certified with State of Illinois Professional Experience Client: BANK ONE/JPMC - FTE Project: STARBASE Period: MAR 2003 - Present Environment: S390, MVS, COBOL II, DB2, CICS, MQSeries, JCL, XPEDITER, TSO/ISPF, CHANGEMAN Description: Worked on Starbase Financial profile system in DB2/COBOL/ CICS/MQ Series. Responsibilities: • Was instrumental in design and analysis on Data Integrity team in solving several major synchronization issues • Designed and built VB and C# grid data connectivity applications for MS SQL and DB2 • Managed consultants on LSII and Anti money laundering projects • Tech Lead on ODS auditing and enhancement project with 3 other developers • Assist in design meetings in effort for Merger readiness systems • Co-designed DB2 commit restart module with DB2 DBA technician Client: MasterCard St. Louis, MO - Consultant Project: Clearing and Processor Card upgrade Period: NOV 2002 – Mar 2003 Environment: S390, MVS, COBOL II, DB2/UDB, QMF, VB, DB2 Direct Connect, Stored Procedures, JCL, XPEDITER, TSO/ISPF, VSAM, Mercury Test Director Description: On the mainframe UDB Stored Procedures design and development team. The system is an upgrade of current IMS technology. The new design will run with a Visual Basic front end and access mainframe UDB. Stored procedures contain multiple join queries with a staging database for updates. Responsibilities: • Appointed System Subject Matter Expert to lead design and guide development • Mentored other developers with SQL and program designs • Represented MPS development in geological requirements meetings • Represented MPS in Tandem/VM systems integration design meetings • Designed and wrote VB Stored Procedure testing tool for multiple procedures with lists • Assisted with Analysis, modeling, and design of new database designs for MPS • Analysis and design of new DB2/COBOL Stored Procedures and VB applications • Test the programs using QMF for Windows, VB, C#, DB2 Direct Connect, and XPEDITER Client: ADM, Decatur, IL - Consultant Project: Grain Commodity System upgrade Period: May 2002 – Sept 2002 Environment: S390, MVS, COBOL II, IMS DB/DC, CICS, DB2, NETRON, JCL, XPEDITER, TSO/ISPF, VSAM, VAX Description: Truck, rail, barge, and vessel grain purchasing and selling system used through out the world. The main part of the system is on an IBM mainframe running IMS/DB/DC with some VAX. It consists of various contract purchasing and selling arrangements as well as distribution tracking of shipments. Responsibilities: • Analysis and design of new auditing databases • Develop new online and batch COBOL II, NETRON, IMS, DB2 applications • Test the programs using XPEDITER • Create new PSB's, DBD's with online automated system • Recently completed online auditing system to alert users of contract changes Client: Wisconsin Department of Employee Relations - Consultant Project: Employee Testing system Period: Sep 2001 - Feb 2002 Environment: S390, MVS, COBOL II, CICS, DB2, JCL, Omegamon, TSO/ISPF, UDB, Platinum, SQL2000 Description: The Employee Testing System consisted of many CoolGen, HTML, ASP applications running on servers but accessing mainframe DB2. The new system was designed to use both DB2 and SQL2000 using web forms. Volume was several million rows on larger tables. Responsibilities: • Developer and mentor for DB2 mainframe Employee Testing System • Mentored new DBA candidate for Support of DB2, COBOL, SQL2000, UDB systems • DBA lead for IEF/DB2/SQL2000 design and performance • Attend design meetings for new SQL2000 and web forms testing system • Assisted in installation of UDB Client: Illinois Department of Public Aid - Consultant Project: Maintain and enhance existing KIDS and Medical Systems Period: Aug1998 - Apr2001 Environment: S390, MVS, COBOL II, IMS DB/DC, DB2, JCL, XPEDITER, TSO/ISPF, UDB, Perl, AIX, BMC, SQL2000, Panvalet Description: The KIDS system was a high visibility Federal project for tracking delinquent parents and collecting child care monies. It consisted of several hundred online programs and many batch/BMP programs. The medical system was primarily a mainframe IMS DB/DC system with some S390 DB2, AIX, and UDB. Volume was reaching over 100 million rows on larger IMS databases so we partitioned in to 3 to 6 partitions and also partitioned the indexes. Systems had 1000 programs plus. Responsibilities: • Attend HIPPA design meetings representing Tech Services Department • Tutored 4 technicians on new tools and design techniques • Worked with IBM and Illinois Data Center personnel to solve index RBA problem with IMS index partitions • Set up backup and recovery procedures for IMS and DB2 databases • Worked with Bool and Babbage with INTUNE DB2 monitor to install and tune • Use ERWIN to design new DB2 tables • Implement NEON/IBM IMS database Partitioning • Work with consultant installing AIX/UDB for consistency with DB2 • Design and develop AIX/Perl DBD:DBI and DB2/UDB WEB abbreviation lookup Client: Illinois Central Management Systems - Consultant Project: Employee Insurance System Period: Jul 1997 - Jun 1998 Environment: S390, MVS, COBOL II, IMS DB/DC, DB2, QMF, JCL, XPEDITER, BTS, TSO/ISPF, Panvalet Description: The Illinois insurance system was a large system originally written for IMS DB/DC and was slowly being re-written for both IMS DB/DC/DB2. It consisted of tracking employee deductions as well as payouts and contained various complex calculation modules. 10+ million rows. System had 400 programs plus. Responsibilities: • Tech DB2/DBA application lead mentoring other developers (25) • Met various LOB’s with Development managers to get development requirements for insurance rate calculation system • Assist other programmers with IMS and DB2 data access and tuning queries Client: New England Electric Systems, Westboro, MA - Consultant Project: ISI Payroll and HRMS System Period: Dec 1996 - Jun 1997 Environment: S390, MVS, COBOL II, CICS, DB2, QMF, JCL, Xpediter, BTS, TSO/ISPF, EDI, Panvalet Description: The ISI Payroll System is a purchased software package that is a complete large corporation payroll and human resource system. In many cases, like at New England Electric Service, it requires extensive enhancements to fit the corporation’s business rules. There were many interfaces to People Soft accounting packages also. 25 million rows. Responsibilities: • Analysis of finance user requirements for enhancements • Worked with development analyst to get Sr payroll requirements for major system redesign • Work with financial institutions to finalize EDI transfer design • Design new COBOL and DB2 applications for online transfer of ACH payment information Client: MBNA, Dallas, TX - Consultant Project: DB2 Credit Card conversion Period: Apr 1996 - Nov 1996 Environment: S390, MVS, COBOL II/370, DB2, CICS, QMF, JCL, Strobe, Xpediter, TSO/ISPF, Panvalet Description: The Credit Card system was made up primarily of twenty four large VSAM files that were accessed through a common module that sent the queries to the right file. We converted these VSAM files to DB2 tables, some as large as 200 million rows. Responsibilities: • Attended months of design reviews with IBM team for accurate data conversion • Met with assistant CIO from Baltimore on many occasions about progress • Member of five person special team to design conversion effort of all credit cards from VSAM to DB2 • Met with system staff about tuning computer for conversion run • Met with managers of various departments for requirements • Managed development team conversion effort with 3 other developers and 2 documentation specialists • Tech lead on DB2 design, conversion, and system tuning effort • Ran multiple tests of programs and BMC utilities for accuracy in conversion • Set up Referential Integrity and data check jobs and tested for conversion Client: Sears, Mexico City, Mexico - Consultant Project: Price Waterhouse Payroll and Inventory enhancement Period: Aug 1995 - Apr 1996 Environment: S390, MVS, COBOL II, DB2, CICS, QMF, JCL, INTERTEST, TSO/ISPF Description: The Inventory and Payroll system was a complete system that had to be enhanced to fit the way Sears did business. It included employee time tracking, payroll distribution, inventory SKU number tracking, etc. Responsibilities: • Was brought in to replace existing CSP/DB2 Administrator for Price Waterhouse • Lead 15 developers on installation and enhancement of payroll/retail system • Managed installation upgrades of DB2 with system staff • Managing consultant to 5 system staff with OS390/DB2 to align system configuration Client: Sara Lee Knit Products, Winston-Salem, NC - Consultant Project: ISI Payroll and Inventory enhancement Period: Oct 1990 - Aug 1995 Environment: S390, MVS, COBOL II, Datacom, DB2, ORACLE, CICS, QMF, JCL, INTERTEST, TSO/ISPF, Panvalet Description: The ISI payroll and Human Resource software had to be enhanced to be in accordance with the law and Sara Lee’s Business rules. There were many Datacom inventory files that had to be converted to DB2. There were many enhancements documented by users that had to be made including interfacing with existing VSAM inventory files. Responsibilities: • Managed 3 developers on new time keeping enhancements • Install new releases DB2 and payroll system with referential Integrity • Design and load ORACLE databases for server warehouse access • Worked with ESS (Essbase) warehouse database • Attended Board meetings as advocate to discuss bundling technology • Was instrumental in solving SKU number discrepancy saving $4 million a day • Design and develop programs to convert Datacom databases to DB2 • Design and develop new COBOL, CSP, DB2 program repository system • Support developers with design and tuning issues • Client: Partners National Health Plans, Dallas, TX - Consultant Project: Data warehousing development Period: Oct 1988 - Aug 1990 Environment: S390, MVS, COBOL II, VM/SQL/DS, DB2, CICS, QMF, JCL, TSO/ISPF, PICK, HASM, Roscoe, Panvalet Description: The Decision Support database(s) was a repository of health plans and participants that were collected by various agents, most of which had been collected on a VM/PICK operating system. In process was a plan to move to SQL/DS and then to MVS/DB2. Responsibilities: • Tech Lead for 8 developers on VM/CSP/COBOL/DB2 systems • Install MVS/DB2 and convert SQL/DS data to MVS/DB2 format for the Decision Support system • DBA Manager of two other JR DBA’s • Represented System/DBA group at Board meetings to discuss new designs to convert from PIC system • Managed Production Control staff (4 people) on new MVS under VM system • Gave seminar to board on possible conversion to MVS/DB2 • Lead on installing and tuning new mainframe computer system at IBM for partners delivery with 4 other systems people and DBA’s • Met with IBM staff on regular basis for system upgrades Client: IBM, Kansas City, MO - Consultant Project: CSP/DB2 SRA education Period: May 1988 - Oct 1988 Environment: S390, MVS, CSP, DB2, TSO/ISPF Description: The project consisted of writing education scripts for IMS/DB2 and CSP for the SRA Education series. Responsibilities: • Wrote SRA Education series for IMS/DB2 and CSP version 3.2 • Educated junior members about CSP and IMS/DB2 Client: Lomas and Nettleton, Dallas, TX - FTE Project: Mortgage loan Investor Commitment Period: May 1986 - May 1988 Environment: S390, MVS, COBOL II, TELON, IMS DB/DC , DB2, CSP, BMC, XPEDITER, INTERTEST, BTS, TSO/ISPF, Panvalet, DB2 MAUI Description: IMS DB DC and CICS, DB2 Mortgage Loan Investor Commitment System consisted of many online and batch programs which captured Mortgage Loans and could package many loans into Commitments which could be sold to investors. The system operation involved scanning through loans to find fits according to specified criteria. The system was originally developed in IMS/DB/DC/TELON and later we re-wrote it in DB2/CICS/CSP. Responsibilities: • Represented System/development group in JAD sessions for seven months to design new mortgage loan system with IBM and upper management • Met with IBM DB2 experts on several occasions to verify designs • Managed development of new CICS/CSP/DB2 architecture system with 15 other developers and three DBA’s, tracking projects and hours • Design lead with IBM on CICS/CSP/DB2 architecture and security design for the system • Technical lead, designer, DBA on architecture and security system • Attend meetings with management (CIO) at IBM in Cary, NC for beta enhancements of DB2 • Appointed by CIO to help systems group to debug initial system problems with CICS/DB2/CSP Client: ARCO, Dallas, TX - Consultant Project: Automated Parts Inventory System Period: Nov 1985 - May 1986 Environment: S390, MVS, COBOL, IMS DB/DC, BTS, TSO/ISPF Description: The current system consisted of a parts inventory IMS database in which each part was assigned a number. The enhancement to automate included online screens to assign each part a target number of hours of operation before various batch programs sent an alert (report) to inspect the part for maintenance or replacement. Responsibilities: • Lead another developer on new designs • Design the new Automated Parts Database • Design and developed many COBOL and IMS online and batch applications • Attended meetings and phone conversations for requirements from users in Alaska Client: Wisconsin Board of Higher Education - Consultant Project: College Loan Assistance Program Period: Jun 1983 - Nov 1985 Environment: S390, MVS, COBOL, IMS DB/DC, BTS, TSO/ISPF Description: The College Loan Assistance System consisted of IMS online and batch applications. It tracked prospective individuals for loan approvals and tracked the disbursement of loan amounts as well as repayments. Responsibilities: • Design and developed many COBOL and IMS online and batch applications • Attended meetings for requirements Client: Illinois Department of Children and Family Services - FTE Project: Foster Care Payment and Receivables System Period: Jan 1979 - Jun 1983 Environment: S390, MVS, COBOL, IMS DB/DC, BTS, TSO/ISPF Description: The system consisted of many online IMS applications as well as batch calculation and update applications. It updated and reported foster care payments as well as wrote the checks. It also interfaced with the Child Abuse System which tracked abuse cases twenty four hours a day. Instituted checkpoint restart for BMP processing in the shop. Responsibilities: • Design the new IMS payments and receivables databases and associated PSB’s and DBD's • Institute first BMP’s with checkpoint restart for the shop and lead design for others • Write screen painting software to ease in matching COBOL screen segments with MFS • Attend design meetings • Setup backup and recovery procedures for databases • Design and develop many COBOL, IMS online, batch, and BMP applications • Develop new COBOL and IMS DB/DC programs for the Child Abuse System Client: Illinois Department of Public Health - FTE Project: Death Records, Employee Time, and WIC Programs Period: Jun 1977 - Jan 1979 Environment: S390, MVS, COBOL, IMS DB/DC, VSAM, BTS, TSO/ISPF Description: The system consisted of several online VSAM/CICS applications as well as many batch update applications. The applications systems updated and reported Death records, and WIC support services. Responsibilities: • Design the new Employee Time databases and associated PSB’s • Maintain WIC batch programs • Attend design meetings using Warnier Orr • Design and develop many COBOL and IMS batch applications Other Experience • RS6000 with AIX 5.1 and enterprise UDB 7.1 that I have installed and operated • Windows 2000 server with SQL2000 and UDB using ASP/C# web services • I have installed Visual Age for Java and WEBSPHERE and developed some JAVA SERVLETS • I have done VB and C# web applications with stored procedures using ASP/XML on Windows 2000 server • I have done PHP/HTML/MYSQL web applications in object oriented design • Eclipse familiarity