Abir Sur

Abir Sur Email and Phone Number

Senior Business Analyst @ Orange County Public Schools
Orlando, FL, US
Abir Sur's Location
Los Angeles Metropolitan Area, United States
About Abir Sur

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!

Abir Sur's Current Company Details
Orange County Public Schools

Orange County Public Schools

View
Senior Business Analyst
Orlando, FL, US
Employees:
21127
Abir Sur Work Experience Details
  • Orange County Public Schools
    Senior Business Analyst
    Orange County Public Schools
    Orlando, Fl, Us
  • Northern Trust
    Data Analyst
    Northern 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
  • California State University, Los Angeles
    Data Analyst - Graduate Assistant
    California 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
  • Finance & Communication Audit
    Auditor - Data Analysis
    Finance & Communication Audit Apr 2017 - May 2022
    Kolkata 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

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?

  • Abir Sur

    Youtuber At Youtube
    Bangladesh
  • Abir Sur

    Devops & Asp.Net | Kubernetes Specialist | Azure | Gen Ai | Ml | Llm & Fine-Tuning Gpt, Llama | Sage Maker | Architectural Patterns & Designs Enthusiast | Currently At Ltimindtree
    Kolkata
  • Abir Sur

    Software Engineer At Citytech Software
    Baduria
  • 1
    gmail.com

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.