We provide IT Staff Augmentation Services!

Senior Data Warehouse Architect Resume

Virginia, UsA


  • 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
  • Successfully architected/re-architected and implemented more than 10 Data Warehouses / Data Marts.
  • Re-architected Data Warehouse that reduced ETL time and improved report performance significantly.
  • Improved DW daily data availability from 11AM to 6AM by re-architecting ETL Processes.
  • Fixed MicroStrategy Report performance issues by remodeling the attribute relationships.
  • Efficiently handled client relationship which resulted in winning additional projects from same clien
Professional Experience
Confidential, Virginia, USA
Senior Data Warehouse Architect
  • 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, USA
Senior Data Warehouse Architect
  • Led the Data Warehouse/ETL architecture efforts for US Treasury MHA-C / HAMP project
  • 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, USA
Enterprise Data Warehouse Architect
  • 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)

Role: Senior Data Warehouse Architect / Project Manager
  • 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
Role: Data Warehouse Architect
  • 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

Role: Data Warehouse Architect
  • For this Fortune 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
Role: Data Warehouse Architect
  • Designed and developed Data Warehouse/ETL architecture for ADT 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

Role: Data Architect / Data Modeler
  • Created Process Flow Diagrams, Data Architecture and Data Models for Siemens’ new Global Web site integrating Siemens Medical and Siemens 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

Role: Programmer Analyst
  • 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

Role: Programmer Analyst
  • Performed Requirements Analysis, Systems Architecture and Data Modeling of Applicant Tracking System for ORACLE Corporation 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
Role: Programmer Analyst
  • For AT&T USA, migrated data from mainframe to Oracle, developed Data Models and Oracle Forms & Reports to automate the publishing of Telephone directories
  • Technical Environment: Oracle*Designer, Oracle Forms, PL/SQL, Oracle 7, MS SQL Server

Role: Programmer Analyst
  • Performed Requirements Analysis, development and implementation of Online Stock Trading System and financial accounting system using PowerBuilder, PL/SQL and Oracle
  • Technical Environment: Oracle 7, PL/SQL 2.1, PowerBuilder 4.0, Windows 3.1, UNIX

Role: Programmer Analyst
  • Developed Magazine Distribution Management System and Account Information System
  • Technical Environment: PL/SQL, Oracle, PowerBuilder 3.0, MS-Window

Hire Now