LISA Rancourt

Google Payment Platform

• Enhanced data quality by implementing rigorous validation processes and best practices.
• Led initiatives to streamline reporting processes, reducing turnaround time for analyses.
• Facilitated seamless integration of acquired company''s data systems by mapping critical fields between databases and performing extensive reconciliation efforts.
• Developed customized reports, summarizing and presenting data in visually appealing format.

• Scrape and manipulate data from different sources using SQL; leverage Tableau to create streamlined, one-click dashboard, significantly minimize time spent on weekly monitoring
• Initiate enterprise level of KYC monitoring dashboard for a major payables and receivables, spend and expense, and invoice financing product, doubling capacity to deliver real-time analytics
• Pipe critical compliance data for analytics, enabling an automated comprehensive report
• Transform a series of KYC review QA into analytic tools, doubling audit effectiveness and efficiency

• Designed Tableau dashboard to visualize core business KPIs and ensure effective investment and resource allocation

• Managed partnerships with 26 organizations in Central America; built relationship with 20+ new customers across 5 countries, increasing contact network by 10% in 1 month

• Built functional platform of ACL code used by a team of data analytics to support data cleansing, preparation, and exploration, reducing workload by 30%
• Formulated and designed visualization to achieve business objectives using advanced spreadsheet and Qlik, driving incremental $300K in annual revenue
• Transformed a series of journal entry testing into analytics tools, doubling audit effectiveness and efficiency
• Audited 35+ financial statements per year and generated risk profiling reports, under limited timeline, saving 35% of project’s budget, System Integration
• Served as part of a PMO team for SAP governance, risk and compliance (GRC) development; prioritized features, gathered requirements, conducted A/B testing, coordinated with 50+ major stakeholders for user acceptance test (UAT), collaborated with engineers, and developed reports

• Worked collaboratively with cross-functional team of 15+ to conduct risk-based internal controls review, improving 45+ areas of IT operational risk management for major bank
• Oversaw workflows of business process, and IT security and control to conduct audit, risk assessment, gap analysis, and fraud investigation for 20+ $100K – $2M projects

• Worked closely with board of management to extend business and customer relationship, company successfully opened one international branch