Software: MS SQL Server, Micro Focus Enterprise Server,Sybase DB, VB.Net, C .Net,IBM WebsphereApplication Server, HIPAA X12, Informatica ETL,EDW,TERADATA,Cobol-II, CICS, MQSeries, HPS, DB2/SQL, TSO/ISPF, VSAM, Intertest, PVCS, IDCAMS, File-Aid, Changeman, Endevor, AFP, EDI, MicroFocusCobol/CICS, XDB, PYTHON

EXPERIENCE

Confidential

Mainframe Developer

• Worked as a Sr. Data analyst, to create service data mart required for Business Intelligence and reporting purposes
• Performed DB2/TERADATA software development, enhancements and maintenance for ADJUSTMENT system for new SUBROGATION subsystem, including DLD and full QA and production support for TERADATA Data Warehouse.
• Performed mainframe software development, enhancements and maintenance for NRX system to provide benefits for new DOD client
• Created FRD and DLD for Replenishment project to provide functional methods of online model stock calculation replenishment at Item/Pharmacy level by designing specifications for the new batch programs, reports.

Confidential

Analyst/Developer

• Worked as a Sr. Data analysin the Analysis, Design and Development Phases of report development, performance tuning and production rollout for every report of Information Technology Department for CVS Caremark
• Performed technical lead and work coordination between client side RxClaim, QL, RECAP on-shore core team and off-shore team,
• Created BRD's and TRD's for data transition project between different platforms for Pharmacy Benefits Management PBM within Enterprise Data Warehouse EDW using Informatica Power Center client for creating mapping and run workflows.

Confidential

Analyst/Developer

• Involved in design and development of a new transaction for Claims system to process inpatient and outpatient hospital claims for city of NY workers based on information from Subscribers
• Filed and collected all co-payments for family/individual plans.
• Assist in translating business requirements and assist IT with the development of technical specifications
• System written on COBOL II/CICS under OS/MVS/XA operating system

Confidential

Analyst/Developer

• Involved in development and support of LOI fulfillment/ROA processes Application used to communicate between Morcom trading system and MFRS and Charles Schwab investment.
• Project developing and implementation involved utilizing CICS Web Services, Cobol/DB2 SPs, Batch/DB2 programs and streams.
• Responsibilities included communication with the business users, gathering the business requirements, performing the analyses, creating the functional specifications and test cases, unit and QA testing with other business
• System written on under OS/MVS/XA operating system

Confidential

Analyst/Developer

• Designed, developed, and implemented the Investment Solution Toolset Application. The system's intent is to unify the way various related data i.e. Security,Trade, Account est., is stored, maintained and presented.
• Developed the Cash Management Subsystem which letthe user identify all cash positions for the client as a feeds coming from different subsystem and reflect it on trading screen.
• Development included CICS/DB2 modules, Cobol SPs, Batch/DB2 programs and streams.
• Responsibilities included the interface with the Business Unit, writing functional specifications and programs, UAT and QA testing utilizing business applications on different platforms.

Confidential

Lead Consultant

• Involved in enhancement and support of Commission/Accounting Transaction Processing System and Licensing System for BackOffice operations.
• Created TRD's for data transition project to new platform from UNIX/IBM S-36 to MF Enterprise Server./SQL Server
• Responsibility included administrate Microfocus system network connection and migration all job stream to MF Enterprise Server for easy batch execution thru Job Execution System JES engine
• Converted system to allow all ALPS product to use Sybase System 12.5 for any lines of businesses as endorsement, or renewal.
• System was written in MicroFocusCobol/Sybase using Stored Procedures for back-end and MS Visual Basic/Sybase for front end.

Confidential

Mainframe Developer

• Involved in enhancement and support of Claims Reconciliation System, designed to reconcile any existing claim which had been initially sent in and adjusted any initially payment which had been made.
• Was heavily involved in conversion to make this system compliant with HIPAA standard, to be able to process HIPAA compliant EDI 834 data input from clients.
• System written on Cobol II/CICS/DB2/MQ Series

Confidential

Mainframe Developer

• Involved in enhancement and support of Monthly Option Expiration system, to move it from Monday after the expiration processing to Friday
• Developed process for all exercise and expires of long Equity and Index options actions taken on the last trading day of the month for both customer and firm positions.
• Provided the Listed options Clearance Group with the categorized option positions through the MES Monthly Expiration System
• System written on Cobol II/HPS/CICS/DB2 under MVS operating system.

Confidential

Mainframe Developer

• Involved in development and support of IDCR system, designed to uploaddaily trades to trade repository and allows user to work with new type of security Mortgage Backed Security MBS .
• Involved into conversion of a GOTS VSAM files into new security databaseCalled FIPR Fixed Income Products DB and conversion existing program to access new database using DB2 stored procedure.
• System written on Cobol II/CICS/DB2 under OS/MVS/XA operating system

Confidential

Mainframe Developer

• Involved in development, support and migration of Customer Profile System CICS Real-Time environment to a Visual Basic front-end
• CPS provides comprehensive service for all brokers in all offices withon-line name and address system.
• System utilize MICROSOFT VISUAL BASIC as a front end and CICS/DB2under OS/MVS/XA operating system for back-end and Grapevine Tool as a middleware

Confidential

Mainframe Developer

• Engaged in support and enchantment of ACE Activity Control Environment system which provided comprehensive service for Life Administration areas and Fields associates to track customer requests through each step from receipt to completion.
• Developed new transaction AEMN to allow for customized views for salesmanagers and general managers.
• Responsibility included administrate Microfocus systemnetwork installation and setup PVSC as a version control tool
• Programs were written in MicroFocusCobol /SQL sqerver

Confidential

Consultant

• Developed programming interface for AUTO insurance between COBOL backend MicroFocusCOBOL v4.0 running on 32-bit environment OS/2 WARP / Windows/NT and Sybase System 11 through named pipes utilizing OS/2 - Windows API calls.
• Participated in development and implementation of ALPS-MARS interface. The functions of the system allow transfer MARS requests to ALPS requests with translation MARS products, Sections, RIsks and Coverages to ALPS based on Alps producer for any lines of businesses as endorsement, or renewal.
• System is written in Cobol/DB2 under OS/MVS/XA operating system and MicroFocusCobol/SQL Server for back-end and MICROSOFT VISUAL BSICIC /SQL Server for front end.

Confidential

Consultant

• As a member of a team, was involved in design and implementation of Integrated Property Information System which processes all information for any leasing property of NYC, all billing and purchasing activities.
• Wrote and implemented Financial Transaction Subsystem which combines on-line and batch applications in order to process monetary transactions via real-time or stored-forward based on the user request.
• System was written on Cobol II/CICS/VSAM.