SUMMARY:

• More than twenty (20) years of continuous IT work experience in various enterprise business application systems utilizing Mainframe, HP Exstream, SAP and Client - Server platforms; Work exposures in Federal, Financial, Brokerage, Insurance, Banking, Telecommunications and Gas / Electric Services; Expertise in Mainframe / COBOL / Legacy systems; Increasing exposures and applications in HP Exstream v8 (OpenText); Exposures to all phases of SDLC Project Initiation /Estimation, System Analysis, Technical/ Detailed Design, Peer Review, Development, Testing (Unit/ Parallel/ Integration/ QA/UAT),
• Deployment, Maintenance, Troubleshoot, Documentation and Production Support; Exposures to Agile methodologies on Mainframe and Client Server architectural projects; Strong ability to plan, prioritize, and manage project; Good communication and reporting skills; Recognized for leading teams through major transitions and critical events; Mentoring and motivating individuals and teams; Understanding of Service-Oriented Architecture (SOA) and applicable web services; Day-to-day exposures in resolving issues at all levels of project life cycle and best practices to ensure quality standards using business process tools; Works independently and effectively under tight deadlines; Skilled in getting end-user results, effective leadership and paying attention to client requirements

TECHNICAL SKILLS:

Programming Languages: COBOL VS, COBOL II, COBOL3/Enterprise COBOL, COBOL LE, JCL, CICS, DB2 V8, SQL, Stored Procedure, SQL Triggers, SAS, MICROFOCUS, EASYTRIEVE+, IDEAL, ABAP/4, POWERBUILDER, PL/1, PL/SQL, SQL*PLUS, C/C++, VISUAL BASIC, HTML, JAVA, .NET

Databases / File Management: DB2, ORACLE, MS-ACCESS, VSAM, QSAM, IDMS, IMS DB/DC, LOTUS NOTES, SQL SERVER 2005, DB2 UDB, CA-DATACOM DBMS, CA-ROSCOE, TestBase

Operating Systems: Z/OS, OS/390, MVS/XA/ESA, OS/VS, Unisys 2200, DEC VAX, DOS/VSE, IBM MERVA, OS/2, UNIX, HP 3000, SAP, WINDOWS, MS-DOS

Development Tools: ISPF, TSO/E, TSO/ISPF, PANVALET, SPUFI, PLATINUM, XPEDITER, FILEAID, ENDEAVOR, SQL SERVER, DATASTAGE ETL, TOAD, HPS, XML, INTERTEST, CSP, CTS, QUICKTEST, TEST DIRECTOR, SAS, TMON/CICS, RUMBA, SPF/PRO, SAR, CHANGEMAN/OneInfo, STARTOOL, ISPF/PDF, IOF, DFP,QMF, IDCAMS, PROEDIT, BMS, SDF/2, EZTEST, DFSORT, SYNCSORT, CUSTOMER1, SQLWINDOWS, FILEMANAGER, NEON, CLIST, COGNOS, MS-WORD, MS-Excel, MS-Project, MS-PowerPoint, MS-Visio, LIBRARIAN, OPCC/Scheduling, SharePoint, Infoman, Decision Tables, CA Deliver, FINALIST, MAILSTREAM PLUS, HP Exstream v8 (OpenText), IBM SCRIPT/Vs, Agile Methodology, API, Jobtrac, ISPW (Containers), VersionOne, JES2MAIL, ESCALA, GT IVORY STUDIO, GLink, Control-M, TestBase Database Utilities, CA-View (SAR), DB Unicenter, Data Studio, ServiceNow

Protocols: MESSAGE BROKER, MQ SERIES, FTP, RDX, TCP/IP, SMTP, TELNET, NDM, SWIFT, LU 6.2, RTTM, MSRB, XML, EDI 837, EDI 277, EDI 820, Kerberos, BizTalk

SAP: FI MODULE, DESIGN/1, SAP-GUI, ABAP/4

PROFESSIONAL EXPERIENCE:

Confidential

CONSULTANT - SR. MAINFRAME PROGRAMMER ANALYST

