Power BI Developer at Genpact (Payroll company: Quess Corp) (2024-07 – 2026-06)
- Collaborated with FP&A, Finance, and HR analytics, Insurance, stakeholders to gather business requirements and translate them into scalable Power BI solutions.
- Designed and developed interactive Power BI reports and SSRS reports, reducing manual reporting, report performance optimization and improving business decision-making.
- Built optimized data models, leveraging SSAS cubes, Power Query, DAX, and SQL Server (SSMS) for high-performance reporting.
- Developed advanced DAX measures, calculated columns, KPIs, trend analysis, forecasting, and time intelligence calculations to deliver dynamic financial insights.
- Created interactive reports using Bookmarks, Drill-through, Tooltips, Field Parameters, Button Navigation, Conditional Formatting, Slicers, Custom Visuals, and Dynamic DAX to enhance user experience and dashboard storytelling.
- Developed and maintained Semantic Models, Dataflow Gen2, and Pipelines ensuring reusable and governed data models.
- Managed the lifecycle of Power BI reports by updating data views in SQL, integrating new mapping tables, implementing enhancements, and collaborating with Data Engineers to resolve backend pipeline issues.
- Administered Power BI Service by managing Workspaces, Deployment Pipelines (Dev/UAT/Prod), Scheduled Refresh, Row-Level Security (RLS), Object-Level Security (OLS), Gateway, and report access governance.
- Implemented, deployed and update existing SSAS Cubes and Azure Analysis Services (AAS) processes and release management for seamless production deployments.
- Executed end-to-end ETL processes using Power Query, SQL, and Dataflows for efficient data transformation and integration.
- Knowledge of Copilot in Power BI to accelerate DAX generation, report development, and data analysis, with a working knowledge of AI-assisted BI capabilities.
- Conducted User Acceptance Testing (UAT) and documentation, while presenting analytical insights to leadership and promoting self-service BI adoption.
Business Analyst at Blockon Pvt Ltd (2024-01 – 2024-07)
- Gathered business requirements and created BRDs, FRDs, user stories, wireframes, and technical specifications.
- Conducted competitor analysis, user journey mapping, and feature feasibility for product enhancements.
- Built Power BI dashboards for sales, lead generation, customer acquisition, and KPI tracking.
- Developed Power BI reports using Excel, Power Query, and DAX for sales and revenue analysis.
- Created interactive executive dashboards with KPIs, drill-through, slicers, and dynamic visuals.
- Analyzed lead funnels, conversion rates, customer segments, and sales performance for business insights.
- Collaborated with Product, UI/UX, Development, and QA teams in an Agile environment.
- Prepared PRDs, FRDs, process flows, and acceptance criteria for project execution.
- Coordinated frontend/backend teams and supported UAT for successful product releases.
Business Intelligence Developer at Celebal Technologies (2021-06 – 2023-12)
Client: Starbucks
- Developed and maintained dynamic data visualizations, mobile layouts, and dashboards in Power BI to provide actionable insights to stakeholders.
- Demonstrated expertise in data integration using sources like Snowflake, Azure SQL Database, SAP, and SharePoint.
- Built and managed data models in Power BI, ensuring efficient and accurate representation of organizational data.
- Created DAX queries for computed columns and measures based on MOM, YOY, and fiscal year metrics.
- Implemented Row-Level Security (RLS) for tailored data visibility across departments and stakeholders.
- Designed logical columns, dimensional hierarchies, calculated measures, and aggregate mappings to meet business needs.
- Collaborated with stakeholders to understand requirements and deliver data-driven solutions aligned with business goals.
- Performed quality assurance and testing of Power BI solutions to maintain data accuracy and integrity.
- Delivered quality reports with thorough QA to PROD, enhancing customer satisfaction.
- Utilized SQL knowledge to develop Power BI reports and provided guidance on data analytics tools and techniques.
Business Intelligence Developer at Celebal Technologies (2021-06 – 2023-12)
Client: Pure Storage (USA Project)
- Migrated ChartIO reports to Power BI, maintaining functionality and logic consistency.
- Integrated multiple data sources including Amazon Redshift, PostgreSQL, Snowflake, and MySQL.
- Applied M Query for complex data transformations and leveraged the advanced editor for dynamic features.
- Utilized Power BI Service features such as Dataflows and Incremental Refresh for efficient data handling.
- Conducted data validation on ChartIO dashboards and SQL server.
- Created and modified SQL queries to meet project requirements.
