We provide IT Staff Augmentation Services!

Senior Data Warehouse Architect Resume

VirginiA

SUMMARY:

  • Senior Data Warehouse Architect with 20+ years of Information Technology experience.
  • 12+ years of exclusive experience in end - to-end Data Warehousing.
  • Well experienced in Dimensional Data Modeling, OLTP Data Modeling, ETL, Master Data Management (MDM), OLAP, MicroStrategy Architect, Requirements Gathering and Data Analysis.
  • Proven leadership, communication and client relationship skills with the ability to model, synthesize and present critical information to key decision makers.

TECHNICAL HIGHLIGHTS:

  • Bottoms-Up, Top-Down, Hybrid, ODS, EDW and OLAP Data Warehouse architectures
  • Multi-Dimensional (Star) and 3NF/OLTP data modeling using ER/Studio, Erwin, Oracle*Designer
  • Microsoft SQL Server and ORACLE database expertise, Master Data Management (MDM)
  • Architecture and cube modeling for SSAS (SQL Server Analytical Services / OLAP)
  • ETL architecture and development using Informatica 8.6.x, SSIS and PL/SQL
  • Business Intelligence Architecture and attribute modeling for MicroStrategy 9.x and Cognos 8.x
  • Requirements Gathering, Data Analysis, UNIX, Windows, Macintosh

PROFESSIONAL EXPERIENCE:

Confidential, Virginia

Senior Data Warehouse Architect

Responsibilities:

  • As the lead Data Warehouse Architect, designed and developed a new data warehouse replacing the legacy data warehouse to provide intelligent analytics based on Point of Sale (POS) data.
  • Architecture improvements provided the ability to handle 4 times additional data to support business growth along with significant advancements in functionalities, scalability and data availability. This also improved data loading and aggregation time by 60%.
  • Implemented new data model that provided ability to handle business product re-alignment changes
  • Performed MicroStrategy Architect role, designing and developing attribute relationship mapping for MicroStrategy components based on base data warehouse as well as OLAP cubes.
  • Managed projects and led a team of seven through design, development and implementation of DW.
  • Developed DW Architecture road maps, developed Data Models, led the requirements gathering efforts, designed ETL architecture, conducted code review, code migration & test plan review
  • Modeled and deployed SSAS OLAP with cube level partitioning to handle the huge volume data

Technical Environment: Embarcadero ER/Studio Data Architect 9.1, Micro-Strategy 9.3.x, SSIS, SSAS, SSMS, SQL Server Database 2008 R2, MDX, Oracle 10g, PL/SQL, Tortoise SVN Code Management.

Confidential, Virginia

Senior Data Warehouse Architect

Responsibilities:

  • Led the Data Warehouse/ETL architecture efforts
  • Created Data Models for Loan File Review, IR2, Complaint and Loan Sampling subject areas
  • Provided architectural guidelines and developed Data Warehouse Architecture road maps
  • Successfully led Data Warehouse Integration project to provide Dashboard capabilities for US Treasury
  • Significantly improved data quality in Complaint Data Mart by user controlled data standardization
  • Performed MicroStrategy project design and maintained attribute relationships
  • Conducted Requirements Analysis, Data Profiling and Data Cleansing

Technical Environment: Embarcadero ER/Studio, SQL Server Management Studio, SSIS, SQL Server Database, Clear Case, Micro-Strategy

Confidential, Illinois

Enterprise Data Warehouse Architect

Responsibilities:

  • As the lead Data Warehouse Architect, developed Data Warehouse architecture for enterprise-wide data warehousing needs
  • Developed Dimensional Data Models and authored System Design Documents
  • Managed Projects & led a team of eight through development and implementation phases for multiple projects, mentoring team members, performing ETL design reviews
  • Successfully performed Informatica ETL Architect role by designing ETL solutions with a thorough understanding of Data and Business needs for Becker Order Management Data Mart, Equifax and Lawson (Accounting) Data Warehouse projects
  • Significantly improved daily data availability for Enrollment Data Mart from 11:00 AM to 6:00AM by resolving ETL complexity (Performance Tuning) and re-architecting ETL Processes
  • Developed Informatica ETL mappings and performed system integration/workflow management with reliable error/exception handling.
  • Designed and developed Master Data Management (MDM) Solution for DeVry EDW.
  • Implemented many standards and processes in enterprise data warehouse including ETL Job Monitoring, Code Reviews, Change Control, Run time metadata capture etc.
  • Conducted product evaluation and price negotiations for E/R Studio and Informatica software

