Description
Summary * Senior Data Modeler / Analyst with 8+ Years of IT professional experience in Data Modeling, designing, developing, and implementing data models for enterprise-level applications and systems. These models are architected at the following layers: conceptual, logical, business area, and application. * Experience in analysis, design, and development of enterprise data warehouse models for business intelligence / reporting. * Deep Understanding in development of Conceptual, Logical and Physical Models for Online Transaction Processing and Online Analytical Processing (OLTP&OLAP). * Experience in Data Warehouse modeling for large/complex business intelligence process including development of dimensional modeling. * Implemented metadata standards, data governance ( data cleaning, data profiling and data analysis) * Followed different concepts in data modeling like Kimball and Inmon methodologies in designing the data models * Strong background in developing high performance queries, view, procedures, Informatica ETL, etc. * Extensive experience in working with tools like Erwin, Oracle Designer, Power Designer and MS Visio for creating data models. * Extensive experience in reverse engineering databases, Complete compare using ERwin. * Experience with various methodologies for creation of data models for data warehouses and data marts. * Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies). * Worked closely with ETL teams such as Informatica to extract data from Source system to target systems and created mappings, Data Reports. * Extensive experience in working closely with End-Users, Business Users, Clients for gathering User and Business Requirements and authoring business processes with project teams. * Designed and developed Data models for Database (OLTP), the operational data store (ODS), Data warehouse (OLAP), and federated databases to support client enterprise Information Management Strategy. * Experienced in master data management (MDM), Metadata management, data quality. * Strong Knowledge in Data Transformation and Data Mapping from source to target database Schema's and also data cleansing. * Designed the PL/SQL procedures for getting the data from all systems to Data Warehousing system. * The data was standardized to store various Business Units in tables. * Expertise in creating Schema objects like Indexes, Views, and Sequences. * Designed Data flow Diagrams, and Activity Diagrams, to support the development team and business groups. * Extensive experience in Database Creation and maintenance of physical data models with Oracle and SQL Server data bases. * Extensive experience in Performance tuning databases for optimum performance. * Coordinated and prioritized outstanding defects and system requests based on business requirements. * Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrators. * Capable of managing project while leading cross-functional teams to meet and exceed overall IT initiatives. * Self-motivated diligent, ability to adapt to new environments and situations quickly, good grasping ability, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.
Accomplishments
Highlights:
Keywords
