Ambarish Karambelkar

Ambarish Karambelkar

Associate Software Engineer

Followers of Ambarish Karambelkar340 followers
location of Ambarish KarambelkarFremont, California, United States

Connect with Ambarish Karambelkar to Send Message

Connect

Connect with Ambarish Karambelkar to Send Message

Connect
  • Timeline

  • About me

    BI Consultant & Business Analyst | Retail & Ecommerce Logistics & Supply chain Analyst | Tableau | ORACLE | ERP

  • Education

    • University of Mumbai

      2005 - 2009
      Bachelor of Engineering - BE Computer Engineering
  • 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
  • Licenses & Certifications

    • ASP.NET 2.0

      NIIT Limited
      Oct 2010
    • Tableau Desktop Specialist

      Tableau
      Jan 2022
      View certificate certificate
    • VC#.Net

      NIIT Limited
      Jun 2010