Project System

Title:Database manager assistant

abpndc@r.postjobfree.com

Document

Source below

NAME: Alfredo Alcausin

ADDRESS: **** ****** ***

CITY: Sacramento

STATE/PROVINCE: CA

ZIP/POSTAL CODE: 95821-5848

COUNTRY: USA

EMAIL: abpndc@r.postjobfree.com

PHONE:

CANDIDATE ID: 217654

CITIZENSHIP: Permit

EDUCATION: Bachelor Degree

EXPERIENCE: 24

WILL RELOCATE: Open

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED:

HOMEPAGE:

HOTSKILLS: Adabas/Natural; COBOL, Easytrieve, Assembly, Full Systems Development Life

Cycle- IEEE Standard

ESUME

TECHNICAL SUMMARY:

SUMMARY: Alfredo B. Alcausin has over 24 years of IT experience:

programming/analysis with focus in IBM-Mainframe for Hardware, and COBOL,

Natural, Easytrieve and Assembler

for programming languages. System Development according to IEEE Standards

documented

phase by phase progress in Jad Sessions; Structured Systems Design and Project;

Multi-level test plan, execution and verification, documentation in Predict,

Endevor.

OPER. SYSTEMS: OS/390, MVS/ESA, MVS/XA, WINDOWS 98/95/NT, UNIX.

UTILITIES, TOOLS: IBM-UTILITIES: IEBGENER, IDCAMS, SORT/MERGE, etc.

TSO, ROSCOE, Easytrieve, MS Office, Access97, Flowchart 7,

ENDEVOR, VIASOFT-Smart Test.

LANGUAGES: Natural 3.14,VS COBOL, COBOL LE/370, Micro Focus Cobol, Easytrieve,

Assembler.

DATABASES: ADABAS, IMS-DB, TOTAL and ACCESS 97.

DBMS: Adabas-Natural, IMS-DB/DC, Total DBMS, and Access 97.

PROFESSIONAL EXPERIENCE:

CLIENT: (California State

) DEPARTMENT OF MOTOR VEHICLE (DMV) 05/00 to 04/01.

Responsibilities included: Directly responsible for the Employer Pull Notice

System, for maintenance and enhancements in both Online and Batch environment.

Team member for Maintenance and enhancements of the Driver License system (with

a home-grown Database).

Environment: IBM Mainframe, Adabas-Natural under CICS / TSO, Assembler, Windows

NT, Rhumba.

CLIENT: (California State

) BOARD OF EQUALIZATION (

08/99 - 09/99)

Responsibilities included: JCL adaptations for laser printer with AFP; JCL

imbedding into Online programs for User Online started Batch processing, and,

printing to user directed printers.

Environment: Mainframe, Adabas-Natural under CICS/ TSO, Windows 95 with

ATTACHMATE.

CLIENT:

SACRAMENTO COUNTY - Public Works Administration

(01/99 - 07/99)

Project: Migrate the whole system from ADABAS-Natural to

SAP:

Extract all the

information from the Database; select all pertinent data; load in the SAP.

(Life cycle covered: specification to implementation).

Responsibilities included: Creation of Extractor Programs, Data complementation

programs. Prepare model files for testing and debug, Programs and system debug,

Units and system testing in PC and in the UNIX BOX.

Environment: WINDOWS 95/ NT 4.0; NetExpress-Microfocus COBOL, UNIX.

CLIENT: PRISON INDUSTRY AUTHORITY (

10/98

- 12/98)

Principal Responsible for the Y2K Compliance of the Payroll and Personnel

Roster System.

Environment: Mainframe, flat files in tapes and disks, Windows 95/98, TSO, COBOL

LE-370, IDCAMS, PC with Attachmate.

CLIENT:

EDS - ELECTRONIC DATA SYSTEMS

(03/98 - 09/98).

Project: Large scale System Maintenance and Enhancement of the Financial Aid

Processing System.

Responsibilities included: High Level Estimates for the requested services;

Write out detailed service request analysis (SRA), technical design for the

more complex requests, labor estimates, etc.; Coordinate changes with other

ongoing updates; SRA and coding walkthroughs; plan, execute and evaluate test

results; Implementation preceded by User system test and evaluation; Post

implementation review; Documentation, On Call services in the User Test

Environment.