Responsibilities:

• Provide in-depth technical support (development and analysis) in the integration project between iValua and eMMA; A new online system development is in-progress for the procurement and connection of vendor community with contracting opportunities with the State; Creation of Vendor and Customer Maintenance Process in batch and online environments where bids and responses are delivered and processed real-time; Heavy programming in COBOL II, JCL, CICS, DB2 and SQL for the creation of relational tables, online transactions and PROCS to be used by Front-end users of the State; Coding, Testing, documentation and implementation following the SDLC methodology and standard process of the State; Utilize COBOL II, JCL, CICS, Intertest, DB2, ISPW, TSO/ISPF, Batch-FTP, ServiceNow

Confidential

CONSULTANT - SR. MAINFRAME TECHNICAL/SUPPORT

Responsibilities:

• Provide Backup and Accretions systems analysis and development support for the Data Delivery and Testing Support Branch (DDTSB) which is a mainframe application using COBOL, DB2, CICS, JCLs and Testbase database; Resolved morning ABEND issues, analyzed process improvements if feasible; performed backups and loads of the TestBase slices and Regional databases, communicate the outcome to the stakeholders, and ensure that there are no DB2 utilities running, and that there are no TestBase checkpoint flags pending a reset; Participate in the daily TDAT ABEND Resolution meetings with the TDAT resources to review the batch system ABENDs and to identify solutions for eliminating recurrences, as well as preparing and distributing meeting notes for approval
• Research the TDAT Tools User Interface (UI) to identify and document steps applicable for more efficient process and the work effort involved in mirroring the existing tool in the DBXX Test environment; Debug and resolve any DB2 problems; Perform testing changes to the Java programs in the DAT Tools UI for integration of the new Control-M libraries and the removal of the invalid email addresses
• Participate in regular meetings to analyze the scheduled tasks, review timeframes, evaluate resource assignments, and to discuss overall project progress; Provide daily operations support to fulfill the TDAT user requests, thereby allowing the TDAT staff to focus on process improvements; Resolve job failures; Discover an incorrect entry in the parameter Sequence (SEQ) and the table list in a parameter; Repartition TestBase DB in a DB2 subsystem; Research performance issues with DELETE jobs for DBs and run stored procedure
• Provide assistance with the resolution of dates set by SoftDate incorrectly in the CICS Validation regions, WebSphere servants, and the DB2 Work Load Manager; Review the Date Manager Morning Process report and created Helpdesk Expert Automation Tool (HEAT) tickets requesting the startup of 154 inactive WebSphere servers and 158 CICS AORs; By generating the On-Demand Ad Hoc report, confirm that all CICS AORs and WebSphere Servers were active and that all active objects reflected the correct virtual dates
• Utilize COBOL II, CICS, VSAM, MQ, DB2, REXX, JCL, TSO/ISPF, Stored Procedures, JAVA, Control-M, SAR, E(JES), DB Unicenter, Data Studio, MS-VISIO, SQL, SQL Server, WebSphere, DB2 Work Load Manager
• Motor Vehicle Commission is doing re-engineering on Agency System to be more reliable, less costly, and more efficient in customer servicing; Currently overhauling the current system which is purely on Mainframe; Convert ESCALA programs and COBOL programs into web services for web interface; Part of the Transformation team to analyze all access on CA DATACOM and convert them into SQL code for web service application; Produce documents (functional and technical) that will be used a business requirement for web application development; Utilize COBOL, CA-DATACOM, CA-DATACOM Data Dictionary/Data Query, DBMS, IBM Utilities, CA-ROSCOE, IBM-JCL, TSO/ISPF, SQL, SQL Server, MQ, CICS, GT IVORY STUDIO, MS VISUAL STUDIO, BMS, ESCALA, GT Ivory Studio, GLink, BizTalk and .NET

Confidential

CONSULTANT - SR. MAINFRAME ARCHITECT

Responsibilities:

