We provide IT Staff Augmentation Services!

Data Modeler Resume

3.00/5 (Submit Your Rating)

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'd love your feedback!