Data Analytics Financial Reporting
Resume:
YAN RAN
Miami, Florida *****
Email: *********@*******.***
Cellular: 305-***-****
CAREER SUMMARY
Data analytics consultant in the areas of accounting and finance, developed and implemented a range of technological solutions and financial models to complex problems, working with a variety of companies and departments. Extensive experience in data analysis, business intelligence, project management, financial modeling, and process improvement.
PROFESSIONAL EXPERIENCE
Financial and Data Analytics Consultant, MassMutual, Boston, MA Jan 2023-Oct 2025
Executed a comprehensive accounting technology transformation initiative, implementing innovative solutions for enhanced financial reporting and analysis.
•Developed and implemented multi period financial models, enabling the organization and strategic partnerships to better plan and adapt to changing market conditions.
•Achieved 30% reduction in manual workloads by successfully integrating new technology into existing systems, while optimizing processes and controls.
•Delivered actionable insights on a daily basis, driving strategic decision making and improving overall financial performance achieving the recorded highest in six years.
Financial Analyst Consultant, Assurant, Miami, Florida Jan 2022-Apr 2025
Developed and implemented financial models to streamline forecasting and planning processes, resulting in a more efficient and accurate financial reporting and analysis.
•Developed and implemented a multi-client/market financial model, used for monthly calculations and analysis, resulting in the reduction of over 240 working hours and in over $100k in annual departmental savings.
•Developed and implemented financial models for forecasting, planning, and for analyzing financial results, across multiple products and markets.
•Directly responsible for implementing data analytics solutions to replace manual with streamlined and automated processes, resulting in decreasing highly time-consuming manual processes, while increasing productivity, efficiency, and client reporting.
Senior Accountant Consultant, Brightstar Corporation, Miami, Florida Feb 2020-Nov 2021
Developed and implemented various financial models to streamline and accurately track the company’s inventory impact on the P&L and B/S, ensuring accurate, timely and more efficient financial reporting.
•Directly responsible for multi period inventory obsolescence analysis across company’s multi business channels, and products.
•Directly responsible for developing and implementing new procedures across multiple departments, resulting in more efficient and productive financial analysis and reporting.
•Streamlined and automated large financial and operational datasets to achieve more efficient, timely and accurate financial reporting, resulting in a significant reduction in close time, as well as the establishment of better internal control procedures.
Senior Accountant Consultant, Crystal Cruises, Miami, Florida Oct 2019-Jan 2020
Assisted in the transition to a new ERP system, developed and deployed technical solutions to streamline existing and new GL structures, to ensure efficient and accurate financial and accounting data integrity.
•Directly responsible for reconciling and streamlining very complex operational accounts in accordance with audit, GAAP and company financial standards.
•Assists in reviewing existing system business rules and financial data flow, resulting in setting up new and more efficient system procedures and interfaces.
•Developed and improved departmental procedures and internal controls in accordance with GAAP and audit standards.
Senior Accountant, Norwegian Cruise Lines, Miami, Florida Jul 2016-Dec 2018
•Directly responsible for multi-factored financial allocations and analysis of revenue by business line including financial accruals, on-board and shore side data transactions automation, analysis, and financial reporting.
•Analyzed ticket revenue, managed and reported on various financial and operational data in accordance with audit and department requests, while reducing departmental redundancy and manual processes which resulted in time efficiency, improved data analytics and accurate reporting.
•Responsible for intercompany transactions and consolidations related to revenue and foreign exchange activities.
•Developed and trained team members on utilizing an automated set of financial models, resulting in the reduction of manual processes, while increasing departmental efficiency and productivity.
EDUCATION
Florida International University, Miami, Florida August 2011
Bachelor of Accounting
OTHER
Computer and Software Skills: Seaware, People Soft, SAP (Business Objects), Hyperion (Oracle), Essbase, Sales Force, JD Edwards (Oracle), Blackline, QuickBooks, NetSuite (Business Software Suite).
Microsoft Dynamics, Microsoft Office Suite (Advanced: Excel Proficiency, Data Analysis, Power Query, and Power Pivot), Power Bi, SQL, MicroStrategy.
Languages: English, Russian & Hebrew (spoken, written & read); Intermediate French and Spanish
Contact this candidate