We provide IT Staff Augmentation Services!

Sr. Data Modeler/data Analyst Resume

2.00/5 (Submit Your Rating)

Fairfax, VA

SUMMARY

  • Over 7+ Years of IT experience in various fields of Data & Business analysis, Data Modelling and ETL Development.
  • Experience in Business and Data analysis, Data Migration, Data Quality, Data Profiling, Data Governance, Data Integration, Meta Data Management Services and Configuration Management.
  • Involved in specifications of Data Mapping for creating and executing detailed system test plans. Data mapping helps in specifying of what data will be extracted from an internal warehouse, transformed and sent to external data.
  • Used SQL for querying the database in UNIX environment.
  • Experience in Database Programming SQL & PLSQL, MS Access, Oracle 12c/11g/10g/9i, XML, DB2 Teradata, Database Tuning and Query Optimization.
  • Well experience in creating data driven subscriptions by using SQL, good knowledge in creating Ad - hoc reports well usage of SQL Queries for pulling out data from the tables.
  • Good in writing analytical SQL Queries, Complex Transact SQL (T-SQL) Queries, Co-Related Sub Queries for analyzing of data, validating data and quality checks.
  • Well expertise in using ERWIN, Embarcadero E-R Studio & Power designer for developing Physical, Logical and Conceptual models.
  • Worked extensively on ERWIN tool with all features like REVERSE and FROWARD Engineering, Naming Standards documentation, Domain, Subject area and etc.
  • Expertise in Extracting, Transforming and Loading (ETL) data from database tables, spreadsheets and other sources using Microsoft Data Transformation Services (DTS) and Informatica.
  • Experience of Business intelligence tools like Tableau and Qlikview for visualizing of data.
  • Well driven exposure of data analysis using SAS and MS Excel.
  • Good knowledge of project development life cycles like Waterfall, Agile TDD & XP.
  • Managed full project of SDLC process which involved in requirement management, sources data analysis, meta data management, data mapping, data quality, workflow analysis, maintenance of the model and testing strategy.
  • Knowledge of OLAP, Dimensional Data Modelling, Operational Data Store (ODS) Snow-flake Modelling for Dimensions Tables using Analysis services and FACT.
  • In depth experience in all phases of SDLC: Requirements Gathering, Analysis, Design, Development, Testing, Implementation (Production) and Maintenance Support (Post Production)

TECHNICAL SKILLS

Languages: PL/SQL, T-SQL, Java scripting and Unix Shell Scripting

Databases: SQL Server 2012/2008/2005 , MS Access, Oracle 11g/10g/9i, Teradata 14.0

Data Modelling Tools: ERWIN, ER Studio, Clear Quest, MS Visio, Rational Rose

ETL Tools: Informatica Power Center 8.6/7.1/6.2

Dash boarding & Reporting Tools: Qlickview, Tableau, SAP Business Objects, Crystal Report, Xcelsius, SSRS

Bug Tracking: IBM ClearQuest, Jira

Operating Systems: Microsoft Windows 8.1/7/ Vista/ 7, UNIX, DOS

Methodologies: Agile/Scrum & Waterfall

PROFESSIONAL EXPERIENCE

Sr. Data Modeler/Data Analyst

Confidential, Fairfax, VA

Responsibilities:

  • Interacted with End user community, external vendors to understand the business requirements and in identifying data sources.
  • Worked closely with different vendor systems as a part of claims and external data source related to data warehousing projects.
  • Identified entities and attributes and developed conceptual, logical and physical models using ERWIN.
  • Worked for cleansing and organizing various tables in a presentable manner to help with better understanding of already existing models.
  • Produced Pdfs for various models (logical and physical) to ensure communication with different teams (DA, ETL, IA, and Development)
  • Handled and maintained model versioning using ERWIN.
  • Worked with the Reporting Analyst and Reporting Development Team to understand Reporting requirements.
  • Produced customized data definition reports for smooth coordination between various teams associated in a project.
  • Generated various presentable reports using report designer and pinned reports in ERWIN.
  • Created documentation for custom reports using report designer in ERWIN.
  • Designed the Data Marts using Ralph Kimball's methodologies using ERWIN.
  • Worked extensively with understand, developed, cleansed, maintained and entered metadata for various new as well as existing models.
  • Generated customized report solutions for metadata reports.
  • Conducted design reviews and validated data models and was involved in MDM (Master Data Management)
  • Designed different type of STAR schemas using ERWIN with various Dimensions like time, services, customers and FACT tables for Claims related project.
  • Reversed Engineered the existing database and based on Functional Design Specification (FDS) updated and optimized the existing star schemas to satisfy the reporting requirements.
  • Created Source to Target mappings and Transformations. Mapped data between Source and Targets.
  • Worked closely with DBA's as a part of various database change requests.
  • Involved in documentation of Data Mapping and ETL specifications for Data warehouse.
  • Involved in Indexing and Partitioning of Database.
  • Interacted with QA team in their testing of Data warehouse.
  • Coordinated with DBA's and generated SQL code from the data models and generated DDL scripts using forward engineering in ERWIN.

