NESTHOR PEREZ

510-***-****

acfqz4@r.postjobfree.com

SUMMARY

. Over 7+ years of experience as Sr. Oracle Developer/Data Analyst in

all phases of SDLC involving Analysis, Design, Development,

Implementation, Testing and Deployment of business applications using

Oracle 11g/10g RDBMS on various platforms.

. Experience in Korn and Perl shell scripting under UNIX, including FTP,

loading data using SQLLDR and input parameter validation.

. Hands on experience with Oracle R12 and Oracle 11i Implementation.

. Used Perl in conjunction with SQL to automate and streamline majority

of manual processes.

. Developed database queries from the Perl scripts.

. Strong experience in Logical Database Modeling and Database design.

. Strong experience with Forms 10g and Reports 9i.

. Involved in requirements gathering and resolution of functional issues

related to EBS modules, Inventory and GL during implementation of

modules.

. Strong skills in developing front-end interface using

Oracle Forms/Reports.

. Extensive experience in implementing enterprise-wide Oracle

based Client/Server and web applications.

. Extensive experience in SQL, PL/SQL, SQL*PLUS including creating

Packages, Functions, Procedures and Triggers with emphasis on

maintaining standards and handling errors in a consistent and robust

manner.

. Experience in ETL, optimization and performance tuning of SQL queries

using hints, EXPLAIN PLAN, SQLTRACE and TKPROF.

. Developed custom batch programs in Pro*C and developed custom

Functions, Procedures and Packages Scripts.

. Extensively used Datastage components like Datastage Designer,

Director.

. Design and Development of Datastage ETL jobs using various stages like

Aggregator, Join, Transformer, Sort, Merge, Filter and Lookup,

Sequence, Modify, Peek etc. stages to load Daily and Historical data

into star schema data model.

. Advance Oracle programming skills including use of Advance Queues, Ref

cursors, Collections, Varrays.

. Strong Performance tuning and optimization experience with SQL and

stored procedures (PL/SQL)

. Extensive knowledge of Export/Import utilities, SQL*Loader and Oracle

supplied standard packages.

. Experience in Business Process Modeling, Data Flow Modeling, Work Flow

Analysis, Use Case Analysis, Activity Diagrams.

. Add or Remove Node from RAC

. Troubleshoot performance issues for the RAC instance

. Designed, tested and documented Oracle RAC database procedures

. Created, relocated and removed Services as needed in an Oracle RAC

configuration

. Adding and removing nodes to existing Oracle database RAC

configurations

Resolving RAC specific issues such as node evictions.

Technical Skills:

Languages: PL/SQL, SQL, Pro*C, Perl, Asp.Net, HTML, VB Script,

UNIX (K/B/C)

Data Modelling: Designer 9i/2000, VISIO Erwin

Tools/UI Forms 10g/9i/6i, /Reports 9i/6,SQL * Loader

Scripting: UNIX Shell & Perl scripting, SQL scripts, PL/SQL

scripts

Tools: Designer 2000/9i, Erwin 4.0, Developer 2000/6i/9i,

Query Builder,

Reports Builder, Forms 10g/9i/6i/4.5, Reports

2.5/6i/9i/10g,

TOAD, SQL*Plus, SQL*Loader, Explain Plan, Import/Export

Databases: Oracle 10g/9i/ 8i/8/7.x, MS-SQL Server, DB2, IDMS,

Access,

Operating System: Sun Solaris, HP-UX, Windows 9x/2000/NT, DOS.

PROFESSIONAL EXPERIENCE

BANK OF AMERICA, Charlotte, NC

May 12 - Present

Programmer

Worked on development or Wealth/Portfolio management Application for BoFA.

Responsibilities:

. Gathered Business Requirements and worked with the users and

stakeholders.

. Created High-level design detail design documents.

. Did review and testing of code to ensure that the code is functioning

perfectly.

. Interacted with end users and functional architects for mapping the

legacy data to the Oracle tables.

