Data Modeler Resume Sample
Gayle Gutkowski
9811 Erin Alley,
Detroit,
MI
+1 (555) 380 5236
Work Experience
Senior Data Modeler
05/2016
-
PRESENT
Philadelphia, PA
- Translate Business Requirements to Conceptual and Logical Data Models
- Recognize the need for a specific relational design – OLTP, OLAP, Data Warehouse – from a set of requirements and/or from a Logical Data Model
- Participate in mapping of Logical to Physical Data Models and vice versa
- Evaluate other Modeler’s logical and/or physical data models for adherence to modeling
- Manage multiple assignments simultaneously, whether working independently or in teams
- Identify, recommend and implement emerging Modeling and IT trends, tools and solutions
- Review junior team members’ data models
- Experience in working in the Pharmaceutical Industry preferably in the Drug Development function
Data Modeler
06/2012
-
12/2015
Dallas, TX
- Develop an in-depth understanding of the business processes and data in the corporation and apply the knowledge towards developing and maintaining the Corporate Data Model and a Metadata Portal
- Enhance (or create - if new system) system logical data model to meet requirements, applying the Data Modeling Standards and the logical Data Naming Conventions. Apply the same enhancements in the physical data model, using the Data Modeling Standards and the physical Data Naming Conventions appropriate for the specific back-end database
- Select the appropriate data types and sizes for the new fields added to the system data model
- Document definitions for all new data model constructs
- Document the data model enhancements in a standard document
- If the project involves the creation an interface between two systems, the data modeler would create a mapping matrix describing the correlation between the data elements in the two system data models
- Develop data mappings for reports, to correlate data elements on reports to tables/fields in the underlying physical data model
- Perform analysis of system data to identify patterns, exceptions and erroneous data
- Create high-level process models (activity hierarchy diagrams, data flow diagrams, workflow diagrams, system interface diagrams) to represent business processes for the area under analysis
Junior Data Modeler
08/2008
-
02/2012
Dallas, TX
- Experience in Entity – Relationship modeling, Object – Relational modeling, Class modeling
- Investment Banking industry experience, or engaging those businesses as part of a market leading consultancy
- Experience Required: At least 5 years of work experience in database modeling and design for enterprise Java applications based on Hibernate, EJB and Spring using tools such as SAP PowerDesigner
- Work experience of SQL and other scripting languages such as Perl or bash, preferably related to Oracle or PostgreSQL
- Review DWH ETL mapping documents
- Identify/Fix SQL performance issues
- Support development teams on all misc. needs including: Access/Privilege Requests, Tablespace Assignments, Space Capacity Analysis
- Conduct/attend requirements definition meetings with end users and document system/business requirements
Education
Maharishi University of Management
2002 - 2007
Bachelor's Degree in Computer Science
Professional Skills
- Project management skills. Experience and skills to design and implement a multi program projects
- Strong SQL skills: 2+ years experience with SQL query language which includes writing, optimizing, and tuning queries / scripts / stored procedures
- Excellent analytical & troubleshooting skills and have experience in analyzing server logs
- Excellent analytical and troubleshooting skills Proven ability to work with user community in both requirements definition and business issues
- Skilled in reporting, data visualisation software and strong presentation skills
- Excellent verbal and written communication skills and the ability to deal effectively with people at all levels
- Advanced verbal and written communications skills. Presentation skills
How to write Data Modeler Resume
Data Modeler role is responsible for business, sql, modeling, interpersonal, technical, analytical, coding, advanced, software, design.
To write great resume for data modeler job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Data Modeler Resume
The section contact information is important in your data modeler resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your Data Modeler Resume
The section work experience is an essential part of your data modeler resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous data modeler responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular data modeler position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Data Modeler resume experience can include:
- Strong communication skills and experience in interacting with business and technical experts
- Strong organization and excellent verbal and written communication skills are required
- Training and demonstrated skills in using ERwin or similar data modeling tools
- Demonstrates the ability to effectively facilitate meetings and/or project discussions and establishes metrics for measuring key project deliverables
- Good communication skills and ability to lead JAD sessions and discussions with business and actively participate in data mapping exercise
- Strong data analysis skills including the ability to manipulate and interpret large datasets
Education on a Data Modeler Resume
Make sure to make education a priority on your data modeler resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your data modeler experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in Data Modeler Resume
When listing skills on your data modeler resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical data modeler skills:
- Excellent listening skills, ability to learn quickly, a client-focused mindset, and willing to accept accountability for company and individual success
- Strong problem-solving and communication skills and enjoys working in a collaborative environment
- Very strong Dimensional modeling and 3NF modeling skills
- Strong Dimensional modeling and 3NF modeling skills
- Effective critical thinking skills for problem identification and solution recommendation
- Highly organized with strong communication, problem-solving, documentation, and presentation skills
List of Typical Experience For a Data Modeler Resume
1
Experience For Senior Data Modeler Resume
- Excellent communication and time management skills, detail-oriented and organized
- Demonstrate a team orientation by working closely and effectively with business partners, development teams and outside services
- Demonstrated extraction/transformation/load processes (ETL) performance tuning skills
- Programming knowledge and skills in SAS, R, or SPSS or other statistical package
- Scripting language knowledge and skills in Python and/or Perl
2
Experience For Junior Data Modeler Resume
- Demonstrated hands-on experience using a data modeling tool (e.g., ErWin)
- Five years data modeling experience, including three years business requirements analysis, entity relationship design, and data normalization experience
- Relevant experience in data modeling, architecture, reporting and manipulation or equivalent combination of education and work experience
- Soft skills required to work with a diverse team within and outside CDO, including senior executives
- Proven experience modeling flat and efficient information solutions
- Analytical and problem solving skills with those needs
- Demonstrated architecture and solution delivery experience in information security, data management, data modelling and/or data protection
- Demonstrated practical experience with taxonomies, ontologies, data modelling tools and data remediation / alignment programs
- Effectively communicate at all levels of the organization, converting complex challenges into simplified options and recommendations
3
Experience For Senior Data Analyst / Data Modeler Resume
- Understand data and systems engineering concepts to effectively integrate data
- Communicate and work effectively with a global team
- Implementation skills such as in Java, Python, and scripting
- Good understanding and hands on experience with Sybase ASE, Sybase replication server and Enterprise Data Connect (ECDA)
- Skills to design and implement enterprise-class data models
4
Experience For Data Modeler Specialist Resume
- Hands on data analysis skills to understand the data
- Maintains strong data governance discipline. Highly effective at facilitation of data requirements sessions for complex applications
- IT experience with 5+ years of direct experience of using erwin data modeler or equivalent technology
- Strong experience of database design, Oracle, SQL
- Solid Java and J2EE experience
- Proven experience as an advocate for data standards
5
Experience For Senior Data Engineer, Data Modeler Resume
- History of demonstrated experience and judgment to plan and accomplish goals
- SQL DBA experience, experience using Tableau as a Business Intelligence tool and data integrationSearch Jobs US
- SQL database experience, experience using Tableau as a Business Intelligence tool and data integrationSearch Jobs US
- Possess at least five (5) years of hands-on experience and/or supervisory experience with
- Form strong business relationships and partner across the enterprise for effective cross-functional project delivery
- Comprehensive knowledge and skills to use data visualization methods to represent complex data
- Validating updated CRDM mappings and leading CRDM mapping working sessions
6
Experience For Associate Data Modeler Resume
- Loading and maintaining production/well test data for operated well from field systems (EC) into the EMSDB
- Modeling experience (building)
- Working experience with relational database, such as Oracle, SQL Server is required
- Prototyping the solution with limited data scope as part of solution assessment, validation and evaluation
- Experience in creating business metadata repository and data catalog, using ERWin and creating ERD, and designing and working with complex data models
- Operate the intelligence platform efficiently by monitoring data set performance, troubleshooting issues, training and certifying users, and supporting peers
7
Experience For Data Modeler Manager Resume
- Strong knowledge of reporting modeling concepts, including dimensional, snowflakes, slowly changing dimensions, and surrogate, compound and intelligent keys
- Progressive applied technology experience including defining, populating and driving adoption of complex data models and taxonomies
- Data modeling and data integration experience specifically in a data warehousing setting utilizing both onshore and offshore resources
- Very good knowledge of banking data (retail banking, capital markets) and data warehouse building using this type of data
- Experience in designing data warehouses, data marts and operational data stores – dimensional modeling, abstract modeling and 3NF modeling
8
Experience For Big Data Modeler Resume
- Experience with conceptual, logical and physical modeling using modeling tools such as SAP Power Designer, Visio, ERWIN, or Embarcadero, etc is required
- Working experience in transactional, and dimensional data warehousing, modeling development
- Experience developing, reporting, and presenting business conclusions to management
- Experience analyzing data, developing data mapping requirements, or equivalent knowledge
- Experience and understanding of logical modeling vs. physical modeling
9
Experience For Enterprise Data Modeler Resume
- Skilled in designing data models including incorporating industry standards (ISO, Fix, FpmL, FIBO, etc.) in the design
- Familiarity or experience with budgeting, analysis, forecasting, and reporting
- Experience in developing and implementing machine learning algorithms
- Experience with SAP PowerDesigner and System Architect as main modelling tool, including exports of artifacts into SAP HANA layers
- Experience with query and scripting languages, including SQL, Perl, Python, and Shell
10
Experience For Data Analyst / Data Modeler Resume
- Hands on experience with modeling tools, such as: ERWIN or another industry standard tool and knowledge of various features of modeling tool
- Experience querying and loading relational transactional, and dimensional data models in a data warehouse environment are required
- Experience querying and loading relational transactional, and dimensional data models in a data warehouse environment
- Significant experience developing and maintaining complex logical data models in both business models as well as meta-data models for dynamic business rules
- Lead the capacity planning and enterprise architecture changes and consolidation efforts surrounding database hardware
- Experience using a data modeling tools such as ERWin
- One to three years Database Administration experience including tuning/optimization
List of Typical Skills For a Data Modeler Resume
1
Skills For Senior Data Modeler Resume
- Demonstrate solid business and organizational skills
- Demonstrated experience with defining and implementing strong data security standards
- Strong oral and written communication and mentoring skills are required
- Proven expertise in data modeling and/or data architecture skills
- Excellent research and troubleshooting skills
- Experience of SAP ECC & SQL coding skills
- Experience of SQL Coding skills & little knowledge of SAP ECC (new)
2
Skills For Junior Data Modeler Resume
- Work experience in a business related environment and advanced skills in MS Office, including Excel
- Excellent written and verbal communication skills with business and technical people at various levels within the organization
- Proven ability to be proactive, possess flexible attitude, learn new skills, and manage ambiguity
- Very strong SQL skills in enterprise data ware house environment
- Demonstrated ability to quickly learn/understand new technologies / applications (to effectively work across IT projects)
3
Skills For Senior Data Analyst / Data Modeler Resume
- Very strong SQL skills in enterprise data warehouse environment
- Demonstrated hands-on experience in relational data management disciplines and design and development experience using Oracle database technologies
- Strong skills in Informatica, Hadoop, data architect and SQL is needed
- Strong SQL skills to support analysis of data
- Very strong abstract and conceptual thinking skills
- Very strong communication skills, especially written
4
Skills For Data Modeler Specialist Resume
- Strong interpersonal, collaboration, leadership, and analytical skills
- Strong technical skills required to ensure technical solutions are efficient and optimal
- Strong inter-personal skills and ability to work as part of a team
- Use strong verbal and written communication skills that non-technical business and end-users can understand
- Solid organizational and relationship building skills, at all levelsSearch Jobs US
- Effective interpersonal skills to interact with management and internal customers
5
Skills For Senior Data Engineer, Data Modeler Resume
- Excellent verbal and written communication skills with ability to clearly articulate and discuss technical issues with both technical and business personnel
- Excellent interpersonal skills with an ability to network and interact with senior staff
- Performing unit tests to validate modifications to models and context prior to merging changes to GIT Develop
- Demonstrated strong analytical thinking when evaluating business requirements, designing solutions, troubleshooting issues, and identifying root cause
- Prior experience performing data modeling / mapping and designing data structures
- 60+ Months Demonstrated hands-on, in-depth experience with designing, creating applications and Banking domain reporting solutions
- Demonstrated skill in SQL PL/SQL and other query languages including complex query building and query performance tuning
- Prior experience using or supporting BMC Remedy tools
- Robust skills in developing understanding business needs and requirements
6
Skills For Associate Data Modeler Resume
- A passion for coding and a desire to leverage these skills in collaborate and supporting environment
- Proven experience managing vendor resources in onshore/offshore staffing models
- Entry level experience in data manipulation, cleansing and modeling (0-2 years), although demonstration of core skill set required to satisfy project requests
- Strong knowledge of and experience with working on multiple applications and establishing data interfaces
- Strong understanding data management, data warehousing, databases, data models. business intelligence, and analytics concepts with 5 years of experience
7
Skills For Data Modeler Manager Resume
- Proven experience in data modeling, data management, data warehousing, data transformation, metadata and reference data
- Analytical and problem solving skills for design, coordination and testing of applications
- Proven experience designing and implementing Fact/Dimensional models (at least 3 years)
- Strong business data modelling experience - preferably in investment banking trade management
- Full development lifecycle experience, working within IT, with proven delivery record and an ability to work in a demanding environment
- 24 Months Demonstrated hands-on experience with reviewing the data modeling of others for compliance and accepted standards of development
- Prior experience working with a data warehouse
- Prior experience interfacing with vendor support resources
8
Skills For Big Data Modeler Resume
- Prior experience working with projects to address technical requirements and complete system design
- Advanced Excel/VBA coding skills
- Prior experience working with and knowledge of ERP systems
- Experience in a data warehouse, data modeling or equivalent experience
- Applies principles, concepts and techniques of skills in developing solutions and strategies
- Experience creating information policy to support effective design of information systems and use of information across the enterprise
- People management skills, including the ability to direct, counsel, lead, and motivate staff in a matrix environment
- Experience with understanding data - profile and analysis (metadata (formats, definitions, valid values, and boundaries), relationship/usage)
- Five or more years of experience in data modeling and design, coupled with strong knowledge of the software development life cycle
9
Skills For Enterprise Data Modeler Resume
- Proficiency in using query languages such as SQL and data investigation skills
- Database skills using SQL to create/maintain database objects, query and load data required
- Advanced math skills. Develops formulas and performs calculations involving algebra, statistics, and calculus
- ABAP coding skills (new)
- Solid SQL skill and be able analysis the data and issue root cause, as well as create complex analytical procedures
- Superior written and verbal communication skills with business and technical people at various levels within the organization
- Strong English and technical documentation writing skill is required
- Work effectively with a global team
- Prior experience with webservices and APIs
10
Skills For Data Analyst / Data Modeler Resume
- Prior experience with Powershell scripts
- Prior database management systems experience (preferably SQL Server)
- Demonstrated hands-on experience with reviewing the data modeling of others for compliance and accepted standards of development
- Demonstrated analytics and communications experience (e.g., math, statistics, quantitative methods, and writing)
- Demonstrated communication experience (e.g. writing)
- Demonstrated hands-on experience utilizing SQL programming for data analysis purposes in a data warehouse/business intelligence environment
List of Typical Responsibilities For a Data Modeler Resume
1
Responsibilities For Senior Data Modeler Resume
- Solid analytical, problem solving and strategic thinking skills
- 60+ Months Demonstrated hands-on experience in relational data management disciplines and design and development experience using Oracle technologies
- Excellent communication (verbal and written) and professional skills
- Proven experience as a quick learner and effective change agent
- Superior listening skills, ability to learn quickly, a client-focused mindset, and willing to accept accountability for company and individual success
- Strong understanding of SDLC and experience in Agile methodologies
- 60+ Months Demonstrated hands-on experience with SQL programming
- 36 Months Demonstrated analytics and communications experience (e.g., math, statistics, quantitative methods, and writing proficiency)
- Work effectively at conceptual level and detail level
2
Responsibilities For Junior Data Modeler Resume
- Experience in Teradata database is a desirable skill
- Logical Design Demonstrated experience with large scale, multiple business solutions across divisions or enterprise
- Adaptable and able to pick up new tasks and skills quickly
- Prior experience with data analysis tools
- AWS cloud services such as EC2, EMR, RDS and Redshift, are required skills
- Excellent team player that demonstrates initiative and sound business judgment and is interested in continually learning
- Strong acumen and experience in database analysis and design is an imperative
3
Responsibilities For Senior Data Analyst / Data Modeler Resume
- Extensive critical thinking skills for problem identification and solution recommendation
- Proven experience in standard database technology (Oracle, Sybase, etc.)
- Working experience with cross-functional teams
- Working experience with relational database, such as Oracle, SQLServer is required
- Supporting the definition and maintenance of enterprise data quality rules (business rules and validation rules) for programs and VA Lines of Business
- Experience with moderate SQL scripts (creating, reading, running, customizing)
- Experience with data mapping (ETL data mapping with defined technical and business rules. Complex logic, not only 1:1 data mapping)
- Participate in business process modeling, working with the developers, with respect to data mapping and validation of the data’s life cycle
- Working experience in data modeling methodology and process using Erwin
4
Responsibilities For Data Modeler Specialist Resume
- Experience with conceptual, logical and physical modeling using modeling tools such as SAP Power Designer, Visio, ERWIN, or Embarcadero, etc
- Experience supporting multiple projects, estimating project resource requirements, and managing project delivery schedules and associated risks are essential
- Strong Knowledge of Dimensional Modelling, DW architecture, ETL Frameworks, Design using oracle, Best Practices and Troubleshooting
- Experience with data modeling and forecasting
- Significant experience developing and maintaining complex logical data models in both business models as well as metadata models for dynamic business rules
- Experience with data profiling, SQL, Teradata, and any enterprise class data modeling tool, such as ERStudio or erwin
5
Responsibilities For Senior Data Engineer, Data Modeler Resume
- Develop solid understanding of the various source data sets and assist in laying out the overall data design solutions
- Perform enterprise and project data modeling, including model consolidation and integration
- Experience with the following Erwin Data Modelling, Oracle, SQL Server, DB2, Big Data Technologies
- Experience making decisions on a variety of tasks frequently requiring discretion, judgment and initiative, guided by general procedures or standards
- Experience in data modeling principles/methods including conceptual, logical & physical Data Models
- Experience in translating/mapping relational data models into Data Base Schemas
- Experience with unit testing, release procedures, coding design and documentation protocol
- Data/information modeling experience, in both UML and entity relationship modeling
- Hands-on experience with SQL and shell scripting, and in-depth understanding of OLTP and OLAP
6
Responsibilities For Associate Data Modeler Resume
- Experience in developing and administering Microsoft SQL Server
- Experience developing predictive and prescriptive analytical tools; optimization modeling
- Experience manipulating large datasets and applying advanced analytic techniques
- Experience with data modeling tools, including Embarcadero ER/Studio or Erwin
- Experience with developing and maintaining logical and physical data models, data dictionaries, and database standards documents
- Experience in data modeling using Erwin and related tools
- Experience building and managing complex data model solutions
- Experience developing logical and physical data models and associated meta data in accordance with corporate guidelines and naming standard conventions
- Experience with Performance, Scaling, Caching
7
Responsibilities For Data Modeler Manager Resume
- Experience in using data modeling tools like Erwin
- Programing or scripting experience
- Perform data profiling, data validation, data cleansing and data conversion
- An excellent understanding of ETL processes and requirements mapping
- Experience working in Hadoop environment, including HDFS, Hive, Sqoop, HBase, Pig, Flume, Parquet, Avro and/or Spark
- Experience with medical standard vocabularies and coding principles, including ICD9/10, SNOMED, and LOINC
8
Responsibilities For Big Data Modeler Resume
- Proven ability in working with and leading the development efforts of other team members with minimal supervision
- Relevant experience in Data Modeling role, including transactional systems, data warehouses and data marts
- Experience researching and keeping "abreast" of industry technical/ business information security requirements
- Experience with Entity Relationship Models, Star Schema, Dimensional Modeling, and other Data Modeling Techniques and Methodologies
- Experience deeper understanding of Data analytics, Emerging technologies and Development practices
- Experience providing technical direction and mentoring to at least 2 or more people
- Experience modeling data for BI with at least 2 full life cycles delivering a large and complex solution
9
Responsibilities For Enterprise Data Modeler Resume
- Experience using CA’s Erwin data modeling tool
- Experience of designing and working with relational and dimension models and complex record layouts, both structured and unstructured
- Experience maintaining metadata for complex data environments and ensuring data integrity
- Data modeling, database design, and data development experience, including at least 2 enterprise-level data solution projects
- Five years of experience designing and implementing APIs for the purposes of data integration with external and internal systems
- Experience defining and enabling Service Oriented Architecture (SOA) required
- Experience in working with software development teams using waterfall and agile methodologies
- Provide extensive experience in Data Modeling and act as the Data Model expert on the team,
10
Responsibilities For Data Analyst / Data Modeler Resume
- Strong understanding of process models
- Experience using the ERWin tool
- Hands on experience with modeling tool such as (but not limited to) ERWIN, Power designer
- Experience designing relational and dimensional data models
- Develop, validate, and communicate Dimensional data modeling solutions
- Review the logs/ reports/ alerts and recommend improvements on existing systems and processes to ensure the effective performance of the system
Related to Data Modeler Resume Samples
Data Resume Sample
Work Experience
• Liaise with other technical areas, conduct technology research, evaluate software and produce research papers
• Proficient PC Skills and expert MS Software and database processing/maintenance skills (e.g. Word, Excel, Access)
• Act as liaison between the Care Management and C...
Professional Skills
• Excellent analytical skills and strong rep...
• Strong written and verbal communication sk...
• Strong analytical and quantitative skills ...
Data Collector Resume Sample
Work Experience
• Experience working with children
• Experience working with children
• Higher NITEC in Electrical/Mechanical
• Understanding of mechanical or instrumental equipment is required
• Good verbal, reading and writing skills
Professional Skills
• Experience working with high risk families...
• A person who has a valid driver’s licens...
• Strong computer skills including MS Office...
Data Leader Resume Sample
Work Experience
• Making available all the resources required for the administrative and financial processing of market and credit operations initiated by the various Business Lines
• Performing level one auditing in accordance with regulatory requirements, and setting up all the facilities required for secure proce...
Professional Skills
• Good scripting and programming skills Data...
• Demonstrates a compelling case by using da...
• Makes a point of responding promptly and e...
Data Mgmt Analyst Resume Sample
Work Experience
• Participate in projects and other initiatives per year that influence GOMD and Dell’s strategic objectives
• Management and coordination of configuration/data management system for both commercial and government projects
• Responsible for software configuration, participate i...
Director Data Resume Sample
Work Experience
• Market services to brand Zones Data Center solution capabilities
• BS or MS in Computer Science or other Science/Engineering related field or significant demonstrable professional work experience
• Experience in Finance or Payment Services s industries, with clear understandi...
Professional Skills
• Excellent presentation skills and demonstr...
• Demonstrated experience and skills at arch...
• Possesses excellent people interaction ski...
Data Collection Resume Sample
Work Experience
• Build lasting relationships with Humana’s customers
• Fluent – in Chinese language as this role is APAC focused
• Willingness to learn and hungry to grow
• Associates or BA (or demonstrated progression for pursuit of an education)
• &nb...
Professional Skills
• Excellent communication, interpersonal and...
• Excellent communication, strong organizati...
• Excellent interpersonal and communication ...