Environment: ERWIN 9.5, oracle 11g, SQL, MS Excel, Tableau, TOAD, Crystal reports 9.

Data Modeler

Confidential, Indianapolis, IN

Responsibilities:

  • Gathered requirements and created ER (entity-relationship) diagrams as part of requirements analysis using ERWIN.
  • Used forward engineering to develop sound Physical Data Model by implementing referential integrity, database rules, super types and sub types.
  • Created dimensional model for the reporting system by identifying required dimensions and facts using ERWIN.
  • Worked on the Snow-flaking the Dimensions to remove redundancy.
  • Maintained warehouse metadata, naming standards and warehouse standards.
  • Ensured the quality, consistency, and accuracy of data in a timely, effective and reliable manner.
  • Involved in the mapping of data sources and analytics, with the goal of ensuring data quality.
  • Designed the data marts using the Ralph Kimball's Dimensional Data Mart modelling techniques.
  • Identified the Facts and Dimensions.
  • Created documents for logical, physical and dimensional data models.
  • Created logical, physical dimensional models using ERWIN.
  • Implemented Referential Integrity using primary key and foreign key relationships.
  • Created physical data models using forward engineering principles.
  • Co-ordinated with QA team to test and validate the reporting system and its data.
  • Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.
  • Worked with Database Administrators (DBA's) to finalize the physical properties of the tables such as Partition key.
  • Involved in extracting the data using SSIS from OLTP to OLAP.
  • Used various kinds of Data sets with SSRS.
  • Implemented slowly changing dimensions Type2 and Type3 for accessing history of reference data changes.
  • Provided source to target mappings to the ETL team to perform initial, full, and incremental loads into the target data mart.
  • Create and deploy reports using SSRS.

Environment: SQL Server 2008, SQL Server Analysis Services 2008, SSIS 2008, SSRS 2008, Crystal Reports7.5/8.0, Windows 2000, Micro strategy 9.3, Crystal Enterprise8.0, Erwin, power designer, CSV files, XML files, Business Objects, Oracle10g.

Data Modeler/Data Analyst

Confidential, Fishers, IN

Responsibilities:

  • Interacted with business users to identify and understand business requirements and identified the scope of the projects.
  • Identified and designed business Entities and attributes and relationships between the Entities to develop a logical model and later translated the model into physical model.
  • Developed normalized Logical and Physical database models for designing an OLTP application.
  • Enforced Referential Integrity (R.I) for consistent relationship between parent and child tables.
  • Reverse Engineered the Data Models and identified the Data Elements in the source systems and adding new Data Elements to the existing data models.
  • Created XSD's for applications to connect the interface and the database.
  • Compare data with original source documents and validate Data accuracy.
  • Used reverse engineering to create Graphical Representation (E-R diagram) and to connect to existing database.
  • Conducted sessions with architects, business and development teams to understand the Change Requests (CR's), and effects caused on the system by the change requests.
  • Maintained and updated Metadata repository based on the change requests
  • Used Forward engineering to develop physical model with DDL based on the requirements gathered from a logical model in ERWIN.
  • Checked for all the modelling standards including naming standards, entity relationships on model and for comments in the model.
  • Conducted design walk through with project team and got it signed off.
  • Created entity / process association matrices, entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
  • Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
  • Involved in Data Mapping activities for the data warehouse
  • Extensively worked on Performance Tuning and understanding Joins and Data distribution.
  • Executed DDL to create databases, tables and views.
  • Experienced in generating and documenting Metadata while designing application.
  • Coordinated with DBAs and generated SQL codes from data models.
  • Generate reports for better communication between business teams.

Environment: ERWIN 8.2, Oracle 11g, Teradata, Crystal Reports, Toad, Windows OS, DB2, SSRS, Business objects, SQL Server 2008

Data Modeler

Confidential, Fishers, IN

Responsibilities:

  • Gather the various requirements from the business analysts.
  • Gather all the Sales analysis reports prototypes from the business analysts belonging to different Business units; Participated in JAD sessions involving the discussion of various reporting needs.
  • Reverse Engineering the existing data marts and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
  • Conduct Design discussions and meetings to come out with the appropriate Data Warehouse at the lowest level of grain for each of the Dimensions involved.
  • Designed a STAR schema for sales data involving shared dimensions (Conformed) for other subject areas using Erwin Data Modeller.
  • Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
  • Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
  • Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
  • Ensured the feasibility of the logical and physical design models.
  • Worked on the Snow-flaking the Dimensions to remove redundancy.
  • Identified and tracked the slowly changing dimensions (SCD I and II) and determined the hierarchies in Time and Branch Dimensions.
  • Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically.
  • Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
  • Worked closely with the ETL Developers to explain the complex Data Transformation Logic.
  • Employed naming standard editor for defining new naming standards for the entities, attributes, domains, columns and tables that applied consistently all over the enterprise.
  • Implemented slowly changing dimensions Type2 and Type3 for accessing history of reference data changes.
  • Provided source to target mappings to the ETL team to perform initial, full, and Incremental loads into the target data mart.

Environment: SQL Server 2008, SQL Server Analysis Services 2008, SSIS 2008, SSRS 2008, Crystal Reports 7.5/8.0, Windows 2000, Micro strategy 9.3, Crystal Enterprise8.0, Erwin, Informatica Power Centre, power designer, CSV files, XML files, Business Objects, Oracle10g.

Data Modeler/SQL Developer

Confidential, El Segundo, CA

Responsibilities:

  • Created logical, physical and dimension models.
  • Optimize and update logical and physical data models to support new and existing data models
  • Recommended opportunities for reuse of data models in new environments
  • Perform reverse engineering of physical data models from databases and SQL scripts.
  • Validate business data objects for accuracy and completeness
  • Created entity diagrams and relationship diagrams and modelled cascade to maintain referential integrity.
  • Wrote store procedures and triggers.
  • Added database objects (like indexes, partitions in oracle database) for performance.
  • Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business users.
  • Added database objects (like indexes, partitions in oracle database) for performance.
  • Performed extensive requirement analysis and developed use cases and Workflow Diagrams.
  • Documented and delivered functional specification document to the project team.
  • Analysed existing logical data model (LDM) and made appropriate changes to make it compatible with business requirements.
  • Resolved the data type inconsistencies between the source systems and the target system using the mapping documents and analysing the database using SQL queries.

Environment: ERWIN r8.2, SQL, SQL Server 2000/2005, Rational Rose, Windows XP, Oracle 8i, Windows XP/NT/2000

PL/SQL Developer

Confidential

Responsibilities:

  • Responsible for designing, developing and delivery of Functional Specifications and Design Documents.
  • Worked with different team to provide them with the essential stored procedures and packages and the required access to the data.
  • Created assessment table to record the UPDATEs and INSERTs on the tables by creating database triggers.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Generated SQL and PL/SQL scripts to install create and drop connection database objects including tables, views, primary keys, indexes, constraints, grants and synonyms.
  • Coded and implemented PL/SQL packages to perform batch job scheduling.
  • Data design for time module.
  • Used EXPORT/IMPORT to do table level and full database defragmentation.
  • Data conversion and integration of front end application to the data warehouse using SQL, PL/SQL and Stored Procedures.
  • Used ErwinEnterprise Data modeller Suiteto enforce naming, data type and referential integrity standards,tocapturebusiness definition of entities and data element.
  • Responsible for Reviewing Product Documents and Test Documents (Test Plans and Test Cases) from Document and QA teams.
  • Tested and promoted code from DEVELOPMENT through QA, UAT to PRODUCTION.
  • Evaluated requirements from functional specifications to create efficient technical design.
  • Developed complex technical objects in accordance with the technical development standards and best practices.
  • Responsible to test the modules for load testing, memory leaks and performance.
  • Validated and loaded data into Oracle Database using DB links and external tables from CSV files.

Environment: Oracle 8i, PL/SQL, SQL *Loader, Toad 9.1, Putty, Erwin Data modeller, Visio, Data Flux, UNIX, Windows XP

We'd love your feedback!