Oscar
ognaranjo@gmail.com
305-764-7527
1205 Belhaven LN
Ponte Vedra Beach, FL 32082
Software Development Specialist
31 years experience W2
0
Recommendations
Average rating
236
Profile views
Summary

I am a professional programmer working on PowerBuilder and Oracle databases since 1997, developing complex applications in most departments in the Central Bank of Venezuela, achieving goals in record time. In 2003, I developed an ERP system also in PowerBuilder and Oracle, obtaining the best performance making most of the process with PL/SQL, ( stored procedures, triggers, functions and more). Here are some of my developments:

  • Implemented SIGER2000 in “Comercializadora ROMHER”
  • $300MM annual revenues, the exclusive distributor of COLGATE, Johnson & Johnson, SC Johnson in Venezuela.
  • Implemented SIGER2000 in Nippon Corporation, $100MM – annual revenues, a leading car parts supplier nationwide in Venezuela. Lately, the focus has shifted to Business Intelligence, working on projects to extract, load and transform data from several sources producing KPIs, dashboards, and reports using Oracle APEX and SQL Server Tools like SSIS, SSRS, and SSAS. I recently successfully passed the exam for 70-461 Certification Querying Microsoft SQL Server 2012/2014. My most recent projects include two PowerBuilder Appeon 2017 migration projects and one in HTML 5 / JavaScript / Polymer web components / No SQL Firebase Database. I finished a successful migration project from the Engine Records System (ERS) and Shop Floor Execution System (SFE) systems to PowerBuilder 2017 and Oracle 12c for the Aviation Division of General Electric (GE). At this moment, I'm working on the migration of Rhode Island Children’s Information System (RICHIST) from PowerBuilder 2017 Classic to PowerBuilder 2017 R3 Web version and Sybase ASE 16. Over and above that, I developed and implemented APIs in C # to interconnect the RICHIST application with DUO 2 factor authentication and LDAP. As well, I Developed a tool to generate subversions and comparations PowerBuilder libraries, this tool has been developed in C #, XAML, and the ORCA library.

Experience
Education
Program Grant
Florida State College at Jacksonville 2017
Microsoft SQL Server / T-SQL
Florida State College at Jacksonville, 2017 - 2017
Economics
Santa Maria University 1996
Economics
Universidad 'Santa María', 1991 - 1996
Certifications
SQL Server 70-461 Certification
Exam 461: Querying Microsoft SQL Server 2012/2014 Issued to Oscar Naranjo Romero Issued by Microsoft
Microsoft, 2017
Professional Scrum Master I
Scrum.org, 2021
Oracle Database SQL Certified Associate
Oracle, 2019
Skills
SQL
2021
43
Triggers
2021
41
Oracle
2021
37
PL/SQL
2021
37
System Analysis
2007
25
PowerBuilder
2017
20
Stored Procedure
2017
20
Reconciliation
2021
17
Regulatory Reporting
2021
17
Database Design
2021
16
ERP
2017
13
SQL Server T-SQL
2017
1
C#
2022
4
Windows
2022
4
Account Management
0
1
Analysis
0
1
APEX
0
1
API Development
0
1
Business Analysis
0
1
Business Development
0
1
Business Intelligence
0
1
C
0
1
Cloud Computing
0
1
CSS
0
1
Data Modeling
0
1
Data Warehousing
0
1
ETL
0
1
Firebase
0
1
HTML
0
1
Java
0
1
JavaScript
0
1
Marketing Strategy
0
1
Microsoft Office
0
1
Microsoft SMS Server
0
1
mSQL
0
1
OOP
0
1
Oracle Data Integrator
0
1
PFC
0
1
Polymer
0
1
Project Management
0
1
Sales
0
1
Sales Management
0
1
Software
0
1
SQL Developer
0
1
SQL Server
0
1
SSIS
0
1
SSRS
0
1
Strategic Planning
0
1
SVN
0
1
T-SQL
0
1
XAML
0
1
XML
0
1