SUMMARY

• 4+ years of professional experience in Information Technology
• 4 years experience in design, development of various application processes, batch processes and tools using Sybase, Unix, shell scripting, perl.
• Efficiently managing a high volume 24X7 batches (L2 and L3 support) with a team of 7 in both offshore and on - site.
• Extensively involved in automating support model hit frequency reducing man-hours.
• 2+ years experience in managing a high volume client confirmations application .
• Resolved numerous user issues in OLTP platform, application and system performances.
• Good knowledge on incident management and protocols followed in maintaining incident data quality hygiene.
• Documented end-to-end runbooks for various production issues across applications and maintained repositories.
• Proficient in writing and handling SQL Queries, PL/SQL, Stored Procedures, and triggers.
• Enhanced and supported different live applications onJava
• Having excellent knowledge in Autosys configurations for batch Jobs.
• Developed and deployed autosys jobs for back-end data processing for database updates and data retrieval.
• Excellent knowledge and experience in writing JIL commands for various kinds of Autosys jobs.
• Involved in release and configuration management for different applications built onJava.
• Developed analysis level documentation such as Use Case, Business Domain Model, Activity & Sequence and Class Diagrams.
• Extensively used shell scripting in deploying batch jobs
• Used Commons Logging framework (log4j) utility to log error, info and debug messages
• Good exposure to UNIX/Linux environments.
• Providing production support for existing application and newly on-boarded applications.
• Strong analytical, problem solving and troubleshooting skills, willingness and ability to quickly adapt to new trending technologies
• Experience at working both independently and in a team-oriented, collaborative environment.

TECHNICAL SKILLS

Database Tools: SQL Server Management Studio, SQL Profiler, T-SQL, PL/SQL, OLAP, OLTP, Sybase, Oracle, DB2

Languages: SQL, T-SQL, PL/SQL, C, C++, Shell scripting, Python, Basic of Java

Application Packages: Microsoft Office Suite

Operating Systems: UNIX, LINUX, WINDOWS 8/7/XP/98/00/NT

Servers: Apache Tomcat 5.5, Web sphere 7.0/8.0, JBoss

Scheduling Tools: Autosys, Control M, Procmon

Document Management: SharePoint, Documentum

Ticketing tools: JIRA

PROFESSIONAL EXPERIENCE

Confidential

Senior Systems Analyst

Responsibilities:

• Maintenance, development and enhancement of applications and batch scripts using SQL, Shell Scripts and Perl Scripts. These are used for incoming-outgoing feed processing, data pulling, data formatting, data modelling, trade processing, trade mapping and pricing of Trades/Instruments
• Also involved in designing, creation and upgradation of SQL databases.
• Had written Stored Procedures, Triggers, Indexes, Tables, Views and SQL joins for applications following SQL code standards.
• Involved in User support and worked on solving many critical, batch dependency production issues.
• Provided resolution and analysis documentations for numerous user issues and OLTP issues.
• Involved in setting up Autosys jobs for various recurring jobs across applications and involved in drafting JIL commands.
• Creating ad-hoc and automated reports for Business Users using complex queries.
• Maintenance and recycling of servers and production environments and their timely checkout processes were handled successfully.
• Participated in BCP for various applications and played a major role in smooth running of applications.
• Involved in User support and worked on solving many critical, batch dependency production issues.
• Extensively used shell scripting in automating batch processes.
• Involved in extracting, generating and transferring daily scheduled reports to clients without breaching SLA’s.
• Involved in release managements for various applications and ensured the smooth flow of application.
• Liaise with Infrastructure to perform system maintenance like BCP(production swap) and database migration between versions
• Documented User support training manuals and runbooks for production Engineers.
• Providing a 24/7 tech support for the applications and solving User related technical issues.

Confidential

Systems analyst

Responsibilities:

• Analysis, high level and low level design based on Customer specifications.
• Participated in code and test case document reviews.
• Involved in complete documentation of Analysis, Design and Testing.
• Used C++ templates extensively in developing generic patterns. Used XML for data exchange.
• Provided database security by using role base authorization on accessing data.
• Used Perl Regular Expression for comparing the new services.
• Used XML messages as data communication between the client and server.
• Debugging Using Workshop.
• Fix Time crucial bugs reported in production.
• Development of database components using SQL.
• Participated in Test Case review meeting with QA teams.
• Developed Unix Shell scripts and Perl Scripts for testing automation.

Confidential

Junior SQL developer

Responsibilities:

• Involved in the life-cycle of the project, i.e., requirements gathering, design, development, testing and maintenance of the database.
• Created new database objects likeProcedures, Functions, Packages, Triggers, IndexesandViewsusingT-SQLinSQL Server.
• Conducted data import and export operations using the DTS wizard.
• Developed SQL Server objects such as tables, materialized views, clustered and non-clustered indexes, stored procedures, cursors, triggers and constraints.
• Performed query optimization and tuning, debugging and maintenance of stored procedures.
• Used System tables and stored procedures to retrieve metadata.
• Backupandrestoredatabases.
• Monitored SQL Server jobs, and developed queries to perform database operations.
• Provided back-end support for functional testing and performance testing.