SUMMARY:

• A software professional with 8 years of extensive experience in the systems analysis, design, development, testing, implementation and maintenance of software applications in the financial domain
• Experienced in all the phases of SDLC - Requirement Analysis, Design, Development, Implementation and Post-Production
• Expertise in back-end application development using SYBASE 11.x/12.x and front-end scripts using PERL.
• Expertise in developing applications, batch processes using PERL, Shell Scripting, TSQL, JavaScript for 7 years and Oracle, PL-SQL for 2 years.
• Supported the existing applications in development, QA and production domain.
• Knowledge in VB.NET and Component One Reporting tool
• Expertise in Autosys and Crontab
• Expert in Version Control using Clear Case 2002.05.00
• Experienced in Unit, Integration, Regression, UAT and Parallel testing
• Excellent knowledge in MS Unicode Character sets.
• Excellent analytical and verbal communication skills and a good team player

TECHNICAL SKILLS:

Languages: PERL, TSQL, PL/SQL, KSH, JavaScript, C, C ,

HTML, AWK, UNIX Shell, VB.NET, XLS

Tools: Autosys, DBI/DBD, BCP, ISQL, ClearCase, Crontab, Component One, Microsoft Visual Basic 7, TOAD, DB Artisan, Rapid SQL, Text Pad, Ultra-Edit, CVS, Borland Star Team,

SQL LOADER

RDBMS: SYBASE 11.x/12.x, Oracle 8i/9i/10g

Operating Systems: Solaris 2.x, SunOS 5.x, MS-WindowsNT/2000

Web App Server: Apache 2.0

EXPERIENCE:

Confidential

Sybase Developer

RESPONSIBILITIES:

• Extensively used Sybase T-SQL 15.x for creating, modifying and maintaining the stored procedures for the processing of the business logic for the different system modules and modifying them according to the customer needs and expectations.
• Maintaining the backend with Sybase 15.x
• Involved in extensive tuning the performance of the stored procedures and queries in Sybase.
• Resolved the back-end production issues in stored procedures on a real-time day-to-day basis.
• Participated in extensive user meetings with the end users to understand their needs and expectations and the business analysts to understand the business logic.
• Worked extensively on Borland Star Team for version control.

Environment: TSQL, Sybase 15.x, Rapid SQL 7.5.1, Borland Star Team.

Confidential

Perl Developer

RESPONSIBILITIES:

• Designed and developed front-end PERL scripts with HTML for generating the e-statement, text statement and regular exporters.
• Used PERL file-handling and regular expressions extensively to parse extremely sensitive bank account information of the customers to generate e-statements.
• Developed PERL scripts with HTML to add new overdraft sections to the bank statements to make them Regulation DD UDAP compliant.
• Performed Unit and Integration testing before sending the code through UAT and QA queues.
• Interacted face to face with the end users, the banks and product implementation engineers regarding the format of their statement exporters.
• Used UNIX and shell scripting extensively to enhance the PERL scripts and develop crontab jobs to schedule the PERL scripts.
• Used the DBI/DBD module for Sybase connection from PERL scripts to store trading information data into the database, created tables, procedures for displaying them in the form of a report.
• Worked extensively on CVS through the UNIX environment for version control.
• Documented the entire data flow for the change requests from the external financial institutions to resolve their issues at run-time.

Environment: PERL, DBI/DBD, TSQL, Crontab, HP UNIX, KornShell, CVS.

Confidential

Oracle/Perl Developer

RESPONSIBILITIES:

• Designed and developed PERL scripts with SQL LOADER for loading the data from the ADP, ESS or Imagine systems into the reconciliation system tables in the Oracle database
• Designed and developed PERL scripts for generating table-driven reports from Oracle tables, views and stored procedures by loading the report parameters dynamically
• Used Spreadsheet module in PERL extensively to generate integrity reports, MIME::Lite module in PERL to generate reports as email attachments and sent them to the end users and Date::Calc module in PERL to keep track of close-of-business dates for running the reports
• Worked extensively on FIX protocol to communicate with the end systems
• Created tables and developed stored procedures and views in Oracle
• Maintaining the backend with Oracle
• Created front-end GUI screens with VB.NET. The users could select the type of reports and their aging from these screens and generate reports and charts on the fly in MS Excel. The summary and the detailed reports were generated using Component One Reporting tool
• Developed scripts using Kornshell to download trade data on a daily basis and enhance and support existing PERL code
• Used Crontab for scheduling of reports
• Used DBI/DBD for Oracle connection from PERL
• Documented the entire data flow from the external systems into the reconciliation system
• Participated in extensive user meetings

