Tong (Tom) Dai Email & Phone Number

New York, Ny, Us

Long Island City, New York, Us

Englewood Cliffs, New Jersey, Us

• Designed and developed code, scripts, and data pipelines that leverage structured, and semi-structured data integrated from multiple sources• Provided architecture and design for large enterprise data platform efforts related to data modeling, storage, sharing, role-based user access control, network security, resource allocation (virtual warehouse), and management• Responsible for end-to-end data operations (data ingest, transform, business data-marts, secure data sharing across instances), designed and implemented enterprise data platform using Snowflake, Fivetran, and AWS Services• Extracted 7+ years of historical SFDC data from the OwnBackup endpoint via a programmatic process, and converted from raw CSV files to JSON format prior to data ingestion to Snowflake for better support of sales ops trend analysis and forecasting modeling• Oversaw 15+TB of multi-year Salesforce, CloudHealth billing, Greenhouse, NetSuite, OB prod-usage data across 10+ major systems• Developed and maintained technical standards, procedures, and guidelines, architecture designs, and data flow diagrams• Support the development of performance dashboards that encompass key metrics to be reviewed with senior leadership and businesses

New York, Ny., Us

• Design and develop Power BI dashboard that visualizes KPIs (Utilization Rate, Billed/Collected Realization, Actual/Projected/ Target, $Cost per Incident, Incidents per FTE, Avg Resolved Time Before/After Escalation, First Caller Response Rate (FCRR) %, Customer Satisfaction Response Time vs Overall Rating, Balance of Trade, etc) to help the leaders of each department and practice to establish goals, measure progress, share results, and deliver data-driven insights & recommendations in support of business opportunities and day to day decision• Gather data from the various sources within the organization (Aderant ERP, ServiceNow, Azure Endpoint, Intapp, Microsoft Intune, Netskope, etc) and building REST API if necessary to help create the presentation layer in Snowflake for reporting and analysis purposes• Lead and develop sustainable data-driven solutions with current technologies to meet the needs of organization and business customers• Create BI architecture specifications and other design artifacts representing the approach and effect of firm BI strategy• Work with business groups, technical teams, data scientists, and statisticians to understand their data needs, improve the analysis and presentation of their deliverables• Gather business and functional requirements and translate these requirements into robust, scalable, operable solutions that work well within the overall data architecture

Tarrytown, New York, Us

• Coordinated data extraction and metrics development to support projects’ engagement across teams (data scientists, sales, business analytics); projects include patient journey reporting, cost savings analysis, and other ad-hoc analysis• Analyzed Tableau-based visual intelligence models and a wide variety of data sources (marketing, sales and financial) to identify insights, patterns, and treads (YoY sales rate/patients claims activity, % of patient refill rate, claims channels/prescribers to members tread etc.)• Enhanced existing processes for optimizing delivery procedures: consolidating individual Python scripts with yaml configuration features enabled, re-designing ETL solutions for greater scalability using Python, Airflow, Spark• Implemented data governance rules to ensure data quality meets standards, and propose/troubleshoot diagnosed issues if necessary• Managed and coordinated the project of remote, and international teams using Agile Scrum, and Waterfall SDLC to provide services of data strategy creation, technology strategic planning, process engineering, and data product development

Us

• Developed Scorecards and Dashboards, utilizing Tableau to identify operational weaknesses, and opportunities within the organization• Delivered client data refreshes/onboarding for more than 8 payer clients, including customized ETL code to account for client-specific business logic to ensure the most update-to-date and accurate data possible• Deployed initial data onboarding in AWS platform, and optimize ETL process to run 420M+ claims from 20M covered lives in < 5hr• Automated QA process using python and Jinja template to increase performance by 30%, turnaround time dropped from 3 days to 8 hours• Oversaw 100+TB of multi-year claims, encounter, beneficiary, pharmacy, and provider data across 30+ major US providers and payers• Designed tech specs that account for data nuances in partnership with business users’ cross-functional domains (e.g. claim adjustment logic, mapping of claim level attributes from service level details, data cleansing, and enrichment)• Engaged across teams, domain leads, analysts, IT staff, and stakeholders to design, develop and enhance data modeling, business intelligence solution, scripts, procedures, and metadata for supporting team’s analytic needs• Performed extensive data analysis on healthcare data to help identify improvement opportunities for the client and stakeholders• Provided ongoing support for query optimization, client data extract, transform and load process by responding to inquiries and ad-hoc requests from the various domains, business users and over 200+ consultant

Master Of Science - Ms, Analytics

Master Of Science - Ms, Information Technology

Bachelor Of Science - Bs, Management Information Systems And Services