Mayra Arango Email & Phone Number

Seattle, Washington, United States

- Design, implement, and manage data warehouses to support the business intelligence needs of multiple departments.- Perform complex data analyses using Alteryx to manage ETL processes across multiple systems, streamline workflows, and automate data feeds into SQL tables and Tableau reports.- Use SQL Management Server for efficient data storage management and query optimization.- Develop interactive dashboards and reports in Tableau to visualize KPIs, financial metrics, and operational performance across the organization.- Collaborate closely with stakeholders to understand reporting requirements and deliver clear, data-driven insights that support strategic decision-making.- Maintain data integrity and accuracy within data warehouses and reporting systems to ensure reliable insights.- Present findings and recommendations to non-technical audiences, fostering a culture of data literacy and clear communication across the organization.

- Wrote business requirement documents for the development of an ETL pipeline that ingests and curates Project Management system.- Researched and identified API endpoints to Zendesk and Project Management system and documented objects and fields needed in ETL.- Parsed JSON to understand the data structure of Project Management system objects and created database relationship diagram to visualize relations between objects.- Built Looker dashboards that monitor Salesforce data quality and created data validation tests for the data; increased data accuracy to 95%.- Communicated programs status to principal stakeholders on regular cadence.- Supported the Looker audit program by communicating with data asset owners on deprecation plans of unused Looker assets.

Ibague, Tolima Department, Colombia

- Designed, implemented, and evaluated programs related to the Colombian peace and reconciliation process.- Developed methodologies and execution of conflict transformation workshops.- Led conferences to teach principles of the peace process to hundreds of participants. - Designed and developed a historical database to track and analyze organizational KPIs, increasing population enrollment by ~20%.

Colombia

- Designed international cooperation projects that empowered communities displaced by armed conflicts in Colombia.- Assisted with the implementation of the "Empowerment of the relocated and receiving community of Tuluní- Colombia" project, in association with ACNUR and the NGO Colombia Euskadi from Basque Country to provide employment through the creation of hosting services in the tourist areas of Tuluni.- Coordinated the delivery of equipment and utensils to meet the basic needs of people living in elderly care centers as a part of our “Improvement of conditions in community care centers for the elderly in Ibagué,” project.

Master Of Science In Information Systems, Computer/Information Technology Administration And Management, Gpa 3.71

Bachelor'S Degree, Political Science And Government, Gpa 3.54