Application Support Resume
NY
SUMMARY:
- A Software professional with over 8 years of extensive experience in system analysis, design, development, implementation, testing, maintenance and Support of software applications in financial domain.
- Experienced in all the phases of SDLC - Requirement Analysis, Design, Development, Implementation, and Post-Production
- Experience in developing Batch processes using PERL and Unix Shell Scripts
- Expertise in back end Application development and support using Oracle 9.x and 10.x
- Experience in Oracle PL/SQL
- Experience in Autosys and CronTab
- Expert in Version Control - SVN
- Experienced in Unit, Integration, Regression, UAT and Parallel testing
- Excellent analytical and verbal communication skills and good team player.
- Expert in coordinating the Production Releases and Disaster Recovery.
- Great customer support skills and adaptable to changing business needs
TECHNICAL SKILLS:
Operating Systems: Windows NT/2000, Red Hat Linux, Solaris 2.x
Programming Languages: C, C++, JAVA, PL/SQL, AWK, and SED
Scripting Languages: PERL, UNIX Shell (KSH)
Databases: Oracle
Development Tools: Toad
Data Modeling: Erwin 4.x
Networking: TCP/IP, OSI, LAN, WAN
Internet Technologies: CGI, HTML, XML, JavaScript
Version Control: SVN
Office Applications: MS Office 97/2003(Excel, Word, PowerPoint)
Other Applications: Apache 3.0/4.0, CronTab, SendMail, Autosys, FTP
PROFESSIONAL EXPERIENCE
Confidential, NY
Application Support
Responsibilities:
- Reviewing and Approving the Release for TBS apps.
- Managing all Production Infrastructure environments.
- Performing health checkups for the application in the Start of day and End of day.
- Communicating with clients and client service representatives.
- Managing all the TBS applications and communicating with CSR if there are any Outages or Issues.
- Sending SIN (Service Impact Notice) for Outages, Issues and Missed SLA’s.
- Preparing RCA for all Issues on the same day to the Higher Management
- Weekly communication with Development teams about new changes in the application.
- Implemented proactive monitoring of production systems through managed objects.
- Coordinated several activities like Disaster Recovery, Power downs, Quarterly Maintenance, etc.
- Working closely with offshore Support team in understanding various issues overnight during the batch.
- Developed scripts for preprocessing for new clients.
- Developed scripts to reconcile Street side and Client side trades.
- Designed and developed many Perl libraries for Preprocessors.
- Developed Perl Scripts to report Statistics of the application.
- Used Shell scripting to perform trade file validation.
- Developed scripts to extract Positions, Balances and Activities.
- Scheduled Batch jobs in Autosys.
- Monitoring the MQ queues for TBS application and making sure no trades are missing from the clients.
- Developed Run books for the application.
- Helping trade support for any production issues.
- Setting up new Clients for prime services.
- Setting up Rules for validating the client’s trade file.
- Creating new templates for incoming trade files for new clients.
Environment: PERL, Kshell, IBM MQ, Oracle 9/10/11g, Control M, DB Artisan 8.5.2, XML Web service, Sun Solaris 5.8, Windows XP.
Confidential, New York, NY
Developer / Support
Responsibilities:
- Involved in gathering requirements from the client and developing Software Requirements Specifications.
- Created Perl batches to monitor errors in data loading at particular frequency.
- Provided support while the HTML and JavaScript were integrated with server-side code.
- Created HTML forms and used Perl as CGI scripting language for online querying and reporting.
- Designed and developed many Perl modules
- Created many Unix Shell Scripts and enhanced the existing script
- Connected database via Perl DBI and DBD modules
- Created Perl script for feed processing and feed pre-processing for loads
- Designed and assisted in development of back end systems using the technologies
- Developed many Perl scripts for client side data processing
- Wrote various SQL queries for data manipulations
- Designed and developed Perl scripts for sending application based mails using SEND MAIL
- Wrote complex Oracle SQL queries to retrieve unique data sets using inner and outer joins
- Wrote Unix shell scripts to automate the start up and shut down of applications
- Wrote routines in Perl to update database from flat files and vice versa
- Created many Perl scripts for data format/validation checking
- Provided technical support on issues arise after deployment to Production
- Managed the transition of production support to offshore resources
Environment: Perl, CGI, DBI/DBD, JavaScript, HTML, CronTab, UNIX, KSH, PL/SQL, Oracle, SQL AIG, NY
Developer / Production Support
Confidential
Responsibilities:
- Developed and coded Perl scripts and DBI to generating reports.
- Provided application support for Production Engineering Operations, monitoring various Load feeds, data stage applications and database related operations.
- Developed many Perl modules for data handling from other applications.
- Involved in Infrastructure support to all DEV, QA, UAT, Production environments.
- Participated in backend support for all the applications involved in Risk Management.
- Designed and developed Perl/KSH scripts for various applications and executed through AUTOSYS job scheduler.
- Resolved various applications, scripts, data stage, database components related issues.
- Developed and maintained Perl CGI script files for content conversion.
- Wrote complex Oracle SQL using joins, sub queries and correlated sub queries.
- Designed and developed Data Delivery Architecture to maintain and control various external feeds comes to system using Perl, KSH scripts.
- Wrote customized UNIX shell scripts for additional monitoring of production servers.
- Implemented automated Success/Failure notification of production batch.
- Involved in deployment of various UNIX, Perl, Data stage, Fermat, COGNOS components in QA/UAT/PRODUCTION environments.
- Created Oracle Packages and Procedures in PL/SQL to populate data cubes based on User requirements.
- Responsible for maintaining all existing HTML and Perl DBI/DBD code.
- Worked on Clear Quest (CQ) for all deployments, ticket generation and follow up the flow of build process from DEV to PROD.
- Wrote Perl CGI scripts for text processing.
- Monitored the daily activities of the production support.
- Coordinate with data vendors to resolve any data related issues.
Environment: Perl, UNIX, KSH, Autosys 11.0, Oracle 11g, SQL Server2007, DBI, XML,Data Stage 8.1, FERMAT, Sun OS 5.10 Solaris
Confidential, CA
Software Engineer
Responsibilities:
- Developed a work flow set up automation tool that considerably reduces the work flow set up time leading to quick code deployments.
- Developed and documented Perl modules for interfacing with the message store.
- Interactively worked with development team and project manager to develop new features and functionalities, both back end scripts and web based scripts.
- Created packages extensively using Object Oriented Perl involving Oracle DB connections and functionality to call APIs.
- Developed data structures using hashes and arrays for data storage to handle huge data.
- Created Web based scripts using Perl-CGI module and worked extensively on SQL queries.
- Wrote Unix shell scripts for data back ups, and web site systems monitoring.
- Refract, revise and maintained existing code with some focus on improving security, performance, modularity and maintainability.
- Designed and implemented Perl application layer to integrate client-server applications, Oracle database, and user interface.
- Actively taken part into all phase of development life cycle including design, implementation, release, unit testing and maintenance of code versions using SVN.
- Developed Perl scripts to monitor the process schedulers.
- Helped in creation of carefully and clearly planned of specifications that address the entire user interface, business requirements and process flow.
- Wrote Perl/DBI script to parse logs and store in created database.
- Modified Unix shell scripts and Oracle SQL scripts to meet changing business needs.
- Developed database triggers, Perl scripting and Build automation.
- Worked closely with SCM team to test various functionalities of the tools and acquired various input for further improvements.
- Setting various monitors on CRON using Unix shell script, Perl script/CGI to make sure all the services are up and running.
- Worked with SCM team to help them set up new Work flows and providing support during releases.
Environment: PERL/CGI, Oracle 9/10/11g, SQL, PL/SQL, SVN, TOAD, ECLIPSELINUX, Sun OS 5.10 Solaris, XML, SQL*Loader, SQL*Plus, KSH
Confidential
Software Engineer
Responsibilities:
- Responsible for analyzing, designing and coding of Oracle DB applications using Perl.
- Designed and developed many Perl DBI modules and Interfaces.
- Provide recommendations and also implementation of the new tool kits, modules, standards, framework and processes with ability to guide other developers in these areas.
- Developed automated backup status reporting scripts in Perl.
- Deal with the technical problems and fixed the bugs in production scripts.
- Created Perl modules and packages for database connectivity for multiple applications.
- Developed monitoring scripts for web application and database services using Unix shell scripts.
- Designed and developed Perl CGI programs to collect, analyze, and data gathered from log file.
- Interactively worked with development team and project managers to develop new features and functionality, on both sides of back-end scripts and web based scripts.
- Wrote Perl scripts for data manipulation, retrieval and data handling.
- Maintained current versions of production scripts using SVN.
- Created batch scripts using Unix, KSH scripting and scheduled in Cron Tab.
- Refract, revise and maintain existing Perl codes with some focus on improving, security, performance, modularity, and maintainability.
- Designed and developed Environment validation tool for DBA team.
- Designed and implemented Perl application layer to integrate client-server applications, Oracle database, and user interface.
- Created a large number of Unix shell scripts to accommodate various automated processing needs for clients.
Environment: PERL, KSH, Oracle 9i/10g/11g, SQL, PL/SQL, Python, LINUX, Sun OS 5.10 Solaris, JSP, SVN, TOAD, SQL*Loader, SQL*Plus
