Lucas Correa Silva

Resume created on DoYouBuzz

Experiences

Quanto Analytics: discovering insightful features exploring consented financial transactions of customers, under the context of Open Banking, using PySpark, Jupyter and DataProc (GCP). Quanto Analytics is a Quanto's product which deliveries those features as a service, through an API, to our partners.
Ensuring data quality: creating from scratch a data quality process and pipeline using Deequ (Scala), covering all the internal data. The pipeline runs daily and save the results in BigQuery tables, which are synchronized with Metabase where I built a data quality monitoring dashboard to follow on and created alerts to notify the team if any quality test fails.
Data-driven culture: responsible for training teams on Metabase, helping them to explore the internal data, discovery insights and build awesome visualizations.

Ensuring data quality; extracting, transforming and validating data from different sources (Postgres, Snowflake and Redshift databases, also files from AWS S3 through Glue Data Catalog and Athena), using SQL and PySpark for querying, validation and transformation.
Making good visualizations; building advanced dashboards and visualizations for the business areas on Looker and Metabase, gathering data from different sources.
Data enrichment; creating new and useful features crossing different data from correlated entities in order to empower the analytical explorations.
Data pipeline; helping data engineering team to architecture and build the data pipeline from scratch on AWS Cloud, using S3 as data lake, EMR, Lambda and Step Functions for ETL, and Redshift as data warehouse.

Execution of Digital Transformation Labs (DTL), an initiative to connect startups and solutions partners with Microsoft's biggest customers, leveraging the digital transformation on their business. From Jul/17 to Oct/18 have executed the DTL with the following customers: XP Investimentos, Vale S/A, Grupo Ânima de Educação, Netshoes, C&A e Grupo Boticário.
Analysis over marketing campaign data, social media expressions and evangelism events of Microsoft.
Budget management of Developer Experience (DX) area.

São Paulo City Department of Services

October 2014 to December 2016

Full-time

São Paulo

Brazil

Business Intelligence: through open source Pentaho Suite I worked with ETL and dimensional modeling (using Pentaho Data Integration). Creation of analytics cubes in XML (Workbench) and customized Dashboards for KPI's visualization (CTools), deployed on production environment to help the executives on the decision making process.
Business Process Modeling: interviewing users and designing models using Bizagi Modeler accordingly to BPMN.
Requirement Analysis: interviewing employees, users and business unities managers to gather all the requirements of a new open source ERP that would be implemented.
Web Application Development: development of a help desk web application which managed the tasks of Technical Support Team of São Paulo City Funeral Service (SFMSP).

Education

Skills

Communication

Excellent writing and ability to well explain an idea or point of view.

Advanced

_