SUMMARY OF QUALIFICATIONS

Highly experienced IT professional offering 24 years of experience working in Financial (Listed Derivatives, Commodities Futures/Options), Banking (CASA, Loans and Credit Cards) and Human Resources (Benefits and Payroll) industries

Very effective leader with proven capability in technical analysis/design leading combination of full-time employees and consultants through all phases of Software Development Life Cycle (SDLC)

Innovative thinker providing the most cost-effective, secure and user-friendly solutions

Good interpersonal skills, able to effectively communicate with business end-users, regulatory/vendor representatives and technical developers

Expertise in mainframe (21 years) development, testing and deployment/implementation

Capable of working in mid-range (5 years) and distributed (3 years) environments or platforms

TECHNICAL SKILLS

PROGRAMMING/TECHNOLOGIES: COBOL, CICS, DMS, MVS/JCL, NATURAL, Easytrieve+, FOCUS, CList, REXX, ASP, Perl, C#, SQL, JavaScript, WebSphere Application Server, WebSphere MQ, XML, RPG, CL

DATABASE SYSTEMS: VSAM, IMS/DB, DB2, MS SQL Server, ADABAS, Oracle SQL Developer, Qlikview, Business Objects

OTHER SOFTWARE: TSO/ISPF, IDCAMS, Comparex, Sync Sort, File Aid, Changeman, Expediter, InfoPac, JobTrac, OPCA, MS Word, MS Excel, Visio, Spufi, PowerPoint, STAR Tools, PC Span, Cyberfusion, SQL Server Management Studio, GoAnywhere, Power Designer, JIRA

INTEGRATED DEVELOPMENT ENVIRONMENT: Visual Studio

PROFESSIONAL EXPERIENCE

RCS IT Services, Inc. July 2016 – November 2016

Senior Business/Functional Analyst, Consultant assigned at Deutsche Bank (DB)

Part of a 6-member team that supported 27 downstream applications which consume the Canonical Data Models normalized from StreamCore tables/GMI files as DB’s Listed Derivative business converted its R&N system to GMI in an industry-setting record 20-month conversion project

Accelerated user issues resolution by helping users understand the attributes in the models, facilitating the creation of BRDs together with product SMEs for new attributes/tables/processes as per user requirements, creating FSDs/FRDs/CRs (change requests) for product enhancements to be submitted to SunGard/FIS (GMI vendor), or reconciling data produced from R&N with data from StreamCore/GMI

Conducted team huddles wherein user issues/projects/concerns are discussed

KForce Inc. May 2005 – April 2016

Information System Consultant assigned at Jefferies Bache LLC (JBL) (previously Prudential Bache Commodities (PBC))

Analyzed, developed/amended, tested, implemented and documented processes for JBL’s Commodities - Futures and Options (CFO), a multi-platform system (mainframe, AS/400) written in COBOL, COBOL 400, RPG and CICS using VSAM and DB2:

oSlashed PBC’s hardware operating expenses 67% by eliminating its Chicago and London AS/400 data centers thru the migration of report and file processes to CFO’s mainframe

oMaintained US regulatory (CFTC, exchange-related), UK regulatory (FSA, ICE, LME), Position, Commission and Fees sub-systems by gathering regulatory body/user requirements, creating BRDs/FRDs/FSDs, coding, testing, implementing and documenting processes

oEliminated 5 daily man-hours by automating trade entries for various vendors (Montreal, MacQuarie, DBS Vickers, Barclays, Nomura)

oRe-engineered SMART payment processes to GTreasury; provided technical specs/FRDs/FSDs to GTreasury

Served as lead analyst/developer for all data extraction processes for CFO’s transition to UBIX (scrapped project); wrote most technical specs/FRDs/FSDs for JBL-specific processes for possible UBIX customization

Served as lead analyst/developer for all VSAM/DB2 data extraction processes for CFO’s transition to GMI; coordinated with SunGard/FIS technical group on understanding JBL’s data for effective conversion to GMI; liaised with users and regulatory bodies (CFTC, Exchanges, OCR, FIA) for testing and submission of files from GMI

