Jemput Pekerja Bebas ke Projek
Anda tidak mempunyai projek aktif pada masa ini. Kenapa tidak memaparkan projek sekarang? Ia percuma!Siarkan Projek
- N/AKerja Diselesai
- N/AMengikut Bajet
- N/ATepat Pada Masa
- N/AKadar Ulang Upah
BI and BPM specialistAug 2017
Full implementation and configuration of the new BI architecture using SQL Server 2017 DB/SSIS, MS Power BI and Oracle ERP database. Creation of analytical apps pulling data from diverse sources like DELSIP, Service Desk, OET ERP, NUTRICIEL, EROUTE, QDOC and other custom databases. Full responsibility for the data architecture, ETL framework and dimensional modelling for the EDW platform. Full BI lifecycle new data models to be implemented using MS Power BI.
BI team leaderApr 2016 - Jul 2017 (1 year)
Full BI lifecycle (requirements gathering, design, development, and support) for the Business Intelligence platform using SQL Server 2012 DB/SSIS, Qlik View 11 and Oracle ERP. Primary role in defining short and medium term BI strategy for the company along with relevant internal stakeholders. Lead analytic initiatives and enhancements while mentoring and coordinating external consultants. Development of fixes / enhancements / troubleshooting of ETL processes and Qlik View modules.
IT BI/ETL System AnalystMay 2008 - Apr 2016 (7 years)
Design and development of BI solutions for new modules in the USA and México enterprise DW. Dimensional modelling and creation of ETL processes using IBM Data Stage 9.1 (USA) and SQL Server/DTS (Mexico). Production support activities , development of fixes / enhancements of ETL processes, SAP BO universes and SAP BO reports (USA) and BITAM Artus (Mexico).
BI Analyst and DeveloperMar 2006 - Apr 2008 (2 years)
Full responsibility for design, development, user support and training activities of analytic applications. Redesign and development of the logical and physical dimensional models for the whole value chain of the company (urbanization, sales, finance, construction and administration) using SQL server 2000 and Artus V5. Design of the ETL processes to extract information from Enkontrol ERP (Sybase RDBMS). Design and creation of the data cubes using BITAM Artus Administrator.
BI Analyst and DeveloperMay 2005 - Feb 2006 (9 months)
BI project with El Colegio de San Luis (postgraduate school of business and politics). The project consisted of the design and development of the new BI/DW system for the financial department of the school, creation of the ETL jobs to extract information from Microsoft Solomon ERP and the design of the front-end applications using BITAM BI Artus.