Summary
Overview
Work History
Education
Skills
Timeline
Generic

Surya Sahoo

Oak Park,IL

Summary

Results-driven Lead Data Analyst with 8+ years of experience in data analysis, market research, and business intelligence. Led cross-functional teams to deliver data-driven insights for strategic decision-making and improved business performance. Expertise in developing and implementing analytical frameworks, models, and strategies to drive growth and optimize operational efficiency. Proficient in data visualization tools, statistical analysis software, and SQL. Effective communication and leadership skills enable collaboration with stakeholders and drive actionable outcomes. Seeking to leverage expertise to drive innovation and contribute to the success of a dynamic organization.

Overview

15
15
years of professional experience

Work History

Lead Data Analyst

BMO Financial Group
11.2021 - 09.2024
  • Led the execution of retail and business banking data analysis and reporting projects, optimizing processes and delivering key insights to stakeholders.
  • Spearheaded the creation of 360-degree Power BI dashboards for key performance indicators (KPIs), delivering dynamic visualizations that empowered decision-making.
  • Led the strategic planning, research, and execution of customer lifecycle journeys and communications, improving customer engagement and retention rates.
  • Acted as the subject matter expert for report and dashboard automation, delivering automation for 20+ reports, greatly enhancing efficiency and reducing resource allocation.
  • Delivered key insights and strategic recommendations to improve digital adoption, boosting online and mobile app engagement.
  • Analyzed attrition trends and collaborated with cross-functional teams to implement data-driven retention strategies.
  • Collaborated with stakeholders across teams to turn business requirements into effective campaigns and customer journeys.
  • Guided and mentored junior data analysts, promoting the adoption of best practices and improving data reporting standards.

Data Scientist

Insight Global (BMO Financial Group)
04.2019 - 10.2021
  • Collaborate with cross-functional teams to create interactive dashboards and data visualizations for data-driven decision-making.
  • Enhance monthly performance reporting processes by identifying key areas for improvement and streamlining the process.
  • Automate manual data pull and reporting efforts to increase efficiency.
  • Provide data-driven insights and recommendations to stakeholders and senior leadership to optimize marketing strategies.
  • Conduct exploratory data analysis and visualization to identify trends and insights for informed business decision-making.

Data Analyst

Cubic Transportation Systems
05.2018 - 10.2018
  • Develop SAP crystal and web intelligence reports to track the performance of various campaigns and marketing offers.
  • Create monthly, bi-monthly, weekly, and daily reports for auditors and clients Help with all ad-hoc reporting needs.
  • Create custom SQL queries to change/update existing processes.
  • Optimize existing SQL queries to improve report performance.
  • Act as an SME to provide the application support.
  • Perform regular data checks and reconciliation to ensure accuracy.
  • Manage user access for different applications.
  • Work closely with DBAs and IT teams to fix data-related issues, SAP reporting, and performance tuning.

Data Analyst

Kaiser Permanente
03.2018 - 05.2018
  • Perform ETL using SAS and SQL
  • Create Monthly, Bi-Monthly, and Weekly reports for auditors and internal clients
  • Work with different teams to deliver Ad-hoc data requests
  • Automate Excel-based reporting solution using SAS, SQL, and VBA
  • Write complex SQL queries to bring in data and summarize it to create reports
  • Collaborate with auditors and internal clients to ensure report accuracy.

Data Analyst (SQL and Tableau)

Spectrum Data, Inc
03.2017 - 05.2017
  • Gather client requirements for reporting needs.
  • Use SQL Server Integrated Studio (SSIS) to read and upload flat files.
  • Apply data cleansing techniques to ensure data readability for processing.
  • Develop dashboards on Tableau desktop using SQL Server Management Studio (SSMS).
  • Publish and maintain dashboards on Tableau server site created daily, weekly, and monthly reports in Excel and Tableau.
  • Support Ad-hoc reporting, and maintain flow charts and ER diagrams using Visio.

SAS Programmer Analyst

American Express (India) Pvt. Ltd
03.2015 - 10.2016
  • Develop SAS-based data mart solution to fulfill large data extraction needs for reporting.
  • Provide easy and simple User Interface (UI) access to stakeholders for data extraction needs.
  • Create visualizations/dashboards in Tableau, tested, and deployed the final product.
  • Set up a regular reporting process/structure for internal and external clients.
  • Collaborate with data governance team to fix data quality issues.
  • Automate legacy reporting suites/programs through SAS, SQL, and VBA to eliminate old systems causing a huge amount for maintenance.

Data Analyst (SAS)

Ness Technologies
05.2012 - 12.2014
  • Develop and test SAS programs/codes to create a SAS data mart.
  • Perform ETL on different databases, sources, and flat files using SAS tools.
  • Access databases like Sybase, Oracle, SQL servers using SAS tools.
  • Set up a robust data validation process to measure and improve data quality.
  • Generate regular monthly and weekly reports in HTML, PDF, Excel, and SAS formats.
  • Work with SAS macros to automate manual reports and develop reusable macros to save time and resources.

Data Process Engineer

Omniglobe International
10.2009 - 03.2011
  • Provide data support to client (AT&T Mobility).
  • Create users, roles, and profiles, and set access privileges using SQL server
  • Develop triggers, functions, and sequences based on business requirements.
  • Make sure customer inventory information is updated properly and well managed. Keep the order information up to date across all data sources.
  • Assist with maintenance activities and provide application support to internal/external clients.

Education

Master of Science -

Ranchi University
India
06.2012

Bachelor of Science -

Ranchi University
India
06.2007

Skills

  • Data Analysis
  • Marketing Analytics
  • BI Reporting
  • Automation
  • ETL
  • Detail Oriented
  • SAS
  • SQL
  • Python
  • Tableau
  • Power BI
  • Salesforce
  • Advance excel
  • Powerpoint
  • VBA
  • SAP web intelligence
  • Dataiku
  • ServiceNow
  • Agile Methodology
  • Hadoop
  • JAVA
  • Hive

Timeline

Lead Data Analyst

BMO Financial Group
11.2021 - 09.2024

Data Scientist

Insight Global (BMO Financial Group)
04.2019 - 10.2021

Data Analyst

Cubic Transportation Systems
05.2018 - 10.2018

Data Analyst

Kaiser Permanente
03.2018 - 05.2018

Data Analyst (SQL and Tableau)

Spectrum Data, Inc
03.2017 - 05.2017

SAS Programmer Analyst

American Express (India) Pvt. Ltd
03.2015 - 10.2016

Data Analyst (SAS)

Ness Technologies
05.2012 - 12.2014

Data Process Engineer

Omniglobe International
10.2009 - 03.2011

Master of Science -

Ranchi University

Bachelor of Science -

Ranchi University

Similar Profiles

CREATE PROFILE
Surya Sahoo