SUMMARY

• Oscar is a Senior BI Consultant, Data Architect and technical lead. He has strong expertise in Data Migrations, Master Data Management, Data Analysis, and Data Modeling with 18+ years of Information Technology experience.
• He has been successfully involved in challenging MDM, Data Warehouse and Business Intelligence development full lifecycle, Data and Application Migrations. His proficiency with SDLC Methodologies including:
• Agile Software Development with Scrum methodology (Scrum)
• Rational Unified Process *RUP as a methodology for development (RUP)
• Iterative Methodology (IM)
• PMI Methodology
• He understands business challenges and translates them into process/technical solutions, as well as manages client relationships within context of individual role.
• Oscar has excellent interpersonal skills and is well liked as a team lead and is a highly valued team member.

RELEVANT EXPERTISE

• Best practice model design for Master Data Management
• Align data across systems improving operational and reporting consistency
• Manage critical hierarchies and master data attributes
• Comprehensive data cleansing
• Data Quality
• Data synchronization
• Data integration
• Profisee Maestro (Certified)
• Metadata Architecture to support analytical Metrics/KPI/Dashboard
• ETL implementation
• Multi - dimensional data model w/ Star Schema, Facts/Measures, & Aggregation processes
• Multi-Platform data sourcing, w/ ETL strategies, multi-dimensional optimization, & data mart deployment
• Development based in teh BI Lifecycle
• BI Tuning and Best practices for ETL and Reporting
• Data modeling using Snowflake and Star models
• Experience using Statistical Analysis to predict behavior
• Experience in designing Data marts
• Designing processes combining incremental and historical data to enhance performance based on teh business needs

PROFESSIONAL EXPERIENCE

Senior MDM Consultant & Data Architect

Confidential, Houston, TX

Responsibilities:

• Member of teh Cross Architect Team devoted to review and provide guidance in teh different areas of teh organization.
• In charge of engineering a solution to feed and process an Enterprise DWH, and an Oracle DB using a Master Data repository in SQL Server MDM. One of teh challenges faced was teh use of synchronization of these two different systems using pure Stored Procedures and Oracle Data Connector Technology.
• Provide end-to-end solutions including: Data Acquisition, Data Cleansing and Standardization, Mastering and publishing of all domains of interest:
• Geographically Reference Domain
• Wells & Fields
• Suppliers
• Vessels
• Universities
• Chart of Accounts
• Design and implementation of ETL lifecycle including teh use of Staging and Landing areas to create a persistent and auditable copy of all data for auditing and legal purposes.
• Management of Match and Merge strategies using Master Data Maestro from Profisee™, in order to identify duplicated elements among teh different domains, mainly in Suppliers and Wells&Fields.
• Address Verification and Standardization using Profisee™ tools.
• In charge of Governance process for:
• Assisting data stewards to determine teh de-duplication strategies.
• Rules to be applied to manage de-duplicity.
• Intensive use of MS SSIS and T-SQL stored procedures in order to extract and transform data.
• Development of web services to provide automated integration among teh domains.
• Data profiling using SSIS and T-SQL.
• Design KPI reports to allow data owners and end users to find detailed information regarding all domains.
• Functional testing to verify teh unity and completeness of elements amongst domains.
• Implementation of Change Control Management processes to control all objects developed during teh project using Team Foundation Server (TFS) as backbone.

Tools used: Oracle RDBMS R12, MS SQL Server R2 2008 & 2012, MS SSIS 2008 R2 & 2012, MS SSRS 2008 R2 & 2012, Master Data Maestro 3.5.4, MS Master Data Services (MDS), MS TFS, MS Development Studio 2012 & 2013, and SharePoint 2010

Confidential, Houston, TX

Senior BI Architect & ETL Developer

Responsibilities:

• This project involves implementing a Data warehouse using SQL Server and MicroStrategy software
• Developed SSIS package to support ETL (extract, transform and load) process to populate a finance solution in MicroStrategy tool
• Responsible for mapping data sources to target tables
• Performed and created test packages
• Matched and validated EDW data again sources and getting obtained approval of teh users

Confidential, Houston, TX

Senior MDM Architect

Responsibilities:

• Implemented teh Profisee platform in order to support their Master Data Management initiative
• Applied teh best practice model for teh Confidential Industry
• Extracted processes in order to load information from several sources
• Configured rules validating core information such as: customers, vendors, and bill of materials
• Configured teh processes to create a Gloden Record Management
• Designed data models dat will be used by Business Intelligence Platforms
• Designed different interface views in order to analyze core data by key areas

MDM Architect /System Architect / BI Specialist

Confidential

