Expertise Summary:

• Developed various Oracle Applications using PL/SQL, SQL Plus, Reports, Workflow Builder, and Application Object Library.
• Over 8 yrs of professional experience as an Oracle/PL/SQL Developer in Analysis, Design, Development and Customization of Business Applications using Oracle Relational Database Management Systems.
• Strong working knowledge in various versions of Oracle database 11g/10g/9i/8i
• Migrated various applications from Oracle10g to 11g
• Expert in various components of SQL and PLSQL including Procedures, Packages, Functions, Cursors, Triggers, Views, Sub-queries, Joins
• Developed various data migration scripts using Oracle SQL LOADER and UTL packages.
• Can efficiently handle data using PL/SQL, SQL plus, TOAD and SQL Loader.

• Very strong in Oracle, Perl, Unix shell script KSH programming.
• Strong command over web standards, cross-browser compatibility and various web-related optimization techniques and content management systems using CSS, CGI/DBI DBD programming in Perl using HTML.
• Experienced in providing application and user support.
• Strong Knowledge of SQL and PL/SQL object types, materialized views, bulk collects and collections.
• Experience in SQL query optimization and PL/SQL stored procedures, performance tuning in Oracle.
• Experience in handling very large data files using Export-Import Utilities, UNIX Shell scripts and SQL Loader.
• Expertise in performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF and Hints.
• Sound knowledge on scheduling jobs with Control-M.
• Sound knowledge of Data modeling concepts like ER Diagrams, Normalization and De-normalization of tables.
• Ability to adapt to new software applications and products, self-starter, with excellent communication skills and understanding of business workflow.
• Strong communication, analytical problem solving, and design skills.
• Highly organized and dedicated with positive attitude.

Professional Experience:

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Developed various Oracle PL/SQL blocks Stored Procedures, Functions Packages for implementing complex business logic.
• Wrote complex SQL Queries using joins, sub queries and correlated sub queries as per the business requirement.
• Created procedures and packages to transfer and process data as XML formatted files.
• Wrote SQL queries and Oracle PL/SQL stored procedures for displaying and inserting.
• Developed Unix shell scripts with embedded SQL Loader calls and PL/SQL statements to extract data from the existing application in the form of flat files and load the extracted data into the new proposed application.
• Validated and loaded data into Oracle Database using DB links and external tables from CSV files.
• Used various Optimizer Hints to speed up the SQL queries.
• Worked on performance tuning of Oracle SQL, PL/SQL and analyzed Tables.
• Used various Optimizer Hints to speed up the SQL queries.
• Worked on performance tuning of Oracle SQL, PL/SQL and analyzed Tables.
• Involved in Oracle database Design, Creation of Tables, Stored procedures to access using the callable statement.
• Developed PL/SQL packages and procedures for the back end processing of the proposed data base design.
• Done extensive performance tuning by developing Explain Plans, and embedding various Indexes and Optimizer Hints, BULK LOAD, BULK COLLECT to speed up the SQL queries.
• Customized Forms to meet the business requirements using Forms 10g.
• Worked on bug fixing and supported the production applications.

Environment: PL/SQL, SQL Loader, SQL Plus, TOAD, SVN , Unix, Putty, SQL Loader

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed packages using Oracle PL/SQL for automate transactions in tables
• Involved in Software Development Life Cycle SDLC
• Developed back-end PL/SQL packages, building UNIX shell scripts for data migration batch processing.
• Provided on-call production support for several applications
• Responsible for participating in out-of-hours support duties
• Created Unix shell scripts for automating the execution process
• Developed cross-browser CSS/HTML design and behaviors
• Developed Oracle PL/SQL triggers to work with work flow design
• Worked in data handling using Unix shell scripts using KSH
• Designed and developed Oracle PL/SQL scripts for Data Import/Export
• Developed PL/SQL routines to extract data from external files and to load it into the Oracle database
• Applied necessary grants database privileges, validate all business areas workbooks, performance tuning, granting scripts.
• Wrote a shell script for scheduling jobs using Control-M.
• Performed performance tuning of the overall system by eliminating redundant joins, creating indexes, removing redundant code
• Involved in coding of stored procedures, triggers and SQL queries in Oracle.
• Created Perl scripts to check header/footer format on feeds.
• Designed and developed various OUTBOUND interfaces by generating files using UTL FILE utility and transmitting over secure channels using SFTP.
• Coded and tuned Oracle PL/SQL and SQL throughout the development
• Developed and tested Unix shell scripts

