Data Architect Resume Samples

Description :

1. Manage data and determine clinical functions that are suitable to build to ensure alignment with professional standards of clinical practice.
   
2. Performing, identifying needed process changes, and developing future workflows related to the implementation of new solutions or functionality.
3. Responsible for working to analyze, design, build, deliver and maintain Meta data, BI dashboards and other data extracts requested.
4. Data models and architecture across the entire EMR, PLSQL table queries and design.
5. Strong analytical and problem-solving skills and a willingness to work at a detailed level.
6. Design methodology to meet client (internal/external) information needs for feasibility assessment.
7. Provide technical and operational support in the delivery of custom data extracts.

Experience

5-7 Years

Level

Executive

Education

Bachelor Of Science

Description :

1. Implemented Producer Release project where primary policy, producer, financial, customer and product information is processed to a new system which consists of the BOR, Data warehouse, and Producer Data Mart.
2. Responsible for developing the implementation strategy for SBNR, Intracorp and Producer.
3. Involved in discovery sessions to collect information about FACTS, IMAGE, and ICS source systems and performed extensive data profiling on the information contained in those systems.
4. Designed logical, physical and dimensional data model for Producer book of records and data mart respectively on Image Commission, Producer and Policy information.
5. Designed the Intracorp Vendor Information System that provides claim information to vendors.
6. Designed for processing huge volumes of 10 Terabytes sixe and estimated growth of 10% per year.
7. Developed and established high-level data flow diagram, data standards, and naming conventions and evaluated the consistency and integrity of the model and repository.
8. Performance tuning for ETL code, stored procedures and SQL query optimization and process automation.

Experience

7-10 Years

Level

Consultant

Education

Master Of Science

Description :

1. Designed enterprise data management strategies and standards.
2. Primary contact for data management engagement on strategic company initiatives, and cross-departmental project, contributing to design decision, documentation, and information.
3. Developed common, logical and physical data models and XSD and JSON schemas for SOA and Restful Web Services.
4. Delivered data cleansing solutions, data lineage diagrams, mapping and transformations rules, data integrity solutions for applications, conversion, integration, and production support issues.
5. Created common naming and ubiquitous language for data elements which enabled integration, communications and clarity between applications by composing, establishing, publishing, and socializing models and definition standards.
6. Improved visibility and understanding of enterprise data to business and development teams by initiating and creating DA home page on confluence; highly received and valued by teams.
7. Conducted and made recommendations on Data profiling and modeling tools.

Experience

2-5 Years

Level

Junior

Education

Computer Science

Description :

1. Provided logical and physical data modeling, data profiling, and data mapping support for Maersk's Enterprise Logical Data Model and Enterprise Data Warehouse projects.
2. Performed data profiling on existing data sources in Teradata, Oracle, and MS SQL Server environments.
3. Created conceptual, logical and physical data models using CA/ERwin Data Modeler.
4. Created data mapping documents for movement of data from various sources into the data warehouse.
5. Mentored less experienced data modelers in modeling techniques and use of CA/ERwin Data Modeler and CA/ERwin Model Mart suite of modeling tools.
6. Participated in and led schema design peer review sessions, client reviews, and technical reviews with development resources.
7. Created Teradata Data Definition Language (DDL) script based on physical data models, and ran the scripts in the development database environment for creation of the development database.
8. Consulted with DBA group on database performance tuning efforts.

Experience

5-7 Years

Level

Executive

Education

Bachelor Of Science

Description :

1. Analyzed data sources, requirements, and business rules to perform new Logical and Physical Data modeling.
2. Worked on identifying dimensions, facts, and various other concepts of dimensional modeling, which are used for data warehousing projects.
3. Used Reverse Engineering approach to analyze the table structure.
4. Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible with business requirements.
5. Design high level conceptual business/data models, relational and dimensional logical data models, and detailed physical database design models.
6. Normalized the relational logical model to 3rd normalization and contains both current and history tables.
7. Divided data model in number of sub models for the ease of understanding and comprehension.
8. Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions.

Experience

5-7 Years

Level

Executive

Education

MBA

Description :

1. Joined Aquent as a consultant in the area of data architecture and data analysis.
2. Assigned as a data architect using data analysis techniques and data modeling tools, such as Erwin for a high-profile application in-house development project for GC Services.
   
3. Gathered and analyzed the data requirements and designed a database solution for a project that replaced several legacy mainframe systems.
4. Included: Designing overall company data architecture using enterprise data entities and models.
5. Reconciling and integrating individual application data models with the enterprise data model.
6. Creating new enterprise data designs for transactional (OLTP) systems, data warehouses, and data marts.
7. Collecting and managing project data elements and attributes in metadata dictionaries and repositories.

