Target Positions:Data Architect, Data Modeler, Database Designer

Professional Skills and Technical Experience - Highlights:

• Data modeling and design of relational transactional OLTP databases (tools used: ERStudio, ERWin, Oracle Designer, etc).
• Data warehouse design: OLAP star-schema, reference dimensions (Oracle Reports, Business Objects, Informatica ETL).
• Data architecture planning for data integration across applications with data exchanges via XML (XML Spy, Stylus Studio).
• Data standardization including development of data dictionaries, metadata repositories (ISO-11179 data element naming).
• Requirements analysis/definition (IDEF data flow diagrams, object-oriented methods), business process reengineering.
• Experience in information system development methodologies (structured and prototyping), techniques, and standards.
• Experience in planning agency/enterprise-wide information systems architectures (based on the Zachman's Framework).
• Experience in ISO data management standards: ISO-11179, product engineering data (STEP), and geospatial data.

Business Areas with extensive business experience:

• Insurance policy data management for multiple lines of business (Personal Auto, Business Owners) and ACORD standard.
• Healthcare information integration using the international data exchange standard HL7 and national healthcare data models.
• Project, program and work management data including budgeting and financial accounting data for US Federal agencies.
• Transportation safety data for safety analysis and improvement in highway traffic and civil aviation transportation (FAA).
• Asset supply chain management data - product life cycle data for FAA facility & equipment including procurement data.
• Resource allocation data: Panama Canal ship schedules, resource allocations (locks, pilots, tugs), waterway geospatial data.
• Environmental protection EPA data: site contamination, hazards, workflow mgmt, performance measurement, enforcement.
• Environmental management on US Postal Service applications: hazardous tanks, asbestos removal, energy conservation, etc.
• Product configuration and logistics data (engineering, supply, maintenance) - Coast Guard information systems architecture.

3/09 - 9/09 Confidential, Canton, MA
Consultant, Data Architect

• Design of a relational database for healthcare insurance policies (healthcare providers, malpractice, etc.).
• Development of the data warehouse for insurance policies (for any Property & Casualty line of business).
• ERWin was used for data modeling, database schema generation, physical database optimization.
• SQL Server 2008 tools used to implement the data warehouse, multi-dimensional cubes, ETL processes.

8/08 - 2/09 Confidential, Worcester, MA
Consultant, Data Architect

• Design and development of the relational database for the Specialty Insurance policies.
• ERWin was used for logical and physical data modeling, database schema generation for SQL Server 2005
• SQL Server 2005 tools were used for data profiling, loading reference data, legacy data migration.
• Application of the universal data model for insurance to the Specialty Insurance line of business policies.

9/07 - 8/08 Confidential, Wakefield, MA
Data Architect

• Data modeling and design of data warehouse for insurance claims (for data mining, decision support).
• Data mapping using Informatica ETL tools and XML tools (XML Spy).
• Developed a universal data model for insurance policies of any line of business (P & C, healthcare).
• Developed a universal data model for healthcare delivery activities (based on an extensive analysis of several data models used in US and European healthcare systems, HL7, Veteran's Administration, CDC).

2/06 - 8/07 Confidential, Quincy, MA
Data Architect, working as an Independent Consultant

• Data modeling and database design to computerize insurance policies and integrate well-structured data with poorly structured information contained in insurance policy documents.
• Application of the insurance data exchange standard ACORD (defined for the whole insurance industry in several extensive XML schema) to automate data exchanges between insurance agents, insurance carriers and external application systems.

1997 - 1/06 Confidential, Cambridge, MA
Consultant/Contractor in the roles of a Data Architect, Business Analyst
Volpe National Transportation Systems Center (R & D center of the US Department of Transportation)

Federal Motor Carrier Safety Administration (FMCSA) - agency within US DOT:

• Defined data exchange standards and XML schema for integrating data between FMCSA systems for: commercial carrier registration, vehicle inspections, safety compliance reviews, safety evaluation/analysis, company licensing & insurance, accident data, and legal enforcement data.

Confidential
Federal Aviation Administration (FAA) - agency within US DOT:

• Requirements analysis and data modeling for a new FAA Asset Supply Chain Management system to replace several legacy systems for life cycle management of assets, project materiel, and inventories.
• Planned data migration and integration between FAA legacy databases and new asset mgmt systems.
• Planned FAA data architecture for integration of data across FAA systems and organizations.
• Performed standardization of data elements and reference data using the FAA metadata repository compliant with ISO-11179 international standard for specification and standardization of data elements.
• Developed a global data model of aviation safety data for the Federal Aviation Administration databases including aircraft categorization and identification, accident causal factors, risk assessment data, etc.

Panama Canal Commission - former federal agency within US DOT:

• Designed and developed in Designer 2000 an Oracle 8 database for automated scheduling of ships in Panama Canal - Enhanced Vessel Traffic Management System (EVTMS). The EVTMS system is used in the Panama Canal successfully since 1999 for advance scheduling of ships and real time traffic control.
• Programmed in SQL the EVTMS database views and stored procedures for the advance traffic scheduler (smart event time calculator for ship transits in Panama locks) and for the pilot scheduling application.

Confidential
US Postal Service:

• Defined user requirements and designed database structures for a US Postal Service application Environmental Management Information System (using ERWIN for Power Builder and Oracle).

1986-97 Confidential, Cambridge, MA
Task Leader, Systems Architect, Consultant/Contractor

Federal Aviation Administration:

• Developed a data model and designed a database to integrate program/project management information including budgets, investment plans, projects, schedules, tasks, products, resources, personnel, contracts, and facilities (developed in S-Designor and Oracle Designer 2000 for the relational Oracle database).
• Environmental Protection Agency: environmental data integration for all US Superfund sites

• Modeled and designed a large relational database for the national Superfund information system CERCLIS containing: 240 tables, 2300 columns, and 420 relationships (developed in the data modeling and code generation CASE tools Silverrun-RDM and Power Builder generating code for Oracle).

Confidential
IS Development for the US Coast Guard logistics (business analysis, planning, systems design)

• Planned information systems architecture for USCG Shipyard including MIS, CAD/CAM, MRP.
• Performed business analysis of ship design and repair at Maintenance & Logistics Centers and HQs.
• Planned information systems architecture of Supply Centers (14 applications, 12 subject databases).
• Designed a logical data model for the Supply Centers (450 data entities, 15 functional areas).
• Designed a system to automate ship maintenance, supply, and configuration management.
• Developed a data model and designed a database for the ship logistics system (Progress DBMS).

IS Architecturefor the US DoD initiative Computer-aided Acquisition & Logistics Support (CALS)

• Planning data integration of product engineering data and logistics support analysis record (LSAR) data.
• Planning automation of technical documents (engineering drawings, computerized manuals).
• Defined requirements, designed, and programmed the logistics Transportation Distribution System for the US Air Force initiative LOGC3I (using the DOD system development standard 2167A).

1982-90 Confidential, Cambridge, MA
Senior Analyst, Methodology Expert, Project Manager (1987-90)

• Introduced an information systems development methodology Productivity+ at MIT IS.
• Evaluation of information systems development methodologies and selection of Productivity+.
• Methodology implementation through pilot projects, training IS developers, adaptation of CASE tools.
• Development of several MIT database application systems (specification, design and programming).
• Personnel, payroll, property, publications, telecommunication, office automation projects.
• Designed Computerized Account Manager application for projecting departmental budgets.
• Administrative data & process modeling, design of databases, applications, programs, reports.

Systems Programmer, Database Architect, Technical Supervisor (1982-87)

• Development of the Relational Database Management System (RDMS) and its applications.
• Designed, coded and implemented RDMS data dictionary, programmed relational operations.
• Technical leader of the RDMS project team of 6 application and systems programmers.
• Consulting, designing, and programming of RDMS applications (in C and PL/I).

1981-82 Confidential, College Park, MD
Confidential, Silver Spring, MD
Visiting Researcher

• Research on methods and techniques of requirements analysis and software design.
• Design of full extensibility features for the Information Resource Dictionary System (IRDS) standard as subcontract for National Institute of Standards and Technology (NIST).

Shorter consulting assignments in parallel to work at CSC, Unisys and MIT:

1998-99 Confidential, Panama
Database designer (as Independent Consultant)

• Design and implementation of a relational database for the new Panama Canal scheduling system.

1995-96 Confidential, Boston, MA
Independent Consultant

• Design of a data warehouse and a relational database for the NYNEX decision support system to track, project, analyze, and improve performance of NYNEX repair and installation teams based on comparison of workload to workforce and aggregation of summary measurement data for measures of work productivity and quality.

1994-95 Confidential, Cambridge, MA
Consultant/Information Systems Developer

• Design of applications for the USCG National Pollution Fund Center to automate document management and financial operations for cleanup of water pollution cases (Progress, Lotus Notes).

1992-93 Confidential, Cambridge, MA
Independent Consultant, Systems Architect

• Business analysis of the US Coast Guard Shipyard using the object-oriented modeling.
• Planning of USCG data administration strategy, plans, procedures, and metadata repository design.

1985-86 Confidential, Cambridge, MA
Independent Consultant

• Designed and programmed an application/code generator for the Model 204 database mgmt system.

1983-85 Confidential, Billerica, MA
Independent Consultant

• Development of distributed directory services for electronic mail on Honeywell computers.

TECHNICAL TOOLS QUALIFICATIONS SUMMARY:

• Modeling & development tools: ERStudio (Embarcadero), Oracle Designer, ERWin, Silverrun, System Architect.
• Data integration & reporting tools: Informatica, Oracle Reports, XML Spy, XML Stylus Studio, Business Objects.
• Database management systems: Oracle, MS-SQL, MS-Access, RDMS, Model 204, IDMS, RODAN (Codasyl).
• Operating systems/hardware: Windows, UNIX, IBM PC, Apple, IBM mainframes, DEC, ICL, Honeywell Multics.
• Programming languages: SQL, PL/SQL, XML, HTML, C, PL/I, Fortran, Algol, Cobol.
• Development methodologies: US DOT & DOD standards, EPA Life Cycle, DMR Productivity+, Information Engineering.
• Modeling/design techniques: Entity-Relationship Diagrams, Unified Modeling Language, Business Process Modeling, Data Flow Diagrams, IDEF, SADT, object-oriented methods.

AWARDS:

• 2002 US DOT Award for outstanding work on the FAA Asset Supply Chain Management system.
• 1998 US DOT Award for the development the new traffic scheduling system for the Panama Canal.
• 1997 Award for the Environmental Management Information System for the US Postal Service.
• 1996 US DOT Award for the development of the National Superfund Database for US EPA.
• 1991 Quality/Productivity Award for the US Coast Guard information systems architecture work.

EDUCATION:

Department of Electronic Engineering and Computers
MS Electronic Engineering, Specialization in Computers
Thesis on "Computer Hardware Description and Simulation Languages" and for the implementation of the gate level simulator of digital structures.

Computer Science Department
Graduate level courses on Databases and System Development Methods.

Graduate level courses on Management Information Systems.
Training courses in information system development methodologies, techniques, and tools.