PROFESSIONAL EXPERIENCE:

Confidential

Data engineer

• Mantenimiento y mejoras de aplicación de finanzas utilizada casi exclusivamente por entidades bancarias para implementación de grano fino sobre movimientos de todo tipo para todo tipo de clientes.
• Soporte a clientes bancarios sobre el uso de la aplicación de finanzas.
• Desarrollo de requerimientos específicos de los clientes para adaptar la aplicación al modelo de datos de cada banco.
• Asistencia y seguimiento del uso de la aplicación para configuración, instalación y carga de datos.

Confidential

Senior Confidential Analyst & Developer

• Managed and maintained several inherited applications for US clients, usually Confidential subsidiaries, created functional and technical documents of the applications for a better understanding of them on presentations or new developers, working in direct contact with the clients
• Developed APEX applications adding javascript, HTML and CSS to increase the solutions that could be provided to met the client’s needs, since APEX is a very intuitive app, knowing the source code of it gives an infinite of possibilities to create custom applications extending the wizard options within APEX
• Tracked work progress on self build internal app in APEX, this allows fastest and simplest interface for users to see the status of requirement or bugs created, also showing reports and charts that gives overall statistics, like summarize the daily or weekly effort, estimated or average time to deliver, etc
• Designed documentation for new features, estimate of effort and demos for presentations with the clients
• Tuned SQL and PL/SQL code, there isn’t an specific percentage to tell on how less time or less cost a query or block could be executed on, but I always try my best to improve the code that is making a negative impact in the database either visible for the clients or not

Confidential

Semi - senior Confidential Analyst & Developer

• Worked as team leader in a team of four developers on the consolidation of multiple applications used by different subsidiaries of Confidential achieving the unification of the data on the front-end, increasing the communication and interaction between subsidiaries improved the performance of the users that could see into one application what they had to manage in several and reduced the scheduled jobs costs
• Managed and maintained several inherited applications of reporting and custom tools for US clients, created functional and technical documents of the applications for a better understanding of them on presentations or new developers
• Implemented JQuery to decrease the development time on custom requirements and expand the possible layouts on APEX for the clients
• Administrated 3 DB environments: Development, Testing and Production. Managed the migrations between the environments, from downtime notifications and backing up the DB before to avoid any corruption on the system to emailing users the new features and reviewing log of migrations for any error or warning
• Created database diagrams using SQL Developer Data Modeller enhancing the productivity and simplifying data modelling tasks

Confidential

Semi-senior Confidential PL/SQL Developer & DBA

• Developed PL/SQL back-end code for a Java interface between mobile&web applications and bank branches availability
• Tuning SQL and PL/SQL reaching an average improvement of 15% on speed and 40% on costs on long running queries and scheduled procedures
• Assisted as DBA when the workload was more focused on improving the performance in the database structure increasing the response time and decreasing our delivery dates

Confidential

Junior Confidential APEX Developer

• Started from scratch an application on APEX 3.2 to automate the documents needed between contract companies and the hiring companies of each individual like SOW, SPA and PO. Within three months of development we released the production version with over 100 users in Latin America
• Improved applications with AJAX, increasing the response time of the web interface by 90% on those who had conditional list of values
• Migrated applications from APEX 2.2 to 3.0 and later to 4.0 with a perfect delivery time based on the deadlines proposed keeping the downtime of the applications to a minimum
• Managed and maintained local application on APEX 2.2 for track of opportunities, documented functionality, discussed bugs and developed new features with the users. Designed and developed a new module to extend the management of the app to projects, the new module allowed the users to get easier, faster and organized access to the invoices, forecast and backlog of each project reducing the time needed for data recollection for presentations

Confidential

Course instructor

• Designed and taught a 60hs course that included 30hs of SQL and 30hs of PL/SQL, guided to computer science students with basic knowledge on programming language to add a skills set that is usually expensive to learn for free and increase their jobs opportunities in the local market

Confidential

Course instructor

• Worked as course instructor more than once for the following Confidential courses:
• Confidential SQL Fundamentals I
• Confidential Program with PL/SQL and Confidential PL/SQL Advanced
• Confidential APEX Workshop I & II
• Confidential SQL Tuning