CARLOS MEDINA

Port Saint Lucie, FL ***** 305-***-**** acvimz@r.postjobfree.com

SUMMARY OF QUALIFICATION

Results-driven IT Professional with extensive experience in life cycle phases including requirements analysis, design, implementation, testing, and maintenance. . Well versed in identifying client needs and transferring them into technical solution.

Languages: English, Spanish, German.

TECHNICAL SKILLS

Oracle application: create and maintain application constructs like Forms, Reports, Functions, Menus, Request Groups, Responsibilities, Values Sets, XML Templates, XML Data Definitions, Concurrent Programs and Executable Programs (custom code).

Oracle database: create and maintain tables, indexes, synonyms, views, packages (specifications and bodies) and stored procedures.

Advance PL/SQL programming.

Complete documentation.

Knowledge of Oracle databases for 11i and R12 versions.

Knowledge of the Oracle modules General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Projects/Grants, Fixed Asset, Inventory, Human Resources and Payroll.

Experience acting as Oracle trouble shooter for maintenance.

Experience as System Analyst.

Experience as Business Analyst.

PROFESSIONAL EXPERIENCE

BRINKS INCORPORATED, Medley, FL 2014 – 2015

World’s premier provider of security solutions – including advance technology with annual revenue $3.5 billion.

Oracle Electronic Business Suite Developer

Served as Oracle finance technical support specialist for Brazil, Mexico, Panama, Chile and Argentina.

Worked closely with Latin America Share Service Center (accounting and ledger consolidation) in order to solve system failures, adjust processes and get special information.

Followed up Brazil post-implementation to develop new solutions for not optimal processes.

Supported Mexico upgrade including testing phase, go-live and hyper-care phase.

Developed CEMLIs for the version upgrade in Chile and Argentina.

CITY OF MIAMI, Miami, FL 1999 – 2014

Municipality in Miami-Dade County, population 417,650, $0.5 billion budget.

Senior Programmer, Senior System Analyst and Oracle ERP developer (2005 – 2014)

Programmed data migration from Legacy for Phase I (finance) and Phase II (human resources).

CARLOS MEDINA Page Two

In charge with the technical support of the Oracle finance system (24/7).

Developed custom module Solid Waste Assessment (yearly income 15 million).

Wrote and tested numerous CEMLIs for modules General Ledger, Accounts Payable, Accounts Receivables, Purchasing, Projects/Grants and Human Resources.

Developed the link Payroll – Projects/Grants, which support the recovery of salary payment for Fire Fighters from general fund to special funds.

Designed and developed custom forms for Human Resources/Payroll.

Developed the employee Information data warehouse in order to link Oracle with the historic legacy information on line.

Participated in the upgrade to R12 version.

Programmer (1999 – 2005)

Human resources, payroll and finance systems technical support and programming.

Some relevant results:

oBased on the analysis (reverse engineering) of the XGEN source codes developed and tested reports for City’s financial systems using MS SQL embedded in MS Access Projects (VB Code). These reports were extremely necessary by the transition from mainframe to Oracle.

oProject “Lawsuit regarding the increase in retiree’s insurance premium” involved the design and development of a solution to collect the information and evaluate the impact to the City, if the City were to lose the lawsuit.

oDeveloped a solution using MS Access and VB to reconcile the Fire Calls Data to the Address Data in the Non Ad Valorem System to allow the evaluation of the relationship between Fire Calls and Property Categories. This was used by the City Commission in establishing rates per property category for the Fire Assessment. Fire assessment involved around 100 thousand properties and represented an income of 20 million US yearly.

EDUCATION / PROFESSIONAL DEVELOPMENT

BS Computer Science Education

Technische Universitat Dresden, Germany

Microsoft Certified Professional

Oracle Certified Associate

Contact this candidate