. Enhanced UI screens using Forms 10g.

. Developing and Customizing Oracle Forms as per the client requirement

. Developed Test Plans and test cases for Oracle Forms, Reports and

database scripts

. Upgraded Oracle Forms and Reports from 10g to 11g.

. Enhancements include the existing functionality of forms, reports,

interfaces and workflow

. Design and implemented customized Forms using Oracle Forms, and

registered the Forms in Oracle Application 10g and 11i ERP modules.

. Worked on solution design and setup of EBS modules, Inventory and GL

modules as per the client requirements and suggested business process

changes.

. Involved in requirements gathering and resolution of functional issues

related to EBS modules, Inventory and GL during implementation of

modules.

. Created functional design documents (MD050) for conversion, forms and

reports to address business requirements.

. Hands on experience with Oracle R12 and Oracle 11i Implementation.

. Functional experience in Oracle Financials Applications with multiple

Implementations, Upgradation of General Ledger (GL), Accounts

Receivable (AP), Cash Management (CM), Fixed Assets (FA).

. Optimize ETL processes to fit in a desired time frame

. Experience scheduling ETL processes

. Analyzed the requirements and framed the business logic for

the ETL process.

. Created ETL process Design documents and assisted project manager with

the project planning and documentation

. Developed PL/SQL packages, stored procedures, functions, alerts for

ensuring the warehouse data integrity checks and Shell scripts to

balance the data between source and target tables after each ETL

process

. Developed SQL *Loader scripts to load data from flat file

to Oracle 10g database tables as part of ETL process.

. Developed control files for SQL*Loader and written PL/SQL programs for

loading and validating the data into the tables from the Legacy system

as part of ETL process.

. Extensively involved in creating Oracle PL/SQL Stored Procedures,

Functions, Packages, Triggers, Cursors, and Indexes with Query

optimizations as part of ETL Development process.

. Developed ETL code by the business logic defined in the Functional

Design Document

. Extensive work in ETL process consisting of data transformation, data

sourcing, mapping conversion and loading

. Designed database with PL/SQL as the basis for generating various

financial reports and performing necessary financial analysis.

. Created functional design documents for conversion, forms and reports

to address business requirements.

. Converted all custom reports, Custom PL/SQL scripts and Custom

Packages, forms, reports, PL/SQL packages, procedures and database

triggers from 11.0.3 to 11.5.10.2

. Developed Test Plans and test cases for Oracle Forms, Reports and

database scripts

. Created database schema, tables, Views and triggers.

. Developed and tuned customized complex PL/SQL procedures based on

client requirement. Tuned procedures to improve overall system

performance.

. Created ETL process Design documents and assisted project manager with

the project planning and documentation

. Developed PL/SQL packages, stored procedures, functions, alerts for

ensuring the warehouse data integrity checks and Shell scripts to

balance the data between source and target tables after each ETL

process

. Developed SQL *Loader scripts to load data from flat file to Oracle

10g database tables as part of ETL process.

. Developed control files for SQL*Loader and written PL/SQL programs for

loading and validating the data into the tables from the Legacy system

as part of ETL process.

. Extensively involved in creating Oracle PL/SQL Stored Procedures,

Functions, Packages, Triggers, Cursors, and Indexes with Query

optimizations as part of ETL Development process.

. Developed ETL code by the business logic defined in the Functional

Design Document

. Extensive work in ETL process consisting of data transformation, data

sourcing, mapping conversion and loading

Analyzed the requirements and framed the business logic for the ETL

process.

. Wrote complex SQL queries and PL/SQL code to implement business logic.

. Developed custom reports for backorders processing.

. Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.

. Extensively used Export Import, SQL*Loader, Toad, FTP.

. Analysis of data and advising marketing and sales managers about

various options

to get perfect customers for organizing events and launching oracle

campaigns and products.

. Responsibilities include creating and fine-tuning multi-strategic

complex scripts using SQL and PL/SQL Packages, Procedures & Functions.

