Enterprise Data Architect Resume

SUMMARY

Over 23 years of IT experience in Enterprise Data Architecture, Data Integration and Data Modeling.
Designed and implemented several large data warehouse projects utilizing a variety of methodologies and technology design approaches providing a full range of enterprise services and solutions for both relational and multi - dimensional platforms.
In-depth knowledge and expertise for Information Management in areas of Enterprise Architecture Planning, Data Governance, Master Data Management and Data Warehousing.
Designed several large terabyte projects for various industries i.e., Financial Services, Retail, Manufacturing, Energy Services Oil & Gas, Pharmaceuticals, CPG, Telecommunications, Education Sector, Aerospace and DOD.
Vast experience of working with Industries such as Pharmaceuticals, Telecommunication, Financial Services, Oil and Gas, Personal Care, Defense and Space etc.

TECHNICAL SKILLS

Data Warehousing: EDW relational/dimensional modeling, star schema/cube design, MDM hub design, ETL and BI design.

DBMS: Oracle, Netezza, Teradata, DB2/UDB, SQL Server 2008, Sybase, MS Access & IMS.

Data Modeling: Relational, Dimensional, Data Vault Modeling, MDM Hub, ODS, Structured/Unstructured and OLTP.

Operating Systems: Linux, UNIX - Sun Solaris, Dec Alpha, HP-UX, NT, OS2, MVS.

Life Cycle Expertise: Requirements analysis, BPR, design, coding, testing, database tuning and DB Admin.

Methodologies: Inmon, Kimball, Zachman Framework, TOGAF-V9, IDEF, IE, and Six-Sigma.

Management: Lead Enterprise Data Architect/Data Modeler, MIS Dept. Manager, DBA and Project Lead.

Languages: SQL*, VB, Assembler, COBOL, FORTRAN and CICS.

Other Products/Tools: Erwin 9, Power Designer, ER/Studio, Informatica, Data Stage, MS Project, Business Objects.

PROFESSIONAL EXPERIENCE

Confidential

Enterprise Data Architect

Responsibilities:

Responsible for participating in detailed requirements interviews with PM&R business executives, IT technical staff and end users.
Defining and documenting 16 data subject areas across the business, designed conceptual data models for 8 in-scope subject areas and developed 13 logical dimensional star schema models in support of the clients core metrics.

Confidential

Enterprise Data Architect

Responsibilities:

Performed comprehensive reviews of Capital Management Integration and Securities Asset Management projects.
Assisted Enterprise Standards Team in defining an Enterprise Data Architecture framework and data standards.
Reviewed enterprise architecture approach, hardware/software environment, object oriented and relational data modeling design patterns.
Handled Environment: Oracle, GemFire (in-memory database), ER/Studio, IBM Rational Software Architecture 9.0