Raman Joshi

Project: BFSI CBO

Client: Lloyds Banking Group

Role: Windows Admin

Team Size: 5

Duration: From August 30, 2022 – Till Date

Employer: TATA Consultancy Services (TCS)

Platforms: Vulnerability Management, Windows Application & Microsoft SQL Server Migration

Tools: Windows, Windows Group Policy, and Microsoft SQL

Roles and Responsibilities:

• Led efforts to mitigate vulnerabilities in Windows and SQL Server infrastructure identified during penetration testing, implementing security patches and system hardening techniques to ensure compliance with industry best practices.
• Assisted in migrating application databases from SQL Server 2014 to SQL Server 2019, performing compatibility assessments and database optimizations, and ensuring minimal downtime during the transition.
• Collaborated with cross-functional teams to identify and prioritize security vulnerabilities in Windows and SQL environments, providing recommendations and deploying mitigations to reduce risk.
• Analyzed and reviewed security findings from pen test reports, developing and executing a remediation plan for SQL Server and Windows systems to address critical vulnerabilities and enhance overall security posture.
• Performed database performance tuning on SQL 2019 during migration, optimizing queries, indexing strategies, and server configurations to achieve improved performance and stability.
• Ensured seamless database migration by conducting thorough testing, validation, and troubleshooting, resolving compatibility issues between SQL Server 2014 and SQL Server 2019.
• Developed and maintained documentation for vulnerability mitigation processes and SQL migration steps, guiding future audits and system upgrades.
• Contributed to risk assessments and security audits for Windows and SQL infrastructure, identifying potential threats and advising on strategies for ongoing protection post-migration.

Project: CORP-IT

Client: Collins Aerospace, Alstom, AIRBUS, Thales CANADA and UK and DIEHL

Role: System Administrator

Team Size: 7

Duration: From July 2017 – 02 May 2022

Employer: Cyient Limited

Platforms: Windows, VMWare, Veritas Backup and Ubuntu

Tools: SCCM, Windows Hyper-V, Active Directory, DNS, DHCP, Windows Group Policy, Service-Now, McAfee EPO Server, Windows Deployment Services, Veritas Backup Exec & NetBackup

Roles and Responsibilities:

• Managed the daily operations of infrastructure.
• Managed Active Directory by creating, deleting, and modifying users and groups.
• Created Group Policy objects to manage computers and users.
• Worked on a project to migrate all the Windows 2008 servers to Windows Server 2016. So far, we have migrated physical servers.
• Manage Windows servers located in the data center.
• Troubleshooting issues related and not limited to DNS, DHCP, MDT, and Active Directory.
• Manages MDT server for deploying images in End-user Computing.
• Provision and do post configuration for new VMs for the data center.
• Installation and support of VMWARE ESX/ESXi 5.x/6.x server hosts the virtual servers for the test/ dev/staging environment.
• Performance tuning for VMware ESXi hosts and Virtual Machines, setting up their CPU affinity rules, allocating resources, and fine-tuning storage.
• Created VMware templates to decrease the deployment time of servers.
• Manages Windows virtual machines in VMware vSphere.
• Creating and managing virtual machines and templates, working with snapshots of Virtual Machines.
• Installed several hotfixes and patches using SCCM & WSUS on Windows servers to eliminate vulnerabilities.
• Managed and organized user accounts and daily data backup.
• Responded to server-down alerts promptly and brought them up via HP iLO/ Dell DRAC. Regularly monitored data backups to ensure data integrity.
• Worked closely and effectively with clients to regulate disk space on servers and End User Machine’s
• Monitoring Incidents and SRs via the ticketing tool.
• Documented functions and changes to new or modified modules, activities, or results; ensured documentation of applications according to standards.
• SQL Administrator – Manage SQL database access and Migration.

Highlights:

• Received the Bronze Award for complete CYIENT Project (Collins Aerospace) server’s migration to a new domain without taking downtime from the business team.
• Received TEAM OF THE MONTH award for completing and supporting Major IT Activities.

Project 2: Suncor Access Management

Client: Suncor Energy Inc

Role: Junior System Engineer

Duration: October 2016 – March 2017

Team Size: 30

Employer: CGI Group, Bangalore (Payroll Company CMS IT Services)

Tools: Active Directory, DFS Services, BMS Remedy Tool and Dell One Identity

Roles and Responsibilities:

• Creation, Modification, and Deletion of User accounts in multiple domains with the help of Dell One Identity Tool or AD servicing tools
• Exchange ID’s creation for User’s ID on business team need bases
• Creation of Security Groups and Distribution List
• Creation of shared Mailbox with or without restrictions
• Email forwarding or Mailbox backup for left users on request bases in the ticketing portal.

Project 1: IS-IT

Client: CGI Group, Bangalore

Duration: June 2015 - October 2016

Role: Desktop Support Engineer (L2)

Employer: CMS IT Services

Tools: BMC Remedy 7.4 and 9.1 for ticketing

Roles and Responsibilities:

• Providing on-call assistance for the issues
• Managing:

a) Work based on request and SLA.

b) Network troubleshooting.

c) Non-compliance issues related to McAfee Anti-Virus, Symantec Endpoint Encryption (SEE) and Symantec PGP.

d) Installation and troubleshooting issues related to the Operating System (Windows 7, 8.1, and 10) and MS Office (2007, 2010, and 2016).

e) Local & Network Printer installation, configuration, and troubleshooting.

f) Proactive testing of VC and Network Printers.

• Responded proactively and positively to rapid change.
• Managed high volume of inbound calls while maintaining a professional demeanor and ensuring timely resolution of issues.

Project: IS-IT

Client: CGI Group, Bangalore

Duration: June 2013 - June 2015

Role: Desktop Support Engineer (L2)

Employer: PC Solutions Pvt Ltd

Tools: BMC Remedy 7.4 and 9.1 for ticketing

Roles and Responsibilities:

• Providing on-call assistance for the issues
• Managing:

a) Work based on request and SLA.

b) Network troubleshooting.

c) Non-compliance issues related to McAfee Anti-Virus, Symantec Endpoint Encryption (SEE) and Symantec PGP.

d) Installation and troubleshooting issues related to the Operating System (Windows 7, 8.1, and 10) and MS Office (2007, 2010, and 2016).

e) Local & Network Printer installation, configuration, and troubleshooting.

f) Proactive testing of VC and Network Printers.

• Responded proactively and positively to rapid change.
• Managed high volume of inbound calls while maintaining a professional demeanor and ensuring timely resolution of issues.