SUMMARY:

• MS SQL Server/.Net/Windows Server CONSULTANT/Application Support, Production Management/Project Management.
• Business Areas: Banking, Financial and Corporate Banking
• M.C.A - 9 + Years of Experience with Confidential APPLICATIONS Programming(MS SQL Server), Production support(VB.Net&SQL Server), Administration(SQL DBA) and Infrastructure solutions in 24x7 Global Support environments which includes managing Large-Scale databases with Production Environment on Windows Platform
• Experience in Project Management, Cost Management, People Management, Stakeholder Management, Delivery Management & Program Management
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting different versions of Microsoft SQL Server.
• Having experience and knowledge with application frontend development tools using: VB VB.Net, SQL Server,CMOD, Service Now
• Having Very Good Experience and Strong Knowledge in ITIL with Service Now Incident management, Problem management and Change management to maintain the SLA with high Customer Satisfaction rates.
• Having Work Experience in designing, implementing, maintaining, and documenting complex Database applications and data warehouse in financial environments.
• Extensive experience with SQL Server and T-SQL in constructing Stored Procedures, tables, views, indexes, relational database models.
• Hands on experience and outstanding knowledge of HIGH AVALIABILITY SQL Server solutions, AAG, Including Mirroring and SQL Server Clustering.
• Database administration: database design and database development work with SQL Server 2005, 2008, 2012 performance tuning is one of my key skills.
• Having very good experience on IBM CMOD Programing, Administration and Tivoli storage manager. Designed, developed and supported front end GUI application providing the integration line of business application with the Content Manager Imaging and document management platform.
• Primary Project Delivery with Quality as per Schedule and SLA, Resource allocation, Allocation of responsibilities to team, handling time sheets, Onsite Coordination between Clients and Offshore Team.
• Coordinating with other IT managers working on the projects and Reporting to the senior project manager about the status of project, discussing the problems facing in completion.
• Involved in capacity management by managing business volumes against IT resources allocated to ensure adequate capacity.
• Performing Disaster Recovery (DR) test on a yearly basis and also ensuring the Primary and Standby Environments are intact.
• Outages: Managing Outages to improve stability levels by further reducing application outages.
• Escalations: To consolidate support & escalation Rota, ensure all applications for 24x7 Rota defined, published and maintained.
• Service Level Management: implementation of SLA module for applications.
• Relationship Management: establishing monthly client and CIO sessions to actively gather feedback and identify improvement areas.
• Vendor Management: - implementation of measurement for vendor performance through KPI framework and make service quality transparent.

TECHNICAL EXPERTISE:

Databases: MS SQL Server 2012, 2008, MS SQL Server 2005

Programming: Visual Basic 6, .Net, SQL Server, IBM CMOD,

Administration: Database administration of MS SQL Server 2012,2008, 2005, IBM CMOD Administration,

Operating System: Windows 2008/2012, Unix

Tools: Visio, Service Now, DB Symphony

PROFESSIONAL EXPERIENCE:

Confidential

Environment: VB.Net, SQL Server 2014/2012/2008 , Windows.

Production support, SQL Server Administration and Project management

Responsibilities:

• Handling the Production for Confidential and providing Support USA and Europe regions.
• Mainly involved in System Monitoring, Application Maintenance, Application, deployment, User Support, Resolving Issues and Reporting.
• Responsible for Project Management including Resource Planning, Incident Management, Problem Management, Change Management, Release Management, SLA Management. measures) with application owner/domain manager or clients
• Manage GIM call for P1, P2 & P3C Incidents. Prepare the Chronology, RCA, & Remediation plan for all P1, P2 & P3C incidents
• Achieved 25% Incident reductions through Problem Management in 6 months.Managed 3200 tickets (2800 INs and 400 SRs) per month.
• Establish structures, processes and tools to handle, escalate and resolve client queries Manage communication with end users/customers and ensure known-issues are communicated in a timely and proactive manner
• Monitoring the key metrics; attend the monthly quality audit meeting, DPA, CAB and SMR meetings. Accountable for ensuring good relationships with all stakeholders.
• Define and agree SLA/metrics for support function (e.g. time to handle queries; escalation
• Analyze customer problems of high complexity, assesses scope of impact, identifies options for problem resolution and takes action to resolve issues according to defined service levels.
• Manage patch management strategy for the applications system as when required. Conduct regular application health checks.
• Conduct root cause analysis to prevent re-occurrence of problem incidents.
• Successfully resolving SQL Server problems in conformance with SLAs, which involves In-depth knowledge of SQL Server architecture, connectivity, Backup/restore, database corruption, security, programming etc. Ensuring high customer satisfaction rates.
• Configured and maintained, Always on Availability(AAG),Clustering, Mirroring, log shipping Servers to provide high availability. Involved in Troubleshooting performance issues, fine-tuning queries and stored procedures.
• Handling Outage Notifications accordingly and following the process during production maintenance/production down issues.
• Have understanding of clustering environment and monitoring through cluster administrator

Confidential

Environment: IBM Content Management System (CMOD)

Production support, Administration and Project management

Responsibilities:

• Handling the Production for Confidential and providing Support USA and Europe regions.
• Mainly involved in CMOD administration System Monitoring, Application Maintenance, Application Deployment, User Support, Resolving Issues and Reporting.
• Provide technical level application administration, support, maintenance, and monitoring of the systems.
• Defining Content Manager OnDemand groups and users
• Working with users to determine report indexing and retrieval requirements
• Participate in the BCM, DR, Back Up and Recovery Exercises for the platforms
• Monitoring the space used for archive storage and the space available on the system
• Providing the Proactively monitor production environments and/or applications and conduct health assessments to identify areas for improvement.
• Analyze customer problems of high complexity, assesses scope of impact, identifies options for problem resolution and takes action to resolve issues according to defined service levels.
• Manage patch management strategy for the applications system as when required. Conduct regular application health checks.
• Conduct root cause analysis to prevent re-occurrence of problem incidents.

Confidential

Environment: VB.Net, SQL Server 2014/2012/2008 , Windows.

Application Development and Production support4

Environment: VB,SQL Server 2005, Windows.

Confidential

Environment: VB,SQL Server 2014/2012/2008 , Windows.

Application Development