SUMMARY

• 10 plus years’ experience in software development using Oracle database and tools.
• Worked with Oracle 11g/10g/9i/8i databases developing backend modules (Stored Procedures, Functions, Packages, Triggers and Views) for multi tier business applications.
• Exposure to complete Software Development Life Cycle including requirement gathering, design, development and documentation.
• Good Knowledge in Advanced PL/SQL such as Bulk collection, Ref Cursor, Autonomous Transaction and optimizing the PL/SQL code.
• Experience working on Oracle Applications EBS Release 11i and R12 - Financial Modules developing RICE (Reports, Interfaces, Conversions, Extensions).
• Experience in tuning SQL queries and PL/SQL code using Explain Plan, trace, Tkprof.
• Good knowledge of Oracle performance related features like hints, indexes, partitioning and cost base optimizer.
• Good Experience in developing and maintaining Batch Process code for processing large volume of business data.
• Good Experience in Data Analysis and Data Conversion- converting data from legacy systems to Oracle Database.
• Experience in developing reports using Oracle Reports 6i, 10g and MS SSRS.
• Experience is developing ER Diagrams using Visual Paradigm and ERwin.
• Experience in UNIX environment and developing shell scripts.
• Knowledge of Core Java, J2EE, JSP, HTML, XML.
• Experience in Version Control Tools like MS Visual Source Safe, Subversion, CVS and RCS.
• Experience working with US State government. Also worked in Banking and Financial, Networking domain.
• Team Player, quick learner, highly motivated and result oriented.

TECHNICAL SKILLS

Database: Oracle 11g/10g/ 9i/ 8i, MySQL

Languages: SQL, PL/SQL, JAVA, UNIX Shell, Visual Basic, C++

ERP: Oracle Applications 11i/R12 Financials (AP, AR, FA, CE, PO, GL)

Web Technologies: J2EE, JSP, HTML, XML, Flash

Operating Systems: MS Windows NT/XP/Vista/7, Linux, UNIX, Mac OS X

Tools: TOAD, SQL*Plus, SQL Developer, SQL*Loader, putty, Oracle Reports 6i/10gVisual Paradigm for UML 9.0, Erwin, MS SSRS, MS Visual SourceSafe 6.0, Subversion, CVS, PVCS, RCS, Kintana, Eclipse, MS Office, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Oracle PL/SQL Developer

Responsibilities:

• Worked with end client to understand the Business requirement details.
• Did technical analysis to decide the approach to implement these requirements using Oracle database as backend.
• Created new database objects such as Tables with partitions, Views, Indexes, Grants and Synonyms as per the requirement.
• Developed and modified Data Migration code which is a PL/SQL Package that extracts data from source tables and after doing data transformation as per business logic loads into target tables.
• Did performance tuning of existing migration code to finish migration task in much less time. Used bulk collections, Hints and indexes to improve the performance.
• Developed and modified daily and monthly batch jobs using Unix shell scripts which clear current month data and reload current month data from other legacy systems.
• Developed validation scripts in SQL to verify if the Data Migration code has correctly migrated data from source to target. Also developed validation scripts for daily and monthly batch jobs.
• Developed shell scripts which call these validation scripts and present the validation output.
• Created and updated Cron jobs to run these batch jobs daily and once in a month.
• Modified existing Reconciliation batch job which reconciles net revenue and net resale between source and target databases. Made changes to the reconciliation view as per new requirements.
• Created SQL script to check Reconciliation errors on daily basis.
• Used Oracle Hyperion Essbase OLAP server to view multi-dimensional database cubes. Used Essbase Excel Add-In to retrieve and view multi-dimensional data.
• Did Unit testing of PL/SQL code developed.
• Created Technical Design documents using MD070 format.

Environment: Oracle 11g, SQL, PL/SQL, TOAD, MS office, RCS, Oracle Hyperion Essbase 11.1.2, UNIX, Windows 7.

Confidential, San Jose, CA

