Oracle System

MICHAEL SHEFFER

*** **** ***, ***. **,

Fort Lee, NJ 07024

201-***-**** -- Home

917-***-**** - Mobile.

**************@*****.***

OBJECTIVE: A growth oriented position utilizing my programming and

analytical experience.

Experienced with a wide range of development platforms, Unix,

Windows, Mainframe. Exceptional communication and

presentation skills.

SOFTWARE Oracle 9i, 10g, Sqlplus, PL/SQL, DB2, APS, TOAD, Microfocus

cobol, NetExpress 3.1, Server Express, Linux, Perl, DOS,

PVCS, Version manager

HARDWARE IBM PC's, IBM RISC 6000, HP 9000, LAN, IBM3090, Sun Solaris,

RedHat Linux.

EXPERIENCE

Consultant, Cognizant Lexington, MA

05/2010- Present

Oracle/ Unix/Mcrofocus Cobol developer on IBM RISC 6000,

AIX.

Writing Oracle SQL, Microfocus Cobol programs for Retail

Automation System for Collective Brands Sales Company.

Creating Unix Scripts on AIX, to compile, execute Mcrofocus

cobol programs, archive datafiles.

Using awk, grep, find, cat utilities and vi editor.

08/07 - 10/09 Consultant/System Engineer/Mainframe cobol/ Microfocus

cobol developer, AT & T,

Middletown, NJ

Wrote Microfocus cobol, using

Server Express, VSAM, Oracle PL SQL programs on

the Unix platform (Sun Solaris), wrote Korn Shell scripts to

compile and execute programs.

Created System and Feature Design, Interface

Agreement documents for the

project

which calculates Universal Connectivity Charges. These

charges

are calculated based on the data which was transferred from

mainframe

to the unix server in the Billing extract file. Used

Control-M to transfer the

files from mainframe to the Unix server.

Performed system test utilizing grep, sed, awk, find

utilities, vi editor and

TOAD.

Created reports based on the Oracle system which contains

more then million rows.

12/06 -- 5/07 BMW of North America, Woodcliff Lake, NJ

Datawarehousing / Conversion project/

Consultant.

Created and populated oracle tables with the data received

from the company headquarter in Munich, using sql loader,

converted SAP datatypes to Oracle datatypes. Converted DB2

stored procedures on mainframe to the Oracle stored

procedures on unix.

05/06 -- 9/06 One Call Medical, Parsippany, NJ

Consultant/ Oracle 9i developer

Wrote Oracle 9i stored procedures, using TOAD.

These stored procedures provide EDI between OCM and

different insurance companies by ftp'ing and encrypting

files between Linux and Windows servers.

The data is transmitted in binary and ASCII formats,

depending on individual profiles, which include (source,

destination directory, encryption indicator, compressing

indicator, login ids. Passwords, schedule, file names,

etc.)

11/05 - 05/06 BNP Paribas (French bank), New York, NY

Consultant

Maintained banks Report System (Atlas 2) written in

Microfocus cobol, Oracle 9i which is running on Unix

(AIX).

Modified Microfocus cobol programs, Korn shell scripts to

provide Canadian branches with reports in English or in

French, depending on the province name. Modified scripts

to animate programs and to redirect files to different

locations. These scripts use different Unix utilities (awk,

sed, grep, sort, etc.)

Heavy use of UNIX vi editor, Microfocus COBOL Animator,

VSAM files and SQL Navigator.

1/05 -- 7/05 Novartis Pharmaceuticals, East Hanover, NJ

Consultant

Developed new and modified existing

Microfocus Cobol and

Cognos Impromptu programs, these programs are part of the

CPCC

Contract, Pricing and Chargeback Component (CPCC) and

UPS (Utilization) Preprocessing systems.

CPCC system supports healthcare

contracts and services for

Pharmaceutical, medical/surgical

supplies, over-the-counter (OTC)

and diagnostic industries. UPS system

"scrubs" data from the

customer.

Microfocus Cobol programs contained

VSAM files, embedded

oracle SQL and PL/SQL.

Executed and tested on Unix servers

(Sun Solaris)

6/04 -- 11/04 Highmark Blue Cross/ Blue Shield, Pittsburgh,

PA

Assisted Highmark Blue Cross/Blue Shield with the analysis,

design, and implementation of programming modifications of

their Revenue Estimation and Group Settlement system,

developed new and maintained existing Microfocus cobol

2/Oracle 9i programs on Sun Solaris machines.

Created PL/SQL blocks and stored procedures to insert the

data into

Oracle tables.

Compiled Microfocus cobol programs to int, idy, gnt, using

Korn Shell script. Tested programs using Microfocus cobol

animator, SQL Navigator 4 and rtsora .

