Yelena Krupnik

**** *** ******* # *-*, Brooklyn, NY 11214 phone 347-***-**** ac46uc@r.postjobfree.com

Objective

Highly motivated and energetic professional with 20 + years of development experience in

IT Operations and Data Processing in Legacy System with full attention to customers’ needs, business constraints, and technological realities looking for full time, or long term-contract to utilize acquired skills and experience within a progressive and cutting edge Company.

Summary of Qualifications

20 years of experience in IT Operations and Data Processing.

Experience in implementing Technical & Functional projects.

Skilled at problem solving and developing unconventional solutions.

Energetic, self-motivated, and responsive to client needs.

Hardware

IBM 3081, 3090/370, IBM PC

Software

COBOL, COBOLII, CICS, DB2/SQL, EGL, OS/MVS, VSAM, OS/JCL, TSO, FILEAID, XPEDITER, DTCN, CSP3, CSP4.1, VAGEN, RBD, CSV, ENDEVOR, EASYTRIEVE, Stored Procedures,

IT Service Desk, CM (Change Management), Microsoft Office.

Professional Experience

Sr Applications Programmer

Visiting Nurse Service of New York 1/1994

●Designed, created and implemented new Census Tract based Escort model. Implemented robust stored procedures, functions and triggers. Individually designed a number of applications according to business requirements.

●Enterprise COBOL/CICS programs used to create an interface file and transfer it to PeopleSoft(HR, Payroll systems) via MQ.

●Converted an VSAM based Payroll System to a DB2 based PeopleSoft sourced system. Developed code to receive accounts receivable transaction data from PeopleSoft and load new DB2 Enterprise tables.

●Developing of MQ based process with automatic Medicare and Medicaid clearance on Mainframe.

●Customized Referral and Clinical system in order to support VNS CHHA Expansion to Suffolk County. Was fully involved in strategy, design, transition and operation stages of this agency initiative.

●Develop, maintain, and support application programs for the Plan of Care System.

●Maintain nurse, therapist, and paraprofessional visits.

●Played a key role in the design of the DB2 tables, CICS and EGL screens, and batch programs for all of the aforementioned systems at their inceptions, and converted all VSAM database code to DB2. Strong Knowledge of SQL and ability to tune SQL queries. Designed multi-dimensional data models through all stages of Data Modeling Life Cycle .

●Developed massive report for nurse productivity using comma-separated values (CSV) files and processes to summarize nurse visits by pay period .

●Fixed many of the functional, performance and production issues thru the years.

Full development life-cycle of number a projects such as:

●Plan of Care Redesign according to new business requirements for 2016-2018 ;

●Medicare and Medicaid clearance project redesign according to new business requirements provided by the Centers for Medicare and Medicaid Services (CMS);

●Developed massive report for nurse productivity using comma-separated values (CSV) files and processes to summarize nurse visits by pay period.

●Created and edited stored procedures and user defined functions using DB2 SQL;

●Created the data interfaces between the Cobol and Oracle, Cobol and PeopleSoft;

●Maintained and enhanced system providing accurate and timely resolutions ;

Participated in architecture planning on some projects to ensure applications are developed within the context of the enterprise architecture.

●Development and Support of Clinical and Referral Systems;

●Played a key role in the design of the DB2 tables, CICS and EGL screens, and batch programs for all of the aforementioned systems at their inceptions, and converted all VSAM database code to DB2.

●Programmed the back-end using Cobol, CICS and EGL with connectivity to a DB2;

●Updated and modified applications based on the feedback of end-users;

●Fixed many of the functional and performance issues thru the years;

●Participated in business discussions with non-technical audiences;

Applications Programmer, Consultant

Merrill Lynch, New Jersey (01/1993-12/1993) Assisted clients of this service bureau in order to handle heavy volume trading of mortgage-backed securities by enhancing the reporting of securities in on-line and batch programs. Coded a variety of data entry screens for security trading and customer support.

Education

Globe Institute of Technology, New York

Kiev state Pedagogical college. Ukraine.

Contact this candidate