We provide IT Staff Augmentation Services!

Data Architect/ Modeler, Team Lead Resume

Dallas Tx Warren, NJ

SUMMARY:

  • 11 years of professional experience in data modeling and data analysis.
  • Proficient in gathering business requirements and handling requirements management.
  • Excellent command over Logical and Physical entity relationship data modeling using Modeling tools
  • Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments
  • Proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
  • Well versed with Data Migration, Data Profiling, Data Extraction/ Transformation/ Loading (ETL)
  • Participated in all phases of Software Development Life Cycle (SDLC).
  • Experience in data transformation, data mapping from source to target database schemas, data cleansing procedures using.
  • Knowledge of Big Data concepts, Hadoop Architecture and Hive query language.
  • Facilitated and participated in Joint Application Development (JAD) sessions, and white board sessions to keep executive staff and the team members apprised of goals, project status, and resolving issues.
  • Excellent analytical, inter - personal and communication skills with clear understanding of business process flow

TECHNICAL SKILLS:

Data Modeling Tools: Power Designer 15.2, Erwin 9.6, ER Studio, Access, Visio

Programming Languages: SQL, PL/SQL

Databases: ORACLE 11g, Netezza, DB2, MS SQL Server 2000, MS-Access Rational Suite Rational Rose, Rational RequisitePro, Rational ClearCase, Rational Clear Quest

Project Management Tools: Object Oriented Analysis and Design(OOAD) Using Unified Modeling language(UML), Rational Unified Process (RUP), MS Project, MS Visio, HP Quality Center, SVN

Data warehouse Tools: Informatica, Cognos, Oracle Warehouse Builder, SQL Developer

BI Tools: COGNOS 7.0, Business Objects 4.0/5.0/6.0 and Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential, Dallas TX / Warren, NJ

Data Architect/ Modeler, Team Lead

Responsibilities:

  • Understand the transaction data provided by various product processors.
  • Primary modeler for design of Journal record, Metadata and Reference data, Entitlements modules related to the project.
  • Perform data analysis/Investigation on the source systems for better understanding of the data and assist in data related issues.
  • Conduct knowledge sharing sessions with the Architect and SMEs and design the Data Flow Diagram.
  • Designed logical and physical data models for the different components of Finance Backbone system in Erwin Tool.
  • Ensure that the logical model follows the normalization rules and have the best possible traceability pattern.
  • Create logical and physical data models using Erwin and reviewed these models with business team and data architecture team.
  • Ensure that the data models are updated and follow the enterprise naming standards.
  • Created business data constraints, Bitmap and B-Tree indexes, sequences, partitioning etc as needed in the Physical data model.
  • Created ddls in Parquet format for deployment in Hadoop.
  • Deploy Database objects to various environments across multiple regions.
  • Create custom views in Data Access layer for consumption by downstream applications.
  • Created Source to Target mapping documents for any new source data.

Environment: Erwin r8, Oracle, Netezza, SQL Developer, Informatica, EBX5, Microsoft Visio, HPQC, SVN

Confidential, Dover, NH

Data Modeler

Responsibilities:

  • Understand the application and Business requirements for the enhancements of ARMMS Application.
  • Conduct knowledge sharing sessions with the Architect and SMEs and design the Data Flow Diagram.
  • Identify all the data architecture tasks involved and provide detailed estimates accordingly.
  • Updated logical and physical data models using Erwin and reviewed these models with application team and data architecture team.
  • Supported the DBA in the physical implementation of the tables in DB2 environment.
  • Ensure that the data models are updated and follow the enterprise naming standards.
  • Created business data constraints, indexes, sequences etc as needed in the Physical data model.
  • Created Source to Target mapping for the new fields as user defined properties in Erwin data model.
  • Converted SilverRun data models into Erwin data models.

Environment: Erwin r7, DB2, Teradata, DbVisualizer, Informatica, Microsoft Visio, windows 7, SilverRun, Notepad++.

Confidential, St. Louis, MO

Data Modeler

Responsibilities:

  • Part of the Confidential Data Management team and responsible for design and implementation of Brokerage ODS and Warehouse environments.
  • Understanding the business requirements from various brokerage application teams and updating the ODS for capturing any new transactional data elements and DW for any new reporting needs.
  • Reviewed the application business requirements and created the Functional Data Requirements document highlighting the changes needed within the Data Management team for the successful completion of the project.
  • Created new conceptual, logical and physical data models using Erwin and reviewed these models with application team and modeling team.
  • Conducted impact analysis for the proposed changes with various application teams.
  • Created SSA Documents for each new or updated table and reviewed the document with ETL Tech Lead. The document includes Source to Target mapping, Data selection criteria and transformation logic
  • Performed analysis to identify if there are any data gaps and issues within ODS and BDW which might be of concern to the project and resolve it.
  • Created the DDL and DML scripts and supported the DBA in the physical implementation of the tables in both Oracle and DB2 databases.
  • Created business data constraints, indexes, sequences etc as needed in the Physical data model.
  • Supported the ETL and Testing teams with any issues identified during the lifecycle of the project.
  • Created the file layouts for any new data being received or extracted from ODS and BDW. Reviewed these file layouts and handed over to the Central File Distribution team

Environment: Erwin r7, Oracle, DB2, Toad, Teradata, Informatica, Documentum, Microsoft Visio, windows XP.

Confidential, St. Louis, MO

Data Modeler / Architect

Responsibilities:

  • Involved in the projects from requirement analysis to better understand the requirements and support the development team with a better understanding of the data.
  • Did the impact analysis for multiple projects from a data modeling prospective.
  • Designed logical and physical data models for multiple OLTP and Analytic applications.
  • To Design the logical Model and ensure that it follows the normalization rules and have the best possible traceability pattern
  • Developed the Star Schema/Snowflake Schema for proposed warehouse models to meet the requirements.
  • Supported the DBA in the physical implementation of the tables in both Oracle and DB2 databases.
  • Performed Reverse Engineering of the current application using Erwin, and developed Logical and Physical data models for Central Model consolidation.
  • Created business data constraints, indexes, sequences etc as needed in the Physical data model.
  • Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents and analyzing the database using SQL queries.
  • Resolved the revolving issues by conducting and participating in JAD sessions with the users, modelers and developers.
  • Designed class and activity diagrams using Power Designer and UML tools like Visio
  • Resolved multiple Data Governance issues to support data consistency at the enterprise level.
  • Created Party model for Enterprise Data Repository(EDR) designed to support the enterprise data needs for multiple applications across the organizations.
  • Involved in physical transformation and Load of data for multiple Projects.
  • Simultaneously handled multiple projects from various groups across Mastercard.
  • Responsible for ensuring and providing consistent metadata across all the models in MasterCard.

Environment: PowerDesigner 10/12/15,Erwin r7, Oracle (9i,10g,11g), DB2, SQL Server 2000, Toad, DataStage, Microsoft Visio 2003, windows XP, Notes.

Confidential, Burbank, CA

Data Modeler / Analyst

Responsibilities:

  • Responsible for understanding the use cases and business rules and make the appropriate changes to the data model.
  • Redesigned some of the subject areas and introduced new entities and attributes as per the requirements.
  • Interacting with business analyst to understand the ITDS process and updating the use cases as discussed with the users.
  • Was responsible for the design of report mockups and the data mapping related to those reports.
  • Used Erwin to transform data requirements into data models.
  • To design the transactional database up to the fourth normalization.
  • Conducted User Acceptance Testing on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review.

Environment: Sybase, Erwin, Microsoft visual studio 2005, Microsoft Visio 2003, windows server 2003.

Hire Now