Summary

• Charles is a Professional/Technology Services provider in:
• DB2 zOS Performance/Scalability - Architecture/Tuning/Re-Engineering
• Enterprise Application Modernization - SOA/DB2/CICS/MQ Server/Services
• Legacy Systems Integration/Migration to Distributed Java/Unix/Web platforms.
• A dynamic, high-energy solution provider and high-impact technical resource in strategic enterprise projects, with over thirty-five years of broad-based experience in the Information Technology industry, primarily in systems analysis, application development, database architecture, and project management. This includes over30 years of experience in the systems consulting arena, 24 as an independent contractor and another 7 years as Consulting IT Architect with IBM. Has delivered systems integration and database solutions for the manufacturing, distribution, pharmaceutical, telecommunication, transportation, healthcare, and publishing industries. Has delivered data warehouse and large database solutions for ERP, CRM, and integrated Supply Chain applications on multi-tiered platforms. A pro-active and dedicated agent-of-change, facilitating the technological and cultural changes necessary to promote the integration and assimilation of legacy and emerging technologies.

Specialties include:

Relational database architecture

• data analysis, normalization, data modeling, logical/physical design
• performance tuning, data warehouse design

Project management technical/team leadership: team building, JRP, JAD, RAD, coach, mentor

Strong technical skills

DB2 Data Architect, DBA, CICS, zOS/MVS, VM/VSE

Application Development

COBOL, REXX, PL/1, MySQL/PHP

Data Base Systems

DB2 v8, 9, 10 for zOS, AIX, VM/VSE IMS/DLI,

Middleware tools

MQ Series, WebSphere, WebServices

Service Oriented Architecture SOA

Experience

DB2/zOS Solution/Data Architect, Engineer, DBA, Developer, Performance Tuning

Confidential

• Hands-On, Make IT Happen IT Contract/Consulting or Full-Time positions, specializing in
• DB2/zOS Performance/Scalability/Tuning, SOA/Mainframe Modernization, Integration/ Migration to Distributed Java/Unix/Web platforms -- Web Enablement, Web Services, Application Integration, Service Oriented Architecture -- Mainframe DB2 Server/Services, CICS/MQ Messaging -- Application/Database/Data Warehouse Architecture/Development -- Architect/Technical Team Lead -- Coaching, Mentoring, Team-Building..-- Providing innovative technical solutions to client business/technology problems

Recently provided Data/Solution Architect, Database Re-Engineering, Scalability/ Confidential

Provided DB2 Application/Database Architect, Engineer, Data Modeling support in design, development, implementation of track-side scanning devices/systems for detecting/reporting heat/air pressure anomalies in rolling stock wheel/ axle/bearing/brake sub-systems, and integrating with legacy bar-code scanning systems. Relied on years of railroad operations experience in my early IT career 1960s .

Confidential

Design/DB Engineering/DBA services and DB2 database re-engineering to support ACA/Obama-care Federally Mandated upgrades to legacy mainstream healthcare systems as a contractor to IBM.

Confidential

Design/Engineering, Development, Performance Tuning, Administration for Master Data Management implementation at Medicare..

Also provided solutions as an independent contractor/consultant to the following clients:

Confidential

Modernize, Migrate, Integrate legacy Customer Service/Operations systems from mainframe to GUI/Web front end, upgrading back end DB2 database server/services to SOA technology.

Confidential

SSA/CMMS Medicare in Baltimore/Woodlawn, MD -- Contingency position on hold for the entire period due to Federal contract funding issues no work done, no income accrued..

Confidential

Provided Data Architect/Data Modeling services for implementation of Basel II Accords across Enterprise System Architecture, as well as supporting other Operational Data Store systems architecture.

Confidential

Provided assessment/recommendations for existing DB2 Claims database/applications to improve Performance/Scalability prior to major upgrade and for new Benefits/Claims database modeling/re-design. Cognos BI.

Confidential

As DB2 Performance Architect/Engineer on a government contract with USPS, consulted on their Postal Tracking System for high-volume certified/registered/Express mail logistics. Was the primary technical contributor, producing Performance Assessment/Recommendations report, which was highly acclaimed by HP Consulting prime contractor. Due to Federal funding issues, USPS could not implement the recommendations before their Christmas Rush overload.

Confidential

As sole mainframe support resource and SOA services developer/consultant for Global Event Management System GEMS development project, integrated mainframe DB2/IMS systems into SOA data services and messaging migrating EDI/XML container/shipping logistics/tracking applications to Unix/Web platforms.

Confidential

As DB2 Technical Team Lead/Project Management Liaison for a team of 16 contract DB2 Technical Developers/DBAs, provided project coordination/ liaison to multiple Off-Shore development teams.

Confidential

Provided consulting, project management, technical team lead, DBA, IT Architect, Performance Tuning, and various technical, programming, Cognos BI services to the following IBM clients:

Confidential

October 2006 August 2007 11 months Provided DB2 Performance Monitoring/Tuning of Claims Processing systems subsequent to upgrade from DB2 v7 to DB2 v8. REBINDs with changed parameters , Cognos BI.

Confidential

Installed, configured DB2 LUW and associated middleware/ETL on AIX platform for BI/DW/CRM development designed/built-out/ provisioned CRM Data Warehouse for off-shoring GM Customer Relationship Management JAD sessions. Trained in MySQL/PHP Scripting to enable SQL/Relational DB access/ interface for Web-based HTML pages, but provided DBA support only as hands-on , troubleshooting developer problems.

Confidential