. Reviewing scripts and modification per the new requirements for new

service requests.

. Development of Complex Matrix Reports.

. Performance Tuning of the reports for enhanced speed in the production

environment.

. Extensively involved in using the merge process to load the data into

the target tables.

. Involved in uploading of the data from flat files into Databases and

validated the data with PL/SQL procedures.

. Automated Production tasks using Cron Jobs and Autosys

Environment: Oracle 10g,Forms 10g,PL/SQL, Pro*C, Oracle Tuning, Stored

Procedures, SQL* Loader, SQL*Plus, Windows, UNIX, Shell Scripts, C

Marathon Oil, Houston, TX Oct 10 -May

'12

Sr Programmer

Worked on development and enhancement of Inventory management and

procurement system.

Responsibilities:

. Performed systems analysis, gathered requirements and created design

documents.

. Developed a Client Management System to maintain client records and

all customer related transactions.

. Worked on Order entry and Order review process.

. Designed the database based on the analysis done which had almost 8-

10 database tables.

. Used SQL to define and manipulate database tables.

. Design and implemented customized Forms using Oracle Forms, and

registered the Forms in Oracle Application 10g and 11i ERP modules.

. Created functional design documents for conversion, forms and reports

to address business requirements.

. Converted all custom reports, Custom PL/SQL scripts and Custom

Packages, forms, reports, PL/SQL packages, procedures and database

triggers from 11.0.3 to 11.5.10.2

. Customized Oracle Form using Form Personalization, Custom.pll on Form

4.5/6i/9i/10g.

Migration Experience working on 10g to 11i and 11.0.3 to 11.5.10 and

from 11.5.10 to R12 Instances

. Enhancements include the existing functionality of Form, reports,

interfaces, workflow and XML publisher reports.

. Developed new forms for single and multiple table and blocks, made use

of menus, alerts, attributes and libraries to make interface user

friendly.

. Created UI screens using Forms 9i.

. Created SQL queries and PL/SQL code for business logic.

. Wrote database PL/SQL stored procedures, triggers and procedures to

provide backend security and data consistency.

. Created Reports using Oracle Reports 9i to look the customer

information according to given date and also to get the policy details

such as policy number, expiration date and issuing date with the

renewal date.

. Perform routine database tuning and administration activities for

several Oracle databases.

. This software had a capability of storing pictures in form of TIFF

format and all the proofs of insurance policy, which would link with

the associated client record.

. Database was later on migrated to Oracle 9i to enhance the software

capabilities to new web enabled features such as remote access. SQL *

Loader was used to transfer all records to new Oracle 9i database.

. Perform routine database tuning and administration activities for

several Oracle databases.

. Extensively worked on report attributes like Report triggers, Program

units, Attached libraries and Built-in packages.

. Customized forms by writing block level triggers and item level

triggers using Oracle Forms.

Achievements:

. Did the business analysis and data assessment of the project.

. Normalized the database based upon the specification prepared during

the analysis.

. Developed a custom workflow for tracking service requests, and

notifying users about the status of these service requests.

. Used abstract data types in database tables such as VARRAY and NESTED

tables.

. Created complex PL/SQL stored procedures and triggers.

. Converted an existing database in MS-Access to Oracle for a pre-

existing application in Visual Basic.

. Did some modification in database connectivity for VB application for

Oracle database.

. Planned and implemented proper network methodology by introducing a

proper Client/Server technology.

. Validated test data results using complex SQL queries.

. Created a separate form that would process large object storage such

as scanned pictures, documents and other binary files.

Environment: Oracle 10g/9i,Forms 9i/Reports 9i, PL/SQL, SQL, TOAD, SQL *

Loader, UNIX, Discoverer 10g, TOAD, Windows 2000, HP-UNIX

Administraci n y Sistemas S.A,El Salvador

Feb '09 to Oct '10

Oracle Developer

Consultant company with customers in a wide variety of industry field:

