Tuesday, May 19, 2009

Resume

 

 

 

 

Professional Profile

For more than 20 years, Charles has been assisting clients in the US, Canada, and Brazil architect, re-engineer, integrate, design, build, test, and implement their business processes on different platforms and technologies: IBM mainframes, UNIX /Linux systems and Windows. Charles helped clients build automated business processes that are efficient, effective, easy to support and maintain, and responsive to changing business requirements.
 
Charles previously worked as an IT Architect at IBM for more than 9 years. While at IBM, he was assigned to various Fortune 500 companies in different industries performing various roles: architect, integrator, business systems analyst/designer, auditor, developer, and tester. He also worked frequently as a team lead managing up to 20 globally-based IT staff (US, Canada, India, Brazil).
 
Charles started his Information Technology (IT) career on IBM Mainframes. He augmented his technical expertise to include internet technologies when the web became mainstream.
 
Charles is currently focusing on business process management (BPM) technologies to assist clients in managing their automated business processes to make them more efficient, effective, flexible and responsive so that they can be readily adapted to ever changing business requirements.
 
Charles believes that business requirements should drive IT and not the other way around.
 
As an Enterprise Application Architect, Charles concentrates on the design of applications required to automate business processes and resolve business issues. The resulting design may run on multiple platforms and may be composed of multiple software packages. He performs critical evaluation and selection of the software and hardware components of the applications and data, and prepares for the development of the application by evaluating and selecting appropriate development methodologies and tools. He is responsible for applications related performance, availability, scalability, and integrity. He is also concerned with the functional interface to the applications.
 
As an Enterprise Integration Architect, Charles focuses on the design of solutions which enable existing applications, packaged software offerings, networks, and systems to work together within an enterprise or among enterprises. These solutions may use different technologies/middleware, vendors, platforms, and styles of computing.
 

Work Experience overview

Enterprise Application Integration

Design/Assess enterprise integration architecture of various clients to identify gaps and weaknesses and make appropriate recommendations for improvements.
  
  • SOA/Web Services
  • Middleware
  • Routing/Data Transformation
  • Message/Event Brokering
  • Non-Functional Requirements
  • Synchronous/Asynchrounous communication
  • Request/Response
  • Publish/Subscribe
  • Security (transport level, application level)
  • Single Sign-On

Enterprise Technical Architecture

Assess enterprise architecture of various clients to identify gaps and weaknesses and make recommendations by interviewing client’s technical SME and and reviewing technical documentations.
  
  • Application Architecture
  • Integration Architecture
  • Database Architecture
  • Application Server Architecture
  • Non-Functional Requirements (High availability, performance, scalability, maintainability)
  • System Development Life Cycle

Web services

Architected, built, and tested Web Services for various clients using the following standards, tools, and technologies:
  
  • WSDL (RPC style and Document style)
  • XML, XML Schema/XML Namespaces
  • SOAP
  • EJB web service/Java Bean web service (Bottom up/Top down development)
  • Rational Application Developer V6.0.0.1 
  • DB2 UDB 8.2
  • JMS (Point-to-Point and Publish/Subscribe Messaging)
  • WESB (Websphere Enterprise Service Bus)
  • Rational Application Developer
  • JAX-RPC
  • SAAJ
  • WS-Addressing, WS-Eventing, WS-ReliableMessaging
 

IBM Mainframe Systems Consolidation

Assisted several clients in consolidating their IBM Mainframes systems due to mergers and acquisitions.  Maintaining multiple databases (IMS, DB2, VSAM), transaction managers (IMS/DC, CICS), and different mainframe utilities (i.e, Sort, Job scheduler, source control) is expensive because they require different skill sets to use and support.
 
The following are some of the Mainframe systems consolidations I performed:
  • Migrated VSAM files to DB2 and change data access to DB2 SQL.
  • Migrated IMS data to DB2 and change data access from IMS/DL1 to DB2 SQL.
  • Changed IMS/DC to CICS
  • Migrated Mainframe SORT JCL from one vendor to a preferred vendor

Application Outsourcing Costing

A Telco wants to outsource its Information Technology (IT) for a given price.  Before accepting the outsourcing contract, the client wants to examine the Telco's IT to determine whether the outsourcing deal would be profitable.
 
An IT that exhibits the following attributes can be considered a high quality IT and would be in-expensive to support and thus would be profitable to operate:
  • It is always up and running with no unplanned downtimes
  • It is available 24x7 
  • It is scalable, able to provide excellent service not just to a few users but to an unlimited number of users all using the system at the same time
  • It is easy to use
  • It is easy to change to meet new business requirements
 
