Business Analyst Ii
Current
Aug 2022 - Present
AeroLeads people directory · profile
Ayan Bose Email & Phone Number
Data Analytics at Amazon
at
Amazon
1 work email found
@segalgroup.net
2 phones found area 716
LinkedIn matched
✓ Verified July 2026
4 data sources
Profile completeness 100%
Who is Ayan Bose? Overview
A concise factual answer block for searchers comparing this professional profile.
Quick answer
Ayan Bose is listed as Data Analytics at Amazon at Amazon, based in San Francisco Bay Area, United States. AeroLeads shows a work email signal at segalgroup.net, phone signal with area code 716, and a matched LinkedIn profile for Ayan Bose.
Ayan Bose previously worked as Business Analyst II at Amazon and Data Analyst at The Segal Group. Ayan Bose holds Master'S Degree, Management Information Systems from University At Buffalo School Of Management, The State University Of New York.
Company email context
Email format at Amazon
This section adds company-level context without repeating Ayan Bose's masked contact details.
{first}.{last}@segalgroup.net
86% confidence
AeroLeads found 1 current-domain work email signal for Ayan Bose. Compare company email patterns before reaching out.
Profile bio
About Ayan Bose
With over 10 years in the data analysis landscape, I've honed my expertise in data warehousing and business intelligence, specifically with Microsoft Power BI and SQL. Currently at Amazon, my mission is to streamline complex data processes, ensuring efficiency and scalability that align with our organizational goals. My approach is shaped by a passion for impactful analysis and a commitment to fostering an inclusive and dynamic work environment.
Listed skills include Sql, Oracle Applications, Tableau, Sas E Miner, and 26 others.
Current workplace
Ayan Bose's current company
Company context helps verify the profile and gives searchers a useful next step.
6 roles
Ayan Bose work experience
A career timeline built from the work history available for this profile.
Data Analyst
• The primary focus of the role was to redesign the existing data warehouse and modernize the ETL processes and reporting suite to be more efficient, robust and scalable• Led the efforts in design and development of data pipeline using SQL Server Integration Services (SSIS) and SQL packages to transform and load source data. Resulted in a single source package and deduced maintenance efforts by over 90% •Created Power BI dashboards as part of SQL Server Reporting Services (SSRS) report migration. Added interactive features for clients to slice and dice data as required and reduced the need for ad hoc data requests
Aug 2016 - Jul 2022
Research Assistant
• Analyzed longitudinal data to identify the differences in various physician's referral pattern by modeling network structures across referral data using Gephi• Performed hypothesis testing, regression modeling and A/B Testing on medical data using SAS and MS-Excel
Dec 2015 - May 2016
Technical Analyst | Product Services Team
• Analyzed PIM/EPDQ LIVE defects and delivered hot fixes as KANBAN• Involved in SQL Query tuning and optimization; provided tuning recommendations for ERP jobs, time/CPU consuming queries; generated AWR reports from Oracle R12 database; analyzed reports for Oracle wait events, time consuming SQL queries and tablespace growth• Designed interactive and insightful dashboards and reports in Tableau and SSRS for showcasing metrics/KPIs relevant to product induction statistics, revenue statistics, daily job monitoring statuses of client applications; reduced requests for ad hoc reports by over 40%
Jul 2014 - Jun 2015
Technical Analyst | General Merchandise Online Team
• Worked on new features and enhancements for Tesco's Oracle PIM solution for Product Data management• Hardened PIM (Oracle Apps functional module for MDM) custom code base. Supported implementation of product induction and product data publish process• Created AS-IS and TO-BE process flow diagrams in Visio to streamline Tesco's product induction process; resulted in performance benefits of over 25% following implementation of the changes
Feb 2013 - Jul 2014
Software Engineer | Supplier Data Cleansing And Migration
• Transformed legacy data using Informatica to ensure compatibility with Oracle 11g base tables; used SQL*Loader to load data into staging area from flat files obtained from Informatica• Developed stored procedures in PLSQL implementing cursors, dynamic SQL, materialized views and bulk collect for outbound and purge components• Defined supplier induction and update process flows using Oracle Workflow Builder; used Business Event System to send notifications to request and verify approvals for all the flows• Identified KPIs for monitoring newly implemented system following discussion with clients; created parameterized reports in SSRS to monitor performance metrics and trigger alerts• Audited and monitored data for accuracy; responsible for loading, extracting and validation of data prior to reporting; reduced reporting failures by 30%
Aug 2010 - Jan 2013
3 education records
Ayan Bose education
Master'S Degree, Management Information Systems
University At Buffalo School Of Management, The State University Of New York
Information Science & Engineering
Sir M Visvesvaraya Institute Of Technology
High School, Science And Computers
La Martiniere For Boys
FAQ
Frequently asked questions about Ayan Bose
Quick answers generated from the profile data available on this page.
What company does Ayan Bose work for?
Ayan Bose works for Amazon.
What is Ayan Bose's role at Amazon?
Ayan Bose is listed as Data Analytics at Amazon at Amazon.
What is Ayan Bose's email address?
AeroLeads has found 1 work email signal at @segalgroup.net for Ayan Bose at Amazon.
What is Ayan Bose's phone number?
AeroLeads has found 2 phone signal(s) with area code 716 for Ayan Bose at Amazon.
Where is Ayan Bose based?
Ayan Bose is based in San Francisco Bay Area, United States while working with Amazon.
What companies has Ayan Bose worked for?
Ayan Bose has worked for Amazon, The Segal Group, University At Buffalo (Ub), Tesco, and Infosys.
How can I contact Ayan Bose?
You can use AeroLeads to view verified contact signals for Ayan Bose at Amazon, including work email, phone, and LinkedIn data when available.
What schools did Ayan Bose attend?
Ayan Bose holds Master'S Degree, Management Information Systems from University At Buffalo School Of Management, The State University Of New York.
What skills is Ayan Bose known for?
Ayan Bose is listed with skills including Sql, Oracle Applications, Tableau, Sas E Miner, Shell Scripting, Unix, Agile Methodologies, and Java.
Find 750M verified contacts
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trial