- Featured in:
-
More Enterprise Data Architect Resumes
Use these Enterprise Data Architect samples as a guideline or visit our extensive library of customizable good resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Architecture Resume Samples
Enterprise Data Architect Resume Samples
No results found
0-5 years of experience
Lead architecture, design, and develop teams for $8 Million client data and reporting solution
- Reviewed existing warehousing models and architecture leading to new development that improved existing warehouse loading by 22% and reporting system loading by 25%
- Architected data systems, strategies and business processes operational data store and warehouse models for new reporting customer.
- Worked with all levels of external and internal business customers for requirements development
- Implemented data extraction tool using metadata to generate Extract, Transform and Load (ETL) loader code for large warehouse (VLRDB) and Operational Data Store (ODS).
- Identified capabilities and supporting applications imbalances resulting in revisions to corporate data models and reporting capabilities.
- Highlighted gaps in reporting and data management capabilities, and developed mitigation strategies.
- Developed and presented customer database to internal database loading strategy that lead to first ever direct warehouse loading project at Fetter Logic resulting in significantly shortened development and warehouse loading time.
- Designed and implemented first Fetter Logic point-in-time reporting system of which 90% of the code was generated.
0-5 years of experience
Led data model team on Data Marts (Star Schema), E-Commerce, Customer Data Management and Member Data Management Systems (Oracle 8.0x/Solaris).
- Wrote Company’s MetaData standards and practices, including naming standards, modeling guidelines and Data Warehouse Strategy.
- Analyzed business requirements and modeled the Campaign Management System (Oracle 8.0x).
- Built and tuned complex and large data load from various sources to ODS (Operational Data System), Financial Star Schema and Campaign Analysis Mart ETL (Informatica Power Center 1.7/Oracle Analytical SQL)
0-5 years of experience
AF DCGS 360 Enterprise Analytics
- Normalized personnel data received from multiple Active Air Force and Air National Guard sites across the AF DCGS Enterprise. Data Included Unit Manpower Documents, Unit Personnel Management Rosters, and Letters of Qualifications.
- Developed Troux(TM) Collectors to ingest, sort, and correlate collected data. Developed Collectors to ingest Air Force Specialty Codes, Program Element Codes, and other data needed to support personnel data.
- Analyzed collected data to help determine shortfalls in manning and training
- Developed Troux(TM) Architect models to graphically display the relationships and identified shortfalls.
- Conducted testing of AF DCGS 360 toolset.
- Developed overall structure of AF DCGS 360 User Manual using Adobe RoboHelp and HTML. Helped develop and deploy actual manual.
0-5 years of experience
Provided information systems support for the implementation of HUD’s Community and Planning Development (CPD) Data Warehouse Project in full compliance with HUD’s systems development life cycle (SDLC) standards and guidelines. The DW increments were successfully deployed which involved data requirements gathering, analysis with data modeling and database star schema design, physical database creation, data migration and loading from legacy source systems to target MS-SQL server database, front-end application customization using a vendor-provided OLAP tool.
- Defined system specifications for the extract, transform, and load (ETL) of the source-to-target data, executing data transfer using the Informatica PowerCenter tool.
- Coordinated project activities involving system users and IT development staff to ensure datamart requirements are identified and verified, and meet user specifications.
- Reviewed and updated project plans, identified and resolved issues/concerns, and coordinated completion of project activities.
- HUD’s mainframe repository (PR/MVS) was also utilized for the DW metadata management and as a data dictionary reference for end-users. The business users were also provided DW demonstrations and hands-on training.
- The data warehouse is used by the business end-users to access information on CPD grant recipients to evaluate the effectiveness of their HUD program performances. They also generated adhoc reports to perform additional business analysis.
0-5 years of experience
Developed and maintained enterprise artifacts and IT roadmaps for current systems/services.
- Provided the “As-Is” business models and data models for business units to determine “To-Be” architecture.
- Facilitated and documented evaluation of business/IT systems for an internal IT systems Audit project (As-Is vs To-Be).
- Managed RFP/RFQ/RFI to complete analysis and deployment of a web-based corporate Encyclopedia.
- Implemented a complete analysis and deployment of a web-based corporate Encyclopedia.
- Reviewed, analyzed, and evaluated business/IT systems and user requirements for the IT systems Audit.
0-5 years of experience
Designed Enterprise Data Models supporting the on-going efforts of the Treasury Department and Federal Reserve System to create a SOA (Service Oriented Architecture) deliverable. Model deliverables were created in Erwin v9.
- Created a comprehensive Project Plan (MS Project) outlining all tasks and deliverables supporting the development of an enterprise data model.
- Provided requirements analysis to ensure that various tangibles were in line with best practices and met the intent of the stakeholder.
- Created “white papers” to direct data clean-up efforts and performance enhancement recommendations in an Oracle and MS SqlServer environment.
- Provided recommendations on data gathering and analysis based on best practices and emerging technologies.
0-5 years of experience
Let the development of a very large scale (OLTP) data model for the migration of the Banks Retail Deposit application.
- Led the architecture and data modeling effort for Business Intelligence solutions for the Chase Retail Bank to include Internet Banking. Created conformed dimensions and measures. The solution was based on Oracle DB and hosted about 5 TB of data.
- Developed the target architecture and strategy for the replacement of a Retail Deposit Processing application
- Led the implementation architecture effort for a large scale, multi-year client data integration Hub project spanning multiple business units. Successfully created the reference architecture, the implementation architecture, services APIs, and data models, all of which were implemented using IBM/DWL Customer HUB technology and IBM Mainframe DB2. Managed Architects/Designers from multiple business units
- Led the Retail Bank’s enterprise information architecture (EIA) initiative. Successfully developed the Enterprise Conceptual Data Model and the logical model for Party, Product, and Account.
0-5 years of experience
Created and managed a Data Management staff of 10 with additional consultants, including database administrators, data architects, ETL and BI specialists and consultants. Managed several data conversion and data quality improvement projects.
- Led the $3 million delivery of an enterprise data warehouse using ERwin, HP/UNIX, Oracle, Toad, Informatica and Business Objects, in several iterative releases.
- Personally developed logical and physical database designs the Enterprise Data Warehouse and dimensional models for its dependent data marts using ERwin.
- Using ERwin, developed logical and physical database designs for a strategic enterprise Oracle OLTP database supporting Java-based web services applications.
- Designed real-time master data integration between the new Oracle underwriting application and the legacy IDMS underwriting system. Designed customer data integration, including match/merge rules, for all customer parties within the underwriting system.
- Designed a custom Reference Data Management system, allowing business data stewards to manage slowly-changing master data sets in registered Oracle tables used by other OLTP systems.
- Defined standards and procedures for data modeling, database design, reference data management, and ETL requirements and design.
- Developed and published the Enterprise Data Model (using ERwin), Enterprise Business Process Model and Application Strategy.
- Organized and coordinated the Data Governance Council. Recruited business executive and senior staff members, organized and chaired quarterly meetings. Framed data quality issues for discussion and resolution. Facilitated business data stewards in defining business entities and attributes and data quality requirements.
- Led the implementation of the Informatica SuperGlue metadata repository.
- Designed web-based Business Intelligence environment for reporting and analysis using Business Objects. Defined universes, related metadata and standard corporate reporting requirements. Personally trained business users nationwide in Business Objects via web conferencing.
0-5 years of experience
Created business case and performed capacity planning
- Managed high-availability 4 Terabytes relational Enterprise Data Store
- Collaborated with System architects to deploy Service Oriented Architecture (SoA)
- Designed complex data model for Subrogation, Vehicle Scoring, & Historical Parts system
- Experience with XML schemas and writing high performance queries
- Handled multiple projects and managed the delivery expectations across matrix organization
- Earned “Above and Beyond” quarterly award for excellent performance. Accredited with topmost “Outstanding” rating in performance review
0-5 years of experience
Authored the metadata for the mandatory [company name] metadata asset inventory management program.
- Analyst of the documentation produced a various stages of the application development; from planning (the need/benefit), to design , to the deployment (servers/network)
- Data modeled new functional areas (subject areas) for Enterprise Data Model
- Provided conformance to the National Exchange Information Model (NEIM) standards when developing USCIS data models for external facing system interfaces
- Assisted in the promotion of internal and/or external partnerships that improve data integration and information sharing responsiveness
- Created, updated and used documents stored in SharePoint
- Participated, with Business Architects, in gathering business data requirements and creation of supporting data models
- Created a matrix of data stewardship to business function
- Provided recommendation on alignment current data models to the Enterprise Data Model
0-5 years of experience
Current job has emphasis on communication and coordination with various State Agencies on best Data Management practices. We use Gartner Research to advise us on our efforts.
- Developed Data Principles for the State of Arkansas.
- Started work on enterprise data strategy for the State of Arkansas using the DAMA International DMBOK Framework.
- Championed couple of Master Data Management efforts.
- Educating stakeholders on the criticality of Data Governance and other Data best practices.
6-10 years of experience
Gathered, managed, prioritized and estimated requirements by working closely with customers.
- Developed project plans, ROI Analysis and managed project budgets.
- Recruited and directed data warehouse, ETL and BI development teams.
- Managed software and resource vendors.
- Developed strategic plans for overall enterprise data.
- Led End-To-End information delivery solution that ingests data from various sources, consolidates and aggregates 150 KPIs into a central data mart. These 150 KPIs were consumed by multiple business units and field team via dashboard. Played multiple roles, data architect for modeling, ingestion and integration, lead role in implementing ETL, lead role working with BI team on designing a consolidated dashboard. Estimated cost savings achieved was $700k based on timely availability of consistent information.
- Led enterprise data models development projects. Managed data architectures, data strategy, data marts (Dimensional and ODS) as well as operational data structures (3NF).
- Developed data governance model, business glossary and data standards across enterprise by working closely with development teams, DBAs, data stewards and business stakeholders.
- Led architecture development for Customer Data mart. Worked closely with marketing department, Siebel team to develop CDI-MDM strategy .This included data cleansing, de-dup, leveraged Trillium software and Acxiom vendor to improve customer data quality. Developed data quality exception reports for data stewards.
- Leading Big Data strategy effort to get better customer insights for effective marketing. It is based on using customer survey data from vendor Medallia, internal customer data and external customer data from the events.
0-5 years of experience
Developed a data architecture for the Credit Card Risk database
- Designed a solution utilizing a Pyramid DB2 parallel processing database optimized for performance
- Developed metrics for Consumer Credit Risk and integration with FDR
- Developed Master Systems for common definitions and naming
- Developed and integrated a Data Governance Program
- Utilized Summit-D to develop full project plans in an iterative manner
0-5 years of experience
Translated business data definitions to systems and applications data definitions.
- Developed an enterprise data dictionary. Defined element level business rules.
- Profiled data and mapped it to data sources through the MS BizTalk canonical.
- Developed data flow diagrams and state diagrams.
- Worked with Application DBA/Development DBA to create the logical and physical data models.
- Assessed data quality and established a data confidence index for each data source/field.
- Developed ETL (extract, load and transform) processes using SQL Server Integration Services (SSIS) to move data from application databases to enterprise data marts or to the BizTalk canonical.
0-5 years of experience
Independent consultant and then hired as Corporate Data Architect with Health Care Service Provider, responsible for consolidating and refined existing E/R Data Models, and Dimension Data Warehouse Models and physical database design. Also responsible for enterprise-wide data architecture, policy, methodology, and modeling procedures.
- OLTP Database design, and OLAP Dimensional data modeling.
- Worked with Users and I.S. Application teams in developing Process models and Data Models, business rules, and User requirements supporting Healthcare Service Request Management, and Subrogation, in money recovery initiatives.
- Developed ETL processes, criteria and templates for major conversion BC/BS process across 4 states.
- Developed business process models, business rules, Dimensional Data Models, E/R models, physical data base design at the project level and corporate integration level.
- Developed and implemented database and application for inventory control and configuration management & release of all Y2K-related hardware & application components.
0-5 years of experience
Supported Human Resources and enterprise-wide data model design
- Established Agile data modeling practice, leveraging data abstraction from physical storage based upon SOA architecture
- Participated in cross-functional work groups to assess business needs, developed a systems architecture strategy, and implementation plans for a longer term multi-tier consolidated Human Resources application integrated with SAP
- Developed and maintained enterprise-wide data management standards
0-5 years of experience
Technical lead for 5 FTE’s consisting of 1 Web Architect, 3 junior Web developers and 1 Database developer
- Accountable for highly available web and database services within all environments
- Rebuilt our development environment to leverage virtualization
- Reorganized the development cycle to be consistent and transparent to the business using Agile methods and weekly dashboards
- Supervised and rebuilt Production and Development Data Center environment
- Re-engineered Data Warehouse process lowering process time from 6.5 hours to just under 3 hours
- Architecting enterprise reporting environment to provide a suite of tools to the business and data sources that are updated frequently and highly available
- Implementing phase 1 of reporting strategy to include Data Mart for our Research team
- Developing phase 1 of Master Data Management strategy
0-5 years of experience
Data Architect on Billing System upgrade from custom solution to Oracle BRM.
- Data Architect on $18 million system modernization project for Unemployment Claims.
- Responsible for assessment and selection of enterprise BI standards and tools.
- Key member of the Data Governance team responsible for evaluation and selection of Metadata standards and tool selection.
- Responsible for the assessment and tool selection of enterprise BI and ETL tools.
- Established Standards for a multi-tiered BI platform (OBIEE, Tibco Spotfire, Jaspersoft). Standards were reduced from 16 products too 3.
- Work with domain-specific application architects, focusing on maximizing component reuse, application patterns and adherence to standards.
0-5 years of experience
Performed source data analysis, logical and physical database design for new data marts using Erwin.
- Designed and implemented ETL processes from a MVS/DB2 platform to the AIX/Oracle data warehouse.
- Completely restructured the back end environment in Oracle 8i running on AIX 4.3 for a five terabyte data warehouse application.
- Tuned for performance the load processes and business logic written in PL/SQL and sql loader for both OLTP and OLAP environments including tuning the physical Oracle database. Batch load times were critical because of the size of the loads and because of the many international time zones the application needed to be available.
- Converted the Marketing and Pricing data marts related to the nations largest retailer from Oracle 8i to Teradata v2.4.
0-5 years of experience
- Reviewed and made suggestions on the best way improve data flow from transaction systems (EPIC) to Corporate Data Warehouse.
- Worked with the team to start the rebuilding the Corporate Data Warehouse for Claims and Pharmacy. Implemented using Data Vault for improved adaption to change.
- Worked with Data Governance to build a plan to consolidate multiple master data management and metadata repositories.
- Taught Data Modeling (specifically toward Data Vault) to the Sr. Architects and developers for the Corporate Data Warehouse.
0-5 years of experience
- Provided leadership for definition, direction and guidance at CareFirst’s Data Architecture team to support the business needs.
- Lead Data Architect for the Pharmacy Benefits Manager (PBM), Medicare Part D and the Medi-Span Data Acquisition Layers.
- Conceptual, Logical and Physical data modeling using CA ERwin and ER/Studio Data Architect, Repository and Portal. Implemented naming standards for logical and physical names and translation between logical and physical entities and attributes.
- Forward and reverse engineered data models, compared and merged changes between logical and physical data models, capacity planning and volumetrics to manage and estimate the growth of data.
- Active participation during Architecture Review Board (ARB) and Solution Review Team (SRT) meetings on behalf of the Data Architecture team.
- Provided technical solutions and recommendations, engaged with ETL developers and Architects, Business SME’s and other stakeholders throughout the development of the solution.
- Worked with the DBA’s to implement and deploy the generated DDL from the physical data models and resolved outstanding issues.
- Reviewed logical and physical data models, data flow diagrams (DFD) and DDL scripts with the Data Architecture team and provided valuable recommendations.
- Conducted review meetings and JAD sessions with the Data Architecture and development teams to review LDM’s and PDM’s.
- Worked with the Data Architecture team to create a 2014 Corporate Initiative for the Hadoop Big Data proof of concept project.
0-5 years of experience
Developed enterprise-level data architectures, capability models and roadmaps
- Developed Information Capability Maturity Model (mapped to Business Capability Maturity Model)
- Developed Data Architectural Roadmap (mapped to Executive Strategic Directions)
- Designed Enterprise Data Layer (Erwin, Visio)
- Evaluated Master Data Management and Data Virtualization software
- Reverse-engineered Pearson eCollege database into local data stores (ERwin)
- Designed predictive analytic sandbox (ERwin)
6-10 years of experience
As part of a three member team, responsible for the creation of the Enterprise Data Model (single point of truth) for the entire HP Enterprise.
- Responsible for the creation of Logical/Physical data models.
- Work with Data Governance Team and Data Stewards to make sure the master data and all transactional data is defined, captured.
- Facilitate sessions on Project Charter, Requirements Analysis, Object Life Cycle analysis and Elementary Processes Specifications.
- Train IT staff on the best practices to create data models using ERwin tool.
- Work with the Business and IT to help design the database to host the Master Data and also the distribution of this across the entire enterprise.
0-5 years of experience
- Worked directly with the business teams to capture and review business requirements.
- Recruited and hired a team of data architects who were responsible for defining strategy, processes, and procedures around data modeling and management for [company name] Audit Program.
- Created multiple business level documents and communications around data and business processes, data governance, and master data management.
- Worked directly with business to define data taxonomies to classify and categorize content in order to improve data quality and optimize applications.
0-5 years of experience
Tasked with monitoring Enterprise database storage and growth of close to 70 Terabytes ultimately providing mechanism for identifying growth rates and storage needs before getting to a critical state.
- Built out replication for source databases feeding the Data Warehouse build.
- Provided desk level procedures for SQL server builds.
- Provided Naming Standards for Enterprise database development.
- Collaborated with the Data Warehouse team in rebuilding portions of the data warehouse build gaining fifteen percent on total build time to date.
- Worked with Server team on EMC storage migrations.
- Worked with Server and DBA teams to correct Snap Present issues bringing success rates of Snap Present jobs from sixty-two percent to eighty-four percent.
- Redesign of Medicare and Retirement architecture providing scaled out environments for processing smaller datasets of 2 – 4 Terabytes per database.
- Initiated and collaborated with development teams leading code reviews for technical projects.
- Worked with various development teams to clean or archive unnecessary data for daily operational tasks.
- Led Change management process for Data Warehouse team allowing for more consistent and stable releases of the Data Warehouse code builds.
0-5 years of experience
- Created frame work for MDM implementation for Customer and Supplier data across [company name].
- Created and deployed BI Solution for Data Governance/Steward team from smooth on boarding of customers in supplier and Customer Connect.
- Designed & incorporated processes, policies, guidelines for administering critical data elements in compliance with policy and/or regulatory obligations.
0-5 years of experience
- Responsible for large-scale enterprise data architecture projects
- Implemented data architecture standards for distributed databases
- Developed and maintained data models of various size and complexity for web-based and client applications using Federal Enterprise Architecture (FEA) guidelines
- Facilitated Joint Application Design (JAD) sessions to gather data requirements and educate team members on Data Architecture
- Researched, evaluated, implemented various architecture tools
- Developed UML models and XML Schemas of the Aeronautical Information Exchange Model (AIXM) 5.0 used worldwide to promote and support aviation safety for the flying public
- Produced extensive metadata and modeling documentation to assist in converting legacy databases used to maintain operational data on Airports, Runways, and Navigational Aids
0-5 years of experience
- Developed requirements for bringing pricing and orders data into Hadoop enterprise data hub.
- Worked with offshore ETL team to design Pig UDFs and use appropriate piggybank UDFs.
- Designed Hive tables using partitioning where applicable to improve HiveQL performance.
- Defined enterprise data standards for all logical/physical models under development.
- Migrated Hadoop Hive metadata to SuperLuminate data dictionary. Consolidated data dictionary company-wide.
- Developed scripts to analyze Hadoop jobtracker and tasktracker statistics and integrate the results with those of other systems, specifically Teradata.
- Validated existing Hadoop processes as part of planned migration to CDH 4.3.
Architecture Cover Letter Examples
Rate This Article
[Enterprise Data Architect]
Last edited by: Gabriela Barcenas, CPRW, Content Writer II -
Gabriela Barcenas
CPRW, Content Writer IIGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
