Shalini

Power BI Analyst with 5 years of experience in designing, developing and maintaining interactive dashboards and reports that support business decision-making. Proficient in Power BI, DAX, Power Query, SQL and Excel with hands-on experience in data modeling, ETL processes. Strong analytical, problem solving and communication skills with a proven ability to deliver high-quality reports on time.

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.

Bachelor of Engineering - Electrical & Electronics - LCR College of Engineering & Technology, Tiruvallur (2007-06 - 2011-04)