Technical Environment: Informatica PowerCenter 8.6.x, Embarcadero ER/Studio, Cognos 8.3.x, Oracle 10g, PL/SQL, TOAD, Oracle Warehouse Builder 10.x, Unix (SunOS)

Confidential, Virginia

Senior Data Warehouse Architect

Responsibilities:

  • Performed Data Warehouse Architecture for Commercial and Consumer Data Mart projects.
  • Developed Dimensional Data Models, consolidating data from various business segments of the bank, which providing Bank Wide Profitability & Credit Risk Analysis, and Cross Sell Opportunities for products including Loans, Mortgages, HELOC, Credit Cards and TSYS
  • Managed multiple projects and client relationship successfully.
  • Developed Master Data Management (MDM) Solution.
  • Led a team of seven through Design, ETL development and implementation phase.
  • Developed and deployed ETL processes using Informatica and Oracle PL/SQL.
  • Performed system integration of ETL mappings. Conducted Requirements Analysis and Data Profiling
  • Improved database performance by strategic implementations of Materialized Views, Bitmap Indexes and Partitions, which improved management reporting efficiency by 40 percent

Technical Environment: ERwin 3.5.2, Informatica, Oracle 10g/9i, PL/SQL, Webfocus, IIS, SQL*Plus, SQL*Loader, TOAD, SQL Developer, Enterprise Manager, Cognos, UNIX, Windows XP/NT/2000 Servers

Confidential

Data Warehouse Architect

Responsibilities:

  • For this second largest pharmaceutical company in U.S, conducted Requirements Analysis and Data Modeling to implement “In Process Management - Data Mart” project (Erwin/Oracle)
  • Developed graphical data warehouse load monitoring system (Java 1.3, AWT and JDBC)

Technical Environment: ERwin 3.5.2, Oracle 9i, PL/SQL, Java 1.3, JDBC, UNIX

Confidential

Data Warehouse Architect

Responsibilities:

  • For this Confidential 500 firm, developed Dimensional Data Model for Campaign Management
  • Performed Requirements Analysis, High-Level and Detailed System Design and documentation

Technical Environment: ERwin 3.5.2, Oracle 9i, PL/SQL, Enterprise Manager, UNIX, Windows NT

Confidential

Data Warehouse Architect

Responsibilities:

  • Designed and developed Data Warehouse/ETL architecture for Confidential Operational Data Store
  • Constructed PL/SQL Packages to aid ETL process (ODS, Oracle)

Technical Environment: ERwin 3.5.2, Oracle 8i, PL/SQL, Enterprise Manager, UNIX, Windows NT

Confidential, New York

Data Architect / Data Modeler

Responsibilities:

  • Created Process Flow Diagrams, Data Architecture and Data Models for Confidential ’ new Global Web site integrating Confidential Medical and Confidential Building Technology.
  • Installed and maintained Oracle (Win NT)

Technical Environment: Oracle*Designer, PL/SQL, Oracle 8i, SQL Anywhere 5.0, MS SQL Server, Oracle Enterprise Manager, SQL*Loader, JAVA, Windows 2000 Server, Windows NT, Sun Solaris

Confidential, Maryland

Programmer Analyst

Responsibilities:

  • Created Data Model for Cable & Wireless project “Consolidated Commission System”
  • Developed Oracle Forms, Reports and calculation modules (PL/SQL) for Sales Commissions

Technical Environment: Oracle*Designer, PL/SQL, Oracle 8, SQL Server, WinNT, UNIX

Confidential

Programmer Analyst

Responsibilities:

  • Performed Requirements Analysis, Systems Architecture and Data Modeling of Applicant Tracking System for Confidential using Oracle*Designer Webserver component
  • Conducted product analysis and functionality testing of Oracle*Designer (Designer/2000)

Technical Environment: Oracle*Designer, PL/SQL, Oracle7, Oracle Developer, WinNT, UNIX

Hire Now