• The Federal Housing Finance Agency (FHFA) has directed Freddie Mac (FRE) to integrate with Common Securities Platform (CSP) the company's defined securitization functionality; Freddie Mac has defined a multiple-phased approach - Phase 1 is to integrate with CSP the following transactions: Data Validation, Issuance, Master Servicing, Bond Administration and Disclosure; These are for Freddie Mac’s single class securities and underlying loan products and single class re-securitization and its underlying securities collateral; A new system, MBS Data Manager and Integration is developed to integrate the following business functions: loan removal; receive and store MBS related data into MBS App; calculate payments: preliminary factor, investor balance reconciliation and final factor; This system also develops solution to provide append data to CSP’s out files to FRB or vendors, which are necessary for Multi-family/Single family ARM products; Perform technical analysis, data requirements, development and implementation on the mainframe side; Perform technical design on UNIX (JAVA) and JAVA Scripts for Mainframe interface architecture to single and multi-class data elements of SAP application in MVS; Work on FTP utilities for data transmission into Oracle database; Utilize COBOL II and Enterprise COBOL; CICS, SAS; JAVA Scripts, APIs, SQL, DB2; FileAid; JCL; TSO/ISPF; Procs; VSAM; JobTrac; ISPW; FTP; Agile methodology; MS Outlook; Lotus Notes; Oracle DB; MS Servers; XML; Canonical Data Model (CDM); VersionOne Enterprise

Confidential

CONSULTANT - TECHNICAL/SUPPORT LEAD HP EXSTREAM

Responsibilities:

• Provide daily technical leadership to support various requests from resolving system abends to developing new functionalities on Credit Letters/Postcards application in Mainframe & HP Exstream (OpenText); Main support of CAS for Credit Letters/Postcards with exposures to Design Manager, PUB creation, Driver implementation, HTML and XML; Created complex bills and letters for customers and produce duplex outputs such as postcard, PDFs and XMLs; Utilize dynamic import from SQL databases for user’s dynamic request s for design changes and content changes; Analyze and recommends changes to correct production problems overlooked during system development on Mainframe and HP; Recommends improvements to streamline mainframe processes of Credit Letters/Postcards; Address various impacts on HP for change processes and flows & provide understanding to the team regarding implications on the Mainframe; Convert old COBOL into COBOL/DB2 in MVS environment; Utilize Unisys COBOL, COBOL 3, JCL, VSAM, DB2, HP Exstream (OpenText), File Manager, FTP, SQL Server, AFP, PDF
• Provide guidance in all phases of System Development Life Cycle (SDLC) for Credit Letters Re-Write with collaboration with Customer Ops, Public Affairs, Customer Outreach & Corporate Accounting in identifying immediate requirements; Participate in the current phase of the project in determining new processes, data/variables harvesting, driver file preparation and technical design on Mainframe processes to eliminate IBM/SCRIPTS; Provide system documentations on Credit Letters/Postcards to ensure and correct processes of the system;
• Oversee and provide day-to-day guidance to the team regarding requests on development, enhancement and maintenance of the system; Provide technical direction in running mainframe processes during volume tests; Directly interface with users on change requests and address any possible impact in the mainframe applications; Maintain knowledge of new software (HP Exstream v8) and discover useful functions and features to share with the team; Initiate learnings to maintain ancient IBM Scripts; Review and correct IBM scripts by eliminating codes that were already converted into Postcards; Help in maintaining and supporting other CAS systems such as REVSTAT and FMBC by providing technical assistance in coding, testing and deployment of mainframe applications utilizing Unisys COBOL, COBOL, COBOL LE, COBOL II, Enterprise COBOL, DB2, VSAM, JCL, TSO/ISPF; File Manager, ORACLE PL/SQL, SAR, GDGs, Decision Tables and CA Deliver

Confidential

CONSULTANT - PROJECT LEAD/MAINFRAME ARCHITECT

Responsibilities:

