SUMMARY

• Strong hands - on experience of 8 years with large IT applications on requirement, analysis, coding, testing, implementation, maintenance and review
• Strong experience in Perl, Oracle, Unix programming
• Good experience in CGI programming using Perl
• Very strong programmer in OO PERL and Unix Shell scripting
• 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 JavaScript and HTML
• Well versed in languages like Java/J2EE with solid experience in the database side including Oracle PL/SQL database packages, procedures, functions, triggers and views to retrieve and manipulate complex data sets
• Good experience in PERL CGI and DBI/DBD programming to develop the application
• Experienced in distributed application design and development in Perl
• Have in-depth knowledge of Unix shell scripts, SQL, PL/SQL scripts in Oracle
• Well experienced in design and development of large-scale client-server systems 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++, HTML, XML, Java, Oracle SQL, Oracle PL/SQL

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

Scripting Languages: Perl, JavaScript, CSS, UNIX KornShell scripting

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

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

Web Server: Apache Web server, Weblogic, WebSphere

Others: Microsoft Office Suite

PROFESSIONAL EXPERIENCE

Mortgage Controlling System

Confidential, NYC, NY

Environment: JavaScript, HTML, Oracle, Sql, Java, SQL*Loader, SQL*Plus, PL/SQL, Perl, DBI/DBD, CGI, Unix, AutoSys

Responsibilities:

• Involved in the design, analysis and testing of the application
• Developed Perl scripts to fill in the gaps between technologies
• Used JavaScript (HTML), JSON and Web Services to proxy data in this web application with client-side behavior
• Responsible for scripting data manipulation using Perl in validation module
• Developed and helped performance tune several Oracle SQL packages, procedures, functions and triggers
• Well versed in Asynchronous programming in Java
• Managed complex information architectures and visualized the potential impact using Sybase PowerDesigner
• Developed Perl script which will write the session statistics such as rows loaded, rows rejected from session log file to a fixed width flat file
• Developed Perl/CGI form to easily build and maintain web files
• Wrote a Perl based backup system to perform network backups of all workstations and servers
• Created Spring Batch jobs for automation of products and validation of operation
• Wrote Unix shell scripts with SQL to unload and load data and change state information for databases
• Wrote many Java programs to do the data validation
• Developed a data-synchronization utility (Perl/Sybase) for big tables
• Worked in OO Perl extensively for data extraction
• Modified Perl DBI scripts for error handling
• Wrote Perl scripts to discover and document dependencies between tables in the database, establishing a table hierarchy
• Modified required Java codes and other SQL validation scripts and writing scripts to validate the outputs
• Used various object-oriented concepts such as Multithreading, exception handling, collection APIs to implement various features and enhancements
• created source code repository for tracking and versioning all SQL, Java, and UNIX shell scripts
• Used XML parsing techniques for data handling for JavaScript front-end pages
• Used Unix shell scripting using hash tables and array index listing for fast retrieval
• Developed and tuning of Perl code used in quantitative applications for risk management and trading
• Wrote Oracle procedures to convert Oracle data to flat file
• Automated numerous back-end processes written using OO Perl
• Used Perl for interfacing database using DBI/DBD
• Used Perl pdf module for conversion of files into pdf which will be accessible in reporting module
• Provided production support to various functional areas such as processing and operations
• Used Unix crontab for the purpose of scheduling jobs
• Preformed extensive Linux Systems automation through shell scripting
• Used Perl script to validate the flat files
• Wrote Oracle script to check the size of table spaces
• Created JavaScript pages in combination with XML/HTML
• Used Perl mail module to send email with attachments to different recipients designed for reporting module
• Wrote application in Perl DBI/CGI for data parsing and loading
• Used crypt module for encryption in Perl to crypt the passwords which is used in administrative module
• Created many OO Perl methods for data validation and format checking
• Developed HTML screens using Perl and JavaScript in administrative module for user preferences
• Responsible for 24x7 production database support, high availability, maintenance, monitoring and problem management

Online Trading for Fixed

Confidential, New York, NY

Environment: Perl, DBI/DBD, JavaScript, HTML, Java, Oracle 11g, SQL, PL/SQL, UNIX, AutoSys, Weblogic

Responsibilities:

• Reviewed the business and functional requirement documents and identified test scenarios
• Automated SQL tasks through Perl DBI for extraction in data extraction and loading module
• Developed Perl scripts to transform data and to drive execution of Oracle PL/SQL packages and procedures
• Coded Unix shell scripts to call SQL scripts and to manipulate the returned data
• Involved in creating data upload modules in Perl used in data extraction and upload module
• Generated SQL & PL/SQL scripts to install, create and drop trading exchange connection database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms
• Used JDBC/JConnect for oracle connectivity
• Developed and set up scheduling procedures for an automatic download from marketing data from Sybase to Access, and generating all downstream report
• Wrote XML/CGI programs in Perl to handle the inputs from the configuration screens
• Developed OO Perl scripts for access modification in production
• Created PERL script to make the connection to Oracle database using DBI/DBD module
• Designed system tools in Perl and shell script to automate and monitor application in administrative module
• Developed Oracle tables and PL/SQL packages, procedures and functions
• Supported the application during production hours
• Worked on XML/JSON Parsing technologies
• Developed scripting automation testing using Perl scripts and incorporated into in-house test tools
• Wrote Perl scripts to perform end of day processing and system maintenance used in administrative module
• Created OO Perl scripts to process the feeds
• Used Unix shell scripting using hash tables and array index listing for fast retrieval
• Developed CGI automation testing using Perl scripts and incorporated into in-house test tools
• Wrote Oracle script to check the size of table spaces
• Used crypt module for encryption in Perl to crypt the passwords which is used in administrative module
• Debugged database connectivity through JDBC from Java modules
• Developed web applications for configuration and generation of reports using Spring
• Send Perl mail module to send email with attachments to different recipients designed for reporting module
• Used Unix crontab for the purpose of scheduling jobs
• Used Perl pdf module for conversion of files into pdf which will be accessible in reporting module
• Worked with Production Support team to immediately resolve failures to production data processing

Global Logistics System

Confidential

Environment: Oracle 10g, SQL, PL/SQL, Perl, DBI/DBD, JavaScript, HTML, Unix, AutoSys

Responsibilities:

• Analyzed, developed, documented, and validated product for the application, against the use case and business requirements documents as part of the SDLC activity
• Created several Perl scripts for front end support
• Developed Oracle PL/SQL processes for data extraction and loading which is used in inventory management module
• Created front end using CGI, XML and JavaScript
• Developed Perl scripts to implement the designed functional components like different kind of searches used in inventory management module
• Designed, developed and modified OO Perl scripts using the package & modules
• Wrote Unix shell script to automate the verification of the information inserted in the database via the application which is used in inventory management module for verification
• Wrote routines in Perl to update database from flat files and vice versa implemented in inventory management module
• Wrote application in Perl DBI for data parsing and loading used in reports module
• Maintained the system, wrote scripts in Oracle SQL to monitor batch processing to get early warnings, in case of wrong data processing used in inventory management module
• Used Perl mail module to send email with attachments to different recipients designed for reporting module
• Worked with Unix commands to check and match the output manually
• Created Perl scripts for data format/validation checking
• Utilized PC and desktop applications to support change management and production operations support used in administrative module
• Worked in data handling module using OO Perl and SQL
• Used crypt module for encryption in Perl to crypt the passwords which is used in administrative module
• Updated database using DBI/DBD from PERL
• Created Unix shell scripting in KSH to schedule jobs using Crontab
• Used SQL*Loader to export and import data used in inventory management module
• Used Perl pdf module for conversion of files into pdf which will be accessible in reporting module
• Developed Oracle PL/SQL stored procedures, functions, packages and SQL scripts to facilitate the functionality for existing module
• Maintained multiple levels of support for all the system batch processing
• Provided production support to various functional areas such as processing and operations

Wholesale Distribution System

Confidential

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

Responsibilities:

• Implemented security solution for section servers (SSH, Web and Standard OS tools) used in administration module
• Created Perl batches to monitor errors in data loading at particular frequency used in inventory management module
• Created Unix shell scripts for ad-hoc work
• Connected Oracle server from Perl using DBI/DBD
• Managed and supported the outages during urgency
• Supported compliance to all regulatory and audit requirements in reports module
• Created Perl script for feed processing of loads in inventory management module
• Wrote awk/sed scripts to generate the code for user interface and pattern matching
• Designed and developed customized Oracle PL/SQL client/server environment in sales module
• Developed Perl scripts for server side data processing
• Implemented dynamic SQL procedures to communicate with database backend
• Used TOAD to populate tables, and to write procedures describing data entry in to tables/views
• Developed scripting automation testing using Perl scripts and incorporated into in-house test tools
• Created and modified SQL*Plus procedures to capture data
• Created batch jobs using Unix shell scripts and Perl scripts to process database activities
• Wrote Unix utilities to support environment for security compliant used in financial module
• Developed Perl scripts to implement the designed functional components like different kind of searches used in sales modules
• Developed scripts with Perl, SQL, and Oracle PL/SQL to support development, testing, and production support activities
• Utilized PC and desktop applications to support change management and production operations support used in administrative module