Sumiran Satsangi

Served: Wealth Management, Business Banking, Credit Cards, Marketing Analytics
• Spearheaded data-driven marketing strategies by building A/B testing frameworks, uplift models, and multivariate regression analyses to
optimize targeting and measure campaign effectiveness.
• Engineered scalable machine learning pipelines using Python (logistic regression, decision trees, clustering) to predict product uptake,
churn, and segmentation, increasing campaign ROI by 18%.
• Designed enterprise-grade Power BI dashboards using advanced DAX, complex data models, and performance-tuned visuals for executives.
• Developed robust ETL pipelines using SQL and Apache Airflow, consolidating data from 10+ systems and reducing data latency by 40%.
• Implemented data refresh schedules and workspace management in Power BI Service to ensure reliable and secure data delivery.
• Led full-cycle data lifecycle management—from cleansing and wrangling to model deployment and insight generation.
• Presented strategic insights in executive-ready formats, driving alignment across marketing, credit, and business teams.
• Collaborated cross-functionally with Data Engineering, Risk, and Marketing to define KPIs and build sustainable analytics frameworks.
• Led development of a unified marketing performance dashboard that consolidated 5+ campaign data streams, reducing manual analysis by
50+ hours/month and increasing stakeholder adoption by 70%.

Domains Served: Banking, Oil & Gas, Food & Beverages, Consumer Goods, Government Corporation, Retail
• Delivered customer and marketing analytics solutions, integrating survey, transactional, and behavioral data across industries.
• Built and automated ETL pipelines using SAS, SQL Server, and Power BI, reducing manual reporting effort by 65%.
• Developed predictive models in SAS for churn, segmentation, and NPS forecasting, collaborating directly with client-side data science teams.
• Managed Canada Posts CX (Customer Experience) program, analyzing CSAT, NPS, and delivery KPIs through dynamic dashboards and
monthly insights.
• Created tailored executive reports using PowerPoint + Power BI, presented directly to the CMO and senior leadership.
• Enhanced dashboard usability through DAX-powered bookmarks, drilldowns, and conditional visuals, enabling self-service analytics.
• Designed and applied Row-Level Security (RLS) roles in Power BI to restrict data access based on geography, department, or user role,
enhancing data governance.
• Standardized cross-client KPI logic and automated data pipelines, leading to a 25% reduction in reporting errors and saving 10+ analyst
hours/week across teams.

Domains Served: Retail, Banking, Insurance, Food & Beverages, CPG, Healthcare
• Executed high-impact analytics projects for brands like AB InBev and Mondelez, transforming B2B campaign data into tactical insights.
• Built Python-based churn models, increasing forecast accuracy by 22% and informing lifecycle marketing initiatives.
• Created SAS Studio models for credit risk, customer behavior segmentation, and campaign optimization.
• Developed optimized SQL scripts to accelerate delivery of ad hoc and recurring insight reports by 80%.
• Delivered user-friendly dashboards in Power BI and Tableau, applying best-practice design, row-level security, and business-friendly
navigation.
• Designed segmentation analytics dashboards to improve audience targeting and increase campaign ROI.
• Enabled data-driven campaign redesigns by analyzing test results across 3 product lines, driving a 17% increase in customer acquisition for a
global CPG client.

Served: Manufacturing, Energy, Oil & Gas, Healthcare, Retail
• Built and maintained SQL-based reporting systems and Tableau dashboards for market intelligence, improving data accessibility by 60%.
• Partnered with Mitsubishi Electric on cash flow modelling and financial gap analysis, contributing to long-term planning strategies.
• Implemented data warehousing solutions using MS SQL and SSIS, reducing manual consolidation errors and enabling real-time dashboarding.
• Modeled supply/demand dynamics using statistical tools to support strategic decisions in pricing, inventory, and production planning.
• Acted as primary data liaison for B2B client accounts, translating technical output into actionable business recommendations.
• Deployed forecasting models that improved supply-demand accuracy by 28%, directly supporting $5M+ in procurement decisions across
APAC and MENA operations.