SUMMARY

• 7 years of IT experience working as Oracle Technical Consultant/Analyst on Sun Solaris, AIX 5.3 and Windows 2000/XP Professional/NT Server in 24x7 Production and Development environments.
• Experience with Oracle 8i, 9i, 10g,11g versions.
• Experience in writing Packages, Procedures, functions and triggers using PL/SQL.
• Optimising the SQL Queries through Database Tuning using TOAD/PLSQL Developer.
• Experience in Oracle 8i/9i/10g/11g (both on UNIX and Windows environment), SQL*Loader, Export, Import, PL/SQL, SQL*Plus, Performance Tuning of Database by optimizing SQL and PL/SQL scripts.
• Documentation as per the client requirement.
• Expertise in developing forms using Oracle Forms 6.0/6i/9i/10g/11g, Oracle Designer 9i/10g and Reports using Oracle Reports 6.0/6i/9i/10g/11g, SQR Reports.
• Experience on Korn/Bourne shell scripting, includes file monitoring scripts, data manipulation scripts and data load scripts.
• Extensively used VI editor.
• Responsibilities include client interaction to understand expectations, requirements, formulating solutions, designing the architecture and developing the application besides managing teams.
• SQL loader, DB links, Materialized view creation, index creation and fine - tune queries.
• Involved in Resolving the Tickets in Service Center depending on the priority of the tickets.
• Good understanding of UNIX concepts and architecture.
• Initiating the project with identifying the requirements, estimating and designing. Ensuring and implementing a good development plan. Work distribution and tracking is one of the prime responsibilities.
• Experience on Logical & Physical Designing of Databases. Data Modelling, Conceptual Design & Data Architecture. Extensive use of Erwin as a modelling tool.
• Experience in technical documentation.
• Good communication and interpersonal skills.

TECHNICAL SKILLS:

RDBMS: Oracle 8i, 9i, 10g, 11g.

GUI Tools: Oracle Forms 6i/9i/10g/11g, Oracle Reports 6i/9i/10g/11g, Oracle Designer 9i/10g.

Languages: SQL, PL/SQL, SQR, UNIX Shell Scripting.

Other Tools: SQL*LOADER, Putty, SQL Navigator, PL/SQL Developer, TOAD, Hummingbird, SSH

Operating Systems: Sun Solaris 5.8/5.6,HP-UX 11.x/10.x, AIX 5.3, Linux, UNIX, Windows 2000/03/NT/XP

PROFESSIONAL EXPÉRIENCE:

Confidential, Rosemont, IL

Oracle Developer

Responsibilities:

• Created several materialized views for reporting purpose and better performance.
• Done the data loading (Migration) process from flat files XML files into the new database respective tables using SQLLDR by writing scripts.
• Developed the complex search Measurement functionality by writing stored procedures, package and function.
• Tuning SQL using Explain Plan and SQL Tuner.
• Detected and rectified errors. Modified & enhanced the related PL/SQL stored procedures according to the requirements.
• Used TOAD Xpert for development of Oracle scripts and procedures.
• Assisted the team of Developers in SQL statement tuning and use of ANALYZE command, Events trace to track the execution plan of statements.
• Involved in Writing Backend Packages extensively in PL/SQL.
• Defining and reviewing the coding standards, besides reviewing the code.
• Customization of code as per the user requirements.
• Separating of tables and indexes on different locations. Reducing Disk I/O Contention etc. Applications Tuning of Database using Explain plan, Tkprof, SQL Trace, Analyze, Ordered Hints, query tuning and optimization.
• Built Error management System for the Capturing all the Errors in the Packages and all the errors that belong to pl/sql are generated using error management system.
• Extensive Use of External tables and Creating Sequences to generate numbers on the fly.
• Co-ordination between development, testing and production teams and attending bridge calls and technical.
• Created, debugged and modified form level validations.
• Unit testing of all the forms and reports developed and modified thoroughly before QA testing.
• Closely worked with functional team and users in resolving the issues.
• Provided Tier3 Application support with 24/7 production support.

Environment: Oracle 10g/11g, SQL, PLSQL, TOAD Xpert Ver 7.6, SQLLDR, SVN, Putty Manger, UNIX Shell Scripting, Erwin, UNIX, Windows

Confidential, Buffalo, NY

Oracle Developer

Responsibilities:

• Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.
• Created, debugged, and modified stored procedures, triggers, tables, views, user-defined functions etc.
• Customized and optimized existing PL/SQL packages, procedures and functions to accommodate change in functionality and better performance.
• Involved in writing the database triggers to furnish the audit details.
• Designed notification process for order movement using PL/SQL.
• Involved in developing and scheduling using cron jobs to load the data into the database and export/import mechanism for data migration for bulk upload.
• Provided Tier3 Application support with 24/7 production support.
• Involved in Writing Backend Procedures, Function & Packages in PL/SQL.
• Trouble shooting and provide 24x7 supports for Production environment.
• Maintained the data integrity and security using integrity constraints and database triggers
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Defining and reviewing the coding standards, besides reviewing the code.
• Customization of code as per the user requirements.
• Separating of tables and indexes on different locations. Reducing Disk I/O Contention etc. Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS etc. Oracle query tuning and optimization.
• Developed various forms as per the requirements for data processing.
• Involved in Preparing Detailed technical documents

Environment: Oracle 10g, PL/SQL Developer 7.1.5,Unix, Shell Scripts, Hummingbird, .

Confidential, Chicago, IL

Oracle Developer

Responsibilities:

