SUMMARY

• Have over 7 years of experience in software development, deployment of software systems for various commercial applications and SDLC
• Good experience in creating Perl DBI/DBD scripts to connect with Oracle database and good experience with creating Perl scripts
• Strong experience in creating many Perl scripts for server side data processing
• Proficient knowledge of Oracle PL/SQL (Stored Procedures, Packages, Functions, Triggers, etc) and Oracle SQL
• Experience with Unix Shell Script Programming including Perl, HTML, JavaScript
• Experience in designing and developing Oracle based applications including performance tuning
• Strong hands on experienced with Unix and Unix Shell Scripts for the automated testing
• Strong experience with providing 24x7 support for application deployment
• Extensive experience in Oracle backend in PL/SQL development
• Good interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment

TECHNICAL SKILLS

LANGUAGES: Perl, JavaScript, HTML, SQL, PL/SQL, C++, Java

OPERATING SYSTEM: Unix, Windows, Linux

RDBMS: Oracle, MS Access

WEB/APP SERVERS: Apache, Weblogic, WebSphere

TOOLS: Erwin, Cron, AutoSys, SQL * Loader, SQL*Plus, SAP

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Responsibilities:

• Involved in object oriented analysis, design, development and production phases of the different modules
• Developed many tables, stored procedures and triggers on Oracle database for implementing complex business logic
• Wrote various Unix scripts for file handling and manipulation
• Worked on performance tuning of Oracle SQL, PL/SQL and analyzed Tables
• Used various Perl/XML modules for generating reports
• Created various batch processes and scheduled using CronTab for various jobs such as periodic file checks and error report generation
• Created Perl scripts that accessed data from Oracle database utilizing SQL
• Worked with SQL *loader to load data from flat files into databases
• Prepared reports using Stored Procedures with DBI/DBD connection to Oracle and created many reports using HTML
• Developed numerous Perl scripts to validate file line by line against various compliance rules
• Created multiple Unix shell scripts to import data into Oracle using SQL*Loader
• Created many tables and stored procedures to load data into databases
• Also worked with many PL/SQL procedures to create calculated values and store them in database
• Wrote source code in SQL*Plus and Oracle PL/SQL to handle multiple tables
• Worked with Perl file handling to generate various error logs and log files
• Developed and performance tuning Oracle PL/SQL, packages, procedures, functions and triggers
• Used Unix Cronjobs to schedule periodic reports
• Developed complex SQL queries to query multiple tables for report generation
• Connected Oracle database through DBI/DBD from CGI
• Maintained and improved existing code
• Involved in performance tuning of various queries and stored procedures
• Created SQL*Loader scripts to load data from external system to Oracle
• Created many batch scripts using Unix scripting and scheduled in CronTab
• Provided hands - on support as a backup for the production technicians
• Provide day-to-day support for production database and programming issues
• Involved in manual and automated testing

Environment: Oracle, SQL*Loader, DBI/DBD, Perl, HTML, JavaScript, SQL, Unix, CRONTAB, PL/SQL, SQL*Plus

Confidential, New York, NY

Responsibilities:

• Participated in design, user meeting, unit and system testing
• Created many new functionalities for report distribution module and user/client update module using SQL on Oracle
• Developed many Perl scripts for data parsing, manipulation and updating
• Responsible for performance tuned in Oracle SQL queries using the parallel query feature, indexes, and processor hints
• Used Unix KSH CronTab for batch scheduling
• Coded and tuned Oracle PL/SQL and SQL throughout the development wherever needed
• Created and modified SQL*Plus scripts to capture data
• Service requests and enhancements using JavaScript and HTML programming
• Wrote complex Oracle SQL using joins, sub queries and correlated sub queries
• Did Perl programming to provide online forms, request forms, searches and queries, etc
• Wrote and enhanced Oracle PL/SQL stored procedures and triggers for better performance of queries
• Automated numerous back-end processes written using Unix CronTab
• Monitored the performance tuning in Oracle PL/SQL application
• Maintained and improved Perl code for parsing multiple files and printing to booklets for mailing
• Worked intensively on Oracle side creating many Tables, Stored Procedures and Triggers
• Created various stored procedures to validate data in Oracle
• Involved in PL/SQL code review and modification for the development of new requirements
• Worked on performance tuning and monitoring of Oracle database
• Created many SQL batches and executed using Unix scripts
• Used SQL*Loader loads data from external files into tables of an Oracle database
• Participated in providing off hour and 24x7 support
• Created many Unix shell scripts for data file extraction and loading
• Supported the application during production hours
• Maintained multiple levels of support for all systems batch processing
• Did documentation and testing

