We provide IT Staff Augmentation Services!

Data Modeler Resume

3.00/5 (Submit Your Rating)

Columbus, OH

SUMMARY

  • 7+ years of professional experience as a Data modeler in Finance/Banking Domain with expert in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems using ERwin and Power Designer.
  • Extensive experience in Conceptual, Logical and Physical Data Modeling, Comparing and merging, Reverse and Forward Engineering using various data modeling tools like Sybase Power Designer 15.2, Embarcadero ER Studio Data Architect 9.1/9.5, ER Studio Business Architect 1.7, Erwin 7.1 and Toad Data Modeler. Experience in designing conceptual model of COTS (Commercial off - the-shelf) package.
  • Expertise in data analysis, data modeling, Conceptual logical modeling and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems with efficient in analyzing data samples and identifying factors that affect development costs.
  • Have a strong exposure and experience on Service Oriented Architecture (SOA) and object oriented methodologies.
  • Extensively worked with complex SQL queries, PL/SQL Stored Procedures, Functions and Packages using TOAD and SQL*Plus.
  • Experience with Object Oriented Analysis and Design (OOAD) using UML, Rational Rose and MS Visio with proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
  • Worked with various RDBMS like Oracle, SQL Server, DB2 UDB, and Teradata with expertise in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS), and Informatica.
  • Highly experienced in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions with expertise in automation of SAS processes, models and reports using SAS tools.
  • Have the extensive experience of supporting Oracle EBS that includes the upgrades from 11i to R12, planning upgrades, manage the team of DBAs/ Developers to perform the upgrades.
  • Developed Enterprise Canonical Data Model for messaging structure to support Master Data Management.
  • Worked extensively using TOAD, SQL*Plus, PL/SQL Developer and UNIX utilities.
  • Strong experience in requirements gathering, analyzing business processes and requirements, creating ETL interface specification and technical design documents with led facilitated workshops and Joint Application Development (JAD) sessions to refine requirements.
  • Efficient in data mart design and creation of cubes using dimensional data modeling with hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility.
  • Experienced in designing and creating dynamic web applications by using the Java programming language and advanced Java frameworks such as JDBC, J2EE, JSPs, Apache Struts, Hibernate, Spring, and JSTL.
  • Data mapping between various application and Canonical Data Structure for Integration.
  • Extensive experience in gathering requirements, gap analysis, design, development, testing and implementation of the OBIEE / ETL / Data warehouse projects.
  • Designed an ETL process to load the XML file from source to target using XSD, SQL LOADER, PL/SQL Package and shell script with also worked on Data Modeling, E-R diagrams, Logical, Physical design, Star/Snow flake Schemas using Erwin.
  • Exposure to Top down(Inmon), Bottom Up (Kimbal) and Mixed Approaches.
  • Experienced in performing database modeling using CA Erwin and MS Visio; performance tuning of SQL queries, stored procedures, views, and functions for MS SQL Server, Oracle, and Sybase databases; providing systems engineering / development / testing expertise; and deploying processes / applications / scripts.
  • Analyzed Teradata data from sources such as Google analytics and used map-reduce algorithms to analyze textual data with extensive experience in numerous Data warehouse, Data mart, Client-Server Applications.
  • Extensive experience in Business Analysis with excellent knowledge to the full Software Development Life Cycle (SDLC) methodologies and processes. Experienced in managing requirements from project inception through release.
  • Created Logical data model using ER/Studio tool and created normalized schemas by logical grouping of EDM attributes.
  • Design and implement data mapping and conversion/migration procedures using Transact-SQL, SSIS (DTS), PL/SQL and Unix shell scripts. Maintained Informatica and SSIS (DTS) based ETL architectures.
  • Highly Skilled in MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica/Business Data Director.
  • Very experienced in the development of data integration and ETL processes, including schema design, data mapping, data extraction, data cleansing, interfacing with third-party software interfaces, email notification, and SQL development for databases (MS SQL Server, Oracle, Sybase,Terra-data, and MS Access).
  • Possess strong ER Modeling and Dimensional Modeling skills for OLAP, OLTP, Enterprise Data Management (EDM), DSS, ODS using various databases like Oracle 10g/9i/8i, SQL Server 7/2000 and MS Access 97/2000/2002 , very good knowledge of Teradata V2R5/V2R6. Experienced in configuration management.
  • Used XML, WSDL, XSD, SOAP, SAX parser, DOM parser and Web Services for communicating data between different applications with dimensional Data Modeling experience using Data modeling, Erwin Modeling (Erwin 4.5/4.0, Oracle Designer) Star Join Schema/Snowflake Modeling, FACT & Dimensions tables.
  • Designed and built the application on SOA / web services based multi-tier environment with also extensively worked source systems like Oracle, Teradata, Access, Flat files, XML and Mainframe.
  • Extensively worked on data modeling and OLAP Data Analysis techniques - Data Mapping, Drill Down and Roll Up, Slice and Dice. Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, using industry leading Data Modeling tools like ERWin, ER/Studio, Power Designer.
  • Expertise in modeling using case tools like Erwin, Power Designer, MS Visio, ER/Studio, development of PL/SQL, Functions, Stored Procedures, Triggers and ActiveX Scripts.
  • Has been an integral part of every phase (analysis, design, testing, implementation) of database projects using every common type of data store - transactional (OLTP), data warehouse, Data Mart (OLAP).
  • Data preparation for various statistical modeling, which includes data cleansing, descriptive statistics, missing data analysis, data validation and preliminary data reporting using SPSS modeler and SAS Enterprise Miner.
  • Experience in the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse using Informatica Power Center and good Experience in analysis and resolution of bottlenecks for performance tuning of sources, targets, mappings and sessions.
  • Have experience in Dimensional Modeling using Star and Snowflake schema methodologies of Data Warehouse and Integration projects with also extensively worked Data Governance, i.e. Meta data management, Master data Management, Data Quality, Data Security.
  • Deep understanding of enterprise data warehouses and also worked with ETL processes to transfer/migrate data from relational database and flat files common staging tables in various formats to meaningful data in Oracle and MS-SQL.
  • Excellent experience and knowledge in modeling concepts like Conceptual Data Modeling (CDM), Logical Data Modeling (LDM), Physical Data Modeling (PDM), Star Schema, Snowflake Schema, Fact & Dimension tables, OLTP and OLAP.
  • Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle as per business requirements using Erwin 7.2.
  • Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
  • Experience in various programming languages (SQL, XML) and operating hardware and software applications including TOAD, Crystal Reports, Oracle Discoverer, Query Analyzer and SQL Navigator.

