Ambarish Karambelkar

Experience

• 

  CGI

  May 2010 - Jan 2011

  Associate Software Engineer

  Development of various applications in RTM (Real-time Transaction Manager System), a proprietary language of CGI Information Systems and Securities Pvt. Ltd.

• 

  Reliance Retail

  Jan 2011 - Dec 2018

   Worked closely with Ecommerce team to understand the process of overall business. Analyzed the information stored in SAP R3, Hybris, Sterling database and conceptualize the data warehouse model for implementing BI solution on it. Discussed with database and ETL team for sourcing of required data from various systems and integrating it in single reporting database. Multiple reports have been developed in SAP BO, SAP BW, HTML, Tableau to track critical KPIs of Ecommerce business and presented the same to Business teams. Successfully migrated complete data warehouse and BI report from ORACLE to SAP HANA. Show less  Worked closely with Project Team and Internal Business Partners (IPs) to clarify business requirements and translate the requirements into technical specifications. Discussed and understood various KPIs required for measuring or tracking performance of Supply chain process. Analyzed available reports as well as created new reports using existing data models and presented it to business teams. Worked closely with database and ETL team for sourcing required information from SAP ERP system to ORACLE database. Show less  Worked closely with Project Team and Internal Business Partners (IPs) to clarify business requirements and translate the requirements into technical specifications. Performed Source system analysis (SSA) of SAP R3. 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. Show less

  • Deputy Manager

    Apr 2018 - Dec 2018

  • Assistant Manager

    Apr 2016 - Mar 2018

  • Sr. Associate

    Apr 2013 - Mar 2016

  • Information Technology Associate

    Jan 2011 - Mar 2013
• 

  Jacks of Fiji

  Jan 2019 - May 2022

  Business Intelligence Analyst

  As a Business Intelligence Analyst i have successfully implemented BI solution for Jacks of Fiji Retail PTE. This BI solution which is built in Tableau required integration with multiple systems such as ERP (oracle 12 ) , WMS ( Sql Sever) and FTP files.With my previous experience in the same retail domain , In Jacks i could work on various other modules of retails business such as HR, Finance, Audit etc.

• 

  Amazon

  May 2022 - now

  Business Intelligence Engineer