EXPERIENCE SUMMARY

Over 7 years of experience in software development life cycle and comprehensive understanding of software testing methodologies and tools. Strong experience in Oracle, Perl and UNIX shell Scripting. Strong Knowledge of SQL and PL/SQL object types, Oracle parallel queries, materialized views, bulk collects and collections. Well experience in Perl programming using JavaScript and HTML. Experience in Oracle SQL queries and PL/SQL scripts, procedures, functions, triggers and packages and query optimization. Good experience with creating UNIX shell scripts to automate validation process, saving of log files, and other tasks. Experience in developing Oracle PL/SQL Cursors, Exceptions, Stored Procedures, Views and Functions. Experience in operational 24x7 support, best practice trouble shooting, monitoring, capacity planning and maintenance. Excellent written, and verbal communication skills. Good understanding of project management disciplines

EDUCATION QUALIFICATION
Bachelor of Science in Computer Engineering Technology

Languages: Perl, KSH, JavaScript, CGI, DBI/DBD, HTML, SQL, PLSQL
Operating Systems: Windows, Sun Solaris, Linux
Databases: Oracle, Sybase, MS Access, MySQL, MS SQL Server
Web Servers: Apache, Netscape Enterprise Server, IIS
Tools: ERWin, CronTab, Autosys, SQL * Loader, SQL*Plus

Confidential, New York, NY
DURATION July ’10 - Till Date
PROJECT1 Trade Monitoring System
DESCRIPTION: Application feeds the trade data coming from various trading system and generates the customized reports and store them for reuse. Users could view the real-time price, historical price in form of data columns or graph. This System has trade data, historical data and intra-day data used in analysis.

DUTIES

• Worked on performance tuning of SQL, Oracle PL/SQL and analyzed Tables
• Developed Unix Korn Shell and Perl scripts to ad hoc user requests
• Used PL/SQL to process handle for automate extract data from Oracle SQL table
• Wrote Unix shell scripts to automate verification of database information via web application
• Involved in data load using PL/SQL and SQL*Loader
• Designed and developed Oracle PL/SQL scripts for Data Import/Export
• Designed, Managed and delivered a Data conversion utility for use with multiple applications
• Worked on development and maintenance of SQL code embedded in Oracle PL/SQL
• Developed PL/SQL Performance Tuning by implementing Table Partition and Creating appropriate indexes
• Used Oracle PL/SQL tables, ref cursors to process huge volumes of data
• Developed database triggers and stored procedures using Oracle PL/SQL cursors and tables
• Developed Unix shell scripts and set up Cron jobs for monitoring the database
• Created flat files with SQL*Plus from Oracle tables
• Modified in Perl scripts due to database changes using Perl DBI, SQL and Oracle PL/SQL
• Worked with users for data analysis and support
• Managed and supported the outages during urgency

TOOLS & TECHNOLOGY: ORACLE, UNIX,PERL, SQL, PL/SQL, DBI/DBD, HTML, JAVASCRIPT, CRON TAB, CGI, KSH

Confidential, New York, NY
DURATION Aug ’08 – Jun ‘10
PROJECT2 Investment Decision Tool
DESCRIPTION : It is a multi-tier, service-based, high-end rule-based, computing financial and decision supporting web based system for trading on securities. It does tracking, classifying, analyzing and suggesting trading activities on stock markets for their clients before and after trading.

DUTIES

• Gathered business requirements for applications, planning the scripting process and managing
• Developed Server side Oracle PL/SQL (Stored Procedures, Functions & Packages) for implementing complex business logic
• Wrote scripts in Unix shell and Perl to back ground processing
• Developed and maintained Perl CGI script files for content conversion
• Optimized performance tuning on a Oracle PL/SQL web application database
• Used Oracle PL/SQL tables, ref cursors to process heaps of data
• Created indexes, materialized views and partitioning of tables for SQL Tuning
• Developed and maintained Unix shell scripts for data extraction and manipulation
• Created Oracle PL/SQL procedures and packages to transfer and process data
• Involved in Performance Tuning of SQL statements
• Developed database triggers and stored procedures using Oracle PL/SQL cursors and tables
• Wrote source code in SQL*Plus and PL/SQL to handle multiple tables
• Used SQL*Loader to load data from a file into Oracle tables
• Coded and tuned Oracle PL/SQL and SQL throughout the development wherever needed
• Designed and script automated database jobs using Unix Korn shells
• Created Perl batches to monitor errors in data loading at particular frequency
• Used advanced Oracle PL/SQL techniques like cursors for data retrieval
• Created and generated numerous reports (daily, weekly and monthly), for various levels of support and auditing
• Provided on-call after hours application support for 24 x 7 helpdesk

