SUMMARY

• Over 6+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
• Expert in various components of SQL and PLSQL including Procedures, Packages, Functions, Cursors, Triggers, Views, Sub - queries, Joins
• Developed various Oracle Applications using PL/SQL, SQL*Plus, Reports, Workflow Builder, and Application Object Library.
• 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.
• 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.

TECHNICAL SKILLS

Languages and web technologies: SQL,PL/SQL, KSH, Perl, HTML, CGI,XML

Operating System: Linux, Windows, Hp UNIX

RDBMS and servers: Oracle 11g/10g/9i, SQL*PLUS, SQL*Loader, Oracle Enterprise Manager

Tools: TOAD, PLSQL Developer, TKPROF, Erwin

Version Control: SVN

PROFESSIONAL EXPERIENCE

Confidential, AZ

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in Software Development Life Cycle (SDLC)
• Developed packages using Oracle PL/SQL for automate transactions in tables
• 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.
• 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, NYC, NY

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.
• 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, MN

Sr. Oracle PL/SQL Developer

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, NY

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

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created and managed many objects in large Oracle Databases containing millions of records.
• Created PL/SQL functions to facilitate business functions and calculations.
• Provided high-level support for all Unix issues.
• Worked in CGI/Perl programming and DBI/DBD to connect to Oracle and fetch data for presentation.
• Improved the performance using Global Temporary Tables, Ref Cursors, Dynamic SQL such as EXECUTE IMMEDIATE for data load and updates.
• Developed logical and physical data models for central model consolidation.
• Created database scheduler scripts and applications using Unix shell scripts, SQL *Plus script
• Created job sequences and schedules for automation.
• Developed Oracle PL/SQL procedures, packages, triggers, functions.
• Involved in data migration from CSV format into the respective Oracle Database tables using TOAD
• Wrote SQL scripts to create tables and views.
• Used Erwin to transform data requirements into data models.

Environment: Oracle, KSH, CGI, DBI/DBD, Perl, HTML, SQL, PL/SQL, Cron Tab, SQL*Loader, SQL*Plus, Unix

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Assisted in database designing by creating database objects such as Tables, Views, and Indexes.
• Worked with Sub-queries/Correlated Sub-Queries in Different areas of the database.
• Received data from source (Soft Dollar, Market data & Communications) and imported the data to the interface table using SQL * Loader.
• Developed validation programs to validate the data before importing into oracle tables.
• Worked on UNIX Shell Scripting for Scheduling Batch Jobs.
• Developed PL/SQL Packages and Database Triggers.
• Customized Reports using Reports according to client requirements.
• Developed Revenue reports like Monthly and weekly Revenue, Total Revenue and Monthly Transaction and Revenue Comparison Reports.

Environment: Oracle 8i/9i, SQL, PL/SQL, SQL*Loader, TOAD, UNIX.