Oracle PL/SQL Developer

Responsibilities:

• Worked with Business Analysts to understand the Business requirement details.
• Did technical analysis for deciding the approach to implement these requirements using Oracle database as backend.
• Designed and modified the Data Model to add new Tables and modify existing tables as per new business requirements in the Project.
• Created new database objects such as Tables, Views, Indexes, Sequences, Grants and Synonyms, DB Links as per the requirement.
• Did designing and development of new PL/SQL Code as well as enhanced the existing PL/SQL Code which involved creating new PL/SQL Packages, Functions, Data types and Objects.
• Worked on setting up new database schemas in Development environment.
• Created PL/SQL Cursors, Ref Cursors.
• Did Exception/Error Handling using Named and Un-named Exceptions and defined Exceptions.
• Performed Unit Testing of developed code.
• Did performance tuning of SQL queries and PL/SQL scripts with help of oracle tools like explain plan.
• Worked with Quality Analysts to identify the defects existing in already developed PL/SQL code and fixing the bugs to work as per business test cases.
• Created Kintana Packages and lines for Production Code Release.
• Offshore team Co-Ordination.
• Prepared Technical and Release documentation.

Environment: Oracle 11g, SQL, PL/SQL, TOAD, PVCS, Kintana, Windows 7, MS office.

Confidential, Cupertino, CA

Oracle PL/SQL Developer

Responsibilities:

• Worked with Database Architects to understand and analyze the requirement details.
• Did analysis for identifying new data groups as part of distributed database system.
• Redesigned the Data Model to create new databases as per new Data Distribution architecture for NextGen Project. Used Visual Paradigm for UML tool for developing the ER Diagram.
• Designed and implemented splitting of existing Database Objects such as Database Packages and compiling them in respective databases.
• The work involves development of new PL/SQL Code as well as enhancing the existing PL/SQL Code.
• Did analysis of existing database code and objects to identify obsolete database objects. Then worked on step by step approach to remove them from code and from database.
• Worked on resetting Sequences to new higher values.
• Worked on setting up new database schemas in various database environments.
• Created database objects such as Tables, Indexes. Also created and modified Views, Sequences.
• Created Grants, Synonyms, DB Links as per requirement.
• Created PL/SQL Cursors, Ref Cursors.
• Did Exception/Error Handling using Named and Un-named Exceptions and defined Exceptions.
• Developed Database deployment automation scripts. The shell script accepts location of file to be run and list of databases where to run the file. Then it will connect to all databases one by run and run the respective scripts there.
• Performed Unit Testing of developed code.
• Worked on code troubleshooting and bug fixing.
• Prepared Technical and Release documentation.

Environment: Oracle 11g, SQL, PL/SQL, Oracle SQL Developer, UNIX, Mac OS, Subversion, Visual Paradigm for UML, MS office.

Confidential, South San Francisco, CA

BI Developer

Responsibilities:

• Worked directly with business users to understand and analyze the exact Report requirement and to gather related data.
• Wrote complex SQL Queries to fetch the report related data from Oracle database.
• Designed and Developed new Reports as per specifications using MS Visual Studio.
• Developed reports with parameters to select individual customer data.
• Also developed Invoice reports for calculating billing info for clients.
• Deployed the reports on MS SSRS Server.
• Also modified existing reports to make required changes to them.
• Tuned the SQL queries using indexes, hints for enhancing performance.
• Prepared Technical and Functional documentation for the reports developed.

Environment: Oracle 11g, SQL, PL/SQL, TOAD for Oracle, Oracle SQL Developer, MS SQL Server 2008, MS Visual Studio 2008, MS SSRS, MS office.

Confidential, San Jose, CA

Oracle PL/SQL Developer

Responsibilities:

