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