• Transform manual front-to-back Processes of FX structured products (under Wealth Management) into a full straight online Process; Solid leadership to accomplish the whole SDLC phases; Provide tasks, mentor and supervise day-to-day workload of four in-house consultants; Code CICS/COBOL II with XML parsing logic, MQ intervention and DB2 interrogation; Create test cases and scenarios using MS-EXCEL based on requirements provided in Business Requirements and Technical Specification documents;
• Conduct tests in various regions with users and business analyst and present/document results and findings; Conduct UAT and integration testing with various groups; Evaluate testing results; Collaborate with Business Analysts for test criteria and validation sequence Processes; Validate information in local electronic journal and mainframe systems; Utilize XML code to extract, transform and load (ETL) records into a logical set of fix message format into MQ adhering to the UBS standards FIX messaging protocols; Implement jobs and programs into production;
• Work with Orders, Executions and Trades (OET) Database group to capture and store all trade-related activity for equities, options, mutual funds and fixed income products on a real-time basis;The system provides subscription, publication and inquiry services by product and activity; Coordinate with front-end application group (JAVA, ASP) for synchronization of maps and data transmission between Mainframe and Client-Server side; Perform analysis on business constraints and strategies regarding the streamlining of batch jobs in production; Communicate with users on the performance and accuracy of job enhancements and recommend immediate solutions for problems on-hand; Quality assurance (QA) maintenance of existing production settlement and clearing Processing of the Matchbook Reporting System (MRS), and the Margins system, interfacing with other brokerage sub-systems like Prime Broker and Market Makers; Develop and maintain fixed income (FI) application that deals with Municipals, Bonds, CD, Equity linked securities and mortgage securities; Assist in the infrastructure and communication of OET core regarding order match/trade flow Process (edits, validation, detail, summary, notification); Perform FI configuration, P&S feed, reconciliation, summary, reporting and real-time trade matching;
• Worked to assist the Systems Programmers to work on internal facilities for hardware installs/upgrades and re-IPL of Mainframe operating system; Worked on the blueprints to learn and install new hardware, to plan for refreshes of disks, tapes and CPUs; Worked with the Mainframe Infrastructure Team and IBM to identify configuration requirements and document them, determine installation timelines and their refresh times, identify data center requirements and facilitate implementation of server refreshes;
• Streamline and maintain the mutual fund reconciliation Process (MFGI system) on priced orders, order creation, order exchanges, order cancel, cancel exchanges, order drops and order replaces using COBOL II, CICS, DB2, MQ, Message Broker; Perform CICS background Processing; Schedule all components to be migrated to production; Participate in the enhancement of interactive messaging for real-time matching (RTTM) of NSCC fixed income products; Develop batch and online programs which line to MSRB or NASD to facilitate matching and settlement; Use SWIFT message structure to format RTTM messages for real-time input of trade data for matching or price reporting purposes; Create threshold criteria for the messages that could be loaded into MQ to prevent damaging intraday data and to eliminate significant errors during reconciliation; Utilize COBOL II/III, CICS, VSAM, DB2 Ver.8, Stored Procedures, PL/1, PL/SQL, JCLs, TSO/ISPF, MQ Series, CICS MRO (multi region option); INTERTEST, CEBR, SWIFT, DB2 Ver. 8, SPUFI, PLATINUM, SAR, CHANGEMAN, STARTOOL, FileAid, SharePoint

Confidential

CONSULTANT - MAINFRAME PROGRAMMER

Responsibilities:

