Jhon Enrique Ramírez Email & Phone Number

Bogotá, Bogota, Co

Colombia

Collaborate and develop data visualization, engineering, and data science initiatives to enhance client experience through insightful data analysis, driving informed decisions and continuos improvement to Citi Global Senior Management.

Bogota, D.C., Capital District, Colombia

Recent Achievement:• Best Transformation Contributor (02/2023). Enhanced Customer Lifecycle Tracking Business Process and Data Quality by 35% through the development of Microsoft Forms for streamlined data collection in two (2) Operations, expertly employing Microsoft Fabric and data modeling for data extraction and transformation, and implementing an efficient Power BI dashboard for comprehensive data analysis, key performance indicators control and process optimization. This tool provided… Show more Recent Achievement:• Best Transformation Contributor (02/2023). Enhanced Customer Lifecycle Tracking Business Process and Data Quality by 35% through the development of Microsoft Forms for streamlined data collection in two (2) Operations, expertly employing Microsoft Fabric and data modeling for data extraction and transformation, and implementing an efficient Power BI dashboard for comprehensive data analysis, key performance indicators control and process optimization. This tool provided the bases for a CRM (Customer Relationship Management) solution.Main duties:Reporting:- Define ways to measure and report on the key indicators and operational performance.- Develop high quality technical visualization tools, starting from data extraction and transformation to dashboard development and publication.- Stay updated with emerging data visualization trends and technologies.Control:- Oversee the execution of business processes and projects in accordance with defined metrics/KPIs and standards.- Actively engage stakeholders and participate on business execution to ensure result delivery- Support the processes/operations through the activities planning (Forecasting, Campaigns definition, Prioritization, Scoring)Risk:- Constantly analyze the performance of processes/operations to identify potential risks.Others:- Lead on demand projects (planning, Execution and Closing)- Implement process improvements based on performance analysis.- Foster cross-functional collaboration to enhance process efficiency. Show less

Bogota, D.C., Capital District, Colombia

Colombia

Analyze client requirements and document business processes. Provide timely resolutions via email or video conference by designing strategies and implementing or configuring company software. Customize rental agreements and email templates according to clients' preferences using HTML and CSS.

Colombia

Handle inbound phone, chat, and e-mail routine inquiries and complaints, and determine the nature of the contact in order to provide the appropriate timely resolution, educate customers about policies and procedures, and create immediate strategies to prevent problems from recurring.

Bucaramanga, Santander, Colombia

Handle inbound phone queries from customers, receive routine inquiries and complaints, and determine the nature of the contact in order to provide the appropriate timely resolution.

Bogotá D.C. Area, Colombia

Last Achievement:• Contributed to reducing in 10% the failure index in ESP by providing operating recommendations to Reservoir and Production Teams, which helped to increase base oil production and ESP Run-Life in 5% over the target in 2019.Main Duties:Optimize oil production - energy consumption and reduce failure index - sanding issues and loss of production by remote monitoring and evaluation of operating parameters behavior in wells with Electric Submersible Pump - ESP… Show more Last Achievement:• Contributed to reducing in 10% the failure index in ESP by providing operating recommendations to Reservoir and Production Teams, which helped to increase base oil production and ESP Run-Life in 5% over the target in 2019.Main Duties:Optimize oil production - energy consumption and reduce failure index - sanding issues and loss of production by remote monitoring and evaluation of operating parameters behavior in wells with Electric Submersible Pump - ESP. Evaluate operating conditions in wells with sand control installations using PROSPER. Present results weekly and lead Well Review Sessions. Show less

Bogotá D.C., Colombia

Last Achievements:• Developed a visualization tool in TIBCO Spotfire to identify injection wells for the implementation of vertical efficiency improvement methods, which increased over 10% the portfolio of workovers in 2019.• Contributed to exceed over 12% the Oil Production target in 2018 by workover proposals.Main Duties:Identify, evaluate, and follow-up workover operations to increase oil production and improve the efficiency of water injection. Analyze and optimize… Show more Last Achievements:• Developed a visualization tool in TIBCO Spotfire to identify injection wells for the implementation of vertical efficiency improvement methods, which increased over 10% the portfolio of workovers in 2019.• Contributed to exceed over 12% the Oil Production target in 2018 by workover proposals.Main Duties:Identify, evaluate, and follow-up workover operations to increase oil production and improve the efficiency of water injection. Analyze and optimize waterflooding performance and provide recommendations to reach production targets. Analyze decline curves and reserves estimations in mature oil-field. Show less

Bogotá D.C., Colombia

Last Achievement:• Developed a new methodology for the identification and characterization of injection wells that could be candidates for improving vertical efficiency by mechanical and/or chemical methods. This project allowed me to achieve first place in the 2017 internship competition of OXY Colombia LLC.Main Duties:Provide technical support to the reservoir team in engineering functions related to the waterflooding process, KPI's follow-up, advanced projects under study… Show more Last Achievement:• Developed a new methodology for the identification and characterization of injection wells that could be candidates for improving vertical efficiency by mechanical and/or chemical methods. This project allowed me to achieve first place in the 2017 internship competition of OXY Colombia LLC.Main Duties:Provide technical support to the reservoir team in engineering functions related to the waterflooding process, KPI's follow-up, advanced projects under study, and well review sessions. Show less

Master'S Degree, Data Science

• Thesis Statement: Enterprise System for the Management and Analysis of Sustainability Data in Mining Organizations. • Relevant courses.

Bachelor'S Degree, Petroleum Engineering

Activities and Societies: Member of "Grupo de Investigación Recobro Mejorado" (GRM-UIS), SPE UIS Student Chapter; Selección de Ajedrez UIS.