Data Analyst Power Bi

Andy Saint-Ilma

Data Analyst, Power BI Developer

352-***-**** Email: **********@*****.*** Website: lhttps://www.andysaintilma.com/

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-solvers possess a strong cross-functional understanding of information technology and business processes.

Experience

Data Visualization Consultant Sep 2023 – Dec 2024

Dados Consultant, Plano TX

•Created Logistics Dashboards in Power BI to track shipping cost and analyze the 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.

Customer Success Data Analyst

•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 Operation Analyst SQL, Power BI, PowerPoint Mar 2023 - Aug 2023

Huaptec US Inc - Irving, TX

•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 Excel, PivotTable, Dax Feb 2018 - Jan 2022

Pella Windows & Doors - Ocala, FL

•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.

Skills

Predictive Modeling, Statistical Analysis, Data Visualization, Data Processing / Cleaning, Data Collection, Report Writing, Data Modeling, Data visualization, Supply Chain Management, Inventory Management, Project Management, Six Sigma Black Belt, Data Validation, Sprint Cycle /Agile, Communication

Technical Skills

Analytical Tools: Excel(V-Look Up, Pivot Tables…), Power BI(Dax, M Query…), Power Query, Tableau

Languages: ·SQL (PostgreSQL, MySQL workbench),T-SQL/SQL Server

Education And Professional Development

University Of Colorado Boulder Feb 2022 – Jul 2022

Advance Business Analytics – Certificate Ohio, MA

Microsoft Certified: Power BI Data Analyst Associate (PL-300)

Certification number: 1DA77D-CFAA34

Microsoft Certified: Security, Compliance, and Identity Fundamentals (SC-900)

Certification number: 6C44Q8-0EF909

Life and health Insurance,

Texas Department of Insurance License Notification

License number: 3156538

Contact this candidate