SUMMARY:

Programmer/Analyst with specific interest in development and maintenance of database applications on Mainframe and server platforms. Clients and employers list includes major banking, financial services and communication companies.

TECHNICAL SKILLS:

SOFTWARE:

Mainframe: COBOL, COBOL II, Cobol/Micro Focus, Basic Assembler Language, MVS/ESA, OS390, MVS/JCL, TSO/ISPF - PDF, REXX, OS Utilities, IceTool, Librarian, VSAM, IDCAMS, File-Aid, CICS, DB2/SQL/QMF/SPUFI, DB/PROEDIT, PLATINUM, Stored Procedures, STROBE, OMEGAMON, ENDEAVOR, Changeman, DTM/SNAPPI, SYSTEMATICS, MQSeries, Expediter, EZTREIVE

Servers/PC: Windows 9x/XP/NT/2000, OS/2, MS DOS, MicroFocus COBOL, MS Office, DIS, Visual Basic 6.0, XML

CASE Tool: HPS 5.x.

Testing Tool: Stresstimulus, Loadrunner, TESTME, and ACSS-testing-tool

EXPERIENCE:

Confidential, NJ

Senior Programmer-Analyst/Consultant

Responsibilities:

• Development and Production support, maintenance and resolving Ad hoc issues for company systems: CST, PMS, DVS & CPI.
• Development and creating reports as a part of Trouble Ticket processing.
• Writing SPUFI’s to load data into System Test to support mission critical projects..
• Performance optimization of time-critical jobs by improving queries and transaction design in cooperation with DBA’s and Infrastructure.
• Support change control process: participated in various change control meetings and provided night support of implementations outside company's enterprise releases.
• Participated in special off-hours coverage including enterprise release support and Command center for Iconic launches,
• Provided testing of updated services to prepare them for implementation on company’s Enterprise Release.
• The Work was performed using COBOL, DB2, Stored Procedures, CICS, RDZ, Microsoft Office, and various tools across the system such as TESTME, and ACSS-testing-tool.

Confidential, Jersey City, NJ

Senior Programmer-Analyst

Responsibilities:

• Developed program modules for conversion mutual fund accounts of acquired companies’ to build a consolidated database and wrote stored procedure for its maintenance. Developed a process to create Schwab clearance daily file with Letter of intent (LOI) information related to securities purchase.
• Was involved in reengineering of Retail Portfolio system to accommodate three times more accounts added by acquisition of two major banks.
• Performance increase was achieved by parallel processing of several batch streams that were originally designed for sequential run.
• I was responsible for assessing what modules and components require reengineering.
• Implemented host of modifications to accommodate substantial data format upgrade, database table partitioning, as well as changes in processing workflow.
• Production support and maintenance of Global Risk Management System that monitors and analyzes credit exposure of several trading areas.
• Daily batch collects and summarizes operational data from the offices located world-wide to rebuild transactions, positions and credit limit information in DB2 tables that are used by financial analysts to create multiple analytical reports through the front-end GUI.
• Responsible for development and maintenance of Stored Procedures that extract and aggregate data for such analytical reports.
• Developed COBOL programs for generating reporting files, which are forwarded for further processing to UNIX servers.
• Built ad-hoc and on-demand SQL reports requested by financial analysts. By system architect’s request researched previously written code to investigate undocumented rules and algorithms and spec dependencies and input/output relationship between program modules.

Confidential, NJ

Senior Programmer-Analyst/Consultant

Responsibilities:

• Billing system Integration project.
• The goal is to merge multiple cellular billing systems and enable to create consolidated Invoice with activity reports for National Accounts across all participating Cellular Carriers.
• The development goal is to convert the software and database structure of several systems to support the industry-standard billing format on DB2 platform.
• This job required technical background close to DB2 DBA level.
• As a part of conversion team designed and developed COBOL routines to perform massive data transformation between legacy and new billing systems.
• During the implementation phase I was solely responsible for handling trouble tickets with exceptions, which were not handled by the conversion routines. Worked with business analysts group to study exceptions using various resolution techniques.
• Develop a set of logical test to support data integrity during the migration steps.
• In order to meet tight conversion schedule, while developing a large number of highly reliable SQL statements and procedures for DB2 for interactive and batch processing, I used tools such as Excel, and MS Access scripts and macros to automate generation ofSQL script as well as IBM and BMC load utilities.
• This job requires good knowledge of conversion specs and fast developments skills.

Confidential, NYC

Programmer-Analyst/Consultant

Responsibilities:

• Developed multi-dimensional data analysis module to report shares allocation between regions, branches, financial advisers and tickets for “Equity Syndicate View” application with Intranet Java-based front-end and DB2 backend.
• Wrote stored procedures to process drilldown users’ requests.
• Google IPO project. Participated in reengineering of significant part of CICS / DB2 Syndicate Desk application in order to implement change from fixed price model to auction model.
• Developed batch application to process incomplete and late email bids to be reflected in P&S.
• Developed several ad-hoc and on-demand COBOL-based reports.

Confidential, Jersey City, NJ

Senior Programmer-Analyst / Employee - project lead

Responsibilities:

• Developed and maintained the market data repository based on Bloomberg data. Real-time market data files are FTP’d from the Bloomberg UNIX machine every 15 minutes and loaded into DB2 data repository.
• Developed mission-critical processes to control data delivery schedule and auditing data completeness and accuracy.
• Provided extensive data validation and cross matching against historical information from the data warehouse. Was also responsible for providing access, extracting and distributing data to financial analysts.
• Built ad-hoc and scheduled reports, delivered from mainframe to Unix users. Used DB2, Cobol II, IceTool.
• Developed and maintained web-based system to determine financial consultant’s performance and compensation.
• System builds National Sales Revenue Database using accounts transactions data.
• Application implements multifactor evaluation and ranking model. Extensive reporting capabilities include drill-down analysis in Excel spreadsheets that are dynamically deployed to a web server on corporate Intranet.
• Wrote and implemented many of the back-end programs using COBOL II, TSO utilities and DB2.
• Responsibilities include full life cycle development.
• Also, participated in Y2K program testing using DB2.
• General responsibilities include: design, development, testing, documenting, coordination, rollouts, users training, support.