SUMMARY:

• I have over 20 years Mainframe experience in healthcare, telecomm and financial systems.
• I had master degree in Industrial management and always dreamed that one day I would use what I learned in school and own my own business.
• I am not afraid of challenge and enjoyed working in a dynamic work environment. Currently I work on mainframe and web based applications.

TECHNICAL SKILLS:

PRIMARY FOCUS: COBOL II, CICS, VSAM, DB2, STORED PROCEDURE, MQ SERIES, MICRO FOCUS COBOL, MFE, UDB, EXSTREAM DIALOGUE, ONDEMAND, OS/JCL, IBM Utilities, MVS/XA, FTP, NDM, TSO/ISPF, PANVALET, LIBRARIAN, ENDEAVOR, CHANGEMAN, INTERTEST, EXPEDITER, SMARTTEST, DASD, CEDF, SDF2, MAPPAINT, EASYTRIEVE PLUS, SAS, PLAYBACK, FILE - AID for DB2, SPUFI, BMC UTILITIES, SYNCSORT, CA-7, DYL280, SAS, VISIO and STARTOOL

SECONDARY SKILLS: HTML, FRONT PAGE 2000, UNIX, LINUX, JAVA 2, JSP, J2EE, JBUILDER, WEBLOGIC, JAVASCRIPT, XML

AREAS OF EXPERTISE:

Financial/Other services:

• Equity and Stock Option Processing.
• Retail Savings and Checking System
• Commercial loans and Finance
• General Ledger and Cost of Sales
• Human Resources and Compensation
• Retail

Healthcare Insurance:

• Healthcare Claims
• Batch Adjudication
• Enrollment
• Authorization/Reference
• Case Management
• Pharmacy Claims Processing

PROFESSIONAL EXPERIENCE:

Consultant

Confidential, Pennington, NJ

• Performed coding of system maintenance and provided on-going production support in Universal Link System and Asset Management by using COBOL II, CICS, DB2 and MQ series, JCL, PROC, ICETOOL.
• Performed IMS conversion to DB2 in Universal Link System and Asset Management and successfully implemented into production.
• Participated in system cleanup project: identified the jobs and reports no longer used by business, suspended the jobs by changing CA-7 job schedule first, then removed all components from ENDEAVOR.
• It is using COBOL II, CICS, B2, Stored Procedure, MQ Series, Web Services, SPUFI, BMC UTILITIES, SYNCSORT, TSO, ISPF, JCL, IBM Utilities, MVS/XA, NDM, FTP, CFI, ENDEAVOR, EXPEDITER, FILE-AID and CEDF.

Consultant

Confidential, Warren, NJ

• Performed coding of system enhancements and provided on-going production support in Rating & Billing Systems by using COBOL II, CICS, DB2 and MQ series.
• Performed development of Data Mask System. Confidential started to outsource computer application developments to India, but sensitive information are not legal to be viewed by non-Americans, therefore, certain data from the input files must be masked. I developed the Data Mask system to mask various input files for Indian programmers to do unit tests.
• Participated in Account Level Pricing project: It allows multiple phone lines to share usages under the account level. The project is using the new account level pricing plans and usage summary in Rating and Billing systems.
• Participated in Voice, Data and Text Message Usages Alerts project by creating alerts of voice data and text when the usages reach over 50%.
• It is using COBOL II, CICS, B2, Stored Procedure, MQ Series, Web Services, SPUFI, BMC UTILITIES, SYNCSORT, TSO, ISPF, JCL, IBM Utilities, MVS/XA, NDM, FTP, CFI, ENDEAVOR, EXPEDITER, FILE-AID and CEDF.

Consultant

Confidential, Malvern, PA

• Developed web based Retail Advice System, which will help Financial Advisors to consult with clients on specific investment goals, construct and manage the client portfolios. It involved extracting data from various Retail Managed systems and sending data to server/front end by using Micro Focus COBOL, DB2, CICS, MQ SERIES, STORE ROCEDURE, Web Services, SPUFI, BMC UTILITIES, SYNCSORT, TSO, ISPF, JCL, IBM Utilities, MVS/XA, NDM, FTP, CFI, ENDEAVOR, EXPEDITER, FILE-AID and CEDF. The project was developed in Micro Focus COBOL and tested in MFE environment. Performed coding of Retail Management Account system enhancements and provided on-going production support in Retail Management Account Systems.