• Work on a new government regulatory compliance for OFAC which is a screening Process for check print and email services to be integrated into the EDI application system; Check transactions (EDI 820) sent to CITI via EDI is sent to NESS (Name and Entity Screening System) through MQ Series for screening Process; The MQ serves as a channel to send and receive responses to/from EDI and NESS; Warehouse DB2 updates, history and reconciliation Processes are done on the mainframe application; Work on different EDI format such as ACH Return into EDI 827, Paid Check Items into EDI 821, Lockbox Items into EDI 823, Issuances into EDI 828 and Control Totals into EDI 831; Create JCL jobs, procs, maps, DB2 table requests, DCLGENs, COBOL ENT coding; DB2/CICS coding; Unit and UAT testing and implementation; Participate in daily project meetings for enhancements and design changes; Create project plans according to project phases and present them for management decision and approval; Utilize COBOL ENT, CICS, DB2 Ver.8, MQ, VSAM, GDGs, Changeman, InfoMan, OPCC Scheduling
• Work on a new application that sends certain claims to Orthonet for claim audit that meets the company's internally set threshold values; These claims are sent via Health Care Claim Transaction File (EDI 837P) from QCare after the batch claims adjudication and Process is complete and claim is in pre-financial status; Orthonet would then give recommendation for either denial or payment by sending us another file (via EDI 277U);
• Accomplish the whole phase of SDLC from data gathering, system analysis, technical and functional design, coding, testing and implementation; Utilize COBOL II, TS Queues, MQ Series, with XML data parsing between Orthonet (EDI 837P) & EmblemHealth (EDI 277U); Generate programs to encrypt the files and transmit/exchange them via MFT (secure Process); Participate in the manual testing of the application with assistance from the QA/UAT Team; Create test scenarios and test database all across other applications to make sure that all files are logically in-sync; Perform full-cycle test and document each test conditions and results;
• Work on the Billing System of the company using Customer1; Upgrade the billing process with the integration of web based applications in MS-SQL Server database and pass information into the Customer Service agents which is also being handled and maintained by Customer1;
• Provide program specs and documentation using MS-WORD and MS-VISIO for business presentation and signoffs; Coordinate with other application groups for system interface and external Processes; Prepare all files, databases, target records in QA region for UAT and integration testing; Facilitate in the implementation of all components (JCLs, PROCs, copybooks, key records, maps and programs) into production environment; Utilize COBOL II, JCL, TSO/ISPF, PROCS, SYNCSORT, VSAM, DB2 Ver.8, SQL, SPUFI, TSQ, TDQ, MQ Series, XML, EDI 837P, EDI 277U, BMS, FileAid, XPEDITER, LIBRARIAN, MS-WORD, MS-VISIO, SharePoint

Confidential

CONSULTANT - PROGRAMMER ANALYST

Responsibilities:

• Accomplish system testing, functional and integration testing for the retirements of Power Plant System; Work Management System (WMS) serves as the source for asset data that interface with Property Records System and Power Plant System; Code CICS/DB2, online & batch coding, DB2 interrogation using Stored Procs and Triggers, integration testing and implementation of programs, tables and screens to be passed onto JAVA, ASP and .NET applications SOA protocols & standards; Perform modification, enhancements, new screen developments, unit and integration testing to consolidate features of Power Plant System into the existing PLUS system;
• Perform online enhancements and batch developments (COBOL II, JCL, DB2, VSAM) to effectively monitor security application on the mainframe side and at the same time, create shell scripts in-line with the security changes in the mainframe world; Prepare test plans and test cases for Unit testing, Regression testing, QA/UAT Testing; Instituted QA Processes and testing parameters, automation scripts, templates, test databases, scenario libraries, performance testing and benchmarks for major system changes and releases, and of business analysts during UAT; Utilize MVS/XA, DB2 Ver. 8, SQL, SPUFI, DB2 Stored Procedures, SQL Triggers, COBOL II, CICS, SDF, GDG, JCL, VSAM, UNIX and MS-Excel; Utilize IBM utilities such as IDCAMS, DF/SORT, IEBCOPY, IEFBR14, FILEMANAGER, IBM DEBUGGER

Confidential

CONSULTANT - LEAD PROGRAMMER ANALYST

Responsibilities:

• Convert current protocols/message formats to preferred industry standard FIX format using Message Queuing (MQ) to satisfy the fix messaging system of Jefferies that will feed other online applications throughout the company; Participate in providing DB2 data objects and models to facilitate in the design of an SOA architecture within the company to feed the front-end application system;
• Perform system integration and conversion from IDEAL to COBOL II programs with major changes in logical and physical design; Perform system analysis and design, code and implement COBOL II/CICS and batch programs and maps; Change IDEAL based screen programs into BMS with CICS/COBOL II to suit the Datacom database; Code and enhance CICS/COBOL II and COBOL III to reconcile trade allocation feeds and generate real time acknowledgement and to link these allocations into executions for analysis and reporting; Develop and automate functions to perform mass cancels/corrects in large volumes for the P&S group in support of the Program Trading Desk using dynamic SQL; Utilize MVS OS/390, DB2, Dynamic SQL, MQ, Stored Procedures, Enterprise COBOL, CICS, Changeman, GDG, JCL, VSAM, MS Project and Excel; Utilize IBM utilities such as IDCAMS, IEFBR14, IEBCOPY; DF/SORT, DB2 Ver. 8