To determine whether the Telco's IT is comparable to an ideal IT environment, I reviewed some technical documentations and discussed it with the Telco's SME's (subject matter experts).
 
  • Problem reports
  • Frequency of problem incidents
  • Duration and cost to resolve problems
  • Nature of problems
  • Number of internal/external interfaces
  • Interface agreements
  • Non-Functional requirement
  • Service level agreements
  • Third-party software packages
  • Application development methodologies, standards, frameworks
  • Single point of failure

IBM Mainframe web enablement

 

Application maintenance cost control 

A client noticed that its IT maintenance cost is growing significantly and they are at a loss as to what was causing it.  The client's IT (primarily COBOL/CICS/VSAM/DB2) has been outsourced 3 years ago and has been very responsive ever since to all request for changes.  However, lately the turn-around for change request has been getting slower and slower and more expensive even though the level of change requests remained constant.
 
 
 
 
 

Java Application Development for CICS

Assisted a client in preparing a development environment for building CICS application using the Java programming language.  This client, as most other companies, has a growing population of Java developers and a shrinking pool of seasoned COBOL developers.  It is easier to teach Java developers how to use Java to build CICS applications than to teach/train them how to use COBOL; these up and coming Java developers are not that enthusiastic to learn COBOL.
 
I taught the Java developers on how to use Java to build CICS applications to access corporate data on DB2 and IMS/DB on the mainframe. 
For training purposes, I set up a development environment that includes the following:
 
  • WebSphere Developer for z/Series
    WebSphere® Developer for zSeries® V6.0.1 provides a comprehensive set of capabilities that help make traditional mainframe development, Web development, and integrated mixed workload or composite development faster and more efficient.
  • CICS Transaction Gateway
    CICS Transaction Gateway (CICS TG) provides connectivity to application server environments such as WebSphere Application Server delivering enterprise modernisation for your business without needing to alter fundamental CICS assets.
  • TXSeries for Multiplatforms
    As a part of CICS family, TXSeries for Multiplatforms is a distributed CICS Online Transaction Processing (OLTP) environment for mixed language applications. It is widely used for integrating data and applications between distributed solutions and enterprise systems, and the deployment of CICS applications written in COBOL, C / C++, PL/I and Java.

Business Process Re-engineering

A customer satisfaction survey done for the insurance industry showed that a particular US insurance company was near the bottom of the rankings.  One primary reason is that this company takes more than one day to provide a 'quote' to a prospective client while other insurance companies can provite a 'quote' instantly.  In addition, there are numerous features that prospective clients wants that this company cannot currently offer.  To be more competitive, this company decided to re-engineer and transform its mainly batch-oriented systems. 
 
The initial business process documentation was prepared using Microsoft Visio primarily because this is what the client has been using.  I recommended converting the visio documents to IBM Business Modeler to enable 'what if' analysis (simulation/analysis) of the business processes.  Microsoft Visio does not have this capability.
 
 

J2EE Business Control Mining

IBM Mainframe (z/OS, OS/390) Applications Architect/Developer/Tester

  • Architected, built, maintained, optimized/tuned, migrated, converted on-line(CICS) and batch Business Systems for various companies.
  • Led, mentored, and trained US and off-shore application development resources.
      
  • Technologies/Platforms Used
    • IBM WSED
    • Visualage Generator
    • Visualage for Java
    • COBOL
    • PL/I
    • TSO/ISPF
    • DB2
    • SQL
    • Stored Procedures
    • CICS
    • TELON
    • z/OS
    • OS/390
 

J2EE Applications Architect/Developer/Tester

  • Architected, built, maintained, optimized/tuned E-Business Systems for various clients.
  • Led, mentored, and trained U.S and off-shore application development resources.
  • Installed/configured J2EE development/test platforms including legacy systems connectivity (IBM Mainframe).
     
  • Technologies/Platforms Used
    • J2EE
    • JSP (java server pages)
    • JSF (java server faces)
    • Spring Framework
    • Hibernate OODB
    • STRUTS
    • EAD4J
    • UML
    • WSAD/VisualAge for Java(development/testing)
    • WAS
    • WBI
    • DB2
    • Stored procedures
    • CICS
    • MS sourcesafe/Clearcase (source control)
    • Windows
    • UNIX
    • IBM Mainframe
 
  • Architecture Used (N-tier,MVC-Model, View, Controller)
    • Model (JavaBeans, EJB)
    • View (JSP, HTML)
    • Controller (Servlets)
  • J2EE Design Patterns Used
    • Presentation Tier
      • Front controller
      • Application Controller
    • Business Tier
      • Business Delegate
      • Session Façade
    • Integration Tier
      • Data Access Object
      • Adapter
      • Bridge
 
 

Web Services Proof of Concept, Architect/Developer, Insurance

After successfully implementing a consolidated CRM system, an insurance company wants to find out how to leverage its web-based applications to enable its business partners to connect to their business systems programatically using standard Internet protocols/technologies.
Architected, designed, built, and tested a working Web Services prototype.
Presented the prototype to the client and indicated the technologies involve, the required technical changes, and an estimate of the effort (time/money) required.

Information Extract, Architect/Developer, Health Care

Architected, designed, built, and tested an information extract application.  The data source is DB2 on UNIX, the client is character-base Java, the middleware is JDBC calling a DB2 Java Stored Procedure. The data returned is a delimited file.  Other technologies included an E-Mail notification regarding the status of an information extract run.  Completed this project ahead of schedule and well under budget.

Integrate Siebel to Mainframe Database, Architect, Financial Services

Completed an application/integration architecture document (IGS Method work products) specying how Siebel should retrieve data from an IBM Mainframe and how Siebel should update Mainframe databases. The technologies used were MQ/MQSI/XML and MQ CICS adapters.  The Siebel/Mainframe Systems integration consisted of batch/real time integration.

 IBM Mainframe Consolidation, Architect/Developer/Tester, Banking
Due to a bank merger/buyout, one of the top 10 US banks decided to consolidate its various IBM Mainframe Systems located in various US locations into a single/centralized IBM Mainframe system.

The basic objective is to migrate all applications from one IBM Mainframe System to another IBM Mainframe System. Most of the work involved remediating JCL (2,500 jobs,  procs)  to conform to the target host JCL standards, changing,recompiling and testing  5,000 COBOL/DB2/CICS programs,  changing FTPs and NDMs to use new IP addresses and new data set naming conventions.

Led the conversion/recompilation/testing of the application/JCL for one of the major systems.

Consolidated Reporting Database, Architect, Telco

Completed an application/integration architecture document (IGS Method work products) specying how to populate a reporting database with data from 7 different CRM related applications (Genesys, ACD’s, IVR’s, WFM, etc).  Integration is batch only.  Java, JDBC, Native API’s were used.  Due to budget constraints, proprieatary middleware products were not used.


Mainframe Legacy Applications Cost control, Architect, Health Care Company

Conducted a technical review to find out why the cost of maintaining legacy applications is  rising significantly to unacceptable levels.  Prepared/presented a technical report indicating the reasons why and made recommendations on potential solutions.  The technologies include Mainframe DB2, COBOL, VSAM, CICS, Green Screen.  Some of the recommendations included componentizing the monolithic COBOL applications,  using MQ-Series, and discouraging application ‘cloning’.

Performance Tuning, Architect, Direct Consumer Sales

Conducted a technical review to find out why a new J2EE web-base system severely degraded the performance of a backend Mainframe legacy system.  Prepared/presented a technical report indicating the reasons why and made recommendations on potential solutions. The technologies included Mainframe DB2, Websphere Application Server(UNIX), Java, JDBC, JSP, Servlets, Database Connection pooling.

Mainframe Web Enablement, Architect/lead developer, Book distributor

The success of Amazon.com, Barnes & Noble, and Borders Bookstore in using Internet technology as an  effective marketing/sales medium,  prompted  a Nashville, TN based company to deploy its fully functional IBM Mainframe COBOL CICS/TELON/DB2 system  on the Web.  The first phase was to use web/internet technologies as the front-end. This will allow customers to browse/place orders, check accounts, track orders on-line 7/24.

Led a group of Java developers to make the above possible. Technologies included J2EE, Websphere Studio, Visualage for Java, CICS ECI programs, CICS Transaction Gateway.
 

 

Work Experience Details

Skills

 
 
 
 

Others

Education

Ateneo de Manila University (equivalent to a US university degree)
 
CGA finalist (fifth level)

Contact us

Offices in
  • Vancouver, BC, Canada
  • Phoenix, Arizona, US
  
 
 
 
 
 
 
 
  
 

No comments: