MRIDUSMITA BARUAH
Summary
Experienced Power BI Developer with nearly 4 years of hands-on BI expertise and over 7 years in various professional roles spanning analytics, support, and operations. Demonstrated track record in crafting engaging dashboards and reporting solutions utilizing Power BI, SQL, SSRS, and ServiceNow. Holds Microsoft Azure Fundamentals (AZ-900) certification, showcasing proficiency in cloud technologies. Skilled communicator with a customer-centric approach and a passion for ongoing skill development.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Power BI Developer
Netserv Technologies Pvt Ltd
Bengaluru
10.2021 - Current
- Handled and resolved SQL-related tickets in ServiceNow, supporting internal teams with data retrieval and issue analysis.
- Excellent experience in Designing Database Objects like tables, constraints, joins, user functions, views, indexes etc.
- Built and maintained SSRS reports to assist in service performance tracking.
- Designed SSRS reports based on SQL queries involving complex joins, CTEs, and subqueries to fulfill business reporting needs.
- Collaborated with business teams to clarify data needs and provide timely resolutions.
- Creating the reports as per client's requirements in the form of Table, Matrix, Parameterized reports and cascading reports.
- Designed different types of reports like Drill Down, Drill Through and Sub reports.
- Expertise in generating reports, configuring report server and scheduling report manager using SQL Server Reporting Services (SSRS).
- Experience on Report Design, Development and Deployment in SSRS.
- Designed and developed interactive Power BI dashboards using SQL and Excel data sources to visualize KPIs, trends, and forecasts.
- Translated business requirements into data models and reports using Power BI Desktop and Power BI Service.
- Implemented drill-through, drill-down, and tooltip pages to enhance dashboard interactivity and user experience.
- Developed custom visuals and slicers to enable flexible report filtering and self-service analytics.
- Created calculated columns, measures, and KPIs using DAX expressions to support dynamic calculations and business logic.
- Built and optimized star schema and snowflake data models using relationships and normalization techniques.
- Used Time Intelligence functions (YTD, QTD, MTD, SAMEPERIODLASTYEAR) to perform year-over-year and period-based analysis.
- Utilized Power Query (M language) to clean, shape, and transform data from multiple sources (Excel, CSV, SQL).
- Wrote complex SQL queries, joins, and subqueries to prepare data models used in Power BI reports.
- Scheduled auto-refresh in Power BI Service for SQL data sources with gateway configuration.
- Applied best practices such as removing unnecessary columns, disabling auto-date/time, and using SUMMARIZECOLUMNS instead of FILTER-heavy logic.
- Project: Victor BAU (Jan 2022 – Jan 2024)
- Project: HudsonsYard (Mar 2024 – Sep 2024)
E-Commerce Executive
Duroflex Pvt Ltd
Bengaluru
10.2019 - 05.2021
- Managed operations on platforms like Amazon, Flipkart, Shopify.
- Automated daily, weekly, and monthly reports in Excel and Power BI.
- Tracked orders, returns, and logistics using Vinculum, Capture tools.
- Additional Internal Projects
- Tatvam – Created Power BI dashboards for product sentiment analysis.
- Duroflex – Provided basic support on .NET-based modules.
- Dovetail – Worked as QA tester for UAT cycles and test execution.
Customer Support & Tech Roles
Accenture | British Telecom | Convergys
08.2017 - 10.2019
- Technical & customer support for telecom operations (UK & US clients).
- Promoted to Quality Analyst at Convergys—handled call audits and training.
- Delivered first-hand issue resolution, order tracking, and process optimization.
Education
Bachelor of Commerce (B.Com) - undefined
Delhi University
01.2017
Skills
- Power BI, SSRS, DAX, KPI Reports
- Databases: SQL Server, ServiceNow Reporting
- Cloud & Tools: Azure Fundamentals (AZ-900), NET (basic)
- Data Handling: Data Modeling, ETL Concepts
- Productivity: Excel (Advanced), PowerPoint
- Soft Skills: Communication, Collaboration, Problem Solving
Certification
- Microsoft Certified: Azure Fundamentals (AZ-900)
- Power BI Masterclass – Udemy
- Power BI Essential Training – LinkedIn
- Excel from Beginner to Advanced – Udemy
Languages
English | Hindi | Assamese
Timeline
Power BI Developer
Netserv Technologies Pvt Ltd
10.2021 - Current
E-Commerce Executive
Duroflex Pvt Ltd
10.2019 - 05.2021
Customer Support & Tech Roles
Accenture | British Telecom | Convergys
08.2017 - 10.2019
Bachelor of Commerce (B.Com) - undefined
Delhi University