Hi, I’m
Akshay Birare
Senior Power BI Developer
Pune,MH
Summary
Results-driven Business Intelligence (BI) Developer with extensive experience in designing, developing, and optimizing Power BI solutions to drive data-driven decision-making. Adept at migrating Tableau reports to Power BI, developing custom dashboards with complex DAX calculations, and improving performance efficiency through optimization techniques. Skilled in SQL procedures, ETL processes, and dimensional modeling, ensuring data integrity and efficient storage in enterprise analytics environments.
Overview
6
years of professional experience
3
years of post-secondary education
Work History
UBS Investment BankPune, Maharashtra
Senior Associate
09.2024 - Current
Job overview
- Spearheaded the development and migration of Power BI reports from Tableau, ensuring seamless data
transition and enhanced visualization compatibility. - Designed and developed complex, custom Power BI reports, incorporating advanced DAX calculations and
external integrations to resolve Tableau compatibility challenges. - Implemented different custom visual approaches like HTML content visuals, SVG's etc., within Power BI
reports, enhancing user experience and functionality. - Led the creation of sophisticated data models in Power BI to support the migration project, ensuring optimal structure and performance for reports transitioning from Tableau Server.
- Authored efficient SQL procedures to transform and process data from ODBC servers and managed query
for data bricks transition as well, optimizing data accessibility and performance. - Managed performance optimization initiatives, developing tailored techniques for improving report efficiency
and supporting native developers. - Provided technical mentorship to junior associates, guiding them through complex Power BI development
challenges and best practices. - Acted as the technical lead, assisting India and U.S. teams in resolving critical issues related to Power BI and
Tableau, ensuring smooth execution of BI solutions. - Oversaw cross-team communication and project coordination, collaborating with QA teams, developers, and
stakeholders to ensure timely delivery of high-quality reports.
Conducted walkthrough sessions for Tableau and Power BI developers, facilitating knowledge sharing on Databricks-connected Power BI development. - Developed a centralized Power BI application, consolidating reports for user access, testing, and streamlined navigation.
Motifworks An AccionLabs CompanyPune, Maharashtra
Power BI Developer
03.2023 - 09.2024
Job overview
- Designed, developed, and deployed end-to-end Business Intelligence (BI) solutions using Microsoft Power BI, translating complex business requirements into technical specifications.
- Maintained and optimized data analytics platforms, including the creation and management of OLAP cubes, ensuring efficient data storage and retrieval.
- Developed hybrid data models, including Power BI Dataflows, Composite Models, and Direct Query Models, utilizing star and snowflake schema approaches, leading to a 90% improvement in performance efficiency.
- Conducted unit testing and troubleshooting, ensuring the integrity and reliability of BI systems, resulting in a 15% enhancement in overall system performance.
- Evaluated and improved existing BI systems by integrating advanced ETL processes and dimensional modeling, streamlining data mining and warehouse design.
- Demonstrated expertise in database management systems and Online Analytical Processing (OLAP), enabling data-driven decision-making for key stakeholders.
- Developed and implemented automated ETL workflows using Power BI Dataflows, optimizing data processing and shared dataset management across the organization.
- Applied model and visualization optimization best practices, leveraging DAX analyzation tools such as DAX Formatter, DAX Studio, Tabular Editor, Bravo, and Power BI's built-in performance analyzer, significantly improving visual and query runtimes.
- Designed and implemented DRLS/RLS (Dynamic and Row-Level Security) strategies for embedded reports, based on system-generated GUIDs, ensuring secure access control.
- Managed dataset policies in Power BI Capacity Workspace, overseeing incremental refreshes, scheduled
refreshes, and large model enhancements, optimizing performance and scalability.
Neal AnalyticsPune, Maharashtra
Data Engineer
07.2022 - 02.2023
Job overview
- Conducted discrepancy analysis using Excel, Power BI, and Azure SQL (SSMS) to refine logistics data, finalizing key metrics and improving data quality by 50%, leading to enhanced model performance.
- Developed a centralized Power BI Dataflow on Synapse Analytics DW, leveraging Power Query within
Power BI Services Platform for streamlined data management. - Managed the ETL process for reporting datasets sourced from Azure Synapse Analytics DW, implementing star and snowflake schema models using import storage mode for optimized data retrieval.
- Enhanced data model performance by resolving errors, optimizing datetime fields, aggregations, and DAX calculations, resulting in over 60% improvement in query execution time.
- Designed and developed Power BI reports featuring tracking visuals and interactive elements, providing
valuable insights into shipping and logistics sales trends. - Implemented a deployment pipeline strategy, enabling seamless comparison and validation across
development, QA, and production environments. - Authored technical documentation on Azure Wiki and SharePoint, including STM (System Technical
Manual) and ERD (Entity Relationship Diagram) to support enterprise data governance and reporting standards.
Nimbja Security SolutionsPune, Maharashtra
Power BI Developer
10.2019 - 07.2022
Job overview
- Developed Power BI reports and interactive dashboards with email alerts to support HR analytics, enhancing data-driven decision-making.
- Transformed and optimized HR datasets from SharePoint and SQL Server using Power Query, ensuring data
accuracy and improved reporting efficiency. - Designed and implemented star schema data models for structured data transformation, leveraging import
mode connections for seamless analysis. - Authored user-friendly DAX calculations for key HR metrics, including Age Group Dynamics, Attrition Rate, Gender Insights, and Satisfaction Ratings, facilitating actionable insights.
- Created dynamic and insightful visuals from Power BI's native marketplace, tailoring dashboards to meet specific business requirements.
- Successfully deployed reports and dashboards to designated workspaces while managing access control via
Row-Level Security (RLS) for HR teams.
Skills
- Databricks SQL
- Azure Synapse Analytics
- SQL Server (SSMS)
- ODBC (Impala)
- Tableau Desktop
- Power BI Desktop
- Power Query (ETL)
- Query Folding (Optimization)
- Data Modeling (Composite, Hybrid, DQ etc)
- Data Visualization
- DAX Queries (Optimized)
- Creating and Importing Theme
- Dashboard Development
- Power BI Apps (Workspace App)
- Semantic Model
- Relationships & Cardinality
- Dataflow and Shared Datasets
- RLS & DRLS (Embedded)
- XMLA Endpoint Refresh
- Incremental and Scheduled Refresh
- Paginated Reports
- DAX Studio, Bravo, Tabular Editor,
- Performance Optimization Techniques
- Deployment Pipelines etc
- Attention Details
- Critical Thinking
- Leadership & Communication
- SSIS and SSAS Knowledge
- Data Warehousing
- Pandas, Numpy, Matplotlib, Seaborn etc
- EDA, Data Preprocessing and Data Modeling
- ARIMA model (Time Series)
Projects
Project 4: Investment Banking Report Transition
The project focused on the development and migration of business intelligence reports from Tableau to Power BI, ensuring a smooth transition while maintaining data integrity and improving visualization compatibility. Take care of query optimization of SQL while transition from Impala/SQL to Databricks Platform.
Project 3: Asset Usage Report, Portfolio Activity and Project Management Reports
Developed and deployed embedded reports of the user usage and activities within active state of subscriptions of clients to the subscription system platform which can be accessible by stakeholder to review and track the business activities.
Project 2: Watkins Wellness Freight and Sales Analysis
Logistic Watkins Wellness (Freight Analysis and Sales Analysis), Developed fresh business-oriented Power BI Reports, Power BI Dashboards, Paginated Report and Power BI Apps for the TRUCK and TRAX logistic systems generated logistic data, stored at Azure Synapse. Developed Optimized Report and Model for sales data with historical insights as well as the forecasted insights using AI techniques in Power BI.
Project 1: HR Aggregated Report
This report displays a traditional online, dynamic aggregate report. This report will allow group to see the results for participants that have completed assess competencies to the internal and client admin.
Education
University of Pune Pune
Bachelor Of Engineering from Electrical Engineering
08.2016 - 07.2019
Disclaimer
I hereby declare that the details and information given above are complete and true to the best of my knowledge.
Certification
- PL 300 (Microsoft Certified Data Analyst)
- Certified Data Scientist
Languages
English
Proficient
C2
Hindi
Proficient
C2
Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Work Preference
Work Type
Full TimeWork Location
RemoteHybridOn-SiteImportant To Me
Work-life balanceCareer advancementCompany CultureFlexible work hoursPersonal development programsHealthcare benefitsWork from home optionTeam Building / Company RetreatsStock Options / Equity / Profit SharingPaid time offTimeline
Senior Associate
UBS Investment Bank
09.2024 - Current
Power BI Developer
Motifworks An AccionLabs Company
03.2023 - 09.2024
Data Engineer
Neal Analytics
07.2022 - 02.2023
Power BI Developer
Nimbja Security Solutions
10.2019 - 07.2022
University of Pune
Bachelor Of Engineering from Electrical Engineering
08.2016 - 07.2019
Similar Profiles
Raj GaneshRaj Ganesh
Production Support Engineer at UBS Investment BankProduction Support Engineer at UBS Investment Bank
Shital HirveShital Hirve
Assosicate Director at UBS Investment BankAssosicate Director at UBS Investment Bank
Jonathan Tyler EmlerJonathan Tyler Emler
Sr Reconciliation Analyst (AO) at UBS Investment BankSr Reconciliation Analyst (AO) at UBS Investment Bank