Akshay Heroor — Product Manager

Analytics Lead with over 13 years of extensive experience in business intelligence and analytics projects, both on-premise and in the cloud. Possesses hands-on expertise in AWS services including Glue, Lambda, EC2, IAM, Step Functions, Secrets Manager, SES, SNS, VPC, and S3. Proficient in data migration and business intelligence projects, with a strong track record of building robust data products. Skilled in Apache Spark, primarily using AWS Glue for ETL processes to transform data for reporting and analytics. Experience includes handling large data volumes and designing cost-effective solutions to deliver insights on sales and supply chain data. Demonstrates exceptional team leadership skills, blending technical and functional knowledge with proven expertise in AWS services. Successfully led a team of 12, providing guidance on best practices and designing solutions for migrating existing BI solutions to the AWS Cloud. Proven ability to design and deploy highly scalable, fault-tolerant, secure, and highly available applications on AWS Cloud. Over 7 years of experience in designing physical data models and developing cost-effective Power BI datasets for self-service BI and strategic reporting. Expertise in DAX functions and writing optimized code for Power BI data loads. Additionally, over 3 years of experience in migrating Tableau reports to Power BI environments. Domain Experience: P2M (Plan to Manufacture) O2C (Order to Cash) IBP (Integrated Business Planning) PPLAN (Production Planning) Key Skills: AWS Glue AWS Redshift AWS Lambda AWS Step Functions AWS EC2 AWS S3 AWS VPC AWS Secrets Manager AWS Notification Services (SES, SNS) Apache Spark (PySpark, SparkSQL) Power BI Data Modeling Power BI DAX Functions Tableau Team Leadership with strong communication skills

Stackforce AI infers this person is a Data Analytics Lead with expertise in SaaS and supply chain analytics.

Location: Bengaluru, Karnataka, India

Experience: 13 yrs 3 mos

Skills

Amazon Web Services (aws)
Data Warehousing
Data Modeling
Microsoft Power Bi

Career Highlights

Over 13 years of experience in analytics and business intelligence.
Expertise in AWS services for scalable data solutions.
Proven leadership in ERP implementation and data governance.

Work Experience

Koch Business Solutions India

Data Analytics Lead (9 mos)

Data Analytics Lead (2 yrs 11 mos)

Data Engineering Lead (3 yrs 9 mos)

BI Tech Lead (1 yr 4 mos)

Data Engineer (1 yr 6 mos)

Intel Corporation

Senior BI Developer (3 yrs 8 mos)

Mindtree Ltd.

Software Engineer (3 yrs)

Education

Bachelor’s Degree at B V BHOOMRADDI COLLEGE OF ENGINEERING AND TECHNOLOGY

Akshay Heroor

Product Manager

Bengaluru, Karnataka, India13 yrs 3 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Over 13 years of experience in analytics and business intelligence.
Expertise in AWS services for scalable data solutions.
Proven leadership in ERP implementation and data governance.

Stackforce AI infers this person is a Data Analytics Lead with expertise in SaaS and supply chain analytics.

Contact

Skills

Core Skills

Amazon Web Services (aws)Data WarehousingData ModelingMicrosoft Power Bi

Other Skills

Supply Chain AnalyticsSAP Integrated Business Planning (SAP IBP)SQLOTCP2MSAP VistexETLAmazon RedshiftApache SparkData PipelinesTableauAWS GlueDAXData EngineeringSupply Chain Management

About

Experience

13 yrs 3 mos

Total Experience

4 yrs 5 mos

Average Tenure

6 yrs 7 mos

Current Experience

Koch business solutions india

5 roles

Data Analytics Lead

Sep 2025 – Present · 9 mos

Data Analytics Lead

Jul 2023 – Present · 2 yrs 11 mos

Worked on GP's SAP ERP implementation. The entire GP’s supply chain, planning, sales, accounting and financial planning was planned to move into SAP’s ERP.
 Predominantly worked on P2M, OTC, P2P, IBP domain areas for analytical insights.
 Led a team of 8 in ERP implementation using SAP, managing data across sales, planning, demand,
supply, logistics, procurement, and warehousing.
 The entire DWH was designed from scratch that supported operational and transaction reporting.
