Data Modeler Resume Essex, MD - Hire IT People

SUMMARY

Strong background in Data Modeling, Data Integration, Database Development, Administration and ETL. Over 14 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.
Strong technical knowledge of Data Warehousing, Data Validations, Data Migration, Data Extraction, Data Cleansing, Data Profiling, Data Standardization and Data Quality
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.

PROFESSIONAL EXPERIENCE

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, MS SQL

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, Knowledge on data-intensive applications on cloud-based architectures and infrastructures such as AWS, Big data such as Teradata, Hadoop, Cassandra etc.

PROFESSIONAL EXPERIENCE

Confidential, Essex, MD

Data Modeler

Lead Data Modeler role. 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.
Performed data manipulation, data cleansing and data profiling in the source systems that are required for Dual credit report Data mart. 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 LDM 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

Data Modeler

Lead Data Architect for Chevrons Upstream Appalachian Michigan Business Unit (AMBU). 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.
Develop various data quality functions including data profiling, data cleansing and standardization and data harmonization
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 AMBU 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

Data Modeler

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!

Data Modeler Resume

Essex, MD

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship