Rohan Ingalgaonkar

Senior Consultant at Agile Analytics
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Sydney, New South Wales, Australia, AU

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • Australia
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Senior Consultant
      • Feb 2022 - Present

      Sydney, New South Wales, Australia Agile Analytics is a specialist consulting firm with teams across Australia, Philippines, India, New Zealand, the Mid East and the US, an Azure Analytics Advanced Specialisation Partner and a Microsoft Partner in Digital and App Innovation as well as Data & AI. We consult, design, and deliver tailored and transformative data analytics and technology solutions to mid-to-large size organisations across the world. Our Mission is to empower every organization to embrace a data-driven… Show more Agile Analytics is a specialist consulting firm with teams across Australia, Philippines, India, New Zealand, the Mid East and the US, an Azure Analytics Advanced Specialisation Partner and a Microsoft Partner in Digital and App Innovation as well as Data & AI. We consult, design, and deliver tailored and transformative data analytics and technology solutions to mid-to-large size organisations across the world. Our Mission is to empower every organization to embrace a data-driven approach by design, unlocking the potential of data-led transformation and innovation Show less

    • Australia
    • Staffing and Recruiting
    • 500 - 600 Employee
    • Power BI Consultant
      • Nov 2021 - Dec 2021

      Sydney, New South Wales, Australia -Assisted the Head of Finance & Planning in developing key financial reports like Profit and Loss Statement, Gross Margin reports, Variance analysis report for budget and forecast using Power BI -Analyzed large data sets and prepared a structured data model to increase interactivity between various data sources like D365, Excel, Azure -Using time intelligence DAX functions, implemented functionality to compare the data across different time periods -Implemented best practices for data… Show more -Assisted the Head of Finance & Planning in developing key financial reports like Profit and Loss Statement, Gross Margin reports, Variance analysis report for budget and forecast using Power BI -Analyzed large data sets and prepared a structured data model to increase interactivity between various data sources like D365, Excel, Azure -Using time intelligence DAX functions, implemented functionality to compare the data across different time periods -Implemented best practices for data visualization and modelling technique to ensure that the reports were dynamic, easy to use and provided quick insights to make informed business decision -To assist in technical innovation in the ongoing structural transition within Hudson, ensured that all reports were delivered defect-free and within the planned deadlines Show less

    • United States
    • Business Consulting and Services
    • 700 & Above Employee
    • Senior Business Intelligence Consultant
      • Nov 2021 - Dec 2021

      Pune, Maharashtra, India -Worked as an external BI consultant for ZS Associates and assisted them in setting up Sales dashboards using Power BI for their US based pharmaceutical client -Coordinated with the Sales Operations team to understand business requirements and to define their Sales KPI metrics -Consolidated data from various sources like IQVIA and Speciality pharmacies for analysing sales data across different data points -Developed interactive reports with KPI scorecards for sales executives that… Show more -Worked as an external BI consultant for ZS Associates and assisted them in setting up Sales dashboards using Power BI for their US based pharmaceutical client -Coordinated with the Sales Operations team to understand business requirements and to define their Sales KPI metrics -Consolidated data from various sources like IQVIA and Speciality pharmacies for analysing sales data across different data points -Developed interactive reports with KPI scorecards for sales executives that helped them in monitoring daily sales activities, identifying target sales areas and to improve overall process efficiency -Prepared competitor analysis reports for all products in the HIV medication segment Show less

    • India
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Senior Business Analyst
      • Jun 2020 - Nov 2021

      Pune Area, India -Worked with the Digital Transformation and Operations Excellence teams and leveraged Power BI reports to generate actionable insights for cost savings and process improvements -Developed 50+ Power BI reports for the four core functions of the organisation: Finance, HR, IT and Travel, that led to cost savings in each department -Automated redundant manual tasks through Power BI reports by using complex transformations and data modelling techniques which led to FTE savings of more than… Show more -Worked with the Digital Transformation and Operations Excellence teams and leveraged Power BI reports to generate actionable insights for cost savings and process improvements -Developed 50+ Power BI reports for the four core functions of the organisation: Finance, HR, IT and Travel, that led to cost savings in each department -Automated redundant manual tasks through Power BI reports by using complex transformations and data modelling techniques which led to FTE savings of more than 300-Man Days -Conducted Power BI training's for 100+ employees in the organisation

    • Business Analyst
      • Jun 2019 - Jun 2020

      Pune, Maharashtra, India

    • Trainee
      • Jun 2018 - Jun 2019

      Pune, Maharashtra, India

    • India
    • Software Development
    • 1 - 100 Employee
    • Associate Business Analyst
      • Nov 2017 - Apr 2018

      Hyderabad Area, India -Worked closely with the Senior Management of this startup and assisted them in development and maintenance of dashboards and reports on the in-house developed BI Tool called Pi- -Assisted the Lead Business Analyst in gathering requirements and documented the minutes of the meeting and prepared BRD’s based on the inputs

Education

  • Symbiosis Institute of Computer Studies and Research
    Master of Business Administration - MBA, Data Modeling/Warehousing and Database Administration
    2016 - 2018
  • Maeers M.I.T.School of Management and Research, Paud Road, Kothrud, Pune 411038
    Bachelor of Computer Application -BCA, Computer Science
    2013 - 2016

Community

You need to have a working account to view this content. Click here to join now