PROFESSIONAL PROFILE

7 years of strong experience in software industry with proficiency in handling complex projects, user expectations, and rapidly evolving requirements and user satisfaction. Strong experience in Information Technology that includes application analysis, design, development, testing, implementation, support and maintenance using Oracle, Perl and Unix Shell scripting. Extensive development experience in Perland Unix and possessed strong hands-on background in supporting production environments and meeting customers’ need. Strong hands on experience in Oracle database, SQL queries and PL/SQLprocedures/functions, triggers, packages and query optimization. Good working experience with Oracle SQL*Loader and SQL*Plus. Good experience in scripting languages such as KSH and CSH.Experience in designing and developing Oracle based applications including performance tuning. Worked effectively with all levels of management and satisfied project and productivity requirements on a consistent basis.

TECHNICAL COMPETENCY

Operating Systems - Unix, Windows, Linux, Solaris
Language - Perl, C, KSH, PL/SQL, SQL, Javascript, HTML
Databases- Oracle, Sybase, SQL Server
Web Server - Apache, Weblogic
Tools -TOAD, Cron Tab, Erwin, DBI/DBD

CLIENT PROJECTS

09/2009 to Present - Confidential, NY (Fixed Income and Equity Operations Project)
This system is a Fixed Income and Equities in support of Straight Through Processing (STP) initiative. Site enables clients to monitor trading activity from a summary page displaying real-time trades, settlements and fails. Users could drill down to transactions from the summary page or search for historical trades and open confirms for each transaction. Data could also be exported to excel. Users have the ability to trade internationally.

• Wrote Oracle PL/SQL scripts to analyze the data for inconsistencies and integrity issues
• Involved in gathering requirements from the client and software requirements specifications
• Worked on performance tuning of Oracle SQL, PL/SQL and analyzed Tables
• Designed and implemented custom Perl utilities to support job control
• Tuned stored procedures for performance tuning of application in Oracle
• Created/Modified numerous web pages using HTML with JavaScript validation
• Created flat files with SQL*Plus from Oracle tables in Unix environment
• Used TOAD to write PL/SQL stored procedures for inserting and retrieving data
• Developed Perl scripts for access modification in production
• Wrote packages using Oracle PL/SQL to access data from the database and write into and extract from flat files using SQL* Loader utility
• Created many batch scripts using Unix Shell scripts (KSH)
• Developed new and updated existing PL/SQL programs using Oracle Applications
• Wrote Unix shell scripts to automate the verification of the information inserted in the Database
• Used Oracle PL/SQL to filter and load data from databases
• Used Perl, CGI and shell scripts to set up many dynamically web pages
• Developed numerous scripts to test different functional aspects of Oracle SQL
• Worked on Performance tuning of SQL using Joins and data distribution
• Tuned SQL queries using TOAD
• Provided 24x7 support and debugged production issues
• Experience in working with database objects especially database Triggers, Stored Procedures, Tables and Functions
• Provided user support, training and troubleshooting

Environment: Oracle 10g, Perl, CGI, DBI/DBD, SQL, PL/SQL, Unix, HTML, SQL * Plus, Javascript, KSH, Cron tab, SQL * Loader, TOAD

05/2007 to 08/2009 - Confidential, NY (Single Security Analysis)
Single Security Analysis allows user to analyze mortgage securities. The system collects all pertinent and material information needed to evaluate and calculate the risk measures of the security. The interactive calculators provides real-time option-adjusted spreads and durations along with other risk measures; industry-leading prepayment, Default and Term Structure Models. The calculator also returns yield tables, cash flows and provides pass-throughs prepayment analysis.

