Rafael B. Email & Phone Number

Phoenix, Az, Us

Santa Clara, California, Us

Enterprise Solution Data Architect for the IDM 2.0 Acceleration Office (IAO), focusing on the Procure to Pay (PTP) Supply Chain. This role has responsibility for understanding data from SAP S/4 applications as well as other non-SAP systems and into the Azure Enterprise Cloud Application (ECA) as Intel transforms its business into separate production and foundry businesses, each with their own platforms and segregated data.

Redmond, Washington, Us

San Francisco, California, Us

San Francisco, California, Us

Oakland, California, Us

Contract employment working on Data Analysis and Modeling

Phoenix, Arizona, Us

Data Modeler Architect

Somerville, New Jersey, Us

Data Consultant, Bank of AmericaResponsible for analyzing legacy data flows and integrating new sources systems on a project to standardize, simplify, and automate the technology and infrastructure related to Federal Risk Assessment compliance. Utilized SQL tools (Toad Data Analyst, and SSMS) for querying, analyzing and profiling source data to establish rules for data integration. Wrote integration specifications for ETL as well as mapping documentation. Developed prototypes of SQL queries for use in extracting, merging, reconciling and harmonizing data from multiple sources. Performed Data and Process modeling using SAP PowerDesigner for different bank applications, the primary focus being data movement from assorted BMC tools (ADDM, Remedy, etc.) to an internal operational data store for data quality reporting. Responsible for extracting test data from multiple systems and performing transformation and load into a SQL Server sandbox environment using Microsoft Visual Studio for prototyping data movement and derivation logic for composite key matching. The assignment initially was for a Data Architectural role for establishment of standards and guidelines for governance of Data related deliverables (Architecture, Modeling, Data Reconciliation and Normalization).

Hanover, Md, Us

Consultant at NationWide InsuranceLead Data Analyst on project to extract, cleanse, and harmonize Customer Master Data. Responsibilities include interpretation of Enterprise Master Data requirements, creating profiles for Source System Data, analysis for determining quality of the source data, determining business rules for extraction, transformation and loading into IBM MDM XML schema, and defining mapping into IBM MDM persistent data structures. Lead Data Analyst for analysis of information related to the Nationwide effort to combine data from multiple subsidiaries into a single reporting platform for BI consumption. Responsibilities include analysis of ratings and issuance transactions in the Scottsdale Insurance Property and Casualty business lines for mapping and aggregation to ODS and EDW Dimensional models.

Santa Clara, California, Us

Data Architect/AnalystData Architect on Enterprise Information Architecture for Intel CorporationData Analyst focused on Data Warehouse reporting applications creating Dimensional Data Models, for SAP BW and Teradata platformsData Analyst and Technical Design for Transactional Data Modeling, with an emphasis on OLTP (3NF) ModelingExperienced in collecting business processes and data requirements for transactional and reporting solutions, creating functional requirements and technical detailed design documentsData Analyst, with an emphasis on design for master data in transactional and reporting applications, specific experience related to Materials and Business Partner Capability Engineering: SAP Business WarehouseMember of Capability Engineering organization responsible for implementation of SAP BW Data Warehouse at Intel, including implementation of the most recent NetWeaver 7.4 implementation for SAP BWAuthor of training material on SAP BW Data Modeling and SAP BW ETLDeveloper for standards, governance and review processes, as well as several how-to documentsTechnical Lead on projects for SAP BW development of transactional DataSources, InfoPackages, DTP and InfoProviders from ECC and CRM Source systems into SAP BWQuality Assurance: Environmental SupportProvided ongoing technical assistance in support of projects in QA environment for data landing in SAP BW from SAP CRM, ECC and SRM Transactional and Master Data sourcesBW team liaison/acceptance testing for NetWeaver 7.4 implementationContact between business users and QA teams for issue resolution between SAP ERP applications and SAP BWSAP BW Development: Business IntelligenceMember/Contributor on team that successfully rolled out SAP Business Objects at Intel with focus on WebI and Chrystal ReportsDeveloper of WebI and Chrystal Reports in support of testing InfoCubes, MultiProviders, and BEx Queries, as prototypes for end user reporting

Master Of Science, Information Technology

Bachelor Of Science (B.S.), Computer Science

Education record