Oracle PL/SQL Developer

PIEDRABUENA GAETE, FEDERICO DANIEL

****, ********** *****, ******, ** 30084

(C) 470-***-**** • ******@*****.***

EXPERIENCE:

ORACLE

Senior Oracle Analyst & Developer Oct-12 to Present

Managed and maintained several inherited applications for US clients, usually Oracle 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

TECNOSOFTWARE

Semi-senior Oracle Analyst & Developer Apr-10 to Oct-12

Worked as team leader in a team of four developers on the consolidation of multiple applications used by different subsidiaries of Oracle 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

MOBILE COMPUTING

Semi-senior Oracle PL/SQL Developer & DBA Nov-09 to Apr-10

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

THALES SYSTEM

Junior Oracle APEX Developer Aug-07 to Nov-09

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

OTHER EXPERIENCE

FREELANCE

Course instructor Aug-13 to Dec-13

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

CONTRACTOR

Course instructor Jan-14 to Mar-15

Worked as course instructor more than once for the following Oracle courses:

oOracle SQL Fundamentals I

oOracle Program with PL/SQL and Oracle PL/SQL Advanced

oOracle APEX Workshop I & II

oOracle SQL Tuning

EDUCATION

B.S. System Analyst (4 credits to graduate) San Miguel, Argentina Mar-10

ADITIONAL DATA

Work Authorization: Sponsorship needed for H-1B

Contact this candidate