Harika Vanamala
Williams Landing,Australia
Summary
Business intelligence professional with strong track record in delivering data-driven insights to support business strategies. Proven ability to design and implement data models and reporting solutions that align with organizational goals. Known for collaborative approach and adaptability, with proficiency in SQL and data visualization tools.
Overview
9
9
years of professional experience
Work History
Business Intelligence Developer (Insights Analyst)
Sigma Healthcare
06.2024 - Current
- Collected Business requirements from business stakeholders across different teams.
- Gathering data from various sources, performed data cleaning and transformation tasks to ensure data accuracy and consistency based on requirements.
- Engage with internal and external stakeholders to facilitate collaboration, enable data access, and provide consistent and strategically aligned
- Developed the views and scripts for power bi Reports.
- Developed and deployed Power BI back models and semantic models using Tabular Editor, based on data from the enterprise data warehouse, to facilitate self-service reporting and centralized reporting solutions.
- Develop and maintain data visualizations, dashboards, and reports that effectively communicate trends, insights, and performance to executive leadership and stakeholders.
- Provide data-driven insights and analysis to support development of key business initiatives, ensuring alignment with strategic priorities.
- Optimised the Power bi data models for better performance of Reports and Dashboards
- Prepare detailed documentation for Power BI reports, ad-hoc requests, and other data-related processes.
- Managed refresh of all Reports and Dashboards.
- Used Logic apps/Power Automate to schedule refresh the Power BI Reports
- Worked on Microsoft power applications
- Development of reports and presentations for senior management and program stakeholders.
- Mentoring power bi for internal team and Business users
- Strong attention to detail and problem-solving abilities
- Hand on experience with ADF
- As admin Managed Power bi platform and gateways.
- Experience in Power bi Fabric
Business Intelligence (BI) Consultant
NCS Group Australia
03.2022 - 04.2024
- Australian Electricity Market operator (AEMO) -Senior Power Bi consultant
- Understanding and gathering Business requirements from business owners across various business units in the company
- Gathering data from various sources, cleaning and transforming based on requirements.
- Extracted data from different sources like flat files, databases like SQL, Azure synapse and Databricks to power bi, implemented extract and transform [duplicated removal, datatype, format changes etc....] operations extensively in power query and modelling and created insights for Dashboard.
- Creating and Maintaining Process/Dashboard documentation on Confluence
- Worked on existing dashboard and created more insights and automated data sources to existing Dashboard.
- ETLs and data modelling in Power BI Cube
- Creating Ad-hoc reports using power BI and complex Dax queries.
- Developed Power BI reports and dashboards.
- Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
- Created power bi dataflows on power bi service.
- Worked on Regular BAU Reports and able to investigate the issues on Reports.
- Developed SQL queries/SQL code to validate the data such as checking duplicate, null values, truncated values and ensuring correct data aggregations.
- Created pipelines and updated existing pipelines.
- Extensive experience in communicating with Stakeholders effectively and improve reports as per client requirement.
- Managing refresh of all Dashboards
- As a power bi Admin maintained power bi service and resolved the issues for other teams
- Maintaining JIRA tickets to facilitate Agile Delivery/KANBAN.
Business Intelligence (BI) Consultant
ARQ Group
04.2022 - 02.2023
- Department of Environment water Land and Planning. Senior Power Bi consultant
- Responsibilities:
- Understanding the gathered requirements from business owners across various business units in the company
- Created ADF pipelines using activities like IF Condition, try catch error, copy data, stored procedure, set variable, execute pipeline and scheduled pipelines by creating triggers.
- Created secrets on Key vaults in UAT and PROD
- Deployed ADF Pipelines to UAT and PROD environments using DEV OPS
- Used Github for version controlling to store ADF Pipelines, created pull up requests to merge into main branch on Azure-Pass-Implementation
- Worked on SSIS packages and Deployed SSIS Packages to Destination servers
- Error handling of Pipelines
- Testing and validating pipelines.
- Developed Power BI reports and dashboards.
- Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
- Created power bi dataflows on power bi service.
- Worked on Regular BAU Reports and able to investigate the issues on Reports.
- Worked on Agile Methodologies, used Jira and Confluence.
- Extensive experience in communicating with internal and external stake holders.
Data Analyst
MLC Life Insurance
03.2020 - 03.2022
- Responsibilities:
- Gathering data from various sources, cleaning and transforming based on requirements.
- Understanding and gathering requirements from business owners across various business units in the company
- Extracted data from different sources like flat files, databases to power bi, implemented extract and transform [duplicated removal, datatype, format changes etc....] operations extensively in power query and modelling and created insights for Dashboard.
- Creating and Maintaining Process/Dashboard documentation on Confluence
- Worked on existing dashboard and created more insights and automated data sources to existing dashboard.
- Updated SSIS packages to perform ETL on data during ingestion into SQL -server.
- ETLs and data modelling in Power BI Cube
- Creating Ad-hoc reports using power BI and complex Dax queries.
- Developed Power BI reports and dashboards.
- Designed Power BI data visualisation utilising cross tabs, maps, scatter plots, pie, bar and density charts.
- Worked on Regular BAU Reports and able to investigate the issues on Reports.
- Developed SQL queries/Scripts to validate the data such as checking duplicate, null values, truncated values and ensuring correct data aggregations.
- Proficient use of MSSQL Server, SSIS and Power-BI to develop the solutions.
- Extensive experience in communicating with Stakeholders effectively and improve reports as per client requirement.
- Managing refresh of all Dashboards
- Maintaining JIRA tickets to facilitate Agile Delivery/KANBAN.
Power Bi Developer
Idle Brain Technologies
07.2019 - 02.2020
- Responsibilities:
- Strategic expertise in data collection, analysis, and visualization.
- Proficient use of MSSQL Server, SSAS (tabular), SSIS, SSRS and Power-BI to develop the solutions.
- Developed Power BI reports and dashboards from multiple data sources using data blending.
- Developed SQL queries/scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
- Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
- Comfortable in working with DAX studio by writing queries and observing query plans.
- Used techniques Measures, Filters, slicer, Hierarchy, Drill trough, Developed Adhoc reports.
Power BI Developer
UBN QTECH Solutions PVT Limited
08.2016 - 06.2019
- Responsibilities:
- Understand the requirements and functionality of the application from specifications
- Azure Data warehouse and Azure SQL database Worked with azure technologies like
- Worked on different native visualizations (table, matrix, kpl, gauge, various types of charts and maps) and custom visualizations (Multi slicer and Hierarchy slicer, Histograms, Shape maps, Bullets, heat Maps, etc.
- Implemented business functionality to create computed tables, Measures and columns using different kinds of DAX functions (Aggregate, Filter, Table valued, Mathematical, Information and text functions etc.
- Presented analytics using Date, Time Intelligence, Statistical, and Path functions.
- Created reports with parameters, bookmarks, drill down and drill through options.
- Used different types of slicers, filters (static and dynamic), cards, KPIs, and gauges.
- Created hierarchies, groups (list and bin), hidden fields, and custom functions.
- Worked with Power BI Templates, Datasets, Data flows, Content Packs, and App workspaces.
- Implemented Extract and Transform [duplicates removal, data type, format change etc.] operations extensively in Power Query
- Designed, Developed, tested and maintained tableau functional reports based on user requirements
- Implemented Database Testing to evaluate Power BI report data after development, provide report testing support and direction for the UAT and Quality teams.
- Developed various Views, Dashboards and customizing of Dashboards.
Data Analyst
Adactin Group of Pty Ltd
02.2016 - 07.2016
- Experience in writing simple /complex queries, views, join, stored Procedures, Functions, Triggers, User defined functions etc.
- Experience in Debugging, Error Handling and Deploying the SSIS Packages
- Experience in manual testing.
Skills
- Experience with Microsoft BI suite and programming languages
- Proficient in Tableau and Power BI
- SQL Server management
- Proficient in Windows and Linux operating systems
- Cloud technologies expertise
- Interactive dashboard development
- Equipment maintenance
- Automation
- ETL development
- SQL programming
- Project management
- Business analysis
- Dashboard design
- Business intelligence roadmap design
- Data modeling
Timeline
Business Intelligence Developer (Insights Analyst)
Sigma Healthcare
06.2024 - Current
Business Intelligence (BI) Consultant
ARQ Group
04.2022 - 02.2023
Business Intelligence (BI) Consultant
NCS Group Australia
03.2022 - 04.2024
Data Analyst
MLC Life Insurance
03.2020 - 03.2022
Power Bi Developer
Idle Brain Technologies
07.2019 - 02.2020
Power BI Developer
UBN QTECH Solutions PVT Limited
08.2016 - 06.2019
Data Analyst
Adactin Group of Pty Ltd
02.2016 - 07.2016
Similar Profiles
Austin ChengAustin Cheng
Warehouse Storeperson at Sigma HealthcareWarehouse Storeperson at Sigma Healthcare
Courtney RoylanceCourtney Roylance
Team Manager at Sigma HealthcareTeam Manager at Sigma Healthcare
Rami AbilahadRami Abilahad
PQC at Sigma healthcarePQC at Sigma healthcare
MANPREET REKHIMANPREET REKHI
Postal Delivery Officer at Australia PostPostal Delivery Officer at Australia Post
Sanjeev KhariSanjeev Khari
Store Manager of Operations at VodafoneStore Manager of Operations at Vodafone