Environment: Oracle, Perl, HTML, JavaScript, DBI/DBD, PL/SQL, SQL*Loader, SQL, Unix, CRONTAB, SQL*Plus

Confidential, Lodi, NJ

Responsibilities:

• Involved in analysis and designing phase
• Developed a drag and drop slide show editing and viewing application with JavaScript and HTML
• Developed many PL/SQL scripts, stored procedures and triggers in Oracle
• Analyzed web server traffic, both with Analog stats package and homemade Perl programs
• Optimized performance tuning on a Oracle PL/SQL web application database
• Implemented automated monitoring procedures in a Unix Shell environment to alert the staff to a potential service interruption
• Wrote CGI and DBI/DBD based programs to connect to Oracle for data retrieval
• Developed Scripts to generate HTML/JavaScript reports on Intranet
• Used SQL*Loader to load data from a file into Oracle tables
• Created and scheduled Unix Korn Shell scripts for maintenance using CronTab
• Developed numerous scripts to test different functional aspects of Oracle SQL
• Designed tables, views, various SQL queries, stored procedures and functions
• Wrote numerous Perl scripts for Oracle data handling
• Designed and developed CGI and HTML web pages
• Worked on Backend Programming using PL/SQL, Stored Procedures, Functions, Packages, Database triggers for Oracle
• Developed holding upload system using Perl for research group
• Responsible for performance tuning activities in Oracle
• Created data maintenance utility using Unix Shell Scripts (Korn & Perl)
• Supported compliance to all regulatory and audit requirements
• Provided support for job scheduling, file transfers, and transactional processes
• Did unit testing for different components

Environment: Oracle, JavaScript, Perl, HTML, Unix, CRONTAB, DBI/DBD, PL/SQL, SQL*Plus, SQL

Confidential

Responsibilities:

• Participated in user meetings and requirement collection
• Created interfaces using HTML and JavaScript for web page presentation of data
• Developed database triggers and stored procedures using Oracle PL/SQL cursors and tables
• Developed and tuning of Perl code to be used in quantitative analysis
• Created & Updated the HTML pages and indexes for intranet
• Worked in Oracle SQL query analysis and performance tuning
• Created Perl modules and framework for efficiently retrieving time series data from multiple data sources
• Wrote Unix scripts to schedule data loads using Unix Cron
• Involved in Oracle PL/SQL code review and modification for the development of new requirements
• Used SQL*Loader techniques to copy a mass storage of data
• Worked extensively in the back-end Oracle database using PL/SQL
• Created PL/SQL Tables, Stored procedures, Triggers and Views
• Created flat files with SQL*Plus from Oracle tables in Unix environment
• Programmed on Perl involving automation of network abuse response
• Worked in performance tuning of the PL/SQL batches and stored procedures
• Modified the Unix Script as per the technical specifications
• Provided 24X7 support and monitoring of the enterprises infrastructure
• Worked on performance tuning on Oracle database queries
• Created Oracle PL/SQL procedures and packages to transfer and process data
• Supported to resolve production batch failures
• Worked on bug fixing and supported the production applications
• Took part in user requirement meetings and QA analysis

Environment: Oracle, SQL*Loader, DBI/DBD, Perl, HTML, JavaScript, PL/SQL, SQL, Unix, SQL*Plus, CRONTAB