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.
Experience in Relational Databases, Data Warehousing implementation and cloud-based data warehousing databases like Redshift and Snowflake. Databases, Business analysis, Microsoft SQL server, Business intelligence, Data warehouse, Oracle, Dimensional and physical data modeling, Expert in both OLAP and OLTP systems data modeling.
Thorough understanding and expert knowledge on various Data modelling techniques like ODS, EDW, Dimensional, Real time and Micro services Modelling. In-depth knowledge and expertise for Information Management in areas of Enterprise Architecture Planning, Data Governance, Master Data Management, and Data Warehousing.
Expertise in building dimensional, reporting structures, source to target mapping, data transformation, and rationalization.
Experience managing a data model repository. Designed several large terabyte projects for various industries: Financial Services, Energy, and State Government.
Coordinating across teams that leveraged multiple development methodologies, Waterfall, Agile, Scrum & Kanban. Developed strong relationships with the business; excellent documentation and requirement gathering skills, enjoyable to work with while still being effective and efficient.

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

Responsibilities:

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.
Developed and maintained domain logical data model artifacts, logical data models, data element dictionaries and physical data models. Data Vault 2.0. Data vault modeling and implementation.
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

Responsibilities:

Develop various data quality functions including data profiling, data cleansing and standardization and data harmonization.
Technical architecture analysis, understanding data flow diagrams, system architecture diagrams, and an understanding of functional and system analysis.
Conducted and lead discussions with business leads and SMEs to understand and document the scope and business requirements, and translate these into the Logical, physical model design.
Converting the Business/User requirements into logical models and Conducting data analysis and translating them to logical models.
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.
Helped resolve cross module integration issues. Coached a team of project managers, data architects and business analysis using data architecture leading practices.

We provide IT Staff Augmentation Services!

Data Modeler Resume

Essex, MD

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship