Amrit Bhandari

About Amrit Bhandari

Analytically-minded consulting professional with over a year of in-depth experience in…

Experience

1. Senior Data Analyst

   PwC

   Sep 2018 — Present

   Skills: Python, SQL, SAS,Tableau, Alteryx • Leveraged Computer Assisted Audit Techniques (CAATs) including SQL, Python, and SAS to automate the process of internal audit (GL and TB extracts from major ERP systems) and accurately and efficiently identify high risk transactions and fraud. • Performed full cycle of data governance and regulation compliance testing including data validation, developing test cases based on regulatory T&C’s, writing test scripts and documentation in work papers. Delivered actionable intelligence to help client manage critical risks in the future. • Developed customizable test scripts in SAS that tests transaction datasets of millions of records against client’s regulatory T&C’s. Build Tableau Dashboards that analyzes exceptions and risk for non-compliance with T&C. • Performed exhaustive data cleaning including data integrity checks and anomaly detection to convert raw data into structured clean dataset. Design and implement programs using Python and SAS to extract, transform and load (ETL) the clean and structured data into the targeted database system. • Developed customizable data validation script in Python that performs null checks, length check and pattern check to assess the data completeness and integrity of large datasets. • Wrangled, cleaned and analyzed employee expense transaction log data for a client to identify potential expense policy violations including cash advances, expenses over maximum allowed. • Developed analytical dashboards in Tableau with details on specific policy violations. Solution analyzes transaction data on high-level aggregations and includes ability to drill down to specific transaction logs.