Supply Chain Power Bi

James Mutua

Business Analyst Power BI Supply Chain Data Analytics SAP Hanna Project Management

ad5q22@r.postjobfree.com 817-***-****

Personal Statement

●James is an expert in synchronizing supply with demand and developing supply chain strategies, Business Analytic tools, BPMN’s that significantly impact the profitability and total value of an organization. Demonstrated ability to optimize database performance through indexing, query tuning, and efficient data retrieval methods. - Proven track record of designing and implementing database schemas, tables, and views to support application development and reporting needs. Over 4 years of Power BI data Visualization, Results-oriented data analyst with extensive experience in Tableau visualization and data storytelling. Skilled in creating interactive dashboards and reports to drive data information and decision-making.

●Holds a Bachelor of Science in Industrial Technology Engineering from Lamar University. Currently pursuing a Master of Science in Global Logistics and Supply with a concentration in Logistics Information Systems ERP. He is currently looking to work with an organization seeking the best qualified and most experienced people.

●Project Management: Leading and contributing to cross-functional projects aimed at optimizing procurement processes and enhancing spend visibility. Collaborating with diverse teams in implementing and configuring software solutions, including Power BI, Sievo, E2Open, and Oracle Fusion ERP. Monitoring and controlling project quality, fulfillment of commitments, timelines, milestones, budget, risk, performance, and opportunities for continuous improvement. Capturing, analyzing, and documenting business data requirements, workflow processes, and process improvements for supply chain projects.

●Supply Chain Experience: Extensive experience in Supply chain and responsible for Planning approval process with SCOM-Supply Chain Operations Management, Engineering, and logistics. Interpreting historical supply data and retracing current inventory balances for the reconciliation of imbalances. Maintaining and updating the ERP item MRP for vendor, safety stock, pricing, Order management, and other information.

●E-commerce: Analyzed and evaluated the company's online retail performance –PepsiCo, Samsung, and Microsoft. Produced web content and developed new promotional email campaigns. Worked on the improvement of customer experience, analyzed website performances, and stayed up to date with current industry trends.

●Financial Analyst: Knowledge on financial analysis and planning, data visualization, risk and asset management, and investments, reviewing and analyzing financial data for clients. Creating successful sales and Inventory monitoring systems increasing inventory turnover rate by over 25%, especially in Abbott, Samsung, Motorola, and PepsiCo.

●SAP-Hana Experience: Good experience in SAP and responsible for maintaining SNP manufacturing planning model in SAP; daily for new production, weekly using current forecast data. Using SAP to research material availability for internal and external customers. Order management and PO creation. Run different reports.

●GMP/Biopharma Experience: Good Experience working in GMP & Biopharma background - PepsiCo Inc. & Abbott Diagnostic and Laboratories

Key Competencies

●Transformational capability

●Familiarity with various automated database reporting tools

●Integrated business planning

●Integrated value chain implementation.

●Linking supply chain performance to organizational success.

●Project-based Logistics

●Process Improvement

●Project Management

●Supply Chain Solutions Familiarity with various automated database reporting tools

●Time Management

●Ability to coordinate with technical and non-technical audiences.

Executive Strength

●Visionary leadership, managing teams.

●Big Picture Insights and Perspectives

●Highly Ambitious and Determined to Win

●Communicating for Impact

Creative Problem Solving

Languages

●English-Fluent

●Swahili Fluent

Educational Background

●January 2021- July 2024 Master of Science in Global Logistics &Supply Chain Concentration- SAP & Logistics Athens State University Alabama

●January 2016- December 2018 Bachelor of Science in Industrial Technology Engineering Lamar University-Texas

