Sonia Celis

Master of Business Analytics & Big Data Strategy

2019 - 2020

Pearson Professional Programs - (IPQ - International Project Qualification.)

• Big Data Professional, Data Analytics.
• Certificate in DATA Analytics .: IPQ :.
• Executive Certificate in Project Development Management and Implementation For Strategic Managers .: IPQ :.

System Engineer - Universidad INCCA de Colombia – Bogotá.

1984 - 1992

Validation of Degree in Spain, Technical Engineer in Management Computing. 2.005.

Otros.

2021

• Cloudera - CCA - 175 - Spark and Hadoop Developer.
• IFCT55 - ORACLE BIG DATA CLOUD ANALISTA.
  • Predictive Analytics with Oracle Data Mining, Oracle Business Intelligence, Oracle Data Visualization.

2019

• Cloudera - CCA - 159 - Data Analyst.
• IFCD17-ORACLE DATABASE FUNDAMENTALS AND ADMINISTRATION.
  • Oracle Database Administrator (D105916 - Administration Workshop Ed 1). Oracle Database: (D105920 - Backup and Recovery Workshop).

• MongoDB
  • M220JS: MongoDB for JS Developers. + The essentials of JS application development with MongoDB.
  • M220J: MongoDB for Java Developers. + The essentials of Java application development with MongoDB
  • M001: MongoDB Basics. + The Learn the fundamentals of MongoDB.

2018 - 2003

• Miscellaneous
  • Introduction to SCRUM. Angular 2 Basic.
  • Angular 2 Basic.
  • Spring Basic.
  • Object Oriented Programming and Web Application Development
  • Windows 2003 Corporate Network Technician (MCSA) and Cisco (CCNA).
  • Windows XP (MCP Certification in Windows XP)
  • VISUAL BASIC Programming Applied to Office.
  • Graphic Design. Photoshop - Freehand.
  • Creation, Management, Administration, Dynamic Pages. Apache, MySQL, PHP.

  1998

  • I.B.M. Bogotá (Colombia)
  • AS/400 resources for interactive programme design
  • RPG Fundamentals
  • AS/400 Interactive Programming Workshop
  • Design and Coding of AS/400 Relational Databases

ALTEN SPAIN S.A.

May 2022 -

IT CONSULTANT, Madrid

DEVELOPMENT AND/OR MAINTENANCE SERVICE FOR RADIOLOGICAL AND PHYSICAL SAFETY MANAGEMENT AND CONTROL APPLICATIONS INTEGRATED IN THE CIEMAT WEB SYSTEMS.

• Requirements gathering.
• Data model development.
• Backend
• Baseline BackEnd infrastructure, based on an Archetype.
• Includes persistence - relational DB access.
• REST services - get and generate data and operations in JSON.
• Functional Documentation.

AMP SOFTWARE

Nov 2021 - Mar 2022

Technician, Madrid

IT Department MOLDTRANS GROUP - International and National Transport Company.

• Development of Statistical Reports - on demand - JasperSoft.
• Development of processes to carry out customer file integrations to the company's DB, for transport processing. Data processing and distribution with Apache NiFi and Procedures in PostgreSQL.
• Development of queries for the creation of reports on customer integrations, tariffs, procedures, customer operations, in PostgreSQL, using the OmniDB manager and different OCR utilities.
• Use of the Bots tool for EDI (Electronic Data Interchange) file processing. Integration of these files with our own databases.

COMUNIDAD DE MADRID

May 2021 - Jul 2021

Interim Officer, Madrid

• Computing Teacher (leave replacement) at Vocational Training High School.
• Medium and Higher Level.
• Markup Language - ML, (HTML5, XML, XSL).
• Desarrollo de Aplicaciones Web - DAW
• Administración de Sistemas Informáticos en Red - ASIR
• Sistemas Microinformáticos y Redes - SMR
• Aplicaciones Multiplataforma - DAM

Application System Design Analyst

Mar 2011 - Jul 2019

Sopra Steria, Madrid

• Projects:
  • Analysis and development of procedures to Stock Market Reform of 2015.
  • Evolutionary:: Financial Operations (Public Offer, IPO - Initial public offering, Amortization, Exchange, Public Subscription Offer, etc.). RestFul Services.

• Project and Evolutionary Analysis and Front-End development in the Stock Market application. (BBVA).
  • Using WATERFALL and INCREMENTAL methodologies as well as AGILE. ("Framework" BBVA).
  • Elaboration of technical designs.
  • Definition of use cases according to functionality.
  • Implementation and support in different environments. Development, Integration, User Acceptance and Production.
  • Coding, debugging, maintenance, testing, verification and validation, implementation, configuration management, etc..
  • Horizontal information flow. (Management and Coordination.).

Programmer Analyst

Apr 2008 - Mar 2011

Steria Iberica, Madrid

• Participation in analysis and Front-End development of evolutionary developments in the Stock Market application ("Framework" BBVA).
  • Definition of use cases according to functionality. - Feedback with programmers through experience.
  • Corporate best practices. Horizontal information flow. (Management and Coordination.).
  • (Coding, testing, verification and validation, configuration management, etc.).
• Projects: National Market based on existing International Market software.
• Evolutionary: Maintenance and new functionalities for National Market.

Programmer

Sep 2007 - Mar 2008

Ibermática, Madrid

• Front-End development on the External Trade application. ("Framework" BBVA).
  • (Coding, debugging, maintenance, testing, verification and validation, configuration management, etc.).

Programmer

May 2007 - Sep 2007

Alpainfo, Madrid

• First steps, and Front-End development, ("Framework" BBVA).
• Knowledge of the work environment as well as the tools used and the flow of information (coding, testing, verification and validation, etc.).

Officer

Apr 2001 - Mar 2003

MasBytes SL, Madrid

• Computer installation, Web page design, computer sales, warehouse administration, purchase/sale, invoicing.
• Implementation, Maintenance and Updating of Management and Invoicing Programs.

System Analyst

Jul 1994 - Jun 2000

Leasing de Occidente, Colombia

• • Logistical and technical support on decentralization of of Company Loan Portfolio
  • Implementation of the Company Deposit Sub-system, developed in RPG Programming Language for the AS/400 System.
  • Monitoring and control of Deposit Sub-system and Leasing Loan Portfolio for proper performance in the new millennium.
  • Development and Maintenance of the Leasing Loan Portfolio, in COBOL/85 Programming Language under UNIX operating system.
  • Participation in the Development of the AS/400 Leasing Loan Portfolio Project.
  • General knowledge of the AS/400 System, as well as some tools for information management such as SQL, DFU, QRY's, RLU, SDA, SEU.