SUMMARY:

Experienced Analyst and Programmer possessing high energy and motivation and focus and drive and the ability to excel at all phases of a development or enhancement or modification or conversion or production support Information Technology project in the Financial and Healthcare spaces. Quick learner and very resourceful. Deadline driven. Have a passion to understand and specify the business and to quickly codify the business rules and databases and to show samples/trials to the business user and to put a useful tool into production and to support it thereafter. Have worked in Finance and Global Wealth Management and Accounting and General Ledger and Payroll and Book-Keeping and Data WareHouse and Tax and Balance and Control and Government Operations and Brokerage/Investment-Banking and Securites Processing and Capital Markets and Corporate Actions lines of business. Very good with problem research and root-cause analysis and resolution. Very good with deciphering and documenting old complex code. Global experience analyzing/resolving software issues in 24X7X365 environment Onshore-Offshore Business Model .

EXPERIENCE:

Confidenital

Systems Analyst and Applications Programmer/Analyst and Project Lead Contract

• Improved the Reconciliation Process by adding a clearance report for the EPAY Vendor and by pulling data from this report and from the cashed report so as to create a new report that contains the correct certified opening and closing balance for all vendors.
• For Accounts Payable and General Ledger and Payroll and Accounting Departments and within the ASI Mainframe Vendor Package: Designed, created, tested, implemented and supported COBOL Batch Programs some contained an internal SORT that created reports and EXCEL Spreadsheets and extract files that were copied to a website . Used VSAM and sequential files and JCL/Utilities/SORT and REXX. Corrected the spelled-out check amount on the checks. Have also performed the Project Lead role and the Systems Analyst role for projects.

Environment: ISPF/TSO COBOL VSAM JCL/Utilities/SORT REXX

Confidenital

Applications Programmer/Analyst Contract

• Within a COBOL/DB2 Stored Proc that I was responsible for, remote data from the Department of Defense was missing I fixed this software problem and saved the client the additional trouble of having to search for this data on other systems.
• For the COPAY Benefit Pricing System, working on technology gaps created by the merger merging the systems from a data and programming perspective thereby providing the same look-and-feel for the users. Coded in COBOL, CICS, DB2, VSAM, JCL, and SPROCS. Performed development and production support tasks.

Environment: ISPF/TSO COBOL CICS DB2 VSAM JCL SPROCS ENDEVOR

Confidenital

Applications Programmer/Analyst Contract

Default Mortgage Strategies/Analytics Line of Business

• I ran SAS jobs that cleansed the data and that created spreadsheets/data so that the Risk Analysts had timely information on which to do trending analysis and make actionable decisions concerning people's mortgages.
• Worked with Mainframe DB2 and ORACLE data from the Operations Dept. and the Capital Markets Dept. and read/created SAS Tables/Views and ORACLE Tables/Views and EXCEL SS's and sent final result to Risk Analysts
• Used PC SAS and SAS/ACCESS and SAS/SQL and PROC/SQL and LIBNAME and ORACLE and TOAD on a UNIX platform and Windows platform and extracted DB2 data in a MVS/ISPF/TSO Mainframe Environment created DB2 LOAD and UNLOAD Jobs .
• Created EXCEL Spreadsheets using advanced SAS MACROS and ODS, PROC PRINT and PROC REPORT
• Performed weekly, monthly and adhoc SAS/ORACLE/UNIX production support submitted, monitored and verified Interactive and Batch SAS jobs run on UNIX platform
• Utilized Base SAS 9.2 and UNIX SCREEN utility and Putty for Batch job submittal
• Used WINSCP to navigate UNIX and to transfer files

Environment: SAS, UNIX, ORACLE, SAS MACROS, PC SAS ISPF/TSO, DB2, DB2 Utilities, JCL/Utilities/SORT

Confidenital

Applications Programmer/Analyst Contract

• Change-The-Bank and Run-The-Bank Lines of Business
• I helped users fix their Taxlot data and provided utilities for them to run reports against their Taxlot data, thereby providing accurate information thereby saving the firm 1M
• Worked on the Cost Basis Project a Fixed Income Project which creates Taxlot data and Taxlot reports for Financial Analysts via reading Book-Keeping data. This Taxlot data is then passed to Statements System and to a street-wide website called GK
• Added new Daily, Weekly, Monthly, ADHOC JCL Jobs, Procs, Programs, Control-Cards to Development Environment, two Q/A Environments, Production Environment via CHANGEMAN. Used OPC to monitor jobs used SAR to view reports.
• Utilized COBOL, DB2, JCL, Utilities, DB2 Utilities, Advanced SORT and ICETOOL and SORT/JOIN and EZTRIEVE and STAR-TOOL to correct Taxlot data and to produce adhoc reports.
• For the Taxlot users: Wrote a Mainframe SAS and FTP and REXX and EZTRIEVE and ISPF Dialog Manager and PKZIP Production Support Utility that created Realized and Unrealized Tax Lot Reports in HTML/EXCEL/PDF/XML formats and emailed them to the Taxlot users.

