A Senior Data Analyst, Engineer, and ETL Architect with over 10 years of experience providing data warehousing, integration, and business intelligence solutions for enterprise environments. Sergio’s well versed across SQL Server, PostgreSQL, MySQL, and Oracle with recent cloud experience. He’s an expert with SSRS, SSIS, SSAS, Talend, PowerBI, and Tableau.
Hire SergioData Integration for transactional business information stored across 3rd party systems like SAP, HubSpot etc. Dimensioned entities to load historical transactional data into multiple cloud environments and data lakes. Streamlined data visualization across ETL processes to have data before and after transformation conveniently profiled and counted up to smoothly integrate Talend tasks.
Built an automated search that integrates Google API for business specific profiles (restaurants, hotels, and Business Corporate Offices) and other business relevant indicators like economic data. Also, built a web application and basic user interface for users to administer and update analytical data.
Migration of stock market instruments and data infrastructures from a legacy mainframe to a data cluster and modern cloud based microsoft, .NET and SQL Server environment. Responsible for complex data analysis to shield business logic processes belonging to Citi and protect each institutions business rules.