SUMMARY:

• Over 8 years of experience asSr. Oracle Developer/Data Analystin all phases of SDLC involving Analysis, Design, Development, Implementation, Testing and Deployment of business applications using Oracle 11g/10g RDBMS on various platforms.
• 6+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Applications such as OLTP, OLAP using the Oracle Relational Database Management System (RDBMS).
• Extensive experience in implementingenterprise - wideOracle basedClient/Serverandwebapplications.
• Extensive experience inSQL, 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 inETL,optimizationandperformance tuningof SQL queries using hints, EXPLAIN PLAN, SQLTRACE and TKPROF.
• Strong experience in Logical Database Modeling and Database design.
• Strong experience with Forms 10g and Reports 9i
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and Oracle 11g.
• Strong skills in developing front-end interface using OracleForms/Reports.
• 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 ofExport/Importutilities,SQL*Loaderand Oracle supplied standard packages.
• Experience in Business Process Modeling, Data Flow Modeling, Work Flow Analysis, Use Case Analysis, Activity Diagrams
• Experience in deployment of Business Objects from various database sources like Oracle, Vertica
• Experience with Vertica database architecture and experience in using designer, creating super projections and projections
• Experience in Korn and Perl shell scripting under UNIX, including FTP, loading data using SQLLDR and input parameter validation.

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: /UIForms 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 BuilderReports Builder, Forms 10g/9i/6i/4.5, Reports 2.5/6i/9i/10gTOAD, SQL*Plus, SQL*Loader, Explain Plan, Import/Export

Databases: Oracle 10g/9i/ 8i/8/7.x, MS-SQL Server, DB2, IDMS, AccessOperating System: Sun Solaris, HP-UX, Windows 9x/2000/NT, DOS.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Oracle PLSQL Developer

Responsibilities:

• Enhanced and up-graded the product by redesigned the existing data models to improve the architecture and performance
• Designed the Technical design document
• Designed and developed business logic for creating hourly, daily, weekly, monthly, quarterly and yearly summary on telecom data (Call Detail Records) using Oracle PL/SQL programs
• Developed the business logic of incremental summary of weekly, monthly, quarterly and yearly
• Developed Job scheduler to execute the summary and other packages
• Maintained huge volume of historical data (Call Detail Records)
• Involved in data mapping and populating database tables using SQL * Loader
• Implemented various PL/SQL objects like table, views, procedures, packages, triggers, functions, materialized views, global temporary tables, cursors, Bulk collect, collections, bind variables, ref cursors, sequences, synonyms, indexes etc
• Performed performance tuning at each level from creation of database to query modification using explain plan to gathering statistics of the environment including tables and schemas
• Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables
• Implemented table and index partitioning, compression and similar oracle feature to upgrade the performance
• Handled the DBA activities using oracle PL/SQL Programming like creation of Datafiles and moving tables into different tablespaces
• Also responsible for handling DBA activities
• Worked in designing of flow diagrams and ER diagrams and Business Process diagrams using various tools like Visio
• Created new forms based on UI (User Interface) requirements.
• Changed pre-existing forms to enhance screen functionality.
• Created new form triggers (like when-validate-trigger) to handle customer input validations base on one or several combination of conditions.
• Created new forms using control blocks based on stored views to display records according certain conditions.
• Used cursors with PLSQL statements to proceed to sweep and process all records retrieved one by one. Sometimes these records were displayed using control blocks at the form.
• Used “when-validate-triggers” for new data validations through item level, record level, block level, and form level.
• Used TOAD, Oracle SQL Developer and SQL Navigator:
• Used Report Builder to create new reports of Change Request using parameters.
• Used before-form and after-form to capture user parameter report set up and configurations.
• Used Report Builder to export data in several formats: Excel, PDF, TXT, and CSV.
• Oracle Discoverer:
• Did end-user support to explain the use of tables, views, and field selection to generate reports and graphics.
• Oracle Job Scheduler:
• Created and executed Oracle Job PLSQL statements to run scheduled jobs to generate export data files in formats like Excel, TXT, and CSV.

Environment: Oracle 11g, Pl/sql developer, SQL *Loader Oracle Forms and Reports 10g, Oracle PL/SQL, Oracle TOAD, Oracle Database objects (Stored Procedures, triggers, constraints, jobs), Windows, Oracle Report Server, PL/SQL Scripts, Oracle Job Scheduler.

Confidential, Charlotte, NC

Oracle PL/SQL Developer

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.
• Migrate/Upgrade OLTP/OLAP database to the new Linux Oracle RACand RacOne
• Created database schema, tables, Views and triggers.
• Managing, Monitoring and optimizing the performance of the databases on a periodic basis using AWR, ADDM reports and providing recommendations.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM)
• Developed and tuned customized complex PL/SQL procedures based on client requirement. Tuned procedures to improve overall system performance.
• 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, Oracle Tuning, Stored Procedures, SQL* Loader, SQL*Plus, Windows, UNIX, Shell Scripts.

Confidential, Houston, TX

Oracle PL/SQL Developer

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.
• 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.
• 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.

Confidential, EL Salvador

Oracle Developer

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 for significant performance in the third quarter.
• High appreciation from the client bagging a place in the IBM ‘Hall of Fame ‘for
• 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.

Confidential, EL Salvador

Oracle Database Programmer

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 cardinalities 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 selects 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. ver 1.42