SUMMARY

• Strong hands - on experience of 8+ years with large IT applications on requirement, analysis, coding, testing, implementation, maintenance and review
• Well experience in Perl programming using JavaScript and HTML
• Strong experience in Perl, Oracle, Unix programming
• Good experience in Perl OOP, Perl Mod Perl, & DBI
• Strong command over web standards, cross-browser compatibility and various web-related optimization techniques and content management systems using DBI/DBD programming in Perl using HTML
• Good experience in ASP.NET, C, & C++
• Well-versed in Perl and HTML/JavaScript based web applications
• Have in-depth knowledge of Unix shell scripts, SQL, PL/SQL scripts in Oracle
• Proficient in server-side programming and debugging using Perl
• Possessing strong hands-on background in supporting production environments and meeting customers needs
• Possessing exceptional technical and analytical skills with strong business knowledge

TECHNICAL SKILLS

Languages & Web Development: C, C++, MATLAB, HTML, XML, Oracle SQL, Oracle PL/SQL

Operating Systems: Solaris, Windows, Linux, Mac, UNIX

Scripting Languages: Perl, CSS, UNIX KornShell scripting

Databases: Oracle 10g/11g, Sybase, MS SQL Server, MySQL

Tools: SQL* PLUS, SQL * Loader, CronTab, DBI/DBD, Erwin, FTP

Web Server: Apache Web server

Others: Microsoft Office Suite

PROFESSIONAL EXPERIENCE

Fixed Income Trade Analysis

Confidential, New York, NY

Environment: Perl, DBI/DBD, HTML, CronTab, C, C++, Unix, PL/SQL, Oracle, SQL, SQL*Loader, SQL*Plus

Responsibilities:

• Used DBI/DBD for connection between Oracle and Perl
• Wrote PL/SQL,SQL scripts to retrieve data from Oracle database
• Developed Perl scripts to fill in the gap between responsibilities
• Used unix to schedule a job for sending reports
• Developed, implement, and maintain an asynchronous, AJAX based rich client for improved customer experience
• Designed and built sites for clients and self, utilizing CSS, HTML, JavaScript, & MySQL
• Developed OO Perl and JavaScript for database access over the web
• Participated in application support both monitoring and troubleshooting support
• Used data structures and algorithms to optimize the code in C++
• Created batch status reports using ASP.NET and KSH script
• Collaborated with clients, product management as well as (UI) User Interface team
• Created generic shell scripts to FTP and purge data extracts
• Created mod Perl CGI scripts & modules interfacing with Oracle
• Implemented automated product build and packaging process for both Windows and Linux
• Provided multiple enhancement and bug fixes to Perl module
• Designed data schema for Oracle and XML data definitions (DTD) for HTTP web service calls between computers in the system
• Involved in Performance tuning of the programs and ETL processes
• Used Perl CGI and DBI code to processed stock codes with implementing rules
• Integrated data and business logic using HTML /JavaScript CSS
• Used PL/SQL, SQL procedures to audit user activity and log the same
• Did inheritance and operator overloading with C
• Automated builds for both Unix and Windows Clear Case regions using Perl and bash shell scripting
• Wrote Oracle procedures to convert flat file to PDF and XML format
• Designed and implemented a dynamic image rendering web service which is consumed by PHP, JavaScript
• Responsible for creating user interface (UI) standards, front end templates and screen prototypes
• Developed and tuning of Perl code to be used in quantitative analysis
• Involved in data and process modeling, standards development, meta-data management, SDLC & methodology
• Used Rational Rose for all UML modeling
• Assisted in setting up and tuning Apache web server
• Made minor edits to HTML pages using the VI editor on a Unix server
• Debugged and wrote error trap routines in Unix Korn Shell
• Used PL/SQL, SQL procedures to set alert based on volume, price and user activity
• Used Perl scripts to check data availability
• Documented pre-compliance monitoring rules for MySQL database. Created database objects using MySQL
• Web developer using Perl, Mod Perl, CGI, JavaScript on a clustered UNIX Solaris web server platform
• Wrote Oracle procedures to convert Oracle data to flat file
• Used Data Stage Designer for developing various ETL jobs to extract, cleansing, transforming, integrating and loading data
• Developed and maintained functional testing automation support on both Windows and Linux
• Used Perl script to archive old data
• Designed interactive and live web pages using Ajax, JSP and JavaScript, and Servlets
• Wrote OO Perl based CVS deploy scripts
• Utilized communications manager/server, HTTP for interfacing to legacy systems
• Expert in C++, C, numerous scripting languages, and the Unix/Linux multi-threaded environment
• Developed the application in ASP.Net also involved in documentation and producing reports
• Wrote Unix shell scripts to automate verification of database information via web application
• Used Perl script to log step by step parsing
• Provided hands-on support as a backup for the production technicians
• Used Perl script to create various formats like PDF,XML
• Involved in the Maintenance releases to support the production environment

Mortgage Backed Securities System

Confidential, New York, NY

Environment: Oracle 11g, SQL, Perl, DBI/DBD, HTML, C,C++, CronTab, Unix, PL/SQL, Weblogic

Responsibilities:

• Reviewed the business and functional requirement documents and identified test scenarios
• Involved in creating data upload modules in Perl
• Developed Unix shell scripts and set up Cron jobs for monitoring the database
• Automated SQL tasks through Perl CGI/DBI
• Wrote Perl CGI and DBI scripts to perform end of day processing and system maintenance
• Prepared UML Class diagrams, Sequence diagrams and State diagrams using Rational Rose
• Design and develop interactive HTML/JavaScript/CSS prototypes to present a proof of concept for new business requirements
• Worked in Unix environment using VI editor, compiler and Unix debugger
• Worked with business acceptance team to refine user interface(UI)
• Involved in HTTP development and developed web reports using HTTP
• Re factored code interfacing with custom debugger back-end in order to support Linux
• Configured database connectivity from Apache server
• Wrote Perl, Mod Perl and SQL scripts to update databases from feeds for Equities, Bonds, Mortgage Back Securities, and Listed Derivatives data
• Utilized Oracle PL/SQL to perform troubleshooting while assisting client services
• Created many OO PERL/CGI reports
• Developed HTML, JavaScript, XML, XHTML, CSS, XSL, XSLT web pages
• Did function overloading with C
• Worked on architecture and development of an ASP.NET application framework
• Wrote SQL*queries to access data from Oracle database
• Involved in writing shell scripts on Unix for Informatica ETL tool to run the sessions
• Worked in Shell scripting (ksh and bash) both on Solaris and Linux for performing tasks related to packaging & deployment of software
• Developed numerous scripts in Perl and PHP to automate or simplify various system administration functions, such as monitoring of critical services, and reporting of web service, mail server, and other network activity
• Designed and implemented a Perl script to retrieve files from FTP server
• Managed the workflow process using SDLC methodology and Iterations
• Designed user interface(UI) web pages so as to configure the promotion based any amount of recharge
• Worked in Perl programming and DBD/DBI to connect Oracle and fetch data for presentation
• Coded Unix shell script to call SQL scripts and to maintain the returned data
• Created website and MySQL database prototype
• Creates scripts to SFTP/SCP files from one server to another server
• Developed Perl scripts to transform data and drive execution of Oracle PL/SQL Packages and procedures
• Generated SQL,PL/SQL scripts to install, create and drop trading exchange connection database including tables, views, primary keys indexes etc
• Created mockups using HTML, JavaScript, and CSS
• Implemented the ETL process and business logic by using SQL
• Support Linux adoption strategy by providing Linux-specific build, packaging, and automated testing support and ensuring product compatibility on Linux platforms
• Programmed Perl security checking script and performed security and reliability of the application
• Developed Oracle tables and PL/SQL Procedures and functions
• Developed and tuned of OO Perl code used in quantitative applications for risk management and trading
• Designed and implemented distributed objects in C++
• Created cross-browser compatibility and various web-related optimization techniques using HTML, JavaScript, XML, XHTML and CSS
• Used AJAX Extensions and AJAX Controls Toolkit to improve performance
• Involved in application layer based on C# ASP.NET to manage and control application
• Developed and maintained Perl script files for content conversion
• Created many PERL CGI and DBI/Mod Perl/KSH batches and scheduled them for the batch application
• Wrote a Unix shell script for file extraction and loading
• Automated SQL tasks through Perl DBI
• Developed of code- and system-level documentation for a large, Perl-based application
• Supported the application during production hours
• Worked with production support team to immediately resolve failures to production data processing

