SUMMARY:

• Accomplished Data Processing professional with over 18 years of experience in the full life software design process including analysis, development, testing and technical support of mainframe financial, accounting and pharmaceutical benefits management system distribution applications.

TECHNICAL SKILLS:

Platforms: IBM MVS, UNIX (AIX), WINDOWS NT/ 2000/XP

Languages: MVS COBOL II, JCL, SQL, JAVA, XML, XSLT

Data Storage: IBM DB2, ORACLE, VSAM

Software: CICS, TSO/ISPF, INTERTEST, CHANGEMANPANVALET, ENDEVOR, XPEDITER/TSO, FILE - AIDIBM MQSERIES, IBM UTILITIES, MICROSOFT EXEL/WORD

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Participated in company effort to implement IBM CICS VSAM Transparency software. IBM CICS VSAM Transparency helps move valuable data from VSAM files to DB2 tables. This migration can evolve as business requirements dictate, without having to modify existing CICS and batch VSAM application programs.
• Inspected and prepared corporate data in VSAM files for migration Merchant initial information to the new DB2 tables.
• Wrote COBOL programs that eliminate data discrepancy between required DB2 data types and actual data in old VSAM files.

Confidential

Consultant/Senior Programmer/Analyst

Responsibilities:

• Performed redesign/conversion of Client Database & Information System (ICS/KD/CAM);
• Accomplished multiple projects based on business client’s requests for Cost Basis/Tax Lot Accounting applications, data conversion, synchronization and new product/functions additions.
• Analyzed and modified the code in MVS/JCL/COBOL/DB2/CICS/MQ for batch and online systems: (KD link, Name & Address Infrastructure, Accounting AP/AR, Client Experience and DQ Document Rewrite) to correct address/names inaccuracies and ambiguities.
• Designed and developed the Close of Business Day processes by synchronizing Real Time and COB databases. Defined Trigger tables, created daily jobs for unload and load of DB2 tables.
• Performed QA and full scale of cross systems testing.

Confidential

Senior Programmer/Analyst

Responsibilities:

• Specialized in Client Benefit Pricing System that serves as repository for all pricing, co-pay and other types of information, creates the pricing components and the rules governing their use for various lists of drugs and supports differentiation between Billable and Payable pricing.
• Wrote extracting/updating/DML SQL queries and use of AD HOC queries to investigate and resolve issues in various systems.
• Developed functional/technical documentation (FRD, ADD, and AID) for the modified application/modules.
• Built and modified COBOL/DB2 Stored-procedures, CICS/DB2 back ground processes using Channels and Containers.

Confidential

Senior Programmer/Analyst

Responsibilities:

• Had performed migration of data and applications from Smith Barney business model to Morgan Stanley business model.
• Provided production support for Confidential Syndicate Management System (SMS).
• Maintained COBOL batch and CICS programs in accordance with FINRA Rules.
• Built API to serve SMS and Cost Basis Account activity History system.
• Implemented all requests and requirements of compliance department for monitoring the initial Public Offerings (IPO).

Confidential

Senior Programmer/Analyst

Responsibilities:

• Participated in large construction and implementation of Web/CICS Syndicate Management System (SMS).
• SMS performed full range of actions during Initial Public Offering (creating and modifying of deals, entering indication of interest for accounts, splitting of shares between accounts, distributing shares based on clients indexes, entering exemption for some qualified accounts, carrying user’s profiles, distributing of shares between Smith Barney’s branches).
• Analyzed service requests for determination of feasibility and extent of technological changes from NDM transfers to MQ-series/CICS/BATCH & FTP including vendor product.

Confidential

Senior Programmer/Analyst

Responsibilities:

• Participated in company-wide effort to bring investment business to Internet in order to provide investment professionals and clients with fast, easy, up-to-date access to company market researched data.
• Performed production support for big batch processing of incoming data from different vendors.
• Developed modules and processes, MVS/JCL procedures, recovery procedures, DB2 stored procedures, background CICS transactions.

Confidential

Programmer/Analyst

Responsibilities:

• Participated in the development of multi-tier Internet system that enabled customers to view their existing accounts with Confidential and obtaining comprehensive information about different computers, software, configuration for them and parts as potential purchases.
• Wrote JAVA classes that access ORACLE database and created XML documents. Wrote XSLT style sheets that transformed these XML documents into HTML pages that were displayed in WEB browsers to our customers.

Confidential

Programmer/Analyst

Responsibilities:

• Assisted in splitting common database into 3 parts: Confidential, Confidential of Joint Diseases. Involved in coding and testing of conversion programs to reformat and load files into the database. Created new and redesigned existing production reports.
• Wrote PROCs and created schedule to perform the entire batch cycle runs.
• Facilitated migration of CUF accounting system to GEAC accounting system.