Luis Quesada - Analytics Analyst,

Feedback from Luis’s ex-colleagues

Let me see

Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app

Work Background

Experian Consumer ServicesAnalytics Analyst

Nov. 2024Costa Rica

VMwareSenior Data Analyst

Jul. 2022 - Dec. 2023Costa Rica• Leveraged Presto, SAP Hana, and SQL to extract data, creating dashboards with Tableau, resulting in enhanced partner activity insights and a significant increase in VMware sales and product usage. • Refined Tableau dashboards to track campaigns, products, sales leads, and metrics, leading to improved marketing analytics services and actionable insights. • Updated SQL scripts on Spark to modify datasets, supporting comprehensive and accurate marketing analytics dashboards. • Monitored ETL processes using Informatica, detecting failures and implementing restart activities, which resulted in improved data reliability and efficiency. • Analyzed Python scripts to identify and correct data errors, resolving issues within the ETL process and ensuring data integrity.

Western UnionSenior Data Analyst

Jan. 2020 - Jun. 2022Costa Rica• Data extraction and analysis using SQL and Snowflake to determine flawed transactions affecting customers. The results were transformed in several ways using Alteryx and the outcomes were used for further processing giving appropriate remediation to affected customers and fulfilling compliance requirements for the business. • Defining strategies to clear the backlog of remediation cases coordinating activities with the robotics team to simplify the automation process and consolidating related data. • Using Hive, Impala, Snowflake and SQL provide specific product analysis to determine potential risks of fraud. Provide recommendations to avoid it. • Design a new database schema for fraud monitoring dashboards, to allow better performance for millions of rows, better user experience, refresh scheduling and lower refreshing times. • Reports and dashboards creation using Power BI (including Internal database design) and Snowflake as the data source for regular fraudulent activity monitoring. • When fraudulent activities were detected, extract and analyze related data (SQL and Snowflake) to determine dates, impacted products, funding, countries, amounts and, recommendations to stop the attack and provide input to create new rules. Depending on the impact, results needed to be communicated and explained to interested parties to prevent this situation from happening in the future. • Collaboration developing machine learning models to detect fraudulent transactions, resulting in reduced fraud rates and avoiding losses. • Prepare data for machine learning models using SQL, Snowflake and Python. • Create scripts in Python for data wrangling when needed.

FiservData Analyst

Aug. 2018 - Jan. 2020San Jose, Costa Rica• Generate periodical debit card marketing campaigns for clients, applying sampling, business constraints, and evaluation using SQL and Netezza. The campaigns increased revenue for clients and more engagement with the company. • Report automation to communicate campaign results for many partners and clients using Excel and VBA, this automation saved resources and time and provided faster and more accurate results. • ETL Package and database design and development for specific clients and projects. Queries from the created database were used as input for statistical and machine-learning models and report creation. These projects allow the team to have more structured and quality data generating more accurate results in less time and reducing processing loads. • Feature engineering for predictive modeling using SAS, these new features increased the accuracy of machine learning models to select customers with bigger potential to respond to the campaigns and better results and services to clients. • Data extraction and ad-hoc analysis using SQL, Netezza, and Excel.

abcQ SolutionsSenior Software Developer and Consultant

Apr. 2007 - Aug. 2018San Jose, Costa RicaDeveloping different projects using agile methodologies for several industries : Finance and Banking, Refrigeration and Air Conditioning, Automotive, Call Center, Printing and Publishing. Including: DataMarts and Multidimensional Databases using Microsoft BI Tools (SSRS, SSIS, SSAS) Database development SQL Server 2012+, Replication, automated processes.(TRANSACT SQL). Exposing database information using Google Maps and MAP APIs Web Applications Development Full Stack (ASP.NET MVC, Forms, IIS, SQL Server, Oracle, MySQL, Front End: Javascript, jQuery, HTML5, CSS3). Azure Deployments

Banco Nacional de Costa RicaSenior Business Intelligence Developer

Jan. 2005 - Apr. 2007Costa RicaAlgorithms for customer segmentation. Customer evolution Transaction Analysis for promotions and offers. Algorithms to measure and classify business volume and profitability Consumption ideals by customer segment and potential Data mart building ETL Process and Multidimendional databases

Banco Nacional de Costa RicaSenior Business Analyst

Jan. 2001 - Dec. 2004Costa RicaCRM Model development Customer, products and transactions data cleaning and integration. Customer segmentation, demographics Business and profit volume individual analysis Business potential based on segments

Banco Nacional de Costa RicaWebmaster

Jan. 1997 - Dec. 2000Built and implemented the first intranet for the bank. Business requirements gathering and analysis. Internal cultural change to use automated tools.

Banco Nacional de Costa RicaNetwork Administrator

Jan. 1992 - Dec. 1996Network administrator of the Human Resources Department of the bank. Develop custom applications for HR Information extraction and cleaning for HR research

Banco Nacional de Costa RicaOffice Associate

Oct. 1986 - Dec. 1991Office worker: Checking Accounts, Assets Management Technical: Job Evaluation and Position Classification Procedures