AMBARISH KARAMBELKAR
Santa Clara,CA
Summary
Experienced Professional and thought leader with over 13 years of experience in Business Intelligence, Visualization, data transformation, reporting/Data Architecture. Well versed in defining requirements, planning solutions and implementing solutions using big data technologies at the enterprise level. Strong experience in leading technical implementations of end-to-end Data Warehouse and BI Solutions providing expertise in business requirements gathering, technical architecture design, ETL architecture, reporting and analytics. Sound domain knowledge of Retail Brick and mortar, E-commerce, Supply chain & warehouse management Systems, Payments etc. Experienced in mentoring junior developers, knowledge transfer sessions and training users on BI solutions.
Overview
15
15
years of professional experience
2010
2010
years of post-secondary education
1
1
Certification
3
3
Languages
Work History
Business Intelligence Engineer
Amazon
05.2022 - Current
- Conceptualized and developed Unified challenge dashboard for providing insights about WW authentication mechanisms such as ‘MFA’, ‘CVV’ and ‘Tap to Pay’ with their dual impact on mitigating bad debt while increasing checkout friction impacting revenue
- Implemented compliance policies for the Redshift cluster owned by the team, ensuring adherence to organizational standards and data governance practices
- Revamped and reinstated 5+ dashboards by optimizing backend ETL jobs, improving scalability, and providing enhanced visualizations
- These improvements also reduced overall IMR cost for the team by saving ~4.2 TB in storage and reducing 326 hours of compute time across production jobs
- Identified and resolved bugs in existing critical data pipelines within the first six months, restoring dashboard functionality, rebuilding customer trust, and enabling stakeholders to set informed goals for the following year
- Started working in Amazon’s ‘Digital Payments and Emerging Markets (DEP)’ BI team where I designed and developed 7+ BI dashboards in QuickSight, leveraging Amazon AWS’s big data platforms
- Built robust and scalable data artifacts on top of datasets with billions of records
- Defined the team’s BI strategy by standardizing dashboard templates and establishing a consistent data-sharing framework, ensuring efficiency and uniformity in reporting
- Revamped team’s traditional payment dashboards for Digital ALC and Subscription businesses, ensuring scalability for future DEP expansions and optimized IMR costs by deprecating legacy tables and creating aggregated versions, significantly improving storage and runtime efficiency
- Partnered with senior and principal product managers to develop dashboards tracking launch-critical metrics for payment product rollouts in emerging markets, providing actionable insights for decision-making
- Joined Amazon’s EU Payments Regulation team in 2023, focusing on customer authentication data and leveraging expertise in the payments domain to drive impactful solutions
- Quickly identified and resolved critical bugs in the team’s data pipelines, restoring functionality of high-usage dashboards and enabling stakeholders to set informed goals for the upcoming year
- Collaborated with the engineering team to address gaps in data instrumentation, enabling more accurate impact analysis of experiments aimed at improving payment fix-up rates
- Delivered actionable reports that highlighted early results from these experiments, empowering product managers to make informed, data-driven decisions
Business Analyst
Jacks of Retail PTE
01.2019 - 05.2022
- Company Overview: (Fiji)
- Integrated tableau with ORACLE, SQL Server, IBM Informix and developed more than 100 reports, 30 Data sources with necessary data blending and data modelling techniques
- Real Time dashboards created for tracking sales and warehouse activities
- Created and maintained data visualizations that educated, informed and engaged business partners on key metrics and performance measures
- Created real-time dashboards and reporting capabilities of KPI metrics to senior leaders
- Collaborated with enterprise data warehouse, data governance, and business teams on data quality issues, as well as architecture or structure of data repositories
- (Fiji)
Business Analyst
Reliance Retail Ltd.
01.2011 - 12.2018
- Company Overview: (India)
- Set up Live inventory feeds for Ecommerce businesses
- Developed live reports for order fulfillment as well as analytical report such as DC slotting which helped in improving productivity and fill rate of DCs
- Migration of entire data warehouse from ORACLE to SAP HANA
- Majorly worked with D&L (Distribution and logistics) and Supply chain teams for creating reports such as Real Time Inventory, DC Efficiency, DC Slotting, Picker efficiency etc
- As well as various exception reports for improving efficiency of warehouse operations
- Also managed team of BAs and mentored them to support ongoing BI requests
- Performed Source system analysis (SSA) of SAP R3, Sterling, and Hybris to identify the source data that needs to be moved into data warehouse (ORACLE/HANA) using SLT /Informatica power center/ TIBCO JMS queue
- Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied
- Wrote SQL queries to perform Data Validation and Data Integrity testing
- Created and automated Business reports / Dashboards using various technologies like SAP BW-HANA, SAP BO, HTML and Tableau which will cater all critical Business metrics
- (India)
IT Associate
CGI Information Systems and Securities Pvt. Ltd.
05.2010 - 01.2011
- Developed various applications in RTM (Real-time Transaction Manager System), a proprietary language of CGI Information Systems and Securities Pvt
- Ltd
Education
BE - Computer Engineering
Tableau Desktop Specialist - undefined
Skills
Tableau
QuickSight
SAP BO
SAP BW
Oracle
SAP HANA
Redshift
SQL Server
IBM Informix
SAP ERP
Retail Viva
PRONTO
PL/SQL
Data mining
Data profiling
Data analysis
ETL architecture
Informatica
Tableau Prep
BDT
Technical design documentation
Trainings
Mentorship
Locations
- San Francisco, CA
- Bengaluru, Karnataka, 560016
Certification
Tableau Desktop Specialist
Timeline
Business Intelligence Engineer - Amazon
05.2022 - Current
Tableau Desktop Specialist
01-2022
Business Analyst - Jacks of Retail PTE
01.2019 - 05.2022
Business Analyst - Reliance Retail Ltd.
01.2011 - 12.2018
IT Associate - CGI Information Systems and Securities Pvt. Ltd.
05.2010 - 01.2011
- Tableau Desktop Specialist,
Mumbai University - BE, Computer Engineering