Summary

• More than 6.5 years of experience in Software development involving Requirement Analysis, Designing, Development, Testing, Release Management and Production Support in variousTelecommunication network sector and Bankingservices projects. Successful at designing and implementing Solaris Server Hardware Migration.
• My technology forte isSQL server, Sybase, UNIX, Shell/Perl Scripting, Autosys, Cron job, Solaris, High Availability Cluster, SUN Volume Manager, PDM, OpenSSH, OpenSSL, Oracle PL/SQLand Java.
• Very good experience of working in different relational databases like Sybase, MS SQL Server, Oracle. Worked extensively on T-SQL and PL/SQL stored procedures, views, function, packages, triggers, indexes, cursors
• Strong experience in working with large volume databases with involves performance tuning and transactionbased processing. Have worked on database loading utilities like bcp and sql loader.
• Strong experience in Perl Scripts development. Worked with File handlers,Array, Hash, Subroutines, Packages,RegEx handling,Multi processing concepts like Fork, DBI libraries for database connectivity and parsing files. Developed several Perl process to monitor the input, process the input jobs and NDM the output jobs.Strong object oriented development experience in Perl.
• Excellent skills in working with UNIX shell scripts. Developed shell scripts for feed file integrity checks, polling, FTP activities using commands like find, grep, pipe, cut, redirection and utilities like awk and sed.
• Extensive experience with Cron and Autosys job scheduler like writing jil scripts for creating job definitions. Also used commands like autorep for checking status, definitions, sendevent for starting jobs, changing status.
• Very good experience of working in Solaris OS environment like Installation of Solaris server through DVD and Jumpstart, Upgrade of Solaris server and application server from one lower software version to another, Migration of Solaris server from one hardware platform to another higher version hardware platform. Worked extensively on Solaris server patching, adding/removing packages in Solaris server, Cluster and Volume Manager.
• Vast knowledge on different run-levels/init states of Solaris Operating System. Also have very good experience of different booting concepts like Recovery boot, Reconfiguration boot, Reboot.
• Strong experience in Solaris server booting sequence and importance of Shutdown wrapper scripts.
• Very good experience of administrating and modifying firmware settings of SUN Solaris Hardware at Open Boot PROM level.
• Very good experience of working in Solaris Server DVD Backup and Restore, NetworkBackup and Restore. Worked extensively on Oracle RMAN Recovery Manager Backup and Restore.
• Worked extensively in NDM Network Data Mover scripts for job/file transmission and conversant with FTP, SFTP, SCP protocols and encryption methods.
• Worked extensively in Build management tool like Maven and different third party tools like PDM Private Data Manager , OpenSSH, OpenSSL.
• Exposure to working in onsite client's place for about 3 years good experience in Onsite-Offshore delivery model and its co-coordinating activities and managing the project delivery.
• Very good exposure of softwaresystems architecture and all stages of Software Development Life-cycle.
• Good exposure of performing Root Cause Analysis for the production issues and deliver fix for them.
• Recognized for my professional excellence by my employer with Outstanding Contribution Award and Best Outsourced Project Award, by the client.
• Vast experience with Level 2 production support, involving resolution of issues escalated to development team.

Technical Expertise

Professional Experience

Confidential

Role: Sybase/Perl Developer

Responsibilities:

• Developed SQL queries for carrying out sanity checks and data validations for performing functional and regression tests. Developed perl scripts to perform this in an automated fashion.
• This includes using perlCTLib modules for database connectivity and collecting the result set. Also implemented parallelism using a multi process design, done through fork and exec routines.
• Developed scripts for automated deployment of data base objects through various regions from development through stage, UAT and to production. This involves sourcing DDLs for creating views, tables, triggers, index, etc. and procedure definitions from perforce or the immediate lower environment.
• Involved in developing stored procedures, SQL and performance tuning in Sybase to implement functional logic.
• Related activities in Database include DDL and loading of high volume of data file into DB using bcp utility.
• Making Perl and UNIX shell scripts to implement end of day batch processing functions. This includes input feed parsing, file transfers using FTP, SFTP, etc. generating fixed or delimited format files.
• Implement scheduling for the backend processes using AutosysJILs.
• Maintenance tasks like performance and process improvement by remediating the production code. Also includes fixing the functionality bugs.

Technical Environment: Sybase 12.5.4, T-SQL, Shell Scripts, Perl Scripts, Perforce, AutoSys, Linux 2.6.9

Confidential

Role: Sybase and Perl/Shell scripting Developer

Responsibilities:

• Analyzing the requirements and making functional specification by discussing with business user groups, generally back-office operations.
• Development activities include writing stored procedures, SQL and performance tuning in Sybase / SQL Server to implement functional logic.
• Development activities in Database include DDL for creating views, tables, triggers, index, etc.,and loading of high volume of data file into DB using bcp utility.
• Currently involved in migration of database from Sybase to SQL Server, includes converting DDL Statements and stored procedures and all other database objects to make it SQL Server compliant.
• Making Perl and UNIX shell scripts to implement end of day batch processing functions. This includes input feed parsing, file transfers using FTP, SFTP, etc. generating fixed or delimited format files, database interfaces using DBI modules.
• Implement scheduling for the backend processes using AutosysJILs. Recently did a migration from Autosys 4.5 to R11
• Working the java classes used for common wrapper modules that interfaces with database using JDBC and executes the daily EOD batch. Implemented classes for consuming messages from MQ Message Queues and loading to databases.
• Maintenance tasks like performance and process improvement by remediating the production code. Also includes fixing the functionality bugs.
• Developing Perl and shell scripts for extracts and feeds. Data is extracted through from different sources like Relational database tables, FIXML messages, text format reports, etc.
• Level-2 production support work in assisting the application support team to resolve the day-to-day production issues.
• Capacity planning to cater for business volume growth and maintaining the SLAs within limits.

Technical Environment: Sybase 12.5.4, T-SQL, MS SQL Server 2008,Shell Scripts, Perl Scripts, ClearCase, Perforce, AutoSys, Crystal Reports XI R2, Sun Solaris 10, Linux 2.6.9

Confidential

Role: Perl/SybaseApplication Developer

Responsibilities:

• Requirement analysis and prepare functional specification for migrating billing and customized data from SUN Netra N240 to SUN Netra T5220 together with Sybase data model upgrade.
• Preparing High Level design document, Detailed Design document and Functional Specification document.
• Development activities in Database include DDL for creating views, tables, triggers, index, etc., and loading of high volume of data file into DB using bcp utility.
• Development activities include writing UNIX Shell Scripts to implement functional logic for data migration.
• Development of framework processes using Perl Scripts. This also includes file processing through sed, awk within the scripts.
• Development activities include parsing of XML files using Perl scripts to execute XML frameworks for data migration.
• Writing commands to schedule the processes in Crontab
• Preparing test cases for Unit Test, End-to-End Functional tests and System Integration tests with other applications in the core CDMA network.
• Support user testing and deploying the changes. Also handle post deployment support.
• Assisting application Production Support team in resolving production issues when escalated to Level-2

Technical Environment: Sybase 12.5.4, T-SQL, MS SQL Server 2008, Shell Scripts, Perl Scripts, Crontab, ClearCase, Sun Solaris 10, SUN SPARC SUNW Netra-240, SPARC SUNW Netra- T5220,

Confidential

Role: Perl/Shell scripting Application Developer

Responsibilities:

• Development of Korn / Bash Shell Scripts to implement DVD backup and restore. This includes using Solaris commands ufsdump, cpio, tar, gzip, fssnap, fmthard, etc.
• Development of Command Line User Interface CLUI for this functional module using Perl Scripts.
• Development of java classes for implementing network backup and restore.
• Writing commands to schedule the processes in Crontabfor automatic scheduling of Daily night backups.
• Development of RMAN scripts to perform backup and restore of Oracle database.
• Carryout Design review and Code review of the new modules.
• Preparing test cases for Unit Test, End-to-End Functional tests and System Integration tests with other applications in the core CDMA network.
• Carryout unit and functional tests, which includes core dump analysis using pstack. Also handle post deployment support.
• Assisting application Production Support team in resolving production issues when escalated to Level-2

Technical Environment: Sun Solaris 10, Shell Scripts, Perl Scripts, Java, Crontab, ClearCase, SFTP, SCP, Oracle RMAN.

Confidential

Role: Perl/Sybase Developer

Responsibilities:

• Analyzing the requirements and making functional specification by discussing with business user groups.
• Development activities include writing Bash/C shell scripts,Perl scripts to implement functional logic of new SPFS combo profile.
• Preparing High Level design document, Detailed Design document and Functional Description document Installation Manual and Technical Publications .
• Administering and monitoring firmware settings at Open Boot PROM level.
• Performing DVD installation, Jumpstart installation for different types of SPFS profile.
• Configuring System information like Host name, IP address, Default router, Net masks, Domain Name System Configuration.
• Monitoring system run-levels/init states during system boot up.
• Performing recovery mechanism like Recovery boot, Reconfiguration boot, Reboot if system encounters any issue during boot-up or during installation.

Technical Environment: Sun Solaris 10 / 9 ,DVD Installation, Jumpstart, Shell Scripts, Perl Scripts, Java, Crontab, ClearCase