Hema Narendra Babu Bazaru Email & Phone Number

Perth, Wa, Au

Australia

Australia

• Extracting data from various data sources and creating single data mart for reporting.• Turning complex data into actionable insights for a range of stakeholders• Analyzing the sales data to track performance metrics, identify trends, and provide insights to sales and marketing teams.• Creating and testing reports targeted for the Strategic Business Manager Delivery, other senior staff, and stakeholders.• Performed DDL, DML and DCL operation using complex querying. And integrated with the Power BI platform for data analysis.• Developing dashboards, new reports, and visualizations to support client needs.• Finding solutions to complex and technical problems involving data analysis and visualisation• Contributing to the development and implementation of strategies to facilitate data driven decision making that provide opportunities to improve the business.• Generated weekly and monthly reports on key sales and marketing KPIs for management review.• Undertaking research, Analysis and design of database models for Power BI migration.• Implementing the row Level security in Power Bi report to restrict data access for given users.• Collaborated with cross-functional teams to develop sales strategies, marketing campaigns, and promotional activities.

Sydney, New South Wales, Australia

. Designed and created database systems after reviewing end user’s requirements.. Developed Advanced SQL queries and stored procedures to generate data reports.. Load data into databases servers and ensure data quality as per the business requirements.. Experience in writing complex SQL queries, and performance tuning by creating/ modifying indexes, joins, views and changing the query structures.. Built extract, transform, and load (ETL) process to migrate data from multiple types of data sources ( SQL Server, oracle, Excel, SharePoint) to destination database server by using SSIS packages.. Been part of production support, to work with Business, to handle with any data issues, data analysis, data verification, change requests and production report requests.. Created/ modified the ETL processes to achieve the daily/monthly loading requirements.. Performed DDL, DML and DCL operation using complex querying. And integrating with the PowerBI platform for data analysis.. Developed visual reports, dashboards and KPI scorecards using PowerBI desktop.. Adept in developing, publishing and scheduling PowerBI reports as per the business requirements.

India

• Developed end to end solution with Data Integration, Data Management and Data Reporting.• Design and Development of Executive level POWER BI report with all the important KPI/Metrics DX Business.• Integrating datasets for all the KPI into tool and building Data Model to create relationship among the KPI.• Building complex calculation using DAX, Drilldown, Tool tips, Bookmarks and linkage of external reports.