Prathika Cheerala

• Prepared monthly and quarterly financial forecasts covering $100M+ in revenue, analyzing trends across sales, cost structures, and market conditions to support strategic decision-making. • Conducted detailed financial studies across departments, producing actionable insights that led to a 12% improvement in working capital efficiency. • Assessed current and projected performance metrics to identify $2M in potential cost reduction opportunities and mitigate financial risk exposure • Processed and reviewed journal entries each quarter, ensuring 100% compliance with SOX controls and GAAP standards. • Analyzed and reconciled financial data from over various business units to produce accurate general ledgers and contribute to monthly and year-end financial statements. • Delivered several financial reports per month to internal stakeholders and external auditors, improving reporting accuracy and timeliness by 25%. • Partnered with cross-functional teams (finance, operations, supply chain) to develop and present specialized reports that supported executive level decisions on capital investments and budgeting

• Conducted comprehensive analysis of marketing campaigns' ROI, utilizing advanced Excel functions, including Pivot Tables and VLOOKUP, resulting in a 15% reduction in low-performing campaigns and a 20% increase in overall ROI. • Collaborated with marketing teams to develop accurate revenue forecasts, leveraging data-driven insights and statistical models to improve forecasting accuracy by 10%. • Utilized SQL to streamline data gathering, enhancing the speed and accuracy of quarterly financial reviews. • Played a pivotal role in month-end close by reconciling marketing spend data and actual results, ensuring alignment with budgeted figures, and providing accurate financial reports to senior management. • Analyzed marketing attribution models to determine the impact of various touch points on customer conversion, leading to a more efficient allocation of marketing resources and a 12% increase in conversion rates. • Managed and maintained marketing data integrity within NetSuite and Smartsheet, ensuring accurate financial reporting and facilitating seamless financial and operational data integration. • Streamlined financial reporting processes by optimizing Oracle queries, reducing report generation time by 30%. • Actively participated in ad-hoc financial and operational analyses, offering data-driven recommendations that led to a 15% reduction in operational costs while maintaining or improving campaign effectiveness. • Conducting in-depth cost analysis, resulting in a 15% reduction in operational expenses through targeted cost-saving initiatives.

• Developed Python scripts for data validation, enhancing data accuracy and integrity in monthly financial reports. • Analyzed large datasets using pivot tables, VLOOKUP, and other advanced Excel functions to extract key insights and present findings to senior management. Involves the calculations and documentation using MS Excel, MS Word, and MS Access. • Utilized SQL to extract, manipulate, and analyze financial data from multiple databases, providing actionable insights to senior management for strategic decision-making. • Developed complex financial models to support strategic decision-making, including forecasting, budgeting, and scenario analysis. • Conducting thorough financial analysis and risk assessment to provide insightful recommendations to clients and internal stakeholders. • Led a team of analysts in designing and implementing a streamlined Excel-based reporting system, reducing reporting time by 30%. Designed custom visuals using Power BI's capabilities to display trends, outliers, and correlations within financial data. • Developed, calibrated, and maintained credit risk models to assess the creditworthiness of clients, resulting in a 15% improvement in risk assessment accuracy. Strong attention to detail and commitment to accuracy in financial reporting.