SUMMARY

• 8 years of experience as Application/Production Support Analyst.
• Strong experience in financial industry.
• Extensively experienced in UNIX Shell Scripting.
• Excellent scripting abilities for automating various tasks.
• Managing filesystem usage, disk quotas on UNIX servers.
• Strong experience in RDBMS and Client/Server Technology.
• Advanced experience in SQL, PL/SQL, T - SQL, Oracle, Sybase and MS SQL Server databases.
• Expertise in writing SQL Queries, Stored Procedures, Views, Indexes, Triggers.
• Working knowledge of PERL programming.
• Knowledge of HTML/DHTML, CSS (Style Sheets), JavaScript.
• Experience working with BMC Remedy Change/Incident Management system.
• Flourished in both independent and collaborative work environments with quick learning abilities and excellent communication skills, problem solving skills, presentation skills.
• Proficient in learning new technologies and quickly adapting to new environment.

TECHNICAL SKILLS

Operating System: UNIX, AIX, LINUX, Windows NT 4.0, Windows 98/2000/XP

Languages: Shell Scripting, PERL, PL/SQL, T-SQL, C, C++, C#

Web Technologies: CGI, ASP.NET2.0, ASP 3.0, HTML, XML, CSS

Databases: Oracle8/9i,10g, Sybase, DB2, SQL Server

Tools: SQL Developer, BMC Remedy, HP Load Runner, HP Quality Center 10.0

Version Control Tools: CVS, Rational Clear Case, MS Visual Source Safe, Harvest CM 7.1

Technology / Concepts: OOPS (Object Oriented Programming), OOAD, UML

Servers (Application/Web/Transaction): Apache, IIS 6.0, Tomcat 5.0, Web Logic

PROFESSIONAL EXPERIENCE

Confidential, IA

Application Support Analyst

Responsibilities:

• Worked together with business analysts to gather requirements, design and implement new processes and up-gradation to existing processes.
• Responsible for creating shell scripts to provide automatic updates of market data (daily).
• Responsible for creating scripts to provide historical time series.
• Automated Monthly and Historical data pull to avoid manual intervention.
• Made enhancements to the existing Shell/Perl scripts.
• Created scripts to check the health of the application.
• Created scripts to check the disk usage, archive files on a monthly basis.
• Created script to automate the transfer of files between local server and Bloomberg FTP server.
• Worked with Network team to troubleshoot ftp connection issues.
• Tuned queries for better performance and faster data retrieval of the BB tickers.
• Created Change/Incident/EC tickets based on the requests and the severity of the issue using BMC Remedy.
• Responsible for documenting all the processes and setup procedures on the WIKI.
• Involved in User meetings, documenting UAT activity and testing.

Environment: Linux, Oracle 10g, SQL*PLUS, Perl 5.8.9, Windows 2000, Remedy, Control-M

Confidential, DE

Risk Execution Analyst

Responsibilities:

• Developed UNIX scripts to tag the High Risk customers, Inactive Accounts for CLD and Closure.
• Developed UNIX scripts to load the data from flat files to database.
• Worked on oracle hints to improve the performance.
• Worked on Balance Transfers, Auto Charge Back, current and delinquent accounts for reviewing.
• Worked on review the inactive accounts, excluding the VIP accounts and other special criteria accounts.
• Extensively involved in Oracle PL/SQL programming to create Triggers, database Procedures etc. Creation of database objects like Tables, Views, and Synonyms etc.
• Worked on SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Worked on Oracle Tools and Utilities such as Developer 2000, SQL*Navigator.
• Enhancements to C++, Pro C backend code interacting with the Oracle backend.
• Worked on High Performance query and debugging it to improve the performance.
• Responsible for creating technical and functional documentation.

Environment: AIX, Perl 5.8.4, Oracle 9i/10g, SQL*PLUS, SQL Loader, PL/SQL, Windows 2000, SAS 9.0, Pro C, C++, Mercury QC 9.2, Harvest CM 7.1

Confidential, FL

Application Support Analyst

Responsibilities:

• Worked with business analysts to understand functional requirements and implementation.
• Retrieve the data from different tables and also from the specific directories/Locations, format the data and to verify the data before loading into Tables.
• Developed UNIX shell scripts to process files.
• Designed and developed shell Scripts to extract, transform and load.
• Developed PERL Scripts to generate daily reports.
• Performed Exceptional error handling using PERL Modules.
• Used DBI/DBD module to interact with the database.
• Tuned queries for better performance and faster data retrieval from trade’s data.
• Created Technical Documentation for scripts and stored procedures.
• Created and tested Unit test Documents.
• Actively participated in Application/Production/User Support.
• Coordinated with operations team during testing and deployment of code in staging and production environments.
• Actively worked in the Support team and sent daily reports on the health check of Weblogic Servers.

Environment: Perl 5.8.4, Sybase 12.5, HTML, Sun OS 5.10, KSH, CVS

Confidential, NJ

System Analyst

Responsibilities:

• Analyzed and implemented new requirements by coordinating with BAs.
• Involved in System Analysis and requirements gathering with lot of user interaction.
• Developed UNIX Shell scripts to support and monitor the application.
• Developed Shell scripts to parse the files based on the requirement.
• Developed PERL scripts for various kinds of reports needed by the users and developed common modules in PERL.
• Used XML to combine the data into a format that is understandable by all.
• Supported front-end programs with Sybase Stored Procedures and queries.
• Writing stored procedures and triggers on Sybase database; tuning queries for better performance.
• Creating CRON jobs as per requirement, maintaining the existing scripts and administrating the CRON entries.
• Supported the batch application which runs many batches daily/weekly/monthly.
• Used DBI/DBD for Sybase connection from Perl.
• Development of Perl scripts for sending application based mails using SENDMAIL.

Environment: UNIX (Sun Solaris), PERL/CGI, C++, HTML, XML, Java Script, Crontab, Sybase 12.5, Transact-SQL, Sql*Plus, Sql Loader, Windows 2000

Confidential

Software Engineer

Responsibilities:

• Involved in requirement analysis, database design, coding, testing, implementation and review.
• Created UNIX Shell Scripts for sequential execution of PERL scripts including data extraction, loading and Oracle Stored Procedure execution.
• Created PERL batches to monitor errors in data loading at particular frequency.
• Coded sub-routines in PERL to update database from flat files and vice versa.
• Wrote PL/SQL and UNIX scripts used in loading of legacy data.
• Handled scheduling of Korn Shell scripts that loaded data from flat files to Oracle.
• Created database triggers for data validations in Oracle.
• Worked in data handling using UNIX scripts.
• Maintained multiple levels of support for all systems batch processing.
• Provided support for job scheduling, file transfers, and transactional processes.
• Involved with production and quality assurance environment support.

Environment: UNIX, PERL, Oracle 8i, PL/SQL, HTML, JavaScript, CVS.