Name: Fernando Manuel Roque Roldán
Nationality: Guatemala
Birth Date: April 10th., 1973
College Degree: Degree in Computer Science.
Current Position: CEO of SD METRICS (www.sdmetrics.info ) since 2004.
Technical website
Of SD METRICS: www.qestad.info
Email: -Biography:
1997: Degree in Computer Science-: Independendent contractor for WEB oriented Technology Projects.
2004 to date: Founder and CEO of SD METRICS. Company specialized in the following
areas: statistical data analysis, Excel Financials with Pivot Tables, Logistics and Project
Management. Technology used to process and generate reports: JAVA, JAVA SERVER
PAGES, PHP, MYSQL, TOMCAT.
2005: Development of the TRAINING Division of SD METRICS for courses in
Project Management, Finance Optimization, Logistics and Statistical applied to Quality Control-: Speaker in several opportunities in the United States talking about Project
Management Financial Topics. Links to presentations in the USA below:
a) Cost Engineering Applied to Project Management and Manufacturing Unitary Cost of Products
http://www.evmlibrary.org/library/PS%2003.pdf
b) Cost Engineering Applied to Project Management and Manufacturing Unitary Cost of Products
http://www.evmlibrary.org/library/PS%2003.pdf
c) EVM for Manufacturing and Internal Projects to Measure Cash Flow
http://www.evmlibrary.org/library/PS%2016(1).pdf
2009 to date: Representative of swiss software Project Management firm, PARM for Central
and North America. Reference: Eduard Pfister, CEO. E
mail: -2012: Certified by the College of Performance Management in the United States
(www.mycpm.org) in the following topics of Project Management and Earned Value
Management. Earned Value is a financial indicator that says if a project is generating enough
value to justify the money that has been invested on it.
Certifications:
a) Principles of Schedule Managment
b) Project Management
c) Earned Value Metrics and Analysis
d) Control of Project Execution
2013: Corrector and TEST PROCTOR of the College of Performance Management for
certification tests in the United States.
2016: Project Management for Development of Information System to do surveillance
of Impact of Climate Change on droughts in Central America. The data is captured from
European satellites (Copernicus, http://land.copernicus.eu/global ), and NASA
(https://worldview.earthdata.nasa.gov/ ).
The results were presented in Brussels in June, 2016. Link to the Conference:
http://events.ulg.ac.be/copernicus-gl-workshop/programme/
The technology used to develop the system was:
a) Google MAPS API
b) JAVASCRIPT
c) MYSQL
d) PHP
e) TOMCAT
f) HTML5
Link to the LIVE technical data: http://www.qestad.info/fps/dispdatagt.jsp
Continuous surveillance of weather conditions for Central America will be done to
see the drought conditions during -:
Project leader in SD METRICS to get data and statistics of traffic affecting the
following cities: Mexico City, Guatemala, Bogota, Cali and Fresno-California, United States.
The data can be used to improve planning of Logistics Routes and Delivery.
2016:
The data got from the traffic will be crossed with Contaminations INDEXES from
NASA satellites to see the relationship between heavy traffic in the cities and contamination
particles.
Online paid courses for UDEMY (www.udemy.com) about:
a) Project Management,
https://www.udemy.com/presupuestos-costos-y-avances-de-proyectos-con-excel/
b) Basic Excel
https://www.udemy.com/excel-de-bolsillo-formulas-filtros-tablas-dinamicas/?instructorPreviewM
ode=student_v4
c) Inventory-Sales analysis with Excel Pivot tables
https://www.udemy.com/analisis-ventas-inventarios-comprastablas-dinamicas-excel/?ins
tructorPreviewMode=student_v4
2016:
The courses are in spanish.
2016: Developing new solutions in Oracle Primavera and SAP.
2016: Nine courses in spanish in Project Management, Costs, Statistics for Quality Control and
Logistics.
Nueve cursos de entrenamiento en temas de Administración de Proyectos, Análisis de Costos,
Planillas y Recursos Humanos, Estadística para Control de Calidad. Puede consultarlos en este
link: http://www.stmetrics.info/index01.php?correlativo=24
2017: October. Certified among the top 10% of the world in Object Oriented Programming for
Cloud using PHP for the freelance company, UPWORK. UPWORK is the largest freelance
company of the world. Read my profile here:
https://www.upwork.com/freelancers/~01b9bac54ae8232efd?viewMode=1