SUMMARY

• 9+ years of total experience in Analysis, Design, Development, and Testing of business applications in OLTP, web based, Client/Server architectures.
• Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development life cycle.
• Data loading using UNIX Shell scripts, SQL*Loader.
• Written Pro*C modules to integrate with extraction and mapping tools.
• Experience in developing logical and physical modeling of a database using ERWIN.
• Analyzing of SQL and PL/SQL statements using EXPLAIN PLAN to improve the performance.
• Excellent working and conceptual knowledge of C/C++, Oracle 9i, 10g,11g, PL/SQL, Java, JSP, HTML, and Java Script.
• Used Oracle Forms 9i, 6i and Reports 9i, and 6i as GUI for Oracle Applications.
• Strong programming skills in JAVA (servlets, JSP), C/C++, HTML and DHTML.
• Working experience of XML, XSLT and XSD.
• Expert in writing data warehouse data definitions in clear and concise business language and fulfilling ad hoc report requests for users against various source systems.
• Having good knowledge of Oracle 9i Database Administration (DBA).
• Good knowledge of Solaris Administration.
• Extensive experience in writing packages, stored procedures, functions and database triggers using SQL and PL/SQL in oracle.
• Used Web Services and XML for certain applications.
• Expert in using APEX interactive Report Features and PDF printing.
• Expert in working on Various Charting features and Sales order applications in APEX.
• Conceptual knowledge of Software Development Life Cycle.
• Expertise in developing web applications using Java and related technologies.
• Excellent analytical and communication skills those are required effectively to work in the field of applications development and maintenance.

TECHNICAL SKILLS

Databases: Oracle 8, 8i, 9i,10g,11g, DB2, MS ACCESS, SQL Server7.0, Advanced Queuing, 8IDE SQL Developer, SQL Plus, SQL Station C, SQL Navigator, VISIO., TOAD, ERWIN

Operating Systems: Win 98, XP/NT, Windows 2000, Red Hat, Linux 7, Sun Solaris 7, HP - UX.

GUI: Oracles forms and reports 6i, 9i, 10g, APEX 3.1, 4.0. forms and reports.

Reporting Tools: Oracle Reports 10g /9i/6i, Discoverer Reports, Crystal Reports.

Languages\Scripting: ASP.Net, VB, Visual Basic, Java, J2EE, XML, Pro*C, Korn & Bourn Shell, PL/SQL Scripting, SQL, JDBC, JavaScript, Unix, VBA

SQL Utilities: SQL*Plus Worksheet, SQL*Loader, EXPORT, IMPORT, TKPROF, SQL*PLUS

Version Control Tools: Clear Quest, Star Team, Clear Case, CVS, REMEDY, Visual Source Safe, HP Quality Center.

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, North Carolina

Sr. Oracle Developer

Responsibilities:

• Developed Procedures to validate data in the new oracle database for the biennium with the Legacy data.
• Wrote UNIX Korn shells cripts to call forth all the SQL Procedures and scheduled them as Cronjobs.
• Exported and Imported Large Volumes of Data in the format of CSV files, Excel Sheetsand TEXT files into the Tables using toad and sql plus.
• Performed Data Dump operations using EXPDP and IMPDP in sql plus. Also schema exports and imports were performed when necessary.
• Created partitions on the tables to be queried and used EXCHANGE Partitions to improve the performance of the materialized views refresh.
• Developed PL/SQL Views and Materialized Views with fast and Incremental Refresh Rates using Oracle TOAD. Performed advanced queuing for creating message based functions.
• Developed HTML Reports emails to report all of the daily jobs running by all the teams.
• Worked closely with COGNOS Developers for reporting needs and developed SQL queries, Views and Materialized Views to run the self service reports very fast.
• COGNOS Master-Detail Forms were developed using the queries given by the database developers based on the best performing lowest cost optimized query..
• Worked closely with JAVA teams including in Hibernate to develop high performing and low cost Dynamic queries which retrieve data very fast.
• Developed Balanced and Bitmap Indexes and Composite Indexes on tables and materialized views for fast querying with n the partitions themselves.
• Large tables were copied from one database to another using COPY command in SQL plus.
• Developed PL/SQL Packages for data Loading (ETL) purposes and materialized views with a complete refresh.
• Created Synonyms for the Materialized Views and refreshed the materialized views using scheduled cronjobs.
• Wrote SQL code to create JOINS, VIEWS on various tables.
• Performance tuning using TKPROF, Hints, Stats packs, Explain plan and using SQL Optimizer tool in TOAD was done.
• Performed file cleaning in UNIX and modeled the unix directories structure for including the environment files along with its variables.
• Used FTP and SCP to bring files from legacy systems to load data into database using SQL* loader. Also some of the files were sent to mainframes to validate data.
• Worked on PL/SQL Implicit, Explicit Cursors including Cursor for-loops.
• Extensive work in project planning with managers, business analysts and team members to collect business objectives requirements and proposing subsequent solutions.
• Wrote SQL Queries and developed PL/SQL Packages and XML scripts for indexing data so that budget analysts can view the data online.
• Worked on External Tables and Global Temporary Tables.
• Code optimization using Explain Plan and Process time reduction and analysis.
• Worked on PL/SQL Error/Exception handling, Control Structures in PL/SQL.
• Utilized DBMS utility packages and DBMS SQL for better error handling and fast dynamic DML activity by parsing the data into the DBMS SQL package.
• Involved in Functional Testing and Unit Testing. Worked on SDLC (Software Development Life Cycle) during the period of application development.
• Executed Korn Shell Scripts in Production.
• Created DBLINKS in oracle to connect to the old databases based on Oracle 10g.
• Worked on Oracle Performance tuning to improve the performance of SQL queries.
• Responsible for troubleshooting the errors using event handling exceptions and PL/SQL programming during the Production Support period.
• Created Indexes on tables and Optimizing Stored procedure queries using Oracle TOAD.
• Performed Integration, Functional and Unit Testing on code.

