Subashini

Results-driven Power BI Developer with 4+ years of experience designing and deploying enterprise-grade dashboards and analytical reports across banking, insurance, e-commerce, and promotional products domains. Proficient in Power BI Desktop, Power BI Service, DAX, Power Query, SQL Server, and data modeling. Skilled at translating complex business requirements into actionable visual insights, implementing Row-Level Security, optimizing report performance, and collaborating with cross-functional stakeholders in Agile environments.

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.

Bachelor of Computer Applications in BCA – Dr. Nallikuppusamy Arts College (2018 – 2021)