We provide IT Staff Augmentation Services!

Data Architect Resume

SUMMARY

  • Extensive systems analysis experience facilitating JAD sessions attended by client Subject Matter Experts, during which IBM industry standard Data Models were customized to reflect customer - specific data governance, analytical data and reporting requirements
  • Led pre-sales team that created and presented warehouse proposals to major IBM clients
  • Experience in Data Architecture, enterprise database and data warehouse strategies, Requirements Analysis, Data Governance and logical and physical design and implementation
  • Experience in developing Project Plans, estimates, and Resource Plans for data warehouse implementation initiatives and integrating the plans into a program-level Master Program Plan
  • Experience in building and leading PMOs used to govern major data warehouse delivery programs
  • Experience mentoring team members in data-warehouse architecture and data-warehouse-specific SDLC implementation methodologies
  • Experience designing and implementing Data Governance processes
  • Master Data Management (MDM) experience
  • Data governance Target Operating Model development and implementation
  • BI Platform Target Operating Model development and implementation
  • Vendor Management
  • Data Migration, Data Integration, MDM and Data Warehouse Strategy design and development
  • Business Requirements definition
  • Solution Architecture
  • Technical delivery team building and leadership
  • Program managed the delivery of multi-terabyte data warehouses the logical data modeling and physical design of multiple distributed SQL Server transactional databases the logical data modeling, architectural design, physical data modeling and implementation of a multi-terabyte Student Loan Analysis Data Warehouse an SAP BW 7.0 Business Content install and customization in the FI/AR area for a software and services company with annual revenue  the logical and physical design and implementation of globally distributed equipment maintenance database for a major US telecom operator the requirements analysis, design and implementation of a MDM data abstraction layer for a major US mobile carrier the architectural evaluation and performance tuning of a stock trading system for a major Confidential 

TECHNICAL SKILLS

  • IBM Industry Models (TDW, IIS, BDW), Confidential Industry LDMs (Insurance Industry LDM, FSLDM, Travel industry LDM)
  • RUP, Agile, SSADM, Prince, Waterfall, Confidential Solutions Methodology (TSM)
  • Oracle Exadata, Microsoft SQL Server, IBM DB2, Greenplum
  • ERwin, Tableau, Informatica, IBM DataStage, DTS, Business Objects, Hyperion Essbase, OFSAA banking calculation engines, OBIA C, C++, J2EE, SQL, Transact-SQL, PVCS, Loadrunner, UNIX, Visio, MS Project, PowerPoint, MS Word

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Responsibilities:

  • Led analysis sessions with the business users to define the MDM business requirements
  • Designed the MDM architecture and logical and physical data models
  • Reverse engineered source systems and designed the MDM RI / data retention triggers
  • Designed a change data capture system to detect and distribute MDM changes
  • Advised and performed a quality control function on analysis and design deliverables produced by the data extraction and data migration teams.
  • Reviewed and confirmed the overall forecasting system data architecture
  • Implemented the Agile project management infrastructure to deliver the project
  • Reviewed and confirmed the enterprise data architecture
  • Consulted on the implementation of IBMs IIW industry data model
  • Trained technical staff on IBM’s anchor-style modelling techniques within IIW
  • Defined and documented the implementation approach covering the data warehouse, OLTP database and Operational Reporting database
  • Defined and documented the data model management approach

Confidential

Solutions Architect

Responsibilities:

  • Responsible for developing the solutions architecture for a pilot project that implemented a Nordea Central Data Warehouse that served Group Finance, Group Treasury and Group Capital’s regulatory and operational reporting requirements
  • Was Lead Facilitator on the business requirements gathering sessions with Group Capital and Group Treasury key stakeholders
  • Developed a data governance target operating model and defined the required processes for the Group

Confidential

Data Architect

Responsibilities:

  • Responsible for defining the Confidential EDW and ODS architecture
  • Responsible for governance on the central EDW model and for ensuring that project teams’ complied with data standards
  • Responsible for selecting and customizing an industry standard data model in order to implement an enterprise logical data model

Confidential

Program Manager

Responsibilities:

  • Led the team that designed a target operating model for the Confidential Applications Division software upgrade process.
  • Worked across multiple divisions in the US and EMEA regions to develop a project initiation, scheduling, resource allocation and tracking system that was used to initiate and track Confidential internal projects that performed software upgrades to Confidential products

Confidential

EDM Platform Delivery Program Manager

Responsibilities:

  • Led the definition of the EDM program target operating model
  • Definined and implemented the target operating model for the EDM program
  • Built the team to deliver the EDM program
  • Responsible for implementing the EDM PMO

Confidential

Data Warehouse Lead (Data Architect)

Responsibilities:

  • Led the technical design of the Oracle DataWwarehouse on the RBS Finance, Risk & Treasury (FiRST) program
  • Responsible for architectural design and integration of the Group Data Warehouse within an RBS environment consisting of multiple Confidential FSLDM-based Data Warehouses and Oracle EBS
  • Responsible for implementing the Data Warehouse component of the Oracle Financial Analytical Applications Suite (OFSAA) (Basel II, Business Events, LRM, ALM, FTP, GL Recon, Retail Credit Risk Analytics, etc.)
  • Responsible for implementing the Oracle Business Applications Warehouse (BAW)

Confidential

Executive Program Manager

Responsibilities:

  • Projects consisted of production of Korean international reporting standards, production of BASEL II reporting, production of PeopleSoft GL data feeds
  • Projects were 2nd and 3rd on Confidential ’s global list of red-condition, high-impact projects. Was the 9th PM assigned to recover the projects, which were successfully recovered and removed from the red list less than 1 month after taking responsibility, with client satisfaction indicated by a follow-on contract awarded to Confidential

Confidential

Chief Systems Engineer

Responsibilities:

  • Established a Data Architecture Review Board on the Program.
  • Initiated joint review sessions with the data modellers and business users to review changes to the implemented version of the IBM Banking Data Warehouse Model (BDW)
  • Facilitated requirements gathering sessions with key managers and executive leaders on the platform to define a Target Operating Model for the Lloyds BI Platform.
  • Target Operating Model successfully implemented, leading to the successful integration of the Lloyds and HBOS BI platforms.

Hire Now