SUMMARY

• Dynamic, Result-oriented professional with over 7 years of IT experience in Oracle Database as a proven success record in working as Oracle PL/SQL developer/Software Developer.
• Expertise in working with Oracle Versions such as Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.
• Expertise in working complete System Development Life Cycle SDLC such as analysis, design, development, testing, implementation and support with exposure in database.
• Extensive knowledge of Relational Database Management System RDBMS Concepts.
• Deep knowledge of Oracle Architecture and it's content.
• Expertise in using Oracle SQL Developer GUI Graphical User Interface tool for database development, browse database objects, implement and edit SQL as well PL/SQL statements.
• Strong knowledge of Database Architecture, Database Development and Data Modeling Physical and Logical .
• Extensive work experience in writing and implementing database objects like Tables, Views, Indexes, Sequences, Synonyms, Stored Procedures, Functions, Exceptions, Triggers and Packages.
• Modified existing complex queries into easily understandable by using Sub-query and Loop structures.
• Efficient in Creating and Using Cursors and Ref Cursors in processing of data.
• Created Materialized Views and DBlinks.
• Experience with Oracle LOB Data type CLOB, BLOB, BFILE, NLOB .
• Implemented Oracle skills like SQL PLUS, TOAD.
• Implemented Oracle tools SQL Loader, export/import and data pump utilities like expdp/impdp to load data from another database and text file to oracle database.
• Experience in Query optimization/Performance tuning like Performance Planning, Instance Tuning.
• Used Collections and Bulk Techniques to improve performance.
• Experience in creating different kinds of Partitions on large tables and creating indexes in order to improve performance.
• Experience in SQL tuning using tools like Explain Plan command, SQL Trace facility, TKPROF facility, V performance views, Autotrace Report.
• Effectively worked on several Oracle provided packages like DBMS ALERT, DBMS OUTPUT, DBMS CONNECTION POOL, DBMS JOBS, DBMS PROFILER and UTL FILE.
• Hand on experience with Oracle Forms, Oracle Reports and BIRT Reports.
• Customized new Oracle Forms based on requirements nearly 20 and maintained Oracle Forms nearly around 100.
• Experience working with API Application Programming Interfaces such as JDBC Java Database Connectivity used to connect and access data that stored on the server.
• Extensively used ETL methodologies for Data Extraction, Transformation and Loading processes.
• Knowledge of Data staging which simplifies Data warehousing process. It supports in extracting source data, decoding, transforming, integrating, loading, cleaning of target databases.
• Have extensive knowledge of Oracle Warehouse Builder OWB ETL tool.
• Good knowledge of STAR Schema, Snow Flake Schema, FACT Tables and Dimensional Tables.
• Knowledge of Oracle E-Business Suit Modules.
• Having working experience with 3-tier architecture.
• Knowledge of Cognos Reporting Tool for design and development of reports in report studio. Also knowledge of different kinds of reports like planning reports, executive reports and pre-generated reports.
• Worked on Data modeling tools like CA Erwin, TOAD and Oracle SQL Developer.
• Expertise in using PL/SQL Wrappers to protect the PL/SQL Procedures and Packages.
• Expertise in conforming SQL and PL/SQL coding standards as per business rules.
• Experienced to translate reporting and analytical needs into technical solutions.
• Expertise in documentation of changes and to follow up any pending work.

TECHNICAL SKILLS

• Database :Oracle 11g, 10g, 9i, 8i,6i SQL Server 2000/2005
• Operating System :Windows NT, Windows 95/98/2000, Windows XP
• Tools :TOAD, Putty, OWB/ETL, SQL Developer, Cognos 8 business
• intelligence 8.3/8.4
• Languages :SQL, PL/SQL, UNIX Shell Scripting, C, C , Perl Scripting
• DB Utilities :SQL Loader, Explain Plan, vi Editor, Data pump, Export /
• Import, Expdp / Impdp
• File Transfer :TCP, UDP, FTP, DNS, SMTP, DHCP
• Web Technologies :HTML, DHTML, XML, JavaScript, CSS
• Other Application :Macromedia Dreamweaver, MS Office, Adobe Acrobat, IBM Rational, IBM Lotus iNotes, HP Quality Center, Clear Case, Maxio Scheduler

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Developer

