DWH Architect Resume

SUMMARY:

11 Years of Experience in Software Development Life Cycle
7+ Years of Experience in Architecting, Designing & Development of Data Warehousing Applications
6+ Years of experience in Enterprise Data Modeling (OLTP, ODS & Data Marts). Preparing DFD’s, Conceptual, and Logical & Physical Data Models.
Data Warehouse Design Experience, following the Ralph Kimball & Bill Inmon Methodologies
1+ Year of experience in Master Data Management (MDM) in Architecting, Designing Canonicals, Integration and Synchronization Mechanism, Workflow Modeling, Handling Data Governance & Data Stewadship
Have had my experience on tools like, Erwin Tool & Visio (for Data Modeling), MS OLAP SQL Server (for Cubes Design), Micro strategy (For Analytical Reporting), Informatica (For ETL Design and Development)
Work Experience in Oracle, Teradata & SQL Server
Establishing Data Quality Procedures, Data Change Management Process & Establishing Enterprise Data Standards
Belongs to Data Architecture practice at Confidential, since more than 5 years
Mentoring a 5 member team in the Data Management Space, in different areas
Being into Architecture team and was mostly involved in Data Modeling and Designing Data Warehouses, I am good at Client interfacing, Good in understanding what business expects, and converting their expectations into a design.
Good in Understanding Functional & Technical Requirements and creating Data Models (OTP and Multi - Dimensional) from those requirements.
Interacting with ETL and reporting team to make them understand and use the model, by providing Mapping Documentations, Subject Area VS KPI Vs Formulae Mapping Documentations, Generating DataDictionaries, and various other documentations
Current Research Topics: Columnar Databases, Effective MDM Design and Development
Frequent Website Visitor for - Steve Hobberman Design Challenges (Name featured once), Information Management, Ralph Kimball Tips, Answers.com, Wikipedia.com, etc.

PROFESSIONAL EXPERIENCE:

Confidential

DWH Architect

Responsibilities:

Participation in Requirements Workshop
DWH Architecture (Solution Architecture, End-State Architecture)
Dimensional Data Modeling
Designing Hierarchies
Defining ETL Strategy
Defining Security Architecture

Confidential

Data Architect

Responsibilities:

Holistic View/Understanding the Application, and identifying the pain points
Canonical Data Model Definition
Defining Data Governance
Defining the Data Change Management Process
Defined the Data Store (RDS), maintaining single copy of Data
Defined the Data Standards & Guidelines at the enterprise level
Data Model Review & Recommendations
Data Warehouse Architecture

Confidential

Solution Architect

Responsibilities:

Understanding AS-IS Architecture for Retail Execution, DMS(Distributor Management System), IC&C (Information Command & Control)
Identify Current Capabilities & Future State Capabilities & translate the relevant capabilities into IT functionalities
Define the Future State Business Scenarios, and translate them into define Conceptual Architecture
Preparing Vendor Evaluation Matrix
Logical Architecture Definition for IC&C

Confidential

Data Architect / Data Modeler

Responsibilities:

Requirements Analysis with Client Business Team and End Users
Source Database Analysis
Designed & Built a Dimensional Data Model for Transportation Team
Architecting the Data Flow from the data sources till it is available in the data marts
Provided Handful Documentation to other stakeholders like
ETL team with ETL Mapping Documents
KPI Vs Formula Vs Data Element Vs Subject Area Mapping for OBIEE Team
Business Group Vs Subject Area Vs Table Mapping

Confidential

Data Architect / Data Modeler

Responsibility:

Data Warehouse Design
Integration of Store Interfaces
Building Enterprise Logical Data Model with Erwin Model Manager
Database Environment Standardization
Writing DDL’s & PL/SQL codes to process the Daily loads

Confidential

OLAP Analyst

Responsibilities:

Technical impact analysis of the Data model and the Micro Strategy reports
Developing the programmable coding complied with the design document and Confidential programming standards.
Unit test planning, documenting and executing according to Confidential standards.
Execute test plans and scripts
Documentation of results and area of concerns

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship