Sai Krishna Kolusu
Senior Data & Pricing Analyst
Ras Al-Khaimah,RK
Summary
Result-oriented professional with 07+ years of hands on experience in Sales, Operations, Pricing & Data Analytics. Made significant contributions over the years in all held positions that helped in driving business for the company. Focused on optimizing operations and motivating employees while establishing market dominance.
Overview
8
8
years of professional experience
4
4
years of post-secondary education
1
1
Certification
4
4
Languages
Work History
Senior Executive
RAK Ceramics PJSC
Ras Al-Khaimah, UAE
06.2021 - Current
- Executed a deep-down Price Analysis of all the tile markets, which helped in tapping out a better share of profits, which the company was losing out as opportunity cost.
- Performed Data Mining and Data Analysis activities to design and build dashboard wireframes as per team requirements.
- Design various Analytical Reports related to production, sales, inventory control, and pricing.
- Managed KPI Reports in collaboration with the team heads of all export markets . Analyzed data and used visualization techniques to create solutions that enhanced business performance by 15%. (w.r.t export shipment facilitation)
- Monitored shipping and inventory status on a daily basis and produced analytical reports indicating country-wise performances.
- Framed a Demand Planning & Forecasting Model for all RAK tile products through coordination with sales and operations team.
- Responsible for the daily Planning and Scheduling of reprocessing requirements of tile orders, monitoring new developments and their implications in the product mix.
- Enhanced the efficiency of the reprocessing activity in RAK tiles by 50% with increased productivity rates utilizing existing workforce. Automated and streamlined the reprocessing procedure which simplified the processing & planning time.
- Provide training to Users through on-site or virtual sessions.
Executive
RAK Ceramics PJSC
Ras Al-Khaimah, UAE
05.2017 - 05.2021
- Initiated daily customer Shipments worth AED 40 M in the Saudi Arabia market.
- Coordinated with sales, warehouse, accounts & production planning team to ensure the Timely execution of customer orders.
- Maintained all necessary data relating to customer orders, price, delivery dates etc. and documents including preform invoice, sales order, customer review and feedback forms.
- Contributed to a better planning of tile production by collecting customer feedback regarding their priority requirements.
- Ensured Minimal inventory levels at all times through continuously monitoring of physical stock held by the customer.
Junior Executive
RAK Ceramics PJSC
Ras Al-Khaimah, UAE
02.2015 - 04.2017
- Supervised materials in production, dispatch, and stock.
- Updated BOM for production and stock materials.
- Managed and updated raw materials requirements in plant.
- Worked as the SAP core user with access to all production entries and routings.
- Facilitated KPI reports in collaboration with all the Production Managers.
Education
Bachelor of Engineering - BE - Mechanical Engineering
Jawaharlal Nehru Technological University
Hyderabad, India 05.2009 - 05.2013
Skills
Process OrientationData Analytical Skills
Team Leadership
Sales OperationsOperations oversight
SAP ERP
SAP Cloud For Customers (C4C)
Supply Chain Management
Microsoft Power BI
Microsoft Power Automate
Microsoft Office 365
Projects
Part of Implementation of SAP Cloud for customer (C4C) - (11/2021 - 02/2022)
Key Highlights:
- Lead Management to capture information about Leads, which will get from various sources.
- Account Management to retrieve all follow-up items, like Leads/Opportunities/Appointments/Tasks created against an account.
- Opportunity marks the start of the sales cycle and assigns different Sales Phases against the Sales Cycle allowing the sales team to track and manage the deals and understand the sales cycle.
Revamping of Pricing Structure - (11/2021 - 11/2022)
Key Highlights:
- Minor customization in SAP to have desired key combinations in condition type.
- Market-based pricing strategy to get the company list price.
- Price master review on case to case basis depending on the changes in the market trends.
- Customer classification based on bucket size and long-term loyalty.
- To activate actual and fixed freight conditions.
- Reviewing material master cluster attributes.
Microsoft SharePoint Workflow Process Automation - (11/2022 - Present)
Key Highlights:
- Design prototype confirmation and Form validation.
- Project review meetings and end to end testing
Part of SAP Change Request - (06/2022 - Present)
Key Highlights:
- Slow Moving Stock Liquidation Report.
- Analysis of Residual Make to Order Inventory.
- New Order Type For Blocking Materials
- Product Life Cycle Report
- Sales Order Pricing and discount Report
- Delivery Performance Report
Certification
SAP Certified
Timeline
Senior Executive
RAK Ceramics PJSC
06.2021 - Current
Executive
RAK Ceramics PJSC
05.2017 - 05.2021
SAP Certified
09-2016
Junior Executive
RAK Ceramics PJSC
02.2015 - 04.2017
Bachelor of Engineering - BE - Mechanical Engineering
Jawaharlal Nehru Technological University
05.2009 - 05.2013