Environment: Oracle 10g, Oracle Performance Tuning, Korn Shell Script, JDBC, JSP, HTML, XML, UNIX scripting, ESP, Data Stage, Oracle SQL OPTIMIZER, TOAD, SQL*Loader, PVCS, SQL Navigator, TKPROF, Query Analyzer, ORACLE Enterprise Manager, MS Visio, Clear Quest, TOAD, Eclipse, TKPROF, Hibernate, UNIX, ERWIN 4.0.

Confidential, Charlotte, North Carolina

Oracle Developer (PL/SQL)

Responsibilities:

• Developed PL/SQL Procedures, Functions, Packages using TOAD and Oracle 10g.
• Developed PL/SQL Views and Materialized Views with fast and Incremental Refresh Rates using Oracle TOAD. Performed advanced queuing for creating message based functions.
• Worked on PL/SQL Implicit, Explicit Cursors and created Triggers for tables.
• Used TOAD, SQL*Loader and APEX 4.0 utilities to Export and Import Large Volumes of Data in the format of CSV files, Excel Sheets into the Tables.
• Extensive work in project planning with managers, business analysts and team members to collect business objectives requirements and proposing subsequent solutions.
• Wrote SQL Queries and developed PL/SQL Packages for data Loading (ETL) purposes.
• Wrote SQL code to create JOINS, VIEWS on various tables.
• Worked on External Tables and Global Temporary Tables.
• Performance tuning using TKPROF, Hints, Statspacks.
• Code optimization using Explain Plan and Process time reduction and analysis.
• Worked on objects types and PL/SQL tables.
• Front end user interface development Oracle APEX 4.0 and developed Master-DetailForms.
• Extensively worked on PL/SQL Error/Exception handling, Control Structures in PL/SQL.
• Support production DBA in daily or emergency procedures to resolve issues.
• Involved in Functional Testing and Unit Testing. Created Master-Detail forms using Oracle APEX.
• Worked on SDLC (Software Development Life Cycle) during the period of application development.
• Executed Korn Shell Scripts in Production.
• Created DBLINKS in oracle to connect to the old databases based on Oracle 10g.
• Performed daily jobs and procedures and logging the Materialized views for cataloguing and refreshing new data to merge with the old data.
• Worked on Oracle Performance tuning to improve the performance of SQL queries.
• Worked on a rotating schedule providing Production Support to mature PL/SQL applications
• Responsible for troubleshooting the errors using event handling exceptions and PL/SQL programming during the Production Support period.
• Provided support and automation of routine Informatica procedures, also involved in Performance tuning of ETL transforms and workflows.
• Created Indexes on tables and Optimizing Stored procedure queries using Oracle TOAD.
• Performed Integration, Functional and Unit Testing on code.

