Lani L. Mateo

San Francisco, CA, United States **107 +1-415-***-****

adafj0@r.postjobfree.com www.linkedin.com/in/lanimateo

Summary

A detail-oriented SME in Data Analytics and Visualization with strong Excel and project management background driven to help companies achieve growth through data-driven insights and solutions. My 10 years of experience molded me to become analytical while also adopting intuitive business decision making skills developed by directly working with C-suite executives.

Skills

MS Power BI, Python, SQL, R, SPSS, CRM/Qualtrics/Velocify, Encompass, Tableau, ArcGIS, MySQL, Excel/PowerPivot/Power Query, MS PowerPoint, Office 365, Power Pivot/Query, MS Teams, Machine Learning, Data Optimization, ETL, Logistic Regression, Google Sheets/Docs, Basecamp, Smartsheet, Slack, Trello

Education

Master of Science in Business Analytics (MS) August 2019

HULT INTERNATIONAL BUSINESS SCHOOL – San Francisco, California, USA

Master of Tri-sector Collaboration (MS) August 2018

SINGAPORE MANAGEMENT UNIVERSITY - Singapore

International Perspectives on Governance August 2017

BROOKINGS EXECUTIVE EDUCATION – Washington D.C., USA

Bachelor of Science in Social Work (BS) May 2009

UNIVERSITY OF THE PHILIPPINES – Quezon City, Philippines

Experience

WORLD VISION SYRIA – Amman, Jordan June 2019 – August 2019

MS Power BI Consultant

Subject matter expert on Power BI and optimized Syria crisis response decisions for Shelter, Non-food items, Water, Sanitation and Health for a $94 million project targeting 1.7 million beneficiaries

Led the entire SDLC process (requirements gathering, documentation, data collection design and data modeling to management dashboard including interactive maps and reports).

Collaborated with 6 different non-profit organizations operating within the FAST (Facilitating Assistance in Syria Together) Consortium rapid response working group with teams composed of finance, operations, strategy and technical sectors.

Trained a team in maintaining/troubleshooting/optimizing the Power BI dashboards that contain information on operations, strategy and finance.

Assisted senior management decisions by flagging metrics that need attention.

WORLD VISION INTERNATIONAL – Pasig City, Philippines June 2016 – August 2018

Business Analyst (People Analytics). Optimized global workforce data analytics and reporting system benefitting 128 offices globally using MS Power BI, GIS, Excel, Office365, PowerPoint.

Managed cost-efficient process improvement and mentored a cross-cultural team in reporting data from legacy

platform to cloud-based data warehouse and analytics system saving more than $50,000 annually.

Improved accuracy of reports gathered from Qualtrics and optimized report generation turnaround time by 9000% at zero additional cost.

Business Analyst (Strategy and Innovation). Accelerated strategy and business process development in 128 offices by developing automated Power BI dashboard and Tableau analytics for senior management.

Designed Tableau analytics of employee feedback from 2013 to 2017 gathered using Qualtrics and presented key performance strengths, gaps and opportunities to drive improvement in 3 key organizational metrics – leadership, effectiveness and agility in Regions, SOs, Marketing and Research and Development teams and NOs in support to the Chief Strategy Realization Officer.

Coordinated a team of 5 in designing an online Strategy Alignment Review tool and spearheaded use of MS Power BI executing immediate analytics for 68 countries, 21 support offices, 7 regional offices and 20 global centers.

Increased engagement of offices in driving strategy alignment by 22% in 3 months through innovation in online

strategy dissemination analytics remotely accessible to 100% offices.

Analyzed and developed Power BI Strategy dissemination dashboard for the SRO and Partnership Leaders

Support other Business Analysts in revenue analysis, forecasting, ADP analysis among others

LENDERFI – Calabasas, Los Angeles, CA April 2017 – August 2018

MS Power BI Consultant (Remote). Engineered analytical reports in collaboration with a team of programmers and analysts allowing Senior Management to optimize investments, revenue and employee performance.

Directed project management efforts with a team of database administrator, programmer and analysts and maintained 98% delivery of requirements.

Streamlined CRM management analytics system and drove data-driven management of 28 leads and 30 loan officers. Diagnosed inaccuracies in data and steered the team to explore solutions leading to 99 % data integrity.

INTERNATIONAL RICE RESEARCH INSTITUTE – Los Banos, Laguna, Philippines May 2015 – June 2016

Monitoring and Evaluation Specialist. Managed an evaluation project with a team of enumerators and data managers to evaluate agriculture ICT tools impact in farmer’s decisions, farm yield and income.

Developed theory of change and monitoring and evaluation framework for a multimillion-dollar, multi-year project under the Food Staples Security Program (FSSP) of the Philippine national government and facilitated the implementation.

Designed and managed monitoring and evaluation systems and tools to track project progress and supported annual planning of projects.

Provide training to relevant staff in field offices/project on the monitoring and evaluation of project activities

WORLD VISION INTERNATIONAL – Tacloban City, Philippines November 2013 – August 2014

Information Manager. Led and managed the development and roll out of information management systems (Sharepoint reporting, ArcGIS map, Google sheet Reports) for World Vision’s Typhoon Haiyan Global Response with funding of more than USD60 million to support programming and management decisions.

Provided strategic and data-driven insights on budget allocation, logframe plan and donor budget commitments in collaboration with Program Officers

Developed and standardized Operations monitoring and reporting system in all response location covering more than 48 municipalities from relief to recovery phase, tracking figures of more than a million beneficiaries.

Developed operations and management reporting and feedback system for the Response with 400-500 staff.

Information Management Specialist. Support the development and roll out of information management systems for World Vision’s Typhoon Haiyan Global Response.

Developed prioritization framework that guided the development of Response strategy and delivered regular summary reports for operations, strategy, finance and HR to inform allocation of resources

WORLD VISION DEVELOPMENT FOUNDATION - Quezon City, Philippines August 2009 – April 2015

Design, Monitoring and Evaluation Specialist/Team Leader November 2011 – October 2013

Support the Country Program Quality Manager/Program Effectiveness Associate Director in managing country level assessment, baseline, monitoring and evaluation to inform management decisions and ensure effectiveness of programming strategy at the National level.

Sponsorship Relations Specialist – Isabela, Philippines August 2009 – November 2011

Led community development processes with children, families and communities including regular monitoring activities for more than 1,000 children to track progress and impact of community development projects.

Contact this candidate