Jorge R.

I Solve your needs, you solve my Goals

0 / 5

Colombia
Valor hora:

CO$ 90.000,00

IT & Programación

Habilidades (Máximo: 5)
¿Qué es posición de perfil bronze?

Bronze es el segundo nivel de los freelancers de Workana. A medida que consigan más logros y ganen más proyectos, irán progresando hacia los niveles superiores. Leer más

Contratar

Rankeado: No está rankeado

Posición del perfil: Bronze

Último login: Hace un año

Registrado: Hace 4 años

Sobre mí

I am a Software Engineer with an excellent record of achievements in building value for the companies and their projects that I have worked with.
My foundation of technical expertise stems from  hands-on development and leadership background since I graduated from University.
I have worked in different companies from different market segments like Manufacturing, Government, Education, Health, Telecommunications, Technology,
Financial, Insurance, Logistic, Publishing, Law Enforcement, Oracle Corporation and I have managed my own Software business consulting company.

Historia laboral

•    Over 20 years of successful experience in software development and implementation cycle
•    Skilled in planning, estimating, costing, scheduling and implementing software business solutions and development projects

TECHNICAL SKILLS AND EXPERIENCE

Oracle:
•    Database and Application Server and PL/SQL technology, 6.0 to version 11g
•    Oracle Forms versions 2.3 to 11g
•    Reports, SQL-ReportWriter version 1.0 to 11g
•    Designer 6i-10g, Workflow, Portal and Discoverer
•    Content Management and Collaboration Tools
•    Collaboration Suite, Beehive and Oracle Analytics
•    Application Server Enterprise Edition
•    Oracle ADF
•    Oracle applications system administration role
•    Oracle Financials

Languages:
•    C, Java, PHP, Pascal, Cobol, PL/I, Fortran, SQL, PL/SQL
Other tools:
•    Linux, Ms Windows, Unix, AIX, Solaris, Oracle VM
•    SQL Navigator, Jdeveloper, NetBeans, TOAD, MS-Office, SQL Developer, Oracle APEX
•    Multispeak standard
•    Oracle CDM, Oracle AIM and Oracle studio methodologies
•    SAP’s Batch processes manager


RELEVANT EXPERIENCE




SOFTGEN BUSINESS SOLUTIONS, Medellin, Colombia    2012 – present

PROJECTS

Director of business implementation.  Fusion project
I have been generating new business and market opportunities using and/or creating new products into our company achieving the goals for the new software product version in the Colombian’s apparel market.

Estimated,  analyzed and managed the migration project of the SIMBAD product from Oracle Forms 6i to Oracle Forms 11gR2, converting 933 Oracle forms and 897 Oracle Reports to the “state of the art” Oracle forms in 10 months. Added new mobile functionality to the application using Oracle APEX  to SIMBAD’s sales force and off shoring modules.




London Hydro, London, ON, Canada    2010 –2012

PROJECTS

Database administrator,  London Hydro  - Information Systems Division                              2011-2012
•    Implemented  and documented a Disaster and Recovery exercise at SunGard (Mississauga) of the complete London Hydro Core business applications running on Oracle (SAP) in less than 14 hours 17% less time than expected
•    Upgraded and tested  12 Oracle 10g instances to Oracle 11gR2 getting the new 11g features improving the performance in almost 23%
•    Upgraded the 16 SAP EHP5 Oracle instances (Primary and standby servers ) to 11g (Production – QA and Development environments) in two weekends. 
•    Optimized the synchronization processes between Primary and standby servers decreasing the I/O contention in a 9%
•    Implemented Oracle partitioning option to improve the performance of the end user applications that use more than 1.9 Billion records per year,  saving money separating the historical data from the current data which were stored in different kind of hard disk technology.
•    Managed the RNI (Regional Network Infrastructure), AMI (Advanced Metering Infrastructure) and ODS systems (Operating Data System)  from SENSUS (www.sensus.com) and ITRON systems (www.itron.com) for 150,000 smart meters and automated their alert systems to control them remotely.
•    Tuned their systems to achieve the Windows data collection between 12 am to 7 am.
•    Replaced MS Access using Oracle Apex for 22 Accounting users
•    Integrated MS-SQL server with Oracle 11gR2 using a Linux gateway to replace the first one for Oracle technology in the reading processes. We had to process 500,000 transactions per hour.