Created new Korn Shell scripts using

vi editor.

5/03 -11/03 DressBarn, Suffern, NY

Conversion project (Consultant).

Converted programs from Windows 2000, RM Cobol to Unix/AcuCobol.

Resolved the current problems with the scrolling data on the screen

with

the arrow keys, compiled, debugged, transferred, tested various

batch and on-line programs.

Project included the store field expansion, changing the location of

the data files, resolving the problems with the function

keys.

Used Alfred utility to display and to change the data in the

datafiles,

ftp commands to transfer the programs and the

datafiles.

Updated the Korn Shell scripts, using vi Editor.

10/00-12/02 Tesia Corporation, New York, NY

Participated in design, documentation and development

of moderate to complex applications.

Wrote new and maintained existing programs using

Microfocus Cobol, AcuCobol GT, DB2, rebuilt VSAM files using WFL

utility (accessed form the workbench menu).

Converted programs from UNIX and DOS operating systems to

Windows NT,

development has been performed in Windows NT and Unix

operating systems.

These programs provide real-time, interactive communications

between ambulatory providers and payers through the full

automation of all types of health care transactions - claims

adjudication, encounter data collection, eligibility verification,

clinical referral, hospital pre-certification and other related

transactions.

Worked individually as well as part of a small team of developers..

02/00 - 09/00 Long Island Rail Road (LIRR), Queens, NY

Consultant

Maintained and supported Work Management Subsystem

for the major Rail Road Company in North America.

The WMS subsystem is used to define, organize and prioritize

maintenance requirements for the entire railroad.

The System provides for creation of the various work order

types, such as Scheduled periodic inspections, RSU corrective

work orders and support shop work orders, support scheduling

of work order tasks and printing of daily work schedules.

MicroFocus Cobol/CICS is implemented as a front end, Oracle 8

as a back end, UNIX(AIX version 4.3.2.0) as an operating

system.

Developed Korn Shell Scripting using vi Editor.

Responsibilites included design of significant new subsystems

of Rolling Stock Management System (RSMS), coding of newly

designed modules, debugging program using the animator,

unit and system tests of new modules, turnover of new

enhancements to production.

Worked individually as well as part of a small team of

developers.

08/97 - 06/99 Pierce Technology, Montvale NJ

Consultant

Maintained and supported Time Detail System, for major accounting

Company (KPMG LLP), this system is

written in Microfocus Cobol2.

(Widndows operating system and Mainframe).

Heavy user support based on the

implementation of Remedy system,

used Microfocus workbench to write the source code, Animator to

debug programs,

Workbench File Loader (WFL) to Recover corrupted indexed files and

to convert data files from EBCDIC to ASCII format.

Accounts Payable, accounts receivable

programs were rewritten and tested to make them Y2K-

compliant, modified according to the specs.

Rebuilt VSAM files using WFL utility (accessed form the workbench

menu).

Examples of developed programs:

program to process control file to determine next cycle end

date, make data Y2K compliant, to sort data in the

personnel file if effective dates were in the wrong order.

Participated in the Design and Creation of the new TDS/HR System,

where data were brought from the Oracle tables, instead of

using VSAM files downloaded from mainframe.

Created and populated with data Oracle tables: Personnel,

Client and Engagement.

Processed data from these tables using Oracle SQL and different

functions

(SUBSTR, CONCAT, INITCAP, TO_CHAR, TO_DATE, SOUNDEX, AVG, COUNT,

etc.). Created Oracle procedures, functions and

triggers.

.

Other responsibilities included:

. Development of COBOL II/VSAM programs in the MVS

environment.

. Modifications and testing of On-line programs for the

General Ledger and Fixed Assets systems.

07/92 - 07/97 UPS, Mahwah NJ

Programmer

Wrote programs in MicroFocus COBOL II, Cobol2, APS, C with SQL to

process data from various tables using Watch, Step, setting

conditional Breakpoints and Zoom. Both character based and

GUI based versions are implemented. Programs support

Automotive and MaxiShip systems. Maintained DB2 data using

SQL Insert, Update and Delete statements for embedded and

interactive formats. Created and maintained hundreds of

Automotive and MaxiShip related programs. These programs

are written using the Client/Server Architecture; tested

and ran with the workbench animator.

I also supported the part of MaxiShip system that was written in

Microsoft C, v7 and DOS.

Managed version control and migration

to the new release of Automotive

System using PVCS.

Education: 1996 Computer Science Course Ramapo College, Mahwah, NJ

1988. Advanced course in Computer Programming,

Diploma, Cope Institute, Brooklyn, NY.

1974 - 1979 BS Degree in Computer Science

Auto-Mechanical College

References: Available upon request.

Contact this candidate