Alankrita Ghosh

[Global Fraud Solutions – Device Risk, Fraud Prevention, Truvalidate Platform]

• Lead a team of BI developers, fostering a collaborative environment that encouraged continuous learning and knowledge sharing; work closely with leadership to prioritize BI initiatives and align themwith strategic goals

• Collaborate with Data Engineering, Analytics and Product teams to lead a comprehensive migration strategy for transitioning 150+ on-demand and 2500+ scheduled Looker reports from Snowflake to GCP BigQuery, ensuring sub 60 minutes downtime

• Design and execution of data validation processes to verify data accuracy and consistency post-migration, identifying and resolving discrepancies swiftly ensuring timely decommissioning of Snowflake thus saving ~2M+ per year

• Defining and building standardized marketing and industry reports that enable Marketing teams to self-serve for data needs, analyze risky transactions of device risk customers and share the TransUnion Annual Fraud report with public audience as a press release showing standard evaluation practices for our solutions

[A tech-driven managed health care provider, focuses on personalized, prevention-oriented health and social care]

• Led the DBT and LookML data model design of code migration project for multiple state-mandated patient's health risk assessments into single health-risk-assessment module which led to decreased documentation lag by 6 hours and productivity increase of 40% for Nurse practitioners in Massachusetts market

• Designed analytical data models in DBT by harmonizing claims, EHR, HIE data from BigQuery data warehouse for efficient data governance and data Quality, build Looker reports and present business insights to senior leadership

• Wrote python & SQL scripts to automate ETL/Data Pipelines for regulatory reporting on key KPIs such as ED Utilization, in-patient visits, patient risks, identifying hard-to-reach Medicare/Medicaid patients for in-person outreaches, resulting in Cityblock's care plan enrollment annual growth by 38% for FY2020

• Handled 0-to-1 projects from inception to completion including planning bi-weekly sprints, managing JIRA epic & story boards while supporting sprint retrospectives following Agile Delivery Model

[A Leading Provider of Virtual Behavioral & Mental Health Care Therapy]

• Built COVID-19 KPI Dashboard for leadership team, to address the impact of pandemic on businesses; loading data from BigQuery to build Looker data models via DBT data transformations to deliver insights on metrics such as increase in average enrollment rate by 6%, resulting in Revenue growth by 3.5M

• Presented business insights to senior Leadership (SLT) on company OKR of improving 5% of Call-to-Enrollment yield of participants by testing the hypothesis with data analysis of session no-show reasons, demographics, cost share, assigned therapist rating to find the opportunity of contributing towards achieving the 80M revenue goal for 2020

• Collaborated with Product owners in Agile Delivery Model to identify the clinical projects KPIs, build functional requirement documents, Looker dashboards and perform quality checks of data using SQL queries

• Wrote Python script to automate upload of patient's survey data into BigQuery database for building looker report and gather insights on engagement and patient's experience with AbleTo digital health therapy program

• Conducted A/B testing on therapy reminder emails campaigns using Braze to measure marketing analytics KPIs (CTR, Bounce rate), resulting in 2% no-show rate drop for participants