ANATOLE TSYPIN

** ******* *****, *** **

White Plains, NY 10603

917-***-****

acwatl@r.postjobfree.com

SENIOR PROGRAMMER/ANALYST

Highly experienced programmer who values integrity, forging productive and positive work relationships and a focus on results. In depth knowledge of LANSA AD and its applications for various types of business applications as well as theoretical knowledge of Visual LANSA, Visual Framework for Windows and Web. Developed solutions on a iSeries platform to support business needs of over 100 local and overseas users at Credit Agricole CIB, played a key role in deploying relevant solutions to support the achievement of business goals. Led and participated in several large and complex IT projects including, Credit Agricole-to-FIS migration, ATM (Automatic Ticket Maker), Customer Notifications, Interest and Fees Bills and a Tax Withholding Module. Core responsibilities were to maintain ACBS application, and to design, develop, test and maintain all in-house developed applications, while supporting all users. Self-starter, who can "juggle" multiple projects and work well in a face to face or virtual team environment. Hardware iSeries, AS400: 9406, 9404, 810, System 36 Software Python, LANSA 12.1(RDML), Theoretical knowledge of Visual LANSA (RDMLX), Visual Framework for Windows and Web, ILE RPG, RPGIII, RPGII, RPG, CL, QUERY, SQL, FAX/400, 5250 Terminal Emulation: Rumba, Reflections, Client Access Experience

March 2015 – FIS

March 2016 SENIOR PROGRAMMER LANSA AD, ACBS ANALYST/QA ACBS (Advanced Commercial Banking Systems) In-house applications development working at a client site. Some of projects included:

Creation of Automatic Ticket Maker (ATM), where user can save this source document and view it at a later time. This was designed to eliminate printing and save input time for ACBS transactions.

Designed screen and input process to provide users the ability to input two additional overnight rates for newly created Canada portfolio. This requirement was designed to integrate Canada’s Prime and Non-performing loans to other applications with the bank.

Conversion of all ACBS in-house functions to FIS standards. Project Management and coordination between different IT groups ACBS application support, this also includes:

User set up

Application security

System Access designation

Fax/400 support

User support,

Trained overseas resources

ANATOLE TSYPIN Page 2

1998 – CREDIT AGRICOLE CIB

March 2015 SENIOR PROGRAMMER LANSA AD, ACBS ANALYST/QA Develop and maintain ACBS user requests and any user enhancements.

Projects include Customer Notifications, Interest, L/C and Authorization fee statements -

By utilizing ACBS data, these projects have completely eliminated manual entry environment, created ease of process, established efficiency and greatly reduced loan administrators’ work load.

ACBS General Ledger set up for new products

Reports

E-mail notifications -

The Letter of Credit Notifications are automatically created and emailed directly to the groups within the bank, thus eliminating the need for manually printing, scanning and emailing these documents. On-line and Batch versions were developed and implemented.

Project Documentation

Provide SRS (System Requirements Specifications) documents

Provide Technical Documentation

Testing and implementation of -

New releases of ACBS

New releases of LANSA

Enhancements and installation and overall support on any new AS400 related applications including Fax/400 and iCluster (replication software) Primary support for -

ACBS daily activities and nightly end-of-day batch process

Additional duties include Tiger L/C application support. (SUNGARD application for booking and maintaining Letters of Credit)

Troubleshoot any AS400 printing related issues.

Technical ACBS lead for annual bank wide disaster recovery exercise ANATOLE TSYPIN Page 3

June 1995 – WILSON, ELSER, MOSKOWITZ, EDELMAN & DICKER, New York, NY 1998 LANSA 400 Consultant

Documentation

- Provided detailed documentation, run procedures and samples of all completed projects.

User Support

- Run End of Month reports and assist as troubleshooter in all areas of the data processing department.

Designed, coded and implemented a securitized Client/Matter Billing Inquiry module. Security system restricted viewing of files to the Partner or Associate that was assigned to these files.

Designed and implemented a Client Directory Report for all users. Other reports: financial reports, billings, collections, and write-offs to the Accounting and Managing departments.

1995 – CHASE MANHATTAN BANK, New York, NY

June 1995 LANSA 400 Consultant

Assisted an in-house staff in the simplification of procedures for the consolidation of two systems into one global lending system.