Confidential

Environment: CronTab, Unix, C,C++, PL/SQL, Oracle, SQL, Perl, DBI/DBD, HTML

Responsibilities:

• Analyzed, developed, documented and validated product for the application against the use case and business requirements as part of the SDLC activity
• Created several Perl scripts for front end support
• Developed Oracle PL/SQL process for data extraction and loading
• Built web service tools using PHP and Perl
• Created Javascript pages in combination with XML/HTML
• Established Secure HTTP connection to the IIS web server
• Developed Perl scripts to implement the designed functional components like different kinds of searches
• Developed and maintained Unix/Linux shell scripts for data extraction and manipulation
• Conducted requirements analysis, UI design, data modeling, database design, stored procedure design
• Developed numerous Perl CGI and DBI scripts to validate file line by line against various compliance rules
• Developed and helped performance tune several Oracle packages, procedures, functions and triggers
• Wrote routines in Perl to update database from flat files and vice versa
• Wrote C++ HTML, JavaScript and CSS interfaces to extract and analyze experimental data from database
• Wrote application in Perl CGI/DBI for data parsing and loading
• Participated in installation, configuration and troubleshooting of web servers like Apache Tomcat and Weblogic in a complex business application
• Implement Javascript based encryption for NON-SSL AJAX requests
• Created a OO Perl client interface for international trade web services server
• Checked availability of allowed email addresses using a central MySQL database
• Wrote SQL scripts to debugged ETL process
• Developed ASP.NET tools to improve efficiency and accuracy of employee effort
• Worked with Unix/Linux commands to check and match the output manually
• Used various Perl/XML modules for generating reports
• Responsible for the design and development of an object oriented reporting tool and an associated code generator using C
• Maintained the system, wrote scripts in Oracle SQL to monitor batch processing to get early warnings
• Developed many Perl CGI and DBI scripts for data parsing, manipulation and updating
• Designed and developed many Perl modules
• Created Unix/Linux shell scripts to perform transfer of data to clients
• Created Perl batches to monitor errors in data loading at particular frequency
• Maintained multiple levels of support for all the system batch processing
• Used SQL *loader to export and import data to and from files
• Maintained multiple levels of support for all system batch processing

Web Based Accounting System

Confidential

Environment: HTML, CronTab, Unix, PL/SQL, Oracle, SQL, Perl, DBI/DBD

Responsibilities:

• Worked with Perl file handling to generate various error logs and log files
• Created Perl scripts to monitor error in data loading at particular frequency
• Developed and maintained Unix shell scripts for data extraction and manipulation
• Created Perl scripts to feed processing for loads
• Connected Oracle server from Perl DBI/DBD
• Responsible for performance tuning of Oracle SQL queries using the parallel query feature
• Created many PL/SQL/Perl scripts for data archiving and data movement
• Developed Perl scripts for server side data processing
• Coded Unix shell scripts to call SQL scripts and to manipulate the data
• Developed Perl scripts and Oracle PL/SQL to support development testing
• Prepared many Perl scripts for server side data processing
• Designed and customized Oracle PL/SQL procedures, functions and triggers
• Created batch jobs using Unix shell scripts and perl scripts to process database activities
• Managed and supported outages during urgency