We provide IT Staff Augmentation Services!

Senior Data Architect Resume

SUMMARY

  • I have significant experience (25+) in developing data architectures. This includes both OLTP schemas and warehouse schemas suitable for deployment utilizing technologies like CloudBase, NOSQL, etc. I know that the best architecture means the best code.
  • My experience as a developer has made this clear. My expertise includes being able to distinguish the differences between processing data and utilizing data.
  • I have demonstrated an understanding that the term cloud computing means networks, hardware, storage, and services provided in a more standardized way. Furthermore I understand that architectures exist independent of deployment and this is the advantage they hold.
  • The ultimate deployment of the architectures I have developed always reflects conformance to the unique needs of the enterprise. I have a rare ability to produce the architecture but also aid in the development of the administration needed to support and evolve the architecture over time.
  • My current duties include the development of a standardized API to expose the underlying CRUD database procedures. I have extensive experience in both deploying and configuring all aspects of DBMS servers (Oracle, DB2, SQL Server) to include developing tablespace architectures that properly leverage the physical database design.

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Architect

Responsibilities:

  • Provided enterprise architecture data modeling support
  • Implemented physical database architecture
  • Provided MDM architecture design support
  • Provided data analysis services in support of several cloud architecture initiatives, This included converging element universes via myriad data correlating activities
  • Designed and implemented ETL in support of an enterprise MDM hub
  • Provided DBMS performance tuning services
  • Developed nd implemented a warehouse / decision support reporting architecture

Confidential

Senior Data Architect

Responsibilities:

  • Architected both the OLTP and warehouse layers of the information architecture
  • Worked with Oracle SA to configure OHS to utilize CASPORT
  • Developed SOAP envelopes and processes to utilize CASPORT services
  • Managed project from vision to implementation
  • Designed the conceptual architecture
  • Designed and implemented the physical architecture
  • Gathered business rules
  • Translated business rules into user requirements
  • Translated user requirements into system requirements
  • Developed the application interface using Oracle APEX
  • Developed the business layer using PL SQL and JAVA,
  • Created design artifacts using ERWin

Confidential

Senior Data Architect

Responsibilities:

  • Data Warehouse Architecture Development (Oracle) /Data Model Development Utilizing Popkin System Architect
  • Physical Model Implementation …
  • Business Translation Into Logical and Physical Data Models
  • Data Conversion Tasks Utilizing Informatica
  • Overall Data Management Strategy Development and Implementation
  • OLTP Schema Development
  • Heterogeneous ETL Strategy Development
  • Comprehensive Data Analysis
  • Business Rule Development

Confidential

Senior Data Architect

Responsibilities:

  • Reviewed the database design and provided improvement recommendations.
  • Incorporated some improvement recommendations and helped the other data architecture team member (Oracle background) physically implemented the design.
  • Performed schema modification utilizing the ErWin compare facility. ErWin was used to tightly manage the database configuration.
  • Database Management duties included providing support for the development staff after hours and on weekends. Scripts for Constraint Enable/Disable and Identity Column Insert Enable/Disable were developed. A cache of initial data was maintained for initial deployment and this data was subsequently loaded by a script. Participated in devising DTS and single stored procedures to produce a repeatable build process for final deployment.
  • Modified both server and database configurations for DBMS optimization.
  • Developed stored procedures and instructed the COM+ developers in the construction of the same. Devised and implemented stored procedure development guidelines.
  • Worked with team members at all levels to insure that pertinent database considerations were addressed.
  • Capacity Planning for the final deployment environment was devised to include the development of a comprehensive filegroup strategy that utilized SQL Servers abstraction layer to highly leverage parallel processing opportunities as well as disaster recovery considerations.
  • Benchmarked database performance utilizing testing tool that simulated multiple concurrent web users.

Confidential

Senior Consultant

Responsibilities:

  • Performed all data design and analysis work listed below utilized the ErWin modeling tool.
  • Led JAD Team Design session for the administration of negotiated union employee member benefits system.
  • Created the logical design for this system and provided a cross - reference document outlining the system’s interaction with the database.
  • Reviewed legacy database design and devised revisions to support the FDIC prototype usage of IBM’s Websphere facility (Websphere was to be utilized to make access to FDIC’s mainframe data more N-Tier compatible. Basically the mainframes would look and be accessible like any other server. ).
  • Devised a multi-user MS Access application that warehoused information form files, MVS DB2 Database, and SQL Server databases to evaluate the feasibility of upcoming IT projects.
  • Assessed the resource impact of all upcoming FDIC IT projects (130 +)
  • Revised the FDIC data administration guideline document.
  • Revised the FDIC data analyst and database administration interaction guidelines documentation.

Hire Now