Developed and coded a series of CL procedures to fully automate partition upgrade process. Revised and rewrote a partition upgrade user manual making the process more user friendly and precise.

Utilized LANSA database internal files to provide reports for IMS management to review all partition processes and functions and custom database files.

Utilized AS/400 SDA screen design facilities with CL programming to simplify a download procedure from a tape to a safe file on the AS/400.

Provided LANSA user support.

1992 – WILSON, ELSER, MOSKOWITZ, EDELMAN & DICKER, New York, NY 1995 LANSA 400/Programmer/Analyst

Independent responsibility for the development of programs and systems for local and regional use. Firm is a 500 attorney national law firm specializing in medical malpractice and insurance defense.

ANATOLE TSYPIN Page 4

1992 – WILSON, ELSER, MOSKOWITZ, EDELMAN & DICKER, New York, NY 1995 LANSA 400/Programmer/Analyst

(continued)

Developed a custom Docket Calendar and Service Database system for Partner and Associate. This local system maintains court appearances, adjournment dates, mail received, motion and calendar forms. Both systems maintain quick, on-line search capabilities, past and future date calculations and global updates. System was adapted for use nationwide.

- Service System database monitored and tracked documents filed with the court and outcome of cases (adjournments, motions, etc.).

- Also followed up on documents given to outside clerical services.

Created a Client Response System for New Matters Department. System printed New Matter Form, enabling all details regarding the matter to be included. Other components: an acknowledgement letter with signature by attorney and client.

Provided detailed documentation, run procedures and samples of all completed projects.

User support, run End of Month reports and assist as troubleshooter in all areas of the data processing department.

1990 – P/KAUFMANN INC., New York, NY

1992 RPG III/400 Programmer

Developed software enhancements and custom coding in Inventory and Piece Systems module in RPG III/400 and CLP. Developed management requested top priority programs.

Designed, coded, implemented, tested and debugged software for Sales Department. Program featured present years and previous years’ to date sales figures for individual sales representatives.

Designed and coded CL programs for ROBOT/400 job scheduler.

With the use of SDA (Screen Design Aid) utility in conjunction with CLP, created a user-friendly procedure to perform daily back-up of system and non-system libraries.

Redesigned and implemented main order entry menu to send all user requested reports to another subsystem for later printing. This process was designed to free up system’s spooling output queues for better operational efficiency.

Daily monitoring of all communication lines between company and affiliates; repaired any problems.

Installed and networked all terminals and printers.

Designed and implemented all programming specifications including file layouts, screens and report designs for a Duty Drawback System. Results: company was able to claim duty taxes which had been paid for imported goods. ANATOLE TSYPIN Page 5

1989 – LORRAINE LINENS, INC., New York, NY

1990 AS/400 Specialist

Designed, coded, implemented, tested, debugged and documented employee database system. This comprehensive database system allowed for all options required in system management and maintenance.

System allowed management to monitor employee absenteeism.

Created a RPG 400 program to access raw material information and display it at the request of users.

Created SDA screens supported by CL allowing users faster access to previously written programs.

Security Officer: responsible for establishing and updating user profiles and system configuration in order to maintain systems integrity.

EDI Coordinator: responsible for daily operations of transmitting and receiving purchase orders. Designed and implemented user file definitions, trading partner IDs and document layouts. Provided user support to all EDI users.

Performed all systems “tune-up”; set up AS 400 communication, including line and controller descriptions; installed PTFs and OS/400. 1987 – AFA COMPUTER SERVICES, New York, NY

1989 AS/400 and System/36 Operator

Maintained both computer systems including report generation. Provided customer support.

Installation: installed all types of System/36 customized software for IBM 5360, 5362, 5363, 5364 and PS/2. Provided assistance in installing AS/400.

Data file conversion: performed file conversion from System/36 to AS/400 (using and generating DFUs). Uploaded and downloaded data from 8 inch diskettes to 51/4 inch diskettes using PC Exchange software.

Education Queens Borough Community College

A.A.S., Computer Technology

LANSA eLearning

Visual LANSA Fundamentals

Visual Framework for Windows and Web

Enskill - Programming in ILE RPG

Codecademy – Python

Udacity – Intermediate Python

IBM Guided Learning Center

RPG II Programming Workshop

Advanced Topics and AS/400

Computer Aided Training

References Available upon request

Contact this candidate