Afonso Henriques - Online CV - Sprint CV

Achievements

Delivery of Budget Monitoring, dashboard used by 52 agencies, 150 users to monitor the live cycle of budget workflow.
Implementation of cross-department project to build the EC Budget Interactive map, collaborating with DG COMM, DIGIT and DG BUDG.

General description

DG BUDG recently created dashboarding team, has the mission to study, build and maintain dashboard tools to support the budget, planning and supervision of European Commission.
The dashboard created aim global public, from desk officers and other DGs.

Activities and responsabilities

Developer and analyst on Qlikview projects like Budget monitoring, Budget and money flows;
Analyse, design, improve and maintain Qlikview dashboards;
Improve communication between IT and Business for a better alignment;
Improve automation of existent process to support business report's needs;
Present technical solutions;
Build of the approved solution;
Quality control and evaluation of the deliverables;
Project documentation using Confluence and JIRA.

Roles performed

Developer, Analyst, Team Leader, Project Manager

Technologies and methodologies used

PL/SQL, Oracle, RUP, Oracle 11g, Qlikview, Business Objects XI 3.1, Desktop Intelligence, Confluence, Jira, Qlik GeoAnalytics, MiFID II

Achievements

Implementation of Credit automation process, using Qlik we improved a process that every month was taking 5 FTE to 20 minutes.
Implementation of Claims Monitor dashboard.

General description

CDM (Central Data Management) is the team to produce E2E reports and dashboard for the Senior Management at NPB Bank. CDM has the function to combine multiple data sources and provide accurate reports that cover all end to end operations of the bank. CDM being a business team has a very dynamic and agile approach regarding the challenges.

Activities and responsabilities

Analyse, design, improve and maintain Qlikview dashboards;
Gather business requirements for new ETL processes, business reports and/or Qlikview dashboards;
Responsible for all reports connected with Cash, Credit, Fatca and Cards sub-domains;
Improve automation of existent processes with Qlikview;
Present technical solutions;
Build of the approved solution;
Quality control and evaluation of the deliverables;
Project documentation;

Roles performed

Developer, Analyst

Technologies and methodologies used

PL/SQL, Oracle, Oracle 11g, Qlikview, Business Objects XI 3.1, Desktop Intelligence, Scrum

Achievements

Implementation of first Qlikview dashboards in the unit.
Represented EC at Fish Single Market user group for data sharing.
Invited speaker at Qlik at EC to show the world fish imports dashboard.

General description

FSMO (Fish Single Market Observatory) constitute a powerful reporting and analysis tool gathering relevant data for the monitoring of the Fish market.
It is built as a "data warehouse" system collecting information from different external data providers.
FSMO supports the European Commission to monitor and develop new policies and market analysis.

Activities and responsabilities

Team leader for all Qlikview projects;
Analyse, design, improve and maintain ETL processes, business reports and/or Qlikview dashboards;
Improve communication between IT and Business for a better alignment;
Improve automatization of an existent process to support business report's needs;
Present technical solutions;
Build of the approved solution;
Project documentation.

Roles performed

Developer, Analyst, Team Leader, Tester

Technologies and methodologies used

PL/SQL, Oracle, RUP, Oracle 11g, Shell Script, Toad, XML, Unix, Qlikview, Business Objects XI 3.1, Desktop Intelligence, Solaris, Business Objects Universe Builder, Web Intelligence, Business Objects Data Services, Business Objects Data Integrator

Achievements

Responsible for a successful Revenue Assurance project delivery within the deadline and budget, it was the first time in the history of the client that a project was delivered within the deadline and contracted budget.

General description

Implementation of a real time data analysis project covering all the network (20 systems) to detect revenue leakage for Afghan Telecom, using Oracle Data Integrator ETL to reconcile all the systems.

Activities and responsabilities

Project management tasks;
Gather business requirements;
Present technical solutions;
Build of the approved solution;
Design, implement, integrate, deploy, maintain and tuning of a delivered system (application and Oracle database)
Quality control and evaluation of the deliverables;
Project documentation;
Training the local team.

