Jonas Bartz Email and Phone Number

Working as data engineer and analytics professional supporting:
- Redshift and databricks data ingestion pipelines with airflow, make, fivetran and hightouch
- Query refactor and tunning
- Tableau, Looker and Power BI dashboards design
- AWS cloud environment

**********************************
Legacy Data and App Migration
**********************************
• Acted as Data Engineer, leading a multi-disciplinary team based in the US and IN to migrate the legacy OnPremise application to AWS Cloud.
• Ran end-to-end Data engineering projects, ensuring data quality and efficient data ingestion processes.
• Utilized SQL, Python Pandas, and various ingestion tools (ETL), including AWS Glue and Talend, to deliver data to different databases such as Amazon Redshift and DynamoDB.
• Turned business requirements into demonstrable proof of concepts, packaged, deployed, and discussed their added value to the organization.
• Worked on client behavior analyses through Splunk and Pendo.
• Spearheaded the Data Engineer projects roadmap using Jira and Jira align.
• Hands-on experience with ETL (Extract, Transform, Load) processes, landing data on Amazon Redshift.
• Managed PaaS infrastructure handling over 100k simultaneous users.
• Utilized Python, Pandas, SQL, Splunk, AWS Glue, and Amazon Redshift for data engineering and cloud projects.

Reduced OnPremise structure by moving clients to AWS cloud. Enhanced client experience with brand-new technology and features. Enhanced data quality due to new data pipelines with AWS Glue.

• Leading multi-disciplinary teams base in US and IN on HCM and Compliance projects.
• Hands on activities on PaaS environments and legacy migration (SQL,Oracle, Rest API's).
• End-To-End wrangling data ingestion and transformation reducing the time of data availability.

***********************
"Go to Cloud" Project
***********************
• Led the "Go to Cloud" project, migrating OnPremise data to Azure using Data Factory and ETL Tools.
• Conducted data analysis with Power BI, Qlik, and Tableau.
• Led Machine learning and deep learning projects based on Python and Azure to detect frauds, predict churn, and rank clients.
• Led data engineering initiatives, creating and promoting data quality between environments.
• Worked on visualizing/presenting data for stakeholders using Power BI, Tableau, and ggplot.
• Led multi-disciplinary teams based in the US and IN on HCM and Compliance projects.
• Utilized Splunk, Pendo, Jira, and Jira Align.
• Leveraged Azure, Tableau, Python, Deep Learning, Go, Machine Learning, ETL, and Power BI.

Data quality enhancement with a single point for data analyses and a better comprehensive from other departments about the importance of data.

************************************
Europen Central Bank Information
************************************
• Utilized Azure Data Factory, SQL, and Python to extract information from the legacy on-premise application to the cloud and further process and transform the data.
• Created new information and fed the European Central Bank with the necessary information.
• Conducted hands-on activities on PaaS environments and legacy migration.
• Worked extensively with SQL, Oracle, and REST APIs.
• Managed end-to-end data ingestion, transformation, and wrangling processes.
• Applied Machine Learning techniques such as linear and logistic regression to evaluate possible inconsistencies among data and identify outliers.
• Leveraged SQL, Python, Azure, Cloud, and Machine Learning for various aspects of the project.

Worked on data quality, reducing penalty taxes by delays and missing information.

***************
Cloud DW
***************
• Conducted hands-on data engineering projects to create and maintain data pipelines on the cloud.
• Utilized Python, NumPy, Pandas, Azure, SQL, and NoSQL for data engineering tasks.
• Led data D&A projects to provide self-service BI with engaging Power BI dashboards.
• Trained team members outside the IT department on how to use Power BI in their daily activities, improving data quality and performance.

A new data structure that provides any user data access to our datalog and the capability to retrieve data and create their own analyses.
***************
Elevator Vision
***************
• Developed a POC to identify individuals entering the elevator.
• Applied computer vision techniques using CV2, DLIB, and Python.
• Aimed to enhance security and accelerate the credential process.
• Worked with scanned documents utilizing Computer Vision/Image processing.
• Demonstrated proficiency in cv2 and object recognition for processing scanned documents.
• Engineered visual features for model training to improve accuracy.

Provided data quality and technology understanding.

************************
Compliance Validation
************************
• Worked on a cross-check validation project between digital obligations from the Brazilian government.
• Built the application on C#, SQL, and Oracle to achieve this goal, presenting the results with reports/dashboards and Data Analysis tools.

An important outcome was the data quality and file processing speed up finding issues that normally wouldn't be found with manual checks.

***********************
Digital Obligation DW
***********************
• Worked on a centralized DW with all digital information and obligation files from clients.
• Made data ingestion with SSIS and Alteryx and data analyses with SAS, Power BI, and Qlik.
• Provided dashboards and reports to the client facilitating the information fixes.

A DW on Azure provides metadata and general digital obligation information about several obligations related to the Brazilian government. It reduces the time to gather this kind of information instead of going to SOR.

***********************
Product Management
***********************
• Involved in the integration between banks (CNAB), credit analysis, and simulation for individuals.
• Responsible for managing the project for the implementation of its own call center.
• Worked on the organization of schedules, and alignment of activities with the analysis and development team.
• Knowledge and experience with Recommender Systems (content-based filtering, collaborative filtering, and knowledge-based systems).

Provided business analysis of systemic solutions for the financial area.

* Delphi and C# Developer

* Delphi developer