Detroit energy is one of the largest electricity and gas providers in almost around 27 states in United States. The project is mainly to focus on CSB core application Customer Service and Billing . There are different interfaces within DTE, City of Detroit and State in Michigan.

Responsibilities:

• Involved mainly in developing new functionality based on client requirements for monthly releases
• Working on Oracle Forms in 3 tier architecture which involves any updates to pro c files.
• Using cursor, ref cursor, user defined exceptions, Oracle in-build exceptions, etc in day o day development work.
• Working on code construction, unit testing, string testing and testing support for system and UAT testing.
• Using Explain Plan, TKPROF utilities for SQL query optimization.
• Development involves creation of procedures, functions, batch jobs, triggers, cursors, partition tables, online screens, reports, etc
• Using analytical and aggregate functions for development enhancements.
• Involved with clients and business for the requirements and provide any idea which provides efficient and accurate results.
• Involved in production support and production tickets which involves any research and code fix.
• Implemented table Partitioning and Sub-Partitioning to improve performance and data management.
• Used SQL Loader and Oracle Bulk techniques to load data from flat file to Oracle database tables.

Environments: Oracle 6i, Toad 9.7.2, SQL Developer, Unit Scripting, Maestro scheduler, Tuxedo, IBM Rational clear case, Pro C, Ultra edit, Virtual Desktop

Confidential

Oracle Confidential

Developer / Programmer Analyst

MiCSES Michigan Child Support Enforcement System

MiCSES is a child support project which provides supports to needy child s in Michigan and also share information with States, Federal government, IRS, SACWIS, BRDGES, UIA systems to provide accurate child supports.

Responsibilities:

• Construct database objects like Packages, Procedures, Functions, Batches, SQL Queries, Views, Indexes, and Exceptions using Toad.
• Also involved in creation modification of Triggers, JIL's TAPI's.
• Modified existing cursors also created brand new as per required.
• Created new and modified existing Oracle Forms .fmb as per business requirement.
• Converted Oracle Reports into BIRT Business Intelligence Reporting Tools open source report tool.
• Created new queries modified existing queries requested by different counties of Michigan as per needed.
• Modified Templates which coded in XML tags.
• Working on Construction Changes in Code , Unit testing and Test Result.
• Involved in string testing which is high level scenario based testing of the changes.
• Working with OVER PARTITION BY, BULK COLLCTS, ROWTYPE, ROWTYPE as per the data requirement as output.
• Created Indexes for faster retrieval and improved query performance.
• Takes responsibilities as Unit of Work Lead UoWL for small projects releases.
• Involved thoroughly in major, minor and emergency releases.

Enviornment: Oracle11g, Toad 9.6.1, Oracle Forms 10g/11g, Oracle Reports 10g/11g, JDK, JBOSS, SQL-Plus11.2.0, BIRT reports, TML, XML, Examine32

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created database objects like Tables, Indexes, Views, Materialized Views, Triggers, Procedures, Functions, Exceptions using SQL plus and TOAD.
• Involved in creating Sequences to generate consequence numbers and Constraints to limit the type of data .
• Used JDBC Java Database Connectivity connection in support of creating and executing queries.
• Created and managed users, roles and profiles, monitored databases and user access.
• Analyzed time consuming SQL and PL/SQL block queries and tuned them to run in less time by using cost based Optimizer hints, Explain plan.
• Worked with different types of Sub-queries and Loop structures which suit according to business logic.
• Written Cursors and Ref Cursors to fetch records.
• Created Indexes on the tables and on another Index for easy retrieval of the data to make the data searching speed faster.
• Planned Index Rebuilding, Index Analyze and Table Analyze on periodic basis.
• Involved in creating users and privilege Management using roles and grants.
• Used Pragma Exception INIT to name the system exceptions that are raised by the program.
• Handled errors using System defined exceptions and User defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Developed Row level and Statement level Triggers for auditing tables in PL/SQL.
• Written Shell scripts to automate loading the files into database using Crontab.
• Developed Views and Materialized Views for specific data retrieval for the reports.
• Made used Sub-query WITH clause to make complex SQL statements simple and make them more efficient.
• Used PL/SQL tables to avoid mutating problem in database triggers.
• Used Public Synonyms, read only User Accounts and Database Links for remote database access.
• Used Oracle supported DBMS STATS, DBMS JOB packages to gather the statistics and schedule job respectively. Also used DBMS METADATA.GET DDL package to describe table structure.
• Used TYPE and ROWTYPE for anchoring the variables to the database data types.
• Worked with Bulk Collects to improve the performance of multiple-row queries.
• Documentation of the completed work.