Responsibilities:

• MDM architecture, design and governance
• Performed integration of several sources
• Performed data synchronization
• Responsible for data cleansing
• Involved in teh design of teh Supply Chain Workflow including its different phases:
• Procurement
• Purchasing
• Receiving
• Inventory
• Maintenance
• Project planning under PMI Methodology
• Developed workshops with functional areas to ensure all requirements were met with teh architectural design
• Provided supply chain architecture definition
• ETL architecture
• Provided Web services design, construction and deployment
• Utilization and implementation of teh telecommunications best practice framework
• Defining and documenting teh architecture for SAP platform
• Analyzed impact on data objects
• Provided Service Desk support on teh cloud project
• Project planning under PMI Methodology
• Designed to support BMC Remedy platform a best practice of ITIL
• Project planning under PMI methodology
• Defining teh architecture to support teh infrastructure as a service
• Teh solution was defined in teh new portal design with full compatibility with other platforms in teh company such as CRM system (Siebel)
• Teh solution offered more agility and flexibility to integrate other elements such as new portals or systems

DW/BI Architect & Tech Lead

Confidential

Responsibilities:

• Analyzed, designed, built, and deployed data integration packages (database objects, DI packages, scripts)
• Analyzed, designed, built, and deployed data marts (database objects, ETL packages, scripts)
• Definition of teh ETL process using Cognos Transformer
• Analyzed, designed, built, and deployed reports to address teh financial department needs using Cognos Enterprise (Cognos Powerplay)
• Multi-source and multi-platform data extraction including: Oracle RDBMS, Flat Files extracted from Unix OS, and Excel spreadsheets
• Highly recognized BI project within teh organization for teh huge impact dat it generated
• Data Quality Assurance process planning, design and execution
• Creation and implementation of technical documentation
• This project uses distributed information stored on custom systems dat use MS SQL Server database (SSIS was used to consolidate and load this information)
• Design and constructed metadata, ETL process, reports and cubes, and shell processes
• Performed data quality assurance process planning, design and execution
• Designed and built metadata, ETL process, reports and cubes, and shell processes
• Cognos as ETL/BI tool
• Use of MS SQL Server as RDBMS for DW/BI
• Performed multi-source and multi-platform data extraction
• Analyzed, designed, built, and deployed report specifications and dashboards (SSAS, SSRS) for operative areas to alert them; resulting in fraud reduction
• Performed Data Quality Assurance process planning, design and execution

Confidential

Responsibilities:

• Defined teh BI Architecture; applying a multi-Platform data sourcing, multi-dimensional optimization, & data mart deploy
• Defined data modeling
• ETL Architecture and Construction (SSIS)
• Analyzed, designed, built, and deployed report specifications and Dashboards (SSAS, SSRS)
• Part of teh Sperto Center, is used to show customers all teh products and services offered by teh company; Some of teh variables displayed in teh dashboard are:
• Number of calls diagrams
• Calls duration
• Entities such as city, state, etc.
• Several other dimensions
• Data Quality Assurance process planning, design and execution

Confidential

Responsibilities:

• Project planning under PMI methodology
• Led teh project to upgrade Cognos to 8.2
• Migration of different modules and components such as Datamanager, Cognos, and Power Play
• Server migration (to support teh Oracle server)
• Accomplished upgrade of all components, data migration, and reports and cubes migration (Without impact at teh operation)
• Performed Data Quality Assurance process planning, design and execution
• Presentation of solutions to address identified requirements to stakeholders
• Data Modeling
• ETL architecture and construction
• SSIS and SSRS as ETL/BI process construction and MSSQL Server as Relation Database
• Data migration using a custom system developed in .Net technology
• This project used information stored on lead technology platform such as Siebel

Confidential

Responsibilities:

• Data migration using a custom system developed in .Net technology
• Use of MS SQL Server as RDBMS
• Propose, design and build metadata, ETL process, reports and cubes
• Teh information is used for teh customer service department to analyze teh time spent per executive with customers
• Use of SSRS capabilities as reporting tool
• Information needed was stored on Siebel and SSIS was used to push data into teh Project Operational DB

Application Specialist/BI Specialist

Confidential

Responsibilities:

• Provided support, and implemented solutions for billing processes
• Business Objects platform for construction, Oracle as a Relational Database and built Unix shells and AWK scripts

Consultant & Application Specialist

Confidential

Responsibilities:

• Investigated, analyzed and designed project specifications
• Supported, enhanced and implemented solutions for billing process
• Designed, built and implemented reports for various areas
• Business Objects platform for construction, Oracle as a Relational Database and built shells and AWK programs