SUMMARY:

• Around 7+ years of IT experience in developing software applications using Oracle 11g/10g/9i and its products in wide range of applications including Manufacturing, Banking and Telecommunication applications.
• Solid experience working on Oracle 10g/9i/8i/8.0/7.x, Developer 2000/6i (Oracle Forms 6i and Reports 6i), PL/SQL, UNIX and Discoverer.
• Expertise in all aspects of SDLC requirement analysis, technical specifications, Logical and physical design, development, testing, documentation, implementation and maintenance in multi - tier and client/server architectures.
• Worked on the physical transformation of the data model which involved creating the database objects like Tables, Indexes, Stored Procedures, Functions, DB Links, Packages and Triggers.
• Designed database schema's using Entity relationship modeling with ER diagrams & database normalization principles.
• Experienced in SQL Loader, Export and Import and enforcing security by creating roles, granting system and object privileges on the Tables and Stored procedures.
• Developed Data Mapping and Data Conversion scripts using SQL and PL/SQL.
• Knowledge on Oracle Forms, Reports and Menus.
• Solid experience in writing and debugging stable and robust PL/SQL code, handling various kinds of Exceptions, SQL, Dynamic SQL, C, and UNIX scripts.
• Supported advance PL/SQL using Cursors, REF Cursors, and Dynamic SQL.
• Developed complex PLSQL Triggers for data integrity and enforcing business rules.
• Experienced with SQL performance tuning and optimization using execution plans.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading in a corporate-wide-ETL Solution using Oracle.
• Experienced in OLTP and OLAP System Study, Analysis and E-R modeling.
• Improved performance of PL/SQL program units by using Bulk Collect and Bulk Bind features with Collections instead of using cursors and FOR loops.
• Excellent analytical, verbal & written communication, interpersonal, team work skills and assertive leadership abilities with a high degree of professionalism and dedication to exceptional quality.
• Ability, willingness, and passion to learn new technologies and acclimatize to diverse work cultures.
• Solid managerial and administrative skills with good business understanding and excellent versatility and adaptability to manage multiple tasks.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i, MS SQL Server 2000, DB2, MS ACCESS 2007

Languages: SQL, PL/SQL, C, C++, Java 1.4/1.5

Tools: TOAD, SQL Developer 3.0, Oracle Enterprise Manager 10g, SQL*Plus, SQL*Loader, Oracle Forms and Reports 10g/9i/6i, Pro*C, Oracle Framework, MS Office 2007, Open Office 3.3

Internet Technology: HTML 5.0, JavaScript, XML, PHP 5.0, CSS 3, DHTML.

Scripting: Unix Shell Scripting, Java Script

Operating Systems: HP-UX 11.0,UNIX, Windows 95/98/2000/NT/XP/Vista and AIX

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Oracle Developer

Responsibilities:

• Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.
• Involved in Code Reviews and preparing Unit test cases.
• Maintained the data integrity and security using Integrity Constraints and Triggers.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Defining and reviewing the coding standards besides reviewing the code.
• Developed various custom reports using Oracle Reports Builder. The reports range from Monthly income analysis, Balance analysis, Customer Transaction Summary/Audit, Customer Transaction aging, etc.,
• Created extensions to existing forms using Forms Builder as per client business requirement.
• Prepared Check lists; identified Test Cases and created Test Plans.
• Actively Involved in Integration and Deployment in Production Environment.
• Highly involved in high level database design, defining table structures, laying out ER-Diagrams, helped in building the physical data model using Erwin and identified key features for scalability of the application.
• Complex PL/SQL procedures and functions and packages are developed to adhere to the specifications of the application.
• Involved in the analysis of the existing database for improved performance.
• Separated Tables and Indexes on different locations for reducing Disk I/O Contention.
• Extensively used EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE and HINTS for tuning various SQL and PLSQL objects.
• Used Bulk Binds and Bulk Collect.
• Implemented External tables and created Sequences to generate numbers on the fly.
• Co-ordination between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases.
• Attended business user sessions to make changes in warehouse loads.
• Extensively developed code extract procedures for daily upload to Customers data warehouse.
• Extensively worked on version control software for migrating codes to different application instances.

Environment: Oracle Database 11g, TOAD, UNIX, VSS, WINSCP3, SQL, PL/SQL, SQL*Loader, PUTTY, MS Office, Windows XP, Oracle Reports 10g, Oracle Forms 10g, Erwin.

Confidential, Warren, NJ

Sr. Oracle PL/SQL Developer

Responsibilities:

• Designed and Authored Technical Specifications from Functional Specification (Detail Design) documents.
• Used SQL*Loader to load data from various sources into an Oracle database. Created automated scripts for handling multiple files and emailing the status of individual data loads.
• Created various PLSQL blocks to validate data using functions and procedures, and used dynamic SQL to identify client specific requirements and loading into Oracle core tables form staging.
• Wrote PLSQL programs required for retrieving data from the Data repository using Cursors, UTL File I/O. Extensively used Exception handling for error handling.
• Wrote various PL/SQL Packages, Functions and Procedures to implement the Business Logic for the specified client application.
• Created various database triggers for implementing data security across multiple financial sensitive tables.
• Verified coded logic by testing and correcting programs via unit tests.
• Involved in Integration test, System test and Implementation.
• Involved in developing materialized views, views, synonyms and dblinks to access data across schemas, indexes to gain performance.
• Proficiently developed test cases in Quality Center.
• Created Informatica Mappings with PL/SQL procedures to build business rules to load data using transformations like Source Qualifier, Aggregator, Sorter, Expression, Joiner, Connected and Unconnected lookups, Filters, Sequence, Router and Update strategy.
• Used debugger to test the mapping and fixed the bugs.
• Applied Performance Tuning logic to optimize session performance.
• Examined, reviewed, and/or changed code to adapt to changes in requirements.
• Developed shell scripts for batch processing and database transactions.
• Tuning SQL Statements, PL/SQL Packages, Triggers, Functions and Procedures.
• Application Testing and Documentation in the upgrade of Oracle 9i to 10g.
• Involved in Database performance tuning using Explain plan.

