SUMMARY

• Over 7+ years of professional experience in IT industry as Oracle SQL/PLSQL Developer, Oracle Forms/ Reports Developer and Data Modeler.
• Involved in the development, Enhancement and Maintaining of applications in Oracle 8i/9i/10g using SQL, PL/SQL, Oracle Forms and Reports in windows and Unix environments.
• Extensive experience in developing reports using Oracle Discoverer 4i/9i/10g (administrator, desktop/plus and viewer), Report builder 6i.
• Extensive experience working with the Oracle Developer Suite.
• Experience in Debugging, Testing, and Deploying the Applications.
• Highly skilled in writing Stored Packages, Procedures, Functions, Views and Database Triggers using SQL and PL/SQL.
• Strong PL/SQL experience with Cursors, Ref cursors, collections, Dynamic SQL, DBMS Packages, Materialized views, UTL File, Import/Export Utilities and Shell Scripting.
• Experienced in Performance Tuning and Query Optimization using explain plan, Tkprof, hints and indexes.
• Expertise in using tools such as SQL*Plus, SQL Navigator, TOAD, SQL Developer and SQL*Loader.
• Data Conversion from Flat files to Oracle using Oracle SQL* Loader.
• Sound working knowledge in UNIX Shell Scripting for job scheduling on AIX 5.3 and version control tools like PVCS and CVS.
• Developing front end applications using Oracle Forms and report generation using Oracle Reports.
• Developed and supported Extraction, Transformation and Load process using Pl/Sql scripts to populate the tables.
• Extensive experience in data modeling. Created ER Diagrams on Erwin, Microsoft Visio and Smart Draw using Normalization Techniques.
• Expertise in testing and debugging process, system integration testing, unit testing and automated testing.
• Experience in preparing technical documentation and user manuals.
• Worked on 24*7 environments to provide production support.
• Worked in different phases of Software Development Life Cycle which include Analysis, Design, Development, Testing and Implementation.
• Experienced in environments requiring direct customer interaction during design specification, development, and product implementation phases.
• Interact with people at all levels; possess excellent communication skills, work ethics, Strong analytical, diagnostic and problem solving abilities.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, MS SQL Server 2000, MS Access, MySQL

Scripting: SQL, PL/SQL, UNIX Shell Scripting, PERL.

Programming Languages: C, C++, Java, JSP, HTML/DHTML, XML, ASP, VBOperating Systems MS - DOS, UNIX-IBM AIX, Solaris, Linux (Red hat, SUSE 9.2/9.3), Macintosh, WINDOWS 95/98/2000/NT/XP/VISTA.

GUI: Oracle Developer - Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 9i/10g, Developer 2000.

Query Tools: TOAD, SQL Navigator, SQL*PLUS

Other Tools: SQL*Loader, Erwin, Smart Draw, MS Visio, MS Project Professional 2003, CVS, Clear Case.

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

Sr. Oracle Developer

Responsibilities:

• Involved in all the stages of the application development including design, development and maintenance.
• As a senior Database Developer responsible for creating and managing PLSQL packages used by front end Java applications as well as batch applications using Bulk loading, Dynamic Sql, ref Cursors, regular expressions.
• Created and maintained the ER diagrams of the database using Erwin tool.
• Loading data from various sources using External table, Data pump, Sql loader utility, shell scripts and scheduled jobs to run on a regular basis using crontab.
• Writing Stored Procedures, Functions, Packages and Autonomous triggers using PL/SQL to implement business rules and processes.
• Involved in the creation of database objects like Tables, Views, Synonyms, Sequences, Indexes, Triggers, Database links etc.
• Performance tuning of materialized views using fast refresh.
• Good experience in enforcing data integrity using integrity constraints.
• Performance Tuning of SQL queries and Optimization of materialized views using fast refresh.
• Designed and developed ad-hoc Oracle Discoverer workbooks and reports and also trained the End Users.
• Worked on creating BA’s, EUL in Discoverer, creating and sharing workbooks in Discoverer Desktop and Plus and also running reports in Discoverer Viewer.
• Created custom folders and summary folders according to the user’s requirements and modified existing reports by creating additional joins using Discoverer Admin.
• Created Workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer Plus and Discoverer Desktop.
• Involved in unit testing and provided test scripts to the test team.

