Professional Profile:

• Currently working on SCRUM/Agile methodologies.
• Around 8 years of experience in requirement analysis, system design, coding, testing and documentation.
• Experience in various domains including Tour Travel and Hospitality.
• Currently working in TTH domain with AVIS BUDGET CAR RENTAL LLC.
• Experience in providing 24x7 Production support.
• Experience in production support to the users UAT as well as to the Clients Business requirement .
• Experience as Module Leader in Client Server Maintenance Team, Software engineer as well as analyst.
• Relational and Dimensional Data Modeling.
• Database Design / Modeling / Migration
• Database Development and General Administration
• Experience in Sybase database Extensive Experience in Database Optimization and Performance Tuning
• Automated Backend process through Shell / Perl Scripting, extensively optimized Batch Processes
• Experience in Writing Oracle Packages , stored Procedures and Function and Handling the Error in a better way.

Objective:

To achieve a position that offers challenge, growth career opportunity in a result oriented company, which seeks an ambitious and career conscious person, where acquired skills and education will be utilized towards growth and advancement.

Technical Expertise:

Languages : Core Java, Servlet, JSP, JDBC, PL/SQL, Web-Services, XML, Perl

Scripting, Windows Scripting, UNIX Shell Scripting, Power Builder

Frameworks : J2EE Struts , JMS, JBoss

OS : MS-DOS, Windows 7/NT/XP/2000/98/95, Sun Solaris 10/8/7.

Database : Oracle9i and 10g, Ms-Access, SQL Server 2005, Sybase ASE 15.0.2/12.5.3/12.5.0.3/12.0, IMS DB2.

Web Servers : Apache Tomcat 5.0, WebLogic, Sunone

Tools : Net beans, MyEclipse, SSH, Power Builder, MS Office, Putty, Toad

Maximo, ITS, Incident Manager, SQL 7.4/5.7, Sybase Central 4.1.1

SCM : PVCS merant 6.8, SVN.

Concepts : Requirement analysis, High level design, detailed design, Low level design

Project/Release Planning, Software development, Code walkthrough

Unit Testing, System testing, Regression testing, Performance testing

Production delivery kit

Work Experience:

Confidential

Role : Java Developer

Environment : Java, UNIX, Sybase

• Maintenance, enhancement and development of reporting system front-end application.
• Estimation of software development effort.
• Requirement capture, design and code development.
• Unit and system testing.
• Continuous client interaction to ensure an open communication loop is maintained with reference to queries and issues.
• Deployment and post-deployment support to packages
• Defect prevention and causal analysis activities
• System and business knowledge build

Confidential

Role : Sr. Database Developer

Responsibility : Developer, Tester, Analyzer

Environment : Sybase 15.0.2/12.5.3, Oracle 10g, BCP, Stored procedures, Indexes, Solaris 10/7,

• Upgraded Sybase 12.5.3 to Sybase 15.0.2. Responsible for testing batch jobs for Americas, Europe and Asia Pacific Regions.
• Optimized the batch cycle run time from 7 hours to 4.5 hours.
• Optimized price testing, data upload and mapping modules for product controllers. There is 65 improvement in the run time from 40 minutes to 14 minutes.
• Developed/optimized stored procedures for fair value accounting, a feed to downstream.
• Played a key role in masking highly confidential data.
• Worked as a SCM within the team, collecting release files from the developers, consolidating and preparing for the release. Coordinated the release with the DBA's and SA's and ensured that database objects/ Unix scripts have been deployed correctly.
• Participated in DR/QMW tests and performed checkouts to ensure that price testing applications are working as expected.
• Extensively worked on data archival and purging.

Confidential

Role : Team Member as well as Team Lead

Responsibility : Developer, Tester, Analyzer

Environment : UNIX, Sybase, C, PowerBuilder.

• Analyze the input file received from GM, Ford, and Chrysler.
• Design the database for all 3 manufactures
• The files will come on Unix Sever using secure FTP.
• C parser program will read the file and store in Sybase database through Stored Procedure
• Write the Stored Procedures to insert the data into Sybase table
• Recommended DBA to increase user log cache ULC from 2k to 8K based on the observation that transactions started taking upto 14 minutes while doing a commit . Change was implemented by DBAs and transaction committed at a normal pace.
• Suggested multiple tempdb as a solution to heavy usage of temp db frequent blockage on system tables. It was implemented by using 2 tempdbs initially and later promoted to 3 tempdbs.
• Partitioned key tables for performance improvement.
• Once the data is loaded into the Sybase database table
• Create a new login and Display function which will be written in Power Builder
• Write a Shell Scripting which will sftp the file from the Vendor's server.
• Write a Shell Scripting to check the file and process the file using C binary class file.
• Schedule the job in crontab.

