Data Modeler Resume
Data Modeler develop conceptual, logical, and physical data models for databases and data warehouses, and ensure high data quality, and less redundancy. They work with data architects and analyze business requirements, implement data strategies as well as optimize, and update data models. If you are really interested to work for this profile, you will need an effective Data Modeler resume that makes you stand out from the competition. The resume must display your expertise in data model development and usage, identifying and reducing data redundancy, data migration and profiling, requirement analysis, metadata management, SQL data modeling, DDL generation and model repository development, data validation and troubleshooting, data modeling standards, data model documentation. To increase your chances of getting an interview call, showcase your effective analytical thinking, documentation, communication, team-working, time-management and multi-tasking skills.
To get a clear understanding, customize your resume with the given below sample Data Modeler resume:-
Data Modeler Resume Sample
Ellen C. Bates
1637 Union Street
Seattle, WA, 98106, USA
Phone No: 206-623-5789
Email: ellenCbates@anymail.com
Career Summary:
Highly-dedicated, enthusiastic and professional Data Modeler with more than 6 years of experience in creating, updating and maintaining physical, logical or conceptual data models, and designing databases as per business requirements. Capable of setting data modeling and design standards, implementing data strategies, identifying missing or redundant data as well as possess excellent communication, analytical, problem-solving, team-working, project management, and organizational skills.
Summary of Skills:
- Thorough knowledge of data modeling and management, database design, SQL implementation, requirement analysis, data based system integration, data reviews and enhancements, technical documentation
-
Experience with Sybase Power Designer, Erwin data modeler, Oracle Designer, Toad database management toolset, ER/Studio software, Microsoft Azure platform, data analytics and BI tools, ETL and OLAP tools, Oracle SQL Developer Data Modeler
-
Proficiency in SQL, PL/SQL and HTML PLs, MS Office packages, RDBMS, scripting, UNIX and Windows OS, Oracle 10g and 11g, MS SQL Server 2008
-
Clear understanding of conceptual, physical and logical data models, data warehouse and data mart designing, database schemas, ETLs ,and data visualizations, data profiling, mapping and redundancy; metadata management, computer binary process, ER modeling
-
Ability to analyze business data requirements, functional and technical specifications as well as design conceptual, physical and logical data models
- Excellent organizational and time-management skills and the ability to handle large data volumes and databases
-
Effective communication and presentation skills and the ability to engage with client or business users in technical discussions
-
Excellent analytical and mathematical skills and the ability to solve complex data modeling and database issues
-
Ability to cope with fast-paced and challenging environment as well as work both independently and in cross-functional teams
Work Experience:
Data Modeler
ADP Tech Group, Seattle, WA
February 2018 - Present
- Creating, optimizing, updating, and maintaining logical and physical data models for various databases, applications and systems as well as leading design reviews of data models and relevant metadata to ensure consistency, quality, accuracy and integrity
-
Working collaboratively in a diverse team environment, including data architects and developers as well as understanding and translating business needs into high-level conceptual data models, data strategies and data flows as required
-
Collaborating with database administrators in creating physical data schema from the logical and physical data models by making recommendations, designing referential integrity, and ensuring compliance with business requirements
-
Designing and developing data mapping, error-free DDL scripts and transformation scripts to support and promote data warehouse development, structural changes of multiple RDBMS and data analytics efforts as well as design effective ETL logic and code as required
-
Defining and governing data modeling and design standards, tools, best practices and related development methodologies as required as well as utilizing data modeling tools and associated graphical methods to depict and analyze conceptual, logical and physical data schemas
-
Evaluating data models, business data objects and physical databases and troubleshooting or resolving related issues as well as making recommendations for proper usage or re-use of data models in different environments
Data Modeler
CGI Technologies, Seattle, WA
April 2016 - January 2018
- Led discussions with developers, data architects and SMEs to understand, document and translate business requirements and scope into technical designs as well as high-quality conceptual, logical and physical data models
-
Supported the development and documentation of data flow diagrams, integrated data models and metadata as required as well as mapped data elements of data sources into domain data models and conducted model reviews with business and technical project teams
-
Developed SQL scripts to build database objects and roles that included stored procedures, views and tables as well as managed ETL design, data replication and change data capture processes as needed
-
Facilitated in developing testing procedures, test cases and UAT as well as identified and troubleshooted data-related system integration issues as needed
-
Developed best practices for standard naming conventions to ensure data consistency as well as validated data models and physical databases for variances and discrepancies as needed
-
Applied metadata standards and checked models in and out of model repository as well as identified potential database designs, process or system changes to optimize performance and mitigate risks as required
Data Modeler
SoftVision Systems, Seattle, WA
December 2013 - March 2016
- Created, developed, implemented, updated and maintained data models, data flows and related strategies for applications, data marts or warehouses as per established standards and procedures to ensure high data quality and reduced redundancy
-
Transformed business or data requirements into logical models and developed physical data models to define database structures as well as optimized database performance through efficient indexing and table relationships
-
Collaborated with technical teams in performing QA reviews of data model deliverables as well as created and maintained data model repository as per established standards and procedures
-
Worked closely with ETL and DBA teams in analyzing and recommending solutions related to various data issues during project implementation as required as well as produced data dictionary and database support documentation for technical and business purposes
-
Converted logical models into physical models as well as generated DDL scripts and complex SQL views for optimal performance tuning
-
Trained and supervised less experienced data modelers in integrating multiple logical data models into a single data model as well as performing gap analysis, impact analysis, data profiling and ETL processes
Education and Training:
-
Database Design and Data Modeling course
2013
- Bachelor's Degree in Computer Science
University of Washington, Seattle, WA, USA
2013
Reference:
On Request.