TECHNICAL SKILLS

Data Modeling Tools: Erwin r 7.1/7.2/8.0/9.5 , Power Designer, Clear quest, TOAD, Rational Rose, MS Visio, ER Studio, Oracle BPA, SA - System Architect,Embarcadero ER/Studio and Oracle Designer,OBIEE.

OLAP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports9 .

SAS skills: SAS9.0, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/REPORT,SAS/GRAPH, SAS/ETL, SAS/ETS, AS/ACCESS, SAS/CONECT.

ETL Tools: Microsoft DTS/SSIS, SSRS, Data Stage 7.5, Ab Initio and Informatica 7.1.3.

Programming Languages: SQL, PL/SQL, Base SAS, HTML, XML, VB.NET,C, C++, UNIX and Shell Scripting.

Database Tools: Microsoft SQL Server / 2005/2008/2011 , MySQL, Oracle 11g/10g/9i/8i, DB2, Teradata 13,MS Access 2011 and Teradata V2R6.1.

Packages: Microsoft Office Suite, Microsoft Project 2010, SAP and Microsoft Visio

Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Data Modeler

Responsibilities:

  • Captured data extract requirements for multiple subject areas sourced from an external ERP system with maintained existing ETL procedures, fixed bugs and restored software to production environmen and created the conceptual model for the data warehouse with emphasis on mutual funds and annuity using EMBARCADERO ER Studio data modeling tool.
  • Analyzed data which included investigation and analysis, documentation, filtering of bad data through generation of crystal reports with designed 3rd normal form target data model and mapped to logical model with also created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE.
  • Worked with Data Warehouse Extract and load developers to design mappings for Data Capture, Staging, Cleansing, Loading, and Auditing with designed artifacts like WSDL, Schema (XSD), Mapping Documents, for the Middleware MQ and Web Services.
  • Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design with used SAS/SQL to extract data from different databases and joining tables.
  • Maintained DataMirror and DTS based ETL architectures. Recommended/developed testing procedures.
  • Played the lead role as a SOA Data Modeler and Architect for the IAA's IDM (Interface Design Model), which will be later consumed by the development team in building the application.
  • Designed and developed MDM canonical data model to support SOA based data distribution architecture.
  • Developed, enhanced and maintained Snow Flakes and Star Schemas within data warehouse and data mart conceptual & logical data models with also analyzed and designed XML Schema Definition (XSD) data objects in XML Spy to standardize MDM.
  • Defined logical and physical data modeling principles and guidelines for Teradata FSLDM modeling.
  • Performed Business Analysis and Requirements Gathering from high-end users and managers with designed data models based on business case documents provided by client and also developed / Reviewed conceptual, logical and physical data models using ER Studio.
  • Writing Complex SQL queries, SAS Base, SAS SQL and QlikView Business Intelligence Software to mine/extract data for the purpose of report-making and designing the report with also used SAS/Macro facility to create macros for statistical analysis, reporting results and data extraction.
  • Analyzed business requirements and translated them into detailed conceptual data models, process models, logical models, physical models and entity relationship diagrams. Gathered enterprise level data requi rements.
  • Responsible to create Canonical Data Model for loosely coupled systems that use different notations for the transaction codes.
  • Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP with also communicated data needs internally and externally to 3rd parties. Analyzed and understood the data options and documented data dictionary.
  • Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
  • Extensively used Data Null to create macros, customized reports, reports on external files and debugging SAS codes with also using Erwin, designed Logical and Physical data model/meta data /data dictionary for business users and development team.
  • Data modeling and data analysis with Teradata, Oracle, SQL Server, using Erwin for OLTP, ODS, EDW.
  • As a data modeler, my duties include Understanding the business rules, Coordinating the queries with the Business team, defining the Meta Data Model, designing and reviewing the schema with the senior data architects, reviewing the schema with SOA Governance team,publishing XML schema Definition files, WSDLs to development team.
  • Created Data bases, table spaces, buffer pools in Power designer to create physical tables on the data base.
  • Created and maintained XSD xml schemas for the application teams, mapped XSD complex types and data elements with analyzed content and quality of data model(s) and databases.
  • Work closely with the DBA team to translate the model(s) from logical design to physical implementation.
  • Design the Canonical model for the Financials domain of the Enterprise model with also creating Data Architecture Models, Entity Relationship Models (ERD) and Data Flow Diagrams (DFD) with lead the JAD sessions and project status meetings with the stake holders.
  • Set direction and analysis approach as well as maintain task assignments and report statuses to management as the Lead Data Modeler on new critical corporate initiatives with minimal or no management oversight.
  • Analyzed the existing structures, ETL, database objects, Server infrastructure for the EDW and Data mart and then created system stabilization tasks to improve the data quality, avoid ETL failures and improve performance.
  • Architectural analysis of the data models and data analysis for the several source systems to populate the new canonical databases and the new dimensional EDM database.
  • Perform logical and physical data structure designs and DDL generation to facilitate the implementation of database tables and columns out to the DB2, SQL Server, and Oracle DB schema environment using CA ERwin Data Modeler Release 7.3.
  • Design envelops canonical structure to enable integration across applications.
  • Proficient in documenting business requirements, business use cases, application use case and system requirements specifications for both in-house systems and COTS products. Possess strong Enterprise Architectural skills with specialization in Enterprise Data Modeling, Enterprise Business Process Modeling, Enterprise State Event Modeling and Enterprise Canonical Message Schema Creation.
  • Determined requirements, maintained legacy systems; led JAD sessions, developed conceptual and logical data.
  • Conduct source data analysis of various data sources and develop source-to-target mappings with business rules.

