OVERVIEW
A proficient Software Developer with extensive experience in systems analysis and design and programming in various languages like COBOL and Natural and familiar with DB2, MS Office, MS Project and MS Visio. Exposed to the mainframe environment for more than 10 years utilizing JCL, VSAM, and MVS utilities. Worked for companies like American Armed Forces Mutual Aid Association AAFMAA , Morgan Stanley, NABISCO, Inc., and Leviton Mfg. Inc., handling insurance, financial, accounting, payroll, manufacturing, and brokerage applications. Able to interact with users and address production problems. Self-motivated, analytical, and team player who can leverage skills and background to contribute to the success of the organization.
Skills Profile
| |
- Databases / DB Tools/ File Access Methods:
| - DB2, ADABAS, Access, SQL, Sybase, Excel, CONNX
|
| - IBM ES-9000, IBM 3090, IBM 43XX, IBM S/36, PC, Mac
|
- Methodologies / Techniques:
| - 4GL Programming, Batch Programming, Systems Analysis and Design
|
| - IBM z/OS, IBM OS/390, MVS/ESA, MVS/XA, UNIX, SSP, Windows 7/8
|
- Utilities / Applications/ Command Languages:
| - Visual Studio, MS Project, MS Visio, JCL, TSO/ISPF, IDCAMS, XML, SPUFI EntireX, CICS, FTP, XMITIP, PREDICT, JES3, XTERM, SPoD, CRM, SCL, BCP, VM, Rhumba, CONSTRUCT, ICCF/SPIFFY, VOLLIE, DIRECT CALL, MS Office, ExamDiff Pro, Adobe Acrobat 9
|
Professional Experience
Confidential Sr. Software Engineer |
Maintained and enhanced the Insurance Administration System IAS and Services Administration System SAS of AAFMAA Army and Air Force Mutual Aid Association . Was involved in migrating legacy systems mainframe-based to UNIX. Created and maintained programs that send information to .Net applications via EntireX. Assisted and worked closely with business analyst to manage projects and produce documentation using MS Project and MS Visio. Gathered requirements from users and coordinated closely with them throughout the development and testing processes including unit, QA, and system testing. Built test data to suit various scenarios and applied extensive and intensive testing procedures to ensure production-ready modules and applications. Enhanced programs/subprograms and applied fixes to production problems when necessary. Worked with UNIX scripts for file FTP, etc. |
Environment: Natural, ADABAS, UNIX, SPoD, MS Project, MS Visio, .Net, EXCEL, WORD, ACCESS |
Confidential |
Sr. Programmer-Analyst |
- Maintained and enhanced the Customer Service System CSS by developing and modifying online and batch programs and procedures. CSS is composed of the Order Entry, Order Processing, Billing, and Inventory Sub-Systems. Usually developed online update and query programs that submit batch jobs which FTP files to the PC.
|
- Developed online and batch programs and procedures based on user requests.
- Enhanced programs/subprograms.
- Coordinated closely with users regarding program specifications and requirements.
- Built test data to suit various scenarios and apply extensive and intensive testing procedures to ensure production-ready modules and applications
- Applied fixes to production problems.
- Found a way to retain leading zeroes, inline double quotes and commas and multiple heading lines in CSV files when mainframe work files are FTP'd to the PC.
- Created an online program that submits a batch job to send email with attachment to users.
- Designed and created a Terms and Conditions document that is attached to emails to customers.
|
Environment: Natural, ADABAS, JCL, TSO/ISPF, FTP, XMITIP, PREDICT, CONSTRUCT, JES3, EXCEL |
Confidential |
Mainframe Developer |
- Maintained and enhanced the WIRE Worldwide Interest Rewrite System by developing and modifying programs and procedures and providing support to various business units on a daily and nightly basis.
|
- Developed and enhanced programs and procedures based on user requests.
- Coordinated closely with users regarding program specifications and requirements.
- Built test data to suit various scenarios and apply extensive and intensive testing procedures to ensure bug-free modules and applications
- Wrote JCL's to upload data files to Sybase via BCP and send emails to users when jobs abend.
- Provided production support 24/7 for two weeks on a rotating basis.
- Debugged and fixed program problems.
- Streamlined the extract process by combining all JCL's into a single procedure for efficiency and uniformity.
- Created a forecasting process for the Billing Posting System.
- Created macros to simplify the generation of comparison reports in EXCEL
|
- Environment: Natural, ADABAS, TSO/ISPF, DB2, SYBASE, UNIX, SQL, BCP, JCL, FTP, JES3, XTERM, ACCESS, EXCEL
|
Confidential |
Senior Pastor |
Served as full-time pastor of a Filipino-American church in Brooklyn, NY for almost six years. Decided to return to programming after getting married and having two children to support them and have more time for growing family. |
Confidential |
Sr. Programmer-Analyst |
- Maintained and developed programs to process trade information for the Equity Trades System.
- Modified programs to make them Y2K-compliant.
|
- Wrote new programs.
- Debugged and fixed program problems.
- Converted programs for the Y2K project.
|
- Environment: Natural, ADABAS, TSO/ISPF, JCL
|
Confidential |
Sr. Programmer-Analyst |
- Maintained and developed programs for the Trade Capture System and provided technical support to the Prime Brokerage group on a daily and nightly basis.
|
- Wrote programs to reformat trades transmitted by clients via FTP.
- Wrote programs to reformat trades transmitted by clients via the SWIFT system.
- Created JCL procedures for trades processing.
- Debugged and fixed program problems.
|
- Environment: Natural, ADABAS, TSO/ISPF, JCL, RHUMBA
|
Confidential |
Programmer-Analyst |
- Coded, tested, and implemented COBOL programs that accesses DB2 and developed and maintained JCL's using TSO/ISPF. Tasked with maintaining the General and Administrative Budget System which processes employee information used by the Payroll Department to calculate payroll, tax, benefits and cost by individual and also utilized by the administration to calculate general and administrative expenses by account number.
- Coordinated closely with users regarding requirements.
- Fixed production problems.
- Developed and maintained Natural programs using Adabas for the Time and Attendance System TAS to process employee information which is subsequently passed on to Payroll.
|
- Environment: COBOL II, DB2, Natural, ADABAS, ADASQL, VSAM, TSO/ISPF, JCL
|
Confidential |
land Titles Office CLient Public Sector |
Consultant |
- Developed and maintained programs and procedures for the Business Operations System to process land titles online to provide better reporting and monitoring of the system thereby reducing delays in processing workflows.
|
- Environment: Natural, ADABAS, TSO/ISPF, JCL
|
Confidential |
- Developed programs for the General Accounting Service System to process customer information in relation to gas utility consumption.
|
- Environment: Natural, ADABAS, CONSTRUCT, PREDICT
|
Confidential |
- Maintained programs for the Investment Portfolio System to produce daily, monthly, and annual reports on the amount and nature of bank investments.
|
- Environment: Natural, ADABAS, TSO/ISPF, JCL
|
Confidential Financial Services |
Programmer |
- Coded, tested, and implemented COBOL/CICS programs and JCL's using TSO/ISPF and maintained the same for the Payroll System to process employee information and produce reports.
|
- Environment: COBOL, CICS, Natural, ADABAS, RPG III, PANVALET, VSAM, TSO/ISPF, JCL
|