Data Modeler Resume

SUMMARY:

Strong background in Data Modeling, Data Integration, Database Development, Administration and ETL. Over 9 years of IT experience.
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.
Expert in both OLAP and OLTP systems data modeling. 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: Financial Services, Energy, and State Government.
Develops strong relationships with the business; excellent documentation and requirement gathering skills; enjoyable to work with while still being effective and efficient.

SPECIALTIES:

SSIS, SQL, T-SQL, PL/SQL, SQL Server 05, Oracle 9i, Oracle 10g, Data Integration, SSAS, MDS (SQL Server Master Data Services), Master Data Management.

TECHNICAL SKILLS:

Data Warehousing: EDW normalized/dimensional modeling, star schema/cube design, Data Vault, BI and ETL design

DBMS: Oracle, Teradata, DB2/UDB, Sybase, SQL Server, MS Access

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

Methodologies: Inmon, Kimball, MDM, IDEF, IE, Zachman and Six-Sigma

Languages: SQL*, VB, COBOL,C++

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

PROFESSIONAL EXPERIENCE:

Confidential

Data Modeler

Hardware/Software: DB2, Erwin9.5, JIRA

Responsibilities:

Worked on departments Enterprise Regulatory Data Modeling Practices for federal reporting.
Established a granular reporting procedure in which department reported aggregated summary of the dollar amounts details to the authorities.
Overcame the flaws of redundant and parallel processing steps for the same reporting data.
Removed inconsistencies in the reporting.
Created and reviewed Conceptual, Logical and Physical Data Models for OLTP database, an integrated eligibility management system consisting of over 1000 entities across 17 data subject areas.
Helped Department of Social Services to create the best quality data models that meet all business requirements, database change requests, industry standard.
Conducted sessions with business track leads to revise Confidential based on gap analysis.
Ensure synchronization among business requirements, data models and the database.
Created and reviewed data mappings for right implementation of departments interfaces with other state and federal agencies.

Confidential, Pittsburg, PA

Role Data Modeler

Hardware/Software: SQL Server, Erwin9.2

Responsibilities:

Champion an enterprise architecture planning effort to outline the client’s future state business model for data, applications and technology in both the OLTP and OLAP systems. The plan included a 3-5 year enterprise road map.
Defined an MDM solution for well master data.
Designed the Data Warehouse and MDM hub conceptual, logical and physical data models in support of the Confidential Data Foundation Strategy.
The MDM hub supports the client’s goal to improve Well exploration, development, production and field management and comply with regulatory environment, health and safety policies.
Coached a team of project managers, data architects and business analysis using data architecture leading practices.

Confidential, Wilmington, DE

Role Data Modeler

Hardware/Software: Oracle 10g, SQL Server, Erwin, Toad, Hyperion System 9 and Brio IR

Responsibilities:

Translated analytic business requirements into dimensional designs.
Developed data standards, data mappings, load strategies and history tracking solution.
Developed functional data models to enhance the reconcilability of financial and risk data by means of an integrated data model and to increase data consistency in regulatory reporting.
Evaluated the business needs of the Marketing and translating those into IT System business requirements.
Facilitated business acceptance of completed transition solutions working on multiple projects, managed stakeholder expectations and delivered work requests within the stated or expected deadlines.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship