Dhiman Biswas

• Non-Credit Data Analytics R&D; Identity Graph Product Development and R&D; Identity Data Strategy. • Leveraging Big Data Tools to evaluate and measure the quality and coverage of data assets (internal and external) and seek to derive new business insights from the data assets to support new product development; creating scalable reports/dashboards and presentations to summarize analysis results in Power BI / Tableau. • Supporting TU's Data Strategy teams to identify data acquisitions/licensing opportunities, present insights and recommendations to senior management. • Identifying, researching, and developing solutions to improve TransUnion’s data quality and consumer matching. • Performing data manipulation and analysis using Excel and BigQuery/SQL on massive data sets in GCP/Dremio. • Providing subject matter expertise to projects that require TU’s core credit data, as well as other alternate data assets TU has licensed. • Proactively researching and identifying market changes and data assets that will enhance TransUnion’s globally diversified product lines, revenue and profitability, and continuing to look for new tools and ways to improve and standardize the data evaluation methodology and seeking for improved team productivity.

• Domain expert in market mix modeling and market measurement • Managed, implemented, and delivered Marketing Mix projects for leading CPG clients, tailoring analyses and findings to address clients' business questions while leveraging extensive proprietary data sources to provide actionable insights to senior-level clients • Used regression models to identify and measure incremental sales/volume and campaign effectiveness/ROI • Performed deep dives to identify trends and causality with ROI and incremental volume for client mix projects • Combined advanced analytics, marketing, sales and strategy, empowered with big data and technology, to develop practical insights and actionable recommendations • Leveraged IRI’s granular and proprietary data to develop scalable, data-driven and robust analytical solutions for real business problems • Collected, cleaned, and processed data by developing automation tools in R and Excel

• Provided BI and data centric solutions to top tier clients in CPG and Health Domain using Advanced SQL and Visualization • Developed adhoc reports, dashboards, analytics to derive key business insights and KPIs • Designed, developed and tested customized client reports incorporating multiple raw data sources using advanced T-SQL scripting • Consulted and advised clients and team on most impactful data measures to report and best way to derive those measures • Manipulated, cleansed, transformed and processed data. Performed data audit and data validation of collected data to derive measures • Performed Data Analytics to analyze IRI shelf, causal, audit, panel, POS data to facilitate clients to understand brand position, sales velocity, and shelf space in stores. Guided clients in business development, future plans, and innovation and ROI goals • Analyzed sample store collection data and apply projections to project data across all US geographies • Applied statistical and modeling techniques on large datasets using R to identify trends, key predictor variables of the datasets, and developing custom BI solutions in SQL Server and SSRS.

Worked as a Teaching Assistant to Professor John James Sparks for the course IDS 270 (Business Statistics) in the Information & Decision Sciences department.

• Led a reporting team of 3 people. • Researched, analyzed and interpreted data for 5,000 policy agents and strategized with executive team to double the YTD value of policy agents in the form of interactive dashboards – the strategy achieved a figure of 17% increase in value. • Conducted ongoing performance tracking and success metrics for policy agents to consistently increase operating benefits – achieved 23% increase in overall benefits. • Performed Data Analysis using R and developed Dashboards as per client provided technical specifications using SAP Business Objects • Validated the Reports with the values from the database through self-written queries on Sybase

• Analyzed consumer complaints data and found patterns and trends on R, and conducted statistical analyses to leverage the results to drive decision making. • Created DMR and Relational packages using Cognos Framework Manager. • Developed Dashboards as per client provided technical specifications using Cognos Report Studio • Validated the Reports with the values from the database through self-written queries on DB2 • Performed and designed test scenarios and test scripts • Wrote complex SQL queries, stored procedures, triggers and views for business logic and functionality of various modules in SQL Server. • Developed packages according to the ETL specifications for the staging area and warehouse data loading using SQL Server Integration Services after multiple transformations • Scheduled ETL packages (monthly) • Involved in dimensional modeling using the identified fact and dimension tables using SQL Server Analysis Services • Generated multiple Dashboards using SQL Server Reporting Services

UIC Liautaud’s Master of Science in Business Analytics prepared me to meet the growing demand for business analytics professionals. At UIC Liautaud, I received an education based on data analysis and technology that integrates functional applications from accounting, finance and marketing. The program helped me develop skills and training to work in data-rich environments, and enabled me to develop capability in business intelligence and analytics. After completing the program, I was able to bring together information technology, data science and business to be able to analyze and communicate the value of data.