SUMMARY:

• Senior Programmer Analyst - 15+ years experience in the Brokerage and Financial industries.
• Requirements definition documentation and systems requirements creation.
• Experience with team oriented projects in multi-platform/multi-domain scenarios.
• Full SDLC/Use Case experience.
• Project Life Cycle methodologies (architecture, planning, applications design/development and implementation).
• UA Testing / QA system-integrated testing background including creation and execution of unit, system, integrated and regression test plans.
• Possess excellent communication skills.

TECHNICAL SKILLS:

• Access DB
• AFP
• ALC
• CA7
• Serena Changeman
• CICS
• CICS LU6.2
• CMS
• Cobol
• DB2/SQL
• Stored Procedures
• DMS/FSE
• JCL
• VSE
• ETL
• Easytrieve
• Endeavor
• Expediter
• File Aid
• HTML
• ICCF
• IMS/DL1
• Insync
• Intertest
• Java
• JavaScript
• CICS
• MF Cobol
• Access
• MS Project 2000
• Word
• Excel
• PowerPoint
• MQSeries
• .Net
• OS/JCL
• OS/MVS
• Panvalet
• Platinum
• QMF
• SPUFI
• Sybase
• TCP/IP
• TSO/ISPF
• Top Secret
• Visio
• VSAM
• XML

PROFESSIONAL EXPERIENCE:

Confidential,Garden City, NY

Senior Programmer Analyst

• Supported a Dealer Auto Leasing system using Cobol, CICS, DB2, SPUFI, QMF and VSAM.
• Designed and Developed a Cobol, DB2, CICS Owner Loyalty System to provide financial incentives to the manufacture’s customers.
• Designed DB2 tables for new Owner Loyalty system.
• Created SQL queries and Cursors to parse customer data for financial analysis.
• Managed system updates and changes utilizing Serena Changeman
• Performed system UAT testing and data validation.

Confidential, New York, NY

Technology Lead

• Developed and supported financial information systems using Cobol, CICS, DB2, VSAM.
• Interfaced with financial client business users and managers to formulate functional requirements and technical specifications.
• Provided off shore and on shore programming groups with technical specifications and business user clarifications.
• Created SQL queries to parse data to perform financial analysis.
• Managed system updates and changes and new JCL and procedures
• Performed system testing and data validation.

Confidential, New York, NY

Senior Programmer Analyst

• Developed and supported financial information systems using Cobol, CICS, DB2, VSAM and Access.
• Interfaced with global business users and managers to formulate functional and technical concepts.
• Performed analysis of user Top Secret security entitlements for Confidential ’s multiple lines of business.
• Converted and restructured security entitlements on a role base for the simplification of use and update.
• Extracted Top Secret security data from multiple databases and files and converted the data into an Access database format.
• Created SQL queries to parse Top Secret entitlement data from Access tables to perform entitlement analysis.
• Created new user role based Security profiles and eliminated unused entitlements.
• Updated data dictionary entitlement descriptions.
• Created data mappings from history data to Access database tables.
• Managed system updates and changes utilizing Serena Changeman.
• Performed file transmission engineering Utilizing FTP, FTP/PGP, FTPS, NDM, SFTP protocols.
• Created system error reporting and corrected system conversion errors.

Confidential,New York, NY

Senior Programmer Analyst

• Converted and supported financial information systems using Cobol, CICS, DB2, VSAM.
• Interfaced with global project teams and senior managers to communicate functional and technical concepts.
• Modified existing Cobol programs to process DB2 tables
• Expanded a Brokerage Datamart for Confidential ’s multiple lines of business.
• Converted programs and procedures for the migration of the Smith Barney Brokerage data feed to data feeds from Pershing bank. .
• Extracted history data from multiple databases and files and converted the data into the common datamart format.
• Modified the datamart table structures with the addition of new fields and indexes and loaded the datamart with history data.
• Created data mappings from user history data to database tables.
• Managed system updates and changes utilizing Serena Changeman.
• Created new JCL, procedures and job scheduling.
• Performed system testing and data validation.
• Created system error reporting and corrected system conversion errors.

Confidential, New York, NY

Senior Analyst

• Developed Test Plans and procedures for the migration of the Bear Stearns mainframe to JPMorgan mainframe.
• Developed Test Cases and Test scripts for system validation.
• Performed system testing using HP Quality Center.
• Performed connectivity and data validation.
• Created system error reporting and corrected system conversion errors.

Confidential, Weehawken, NJ

Senior Project Lead Analyst

• Converted a General Ledger system from a mainframe Cobol batch and CICS architecture utilizing an "M204" database, to a DB2 database system with a Java front end, using Cobol conversion programs, DB2 Utilities and sync sort utilities.
• Created data mapping from the M204 database to create DB2 tables
• Performed M204 data conversions, used DB2 Utilities to perform DB2 table loads and unloads, performed data validation.
• Created Cobol programs to process system updates.
• Modified existing Cobol programs to process DB2 tables by calling stored procedures.
• Created new JCL, Proc’s and job scheduling.
• Created Cobol DB2 stored procedures to provide data access for the Java front end.
• Analyzed and documented system requirements for the new platform teams.
• Managed system updates and changes utilizing Serena Changeman.
• Created test plans, validated test results with business users and created implementation documentation.
• Provided production support for system problem resolution.

