Resume: Matthew Rapaport. EAI/EDI/ETL
data/workflow DBMS development.
Updated spring 2008.
Twenty seven years in custom, intra and inter-corporate data
transfer (EAI) development, operations, and ETL for data warehouse/legacy
migrations. Automated transactions with vendors/customers (EDI), databases and
applications (ETL) using X12, XML, and numerous proprietary data formats.
Conversant with large-project life-cycles, data driven design, and development
tools -- project managers, change-control software, editors, run-time
environments, compilers, etc. Designed and implemented Relational Database
schemas, and both intra and inter-corporate data communication systems.
Implemented large applications working in management, lead, and support roles
in small and large projects. Since 1997, the much of this work was in Perl and
Oracle’s PL/SQL, in both the Unix and Windows
operating systems. I have experience in large scale database design, and
application development, analysis, and reporting in both PC, mini, and
mainframe environments, some going back many years but applied in new ways with
every new employment opportunity.
March 2008, Micrel
Semiconductor Inc. Milpitas,
consulting roll analyzing Micrel’s EDI requirements.
presentation to CIO.
appropriate resource for work.
2002 – 2007,
Oncology Therapeutics Network, South
development and operations in Tibco
Integration Manager, Java Script
development (10,000 transactions/day, 20+ documents, workflow, management
of 30+ trading partners) and operations migrated from Gentran to Tibco
Business Connect, Java script.
development (Vr. 10g PL/SQL, SQL+, Sqlldr, and other Oracle tools)
supporting daily loading (25,000 records/day) and analysis of medical
warehouse development. ETL and development of supporting algorithms for
business intelligence using star schema in Oracle vr. 10g.
for Informatics in PERL coordinating communications, database I/O, progress
and error reporting, and operational support.
of ETL workflow and algorithms (PERL & PL/SQL) for comparison of
medical clinic license and address data supporting efforts to correct
government (DEA & HIBCC) data for private clinics.
Test beds (PERL) for sales transaction data in support of EDI and ERP/CRM
2001 – 2002
Contracts to McKesson Corp(PERL) & Wells Fargo Bank (PL/SQL), San Francisco
development and operational management for Gentran EDI. Operations support
documents/day with many dozens of trading partners using PERL, and Sterling
and upgrade for ConnectMailbox including recovery and conversion of data
from new to old format in PERL.
consulting and performance tuning for large scale EDI environment with
support application package: Oracle/PL/SQL, SQL+, SQL Loader development
in support of small business loan intelligence analysis. Acquisition of
large scale industry business data, analysis of customer data in
comparison to industrial data, etc, generating decisions on million-dollar
lines of business.
– 2001 Xuma Corp., San Francisco.
(Evision) in support of multiple clients. Workflow in PERL.
- ETL and
legacy conversion, in support of client legacy databases with newer
web/oracle-based store fronts (PERL & PL/SQL).
code generator in PERL in support of ETL for various clients.
analysis algorithms (PL/SQL) in support of client CRM.
schema and supporting algorithms for data mining, business intelligence,
and client data warehouse.
– 2000 Headlands (later Greenpoint) Mortgage, Larkspur CA.
EDI suite (15+ documents (X12 & proprietary) 25+ trading partners,
6,000 txns/day) in PERL with PL/SQL I/O including full acknowledgement,
reporting, retransmission, non-repudiation, and encryption support
of DBMS (Oracle) Pipes and sockets (PERL, Java, C)
first, in industry, fully
automated loan origination system with X12 documents through to DBMS
insert and local printing of credit reports in PERL and PL/SQL.
support for all above development work, and all corporate data
communications access in and outbound.
and extension of corporate-wide centralized FAX server with 7500 page/hr
capacity. Development of extensions to this system permitting
corporate-wide access via email.
engineering of Fannie Mae serial data and resulting replacement of expensive
proprietary system with emulator under company control using PERL.
conversion (100+ tables, 1,000K+ records) from DataFlex to Oracle in
PL/SQL with coordinated PERL workflow. Hand tuned and extended PL/SQL
generated by early version of Oracle Migration Workbench (OMW).
of batch acquisition structure for large scale industry application in
corporate-wide remote procedure triggering using email for unix (sendmail) and MS Office email using REXX on OS/2.
Permitted agents throughout the U.S. to print reports and
forms from remote corporate data to local printers without direct
connection to corporate network.
1985 – 1993
American Express Life Assurance, Novato
claims system management (DataFlex)
design (Supra) for new claims system, re-write in
of EDI system for exchanging lead and sales data among Amex dedicated
sales offices nationwide (MLink and various other terminal emulation
- HR and
payroll development and operational support for 2 years using Revelation
(a Windows-based PICK emulator).
1982 – 1985
Datacom, Advanced Information Management, Petaluma,
- Napa County fleet cost accounting
system, data model design and system implementation, testing, production
cut over, and user training in report development.
- Russian River winery inventory and
production control software, schema design and software prototype.
terminal emulation software for DEC RSTS OS.
1980 M.A., San
Francisco State University, San
Francisco. Philosophy, symbolic logic
Other references on request.
Contact: Matthew Rapaport. Mobile (707) 477-2774; Email