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

• 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

• 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

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