Full responsability of the implementation and configuration of the new BI architecture, ETL framework and dimensional modelling for the EDW platform. Integration of data from several ERP systems across the company.

BI & BPM specialist

Part time freelance job. Redesign and development of the whole enterprise DWH / BI architecture to migrate from SQL Server 2000 DTS / Artus G6 into SQL server 2012 SSIS / Bitam Artus G7. All existing logical/physical models, ETL processes and reports were redesigned. Production support activities.

 
BI/DWH Analyst and Developer  (freelance) 

Full BI lifecycle (requirements gathering, design, development, and support) for the Business Intelligence platform. Development of fixes / enhancements of ETL processes and existing BI modules. Architect, DBA and administration activities. 

BI Team Lead

Design and development of BI solutions for new modules in the USA enterprise DW. Dimensional modelling and creation of ETL processes using IBM Data Stage 9.1. Production support / bug fixes / enhancemens activities for the USA enterprise data warehouse (ETL & SAP BO universe and reports). Full responsibility for design, development, support and training activities of analytic applications for Mexico using BITAM Artus suite and SQL Server 2000.  

 BI/ETL System Analyst 

 BI project with El Colegio de San Luis. Design and development of the new BI/DW system for the financial department. 

BI/DWH Developer

Full responsibility for design, development, user support and training activities of analytic applications. Redesign and development of the logical and physical dimensional models and ETL processes for the whole value chain of the company (urbanization, sales, finance, construction and administration) .

Personal details

JORDI G.

Summary

Technical skills

Work Experience