Senior Programmer

Dulce Rivero

Senior Programmer PL/SQL

Winter Garden – FLORIDA 3468

Phone: (954) – 610-5697

E-mail: ************@*****.***

CAREER OBJECTIVE

To obtain a position Senior Programmer SQL.

SUMMARY

Over ten year of experience in analysis, design, documentation and development of custom application using Oracle SQL and PL/SQL, working in various versions including Oracle data base 8i/91/10g and 11g and systems customization to companies different.

I have worked extensively with Pivot Tables Match Functions Macros Crystal Reports SQL Queries.

Good in development and maintaining various PLSQL/database objects like packages, function, stored procedures, triggers, tables, views, indexes, sequences and Used Toad.

Involvement in data inmigrations to enviroments different. Experience in development SQL*Loader control programs.

Skilled at Unix commands for writing scripts and batch processes.

Extensively used of cursors, ref cursors and exceptions in development packages, procedure and function in Oracle pl/sql.

Experience in program Oracle 11g Form Builder and Report Builder.

Involved in project planning and scheduling, System Design, functional specification, Design specification, coding, system test plan, quality assurance and production support.

Proficient in restricting tables and de-normalization of tables.

Very good understanding of Object Oriented Programming.

Good understanding of data modeling concepts, ER diagrams, normalization and De-normalization of tables.

Strong analytical skills with ability to follow project standars and decision-making capability.

Preparation of: Test Plan, Test Workbook, Test Scenarios, Test Cases, Test Steps, Test Data, Defect Reports, Execution Status Reports, Estimates,Test Web Application interfaces

Quick learner and possesses ability to attain a high degree of accuracy in work and Self-motivated.

WORK EXPERIENCE

Mar 2018 - Present. Programmer Analyst. Broward County

Development Forms to ECHO Systems using FormDesigner and Reports using Crystal Report. Developer Stored Procedure, views, trigger, package, T-SQL for Microsoft SQL Server, SQL for Microsoft SQL Server 2012. and PL/SQL to XML integration.

Agus 2017 – Feb 2018 Business Systems Analyst. Renaissance Charter School.

Analyzed, tested and documented different business requirements. Performed sanity testing, requirement testing and regression testing for each project. Performed daily sanity testing to the different channels, regression testing and requirement testing and certify all projects meet requirements.

Feb 2017 – Jul 2017 Sr. Analyst Applications. Chiquita Brands USA.

Development Forms and Reports Builder (Oracle 11g) to the System (MCS) developed

at home for Chiquita Brands. Design and development of various reports for different modules.

Jun 2015 – Jan 2017 Business Systems Analyst. Celistics USA.

Registration and maintenance of projects in the Project Server application. Implementation processes to ensure Data Quality in the ETL. Maintain a deep understanding of the integrated data and work with BI Developers for “ to best interpret. Provide in-depth troubleshooting skills to assist in resolving errors and performance issues. Participation in the analysis, design, documentation and development of custom application new module of quotations Microsoft Silver Bullet. BI/Report Designs, Developer Stored Procedure, trigger, package, T-SQL for Microsoft SQL Server, Oracle 11g, Forms Builder, Report Builder, Developer Crystal Report, Silver Bullet Microsoft, Test Plan, Knowledge Sync Event, SSIS, SSRS.

Migration of data in different environments.

Development, installation and implementation of the system of credit insurance

procedure use PL/SQL, Oracle 11g (Forms and Report Builder, Power Pivot).

Identify coding and development issues, report and resolve the issue.

Execute Functional testing on web applications interface.

Provide reports and recommend improvement of application.

Recommend approval on programs that passed the test.

Deliverables: Test Plan, Test Workbook, Test Scenarios, Test Cases, Test Steps, Test Data,

Defect Reports, Execution Status Reports, Estimates, Executive Briefs/ Reports/

Test Web Application interfaces

Communicate test progress and results to system stakeholders.

Dashboards/ Forecasts, Metrics, etc.

