SHAINA KAYE DE GUZMAN

• Led monthly and quarterly variance analysis reviews, providing valuable insights by comparing actual results to budget and forecast expectations.
• Collaborated with cross-functional teams to drive process improvements and enhance operational efficiency.
• Enabled informed decision-making by presenting key findings from complex data sets in clear, concise formats to senior leadership.
• Trained new analysts on corporate policies and procedures; implemented a mentoring program that reduced onboarding time.
• Analyzed statistical data to identify financial trends, supporting investment planning and strategic initiatives.
• Ensured regulatory compliance through diligent review of financial documents and reporting procedures.
• Developed comprehensive financial models to support strategic decision-making and business planning.
• Improved financial accuracy through in-depth analysis of financial data, forecasts, and trends.
• Conducted ad-hoc analyses to support cost-reduction initiatives and optimize resource allocation across departments.
• Created and maintained detailed financial models, dashboards, and reports with a high degree of accuracy.
• Developed financial strategies to optimize portfolio performance while minimizing risk exposure.

• Developed and maintained data workflows using Alteryx, SQL, and Tableau to ensure finance and global services data were accurately transformed into actionable insights, aligned with industry best practices.
• Utilized SQL scripting in Data Lab (Databricks), SQL Data Warehouse, and EDL Cloudera to build scalable data pipelines feeding into Tableau and Power BI, supporting financial dashboards and performance tracking.
• Led enhancement and hypercare processes for finance-related dashboards under the Reimagine Project, gathering requirements from stakeholders to align reporting with business and financial objectives.
• Collaborated with finance and business stakeholders to define reporting needs and translate raw financial data into clear, actionable insights using ETL processes, advanced analytics, and data visualization tools.
• Delivered key financial insights and strategic recommendations through dashboards and reports, enabling senior stakeholders to make data-informed budgeting, forecasting, and resource allocation decisions.
• Directed business analysis and requirements gathering to develop Business Intelligence (BI) solutions that streamlined finance and accounting reporting across departments.
• Managed and maintained financial data pipelines and reporting tools created by the Data Transformation and Business Intelligence Team, ensuring accuracy, consistency, and compliance.
• Spearheaded the Reimagine Project, producing operational dashboards to track financial performance metrics, reducing manual reporting time by over 3,200 minutes and minimizing ad hoc requests.

External Senior Auditor

• Acted as remote team member for United States, New Zealand, Australia, Singapore, Malaysia, Hongkong, establishing clear and effective communication channels to execute audit tasks efficiently.
• Audited financial statements and managed multiple accounts for diverse client industries such as Oil and Gas, Technology, Retail and Merchandising, demonstrating a proficiency in financial analysis and reporting.
• Analysing and reconciling accounts and reviewing financial reports.
• Preparing journal vouchers and reviewing transactions for entry into the accounting systems.
• Actively engaged in a fiscal year audit for a prominent diverse industry, demonstrating expertise in managing complex audit engagements, compilation, and review engagements.
• Preparing working paper files for planning audit procedures.
• Performed substantive analytical procedures in which we tested if there were material misstatements at the assertion level. Performed journal entry testing, involved in test of details, performed using non statistical sampling procedure (classes of transactions, account balances and disclosure).
• Preparing working papers for the procedure performed in a concise and organized manner and meet the requirements set forth in the audit.
• Extensive experience with Excel and various financial software applications, utilizing spreadsheet tools and programs to maximize operational efficiency and data accuracy.
• Demonstrated proficiency in general ledger management, GAAP compliance, financial statement presentation.
• Create working papers documenting the procedure performed in a concise and organized manner and meet the required audit practice.
• Mentored junior auditors, contributing to their professional development and enhancing team performance.

Data Analytics

• Providing innovative analytical insights within the data products program.
• Preparing working papers for the procedure performed in a concise and organized manner and meet the requirement set forth in the audit.
• Maintain relationships with the teams to create analytics request that allows to understand, cleansed, and transform complex data sets from various audit software to an easily digestible format using a standardized analytics approach and utilize data analytics tools.
• Conduct detailed data analysis on data used across business units to evaluate business processes and improve on/create new feature or provide recommendation.
• Reviewing and commenting, where necessary, on task performed on the changes and new used in business units in relation to data analytics techniques and audit.
• Strong understanding of business processes and related risk particularly those that impact financial reporting.
• Performed various data analytics in ACL, Alteryx and MS Excel using statistical models or industry accepted tools.
• Deeper understanding and experience with PowerBI, SQL, Alteryx and Tableau.
• Create working papers documenting the procedure performed in a concise and organized manner and meet the required audit practice.

Project Management and People

• Maintaining relationships with the engagement teams and monitoring team’s progress against business plans/performance objectives and driving performance as required.
• Developing team members through formal and informal coaching and facilitating in-house training – both functional and industry.
• Conducting performance reviews and providing performance feedback (formal and informal) in a timely manner

• Providing services for international clients specifically handled Australia, Hongkong, New Zealand, Singapore, United States and Papua New Guinea
• Preparing updates for weekly or monthly call with audit teams across the firm such as Australia, New Zealand, etc
• Managing over a portfolio of clients and delivering high quality audits and assurance services, including preparing or reviewing financial statements and other reports
• Reviewing and approving of the work done by staffs such as Halo for journals, data transformation, Test of Details, and other deliverables for clients
• Communicate and provide timely updates to clients on the status of the work assigned and monitor progress work and manage deadlines
• Provides timely advice to the clients on the utilization of audit tools appropriate for the client and helps in interpreting the reports generated by the client’s accounting system
• Helps to assist engagement team to perform ITCG's to determine the accuracy, completeness, validity and authorization their financial statements
• Maintaining the highest technical and professional standards by understanding the client’s industry, key performance drivers, business trends, and emerging technical and industry developments
• Achievement:
• Consistent performance assessments with an exceptional rating

• Perform Manual Control Testing which helps to trace transaction and test operation if designed effectively
• Assisting Data Assurance team in Australia to perform Financial Process Analysis (FPA) by utilizing the tools such as Alteryx and PowerBI
• Perform IT General Controls for all branches for Hongkong and Shanghai Banking Corporation (HSBC) across the globe
• Examine controls, evaluate the design and operation effectiveness, determine exposure to risk and provide recommendation to the engagement teams
• Performing services like Financial Statement preparation, test of details, electronic audit file set-up and maintenance, analytics assistance, data transformation and performing manual testing control
• Identifying problem transactions and irregularities in related accounts, proposing corrective actions and accounting entries
• Preparing journal vouchers and reviewing transactions for entry into the accounting system
• Providing information needed to respond to auditors’ requests
• Analyzing proposals from candidates for external audit exercise
• Achievement:
• Promoted to Audit Analyst position with an exceptional rating