Confidential

Role : Team Member as well as Module Leader

Responsibility : Architect, Developer, Tester, Analyzer

Environment : Java J2EE, PL/SQL, UNIX, Sybase, SSH, Toad

• Analyze the business requirement what the business demands through Calls
• Prepare the Scenario and PDD for this Project
• After the Approval of the PDD by business prepare the flowchart
• Prepare the database design Document
• Prepare the Batch Process Design Document
• Develop the Web Application on Java J2EE Platform
• Develop the Batch Process in Core Java.
• The challenge is here to 1st connect to the IMS DB2 data base and pull the data and do some business logic stored into oracle data base, then connect to Sybase database to retrieve all the data based on the VIN Vehicle Identification Number and again load into Oracle data base as the record is more than 5 core at a time to handle java is very difficult
• Write the Stored Procedures, functions,Sequences,Objects, Packages to upload the data into respective tables and to mitigate the business requirement
• The Web Application war file is deployed in Unix environment
• The batch process is also deployed on Unix Plat form which will do all business logic and send the file to Autonation Server through Secure sftp
• Create a new login and Display function which will be written in Power Builder
• Schedule the job in crontab.

This project went live few months back, I am also worked the maintenance phase which includes Enhancements handling, DB analyzing, Performance Tuning, Crucial Testing etc.

Confidential

Role : Team Member

Responsibility : Developer, Tester, Analyzer

Environment : UNIX, C, Sybase, Oracle.

• Modify existing processes to parse and load Sabre files into AROS Distribution Rate and Distribution Rate Details tables.
• Create mechanism to transfer eClerx Inbound files to Unix server
• Create new tables to map and store eClerx Inbound rate information.
• Converted clustered indexes on temp tables in stored procedure report SQL's to non-clustered indexes.
• Rebuilt highly fragmented indexes which get fragmented fast due to the nature of the application on the development databases and convinced Manager that application needs a periodic index rebuild on most actively used indexes and coordinated production implementation with the DBA team. Recovered 35 GB of free space from index rebuilt and thus weekly database maintenance improved by 2 hours.
• Create a new process to load parsed Inbound data into AROS tables
• Modify an existing History Capture process to transfer Inbound data into archive tables and purge the current data
• Write an Shell Script to Automate the application and schedule in crontab Scheduler.

Confidential

Role : Team Member

Responsibility : Developer, Tester, Analyzer, Architect

Environment : UNIX, Sybase, Oracle Java J2EE.Perl Scripting

• Analyze the business requirement what the business demands.
• Prepare the Scenario and PDD for this Project
• After the Approval of the PDD by business prepare the flowchart.
• Prepare the Batch Process Design Document.
• Develop the Web Application on Java J2EE Platform.
• Develop the Batch Process in Core Java.
• Write the Perl Scripting which will connect to the oracle data base and prepare a tab delimited file
• Write an Perl Script which will Ftped the file to FPS application Server
• Developed the process in Java Web Application to select multiple rotation at a time
• Optimized stored procedures for PROS Allocation module.
• Created a script to report processes blocked for more than 2 minutes
• Write an Shell Scripting to Automate the Process and schedule on Cron Job

Confidential

Role : Team Member as well as Team Lead

Responsibility : Design, Database Architect, Developer, Tester, Analyzer

Environment : UNIX, Oracle, Java J2EE.

• Analyze the business requirement what the business demands through Calls
• Prepare the Scenario and PDD for this Project
• After the Approval of the PDD by business prepare the flowchart
• Prepare the database design Document
• Prepare the Batch Process and Purge process design Document
• Develop the Web Application on Java J2EE Platform
• Develop the Batch Process in Core Java.
• Write the Stored Procedures, functions,Sequences,Objects, Packages to upload the data into respective tables and to mitigate the business requirement
• The Web Application war file is deployed in Unix environment
• The batch process is also deployed on Unix Plat form which will do all business logic and send the file to Fleet Draft Payment Server through Secure sftp
• Create a new login and Display function which will be written in Power Builder
• Schedule the job in crontab.

Confidential

Role : Team Member

Responsibility : Developer, Tester, Analyzer

Environment : UNIX, Java, Oracle

• Design e-people website in java
• Worked as a team member
• Design and create database tables
• Create deployment Shell script to deploy in Server
• Monitoring the log of the application