Resume 5

Twenty three years of diverse work experience in Information Technology. This has involved Project Management, Structured Systems Design and Analysis, Application and Systems Programming, Database Administration, Data Modeling, Data Communication, Networking of IBM PC to IBM Mainframes and Software Engineering.

Far Eastern University , Manila, Philippines
B.Sc. Electrical Engineering 10/82

IBM 370, 4331, 4341, 4381, 4391, 3033, 3083, 3090, ES 9000, S/390, IBM S/3, S/34, S/36, S/38, AS/400, RS/6000, NCR TOWER, NCR SYSTEM 3000, NCR ATM, AT&T, DEC STATION 3000/5000, DEC VAX 4000, SUN WORKSTATION, PERKIN ELMER, and PC

COBOL, RPG II & III, PASCAL, FORTRAN, BASIC, C, and C++

MVS/ESA, TSO, JCL, ISPF, VSAM, CICS, SSP, PCFSU, OS/400, AIX, OS 32, UNIX, MS-DOS,WINDOWS/NT, VMS, ULTRIX, SOLARIS, LINUX

TOTAL, ADABAS, NATURAL, IMS, DB2, SPUFI, QMF, CSP/AD, INGRES, ORACLE, SYBASE, MS-SQL SERVER, DBASE, VISUAL FOXPRO, CLIPPER, PARADOX and POWERBUILDER

BACHMAN, MARTIN, JSD and ERNST & YOUNG NAVIGATOR, IEW, ADW, IEF, BACHMAN/DBA, ERWIN, SILVERRUN, WINCAP

ESSBASE, EIS, HAL, DATA STAGE, BRIO, ACTAWORKS, OLAP, MOLAP

I was involved in doing some data integration to link Essbase OLAP database using ETL tools such as Hyperion HAL or Ascential Data Stage. Responsible for providing technical expertise in data integration for software packages such SAP/R3, JD Edwards, Lawson, Peoplesoft, DB2, Oracle, Ms-sql server and Sybase.

Environment: Windows NT/2000, OLAP, Essbase, MS-SQL 7, ORACLE, DB2

Involved in the migration of Microsoft SQL Server 7.0 to Solaris Oracle 8i, doing schema re-engineering, conversion of TSQL stored procedure to Oracle PL/SQL, transformation of all MS-SQL data tables to Oracle. Also responsible for the day-to-day task of maintaining production MS-SQL database, like fine tuning, backup and recovery.

Environment: Sun 3400, SOLARIS, LINUX, WINDOW NT 4.0, MS-SQL 7, ORACLE 8i, Erwin

Involved in doing Data Modeling, data mart and ODS development, designing data warehousing boundaries and parameters, Data Transformation, PL/SQL and TSQL stored procedure and DataStage Universe Basic coding. Also responsible in designing, setting up and administering BRIO data repository in Oracle 8, Sybase 11.9 and MS-SQL 7 databases.

Environment: SUN Server, SOLARIS, RED HAT LINUX, WINDOWS NT 4.0, SYBASE, ORACLE 8, MS-SQL 7, ER STUDIO 3.5, DB ARTISAN 5.3

Involve in doing Data Modeling in preparation for migrating legacy application from flat file to ORACLE database, also using ORACLE DESIGNER as Case Tools for analysis, design and creation of Metadata repository for Princess Cruises. Perform data mining, data mapping, data graphing using OLTP and OLAP tools such as Business Object, Relational Rose Red brick software packages. Reverseand Forward re-engineer current database using ERWIN, by adding, and modifying tables on databases. Coding Stored Procedures for Sybase TSQL, CSP/AD-DB2, PowerBuilder, and AIX Shell Script. Also perform DBA function such as backup and recovery, fine tuning, replication and physical database creation through CASE tools.

Environment: IBM S/390, RS/6000, MVS, TSO, JCL, ISPF, CICS, ENDEAVOR, CSP, DB2, SYBASE, AIX, COBOL, POWERBUILDER, MS ACESS, SILVERRUN, WINCAP, ORACLE

Prepare program specification prior to coding using Entity Relation Diagram for Client Server Development projects. Perform program coding in Cobol language using Embedded SQL as interface to Sybase Databases. Also Perform DBA and System Administration task for fine tuning performance, replication of Sybase Database, like coding Stored Procedures, Triggers. Perform Data Modeling analysis of current Logical and Physical database used by various manufacturing application.