Environment: Oracle 10g, Oracle Performance Tuning, Korn Shell Script, JDBC, JSP, HTML, XML, UNIX scripting, BEA web logic, UNIX, DataStage, Oracle APEX 4.0 (Application Express), TOAD, SQL*Loader, PVCS, SQL Navigator, Net beans, TKPROF, Query Analyzer, Enterprise Manager, MS Visio, Clear Quest, SQL Server 2005, TOAD, Eclipse, TKPROF, UNIX, ERWIN.

Confidential, Houston, Texas

Oracle Developer (PL/SQL)

Responsibilities:

• Involved in planning and development of the business solutions with project managers and database administrators.
• Writing Oracle PL/SQL Procedures Materialized Views.
• Extensive coding to create new Function, Procedures and placing them in Packages in PL/SQL.
• Worked on Triggers, Cursors, and Views and in PL/SQL.
• Optimizing the code for better process time using Explain Plan and TKPROF.
• Worked with SQL Trace, TKPROF in generating statistics for queries which are performing badly.
• Developed and Executed Korn shell scripts and moved them to production.
• Query plans analysis and query tuning, in PL/SQL using optimizer Hints.
• Associating Indexes and Views using Statspack.
• Collecting statistical data into the data bases manually and into OEM.
• Monitoring locking issues, contentions.
• Enhancing the performance of Metadata Views.
• Developed Master-Detail forms in Oracle forms 10g and APEX versions
• Designed Worksheets in Cross Tab layouts using Discover Plus for User interactivity.
• Wrote various types of Triggers before INSERT and after UPDATE.
• Used SQL Loader for loading CSV files into Data Base and from database to Excel Files.
• Worked on Various Page settings and Regions and LOV creations, ITEMS in APEX forms
• Developed PL/SQL batch jobs using UNIX Shell scripting.
• Worked on Cursors Explicit and Implicit.
• Using Extract, Transform and Load data (ETL) in PL/SQL for input collection.
• Configuring and tuning both the Automatic PGA memory and Manual PGA memory.
• Generated Reports for Oracle Financials AP, R, GL (Monthly and Quarterly) in PDF/Excel formats using Oracle 10g Reports/APEX.
• Involvement in the test scenarios and performed unit and regression tests on PL/SQL programs, Power Script functions and UNIX shell scripts.
• Dividing and distributing database files across Tables paces using Table space storage structures.
• Reorganizing databases using Oracle Partitioning into segments separated by Row chaining and Row migration methods.
• Using Oracle tools like TOAD, PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.

Environment: Oracle 10g, Oracle Performance Tuning, Korn shell script, XML, UNIX scripting,, Datastage, XML, TOAD, PRO*C and UNIX Shell Scripting, TKPROF, HTML, SQL*Loader, TKPROF, Query Analyzer, Enterprise Manager.

Confidential, Kansas, Missouri

Oracle Developer (PL/SQL)

Responsibilities:

• Expert in writing Oracle PL/SQL Procedures, Function, Packages.
• Worked on Triggers, Cursors, and Views and Materialized Views in PL/SQL.
• Extensively Used PL/ SQL and SQL for tuning buffer cache latches, and enhancing event timed statistics.
• Prepared Quarterly Reports using Oracle 10g and Crystal Reports and Generated Output in the forms of PDF, Excel and JSP pages.
• Expert in Designing the Logical and Physical Data Model using Visio and Toad.
• Prepared Design Specification and Technical Specification Documents.
• Worked on Complex Master-Detailed forms Triggers and LOV’s using Forms 10g.
• Migrated Forms and Reports from old 6i versions to new 10g versions.
• Extensively tuned PL/SQL queries for cost optimization and Performance Tuning using various tools like TKPROF and Explain Plan.
• Experience in designing and developing high volume transaction based systems.
• Database performance modeling exporting and importing data using APEX.
• Highly skilled in performance tuning, query tuning, in PL/SQL using Optimizer HINTS.
• Experience with SQL*Plus, SQL*Loader, Data Pump, EXPORT/IMPORT, TKPROF, Oracle scheduler, Advanced Queues, Object management and used APEX.
• Used Reference Cursors in procedures and functions in PL/SQL.
• Used EXPORT and IMPORT to export current database and copy one schema to another schema.
• Performed Extract, Transform and Load data (ETL) in PL/SQL.
• Perform Data Analysis and Data Scrubbing Tasks in PL/SQL.