• Responsible for gathering requirements from users for reports development and interface program customizations and in analyzing business process.
• Customized and optimized existing PL/SQL packages, procedures and functions to accommodate change in functionality and better performance.
• Involved in writing the database triggers to furnish the audit details.
• Modified order line report using SQR.
• Designed notification process for order movement using PL/SQL.
• Developed Available Inventory reports using Oracle Reports 10g.
• Developed new forms and new reports using Oracle Forms 10g and Reports 6i/10g.
• Extensively used Dynamic SQL in Oracle Forms and Oracle Reports.
• Developed Unix Shell Scripts to automate backend jobs, load data into the database.
• Involved in developing and scheduling using cron jobs to load the data into the database and export/import mechanism for data migration for bulk upload.
• Performance Tuning using Hints, Indexes, Explain Plan, TKPROF.
• Performed SQL performance tuning for various PL/SQL packages.
• Worked with the production support team in resolving tickets.

Environment: Oracle 10g, PL/SQL Developer 7.1.5, Oracle Reports Builder 6i/10g, Oracle Forms Builder 6i/10g, SQR, PITTS.CON, PVCS, Java, AIX 5.3, Unix, PERL, Hummingbird.

Confidential

Oracle Developer

Responsibilities:

• Involved as a key team member for Requirement Analysis during the design phase and interaction with client.
• Responsible for assigned code /screen modifications, enhancements and adhoc data requests.
• Generated new forms for front end user application using Oracle forms Builder 10g.
• Involved in developing new reports and enhancements to the existing reports using Oracle Reports 10g.
• Developed a PL/SQL package 'VZ GC USAGE REPORT' for generating a report which displays the details of customers who received gift cards.
• Developed stored procedure 'load addr std’ which updates the information of the addresses of the transactions, so that they can be checked for valid address.
• Developed a PL/SQL package 'VZ EXP REDEEM REPORT' for generating a report which facilitates in analyzing the gift cards redeemed by the customer.
• Used SQL * Loader to upload the data provided in the staging tables to cleaned further before fulfilling them.
• Worked as production support for Verizon rebate system to troubleshoot the problems that occur during the production run.
• Extensively involved in developing new database objects such as Tables, Views, Procedures, Functions and Packages as per the business requirements.
• Extensive use of LOVs, RG, Alerts, Object groups & features in Oracle forms 10g for developing new screens.
• Used lexical parameters in developing new reports using Oracle Reports 10g.
• Extensively involved in generation of adhoc reports for month end and quarter end data to be sent to the lenders as per the requirements.
• Wrote PL/SQL Procedures, Functions and Triggers in different places using Oracle Forms and Reports 10g.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Involved in Code Reviews and preparing unit test cases.
• Involved in preparation of Checklists, identification of Test Cases and preparing Test Plans.
• Designed and extensively worked on project documentation, creation of solution design document with workflows using Visual Studio for every project.
• Extensively used External tables and Created Sequences to generate numbers on the fly.
• Involved in developing new korn shell scripts and modified existing shell scripts as per business requirements.
• Used Serena Version Controls repository for database objects, Oracle Forms Reports, sqrs, shell scripts dev.
• Extensively involved in back door data fix for production support. Provided 24/7 production support.

Environment: Oracle 10g, SQL Navigator 6.0, Oracle Reports Builder 10g, Oracle Forms Builder 10g, Oracle Designer 9i/10g, Serena Change Man Version Control, Unix

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Creation of back end triggers for faster and integral data.
• Writing Custom Packages to implement various functional areas.
• Loading Data from legacy system via SQL* loader.
• Developed UNIX shell scripts for handling large number of files.
• Schedule jobs via oracle jobs using DBMS JOB.
• Use of various DBMS packages to reuse code and automate scripts.
• Use of DBMS packages to implement scheduling, Dynamic SQL and Extensive Usage of Ref Cursors.
• Extensive use of Oracle 9i features.
• Use of EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance, Extensive Usage of Indexes.
• Extensive use of TOAD for extracting scripts from the dictionary.
• Extensive use of PL/SQL Collections and Records.
• Creation of Synonyms to create read only objects to maintain the security to give access to specific users.
• Use of Sequences to automate number generation.
• Use of different Exception Handlers and also Create Some User defined Exception Handlers.
• Customization of the support screens.
• Use of Bit map and Function based indexes to improve performance of queries.
• Design and development of Interfaces to Integrate modules.
• Extensive use of dynamic SQL in developing new reports using Oracle Reports 6i.
• Involved in developing scripts for compiling the forms and reports developed AIX 5.3.
• Extensive use of SSH for transfer of forms and reports between AIX and windows operating systems.
• Extensively Involved in Developing Transaction Forms, which involve a lot of validations at all, the levels like Field, Block and Form Level.

Environment: Oracle 9i/8i, UNIX, SQL*Loader, D2K, TOAD, AIX 5.3.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in Preparing Low Level Design Documents, High Level Design Documents.
• Coded the Stored Procedures and functions. And well tuned the SQL in the application.
• Involved in writing PL/SQL packages and database triggers.
• Migration of databases from one version to the other versions and applying patches.
• Creation of schema objects, granting of roles and privileges to the users, compilation of procedures etc.
• Generation of the flat files using UTL FILE package for the mainframe users.
• Database design, E-R diagrams, Logical, Physical layout design using Erwin.
• Extensively Involved in Knowledge Transfer for documentation team for development activities.
• Data modeling, database design and creation of database using data modeling tools. Creation of Data Flow diagrams and Entity Relation Diagrams using Erwin.
• Defining and reviewing the coding standards, besides reviewing the code.
• Involved in developing and modifying numerous forms and reports using Forms Builder and Reports Builder.
• Analyzing the enhancement / support request, estimating effort and providing architectural and technical support to the team, besides developing key components.