financial, construction, insurance, investment, telecommunications, and

others. The customers usually have similar business information system

modules like Payroll, Human Resources, Web Services, Risk Management,

Investment Management, Quality Control, Customer Service, and so many

others.

.

Responsibilities:

. Responsible for the design, development and import of invoice

information into Oracle Receivables.

. Maintaining concurrent manager and assigning priorities.

. Creating users & modifying the privileges for users. Creating

appropriate roles and assigning it to users.

. Migrated the data from excel sheets, text files into the respective

Oracle Database tables using SQL *Loader scripts.

. Loaded data into oracle tables using SQL*Loader and dbms_utility

package.

. Maximum number of production releases in one year.

. Excellence award for significant performance in the third quarter.

. High appreciation from the client bagging a place in the IBM 'Hall

of Fame ' for 2010 -2011

. Responsible for fine-tuning the application to speed up the

execution time by almost 70% (From 3 sec down to .03 sec). The speed

of execution had a direct impact on Dollar Gain for the client

. Modifying UNIX shell scripts within the project framework

. Responsible for customization of reports according to client

requirement in key indicator report and Distribution detail report

like Account Status Report, Transaction Detail Report, etc.

. Created the data flow diagrams using Microsoft Visio.

. Registration of new forms, Creation of concurrent executables and

concurrent programs for reports, Opening up Descriptive Flex fields.

. Written scripts to customize customer needs.

. Extensively worked in the scheduling and monitoring of mappings in

Information Warehouse.

. Extensively worked in the analysis and tuning of the Application

code (SQL).

. Monitor all the Production, System Test and developments boxes for

any errors in the logs and fix them as needed.

. Was responsible for tuning the SQL statements using Explain Plan,

SQL Trace, TKPROF, Clusters and Optimizer Hints.

. Used UNIX shell scripts to run the batch PL/SQL procedures.

Environment: Oracle 8i,Forms 6i, reports, SQL*Loader, Developer 2000,

PL/SQL

CONSISA SA, EL Salvador Aug '07-

Feb'09

Oracle Database Programmer

Worked on development of applications for customers of CONSISA.

Responsibilities:

. Developed the database using ER Model. Stored procedures and triggers

were developed to maintain integrity of the database

. Designed forms for data entry, patient information and validation

. Created nested and complex Select statement in Oracle Reports to generate

Matrix reports.

. Created Master-Detail block forms using implicit and explicit

relationships.

. Used pop lists, T-lists, and combo boxes to capture data in the adequate

format.

. Created forms with multi-canvas views to offer space and comfortable

visualization of items.

. Used transactional triggers to performance DML commands within screen or

forms.

. Used form triggers (pre, post, when, on, and key triggers) to ensure the

application of the business rules.

. Used built-ins within the PL/SQL forms code to pre-configure navigation,

canva sequences, and item's events.

. Tuned up database: Implemented indexes and hints within the SQL

instructions to optimize the statements no matter the table size involved

and get the data in seconds instead of minutes.

. Created third tables to define many to many cardinality between tables:

many customers required many products.

. Created scripts to convert existing data into specific format required

for other applications before the loading data process.

. Created cursors stored in packages at the database level to be called and

deployed in a block based on stored procedure.

. Created screen forms to deploy records in a block based table in

different colors (red, orange, blue, green, and yellow) according to a

code alert for a Risk Management application (post-query record trigger).

. Used PL/SQL tables to store temporal end user selection in order to get

parameters to be applied in complex processes.

. Created dynamic LOVs (List of Values) where the populated data depended

on the previous end user selection.

. Created dynamic reports where the end user select the order by fields of

the results.

. Generated custom reports to track patient progress, to print bills and

generated vouchers

. Created indexes for fast retrieval of information

. Backup and recovery was performed on weekly, monthly basis

Environment: Oracle 9i, PL/SQL, Oracle Forms 6i,Reports, Unix, Windows NT.

Contact this candidate