Thomas Song 000.555.1212 123 Any St. Omaha, Neb. 00000 Willing to Relocate

Data Modeler

Offering a proven track record of supporting and influencing positive outcomes in business units and companies throughout the financial services industry through the application of cutting-edge tools and creation of detailed, production-level technical specifications, as well as intuitive conceptual, logical, relational and physical data models. Enthusiastic learner and excellent problem-solver.  Willing to relocate and start work within two weeks anywhere in the U.S. without financial assistance.
  • Lowered processing costs and time by 10% for accident claims through the review and reverse engineering of existing database structures, which reduced redundancies and consolidated databases.
  • Enabled the development of two new insurance products that produced $25 million in first-year sales through the development of a cutting-edge logical data model and module enhancements that facilitated the creation of test cases and precise actuarial forecasting and analysis.
  • Empowered productivity improvements and data sharing throughout a major banking enterprise by using ERwin r7.3 for effective model management.
  • Spearheaded the design and creation of data models that boosted deposits 8% by identifying active, inactive and new investors and private banking clients, tracking their deposits and withdrawals, and providing marketing with fact and dimension tables on a daily basis. View Samples and More Accomplishments: [Insert link to online portfolio]

Data Modeler’s Tool Box

Data Modeling Tools: ERwin r7.1/7.2/7.3/8.0, Oracle Designer 12.0 and ER Studio 8.5.3. OLTP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports 9. Databases: Oracle, MS SQL Server, MS Access, DB2. Business Applications: Microsoft Office Suite, Visio. Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX. Data Warehouse: Informatica, SSIS. Modeling: Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Modeling Experience

Mutual of Nebraska, Data Modeler     Jan. 2012 to present A roving modeler, responsible for gathering and translating business requirements into detailed, production-level technical specifications, creating robust data models, data analysis features and enhancements for this major provider of life and accident insurance. Successfully completed more than 22 projects that produced 10% gains in productivity, $25 million in revenues and 2% in profits. Related Tasks, Responsibilities and Actions:
  • Collaborate with data architects for data model management and version control.
  • Conduct data model reviews with project team members.
  • Capture technical metadata through data modeling tools.
  • Create data objects (DDL).
  • Enforce standards and best practices around data modeling efforts.
  • Ensure data warehouse and data mart designs efficiently support BI and end user
  • Collaborate with BI teams to create reporting data structures.
MidWest Bank, Data Modeler     2010 to 2012 Promoted into a data modeling role handling multiple projects for home loans, auto finance and private banking for this major bank after serving as a marketing data analyst for just two months. Empowered the retention and acquisition of private banking customers, which boosted deposits by 8%. Increased productivity and reduced loan processing time 2% by facilitating the sharing of data among home loans, auto loans and credit cards. Related Tasks, Responsibilities and Actions:
  • Extracted data from Oracle and SQL Server and DB2 using Informatica to load it into a single data warehouse repository.
  • Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.
  • Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
  • Developed and implemented measurements for various marketing campaigns.
  • Created a net loss model which analyzes the impact of loan defaults and recoveries.
  • Created a relational model and dimensional model for online services such as online banking and automated bill pay.
  • Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
  • Developed logical data models and physical data models using ER-Studio.
Close the Gap, Data Analyst     2008 to 2010 Acquired training and expertise in data modeling while serving as a data analyst for this major provider of supplemental accident insurance. Related Tasks, Responsibilities and Actions:
  • Created and implemented ER models and dimensional models (star schemas).
  • Generated SQL scripts.
  • Assisted DBA's in the development of physical database.
Major Holdings, DBA     2005 to 2008

Education and Training

  • Master's Degree in Information Systems, University of Phoenix
  • Bachelor’s Degree in Information Technology, University of Nebraska College of Information Science and Technology
  • Data Modeling Concepts
  • Data Modeling with CA ERwin® Data Modeler
  • Process Modeling with CA ERwin® Process Modeler
  • Model Management with CA ERwin® Data Modeler, Process Modeler and Model Manager
  • Steve Hoberman, Donna Burbank, & Chris Bradley. Data Modeling for the Business.

Thomas Song ♦ LinkedIn ♦ Portfolio ♦ Facebook ♦ 000.555.1212

Upload Your ResumeEmployers want candidates like you. Upload your resume. Show them you're awesome.