Summary:

• Around 7 years experience in all aspects of Software Development Life Cycle including System Analysis, Software Design, Development, Implementation and Testing
• Strong experience with Oracle PL/SQL and Unix shell script programming
• Expertise in Oracle SQL and PL/SQL developing complex code units, database triggers and using the latest features to optimize performance
• Good working experience with Oracle SQL*Loader and SQL*Plus
• Extensive working knowledge on SQL Loader control programs, and PL/SQL validation scripts to transfer flat file data into Oracle database tables
• Good experience with scripting and programming in different languages, including Unix shell and Perl
• Good experience with supporting and developing financial application
• Excellent communication skills and an exceptional client service attitude
• Ability to work in a team and as an individual with minimal supervision

Technical Skills:

Languages:

Perl, C, KSH, JavaScript, HTML, SQL, PL/SQL

Operating System:

Windows, Solaris, Red Hat Linux, UNIX

Databases:

Oracle, Sybase, MS Access

Web Servers:

Weblogic, Apache Tomcat

Tools :

Erwin, CGI, Cron Tab, DBI/DBD

Professional Experience:

Balanced Fund Portfolio Management
Sep 08 - Till Date
Confidential, NYC, NY
This allows the balanced fund managers to analyze the risk and exposures of both fixed Income and equity portfolios in a single aggregated view. It serves to give you broad asset and market coverage, multiple risk perspectives, performance attribute capabilities, decision-making capabilities etc.

Responsibilities:

• Designed, implemented and supported numerous other internal and external web based applications
• Wrote SQL and PL/SQL scripts to retrieval data from Oracle database
• Wrote Perl programming to error check the data and import it into the Oracle database
• Validated the data entered by raising SQL queries against the databases
• Designed and developed customized Oracle PL/SQL Client/Server environment
• Built web interfaces to various views and processes of Oracle database
• Involved in Performance Tuning of SQL statements
• Created Unix shell scripts for sequential execution of Perl scripts including data extraction, loading and stored procedure execution
• Wrote source code in SQL*Plus and PL/SQL to handle multiple tables
• Developed applications with PL/SQL, Database design and data modeling
• Wrote Shell Scripting programs to execute Oracle PL/SQL and SQL Files
• Developed interfaces using Oracle PL/SQL procedures and created packages to load data into targeted Oracle database
• Wrote shell scripts and executed them as Cron jobs on Unix
• Developed Shell scripts and SQL control files to load data through SQL*Loader
• Wrote scripts to automate exports and imports of data from Oracle
• Coded Unix shell scripts to call SQL scripts and to manipulate the returned data
• Wrote Unix shell scripts to automate the start up and shut down of applications
• Wrote various SQL queries for data manipulations
• Developed new and updated existing PL/SQL programs supporting Oracle applications
• Created complex functions, stored procedures and packages, Triggers by using Oracle PL/SQL
• Provided extensive end user Training and Support

Environment: Oracle, Perl, CGI, KSH, PL/SQL, SQL, SQL*Loader, SQL*Plus, Cron Tab, UNIX

Credit Risk Management Process
Jul 06 - Aug 08
Confidential,NYC, New York
This application is designed to facilitate and improve credit investment process. It supports quantitative portfolio monitoring, issuer analysis, and pricing of credit-risky assets. Users like crediting analyst, bonding portfolio managers used to obtain the quantitative insight into issuers credit worthiness.

Responsibilities:

• Involved in Object oriented analysis of requirements, design and programming cycle
• Responsible for scripting data manipulation using Oracle SQL and PL/SQL
• Created many SQL batches for data handling using Perl/KSH
• Worked on performance tuning and monitoring of Oracle database
• Performed database testing by passing SQL Queries to retrieve data in Oracle
• Used SQL*Loader for data uploading from flat files
• Implemented relational Oracle database to store and annotate sequences
• Created Cron jobs in Unix for scheduling file preprocessing
• Wrote Oracle PL/SQL functions, procedures, Korn Shell scripts that were used for staging, transformation and loading of the data into base tables
• Wrote and modified required SQL validation scripts to validate the outputs
• Created many Unix KSH scripts and enhanced the existing script
• Generated Oracle PL/SQL and Shell scripts for scheduling periodic load processes
• Used SQL*Plus to execute PL/SQL programs, procedures and packages
• Wrote Unix shell scripts to automate the verification of the information inserted in the database via the web application
• Used Oracle PL/SQL and SQL*Plus programming to write stored procedures, queries, triggers, objects, and views on normalized database tables
• Worked on performance tuning of Oracle SQL, PL/SQL and analyzed Tables
• Involved in Production Support & resolving production issues
• Worked with Production Support team to immediately resolve failures in production data processing

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

Issue Reporting Solution
Dec 04 - Jun 06
Confidential,New Delhi, India
The purpose of this project is to keep track of daily system related problems within the organization. The system allows all the employees of the firm to enter the issues on their system, check their status, and escalate issues if not addressed. Also admin can generate various reports for the upper management.

Responsibilities:

• Responsible for software quality in regard to the software development cycle
• Designed and developed Oracle PL/SQL scripts for Data Import/Export
• Wrote Perl routines to extract data from Oracle tables and to Create flat data files
• Defined transformations to map SQL queries into text retrieval operations
• Developed database triggers and stored procedures using Oracle PL/SQL cursors and tables
• Rewrote SQL*LOADER scripts to improve performance and reliability of high throughput data loading process
• created new table spaces and instances using Oracle database
• Coded and tuned Oracle PL/SQL and SQL throughout the development wherever needed
• Implemented new database design using Oracle environment
• Wrote customized Unix shell scripts used to provide additional monitoring of production servers
• Wrote complex Oracle SQL using joins, sub queries and correlated sub queries
• Created and modified SQL*Plus scripts to capture data
• Used Unix shell scripting using hash tables and array index listing for fast retrieval
• Used Oracle PL/SQL tables, ref cursors to process huge volumes of data
• Responsible for 24x7 production database support, high availability, maintenance, monitoring, and problem management reporting

Environment: SQL*Plus, SQL, SQL*Loader, Oracle, Cron Tab, UNIX, Perl, CGI, KSH, PL/SQL

Confidential,Gurgaon, India
This is a management product, which keeps track of various customer details, payment history, individual construction requirement, itemized expenses for building contracts and also generates reports. Some of reports include current status report of projects, customer details, customer correspondence and payment details

Responsibilities:

• Involved in analyzing the user requirements and preparing system specification
• Developed PL/SQL routines to extract data from other database and load it into the Oracle database
• Designed and developed of large-scale client-server systems using Perl
• Discovered critical bugs and recommended fixes to Oracle
• Involved in tuning and applying the Oracle SQL statements and PL/SQL processes
• Designed Database Tables, Views, Relationships, Programmed stored procedures, triggers and functions in Oracle
• Involved in Oracle PL/SQL debugging and support
• Developed SQL Scripts and stored procedures to manipulate and query data
• Converted data from many legacy systems environment to the Oracle Applications
• Used SQL* Loader to load data into the tables
• Wrote Unix Korn shell scripts with SQL to unload and load data and change state information for databases
• Created database triggers for data validations in Oracle
• Wrote Unix shell scripts for data manipulation in directories and for publishing the information on the internet
• Used Oracle PL/SQL dynamic procedures during package creation
• Supported compliance to all regulatory and audit requirements

Environment: PL/SQL, SQL, Perl, CGI, KSH, SQL*Loader, SQL*Plus, Oracle, Cron Tab, UNIX

Education:
Bachelor of Technology