Johnny Joseph
Tlalpan, Mexico City
Summary
Dynamic Economist, Statistician and Data Professional with deep experience in BI solutions with proven expertise at Marco Marketing in advanced data modeling and machine learning. Skilled in ETL development and report design, I drive strategic insights through PowerBI, SQL and Python. Adept at collaborating with cross-functional teams, I enhance data quality and foster informed decision-making.
Overview
7
7
years of professional experience
1
1
Certification
Work History
BI Developer
Marco Marketing
11.2024 - Current
- Advanced data modelling in Azure, Azure blob storage, databricks and PowerBI. Applying star and snowflake schemas on top of trusted data.
- Develop scaled pipelines using Azure Datafactory and pyspark Databricks.
- Data integration with CRM (Salesforce), Databricks and PowerBI.
- MSSQL Database management (create schemas, tables, assigning and denying roles ect..)
- Develop and deploy machine learning model (Clustering, Forecasting, Logistics Regression, SVM ect...) using native python, databricks jobs and azure machine machine learning.
- Applying Azure-AI related model to real world issues (Azure speech, Azure OCR engine) to create databases.
- Developed strategic reports for executive decision-making using advanced data visualization techniques.
- Collaborated with cross-functional teams to identify business requirements and translate them into technical specifications.
- Provided timely responses to ad hoc requests for information from management staff, allowing for informed decision-making based on accurate data insights.
Information Manager
Danish Refugee Council
09.2022 - 08.2024
- Implemented effective data storage solutions, optimizing resource utilization and reducing operational costs.
- Monitor and evaluate project using statistical method for impact evaluation.
- Develop user friendly dashboard using power BI and advanced data processing using Power Query
- Develop map of security using ArcGis.
- Championed end-user training programs to promote the adoption of new technologies and processes among employees.
- Managed cross-functional teams to execute complex information management projects within scope, budget, and timeline constraints.
- Evaluated emerging trends in the field of information management, proactively incorporating best practices into daily operations as necessary.
Statistician Consultant
Groupe Croissance
03.2018 - 09.2020
- Optimized data management systems to ensure accurate storage, retrieval, and reporting of statistical information.
- Performed data cleaning and data preparation to support high-quality data and catch errors before processing.
- Develop user-friendly Dashboard with Excel
- Collaborated with cross-functional teams to identify key performance indicators and establish benchmarks for success.
Education
Master of Science - Government And Public Affairs
Latin America Faculty of Social Sciences (FLACSO)
Mexico, México, Mexico09-2022
Bachelor of Science - Applied Economics
CTPEA
Port-au-Prince Haiti02-2018
Skills
- ETL development
- Machine learning
- Report design
- SQL programming
- Statistical Method for Impact Evaluation
- Python Programming
- R Programming
- Advanced PowerBI
- Pyspark programming
- Stata
- Advanced Excel
- Data quality management
- Business intelligence tools
- Data security
- Database administration
Websites
Certification
- Impact Evaluation Methods with Application in Low-and-Middle Income Countries, GeorgetownX
- Public Policy Analysis Using Interrupted Time Series
- Python for Data Science and Machine Learning
- SQL associate data engineer
- Data Modelling in Power BI
- Spark, Hadoop and Snowflak for Data Engineering
- Modern Data Warehouse Analytics in Microsoft Azure
- ETL and Data Pipelines with Shell, Airflow and Kafka
Languages
French
Bilingual or Proficient (C2)
HAITIAN CREOLE
Bilingual or Proficient (C2)
Spanish
Advanced (C1)
English
Advanced (C1)
Timeline
BI Developer
Marco Marketing
11.2024 - Current
Information Manager
Danish Refugee Council
09.2022 - 08.2024
Statistician Consultant
Groupe Croissance
03.2018 - 09.2020
Master of Science - Government And Public Affairs
Latin America Faculty of Social Sciences (FLACSO)
Bachelor of Science - Applied Economics
CTPEA
Similar Profiles
ISABEL CRUZ CASTILLAISABEL CRUZ CASTILLA
Farma Asesor at Marco MarketingFarma Asesor at Marco Marketing
Jolanta SkrokJolanta Skrok
Buyer at Marco Manufacturing/Marco Board House Inc.Buyer at Marco Manufacturing/Marco Board House Inc.
ZARIA WILLIAMSZARIA WILLIAMS
Host at Blue San MarcoHost at Blue San Marco