Implemented Debt Manager Recoveries System, a COBOL/DB2 product converting from HP 3000 platform. Re-wrote poor-performing Ab Initio ETL conversion processes in zOS COBOL/DB2. Became known as Master of the 15-minute DB2/COBOL conversion program . Authored a UAT-to-Production database migration process, later approvingly known to end-users as The Chuck System . JAD sessions.

Confidential

As Technical Project/Team Led 16 IBM FTEs , provided DB2/IMS DC development/integration of multi-region, multi-LOB/silo insurance CRM applications. Responsible for integrating database design, application system/program design. JAD sessions.

Confidential

Provided Data Warehouse modeling, logical/physical design of US Mint Retail CRM operations.

Confidential

As an independent consultant for 17 years est. 1983, LLC 1993 , provided consulting, project management, technical team lead, DBA, IT Architect, Performance Tuning, various technical/programming services to the following clients:

Confidential

Implemented a complete soup to nuts DB2 DBA infrastructure in a startup DB2 installation for a gift catalog sales and distribution firm.

Provided DB2 DBA consulting, planning, and training. Trained e new DB2 DBA.

Assisted and mentored the development team in COBOL, DB2, CICS on VM/VSE z-Series, with WebSphere interface to Web apps.

Confidential

Managed multiple project teams in Y2K remediation, testing of SAP, DB2, mainframe and client/server applications for a national consumer paper products manufacturer JAD sessions

Provided complete analysis of COBOL Y2K remediation on zOS and i-Series platforms..

Confidential

• Worked as DB2 database admin, carrying out performance tuning, analysis, design, development for child support enforcement system at the Department of Social Services.
• Handled development, maintenance, and performance tuning of COBOL/DB2/CICS applications.

Confidential

Provided DB2/CICS technical consulting, analysis, design, and software integration of securities commission applications for leading securities/financial services firm using COBOL, DB2, CICS.

Confidential

Designed and developed middleware database solutions in sales force automation, ordering/invoicing system, using SOA mainframe data access services in COBOL, DB2, CICS and interfacing to Web Services for remote/mobile Appletalk sales force applications JAD sessions.

Confidential

Designed, developed, implemented, integrated CD-ROM order entry/fulfillment system for a national legislative publishing firm using CICS/COBOL/VSAM sole source one-man development team .

Confidential

Provided JAD facilitation, development, integration of AMAPS/Q MRP2/ERP for automotive components division of international mfg firm COBOL, CICS, IMS ,

Confidential

Designed, developed, and performed systems integration of database, VTAM, VAX Mfg applications on AMAPS/Q MRP2 system for textile manufacturing firm CICS/COBOL/Datacom DB, VTAM, MVS JAD sessions

Confidential

Performed DB2 and IMS DBA duties, implemented DBRM Backup/Recovery system for IMS/DB.

Developed Service Level graphic reporting system for departmental use of DB2 IBM SLR .

Confidential

Designed, developed, maintained, performance tuned databases, programs for commercial billing project for leading telecom firm COBOL, CICS, DB2, IMS, and MVS .

Confidential

Designed, developed, implemented Order Processing system for commercial paper mfg.

Confidential

October 1984 - April 1985 7 months - Designed/Developed a system for managing and packaging mortgage loans into real estate investment instruments -- custom application for Mellon Bank and Manufacturers Hanover Bank. Technical Team Lead of six developers.

Confidential

DMS/COBOL for Storm System weather-related electrical service outage response .

Confidential

services for my prior IT Director of textile mfg company -- Customer Order Processing, Inventory Allocation, Database Admin. JAD sessions

Confidential

Administration, and Data Communications services for a major East Coast grocery wholesale/distribution firm. Planned and directed a major operating system conversion from VSE to VM and MVS. Directed troubleshooting production problems and mentored a staff of six system programmers and DBAs in the three service areas. JAD sessions

Confidential

development, systems programming, and database administration across multiple geographic locations -- administrative facilities in NYC 10 contractors and Virginia 5 FTEs , and manufacturing plants in Virginia, Alabama, Arkansas. JAD sessions

Confidential

MRP2 and JIT manufacturing information implementation, including BOM, process routing, finite and infinite loading, production scheduling, shop floor control, order control, shipping, supply chain, standard cost, job cost, and WIP cost.

Confidential

of pharmaceutical/blood derivative manufacturing applications, including reverse/inverted BOM for blood fractionation and linear programming processes. Also Value Assignment analysis, Freight Rate Audit system, Physical Inventory system, and Lot Numbering procedures. Was key proponent/architect in replacing external timesharing services with internal timesharing services on dedicated VAX 1170 system at savings of 300,000 per year corporate-wide.

Confidential

analysis/design/development in a large scale cast steel flow control valve mfg environment. Bill-of-Material, Mfg Routing, Component/Finished Inventory, Shipping/Receiving/Billing.

Skills and Expertise

DB2, Enterprise Architecture, Data Warehousing, COBOL, Data Modeling, CICS, MVS, JCL, AIX, z/OS, Performance Tuning, Websphere, ETL, SOA, SDLC, Data Migration, REXX, Systems Analysis, Relational Databases, Solution Architecture, Requirements Analysis, zOS/OS-390/MVS/VM/VSE, Web Services, Erwin, SQL, Database Design, Visio, Middleware, TSO, System/Data Integration, DB2 zOS Performance/Scalability/Tuning, Application Design/Development, PL/1, RAD, Data Analysis, Normalization, DB2/SQL, Architecture, Unix, Team Building, PL/SQL.