Simera Professional Key (SPK)

Francisco R

Mexico

Application Developer

$ 3,700/month

9 yrs exp

Data Engineer and Application Database Developer and Software Support Engineer with 15+ years of experience in backend development (Java, Spring Boot, REST APIs), ERP modernization, and data architecture across oil Exploration and Production and software industries. Skilled in SQL optimization (Oracle, SQL Server), ETL automation (Python, PL/SQL), and cloud infrastructure (Azure). Practiced in AI-assisted, spec-driven development using GitHub Copilot — converting technical specs into production-…

Skills

  • Database Development
  • data modeling
  • ETL
  • GitHub
  • Java
  • JavaScript
  • Microsoft ADFS
  • Microsoft Project
  • Microsoft SQL Server
  • Microsoft SQL Server Integration Services (SSIS)
  • MySQL
  • Pl/SQL
  • PostgreSQL
  • Python
  • SAS
  • SQL
  • VMware vSphere
  • Vue.js
  • JavaScript ES6
  • 3D Modeling
  • Cloud Infrastructure
  • Data Engineer
  • Microsoft Office 365
  • Microsoft Office Suite
  • Oracle
  • Oracle Cloud Infrastructure/OCI
  • Phyton
  • PLSQL
  • Power BI
  • Spotfire
  • Springboot
  • HTML/CSS
  • Python/R
  • Microsoft Server
  • Data engineering
  • PowerBI
  • Python3
  • microsoft
  • SRS
  • Microsoft Azure/Intune
  • Microsoft Azure
  • Paython
  • Microsoft 365
  • Java.
  • Microsoft365
  • Microsoft Azure Basics
  • Spring boot
  • MSQL
  • Microsoft Azure,
  • Git Hub
  • Microsoft Ads
  • SQL, MS SQL Server
  • SSR
  • Data Analysis with Python
  • Microsoft 360
  • SSRS
  • SOQL
  • PL-SQL
  • Database Developer

Francisco R

Mexico

Application Developer

$ 3,700 /month

Part Time: $ 470/month

9 yrs exp

Data Engineer and Application Database Developer and Software Support Engineer with 15+ years of experience in backend development (Java, Spring Boot, REST APIs), ERP modernization, and data architecture across oil Exploration and Production and software industries. Skilled in SQL optimization (Oracle, SQL Server), ETL automation (Python, PL/SQL), and cloud infrastructure (Azure). Practiced in AI-assisted, spec-driven development using GitHub Copilot — converting technical specs into production-…

Skills

  • Database Development
  • data modeling
  • ETL
  • GitHub
  • Java
  • JavaScript
  • Microsoft ADFS
  • Microsoft Project
  • Microsoft SQL Server
  • Microsoft SQL Server Integration Services (SSIS)
  • MySQL
  • Pl/SQL
  • PostgreSQL
  • Python
  • SAS
  • SQL
  • VMware vSphere
  • Vue.js
  • JavaScript ES6
  • 3D Modeling
  • Cloud Infrastructure
  • Data Engineer
  • Microsoft Office 365
  • Microsoft Office Suite
  • Oracle
  • Oracle Cloud Infrastructure/OCI
  • Phyton
  • PLSQL
  • Power BI
  • Spotfire
  • Springboot
  • HTML/CSS
  • Python/R
  • Microsoft Server
  • Data engineering
  • PowerBI
  • Python3
  • microsoft
  • SRS
  • Microsoft Azure/Intune
  • Microsoft Azure
  • Paython
  • Microsoft 365
  • Java.
  • Microsoft365
  • Microsoft Azure Basics
  • Spring boot
  • MSQL
  • Microsoft Azure,
  • Git Hub
  • Microsoft Ads
  • SQL, MS SQL Server
  • SSR
  • Data Analysis with Python
  • Microsoft 360
  • SSRS
  • SOQL
  • PL-SQL
  • Database Developer

Application Developer

Rethinktheway
March 2025 - present

