Rohan Ingalgaonkar
Senior Consultant at Agile Analytics- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Agile Analytics
-
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
-
-
-
Hudson
-
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
-
-
-
ZS
-
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
-
-
-
Birlasoft
-
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
-
-
-
Progen Business Solutions
-
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 -
Maeers M.I.T.School of Management and Research, Paud Road, Kothrud, Pune 411038
Bachelor of Computer Application -BCA, Computer Science