Summary
Overview
Work History
Education
Skills
Languages
Training
OTHERS
Timeline
Generic

Anabela Palacios

US,NY

Summary

Dynamic Oracle Developer with extensive experience, specializing in PL/SQL and database design. Proven track record in leading Agile teams to enhance application performance and security, while effectively managing technological projects. Strong analytical skills complemented by a commitment to delivering high-quality software solutions. I am committed to my work, I like to build trust with team members, and be able to achieve the project's objectives. I have experience in the development and management of IT projects, as well as the ability to analyze user requirements in detail, to estimate timelines, prioritize tasks, assess risks, and monitor the project's progress.

Overview

27
27
years of professional experience

Work History

Assistant

Airwayllc
08.2023 - Current
  • Alaska Airlines' baggage carrier information entry.
  • Enter, update, and maintain information in Airway's Vehicle System.
  • Creation and support in the use of tools such as Excel, Word, PowerPoint, and Microsoft Outlook.
  • Prepared and reviewed documents for Airway GSE maintenance.

National IT Planning Expert

SERVICIO DE RENTAS INTERNAS (SRI)
06.2015 - 01.2020
  • Definition of technological architectures: information security, human talent solutions, and personal computers (using the MagicDraw tool).
  • Investigation and pilot tests of security configurations and policies for workstations with the LINUX operating system.
  • Report of browsers that support the deployment of applications developed in Oracle Forms Builder.
  • Research Report: Audit of Successful and Failed Connections in Oracle Forms Applications.
  • Standard Definition for Application Development in Oracle Forms and Reports for Software Maintenance.
  • Definition of Technological Security Standards for Applications in Oracle Forms.
  • Definition and review of the technological standard for the creation of OLTP and OLAP database objects in Oracle for software development.
  • Validation of Codexpert rules on SonarQube for developments with Oracle PL/SQL code.
  • Creation of specifications for the public procurement of software, such as Alfresco.
  • Application roadmap: Technological strategies were defined after an analysis of each application. A schedule was established to migrate or rebuild the applications in web technologies that have technological support (internal and external software, 186 applications).
  • Loading and organizing documents in the Alfresco platform.
  • Lead and participate in Agile teams under the Scrum framework for the creation, migration, or reconstruction of technological applications.
  • Support to guide and reach consensus on guidelines in the definition of application architectures across multiple software development teams under Scrum.
  • Provide support to development teams to find the best solution to errors and perform performance tuning in applications under database development standards.
  • Servicio de Rentas Internas of Ecuador is the public institution in charge of managing tax policy.

Development Specialist and Technology Specialist

SERVICIO DE RENTAS INTERNAS (SRI)
04.2010 - 06.2015

First time (Jul 2004 – May 2006)

Comeback: Apr 2010 - Jun 2015


  • Administration and support in the publication of content on the Portal Web (Liferay).
  • Support and maintenance web portal using Eclipse, JDK, and Java.
  • Analyze, design, develop, testing, and implementation related to: Sales and Withholding Voucher Billing, Electronic Billing, Document Validation, Pre-billing control, RUC inquiries, RUC pre-registration, Notifications and Bag, Vehicle Registration, Notification and Mail, Intranet Portal, Complaint System, Alcohol Quota System, Value-Added Tax Refunds, and special cases (Software used: Toad, PL/SQL Oracle, Forms & Reports Oracle, and Oracle Designer tools). Develop and maintain Oracle PL/SQL code for various business applications.
  • Support in the National Tax Audit system regarding the accounting validation process, generation of obligations in collections, creation of alerts for different workflows, integration testing, and certification.
  • Participate in code reviews, troubleshoot issues, and provide technical support.

Systems Engineer

SUPERMERCADO MEGA SANTA MARIA S.A
12.2006 - 04.2010
  • Analysis, design, development, testing, and implementation of custom software using the tools: Designer, Forms Oracle, Reports Oracle, and PL/SQL Oracle for the applications of Human Resources and Inventories. (Software used: Toad, PL/SQL Oracle, Forms & Reports Oracle)
  • Maintenance and support of applications Accounting System using Eclipse, Java, and JDK tools.
  • Lead the migration of big data from human resources and accounting applications to another schema through scripts for the new system (JD Edwards de Oracle).
  • Get summary reports of sales of selected products in large volumes of information using scripts in PL/SQL.
  • Supermercados Mega Santa María S.A. is a supermarket chain in Ecuador.

Senior Oracle Developer

FISA GROUP - MODINTER
05.2006 - 09.2006
  • Analysis, design, development, testing, and implementation of custom software using the tools: Designer, Forms & Reports Oracle, and PL/SQL Oracle for banking applications for the modules: Cash, Deposits (savings, checking, overdrafts, etc.), Money Laundering, and Purchase and Sale of Foreign Currency.
  • Project management of banking applications.
  • FISA GROUP provides integrated banking solutions in LATAM.

Consultant Oracle Developer

SNACKS AMERICA LATINA la Compañía Jack´s y Frito Lay
02.2004 - 06.2004
  • Analysis, design, development, testing, and implementation of custom software. (Software used: Toad, PL/SQL Oracle, Forms, and Reports Oracle)
  • Creation of reports in a flat format for sending taxes, payroll, and others through OPM Oracle Financial.
  • Frito Lay of Ecuador is a subsidiary of PepsiCo, specializing in snack foods.

Consultant Oracle Developer

SOFTWARE DEVELOPMENT TEAM SDT S.A.
10.2003 - 11.2003
  • Migration of Credit Card module data from the Sybase database to the SQL Server database for the PROMETEUS Project of Bank “Produbanco Promerica Grupo.”

