SUMMARY:

• Over 7.5 Years of experience in software industry with depth knowledge in Oracle
• Experience in operational 24x7 application support, best practice trouble shooting, monitoring, capacity planning and maintenance
• Good knowledge in PERL, Oracle, Unix Shell,Python programming
• Experience in analysis, documentation & applications Support using Web and Client Server technologies
• Extensive experience in CGI / DBI/DBD programming in PERL using JavaScript and HTML
• Good experience in Control M
• Proven capability in delivering technical solutions for Unix environment based issues
• Strong coding and programming experience in Oracle PL/SQL using cursors, ref cursors, collections and bulk collects
• Strong experience in PL/SQL based programming and Unix based scripting to build the workflowStrong work ethic, committed to smart work
• Strong hands on experience in Oracle SQL query optimization, stored procedure, performance tuning
• Good experience in writing SQL Queries
• Expertise of Database development including developing Stored Procedures/functions etc
• Strong knowledge on Oracle PL/SQL with Performance Tuning
• Good in Oracle SQL, Writing SQL Queries using Joins
• Excellent database knowledge on RDBMS like Oracle, SQL, PL/SQL

TECHNICAL SKILLS:

LANGUAGES: Perl, CGI, SQL, PL/SQL, C++,python

OPERATING SYSTEM: Windows XP, Unix, Linux, MAC OS

DATABASES: Oracle, MySQL, MS Access

WEB Server: Apache web server

TOOLS: SQL*Plus, SQL*Loader

PROFESSIONAL EXPERIENCE:

Confidential,NJ

Application Support Engineer

Responsibilities:

• Created Perl Based scripts to automate SQL reports previously done
• Responsible for application support, database capacity issues, replication, other distributed data issues, and server security
• Wrote Customizes Unix Shell Scripts used to provide Additional monitoring of production Servers
• Ensured effective and timely resolution and communication to the user during the application support
• Built SQL queries with unions and sub - queries
• Developed comprehensive recovery plan for the Control M system
• Worked an on-call support in production environment on web-based applications to resolve any issues with the system
• Worked on Stream processing for the obvious way to run SQL Queries
• Participated in application support, both monitoring and troubleshooting Support
• Wrote Unix shell scripts for report generating and Printing
• Contributed to the prevention of problems/ issues as they related to production support
• Provided ongoing application support for those systems
• Contributed to the prevention of problems/issues as they related to production support
• Wrote large number of Shell scripts for Unix as part of the move to Control M batch administration
• Maintained and enhancement of Oracle database, including complex business logic written in PL/SQL
• Assisted with application support issues including research, analysis, coding, and installation of production fixes
• Worked an on - call support in production environment on web-based applications

Confidential,

System engineer

• Created many migration and maintenance scripts to keep a record of active members in Perl for the member registration module
• Worked on application support, and receive production calls, and working on trouble reports which are received from clients
• Involved in SQL queries allowing the user to specify a description of the desired result under the search, reservation and returns module
• Monitored daily activities of the application support
• Created and scheduled UNIX shell scripts for maintenance using corn tab
• Provided Support and trouble-shooting covering various application issues
• Wrote scripts in Oracle SQL to monitor batch processing to get warning in case of wrong data processing under the administration module
• Provided application supports and ongoing user supports for the application
• Developed a framework for extensible automated production support in PL/SQL
• Provided application support to various functional areas
• Managed and supported the outages during urgency
• Responsible for production support monitor and investigate issues with production applications
• Worked on bug fixing and application supported to the production application
• Responsible for participating in out of hours support duties

Environment:: HTML, JavaScript, Perl, UNIX, Oracle, DBI/DBD, Windows,PL/SQL, SQL*Plus

Confidential

• Developed comprehensive project documentation and deliverable including Scope & Vision Document, Business Requirements Document, Functional & Technical Design Document, UAT scripts and sign-off document and training kit, manuals etc.
• Developed, tested and optimized Oracle queries and PL/SQL code for the migration of large datasets
• Produced UML models to support project-related artifacts.
• Planned schema versioning synchronization and upgrade from Oracle
• Created/Updated database objects like tables, views, stored procedures, packages.
• Wrote Unix shell scripting for major database utilities
• Used SQL*Loader to convert the data from the CSV to Oracle tables
• Modified existing PL/SQL procedures to increase efficiency of data retrieval
• Developed and documented Perl modules for interfacing with the message store
• Supported development and test databases.
• Created flat files with SQL*Plus from Oracle tables in Unix environments
• Used PL/SQL tables to process huge volumes of data and used Oracle bulk collect to improve the database performance
• Wrote several production Unix Korn shell scripts
• Wrote SQL queries to access data from Oracle
• Developed and wrote shell scripts for data transfer
• Developed numerous Perl scripts to support system administration tasks for user systems
• Wrote PL/SQL queries to build customized reporting module for the users.
• Used Import/Export utilities of Oracle.
• Performance tuning and query optimization were extensively needed in these projects and worked on the same.
• Assisted in the creation of new fields for capturing data in the Oracle database that related to vendor data
• Developed and maintained extensive scripting environment using Unix Shell scripting
• Optimized performance on a Oracle PL/SQL web application database
• Developed a search engine for the online publications, using Perl/CGI scripts
• Improved performance of the application by rewriting the SQL queries
• Wrote SQL and shell scripts for Performance tuning and monitoring, database backup and recovery on Oracle Wrote Oracle scripts to define privileges and rights of each user involved
• Provided application support during post production

Environment: Oracle, PL/SQL, HTML, Perl, CGI, UNIX, DBI/DBD, CronTab, SQL, JavaScript