Resume

Sign in

Oracle PL/SQL Developer

Location:
Tampa, Florida, United States
Posted:
December 28, 2018

Contact this candidate

Resume:

MAX BARRENECHEA

**** * **** *** *** ****, TAMPA, FL 33607 USA

ac72kb@r.postjobfree.com

813-***-****

Summary

Fifteen years of successful experience creating solutions for the Beer Brewery, Tourism and Advertisement industries in South and North America.

Creative, and capable of automating the business process.

Expert building secure, reliable, and scalable desktop and internet solutions.

Team player, detail-oriented, strong organizational, and problem-solving skills. Also, for holding a solid record of accomplishments, consistently meeting goals and expectations.

Proved knowledge in database modeling and coding in high transactional environments.

Strong background in transport, logistic, inventory, vehicle maintenance, retail, and tourism systems with multi-company organizations.

Passionate, self-motivated, and positive attitude towards learning, and open to change and new ideas.

Skills

Procedural language: Oracle PL/SQL.

Database: Oracle, MySQL, PostgreSQL, SQL Server, Sybase.

Web development: Administration, modeling, and Oracle Apex programming.

Operating System: Debian, Ubuntu Linux, and Windows Server Operation.

Java: Servlets, JSP, J2EE, EJB3, Tomcat, Hibernate.

Front End: HTML; XML, and CSS3.

Container: Oracle Virtual Box, VMWare.

Tools : PL/SQL Developer, Oracle SQL Developer, Oracle SQL Developer Data

Modeler, TOAD, CA Erwin, DbSchema, Power Designer.

Other: PHP, Visual Basic, C++, MPLAB, Proteus, Fritzing, Workshop 4 IDE.

Experience

Herlinda Technology Consulting; Tampa, FL – https://h7cs.com

Oracle Developer

Sep 2017 – Present

Code, and Tune up Oracle stored procedures, functions, and triggers that result increasing the output.

Built reports and consults for Tourism software in Oracle APEX 5.1, 4.1.

Developed and tested Oracle 11g, PL/SQL stored procedures, functions, triggers while managing the Transaction module.

Used SQL*Loader command to reads control file and loads data into tables.

Fixed many PL/SQL errors for existing SQL scripts which load data into the target tables.

Mobile Rugged; Tampa, FL – https://www.mobilerugged.com

IT Consultant

Sep 2015 – Ago 2017

Delivered Windows and Linux server setup with MySQL database and, Apache-Tomcat for top clients' new developments.

Timely setup and installation of Rugged data storage for high transactional environments.

Khipudata; Tampa, FL – http://khipudata.com

IT Consultant / Oracle Developer

Sep 2012 – Aug 2015

Provided computer help desk support and technical training on hardware/software to end users.

On time maintaining computers and other peripherals.

Utilized Oracle PL/SQL to perform troubleshooting while assisting client services.

Backus Group – 77 Transports; Lima, Peru– http://backus.pe

Software Engineer / Oracle Developer

1995 – Aug 2012

Lead software engineer planning, analysis, design, and coding for migrating legacy software of Logistic, Vehicles Maintenance, Fleet Control to a new platform using Oracle database.

Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.

Used SDLC for software and database modifications.

Writing PL/SQL code. (Stored procedures, functions, triggers, packages, batch jobs, etc.).

Built the PL/SQL (Procedures, Functions, Triggers, and Packages) and Informatica Processes to summarize the Data to populate summary tables which will be used for generating reports with Performance Improvement.

Analyzed, and validated data from legacy systems and ensured a quality conversion of data into the Oracle database.

Created Purchase Orders Authorization and Tracking solution in Oracle APEX 4.1, improving times by 60%.

Created reports for business analysts and end-users using Oracle Discoverer.

Pro Bags Peru SAC; Lima, Peru – http://www.portaline.com

Software Engineer

2008 – 2011

Experience in database programming in SQL, PL/SQL and Advanced PL/SQL using Oracle 8i/9i/10g databases.

Proficient in SQL, PL/SQL stored procedures, packages, and triggers.

Developed sales and inventory reports module in Oracle APEX 4.0, improving the delivery process in 75%.

Industries del Envase S.A.; Lima, Peru – http://www.envase.com.pe

Software Engineer

2000 – 2008

Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Created scripts to create new tables, views, queries for new enhancement in the application.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Involved in data loading using PL/SQL and SQL*Loader.

Responsible throughout the full development life cycle of Fixed Assets and Sales applications for improving sales, productivity, and on time result for business analysis, using an Oracle database.

Clear Channel Peru; Lima, Peru – http://www.clearchannel.com.pe

Software Engineer

1995 – 2000

Delivered high-quality systems. Modules included logistics, inventories, and fixed assets. Developed in a Client-Server environment.

Education

Ricardo Palma University

Lima, Peru 1988

Electrical Engineering, Electronics.

Telematic Institute

Lima, Peru 1998

Information Technology.

Database Administration and Programming.

National University of Engineering

Lima, Peru 2011

Oracle PL/SQL Developer.

Java Developer.

Visual Studios C#.

Catholic University

Lima, Peru 2005

C++ Programming.



Contact this candidate