Power BI Developer at AllDigi Tech Limited (2024-07 – 2026-02)
Power BI Developer at AllDigi Tech Limited (2024-07 – 2026-02)
The Bank of Missouri | Banking
- Gathered requirements from Credit Card Operations and Risk teams to develop detailed dashboards covering card issuance, activation, spending behavior, and revenue tracking.
- Extracted and transformed credit card transaction data from SQL Server and Databricks using Power Query, ensuring accurate cleansing and reconciliation.
- Designed optimized data models and created advanced DAX measures for KPIs including Card Activation Rate, Transaction Volume, Average Spend per Customer, Credit Utilization Ratio, Delinquency Rate, and Interest & Fee Income.
- Built and deployed a Credit Card Performance Dashboard covering transaction trends, merchant category analysis, region-wise usage, overdue accounts tracking, and fraud monitoring indicators.
- Improved transaction monitoring efficiency by 30% and reduced manual reporting efforts by 40% through dashboard automation.
- Automated data refresh and implemented Row-Level Security (RLS) in Power BI Service, ensuring secure real-time access for Finance and Credit Operations teams.
- Collaborated with Risk and Finance teams to analyze customer spending patterns, identify high-risk accounts, and support strategic decisions for credit limit adjustments and campaign targeting.
Power BI Developer at Trayee Business Solutions Pvt Ltd (2021-09 – 2024-06)
Power BI Developer at Trayee Business Solutions Pvt Ltd (2022-11 – 2024-06)
iPromo | E-Commerce
- Gathered and analyzed business requirements from Sales, Marketing, Finance, and Operations teams to build comprehensive BI solutions.
- Extracted, transformed, and validated large datasets from SQL Server covering sales, orders, inventory, vendors, and customer data.
- Designed and developed interactive dashboards in Power BI Desktop to monitor KPIs such as Revenue, Gross Margin, Order Volume, AOV, Customer Retention Rate, and Product Performance.
- Built a Sales Performance Dashboard to track region-wise sales, top customers, seasonal trends, and sales representative performance.
- Developed a Marketing Campaign Dashboard to measure campaign ROI, lead conversion rate, promotional product demand, and repeat purchase trends.
- Created an Inventory & Fulfillment Dashboard to monitor stock availability, backorders, vendor lead time, and order shipment status.
- Reduced reporting time by approximately 35% by automating manual Excel-based reports.
- Implemented drill-through, slicers, bookmarks, and dynamic filtering to enhance user experience and decision-making.
- Created role-based dashboards for Sales Managers, Marketing Heads, and Operations Teams to support department-specific KPIs.
- Documented data flow, report logic, and KPI definitions to maintain reporting standards and governance.
- Published reports to Power BI Service, configured scheduled refresh, managed workspaces, and applied Row-Level Security (RLS).
Power BI Developer at Trayee Business Solutions Pvt Ltd (2021-09 – 2022-11)
AFLAC (American Family Life Assurance Company of Columbus) | Insurance
- Analyzed end-to-end insurance lifecycle data including policy issuance, endorsements, renewals, claims processing, and cancellations.
- Extracted large volumes of structured data from SQL Server; performed data cleansing, transformation, and validation to ensure reporting accuracy.
- Designed optimized data models with fact and dimension tables for Policy, Claims, Premium, Agents, and Customers.
- Developed advanced DAX measures for KPIs such as Loss Ratio, Claim Settlement TAT, Policy Lapse Ratio, Renewal Rate, Premium Growth %, and Agent Commission.
- Built a Claims Performance Dashboard to monitor claim trends by product type (accident, cancer, critical illness), approval rate, and average payout amount.
- Created a Policy & Underwriting Dashboard to track new policies issued, pending approvals, underwriting turnaround time, and risk categorization.
- Developed a Financial & Premium Dashboard to analyze premium collections, overdue payments, revenue growth, and profitability metrics.
- Designed an Agent Productivity Dashboard to evaluate sales performance, policy conversion ratio, and commission tracking.
- Improved dashboard performance by optimizing DAX queries, reducing report load time by 20–25%.
- Published reports to Power BI Service, configured gateways, scheduled refresh, and applied Row-Level Security (RLS).
- Supported monthly and quarterly executive review reporting with automated KPI summary dashboards.
