Sagar Agrawal

Experience

• 

  Tata Consultancy Services

  Aug 2020 - now

  * Automated the Daily Availability Dashboard at Branch Level • Acknowledged with the Contextual Master position within TCS for outstanding contributions. • Significantly reduced manual efforts across different IS Teams, enhancing SLA from 2 hours to 20 minutes per team, utilizing Power BI for automation. * Developed Security Dashboards for Network and Endpoint devices for the entire North Branch, aiding in strategic decision-making for security compliance and management. • Showed Overall counts with their percentage of Security Parameters. • Showed What is the target we have and where are we standing. • Showed the Non- Compliant Assets counts and in what parameters. • Helped Security Compliance team to decide where and what to target next every time. • Helped management to analyze and to take further decisions.* Created Asset Utilization Dashboard of Endpoint at Branch level• Showed Counts of Overall Assets, Marked as Spared, Allocated, Not Allocated, in WFH with users, in office.• Showed how many of them are endpoints, network devices and others.• Showed the target value and current standing value.• Showed what is the device types count of assets (Customized or Standard)• Showed how many assets are out of warranty and in Warranty• Showed what is the age category of the assets (0 to 4yrs, 4 to 5yrs, 5+ yrs)• Showed how many assets are tagged to single users and from how many days• Helped entire North asset team to take decisions what to target on• Helped management to analyze and to take further decisions.* Prepared Various other Power BI Dashboards• Power BI Task Tracker of different North IS Team• Power BI Dashboard of Weekly Trend for Incident Management Team• Power BI Centralized Physical Verification of Assets for North IS Team• Power BI Dashboard for Network Security Compliance Team• Power BI Dashboard of Multiple Allocated assets only for Intermediate Designation Employee• Appreciated by TCS higher management. Show less  Robotic Process Automation(RPA) Projects• Developed Mass Mailer Utility for Entire North TCS team• Python language was used along with SMTP Package and pandas Library.• Helped entire North IS team in reducing their manual efforts of mail each and every employee one by one• Appreciated by TCS higher management for this.• Developed Python Automation Script to find the Supervisor Name, Email ID, Emp id of an Employee• Developed Python Script using Selenium, Pandas Library, Chrome Driver package. • Helped Various North IS team in marking the supervisor in mail for a particular Employee.• Developed Python Automation Script For Logical Movement of N number of Asset id from one location to another location logically• Developed Python Script using Selenium, Pandas Library, Chrome Driver package. • Helped Asset Team to move assets from one site to another site if site gets ramped down.• Developed the Python Script to find the User category • Python with Selenium was used along with Pandas Library• Appreciated by management for this task completion.• Automated Mail Functionality of Sending Dashboard Using Power BI • Power BI Dashboard PDFs were send automatically under this utility along with Excel file. Show less

  • Azure Databricks Engineer

    Oct 2024 - now

  • Automation Analyst

    Sept 2021 - Nov 2024

  • RPA Developer

    Aug 2021 - Nov 2024

  • Resident Engineer

    Aug 2020 - Aug 2021