Data Analyst Sr | R & shiny developer | Webscraping | GIS | BI | Big data | Automation

- Research, integration, and data analysis to support decision-making and the development of financial products aimed at meeting customer needs. - Automation of analysis and reporting for monitoring OKRs and KPIs. - Development of dashboards with PowerBI. - Development of scripts, data flows, and dashboards with Stratio to address business questions. - Participation in data migration projects and creation of regulatory structures. - Development of Shiny applications with Docker in Azure, including modules for data capture, LaTeX-based reports, storage in Google Drive and Blob Storage, integration with Entra ID, layer intersection and WMS, API consumption, territorial profiling, early alerts, among others. - Web scraping of various public portals such as SuperCias, SRI, Judicial Council, and private ones such as Weather Underground, ASC-AQUA, ISCC, Global GAP, FSC, Rainforest Alliance, Google, Google Maps, among others. - Scraping and data mining from xlsx, pdf, word, and other file formats. - Spatial web scraping, extraction of cadastral data from 55 cantons in Ecuador, automation of map image capture, digitization, mining, and transformation into polygons. - Creation of maps and geographic analysis with R and QGIS. - Support in the implementation of a satellite crop monitoring project through consumption of climate data APIs, integration, analysis, and calculation of indicators from satellite images. - Development of a mobile application with Flutter for data capture and polygon creation for the satellite monitoring project, with online and offline modules integrated with Firebase.

• Business analysis and support Provide BI services and respond to analytical requests to address strategic and tactical business needs. • Predictive and segmentation models Design, build, implement, and deploy predictive and segmentation models to generate customer insights and support decision-making. • Data-driven solutions for commercial strategies Develop solutions that enhance the effectiveness of customer acquisition, monetization, and loyalty strategies, identifying behavioral segments to deliver tailored services and offers. • Information availability Make analytical model outputs accessible through databases to enable tactical campaigns aligned with business strategies. • Campaign monitoring and evaluation Oversee the development and execution of tactical campaigns, testing the performance and effectiveness of proposed models.

- Team leadership Lead the modeling and indicators team. - Risk identification studies Supervise and develop studies on risk identification in public procurement. - Risk evaluation methodologies Implement methodologies to assess risks that support the supervision of procurement procedures. - Mathematical and statistical modeling Develop mathematical and statistical models to evaluate and measure risks in public procurement and their evolution. - Risk analysis automation Automate risk analysis, generate statistics and compliance indicators, and create alerts for potential risks. Automate monthly, weekly, and daily reporting using Markdown, R Presenter, Slidify, and LaTeX. - Web applications and dashboards Implement and develop web applications (dashboards) for consultation, control, data capture, and information visualization using R, integrated with SQL databases, automatic processing, and nationwide institutional deployment with user authentication and role management. - Advanced analytics Apply data mining, text mining, link detection, and intelligent reporting.

- Portfolio monitoring and statistics Prepare statistics and conduct monthly, weekly, and daily monitoring of the bank’s most relevant products nationwide, including Credit Cards, Mortgage, Consumer, and Automotive loans, focusing on admissions, delinquency, charge-offs, and recoveries. - Product simulators Develop and update simulators for the approval of different banking products. - Payment capacity and allocation models Update models for payment capacity assessment and credit allocation. - Specialized analysis Implement special analyses of charge-offs and recoveries to support portfolio sales. - Automation of statistical and economic analysis Automate statistical, microeconomic, and macroeconomic analyses with dynamic reporting.

- Quality analysis of statistical operations Conducted quality assessments of statistical operations within the National Statistical System. - Development of quality analysis tools Designed and implemented tools to evaluate the quality of statistical production.