Ilya Spektor

3125 Tibbett Avenue, #8B
			Riverdale, NY 10463–3820
			Tel: (718) 884–7483
			E–Mail: spektacle@prodigy.net

Summary
Experienced data processing professional with background in Brokerage, Banking, and Financial applications. Strong analytical and problem solving skills. Quick learner. Excellent team player.

Technical Summary
Hardware: IBM Mainframe Environment, IBM AS/400, IBM PC, Apple Macintosh Languages: COBOL/COBOL II, CICS, DB2/SQL, JCL, HTML. 
Software: OS/MVS Utilities, TSO/ISPF, VSAM, MQSeries, SyncSort, Xpediter, Intertest, FileAid, FileAid DataAger, ProEdit, CA-Endevor/MVS, ChangeMan, Windows 3.1/9X/NT/2000, MS Office, Lotus Notes, Photoshop 5.5, Premier 6.0

Programming Experience
1999 – 2001	Lead Programmer/Analyst, FleetBoston Financial Corporation (formerly Summit Service Corporation), Ridgefield Park, NJ

As a member of the Bank Investments (BI) System team, provided support and, finally, conversion of BI processing from Summit to Fleet. BI System is designed to update BI accounts of General Ledger, DDA (Demand Deposits Accounts), AS/400 customer database, and other Bank Systems by processing of daily and monthly transmissions from Sungard and other vendors, create statements for the customers, and provide report generation for the users (BI Operations).

•	Created multiple custom reports for the Summit – Fleet merger process using COBOL II, SyncSort, and JCL.
•	Simulated data files and conducted Integration tests for different stages of the Summit – Fleet merger.
•	Designed, wrote specs, coded, tested, and implemented BI Fax Confirmations project, which allowed sending BI trades confirmations to participating customers by faxes (to be received the same day) and save 20% on printing and mailing expenses. Confirmations for non-faxed customers were printed and mailed as usual.
•	Designed, coded, tested, and implemented BOLT (bonds on-line trading) reconciliation report for the users.
•	To achieve flexibility developed and implemented COBOL II/CICS programs using VSAM files for on-line manual record manipulation by the users.
•	Created production PROCs and JOBs using JCL.
•	Created test data and conducted Unit and System testing for all projects.
•	Monitored transmissions of DEC/VAX minicomputers for the Personal Trust System.
•	Checked data integrity of Customer database by running queries in AS/400.
•	Created technical documentation and worked closely with the users and Sungard on system enhancements and modifications.
•	Participated in multiple stages of Y2K Unit, System, and Integration testing.
•	Supported the current system, analyzed and resolved production problems.
Continued
1999			Staff Programmer/Analyst, Prodigy Communications Corporation, Inc.,
			White Plains, NY
			Worked on the Profile Delivery Billing System (PDS). It is designed to keep its 				customer database in sync with Prodigy Internet Oracle database and provide 				billing information feed to the external system (CSG) for bill generation.
•	Developed and implemented COBOL II/CICS programs using VSAM files and IBM MQ Series.
•	Created test data for initial loading of the new Customer Service Database and sent test Message Queues (MQ) for Enroll, Update, and Delete functions processing.
•	Used SQL to retrieve data on-line from Oracle database.
•	Created test data and conducted Unit and System testing.
•	Supported the current system, analyzed and resolved production problems.

1998			Programmer/Analyst, DMR Consulting Group, Edison, NJ.						Consultant on the Validate, Rate & Price (VRP) System for UPS, Morristown, NJ
VRP is designed to receive billing transactions from various Data Capture systems, rate, incent and aggregate those transactions for each shipper in preparation of bill generation. VRP creates billing information feeds to downstream billing subsystems and external systems.
•	Developed and implemented Batch COBOL II/DB2 programs.
•	Created JCL, PROCs for testing purposes, and ChangeMan packages for turnover to production.
•	Was involved in Unit, System, and UAT testing.
•	Supported the current system, analyzed and resolved production error logs.
  	 		
1993 – 1997		Programmer/Analyst, MDRJ Consulting, New York, NY.
			Consultant on the Production Credit System (PCS) for Merrill Lynch, 					New York, NY.
PCS is a facility that catches, integrates and provides adjustment capability for the production credits, generated by the Firm.
•	Developed and modified COBOL II/CICS/DB2 Programs.
•	System maintenance, problem solving and technical documentation.
•	Worked with the users on system enhancements and modifications.

Education

Web Development Programming Certificate Program (current student)
Cittone Institute, Paramus, NJ

Certificate Program in Computer Programming.								Moscow State Mining University, Moscow, Russia.
	
MS in Acoustics Engineering.										Moscow State Mining University, Moscow, Russia.