Madhu Babu Allu
Specialization in itsm tools and sql dba
Email Id: *********.****@*****.*** 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: *********.****@*****.*** 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: *********.****@*****.*** 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: *********.****@*****.*** 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: *********.****@*****.*** 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: *********.****@*****.*** 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 : *********.****@*****.***
Passport No : M8886920/248-***-****(IQAMA)
Address : Riyadh, Saudi Arabia
Location : Hara, Riyadh
Languages : English, Telugu & Hindi
Madhu Babu Allu