• Developed Oracle PL/SQL procedure for reporting attributes
• Performed requirement collection, analysis and design documentation
• Involved in performance tuning of Oracle SQL statements
• Designed Perl application to generate report to perform administrative function.
• Used Oracle PL/SQL and SQL*Plus programming to write stored procedures, queries, triggers, objects, functions and views on normalized database tables
• Worked in the front-end interface to authenticate the user access to application using CGI/HTML/JavaScript
• Modified and maintained KSH script to monitor the memory usage of Unix system
• Designed, developed, and deployed customizations to Oracle Applications modules using Oracle SQL*Plus and PL/SQL
• Developed Unix shell programs and scripts to maximize productivity and resolve issues
• Responsible for performance tuning Oracle SQL queries using the parallel query feature, indexes and processor hints
• Developed and co-developed tools and reporting applications in Perl
• Developed Shell scripts and Oracle SQL control files to load data through SQL*Loader
• Used Oracle SQL queries to test the migrated database for back end testing
• Performed Korn shell scripting to automate aspects of the Unix environment
• Developed Perl scripts to access the Oracle database using DBI/DBD
• Worked in supporting the application
• Worked on performance tuning and monitoring the database
• Utilized Oracle PL/SQL to perform trouble shooting while assisting client services
• Worked on bug fixing and supporting the production

Environment: Oracle 9i, Perl, Unix, SQL * Loader, PL/SQL, SQL, SQL * Plus, KSH, HTML, Javascript, CGI, DBI/DBD

04/2006 to 04/2007 – Confidential (Pharmaceutical Inventory Management System)
This high performance database system designed specifically for tracking drugs and laboratory supplies. The purpose of this resource center is to provide pharmacists and others responsible for patient care with the drug product acquisition, inventory management with appropriate information, tracking the drug product shortage, backorders, customer information and soon.

• Wrote database triggers, procedures, packages and functions using PL/SQL and SQL in Oracle database
• Involved in front-end design, analysis, development and testing
• Optimized performance tuning on a Oracle PL/SQL web application database
• Implemented Perl DBI applications for batch updates
• Wrote control files and loaded the data into the Oracle database with SQL*Loader
• Designed, developed HTML/JavaScript forms
• Wrote source code in SQL*Plus and Oracle PL/SQL to handle multiple tables
• Created schema, tables, triggers, procedures and views on Oracle database
• Maintained and enhanced the archive and restore Unix Shell Scripts
• Used Oracle SQL to generate schema and retrieve data
• Developed log/error file scanning tool and reporting scripts for KSH
• Used DBI with Perl modules for Oracle connections
• Created Unix Shell Script for data validity
• Worked in performance tuning of the PL/SQL batches and stored procedures
• Supported the application by providing after hours support
• Created Perl script to make the connection to Oracle database using DBI/DBD module

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

10/2004 to 03/2006 - Confidential (eTravel - Domestic) 
eTravel application is designed for a travel based industry in India. It constitutes of both Domestic Travel Plan (DTP) and Domestic Travel Expense Report (DTER). The application is used every time an associate based in India, travels within India for official visit.

• Developed, tested and optimized Oracle queries and PL/SQL code for the migration of large datasets.
• Gathered requirements from the client for front end design and developed software requirements specification
• Responsible for Performance tuning activities in Oracle
• Maintained and created Perl scripts for web server
• Wrote SQL queries to access data from Oracle database
• Provided support while the HTML and JavaScript was integrated with server-side code
• Created Packages in Oracle database
• Created and modified SQL*Plus scripts to capture data
• Implemented and, tested sophisticated Unix Shell scripts to function as the main driver for the uniform execution of the system
• Used SQL*Loader can be loaded from any text file and inserted into the database
• Wrote statistics gathering scripts in Perl
• Designed and developed customized Oracle PL/SQL Client/Server environment
• Responsible for scripting data manipulation using SQL and PL/SQL
• Monitored and managed the Oracle database
• Created GUI and database applications to display travel information using Unix shell Scripts
• Participated in the backup and recovery of Oracle database
• Involved in design, development and Modification of PL/SQL , stored procedures, functions, packages and triggers to implement business rules into the application
• Used Oracle PL/SQL dynamic procedures during package creation
• Developed and tested Unix Shell Scripts (Korn & Perl) which automate, file manipulation, transfers and archives
• Provided user manual for application troubleshooting for production support

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

EDUCATION

Bachelor of Engineering