Uploaded File
Oscar
ognaranjo@gmail.com
305-764-7527
1205 Belhaven LN
Ponte Vedra Beach, FL 32081
CHIEF TECHNOLOGY ARCHITECT CEO (Owner)
24 years experience W2
0
Recommendations
Average rating
131
Profile views
Summary

I am a professional Bachelor of Arts in Economics. I have been working in the software development and database field for the past 20 years. In my past projects, I have worked with Oracle Database, SQL, PL/SQL and PowerBuilder to designed, developed and produced applications for the banking sector. For the past 13 years I've worked on a proprietary ERP system (SIGER2000). I designed, developed, implemented and maintained new modules and interfaces, which was used with several clients. Recently, I have focused on Business Intelligence, working on projects to extract, load and transform data from several sources and produced KPIs, dashboards and reports using Oracle and SQL Server Tools like SSIS, SSRS and SSAS. Accomplishments Designed, developed and produced complex custom ERP, which was successfully implemented by Comercializadora Romher (5 branches, more than 8000 customers and millions of transactions per month). Developing complex applications on most departments in the Central Bank of Venezuela, achieving goals on record time. Designed, developed and produced Bank's Commercial Papers Open Market System (SICET), which was successfully implemented with the participation of all the commercial banks of Venezuela.

Experience
CHIEF TECHNOLOGY ARCHITECT CEO (Owner)
Jan 2004 - present
Miami, AZ
Designed and developed a proprietary ERP System named SIGER 2000 including the following modules G/L, A/P, A/R, Sales, Purchasing, POS, Inventory, Bank Reconciliation, KPI Module, Reporting and Setup Module. Implemented SIGER 2000 in more than 15 customers. Here are some of my principal customers: - Implemented SIGER 2000 in "Comercializadora ROMHER" -$300MM annual revenues, the exclusive distributor of COLGATE, Johnson & Johnson, SC Johnson in Venezuela. - Implemented SIGER 2000 in Nippon Corporation, $100MM - annual revenues, a leading car parts supplier nationwide in Venezuela. Provided networking, computing and software consulting services to mid size and large local corporations in Venezuela.
Database Design
Remove Skill
SENIOR SYSTEMS ANALYST
Information Technology
Jan 1997 - Dec 2003
C.A. (Central Bank of Venezuela) Caracas, Venezuela Lead the project for the bond issuing IT platform (SIMA) for initial public offering of titles. Developed the bank's commercial papers open market system (SICET) for purchasing and sale in the secondary market. Created a management information system compiling major indicators for senior management decision making. Designed and implemented the bank's interest rate reference system (SIREF) integrating local banks electronic information into one platform. All systems were developed using PowerBuilder on Oracle database, Oracle PL/SQL (Store procedures, packages, functions and triggers).
SQL System Analysis
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Program Grant
Florida State College at Jacksonville 2017
Economics
Santa Maria University 1996
Certifications
SQL Server 70-461 Certification
Skills
SQL
2003
26
Oracle
2017
20
PL/SQL
2017
20
PowerBuilder
2017
20
Stored Procedure
2017
20
Triggers
2017
20
System Analysis
2003
17
Database Design
2021
16
ERP
2017
13
SQL Server T-SQL
2017
1
PFC
0
1
Project Management
0
1
SQL Server
0
1