PROFESSIONAL SUMMARY
Over ** years of progressive technical experience in Information Technology
in Application Systems Design, Development, Programming, Testing,
Implementation and Maintenance.
PROFESSIONAL EXPERIENCE
Amdocs, Inc. (Consultant), St. Louis, MO 01/08 - 12/10
Sr. Programmer Analyst (SME)
Developed various projects and enhancements in "Service Order" and "Rate
Change Reconciliation" systems using COBOL II, CICS, DB2/SQL, IMS and JCL
Published the contents of a release including major features, bug fixes,
and enhancements for internal and external use.
Acted as Tier 2 level support for billing operations staff in the research
and timely resolution to production billing issues/incidents related to
"Service Order" and "Rate Change Reconciliation" systems.
Assigned Projects and Enhancements to Off-Shore Programmer/Analysts and
reviewed the System Review documents, Programs, test scripts and results
for "Service Order" and "Rate Change Reconciliation" systems.
Maintained and supported "Service Order" and "Rate Change Reconciliation"
systems using COBOL II, CICS, DB2, SQL, IMS and JCL
Performed Unit tests and QA tests for "Service Order" and "Rate Change
Reconciliation" systems using various test scripts.
Created various reports for the "Service Order" and "Rate Change
Reconciliation" systems using batch process.
Performed daily support and on-call support to the systems in a timely
manner using rotational Pager.
Mastercard Worldwide (Consultant), St. Louis, MO 01/07 - 12/07
Sr. Programmer Analyst (SME)
Developed Mastercard Billing Systems using COBOL II, CICS, DB2, SQL, JCL,
VSAM, FILEAID and ABENDAID.
Planned, documented and executed Disaster Recovery plans for the Billing
Systems of the company.
Identified the release and flow-through issues (major and minor) and
resolved in a timely manner.
Assigned Projects and Enhancements to Off-Shore Programmer/Analysts and
reviewed the System Review documents, Programs, test scripts and results
for Mastercard Billing Systems.
Maintained and supported Mastercard Billing Systems using COBOL II, CICS,
DB2, SQL, JCL, VSAM, FILEAID and ABENDAID.
Performed Unit tests and QA tests for Mastercard Billing Systems using
various test scripts.
Created various reports for the Mastercard Billing System using batch
process.
Performed daily support and on-call support to the system in a timely
manner using rotational Pager.
Arch Coal (Consultant), St. Louis, MO
01/06 - 12/06
Sr. Programmer Analyst (SME)
Developed Program specifications using Requirement Documents for the
"Mincom Ellipse" a Mining System of the company.
Analyzed, designed, developed, tested, implemented and maintained "Mincom
Ellipse" system for asset-intensive industries using Microfocus Cobol, SQL
and Unix Scripts in Unix environment.
Created various reports for the company using "Mincom Ellipse" system.
Performed daily support and on-call support to the system in a timely
manner.
Hussmann Corporation (Consultant), St. Louis, MO
01/05 - 12/05
Sr. Programmer Analyst (SME)
Developed program specifications using requirement documents for the "Bill
of Materials" System.
Analyzed, designed, developed, tested and implemented "Claims Accumulator"
and "Transaction Processing System Claims" for the climate control
department of the company using COBOL II, CICS, DB2, SQL, IMS (DB/DC) and
JCL.
Maintained and supported the accounting package Geac for general ledger,
fixed assets, accounts payable and accounts receivable.
Tested systems thoroughly to determine any errors and omissions,
documenting any suggestions for enhancements, changes, issues, defects
found in testing, and participating in planning and execution of
integration testing.
Prepared and reported month-end, quarterly and semi-annual data and
information to accounting.
Participated in Sarbanes-Oxley Auditing of accounting system.
Assisted with structured walkthroughs of requirements with business and
project team members.
Supported all pieces of business intelligence software and software
development life cycle in delivering reports to end-users and internal
business partners.
Managed the installation of reports and changes to the production
environment.
Performed daily support and on-call support to the branches and home office
in a timely manner.
Southwestern Bell (Consultant), St. louis, MO 12/03 - 10/04
Senior Programmer Analyst (SME)
Conducted feasibility study of the existing system to identify the
different options possible and recommended solutions to address the
business needs.
Tested the systems thoroughly to determine any errors and omissions,
documenting any suggestions for enhancements, changes, issues, defects
found in testing, and participating in planning and execution of
integration testing.
Designed and implemented the Enterprise Billing Format (EBF) system to
replace the old billing format system using COBOL II, IMS (DB/DC), DB2,
SQL, JCL, TSO/ISPF, NDM, CICS, Vantive, ESP Workload Manager and CHANGEMAN
in MVS platform. The new system is four times more efficient.
Performed end-user and staff trainings for the EBF system.
Converted the Southwest Legacy Alldata records into Input Interface records
which are used by BPI (Billing Project Initiative) to create standard
enterprise-wide billing product across all SBC entities using COBOL II, IMS
(DB/DC), DB2, SQL CICS, VSAM, TERADATA, TSO/ISPF, FILEAID, EXPEDITOR, NDM,
Vantive, ESP Workload Manager and JCL in MVS platform.
Maintained ICU (Input Interface Record Creation Unit) system by resolving
various defects and implementing them in a timely manner.
Created CASS report (a Statistical report) using SAS for customer billing
and submitted to the United States Postal Service (USPS) when a new data
file is applied from the vendor. This report helps the USPS to reduce the
cost involved in mailing various customer bills and other documents.
Edward Jones, St. Louis, MO 07/01 - 06/03
Senior Programmer Analyst
Managed project "Birthday Salutation", leading 10 programmers and 2 systems
analysts. The implementation of this project enabled the investment
branches to customize the salutations in birthday greetings they send to
their clients.
Prepared answers to the suggestion wires that come from the branches of
investment representatives throughout the United States, Canada and United
Kingdom.
Performed on-site and off-site support to the branches on a daily basis.
Resolved regular and hot-line abends immediately.
Performed end-user and staff trainings for the List Manager and Marketing
systems.
Designed, developed, tested, implemented and maintained marketing
information system, list manager system, regional leader newsletter and
direct mail systems using COBOL II, CICS, DB2, SQL, VSAM, TSO/ISPF,
FILEAID, EXPEDITOR and JCL in MVS platform.
Implemented System development Life Cycle (SDLC) methodology successfully
in the development of direct mail systems, a marketing tool to send
newsletters and prospectus to prospective clients.
Performed client interviews, collected their requirements and conducted
design sessions to create design solutions for the development of Direct
Mail Systems (a marketing tool for distributing newsletters and prospectus
to the prospective clients).
Performed daily support and on-call support to the branches on a timely
manner using beeper and cell phone.
Express Scripts (Consultant), St. Louis, MO 08/00 - 06/01
Senior Programmer Analyst
Converted the "Billing and Remittance" system to Client/Server using
MICROFOCUS COBOL, PL/SQL, UNIX Scripts and ORACLE/SQL in UNIX/RS6000 from
the old "Billing and Remittance" system developed in COBOL and C for Policy
Benefit Management (insurance) industry.
Analyzed, designed, developed, tested, implemented and maintained "Claims
Adjudication system" for the Canadian division of the company using
COBOLII, CICS, DB2, SQL and JCL.
Performed end-user and staff trainings for the "Billing and Remittance"
system.
Wrote stored procedure - standalone module that is called from another
module or a program in ORACLE.
IBP, Inc. (Consultant), Sioux city, IA
01/00 - 07/00
Senior Programmer Analyst
Designed, developed, tested and implemented order processing system for the
beef processing chain, a worldwide supply chain, to supply packaged beef
and pork to various retailers in the United States and Europe using COBOL
II, CICS, IMS(DB/DC), DB2, SQL, TSO/ISPF, FILEAID, EXPEDITOR and JCL in MVS
platform. There were over 50 Programmer/Analysts and 8 Database Analysts
(DBA) on the team.
Performed end-user and staff trainings for the order processing system.
Created DB2 tables for the claims order information with sales order number
as unique index.
Designed and created a common module that writes to sales order message
queue using IBM's MQ Series.
Designed and created DB2 sales order interface of product availability with
orders placed against an enterprise product availability viewed through a
data warehouse.
IL Department of Public Aid, Springfield, IL 02/97 - 12/99
Senior Programmer Analyst
Designed, developed, tested and implemented public aid accounting system
for the Illinois Department of Public Aid using MICROFOCUS COBOL, PL/SQL,
and UNIX SCRIPTS in UNIX/RS6000 computer in a TCP/IP network.
Designed, developed, tested and implemented Accounts Payable and Receivable
systems for recipients of Federal Child Welfare using COBOL II, CICS, DB2,
SQL, VSAM, TSO/ISPF, FILEAID, EXPEDITOR and JCL in MVS platform.
Designed, developed, tested and implemented vendor file maintenance system
to keep track of vendor payments of software and hardware purchases using
COBOL II, IMS (DB/DC), DB2, SQL, VSAM, TSO/ISPF, FILEAID, EXPEDITOR and JCL
in MVS platform.
Maintained and supported public aid accounting system on a timely manner.
Caterpillar (Consultant), Peoria, IL 06/96 - 01/97
Programmer Analyst
Converted ASSEMBLER language programs for the customer information support
system to REXX using ISPF Dialog Manager and CLIST.
Maintained the customer information support system.
Central IL Public Service Co., Springfield, IL 02/95 - 05/96
Information Analyst
Designed, developed, tested, implemented and maintained materials
management system for power plants using COBOL II, CICS, IMS (DB/DC), DB2,
SQL, VSAM, TSO/ISPF, FILEAID, EXPEDITOR and JCL in MVS platform.
Administrative Office of IL Courts, Springfield, IL 05/92 - 01/95
Information Systems Application Consultant
Designed, developed, tested and implemented a computerized court case
records management system to replace the old traditional system using
PROGRESS, SQL, UNIX/AIX operating system, a client/server system developed
on an IBM RS6000 computer in a TCP/IP network.
Education
M.A. Computer Science
University of Illinois, Springfield, IL
Master of Science (Physics)
University of Kerala, Trivandrum, Kerala
Bachelor of Science (Physics)
University of Calicut, Calicut, Kerala
TECHNICAL SKILLS
COBOL, COBOL II, DB2, SQL, IMS(DB/DC), IDMS, CICS, JCL, VSAM, C, UNIX,
UNIX SCRIPTS, PL/SQL, ORACLE, SYBASE