OVERVIEW

• Over 7 years of experience in the field of information technology
• Proficiency level experience in Oracle, Perl, Unix Shell scripting
• Hands on experience in the financial applications including fixed income and hedge funds systems
• Excellent database knowledge on RDBMS like Oracle, PL/SQL and SQL
• Solid experience in CGI programming using Perl, JavaScript and Html
• Extensive experience in Oracle back-end in PL/SQL development
• Expertise in Oracle PL/SQL and Database Performance Tuning by implementing Parallel Execution, Table Partition, Materialized Views with Query
• Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment
• Excellent logical and analytical skills to solve complex problems

SKILLS

Languages: Perl, Java, C, C++, Unix Shell (KSH), JavaScript, CGI, HTML, TSQL

Operating Systems: Solaris, Windows, Linux

Databases: Oracle, Sybase, MS SQL Server, MySQL

Tools: CronTab, CVS, ISQL, ERWin, Toad

Web Server: Apache Web server, IIS, Netscape Enterprise Server (Web)

EXPERIENCE

Confidential New York, NY (Apr 2010 – Mar 2012)

Fixed Income Analysis System (Environment: Oracle, SQL*Loader, SQL*Plus, Perl, CGI, PL/SQL, Unix, KSH, DBI/DBD, Html, JavaScript) - This system was developed for trade analysis and core analytics package for Fixed Income Research group. The system was integrated with High Grade and High Yield Trading components. Traders, salespeople and managers are some of the users of this application. The system performed gap analysis as part of High Grade and High Yield Fixed Income business consolidation efforts.

• Involved in requirement analysis, database design, coding, testing, implementation and review
• Developed many tables, stored procedures and triggers on Oracle database for implementing complex business logic
• Developed various SQL, PL/SQL blocks to optimize the query performance using SQL*Plus
• Prepared many Perl scripts for server side data processing
• Worked on performance tuning of Oracle SQL, PL/SQL and analyzed Tables
• Prepared reports using Stored Procedures with DBI/DBD connection to Oracle and created many reports using Html
• Created Perl scripts that accessed data from Oracle database utilizing SQL
• Managed batch jobs using Unix shell scripts and Perl scripts to process Oracle database activities
• Developed and performance tuning Oracle PL/SQL, packages, procedures, functions and triggers
• Used Unix Cronjobs to schedule periodic reports
• Worked in PL/SQL batches for data handling in the backendCreated multiple Unix shell scripts to import data into Oracle using SQL*Loader
• Used PL/SQL tables, cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process
• Used PL/SQL dynamic procedures during package creation
• Connected Oracle database through DBI/DBD from CGI
• Worked on Performance tuning of SQL using Joins and data distribution
• Created/Modified numerous web pages using CGI, HTML with JavaScript validation
• Created SQL*Loader scripts to load data from external system to Oracle
• Participated in production support
• Enhanced and fixed existing Korn Shell Scripts
• Took part in testing and documentation

Confidential New York, NY (Mar 2008 – Mar 2010)
Hedge Fund Settlement System (Environment: Oracle, PL/SQL, Perl, KSH, CGI, Html, JavaScript, Solaris, Apache, Unix, SQL*Loader, SQL*Plus, DBI/DBD) - This system is used by brokers to enter, modify and verify trade settlement information. Brokers can look up trade histories, do trade cleanups, perform break cleanups. Hedge Fund Settlement System provides daily reporting and data files for review and interacts with other systems such as account, banking and brokerage.

