Ziyan Ou

Senior Financial Data Consultant @Acclarity

Fort Lauderdale, FL, US

Spearheaded the development of multiple digital automation processes to support a client\'s annual and monthly cash collection reconciliation efforts. This included creating over 100 Alteryx workflows and various Tableau and Excel reports. The resulting workflows and outputs were highly successful, with 100% client satisfaction• Established and customized sophisticated ETL (extraction, transformation, load) solutions for clients, utilizing SQL for data retrieval, Alteryx for data processing, and Snowflake for database management. These solutions greatly improved the efficiency of client engagements, resulting in streamlined processes and increased productivity• Constructed multiple Excel financial models for clients to analyze the quality of earnings and report the profit and loss (P&L) statements; also leveraged data analytics tools to extract and generate raw data to populate the Consolidated Trial Balance