Environment: Oracle 10g, Oracle 9i Reports and Forms, Discover Desktop, MS SQL Server 2005,Toad, Java, J2EE, Sql Loader, Explain Plan, TKPROF, Oracle Performance Tuning, ETL tools, ERWIN, Microsoft Visio, APEX, Clear Case, Clear Quest, PVCS.

Confidential, Columbus, Ohio

Oracle Developer

Responsibilities:

• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle 10g and Apex.
• Performed data loading/unloading from both CSV and Flat Files with the help of Utilities provided in Oracle Application Express (APEX) and TOAD.
• Involved in Performance tuning of ETL transforms and workflows. Created Indexes on Tables and Optimizing Stored procedure queries using Oracle TOAD. Performed Integration, Functional and Unit Testing on code.
• Worked on APEX generating summary reports.
• Written JavaScript functions to load data from XML files to display on the web browser.
• Created partitions on the tables to improve the performance in PL/SQL.
• Used Oracle Reports and APEX for Multidimensional Data Analysis, Designing and Reporting “Presentation Quality” Reports in various formats such as pie charts, bar charts, cross-tab summary tables and nested sub-reports.
• Involved in writing LINUX/UNIX shell scripts.
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus for joining.
• Embedded HTML and Java Script in PL/SQL Program units using HTP package.
• Development and Testing of advanced SQL and PL/SQL based code in support of Reports.
• Created Forms using Data Block wizards and Layout wizards in oracle forms 10g and APEX.
• Created data model for reports and summary columns and formula columns in Oracle reports 9iand APEX.
• Worked on the Email notification programs to notify the users of recent load information.
• Designing report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports and report data export to XML format.
• ‘Converted flat files into databases using SQL*LOADER.
• Created partitions for parallel processing of data.
• Created LOVs, Menus, Program Libraries and Canvases for front-end interface using Oracle Forms and APEX.

Environment: Oracle 10g, XML, Oracle Developer Suite 10gR2, Oracle Forms and Reports 10g, APEX, Sun Solaris (Sun OS 5.10), Oracle Web Server (OAS), Java/J2EE, Perl, Pro* C, C#,.Net, SQL Navigator, Dream Weaver MX.

Confidential, Kansas, MO

Oracle FORMS & Reports Developer

Responsibilities:

• Involved in the analysis, design, coding and testing of the application.
• Involved in preparation of user requirement documents.
• Developed User interface using Oracle Forms and Reports.
• Worked with SQL Trace, TKPROF in generating statistics for queries which are performing badly.
• Developed and Executed Korn shell scripts and moved them to production.
• Constant interaction with the users to coordinate the daily activities and help them to run the business efficiently by solving errors in Forms in the front end using Oracle Forms 10gR2.
• Created Data model in ERWIN and used forward engineering to generate Create Table Scripts.
• Worked extensively on PL/SQL procedures. Functions and Packages.
• Worked closely with the BA’s in gathering Requirements.
• Involved in creation of database objects like tables, views, Materialized views, procedures, packages, cursors using Oracle tools like TOAD, PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Created Technical Specification Document.
• Maintained Version History using CVS.
• Created LOVs, Menus, Program Libraries and Canvases for front-end interface.
• Created Procedures, Functions and packages using PL/SQL.
• Involved in Unit Testing of the Application.

Environment: Oracle Forms 10g and Reports, Oracle 10gR2, Win XP, Toad, SQL * Plus, Oracle Enterprise Manager. HTML DB, JSP, HTML, TOAD, UNIX Shell Scripting, TKPROF, HTML, SQL*Loader

Confidential

Database Developer

Responsibilities:

• Generated Patient reports and their medical history.
• Involved in writing Database PL/SQL Procedures, Functions, Packages and Database Triggers using Oracle for TOAD.
• Involved in creation of Tables using storage parameters and clusters.
• Worked with SQL*Loader to extract and loading the data from flat files, oracle.
• Created PL/SQL VIEWS to provide specific access to different roles.
• Coded many generic routines (as functions), which could be called from other procedures.
• Developed Used Interfaces using Oracle Forms 6i and Master-Detail forms.
• Extensive use of SQL Server queries to perform transaction testing.
• Worked with the developers using Test Director to fix the defects.
• Worked on Oracle triggers and Event Handling.

Environment: Oracle 10g, TOAD, SQL*Loader, Oracle Developer (Forms & Reports 10g), SQL, PL/SQL, C, Java, SQL*loader and Windows XP.