Sammy Warrayat Email & Phone Number

. Responsible for order forecasts for all Sales Leaders across the organization that can be broken down to the granularity of Territory Manager and SKU.. Work with Finance and leadership during AOP and SDP processes to compare expected YoY growth.. Work hand in hand with ops, manufacturing, and Sales to enable SIOP (Sales, Inventory, and Operations Planning) process to create demand planning at each plant to customize production plans and create efficiencies in inventory management and decrease lead time.. Work with leadership and HR to create Commissions repository and dataset that accurately converts bookings to commission payout for Sales team.. Develop both automated and ad-hoc reporting to enable Sales Leaders to measure, track, and improve the mix of the customer, product, and distribution company volume throughout the year.. Conduct market research to develop key metrics to predict both in-market growth and the company's market share expected growth for all Value Streams within Mueller at a regional level.. Constantly improve data integrity regarding orders, new plants, etc. as well as maintain data hierarchy of products to consistently create reports on Value Stream and Sales Org.

Alpharetta, Ga

• Create reports and dashboards for SLT and CIOs within PowerBI that merge Portfolio, Financial, Quality, and Strategy metrics to help guide infrastructure and BU conversations with the intent of open communication and continuous improvement.• Lead ongoing collaborations with Technical Delivery Directors (TDDs) and Infrastructure VP’s to best organize ongoing project delivery as well as prioritization changes in future projects to accurately forecast demand. • Actively manage the overall PS financial budget with the goal of meeting AOP targets and chargeback rate goals.• Develop utilization metrics to actively assess weekly productive hours of resources and effectively guide line managers in staffing projects and balancing resource workload across all initiatives

Greater Atlanta Area

Primary BA and Data Analyst on enterprise Customer Profitability reporting platform. Collaborated and advised Senior Leadership in Finance to make Sales Compensation decisions and insights to grow our Customer base. Completed advanced ad-hoc reporting for Financial data through SAP Business Objects to provide analytical insights to business partners, including Order, Invoice, Service Contracts, and General Ledger Data. Participate in the migration of said data-sets into Enterprise Data Lake and reporting through Tableau and HIVE SQL.

Duluth, Ga

Responsible for operationalizing the North American Software Maintenance (SWM) business for all Lines of Businesses (LOBs). Responsible for optimizing the efficiency of the business by tracking all new deals, cancellations, and all other movement that occurs in the region.Maintained the monthly Outlook for all LOBs in North America, which projects the revenue/cost breakdown for the entire year. Used the Extract, Transform, Load (ETL) process in the SAP Business Intelligence (BI) tool to mine through our ERP database for customer entitlement, cost reduction, and revenue recognition projects.

Duluth, Ga

As part of rotational program, held multiple positions across multiple business units. In the Professional Services team, I worked heavily on the SAP BI tool to help gather data when generating multiple SLRPs for all industries that include an Outlook for future years and costs/margins filtered by regions and solutions. I was also on the task force to help consolidate and finalize the 2017 Plan for Global SWM for all LOBs. In software support role, I dealt mostly with the check processing product called Passport and became well versed in troubleshooting issues, providing excellent customer support, and creating reports to document the issues that I work on.

Johns Creek, Ga

Returned the following year on the Analytics team. Used the Extract, Transform, Load (ETL) process in SSIS and SSRS to create reports that were then modified using PowerPivot. Worked together on major project to transform, create, and modify outdated reports to help optimize the process of the Logistics Business unit.

Georgia

My responsibilities included using SQL queries to pull data from the large Macy's database to create a major Advanced Shipping Notice Error Resolution Report. I also helped co-source existing company data from the Oracle database to the new Microsoft tool stack to improve efficiency of data analysis and reporting for the Logistics Business Unit.