Environment: ISPF/TSO SAS, SAS MACROS COBOL DB2 DB2 Utilities SPUFI VSAM JCL UTILITIES OPC EZTRIEVE IBM DEBUG TOOL FTP REXX ISPF DIALOG MANAGER PKZIP STAR-TOOL CHANGEMAN SAR

Confidenital

• I helped client learn IBM Debug Tool, gave an IBM Debug Tool Presentation IBM Debug Tool helped the client solve Production Problems, thereby decreasing system downtime by 30
• Intensive research and installation and customization and testing of and presentation of IBM DEBUG TOOL V10 for CICS and BATCH
• Setting up IBM DEBUG TOOL V10 for CICS/COBOL modules and CICS/Assembler modules
• Performed migration of some ASSEMBLER programs that had ADABAS Direct CALLS to COBOL DB2
• Used Tivoli Workstation Scheduler TWS to schedule mainframe batch jobs

Environment: ISPF/TSO, z/OS 111 COBOL CICS TS 3.2 IBM DEBUG TOOL V10 VSAM ADABAS DB2 SPUFI JCL ASSEMBLER TWS

Confidenital

Applications Programmer/Analyst Contract

Confidenital

• Helped the client modernize their Mainframe systems towards JAVAScript triggering Mainframe Stored Procedures this represented a total savings of 500,000
• Converted many legacy CICS/VSAM/DB2 programs to COBOL/DB2 Stored Procedures
• Worked with the COE offshore staff who wrote the companion JAVA front-end components that triggered our COBOL/DB2 Stored Procedures
• Used DB2CONNECT and Stored Procedure Builder to test Stored Procedures
• Wrote COBOL/DB2/VSAM programs
• Wrote programs to parse XML files from distributed systems sent XML files to them as well
• Coded a Secure FTP JCL Job, JCL Proc and COBOL/DB2/VSAM program
• Extensively tested all of these new and/or modified components

Environment: ISPF/TSO, OS/390, COBOL, CICS/VSAM, DB2, DB2 Stored Procedures, Stored Procedure Builder, SPUFI, QMF, JCL, CHANGEMAN, FTP, Secure FTP

Confidenital

Applications Programmer/Analyst Contract

• By helping Financial Analysts solve report problems missing and/or incorrect dollar amounts, missing reports, percentages, shareholder name, etc and by performing production support on and monitoring of the website, I saved the firm 5M annually. By making 529 Student Loan regulatory changes in the Mutual Funds area , I enabled the firm to continue to offer the 529 Student Loan product.
• Learned PeopleSoft's SQRibe and made major enhancements to and performed maintenance on a mission-critical time-sensitive high-visibility ETL DB2 Data Warehouse Application and Website called FOCUS that uses SQRibe, DB2 DYNAMIC SQL, COBOL, CICS/VSAM, SAS, and VM/APL to read Mainframe DB2 Tables and to produce Financial Analyst Client Performance Reports with embedded post-script these reports are then FTP'ed to UNIX/PERL which then publishes them onto the web to be viewed by highest levels of the firm
• Performed full SDLC for each SQRibe modification and corresponding JCL changes that included analysis BRD's FRD's data-analysis and data-mapping via SPUFIS and QMF estimates development unit and system testing Q/A testing documentation implementation via CHANGEMAN and support
• For the Morgan Stanley Joint Venture Effort and for the Pershing Conversion: Made major revisions to the SQRibe programs and to the SAS programs and the COBOL CICS/VSAM DB2 programs and JCL Jobs and Procs which contained EZTRIEVE
• Worked with the Data-Masking/Data Obfuscation/Data Redacting Team to encode/scramble customer's names and SS 's
• Wrote a COBOL/DB2 program that invoked a Stored-Procedure that, given employee , returns his EMAIL
• Ran monthly and quarterly adhoc UNIX/PERL/FTP processing which posted the resultant reports to the FOCUS website
• Solved numerous mainframe SQRibe production problems via root cause analysis
• Modified an APL program on VM
• Modified and wrote many mainframe-based SAS programs using Base SAS Procs Version 9 and wrote SAS MACROS as well for a Mutual Funds application
• Modified mainframe-based SAS programs pursuant to the 529 Plan Student Loan regulatory changes
• Wrote, tested and implemented two Mainframe-Based Secure FTP processes that sent success notifications to a UNIX server upon successful completion of mainframe processing
• Onshore-Offshore Business Model

