Experience

Stanford Medicine Partners

• United States
• Hospitals and Health Care
• 200 - 300 Employee

• Financial Analyst IV

  • Jul 2023 - Present

  Experienced Data Analyst with a proven track record of extracting valuable insights from complex datasets. Passionate about transforming raw data into actionable recommendations, I excel in designing and validating reports, conceptualizing ad-hoc analyses, and delivering high-impact presentations to senior leadership. My expertise lies in healthcare analytics, where I leverage advanced knowledge of financial data and outpatient business functions to drive operational efficiencies and support strategic decision-making.Responsibilities:- Independently maintaining internal databases and collaborating with cross-functional teams, I ensure seamless data integration and accuracy, working closely with IT/TDS for external databases.- Proficient in performing complex data extraction and advanced manipulation techniques, I craft meaningful ad-hoc analyses and reports tailored to meet specific needs.- Proactively identifying opportunities for efficiency enhancements, I implement streamlined processes and optimize existing reports, enhancing understandability and user experience.Key Skills:- Advanced knowledge of financial data interpretation, enabling me to decipher complex information and derive actionable insights.- In-depth understanding of healthcare and outpatient business functions, empowering me to provide strategic guidance and contribute to operational excellence.- Proven ability to provide direction and work with interdisciplinary teams, facilitating smooth project execution and cross-functional collaboration.- Proficient in comprehending and executing contractual knowledge (PSA) language, ensuring compliance and risk mitigation.- Advanced user of MS Office, MS SQL Query, MS Access, MS Excel, Tableau, EPSi, and Smartsheet, utilizing cutting-edge tools to drive data analysis and reporting efficiency. Show less

• Sr. Decision Support Analyst

  • Apr 2020 - Jul 2023

  Following the transition of Stanford Advantage operation to Lumeris effective 9/1/2020, now the DSS team supports the FP&A team at Stanford Medicine Partner corporate as well as the Finance team at SMP Accountable Care Division.My key responsibilities and achievements include:- Collaborated with the FP&A team and Stanford I.T. services to integrate the SMP Clinic SQL data warehouse, eliminating the need to manually download large daily and monthly files for analysis and improving team efficiency.- Maintain EPSi Strata Statistic, Decision Support system, and monthly income statements dashboard by loading revenue, expenses, and statistics datasets. - Building a financial Tableau dashboard to help leadership see the organization's year-to-date (YTD) fiscal year financial status.- Built a third-next-available-appointment dashboard for returning and new patients of all clinic locations, which helps leadership identify access issues for patients and plan next steps to improve healthcare access.- Built a weekly slot utilization and visits dashboard for the clinic operations manager and clinics' doctors to see weekly and monthly visit volumes so they can plan staff accordingly.- Built a comprehensive financial Tableau dashboard that presents leadership with a clear and concise view of the organization's Year-to-Date (YTD) fiscal year financial status. The dashboard provides an in-depth overview of the organization's financial performance, enabling leaders to make informed decisions and take proactive measures to improve financial outcomes. Additionally, the dashboard displays a detailed financial income statement categorized by clinic region and doctors' group, providing further insights into financial performance at the regional and group levels.- Assisted the PSA manager in migrating RVU calculations from an access database by writing a complex SQL query to calculate RVU from the clinical charges database available in EDW. Show less

