Data Modeler Resume
Summary : Around 7 years of extensive experience in Data Modeling, Data Analysis for Online Transaction Processing (OLTP), Data Warehousing (OLAP)/Business Intelligence (BI) applications. Expert in Transactional/Dimensional Data Modeling. Experience in various Insurance, Health Care, Financial, and Banking sectors domains.
Skills : SQL, PL/SQL, Transact SQL, C, Java, C# HTML, XML, XSL.
Description :
- Gathered, Analyzed and Participated in JAD sessions with business users to understand and document the business requirements from technical perspective.
- Wrote functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.
- Implemented the standard naming conventions for the entities and attributes of logical and physical model.
- Reviewed the logical model with Business users, ETL Team, DBA's and testing team to provide information about the data model and business requirements.
- Designed conceptual and logical data models of databases and tables.
- Identified entities and relationships and how those all fit together in logical model, these are then translated into physical model using ERWIN tool.
- Created databases for OLAP Metadata catalog tables using forward engineering of models in Erwin.
Experience
7-10 Years
Level
Management
Education
Master Of Science
Data Modeler III Resume
Headline : Experienced in Relational and Dimensional Data modeling for creating Logical and Physical Designs of Databases and ER Diagrams using various data modeling tools like ERWIN, Toad Data Point. Data Modeler with strong Conceptual and Logical Data Modeling skills has involved in JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications and queries.
Skills : Leadership, Entrepreneurship, Excel, Research, Data Analysis, R, Matlab, Google Analytics, Gephi, Tableau, Windows, Linux, Mac, C, SQL, Python, Ruby.
Description :
- Involved in gathering user requirements along with business analysts.
- Transformed project data requirements into project data models using Erwin.
- Designed the data marts in dimensional data modeling using star and snowflake schemas.
- Involved in logical and physical designs and transforms logical models into physical implementations.
- Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
- Participated in the requirements gathering process to create solid business and technical requirements focused on data and data transport use cases.
- Designed of data transformation processes and tools that normalize, cleanse, augment, and attribute incoming and outgoing data from multiple sources.
Experience
5-7 Years
Level
Executive
Education
Bachelors Of Technology
Data Modeler II Resume
Headline : Seven years of extensive Information Technology experience in all phases of Software development life cycle including System Analysis, Design, Data Modeling, Data Mapping, Implementation, and Support of various applications in OLTP, Data Warehousing, and OLAP. Experienced in Designing Data warehouse using Data Vault Methodology to provide long-term historical storage of data coming in from multiple systems.
Skills : Software development, data fusion and association.
Description :
- Worked with star schema and OLAP modeling.
- Experienced in Designing Database with prominent activities like maintaining sequences, index, primary key, foreign key, manipulating columns and tables.
- Responsible for evaluating various RDBMS like OLTP modeling, documentation, and metadata reporting tools including Erwin, Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
- Updated data model as per the requirement and generate DDL and deploy it using SQL developer.
- Responsible for Dimensional Data Modeling and Modeling Diagrams using ERWIN.
- Worked with reversed engineer Data Model from Database instance.
Experience
5-7 Years
Level
Executive
Education
Bachelor's
Data Modeler I Resume
Objective : Over 7+ years of professional experience working as a Data Analyst. Experience in Data Analysis, Data Validation, Data Modeling, Data Flows, Data Profiling, Data Quality, Data Integration, Data Verification, and Data loading. Expertise in Analytical and Problem Solving Skills. Expertise in a new web-based collaborative tools such as web sphere and web 2.
Skills : SAS, SAS/ETS, SAS EG, Enterprise Miner, MS EXCEL, PowerPoint, SQL.
Description :
- Participated in all phases including Analysis, Design, Coding, Testing and Documentation.
- Gathered Requirements and performed Business Analysis.
- Extensively used SQL for Data Analysis.
- Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) as per business requirements.
- Created Schema objects like Indexes, Views, and Sequences Conducted team meetings and proposed ETL strategy.
- Worked on Gap Analysis.
- Selected to work on a team with 4 other consultants, reporting to a Project Manager.
Experience
2-5 Years
Level
Executive
Education
M.S. In Resource Engineering
Sr. Data Modeler Resume
Headline : Over 7+ years of Experience in Data Analysis and developing Conceptual, logical models and physical database design for Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP) systems. Experience working with data modeling tools like Erwin, Power Designer, and ER Studio. Experience in designing star schema, Snowflake schema for Data Warehouse, ODS architecture.
Skills : Predictive Analytics, Predictive Analytics, R, Excel.
Description :
- Designed Physical data model from scratch based on Business requirement and review with LOB.
- Worked as a BI liaison between business users/sponsor and technical IT resources.
- Created data mapping Responsible for evaluating various RDBMS like OLTP modeling, documentation, and metadata reporting tools including Erwin, and Power Designer Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
- Normalized the database to put them into the 3NF of the data warehouse.
- Provided technical support during delivery of MDM (Master Data Management) components.
- Created and changed Data Models using PowerDesigners Update system design documentation including high level design, low level design, source to target .
- Responsible for Asset Management of Computer Hardware and Asset Fixed Products and SAP CRM- POS Management.
Experience
5-7 Years
Level
Executive
Education
Bachelors In Computer Science
Data Modeler/Manager Resume
Objective : Eight plus Years of prevalent IT experience Exceptionally in Data Modeling working as a Data Modeler / Data Analyst in Analysis, Design, Data Modeling Conceptual, Logical and Physical) for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP). Skilled in gathering business requirements, use cases, and requirements analysis.
Skills : Enterprise Architecture, Data Modeling, Project Management, Oracle Database Administration, Java Programming, ASP.Net Programming.
Description :
- Provided insurance coverage in four specialty areas: property and casualty; life, accident and health; international; credit and surety; and related agency and reinsurancebrokerage services to commercial customers and individuals.
- Identified the key facts and dimensions necessary to support the business requirements.
- Developed the logical and dimensional models.
- Developed entity and attribute descriptions and definitions for the models and ensure that conflicts in descriptions and definitions are resolved.
- Conducted team meetings and JAD sessions.
- Performed source data quality assessments.
- Identified the appropriate data sources with the assistance of the business analyst.
Experience
2-5 Years
Level
Executive
Education
Bachelor In Computer Science
Data Modeler/Architect Resume
Objective : Built financial database to test predictive models to improve accuracy, Developed financial engineering models which increased prediction accuracy by as much as 30%.
Skills : Teradata, Hadoop, Datawarehousing.
Description :
- Identified common entities & attributes across disparate enterprise source systems, which consisted of two relational .
- Created common data dictionary for target model Created high level source to target mappings from each source system to common target logical model .
- Automated Client Reporting using VBA programming Used Sumifs, Countifs, vlookup, and pivot tables Reported on weekly events and changes to the .
- Converted Crystal Reports based reporting into MicroStrategy Reports that involves over 70+ reports.
- Created a new architecture using Oracle views and ensure all the output will match the existing production reports.
- Evaluated the suitability option to create full reporting schema based all the available Oracle views.
- Created ODBC connections and customize data-warehouse default read settings Add required views from the data-warehouse catalog Create sample reports.
Experience
2-5 Years
Level
Executive
Education
Bachelors In Computer Science
Data Modeler/Engineer Resume
Summary : Consistently featured on the r-bloggers top ten of the week. Worked on two data modeling projects, including predicting the price of bitcoin, and forming customer clusters based on various parameters. Technology savvy - actively following latest technology trends in the Internet of Things (IoT), Big Data, and Artificial Intelligence.
Skills : Microsoft Visio, SQL Server 2008 & 2012, Visual Studio, SSIS, SSAS, SSRS.
Description :
- Consolidated data environment for Auto Finance will provide improved stability and data consistency.
- Provides improved operational efficiency by removing redundancies in data management activities.
- Identified different SOR's and the related entities and attributes.
- Worked closely with business users, dealers and third party vendors to understand the process and the requirements.
- Created different subject areas and created different entities as per the business needs Identified suitable classification words for the data coming from different sources.
- Identified the attributes to maintain in Semantic layer and provided instructions to Semantic team on how to populate data into those attributes.
- Participated in DRB review meetings and updated model as per their review comments Analyzed source system copybooks and identified necessary attributes and their data types.
Experience
7-10 Years
Level
Senior
Education
Master's In Computer Science
Data Modeler Resume
Headline : Responsible for Participating in DRB review meetings and updated model as per their review comments Analyzed source system copybooks and identified necessary attributes and their data types.
Skills : Microsoft Visio, SQL Server 2008 & 2012, Visual Studio, SSIS, SSAS, SSRS.
Description :
- Chase Auto Finance - BI strategy is part of a multi-year initiative to provide a cross-LOB reporting and analytics data warehouse.
- Provided the required data model to receive and aggregate data from identified source systems.
- Consolidated data environment for Auto Finance will provide improved stability and data consistency.
- Provides improved operational efficiency by removing redundancies in data management activities.
- Identified different SOR's and the related entities and attributes.
- Worked closely with business users, dealers and third party vendors to understand the process and the requirements.
- Created different subject areas and created different entities as per the business needs Identified suitable classification words for the data coming from different sources.
- Identified the attributes to maintain in Semantic layer and provided instructions to Semantic team on how to populate data into those attributes.
Experience
5-7 Years
Level
Executive
Education
Master's In Computer Science
Data Modeler Resume
Objective : Over 8 years of professional experience in data modeling and data analysis as a Proficient in gathering business requirements and handling requirements management. Experienced in designing the Conceptual, Logical, and Physical data modeling using Erwin and ER Studio Data modeling tools. Good in system analysis, ER Dimensional Modeling, Database design, and implementing RDBMS specific features.
Skills : Microstrategy, Microsoft Office Applications, SQL Server.
Description :
- Involved in multiple projects which are driven by the business requirements.
- Gathered and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality Performed in team responsible for the analysis of business requirements and design implementation of the business solution.
- Developed logical and physical data models for central model consolidation.
- Worked with DBAs to create a best fit physical data model from the logical data model.
- Conducted data modeling JAD sessions and communicated data-related standards.
- Used Erwin r7.0 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
Experience
2-5 Years
Level
Management
Education
Bachelor Of Technology