Andy Saint-Ilma
Plano,Texas
Summary
Strategic Data Analyst and Visual Developer skilled in requirement gathering, data wrangler, visual development, and communication. Self-directed and proactive professional with 6 years of experience collecting, cleaning, interpreting, and presenting data sets. Natural problem-solver possesses a strong cross-functional understanding of information technology and business processes.
Overview
6
6
years of professional experience
Work History
Data Visualization Consultant
Dados Consulting
08.2023 - Current
- Company Overview: Logistics Company
- Created Logistics Dashboards in Power BI to track shipping cost and analyze percentage of automated trailers receiving GPS signals over time
- Identifying lags and gaps in tracking data using SharePoint, Excel, SQL server, power automated, DAX, Power Query
- Developed Dashboard comparing inventory levels by fiscal year, highlighting significant year-over-year growth across various categories and regions
- Communicated with customers to gather data requirements and document process flows for internal team support
- Created internal dashboards to track customer access requests
- Developed dashboards to monitor customer service requests, reducing drop-through rates by over 20%
- Conducted data cleaning and analysis tasks to ensure data accuracy and reliability, contributing to informed decision-making
- Logistics Company
Logistics Operations Analyst
Huaptec US Inc
01.2023 - 06.2023
- Implemented Inventory & Shipment tracking Dashboards using Power BI
- Root cause analysis and remedy on account discrepancies costing the company over 20k per month
- Creation of a documentation and reporting process for returns handling
- Established efficient layouts to optimize space utilization, ultimately reducing inventory carrying costs and enhancing operational efficiency
- Applied advanced inventory management techniques, leading to a 20% decrease in stock-outs and a 10% reduction in overstock situations, thereby improving inventory turnover rates
Process Analyst
Pella Windows & Doors
02.2018 - 01.2022
- Created Weekly Reporting to display productivity measures
- Influenced cross-training of floor employees, resulting in increased performance and reduced time
- Operations surpassing productivity targets by increasing efficiency by over 15%
- Presented dashboard and slide decks to executive leaders, providing productivity insights and recommendations for strategic decision-making
Education
Advance Business Analytics Certificate -
University of Colorado Boulder
Ohio, MA02.2023
Skills
- Predictive Modeling
- Statistical Analysis
- Data Visualization
- Data Processing / Cleaning
- Data Collection
- Report Writing
- Data Modeling
- Supply Chain Management
- Inventory Management
- Project Management
- Six Sigma Black Belt
- Data Validation
- Sprint Cycle /Agile
- Communication
- Power BI (DAX, M Query)
- T-SQL/SQL Server
- SQL (PostgreSQL, MySQL workbench)
- Snowflake
- Microsoft Excel (V-Look Up, Pivot Tables…)
- Tableau
- CRM Analytic
Education And Professional Development
- Advance Business Analytics Certificate, University of Colorado Boulder, Boulder, OH, 02/23
- Microsoft Certified: Power BI Data Analyst Associate (PL-300), 1DA77D-CFAA34
- Microsoft Certified: Security, Compliance, and Identity Fundamentals (SC-900), 6C44Q8-0EF909
- Life and health Insurance, Texas Department of Insurance, 3156538
Languages
Haitian Creole
Native or Bilingual
French
Full Professional
Timeline
Data Visualization Consultant
Dados Consulting
08.2023 - Current
Logistics Operations Analyst
Huaptec US Inc
01.2023 - 06.2023
Process Analyst
Pella Windows & Doors
02.2018 - 01.2022
Advance Business Analytics Certificate -
University of Colorado Boulder
Similar Profiles
Joycilene Tamara Candida dos santosJoycilene Tamara Candida dos santos
Gerente de restaurante (Técnico em nutrição) at CARVALHO E REIS PROCESSAMENTO DE DADOS LTDA CNPJ: 57.865.503/0002-28Gerente de restaurante (Técnico em nutrição) at CARVALHO E REIS PROCESSAMENTO DE DADOS LTDA CNPJ: 57.865.503/0002-28
Joaquín Beccar VarelaJoaquín Beccar Varela
Shop Assistant at Dados En ManoShop Assistant at Dados En Mano
Ntobeko Sibongakonke HlopheNtobeko Sibongakonke Hlophe
Owner at Dados internet cafeOwner at Dados internet cafe