Upgrade Post project
IM

Ipswich Mata

available

Last update: 12.03.2019

Oracle Developer

Graduation: M.Sc. Information Systems
Hourly-/Daily rates: show
Languages: English (Full Professional) | Spanish (Native or Bilingual)

Keywords

Attachments

Resume-Ipswich-Mata.pdf

Skills

Over 15 years of experience in Information System Technology. Highly specialized on improvement business operations, systems and processes. Participate in all levels of system life cycle. Training users of different levels. Manage Support on systems deployment

Project history

CITRIOM LLC (Remote- freelance) May 2016 to Present
Senior Oracle Consultant
  • Client: Government Employees and Judiciary Retirement Systems Administration (ASR):
    • Automation of the laws that govern the Puerto Rico retirement system using Oracle Forms/Reports, IBM FileNet, PL/SQL
  • Client: Healthcare PR Health Insurance Administration (ASES):
    • Create a new subject area for a Business Intelligence site (Oracle BI 12c)
    • BIG DATA PROCESS: Create a data validation process (Oracle DB 11g: Package and a Function) for records previously loaded with files given by providers to ASES
    • Create a Datawarehouse as a collection of applications developed with APEX 5.0 & Oracle BD 12c
    • Design and Implementation of Star Model for the business area related to premium payments and claims
    • Implementation of ETL processes developed in PL/SQL oracle 11g.
    • Creation of analyzes and dashboards in OBIEE.
  • Client: Caribbean Metering Systems Inc (CMS Puerto Rico):
    • Create an app (Oracle DB 11g & APEX 5.0) for register each stage of setting of smart meters Client: University of Puerto Rico (UPR):
    • Migrate data from a deprecate COBOL application to an application based on Oracle database 11g, Forms & Reports 11g over WebLogic 11g
Amagi Services C.A (Caracas – Venezuela) Feb 2014 to May 2016
Senior Oracle Developer
  • Software development outsourcing services for La Venezolana de Seguros (Venezuela), One Alliance Insurance Corporation (Puerto Rico) and Seguros La Floresta (Panamá): Adapting developments for RECTOR (made with Oracle DB 10g, PL/SQL, Forms & Reports 10g).
  • Software development outsourcing services for Mercantil Seguros: Adapting developments for RECTOR (made with Oracle DB 10g, PL/SQL, Forms & Reports 11g). Activities:
    • Development of an Accounting process for record payment of policies made in several banks (information that was loaded manually) to facilitate the monthly closing: Development of technical design, development of required solution, deploy solution to different environments for testing and finally deploy to production
    • Development of a report interface inside RECTOR database to be invoked from a new web portal for external producers use, interface returns a URL to generate a standard RECTOR report at the web site
    • Modification: Financing contract clauses by DB
    • Modification: Printing process of accounting entries
    • Adaptation: Policyholders upselling process to handle new branches: Development of technical design, development required solution, deploy solution to different testing environments before the final deploy in production
    • Bonus calculation according to Claims Compliance Goal: Creating module where user can upload, or update configuration required to calculate bonus percentage according to compliance with any accident within ranges set
    • Technical advice to other developers
Global Resources .Net (Caracas – Venezuela) Dec 2013 to Feb 2014
Senior Oracle Developer
  • Software development outsourcing services for Telefónica-Movistar: Development and maintenance of software solutions based on Oracle (DB & PL/SQL 9i/10g/11g), development of TUXEDO services (C or C++ running on UNIX/LINUX), Shell Scripting. Technical advice to other developers
Kentron Sistemas de Información C.A. (Caracas – Venezuela) Dec 2012 to Dec 2013
Senior Oracle Developer
  • Development and maintenance of applications based on Oracle Forms & Reports (6i, 10g & 11g), Oracle DB (9i, 10g & 11g), configuration of compilation & production environments with Oracle Application Server 10gR2 or WebLogic 11g on Windows Server (2003, 2008) or Linux (Suse 9, Red Hat). Migration of client-server applications (Oracle Forms/Reports 6i) to WebLogic environment (Oracle Forms/Reports 11g). Bugs fixing in production server
Accenture C.A. (Caracas – Venezuela) Dec 2009 to Nov 2012
Senior System Analyst
  • Software development outsourcing services for Telefónica-Movistar: Development of software solutions based on Oracle (DB 9i, Forms 6i, Reports 6i), UNIX Shell Scripting. Technical advice to other developers
Cestaticket Accor Services, C.A (Caracas – Venezuela) Aug 2008 to Dec 2009
Senior System Analyst
  • Development and maintenance of own software solutions based on Delphi 5, SQL Server 2005, Visual Basic 6, Crystal Reports 9
Manapro Consultores, C.A (Caracas – Venezuela) Sep 2007 to Aug 2008
Senior System Analyst
  • Development and maintenance of own software solutions based on Visual Basic 6, Sql Server 2005 & Crystal Reports 9
Administradora de Servicios Planinsa, C.A. (Caracas) Sep 2004 to Aug 2007
Senior System Coordinator
  • Coordinator of systems development group, in charge of 2 main enterprise systems (developed with Visual Basic 6, SQL Server 2000 and Crystal Reports 9)
  • Developer of financial area of main system, which interfaces with an administrative software, using it as a book of banks and accounting
  • Development of an interface with a ERP based on Oracle.

Local Availability

Only available in these countries: Colombia
Profileimage by Ipswich Mata Oracle Developer from Oracle Developer
Register