Scroll To View More
Hire the top 3% of freelance developers
toptal.com
Call us: +1.888.604.3188
Pedro J M Fidalgo

Pedro J M Fidalgo

Lisbon, Portugal
Member since November 6, 2015
Pedro is a data warehouse & BI pro over multi-terabyte based systems (Oracle, SQL Server, DataStage, SQL, PLSQL, TSQL, SSIS, MicroStrategy, & BusinessObjects). He's also an experienced database designer/developer (Relational 3NF or DWH Dimensions, Kimball). He has worked with various tech: RAD (VBA Access, C#, VB6, Excel, Java), report/dashboard, complex process automation, data analysis & enrichment, SQL tuning, & algorithms.
Pedro is now available for hire
Hire Pedro
Portfolio
Experience
  • Visual Basic for Applications (VBA), 16 years
  • SQL, 16 years
  • Microsoft Access, 16 years
  • Oracle, 15 years
  • Datastage, 14 years
  • Data Warehouse Design, 13 years
  • Transact-SQL, 7 years
  • SQL Server Integration Services (SSIS), 4 years
Lisbon, Portugal
Availability
Part-time
Preferred Environment
Oracle|SQL Server|VBA|C#|Access|Excel|DWH|ETL
The most amazing...
...thing I created was a full 2 meter wide glider model from scratch when I was 13 years old; this is like programming, each piece in the correct position.
Employment
  • Software Developer | DWH Support
    2013 - PRESENT
    Institute of Informatics, Government of Portugal
    • Refurbished and optimized a 63 hrs ETL Data Mart chain to IBM DataStage Parallel Server 9.1. Reduced the chain critical path to 23 hrs.
    • Developed several PLSQL 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.
    • Developed 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 PLSQL 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 PLSQL.
    Technologies: Oracle (Exadata), PLSQL, SQL Server, TSQL, Tortoise SVN, Bugzilla, VBA, Java/J2EE
  • Programmer
    1998 - PRESENT
    Freelance Work
    • Developed a high number of automation processes, databases, data analysis processes, software applications for companies like:.
    • Sperry Van Ness - http://www.svn.com/;
    • Metanoia Inc. - http://www.metanoia-inc.com/index.html;
    • Royal Eagle Security Services - http://www.ress.com.au/;
    • American Forest Management, Inc. (AFM) - http://www.americanforestmanagement.com/;
    • Quidel - https://www.quidel.com/;
    • Telemedicine Clinic - http://www.telemedicineclinic.com/;
    • Survalyzer - http://www.survalyzer.ch/en/;
    • Branded - http://www.brandedaustralia.com.au/default.asp;
    • Univesity of Aukland - https://www.auckland.ac.nz/en.html;
    • iTrade USA - https://itradeusa.com/;
    • BI-works - http://www.bi-worx.com/;
    • Creative Dynamic, Inc. - http://www.creativedynamicinc.com/;
    • ValYou More, Inc.;
    • FD4Cast - http://www.fd4cast.com/;
    • CSU Industries - http://www.csuindustries.com/;
    • Verdico Solutions - http://verdicos.com/index.php.
    • Worked on various other solutions for private clients.
    Technologies: VBA, SQL, PLSQL, TSQL, C#, SQL Server, SSIS, Oracle
  • Information Manager
    2001 - 2013
    Institute 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 modelling, ETL development, metadata development, testing, report development). Built a main fact table of 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 modelling, 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 modelling, 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 modelling, 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 modelling, 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 modelling, 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 PLSQL, IBM DataStage, VBA, C#, SSIS, TSQL, 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, PLSQL, TSQL, C#, and SSIS.
    • Refurbished several processes mostly tuning SQL and using more recent ETL tools or database features.
    Technologies: Oracle, IBM DataStage, PLSQL, Unix, SQL Server, VBA, TSQL, MicroStrategy, BusinessObjects, ERwin
  • IT Manager
    2000 - 2001
    ParaRede 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: SQL Server, Visual Basic 6, ASP, SAP, BusinessObjects
  • System Administrator / Programmer
    1998 - 2000
    General 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: SQL Server 6.5/7, Visual Basic, Delphi, Microsoft Access, Lotus Notes 4.5, Novell NetWare, Windows NT Server, Windows 2000 Server
  • Programmer
    1997 - 1998
    Euromarkting
    • Developed a call center database using Microsoft Access.
    • Performed data analysis using Microsoft Excel, VBA, and SQL.
    Technologies: Microsoft Access, VBA, Excel
Skills
  • Languages
    Visual Basic for Applications (VBA), Visual Basic 6 (VB6), SQL, Transact-SQL, C#, Java, Delphi
  • Frameworks
    ADO.NET, .NET
  • Tools
    Microsoft Access, Microsoft Excel, Toad, Visual Studio, ERwin, Microsoft Project, Eclipse IDE, TortoiseSVN
  • Paradigms
    Dimensional Modeling, ETL Implementation & Design, Object-oriented Programming (OOP)
  • Platforms
    Oracle, NetBeans
  • Storage
    Oracle 11g, Oracle PL/SQL, SQL Developer, SQL Performance, Relational Databases, Oracle SQL, Datastage, SQL Server Integration Services (SSIS), Microsoft SQL Server
  • Other
    Data Warehouse Design, Data Warehouse, SAP BusinessObjects (BO), MicroStrategy
Education
  • Master's degree in Applied Mathematics
    1996 - 2005
    Technical University of Lisbon - ISEG - Lisbon, Portugal
  • Incomplete Master's degree in Economics
    1992 - 1996
    Catholic University - Lisbon, Portugal
Hire the top 3% of freelance developers
toptal.com
Call us: +1.888.604.3188
To view more profiles, join ToptalJoin Toptal
I really like this profile
Share it with others