• Worked with Business Analysts to understand and analyze the requirement details.
• The work involves development of new PL/SQL Code as well as enhancing the existing PL/SQL Code.
• Worked on setting up new database schemas in Development and QA environments based on Production schemas.
• Created various new PL/SQL Procedures and Functions for Data Migration, Global Update, Data Sync Up. Created wrapper procedures to test functionalities from backend. Also enhanced and supported existing Procedures and Functions.
• Created PL/SQL Packages to group the related Procedures and Functions together as per the functionality.
• Developed various Triggers to maintain the track of database changes.
• Created database Tables. Also created partitioned and sub-partitioned tables using range, list and hash partition types for big transaction tables. Created Global Temporary Tables.
• Created normal Indexes as well as partitioned Indexes.
• Also created and modified Views, Sequences. Created Grants, Synonyms, DB Links as per requirement.
• Created Records and Collections.
• Created PL/SQL Cursors, Ref Cursors.
• Used Bulk Collect and Bulk Update features to process large amount of data.
• Did Exception/Error Handling using Named and Un-named Exceptions and defined Exceptions.
• Tuned the SQL queries using ‘parallel’ hint and additional indexes.
• Created and modified Unix Cron Jobs.
• Performed Unit Testing of developed code.
• Worked on troubleshooting and bug fixing.
• Prepared Technical and Release documentation.

Environment: Oracle 11g/10g, SQL, PL/SQL, TOAD for Oracle, UNIX, MS office.

Confidential, Salem, Oregon

Oracle PL/SQL Developer

Responsibilities:

• Worked with the Project Manager and Business Analysts to understand the business requirements and develop the code accordingly for batch processes and PL/SQL Packages.
• Developed PL/SQL Batch code to process large volume of data which is loaded from Mainframe to Oracle daily. The batch process consists of several PL/SQL Functions and Stored Procedures which retrieve the data, process it to apply the business rules and load the target tables with the results of the process.
• Developed custom reports in different formats which helped business users to analyze the batch process output.
• Developed 'GET and SET' Stored Procedures. 'GET' procedures retrieve specific data from multiple tables and 'SET' procedures insert/update data based on several conditions.
• These Stored Procedures use cursors to process record sets. Used Ref Cursors to pass result sets to “Cold Fusion” front end.
• Developed numerous PL/SQL Functions to check for specific business rules.
• Created PL/SQL Packages to group related PL/SQL Procedures and Functions together which are developed for specific business module.
• Helped Front-end GUI developers to write complex SQL queries and tune them for performance.
• Using Explain Plan optimized the SQL queries and PL/SQL scripts to improve performance.
• Worked with Oracle DBAs to create normal and function based indexes on tables which improved the database performance. This helped to reduce the processing time from 19hrs to less than 15 minutes for “Identify Issue" PL/SQL batch job.
• Performed unit testing and load testing of the batch process code and PL/SQL package code. Done performance benchmarking with various size data loads.
• Did code reviews for the code developed by other developers.
• Prepared technical and release documentation with program flow charts.

Environment: Oracle 11g/10g, SQL, PL/SQL, TOAD, MS Visio, MS Word, MS Excel.

Confidential, CA

Oracle PL/SQL Developer

Responsibilities:

• Responsible for deployment and configuration of EDMS tool. Done EDMS configuration setup for various ERP modules.
• Prepared complex SQL scripts for data selection/extraction as per different criteria like periods, module, etc.
• Developed PL/SQL Procedures, Functions and Packages using cursors. Used Bulk Collect feature to fetch large data.
• Developed Views, Triggers as per the project requirement.
• Did performance tuning of SQL queries and PL/SQL scripts with help of oracle tools like explain plan.
• Worked with DBA to create indexes, run gather stats on tables for improving query performance.
• Created UNIX Shell scripts for batch jobs. Used Cron job utility to schedule tasks.
• Done performance tuning of “Business Reports running on archived data”.
• Used oracle tracing to catch the poor performing queries.
• Prepared technical documentation.

Environment: Oracle Apps R12, Oracle 10g, 10gAS, SQL, PL/SQL, SQL Developer, UNIX.

Confidential, PA

