Forecasted brand-specific sales and cash flow for the Iberia region (Spain and Portugal), enabling targeted market strategies and financial planning. Forecasted customer cash flow and brand-specific sales, improving financial planning accuracy by 15%. Streamlined invoice processing and payment tracking, reducing overdue payments by 10%. Analyzed large datasets to identify key sales trends and actionable insights in Southern Europe, optimizing data-driven decision-making. Developed and maintained sales, cash flow, and KPI dashboards for the Accounts Receivable (AR) team, providing actionable insights for sales and management teams. Generated comprehensive management reports and executive summaries to support data-informed decision-making. Utilized historical data to predict future sales trends, cash inflow, and deliver accurate forecasts for strategic planning. Identified customers with poor payment histories, supporting the Credit Control team in adjusting credit terms and reducing risk exposure. Provided insights on customer behaviour, preferences, and needs to align credit policies with client requirements. Issued invoices and account statements to vendors, ensuring timely payments and transparent credit standings. Applied and removed order blocks based on customer payment timeliness, ensuring accurate data for individual accounts. Shared unallocated and unidentified payments data in the Southern Europe region to support customer credit rankings. Collaborated with marketing, finance, and cross-functional teams to align objectives and achieve shared goals. Conducted regular sales performance analyses, identifying growth opportunities and key market trends. Maintained daily dashboards for payment allocation, order blocking and release, tracking KPIs for Iberia AR and Order Management teams. Managed direct debit and outgoing payments for both direct and indirect Iberia region customers. Processed SAP invoices, billing, and set-offs for due invoices in line with client orders, maintaining billing accuracy. Monitored data management for product, contract, pricing, and invoicing information to ensure data integrity. Updated weekly dashboard scorecards for Iberia and India teams, tracking individual performance and KPI attainment.

ONEPLUS | Jun 2022 - Apr 2023

ORDER MANAGEMENT EXECUTIVE (CONTRACTUAL)

Cleaned and transformed raw data for actionable insights in inventory and sales tracking. Supervised and managed documentation processes, ensuring accurate and complete records. Ensured optimal inventory levels at logistic centers and customer locations, maximizing inventory velocity by analyzing SKU-level product flow data. Maintained continuous supply of stock items aligned with sales rates and forecasts, minimizing service disruptions for customers. Implemented allocation trackers, increasing SKU-level efficiency by 20%. Forecasted purchasing trends and communicated inventory needs to vendors to ensure consistent stock availability. Developed both short- and long-term demand forecasts to support business and sales planning. Collaborated cross-functionally with Corporate Logistics, Sales, IT, and Finance to enhance supply chain performance. Maintained daily stock data reports based on sales figures and purchase orders (POs) raised. Updated data and extracted raw data from internal portals (V2 and E Sales) to maintain data accuracy. Analyze weekly sales data from sell-in and sell-out reports, providing actionable insights to the production team for upcoming production cycles. Analyze business data and user input to improve systems, monitored current processes, and identified optimization opportunities. Established and tracked Key Performance Indicators (KPIs) to manage and enhance performance metrics. Conducted comprehensive operational reviews to design and implement improvement strategies. Oversaw all phases of the supply chain—from purchase order through delivery to invoicing—to achieve 100% end-user satisfaction. Prioritized customers with shorter product lifecycles, ranking them to allocate high-demand products effectively. Created sales orders from purchase orders by verifying stock availability and SKU-level product allocation. Maintained a product allocation tracker to analyze sell-out trends and inform demand planning. Coordinated with customers to expedite orders and handled creation of sales orders, purchase orders, deliveries, invoices, and shipping documentation. Followed up with factories and vendors to ensure timely deliveries aligned with customer-requested dates. Maintained daily communication with the logistics team to ensure materials were ready for scheduled delivery dates. Compiled weekly sales reports for the sales department, facilitating accurate tracking of product performance and success.

LARSEN AND TOUBRO LIMITED | Jul 2017 - Jan 2022

SUPERVISOR ACCOUNTS ANALYST

Built and maintained strong working relationships with key stakeholders to ensure effective collaboration. Maintained raw data and developed dashboards to track labour attendance and productivity by region for each project. Managed customer service relationships, including escalation management, implementation, and execution of carrier EDI onboarding. Conducted regular status calls with customers to discuss service updates and review available service offerings. Processed orders received via phone, EDI, fax, and email, ensuring timely delivery to customer locations. Translated business knowledge into productivity forecasts for each construction project in Odisha regions (Sambalpur, Bhavanipatna, and Talcher). Prepared and presented executive review reports, providing clear insights and recommendations. Collected and analyze complex data to create reports and identify performance trends. Coordinated with the project management team to establish business analytics systems, ensuring timely and organized reporting. Analyze future, current, and open orders to assess business impact and operational needs. Collaborated with cross-functional teams, including Finance, Billing, Safety, and Quality, to support seamless operations across open project sites. Tracked and analyze high-trend forecasting data to inform strategic decisions.

My Education

Take a look at my formal education

Bachelor of Science in Computer ScienceGayatri Vidya Parishad College of UG and PG Courses (Andhra University) | 2017

About Me

Aspiring data scientist passionate about solving problems with data. Actively learning and building skills in BI, statistics, and data analysis. Seeking an entry-level opportunity to apply my knowledge and grow in the data science field

Create Your Data Portfolio for Free

Sai Bhargav Vavilapalli

Senior Analyst

Diageo | Bengaluru

Data evangelist, spreading the gospel of data-driven decision-making.

My Work

Case Study: Net Revenue Management in Excel

Case Study: Ecommerce Analysis in Power BI

Case Study: Analyzing Customer Churn in Excel

Case Study: Net Revenue Management in Excel

My Certifications

Other Certificates

DataCamp Course Completion

Courses

Courses

Projects

My Work Experience