Data Architect Resume Columbus, GA - Hire IT People

SUMMARY

Over Fifteen years of progressive Information Technology experience in development and implementation of architecture, standards, frameworks, models, and strategies for software, system/IT applications architecture, Data Architecture/Data Modeling and Enterprise Architecture, SAP/Business Objects suite of products - SAP HANA-1.0 SP03, BODS, BOBJ Universe Design & Reports and Hyperion Essbase
Developed Metadata Architecture, ETL Architecture, and Data Governance /data Stewardship framework/policies.
Experienced in Project Management activities like leading, coordinating, directing and implementing the OLTP, ODS, data warehouse, and Business Intelligence projects/applications.
Experienced in Business analysis, GAP Analysis, conducting requirement analysis (JAD), dimensional and relational data modeling, conceptual (Entity Relationship Diagrams), logical and physical modeling, normalizing, Star and Snowflake schema design, data base design and providing DBA support
Defined/developed data modeling standards, methodology, modeling procedures and best practices standards for the enterprise.
Experienced in developing and implementing Crystal reports/WebI on SAP/Business Objects Enterprise XI, XI REL2,3.1/4.0, Crystal Enterprise 8.0 thru 10, Business Objects Universe Design, Crystal Reports Explorer, designing Universe(s) from scratch, migrating to different environments, designing WebI documents and maintaining them on Business Objects XI R2 SP3
Experienced in SQL/PL-SQL, databases, and programming languages.
Experienced in all phases of software development life cycle (SDLC) including requirements gathering, Analysis, Design, data conversion, system implementation, Performance tuning, Testing and Support.

TECHNICAL SKILLS

ENVIRONMENT: Appliance SAP HANA 1.0 SP 03Case Tool ER/Studio 9.7.0, Erwin 9.x

Database: Teradata V13.0, Oracle 7.X/8.X/8i/9, SQL Server, DB2, Sybase, MS Access.

ETL: Informatica 6.0/5.1/4.7, SAP BODI/BODS 4.0

Reporting Tools: SAP Business Objects, Hyperian Essbase and MS Tableau

Web Server: IIS 4.0, Web logic server.

Language: JAVA/C

O/S: Windows NT/2000, Sun Solaris 2.8, HP-Unix 11.0, IBM DB2.

Hardware: Sun sparc, Enterprise 250,HP-D9000Other TOAD, MS Word, Power Point, Excel, MS Project.

PROFESSIONAL EXPERIENCE

Data Architect

Confidential

Responsibilities:

Analyzed the data / business requirements, source systems / existing data.
Conducted the JAD sessions.
Developed Conceptual Model and walked it thorough with the Business.
Developed LDM with all entities and attributes, relationships.
Integrated the new LDM entities with the Existing enterprise LDM.
Developed Physical model, generated ddl and deployed in development /test environment.
Developed source to target mapping document all the newly developed/integrated entities/attributes.

Data Warehouse Architect

Confidential, Columbus, GA

Responsibilities:

Conducted the JAD sessions and collected / verified the business/data requirements
Prepared the Dimensional Model metrics (Conformed Dimension/Confirmed Fact)
Developed STAR schema/snow flake (conceptual, Logical and Physical data models) for the Data Mart
Developed a Fact less- Fact table.
Prepared the ETL mapping doc, BO mapping docs for the developers
Lead the development Team, Project Management, conducted status meetings, oversaw the data loading, report development

Data Architect / Lead Data Modeler

Confidential, San Jose CA

Responsibilities:

Developed Conceptual, logical, physical data models, 3NF, start schema and snow flake schema data models
Developed data architecture/data modeling documents like Source data requirement doc, Business view requirement doc, data modeling abbreviations list, data modeling standards doc, etc.
Conducted JAD sessions with SMEs, project managers, DBA, IT experts and collected the business/ data requirements and developed data models
Identified, created Entity, Attributes, relationships from the business requirements, Identified conformed dimensions, and facts and created Bus Architecture
Created Star schema and snow flake schema for data marts. Used type 1, and type 2 for slowly changing dimensions
Developed one enterprise data warehouse (continuously updating) and at least 8 data marts for various reporting requirements
Developed Teradata specific modeling technique like semantic view and business views for data mart applications
Developed ETL mapping documents, metadata model for EDW, Data Governance framework.

We provide IT Staff Augmentation Services!

Data Architect Resume

Columbus, GA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship