Jai Agrawal

Assc. Data Engineer Analyst

Optum•  January 2021 - December 2021•  NOIDA, INDIA

Performed complex log analysis using SQL and HQL queries with DB visualizer and Dbeaver. Modified scripts, scheduled jobs, and re-ran failed jobs using Python, Putty, and Ambari. Created Splunk dashboards and generated reports using SPL for analysis. Developed a team GitHub site using HTML and CSS for easy access to resources.

Assc. Cybersecurity Analyst

Optum•  July 2020 - December 2020•  NOIDA, INDIA

Managed user tickets on ServiceNow using Hydra, including handling resignation, termination, and inactive cases within 45 days. Utilized cybersecurity skills to ensure accurate and efficient handling of user tickets.

Assc. Information Security Engineer Analyst

Optum•  March 2019 - June 2020•  NOIDA, INDIA

Performed firewall tuning for Palo and ASM devices on Splunk, logger, and ArcSight. Prepared advisories to block threats based on group requirements on Palo and ASM. Logged, monitored, and alerted signatures using Kibana. Conducted scorecard analysis for all organization devices on a quarterly basis and provided detailed reports on identified issues.

Software Engineer Trainee Information Security

ValueMomentum•  July 2018 - February 2019•  HYDERABAD, INDIA

Performed IT operations including Office 365 access administration and security reviews for IT assets. Managed help-desk tickets and facilitated the creation and removal of user accounts on a daily basis.

Intern

ValueMomentum•  January 2018 - June 2018•  HYDERABAD, INDIA

Internship experience focused on audits, o365, PowerShell, and SQL. Developed custom queries to track system logoff and logon timings. Conducted proof-of-concepts on open source tools.