Served as lead analyst/developer for all GMI-Vendor Positions interim reconciliation processes; coordinated with Frontier by providing technical specs/FRDs/FSDs on re-engineering various vendor positions reconciliations

Tested and implemented vendor (FastFill, WTD) products into GMI

Wrote workaround solutions/programs as per user requests using various utilities (e.g., Work Query, CL) in AS/400

Wrote C# extraction programs for sub-systems interfacing with GMI

Acted as point/resource person for any changes in User Security Maintenance, GMI and/or Vendor Cross Reference and Real-Time Prices in test environments and coordinated with JBL’s Service Help Desk for production changes

Coordinated with SunGard/FIS technical group for JBL-specific developments/enhancements, testing and implementation into GMI (e.g., Journal Entries – Cash and Adjustments, G/L, Interest), Batch Optimization and EMIR Collateral Valuation changes

Liaised with users for gathering requirements, testing and implementing SunGard/FIS upgrades/patches/CSBs/PTFs to GMI, position transfers (XPITs) using vendor WTD utility during JBL’s business wind down

Decommissioned GMI system, facilitated the transition of GMI/FX to Spectrum, decommissioned JIM (an in-house GMI interface system), turned over support of Operations Web Portal as well as various Business Intelligence software imbedded within the portal to an outsourced support group

Saved JBL $10M by creating a portal hosting CFO reports instead of buying a software/license to archive all compliance reports; accomplished by extracting Infopac entries, splicing and zipping them to be loaded in locked-down JBL servers then unzipping them to be presented in the portal

Pinkerton Computer Consultants Inc. (PCCI) April 2000 – December 2004

Information System Consultant assigned at Prudential Securities Inc. (PSI)

Involved in analysis, development and testing of components of PSI’s Tesseract systems, namely: Human Resources, Benefits and Payroll as well as PSI’s Employee Archive Reporting System (EARS)

Served as lead developer for the following projects:

oPSI to Prudential and Wachovia Securities Merger project

oTesseract conversion to PeopleSoft

AIT- AUSTRALASIAN IT PTE. LTD. January 1997 – April 2000

Systems Analyst/Programmer assigned at CITIBANK, N.A. – Regional Card Center (RCC), Singapore

Member of a team that was responsible for the analysis, design, development and testing of the Enhanced Cardpac System (ECS) used regionally in Taiwan.

Provided 24/7 production on-call batch and online support

AIT- AUSTRALASIAN IT PTE. LTD. January 1996 – December 1996

Systems Analyst/Programmer assigned at Sony Systems Design International (SSDI), Singapore

Involved in the development and testing of extraction programs for data migration of SSDI’s VSAM files in DOS/VSE mainframe environment to ORACLE tables in a distributed environment

Sarte, Teodoro and Associates Inc. (STA Inc.) May 1993 – December 1995

Senior Programmer

Outsourced to Malaysia Borneo Finance Information Systems (MBf-IS), Interface and Deposit Teams in Kuala Lumpur, Malaysia from October 1994 to December 1995. Used Natural/ADABAS as well as CICS/DMS, COBOL in mainframe environment. Involved with the analysis, design and development of new and/or enhancements to the existing Interface and Deposit systems. Made enhancements to meet the statutory requirements of the Securities Commission of Malaysia. Developed ad hoc programs to generate reports and update files as per user requests

Outsourced to Rizal Commercial Banking Corporation IT (RCBC-IT) in Makati, Philippines from July to September 1994. Used COBOL and Easytrieve in mainframe environment

Part of the Dao Heng Bank Conversion Project – involved in the migration of batch and online OS COBOL programs in DOS/VSE environment to VS COBOL II programs in the MVS/ESA environment

Taught Analytic Geometry with Introduction to Differential Calculus in STA-College of Computer Sciences in Las Pinas, Philippines from November 1993 to March 1994

EDUCATION

BS in Mathematics Major in Computer Science (1989 to 1993), University of Santo Tomas, Manila, Philippines

Graduated Cum Laude

Contact this candidate