HEMANTH
Bangalore
Summary
Data Analyst with extensive experience at Egis Engineering Pvt Ltd, specializing in data integration and transformation. Proficient in Azure cloud services and Power BI, developed self-service reporting solutions that improved decision-making efficiency. Implemented data governance protocols to ensure compliance and security, demonstrating strong problem-solving skills.
Overview
7
7
years of professional experience
Work History
Data Analyst
Egis Engineering Pvt Ltd
09.2024 - Current
- Responsible for managing the entire HR data domain, including the end-to-end delivery and maintenance of 6+ critical data products supporting HR operations and analytics.
- Implemented data ingestion pipelines using Azure Data Factory to efficiently collect data from various sources into Azure Data Lake Storage Gen2.
- Designed and implemented a multi-stage ETL pipeline in Azure Databricks, leveraging the medallion architecture (Bronze/Silver/Gold) to transform and store data in Delta tables, ensuring optimized performance, versioning, and data reliability for reporting.
- Implemented Unity Catalog for better data governance and delta sharing.
- Developed robust data governance and security protocols on Databricks using Azure Key Vault and Azure Active Directory, ensuring compliance with regulatory standards and data privacy requirements.
- Created a universal Power BI semantic models as a self-service layer, enabling business users to build their own reports easily with predefined measures and dimensions.
- Recreated and enhanced Smart Recruiters dashboards in Power BI, enabling HR and Talent Acquisition teams to analyze application funnels, conversion metrics, recruiter productivity, and offer acceptance rates.
- Supported end users by guiding them in report development, visualization best practices, and using the semantic model effectively.
- Developed multiple Power BI dashboards and reports using advanced DAX, data modeling, custom visuals, and applied row-level security (RLS) to control access by region, business line, or user role.
- Ensured data governance by implementing version control, naming conventions, performance tuning, and managing Power BI workspace structure and access.
- Reduced manual reporting by providing reusable data models and enabling users to create their own reports through self-service.
Power BI Support
ABINBEV
04.2023 - 09.2024
- Monitoring the service now ticketing tool and picking up the users requests and providing the solutions to fix the users issues.
- Managed the complete Power BI environment including workspaces, user roles, licenses, and data gateways.
- Configured and managed Premium Capacity in the Power BI Service to share apps to business users.
- Installed and maintained On-Premise gateway to provide secure data transfer between On-premise data and Power BI Service.
- Worked with PowerShell cmdlets and Power BI REST APIs to automate administrative tasks and improve efficiency.
- Hands on experience in PowerShell cmdlets, Rest APIs.
- Configure the workloads to manage the memory usage.
- Implemented governance with role-based access control (RBAC) and compliance monitoring.
Associate
Cognizant
09.2021 - 01.2023
- Handled Power BI-related support tickets using ServiceNow and Responded to user requests by identifying and fixing Power BI access and report issues.
- Managed Power BI admin tasks like setting up usage metrics, audit logs, user roles, tenant and dashboard settings.
- Configured and maintained Power BI Premium settings, including memory usage and capacity management.
- As a part of Power BI Administration, configured Usage metrics, Users, Audit logs, Tenant settings, Dashboard settings, Power BI App settings, Power BI Premium and premium Capacity settings.
- Configured and optimized workloads to manage memory and enhance report performance in Premium capacity environments.
- Created canvas app by using Excel, SharePoint and Power Automate for automating the admin tasks.
- Worked on screens, buttons, galleries, forms, variables and functions.
- Automated reporting processes, reducing manual effort through PowerShell, REST APIs, and reporting automation workflows.
Software Engineer
New Found Infotech
05.2019 - 09.2021
- Collaborated with business stakeholders to gather and review requirements, and analyzed data sources (SQL Server) for report design and development in Power BI Desktop.
- Designed and developed interactive Power BI dashboards and reports by integrating data from multiple sources using data blending techniques.
- Performed data transformation using Power Query, including operations like Split Columns, Group By, Append Queries, Merge Queries, Pivot, and Custom Columns.
- Created a wide range of visualizations including Maps, Line Charts, Area Charts, Column Charts, Bar Charts, Pie Charts, and Donut Charts to deliver actionable insights.
- Developed analytical reports using DAX functions such as Table, Aggregation, and Date & Time functions to enable deeper data insights.
- Integrated predictive analytics and business intelligence reporting for stakeholders.
Education
Bachelor of Technology - ECE
JNTU A University
05-2017
Skills
- Azure cloud services
- Data integration and transformation
- Secure data storage
- Workflow automation
- Database management
- Python programming
- Data visualization tools
- Data analysis and modeling
- Business intelligence solutions
- Scripting and automation
- API integration
- Collaboration platforms
Timeline
Data Analyst
Egis Engineering Pvt Ltd
09.2024 - Current
Power BI Support
ABINBEV
04.2023 - 09.2024
Associate
Cognizant
09.2021 - 01.2023
Software Engineer
New Found Infotech
05.2019 - 09.2021
Bachelor of Technology - ECE
JNTU A University