• Sr. Decision Support Analyst

  • Feb 2019 - Apr 2020

  Other responsibilities include performing monthly SQL data pulls to prepare IBNR datasets and working closely with Milliman’s Actuary to prepare monthly IBNR for SMP/Stanford Advantage’s finance team. I also trained newly hired analysts on preparing monthly financial, membership, and health plan revenue reports.In addition, I support the Affinity Medical Group IPA with ad hoc requests and kept track of their Provider Service Agreement, ensuring timely payments, calculating bonuses, incentives, and surpluses. I wrote complex SQL queries to extract datasets following the Affinity Medical Group provider bonus rubric, facilitating their provider bonus calculations.I took part in a project to create logics that validated eligibility issues, where health plan terminated members were still active in the system. Furthermore, I wrote a complex query to extract datasets from EDW to create a weekly roster of annual physical and wellness visits for Medicare members, allowing the quality team to monitor their wellness.Key achievements:- Developed SQL script to automate the generation of monthly financial, membership, and health plan revenue reports, improving the efficiency of the reporting process.- Created a forecasting model in Excel that provided accurate numbers for the following fiscal year budget, allowing the organization to make informed financial decisions.- Implemented a new process to track Provider Service Agreement, ensuring timely payments and accurate bonus, incentive, and surplus calculations.- Assisted the organization save $2.1 million by resolving an on going membership eligibility issue. Furthermore, I developed a report that reconciled the current active memberships with the payment received from the health plan. The purpose of this report was to prevent the recurrence of the membership eligibility issue. Show less

• Sr. Decision Support Analyst

  • Nov 2018 - Feb 2019

  As a Senior Decision Support Analyst supporting the SMP Accountable Care Division and the Stanford Advantage Health Plan, I am responsible for providing critical insights and analysis to optimize healthcare outcomes and drive organizational growth. With a deep understanding of healthcare industry trends and regulations, I collaborate with cross-functional teams to develop and implement strategies that ensure high-quality, cost-effective care for our members.In this role, I have successfully prepared monthly financial, membership, and Health Plan revenue reports for the ACD finance team. Additionally, I designed a SQL query to calculate the monthly Health Plan Revenue capitation file from the CMS MMR file for the respective IPAs for the Stanford Advantage Health Plan, supporting Sutter Palo Alto, Palo Alto Mills, and East Bay Medical Foundation.Furthermore, I managed Field Marketing Organizations and handled calculating the monthly commissions for the FMOs agents. Through my leadership and collaboration skills, I have positively impacted our organization's bottom line and delivered results that improve healthcare outcomes and drive innovation. Show less



Clover Health

• United States
• Hospitals and Health Care
• 300 - 400 Employee

• Operation Coordinator

  • Feb 2018 - Nov 2018

  My role as an Operation Coordinator at Clover Health, a healthcare technology company focused on improving health outcomes and reducing healthcare costs for Medicare beneficiaries, I played a key role in supporting various teams with data-driven insights and analysis. In this role, I created various Mode reports to track the number of claims ingested and used the platform to build dashboard reports for the payment dispute team to monitor overpaid and underpaid claims. I also developed dashboard reports for cost savings processes, such as LPUC (Letter to Provider for Unclean Claims), and utilized data collected from Google Forms to create a dashboard report that measures daily task completion by coordinators. Through my skills in data analysis and visualization, I optimized the process of opening payment dispute tickets in Zendesk by creating a tool in Mode to search claims information. Furthermore, I presented my findings on underpaid and overpaid claims to the manager of claims in 2018 and proposed solutions to improve the efficiency of claim reviews for coordinators. My contributions played a critical role in supporting Clover Health's mission to improve health outcomes and reduce healthcare costs for Medicare beneficiaries through the effective use of data-driven insights and analysis. Show less



CrowdStrike

• United States
• Computer and Network Security
• 700 & Above Employee

• Data Science Consultant (Capstone Project)

  • Dec 2017 - May 2018

  For this role I was a Data Science Consultant, my primary responsibility was to test an open source decompiler project to predict whether an executable file is malicious malware using features derived from decompiled code. In this project, I utilized a range of open source tools and frameworks to achieve this objective. To begin with, I used RetDec, an open source machine-code decompiler, to reverse engineer both malicious and benign malware executables into their source code. This process helped me extract relevant features from the code that were subsequently used for analysis. Additionally, I leveraged Gym-Malware, another open source project that utilizes the OpenAI framework to manipulate Windows PE binaries, to build a baseline model for feature extraction from decompiled executables. Through this process, I discovered more than 2,000 new features that were used to train new machine learning models. Finally, I developed a baseline XGBoost model to measure the performance of subsequent models using the discovered features. Through my efforts, we were able to improve the accuracy of our malware detection system and mitigate potential threats. Show less



LendingClub

