Somna Sattoor

Data Analyst @Northern Trust

US

Engineered automated ETL pipelines in Python & SQL using Snowflake and BigQuery, consolidating multi-source financial data, cutting reporting cycles by 65% and boosting accuracy by 40%.• Designed and delivered Tableau & Power BI dashboards to track portfolio performance, risk exposure, and liquidity trends, enabling executives to make faster, real-time investment decisions.• Consolidated large-scale financial datasets in Azure Synapse under strict governance frameworks, enhancing data quality and ensuring SEC/SOX regulatory compliance.• Applied machine learning models (time series forecasting, regression, clustering) to predict investment returns and client behavior, driving a 25% improvement in portfolio optimization strategies.• Developed transaction anomaly detection algorithms in Python (Scikit-learn, Pandas) that reduced fraud false positives by 18%, enhancing Northern Trust’s risk management systems.• Automated regulatory compliance reporting by implementing audit trails and data lineage tracking in Jira & Confluence, ensuring 100% audit readiness and saving 50+ analyst hours each quarter.• Partnered with portfolio managers, compliance officers, and IT teams to translate business requirements into scalable data solutions, accelerating delivery timelines by 30% and improving client confidence.

San José State University

Master's degree, Data Analytics

G Narayanamma Institute of Technology and Sciences

Bachelor of Technology, Information Technology