Janak Chetri

> Led enterprise BI function & data strategy, managing analysts & engineer teams while establishing governance frameworks that increased data accessibility by 40% and eliminated 1,000+ annual hours through centralized architecture and self-service capabilities. > Architected enterprise-wide data infrastructure consolidating Finance, Sales, Operations, Compliance, Marketing, and HR data sources across business units into unified reporting for MD, CEO, CFO, and leadership teams. Designed multi-source ingestion pipelines integrating CRM (Dynamics 365, HubSpot), HR platforms, Snowflake, PostgreSQL, and external APIs (Google, Meta, Bayut) with robust governance and single source of truth principles. Enabled seamless CRM and HR integration, automating 70% of manual reporting through MS Data Fabric and Datamarts. Delivered executive-ready dashboards tracking unified financial and non-financial KPIs (profitability, customer acquisition, retention, operational efficiency, ROAS, CTR, CAC). Developed scenario modeling, trend analysis, and predictive analytics capabilities guiding strategic decisions and performance optimization at scale. > Migrated executive dashboards to Datamarts, reducing manual reporting by 70% and accelerating board-ready insights. Partnered with Marketing and CRM teams to integrate Meta Ads and Google Ads analytics, building centralized Customer Data Platform with unified Single Customer View supporting data-driven digital strategies across all channels. > Fostered data literacy culture across the organization through governance committees, training programs, and change management initiatives, enabling business leaders to make evidence-based decisions and embed data-driven decision-making at all levels. > Delivered end-to-end automation solutions for Production, Marketing, and Sales teams using Power BI, Monday.com, Power Automate, and Zapier workflows reducing manual workload by 80% while improving reporting accuracy and operational efficiency.

>Data Migration to OneCRM for different horizontal and verticals of the business doing ETL/ELT data ingestion different data formats for which implemented new code logic as per business requirements, built new pipelines and reworked on existing 3 entities using Azure Data Factory, Azure SQL, Azure data lake by saving 6 hours doing the imports, if it were done via the front end of Dynamics 365. > Data reconciliation reports on OneCRM project status and published to business and also developed an audit report and Dashboard on the CRM user data which aids in identifying of anomalies on the user checks and the roles, which runs weekly and updates to us and our wider team in UK thus reducing human error and achieved 90% efficiency using Odata API, SQL and Power BI. >Developed a routine for the Marketing team for unsubscribing and deactivation of contacts across WTW on a weekly & monthly basis by writing complex advanced SQL queries, which earlier was done manually going through every single contact and updating it, thus saving 320 hours annually. And that allowed for us to do more detailed data analysis on the customer drop by finding RCA's for different regions. > Collaborated with UK-based data science teams and internal stakeholders to deliver in-depth RCA reports and cohort-level segmentation, uncovering behaviour-driven insights for optimising user journeys and re-engagement strategies. > Designed and implemented SQL-based reporting frameworks and dynamic Power BI dashboards to track key performance metrics such as acquisition, engagement, conversion rates, LTV, and channel ROI, empowering marketing teams to make data-driven decisions and continuously optimise campaign performance. > Supported smooth data imports and reimports using both native methods and XRM Toolbox tools (e.g., Data Import++, FetchXML, SQL4CDS), ensuring data quality and duplication checks throughout the process.

>Solved and optimized solutions for our client "IDFC First Bank" >Identified root cause for problems addressing customers journey and complaints successfully revealing insights thus increased customer retention and satisfaction up by 11%. >Proposed solutions with SQL and Advanced Excel - Power Query to improve system efficiencies, leading to a 15% reduction in man hours. >Interpreted and showcased the data through dashboards and reports using Power BI liaising with multiple Operations team and BOC Team. >Addressed to business stakeholders with daily Ad-Hoc reports for the retail and business customers and built visualizations with Pivot tables, pivot charts and Power BI >My day to day task was catering towards client requirements, meetings and clearly understanding the client needs and proposing better information management and optimization towards the betterment of the Net banking Post login features catering both on Mobile app as well as Web.

>Complete drilldown of the project for the business outcomes using FTP(First principles technique) >Explored and conceptualized the complete data analysis, visualizing on health-care domain and one of the US Police killings and racism experience. >Formed 5 member group and working remotely handling issues and collaborating on a day to day basis. >Showcased and visualized through Excel and Tableau for non-technical people.