Environment: Oracle 9i/10g, PL/SQL Developer, UNIX, PUTTY, Quality Center, CVS Version Control, Microsoft Visual Studio, ERWin Data Modeler r7, Informatica Power Center 7.1.2, Windows XP, AIX.

Confidential, Newark, DE

Oracle Developer

Responsibilities:

• Involved in Requirement Analysis and developing the Project Definition Document.
• Extensively involved in preparing Technical Documents from the functional specifications. Authored BRDs as of when required for the new enhancements.
• Created, debugged and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions as per the business requirements.
• Responsible for developing XML documents to generate SQL dynamically for all the business roles.
• Used XDB UTILITY packages to load XML documents into database tables.
• Worked with CLOB and LOB data types to load large XML documents into database tables.
• Responsible for developing PL/SQL database objects like Functions, Procedures and Packages.
• Developed a PL/SQL conversion program and SQL*Loader program for validating and migrating the legacy agents information into Oracle base tables.
• Involved in Performance Tuning of various custom PL/SQL reports and PL/SQL packages.
• Involved in migrating the application from Oracle Database 9i to Oracle Database 10g.
• Extensively wrote PL/SQL code to customize various forms pertaining to Contracts and data load.
• Used Dynamic SQL and autonomous transactions for error handling.
• Worked on Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Created Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Error Handling.
• Developed Unix shell scripts for job scheduling.
• Used UTL FILE (file handler), DBMS JOB, DBMS ALERT and other utility built-in Packages in PL/SQL.
• Run batch jobs for loading staging tables from flat files using SQL*Loader.
• Involved in unit testing the application code and database code for data integrity and application functionality.
• Conducted meeting with System Analyst to explain the application functionality.
• Debugged Packages, Procedures, and Functions and fixed them according to the business requirement.
• Tuned the existing SQL queries to improve the performance.
• Involved in the Data Modeling phase of the application.
• Used ETL tools like SQL Loader to load the flat file data into database tables.
• Also written UNIX shell scripts to automate the nightly data load from third party servers.
• Extensively involved with end users to make the enhancements.

Environment: Oracle Database 10g, SQL, PL/SQL, Oracle Reports 6i, Oracle Forms 6i, TOAD, UNIX, XML, FTP, SQL*Loader, Discoverer 4, Erwin 4.0, LINUX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Created numerous web based Forms and Reports using Oracle Developer 6i.
• Defined Editors, created List of Values and Record Groups in Oracle Forms 9i.
• Designed, developed and tested Reports using Report 6i and Discoverer 4i.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts.
• Developed Forms, Packages, Triggers and Shell Scripts to load the staging table data into Analysis Data Mart System.
• Involved in gathering requirements from users to develop the application from the scratch.
• Involved in working with analysts for gather more information on data flow designs that required for the project to develop.
• Developed Stored Procedures to maintain details of the vendors and maintained them in Packages.
• Designed database tables using various Normalization techniques and database rules.
• Developed reports as per the requirements collected from the users using Discoverer and Oracle Reports 10g.
• Good Experience working on TOAD, PL/SQL Development for database access.
• Generate and maintain Keys, Constraints and Relationships between the tables for OLTP & OLAP instances.
• Developed complex SQL queries to perform the back end testing of the Oracle database using SQL and UNIX shell commands.
• Created Shell Scripts for automating the execution process.
• Involved in migrating applications to the new release versions.
• Performed Data validations and mappings at staging table level.
• Created Complex Dynamic / Static / Parameterized Reports and Charts using Report 6i.
• Assessed the efficiency of the SQL statements using SQL Trace and TKPROF

Environment: Oracle 8i/10g, SQL, PL/SQL, Developer 2000 (Forms 6i, Reports 6i), HP UNIX, Secure Shell, TOAD, XML, HTML 4, Windows XP, SQL*Loader, Discoverer 4i, SQL*Plus

Confidential

PL/SQL Developer

Responsibilities:

• Built complex queries usingSQLand wrote stored procedures usingPL/SQL.
• CreatedPL/SQLprocedures and functions to migrate data between Oracle Database.
• Use Toad to runSQLandPL/SQLcode to manipulate the database in all environments.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Worked in Production Support Environment as well as QA /TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Involved in Logical & Physical Database Layout Design.
• Performance tuning of Oracle Databases and User applications.
• Provided user and production support.
• Involved in designing E-R model using MS-Visio.
• Improved the performance of the application by rewriting theSQLqueries.
• Designed data modeling using MS-Visio, used at the time of designing of database.
• Coordinate with DBA about the database related issues & tasks.

Environment: Oracle Database 9i, SQL, PLSQL, HP Quality Center, SQL*Developer,SQL*Loader, TOAD, MS-Visio, Windows XP, SUN Solaris