Abhishek Barbaruah
DW/BI Architect
Bangalore
Summary
- 10 Years of Total Experience in developing BI and DW solutions, OLAP & OLTP database models. Cloud migrations and building hybrid data platforms.
- Working on Azure/AWS Cloud architectures and solution design
- BI and ETL/ELT expertise in working with tools and databases like Snowflake, Azure Data Factory, Teradata, Informatica and Vertica to provide DW/BI solutions, and Data Modelling with Erwin.
- Strong leadership, analytical and interpersonal skills with exposure of working in multi-cultural environments
Domain Experience : Telecom - Supply Chain
Overview
10
10
years of professional experience
4
4
years of post-secondary education
3
3
Certificates
Work History
DW/BI Architect
Amdocs Ltd.
04.2021 - Current
- Lead a team of 6 DWH/BI Developers in projects delivering marketing intelligence for an American telecom giant's customer base
- Work with functional users to delineate project impact assessments, estimates/timelines, and incorporating Agile project deliveries.
- Lead entire application warehouse transformation project from Teradata to Snowflake (~600+ Tables) using Teradata TPTs, Azure ADLS Services and Snowflake ingestion techniques (COPY, SnowSQL, Stages, Shared Accounts)
- Build architecture solutions for hybrid applications, lead code development and data interfaces across on-prem and cloud platforms
- Created project and application architecture deliverables consistent with architecture principles, standards, methodologies and best practices.
- Work on Erwin to develop data models for applications
DW/Senior BI Developer
Amdocs Ltd.
05.2017 - 03.2021
- Developed applications supporting intelligence dashboards for marketing campaign management
- Build data applications to enable customer solicitation handling
- Lead the development of hybrid applications hosted on-prem and on-cloud, maintaining seamless CDC between systems for high criticality data
- Write code for Teradata (BTEQ, MLOAD/TPT/TPUMP) and Snowflake platforms (SnowSQL) and use Azure functions to build applications
- Coached new developers on dev strategies, platforms and best practices
BI Developer
Tata Consultancy Services Ltd.
11.2013 - 04.2017
- Project Offshore Lead in projects providing procurement solutions for American Healthcare client which helped make better purchase decisions.
- Implemented cost analysis reports helping strategize sourcing for client from a range of 100+ suppliers.
- Developed historical data load strategy for Bill-Of-Material details in Teradata and implemented Explosion Report for aggregated analysis
Education
Bachelor of Technology - Computer Science
Institute of Technical Education And Research, S'O'A University
Bhubaneswar 09.2009 - 05.2013
Skills
Data Warehousing
Azure Cloud Architecture
Teradata DW
Informatica Powercenter
Unix Shell Scripting
Erwin Data Modelling
Snowflake DW
Certification
AWS Certified Solutions Architect - Associate
Timeline
SnowPro Core Certified
02-2024
DW/BI Architect
Amdocs Ltd.
04.2021 - Current
Vantage Certified Teradata Associate
06-2020
AWS Certified Solutions Architect - Associate
07-2019
DW/Senior BI Developer
Amdocs Ltd.
05.2017 - 03.2021
BI Developer
Tata Consultancy Services Ltd.
11.2013 - 04.2017
Bachelor of Technology - Computer Science
Institute of Technical Education And Research, S'O'A University
09.2009 - 05.2013