Software developer for SmartGrid,  London Hydro  - Information Systems Division    2010-2011
•    Analyzed, estimated and Migrated  5 Oracle JDE Instances from  9.2 Oracle version  to Oracle 11gR2, developing Linux shell scripts, pl/sql packages and SQL scripts  saving one week in the migration project ’s schedule leaded by SYNTAX (www.syntax.com)
•    Analyzed Smart Meters web services ruled by MultiSpeak.org  to implement the last version at London Hydro using TOMCAT server version 5.5 and UTL_TCP package allowing us to calling its complete set of functionality from PL/SQL
•    Designed and built the programming to integrate Oracle RDBMS 11gR2 to ActiveMQ using  JMS Queues, PL/SQL and java to integrate them
•    Sold the idea and built the “Smart DashBoard” of LDHY processes using Oracle Application Express which  allow us to follow up and control the complete background interfaces of the billing process related to smart  meter  readings avoiding  three Technical staff interaction.
•    Upgraded Oracle application server Enterprise Edition from 10g to 11G in Production, QA and development environments


NEXGEN BUSINESS SOLUTIONS, San Juan, Puerto Rico    2004 – 2010

PROJECTS

Project Manager, Sales Referral System Implementation, BBVA Bank
•    Designed sales referral system for banking processes and sold to BBVA; implemented referrals process for 1300 employees and 51 branches during three month period

Senior Consultant, Trans Oceanic Life Insurance
•    Designed business solution for sales compensation process; migrated core business solution from Forms 6i to 10g and integrated to customer’s core insurance business solution; created sales incentive data mart; analyzed insurance policy processes and developed approximately 700 workflow interactions and integrations with insurance core software solution; optimized insurance analysis costs

Senior Presales Consultant, Mendez & CIA
•    Installed and implemented Oracle Business Intelligence (Analytics) and designed ETL structure enabling six analysts to understand Oracle technology

Senior Oracle Consultant, Wells Fargo – Reliable Financial
•    Estimated and diagnosed migration path from Oracle 6i to Oracle 10gR2 of core business loan application resulting in a contract renewal for Oracle Corporation
•    Analyzed and resolved all issues regarding different vendors ensuring win-win situations while managing functional and cost relationships
•    Kept document management solution in same version due to migration strategy implemented enabling customer to save hundreds of thousands of dollars without investing on new document management license version

Project Manager, Content Management and Collaboration System, LMC & Associates
•    Marketed Oracle Collaboration tools and content management solutions in construction industry; implemented Oracle Collaboration Suite for 24 Civil Engineers allowing them to record all construction information from daily reports to web conference and email saving at least two hours per engineer daily


Project Manager, Puerto Rican Police Department
•    Delivered software solution to document and forecast domestic violence trend; used Oracle Technology from business requirements  to implementing on-line integration; created dashboard for different users’ profiles using Oracle Portal and Discoverer
•    Oversaw  seven customer service technicians through entire project, meeting expectations for 69 end users
•    Sold Criminal Check Report software development project for Oracle Caribbean to Police Department; managed complete software development cycle from strategy to implementation which involved three Oracle consultants, six customer service technicians and 754 users around the island; delivered project in 73% of the expected time and 41% lower cost than competitor’s version created five years previously



TRADE WINDS NETWORK, West Palm Beach, Florida    2002 – 2004

PROJECTS


Technical Manager, Budget and Management Bureau of Puerto Rico
•    Estimated, Analyzed and designed integrated budget system of the Bureau and 75 government agencies; implemented solution in seven month period on Linux, HP, Oracle Forms, Oracle Reports, Oracle Discoverer and Oracle Portal

Oracle Presales Consultant Trainer, Puerto Rican Police Department
•    Planned, designed and sold Oracle technology workshop for a complete development tools gamma; installed all Oracle stack technology; trained all Police Department technicians on Oracle database administration and Oracle developer tools generating new Oracle sales

Oracle Presales Consultant – Outsource, Oracle Caribbean, Puerto Rico
•    Integrated Oracle Portal and Oracle workflow; positioned Oracle Application server and Oracle 9i in the three largest Puerto Rican government agencies; created customized demos of Oracle Application Server, Database and development tools

Director, Business Implementation
•    Developed business solution for food and beverage transportation, controlling and supporting complete revenue logistics cycle; managed for Doral Bank the centralized report generator project using SOX compliance extracting all data from Oracle Financials GL and Excel worksheets decreasing report time from three weeks to six business days


IDEAS APLICADAS AND APLICACIONES ESPECIALES, Medellín, Colombia    1997 – 2002
•    Created company with four partners; partnered with Oracle Corporation to sell Oracle technology

PROJECTS

Project Manager, CRISA S.A.
•    Sold manufacturing software that I had previously created using Oracle technology; implemented complete ERP and MRPII automating all procurement, apparel, inventory and distribution processes