Environment: DEC MicroVax 4000, Alpha, Pentium-based PC, Novell LAN, Windows 95, Windows NT, DEC Cobol, Sybase, 4th Dimension - Client Server Gui, Reflection

Responsible for doing analysis, debugging, modification and testing of the IV-D financial module of the Child Welfare Support System of the State of Nevada - Nomads Project. Perform program coding in CSP/AD, DB2 SQL, generate ALP codes for CICS and JCL. Update documentation pertaining to Entity Relation Diagram and Pseudo Code for the CSP specification.

Environment: IBM ES 9000, IBM PC s, MVS/ESA, CICS, TSO, JES2, ISPF, REXX, DB2, CSP/AD, SPUFI, QMF, OS/2.

Responsible for the development of GUI application using Visual FoxPro Ver 3.0 as standard Platform, running under Windows 95 and NT server. Design object classes and database tables for reusable interfaces with different software packages like RMA and ACCPAC Accounting Packages. Perform program coding using Visual FoxPro Ver 3.0, Stored Procedures and Trigger at Client Server level using MS-SQL Server 6.0.

Environment: 486 and Pentium-based PC, Novell LAN, Windows 95, Windows NT, Visual FoxPro, Micro Focus Cobol, ACCPAC Software Development Kit, Crystal Report Writer, Visio

Develop functional specification utilizing DFD, ERD, PAD, and Crud Matrix using IEF and ADW 2.7 CASE tools. Develop Data Warehousing DB2 multidimensional fact logical and physical databases based on Star Schema. Perform Data Modeling, Database Administration and program coding in COBOL, CICS, CSP, PowerBuilder, TSQL Stored Procedures and Triggers for SYBASE. Also do DBA tasks like backup, fine tuning and replication of SYBASE Databases.

Environment: IBM ES 9000 IBM PC s, NCR 3000, SUN 100/20 Workstation, MVS/ESA, TSO, JES2, ISPF, DB2, CSP/AD, CICS, SPUFI, QMF, SYBASE, PowerBuilder, CASE Tools ADW 2.7, Ernst & Young Navigator, BACHMAN DBA, IEF Version 5.0

Provide consultancy services such as system analysis, database design and software construction through the use of IEW CASE Tools. Perform DBA and database program coding for Stored Procedures and Triggers on SYBASE, ORACLE and INGRES database. Install and set-up UNIX operating system for NCR 3300 and DEC 3000 hardware.

Environment: DEC VAX 4000, NCR 3300, NCR ATM, IBM AS/400, IBM OS/400, RS/6000 VMS, ULTRIX, AIX, UNIX System V, Ingres, Sybase, Oracle 6.0, CASE Tools IEW Ver 5.0

Conduct Data Gathering and JAD Session with Asthma - Allergy Medical Specialist Practitioner. Develop user s requirement and detail functional specification using Entity Relational Diagram, Program Action Diagram and Structure Charts. Perform C/C++ program coding using Borland C++ 3.5 compiler.

Environment: 486 EISA PC - MS DOS, Windows 3.1, Borland C/C++ Ver. 3.5, CodeBase, Liant Libraries, CASE Tools - EasyCase Plus Ver 3.1

Develop data model diagram based from Entity Relation Diagram, Structure Chart, Process Flow Diagram, Action Diagram, using IEW Ver 5.0. Engage in the development of an Integrated Hospital Management Care System, using ORACLE Version 5.0 and 6.0 as standard platform. Utilized ORACLE SQL Forms Writer and Reporter and code PL/SQL. Generate COBOL code through IEW GAMMA software construction module.

Environment: IBM 4381, 4391, 3083, ES 9000, PC s, MVS/XA, TSO, ISPF, JES2, MANTIS, PANVALET, CICS, COBOL, C, TOTAL, Oracle 5.0 & 6.0, Millennium, FoxPro, Case Tools IEW Ver. 5.0 Gamma COBOL Generator

Develop Data Model Diagram based from the Context Diagram, Data Flow Diagram, Entity Relation Diagram, Structure Chart and Process Flow Diagram, using EXCELERATOR package. Design and prepare testing strategy procedures. Code IMS DL1, COBOL, JCL and CLIPPER programs for Uploading and Downloading of IBM Mainframe files.

Environment: IBM 3033, 3090, PC s, MVS/XA, TSO, ISPF, CICS, JES2, PANVALET, SAS, Novell LAN, IMS, Clipper, FoxPro, COBOL, FORTRAN, BASIC, C, CASE Tools Excelerator.