Confidential

CONSULTANT - LEAD PROGRAMMER ANALYST

Responsibilities:

• Work on RBC Dain Conversion project; Develop new Broker Reg Screen to in corporate fields that RBC Dain uses for extraction to CheckFree and various trade edits/inquiry purposes; Work on Real-Time Blue Sky, Managed Accounts, and other BPS/A distributed infrastructure to ensure adequate performance and capacity; Work on MCGU (Mutual Fund Commission System) to read new B1's for inactive representatives and dollar threshold whenever edits are performed;
• Created enhancements to the MFRS Networking System to produce reports of fund conversion received on same day, and position report that where received in the DTCC networking position file; Data conversion from VSAM to DB2 databases; Convert other applications from IDMS to DB2; Utilize Cullinet in IDMS to access/transform database information and convert them into DB2; Process of ACATS/Non-ACATS transfer requests to DTC; Enhance account transfer on ACATS, mutual funds re-registration and physical Processing; Furnish clearing firm RBC Dain for access to funds and securities for them to enter orders; Utilize MVS/XA, COBOL II/III, CICS, VSAM, DB2 Ver 8, DB2 Stored Procedures, PL/1, PL/SQL, JCLs, MQ Series, CICS MRO; INTERTEST, CEBR, SWIFT, SPUFI, PLATINUM, SAR, ENDEAVOR, CHANGEMAN, STARTOOL, FileAid
• Develop and implement a Processing engine for Redemption System; This application handles the monitoring, Processing and distribution of redemption events on government, municipal and corporate bonds and money market instruments; Code, test and implement batch COBOL II, CICS/COBOL II and interface with DB2, XML and LDER tables using HPS system; Utilize INTERTEST, JCL, PL/1, PL/SQL, FILEAID, MS-EXCEL, DB2 Ver. 5, SPUFI, PLATINUM
• Perform all phases of SDLC to implement batch and online programs to facilitate the data movement from SAP to Mainframe and vice versa; Code ETL programs and objects for data mapping and extraction to meet data conversion requirements; Design and develop ETL jobs, scheduling and monitoring Process; Create ETL documentation using data flow diagrams, rule-sets/thresholds and mappings; Perform data analysis and data cleansing Process to extract, transform and load (ETL) the data into DB2 instance using XML data format; Maintain legacy billing that issues user transactions/statements and updates DB2 databases;
• Provide functional/technical documentation for technical personnel and business users using MS-VISIO; Create test scenarios/scripts and execute them using QuickTest or TestDirector; Code ETL jobs and routines to Process error handling, batch control and FTP Process; Code DataStage data mapping programs with selection criteria for DB2 ETL Process; Code COBOL II/DB2 programs to generate cross tables to be utilized and loaded into SAP; Involve in the technical feasibility testing and integration testing for both legacy and SAP to ensure accuracy, consistency and compliance with business rules and guidelines; Utilize MVS OS/390, COBOL II, CICS, DB2 Ver. 5, SAP, MQSeries, VSAM, ORACLE, TOAD, DataStage ETL, SQL-PLUS, MS-ACCESS, Stored Procedures, QuickTest, TestDirector, JCL, FILEAID, FTP, XML, VISIO, UNIX
• Design, code, test, implement and maintain CICS/DB2 application for Broadcort/Citation System to support its Financial Data Services, specifically the retail offering of domestic mutual funds to the Introducing Firm (IF) clients, order execution, settlement, record keeping and maintenance; Develop an online applicaton that determine fair value of futures OPTIONS to provide quicker responses to order placements and calculated market risks and evaluated OPTION premiums in real time; Generate logical Processes to analyze volatility relationships within the futures and OPTIONS complex, particularly its historical relationship to other products; Direct conceptual, strategic, and tactical creation of robust and integrated online and batch solutions utilizing COBOL II, CICS (with multi region Processing), DB2 and MQ Series;
• Perform QA testing on referential data integrity between tables and initiate performance testing with other applications which uses the same data and Processes; Setup and manage programs, jobs, PROCs and copybooks to be migrated to PROD using ENDEAVOR;
• Design and implement MQ interface to serve as repository of introducing firm's information and create Trigger Level parameters to execute another transaction and produce output file by running a batch Process following the parameters for SOA architecture; Interrogate Security Master database using the record captured from MQ and verify financial information for the Processing of financial transaction depending on the request received from MQ; Use FTI application to fix and standardize decimalization routines for the Citation system; Streamline the MQ Series design for effective and accurate flow of Processing of records; Define/generate CICS/DB2 programs to automate fund transfer Process for conversion, support IF firm trading, physical clearance, settlement, commission calculations and reconciliation, and ensure that Sharelot is updated from conversion and maintained to effect the correct trailing commission payments and CDSC calculation; Perform CICS background Processing using batch job; Utilize IBM Merva, MVS, COBOL II, CICS, PL/1, PL/SQL, DB2 Ver. 5, DB2 Stored Procedures, SYNCSORT, JCL, VSAM, GDGs, MQ Series, TD Queues, INTERTEST;
• Develop a real-time trade and settlement date position database (GCDB) to interface Online Trades Processing (OLTP) system and securities settlement systems to show up to the minute collateral availability; Utilize DB2, Triggers and JAVA (front-end) application; Supervise and manage day-to-day activities/workload of two consultants; Provide program specifications to these consultant and direct to the company's protocols; Design and implement data models to determine and classify parent/child relationship; Create and implement indexes for each table defined in the data model; Provide database management, converting the old VSAM and QSAM access method into DB2 to maximize the use of all collaterals in the firm, reduce fails and find additional sources of raising cash; Manage and enhance cross databases for mutual products with pricing and other FC's commission rates;
• Generate viewingcapabilities to Treasury, Asset and Liability Management (ALM), Risk Management and Global REPO Operations; Utilize Security Master database to populate GCDB tables by capturing related data and maintain the newly defined tables to be in-sync with Security Master; Link to FTI application for calculation/determination of T+1 settlements from open date; Using FTI application, create programs to consolidate the information and distribute them to internal/external users; Provide documentation and user's s of internal codes and their interpretations in the programs which is part of the system analysis documentation for the group;
• Create MQ Series application to hold different data structures according to its application source and create NEON rules per data conditions inside MQ; Initiate online transaction using trigger levels in MQ to clean up other MQ series which is a perpetual transaction as long as the MQ is open and active in mainframe; Create NEON rules to capture/filter pertinent data from other platforms to be Processed by a DB2 application; Interface with COGNOS to generate dynamic SQL codes for users to apply for the creation of input data to be fed to DB2 in mainframe; Utilize COBOL II/CICS and CICS/DB2 programs, DB2 Stored Procedures, DB2 Ver. 5, INTERTEST, MVS, FILE-AID, SYNCSORT, HTML, SPUFI, PL/1, PL/SQL, VSAM, TDQs, EDI, MQ Series;
• Enhance and maintain Portability System (Mutual Funds) to enable outside broker/dealers to trade company's asset management (MLAM) mutual funds to outside customers; Work on the branch office security system (BOSS) which facilitates/maintains individual's security access to the company's CICS network at the West Street and Teleport Datacenters; Support the maintenance of Trust Application System written in CICS, COBOL II, VSAM and IDMS; Function trimmings and enhancements of programs; Project was put on-hold (contract not finished) per management decision; Utilize COBOL II/CICS, FILEAID, VSAM, EASYTRIEVE+, SYNCSORT, IDMS, JCLs, PROCs, MS-WORD, MS-VISIO