Project Manager Customer Service
Resume:
NESTHOR PEREZ
*******.***@*****.***
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