Madhu Babu Allu

Specialization in itsm tools and sql dba

Email Id: adqixg@r.postjobfree.com Mobile:+966-********* ITIL Foundation Certified

Page 1 of 6

Objective

To associate myself to work in the reputed organization that gives scope to update my knowledge and skill in accordance with latest trends and be a part of team that dynamically works towards the growth of the organization. Professional Summary

Having 14+ years of working experience as senior project engineer. in AESSCO as senior SQL DBA and ITSM tools Implementation of MS SQL Servers 2019,2017,2016,2014, 2012, 2008, 2005, 2000 in Production, QA and Development Environments.

Thorough Domain knowledge in Education, Health care, Marketing, Financial Domains and Web Applications, Xtraction, Solar winds, CA-service desk, Ivanti, E- helpline, HP service management (HPSM), HP-site scope, HP-NNMI, SCCM, Software License Management, Procurement and AMC renewals Quotations and Invoice processing’s.

Installation, Configuring and managing database servers and processes including monitoring of system health and performance, to ensure high levels of performance, availability and security.

Experience with backups, restores and recovery models.

Deploying database objects from Test to Dev and prod environments.

Planning and Implementing the Replication of MS SQL Server

SQL Mirroring and Managing the database as in Switchover and Failover cases

Monitor and provide support to the application during the testing and production environments.

Creating Maintenance plans to automate daily maintenance activities

Hands on experience in Database Support, Data analysis and fixing.

Played a key role in application testing, training, production support and Project review with client.

Experience in Installation, Configuration and Upgrading of MS SQL Server, Client Software and related products for Production, Development and Test Environment.

Administering the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups

Madhu Babu Allu

Specialization in itsm tools and sql dba

Email Id: adqixg@r.postjobfree.com Mobile:+966-********* ITIL Foundation Certified

Page 2 of 6

Daily routine DBA tasks like handling user's permissions and space issues on Production and handling maintenance Jobs including backups and restores.

Experience in Creating jobs, alerts, log to monitor the database errors

Experience in Full, Differential and Transaction Log Backup strategies

Experience in high availability and disaster recovery options for SQL server

24 X 7 Production Database On Call Support.

Excellent time management, interpersonal and communication skills and a very proactive team Player.

ITSM Tools like service desk and Inventory tools.

Experience in hosting the web sites in IIS

Implement web and content management systems with Manage and support SharePoint environments.

Installation of sqlserver2005/2008/2012/2016/2017/2019.

Daily routine DBA tasks like handling user's permissions and space issues on Production and handling.

Experience in Full, Differential and Transaction Log Backup strategies.

Experience in Creating jobs, alerts, log to monitor the database errors

Maintained production database, along with supporting development and testing environment.

Planned the complete Backing up of Database and Restored the Database.

Administering the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.

Using SQL Agent to setup and automate internal processing tasks and backup tasks as well as setting up alerts to monitor the server and database health.

Database and Log Backups and restoration, backup strategies, scheduling backups.

Managing the use of disk space, memory and connections. Running DBCC. Experience Summary

1. Worked as Senior Project Engineer AESSCO, from May 2020 to till date. 2. Worked as Senior Project Engineer WIPRO, from May 2010 to Nov 2019 3. Worked as developer in Jayam solutions from April 2007 to May 2010. 4. Ivanti and xtration

Installation, upgrade and migration of Ivanti application in windows

Integration of the application with other application to automate the process.

Configuration All the admin actives.

Creating the webserver for integration.

Monitoring the all the process

Customization of the application.

Madhu Babu Allu

Specialization in itsm tools and sql dba

Email Id: adqixg@r.postjobfree.com Mobile:+966-********* ITIL Foundation Certified

Page 3 of 6

5. HP Service Manager

Installation, upgrade and migration of SM application in windows

Integration of the application with other application to automate the process.

Configuration All the admin actives.

Creating the webserver for integration.

Monitoring the all the process

Creating user views for the support staff.

6. Solarwinds

Installation of Solar winds application in windows

Automatic Reports and schedules creation in solar winds

Alerts configuration and integration with ITSM Tools

Version upgrade and additional pooling engine configurations. 7. HP NNMI

Installation, upgrade and migration of NNMi application in Linux.

Integrating NNMI events with In-house CMDB tool using Shell action scripts.

Create users and node groups.

Discovering seeds and manage /unmanaged interfaces.

Configure custom polar events.

Fine tuning of fault and performance parameters.

Backup and restoration of configuration.

Troubleshooting network issues

8. Ivanti

Installation, upgrade and migration of Ivanti application in windows

Integration of the application with other application to automate the process.

Configuration All the admin actives.

Creating the webserver for integration.

Monitoring the all the process

Creating user views for the support staff.

9. Asset and software license management.

Purchase the licenses from the venders.

End to end AMC renewals process.

Experience on quote’s and invoice process.

SVN related activities to manage the source code and the user details. Madhu Babu Allu

Specialization in itsm tools and sql dba

Email Id: adqixg@r.postjobfree.com Mobile:+966-********* ITIL Foundation Certified

Page 4 of 6

Customers

Worked with RAK BANK Al-Khaimah, (Offshore Support)

Gemalto for NIC, Riyadh

Princess Nora bint Abdurrahman University (PNU), Riyadh.

MTN Africa

Provided supported for major Indian customers.

Education

Master of Science in Computer Science (2005-2007) from GITAM College, Andhra University, India.

Skills Information

IDE : MS Visual Studio 2003, 2005, 2008, 2010

Scripting : JavaScript, Shell Scripting, Sql

Languages : XML, HTML, PL/SQL

Database : SQL Server 2005, 2008 R2, 2012,2016,2017 and 2019 Source Safe Tools : Visual Source Safe 6.0, Microsoft visual studio Web Servers : Internet Information Server (IIS)

Operating Systems : Windows

Domain : ITIL V3.1 (ITIL Foundation Certified)

Good Understanding of TCP/IP/FTP and OSI Layers

Achievements:

ITIL Foundation certified in IT Service Management Trainings:

Attended training on Information Technology Infrastructure Library V3 [ITIL]

Attended for CHRD trainings conducted by Wipro.

Project : 1

Project Name : E-helpline

Madhu Babu Allu

Specialization in itsm tools and sql dba

Email Id: adqixg@r.postjobfree.com Mobile:+966-********* ITIL Foundation Certified

Page 5 of 6

Skills : SQL Server 2000/2005/2008, IIS 6.0/7.0, .Net 2.0, 3.5 and 4.5, Java Script OS : Windows 2003 server/2008 server, Windows XP professional, Windows 2000. Project Description:

E-helpline is a web based call management tool with an asset management module integrated. It’s IT helpdesk management software which provides ease in use, prompting self- service and self-search for solutions on online knowledge base in the system. It provides the customer a comprehensive tool for problem tracking, online self-service, knowledge management, software change and configuration management and more. It is world class ITIL

(Information Technology Infrastructure Library) compliant tool which contains module like incident management, problem management, change management, Service Asset & configuration management (SACM), Knowledge management, Request fulfillment, Vendor management. This tool is certified by PINK body.

Project: 2

Project Name : E-Asset

Skills : SQL Server 2000/2005/2008, IIS 6.0/7.0, .Net 1.1, 2.0 and 3.5, VB Script OS : Windows 2003 server/2008/ 2012

Project Description:

E-Asset is an IT asset management tool which allows the management to track, monitor software compliance, hardware configuration, asset transfer and asset information such as serial number, host name etc.

Service Asset & Configuration module is closely tightened with Service Desk Module like Incident, Problem, and Change etc. SACM will take care of full CI Lifecycle like CI Creation, Configuration, Relationships, Licensing; AMC & WRNTY to till CI is scrapped. Project: 3

Project Name : FIMO (Financial Information and Monitoring Organizer) Skills: ASP.NET, C#.NET, AJAX, Web Services, WCF, VB6.0, Crystal Reports, SQL Server Operating System: Windows 2003 server/2008 server, Windows XP professional, Windows 2000 professional.

Madhu Babu Allu

Specialization in itsm tools and sql dba

Email Id: adqixg@r.postjobfree.com Mobile:+966-********* ITIL Foundation Certified

Page 6 of 6

Project Description:

FIMO is a Software Product, Micro Finance Organizations can use FIMO to maintain and update the day-to-day information of their operational activities. The information is analyzed and the MIS information is provided by FIMO automatically. Progress and the performance will be checked continuously.

Also, having the well-furnished support of the integrated Accounts module and the HRM module, FIMO supports the Micro Finance Organizations to maintain Baseline information, Loan Information, Savings Information, Insurance Information, HRM Information, MIS Information, & Accounts Information through this project.

Personal Details

Name : Madhu Babu Allu

Alternate Email Id : adqixg@r.postjobfree.com

Passport No : M8886920/248-***-****(IQAMA)

Address : Riyadh, Saudi Arabia

Location : Hara, Riyadh

Languages : English, Telugu & Hindi

Madhu Babu Allu

Contact this candidate