Abir Sur Email and Phone Number
I am a Data Analyst with 7+ years of experience transforming large datasets into actionable insights that drive business growth and operational efficiency. Skilled in SQL, Python, Excel, Tableau, and Power BI, I specialize in automating reporting processes, predictive analytics, and delivering impactful visualizations. My initiatives have led to a 25% increase in reporting accuracy, a 40% reduction in manual workload, and measurable improvements in decision-making processes across industries like finance, supply chain, and marketing.In my current role at Northern Trust, I partner with cross-functional teams to develop SQL-driven financial models, create advanced Power BI dashboards, and automate reporting pipelines, streamlining workflows and enhancing data accuracy. I also leveraged machine learning to improve multilingual data accuracy for financial analysis by 25%.At Cal State LA, I developed predictive models to optimize resource allocation and provided strategic insights into enrollment trends. Additionally, I created dynamic Tableau dashboards and SQL-driven reports to track KPIs, improving engagement by 22% and optimizing procurement strategies.During my tenure with the Government of India, I designed ETL pipelines, automated web scraping workflows, and conducted advanced data analyses on a 120-million-record dataset. These efforts significantly improved audit efficiency and compliance monitoring, reducing processing time by 75%.Certified in Six Sigma Green Belt, SAP Analytics Cloud, and IBM Data Science, I am passionate about leveraging data to solve complex problems and create measurable value. I thrive in collaborative environments, translating data into insights that enable strategic decision-making.Let’s connect to discuss how data-driven strategies can optimize business outcomes!
Orange County Public Schools
View- Website:
- northerntrust.com
- Employees:
- 21127
-
Senior Business AnalystOrange County Public SchoolsOrlando, Fl, Us -
Data AnalystNorthern Trust Sep 2024 - Present• Partner with finance, IT, and risk management teams to define specific data requirements and build financial data models and SQL-driven reports, increasing data accuracy by 25% and supporting precise financial analysis.• Developed 6 advanced Power BI dashboards using DAX and Power Query to visualize financial metrics and portfolio performance, reducing report turnaround time by 30% and delivering key insights to stakeholders.• Applied machine learning translation with Python, using… Show more • Partner with finance, IT, and risk management teams to define specific data requirements and build financial data models and SQL-driven reports, increasing data accuracy by 25% and supporting precise financial analysis.• Developed 6 advanced Power BI dashboards using DAX and Power Query to visualize financial metrics and portfolio performance, reducing report turnaround time by 30% and delivering key insights to stakeholders.• Applied machine learning translation with Python, using MarianMTModel to translate over 3,000 multilingual text entries to English for financial analysis, resulting in a 25% improvement in data accuracy.• Led the automation of financial reporting processes, streamlining workflows and reducing manual workload by 40% through automated data pipelines using SQL and Power BI increasing data accuracy. Show less -
Data Analyst - Graduate AssistantCalifornia State University, Los Angeles Sep 2022 - May 2024• Trained non-technical staff on data collection techniques, and built an automated inventory management system using Excel VBA macros, which managed 10,000+ products across 25+ storage units. Created real-time Tableau dashboards to provide management with comprehensive visibility into inventory and logistics.• Developed SQL queries to extract and aggregate data from university marketing and student databases, and created Tableau dashboards to monitor KPIs such as Click-Through Rate (CTR)… Show more • Trained non-technical staff on data collection techniques, and built an automated inventory management system using Excel VBA macros, which managed 10,000+ products across 25+ storage units. Created real-time Tableau dashboards to provide management with comprehensive visibility into inventory and logistics.• Developed SQL queries to extract and aggregate data from university marketing and student databases, and created Tableau dashboards to monitor KPIs such as Click-Through Rate (CTR), Cost per Acquisition (CPA), A/B Testing, and Social Media Engagement to deliver actionable insights that increased engagement by 22%.• Reduced excess inventory purchases by 18% by querying large relational datasets using SQL and performed in-depth analysis in Excel Power Query to visualize inventory forecasts, Reorder Points, and trends with Tableau, enabling data-driven procurement strategies and improving operational efficiency.• Utilized Python (Pandas, NumPy, scikit-learn) and SQL to conduct predictive analysis on enrollment trends, providing the administration with valuable insights into future student intake patterns and optimizing future resource allocation. Show less -
Auditor - Data AnalysisFinance & Communication Audit Apr 2017 - May 2022Kolkata Area, India• Developed ETL pipelines in Excel Power Query to extract and analyze pre-audit risk metrics (e.g., revenue impact, compliance history, process complexity, and fraud indicators) for 300+ branches. Prioritized audits based on risk levels and visualized insights reducing processing time from 4 months to 1 month.• Automated data collection processes using Python web scraping, managing a relational database with over 1,000 contracts and 10,000 tenders, ensuring data accuracy and integrity and… Show more • Developed ETL pipelines in Excel Power Query to extract and analyze pre-audit risk metrics (e.g., revenue impact, compliance history, process complexity, and fraud indicators) for 300+ branches. Prioritized audits based on risk levels and visualized insights reducing processing time from 4 months to 1 month.• Automated data collection processes using Python web scraping, managing a relational database with over 1,000 contracts and 10,000 tenders, ensuring data accuracy and integrity and analyzed using SAS Base reducing the projected timeline by 300%, from 1 year to 4 months.• Executed complex SQL queries on a 120-million-record dataset for India’s largest telecom provider, analyzing metrics related to customer retention, network efficiency, fraud detection, and compliance.• Built and optimized ETL processes with SSIS and Talend, ensuring seamless integration of data from various sources into the central data warehouse.• Published and maintained Power BI Service workspaces, scheduling data refreshes to ensure real-time reporting and up-to-date insights for supervisors. Show less
Abir Sur Education Details
-
Computer Science -
Business Analytics -
Information Technology -
Business Administration And Management, General
Frequently Asked Questions about Abir Sur
What company does Abir Sur work for?
Abir Sur works for Orange County Public Schools
What is Abir Sur's role at the current company?
Abir Sur's current role is Senior Business Analyst.
What schools did Abir Sur attend?
Abir Sur attended California State University, Los Angeles, Liverpool John Moores University, West Bengal University Of Technology, Institute Of Management Technology, Ghaziabad.
Who are Abir Sur's colleagues?
Abir Sur's colleagues are Vijay Sharma, Suryadev Yadav, Teresa Young, Phil Taylor, Surya Prakash, Sai Kiran Kumar R, Claire Whelan.
Not the Abir Sur you were looking for?
-
1gmail.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial