Wednesday, June 15, 2011

Work Experience - US



Work Experience - US

1999 - 2000 Ingram Books, Nashville, TN, USA

  • Roles
    • Lead Web architect, CICS-ECI technical lead, Systems Analysis, Design
    • Programming, testing,debugging,implementation  
  • Technical Environment
    • IBM Mainframe OS/390, CICS 4.1, DB2 Mainframe, CICS-ECI COBOL
    • SUN Solaris
      Websphere Application Server, Netscapte Suitespot Web Server, CICS Transaction Gateway, CICS Universal Client, Oracle 8.1.5, Vignette
    • Windows NT 4.0 with SP6
      Websphere 3.2 AE, IBM HTTP Server 1.3.6, DB2 UDB 6.1, Websphere Studio, Visualge for Java 3.0 Enterprise Edition, EJB, EAB, CICS-ECI beans
  • Projects
    • Mainframe Legacy System Web-Enablement
Lead Web Architect (Mainframe Legacy System Web Enablement Project)
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.  Previously, customers has to call the company for placing orders and  querying their accounts.
The project has the following minimum requirements:
  • No or minimal changes to existing Mainframe legacy applications
  • The front-end client should be universal, requiring only a  typical PC loaded with a browser (MS Internet Explorer/Netscape)
  • The web front-end should be available 7/24 days
  • The web front-end should be scalable.
  • The web front-end should be easy to develop and maintain
  • Successfully Setup a complete Team Development Environment for building the company’s website. The environment consisted of the following components:
  • IBM Mainframe
  • IBM Transaction Server (CICS)
  • IBM CICS Transaction Gateway/Client
  • IBM DB2 Mainframe
  • IBM Websphere Application Server
  • IBM Visualage for Java Websphere Test Environment
  • IBM Websphere Studio
  • IBM HTTP Server
  • MS Sourcesafe (use to manage source codes, ini files)
  • Successfully implemented standards/guidelines on how/when to use JSP, Servlets, Javabeans, JDBC, and SQLJ, Session Beans and Entity beans (EJB).
  • Successfully recommended the use of CICS-ECI over MQSeries as middleware to access IBM Mainframe legacy data
  • Successfully designed/developed common routines (paging or next/previous, column sorting, security validations)


The following are some of my duties and responsibilities:
  • Technical lead for EJB/JSP development group
  • Technical consultant for COBOL/CICS/ECI/DB2 IBM Mainframe Development group
  • Participated in the design, architecture of the different Web Enablement components: Netscapte suitespot, Websphere App Server, CICS Transaction Gateway/Client, OS/390 Mainframe, CICS 4.1 MVS, DB2.
  • Installed and configured Websphere Application Server 3.02 AE on Windows NT 4.0 sp6.
  • Assisted in the installation/configuration of WAS 3.02  AE, CICS Transaction Gateway, CICS Universal  Client on a Sun Solaris 4500 machine.
  • Assisted  IBM Mainframe developers to design/develop COBOL/CICS /TELON ECI programs to be invoked by Java based CICS-ECI programs.
  • Designed/developed EAB CICS-ECI beans to retrieve/update IBM Mainframe DB2 thru COBOL/CICS ECI-enabled programs using Visualge for Java 3.0 Ent Edition using the EAB builders (CICS Connector).
  • Trained JSP front-end developers on how to use the EAB beans.
  • Help administer WAS 3.02 on Sun Solaris.  Also provided performance optimization support.

1998 (Aug) - 1999 (July) AirTouch Cellular Bellevue, Wa, USA

  • Roles
    • Systems Analysis, Design, Technical lead
    • Programming, testing,debugging,implementation  
  • Technical Environment
    • IBM OS/390, CICS 4.1, IMS 5.1, DB2 5.1, IBM AIX
    • COBOL, DL/1, EZTRIEVE, JOBTRACK (job scheduler), Focus, JCL
    • NT 4.0 Server, Unix, Oracle
  • Projects
    • G/L, Billing, Inventory
    • CAMBAR Financial System Enhancement & Y2K Compliance
    • CAMBAR Job Schedule Performance Tuning
    • Mainframe to Unix Interface
Technical Lead /Developer (CAMBAR Financial System Enhancement & Y2K Compliance Project)
Successfully enhanced the system to enable the client to add  retail outlets and make the system Y2K compliant.
The CAMBAR Financial System is a 12 year old accounting system package.  It handles Order entry, Inventory control ,account and billing information. It interfaces with other numerous accounting/financial packages.  It is written in COBOL, IMS DB, DB2, CICS, EASYTRIEVE, VSAM, and ASSEMBLER.
The following are the project requirements:
  • Modify the system to accommodate the significant increase in the number of U.S retail outlets
  • Modify the system to meet Y2K requirements
  • Convert OS/VS COBOL programs to O/S 390 COBOL
  • Convert  CICS 2.1 COBOL programs to CICS 4.1 COBOL
  • Convert IMS 2.0 COBOL programs to IMS 5.1 COBOL
  • Modify JCL to accommodate the above conversions

 The following are some of my duties and responsibilities:
  • Identify systems, programs, JCL to be changed (500 programs/subroutines, 300 JCL)
  • Identify changes to other systems and notify systems owners and discuss alternatives
  • Identify tasks and resources
  • Estimate completion dates and schedule resource requirements
  • Plan and conduct end-user training and mode of implementation
  • Analyze and review  required changes and confirm with users and system owners
  • Interview and hire technical resources with the required technical skills
  • Assign tasks to other team members, review/discuss tasks status
  • Peform programming , testing, and debugging
  • Prepare weekly status report for review by management
  • Prepare and implement test plan, test data, test procedures
  • Prepare implementation plan  including backout procedures
Technical Lead (CAMBAR Job Schedule Performance Tuning Project)
Successfully reduced batch run time from 7 hours to 12 hours.  This enabled employees in the New York office to do something usefull  starting at 8:00 AM instead of waiting until 12:00 PM or later to accept and process orders.
The batch portion of the CAMBAR Financial System runs  everynight for about 12 hours. If any problem occurs during the night, the daily on-line order entry operations is delayed. Clients cannot place orders and the system cannot be used resulting in substantial loss of business.
To prevent and minimize downtimes and the resulting business losses, the nightly runtime was reduced from 12 hours to 7 hours.  This was done as follows:
  • Identify and modify  jobs (JCL) that consume the most time and optimize it
  • Identify and remove duplicate and un-neccesary jobs steps
  • Re-sequence the job schedule to group all critical jobs ahead of the schedule and the non-critical jobs at the end of the schedule.
  • Eliminate redundant file backup steps
Technical Lead (Mainframe GL to Unix Interface Project)
The UNIX G/L Systems is an accounting package that was just recently installed.  It replaced a Mainframe G/L System. It is written using Oracle.
The following are the project requirements:
  • Feed the new UNIX G/L System with G/L data similar to the Mainframe based G/L system
  • Produce audit trail and control and balance reports similar to the ones currently being produced

The following are some of my duties and responsibilities:
  • Identify data, data format, and record layouts acceptable by the new UNIX G/L System
  • Identify data sources, data/file conversion  required to make the Mainframe data acceptable to the New UNIX G/L System
  • Estimate completion dates and schedule resource requirements
  • Select programming tools (COBOL for data/file conversion and EASYTRIEVE for Reporting)
  • Perform programming, testing, debugging, unit/system testing
  • Setup backup and recovery procedures

1998 (Feb-July) ConneXt , Seattle, Wa, USA

ConneXt is a Seattle-based developer of packaged customer information system software that enables utilities to meet the challenges of today's rapidly changing energy marketplace.

ConneXt is a provider of sophisticated, packaged CIS software targeted to utilities. Comprehensive, flexible and scalable, ConneXt billing and customer care solutions allow utilities to thrive in a deregulating energy market.
  • Roles
    • Systems Analysis, design
    • Programming, testing,debugging,implementation
  • Technical Environment
    • IBM 3090, OS/MVS
    • Windows NT 4.0, Micro-Focus Cobol, XDB Database, Visualage Smalltalk
    • COBOL II, DB2, CICS, QMF, Expediter, Intertest, TSO/ISPF,CLIST
    • Platinum, Expediter, Intertest
  • Projects
    • Accounts Receivable
    • Billing
    • G/L
Developer, Billing & A/R On-Line Systems  
The above Systems were developed using Visualage for Smalltalk as the GUI component running on Windows NT, IBM Mainframe COBOL/CICS as the application server, and IBM Mainframe DB2 as the data server. This architecture represent an N-tier model . Development work was done primarily on Windows NT workstations and final testing done on the IBM Mainframe.   In a single software application, the powerful system incorporates all of the modules that utilities need to run their complex billing and customer care operations, including:
  • Customer relationship management to track lifetime customer relationships
  • Sophisticated billing for real-time and flexible multi-tier pricing to all customer classes
  • Accounts receivable management to support virtually all payment methods, including Internet bill payment
  • Outage response management for a coordinated and systematic approach to both planned and unplanned outages
  • Credit collections management for automated oversight of every aspect of the payment and credit function
  • Customer communications management to manage and personalize all customer support functions, including automated targeted communications generation
  • Service order management to oversee and track work orders from origination to completion
  • Equipment management to ensure that all field billing equipment is in place and functioning properly
 
 The following are some of my duties and responsibilities:
  • Identify user requirements and translate into user specifications
  • Translate user specifications into programs and  subroutines.
  • Estimate development effort required and completion dates
  • Identify which existing subroutines to use, error-checking required and DB2 tables/views to set up.
  • Perform programming, testing, and debugging
  • Prepare and implement test plans and review test results with users


Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)