Akhilesh Anandrao Patil

Company Overview: VOIS India Client: - Vodafone (UK)

Application Owner - MDN (Mobile Data Notification)

Department: - Wholesale (Telecom Business Operation)

Environment: - SQL, UNIX, LINUX,Oracle Database(SQL),Shell Scripting

Tools: - Splunk,TWS, Grafana, Remedy, Putty, FileZilla

Responsibilities:

• Lift and shift transition from the L3 team for a new improvisation process.
• System improvement plans built with hypercare initialization of Shell scripting and PHP.
• Creation of an operational menu for processes in coordination with TWS jobs.
• The new Oracle-DRCC environment setup also built up functionality and made housekeeping, archiving, and generic scripts.
• Maintained audit trail and statistical records of problems and conditions reported by client.
• Coordinated with other teams to ensure successful delivery of services.
• Demonstrated strong problem-solving skills, resolving issues efficiently and effectively.
• Provided necessary technical assistance and advice to subordinates when needed.
• Gathered user requirements and preferences for application changes, integrating feedback into subsequent patching schedule.
• Contributed to technical support documentation by updating literature based on common support interactions and known issues with software.
• Provided guidance and mentoring to team members on best practices related to application support activities.
• Maintained composure and patience in face of difficult customer situations, applying de-escalation techniques and positive customer support.
• Participated in regular meetings with senior management regarding project status updates.
• Prepared reports on departmental performance, customer feedback, and other relevant data.
• Handled user account access management, assigning credentials, distributing permissions and terminating defunct users.

Company Overview:

Client: Amdocs India, T-Mobile, SPRINT, METRO.

Application Owner: Revenue Guard

Projects: T-Mobile Prod 31BC (Telecom Business Operation)

Environment:SQL, UNIX, Linux,Oracle Database(Sql),Shell scripting

Tools: TWS, Grafana, Remedy, DBWORKS, RTM, Putty, FileZilla

Project Description:

The TWS scheduler tool is used to execute billing completion and confirmation, map batch jobs to process BAN files, and generate invoices for customers.

• We need to handle two maps daily, Completion map and confirmation map
• Completion of billing the Billing Audit take place
• All the data from 3-heart jobs are gathered in the form of extracts and then stored into the database and aggregate data is stored into the cubes of REVENUE GUARD
• Six months data is stored into the database and audit is take place on daily basis
• Any issue will occur that time, I am changing the definition of views and PL-SQL procedure and then reflects the data from database for aggregation
• Responsibilities: Involved in Application Support and Monitoring, Incident management, problem management and change management for Application
• Used TWS tool to Perform daily Billing cycle activities in Prod environment
• Performed analysis of current technology operations, diagnosis and troubleshooting of aborted batch jobs, and resolving the failed jobs using work around defined in framework
• Analyzing the alert and metrics from various applications raised at recurrent production issues
• Handling tickets through REMEDY and providing the appropriate solution to the issues
• Automating small tasks to ensure a fast and efficient work environment
• Telecom Domain Company: - Amdocs India Client: - T-Mobile, SPRINT, METRO
• Handled root cause analysis, implementing corrective actions when necessary.

• Company Overview:

Client: British Telecom.

Department: TBO (Telecom Business Operations)

Environment: SQL, Unix, Oracle Database (SQL), Shell scripting.

Tools: OVO, SNOW, Remedy, Putty, SQL Developer,TWS.

Project Description:

Field-Plan7 & 90 allows planners to view jobs that are ready to be executed and technicians' details for planning, depending on the selected plan type, which could be a capacity plan as well as a deployment plan.

• Technicians' skills and PWAs' preferences can be edited, and those can be included or excluded from the deployment plan.
• After running the planning engine and making the required changes, the deployment plan, and capacity plan, is refreshed to reflect the modification.
• The application aims to get the Right Man in the Right Place at the Right Time at the Right Cost with the Right Skills
• Based on the plan type, planning is of two types: Deployment Plan—when plans are generated for small to medium-term planning.
• This is a weekly plan applicable for 7 days.
• Capacity plan: when plans are to be generated for medium- to long-term planning.

Responsibilities:

• Monitored end user activities related to supported software applications in order to identify potential areas of improvement.
• 
  
• Provided training sessions for users regarding the use of key enterprise-level software applications.
• Assisted with the planning, testing, implementation, maintenance, monitoring and evaluation of various applications used by the organization.
• Resolved escalated tickets related to application support within agreed upon SLAs.
• Identified, debugged, and fixed system bottlenecks and problems.
• Provided technical guidance to users on application-related issues, including installation, configuration, upgrades and troubleshooting.
• Escalated complex issues by working with engineering team to resolve promptly.
• Collaborated with other IT teams on system integration projects involving multiple platforms and technologies.
• Debugged and repaired application issues.
• Participated in regular meetings with stakeholders in order to discuss current challenges or potential solutions.

Providing Level 1, 2 support for data applications.

Good knowledge of the banking domain.

The core role was to keep the application up 24/7 and to be in touch with administrators and users to help them and resolve server and application-related issues.

Check email alerts, notification emails, and any ticketing tool with their priority.

Maintain and manage systems, software tools, and applications.

Having a good knowledge of Linux/Unix.

Executing DDL and DML statements in SQL Server to analyze and rectify issues.

Knowing database objects like tables, subqueries, joins, constraints, set operators, and views in SQL and PL/SQL.

Creating and modifying the CRONTAB for cleaning up data, such as error logs, older archive logs, and unnecessary text files from the live server and secondary server from time to time, to maintain space for EOD and SOD activities and log files.

Interface with end users.

Weekly meeting with the client to discuss the WSR (Weekly Status Report) for ongoing issues and escalations. Provide on-call support.

Working in coordination with the Linux team, the Development team, the Middleware team, the Network Administration team, and other application support groups for any issues related to databases and applications.

Good understanding of ITIL for incident, change, and problem management.

Resolving application-related queries and issues based on the ticketing system.

Sending daily reports and health checks to the client about application availability.