Business Intelligence Consultant

• Oct 2022 - Present

• Partner with a cross-functional team to identify and address customer challenges, applying innovative thinking to drive business process improvements where feasible. • Leverage Power BI to design, implement and deploy cutting-edge business intelligence and analytics solutions. • Conduct data analysis and forecasting, uncovering patterns and trends to inform decision-making. • Build interactive and data-rich dashboards to support multiple business functions, delivering insights to stakeholders at all levels. • Ensure data accuracy and integrity by identifying and resolving programming and data quality issues. • Design and develop robust SQL databases, crafting efficient and effective statements, procedures, functions, views, and indexes. • Lead problem-solving efforts, performing investigations and analyses to make informed recommendations and support clients in their decision-making process. • Bring features from inception to launch, overseeing all stages of development including functional specifications, design specifications, implementation, performance testing, scalability testing, and production support. • Maintain thorough, accurate and timely documentation of software support activities. • Provide training to internal and external stakeholders on data interpretation, evaluation, statistical and analytical techniques. • Ensure strict confidentiality and protection of all data, files, materials, and records. Show less

Data Analyst, Process Automation Specialist

• Jan 2022 - Oct 2022

• Collaborate with business leaders to establish critical business metrics and develop dashboards and monitoring tools to assess the overall health of the organization. • Develop fully automated solutions for various business needs using cutting-edge technologies such as VBA/VBS, Python, SQL, DAX, Power Query, and SAP Scripting. • Expertise in Power BI report development, maintenance, updates, and bug fixing to ensure accurate and effective data analysis. • Provide ongoing support for existing tools and processes, as well as system support and troubleshooting for business users. • Continuously improve and optimize existing functionalities through bug fixing, increased efficiency, and performance enhancements. • Prepare comprehensive analysis reports to aid stakeholders in understanding data-analysis processes, allowing them to make informed decisions based on relevant facts and trends. • Create visually impactful Excel dashboards from scratch, using user-friendly interfaces. • Work with large data sets, cleaning and preparing data for deeper analysis. • Address data quality concerns, such as data gaps or biases in underlying data sets, and assess their impact on reporting capabilities. Show less

Data Analyst

• Jan 2019 - Dec 2021

• Develop innovative business solutions utilizing tools such as Excel, VBA, Python, SQL, DAX, Power Query, and SAP.• Collaborate closely with internal stakeholders to comprehend their data needs and create scalable, efficient solutions that prioritize rapid development and reusability.• Automate manual tasks to significantly reduce time and effort.• Conduct fast data analysis on large data sets to provide insightful results.• Design, improve, and maintain business applications, handling both front-end and back-end development processes.• Create fully-automated and semi-automated tools that can seamlessly process data from multiple sources, resulting in faster response times for clients. The tools are capable of producing final outputs in just 3 minutes, compared to a team of 5 people taking 30 minutes each to achieve the same result.• Generate daily reports using BI technologies and a 24/7 virtual server, including data export, transformation, and delivery to recipients.• Identify opportunities to upgrade technology systems to drive positive business impact. Show less

Production Planner

• Jul 2018 - Dec 2021

• Prepare weekly plans based on Master Production Schedule (MPS).• Create daily plans based on PtD signals using Preactor and QAD applications.• Maintain constant communication with both external and internal clients to exchange information.• Monitor plan volatility and recommend actions to mitigate potential impacts.• Prepare and monitor essential planning and production summary reports.• Plan, organize, and execute all inbound and outbound freight and shipping operations.• Quickly troubleshoot issues and either resolve them or escalate when necessary.• Ensure that documentation on file sharing platforms is adequate and kept up to date.• Manage component and raw material inventory levels to meet production needs, and run Material • Requirement Planning (MRP) tool for long-term analysis, project planning, and inventory management.• Perform capacity planning and schedule preventive maintenance.• Prepare root cause analysis reports.• Lead daily and weekly calls with the primary client. Show less

Production Planning Assistant

• Dec 2017 - Jul 2018

MRP Controller

• Feb 2017 - Dec 2017

Warehouse Worker

• Mar 2015 - Feb 2017

Production Worker

• Feb 2015 - Mar 2015