Project Manager, Suramericana Insurance Company (Suramericana de Seguros)
•    Negotiated mainframe downsizing; planned and delivered downsizing process from IBM mainframe to IBM AIX RISC-6000 using Oracle Database and development  tools; replaced COBOL-RPG based software solutions with Oracle Forms, Oracle reports and PL/SQL optimizing users and IT processes

Product Manager, Ideas Aplicadas Oracle Front Office (Oracle CRM Implementation)
•    Implemented Oracle Service and Oracle sales compensation allowing our company to improve customer service and to control all software issues; made a presentation to launch Oracle Front Office for 300 guests at Oracle Colombia Bogota

Product Manager, Ideas Aplicadas
•    Managed product development division of ERP, CRM and MRP solutions along with 13 software engineers using Oracle methods and technology


Senior Developer, Suramericana Investment Fund (Fondo De Inversiones Suramericana)
•    Designed complete Investment software solution for Colombian Banking market using simulation algorithms and statistical progressions


Senior Business Intelligence Consultant, SuSalud
•    Designed data mart for Health Industry; developed ETL processes and automated corrections and information feedback; discovered new market trends in health assistance service generating a new service philosophy and resources for walk-in clinics for this company

Human Resources Application Development, Ideas Aplicadas
•    Directed full development cycle of a Human resource software solution for manufacturing and services  market; designed software integration points to Oracle Financials modules


ORACLE CORPORATION, Bogota, Colombia    1995 – 1997

PROJECTS

Andean Region Localizations Technical Manager
•    Analyzed and integrated Andean nations legislation into Oracle applications 10.7 using Oracle Globalization methodology; worked with Oracle partner's teams to develop complete set of localizations before competitor had them available in the market

Project Manager Western Consulting Practice, Oracle Medellin
•    Managed the Western Consulting Division of Oracle Colombia; forecasted all consulting services using Pareto’s law as a basis
•    Analyzed, Designed, Developed, tested  and implemented Insurance investment portfolio system for Suramericana de Seguros (2nd largest insurance company in Colombia)

Presales Senior Consultant
•    Made many presentations on Oracle development tools to different customers; prepared and delivered proof of concepts using customer’s requirements
•    Developed new accounts and/or expanded existing accounts within an established geographic territory, industry, product segment, or channel

Senior Applied Technologist for Oracle Applications 10.7
•    Assessed customer’s processes and needs to deliver strategic business solutions using Oracle technology and estimated ROI of each project

Applications Senior Consultant, Occel Wireless (Founded By Rogers Canada)
•    Implemented Oracle Financials technical structure; estimated and made capacity plan for installing all Oracle solutions and integrated with Roger’s billing system
Senior Support Consultant
•    Supported first support level of main customers in Metropolitan area of Medellin; solved different Oracle technical issues from database crashes to systems recovery; migrated Oracle Databases from Oracle 6.x.x to Oracle 7.x.x


EDATEL, Medellin, Colombia    1992 – 1995

Chief Information Officer
•    Planned information systems projects including Financials applications, telecommunications and customer service solutions; created three-year information strategic plan. Used Oracle technology to integrate France TELECOM solutions with Oracle Financials apps



FAMILIA SANCELA, Medellin, Colombia    1990 – 1992

Chief Information Officer
•    Created information systems department, contracted all systems information personnel and developed a systems information strategic plan
•    Developed a Human resources system focused on Manufacturing industry processes

Lecture

Lecturer at Universidad del Norte since 1998 for “Especializacion en gerencia de sistemas de informacion”. I have been teaching the “Project management game”, designed and created by myself and offered to the University as a regular lecture at the end of this academic program.


EDUCATION

Computer Science Engineer, EAFIT University, Medellin, Colombia     1989
•    Evaluated by World Education Services as equivalent to a four years Bachelor’s Degree from a Canadian University.

Public Linked In profile
http://www.linkedin.com/pub/jorge-rios/19/429/5b6


ABRIDGED LIST OF ADDITIONAL COURSES

Oracle Fusion Middleware Presales Champion Assessment, Oracle University     2007
Oracle Fusion Middleware Sales Champion Assessment, Oracle University     2007
Oracle 10g Technical Presales Champion Proficiency Assessment, Oracle University     2007
Oracle 10g Technical Presales Champion Awareness Assessment, Oracle University     2007
Oracle 10g Specialist Sales Champion Proficiency Assessment, Oracle University     2007
Oracle 10g Specialist Sales Champion Awareness Assessment, Oracle University     2007
Collaboration Suite R2 Sales Champion Proficiency Assessment, Oracle University    2007
Oracle Collaboration Suite R2 Sales Champion Awareness Assessment, Oracle University     2006