Daniel Sakai Email & Phone Number

Los Angeles, Ca, Us

• Utilized SQL to construct, aggregate, clean, and manipulate datasets from diverse sources ensuring high-quality data for analysis• Created the 2023 and 2024 BI trade forecast to assist the Finance Department in their annual forecasting• Designed a data-driven metric to define ‘hyped’ products using Google Analytics and market data, enhancing quarterly and annual trade forecast accuracy• Collaborated with the Engineering team to identify and bill items omitted from storage fee calculations, driving a 150% increase in storage fee revenue• Created Tableau reports which streamlined the month-end close process that saved the accounting team 12+ hours per month• Applied standard statistical methods to analyze complex datasets, offering valuable insights and succinct summaries for informed decision-making• Crafted 50+ dynamic and user-friendly Tableau dashboards allowing teammates, business partners, and executives to track key performance metrics and delve into historical trends• Effectively communicated analysis results to both technical and non-technical stakeholders, ensuring a clear understanding of insights and facilitating collaborative discussions• Collaborated seamlessly with engineering, marketing, operations, and product teams to develop comprehensive analytic solutions for new inventory system

• Developed a multiple regression model to more accurately forecast monthly store utility accruals• Analyze monthly store P&L reports and notated within the financial packages the variances compared to the annual budget and prior year numbers• Developed a streamlined process that saved 6 accountants 3 months of information collection and review time for property tax submissions• Prepared projections and reconciliations of bi-monthly Instacart fees and rebates, saving the company $20,000 a month• Created a new process to project service expenses that each store incurs every month• Diligently reviewed lease contracts to keep ensuring the rent, Common Area Maintenance (CAM), and percentage rent calculations were accurate and up to date• Calculate the rental and percentage rent payments to landlords each month• Prepare General Ledger entries and maintain reconciliation spreadsheets (including the primary bank account reconciliation) for month-end closing; ensured closing of books in a timely manner• Prepare monthly account analysis of balance sheet and income statement accounts• Responsible for all the journal entries related to the in-store pharmacies• Created ad-hoc reports that were distributed to internal and external parties• Collaborated with multiple team members to optimize Oracle Fusion usage by eliminating redundant processes, saving everyone one day during month end close• Coordinate with IT department to update month end inventory process• Completed ad-hoc reports and provided assistance during our acquisition by a publicly traded company • Provided effective supervision and guidance to junior accountants, fostering professional development within the team

• Analyzed bank and transaction activity to create new bank reconciliations for transaction processing• Developed and implemented the process to collect over $300,000 in A/R amid changes in bank reporting• Supervised the procedure to process over 100,000 ACH transactions on a daily basis • Assisted internal auditors in preparation for the company's public listing on the FTSE 250• Streamlined month end close process from 8 days to 3 days• Created the process for health insurance intercompany billings for over 700 employees• Worked with the Oracle consultants, internal IT teams, international IT teams, and international accounting teams to ensure a smooth accounting system migration and implementation from MAS to Oracle • Researched and explained trends and variances for multiple accounts for monthly financial and cost center reporting. • Created a report based on compiled employee expense reports for review by management on a monthly basis that helped departments keep track of monthly budgets and project future budgets• Produced journal entries for month end close, reversing accruals, and maintained bank reconciliations • Processed invoices for A/P and recorded payments for A/R• Assisted Accounting Manager and Director of Finance with the year-end close process, annual audit, and budget process.• Prepared trial balance and financial statements • Performed ad-hoc duties and reporting as requested by management

Orange County, California Area

• Conducted reviews to ensure merchants’ websites were compliant with agreed upon guidelines• Sent correspondence regarding the reviews to the merchants• Answered intra-office questions regarding compliance guidelines• Prepared reports by collecting, analyzing, and summarizing information

• Assisted with maintaining complex financial data to keep client finances current• Prepared journal entries, bank reconciliations, and trial balances• Reviewed accuracy of colleague’s work• Developed a system of organizing documents which increased record keeping efficiency

• Used statistical software to gather and analyze qualitative and quantitative Nielsen viewership data• Created and reviewed sales/proposal packages to support the sales team• Managed and maintained the client database

• Gathered and cleaned economic data• Used statistical software, Stata, to conduct analysis of complex economic and financial data• Created a database that eliminated 50 lines of coding• Communicated with potential sponsors

Orange County, California Area

• Performed broad analysis of potential opportunities in which to market the company's services• Communicated importance of company's positioning services and provided follow- up support• Further developed customer service communication and directed interested clients to the sales team

Bachelor'S Degree, Business Economics

Minor, Urban & Regional Planning