Environment: Oracle 11g, CVS, AIX UNIX 5.3, TOAD 9.5, Discoverer, SQL*Plus, SQL*Developer, Java.

Confidential, Columbus, OH

Sr. Oracle Developer

Responsibilities:

• Extensively worked on Stored procedures, functions and packages to support different functionalities of the application.
• Used Bulk binding/forall with save exception, dynamic sql, dbms packages, plsql collections and Sql MERGE.
• Worked with autonomous transaction, global temporary tables, ref cursors and analytical functions and regular expressions.
• Used triggers to maintain history tables and log maintenance users.
• Worked on improving the Performance of SQL queries by extensive usage of Explain plan and various hints and indexes.
• Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to online production environment using SQL*LOADER.
• Involved in creation of MINI Seeker/WIA Seeker XSD and XML files based on the business requirements.
• Modified XSD schemas and generated JAXB Classes to store parsed XML data in to staging tables.
• Extensively Worked on Unix Shell scripts and xml script for several Inbound processes that are automated. Xml is used to instantiate a java object or shell script.
• Worked on customization of forms and reports as per the requirement.
• Involved in training the Super User to create new work sheets using Discoverer
• Handled Discoverer Administration and EUL development for Applications.
• Created Workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer Plus and Discoverer Desktop.
• Created complex folders, hierarchies and Item Classes for existing Discoverer reports.
• Granted access to Business Areas and worksheets to users.
• Extensively used Control-M desktop to schedule jobs and control-m Configuration manager to run the batch jobs.
• Worked on CVS for software Configuration management.
• Involved in requirement gathering, worked with users.
• Performed Integration and regression testing for upload processes and developed Unit test plans.

Environment: Oracle 10g, forms 10g, reports 10g, Discoverer, CVS, Jdeveloper 9i/10g, comtrol-M(desktop6.3.01 and Configuration manager 6.3.01), AIX Unix 5.3, TOAD 9.5, SQL*Plus.

Confidential, Charlotte, NC

Sr. Oracle Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using SQL in Development and Production environment for Oracle 10g and was involved with the Performance tuning, Optimization of queries and standardization of the code.
• Wrote scripts for creating tables, Indexes, Grants and Synonyms in different schemas and made modifications for the existing tables as per business logic.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Suggested and Implemented indexes for faster retrieval of data in Weekly and Monthly Metrics reports.
• Involved in Data modeling to develop the database design using Erwin 4.0 and developed the logic in the oracle backend with normalization concepts.
• Developed Unix Shell scripts to automate repetitive database processes.
• Worked on data conversion, Loaded data from different Sources into the Temp data backup environment using SQL Loader and validated the data before loading it into oracle tables..
• Optimizing PL/SQL code and SQL queries using Explain Plan, Indexes and Hints.
• Setup batch and production jobs using AUTOSYS.
• Provided production support to improve turnaround time on various issues.
• Provided database support to testing team in writing complex SQL queries.
• Worked on various Business Areas in Discoverer Admin and extensively worked on the Desktop and Plus environment.
• Developed workbooks which needed cascading parameters.
• Created Workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer Plus and Discoverer Desktop.
• Created Workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer Desktop.
• Created custom folders, item classes in Discoverer Administration, cross tab, page detail reports, conditions, parameters, sharing of workbooks in Desktop edition
• Involved in designing of required end user forms and reports using Oracle forms 10g & Reports 10g.
• Customization of existing forms and development of new forms using different form built - in’s, created LOV’s and record groups.
• Worked with different triggers in forms like Block processing triggers, Interface event triggers, navigation triggers and validation triggers.

Environment: SQL, PL/SQL, Oracle 10g, SQL*Loader, Visio, Toad, UNIX Shell Scripting, Erwin, AIX 5.3, Windows NT/XP, Discoverer, Oracle Reports 10g and forms 10g.

Confidential, Minneapolis, MN

Sr Oracle Developer

Responsibilities:

• Developed new PL/SQL procedures, packages, triggers in Oracle 10g according to the business requirement.
• Wrote SQL*Loader scripts to migrate the data from flat files into database tables.
• Developed various UNIX Shell Scripts and PL/SQL procedures to automate the routine tasks and to extract and load data for month-end batch processing.
• Design Logical and Physical data, define relationships, and implement business rules as constraints for normalization / demoralization of entities.
• Resolved many data migration problems involved when upgrading from 9i to 10g.
• Performance tuning of the PL/SQL stored procedures in Oracle 10g.
• Utilized VSS version control tool to check in and check out the source code to maintain proper software configuration.
• Worked on pl/sql scripts for data extraction, Transformation and data loading of data from external sources into oracle tables.
• Used Qwest tools (Toad, SQL Navigator) for database monitoring and tuning.
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Performed Discoverer Administrator activities such as setting up security, privileges and moving reports across instances.
• Developed item classes and item hierarchies according to client report requirements.
• Worked on creating application mode End User Layer, building business areas, and building discoverer workbooks.
• Exported and Imported EUL across the instances
• Involved in training the Super User to create new work sheets using Discoverer.
• Developed User interface, Menus and PL/SQL Libraries for Forms.
• Developed new forms and update existing forms using Forms 10g and wrote triggers for validation, worked with different form objects like data blocks, canvas, windows.
• Worked on report builder 10g for developing new reports and for customization of existing reports.

Environment: Oracle 9i/10g, UNIX, IBM AIX, Windows NT, SQL, PLSQL, SQL Navigator, TOAD, Java, Discoverer, Oracle Forms 10g and Reports 10g.

Confidential, Tampa, FL

Sr. Oracle developer

Responsibilities:

• Designed and developed a custom database (Tables, Views, Functions, Procedures, and Packages).
• Created Stored Procedures, functions and Packages in Oracle 9i using SQL and PL/SQL for the Audit Trail using Oracle 9i as backend.
• Involved in data Conversion from legacy system to oracle 9i, extracting the data from source to flat files, validating the data and uploading it into oracle tables.
• Involved in Cost based and Rule Based Optimization, modified the Explain Plan statements to optimize the SQL statements.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Used UNIX Shell scripts for Extracting and Parsing data from the files.
• Used Oracle 9i features such as merge for various transformations.
• Involved in ETL processes to load data from Flat files, XML, SQL Server, Access and Excel spreadsheet into the target Oracle database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Extracted Data from Base tables using UTL file package generated Data file.
• Used SQL Loader, Import/Export and XML Utilities for Data Migration from legacy system.
• Prepared the detailed design documentation for business requirements
• Designed and developed complex forms using Forms 6i with several stored procedures and triggers.
• Developed several Discoverer reports using Oracle Reports to meet the business requirement.
• Responsible for creating new views which were used for reporting purposes through Oracle Discoverer.
• Exporting the business areas from testing to production environment.
• Done effective requirement gathering for creating new reports in Discoverer.
• Created Workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer Plus and Discoverer Desktop.
• Developed the reports as per the user requirement using Oracle Reports.

Environment: Oracle 9i, Developer/2000 (Forms 9i, Reports 9i), Discoverer, PL/SQL, SQL*Loader, JAVA, Windows 2003, UNIX AIX.

Confidential, Louisville, KY

Oracle developer

Responsibilities:

• Meeting with end user, collecting requirements and converting into technical specification.
• Developed Stored Procedures, Functions and Packages for implementing complex business logic.
• Created and maintained Oracle schema objects like Table spaces, Tables, Rollback segments, Indexes, Sequences and Synonyms.
• Created SQL*Loader scripts to load data from external system to oracle.
• Created UNIX Shell script for sending email to alert users for erroneous records.
• Responsible for performance tuning of SQL queries written in procedures and functions at the back end which are called from the front end forms.
• Involved in Technical Documentation, Unit test, Integration Test and writing Test plan.
• Created data entry Forms using oracle Forms 6i for entering data related to Order Information and inventory.
• Built custom forms using Oracle Forms 6i Builder to fulfill the business requirements of the client.
• Created and customized analytical reports for existing system using Reports 6i.

Environment: Oracle 9i, SQL PLUS, PL/ SQL, SQL*Loader, Shell Scripts, SQL Navigator, Windows XP, MS-Excel, TOAD, Developer suite (Forms 6i and reports 6i).