Customer Service System

TATYANA NEKRASOVA

**** ******* *** *** **

Fort Lee, NJ 07024

Phones: 646-***-****, 201-***-****

E-mail: *******.*********@*****.***

PROFESSIONAL SUMMARY

Highly Analytical and Self-motivated Software developer with over fifteen years’ experience in the full IT project life cycle management. Development process experience includes analysis, design, coding, debugging, implementation, documentation and maintenance of application software. Team-oriented individual with a demonstrated ability to manage multiple projects. Excellent attention to detail, analytical capabilities and process design skills. Accustomed to working with global companies.

TECHNOLOGIES

HARDWARE: IBM Mainframe series, IBM PC

OPERATING SYSTEMS: Windows XP, Windows NT

PROGRAMMING LANGUAGES/TOOLS: OS/JCL, TSO/ISPF, VBA, COBOL,COBOLII, CICS, MQ Series, JACADA/HATS (CICS web services), BMS/GTB, DB2, PLATINUM DB2, DB2 STORED PROCEDURES, ACCESS 2003, 2007, SQL, QMF, SPUFI, ABEND-AID,VSE, MVS/XA, VSAM, XPEDITER, INTERTEST, CHANGEMAN, ENDEVOR, SWIFT, WORD, EXCEL, REXX, VISIO, XML, VISUAL BASIC, JavaScript, RACF, Easytrieve, IDMS, MILLENIUM SECURITY, MOBIUS reports, FTP, NDM, IBM Utilities: INFOX, IPS, SDSF, TWS, TOM, FILEAID, SAR, Rocket Shuttle (DB2 Interactive tool), Macro Recorder, UltraEdit-32, TRACK (CICS debugging tool), XRAY(Batch debugging tool), VISION:REPORT(report writing tool).

DATABASES: DB2, DB2 UDB, IMS, SQL Server, MS ACCESS.

PROFESSIONAL EXPERIENCE

Experis/Verizon Wireless – Orangeburg, NY

Senior Software Systems Engineer (IT) /Consultant 2011-Present

Leading consultant for Billing and Rating applications. Accomplished very important Shared Data for Enterprises project that involves high level design, analysis, detailed design and documentation, coding batch and on-line DB2 programs, working in sophisticated environment. Software used also include: COBOL, JCL, CICS, CA7, DB2 V.10, SPUFI, QMF, MQ.

Tekmark Global Solutions/NYCERS – New York City Employee Retirement System

Sr. Programmer Analyst/Consultant 2009 – 2011

Assist in the planning, design, development of new applications and enhancements to existing applications, analyze, code, implement, test and generate procedural and code documentation for 1600 components including batch, on-line programs, JCL jobs, quick jobs, CICS maps, DB2 tables for the entire city retirement system’s database to replace numeric formatted Member ID to alpha-numeric, change SSN representation on CICS screens, adjustment of DB2 address database, writing batch and on-line sub-modules to replace obsolete hard coded tier specifications, extensive HATS (CICS web services) testing and debugging, recorded plenty of test macros. Was a leading consultant in redesigning Daily and Quarterly Payroll Systems to accommodate new key (member ID) format.

Technology used: COBOL, COBOL II, JCL, VSAM, CICS, DB2, DB2 UDB, MS Excel, ChangeMan, IDMS, Track, XRAY, Rocket Shuttle, VISION: Reporting tool, Macro Recorder, UltraEdit-32 (file compare tool).

Morgan Stanley, New York, NY/Jersey City, NJ 1997 - 2009

Programmer/Software Developer, Finance IT

Lead programmer responsible for multiple assignments of Bank Reconciliation System including Check Reconciliation System, Disbursement Reconciliation System, Deposit System, Wire Transfer System, Tracker, etc. , where projects involved on-site work with off-shore group. Projects utilized: COBOL II, VSAM, CICS, BMS GTB, JCL, DB2, DB2 Stored Procedures, DB2 Utilities, DB2 Performance Tuning, MQ Series, SWIFT, MS ACCESS 2003, VBA, SQL, HTML, JavaScript, MS EXCEL, MS WORD, and MS VISIO. Accomplishments included:

• Responsible for Check Issues process: created JCL, various CICS/VSAM on-line and batch Cobol programs, generated user requested reports, updated and tested system for new accounts to automate process, closed accounts, supported day/night batch/on-line process. Handled hotline to support users’ queries, directly communicating with end-users.

• Fine tuned BRS System achieving significant cost reduction by saving 50% of CPU cost by generating additional History files for BRS system, saved 50% of CPU cost by generating the process of monthly Unloading History Data for Disbursement Reconciliation and Wire Reconciliation systems to non-VSAM files.

• Designed web based GUI screens using Jacada, cost effective and efficiently converted legacy system, into formats that support and extend the capabilities of the Internet to mainframe users: they are able to view mainframe through Jacada screens. Maintained JavaScript/HTML based Jacada Knowledgebase combining responsibilities of Knowledgebase administrator and developer.

• As a team member participated in customization and production support of General Ledger, Fixed Assets (GEAC vendor’s software packages) and Payroll systems: generated new customized programs, updated vendors’ programs, maintained on-line screens, JCL, DB2 tables. Also participated in the conversion of HR system from COBOL/DB2 to PeopleSoft.

• Led Supervisory Functions projects, overseeing team of four: met with decision makers, systems owners, and end users to define business requirements, and systems goals, created system design proposals, identified and resolved business systems issues. Supervisory functions allow supervisors to directly update the account reconciliation processing.

• Developed and implemented full project life cycle for new Return and Adjustment System (RAS) which utilizes ACCESS, VBA, EXCEL, SQL, VISIO (for documentation). Build system to facilitate reverse positive pay, which automated a manual process and reduced the process time by 90%, received recognition in the Department IT Newsletter.

• Led $50 Million Mutual Fund Settlement project requested by SEC. Modified the process of 800,000 check issues overseeing team of five people.

• Supported Unclaimed Property application which reports unclaimed assets to the state: ran reports and generated 25 pages documentation for users and programmers.

• Designed, tested, implemented Customer Service Log application for Cash Control users. The front-end is designed by using Access database forms, the coding is implemented by using VBA, and the database is stored in ACCESS tables and mainframe/text files/reports. This application provides various monthly reporting and data modification tools for senior management.

• For Millennium Security System (Vendor's software package) as Database Administrator: granted, updated and revoked different levels of access. Set up file/printer output profiles, security profiles, maintained Millennium sign-on security, ran mainframe access reports for different business units, also generated security reports for SOX compliance.

• For Cost Allocation System as programmer- analyst: tested application that allocated cost of running jobs on mainframe and programmers’ time. Maintained DB2 UDB tables, VB6 programming and ran monthly and user requested reports.

• For CMS: supported vendor’s software that was used to generate billing of the company’s communication system which included tens of thousands of employees and equipment throughout the nation. Wrote customized programs to maintain systems usage and work productivity, developed statistical reporting to reach cost efficiency. Interacted with vendor and business units to address supporting issues.

• For United Way: managed the application that tracked the employees’ and company’s charitable contributions to United Way. System utilized DB2 programming, database maintenance, running QMF and SPUFI.

ADDITIONAL EXPERIENCE

Board of Education, Russia / Research and Development Division, System Analyst

EDUCATION

B.S., Computer Science, Globe Institute of Technology, New York, NY

M.A., Novosibirsk State Academy, Russia

PROFESSIONAL DEVELOPMENT

Mantissa Reporting Software (RMS) training course (Birmingham, Alabama)

MS/VB6 II, JavaScript (Continuing education classes, New York, Baruch College)

MS ACCESS/2003, ChangeMan, VB6 I, Basic Accounting (Morgan Stanley Inc)

ADDITIONAL INFORMATION

Citizenship: USA

Contact this candidate