Environment: Oracle 11g,PL/SQL, SVN, CGI, DBI/DBD, HTML, SQL,SQL Loader, SQL Plus, KSH, Cron Tab, Unix

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Developed various Oracle PL/SQL blocks Stored Procedures, Functions Packages for implementing complex business logic.
• Wrote complex SQL Queries using joins, sub queries and correlated sub queries as per the business requirement.
• Created procedures and packages to transfer and process data as XML formatted files.
• Wrote SQL queries and Oracle PL/SQL stored procedures for displaying and inserting.
• Developed Unix shell scripts with embedded SQL Loader calls and PL/SQL statements to extract data from the existing application in the form of flat files and load the extracted data into the new proposed application, as a part of migration.
• Involved in Oracle database Design, Creation of Tables, Stored procedures to access using the callable statement.
• Developed PL/SQL packages and procedures for the back end processing of the proposed data base design.
• Done extensive performance tuning by developing Explain Plans, and embedding various Indexes and Optimizer Hints to speed up the SQL queries.
• Created roll back mechanism using Perl programs for feed processing.
• Worked in log/error file scanning and reporting using Perl.
• Wrote HTML/CGI programs in Perl to handle the inputs from the configuration screens.
• Writing the test Plans, test cases and test scripts using Unix shell scripts.
• Worked on bug fixing and supported the production applications.

Environment: Oracle 10g/11g, Perl, SQL Loader, SQL Plus, TOAD, CGI, HTML, PL/SQL, KSH, Cron Tab, Unix

Confidential

Sr. Oracle PL/SQLDeveloper

Responsibilities:

• Performed query analysis and enhanced Query performance by taking advantage of Oracle indexing features and table partitioning features.
• Fine tuned database procedures and Oracle PL/SQL scripts for performance tuning
• Developed shell and Perl scripts to automate and streamline day to day maintenance functions as required.
• Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.
• Created scripts in Oracle to load the data to create Tab Separated files.
• Created Unix shell scripts for ad-hoc requests.
• Worked in CGI/Perl programming and DBI/DBD to connect to Oracle and fetch data for presentation.
• Developed generic Oracle functions for business computations.
• Developed numerous scripts to test different functional aspects of Business Process flow.
• Developed SQL Loader scripts to load flat files into Oracle database.
• Monitored the performance tuning in Oracle PL/SQL application.
• Used Oracle DBMS packages to carry out dynamic SQL processing.
• Created Unix Shell Scripts for sequential execution of Perl scripts including file archiving, transformation and backup.
• Participated in production support tasks as of when required. Resolved many priority High issues to sustain the business operations.
• Created flat files with SQL Plus from Oracle tables.
• Wrote many wrapper scripts and supported the system.
• Supported of development, test, and production environments.

Environment: Oracle 10g, SQL, PLSQL, KSH, PERL, SQL Loader, SQL Plus

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed database triggers and stored procedures using Oracle PL/SQL cursors and tables.
• Monitored the Oracle SQL query performance using explain plans.
• Worked with Unix commands to check and match the output manually.
• Used Oracle PL/SQL to filter and load data from other production databases.
• Supported front-end search and lookup screens using CGI/HTML.
• Worked on performance tuning and monitoring of Oracle database.
• Worked in scheduling the Perl scripts for end of the day run.
• Wrote complex Oracle SQL queries to retrieve unique datasets using inner and outer joins.
• Created PL/SQL functions to facilitate business functions and calculations.
• Provided high-level support for all Unix issues.
• Developed Oracle PL/SQL procedures, packages, triggers, functions.
• Wrote SQL scripts to create tables and views.
• Created many SQL batches for data handling using Perl/KSH.
• Worked with Unix client server application group debugging problems.
• Wrote SQL scripts to extract the BLOB data from Oracle RDBMS database.
• Created UNIX Shell scripts for automating the execution process.
• Managed development and support of consumer and small business

Environment: Oracle 9i/10g, PL/SQL, Perl, CGI, HTML, SQL, SQL Loader, SQL Plus, KSH, Cron Tab, Unix