Oracle PL/SQL Developer

Responsibilities:

• Worked as Oracle Developer performing data analysis and data conversion. Developed custom reports.
• Gathered the requirements from the business users, analyzed and translated into detailed technical specifications.
• Written complex SQL queries and developed PL/SQL Stored Procedures, Functions, Packages, Triggers, Materialized Views.
• Tuned the SQL queries to improve performance.
• Responsible for enhancement of standard and custom reports using Oracle Report Builder.
• Created UNIX Shell scripts for scheduling periodic load processes.
• Created control files for data loading. Used SQL loader tool to load the data.
• Did unit testing of customizations.
• Responsible for the technical and user documentation of the customizations.

Environment: Oracle Apps 11i - Financials, Oracle 10g, SQL, PL/SQL, SQL* Loader, Oracle Reports 10g, TOAD, Windows XP, UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked as Oracle Developer for developing PL/SQL code for Oracle Interfaces and Reports.
• Worked with Functional Team for gathering the business requirements. The development and customization was done according to these requirements.
• Written effective SQL queries for extracting data as per business requirements.
• Developed various custom reports in different formats using Oracle Reports Builder which helped Business Users in analyzing the data.
• Developed PL/SQL code as per the project requirement including Functions, Stored Procedures, Packages, Cursors, Triggers, and Views.
• Performed Data Analysis on legacy system data before loading into Oracle database.
• Developed and maintained SQL loader scripts for loading data from legacy systems to Oracle database.
• Was responsible for creating and modifying the PL/SQL stored procedures, functions and packages which loads data from temp tables to interface tables and do data validations.
• Created indexes to improve performance of SQL and PL/SQL scripts.
• Used Oracle trace and explain plan utilities to catch the poor performing queries and analyze their execution plans.
• Created UNIX Shell Scripts for running the data loading jobs and file handling. Scheduled these jobs using UNIX CRON utility.
• Performed unit testing on developed code.
• Responsible for preparing technical and user documentation of the customizations.

Environment: Oracle 9i, SQL, PL/SQL, Oracle Apps 11i - Financial, Oracle Reports 6i, SQL* Loader, TOAD, Windows XP, UNIX, MS VSS.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked as Oracle Developer for development and enhancement of Reports and Interfaces.
• Developed complex SQL and PL/SQL code as per the customization requirements. Developed stored procedures, packages, cursors, triggers, views.
• Interacted with business users for gathering the functional requirements for enhancements.
• Worked for enhancing the code of various Open Interfaces implemented such as ‘Item Upload Open Interface’ and ‘Customer Item Open Interface’ in Inventory, ‘Vendor Invoice Open Interface’, etc.
• Created and modified SQL Loader scripts to load data from legacy systems to Oracle database.
• Developed and enhanced complex SQL queries for many standard and custom Forms and Reports.
• Created materialized views which store the summary results of complex queries running on high volume tables and helps to run the SQL reports faster and also reduce load on database.
• Written UNIX Shell scripts for running Interfaces programs.
• Responsible for developing test cases for reports and interface customizations.

Environment: Oracle 8i, SQL, PL/SQL, Oracle Apps 11i, SQL* Loader, TOAD, Windows XP, UNIX

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in system requirement analysis, designing and development of the entire unit
• Created functions for device control operations such as starting the device, accepting and validating the notes, reading note’s denomination, activating note dispenser, etc.
• Developed front end code in Visual Basic 6.0 which is a user interactive code that implements ActiveX Controls to interact with the devices and provides options to customer and saving the transaction data in Oracle Database.
• Developed PL/SQL stored procedures and functions, database triggers.
• Created PL/SQL package for validating the entered currency with existing standard currencies in the database.
• Created database objects such as tables, views, synonyms, sequences and executed them using SQL* Plus.
• Used VSS for software configuration management.
• Created indexes to improve system performance.

Environment: Oracle 8i, SQL, PL/SQL, Visual Basic 6.0