TOOLS & TECHNOLOGY: ORACLE, UNIX, PERL, CGI, SQL, PL/SQL, DBI/DBD, KSH, HTML, JAVASCRIPT, CRON TAB

Confidential, Blackwood, NJ
DURATION Aug ’06 – Jun ‘08
PROJECT3 Support Tickets Reporting System
DESCRIPTION: The Support Tickets System is a high visibility reporting system to the users, the accuracy and timing of the reports is more important to various clients for their enterprise support tickets. The other various feeds to the system are properly monitored and data is consolidated in order to provide accurate information to reporting systems.

DUTIES

• Programmed stored Oracle PL/SQL procedures for processing and analyzing raw data
• Coded Unix shell scripts to call SQL scripts and to manipulate the data
• Worked on performance tuning and monitoring of database
• Used Oracle PL/SQL to filter and load data from other production databases
• Designed and developed Perl CGI scripts for sending application based mails using SEND MAIL
• Created database triggers for data validations in Oracle
• Involved in Oracle PL/SQL debugging and support
• Developed Scripts to run Unix shell tabs to update the database in specific intervals
• Used Oracle PL/SQL dynamic procedures during package creation
• Coded and implemented PL/SQL packages to perform application security and job scheduling
• Automated SQL tasks through Perl DBI
• Used SQL*Loader loads data from external files into tables of an Oracle database
• Developed and tested Unix shell scripts (Korn & Perl) which automate, file manipulation, transfers and archives
• Wrote complex Oracle SQL queries to retrieve unique datasets using inner and outer joins
• Provided on-call production database support
• Responsible for performance tuning activities in Oracle
• Monitored daily activities of the production support

TOOLS & TECHNOLOGY: ORACLE, SQL, PERL, PL/SQL, DBI/DBD, KSH, HTML, JAVASCRIPT, CRON TAB, UNIX, CGI

Confidential, New York, NY
DURATION Mar ’05 – Sep ‘06
PROJECT4 Document Management System
DESCRIPTION : This system is used for searching/viewing various documents/images within the organization in an automated or systematic manner. This application facilitates the user to create dynamic tables for the storage and the retrieval of the documents. Version, control, Access control and auditing are available for providing security.

DUTIES

• Responsible for gathering and documentation of new business rules
• Developed PL/SQL routines to extract data from other database and load it into the Oracle database
• Maintained, troubleshoot and enhanced the existing Oracle PL/SQL code library
• Involved in Oracle PL/SQL code review and modification for the development of new requirements
• Responsible for maintaining all existing HTML and Perl DBI/DBD code
• Wrote and modified required SQL validation scripts to validate the outputs
• Developed and performance tuning Oracle PL/SQL, packages, procedures, functions and triggers
• Created complex functions, stored procedures, packages and triggers using Oracle PL/SQL
• Created Unix shell scripts to perform transfer data to multiple systems and clients
• Developed Unix KSH scripts allowed users to perform database tasks
• Developed Oracle PL/SQL functions and cursors for changing existing content to new format
• Developed Perl Scripts to automated backup status reports
• Created and modified SQL*Plus scripts to capture data
• Wrote SQL and PL/SQL scripts to retrieval data from Oracle database
• Worked on Performance tuning of SQL using Joins and data distribution
• Developed Cron job and Unix shell scripts for monitoring web application and database services
• Developed Oracle PL/SQL triggers to work with WorkFlow design
• Wrote Perl CGI scripts for and text processing
• Involved in the Maintenance releases to support the production environment
• Responsible for 24x7, on-call support for all issues affecting Production

TOOLS & TECHNOLOGY: ORACLE, JAVASCRIPT, PERL, SQL, PL/SQL, DBI/DBD, KSH, HTML, UNIX, CGI, CRON TAB