● Implemented JWT-based authentication workflows (Spring Boot), enabling secure and continuous access to data through APIs and improving service availability. ● Implemented modernization of ERP architecture (Apache OFBiz), migrating to Java 17 and refactoring components into a decoupled plugin-based architecture, improving scalability and SQL database integration. ● Developed and integrated REST APIs to expose complex business logic, enabling structured data access for frontend applications (Vue.js) and external services. ● Designed and optimized SQL Server data models and processes supporting critical entities (orders, payments, accounting), improving consistency and efficiency. ● Implemented automation of financial processes (orders, bank reconciliation, payments), structuring data flows to improve traceability and precision. ● Executed AI-assisted, spec-driven development using GitHub Copilot in VS Code, converting Markdown technical specs into production code across Vue.js, Spring Boot, and Apache OFBiz; I implemented and tested REST APIs, JWT authentication, data mapping, and MS SQL workflows. ● Managed development workflows and version control using Git, ensuring code stability and consistency through technical reviews and conflict resolution.

Data and Infrastructure Engineer

SLB
January 2023 - February 2025

● Administered and optimized data environments in Microsoft Azure (DELFI), ensuring availability, cost control, and compliance through monitoring, auditing, and subscription management. ● Designed and optimized SQL Server data models to support Power BI dashboards, delivering insights on resource usage, costs, and subscriptions. ● Developed and optimized complex SQL scripts for analytical tables, improving performance and processing efficiency. ● Implemented PL/SQL and Python (pandas, sqlalchemy) processes for data integration and transformation of large datasets. ● Designed Azure data mapping and cost analysis solutions, evaluating resource consumption (compute, storage, ML, subscriptions). ● Built advanced Power BI dashboards integrating multiple data sources (APIs, Cognite Data Fusion, Excel), improving decision-making. ● Collaborated with global teams (India and Malaysia) on solution integration, technical support, and continuous improvement in distributed systems. ● Utilized ServiceNow software to efficiently track, manage, and resolve support tickets while delivering technical assistance and troubleshooting in English across global teams.

Information Management Engineer

SLB
January 2019 - December 2022

● Led implementation and customization of ProSource Data Services (PDS) for CNH, enabling large-scale E&P data integration and management. ● Designed and automated data ingestion processes (LAS, LIS, DLIS) using Bash and Python, reducing load times and improving data quality. ● Developed data mappings and models for critical datasets (well headers, surveys, production). ● Implemented data quality controls (DQM) and automated validations, ensuring consistency and regulatory compliance. ● Designed and optimized ETL processes and PL/SQL logic for large-scale data processing. ● Built reporting and analytics solutions using SQL, Power BI, SSIS, and SSAS. ● Optimized database performance through query tuning, job execution, and SQL refactoring.

Information Management Engineer

SLB
January 2017 - December 2018

● Served as Technical Lead for the end-to-end deployment of the National Hydrocarbons Information Center (NHIC) at YPFB Bolivia, overseeing installation, configuration, and commissioning of hardware and software across the full project lifecycle. ● Installed and configured the complete ProSource Suite (ProSource Data Services, ProSource Enterprise, ProSource Logs, and ProSource Seismic), enabling structured E&P data access and petrotechnical workflows for operating company users. ● Deployed the eSearch physical asset repository backed by Oracle 11g, configuring schemas, user roles, keyword search indexes, and RMAN backup schedules, enabling petrotechnical staff to digitally request well files and core inventory. ● Administered VMware vSphere virtualized infrastructure in a high-availability (HA) architecture alongside Red Hat Linux and Windows Server environments, ensuring stability, security, and regulatory compliance across critical operations. ● Managed Microsoft SQL Server instances and developed operational reports using SQL Server Reporting Services (SSRS), delivering backup monitoring and real-time visibility into data load progress for project stakeholders. ● Administered enterprise storage infrastructure using HPE 3PAR 8440 Storage Systems (SMB, NFS, OA API) and the HPE StoreEver MSL6480 Tape Library, ensuring high availability, long-term archiving, and regulatory compliance for E&P data repositories. ● Led implementation of the ProSource Data Services (PDS) shopping cart module, enabling operating companies to request, purchase, and securely download licensed E&P datasets, streamlining data distribution and reducing manual fulfillment processes.

Smart Scores

Communication
85
Role Fit
90
Adaptability
85
Problem-solving
90

Smart Skills

beta