ALEXANDER G. TAN
101 Clendenny Avenue
Jersey City, NJ 07304
[Send email to request phone number] 04-3241
[Send email using form at bottom]
SUMMARY OF QUALIFICATIONS
Analyst/programmer with over twenty years of extensive IT experience and
knowledge in the development and enhancement of batch and online data processing
systems. Most current experience is with a major brokerage company. Successful
accomplishments in the design, programming, implementation and documentation of
various data processing applications achieving datelines and expectations.
TECHNICAL SUMMARY
Technical and software expertise include proficient usage of COBOL/VS, COBOL II,
DB2, SQL, VSAM, MQ-Series queue processing, CICS (Command Level), FileAID, IBM
Sort, SyncSort, JCL, BMS, ISPF, TSO, ChangeMan, ENDEVOR, Word, Excel, Visio, HPS,
FTP, InterTest, Xpediter, SmartTest and Easytrieve. Experience includes
analysis, design, programming, testing, implementation, documentation and
maintenance of new and existing application systems under MVS (OS/390) mainframe
operating system.
PROFESSIONAL EXPERIENCE
DEPOSITORY TRUST CLEARING CORPORATION, NEW YORK CITY, NY 2005-2008
Consultant/Employee (Analyst/Developer)
Designed, programmed, tested, implemented and documented various processing
enhancements of the company’s Risk Management Division’s Pricing Consolidation
project, to create a Centralized Pricing Database for its DTC and NSCC systems,
that contains the final prices for all identified securities, including all
securities eligible at the various subsidiaries and will feed the applications
and databases at the subsidiary level, involving positions, settlements and
clearances of fixed-income, equities and Corporate Action. Major person in the
design, programming, testing, implementation and documentation of the project.
Also, lead person in development and implementation of other major systems:
EuroCCP, IDNET, Mark-to-Market, and Clearing Fund Management for MBS, GSD and
NSCC subsystems. Technical environment requires proficient usage of COBOL II,
DB2 (DB2 UDB for OS/390), SQL, MQ-Series queue processing, VSAM, JES2 JCL,
FileAID, SyncSort, ChangeMan, VSAM, CICS, Word, Excel, Visio, FTP, ISPF and
MVS/TSO.
· Developed, tested and implemented various enhancements, programs and execution
JCLs for the Pricing Consolidation project, creating a Centralized Pricing
Database for all eligible securities, feeding the DTC and NSCC systems dealing
with positions, settlements and clearances of fixed-income, equities and
Corporate Action.
· Developed verification programs to validate securities prices in existing
master files versus the new Centralized Pricing Database.
· Provided quality assurance support, tested and migrated various execution
JCLs, PROCs and CNTL members to test and production environments.
· Lead person in various systems’ development and implementation, including
providing and maintaining functional and technical specifications.
· Provide lead, assistance and support to junior programmers.
· Provided verification assistance to various user groups.
· Developed and implemented procedures for FTP upload of data from front-end
distributed processing systems, and analyzed workflows, defining systems
requirement specifications for data transfer and conversion between the DTC and
NSCC systems.
· Developed, tested and implemented various EuroCCP enhancements to programs and
procedures of the Pricing Consolidation project, to process currencies from the
European Union.
· Developed, tested and implemented various programs and execution JCLs for the
IDNET project, utilizing MQ-series queue processing for creating netted positions
for eligible securities for Mark-to-Market processing, feeding back to
distributed processing systems.
· Developed, tested and implemented various enhancements, programs and execution
JCLs for the Clearing Fund Management accounting system, to keep track of
Participants’ ledger positions for the MBS, GSD and NSCC subsystems.
· Experimentation and application of advanced Syncsort and DB2 options.
· Worked with batch and online applications.
· Developed, maintained and implemented various job scheduling documentations.
· Monitored testing cycles, and debugged and implemented changes for program
abends.
CREDIT SUISSE FIRST BOSTON, NEW YORK CITY, NY 2003-2005
Consultant (Analyst/Programmer)
Designed, programmed, tested, implemented and documented various processing
enhancements of the company’s Repo Processing Layer (RPL) system and its
multi-system UAT testing environment; as well as provide quality assurance
support in the 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, Market Makers,
Equities, Fixed-Income and Corporate Action forecasts. Technical environment
requires proficient usage of Panvalet, VSAM, JES2 JCL, COBOL/VS, COBOL II,
FileAID, SyncSort, Xpediter, HPS, DB2 SQL, DBArtisan, ISPF and MVS/TSO.
· Developed, tested and implemented various enhancements, programs and execution
JCLs for the Repo Processing Layer (RPL) system, Matchbook Reporting System
(MRS), Position and Balance (P&B), Margins, and Fails Report systems.
· Developed, tested and implemented various FTP execution JCLs to transmit
mainframe files to other subsystems running corresponding Crystal Reports.
· Developed reconciliation programs to match trades by Trading Account and by
Customer Number for RPL and P&B systems.
· Developed, maintained, tested, and implemented various HPS modules for the
P&B, Margins and Fails Report systems, interfacing with various brokerage
sub-systems like Fixed-Income, Equities, Prime Broker, Market Makers, and
Corporate Action forecasts.
· Provided quality assurance support, tested and migrated various execution
JCLs, PROCs and Procdata members to UAT and production environments.
· Help analyzed, debugged and provided solutions for various processing
bottlenecks in existing production run cycles, including optimizing DB2 database
performance.
· Worked with batch and online COBOL, DB2, CICS programs, MQ-Series queues, and
SQL Procs.
· Developed, maintained and implemented various job scheduling documentations.
· Monitored testing cycles, and debugged and implemented changes for program
abends.
MERRILL LYNCH, JERSEY CITY, NJ 1995-2003
Employee (Analyst/Programmer)
Designed, programmed, tested, implemented and documented various online and
batch processing of the company’s government securities settlements and clearing
processing system (GSI); as well as provide support in the maintenance of
existing online and batch processing of the GSI system. Also, worked with
systems and programs using DB2. Technical environment requires proficient usage
of ENDEVOR, CICS Command Level, BMS, InterTest, VSAM, JES2 JCL, COBOL/VS, ISPF,
TSO/E, and MQ-Series queue processing.
· Designed, programmed, tested, implemented and documented numerous new online
and batch processing of the GSI system, providing enhancements and compliance
with regulatory requirements in processing of government securities of the
company.
· Supported and maintained existing online and batch production programs that
handle the trade, clearing and settlement processes of the GSI system, dealing
with fixed-income, equities, treasury bills, notes and mutual funds.
· Designed, programmed, tested, implemented and documented various inter-company
reconciliation and breaksheet subsystems to verify and confirm securities’ daily
positions.
· Coordinated and implemented testing of system enhancements with other
brokerage institutions and departments, ensuring viable production
implementations.
· Converted existing VSAM and IMS-based customer master file processing to
company-centralized DB2-based SMDB master file.
· Involved in the Year 2000 (Y2K) conversion of all batch and online programs;
responsibilities include programming, testing and implementation of programs
written in COBOL.
· As part of Disaster Recovery effort, primarily responsible for helping
relocated users set up new connection and access to GSI online system.
· Involved in conversion to MQ-Series queue processing of online programs.
· Helped users resolve daily production problems on a timely basis.
· Provided continuous assistance and support to define company-wide front-end
users’ terminal definitions for access to the GSI online system.
· Provided timely ad-hoc reports and files, as per requests of front-end users.
· Mentored other teammates and users in programming, support and usage of the
GSI system.
NEW YORK CITY BOARD OF EDUCATION, BROOKLYN, NY 1989-1995
Consultant (Analyst/Programmer)
Developed, maintained and enhanced the institution’s system to track placements
of special education students. Technical environment required proficiency in
Anscobol, COBOL II, using IDMS, ADS/Online, ADSG, IDD, OLQ, DB2 and CICS Command
Level; for the IBM 3090 running MVS/ESA utilizing VSAM, JES2 JCL, ISPF and
TSO/E.
· Developed, maintained and enhanced the Child Assistance Program (CAP) System;
the online and batch IDMS system keeps track of placements of students requiring
special education services.
· Designed, programmed, tested, implemented and documented various new and
existing online and batch projects; e.g., Monthly Register, Adult Planning
Referral, Citywide Reports, Provider Maintenance, Agency Maintenance, CAP to CAFS
Interface Project, Triennial Reports,, including IDMS subschema records change,
CICS file and table maintenance.
· Maintained production JCLs, procedures and documentations.
EDUCATION
B.S., Electronics Engineering, UNIVERSITY OF SANTO TOMAS, Manila, Philippines
|