Environment: Mainframe, ADABAS-Natural under CICS/ TSO, PREDICT, WINDOWS 95 with

ATTACHMATE, CA-7, PSI, MS Project.

CLIENT:

CSN - NATIONAL STEEL COMPANY of Brazil

(01/90 -01/98)

Project: Investment Budget System (IBS) Partial Implementation of a system

previously started.

Responsibilities included: Unit testing, Complementation, and, enhancements of

inefficient units; Implementation of tested units.

Environment: Mainframe, MVS/ESA, ADABAS-Natural.

Project: Financial and Accounting System (FAS) Maintenance.

Responsibilities included: Frequent adjustments due to the economic fluidity of

the country, Enhancements as per requests of the end-users; Creation of special

reports for independent Auditors.

Environment: Mainframe, MVS/ESA, COBOL, IMS DB/DC, JCL, Easytrieve.

Project: Job and Career Planning System (JCPS) partial implementation from

partially completed design.

Responsibilities included: Database design and specifications, Program

specification and some eventual program coding, Unit and system testing and

debug, JCL coding.

Environment: Mainframe, MVS/ESA, ADABAS-Natural, JCL, PC-Case (for designs).

Project: Personnel Timekeeping System (PTS) complementation and enhancement of

the recent system.

Responsibilities included: Program specification and some eventual program

coding, Unit testing and debug, JCL coding.

Environment: Mainframe, MVS/ESA, ADABAS-Natural, Online and Batch.

Project: Pre-Payroll System (PPS) - Design through implementation (complete

system life cycle).

Responsibilities included: project lead- plan and design system processes and

database; specify file layouts, specify programs, and, some eventual program

coding; Unit and system tests and debug, JCL coding; Plan, track and report

project status; Implementation and Documentation.

Environment: Mainframe, MVS/ESA, ADABAS-Natural, Easytrieve, JCL.

Project: Personnel Information System (PIS) complementation and enhancements of

the recent system.

Responsibilities included: Program specification and some eventual program

coding, Unit testing and debug, JCL coding, and, Documentation.

Environment: Mainframe, MVS/ESA, ADABAS-Natural - Online and Batch.

Project: Juridical Work Complaints System (JWCS) Design through implementation

(complete system life cycle).

Responsibilities included: Project lead, define system requirements, design

database, tables and record layouts. Specify programs, unit tests, eventual

program coding, JCL specification and coding; Online and batch system tests and

debug; Plan, track and report development status, Documentation.

Environment: Mainframe, MVS/ESA, ADABAS-Natural Online and Batch, JCL, PC-Case.

Project: Meal and Snack Control System (MSCS) - Initial development.

Responsibilities included: Collect and organze system information and

requirements, write up and report system costs and benefits, Design system flow

and records layouts.

Environment: PC, PC Case, FlowChart 3.

CLIENT:

CSN - NATIONAL STEEL COMPANY of Brazil

(06/75 - 12/89)

Programmer

: as a member successively of the development and maintenance teams.

Projects: Wide variety in the administrative area: Personnel, Finance and

Accounting; Production area: Supply, Inventory, Production Tracking, Sale,

Export, Transportation, etc.

Responsibilities included: program diagram, code, tests and debug, JCL coding,

and, Documentation.

Environment: Mainframe, MVS, OS/VS Cobol, TOTAL-DBMS, IMS DB/DC, MFS, JCL,

Easytrieves, IBM Utilities.

EDUCATION: BS

Administration, SOBEU, Brazil.

Licentiate Philosophy,

Don Bosco College, Brazil

Bach. Arts, English

Major, St. Louis University, Philippines.

CERTIFICATES: Pontif.Cath. University - CSN: Complete Abridged SYSTEMS ANALYSIS

Course

including Structured Analysis and Project, Data Structure, System Construction

tools, etc.

IBM - CSN: Complete unabridged Programming Course: Including modular

programming, Structured Programming, /370-OS, JCL, IBM Utilities, etc.

American River College (ARC) Access 97, and, Introduction to UNIX,

Basic Assembly Programming through DMV and Train-Right.

NAME and

ADDRESS : Alfredo B. Alcausin

2834 Elvyra Way

Sacramento, CA 95821-5848

Home phone: 916-***-****

Cell Phone: 916-***-****

Email: abpndc@r.postjobfree.com

Contact this candidate