Power BI Analyst - Hexaware Technologies
(2021-01)
- Developed dashboards and reports for clients using BI technologies like Power BI, using interactive charts, maps, bookmarks, drill-down, and drill-through pages and reports that suit business needs.
- Good experience in data modeling, such as adding calculated columns and measures, managing relationships, removing rows, replacing values, splitting columns, date and time columns, etc.
- Developing reports with KPI, YTD, QTD, MTD reports, Maps, Stacked bar/column, table, heatmap visuals, etc.
- Good knowledge of creating calculated measures, columns, and tables with Data Analysis Expressions (DAX).
- Creating Power BI dashboards and reports, deploying them into the cloud, and scheduling Power BI reports through Power BI Gateway.
- Experience in using visualizations like bar charts, cards, donuts, funnels, gauges, tables, matrices, pie charts, slicers, etc., and custom visualizations to represent data.
- Experience in security implementation in Power BI using Row-level security to restrict data access
- Coordinated the extraction of data from SQL Server, Oracle, and Snowflake to Power BI and configured data connections.
- Performed troubleshooting and analysis of Power BI reports.
- Worked closely with the data team to analyse data models for the procurement of business data
Power BI Analyst - Hexaware Technologies
(2024-02)
Project 3: Workforce Revenue Analytics & Staffing Performance Dashboard for Samsung India. Domain: Staffing and Revenue.
- Implemented Power BI (Desktop) and Excel for quick dashboarding and planning related to project and data activities.
- Extracting the data from various data sources into Power BI Desktop and transforming the data in Power Query Editor.
- Created sub-reports, drill-down reports, summary reports, and parameterized reports in Power BI and performed documentation and unit testing.
- Worked on row and column grouping and charts. Created test cases and validated Power BI reports.
- Imported data from SQL Server DB to Power BI for generating the reports.
- Developing applications for HR for the recruitment process and finance for their revenue process and reporting.
- Built reports and input templates in support of finance and accounting operations (SQL, DAX, VBA, and plain old Excel formulas/functions).
- Worked with the finance team to monitor the asset management system.
Power BI Analyst - Hexaware Technologies
(2023-03 - 2024-12)
Project 2: Retail Sales Performance & Business Intelligence Dashboard for The Kroger Company of America. Domain: Sales.
- Extracting data from multiple sources like flat files, Excel, and SQL Server; validating data; and loading it into the final destination.
- Good experience with Power Query, Power Pivot, Power View, and DAX functions. Creating drill-down and drill-through reports.
- Used Quick Measure functionality to create filters, time intelligence, and totals. Used the Edit Interaction functionality to create an interaction between visuals.
- Developing visualization reports and dashboards using Power BI.
- Have good experience in implementing RLS as part of security.
- Working with gateways, scheduling the refresh, and creating reports and dashboards. Involved in installing and configuring gateway services for Power BI Desktop.
- Updating the weekly status and keeping track of the overall development status for the project.
Power BI Analyst - Hexaware Technologies
(2021-04 - 2023-01)
Project 1: Financial Performance & Executive Reporting Dashboard for Accounting Plus Financial Services, Canada. Domain: Finance & Financial Analytics.
- Collaborated with business stakeholders, finance managers, and business analysts to gather reporting requirements and translate them into interactive Power BI dashboards.
- Connected Power BI to Oracle databases and extracted financial data using optimized SQL queries and views.
- Developed interactive dashboards and executive reports to monitor financial performance, revenue trends, expenses, profitability, budget variance, and cash flow.
- Created advanced DAX measures, calculated columns, and KPIs for YTD, MTD, QoQ, YoY, Rolling 12 Months, Budget vs Actual, Gross Margin %, and Profitability Analysis.
- Developed visualizations using Line Charts, Clustered Bar Charts, Stacked Column Charts, Pie Charts, Tree Maps, Waterfall Charts, Gauge Charts, KPI Cards, Matrix Tables, Maps, Scatter Charts, Funnel Charts, and Slicers.
- Implemented drill-down, drill-through, bookmarks, tooltips, and dynamic filtering to improve end-user experience.
- Optimized report performance by reducing model size, improving DAX calculations, and removing unnecessary columns.
- Published reports to Power BI Service and managed datasets, workspaces, and report access.
