• Compression of Microsoft SQL Server original source data, ETL process extraction, transformation and loading to CSV file. SQL scripting.• EDA analysis, DataFrame structure analysis, descriptive statistics, summary statistics, distribution of variables with matrices and graphs with Python and R.• Cleaning of scattered data, stored in different formats, inconsistent, null, redundant, aged or biased data, calculation of new variables, association and correlation of variables with Python… Show more • Compression of Microsoft SQL Server original source data, ETL process extraction, transformation and loading to CSV file. SQL scripting.• EDA analysis, DataFrame structure analysis, descriptive statistics, summary statistics, distribution of variables with matrices and graphs with Python and R.• Cleaning of scattered data, stored in different formats, inconsistent, null, redundant, aged or biased data, calculation of new variables, association and correlation of variables with Python and R.• Preparation, visualization, data balancing with ROS and SMOTE, transformation of categorical data to numerical data with dummy encoding and label encoding techniques with Python and R.• Hyper-parameter optimization, training and testing of Machine Learning models Logistic Regression, Decision Tree, Random Forest and XGBoost.• Evaluation of Machine Learning models with confusion matrices and accuracy indices. Show less

Design, development, protection and support of Oracle, MySQL and SQL Server database schemas for various computer systems, ensuring their efficiency, scalability and reliability. Optimizations of queries, data integrity, index management and backup/recovery, ensuring the correct operation of applications in production and providing technical support to users and development teams.Collaborated systems:• Documentary management GAD Zamora Chinchipe. • Migration of the Sisproy, Sgc and… Show more Design, development, protection and support of Oracle, MySQL and SQL Server database schemas for various computer systems, ensuring their efficiency, scalability and reliability. Optimizations of queries, data integrity, index management and backup/recovery, ensuring the correct operation of applications in production and providing technical support to users and development teams.Collaborated systems:• Documentary management GAD Zamora Chinchipe. • Migration of the Sisproy, Sgc and Quizeeasa systems to Weblogic12c and implementation of WAF security. Services and Online Payments GAD Pelileo.• EMAPA Drinking Water Readings. • Oracle Migration of SOLCA Ambato Documentary System.• Vehicle parking control system for a leading European company in Italy.• Quality Management Computer System SGC EEASA.• Computer System SISPROY EEASA (3 phases of development and support).• Computer System QUIZ EEASA Show less

• Administration of Oracle19c, WebLogic12c and Jasper Report development servers.• Updating of information in the Institutional INTRANET.• Administration of the data network and IP telephony.• Software and hardware support to users.• Maintenance and support of the document management systems SISSOL, Project Control SISPROY, Quality Management System SGC, Quiz knowledge evaluation system and institutional Intranet.

- Configuration of equipment (router, antennas) for internet service installations, coordination with customers and customer support.- Remote customer support and technical visits