We provide IT Staff Augmentation Services!

Data Modeler Resume

5.00/5 (Submit Your Rating)

Atlanta, GA

SUMMARY

  • 8 years of professional experience in Data Modeling, Business Data Analysis and design of OLTP and OLAP systems with excellent communication, presentation, team support, database, and interfacing skills.
  • Proficient in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
  • Strong experience in Data modeling - Conceptual, Logical/Physical, Relational and Multi-dimensional modeling, Data analysis for Decision Support Systems (DSS), Data Transformation (ETL) and Reporting.
  • Involved in JAD sessions with developers, user interface personnel and end users.
  • Experienced in identifying entities, attributes, metrics, and relationships; also assigning keys and optimizing teh model.
  • Proficient in data mart design, creation of cubes, identifying facts & dimensions, star & snowflake schemes and canonical model.
  • Expertise in Data modeling for RDBMS and NoSQL data modeling; Data Warehouse/Data Mart development, ER modeling, Canonical Modeling, Dimensional Modeling, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/ Business Intelligence (BI) applications.
  • Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments.
  • Proficient in Normalization/De-normalization techniques in relational/dimensional database environments and have done normalizations up to 3NF.
  • Involved in Data Architecture, Data profiling, Data analysis, data mapping and Data architecture artifacts design.
  • Being Part of full lifecycle of DW Project, gatheird hands on experience on Evaluation, Installation, Development, Maintenance and Implementation of ETL tools such as Informatica, Data Stage & OWB and Business Intelligence Using Cognos, OBIEE & Business Objects.
  • Solid hands on experience with administration of datamodel repository, documentation in meta data portals in such as Erwin, ER Studio and Power Designer tools.
  • Experience working on SAS.
  • Experience working on Tableu.
  • Experience in writing Unix Shell Scripts and Database validation scripts
  • Created several scripts in UNIX for data transformations to load teh base tables by applying teh business rules based on teh given data requirements.
  • Supportive and enthusiastic team player dedicated to streamlining processes and efficiently reconciling data issues.
  • Ability to work on multiple projects independently as well as in a team.
  • Creative, Problem Solver, Flexible and having good interpersonal skills.

TECHNICAL SKILLS

