Vishal Indramohan
131A Waterloo Road, Hutt Central,Wellington, New Zealand
Summary
An enthusiastic and motivated Power BI Visualization Developer with a proven track record of transforming complex data into actionable insights using tools such as SQL, R, Power BI, Tableau, and Qlik. Spearheaded major reporting transitions, demonstrated seamless stakeholder engagement and facilitated significant improvements in data accuracy and reporting processes.
Overview
9
9
years of professional experience
Work History
Power BI Admin
Te Whatu Ora – Health NZ
Wellington, New Zealand
01.2024 - Current
- Collaborating with the global admin regarding Power BI tenant settings to ensure the security of the data published through the Power BI reports
- Influencing the teams with key points on the maintenance of Power BI reports and workspaces to ease the management of the report registry
- Spearheading the user management process to ensure appropriate security groups are created for the Power BI reports in designated business workspaces
Reporting and Visualization Developer
Te Whatu Ora – Health NZ
Wellington, New Zealand
10.2023 - Current
- Identified the inaccuracies in the data extract, rectified them using tools such as Power BI, SQL and R to wrangle them and reported for future changes in the structure of the data
- Successfully spearheaded the transition of MS Excel monthly and quarterly reports to Power BI reports, and automated them
- Portrayed excellent communication and interpersonal skills with the stakeholders and team colleagues to gather, manipulate and store the data in MS SQL database, enabling weekly refresh of the reports in Power BI
- Re-worked an entire project to expand the level of details visualized in the dashboard as per stakeholder’s new requirements
- Gathered new business requirements for dashboard development from stakeholders by collaborating with the project manager and senior data engineer
- Through intricate analysis using SQL queries, I pointed out the inaccuracies in the data at its source and got them rectified for effective visualizations in Power BI
Data Analyst
Te Whatu Ora - Health NZ
Wellington, New Zealand
05.2023 - 08.2023
- Reconciliation of the hospital ward data present in three different instances and assist the team to understand utilization of beds across New Zealand using tools like MS Excel and R
- Performed data extraction from two external systems, such as Qlik and Snowflake databases, and from national database
- Analyzed and wrangled the data in MS Excel to identify and rectify the inaccuracies in the data spotted in different sources and performed Exploratory Data Transform using Power BI for reporting purposes
- Presented the discrepancies in the data to the stakeholders for investigation using MS PowerPoint slides, and changes were implemented to extract the correct data from its source for Power BI report development
Data Analyst
Te Whatu Ora – Health NZ
Wellington, New Zealand
06.2022 - 02.2023
- Worked on the National Collections datasets to extract sensitive patient level encrypted information suitable for the Equity analysis using SQL queries
- Through data manipulation techniques in Power BI and R, converted the data into useable format and created a dashboard to bring out a clearer story about the data
- Story through the visuals had provided valuable insights on hospital in-patient and outpatient data and equity gaps in the dental services to children of different age groups using Power BI and Excel
- Coordinated with my manager in consolidating these insights in an MS PowerPoint for the presentation to the external stakeholders
Data Analyst
University of Canterbury (EPEC Center)
New Zealand
11.2019 - 02.2020
- Coordinated with the University of Canterbury and EPEC center, working on the household data installed with the virtual power plant in 35 houses present in Christchurch and Wellington
- Performed ETL process by extracting the data from the cloud using Kibana and converted into CSV format and performed data wrangling
- Analyzed the data, providing data insights and solutions to the business on outlier detection and manipulation, null data handling, etc
- Using PySpark
- Provided business with a statistical overview of the Electrical distribution of power throughout the day using Power BI and Tableau
Programmer Analyst
Cognizant Technology Solutions
India
05.2016 - 07.2019
- Business and Process Analysis and providing design solutions
- Process mapping, code maintenance, and debugging
- Handling customer queries/tickets related to healthcare claims
- Maintenance of the client details using SQL database
- Producing project reports documentation using MS Office suite
- Mentored in knowledge transfer during handover to Tech Mahindra
Education
NZQA Level 9 - Applied Data Science
University of Canterbury
Christchurch, New Zealand01.2020
Bachelors - Electrical and Electronics Engineering
R.M.K Engineering College
India01.2019
Skills
- Power BI
- Tableau
- SQL
- Snowflake
- R
- Data Wrangling
- Data Mining
- Statistical concepts
- RShiny
- Python
- PySpark
- MS Excel
- Microsoft Office suite
- Qlik
- Microsoft Azure
- Community Pharmacy
- Adolescent Oral Health
- Banking
- Insurance
- Workforce
References
References available upon request.
Timeline
Power BI Admin
Te Whatu Ora – Health NZ
01.2024 - Current
Reporting and Visualization Developer
Te Whatu Ora – Health NZ
10.2023 - Current
Data Analyst
Te Whatu Ora - Health NZ
05.2023 - 08.2023
Data Analyst
Te Whatu Ora – Health NZ
06.2022 - 02.2023
Data Analyst
University of Canterbury (EPEC Center)
11.2019 - 02.2020
Programmer Analyst
Cognizant Technology Solutions
05.2016 - 07.2019
NZQA Level 9 - Applied Data Science
University of Canterbury
Bachelors - Electrical and Electronics Engineering
R.M.K Engineering College
Similar Profiles
TANIA HUESTONTANIA HUESTON
Clinical Nurse Manager Patient Management Services at Te Toka Tomai | Auckland | Te Whatu Ora Health NZClinical Nurse Manager Patient Management Services at Te Toka Tomai | Auckland | Te Whatu Ora Health NZ
Olepa BinataakeOlepa Binataake
Health Care Assistant at Te Whatu Ora Health NZHealth Care Assistant at Te Whatu Ora Health NZ
DIANNE GJALTEMADIANNE GJALTEMA
Enrolled Nurse at Te Whatu Ora / Health NZEnrolled Nurse at Te Whatu Ora / Health NZ
Stegy StegyStegy Stegy
PGY1- PGY2 House Officer at Te Whatu Ora Health NZ WaikatoPGY1- PGY2 House Officer at Te Whatu Ora Health NZ Waikato
Kavya VysyarajuKavya Vysyaraju
Tutor at Mathematics TeachingTutor at Mathematics Teaching