We provide IT Staff Augmentation Services!

Data Architect Resume

SUMMARY:

Senior Data Architect with a progressive history of leading and / or contributing to warehouse integrations, database design, development, and support, as well as key enterprise database technology initiatives. Worked with manufacturing, finance, retail, healthcare, and state government clients. Expertise in logical, physical, and Confidential data modeling for enterprise BI solutions and traditional / big data architecture. Earned an MS degree, a designation as a Certified Terada Technical Specialist, and mastered multiple technologies.

CORE COMPETENCIES:

Data Warehouse Integration | Advanced IT Infrastructures | Information Visualization | Physical Modeling | Confidential Layer Modeling | Database Architecture | Big Data Architecture | Source to Target Mapping | Data Analysis

TECHNOLOGIES:

  • Viewpoint, OLAP Connector, Schema Workbench, Aggregate Designer, SQL Assistant
  • Business Objects | Cognos | MicroStrategy | Impala | Hive | Streamsets | Oracle, Oracle 10g | SQL Server | MySQL | DB2 | Informatica | DataStage | Ab Initio | Erwin | ER Studio | Toad | Unix | BTEQ | Sybase Power Designer | Quality Center | Source Forge | Hadoop |
  • Commercial Loan (ACBS, ALS, SHAW, CIBAR, ALL Points, APC Equipment Lease, CPI Bank, Stucky) | Mortgage (Coastal, Country Wide, ALS, CPI) | Credit Cards (TSYS) | Deposit (Impacs, Saving Time)

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect

Responsibilities:

  • Implemented single and multi - table pipelines to ingest data from SQL server to the data lake by loading 440 + SQL server tables in a new data lake structure for Confidential fraud detection reports and performing data type conversion, mapping, and quality checks for ELT using Streamsets.

Confidential

Data Architect

Responsibilities:

  • Designed logical physical data models of claims, members, and providers for a new enterprise data warehouse by implementing multiple data lake zones, generating Hive DDLs and installing in different databases, and by providing database/ETL design, logical mapping documents, and source to target transformation for EDW2.
  • Data architected to reference data management (RDM) by developing publication views for RDM end user uses, implementing Confidential bitemporal features in RDM and EDW2, and designing an Confidential backfill process for Confidential common code sets while creating access layer views for financial reporting.

Confidential

Database Administrator

Responsibilities:

  • Supported database space planning, performance tuning, viewpoint monitoring, backup, and access rights / roles.

Confidential

Consultant

Responsibilities:

  • Built a Confidential OLAP connector for sales capability project with multiple BI views with several cubes designed to support different reporting requirements by applying best practices to extract the maximum performance from the Confidential box and including UAT carried out with business users seeking defects on schema design and data quality.

Confidential

Physical Modeler And Application DBA

Responsibilities:

  • Integrated Athena collector and clinical data feeds in Confidential EDW by connecting 100+ Athena files and migrating many reporting packages from SQL server to Confidential enabling Confidential to utilize the data warehouse reporting system.

Confidential

Physical Data Modeler, Application DBA, Developer

Responsibilities:

  • Established physical data models supporting the Confidential & Confidential enterprise data warehouse primarily focused on delivering CCAR strategic federal reports integrated for the enterprise data solution.
  • Designed and implemented Banking Data Warehouse using Confidential FSLDM.
  • Referenced on the Confidential financial logical model, physicalized according to Confidential best practices, generated database objects DDLs, and supported development teams with day to day DBA tasks.

Confidential

Consultant

Responsibilities:

  • Worked on a pilot project for Confidential financial reporting requiring a POC for different reports in Cognos using Confidential by designing the access layer model for financial data access and developing a Cognos framework.

Confidential

Senior Business Intelligence Data Architect

Responsibilities:

  • Created the BI and ETL architectures for ecommerce replacement and integration using Confidential layer and Cognos framework manager for scheduled and ad hoc reports as well as designing logical and physical data models with a data modeling case tool (Erwin) and integrating departmental logical model into an enterprise logical data model.

Confidential

Senior Data Architect

Responsibilities:

  • Designed an EDW and Confidential Layer for business Intelligence by integrating product link, SOS, and VIMS in EDW.
  • Built a high level design and detail design documents for ETL and report development teams that included designing logical and physical data models for EDW, a Confidential layer for the Business Objects Universe, source to target mapping documents for ETL developers, and database migration DDLs.

Confidential

Senior Data Architect

Responsibilities:

  • Supported multiple projects for BDW integration.
  • Reviewed data models for compliance with data modeling and naming standards.
  • Created data mapping documents and DDLS for all DB objects.
  • Implemented an integrated data warehouse for multiple loan servicing systems and worked on commercial loan.

Confidential

Senior Data Architect | Data Modeler

Responsibilities:

  • Designed and implemented a BI solution for the customer information service.
  • Performed an enterprise model change impact analysis and version management.
  • Created a data dictionary, lineage, and data flow diagrams. Implemented the logical / physical data model with Sybase power designer.

Confidential

Senior Data Architect | Data Modeler

Responsibilities:

  • Delivered multiple projects including EDW design and support for AWS application development, and the development of operational data stores, data marts, staging areas, look up tables, and views for database.
  • Designed a complex conceptual data model (CDM), logical data model (LDM), and physical data model (PDM) for relational and dimensional data modeling for different applications using ER Studio.

Confidential

Data Modeler | Data Analyst

Responsibilities:

  • Worked on a new enterprise data warehouse solution for home mortgage using the enterprise origination system (EO).
  • Performed data and gap analyses for wealth management applications and developed database applications.

Hire Now