Confidential, Brooklyn, NY

Senior Project Lead Analyst

• Developed and supported financial information systems using Cobol, CICS, DB2 and VSAM to support funding and expense reimbursement for schools and employees.
• Performed updates and maintenance to Cobol programs.
• Maintained changes to JCL and Procs.
• Configured several CICS regions to mirror a production environment to allow for testing and user acceptance testing.
• These regions were configured to allow connection from a Java server through Hostbridge middleware software and utilized CICS distributed transaction processing to execute transactions within the desired CICS region. Multiple regions were utilized for transaction load balancing as well as for separating test, quality assurance and production ready regions.
• Participated in system requirements and design meetings.
• Created system documentation, CA7 Job Scheduling, and operating instructions.
• Provided production support for system resolution.

Confidential, Edgewood, NY

Sr. Project Lead Analyst

• Developed a Brokerage piece-tracking system using Cobol, CICS, DB2, to validate the number of items mailed and their postage amount matched to what was calculated by the system.
• Created Cobol programs to process system updates and to create system reports.
• Created new JCL, Proc’s and job scheduling.
• Managed system updates and changes utilizing Serena Changeman.
• Created data mapping and field definitions.

Confidential, New York, NY

Sr. Programmer Analyst

• Developed a Money Market Depository Cobol, DB2 system to process Broker client account transactions. Interacted with user and the client’s staff to identify and define monetary calculations and account balance and error reporting.
• Re-engineered the existing business processing to in corporate the new system processing.
• Partnered with business users to develop system test plans and data validation.
• Developed operating and system implementation documentation.
• Provided post implementation production support.

Confidential,Edgewood, NY

Senior Project Lead Analyst

• Developed and supported Brokerage Information Systems Technology for a prospectus and trade confirmation system using Cobol, CICS, DB2, VSAM File Handling routines and MF Cobol.
• Developed and tested programs on the MF Cobol platform and then ported them to the mainframe.
• Developed and implemented a Cobol system to extract brokerage voting information from VSAM data files and load the voting information into a DB2 database.
• Provided data access for the Java front end using DB2 connect to access the voting DB2 database.
• Analyzed and documented system requirements for the Java development teams.
• Developed test plans and test data working with business users.
• Created implementation documentation.
• Managed system updates and changes utilizing Serena Changeman.
• Led the development of a Brokerage QA System, using Cobol, CICS, and VSAM, which validated the Brokerage’s client financial statements accuracy using client data files provided by each Broker. Produced error reporting for each Broker, which was used to prevent, erroneous client statements from being sent, due to invalid Broker data or from statement creation programming. Interacted with each Broker’s systems staff to identify and define monetary calculations and statement balance cross checking.
• Transformed new Brokerage firm’s statement history data into Confidential ’s processing format to enable prior month to current month financial statement reporting. Developed client specific statement house holding validation software to ensure statement mailing accuracy.
• Supported a mainframe AFP print resource environment creating and editing documents and images working with form and page definitions. Parsed customer data from AFP documents to create input transaction requests for brokerage prospectus delivery. Supported the storage and printing of AFP trade confirmations.

Confidential, Orlando, FL

Senior Programmer Analyst

• Developed and supported Financial Information Systems Technology for timeshare mortgage processing using Cobol, CICS, and VM/CMS.
• Created test plans and system documentation for system changes.
• Provided production support for all business processes.

Confidential, Edgewood, NY

Senior Programmer Analyst

• Analyzed and documented system requirements for Java platform development teams.
• The Cobol programs were developed and tested on the MF Cobol platform and then were ported to the mainframe.
• Developed and implemented Information Systems Security Technology for a new web based document delivery system, using Cobol, CICS, MQSeries and JAVA enabling new product revenue.
• Developed and tested programming to store document images to a database repository for customer electronic retrieval, reducing mailing expenses.
• Developed and implemented a CICS e-mail word processing system which was used to create bulk e-mail notifications for customers requesting electronic document delivery, resulting in time savings and data entry errors.
• Led the development and implementation of a CICS system that generated customer certification letters, greatly reducing client services customer response time.
• Developed and tested data communications programming using Sybase Client Server, MF Cobol, Cobol, DB2, CICS, SPUFI, and QMF, routines to implement a web based proxy voting system.
• Designed and developed a front end DB2 transaction processing system for a Prospectus Fulfillment system, which reduced total processing time and ensured on time delivery.
• Re-engineered data communications programming using Sybase Client Server, Cobol, and DB2 routines to client PC proxy voting system.