Consultant

Confidential, Orangeburg, NY

• Performed coding of system enhancements and provided on-going production support in Commission Systems by using COBOL II, CICS, DB2 and MQ series. Designed, developed and implemented the real time Activation, Feature and Contract Renewal systems. Both involved extracting data from Vision Billing databases and sending data to server for Oracle database use.
• Participated Account Level Change project by populating account level plan to Commission systems
• Performed development of Commission Tracker application for the sales force -- transaction done by the rep for the current day. The new system brings in real time ‘Sales Dollars’, price plans and special feature offerings it associated with.
• It is using COBOL II, CICS, XML, DB2, Stored Procedure, MQ Series, Web Services, SPUFI, BMC UTILITIES, SYNCSORT, TSO, ISPF, JCL, IBM Utilities, MVS/XA, NDM, FTP, CFI, ENDEAVOR, EXPEDITER, FILE-AID and CEDF.

Consultant

Confidential, Woodcliff Lake, NJ

• Participated in the full life cycle of development of an interface system to provide vehicle information from Subsidiary Automotive Management System (mainframe) to Vehicle Management System (SAP). The vehicle data ( message type, basic IDOC type, process code and function module ) is needed for processing of vehicles in the US Distribution Centers and Workshops. This was developed by using MQ Series, DB2, COBOL, XML, CICS and Web Services( CICS/TS, Soap, XML and Restful Services).
• Participated in the Internal Finance Template System in gathering financial information from Vehicle Management System automatically. This information was used to create a Sale Orders, Invoice, A/R Documents and automated processing of acknowledgements to North America customers for purpose of billing. It is using COBOL II, CICS, XML, DB2, Stored Procedure, MQ Series, SPUFI, BMC UTILITIES, SYNCSORT, TSO, ISPF, JCL, IBM Utilities, MVS/XA, FTP, INTERTEST, FILE-AID and CEDF.
• Provided production support of various batch and online applications.

Confidential, Jersey City, NJ

• Performed development and enhancement to Global Clearance and Settlement System.
• Converted VSAM file key from numeric to packed format to increase maximum records of Account Processing file. Modified batch and online programs to support packed decimal key of Account Processing file.
• Developed Stock Future Position Forecasting System by using C OBOL II, CICS, DB2, MQ Series, SPUFI, BMC UTILITIES, SYNCSORT, TSO, ISPF, JCL, IBM Utilities, MVS/XA, FTP, ENDEAVOR, INTERTEST, FILE-AID and CEDF

Consultant

Confidential, Warren, NJ

• Designed and developed new Clients’ Statements batch system utilizing Exstream’ s Dialogue/ COBOL II//DB2/MQ SERIES/Oracle/OnDemand. Performed complex testing across multiple platforms and successfully managed software deployment.
• Developed Price Plan Analysis system, which will select optimal plan based on customer usage of voice, data and roam by using COBOL II, CICS, DB2, MQ Series, SPUFI, BMC UTILITIES, SYNCSORT, TSO, ISPF, JCL, IBM Utilities, MVS/XA, FTP, ENDEAVOR, INTERTEST, FILE-AID and CEDF.
• Performed nightly production support to the Customer Care system.

Consultant

Confidential, Paramus, NJ

• Performed data conversion with billions of rows in each DB2 table by using BMC Load and Unload utility, merged data from different tables and loaded it to a new or existing table by partitions.
• Participated in the design and development phase of increasing current 15 days package return information to maximum of 45 days by using COBOL II, CICS, DB2, MQ Series, SPUFI, BMC UTILITIES, SYNCSORT, TSO, ISPF, JCL, IBM Utilities, MVS/XA, FTP, CHANGEMAN, INTERTEST, FILE-AID and CEDF.
• Provided maintenance and enhancement to the package tracking system by using Cobol II/DB2/STORED PROCEDURE/MQ Series/CICS/JCL.

Consultant

Confidential, Philadelphia, PA

• Designed and developed web based Contract and Signature systems to add, revise or cancel Contracts by using COBOL II/CICS/DB2/STORED PROCEDURE/MQ SERIES.
• Designed and developed Social Security Number and Cross Reference System by using COBOL II/CICS/DB2/STORED PROCEDURE/JAVA. The project was developed in Micro Focus COBOL and tested in MFE environment.
• Performed maintenance and enhancement on ICD code update. Provided production support of various online applications.

