SUMMARY:

• Data modeling and logical design of OLTP relational databases (using ERStudio, ERWin, PowerDesigner, Oracle, IBM IDA).
• Design of data warehouses, dimensional modeling, OLAP data marts, master reference data (using Informatica ETL, Oracle BI).
• Data architecture and data integration strategy planning, SOA, design of data exchange XML schema (XML Spy, Stylus Studio).
• Enterprise information systems architecture - planning & development experience (using Zachman’s Architecture Framework).
• Experience with data-driven development, database management systems, modeling techniques, standards, and tools.
• Experience in both structured system development methodologies as well as prototyping/agile techniques and standards.
• Business requirements analysis/definition (data flow diagrams, object-oriented methods), business process reengineering.
• Development methodologies: DMR/Merise, IDEF, Federal Government Life Cycles, company specific methodologies.Data management including development of data dictionaries and metadata repositories (Informatica Metadata Manager).
• Experience in data standardization ( Confidential -11179 standard), product engineering data standards (STEP), and geospatial data.
• Creativity in formulating new concepts, defining critical requirements, proposing alternative approaches, and problem solving.
• Skills in facilitation of sessions for business requirements analysis and designing models (process and data) for IT developers.

PROFESSIONAL WORK EXPERIENCE:

Confidential, Boston, MA

Enterprise Data Architect, Sr. Data Architect

Responsibilities:

• Modeling Confidential customer and product data for the development of the master data management solution - implemented using Informatica tools: MDM, Metadata Manager, Business Glossary. Data modeling of digital products for education and publishing.
• Development of the Confidential enterprise data model (conceptual and logical) in ER/Studio using the Universal Data Model patterns.
• Modeling integration of digital product data and multi-media content data for publishing books and educational materials.

Confidential, Boston, MA & Merrimack, NH

Data Architect, Contractor

Responsibilities:

• Planning of the financial data architecture for the Fidelity fund accounting systems data integration and distribution - outcome
• Created the conceptual data model of mutual funds and Confidential logical data model based on key concepts of: Fund, Holding, Trade Transaction, General Ledger Account, and GL Balance.
• Created the conceptual data model of Fidelity financial data as guidance for development of the Fidelity financial data warehouse and performance analysis of financial products. This modeling process involved sessions with Fidelity data standardization teams and facilitating consensus on key business concepts: Investment Product, Security, Mutual Fund (type Fixed Income, Equity, etc.) Customer Account, Portfolio Holding, Trade Transaction, Performance Fact (Asset value, Cost, Revenue), Performance Measure.
• Modeling the Fidelity corporate finance data warehouse to integrate customer and financial product/instrument data loaded from many investment/brokerage systems and fund accounting systems. Data modeling and reverse engineering using PowerDesigner.
• Design and delivery of IT capabilities for accessing finance metadata starting from business terms down to data lineages stored in technical IT resources - intended for business users, analysts, and developers to understand and control metadata change impacts.
• Development of the Fidelity business terms glossary and metadata repository for fund accounting databases and applications using Informatica Metadata Manager. Capture of metadata (data entities, attributes, files, tables, columns, copybooks) loaded from relational database catalogs, data models from modeling tools, data flow mappings and transformations from ETL tools.
• Data modeling and database design for the Fidelity operational data store for Human Resources using Sybase PowerDesigner. Development process for data warehouses I followed: requirements analysis, reverse engineering schema of legacy databases, conceptual ODS foundation data model, user consumption logical data views, and data models for ETL (extract, transform, load).

Confidential, North Andover, MA

Oracle BI Developer

Responsibilities:

• Development of the business intelligence data warehouse services for reporting and analysis of bus transportation systems data and key performance indicators/measures used by business managers (using Oracle11g, Oracle BIEE, Oracle BI Publisher).

Confidential, Canton, MA

Data Architect, Consultant

Responsibilities:

• Modeling healthcare insurance policy data and design of a database for healthcare providers - facilitating user RAD sessions.
• Development of the data warehouse for integrating healthcare insurance policies for any Property & Casualty line of business.
• Defining access methods with business experts to improve the analysis of healthcare coverage products for cost and profitability.
• Data modeling, dimensional star schema modeling, database schema generation, control of master reference data (using ERWin).
• Implementation of the data warehouse, multi-dimensional cubes for BI analysis, ETL processes was done in SQL Server 2008.
• Adaptation of the previously developed universal insurance data model to accommodate healthcare insurance policies data.

Confidential, Worcester, MA

Data Architect, Consultant

Responsibilities:

• Business requirements analysis for Specialty Insurance policies, modeling sessions with the corporate data architecture group.
• Design and development of the relational database for integrating the Specialty Insurance policies and multiple other LOBs.
• Logical and physical data modeling in RAD user sessions, database schema generation for SQL Server 2005 using ERWin.
• Data profiling, loading master reference data, legacy data migration, data quality (done using SQL Server 2005 ETL tools).
• Application of the previously developed insurance universal data model for Specialty Insurance policies lines of business.

Confidential, Wakefield, MA

Data Modeler/Architect

Responsibilities:

• Developed a universal data model for insurance policies of any line of business (Property & Casualty lines, healthcare plans).
• Developed a universal data model for healthcare delivery based on an extensive research of HL7 data standards and data models used in US (US Veteran’s Administration, CDC) and European universal healthcare systems (UK, Canada, Australia).
• Data modeling and design of a data warehouse for insurance claims (for data mining, performance analysis, decision support).
• Data mapping for integration of insurance data warehouse using Informatica ETL tools and XML tools (XML Spy).

Confidential, Quincy, MA

Data Architect

Responsibilities:

• Data modeling and database design to computerize insurance policies and integrate well-structured data with poorly structured information contained in insurance policy forms and documents.
• Facilitation of modeling sessions with business subject matter experts for different coverage areas, claims payment, and billing.
• Application of the insurance data exchange standard ACORD (defined for the whole insurance industry in several XML schema) to automate data exchanges between insurance agents, insurance carriers and external application systems.

Confidential, Cambridge, MA

Business Analyst

Responsibilities:

• Requirements analysis and data modeling for a new Confidential Asset Supply Chain Management system specified and developed to replace several legacy systems for life cycle management of assets, project materiel, and inventories.
• Planned data migration and integration between Confidential legacy databases and new asset mgmt systems.
• Planned Confidential data architecture for integration of data across Confidential systems and organizations.
• Performed standardization of data elements and reference data using the Confidential metadata repository compliant with Confidential -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.
• Designed and developed in Designer 2000 an Oracle 8 database for automated scheduling of ships in Panama Canal - Enhanced Vessel Traffic Management System ( Confidential ). The Confidential system is used in the Panama Canal successfully since 1999 for advance scheduling of ships and real time traffic control.
• Programmed in SQL the Confidential database views and stored procedures for the Panama canal advance ship traffic scheduler (expert-system smart event time calculator for ship transits in Panama locks) and for the pilot scheduling application.
• Defined user requirements and designed database structures for a US Postal Service application Environmental Management Information System (using ERWIN for Power Builder and Oracle).

Confidential, Cambridge, MA

Task Leader, Systems Architect

Responsibilities:

• Developed a data model and designed a database to integrate program/project management information including federal agency budgets, strategic investment plans, projects, project schedules, tasks, products, resources, personnel, contracts, and facilities (developed in S-Designor and Oracle Designer 2000 for the relational Oracle database).

Environment: al Protection Agency: environmental data integration for US Superfund 1993 - 1994

Confidential

Responsibilities:

• Planned information systems architecture for Confidential 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).

Confidential

Responsibilities:

• Planning data integration of product engineering data and logistics support analysis record ( Confidential ) 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).

Confidential, Cambridge, MA

Senior Analyst, Development Methodology Expert, Project Manager

Responsibilities:

• Introduced an information systems development methodology Productivity+ at Confidential .
• 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

Confidential

Responsibilities:

• 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).