• Identified database objects, created and delivered them to the development team
• Monitored the changes in requirement and constantly kept the database model in sync with the changing requirement
• Developed Perl DBI/DBD and JavaScript for database access from CGI web pages
• Created many Indexes for performance improvement
• Wrote and enhanced Oracle PL/SQL stored procedures and triggers for better performance of queries
• Responsible for performance tuned in Oracle SQL queries using the parallel query feature, indexes, and processor hints
• Used Perl, DBI/DBD for Oracle connection
• Used Unix KSH CronTab for batch scheduling
• Wrote complex Oracle SQL using joins, sub queries and correlated sub queries
• Monitored the performance tuning in Oracle PL/SQL application
• Automated numerous back-end processes written using Perl and Unix CronTab
• Developed many Unix KSH scripts for data file movement and scheduling
• Worked on performance tuning and monitoring of Oracle database
• Used SQL*Loader loads data from external files into tables of an Oracle database
• Coded and tuned Oracle PL/SQL and SQL throughout the development wherever needed
• Wrote source code in SQL*Plus and Oracle PL/SQL to handle multiple tables
• Participated in providing off hour and 24x7 support
• Provided application support during post production

Confidential Moorestown, NJ (Aug 2006 – Feb 2008)
Equipment and Tool Tracking System (Environment: Oracle, Perl, CGI, KSH, DBI/DBD, Html, JavaScript, PL/SQL, SQL*Loader, SQL*Plus, Unix, Windows) - ETTS assists in the maintenance of equipment and tools by providing ready access to technical information and tool rental history. It provides tool management activities like tools tracking, tools maintenance, maintenance scheduling, job tracking, tool set definition, tool movements, tracking, failure diagnosing and reporting.

• Participated in designing the application’s enhancement using object-oriented methodology
• Developed many PL/SQL scripts, stored procedures and triggers in Oracle
• Created many Perl scripts to support front-end pages
• Optimized performance tuning on a Oracle PL/SQL web application database
• Wrote CGI and DBI/DBD based programs to connect to Oracle for data retrieval
• Created CGI and Html based report pages and modified existing pages
• Created Unix Shell scripts for sequential execution of Perl scripts including data extraction, loading and Oracle stored procedure execution
• Developed numerous scripts to test different functional aspects of Oracle SQL
• Created many Perl modules and packages
• Helped design custom data models that integrated with Oracle applications
• Designed and developed interactive GUI forms to support data entry, querying and reporting from the Oracle database
• Developed web-based forms for querying and updating data in Oracle database
• Developed Unix Cronjobs scripts for FTP files and automated processes
• Designed and developed CGI and HTML web pages
• Created and modified SQL*Plus scripts to capture data
• Debugged and fixed many database modules on PL/SQL
• Responsible for performance tuning activities in Oracle
• Created and scheduled Unix Korn Shell scripts for maintenance using CronTab
• Developed and supported custom applications and client web sites
• Worked on development and maintenance of SQL code embedded in Oracle PL/SQL
• Developed procedures and created documentation to support batch operations for batch scheduling
• Took part in testing and documentation

Confidential NJ (Jan 2005 – Jul 2006)
Human Resource Management (Environment: Oracle, PL/SQL, Perl, CGI, Html, JavaScript, DBI/DBD, Apache Web Server, Unix) - This HR application acts a central tools for various HR activity from interview guidelines, rewards & recognition, time sheets, interview history and employee status. The application receives data from several subsystems such as vacation, expense and payroll systems to keep it up-to-date.

• Involved in system study and database design
• Developed database triggers and stored procedures using Oracle PL/SQL cursors and tables
• Created Perl programs with DBI routines for the Oracle connection
• Wrote Perl & Unix shell script to automate the SQL batches
• Worked extensively in PL/SQL batch program
• Involved in Performance Tuning of SQL statements
• Used SQL*Loader to load data from a file into Oracle tables
• Worked with users for changes in the application
• Worked in batch scheduling and 24x7 support of batches using Perl/KSH/Oracle
• Wrote Unix scripts to schedule data loads using Unix Cron
• Created automated reports using Oracle reports
• Created many stored procedures and enhanced the existing procedures
• Created flat files with SQL*Plus from Oracle tables in Unix environment
• Worked in performance tuning of the PL/SQL batches and stored procedures
• Provided 24X7 support and monitoring of the enterprises infrastructure
• Involved in Oracle PL/SQL code review and modification for the development of new requirements
• Created Oracle PL/SQL procedures and packages to transfer and process data
• Took part in user meetings and QA
• Created technical documentation and user manual

EDUCATION
B.Sc in Electrical Engineering