San Francisco, California, United States
Product, strategy and data operations @ Instagram: • Lead large scaled data operations program to enable notable product launches including IG Reels, Suggested Post & In-Feed Recommendations • Lead content understanding workstreams and enabled ML classifiers for IG solving for Originality, diversity, personalization and relevance • Lead competitive benchmarking and content analytics on Reels • Lead and manage global programs providing recommendations integrity for IG Explore, Reels and Suggested Posts
• Use SQL, Microsoft Access, and Excel to obtain, clean and audit claims data to provide hospital clients analysis of various revenue cycle issues • Use stored procedures in SQL Server Management Studio(SSMS) and Excel VBA to create multiple automation tools, audit tools, risk sweeps and project management dashboards to streamline processes for project teams in order to improve efficiency • Prepare and present client deliverables and recommendations derived from large sets of data to health system executive clientele on optimization of revenue cycle operating efficiency while mitigating future losses • Design and develop a new internal training programs for tenured employees on SQL codes and the data import process in SSMS • Hold weekly knowledge sharing and training sessions for new employees to expand their background knowledge in healthcare industry as well as technical skills • Design queries to perform comprehensive audits to effectively identify underpayment risk, leading to the recovery of approximately $10 million across four projects • Gain expertise in different healthcare product and government policies, decipher ambiguous contractual languages and make recommendation for clients’ future contract negotiations
• Using claims table in SQL as weighted average to validate the fee difference for veterans programs between Legion and PPO fee schedule, concluded that Legion fee schedule design deviates from expected • Assisted analyzing Delta and its competitors standing in market share, premium rates, and service margin in federal employee program; conducted a map that broke the nation into 103 partitions to map Delta’s regions with competitors • Used Excel VBA to conduct a case scenario analysis predicting required enrollment growth in each region if Delta changes service premium and maintains a certain service margin • Used Excel VBA to automate the Benefit Plans Savings Analysis presented to the Department of Insurance, streamlined the process of categorizing procedure codes and analyzing benefit plans savings • Used Excel VBA to automate a Plan Block Renewal Tool to automate the renewal calculation for five states government groups, created one model that provides required premiums and service margin for all groups • Used SQL and Excel to estimate percentage savings on Delta’s liability for veterans program