Software Development Methodologies: SDLC, Waterfall

Coordinated with Project Managers to better understand project schedules and risk.

Coordinated with Designer to better understand flows and functionalities

Coordinated with IT development team to ensure timely defect resolution

Direct supervisore: Juan Jose Escobar(Director of technology). Phone: +58-412-***-****

Mar 2007 – Nov 2013 Programmer Analyst

Banesco Banco, C.A., Caracas, Venezuela

Development, installation and implementation of systems interfaces with

Developer Oracle 10g, PL/SQL Plus 8.0 Release 9.0.1.3.0, Report Builder,

Toad 10.1.0.2.0., Unix, C++, Crystal Report. Customization different modules of system.

Participation migration of data in different environments.

Correction of incidents in bank insurance system.

Direct supervisore: Jayce Luques(Head of Applications). Phone: +58-414-*******

Nov 2004 – Mar 2007 Programmer Analyst

GioSeg Systems, C.A., Caracas, Venezuela

Mass Migration of data and commissioning the system.

Development, installation and implementation of systems interfaces with

Developer Oracle 9i, PL/SQL Plus 8.0,8.i, Crystal Report.

Using PL/SQL 8 to XML integration with the insurance system in

modules portfolio, Housing / Income, Expenditure and Financing.

Direct supervisors: Alberto Alvarado, Neira Villamizar(System Manager).

Oct 2002 – Aug 2004 Programmer Analyst

Federal Bank, C.A., Caracas, Venezuela

Correction of incidents in bank system. Lifting information.

Oracle 8.i and Toad 8.6.1. Direct supervisore: Tamara Aguilar(System Manager).

Jul 1999 – Oct 2002 Systems Consultant

Biomerieux Laboratory Colombia, Ltda., Bogota, Colombia

Direct supervisore: Santiago Montes(Administrative and financial manager)

Phone: 571-***-****

Preparation and execution of courses Solomon IV system, including modules for inventory,

accounts payable, accounts receivable, accounting and multi-use currency.

Design and development of various reports for different modules.

Migration of data and commissioning the system.

SQL Server, Visual Basic.

Jul 1998 – Oct 2001 Systems Consultant

AGA Fano S.A., Bogota, Colombia

Direct supervisore: Armando Rocha(System Manager)

Phone: 571-***-****

AGA Gas S.A., Ecuador,Quito

Direct supervisore: Oswaldo Buitron(IT Manager)

Phone: 593-***-****

Migration of data and commissioning the system.

Preparation and execution of courses Solomon IV system, including modules for inventory,

accounts payable and accounts receivable. SQL Server, Visual Basic.

TECHNICAL SKILLS

SQL*PLUS, PL/SQL, Oracle SQL Developer, Oracle Forms 6i/11i,Oracle Reports 6i/11i,Pro*C,VB6.0, Developer 2000,VC++,C,C++, Turbo Pascal 6.0, Assembler, Cobol II, Object Oriented Programming (OOP), Object Oriented Analysis and Design (OOAD), SQL*Report Writer, SQL*Loader, Visual Basic, Excel, Shell Script Unix, Visual C, Oracle SQL Developer, Access, Toad 10.1.0.2.0, SQL Navigator, PL/SQL Developer, web development, KnowledgeSync Event.

Operating Systems HP-UNIX, Unix System V, Windows 95/98/2000/ NT/ XP

Tools/Utilities PLSQL Developer tools, Import/Export,SQL*Loader,Oracle Designer.

EDUCATION

Mar 1992 - June 1998 Central University of Venezuela

Bachelor Computer Science Degree

Mar 2002 - Apr 2002 Grupo Inabox, Introduction to oracle applications development Oct 2010

Oracle 10g: Sql command to intonation

Sep 2012 “SOA”. Fundamentals, levels of abstraction and methodological model

Feb 2012 Introduction at RUPCOB

Nov 2012 Java SE 7 Programming Ed 2

Contact this candidate