We provide IT Staff Augmentation Services!

Data Architect Resume Profile

Profile

  • Relational and dimensional database modeling and architecture for both OLTP and BI/DW
  • Data Governance and Master Data Management
  • Concentration on the benefits of temporal data to a business.
  • Leadership and guidance of technical architecture for decision support and business intelligence
  • Supervision of application and database developers
  • Software development practices and standards development
  • Software project life-cycle management
  • Functional and Technical Specifications development

Technologies and Skills

  • Microsoft SQL Server
  • Microsoft Analysis Services
  • Microsoft Reporting Services
  • Microsoft Integration Services
  • Temporal and Bi-temporal Relational Modeling
  • Dimensional Modeling
  • Object Oriented Design

Professional Experience

Confidential

Systems Corporation

Data Architect

  • Adama Systems provides information management consulting services and solutions development to businesses with a focus on the recognition, development and management of temporal data within a business.
  • With experience in data architecture for OLTP applications, business intelligence/data warehousing, data governance and master data management for a broad spectrum of industries, I offer unique insight to sound data management and data architecture practices for any business. Technical skills include the development and implementation of relational models in the SQL Server database engine, dimensional models in Analysis Services, ETL development with Integration Services, reporting with Microsoft SQL Server Reporting Services and LDMs/PDMs with a wide variety of modeling tools such as Erwin, ER Studio and Microsoft Visio. I have practiced both the Inmon 'Top-Down' approach to enterprise data architecture for decision support as well as the Kimbal 'Bottom-Up' approach. I have found the 'Top-Down' hybrid approach to be the most flexible across a wide variety of industries. This 'hub and spoke' architecture utilizes a normalized temporal relational ODS or MDM Repository . A hybrid of data marts, each modeled based on specific decision support requirements, can then be created using the ODS as a more reliable source than the original source systems. These data marts may be subscribers on a separate SQL Server using transactional replication as well as dimensionally modeled and implemented as cubes in Analysis Service.

Confidential

Applications Development Manager

  • Clarium provides Information technology management and services to its customers, including infrastructure development and management, process guidance, systems implementation, software applications and business intelligence development.
  • Develop technical architecture and processes for systems development and administration.
  • Provide guidance for network architecture.
  • Provide technical supervision and management of software developers and database administrators.
  • Participate in the development of class libraries in C , integration processes and asp.net applications.
  • Development of custom entities, attributes, relationships, views and entity forms within Dynamics CRM.
  • Management of teams responsible for implementing and administrating Microsoft SharePoint Foundation, Microsoft BizTalk for EDI, Microsoft Dynamics CRM 2011. Provide guidance on best practices regarding administration. Provide hands on administration when required.
  • Project management of software development life-cycle.
  • Supervise architecture, design and development of OLTP applications, data warehouses, business intelligence applications and reporting platforms.
  • Promote MDM Master Data Management strategies and practices to Clarium customers.
  • Supervise the architecture and development of MDM environments, including temporal and temporal relational data warehouses with dimensional data models being implemented in OLAP structures.
  • Development and implementation of Analysis Services cubes.
  • Development and implementation of relational MDM repositories on SQL Server.
  • Deliver architecture workshops for Clarium customers, technology managers and engineers on MDM strategies, temporal and temporal relational approaches for both OLTP and decision support/data warehousing/data mart databases and dimensional data implementation in OLAP structures using Analysis Services
  • Assist Clarium with the development of customer Requests for Proposal.
  • Provide technical analysis and recommendations of vendor software systems to Clarium customers.
  • Supervise design and development BI/Decision Support solutions with SQL Server, Analysis Services and Reporting Services.

Confidential

  • Provide technical supervision and management of applications and database developers.
  • Provide guidance on object oriented designs and participate in development of class libraries, integration processes and asp.net applications using C .
  • Develop technical application and database architecture, requirements and testing procedures for business intelligence products.
  • Develop physicals implementation scripts for both SQL Server and Analysis Services databases.
  • Development of stored procedures, indexed views, SSIS packages, dimensional and relational logical database design and their physical implementations.
  • Conduct frequent code reviews, assisting developers with development, ensuring best practices and standards are followed throughout.

Confidential

Insurint Systems - Systems Architect

  • Provide technical supervision and management of database administrators, applications and database developers.
  • Develop technical application and database architecture, network architecture, functional and technical systems requirements, testing procedures and systems management documentation for the Insurint Software suite of applications.
  • Provide guidance on object oriented designs and participate in development of class libraries, integration processes and asp.net applications using C .
  • Conduct frequent code reviews, assisting developers with development, ensuring best practices and standards are followed throughout.
  • Participate in the development of stored procedures, indexed views and SSIS packages.
  • Develop dimensional and relational logical database designs. Prepare physical implementations for both SQL Server and Analysis Services databases.

Hire Now