Consultant

Confidential, Jersey City, NJ

• Designed and developed Confidential ’ s first MQ Series application to automate the Claim Assignments System based on case complexity, state license requirements and adjuster’s availability using Java/COBOL/CICS/DB2/MQ SERIES. Front end (JAVA) writes request messages to MQ, when the first message arrives on the queue, it will trigger CICS transaction and CICS program will read request messages, update VSAM or DB2 and send reply messages back to the front end. The project was developed in Micro Focus COBOL and tested in MFE environment.
• Developed File Transfer application by using DB2 stored procedure.

Senior Programmer Analyst

Confidential, Ft. Washington, PA

• Implementing the federal HIPAA 837 guidelines to Confidential HMO
• Claim Processing System by using COBOL II, CICS, DB2, STORED PROCEDURE, MQ Series, SPUFI, BMC UTILITIES, SYNCSORT, TSO, ISPF, JCL, IBM Utilities, MVS/XA, FTP, ENDEAVOR, INTERTEST, FILE-AID and CEDF.
• Maintained and enhanced on the Prior Authorization, Reference and Eligibility subsystems of batch adjudication.
• To comply with HIPAA 837 and 835 transaction requirements, the providers’ information must be retained for batch and online claims adjudication. A new database was created to retain the providers’ information, which was dropped in current claims processing and needed by processors to adjudicate the claim.
• Eight indicators for COB, Chiropractic, Durable Medical Equipment, Home Health Care, Ambulance, Hospital, General Claim Information, dental and UCK number are added to Claim Inquiry screen to assist processor to process the pended claims.
• Performed maintenance and enhancement on ICD code update.

Senior Programmer Analyst

Confidential, Jersey City, NJ

• Provided maintenance, enhancement in the Equity and Stock
• Option Trading System by using COBOL II, CICS, DB2, VSAM, MQ Series, SPUFI, BMC UTILITIES, SYNCSORT, TSO, ISPF, JCL, IBM Utilities, MVS/XA, FTP, ENDEAVOR, EXPEDITER, FILE-AID and CEDF.
• This system made extensive use of MQ Series for communication between external users and the back-end systems.
• Designed and developed Dow Jones News Entitlements System for Preferred and Select Clients by using COBOL II/CICS/DB2/MQ SERIES.
• Worked on systematic investments in Mutual Funds, which would allow CSFBdirect customers to invest fixed dollar amounts in mutual funds on a periodic basis. This provides the benefits of Dollar Cost Averaging to the customer.

Sr. Programmer Analyst

Confidential, Hopewell, NJ

• Developed the Client Performance Measurement applications for Confidential Web Sites by using Shadow Direct software to retrieve data from DB2 relational database stored on the mainframe through Remote Procedure Calls (RPCs) with static SQL. The RPCs are COBOL II DB2 programs that run on the mainframe; they are invoked by Active Server Pages (ASPs) running at the web server. The Performance application consists of tabular reports, charts and graphs that convey investment performance information for clients’ accounts. Financial consultants can view, scan and filter their current households across the firm's core products and services.
• Provided on-going production support . Heavily involved in debugging Cobol II CICS abends, error messages and misinformation by using CEDF and EXPEDITER.

Senior Programmer Analyst

Confidential, Woodcliff Lake, NJ

• Provided on-going production support for the Pharmacy Claims Processing system (Point of Sale), online claims entry system, batch Explanation of Benefits system and daily Checks Write system. Created Deductible and Cap conversion and load as clients terminate and enroll by using COBOL II, CICS, DB2, VSAM, MQ Series, SPUFI, BMC UTILITIES, SYNCSORT, TSO, ISPF, JCL, IBM Utilities, MVS/XA, FTP, ENDEAVOR, EXPEDITER, FILE-AID and CEDF.
• Responsible for daily transmission of bank reconciliation tapes.

Programmer Analyst

Confidential, Ridgefield, NJ

Provided maintenance, enhancement in the Retail Savings and Checking System and the Commercial Loans System by using COBOL II, CICS, VSAM and DB2. Designed and developed On-line CICS Accounts Link System, which allowed the customers to link all of their accounts to reduce the overall monthly service charge.