Arthur has over 15 years of experience in software development and system analysis and seven years working with SQL and data analysis. He's experienced with Oracle, BigQuery, Snowflake, and other data sources. He also has a solid DBT, Python, data engineering, and business intelligence background. In addition to excellent relationships with work teams and customers, Arthur is very committed, adaptable, and creative.
Designed and built a new data architecture for the company in collaboration with the new data team, helping automate data ingestion, modeling, and visualization.
Implemented dbt (data build tool) for data modeling and trained data analysts on how to use it properly.
Set up Fivetran connectors from several data sources to a Snowflake data warehouse.
Implemented Airflow DAGs (MWAA) to run and test dbt models and for custom data ingestions using API calls.
Built controls for data quality checks in the extracted sources using dbt tests and Airflow.
Worked 100% remotely as part of a global professional services team (English and Spanish speaking teams).
Integrated and configured DCRM and portals for telecom customers in different countries.
Wrote system integration tests, user acceptance tests, test scenarios, configuration handbooks, user training, and production rollout documents.
Analyzed data from different CRM environments, exporting and comparing data into Excel using formulas such as VLOOKUP to troubleshoot missing configuration parameters.
BSSASPX
Microsoft Dynamics CRM
Microsoft SQL Server
Wedo Technologies
Data Analyst | Technical Leader
2011 - 2018 (7 years)
, Remote
Worked with large volumes of data. Found revenue leakages and trends between telecom systems, applying data analytics techniques.
Integrated several telecom systems into the RAID ETL tool, reading different data sources(Oracle, SQL Server, Excel, CSV, ASN1), containing telecom events and customer data.
Performed Oracle DB, SQL performance tuning, procedures using PL/SQL, and wrote Python and Shell scripts.
Provided system analysis and solution design documentation, scope and architecture definition, and technical proposals for sales.
Designed user reports, dashboards, and KPIs to support data-driven decisions and identify revenue leakages.
Oversaw unit tests, integration tests, UAT, and production rollout. Completed technical and functional training for customers and teams.
Provided technical leadership and project management in different projects.
Worked on various projects for telecommunications customers in different countries, such as Brazil, Chile, and Peru.
Designed a geospatial dashboard (map) for a vehicle sharing company, displaying the user adoption and behavior change related to defined parking places.
The data was extracted made using SQL and using Google BigQuery geospatial libs. The dashboard was made using Mode, Python, and Jupyter Notebook.
Designed and built a data architecture to help the company make data-driven decisions. I integrated multiple data sources such as Apple Search, Google Ads, MySQL, and Amplitude into an AWS Redshift data warehouse.Configured data integration services like Fivetran and Stitch to collect different data sources and developed a data pipeline using Python to read and parse JSON files, upload them to AWS S3 and load them into Redshift tables. I installed and configured the DBT (data building tool) to perform data transformation (ELT data modeling) and designed the dashboards and reports using Tableau Online.
I supported the company in building a new data architecture in two stages for data ingestion automation, storing all the data in one data warehouse and supporting the data analysis team to focus on the business intelligence side.In the first stage, we made the data available for data analysts as soon as possible using Fivetran and storing it in Snowflake.In the second stage, we built custom connectors using Airflow and implemented more organized data modeling with dbt and SQL.
Education
Master of Business Administration (MBA) in Project Management