Environment: Oracle 11g/10g, UNIX Shell Scripting, Export/Import, SQL Developer, SQL PLUS, TOAD, Oracle Forms 10g, vi editor, JDK

Confidential

Oracle PL/SQL Developer

Description:

• The Industrial Development Bank of India Limited IDBI is one of largest
• leading public sector bank in India.It is currently 10th largest development bank in the
• world in terms of reach with 1392 ATMs, 833 branches including one overseas branch at DIFC, Dubai and 555 centers including two overseas centers at Singapore Beijing. It is a Nationalized bank.

Responsibilities:

• Designed module wise Oracle 8i/9i database structure and its implementation on the client server.
• Extensively used Explain Plan, TKPROF utilities for SQL query optimization.
• Used PL/SQL table to avoid mutating problem in database trigger.
• Using the Crontab in UNIX and Scheduler in windows for Automatic Tasks Analyzing tables, loading into Tables, Imp/Exp .
• Develop tables, views, stored procedures, triggers, indexes, rules, defaults, and user-defined data types.
• Worked on tuning the SQL queries and stored procedures.
• Used various forms of control structures including IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
• Used EXPORT/IMPORT to do table level and full database de-fragmentation.
• Developed packages, procedure and functions for complex Reports.
• Utilizing Built in Oracle Packages like UTL FILE, DBMS OUTPUT for better debugging.
• Worked on User-defined and System defined exceptions to handle different types of Errors like NO DATA FOUND, TOO MANY ROWS.
• Developed PL /SQL code for updating payment terms.
• Developed SQL loaderscripts to load data into the database tables.
• Created database links to retrieve data from multiple servers.
• Created public synonyms on the database links for easy reuse.
• Developed invoice-printing reports for single and consolidated invoices
• Modified existing codes PL/SQL packages to perform Certain Specialized functions and enhancements.

Environment: Oracle 8i/9i, SQL Loader, TOAD, SQL PLUS, UNIX, Oracle Forms 6i

Confidential

Description: Nielsen is a software development company, dominating over more than 100

Countries. Nielson employees work in the era's to measure market performance, analyze market dynamics, solve marketing sales problems and identify capture growth opportunities for the clients. It provides business solution for the companies.

Responsibilities:

• Analyzed the existing access system and re-designed it in Oracle 8i by developing data validation and load processes using PL/SQL Stored Procedures, Functions, and Triggers to enhance and improve functionality requested by business for reducing manual processing time.
• Optimized and modified the existing Triggers, complex Stored Procedures, and Functions.
• Implemented Cursors and performed Exception Handling.
• Used SQL Loader to load data from Excel text file into temporary table and developed PL/SQL program to load data from temporary tables into base tables.
• Wrote Oracle PL/SQL Stored Procedures, Functions, Triggers, and Packages and managed Oracle
• Used Dynamic SQL DBMS SQL, DBMS DDL in Functions and Procedures.
• Created database Triggers to record Insertion, Updating, Deletion and all other audit routines.
• Responsible for Code Reviews and PL/SQL Code Tuning.
• Extensive use of CRONTAB and Shell Scripting in UNIX environment for scheduling routine task.
• Creating Korn Shell Scripts which act as a wrapper for various tasks like - for executing the SQL Loader command lines, for refreshing the materialized views and for updating the Fact and the dimension tables with the data from the Staging Area Tables.

Environment: Oracle 8i, SQL PLUS, PL/SQL, HTML, TOAD, SQL Loader, UNIX