DATASTAGE 7.5 FULL
After the certification (MCE for employees), developed a few more full BI Projects ( Dimensional Modeling, ETL and obviously the BI part with our tool, MicroStrategy) mainly in Portugal and Spain. In June 2010, after finishing the post-graduation and short after attending the lifecycle course at Kimball University (White Plains, NY), I joined MicroStrategy (in Portugal) as a Consultant. In that role 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 the migration, I 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 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 early 2009, I was offered a contract directly to Portugal Telecom - Sistemas de Informação (not outsourced anymore), and a new challenge, a role called DataStage Specialist with a bit more importance. I also attended some courses like DX444 (DataStage Essentials) and DX445 (DataStage Advanced Parallel Developing) at IBM during that period. 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 metadata through it's API. 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, in order to configure new connections or solve technical problems, constantly had to interact with many other teams of the organization, like the IT networking team, system administrators team, DBA team, production team.
DATASTAGE 7.5 INSTALL
Had to install software packages from the development team (I automated 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.
DATASTAGE 7.5 TV
Had in my hands the maintenance and support of the DataStage 7.5.3 Server Environments of ZON TV Cabo, a triple-play cable TV company in Portugal.
Just after that, I was outsourced to Portugal Telecom - Sistemas de Informação to a different role.