Roles performed

Developer, Analyst, Project Manager, Trainer

Technologies and methodologies used

PL/SQL, Oracle, RUP, Oracle 11g, Shell Script, Toad, XML, Unix, Solaris, Oracle Data Integrator, SQL Navigator, Apache Tomcat

Achievements

Leading and delivering with success two projects phases in Australia Telecom, the project was a great collaborative work between us and the client, resulting in a lot of revenue leakege detection and prevention.

General description

Coaching and leading a team to implement a reimplementation of a complete system of revenue assurance leakage, the project included two modules, "usage control" - monitorization of the network and "platform integrity" - making sure that all clients of Australia Telecom were using the right services.

Activities and responsabilities

Assist in the project management tasks;
Gather business requirements;
Present technical solutions;
Build of the approved solution;
Design, implement, integrate, deploy, maintain and tuning of the delivered system (application and Oracle database)
Quality control and evaluation of the deliverables;
Project documentation;
Training the local team.

Roles performed

Developer, Analyst, Team Leader, Trainer

Technologies and methodologies used

PL/SQL, Oracle, RUP, Oracle 11g, Shell Script, Toad, XML, Unix, Solaris, Oracle Data Integrator, SQL Navigator, Business Objects Universe Builder, Business Objects, Apache Tomcat

Achievements

Part of the team that delivered the biggest project ever of Mtech Solutions, 1 billion CDR per day. The project became a case study of usage of Oracle Data Integrator for a so big volume of data.

General description

Analyst and Integrator roles for the implementation of the Oracle Data Integrator ETL for detection of revenue leakage in the usage of the network and platform integrity for Indonesia Telecom.

Activities and responsabilities

Assist in the project management tasks;
Gather business requirements;
Build of the approved solution;
Design, implement, integrate, deploy, maintain and tuning of the delivered system (application and Oracle database)
Quality control and evaluation of the deliverables;
Project documentation;
Training the local team.

Roles performed

Developer, Analyst, Trainer

Technologies and methodologies used

PL/SQL, Oracle, RUP, Shell Script, Toad, XML, Unix, Solaris, Oracle Data Integrator, SQL Navigator, Oracle 10g, Apache Tomcat

Achievements

Recruitment and selection of numerous new consultants and acquisition of two new accounts.

General description

Acquiring new clients in IT business, managing existing clients accounts, recruitment, and selection of new consultants. The major accounts were MTech Solutions and As Seguros.

Activities and responsabilities

Headhunting;
Validation of the technical skills;
New clients acquisition;
Manage existent clients.

Roles performed

Project Manager, IT Recruiter, Manager

Technologies and methodologies used

PL/SQL, Oracle, Scrum, Java

Achievements

Delivery of multiple successful projects across eastern Europe in the revenue assurance.

General description

IT Consultant for many Telecom operators in Europe.
Large-scale data integration projects in order to get metrics/statistics of network usage, detect revenue leakages, fraud situations and provide business support, using Oracle Data Integrator ETL software.

Activities and responsabilities

Gather systems and business requirements with customer teams.
Provide technical expertise in the telecom domain and high volume data integration and analysis.
Elaborate solution design documentation (functional and technical).
Deployment and configuration of IT solutions. (Java-based running over Unix, Shell scripting, XML, Awk).
Database modeling and data transformation (Oracle 9i - 10g, SQL, PL/SQL, SQL Navigator, TOAD);
Reporting tool deployment and configuration (Proprietary: JSP, Apache, HTML, Javascript and/or Business Objects);
Team leading and project follow-up;
Unit and system testing.
End-user support;

Roles performed

Developer, Analyst, Team Leader, Trainer

Technologies and methodologies used

PL/SQL, Oracle, RUP, Shell Script, Toad, XML, Unix, Oracle Data Integrator, SQL Navigator, Scrum, Java, Oracle 10g, Eclipse, Oracle 9i, XSLT, HTML, Apache Tomcat