Alay Malavia Email & Phone Number

Atlanta, GA, US

San Mateo, California, United States

Santa Monica, California, United States

• Manage an analytics team of consisting of an operations analyst and a talent analyst
• Led operations reporting development and testing in SAP BI, inventory management process design in S4 HANA, and the transition from a 3rd party SaaS system (Encompass8) to S4 HANA & Spring for sales and operations data
• Developed a tool that utilized business plan and product shortage indicators to enable accurate inventory forecasting by location and product
• Automated monthly commission & quarterly bonus processing for 1,600+ sales employees and saving 3-5 days of work every month
• Leverage R to automate data processing and manipulation for operations KPIs, fleet and facilities dashboard
• Refined the HR reporting metrics for headcount, turnover, compensation, training compliance, and recruiting metrics

Greater Los Angeles Area

• Created a monthly fleet and facilities KPI dashboard for the operations team in Tableau that provided insights as well as cost per vehicle/warehouse at invoice level
• Developed a strategy defining the parameters for retiring vehicles as well as rebalancing the fleet for better utilization
• Developed operations trainings and reporting that helped reduce product damages from 0.64% of total sales to 0.4% leading to $2M in savings per year
• Cut down DOT compliance cost by bringing the annual inspection, driver inspection, and HOS tracking to a fleet management company without additional cost and thereby saving $40k-45k/month
• Managed operation’s FP&A budgeting for wages, overtime, fleet & facilities
• SAP R/3 daily/month end/year end intercompany inventory management of more than $1billion

Dallas/Fort Worth Area

• Managed KPI and distribution gap analysis reporting for the sales team at daily, weekly, and monthly levels
• Distribution void analysis for customers with daily & weekly hit list by material and route
• Developed a sales effectiveness report to define when it is financially viable to service a customer
• Ongoing optimization of 1000+ sales routes to improve customer service levels and sales execution
• Owned monthly sales planning process to set volume & KPI execution targets for the entire company at all levels (location, manager, route)
• Centralized the commission management process for the entire company by standardizing 30+ Excel files into one. This saved 20 hours for each location(30+) every month

Dallas/Fort Worth Area

• Using the guide provided by the CIS Team, identify data issues in the Outlet Database.
• Research issues that logic does not resolve and evaluate findings that research provides.
• Submit resolved issues via template to Development Team.

Dallas/Fort Worth Area

• Manage operations for IT claims adjustment processes which coordinate with business demands for RxClaims.
• Track and report on resource allocation for planning and comparison of actual resource, time charges and budget.
• Facilitate and support other Project Managers engagements between IT professionals and Business Analyst for resolving issues.
• Work with Project Managers to devise and execute strategies to improve the quality of the applications.

Dallas/Fort Worth Area

• Developed VBA application for data Sorting and filtering mechanism that reduced weekly administrative tasks

Ms, Management Information Systems, 3.667/4.0

Activities and Societies: SIFE, AITP

B.E., Information Technology