Saurav Nair

Data Analyst @LPL Financial

Automated data reporting by preprocessing approximately rows of data in python and migrating Microsoft Excel calculations as well as Ad hoc requests into Real time Tableau Dashboards for stakeholders. Conducting data analysis in quarterly audits aimed at examining an organization\'s financial and operational data to identify issues, anomalies, and opportunities for improvement. This activity plays a crucial role in ensuring that a company operates efficiently, complies with regulations, and manages its resources effectively. Enhanced the precision of reported data while significantly reducing processing time, reducing it from a duration of 4 hours to less than 10 minutes through the implementation of ETL (Extract, Transform, Load) procedures. Performed SQL Validation on data used for Tableau Dashboards, and developed Alteryx workflows to streamline data extraction and transformation processes, resulting in a 35% reduction in processing time from 40 minutes to 15 minutes. Developed data integration solutions to efficiently move data between 2 systems within a 3-month timeframe