Data Mining: Data reduction, Clustering, Classification, Anomaly detection, sequence mining (HMM

Databases: SQL Server 2017/2016/2014 , MS-Access, Oracle 11g/10g/9i, Sybase 15.02 and DB2 2016.

Big Data Tools: Hadoop 2.7.2, Hive, Spark2.1.1

DWH / BI Tools: Microsoft Power BI, SSIS, SSRS, SSAS, Business Intelligence Development Studio (BIDS), Visual Studio, SAP Business Objects, SAP SE v 14.1(Crystal Reports) and Informatica 6.1.

Frameworks: Scala, Spark, Cassandra, DL4J, ND4J, Scikit-learn, Microsoft.Net 4.5/ 4.0/ 3.5/3.0 , Entity Framework, Bootstrap, Microsoft Azure, Swagger.

Database Design Tools and Data Modeling: Star Schema/Snowflake Schema modeling, Fact & Dimensions tables, physical & logical data modeling, Normalization and De-normalization techniques, Kimball & Inmon Methodologies

Tools: and Utilities: SQL Server Profiler, Import & Export Wizard, Visual Studio v14, Net, Power Pivot, ProClarity, Microsoft Office 2007/10/13, Excel Power Pivot, Excel Data Explorer, Tableau 8/10, JIRA

DataModeling Tools: Erwin r9.6/9.5, ER/Studio 9.7, Power Designer,Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables

Operating Systems: Microsoft Windows 8/7/10/XP, Linux, and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Data Modeler

Responsibilities:

  • Involved in Business requirements and gathering requirements for designing data models, and developing new database.
  • Worked with Project advisors and solution engineers for planning and designing teh model.
  • Created Logical and Physical models according to requirements using Power Designer.
  • Conducted and participated in model reviews to validate teh upgrades.
  • Used Normal forms to develop logical model.
  • Converted data from old database to newly modeled database.
  • Created Views, stored procedures to generate required reports and dashboard.
  • Developed queries, views and procedures to send out alerts for various informatica based environments through SQL Server Agent.
  • Utilized SQL Server Management tool for generating new database and loading data.
  • Worked in Data Analysis, data profiling and identifying Source Data, Source Meta Data, Data Definitions and Data Formats.
  • Worked closely with Informatica ETL team to explain teh complex Data Transformation.
  • Used forward engineering to generate DDL from teh Physical Data Model.
  • Apart from Data Modeler experience, worked on Linux and Unix environments to install Oracle client for informatica utilities.
  • Worked on SNOW to extract data and create tickets and incidents for installation purposes.

Environment: SQL Server 2014, Power Designer, Informatica, Teradata Utilities, Tableau, MS Office 2015, MS Excel, SQL Agent, Linux,SNOW.

Confidential, Memphis, TN

Sr Data Modeler/ Data Analyst

Responsibilities:

  • Involved in Business requirements gathering session, designing operational and Dimensional Modeling Logical and Physical data models.
  • Worked closely with Architects, BA’s, DBA’s, SME’s and ETL team in planning, defining and designing teh database based on teh requirements and provided documentation.
  • Involved in data analysis, designing, and development of data warehouse environment.
  • Involved in converting Embarq legacy CRB (Billing system) Customers in to Finance (Billing System) and worked on various Data warehouse projects
  • Analyzing business requirements, understanding teh Entity Relations and translating busi ness requirements into Conceptual & Logical Data Models.
  • Involved in complete soft ware development life cycle (SDLC)
  • Identifying teh Source Systems, possible Fact tables and Dimension Tables.
  • Created Conceptual design as per requirements before designing logical and physical models
  • Utilized Data Modeling tool (ERWIN) while designing teh Logical & Physical models /Dimensional models for OLTP & OLAP databases. SAS was used for automating fast analysis.
  • Designed teh complex Logical Data Model for E-BAY HRMS in 3NF using Erwin.
  • Worked in Data Analysis, data profiling and data governance identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
  • Used NoSQL for big data usage puposes, as teh project was developed using JAVA as teh primary programming language.
  • Conducting and participating in model reviews to validate data model according to business requirements.
  • Experience with common data science toolkits, such as R, Python, Spark, etc.
  • Good applied statistics skills, such as statistical sampling, testing, regression, etc.
  • Broad noledge of programming, and scripting (especially in Java).
  • Used Hadoop storage systemand processing for optimizingnumber of formats.
  • Worked on Teradata database, installed and configured teh Teradata utility tools.
  • Configured Big Data Database connectivity from Tableau.
  • Created Views, Indexes, stored procedures and other database objects.
  • Conducted Design discussions and meetings to come up with teh appropriate Data Mart at teh lowest level of grain for each of teh Dimensions involved.
  • Designed a STAR Schema for teh detailed data marts and Plan data marts involving confirmed Dimensions.
  • Worked closely with Informatica ETL team to explain teh complex Data Transformation using Logic.
  • Used Power Designer to store models using a variety of file extensions. Also ised Power Designer to store models in a database repository.
  • Generated DDL scripts and coordinated with DBA’s.
  • Environment: Oracle 12c, SQL Server 2012, Erwin 9.6, Teradata, Teradata Utilities, Toad SQL Developer, Informatica Analyst 9.6.1, SAS, NoSQL, Tableu,Sybase Power Designer 15, MS OFFICE 2015, Crystal Reports, ALTOVA XML Spy.

Confidential, Seattle, WA

Sr. Data Modeler

Responsibilities:

  • Interacting with business users to analyze teh business process and requirements and transforming requirements into.
  • Requirement gathering from teh users by conducting a series of meeting with teh Business System Users to gather teh requirements for reporting.
  • Identification of Risks in schedule and marking them in teh Use Cases.
  • Extensively used Star Schema Methodologies in building and designing teh logical data model into Dimensional Models.
  • Worked with DBA Group to create Best-Fit Physical Data Model from teh Logical Data Model using Forward Engineering using ERWin.
  • Worked with DBA’s to create a best-fit physical data model from teh logical data model.
  • Used Mongodb for high write load.
  • Created Design Fact & Dimensions Tables using ERWIN tool.
  • Created a Normalized logical model for teh business to understand teh relationships and at teh deeperlevel of granularity.
  • Forward Engineering teh Physical Model to generate teh DDL scripts to implement on Oracle 11g database.
  • Reverse engineering of teh existing reports to identify teh key data elements and data entities required to design teh data warehouse.
  • Stored data using JSON style documents using Mongodb.
  • Developed Star and Snowflake schemas based dimensional model to develop teh data warehouse
  • Worked on slowly changing dimension tables and hierarchies in dimensions.
  • Good working noledge in normalizing teh tables up to 1NF, 2NF & 3NF.
  • Conducted performance tuning of teh database dat included creating indexes, optimizing SQLstatements.
  • Regularly conducted and participated in weekly status meetings.

Environment: Teradata, SQL Server 2000/ 2005, Erwin 7.5.2, Mongo db, Windows XP, XML, JSON,Excel, Access, Visio, ER Studio 9.7, Tableau 9.03, AWS, Teradata 15, MDM, GIT, Unix, Python 3.5.2, MLlib, SAS, regression, logistic regression.

Confidential, Fairfax, VA

Sr. Data Modeler/ Data Analyst

Responsibilities:

  • data manipulation and Aggregation from a different source using Nexus, Toad, BusinessObjects, PowerBI, and SmartView.
  • Participated in all phases of data mining; data collection, data cleaning, developing models, validation, visualization and performed Gap analysis.
  • Implemented Agile Methodology for building an internal application.
  • Focus on integration overlap and Informatica newer commitment to MDM with teh acquisition of Identity Systems.
  • Good noledge of Hadoop architecture and various components such as HDFS, JobTracker, TaskTracker, NameNode, DataNode, SecondaryNameNode, and MapReduce concepts.
  • AsArchitectdelivered various complex OLAP databases/cubes, scorecards, dashboards, and reports.
  • Programmed a utility in Python dat used multiple packages (scipy, numpy, pandas)
  • Involved in fixing bugs and minor enhancements to teh front-end modules.
  • Implemented Microsoft Visio and Rational Rose for designing teh Use Case Diagrams, Class model, Sequence diagrams, and Activity diagrams for SDLC process of teh application
  • Maintenance in teh testing team for System testing/Integration/UAT
  • Guaranteeing quality in teh deliverables.
  • Conducted Design reviews and Technical reviews with other project stakeholders.
  • Was a part of teh complete life cycle of teh project from teh requirements to teh production support
  • Created test plan documents for all back-end database modules
  • Performs complex pattern recognition of financial time series data and forecast.
  • Maintaining relationship with clients to achieve quality service norms by resolving their service-related critical issues.
  • Implemented teh Slowly changing dimension scheme (Type III) for most of teh dimensions.
  • Implemented teh standard naming conventions for teh fact and dimension entities and attributes of teh Logical and physical model.
  • Involved in defining teh Source To Target data mappings, business rules, data definitions.
  • Programmed a utility in Python dat used multiple packages (Scipy, Numpy, pandas).
  • Conduct complex ad-hoc analytics, summaries, and recommendations, as required.

Environment: R 3.0, Erwin 9.5, Tableau 8.0, MDM, QlikView, MLlib, PL/SQL, HDFS, Teradata 14.1, JSON, HADOOP (HDFS), MapReduce, Pig, Spark, R Studio, MAHOUT, JAVA, HIVE, AWS.

Confidential, Province, RI

Sr Data Modeler/Data Analyst

Responsibilities:

  • PerformedDataAnalysis andDataProfiling and worked ondatatransformations anddataquality rules.
  • Designed both 3NFdatamodels for ODS, OLTP systems and dimensionaldatamodels using star and snow flake Schemas
  • Created, documented and maintained logical & physical database models.
  • Involved in analysis of Business requirement, Design, and Development of High level and Low-level designs, Unit, and Integration testing
  • Performed data analysis and data profiling using complex SQL on various sources systems including Teradata, SQL Server.
  • Developed teh logical data models and physical data models dat confine existing condition/potential status data fundamentals and data flows using ER Studio
  • Identified teh entities and relationship between teh entities to develop Conceptual Model using ERWIN.
  • Developed Logical Model from teh conceptual model.
  • Worked with DBA's to create a best-fit Physical Data Model from teh logical data model.
  • Created Schema objects like Indexes, Views, and Sequences, triggers, grants, roles, Snapshots.
  • Used forward engineering to generate DDL from teh Physical Data Model and handed it to teh DBA.
  • Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions.
  • Designed STAR schema for teh detailed data marts and plan data marts consisting of confirmed dimensions.
  • Did data modeling and involved with design and development of conceptual, logical and physical data models using AllFusion Data Modeler (Erwin).
  • Performed logical data model design including normalization/de-normalization referential integrity, data domains; primary and foreign key assignments and data element definitions as applied to both relational and dimensional modeling.
  • Perform logical and physical OLAP / OLTP schema design.
  • Finalize teh naming Standards for Data Elements and ETL Jobs and create a Data Dictionary for Meta Data Management. Involved in meetings with SME (subject matter experts) for analyzing teh multiple sources.
  • Involved in SQL queries and optimizing teh queries in Teradata.
  • Developed strategies for data warehouse implementations, data acquisitions, provided technical and strategic advice and guidance to senior managers and technical resources in teh creation and implementation for data architecture and data modelling.
  • Data Profiling, Mapping and Integration from multiple sources to AWS S3/RDS/Redshift.
  • Performed data cleaning and data manipulation activities.

Environment: - MS SQL Server 2012, Oracle 12c/11g, MS office, TibcoSpotfire, Clear Quest, Clear Case, Teradata R14

Confidential

Data Modeler/ Data Analyst

Responsibilities:

  • Communicated with end users and business analysts to gather information and functional requirements.
  • Participated in requirement gathering meetings to understand teh data mart needs and expectations. s
  • Gatheird accurate data by data analysis and functional analysis.
  • Created entity / process association matrices, entity-relationship diagrams and data flow diagrams
  • Created logical data model from teh conceptual model and it’s conversion into teh physical database design.
  • Involved in teh creation of database schemas, Conceptual and Physical Data Models using Erwin.
  • Performed data profiling and analysis applied various data cleansingrules designeddatastandards and architecture/designed teh relational models.
  • Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams in Rational Rose.
  • Developed different database Objects like tables, views, materialized viewsetc. using SQL.
  • Built DDL scripts and teh view layers in Teradata database.
  • Extensively used MS Power point, Excel for teh preparation of presentations.
  • Created teh end user views according to teh business requirements.

Environment: Oracle 9i, SQL, PL/SQL, ERWIN, MS VISIO, TOAD, SQL*PLUS, HP-Unix 10.x/11, Shell.

We'd love your feedback!