Subject matter expert and lead data analyst supporting the Digital Transformation Project. Managed identification and flow of critical financial data required in new system implementations/process and required communications across multifunctional departments. • Partner with internal business teams and stakeholders in developing delivery roadmaps and associated system requirements for FP&A planning processes.• Prepared and enhanced finance report for the Hyperscalers and A&G customers' quarterly orders (~$224M) and revenue (~$207M) and provided analysis for the CSO and Sales leadership team to explore the potential growth markets.• Utilized Snowflake/SQL and Excel to analyze and validate data from source systems, files and enterprise data warehouse. Identify the variances and fix the problem for the planning and actual data in BPC, BW and Anaplan.• Certified Anaplan Level 2 Model Builder, Anaplan Admin, and COE, responsible for maintaining 8 individual models for FIN/PPL/OOC/Legal teams.• Managed Anaplan functions for monthly and quarterly end closing processes across multiple BUs and models, ensuring data flow into each model on time and accurately.• Collaborate effectively with Finance, HR, and IT team to transform and implant the new finance system• Maintain and validate the weekly requisition report and proceed data through Fivetran to Snowflake and Anaplan.

Manage multiple projects involving lines of business within retail planning business to improve forecasting and financial reporting. Responsible for monthly forecasting, procurement, planning, projections and reporting.• Prepared and analyzed monthly and quarterly reports in a timely manner, including compilation and analysis of data to be included in monthly retail EBITDA flash communications• Improve and assure the quality and automated routing reporting processes to save the team and leader more time for more creative or strategic activities and decision making• Help to implant the new platforms (From SAS EG to SAS Studio, Python and Snowflake) to improve the automation processes• Develop reports to compare forecast and actual results for use by business managers in the field• Work closely with IT department to develop and support financial reporting and analysis requirements• Apply advanced Excel modeling and data analysis techniques to transform detailed transactional source data into financial reports accurately• Consistently drive process improvement through the development of new strategies

Conducted deep-dive financial analysis for a $250 million credit program, providing insights to senior management. • Developed financial models and ran scenario analysis to optimize financial revenue calculations and identify areas of risk and opportunity. • Utilized SQL to generate in-store and e-Commerce costs and sales results for regional VPs' meetings. • Collaborated with cross-functional teams to provide analytical support for pre and post-promotion analysis.

• Prepared annual budget,revenue forecasts and monthly sales target reports for more than 3,000 facilities using Hyperion/Smart View • Created finance models (NPV/IRR), monthly promotion sales analysis workbooks, month end variance reports to help finance and marketing leadership with strategy decisions

Prepare billing invoices for 4 different projects with over $3 million transactions and report directly to the Deputy General Manager. Organize and validate the quotation files from over 170 vendors to establish the price file with over 20,000 parts by using Moving Average Price methodology.

Performed period end close processes (for 25 stores with over $100,000 transactions daily) covering account reconciliations, posting related JEs to GL, coordinating tax compliance across 18 states, detecting and reporting on abnormal cash activity to CEO/CFO directly

Responsible for training and scheduling of 4 employees, ensured compliance with all process/financial policies. Worked with Division Management to align production with store promotions.