Software Developer | DWH Support
2013 - PRESENTInstitute of Informatics, Government of Portugal- Refurbished and optimized a 63-hour-long ETL data mart chain to an IBM DataStage Parallel Server 9.1. Reduced the chain critical path to 23 hours.
- Developed several PL/SQL Oracle packages regarding the Portuguese annual financial statement political measures. The measures are mostly related to a national wage declaration system that all companies must adopt.
- Implemented several new operations aimed at the national social security system. The SSIS (social security information system) has over than 12,000 final users distributed all over the country. The operations were developed towards a fat Swing MVC client using Java and running business rules layer over Oracle Sun One application server.
- Optimized and developed several data analysis and ETL processes using VBA, C#, DataStage, SSIS, and PL/SQL mostly over Oracle and SQL Server.
- Developed the full data migration process regarding two new national social security applications (household management and income management). The process includes three full Oracle schemas that will be divided into five new schemas. The development uses DataStage 9.1 Parallel Server, SQL, and PL/SQL.
Technologies: Exadata, Oracle, Jakarta EE, Java, Visual Basic for Applications (VBA), Bugzilla, Subversion (SVN), T-SQL, Microsoft SQL Server, PL/SQL, Business Intelligence (BI), Data AnalyticsProgrammer
1998 - PRESENTFreelance Work- Developed a high number of automation processes, databases, data analysis processes, and software applications for companies like Sperry Van Ness (Svn.com), Metanoia, Inc. (Metanoia-inc.com/index.html), Kingstone Insurance Company (Kingstoneinsurance.com), American Forest Management, Inc. (Americanforestmanagement.com), Quidel (Quidel.com), Telemedicine Clinic (Telemedicineclinic.com), Survalyzer (Survalyzer.ch/en), Branded (Brandedaustralia.com.au/default.asp), Univesity of Aukland (Auckland.ac.nz/en.html), iTrade USA (iTradeusa.com), BI-works (Bi-worx.com), Creative Dynamic, Inc. (Creativedynamicinc.com), ValYou More, Inc., FD4Cast (Fd4cast.com), CSU Industries (Csuindustries.com), Verdico Solutions (Verdicos.com/index.php), and IRISOS (Irisos.ch).
Technologies: Oracle, SQL Server Integration Services (SSIS), Microsoft SQL Server, C#, T-SQL, PL/SQL, SQL, Visual Basic for Applications (VBA), Business Intelligence (BI), Data Analytics, Data VisualizationInformation Manager
2001 - 2013Institute of Informatics, Government of Portugal- Participated in all phases of the development of the National Wage Declaration data mart project (requirements definition, data analysis, dimensional modeling, ETL development, metadata development, testing, report development). Built the main fact table that holds more than 3 billion records.
- Aided in all phases of the development of the National Identification and Qualification data mart project (requirements definition, data analysis, dimensional modeling, ETL development, metadata development, testing, report development).
- Worked in all phases of the development of the National Public Insurance data mart project (requirements definition, data analysis, dimensional modeling, ETL development, metadata development, testing, report development).
- Participated in all phases of the development of the Unemployment Benefits data mart project (requirements definition, data analysis, dimensional modeling, ETL development, metadata development, testing, report development).
- Helped in all phases of the development of other minor data mart projects (requirements definition, data analysis, dimensional modelling, ETL development, metadata development, testing, report development).
- Participated in all phases of the development of the Current Account data mart project (requirements definition, data analysis, dimensional modeling, ETL development, metadata development, testing, report development). Main partitioned fact table over than 3,5 billion records;
- Worked as a team player in the development of the anti-fraud platform system. Worked on the requirements definition, data sources analysis, ETL development, dimensional modeling, FICO business rules definition OOP development, Java multi-thread orchestrator development, metadata development, and report development.
- Developed a high-number of data analysis and data transformation processes using PL/SQL, IBM DataStage, VBA, C#, SSIS, T-SQL, and Access.
- Developed a high number of reports or reporting solutions using Microsoft Access, MicroStrategy, Business Objects, Excel, PowerPoint (including VBA).
- Built a large number of automation processes using mostly VBA combined with SQL, PL/SQL, T-SQL, C#, and SSIS.
- Refurbished several processes mostly tuning SQL and using more recent ETL tools or database features.
Technologies: SAP BusinessObjects (BO), Datastage, Erwin, MicroStrategy, T-SQL, Visual Basic for Applications (VBA), Microsoft SQL Server, Unix, PL/SQL, Oracle, Business Intelligence (BI), Data Analytics, Data VisualizationIT Manager
2000 - 2001ParaRede Electronic Business Solutions — SA- Developed MIS systems, ETL processes with VB6, and reports were created using BusinessObjects (desktop and web intelligence).
- Created the entire intranet database model;
- Worked on internal SAP project management regarding the MIS integration.
Technologies: SAP BusinessObjects (BO), ASP, Visual Basic 6 (VB6), Microsoft SQL ServerSystem Administrator | Programmer
1998 - 2000General Electric Capital ITS- Worked on SQL Server, Lotus Notes, and Windows Server administration.
- Developed process automation aimed at the financial department.
- Worked on EDI software development using Delphi 3 and SQL Server.
- Developed Microsoft Access databases.
Technologies: Windows Server 2000, Microsoft SQL Server, Novell NetWare, Microsoft Access, Delphi, Visual BasicProgrammer
1997 - 1998Euro Marketing- Developed a call center database using Microsoft Access.
- Performed data analysis using Microsoft Excel, VBA, and SQL.
Technologies: Microsoft Excel, Visual Basic for Applications (VBA), Microsoft Access