Francis Medina

Experience

• 

  SYNTONEX

  Sept 1998 - Jan 2000

  Jr. Developer

  • Fixing and testing financials programs for proper operation in the “Y2K problem” resulting in continuous use of business operations.Environment: Delphi, Windows/Unix.Skills applied: Applications development in COBOL and Delphi.

• 

  MAGNA SEGUROS

  Sept 2000 - Dec 2003

  Analyst Developer

  • Supported daily operations for the insurance system, built in COBOL under UNIX, and created integrating interfaces with a new in-house visual system developed Delphi / Informix.• Implement a data migration and integration project (ETL) of the policy portfolio for a merge process with an acquisition company ERP system.• Developed the reinsurance module of the in-house policy system for working with reinsurance contracts: Facultative Coverage, Reinsurance Treaty, Proportional Reinsurance, Non-proportional Reinsurance and Excess-of-Loss Reinsurance.• Awarded “IT department Employment of the Month Nov. 2002”.Environment: Informix, Delphi, Windows/Unix.Skills applied: Applications development in COBOL and Delphi, Shell Scripting, VI, ETL, Data Migration and interfaces. Show less

• 

  INCE HOSPITAL

  Jan 2003 - Jan 2004

  Web Developer

  • Developed the hospital website with search capabilities for doctors and services using ASP and Oracle. Environment: Windows/Unix.Skills applied: HTML, JavaScript, CSS, Access, IIS.

• 

  PAN-AMERICAN LIFE INSURANCE (PALIC) BHD

  Feb 2004 - Jan 2009

  Senior Oracle Developer

  • Supported daily operations and developed new solutions with business experts and executives.• Developed an Auto Insurance Quotes system implementing business and technical rules improving policy creation.• Performed ETL process for the company entire financial history for an external audit helping improved revenues.• Prepared user manuals, technical specifications and training sessions to users prior to software releases.• Awarded “Company Employment of the Month (Nov. 2008)”.Environment: Oracle 10g/11g, Forms and Report 2000/11g, Windows/Unix.Skills applied: Troubleshooting existing programs and database objects, ETL, Data Analysis, Shell Scripting, created database objects and troubleshoot forms and reports (ver. 2000). Show less

• 

  GCS COMPUTER SERVICES LIMITED

  Apr 2009 - Dec 2009

  Technical Support Engineer

  • Tier II Supported Engineer for Apparel ERP systems module which included: Financials (AP, AR, GL), Order Entry, Manufactory Production, Purchase Orders, Warehouse Management, Shipping Labels, EDI X.12 transactions (850,810,856,832) increasing customer satisfaction.Environment: Oracle 10g/11g, Forms and Report 2000/11g, Windows.Skills applied: SQL Query, EDI, Troubleshooting existing programs and database objects

• 

  TECHNOCONS

  Jan 2010 - Jun 2013

  Sr. Oracle Developer Consultant

  • Designed and developed a module for sending health insurance policy holders a scanned documents (Birth Certificated, ID cards, passports and others) to the health insurance regulatory government agency as required.• Developed a program to dynamically generate the complete set policy contracts documents in MS Word from Oracle database increasing productivity by 35%.• Integrated the Billing and Collect process for “Seguros Universal”, an insurance company, and a new Investment Insurance Account policy product. • Built an interface between the insurance system and an Enterprise Content Management (ECM) called “OnBase” improving quality of services and reducing cost from the software consultants.• Support daily operations for a hospital ERP system improving patient’s appointments and billing and claims process.• Implement a web services to exchange data and documents with insurance brokers improving business collaboration and integration.• Created a monitoring reports for Call Centers calls quality assurance and agent’s performance.• Developed an interface for extracting information from Quick Book, using QB SDK, to financials reports Excel templates replacing a manual process and submitting to regulatory agencies.• Implemented a document tracking system using barcode readers reducing operational costs by 30%.• Developed a web application based on Google Map API for locating hospitals, doctors and pharmacies.• Designed and developed a mobile web application with Dashboard for a sales team that connects to the company central database improving sales and customer service. Show less

• 

  CareBlue

  Jul 2013 - Sept 2013

  Freelance Web Developer

  Developed a Web Service to extract patience billing and medical information history to the store in a SQL Server database.Environment: Windows, Web, .NET (ASP, C#), XML.Skills applied: Web Services, SQL.

• 

  NBC

  Oct 2013 - Dec 2014

  Senior Oracle PL/SQL Developer Consultant

  • Designed and developed ETL programs for the NBC media legacy system to new application for the core advertising system.• Tuned and improved load and respond time of slow running SQL query and PLS units by 40% using best practices: Reading Explain Plan and Statistics, pkprof, tracing, Parallel and Cache hints, refactoring, changes on the ETL architectures for parallel running of PL SQL units.• Work with DBA team to implement changes on Database (increase size of TEMP tablespace and PGA memory for big sorting process, partitions, Enabled Parallel running).• Assists QA team to solve Data Quality issues and support in changes on the ETL process and Unit Testing.• Support for post migration on the new system to end user. Interact with offshore team (India and Croatia).Environment: Oracle 10g/11g under Unix/Windows with SQL Developer and Toad.Skills applied: Data Analysis and validation, SQL and PL SQL Tuning, Test Driven Development and refactoring. Show less