●January 2013- December 2015 AAS- Petroleum Technology/Automation (Magma cum Laude Navarro College- Corsicana –Texas

Other Certification

●ERP-SAP-2022

●Business Analytic-2016

●Business Analysis Foundations

●Automation Beginners

●Automation Competent Use

Technology

●SAP-Hana, SQL, Power BI, JIRA Slack, Order Management Oracle, WMS, SAS, MS Project; MS Office including Word, PowerPoint, SharePoint, Smart Sheets, Google Docs, Google Sheets Excel; Digital and social media platforms. Cognos, Coupa, Sievo

Work Experience

American Airlines

September -2023-Current

Business Analyst-Finance- Procurement and Accounting Automation.

●Assisted in meeting SDLC (system development life cycle) audit controls/documentation including Design and development.

●Assisted in UAT testing from Devs, Testing, and Production for AZURE-IBM (SAP Migration)

●Gathered all the UAT test scripts and helped in creating scorecards and Audit reports from Test Conditions

●Collaborated with other stakeholders, reviewed the system at various stages, conducted testing and audits, and maintained accurate and up-to-date documentation. SAP AZURE migration

●Collaborated with cross-functional teams to align Power BI solutions with the unique requirements of the airline industry.

●Played a key role in optimizing procurement processes and enhancing spend visibility using Sievo software.

●Collaborated with cross-functional teams to gather and analyze business requirements related to procurement analytics and reporting.

● Implemented and configured Sievo modules to align with American Airlines' procurement objectives.

●Utilized Sievo's advanced analytics features to extract actionable insights from procurement data

●Assisted with Spend Cube Release/Upgrade management. Provided a clear understanding of user impacts, documenting potential configuration conflicts to Spend Cube platform design and researching logged defects for corrective actions or solutions. Helped test quarterly Spend Cube release enhancements.

●Managed projects and provided project support for Spend Cube configuration and systems integrations; assisted with testing configuration changes/updates.

●Generated and Analyzed ad hoc reports using Spend Cube or Cognos Coupa, SAP

●Responsible for providing support to Spend Cube users, Accounting Automation, Finance and Procurement groups.

Motorola Solutions Inc- Feb 2023-To August 2023

Supply Chain Business Analyst II

●Capture, analyze, and document business data requirements, workflow processes, and process improvements. Conduct interviews with business leaders and domain experts to elicit and identify user requirements.

●Ensures stakeholders and business partners generate experiences that delight customers and partners as Envisions IT capabilities related to lead to cash, subscription & customer support services are built, enhanced, and transformed.

●Applied data visualization techniques to communicate complex supply chain insights to stakeholders...

●Work closely with business stakeholders to communicate findings and help implement changes.

●Monitor and control project quality, fulfillment of commitments, timelines and milestones, budget, risk, performance, and opportunities for continuous improvement.

●Support the Business operations, making sure that customers are updated, and daily reports are analyzed and communicated.

●Holds several meetings with Stakeholders, the Business team, SAP team and project partners and Business owners to update on the project's progress.

●Strong understanding of database design principles, normalization techniques, and query optimization strategies.

Samsung SEA - Aug 2022- Dec 2022

Supply Chain Business Analyst & Order Management Contract

•Created dynamic reporting for key measurable and performance tracking as well as identifying process improvements with attention to detail.

•Implemented Power BI tools to analyze and visualize supply chain data for strategic decision-making.

•Developed custom reports and dashboards for monitoring inventory levels, order fulfillment, and logistics.

•Collaborated with supply chain stakeholders to understand business needs and deliver actionable insights through Power BI.

•Processed And managed work orders in Liaison with Logistics Team for efficiency and on time delivery.

•Managed multiple tasks/projects while staying organized in day-to-day activities.

•Worked directly with 3PLs to resolve customer complaints and issues.

•Compiled Inventory reports from SAP and did Purchase orders.

•Created Delivery orders on SAP according to customer request and did follow up with logistics team.

•Did procurement of materials through SHI, OneVizion, making sure that I chose the best supplier based on cost and delivery lead time.

Microsoft Corp- Mar 2022-to June 2022

Azure Cloud Logistics & Capacity Planner Supply Chain.BA

Achievements:

•Conducted interviews with business leaders to elicit and identify user requirements for the Oracle Fusion ERP system.

•Prioritized and protected high Priority Customers by detecting 41 hot regions plus tracking and expediting 73 Servers.

•Monitored mapping of customer business issues and developed appropriate solutions.

•Provided departmental support to Project Manager - Order Management

•Used Power BI Visualization to Update the inventory of capacity needed for different -Data Center and Availability zones across the globe.

•Applied Power BI to streamline supply chain reporting, enabling data-driven decision-making.

•Designed and maintained dashboards for tracking key performance indicators in the supply chain.

•Conducted in-depth data analysis to identify areas for process optimization and cost savings.

•Collaborated with cross-functional teams to implement Power BI solutions tailored to supply chain requirements.

•Utilized Power BI Visualization to update the inventory of capacity needed for different Data Centers and Availability zones across the globe, integrating Oracle Fusion ERP data. Member of JCAB-Joint Capex Approval Board a ticket is raised for change to align to ETES.

PepsiCo Inc- May 2021- Jan 2022

Business Analyst-Supply Chain Contract

ACHIEVEMENTS:

•Maintained and updated the ERP item MRP for vendor, safety stock, pricing, and other information.

•Maintained SNP manufacturing planning model in SAP; daily for new production, weekly using current forecast data.

•Obtained information required to process the order -user data, product reference details, installation details, exchange requests, billing dates, sales codes, billing account contacts.

•Performed daily planning of food schedule in conjunction with Third Party-XPO Logistics provider.

•Modified customer service procedures to improve information accuracy to production planning and the customer.

•Reviewed MRP requirements release purchase orders, planned orders requirements, and expedite shortages as needed.

•Led the development and implementation of Power BI reports for supply chain performance monitoring.

•Created dashboards for real-time tracking of production, distribution, and inventory metrics.

•Analyzed historical data trends using Power BI, contributing to more accurate demand forecasting.

•Collaborated with IT teams to integrate Power BI solutions into existing supply chain system.

•Implemented a culture of continuous improvement by organizing high impact improvement teams, including the formulation of a leadership improvement council.

•Performed Daily balancing of finished goods production components of WMS vs. SAP systems, requiring transaction research.

Abbott Diagnostic and Laboratories - Feb 2019- to Feb 2021

Supply Chain Business Analyst Irving Texas

Achievements:

•Collaborated with sales account managers and suppliers on continuous improvement and product innovation.

•Coordinated and expedited placement of purchase orders to ensure material Delivery on time.

•Negotiated departmental/company service agreements or purchase orders as required to meet Program requirements.

•Participated in team meetings to determine product inventory levels and demand to enable management to allocate product to operations and power BI visualization and reporting.

•Conducted data analysis &; KPI implementation/maintenance.

•Performed extensive data analysis, business planning, forecasting and database querying.

•Used Oracle ERP- to research material availability for internal and external customers.

•Implemented Kanban Picking Process Project and Trained 15 Personnel thus saving Company $2.4M annually.

Trader Joe DC -Oct 2015- Jan 2019

BA-Inventory Analyst Texas

Achievements:

•Completed FDA FSMA 204 training, demonstrating expertise in the regulations and requirements outlined in the Food Safety Modernization Act (FSMA) for ensuring the safety of the food supply chain.

•Spearheaded the implementation of Power BI solutions to optimize inventory reporting processes.

• Designed and developed interactive dashboards providing real-time insights into inventory levels.

• Conducted in-depth analysis of inventory trends using Power BI, resulting in enhanced forecasting accuracy.

•Collaborated with cross-functional teams to gather requirements and ensure reports met business needs.

• Utilized Power BI for data modeling and visualization, contributing to more informed decision-making...

•Maintained labeling system on each stock item Boosted productivity by 18% by revamping the bulk SKU profile.

•Removed existing racking in bulk locations, leading to a 20% increase in capacity.

•Collaborated with vendors to negotiate favorable terms, saving the company 15% in procurement costs.

•Supported the implementation of efficient inventory control procedures, leading to 10% reduction in stockouts.

•Conducted regular audits and cycle counts to ensure inventory accuracy hence increase order fulfillment by 10%.

•Forecasting using historical data and market trends helps to prevent excess inventory thus reducing holding stock cost by 8%

• Performed Free Space audits, location audits, dock audits and drop zone audits.

• Provided support and training relating to Inventory Related issues.

• Responsible for the planning, coordinating, and execution of multi-level, weekly perpetual cycle count program.

• Update inventory and inventory discrepancies in the WMS (Sage X3, SAP) including processing adjustment

•Assisted in implementing Lean Manufacturing, through receiving and put away process and became SME.

Time Management

Certification

I, the undersigned certify that these data correctly describe me, my qualifications and experience.

James Mutua,

Contact this candidate