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.