Darwin Lajoie
Jersey City
Summary
Results-driven BI and Data Engineer with a strong background in statistics and over five years of experience in data analytics. Proven ability to extract valuable business insights through advanced analytical techniques and methodologies. Expertise in transforming complex data sets into actionable strategies that drive organizational success. Committed to leveraging data to inform decision-making and enhance operational efficiency.
Overview
9
9
years of professional experience
Work History
Business Intelligence Engineer
Amazon.com
12.2021 - Current
- Built and maintained a data platform which enables business insights. This includes [1] sourcing and storing data about Amazon Customer Care Center (Amazon contact handling tool), [2] enabling the necessary platform features, and [3] creating scalable reporting tools.
- Partnered with program managers to gather requirements, develop key performance metrics for customer service associates (CSA), implemented ETL processes and built dashboard used by 100+ teams in CS operation to track CSA’s performances.
- Used data and analytics to provide insights to [1] UX teams who seek to learn about friction points customer service associates experience when using the software; [2] Tech teams who seek to identify product components contributing to product latency, time-outs, and errors; [3] Product teams who seek to justify enhancements and quantify the results through test and learn exercises.
- Participated in creating and maintaining the team WBR report and communicating results with leadership.
- Created robust clickstream data pipeline and dashboard using user’s logs data to determine user behavior and engagement with web tools, and output solid analysis report with recommendations.
- Partnered with Data Engineering and Software Development Engineers to conduct deep dive backend data quality checks, identify opportunities for business solutions, and lead or support implementation.
Senior Data Analyst
Imperial Dade
03.2021 - 12.2021
- Developed and maintained a centralized business intelligence model to track purchasing and sales across all the company and the different acquisition sites nationwide using Power BI to give visibility to Supply Chain Senior Management.
- Maintained a ruled based business intelligence model to track and visualize more than $100M annual rebates from different vendors using Power BI to optimize the total rebate claimed.
- Performed supply chain analytics to support multiple ongoing projects to: optimize saving when we are integrating newly acquired companies, track monthly saving, forecast rebates.
- Responded to immediate needs by various depts to meet business needs – examples include aged inventory transfers, customer fill rates, receipt analysis, and more.
Data Analyst
Black Knight Financial Services
10.2019 - 03.2021
- Performed ETL processes and analysis on US residential data to translate into standardized and usable formats using SQL Server.
- Worked Across business units/teams to collect, aggregate, match, consolidate, and confirm data for quality and accuracy.
- Designed and/or developed and ensured the quality of specific databases for collection, tracking and reporting of research data.
- Used Strong ad-hoc SQL Query development to proactively identify data issues that need to be fixed and perform detailed data verification and analysis.
Research Assistant Analyst
University Of Central Florida
09.2019 - 12.2019
- Used of web Scrapping python packages to create scripts to gather detailed data on hotels listed on TripAdvisor.
- Performed analysis and created models to explain US hotels profits using several inputs.
- Time Series analysis on hurricane impacts on southeastern United States economic activities using R programming.
Data Analyst - Intern
International Business Innovation Association (INBIA)
11.2018 - 08.2019
- Collected Data about both entrepreneurship centers and startup companies and accurately registered new records in Salesforce.
- Established verbal or written communication with assigned contacts through phone calls and personalized email outreach.
- Built a web scraper using python to search for additional data about the entrepreneurship centers and their client startups.
- Participated in the data pre-processing and first analysis.
Terre des Hommes International - Data Analyst
Non-Governmental Organizations
02.2017 - 06.2017
- Produced and updated Program/Product Monitoring and Evaluation Plan and Result Framework for programs/products in: Basic Education, School Health, WASH, Agriculture, Farms and small rural business
- Defined and monitor Key Performance Metrics (KPI) for Project/product performance using Excel to track progress toward programs execution for over 10000 beneficiaries.
- Designed and Coordinated evaluation research to measure programs/products objectives achievement.
- Led multiple field data collections (managing teams of up to 30+ data collectors) during research to guarantee data quality and cost efficiency of surveys
- Performed A/B testing and machine learning using SPSS and R to measure project/product performance and suggest actionable insights to the management team to improve performance.
Data Analyst Intern
Heifer International Project
11.2016 - 01.2017
- Produced and updated Program/Product Monitoring and Evaluation Plan and Result Framework for programs/products in: Basic Education, School Health, WASH, Agriculture, Farms and small rural business
- Defined and monitor Key Performance Metrics (KPI) for Project/product performance using Excel to track progress toward programs execution for over 10000 beneficiaries.
- Designed and Coordinated evaluation research to measure programs/products objectives achievement.
- Led multiple field data collections (managing teams of up to 30+ data collectors) during research to guarantee data quality and cost efficiency of surveys
- Performed A/B testing and machine learning using SPSS and R to measure project/product performance and suggest actionable insights to the management team to improve performance.
Education
Master of Science (M.S.) - Data Analytics
University of Central Florida
Orlando, FL05-2020
Master of Science (M.S.) - Statistics and Econometrics
Toulouse School Of Economy
Toulouse, France06-2019
University Diploma - Applied Statistics
Toulouse School Of Economy
Toulouse, France06-2018
Bachelor of Art (B.A) - Economics, Major: Statistics
Centre de Techniques de Planification et d’Economie Appliquée (CTPEA)
Port-au-Prince, Haïti12-2015
Skills
- SAS Base Programmer certification
- Data analysis and visualization tools
- Data analysis with Python and SQL
- ETL processes
- Fluent in French and Haitian Creole
- AWS cloud services expertise
Timeline
Business Intelligence Engineer
Amazon.com
12.2021 - Current
Senior Data Analyst
Imperial Dade
03.2021 - 12.2021
Data Analyst
Black Knight Financial Services
10.2019 - 03.2021
Research Assistant Analyst
University Of Central Florida
09.2019 - 12.2019
Data Analyst - Intern
International Business Innovation Association (INBIA)
11.2018 - 08.2019
Terre des Hommes International - Data Analyst
Non-Governmental Organizations
02.2017 - 06.2017
Data Analyst Intern
Heifer International Project
11.2016 - 01.2017
Master of Science (M.S.) - Statistics and Econometrics
Toulouse School Of Economy
University Diploma - Applied Statistics
Toulouse School Of Economy
Bachelor of Art (B.A) - Economics, Major: Statistics
Centre de Techniques de Planification et d’Economie Appliquée (CTPEA)
Master of Science (M.S.) - Data Analytics
University of Central Florida