SUMMARY:

• Over 9.6 years of success in meeting critical software engineering challenges.
• Hands on experience in Banking, Stock Exchange and UK Taxation functional Domain
• Strong knowledge in Sybase ASE 12.5/15/15.7 and SQL Server 2000/2005/2008/2008R2 database programming using T-SQL Stored Procedures, Built in Functions, Triggers, Cursors etc
• Expert in RDBMS logical and physical Database Designs with excellent Normalization and De-normalization techniques for efficient data storage and retrieval
• Experienced in Query Optimization, Debugging, Performance Tuning and Improvising performance of applications using SQL Trace and Explain Plan to analyze queries for efficient data retrieval.
• Hands on experience in performing ETL using SSIS, DTS, Bulk Insert and BCP.
• Developed various Unix Shell Scripts to manipulate data files, set-up environment variables, custom FTP utility, file archiving.
• Experience in UNIX, Autosys, KSH Shell Scripts and Perl scripting
• Experienced in report design, performance improvement, troubleshooting and enhancements using Crystal Reports, Quick Report components, XML, MS Access and Excel.
• Experience/knowledge in various model of Software Development Life Cycle SDLC of Advance Water Fall Model, Spiral Model and Agile Methodologies.
• Experience in testing of DB data and Application White Box, Black Box and Use case Testing .
• Experience in interacting with Business/Technology groups for analyzing and gathering business needs.
• Experienced with migration from Sybase from version
• Experienced with migration from Delphi application to .Net application Web based application
• Expertise in Delphi 5/6/7/2005/XE Windows and web based application development and migrating from legacy application to latest technology.
• Have hands on experience to work in DOT NET technology especially in ASP.NET, C , MVC.
• Experience in working independently as well as in a team and across various departments.

Sr. Database Developer

Confidential

Junior Software Engineer

Sr. Database developerConfidential

Responsibilities

• Worked on performance tuning on existing application code to speed up the report preparation.
• Designed a Database and a Data Warehouse for the system using Star Schema.
• Created and modifying schema objects such as Tables, Views, Indexes, Stored Procedures
• Developed complex Stored Procedures and Triggers to handle complex business rules, data conversion, historical data, and audit analysis.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using query tuning utilities.
• Created and fixed bugs in the existing shell scripts and Perl scripts.

Technical AnalystConfidential

Responsibilities

• Involving in all phases of SDLC.
• Worked with 3 applications - Troubleshooting, bug fixing and new implementation.
• Worked on performance tuning on existing application code to speed up the report preparation.
• Designed a Database and a Data Warehouse for the system using Star Schema.
• Created and modifying schema objects such as Tables, Views, Indexes, Stored Procedures
• Modified existing SSIS packages and also added more alerts and audits in case of package failure.
• Performed transformations using various SSIS tasks such as conditional split, derived column, that performed data scrubbing, including data validation checks during staging, before loading the data into the data warehouse.
• Developed complex Stored Procedures and Triggers to handle complex business rules, data conversion, historical data, and audit analysis.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using query tuning utilities.
• Worked with migration of existing Delphi application to .Net application. Provided detailed analysis report of existing application for migration.
• Designed sequence diagram, Class diagram, Activity diagram using UML tool Enterprise Architect
• Created existing Delphi application Code flow and business flow document.
• Worked on Orpheus components and enhanced components for project specific purpose.
• Lead the project team in all the weekly project meetings with the Project Manager to review the project and to ensure that the project meets the business and system requirements.

Senior Software Engineer

Confidential

Responsibilities

• Involved in all phases of SDLC process
• Manage Trouble and request queues ensuring timely resolution based on SLA's
• Provided Level 2 Production support primary support .
• Understanding of Third party tools like Autosys, Provide day-to-day database administration and on call support for DEV/UAT environment.
• Implemented Constraints and Triggers for Data Consistency and to preserve Data Integrity.
• Created Documentation on Tables, Stored Procedures, Views and User Defined Functions.
• Created very complex stored procedures and efficient in T-SQL joins.
• Provided in-depth analysis report on Sybase 12.5 to Sybase 15 migration.
• Acquired domain knowledge and mentored new team members.
• Involved in preparation of Release pack and providing support on release/migration
• Updating and creating Delphi GUI interface.
• Created and modifying the UNIX KSH shell scripts and Perl scripting.
• Involved in Troubleshooting and Performance Tuning of the database and T-SQL queries.
• Created Tables, Constraints, Views, Triggers, Indexes, Functions and Stored Procedures in T-SQL.
• Involved in logical and physical design of the database using Sybase
• Responsible for providing leadership on projects assigned, receiving requirement from the Client and dividing it up between project team
• Actively participated in the Internal Audit Team.
• Leading in review meetings with the Project Manager.

Responsibilities

• Designed and supported many Tables, Stored Procedures and triggers on Sybase.
• Made use of temporary tables in Stored Procedure to reduce contention and improve performance.
• Tuning and Optimizing the Triggers, Stored Procedures, SQL to achieve best performance using Showplan and Statistics IO.
• Involved in High Level and Low Level Design for GUI.
• Delphi code development, debugging and reviewing.
• Involved in implementation of complex and performance oriented queries for the Business logic

Jr. EngineerConfidential

Responsibilities

• Involved in Designing Database and GUI interface
• Created user friendly interface for Railway signaling engineers
• Provided the technical assistance to the Team.
• Create own components to meet the project requirement

• Leant Delphi on self-studies with minimal guidelines from the team
• Developing reports through SQL Server and crystal reports.
• Coded for Delphi COM object and OOPS concepts.
• Involved in Debugging, implementation and unit test case preparation