Oracle PL/SQL Developer Engineer

Roberto Carranza

Redwood City, CA ***** 650-***-**** ********@*******.***

Professional Profile

software engineer

Competitive, self-motivated Software Engineer with over 15 years'

experience in enterprise applications development. Innovative and superior

analytical, problem-solving, technical, interpersonal, and communication

skills with experience in project management, business analysis, programmer

and the full life-cycle project development. Proven ability to work in fast-

paced environment and meet highly critical deadlines.

Technical Skills:

Systems: Unix, Windows (XP, Vista, 7, 8)

Software: Microsoft Office (Outlook, Word, Excel, Access,

PowerPoint, Project), Oracle Designer, Forms/Reports, Erwin,

Toad, PL/SQL Developer, Web Sphere Business Modeler, Rational

Rose, Requisite Pro, Clear Case, Clear Quest, J2EE

Languages: C++, C#, Java, JavaScript, HTML, Visual Basic, Delphi,

Oracle PL/SQL

Databases: Oracle, SQL Server, Microsoft Access

Education

BS in Information Technology: Software Engineering - University of Phoenix

(Graduated with honors 2013)

BS in Systems Engineering - Applied Sciences University (2009)

Relevant Coursework: Project Management based on PMI, Mastering

Requirements Management with Use Cases, Configuration Management with

Rational Clear Case, Rational Clear Quest Administration, Relational

Database Design, UML

Experience

INTRATEGO Jul 2011 to Oct

2014

Freelance Oracle Database Developer

Freelance database developer in Oracle PL/SQL, Forms and Reports to

customize and improve the integrated management system created to provide

support business administration and talent management for commercial and

financial organizations

. Developed interfaces to migrate data from integrated system to Data

Warehouse environment, providing availability of information in real

time

. Designed and developed regulatory and statistical reports for

regulatory organizations and high level decision makers

. Maintained Integrated Management System providing high quality of new

forms and reports

. Improved response time to queries up to 40 percent by reviewing and

improving indexes, partitioning tables, SQL performance, and fixing

coding issues for the Integrated Management System

RIMAC INSURANCE COMPANY Mar 2004 to

Jul 2009

Team Manager (2006 to 2009)

Managed 20-person team of Analyst Programmers to support the main

application system for the largest insurance company in Peru, managing

projects, requirements, and software configuration

. Achieved formal recognition for exceptional team work on three

separate occasions - February 2007, November 2007 and first quarter

2007

. Partnered with business units for gathering regulatory requirements,

improvements and new requirements

. Managed budgets for multiple projects up to $50k; delivered on time,

budget, and scope.

. Improved performance and response time in accounting module and the

accounting closing processes by researching and coding database

issues, indexes, SQL performance, and interfaces

. Led system configuration management team, managing 6 analyst

programmers to support company's main application system for

troubleshooting

. Led requirements team, managing 8 analyst programmers to fulfill the

Service Level Agreement with business units developing requirements on

demand, and requirements for improvements and new business rules

. Decreased stock of incidents in the main application from 500 to 0 in

two months by analyzing, identifying and solving issues from the

source

. Reduced tickets of incidents in the main application from 15 to 2 per

week by evaluating, analyzing, defining, and developing projects of

improvements in the system

Analyst Programmer (2004 to 2005)

Analyzed, developed, and maintained back-end PL/SQL programs to function in

Java Web-based applications providing capability of recording, reporting,

and consulting new emissions of policies and accounting interfaces

. Provided troubleshooting gathering requirements, analysis and

solutions to the main database application system

. Developed back-end PL/SQL programs for high access Java Web-based

application for vehicle insurance and transit accident insurance

. Designed and modeled Oracle database and back-end PL/SQL programs for

high-volume Java Web application for reporting brokers' invoice

COMMIT SAC Apr 2002 to Feb

2004

System Consultant

Consultant role in a firm partnered with Oracle Peru providing support,

analysis, and development in Oracle Designer, PL/SQL, Forms, and Reports to

institutions in the commercial, mining, financial, and banking industries

. Designed and implemented new modules in the billing and collection

system for San Fernando Company

. Partnered with analyst and business units to Implement new

requirements and improvements in the accounting system for San

Fernando Company

. Designed and developed the system of consolidation credit for

Santander Bank

. Developed procedures and functions to migrate information from

Teradata to Oracle Database for Credit Bank

. Maintained and developed new modules for the system of agreements at

PeruPetro Company

EXECUPLAN Jan 2000 to Dec

2001

Functional Analyst

Functional role in the project of logistic and material development and

planning system, gathering requirements, definition, and implementation of

the Wardrobe module, in charge of 6 programmers

. Partnered with Analysts and Business Units to gather, analyze, and

implemented the Logistic and Material Development and Planning System

for the Navy of Peru

. Modeled Oracle Database for the Wardrobe module

. Managed 6 programmers to develop the Wardrobe module

. Performed testing process, unit, integration, functional, and

acceptance testing

. Trained personnel in the use of the Wardrobe module

PERUVIAN DEPARTMENT OF ENERGY Jul 1996 to

Nov 1999

Business Analyst

Oversaw the office of development in the electricity area. In charge of

analysis, development, and maintenance of the modules of generation,

distribution, and transmission of energy

. Modeled, designed, and developed the Oracle database system to be used

in all areas of Generation, Distribution and Electric Transmission

. Developed of a workflow database system to track order information

requests, using Oracle Developer 2000 Forms/Reports/PL/SQL

. Maintained and developed new reports on demand using Microsoft Access

Database

. Provided statistical reports to be used in the statistical electricity

yearbook 1998

Contact this candidate