• United States
• Financial Services
• 700 & Above Employee

• Sanction Screening Specialist

  • Sep 2017 - Dec 2017

  In my role at LendingClub, I was responsible for reviewing the company's high-risk portfolios to identify potential instances of identity theft, loan application fraud, money laundering, and other risks. I worked to verify flagged information in the system, ensuring that fraudulent activities were properly identified and addressed. I also contributed to the development of metrics, views, and dashboards to monitor and diagnose delinquency performance at a granular level. These tools were used by cross-functional teams to collectively understand strategies and performance. Additionally, I created a master Excel file containing watch-list information for loans and investors each month in 2017, which served as a valuable resource for future auditing purposes. As part of my efforts to improve fraud detection processes, I proposed ideas to the Head Senior Director of Enterprise Fraud, including the use of Artificial Intelligence/Deep Learning to automate manual fraud screening processes and the development of a graph database to more quickly identify politically exposed persons (PEPs). Lastly, I created a Python script to automate data extraction from XML files and convert it into Excel table format. I also modified an open source Java project found on GitHub to automate simple, repetitive tasks. Through these initiatives, I was able to contribute to LendingClub's ongoing efforts to improve fraud detection and ensure the integrity of its lending practices. Show less



Chinese Hospital

• United States
• Hospitals and Health Care
• 100 - 200 Employee

• Information Technology Specialist

  • May 2015 - Aug 2017

  I was responsible for a variety of duties including developing and implementing databases and reporting tools for data extraction and analysis, providing technical support via e-mail and phone, analyzing and resolving system hardware and software issues, managing and configuring hardware and telecommunication systems, tracking and documenting Helpdesk processes, supporting remote access clients, and administering passwords and system security features. During my tenure, I achieved several key accomplishments, including creating a script to automate and streamline IT support tasks, developing an AngularJS-based website to facilitate registration for the San Francisco Chinese Hospital Fundraising Golf Tournament, and creating a scraping tool in Python using Beautiful Soup to scrape doctor's NPI and license information from https://npidb.org/ for the San Francisco Chinese Hospital Cerner EHR Project. Show less



Dryve

• United States

• Co Founder

  • Jan 2016 - Jan 2017

  Need a ride somewhere? Dryve is an app that targets college students looking for a ride from point A to point B. Finding a way to commute back home on weekends and holidays is a task that college students will experience at least once in their undergraduate years. Some of the popular options that college students will use to commute back home from college are taking the Amtrak and Greyhound. Although there are options of taking the Amtrak and greyhound, using these can get very expensive especially during holidays seasons. Dryve, will help college students who do not own a car find a cost efficient and reliable way to commute back home. Dryve promotes people to be eco-friendly by having less cars on the road to reduce carbon dioxide. Our app will benefits college students who own a car and commute a lot on earning extra money by becoming a Dryver. Dryve can look for people who meet that same schedule or who can add you to their drive route on the days you need a ride. The flexibility makes it a very convenient option for any long commute. For more information and updates about Dryve like our Facebook page at https://www.facebook.com/dryveapp/ Show less



University of California, Merced

• United States
• Higher Education
• 700 & Above Employee

• Information Technology Special Events Liaison

  • Aug 2014 - Jul 2016

  Ensured optimal levels of equipment operation by troubleshooting and resolving breakdowns, maintaining supplies, performing preventive maintenance, and coordinating repairs. Documented service and installation actions. Maintained professional and technical knowledge through ongoing professional development.Key Achievements:• Documented equipment operation to facilitate use by future hires.

• Marketing Assistant

  • Aug 2014 - May 2016

  As a marketing assistant, I was responsible for assisting the marketing manager and the marketing team with all marketing activities. Utilizing my creative skills, I coordinated the production of a wide range of marketing communications.With my leadership skills, I participated in weekly team meetings and other key meetings to gain exposure to the business. I also kept marketing department’s documentation and databases up-to-date►Handled production of marketing materials and literature►Provided support for marketing events and exhibition displays►Wrote articles and designed promotional adverts► Took pictures during events. Show less