Confidential, Hartford, CT

Data Modeler

Responsibilities:

  • Facilitated JAD sessions to determine data rules and conducted Logical Data Modeling (LDM) and Physical Data Modeling (PDM) reviews with Data SMEs also participated in data analysis and data dictionary and metadata management -Collaborating with business analysts, SMEs, ETL developers, data quality analysts and database administrators.
  • Participated in design of Data Asset Management (DAM), Marketing, Customer Contact Channel, IVR, Targeted Payment Protection business processes, target applications architecture and target data model.
  • Developed relational model design, dimensional modeling, and ETL process in Data Warehouse (DWH) environment. Validated and maintained the enterprise-wide logical data model for Data Staging Area, DWH and DSS.
  • Responsible for the data analysis, logical design and canonical models to support multiple Personal Identities with interface to Security and Billing Systems for a Data-provider Organization.
  • Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository with also aided and verified DDL implementation by DBAs, corresponded and communicated data and system specifications to DBA, development teams, managers and users.
  • Developed the logical data model (LDM) & PDM and assisted the DBA to create the physical database by providing the DDL scripts including Indexes, Data Quality checks scripts and Base View scripts.
  • Reviewed data models with Solution Designer to assess the impact of the new model on the enterprise model and managed the data model changes in all enterprise applications. Performed impact analysis to ensure all systems leads are informed and coordinate efforts to implement changes.
  • Migrated and tested DTS packages to SQL Server 2005 Integration Services.
  • Performed data analysis and reverse engineering of data with provided data modeling support to the Marketing operations design team and also developed Business and Subject Area Logical Data Models, Physical Data Models, Physical Staging area Data Models and Data Flow Diagrams.
  • Developed, integrated, managed and promoted enterprise level logical and physical data models and data model standards that source data from multiple origins (internal data sources, external data sources, third party data.
  • Developed detailed mapping documents that will provide the reporting and data warehouse team with source to target data mapping includes logical names, physical names, data types, corporate meta-data definitions, and translation rules.
  • Developed Table Reports, Pivot Reports, Chart reports, Dashboards and Chart Reports from Pivot reports - vice versa and also worked with an architect to design target environment data structures, design source to target data mapping, and design logical and physical data models.
  • Educated users for data quality and metadata management and mentored targeted power users in BI with also participated in the business, information, and user interface requirements, participated in facilitating joint application development (JAD) sessions, designed logical and physical data model (dimensional modeling) utilizing ERWin CASE Tool and created the star schema.
  • Developed several releases of the Enterprise Canonical XML Schema (ECXS), enabling timely implementation of Exchange-related projects for the Affordable Care Act.
  • Develop, implement, and maintain OLTP and data warehouse data models. Increase the use of data modeling in development organizations with also assisted in data modeling JAD sessions with subject matter experts and the creation of the conceptual data models based on these sessions.
  • Performed the logical data modeling necessary to produce the target data model, rationalized and integrated across subject areas, which formed the foundation for Data Warehouse initiatives with also creates test scenarios and test data to support both quality assurance and user acceptance testing.
  • Capture business requirements and rules, design the associated logical models, and create all required documentation to support, communicate, and validate the data model with also created design documents including metadata samples, use cases and data flows to facilitate the development group usage of the subject area.
  • Created database triggers, functions, procedures, cursors and packages also developed PL/SQL scripts to validate and load data into interface tables with extensively used Stored Procedures for handling the database operations.

Confidential, Philadelphia, Pa

Data Modeler

Responsibilities:

  • Conducted Work Sessions with Business Architects/Business SME to understand the business requirements.
  • Worked closely with Application Modelers to customize the project logical models and help them align to Enterprise Model
  • Involved in the design of Messaging Layer for vending data across the Enterprise using Enterprise Common Format.
  • Worked closely with the Application development Team to Implement Security Master Data Management Solution using Informatica.
  • Designed Conceptual and Logical data models for MDM Provider and Member domains and reverse Engineering models from Databases, files, External metadata using ER Studio with maintained Physical models and created DB objects with the help of DBA.
  • Created Enterprise Design Patterns which can be used as guidelines across the enterprise.
  • Contributed to develop Enterprise Modeling Process to identify the various parties their roles/responsibilities, the inputs/outputs for each process on each step in its life cycle.
  • Developed a template to provide estimate by the Modeling Process Steps to the management.
  • Developed Work Flow Process to manage and track the issues raised by consumers to track and resolve the issues against the Enterprise Logical Model.
  • Contributed to develop the Data Model Release process flow to provide transparency & visibility to the Management/Consumers.
  • Contributed to Data Governance efforts to identify the Core and Critical Elements for the Enterprise with the guidance from Business SME's
  • Supported the Data Governance activities by running the Compliance report on Application Models
  • Provided guidance to create Business Glossaries to define standard business terms and ensure consistent and clear communication
  • Worked with Subject Matter Experts in assigned areas and Business Users to analyze business processes and develop and document requirements.
  • Provided data models and data maps (extract, transform and load analysis) of the data marts and feeder systems in the aggregation effort.
  • Coordinated with Informatica ETL developers in providing data mapping and sql queries for bulk data load.
  • Designed and developed the Data Mapping documents, DDL Scripts, data dictionary and Meta data of the models and maintained them.
  • Involved in the full life cycle of project through design, development and maintenance of an enterprise data warehouse repository.
  • Additionally participated in overall system design, data modeling, SQL and process design and tuning, UNIX scripting for processing loads, and PL/SQL development.
  • Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary evolve and change during the project.
  • Created Data model Diagrams (Physical & Logical), Entity relationship using Erwin.
  • Engineered complex ETL processes to load large volumes of data on a daily basis.
  • Involved in data quality and standardization processes and all metadata & ETL documentation that support business roles and detailed source to target data mappings.
  • Performed Data Validation and Unit Testing before handing over the data for production and Quality Testing.

We'd love your feedback!