Imej profil jordiandres
@jordiandres
Penanda Mexico Queretaro, Mexico
Ahli semenjak 22 Mac 2019
0 Cadangan

jordiandres

Dalam Talian Luar Talian
Dedicated IT professional with more than 12 years of data warehouse, database and business intelligence experience. Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and production support. Strong technical and analytical skills with clear understanding of the design goals of dimensional modelling (Kimball’s approach and DNF approach). Good knowledge of ETL concepts and extensive hands on practice with SQL Server Data Transformation Services (DTS/SSIS) and InfoSphere DataStage. Extensive experience developing front end BI applications using Power BI and BITAM Artus. I have worked with SAP BO, Qlikview and Tableau. Team player, problem solving oriented with good written and verbal communication skills. Creative, flexible, self motivated and with an excellent service attitude. Interested in developing best practices within a challenging technical track in a BI/DW development environment.
$25 USD/hr
0 ulasan
0.0
  • N/AKerja Diselesai
  • N/AMengikut Bajet
  • N/ATepat Pada Masa
  • N/AKadar Ulang Upah

Portfolio

Ulasan Terkini

Tiada ulasan.

Pengalaman

BI and BPM specialist

Aug 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 leader

Apr 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 Analyst

May 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 Developer

Mar 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 Developer

May 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.

Pendidikan

B.S. Computer Science

1999 - 2004 (5 years)

Professional master’s degree in Business Intelligence

2012 - 2013 (1 year)

Business Intelligence / Data Warehousing postgraduate certificate program

2010 - 2011 (1 year)

Sijil

  • US English Level 1
    80%

Pengesahan

  • Facebook Disambung
  • Freelancer Keutamaan
  • Bayaran Disahkan
  • Telefon Disahkan
  • Identiti Disahkan
  • E-mel Disahkan

Cari Freelancer yang serupa