About me
Education
Professional Experience
Since the beginning of my professional experience I've been always working with Data Warehousing and Business Intelligence (DW/BI).
I've started more than 6 years ago as a Developer in a DW/BI project for the biggest railway company in Portugal, CP - Comboios de Portugal. The project was to integrate data coming from a new operational system (TrainOffice) in the already existing Data Warehouse, expanding it. This was a full BI project, since requisite analysis to production entry, so I've learned a lot. It involved ETL processes using DataStage 7.5.1, DW using Informix as RDBMS, and reporting using Microstrategy.
At that time, I was working for Altran as Consultant. One thing I liked, was that they always gave me interesting projects for big clients. The next project was for Optimus (SONAE COM), a telecommunications company. We had to work directly with the CDRs (Call Detail Records), building ETL processes in C/C++ for high performance data transformation (large data volumes) ir order to have metrics such as call duration, MMS data volume and SMS count. The more aggregated calculations would be done with ETL and DBMS tools to build summary fact tables.
Just after that, I was outsourced to Portugal Telecom - Sistemas de Informação to a different role. I was responsible for the maintenance and support of the DataStage 7.5.3 Server Environments of ZON TV Cabo, the biggest cable TV company in Portugal. I had to install software packages from the development team (I automatized this task later), to solve DataStage technical problems, to do maintenance tasks, to create and configure new DataStage Projects, to configure new DB connections (Oracle mainly), and to do some developments. In this role, in order to configure new connectivities or solve technical problems, I had to interact with many other teams of the organization, like the network team, sysadmin team, DBA team, production team. I also had to be on call (every time the production team detected critical aborted processes, they would call me as focal point during the night and I would solve it at home by VPN, contacting other teams if necessary). In this role, I learned very much about how Information Systems work in big Organizations and the roles of each team, client facing and communication skills, and extended my DataStage knowledge developing tools to interact with it's meta-data. I also had some courses like DX444 (DataStage Essentials) and DX445 (DataStage Advanced Parallel Developing).
In early 2009, I was offered a contract directly to Portugal Telecom - Sistemas de Informação (not outsourced anymore), and a new challenge, a role as DataStage Specialist with more responsibility. I was now technically responsible for PT COM and TMN's Datastage/IBM Information Servers, and started as making a new installation and migration from 8.0 to 8.1. In the migration, I've changed the topology from 2-tier to 3-tier (using a separate IBM AIX LPAR for the Websphere Application Server which consumes a lot of memory, and other for the Engine tier), and optimized the licensing of the tools (Business Glossary, Information Analyzer, Fast Track) regarding the new topology and CPUs. I also made some performance optimization and process analysis, technical problem solving, and gave consulting services to companies like TAP (Portugal Air Transportation) setting up new DataStage environments and procedures.
In June 2010, I joined MicroStrategy (in Portugal) as a Consultant, where I currently am. After the certification (MicroStrategy Certified Engineer), have been developing full BI Projects (Dimensional Modeling, ETL and obviously the BI part with our tool, MicroStrategy). Some of the customers I had the pleasure to work for include 4 banks - BPI, BES, BAI, BBVA (Data Modeling Project in Madrid), Colep CCL (Retail, RAR Group), AdP (Utilities, public sector), Inditex (iPad MicroStrategy Mobile project). |
