Heidi Guo

Bachelor's

Labor Studies and Industrial Relations

Baker Tilly Virchow Krause, LLP

Strategic Cloud Services Consultant

 Business Systems Analysis & Data Management • Conducted scoping discussions with external stakeholders to develop business and technical requirements documentations and defined data output formats in preparation for ETL processing of structured and unstructured data • Accelerated client adoption of Oracle Reporting & Analytics solution by integrating data visualization and forecasting tools into existing enterprise data management systems • Researched and developed $15M business case for onboarding Business Intelligence cloud solution to identify data patterns and streamline reporting by defining custom calculations with SQL-based formulas and dynamic processing • Optimized cloud performance and business processes by automating data integrations of 900K business users across multiple downstream systems, and created custom data mappings & interfaces to enable database consolidation • Performed fit/gap analysis on system designs across core application modules and consolidated relevant user insights into progress reports to recommend actions and prioritize resolutions  Agile Project Management • Translated technical business requirements and created user stories for mission-critical Approval Workflows functionality • Tracked metrics and resolved escalated tickets across system implementations and presented weekly status dashboards • Executed proof-of-concept SDLC implementation to validate system feasibility and reliability through iterative test scripts  Operational Change Management • Conducted User Testing workshops with client focus groups and functional leads to communicate process enhancements • Led a 5-member team developing a 30+ technical training repository to enable knowledge transfer for global users • Maintained data integrity by interpreting business rules, access controls, and data requirements to meet compliance needs