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.
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.
Herlinda Technology Consulting; Tampa, FL – https://h7cs.com
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
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
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
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
1995 – 2000
Delivered high-quality systems. Modules included logistics, inventories, and fixed assets. Developed in a Client-Server environment.
Ricardo Palma University
Lima, Peru 1988
Electrical Engineering, Electronics.
Lima, Peru 1998
Database Administration and Programming.
National University of Engineering
Lima, Peru 2011
Oracle PL/SQL Developer.
Visual Studios C#.
Lima, Peru 2005