Senior Developer Consultant Oracle Developer

E.B.S. BUSINESS SOFTWARE
11.2000 - 02.2001
  • Analysis, design, development, testing, and implementation of custom software using the tools: Power Builder, PL/SQL, and the Oracle purchasing module for the industry, ADELCA Acerías del Ecuador.
  • E.B.S. Provides business software solutions.

Consultant Oracle Developer

PANAMERICANA DEL ECUADOR
05.1998 - 08.2000
  • Analysis, design, development, testing, and implementation of custom software using the tools: Designer Oracle, Forms & Reports Oracle, and PL/SQL Oracle for banking applications for the Budget module.
  • Support for users in the use of computer systems and peripherals, such as PCs and printers.
  • Analysis, development, and implementation of software in PowerBuilder and Sybase in the modules of policy issuance, portfolio, and reinsurance.
  • Maintenance of the AS/400 COBOL system.
  • PANAMERICANA is an insurance and reinsurance company in Ecuador. Since 2012, the company has operated under the name Liberty Seguros S.A. (Liberty Mutual Insurance Group).

Education

M.D. - Project Management

University Fuerzas Armadas ESPE
Ecuador
05.2014

Computer Systems Engineer - undefined

University Autónoma De Quito
Ecuador
04.2008

Computer Systems Analysis Technologist - undefined

University Escuela Politécnica Nacional
Ecuador
07.1998

Skills

  • Database Oracle 9i, 10g, 11g, 2C, 19c
  • PL/SQL Oracle
  • Tables, Temporary Tables, Views, Materialized Views, Data Dictionary Tables
  • Primary keys, foreign keys, index, index by tables, check constraints, sequences
  • DB links, schemas, tablespaces
  • Cursors, arrays, collects, ref cursor, open-fetch, bulk collect
  • Exceptions, control exceptions, packages
  • Stored procedures, triggers, functions
  • Parameters, jobs, grant
  • Performance tuning
  • XML, JSON
  • Oracle explain plan
  • Forms and reports builder
  • SQL tuning
  • SQL Loader
  • Microsoft Office
  • Excel PivotTable
  • LibreOffice
  • Linux
  • Unix
  • Shell
  • Oracle Designer, database design, data modeler, Erwin
  • Toad, PL/SQL developer
  • Jira, Microsoft Project, Primavera
  • SVN, GIT, CVS
  • Magic Draw
  • Management of technological projects
  • Cascade methodologies
  • Agile methodologies, such as Scrum
  • Fast learner
  • Attention to detail
  • Team collaboration
  • Problem-solving
  • Presentation creation
  • Multitasking

Languages

English: Full Professional
Spanish: Native/ Bilingual

Training

  • Banking Concepts and Products, 2002, 30 hours
  • Migración de ODBEE 8.1.7 a ODBEE 10g, 2005
  • Business Intelligence, 2005
  • Oracle Workflow, 2005
  • Administering JBoss Application Server Basic, 2006, 18 hours
  • RH033 Red Hat Linux Essentials, 2006, 32 hours
  • Java Web, 2010, 32 hours
  • Project Risk Management, 2011, 16 hours
  • Usability and accessibility to websites, 2012, 24 hours
  • Liferay, Portales Web (Administration), 2012, 40 hours
  • Jira Software Update 2015, 4 hours
  • Workshop Oracle DB 19c and Exadata, Oracle University, 2019
  • International Seminar on Project Formulation and Evaluation, National Autonomous University of Mexico Faculty of Accounting and Administration, 03/05/12, 03/08/12, 32 hours
  • Libre Office version 5.2 Y 6.1, 2018
  • LINUX ADMINISTRATION, 2019
  • Oracle PL/SQL Advanced, Udemy, 2022
  • Project Management with Agile methodologies and LEAN approaches, Telefonica Foundation, 03/13/25

OTHERS

  • Square One (IAT), Airway, 02/20/25
  • Aviation Security Awareness Training, Airway, 11/22/24
  • Communicate Effectively in the Workplace Training, Airway, 11/20/24
  • Human Factors in Ground Operations Training, Airway, 10/03/24
  • Safety Management System (SMS) Training, Airway, 09/25/24

Timeline

Assistant

Airwayllc
08.2023 - Current

National IT Planning Expert

SERVICIO DE RENTAS INTERNAS (SRI)
06.2015 - 01.2020

Development Specialist and Technology Specialist

SERVICIO DE RENTAS INTERNAS (SRI)
04.2010 - 06.2015

Systems Engineer

SUPERMERCADO MEGA SANTA MARIA S.A
12.2006 - 04.2010

Senior Oracle Developer

FISA GROUP - MODINTER
05.2006 - 09.2006

Consultant Oracle Developer

SNACKS AMERICA LATINA la Compañía Jack´s y Frito Lay
02.2004 - 06.2004

Consultant Oracle Developer

SOFTWARE DEVELOPMENT TEAM SDT S.A.
10.2003 - 11.2003

Senior Developer Consultant Oracle Developer

E.B.S. BUSINESS SOFTWARE
11.2000 - 02.2001

Consultant Oracle Developer

PANAMERICANA DEL ECUADOR
05.1998 - 08.2000

Computer Systems Engineer - undefined

University Autónoma De Quito

Computer Systems Analysis Technologist - undefined

University Escuela Politécnica Nacional

M.D. - Project Management

University Fuerzas Armadas ESPE
Anabela Palacios