Jose Israel Rodrigues Laguna

Conceptualized and implemented the complete data layer for a new platform, including data modeling, capture pipelines, ETL development, and statistical analysis using Python and Postgres, ensuring that architecture aligned with long-term scalability and business objectives. Coordinated external efforts on presentation-layer development, overseeing contractors and managing deliverables for data visualization and data capture via Django, while maintaining technical alignment with the core architecture.

Engineered large-scale automation pipelines with Airflow, Python, and Postgres, driving efficiency gains and enabling seamless production workflows. • Spearheaded BI development initiatives from KPI definition through Datamart design to dashboard implementation using Power BI, Quicksight, and Aurora, empowering leadership to make informed decisions. • Instituted comprehensive data governance and QA practices, ensuring data quality, reliability, and compliance across all client deliverables.

Automated mission-critical data pipelines with Airflow, enabling seamless data transfers during the adoption of a new cloud infrastructure. Designed and executed ETL processes to streamline data ingestion and transformation, ensuring consistent delivery of reliable datasets. Optimized database systems by managing DDL/DML operations in Postgres and PL/SQL, significantly improving query efficiency and system reliability. Developed advanced data applications using Java-Spark, Python, and SQL.

Delivered ETLs and BI dashboards for banking, construction, and public-sector clients, adapting designs to industry-specific data structures and regulatory requirements. • Conducted deep data and database analyses with SQL, Hive, Impala, and Hue, identifying performance bottlenecks and implementing corrective actions. • Implemented BI solutions across multiple platforms (Power BI, MicroStrategy, Jaspersoft), equipping decision-makers with actionable performance dashboards.

Developed ETL workflows for high-volume banking projects using Scala, Spark, and SQL, ensuring reliable and timely data delivery for advanced financial analytics. • Analyzed large-scale datasets in AWS and HDFS environments, providing insights into operational performance and improving analytical reporting. • Refactored ETL processes to achieve a dramatic improvement in efficiency, reducing data processing time from 15 hours to just 15 minutes.

Coordinated a 6-person Scrum team, driving alignment between development sprints and business goals across diverse industries including publishing, agriculture, and marketing. • Led AI-driven projects such as sales prediction and harvest forecasting, applying CRISP-DM methodology from data capture through BI visualization. • Designed and deployed BI dashboards (Power BI, Qlik, PL/SQL), providing clients with insights into operations and performance metrics.

Maintained critical banking and insurance applications in PL/SQL and Oracle, ensuring continuous system availability and compliance with industry regulations. • Inspected and corrected legacy codebases, eliminating inefficiencies and strengthening application reliability. • Developed enhancements and new features aligned with client requirements, delivering tangible improvements in system functionality. • Converted natural-language business requests into functional and technical specifications.