We provide IT Staff Augmentation Services!

Data Architect Resume

3.00/5 (Submit Your Rating)

Canton, MA

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 – present LeapFrog Systems Consulting, Confidential,Canton, MA
Consultant, Data Architect

  • Design of the data warehouse for the Property & Casualty insurance and healthcare provider policies (database and ETL design was implemented in SQL Server 2008).

8/08 – 2/09 Veritude Consulting, Confidential,Worcester, MA
Consultant, Data Architect

  • Design and development of the relational database for the Specialty Insurance policies (SQL Server 2005). Application of the universal data model for insurance to the Specialty Insurance line of business policies.

9/07 –8/08 Confidential,MA
Data Architect

  • Data modeling, data mapping and data warehouse design for healthcare and insurance applications. Developed universal industry-wide data models for healthcare delivery data and insurance.

2/06 – 8/07 Confidential,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,, 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.

We'd love your feedback!