We provide IT Staff Augmentation Services!

Bi Data Architect / Data Modeler Resume

Dallas, TX

SUMMARY:

  • 14 years of professional experience in data architecture, data modeling and data analysis.
  • Highly effective Architect specializing in implementing an end - to-end architecture and design for Enterprise solutions.
  • Proficient in gathering business requirements and handling requirements management.
  • Excellent command over Logical and Physical entity relationship data modeling using Modeling tools.
  • Proficient in data analytics on Hadoop big data platform using Hive and Impala.
  • Knowledge of NoSQL databases like Cassandra and MongoDB.
  • 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 Conversions, 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.
  • 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.

SKILL:

Data Modeling Tools: Erwin 9.8, ER Studio Data Architect 17, Power Designer 15.2, Access, Visio

Programming Languages: SQL, HQL, CQL

Databases: ORACLE 11g, SQL Server 2016, Cassandra, Netezza, DB2

Project Management Tools: TFS, MS Project, MS Visio, HP Quality Center, SVN

Data warehouse Tools: Informatica, SQL Developer, Apache Hive, Hue

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

BI Data Architect / Data Modeler

Responsibilities:

  • Analysis identifying the patients and practices being served through the various patient and practice engagement platforms of Confidential like 4PatientCare, Shadow Vision etc.
  • Building a fuzzy logic to uniquely identify the patients and practices across various systems and building the record accordingly in the integrated hub.
  • Identifying the booking and appointments made by the patients in various patient care systems and finding the corresponding the transactions and revenue resulting from those bookings in GPN system.
  • Analysis of the website traffic data from Google Analytics for the various brand sites of Confidential like AAV, EOA, EBD etc.
  • Corelating google analytic data with the patient exams and purchase revenue and building various dashboards needed for analytics and marketing.
  • Build patient end-to-end journey dashboard and identifying the various data fallout points currently occurring and working with business teams to address these data fallouts.
  • Build the data models and stored procedures needed to capture the consolidated data regarding patient, practice, bookings, purchases and website traffic into the integrated hub.
  • Build the analytic tables and stored procedures required to ingest data for the Business Intelligence dashboards.

Environment: Erwin 9.8, Oracle 12c, SQL Server 2016, SQL server management studio, SSIS, Google Big Query, Tableau.

Confidential, McKinney, TX

Data Architect / Data Modeler / Governance Analyst

Responsibilities:

  • Understand the existing applications and processes by working with subject matter experts and data stewards.
  • Coordinating with data stewards in identifying the key master data elements and building enterprise business definitions for these elements.
  • Conducted design review sessions with Business and Subject matter experts. Identify and document current and future state of enterprise data architecture.
  • Participate in the review of Business requirements and understand the data needs for the project and document the data scope related to the business requirement.
  • Architect Enterprise data model for data warehouse to accommodate multiple business processes and subject areas.
  • Architect solutions for insights into historical data for data governance and advanced analytics using informatica Data Quality suite. Also create data dictionary and data lineage documentation and get approvals from governance team.
  • Working with Data owners and Data stewards in designing and development of data quality and validation rules.
  • Analysis of Source data from Mainframes and OIPA (Oracle Insurance Policy Admin System).
  • Mapping of the source data to ACORD data model for Life insurance and building the ODS based on the life insurance industry standards provided by ACORD.
  • Create the Functional Data Requirements document highlighting any data related challenges that must be addressed for the successful implementation of the project.
  • Created new conceptual and logical data models using Erwin and reviewed these models with application team and modeling team.
  • Ensure that all the business definitions, data quality and data validation rules are captured in the Data model.
  • Build physical models for implementation in multiple database environments.
  • Lookup code standardization for converting source values to industry standard values wherever possible.
  • Implementation of the model for building Data Lake in Hadoop HDFS.
  • Performed data analysis and also built business glossary using Informatica IDQ.
  • Created Source to Target mapping documents for the new physical tables to support ETL transformations.

Environment: Erwin 9.8, ER Studio Data Architect 17, Oracle 12c, SQL Server 2016, SQL Developer, Informatica IDQ, TFS.

Confidential, Irving, TX/ Warren, NJ

Data Architect / Data Modeler, Team Lead

Responsibilities:

  • Understand the transaction data provided by various product processors.
  • Primary modeler for design of Journal record, Metadata and data, Entitlements modules related to the project
  • 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.
  • To Design the logical Model and ensure that it 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.
  • Perform data analysis/Investigation on the source systems for better understanding of the data and assist in data related issues.
  • Deploy Database objects to various environments across multiple regions.
  • Designing of the journal and sub GL table structures in Netezza.
  • Create custom views in Data Access layer for consumption by downstream applications.
  • Created Source to Target mapping documents for the new physical tables

Environment: Erwin r8, SQL, HQL, 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 Advisors 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, Informatica, Documentum, Microsoft Visio, windows XP.

Confidential, St. Louis, MO

Data Modeler

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 Confidential .
  • Responsible for ensuring and providing consistent metadata across all the models in Confidential .

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

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