SUMMARY

• Over 8+ years of experience in software development life cycle and comprehensive understanding of software testing methodologies and tools
• Strong experience in Perl, Oracle and Unix shell Scripting
• Well experienced in design and development of large - scale client-server systems using Perl CGI
• Strong Knowledge of SQL and PL/SQL object types, Oracle parallel queries, materialized views, bulk collects and collections
• Well experience in Perl programming using JavaScript and HTML
• Good experience with creating Unix shell scripts to automate validation process, saving of log files, and other tasks
• Good Experience in distributed application design and development in Perl
• Strong in DBI DBD programming in Perl using JavaScript and HTML
• Experience in operational 24x7 support, best practice trouble shooting, monitoring, capacity planning and maintenance
• Solid experience in Perl programming using JavaScript and Html
• Excellent written and verbal communication skills
• Good understanding of project management disciplines

TECHNICAL SKILLS

Languages: Perl, C, C++, Unix Shell (KSH), Javascript, CGI, DBI/DBD, HTML, SQL, PLSQL

Operating Systems: Windows, Sun Solaris, Linux, HP Unix

Databases: Oracle, Sybase, MS Access, MySQL, MS SQL Server

Web Servers: Weblogic, Apache, Tomcat

Tools: ERWin, CronTab, Autosys, SQL * Loader, SQL*Plus

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Web developer /Perl Developer

Environment: SQL, PL/SQL, Oracle, DBI/DBD, UNIX, PERL CGI, HTML, JAVASCRIPT, CSS, CRONTAB, MSOFFICE, R, TIBCO SPOTFIRE, JDBC

Responsibilities:

• I have worked on performance tuning of SQL, Oracle PL/SQL and analyzed table in import module to maintain efficient high transaction processing system
• Wrote Perl scripts to pull event log from all financial servers and put them into central database
• I have develop UNIX shell script to Cron jobs for monitoring the database
• I have also developed several PERL modules to handle data from other applications in report module for portfolio analysis
• Developed HTML screen using Perl and Javascript.
• Apart from it, in process report of report module i have used CRONTAB to schedule daily based report
• Crated KSH/PERL scripts to load inbound data from the mainframe to Teradata DB
• I was also Involved in gathering software requirements and specification
• I Have Created UNIX batch scripts for data loading and data file extraction in import and report module
• I have Develop PERL script to monitor the process handler
• Also, I have worked with users for data analysis and support
• Created HTML forms and used Perl scripting language for online querying and reporting
• Developed Database triggers and stored procedure using Oracle SQL, PL/SQL cursors and tables
• Maintaining complete documentation of trading module, system maintenance requirements
• Also I Created a PERL script to work to Oracle database
• Developed SQL query on the back-end to process customer inquiry in inquiry module
• I have Debugged and wrote error trap routines in UNIX KORN Shell
• Wrote Perl programming to error check the data and import it into the Oracle database
• Developed Web page using HTML, CSS, JAVASCRIPT in client interaction module to for providing all the company information in an interactive way
• Used Perl, DBI/DBD for Oracle connection
• Developed Web Pages using HTML, CSS, Javascript for displaying companies information in an interactive way
• Wrote numerous Shell and Perl scripts to automate various tasks
• Maintained complete documentation of Report and Computational Module of Portfolio, transaction, return on investment, sub-brokers and investors
• Implemented UI design using HTML and CSS
• Create new Perl scripts or modify existing Perl scripts as per requirements
• Provided support for job scheduling, file transfers, and transactional processes

Confidential, New York, NY

Web developer / Perl Developer

Environment: Perl, DBI/DBD, HTML, SQL, Oracle, UNIX, Cron Tab, PL/SQL, SQL*Loader, JAVASCRIPT

Responsibilities:

• Analyzed, developed, documented and validated product for the application, against the use case and business requirements documents as part of the SDLC activity
• Developed HTML screens using PERL and JavaScript in administrator module for user preferences
• Created UNIX batch scripts for data file extraction and scheduled jobs using Crontab in extraction and loading module
• Wrote PERL, shell, expect scripts to automate daily processes like archive log, data file, table spaces, control files in Data Extraction and Loading module
• Developed PERL scripts to modify and convert text files
• Created tables and performed data driven test to retrieve items from the database using SQL for loading data from news feeds
• Fixed software bugs via Javascript and CSS
• Developed Perl script which will write the session statistics such as rows loaded, rows rejected from session
• Created Perl scripts for data format/validation checking
• Developed packages by using PL/SQL for automate the transactions in Oracle tables
• Scripted in PL/SQL and SQL to migrate and manage databases
• Involved in programming in Perl to handle input from HTML forms
• Worked on development and maintenance of SQL code embedded in PL/SQL
• Used Unix shell scripting using hash tables and array index listing for fast retrieval
• Generated PL/SQL and shell scripts for scheduling periodic load processes
• Wrote packages using PL/SQL to access data from the database and write into and extract from flat files using SQL* LOADER utility
• Fixed many shell scripts for issues related to batch uploading
• Developed and tested Oracle PL/SQL procedures, functions and triggers for loading and updating the data feeds into tables
• Created Unix Scripts for sequential execution of Perl scripts including file archiving, transformation and backup
• Created many batch scripts using Unix scripting and scheduled in Cron Tab
• Managed and supported the outages during urgency
• Wrote many Perl/CGI modules for upload, download and presentation of the documents
• Provided on-call after hours application support for 24 x 7 help desk

Confidential

Programmer Analyst

Environment: Oracle, SQL, PL/SQL, JAVA, JAVASCRIPT, HTML, CSS

Responsibilities:

• Developed PL/SQL routines to extract data or document from other sources and load it into the central repository database
• Involved in Perl based database work using DBI/DBD
• Implemented Indexes in indexing module to index all the incoming document(physical or electronic) using Oracle PL/SQL
• Created web programming using Perl and CGI Scripting
• Creating back end modules for order processing using Unix shell scripts
• Designed system tools in PERL and shell script to automate and monitor application in administrator module
• Implemented PL/SQL bubble sort algorithm in sorting module to sort the content and send it to the archive database system
• Developed a distributed network testing and data collection system using Linux and Perl
• Update and maintain web server in Unix environment
• Used JavaScript API in HTML5 to work on the system in offline mode also
• Prepared many Perl scripts for server side data processing
• Developed PL/SQL routines to extract data from other database and load it into the Oracle database
• Used DBI/DBD for Oracle connection from PERL in Data Extraction and Loading module
• Developed Unix KSH scripts allowed users to perform database tasks
• I have also used java to support and download of electronic files to load files into the archive, retrieve files from the achieve and spread the document across the archive structure
• Designed and maintained customized Internet applications using Perl
• Created RDBMS and Achieve using sql, pl/sql
• Used Oracle Application server 4.0 to manage interaction between modules and users
• Created many Perl programs for the data upload and download
• Used PL/SQL stored procedure and trigger to update Achieve Database in Archive database
• Supported compliance to all regulatory and audit requirements

Confidential

Software Engineer

Environment: s: Perl, DBI/DBD, SQL, PL/SQL, UNIX, HTML, JavaScript, Cron tab, CGI, KSH

Responsibilities:

• Responsible for gathering and documentation of new business rules
• Prepared reports using Perl, Stored Procedures with DBI/DBD
• Maintained, troubleshooted and enhanced the existing Oracle PL/SQL code library
• I have Designed and implemented automated chain process using Perl CGI
• Created Unix shell scripts to perform transfer data to multiple systems
• Developed Perl Scripts to automated backup status reports
• Developed Cron job and Unix shell scripts for monitoring web application
• Designed and developed Perl scripts for sending application based mails using Send Mail
• Created Perl interface scripts for data conversion
• Developed Oracle PL/SQL triggers to work with Workflow design
• Wrote Perl CGI scripts for and text processing
• Involved in the Maintenance releases to support the production environment
• Created Perl, scripts that accessed data from Oracle database utilizing SQL
• Responsible for 24x7, on-call support for all issues affecting Production