Environment: PERL, DBI/DBD, PL/SQL, Oracle 8i, Shell, Component One Reports, VB.NET, Crontab, SQL LOADER, Apache, Windows 2000, HP UNIX.

Confidential

Sybase/Perl Developer

RESPONSIBILITIES:

• Worked in maintaining the entire backend in Noah with Sybase and in NoahsArk with Oracle
• Created tables and developed stored procedures on Sybase and Oracle
• Worked extensively on FIX protocol to communicate with the end systems
• Developed stored procedures in Sybase and Oracle to produce MS Excel based reports for traders and analysts and created Autosys jobs to format the same
• Involved in tuning the performance of the stored procedures and queries
• Used Autosys for batch scheduling
• Worked on bug fixing and supported the applications in production box
• Designed and developed many PERL scripts with extensive JavaScript for Message Parser and Message Converter
• Used DBI/DBD for Sybase connection from PERL
• Developed scripts using Kornshell for Date functions to enhance Perl scripts.
• Participated in extensive QA testing and user meetings.
• Worked extensively on Clearcase for version control.
• Created and ran the Autosys web method jobs for reconciliation of trades between Sybase and Oracle

Environment: TSQL, Oracle 9i/10g, PERL, Shell, DBI/DBD, JavaScript, AUTOSYS, Sybase 11.x/12.x, BCP, HTML, Apache, Windows 2000, HP UNIX, ClearCase.

Confidential

Perl/Sybase Developer

RESPONSIBILITIES:

• Created PERL scripts with JavaScript for enhancements
• Created PERL script for feed processing and feed pre-processing for loads
• Designed and developed PERL scripts for sending application based mails using SEND MAIL
• Developed tables, stored procedures and created Unix shell scripts for ad-hoc work
• Developed MS Excel based reports for traders and analysts using KSH and BCP
• Participated in testing and test case documentation
• Created CRON jobs as per requirement, maintained the existing scripts and administrated the CRON entries
• Designed and developed PERL scripts and used DBI/DBD for Sybase connection from PERL
• Worked on bug fixing and supported the production applications
• Participated in user meetings and requirement collection
• Worked extensively in Sybase performance tuning
• Created many ad-hoc queries on Sybase and ran with Unix Shell
• Took part in testing and quality assurance

Environment: TSQL, PERL, JavaScript, KSH, DBI/DBD, CRONTAB, Sybase 11.x/12.x, BCP, CGI, HTML, Apache, Windows 2k, HP UNIX

Confidential

Perl/Sybase Developer

RESPONSIBILITIES:

• Involved in creating data upload modules in PERL
• Created HTML pages for the reporting
• Wrote routines in PERL to update database from flat files and vice versa
• Created web pages with dynamic/custom reports
• Wrote stored procedures, triggers on Sybase
• Created indexes on Sybase tables for performance
• Took part in SQL and application tuning Designed and developed new PERL modules
• Developed PERL modules for the data handling from other applications
• Enhanced PERL modules with DBI routines for Sybase connection
• Worked extensively in supporting the application and bug fixing
• Worked in creating PERL/CGI scripts with JavaScript for supporting HTML reports with data
• Designed and developed tables and TSQL scripts for enhancements and maintenance of various database objects in Sybase
• Optimized queries for better performance in Sybase
• Developed business rules in Perl to gather records from other applications
• Created KORN Shell batches for data download and upload
• Used CRON TAB for the batch scheduling

Environment: PERL, CGI, HTML, KSH, Sybase 11.9.2, Windows 2000, Apache Web Server, Sun Solaris 2.x