Environment: ISPF/TSO, OS/390, COBOL, CICS/VSAM, DB2, SAS, DB2 Stored Procedures. SPUFI, QMF, JCL, EZTRIEVE , CHANGEMAN, FTP, Secure FTP, PeopleSoft SQRibe ETL DATAWAREHOUSE UNIX

Confidenital

Applications Programmer/Analyst Contract

• Allowed the users to change the account's CAP Limit and added Average Daily Balance and Annual Percentage Yield Earned and Interest Paid on the Statement and allowed them to override the money management tier all of this saved the firm 750,000
• Provided DB2 tables and programming that allowed users to change the account's CAP limit, to produce reports detailing these CAP limit changes, to add average daily balance and APY earned and interest paid to the statement within the interest-payout-section , to send this modified statement to the Statement System, and to override money manager tier
• Performed documentation/analysis/research of the existing system's programs/jobs/procs/data/DB2-tables and performed analysis of the new system
• Created several analysis-related EXCEL spreadsheets for the new development
• For the data analysis, created and executed complex ADHOC jobs. All of these results were used to complete the new system's specifications
• Wrote and tested several Batch COBOL DB2 programs that updated the database and wrote and tested several utilities so as to check out the results of these DB2 programs' database updates
• Used SPUFI's, BMC Tools PLATINUM JCL/UTILITIES/SORT COMPAREX the firm's match-merge utility DYL280 MQSERIES
• Attended an IBM-DEBUG Tool Course

Environment: ISPF/TSO OS/390 COBOL/3 DB2 SPUFI PLATINUM JCL/UTILITIES/SORT Changeman OPC CICS/VSAM IBM-DEBUG-Tool COBOL DB2 Stored Procs COMPAREX DYL280 IBM DEBUG Tool MQSERIES

Confidenital

Applications Programmer/Analyst Contract

• I saved the TAX users weeks of manual checking by re-writing programs so that the seasonal TAX report could be reset upon error detection. The Development and Maintenance and Production Support that I provided to Balance and Control Department and Book-Keeping Department and Accounting Department and Government Operations Department saved the firm 2M annually.
• Responsible for Maintenance, Development and Support of General Ledger, Accounting, Book-Keeping and Balance and Control Reconciliation Systems, Profit and Loss P L Systems, Government Operations Back-Office Systems, and Tax Systems in a Brokerage/Investment Banking environment where report production was time critical
• COBOL, JCL, CICS/VSAM, DB2 and DB2 Utilities, SPUFI, PLATINUM, Changeman, COMPAREX COBOL Stored Procedures, SQL Stored Procedures in an IBM DB2 Stored Procedure Builder platform
• Wrote numerous complex SPUFIS and complex programs to meet the business needs
• Produced Trade and Book-Keeping Reconciliation reports via querying ADP structures and via querying Book-Keeping and Trade Warehouse DB2 Tables and via reading the street security master file called the MSD
• Performed data conversion due to DB2 table modifications
• Converted a huge non-partitioned DB2 table to a partitioned DB2 table
• Added income and counter-party information to our DB2 table which came from numerous sources via writing numerous programs, JCL streams, utilities , and wrote/produced report programs that reported on DB2 data
• Produced flexible dynamic Book-Keeping Journal Reports
• Modified data-entry CICS programs/screens to support new report parameters report security access
• Added new banks to proprietary Merva process
• Worked with ISO SWIFT Category 5 message types
• Added new reconciliation reports whenever new accounts came on
• Made major Good Friday enhancements to our systems
• Made major Letter of Authorization workflow changes
• Fixed numerous production problems
• Saved users weeks of manual checking via re-writing program so that the TAX-seasonal report could be reset upon discovery of external system's input data problems
• Created COBOL programs that produced dynamic LOAD/UNLOAD/IMAGE-COPY cards for our partitioned DB2 table
• Wrote an extensive Control-M Keystroke Language Utility
• Attended an EXCEL VBA Course
• Attended a ClearCase class
• Performed extensive production coverage and extensive system documentation as well

Environment: ISPF/TSO, OS/390, COBOL, DB2 and DB2 Utilities, SPUFI, PLATINUM, JCL, CICS/VSAM, SQL, Stored Procedures, Changeman, Control-M

OTHER EXPERIENCE:

NBC / Sr. Programmer/Analyst Contract

Sr. Programmer/Analyst Contract

Sr. Programmer/Analyst

Sr. Programmer/Analyst Contract

Sr. Programmer/Analyst Contract

Technical Specialist

Technical Specialist

Programmer/Analyst Contract

PROGRAMMER/ANALYST

Programmer/Analyst

Programmer

Programmer/Analyst