Fresh remote jobs, sorted by category — join Jobicy on Telegram  › Fresh remote jobs on Telegram  ›
Oscar Ivan Solarte cover
Oscar Ivan Solarte
Oscar Ivan Solarte

Data Analyst and RPA Automation Analyst

Open to offers · Member since 28 Aug 2026
Message
Location
Colombia
Desired salary
Unspecified
Work preference
Remote Only
Experience level
Mid

About

Professional summary

I am a data analyst and RPA automation professional with experience applying data analysis, process automation, business intelligence, and artificial intelligence in business environments.

I develop Python-based automation solutions for operational processes, including ERP data-entry workflows. I focus on improving efficiency, data traceability, validation, and the quality of information used by business teams.

I work with Power BI, DAX, Power Query, SQL, MySQL, and relational databases to build reports, indicators, and strategic dashboards. I transform operational and unstructured information into actionable insights for evidence-based decision-making.

My experience includes applied AI and predictive modeling initiatives, such as semantic embeddings, K-Means clustering, STL time-series decomposition, anomaly detection, and generative AI prompting for text analysis.

I have supported risk analysis, occupational safety, and business intelligence projects by designing analytical workflows, structuring field

Skills

27 capabilities

Tech stack & tools

Working toolkit

Communications

Data Stores

Languages & Frameworks

Experience

Career history

RPA Developer and Automation Analyst Productos Alimenticios la Locura S.A.S

Developed a Python RPA agent to automate purchase-entry registration in the SIESA ERP system, eliminating manual data entry for the purchasing department.

Integrated PyAutoGUI and OpenPyXL to read consolidated invoice data from Excel, map product and supplier codes against internal databases, and autonomously complete ERP forms. Applied fail-fast validation logic to ensure data integrity and achieve zero data-entry errors.

Reduced manual processing time and improved operational efficiency for the purchasing team.

AI Researcher and Predictive Modeling Analyst Brain AIX

Conducted applied research and prototyped artificial intelligence solutions for an MVP focused on hyperrealistic digital avatars.

Developed pattern-analysis prototypes for unstructured data and improved early anomaly detection using predictive AI techniques. Validated and refined generative AI outputs for realistic interactions through advanced prompting and LLM response fine-tuning.

Supported the project data pipeline through data collection, cleaning, structuring, and analysis to prepare inputs for machine learning models.

Risk Analyst and Business Intelligence Analyst Adecco Colombia - ARL Sura Bolívar Project

Designed analytical workflows using generative AI and business intelligence tools to capture and process unstructured information from reports and inspections.

Used advanced LLM prompting to extract preventive insights from large volumes of textual data and accelerate the identification of relevant risk patterns. Applied K-Means clustering and semantic embeddings to segment risk categories and generate differentiated recommendations.

Performed STL decomposition on incident time series to identify seasonality, long-term trends, and residual anomalies that supported strategic decision-making.

Operational Data Analysis Technician Quirón Prevención - ARL Bolívar Project

Managed and analyzed field data, organizing collected information into relational databases for later querying and visualization.

Supported the preparation of monitoring reports and performance indicators using data analysis and visualization tools.

Management Systems and Data Coordinator PSI S.A.S

Designed and implemented an integrated management system from the ground up, structuring processes for operational data capture, registration, and traceability.

Created documented procedures and data matrices for high-impact activities, helping standardize information management. Managed performance indicators and monitoring reports to support decisions based on historical data and operational trends.

Advanced Occupational Risk Analytics Developer Independent Project

Developed an end-to-end analytics solution integrating computer vision, time-series analysis, and automated clustering for occupational risk analysis.

Built a data pipeline combining object detection, STL temporal analysis, and K-Means segmentation of sectors. Created Power BI dashboards with DAX metrics and MySQL connectivity for strategic real-time visualization.

Automated ingestion and transformation of unstructured text and image data into relational tables, reducing manual analysis time.

Education

Learning history

Universidad del Quindío

Professional Degree, Occupational Safety and Health

Professional in Occupational Safety and Health. Resolution 3702 of 2023 and Resolution 615 of 2014.

This professional hasn’t added portfolio projects yet.

This professional hasn’t listed any services yet.

People also viewed

All talent ›
Jobs Talent AI Tools Salaries
Menu