Barid Baran Bej

- - Barid Baran Bej linkedin.com/in/baridbaranbej/  Bengaluru, Karnataka  Analytics Leader with 17+ years of experience driving enterprise-wide analytics strategy, building high-performing COEs, and delivering business impact across Banking, Insurance, Pharma, Retail, and Telecom. Proven expertise in BI & Data Science (Power BI, Tableau, SQL, Python, SAS, Cloud) with a strong focus on governance, cost optimization, and scalable reporting frameworks. Adept at partnering with global stakeholders, managing multi-million-dollar analytics budgets, and shaping analytics roadmaps that enhance customer engagement, operational efficiency, and profitability. Skills Tableau SAS Excel VBA PySpark DataFlux Teradata Power BI Python ETL AWS Redshift Executive Storyboarding (Excel/PowerPoint) Microsoft SQL Server Marketing Analytics VB.net C++ Oracle PL/SQL Education Umesh Chandra College, University Of Calcutta B.com(Hons) - Accountancy Kolkata, West Bengal Jun 2006 NIIT, NIIT GNIIT - Compute Programming Language Kolkata, West Bengal Aug 2006 Great Lakes, Great Lakes And Texas Mccombs PG - Artificial Intelligence and Machine Learning Sep 2025 Dezyre Academy Certification - Big Data and Hadoop Persuing Experience Empower Senior Manager / Consultant Bengaluru Apr 2020 - Present (Retirement & Insurance Domain | Tools: SAS, SQL Server, Tableau, VBA, Python, AWS Redshift | Focus: Finance Analytics Leadership, Business Intelligence, COE Development, Budgeting, Team Management & Reporting) Key Contributions: Finance Analytics & Business Intelligence Solutions Hands on development of a multi-technology BI reporting suite (Tableau + VBA) leveraged by 300+ Relationship Managers (RMs) for commission tracking, performance goal reviews, and predictive target setting. Forecasted profit margins and LTV scenarios to support product-level optimization decisions, directly influencing business growth. Partnered with data engineering teams to design and build a centralized data mart in AWS Redshift, serving as the backbone for enterprise BI dashboards and financial reporting solutions. Delivered business intelligence solutions that integrated SAS-curated data with Tableau dashboards, enhancing visibility into assets under management (AUM), revenue, profit margins, and participant risks. Dashboarding & Strategic Insights Designed and delivered Finance & Retention dashboards for Core RMs, tracking retention, NPS, plans at risk, engagement metrics, and sales opportunities. Supported quarterly business reviews (QBRs) and commission decisions with interactive BI dashboards, accelerating executive visibility and decision-making. Built BI frameworks to identify controllable vs. uncontrollable risk factors, providing proactive insights on retention and revenue risks. Delivered QBR-ready BI storyboards for senior leadership, integrating financial analytics with product performance. Leadership & Team Development Expanded and managed the Finance Analytics team (8 direct, 3 indirect reports), aligning resources to high-impact business areas and scaling BI adoption across the enterprise. Oversaw analytics budgeting and resource allocation to maximize ROI and ensure sustainable delivery for Finance and Retirement analytics programs. Established a COE-style analytics hub within the Finance team, centralizing reporting processes and governance for consistency and efficiency. Led talent development initiatives, including hiring high-performing analysts and managing Empower’s internship program -) to strengthen the talent pipeline. Conducted analytics and BI workshops, mentoring analysts on financial domain knowledge, dashboard storytelling, and advanced statistical analysis. JP Morgan & Chase AVP Bengaluru May 2017 - Mar 2020 (Banking Domain | Tools: SAS, Teradata, VBA, Excel, Python, PySpark | Focus: Client Remediation, Risk Analytics, COE Development, Regulatory Compliance, Team Management & Reporting) Key Contributions: Centralized Corrections & Client Remediation Analytics (GAC Team) Built and scaled the remediation analytics team from 2 FTE to 12 FTE in one year, overseeing hiring, capability development, and governance alignment. Directed client remediation programs to identify impacted populations, quantify charges/interest, apply remediation rules, and execute compensation strategies for Consumer Banking, Cards, and SCRA products. Partnered with compliance and audit teams to ensure remediation frameworks met regulatory standards and minimized legal exposure, while protecting customer relationships. Transitioned legacy reports into audit-ready, governance-compliant models, improving transparency, traceability, and regulatory submission readiness. Automated key remediation dashboards in SAS/VBA, saving FTEs and improving accuracy of compliance reporting. Established and led the Consumer & Cards Remediation Analytics COE, balancing regulatory mandates with marketing campaign analytics for credit cards (cross-sell, retention, Sapphire & SCRA campaigns). Machine Learning Initiative – Call Centre Remediation & Optimization (CFO-Sponsored POC) Formed and managed a cross-functional team to deliver an ML-based POC targeting call centre inefficiencies and remediation of client servicing delays. Designed and implemented a Data Lake + ingestion pipeline to support regulatory audit trails and model deployment. Scaled the initiative into a dedicated 4-member remediation analytics team, embedding ML-driven forecasting into BAU operations. Developed an RNN-LSTM model to forecast call volumes, optimize staffing, and reduce delays, improving compliance and customer satisfaction. Wells Fargo Analytics Consultant Bengaluru Sep 2016 - May 2017 (Banking Domain | Tools: Tableau, SAS, Oracle | Focus: Team Management, Analytics, MIS Development, Reporting, Technical Consulting) Key Contributions: Credit Risk Analytics & Reporting Designed and developed data structures and data marts to enable efficient report delivery and support analytical requirements. Applied text mining techniques on credit bureau data to generate insights into credit card customer behaviour and risk patterns. Migrated all existing reports to Tableau, creating a scalable reporting framework to support future analytical use cases. Established credit risk models (PD, LGD, EAD) aligned with regulatory risk frameworks and audit standards. Provided technical consulting and cross-team collaboration to enhance analytics adoption across risk management functions. HSBC Assistant Manager Analytics Bengaluru Sep 2013 - Sep 2016 (Banking Domain | Tools: SAS, Excel VBA, Tableau, Python, MS Access, Apache Spark | Focus: Client Remediation, Global MIS Development, Advanced Analytics, Reporting, Project Management & Technical Training) Key Contributions: Client Planning & Wallet Share Management Directed remediation programs ensuring compliance in client targeting, product allocation, and wallet share management across 2M+ customer population in priority markets. Designed allocation models to optimize wallet distribution across subscribed products, improving revenue alignment with client potential. Automated MIS processes using SAS & VBA, driving efficiency gains equal to 2 FTE savings. Delivered cost–benefit analyses, risk assessments, and project communication frameworks to support global remediation and allocation programs. Global Banking – Business Banking Customer Analytics & MIS Built and deployed dashboards across 11 priority markets to track deal lifecycle, time-to-conversion, and RM performance, creating global consistency in MIS and insights delivery. Reengineered frameworks for “New to Bank” customer acquisition and product subscription tracking, enabling global leadership to optimize onboarding strategies. Partnered with MENA stakeholders to improve product allocation, profit strategies, and retention across Large Corporate and Mid-Market segments. Machine Learning & Advanced Analytics Projects Led ML pilots to identify deal conversion delays, highlighting RM transfers and product T&C complexity as key drivers. Conducted studies on pricing effectiveness and revenue uplift using statistical modeling (moving averages, ARIMA) and Apache Spark for large-scale data analysis. Provided actionable recommendations that influenced revenue strategy, product positioning, and remediation of systemic bottlenecks. Cognizant Associate Gurgaon Feb 2012 - Sep 2013 (Pharma Domain | Tools: SAS, SQL Server, VBA | Focus: Project Management, MIS Development, RDBMS Consulting) Key Contributions: Market & Competitive Insights (MMI Projects) Designed and delivered performance dashboards for senior management to track business outcomes and market trends. Built a competitive analysis framework for MMI teams, enabling upselling strategies across multiple markets. Produced trend reports (regular and ad-hoc) for marketing managers to support decision-making on product positioning. Generated insights into the role of Pharmacy Benefit Managers (PBMs) and payers in influencing drug sales, promotion, and customer behavior. Data Structuring & Digital Marketing Analytics (LMI Projects) Defined and developed data structures to align future pharma data storage and analysis requirements. Built frameworks to analyze monthly digital marketing effectiveness and forecast future engagement trends. Developed MIS reports (bi-weekly/monthly) to identify drug sales trends across therapeutic areas. Customer & Field Force Analytics (CDI Projects) Created analytical reports to measure medical representatives’ performance in doctor interactions. Designed targeting models and sample delivery rules to optimize field assignments and sample distribution strategies. Enabled sales and marketing teams to track rep productivity and refine engagement models. Evaluserve Senior Business Analyst Gurgaon Apr 2010 - Feb 2012 (Telecom & Retail Domains | Tools: Oracle (Unix), SQL Server, VBA, SAS, ETL Tools | Focus: Project Management, MIS Development, Campaign Analytics, Marketing Insights) Key Contributions: Project Manager – Retail Domain Conducted onsite business development in Hamburg, Germany for a pilot project with a leading skin care client. Led requirement gathering, project setup, and managed a 13-member team across India, China, and Romania. Designed a data model to harmonize and align SKU-level data for consistent reporting. Built a data cleansing and standardization framework to support reporting, enable market penetration analysis, and deliver competitor benchmarking. Managed a total team size of 15 analysts across global offices. Lead Developer – Media Domain (Attribution Model Development) Designed and implemented a VB-based Response Tracking Tool for a UK media client to measure advertisement effectiveness. Automated data capture directly from client FTP, applying multi-touch attribution and time decay models to evaluate ad performance. Eliminated a manual process previously requiring a 4-member team, significantly improving efficiency and accuracy. Tool adoption drove improved campaign evaluation and strategic media planning for the client. Senior Business Analyst – Telecom & Data Analytics Collaborated with marketing managers and UK stakeholders to design and execute customer retention, acquisition, and churn campaigns. Wrote SQL code to segment customer bases and deliver highly targeted campaign lists. Performed customer profiling, trending, and forecasting analyses to support campaign strategy. Produced financial summary reports to track expenses and cost centre performance for strategic decisions. Defined business rules for ad-hoc campaigns including cross-sell, up-sell, and win-back activities, and oversaw their execution. Designed a data mart for onboarding new hires, saving £235/month in training expenses. Delivered technical training on Oracle and SAS for new hires and team members. Nielsen Database Programmer Kolkata Mar 2007 - Jun 2009 (Retail Domain | Tools: Oracle (SQL & PL/SQL), SQL Server, SAS (Unix & Windows), DataFlux, VBA | Focus: Data Warehouse Development, Database Programming, MIS Development) Key Contributions: RCS Project – Census Database & WD Mapping Programmed and integrated five distinct ITC Sales Databases with Nielsen’s All India Retail Census data across 19 branches, creating a unified database entity. Designed and implemented data quality processes to cleanse, validate, and standardize Census data. Scaled the framework to cover TLP (Ten Lakh Plus population) and FLP (Five Lakh Plus population) towns. Applied SAS DQ, SAS DataFlux, and match code generation to standardize outlet addresses and channel hierarchies. Partnered with third-party vendors to build a virtual mapping solution, enabling precise store-level mapping (location ID, WD, section alignment) and enriching the Census database. Market Segmentation & Sales Optimization Developed a segmentation framework leveraging the Pareto Principle (80-20 rule) to identify high-value customer outlets. Enabled improved sales distribution and product targeting by focusing on priority customer segments. Provided actionable insights to strengthen retail penetration and optimize product placement strategies.