Professional 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:

Client: Confidential, Rosemont, IL

Role: Oracle Developer

Confidential is one of America’s leading foodservice distributors to restaurants, healthcare and hospitality facilities, government operations and educational institution

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

Client: Confidential, Buffalo, NY

Role: Oracle Developer

Confidential provides health insurance coverage to children and adults. Fidelis Care has grown to provide services to more than 910,000 New York State residents. Fidelis providers has an enterprise data-mart, where all the member data is cleansed and stored from various source systems and used for decision support and Medicaid and Medicare reporting needs.

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

Client: Confidential, Chicago, IL

Role: Oracle Developer

Confidential Services is a leading global marketing services agency with offices and resources throughout the world. A division of Epsilon, Aspen builds long-term relationships with clients, many of which are in the Fortune 100. Clients benefit from Aspen’s comprehensive portfolio of in-house marketing capabilities, including direct marketing, digital marketing, experiential and event marketing, online and offline word of mouth, Hispanic marketing and advanced analytics. This project involves getting user data from clients, sorting, extracting the applicable end user information depending on the criteria provided by clients and email marketing to the selected users.

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.

Client : Confidential

Role: 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.

Client: Confidential

Role: Oracle PL/SQL Developer

Confidential is a pharmaceutical company. The Company has set of products, which help clients understand and evaluate the variables of drug development today, and anticipate the market drivers of tomorrow. These were attained with the help of certain methods applied to data, which is again derived from doctors and physicians all around the world.

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.

Client: Confidential

Role: 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.

Environment: Oracle 8, Forms 6i, Reports 6i, Erwin, UNIX and Windows NT.