Experience

7-10 Years

Level

Consultant

Education

Computer Science

Description :

1. Lead data Architect for MDM and EDW solutions to provide DataMart solutions for retail business using Teradata & DataStage.
2. Participated in Architecture of ERWIN data model to Physical and logical data models for HR systems under heterogeneous platforms - mainframe & PeopleSoft.
3. Meet with business stakeholders and other technical team members to gather and analyze application requirements Provide first level Consultant support for Conceptual/logical/Physical datadesign.
4. Developed and implemented data migration and upgrade procedures for databases.
5. Led the data modeling/data warehouse/ETL team in developing a prototype and detailed design for a large system Provided general data modelling, database programming and administration support for application developers.
6. Involved in developing and designing IBM WebSphere MQ series messaging apps for Lowes HR and Lowes portal.
7. Part of the team in instituting Corporate Logical Model design standards.

Experience

7-10 Years

Level

Consultant

Education

IT Technology

Description :

1. Created source views for implementing ETLs.
2. Coordinated the analysis, design and long term build-out of complex enterprise information architectures.
3. Assisted in developing system requirements, analyzes transactions and data volumes, and designs & develops complex databases and applications Participated in large-scale development initiatives including product selection and implementation.
4. Researches and recommends optimal design criteria and best utilization of resources.
5. Lead reviews and participated in the development of quality entity-relationship diagrams, data flow diagrams, database normalization schemas, logical to physical database mapping, data table parameters, etc.
6. Conversion of the Historical Data to bring in R12 data for Warranty and Claims.
7. Designing the reporting framework for creating Dashboard and BI Publisher Reports.

Experience

5-7 Years

Level

Executive

Education

Bachelor Of Engineering

Description :

1. Lead and apply best practice to Data Modeling, Data Mapping, Data Anomalies, and Data Discrepancies analysis.
2. Design and develop data analysis applications that interface with a variety of large scale enterprise applications on large volume dataset.
3. Define and maintain the architectural frameworks/patterns, processes, standards and guidelines related to systems, business, and data architecture.
4. Provide technical and architectural expertise to various development teams, communicate architectural decisions, and mentor other technical staff around various development technologies and decisions.
5. Define core technology, data entities, business functions and/or subject areas.
6. Identify core common data shared across the enterprise and participate in enterprise wide efforts to reach common understanding of those data.
7. Conduct studies of new technologies to provide more efficient and cost effective architecture solutions.

Experience

2-5 Years

Level

Junior

Education

M.S. In Computer Engineering

Description :

1. Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions Gathered business requirements, working closely with business users, project leaders and developers.
2. Analyzed the business requirements and designed conceptual and logical data models.
3. Using Data Vault Methodology Developed normalized Logical and Physical database models for GM Financial Applications.
4. Owned and managed all changes to the data models.
5. Created data models, solution designs and data architecture documentation for complex information systems.
6. Effectively articulated reasoning for data model design decisions and strategically incorporated team member feedback to produce the highest quality data models.
7. Worked with reverse engineering Data Model from Database instance and Scripts.
8. Based on TRD Document Designed and implemented Informatica ETL solutions.

Experience

5-7 Years

Level

Executive

Education

Computer Science

Description :

1. Analyze source systems and its data and involved in data profiling activities, which covers the originations, servicing and default subject areas of the mortgage life cycle.
2. Created logical and physical data models by adhering to the Dimensional/Third Normal Form (3NF) data modeling principles, Enterprise data modeling guidelines and MISMO standards.
3. Collaborate with enterprise architects, Platform DBA's and data modelers in designing the enterprise level data models.
4. Designed and modeled various ODS on SQL Server and DB2.
5. Participate in Data modeling peer review forums and assisted in resolving the modeling issues faced by other modelers.
6. Contributed in firming up the enterprise modeling standards and guidelines.
7. Created various Conceptual Models for different Line Of Business (LOB) to articulate the business process and flow.

Experience

7-10 Years

Level

Consultant

Education

Computer Science

Description :

1. Designed, modeled and maintained BNA publishing system logical and physical models.
2. Responsible for migration of data out of the STAR system to the oracle database.
3. Designed the logical and physical data models, provided data flow diagrams, transformation logic, source to target data mapping spreadsheets, data dictionary, etc.
4. Actively involved in redesigning regulation central application database.
5. Worked on various applications at BNA and provides enterprise data solutions.
6. Worked closely with data analysts, DBA and application developers.
7. Created sequences, Triggers, indexes, constraints and views as part of a physical data model using ER-Win and provided model change ER-Win scripts.

Experience

5-7 Years

Level

Executive

Education

M.S. In Computer Science