I was also responsible for designing orchestration of the entire data pipeline using Lambda and
Step Functions. These pipelines supported both master and transaction data for analytics.
 Designed data products for SAP IBP ‘What-If’ scenarios by extracting data from IBP system. These
data products were instrumental in providing insights about demand sensing, production
planning and supply planning. Basis understanding on R2R [ Accounting and Product Costing].
 Implemented auditing using Dynamo DB to capture the results of executions and avoid parallel
runs; Dynamo DB helped us in lowering execution cost of services Glue. Extensively used
SparkSQL/PySpark to optimize glue code for data movement from multiple sources to Redshift.
Designed DWH solution for Rebates and sales data from scratch to support complex analytical
reporting.
 Worked on data governance to provide security on data products that were utilized using Power
BI datasets

Supply Chain AnalyticsAmazon Web Services (AWS)Microsoft Power BISAP Integrated Business Planning (SAP IBP)SQLOTC+8

Data Engineering Lead

Promoted

Sep 2022 – Present · 3 yrs 9 mos

BI Tech Lead

May 2021 – Sep 2022 · 1 yr 4 mos

Handled a team of 9 with end to end delivery of BI application that included Data Modeling, semantic models on Power BI, guiding team on techniques to enhance the performance and provide better user experience.

Data ModelingTableauMicrosoft Power BIAmazon RedshiftAWS GlueDAX

Data Engineer

Nov 2019 – May 2021 · 1 yr 6 mos

Project : BI Analytics for TAX.
Role : BI Developer
Tech Stack : SQL, SSIS, SSRS, Tableau
Working with BI team to provide efficient ETL solutions for existing DWH. Created multiple SSIS packages and fine tuned slow running packages to provide better performance. As an individual contributor, I was responsible to maintain health of the TAX DWH and alongside worked on enhancements of existing packages. Also, created multiple reports for tax users on SSRS.
Worked with Koch Industries Business Analyst to provide rich visualizations and analytical solutions on TAX systems using Tableau. Good exposure on Tableau to create physical and logical models, also provide scalable and cost effective solutions for the business.

Intel corporation

Senior BI Developer

Mar 2016 – Nov 2019 · 3 yrs 8 mos · Bengaluru Area, India

Project: Sales and Marketing - Data Analytics
Role: Senior BI Developer, SCRUM Master
Tech Stack : SQL, HIVE, SSAS Tabular, Power BI - DAX , Data Visualization.
Involved in developing the SSAS tabular cubes for the BA's. Data is fetched from Hadoop framework, using Hive/Impala into SSAS tabular cubes and develop reporting solutions for Business users.
Proficient in Power BI desktop and Power BI service. Good exposure on creating data models for reporting solutions.
Extensive experience in developing Star schema data models, handling de-normalized data models.
Proficient with DAX functions. Created data models with large large amount of data and provided efficient solutions for reporting.
Also, worked in an agile environment for 3.5years . Handled a team of 8 as Tech Lead with primary responsibilities of code review, effective delivery and having scalable solutions. Got an opportunity to work as SCRUM MASTER and handled DSU and other Agile ceremonies.

Mindtree ltd.

Software Engineer

Mar 2013 – Mar 2016 · 3 yrs

Project : Leading Tobacco Client.
Role: BI Consultant.
Tools Used:
1. Data Quality tool :SSIS
2. MDM: Kalido DIW , Kalido MDM.
3. Reporting: SSRS, Power BI, and also using SSAS.
4. DB : SQL Server 2008 R2, Oracle(min).
Description:
Involved in developing a new BI solution for the client's requirement. Developed SSIS packages for the data which was being extracted from emerging new markets. The data was hosted on a shared path in the server; this data was being picked up through SSIS and then it applied with business logic's and stored in the DB. The data was made available for end reporting through this logic.
The cleansed data was then used for making reports using SSRS and SAP BO.
Was also involved in using the Kalido MDM and DIW tool which had all the dimension data used in the market analysis.
The data which was uploaded by the sales analyst was compared with MDM for any missing records and pushed through package into the DB.
POC's : Experience on working with Power BI and Datazen. Was part of few POC's wherein we used Power BI and Datazen to make dashboard and present to the clients.