Data Architect/Modeler ( Corporate VP) Resume

SUMMARY:

Information Systems Data Architect/Designer with MS in Management Information Systems and deep experience focused on Data Architecture, Data Modeling, Data Warehousing, Data Administration, Data Stewardship, Business Intelligence, Business Analysis and Process Specification including ETL.
Specialized in Requirements Gathering coupled with Business and Data Analysis resulting in Conceptual, Logical and Physical database solutions for OLTP and/or OLAP (Star Schema) based systems. Expertise in Information Engineering and Object Oriented principles and techniques. Good knowledge of Project Management. Excellent written and oral communication skills.

TECHNICAL SKILLS:

DATABASES: ORACLE, DB2, SYBASE, SQL - SERVER

OLAP/ROLAP TOOLS: BRIO, COGNOS, ESSBASE

DATA MODELING / CASE TOOLS: ERwin, ER Studio, HPS(Seer Technology), LBMS(Systems Engineer), IE Advantage, SYNON, Silverrun, POSE, DEFT

PC Software: Microsoft: WORD, EXCEL, PROJECT, POWERPOINT, INTERNET EXPLORER, SQL-NET, SQL NAVIGATORData Profiling:Informatica, SQL

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect/Modeler ( Corporate VP)

Responsibilities:

Member of the Business Translation Team responsible for:
Compiling Business Glossaries whose terms are utilized in the firm's Regulatory, Operational Risk Control and Data Management processes
Updating the Business Object Model with new Business Terms
Translating Business Requirements from Business to Technical staff
Documenting in-flight Projects
Providing guidance in areas including:
Data Modeling Techniques, Standards & Conventions
Data Model Documentation Standards
Planning the design of a new Glossary Management System to automate glossary building activities

Confidential

Data Architect

Responsibilities:

Provided Database Schemas (ERwin) for new projects targeting DB2 and SQL SERVER including:
Universal Tax Search
Data Mart Restructure
Tax Delinquency
Provided documentation of existing application databases
Provided guidance in a number of areas including:
Data Integrity,
Data Stewardship,
Data Naming Conventions,
Database Documentation and
Process Specification

Confidential

Data Warehouse Architect

Responsibilities:

Initial Activities
Established Data Warehouse Architecture
Interviewed Subject Matter Experts
Design/Implementation Activities
Created Erwin models
Validated models with SME's
Created ETL mappings
Specified ETL processes for SSIS developers
Performed Data Profiling (SQL)
Mentored individuals lacking experience with this type of effort.

Confidential

Data Architect

Responsibilities:

Data Modeling / Data Analysis
Genesis - A project aimed at integrating Fixed Income data originating in Japan into the existing Data Warehouse architecture.
Regulatory Reporting - A project aimed at upgrading to the new data format of Sofgen RegReporter software while also providing users the opportunity to override data values which are incorrect or unreliable at their source.

Confidential

ETL Architect / Data Analyst - (Consultant)

Responsibilities:

Data Modeler / Data Analyst (Data Conversion/Integration Team)
Pyramid - A project aimed at integrating/converting multiple legacy data sources into a single new database system expected to replace current legacy systems.

Confidential

Data Warehouse Architect / Technical Manager - (Consultant)

Responsibilities:

Data Architect / Project Management / Requirement Analysis / Data Analysis & ETL Specification
Data Warehouse Project - Aimed at integrating multiple data sources into a single analytical and reporting platform aimed at providing a “single version of the truth” across the organization.

Confidential

Data Architect / Technical Manager - (Consultant)

Responsibilities:

Data Architect / ETL Specialist / Project Manager / Mentor
Business Intelligence Project - Aimed at integrating multiple data sources into an analytical platform whose objectives are both to provide an historical view of business activity (Dimensional Data Warehouse) as well as a view of current and projected future business activities (ODS/Data Integration Hub).

Confidential

Data Architect - (Consultant)

Responsibilities:

Requirements Analyst / Data Architect
Arrow Global - Aimed at integrating multiple data sources into a single analytical platform to automate the work of financial analysts and provide robust results in a shorter timeframe than previously possible.

Confidential

Data Architect - (Consultant)

Responsibilities:

Data Modeling (DB2 and Sybase)
Provide input to establish future direction of the Architecture Organization

Confidential

Data Architect/BI Specialist - (Consultant)

Responsibilities:

Data Architect
Member of team responsible for establishing Enterprise Data Warehouse (TED):
Project Manager
Bureau Reporting

Confidential

Data Modeling V.P

Responsibilities:

Requirements Analysis / Data Architecture / Project Management / Senior Consultant and Advisor
Citi-Direct - a global online banking system providing “on-line banking” for businesses

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship