Wilson Lam Email & Phone Number

New York, Ny, Us

San Francisco, California, Us

New York, Us

Spearheaded the enhancement of forecasting capabilities by transforming intricate business logic into an intuitive and dynamic Looker dashboard. The forecast achieves a 95.5% accuracy rate in predicting clients' end-of-month card spend for the upcoming three months. This tool is widely embraced by top executives, including the CFO and VP.Designed and deployed Go-To-Market (GTM) dashboards for monitoring and evaluating sales performance. Utilized analytical skills to align performance metrics with the overall business strategy in collaboration with the VP of Sales.Automated commission calculations through integration of data sources and platforms such as Salesforce, Snowflake, and Visual Studio Code. This involved replicating intricate sales commission logic. This dashboard not only streamlined operations, saving the Revenue team 5 hours monthly, but also mitigated the risk of human errors in commission calculations.Acted as a key liaison between the data team and cross-functional departments. Collaborated with Sales, Finance, Marketing, Partnership, and Client Success teams to design and implement automation processes aimed at enhancing operational efficiency.Elevated the integrity of company data by transitioning to the data build tool (dbt) and fine-tuning data tables within Snowflake. This strategic initiative entailed collaborative efforts with diverse departments to implement recommendations operationally, yielding an30% average reduction in runtime.

New York, Us

Pleasanton, Ca, Us

Pleasanton, Ca, Us

Produce and manage the production for Crossix DIFA™, the leading platform for measuring and optimizing healthcare marketingTune and master the production processUse knowledge of Crossix analytics processes to monitor and troubleshoot execution, analyzing root causes, and data anomaliesBuild expertise in analytics related to digital marketing initiatives and become the go-to person for data and methodology related questionsIdentify, plan, and test new processes to improve scale and automation of DIFA productionDefine process specifications to partner with development teams to find solutions and develop new features that will drive automation and scaleExecute project requirements, using python, SQL, logic-based proprietary language and other analytics and data visualization toolsResearch and develop new innovative product features and advanced analytics to enhance DIFAWork with senior team members on rollout plan and execute on the release of new product features to clients

New York, Ny, Us

Review applications for accuracy, compliance, and consistency to ensure the highest data quality. Achieve a 97% threshold quality for all applications submitted to the state and follow-up with Local Department of Social Security on any discrepancies with the application decisions. Quality tests our database system by validating all updates posted in the department’s worklog and report any technical issue.Present database production updates, as well as analyzed error, tends, at the monthly all-staff meeting and provide resources to improve quality submission of Medicaid applications.

Honor Bachelor Of Science, Biology, Psychology

Master'S Degree, Health Informatics