Senior Data Analyst
Current• Mainframe Automation: Converted SAS Scripts into Python Scripts and generated five reports that will help auditors in their audits.1. Who has access report: This is ad-hoc report that auditors can run by themselves to pull access information related to different resources like Datasets on Mainframe using Top Secret Security.2. DB2 Access: This is ad-hoc report related to DB2 table access on Personal Investment and workplace Invetment side. 3. Other three reports are part of continuous auditing, where we checked certain controls mentioned in technical implementation guide related to Mainframe. Reports get generated on weekly basis noting excptions to those control. (Example: Password Expiration Interval, Non Employee Login ID ownership)4. Designed and developed a website that will help auditors to generate new reports and access previously generated reports. • Automated frequently tested controls by Exams team as a part of their investment center’s audit using data integration tool like SSIS. (Examples: Product and TLO compensation, Actmize Alerts, Safe Log Reviews Alerts)• Supported audit squads for testing risks and controls from data analytics prespective. Analyzed Bluecoat proxy configuration files by parsing them using Python and then matching it against request tickets raised to get access to unblocked URLs. Analyzed Bluecoat proxy logs in Splunk to check suspicious activities. • Developed tableau dashboard for analyzing Active Directory Groups, their owners and applications they are related to. Segregated high risk AD Groups by looking at their membership information and also application they support.
