SPECIALIZING IN
- Data Warehouses, Data Marts, Operational Data Stores
- Information Engineering (Data and Process Modeling)
- Relational Database Design (E-R based)
- Project Planning and Project Management
- System Design and Programming Specifications
- Software Package Evaluation, Installation, Conversion
- Training and Troubleshooting
- Quality Assurance
APPLICATIONS
- Financial:
- Secondary Marketing
- General Ledger
- Accounts Payable
- Accounts Receivable
- Collections
- Asset Management
- Purchase Orders
- Inventory
- Health:
- Major Medical
- Pharmaceutical
- Disability Claims Processing
- Banking: Secondary Marketing
- Human Resources
TECHNOLOGY
- CASE tools: BACHMAN, ERWIN
- Relational databases: DB2, CA-UNIVERSE, ACCESS,
- SYNON, Rbase
- Platforms: AS400, Client/Server (NT), MVS/TSO
EXPERIENCE
Nation-wide Savings & Loan Association (8/97 - present)
Project Manager - Banking
- Responsible for the design and implementation of two data marts. Providing leadership for data analysis activities on legacy data, the creation of a logical data model and the logical database design. Responsible for data acquisition, data cleansing and data transformation. Responsibilities also include creation and maintenance of meta data.
Data Processing Company (5/97 - 6/97)
Consultant - Manufacturing/Exports
- Performed the data analysis, created a high-level data model as well as a logical database design, and designed shipping forms for the Auto Parts Sets Export system.
Aerospace (9/95 - 4/97)
Consultant - Manufacturing
- Responsible for the evaluation, maintenance and production support of the Assets Backed Securities system (VSAM/COBOL). Designed and implemented a front end application for the selection, evaluation and processing of portfolios (MS/ACCESS). Major responsibilities included requirements definition, data analysis and data modeling, designing the system, the database, screens and reports, data mapping, and creating DW tables for ABS (DB2).
Nation-wide Savings & Loan Association (5/94 - 4/95)
Consultant - Banking - Responsible for the conversion of a Secondary Marketing application from IBM mainframe to Client/Server using DB2, Windows, SQL, and ACCESS. Responsible for the evaluation and documentation of the old system functions and the definition of new requirements. Performed extensive data analysis and produced a fully-attributed data model. Designed the system, database, screens and reports.
Film Production Company, Santiago, Chile (12/92 - 5/93)
Consultant - Accounting
- Responsible for defining user requirements for a Payroll system and an Accounts Payable system in the film industry.
Health Insurance (10/90 - 6/92)
Sr. System Analyst
- Responsible for defining user requirements for membership and claims processing; in depth evaluation of SOTRISS and GENELCO claims processing system for the AS400. The evaluation included analysis of the overall system design, quality tests of procedures, programs and data utilization, in order to determine the extent of the modifications needed, and to determine the number and complexity of new programs required for system acceptance. Developed the program specifications for modifications and new development. Created a prototype using SYNON.
County Government (7/88 to 6/90)
Sr.System Analyst
- Responsible for the maintenance and production support of the Financial Management System, G/L, A/P and Collections, using IBM 3090, OS/MVS, CICS/VSAM. Responsibilities included:
- Writing of user requirements for enhancements and modifications;
- Re-engineering of the system to simplify maintenance and to speed up processing;
- Writing programming specifications;
- Performing acceptance testing;
- Providing user support for daily, monthly, and fiscal year-end processing.
Telephony (10/86 - 6/88)
IM Analyst, Office systems - Responsible for the feasibility study, proposal, cost benefit analysis, design, implementation, and testing of two systems:
- Office Automation Equipment & Resources Management, a PC based system using R-Base and LAN
- Online Employee Directory, developed for DEC VAX, using JAD methodology.
Consulting Firm (4/84 to 6/86)
Systems Engineer
-
Responsible for seminar presentations; the pre- and post-sales support of CA Financial systems; modeling and prototyping of CA UNIVERSE, a relational data base; evaluation of customer requirements and needs of hardware and software; recommendation and planning for installation and implementation; software installation, training, system support and trouble shooting.
CLIENT LIST & REFERENCES
- Available upon request.
|