SUMMARY

• 8+ years of experience in the areas of analyzing, application programming, system design, development and testing of business applications
• Experience in all phases of implementation including requirements gathering, design, development and Production support
• Good experience in creating web application using C#.net, HTML and JavaScript
• Strong experience in designing and developing many Perl modules
• Experience in operational 24x7 Production support, best practice trouble shooting, monitoring, capacity planning and maintenance
• Strong hands on experience in Unix Shell Scripts for automated testing
• Good experience in L1 and L2 support
• Strong experience in design and development of applications involving Perl, Oracle and Unix Shell Scripting
• Experience in analysis, design, development, Production Support and maintenance of financial applications
• Experience in Oracle relational database modeling, SQL and PL/SQL
• Experience in analysis, design, development, documentation & production support applications using web and client/server technologies
• Strong commitment towards quality, experience in ensuring compliance to coding standards and review process
• Possessed strong hands - on background in supporting production environments and meeting customers’ needs
• Excellent analytical, communication skills and good team spirit

TECHNICAL SKILLS

Languages: Perl, JavaScript, HTML, C#.net, SQL, PL/SQL

Operating System: UNIX, Windows, Solaris, Linux

Databases: Oracle, Sybase, MS SQL Server, MySQL

Web Servers: Web logic, Apache Web server, WebSphere

Tools: /IDE: Visual Studio 2010 (.Net Framework 3.5/4.0)Cron Tab, DBI/DBD, ERWin, SQL*Plus, SQL*Loader

PROFESSIONAL EXPERIENCE

L2 production support

Confidential, New York, NY

Responsibilities:

• Used Perl scripts to load & unload data during the ETL process in Data ETL module
• Provided production support to various functional areas (processing, database, security, operations, etc.)
• Created interfaces for analytical charts using HTML and Java scripts
• Provided various Unix scripts for the effective monitoring of index and table space usage
• Used R language to convert data into graphs for analyzing purpose
• Coordinated with production support processes of escalation and resolution of major service issues
• Developed and tested Oracle, PL/SQL stored procedures, functions, triggers while managing the Transaction module
• Provided third level support for batch scheduling issues
• Created many batch scripts to view custom reports using UNIX & scheduled jobs using CRONTAB tool
• Developed and enhanced the HTML based report pages for Equities, Derivatives, Mutual funds and Fixed Income modules and Investment Banking side modules
• Have worked in leading a production support team for the developing application
• Provided L2 supported the system administration team with security of the networks and backups
• Developed and updated Autosys scripts to automate server monitor
• Created VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries
• Wrote stored procedures to set security policies & report preferences
• Designed and programmed applications and utilities using C++, Perl, and shell scripting for Linux operating systems
• Supported the application during production hours
• Provided L1 support to the users for general purpose
• Used Autosys, Perl and Shell Scripts to schedule automated file and data processing jobs
• Developed Perl script to write session statistics during transactions
• Tested Perl code with Pricing and market data feeding modules
• Used XML parsing techniques to handle the data.
• Involved in debugging P&L reports and General Ledger reports
• Created tables and performed data driven test to retrieve items from database in XML format using Oracle & SQL*LOADER during ETL
• Co-ordinate with L2 technical support staff as well as co-ordination with vendor engineers
• Provided on-call production support for several ecommerce applications
• Created Perl scripts for data format and validation checking in Data ETL module
• Supported and implemented an automated batch scheduling system
• Provided technical support on issues that arise after deployment to production.
• Wrote customized Unix scripts to provide additional monitoring of production servers
• Worked on performance tuning of disclosures using Oracle, PL/SQL packages, functions and triggers
• Developed and enhanced the HTML based report pages for Equities and Investment Banking side modules
• Wrote Unix / Linux shell scripts and Perl scripts to automate manual processes
• Investigated data integrity issues in SQL that were escalated beyond L1 support
• Developed web applications to view current market price information using c# in front end
• Provided password encryption in c# for making the account secure
• Participated in Production support, both monitoring and troubleshooting support
• Developed the UI for transaction module using CSS and JavaScript
• Used Transactions in C# for secure processing the orders placed by the traders
• Provided 24x7 support and debugged production issues
• Provided user support, training and troubleshooting

Environment: Perl, Oracle, DBI/DBD, Cron Tab, C#.net, HTML, Javascript, PL/SQL, SQL, SQL Loader and SQL Plus

L2 production support

Confidential, NYC, NY

Responsibilities:

• Wrote applications in Perl DBI for data parsing and loading from XML files
• Ensured effective and timely resolution and communications to the user during the production support
• Used Oracle, PL/SQL stored procedures and Perl to create inter account transaction system wrote PL/SQL stored procedures to access historical information
• Managed P&L, increasing corporate revenues and leading cost-effective initiatives
• Provided production support by documenting tickets and communicating with customer and vendor
• Wrote Unix shell scripts to automate the verification of the information inserted in the Database
• Implemented procedures to install and deploy large numbers of Linux / Unix servers
• Used Java script and CSS, contributed in making the UI more interactive
• Programmed VBA applications on Excel to fill the Data Tables
• Created Crystal reports in C# for report viewing by managers
• Provided multi-media L2 support for conference rooms and staff meetings such as projectors, video-conferencing, Live Meeting, Go To Meeting sessions and conference calls
• Supported transactional on workout, restructuring, acquisition and new business opportunities of Investment Banking
• Maintained multiple levels of support for all systems batch processing
• Collaborated on the development of a high-level transition plan to re-platform OFF in a UNIX/Linux environment
• Worked with PERL programmers to implement XML/XSLT processing.
• Planned and implemented remote sites hardware and software upgrade, back office connectivity support and desktop/L1 support to end users
• Enhanced alert modules on trading, pricing and market data for reporting
• Web-services in C#.net were created for property evaluation, account balance calculation, tax escrow calculation etc
• To facilitate the ticket generation for every application which helps in tracking of the application status, created triggers in Oracle
• Designed, developed and tested several AutoSys scheduled job scripts and UNIX shell script
• Worked on bug fixing and supported the production
• Tracked production issues and provided production support
• Documented processes and procedures for L1 support staff and provide appropriate knowledge transfer
• Developed and enhanced reports pages for Trade Equities and Investment Banking side modules
• Developed unix development structure as well as developed unix shell programs for nightly batch support
• Developed code to generate PDF for printing and emailing purpose for customers to view the current status of application
• Build custom commercial and system applications, and servers for Linux
• Provided guidance to more employees within L2 Enterprise Applications Production Support
• Supported the production issue to ensure system availability
• Used regular expression validates on server side in c# to validate crucial data. I also contributed during developing UNIX shell scripts for job scheduling of mailing reports using crontab tool
• Provided automated scripts for production support staff for application support
• Provided PERL programming solutions for requested tasks
• Worked on bug fixing and supporting the production
• Maintained multiple levels of support for all the system batch processing
• Created error handler module in order to handle any exceptions during run-time and maintained logs
• Provided 24x7 support during application deployment

Environment: Perl, DBI/DBD, HTML, Javascript, Cron Tab, Unix, C#.net, Oracle, PL/SQL, SQL, SQL*Loader, SQLPLUS

Production support

Confidential

Responsibilities:

• Developed Perl scripts for data validation of data
• Discussed all production support aspects with application development management
• Developed UI with HTML, CSS for various types of request forms
• Created PL/SQL stored procedures, functions and triggers to facilitate various transactions
• Created tables and views in SQL for CRM functionality
• Developed and tested Oracle PL/SQL procedures, functions and triggers.
• Supported on monitoring applications to ensure availability and response times are within the targeted thresholds
• Monitored and provided production support to workflows and provide expert knowledge on all workflow designs
• Wrote UNIX shell script for scheduling alerts to customers and mailing subscribed reports
• Supported and deployed application in test and production environments
• Developed Perl scripts for server side data processing
• Used XSL and XSLT for presenting XML files.
• Administered, supported and Implemented all new systems and ensure transition of plans to production
• Created interfaces for analytical charts and graphs using HTML and JavaScript
• Monitored the daily activities of the production support
• Designed and developed customized Oracle PL/SQL client/server environment.
• Developed search and tracking features for policies and claims using C#.net
• Developed several stored procedures and used transactions for securing the payments of policies
• Created Unix shell scripts for ad-hoc work
• Created reports in pdf format in C#.net for mailing reports to customers
• Provided production support and maintained data
• Managed and supported the outages and during urgency
• CRM can save the reports in excel or pdf format as well
• Provided technical support for modules in case of urgency

Environment: Perl, DBI/ DBD, HTML, C#.net, Javascript, Cron Tab, UNIX, Oracle, PL/ SQL and SQL

Confidential

Responsibilities:

• Created Perl batches to monitor errors in data loading at particular frequency
• Analyzed production support related issues, inquiries and requests
• Created Perl script for feed processing for loads.
• Responsible for performance tuning of Oracle SQL*queries using the parallel query feature, indexes, and processor hints.
• Supported on monitoring applications to ensure availability and response times are within the targeted thresholds
• Connected Oracle server from Perl using DBI/DBD
• Provided user manual for application troubleshooting for production support
• Wrote Unix utilities to support environment for security compliant, fix data etc...
• Developed scripts with Perl, SQL, and Oracle PL/SQL to support development, testing, and production support activities.
• Provided user manual for application troubleshooting for production support
• Created batch jobs using Unix shell scripts and Perl scripts to process database activities.
• Supported compliance to all regulatory and audit requirements.
• Implemented dynamic SQL procedures to communicate with database backend
• Created and modified SQL*Plus procedures to capture data

Environment: Perl, DBI/ DBD, HTML, C#.net, Javascript, Cron Tab, UNIX, Oracle, PL/ SQL and SQL