Oracle PL/SQL Developer, OCA certified

Senior Oracle Certified Associate developer with more than 15 years of IT experience in system analysis, design, coding, implementation, customization, testing and production support of business applications in Client/Server, web environments. Team / Project Leader. Goal and team oriented with excellent interpersonal skills.

HIGHLIGHTS

PL/SQL Developer with extensive years of experience in IT, with very strong skills in developing information systems using Oracle Tools at all project stages.

Over 15 years of IT experience in system analysis, design, coding, implementation, customization, testing and production support of business applications in Client/Server environment.

Analysis and Design with Oracle Designer, and Development Using Oracle Forms, Oracle Reports, and PL/SQL.

Extensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development, Testing and Production.

Extensive experience in designing and working with Oracle 8i/9i/10/11g and writing SQL queries and PL/SQL Procedures, Functions, Packages, Database Triggers, Exception Handlers, Cursors, and Database Objects using PL/SQL.

Proficient in Databases Conversions, Application Tuning, Environment Setups, Security Backup, Restore, Indexes, ETL, Portal, Oracle Application Server 9iAS, SQL Loader, TOAD, FTP and End-User support

Excellent experience in Development, QA, Test and Production environment.

Excellent experience in Tuning, Performance and Optimization of queries.

Excellent experience modeling relational databases.

Extensive experience working on Waterfall and an Agile development environment.

Extensive experience in high volume of data processing and fast paced database environments

Good understanding of Oracle data dictionary.

Development on OLTP Plattforms.

Knowledge and experience in applying standard processes and documentation, under CMMI model (level 5).

Experience working on a wide variety of public and private sectors, including insurance, financial, roadside assistance, education, telecommunication, retail, gas/oil, publications, and government (forensic and national voting polls).

Excellent Interpersonal and Communication skills, coupled with strong technical and problem solving capabilities.

Work well in close cooperation with project managers and other team members

Work well independently or as a part of team.

Excellent Problem Solver, Committed to Work, Good Team Player and Target Oriented

Knowledge and practice in Foreign Exchange (Fx) Market - FOREX.

TECHNICAL SKILLS

Databases: Oracle RDBMS 7.x/8i/9i/10g/11g/12c, Microsoft Access

Languages: SQL, PL/SQL, Java, HTML.

Database Architect

Database Design and Modeling,

Database Normalization.

Security, Data guard

Query performance (SQL Tuning)

Development Platforms: Oracle Forms 4.5/6i/9i/10g, Web forms, Oracle Reports /6i/9i/10g, SQL*Plus, TOAD,

JDeveloper, Oracle Designer 6.0/9, SQL Navigator, Oracle Enterprise Manager, SQL*Loader, TOAD, SQLTools

Web services.

Oracle Designer

Application Servers: Oracle Application Server OAS 10g.

Crystal Reports.

Jasper.

Data Integration.

Oracle Stored procedures, Oracle Trigger Development.

Troubleshooting, Performance Tuning, Debugging.

Operational Systems: Windows (NT/200x Server/XP/Vista), UNIX Solaris.

Data guard, compression.

UNIX shell scripting. Bash.

Java exposition. Eclipse.

JavaScript exposition.

Tortoise, Subversion, GIT, Jira

DBA tasks, Backups, Export, Import

Methodologies: CMMI (level 5).

UML

Testing / Performance: HP ALM,Mantis.

Other technologies:HTML5

Version Control Software: Concurrent Version System (CVS), Rational Team Concert (IBM-RTC), GIT.

Helpsystems Robot SCHEDULE

IT Service Management (ITSM) using ServiceNow

Waterfall, Scrum, Agile

Sybase

Advanced office (MS Access, Excel, Word).

PROFESSIONAL EXPERIENCE

MAPFRE INSURANCE COMPANY Jan 2011–Present

Domain: Insurance.

Almost 6 years of continuous work for MAPFRE projects having two different companies as employers. Designated roles as Business Analyst, Developer and Technical Leader. Involved in a wide range of Lines of Business (Personal and Commercial Lines), Departments and TronWeb modules (issuance, third parties, claims).

Employer: 4Sight Technologies

Technical Leader

Project: Production Support for Personal Lines in TronWeb (TW) application. Webster, MA (07/2015 – 09/2016)

Requirements clarification with MAPFRE module leads and directions to offshore team in Colombia about fixing/enhancing needs.

Delivering of fixed packages and data patches to production database.

Software configuration in Production.

Version Control Management with Rational Team Concert (IBM-RTC).

Support to Business Analysts in testing.

Management tasks in abscense of Program manager.

Responsible to meet the timeline of the development activities and to negotiate with offshore team over design elements and deadlines.

Management of assignments in offshore team (12 people).

Management of tickets according priorities and impact. Productivity was raised to fix fifty issues by month.

Technical Leader - PL/SQL Developer

Project: ISO. Webster, MA (01/2014 – 06/2015)

ETL using PL/SQL and Java to extract data from Databases and XML files.

Technical design & development.

Version Control Management with Rational Team Concert (IBM-RTC).

Modification of Jasper reports.

