SUMMARY: Over ten years experience in data processing as a programmer/analyst. Extensive hands-on
experience in the design, coding and implementation of multi-platform applications. Knowledge of
statistical analysis methods and data modeling.

Software: SQL, SAS 9, UNIX SHELL, PL/1, COBOL, COBOL II, JCL, VSAM, CICS (Command Level), TSO/ISPF, DB ARTISAN, PRO-EDIT, QMF, SMARTEST, INTERTEST, EXPEDITER, SYNCSORT, Microsoft data analysis tools(Pivot table, SQL SERVER 2000 Analysis Services,
Data analyzer), Business Object,
SQL*Plus, PL/SQL, Oracle Utilities,
JCL/PROCs , Job Scheduling, REXX and CLIST
OS: Windows 95/98/NT/2000/XP, UNIX, Linux, OS/MVS/XA
Databases: DB2, IMS, MS ACCESS, MS SQL SERVER 2000, ORACLE 8i
Methodologies: Waterfall, Agile XP (eXtreme Programming), Software Development Lifecycle (SDLC)

PROFESSIONAL EXPERIENCE:
06/2009 - 12/2009 Confidential,
FL
Programmer/ Analyst– Consultant

• Research, analysis, and creation of customized reports of Nielsen Media viewing data.
• Provided technical training, and software development and support, for department producing custom research reports.
• Worked directly with offshore developers to identify, trouble shoot, test, and track problems in large production systems.
• Facilitated strategy sessions, reviews impact analysis documents, provide status reports to all management levels.
• Reviewed offshore contactor’s code changes and test results, and implemented revisions into production.

06/2006 - 03/2009 Confidential,
FL
Software developer

Held Application Developer and Business Analyst roles, on Agile methodology team, recognized within Nielsen for design and development of innovative, multi-platform systems.

• Participated in design, coding, testing, and implementing several applications that extracted, transformed, transferred, and loaded data, across platforms to and from Mainframe and Server side databases.
• Conducted meetings and interviews with marketing, clients, and application end users to identify and interpret critical Business Requirements for complex software systems.
• Experience working with Offshore IT Resources.
• Research, analysis, and creation of customized reports of Nielsen Media viewing data for clients that included TV networks, cable providers, and ad agency marketing & research departments.
• Wrote SAS, and SQL ad-hoc programs to interface with the company’s large production databases and datasets, containing millions of records, in order to extract, analyze, sort, summarize, and produce custom research reports.
• Created business process flowcharts, using VISIO.
• Facilitated and conducted training sessions for SQA, UAT, and end users, on new systems, revisions, and enhancements.
• Created, executed, and documented Unit Test plans and Test cases. Also assisted SQA’s creation and execution of Automated Test Cases in Quality Center.
• Provided technical support and maintenance on production systems (VIP, ADS and Local Sport Reports); while working on new development tasks for medium to high complexity applications, using PL1/COBOL, SAS and SQL.

11/2000 – 10/2001 Confidential,
Brooklyn, NY
Programmer/Analyst – Consultant

Participated in KeySpan’s data conversion project after acquiring Boston Gas. This involved converting and integrating Boston Gas’ customer data into KeySpan’s Customer Relations Information System (CRIS), learned and developed methods for KeySpan’s home grown PL/I object oriented environment.

• Created methods and scripts, using SQL and SAS, to extract data for formatting, sorting and reporting.
• Developed PL/1 (object-oriented)/Cobol/CICS/DB2 interface programs for obtaining info from Customer Service System (CSS).
• Modified production JCL procedures to accept and process externally generated files.
• Conducted unit, system and acceptance testing as well as building test models.
• Provided production support and problem resolution.

12/1997-02/2000 Confidential,
New York, NY.
Sr. Programmer/Analyst

Wholesale Banking System (WBS) was designed to automate the Treasury and Back Office Settlement activities of an International Bank/Financial Institution.

• Extracted all necessary information from the front end to the back office including risk measuring, profitability, exposure and maintenance of accounting.
• Was Responsible for the design and development of data capturing on-line screens, static and variable reports (Primary Money Market, Foreign Exchange).
• Maintained On-Line Cash Flow Cycles and ensured the integrity of overnight batch processing.
• Created a set of PL/1/COBOL/CICS/DB2 programs; prepared procedures to convert from previous or earlier WBS releases to the higher versions and customized releases for specific clients.
• Provided WBS maintenance and customer production support.

03/1996-12/1996 Confidential,
New York, NY.
Programmer/Analyst-Consultant

Worked on the design, development and implementation of an Inventory Claims System.

• Developed an ON-LINE and BATCH system that tracked all open and closed claims and provided a variety of inquiry and maintenance screens.
• Was involved in full project life cycle: preparing program specifications, coding and testing of various batch and on-line modules to perform inquiry and maintenance functions.
• Designed screens and reports, prepared procedures and run books, created VSAM data sets.
• Developed COBOL 2/ CICS programs, using SQL to access DB2 database under OS/MVS/XA operating system. Conducted unit and system acceptance testing, with implementation, production support and problem resolution.

02/95-02/96 Confidential,
NJ
Programmer/Analyst-Consultant

Was Responsible for the support and enhancement of an on-line Management Information System.

• Maintained several system modules, which provided information on international accounts for reporting purposes.
• Established account relationships, produced trade and activity reports, and generated consolidated multi-currency client statements.
• Implemented changes and enhancements to COBOL/CICS modules for updating DB2 database and VSAM files. Provided various reports and data conversion tools from VSAM files through DB2 tables. Used SQL extensively to retrieve raw and aggregate data, required by system reports.
• Worked with DB2 ver.3.2 under OS/MVS/XA operating system.

1985-1994 Confidential,
Russia
Programmer/Analyst

Designed and implemented statistical programs, applying extensive knowledge of advanced mathematics, such as differential equations and numerical analysis.

• Developed suite of programs in PL/1 to halt incoming statistical information on commercial fishing, evaluate the data adequacy, and then provide the data for forecasting areas. Applications performed in PL/1 using CICS and VSAM.
• Implemented new reports and maintained existing modules of Human Resources System using COBOL II, JCL on OS/MVS environment.

EDUCATION:

1979-1984 Polytechnic University, Sevastopol, Russia
MS in Computer Science