Management of offshore development team in Colombia (6 people). Designation of tasks, periodic evaluation, revision of timelines and quality of deliverables.

Commercial lines.

PL/SQL Developer

Project: AFE. Webster, MA (03/2013 – 12/2013)

Use of Oracle objects

Developed Technical Controls using triggers and modifying existing stored procedures.

Creation of Procedures, Functions, Packages, Database Triggers and Cursors.

Creation of new tools to allow create quotes having existing policies as source.

Personal lines.

Technical Leader

Project: Production Support for Personal Lines in TW. Bogotá, Colombia (12/2012 – 02/2013)

Technical lead in offshore team.

Ticket reception from MAPFRE contact and assignment to resources in Colombia, deadlines management.

Version Control Software: Concurrent Version System (CVS)

Environment: Oracle PL/SQL Developer, Oracle 11g R2, PL/SQL, XML, Eclipse, Web Services, Agile, large databases, Unix Shell, Java, SCRUM, Jasper, ServiceNow, RTC, CVS.

Employer: Indra Company

Technical Leader

Project: Production Support for MAPFRE Florida. Bogotá, Colombia – Miami, FL (5/2012 – 11/2012)

Technical lead in offshore team.

Maintenance and enhancements for B2B, Cover-all and TW applications.

Business Analyst

Project: Mass Auto (MAPFRE Massachusetts). Webster,MA (12/2011 - 4/2012)

Selected from Colombia TW team to travel to MAPFRE USA to participate in Massachusetts Personal Auto project.

Requirements gathering phase.

Interviews with users of legacy system to know data flow and to provide some knowledge about TW.

Support to MAPFRE Business Analysts regarding TronWeb features in issuance, claims and third parties modules.

Senior Software Developer

Project: Tronweb Core (MAPFRE Spain). Bogotá, Colombia (1/2011 - 11/2011)

PL/SQL Developer in issuance, third party and claims modules.

Modifications in core database, on stored procedures, triggers and views.

Creation of patches and delivery of fixed code to production database.

Creation of forms and reports using Oracle Forms and Oracle Reports.

Environment: Oracle PL/SQL Developer, Eclipse, Web Services, AS/400, Oracle Forms, Oracle Reports.

TELEFONICA. Bogotá, Colombia (5/2010 - 12/2010)

Domain: Telecommunications.

Employer: Indra Company

Senior PL/SQL Developer

PL/SQL Development in maintenance of Oracle Packages for Internet/TV application for Telefonica (Spain).

Creation of forms using Oracle Forms.

Creation of triggers, functions and stored procedures.

Execution of patches in production database.

Environment: Oracle 11g, PL/SQL. PL/SQL Developer, Oracle Forms 6/9i, Oracle Reports 6/9i, Oracle Enterprise Manager (OEM).

ASESOFTWARE Bogotá, Colombia (6/2005 – 04/2010)

Senior Analyst / Developer

Clients: Banco de la República, Macrofinanciera, Fiduprevisora.

Domain: Banking, Financial.

Development and implementation of Phase 1 of a Treasury Management System called MASTER for Banco de la República.

Development of forms starting from scratch, using Oracle Developer Wizard, or manualy adding canvases (content, stacked, tab).

Database design and modeling.

Database normalization.

Creation of reports using Oracle Reports..

Transactional packages in Oracle Database to handle EFT transactions and Anti – Money laundering.

Creation of flat files for ACH transactions, foreign money exchange.

Creation of financial reports.

AML (Anti Money Laundering).

Clients: La Riviera perfumery, Asistencia Bolívar, Revista Diners.

Domain: Retail, Roadside Assistance, Publications.

Oracle tools used for maintenance / creation of business databases including all phases of SDLC.

Costs calculations for retail sales using Oracle packages.

Selling processes supported by Oracle Forms.

Call-Center information system for roadside assistance using Oracle Forms and Reports.

Environment: Oracle 9i, PL/SQL, Toad, Oracle Forms 6/9i, Oracle Reports 6/9i, Crystal Reports, Oracle PL/SQL Developer, Oracle Designer, CMMI 5

EMPRESA DE TELECOMUNICACIONES DE BOGOTÁ - ETB Bogotá, Colombia (10/2004–5/2005)

Domain: Telecommunications.

Employer: IT-Deusto

Position: Senior Analyst/Developer

Production support. Modification of Oracle packages according to production issues in product database.

Creation of stored procedures (packages, functions and procedures).

Data patching and research of root causes.

Environment: Oracle 9i, PL/SQL, Toad.

gasNatural Bogotá, Colombia (9/2001–9/2004)

Domain: Oil/Gas.

Senior Analyst/Developer

Development from scratch of Oracle Forms (Content, Tab, Stacked canvas) and Reports for Vehicular (transportation) and Home Gas information system.

Analysis and Design for new system using Oracle Designer, and then creating basic Forms with wizards, and complex designs manually.

Environment: Oracle 8i, PL/SQL, Toad, Oracle Forms, Oracle Reports, Crystal Reports.

EDUCATION

Bachelor Degree of Computer Science, Universidad Nacional de Colombia, 2001 (5 years).

Certifications: Oracle Certified Associate (OCA).

Contact this candidate