Mikhail Lapin, MBA

Business Info Consultant at Anthem
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Ridgefield, New Jersey, United States, US
Languages
  • Russian -
  • English -

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Insurance
    • 700 & Above Employee
    • Business Info Consultant
      • Dec 2017 - Present

      • Oversee and manage the development of analytical tools and processes to analyze and create business performance reports for Government and Commercial business lines, such as market and product analysis, utilization and cost effectiveness. - Re-engineered and implemented a new automation process that increased efficiency 10-fold by increasing production capacity by at least 400 – 500% and decreased production time by approximately 90%, which includes an automated and robust data validation in the production time.­ - Developing key Data Marts to aid in the analysis and reporting to increase efficiency and effectiveness of current processes and reporting capabilities.­ - Collaborate with business units to identify new key clinical and financial performance indicators.­ - Enhance end business user and team member’s knowledge through training on reporting packages and clinical/data/business comprehension. • Provide analytical consultation and recommendations to other business areas, leadership and/or external customers.­­ - Analyze key business issues and devise best course of actions to develop diagnostic and tracking analytics that aid in effective and valuable decisions support tools, e.g. Tableau Dashboards.• Coordinate and supervise the resources both financial and employee time of the project team in order to meet project schedules and budgetary goals.

    • United States
    • Insurance
    • 700 & Above Employee
    • Lead Data Analyst (Clinical Informatics)
      • Jan 2016 - Dec 2017

    • Sr. Data Analyst (Clinical Informatics)
      • Aug 2013 - Dec 2015

      • Manage clinical reporting across more than twelve contracted Accountable Care Organizations (ACOs) through the production of utilization and cost analyses at the account, market segment, product, and corporate line of business levels. (Received the EmblemHealth Exceptional Employee Award)­ - Liaise with the Shared Savings team to assist in requests for network and medical management reports ranging from polypharmacy to ER/Admit PMPM and aftercare reports.­ - Develop and maintain the ACO Automation Tools utilizing MS Excel VBA and SAS, decreasing the time needed to assemble a clinical data book by at least 400%.­ - Implement standardized Truven templates across all ACOs to increase efficiency and to ensure the integrity of data quality.• Provide data and analytical support for major corporate initiatives through collaboration with Actuarial, Care Management, Utilization Management, Government programs and other departments through regular reports, special analyses, and other program evaluations.­ - Analyze DOHMH Medicaid Health Homes list and assign members to contracted health homes across NYC based on county, chronic conditions, space availability, and effectiveness of Health Homes’ program.• Function as a subject matter expert in multiple EmblemHealth’s data tools, including E-Saws to the navigation of data warehouses.

    • Data Analyst
      • Feb 2012 - Aug 2013

      • Managed the Productivity Initiative which sets new production standards for employees for sixteen departments based on the analysis of operational productivity data.­ - Developed and implemented a new system, the Productivity Data Processing System (PDPS), which utilizes new techniques and automated tools to assist in the analysis process leading to a two-fold increase in overall efficiency and as much as a 90% decrease in the time needed to harvest and cleanse the data.­ - Modernized the reporting aspect of the initiative, from result analysis, to delivery of the final package to Labor Relations in order to effectively present the need for new standards and the validation of the current study.­ - Acted as an independent liaison to over fifty directors, managers, and supervisors on proper data maintenance rules and techniques for ascertaining whether a specific task can be studied based on the underlying control processes.• Provided support for audits and special projects through data extraction and analysis from the data warehouse and other systems utilizing various tools.• Developed and maintained policies and procedures regarding the TeamMate system, the Productivity Initiative, and all processes regarding the data requests.­ - Evaluated the adequacy of policies and procedures of day to day business/auditing practices regarding utilized systems. ­ - Managed the TeamMate audit management software and other departmental system’s functions, settings, and access controls and evaluated new requests for additions and/or modifications on a case by case basis. ­ - Trained and supported user areas, in and out of Internal Audit on the systems.­ - Ensured all audit-related steps are documented in a standard format and according to departmental standards.

    • United States
    • Hospitals and Health Care
    • 700 & Above Employee
    • Data Analyst
      • Jun 2010 - Feb 2012

      • Managed the day to day reporting system between internal management and external funding sources:­ - Developed new methods and automation techniques using SAS and MS Access for employee daily work reporting, leading to an efficiency increase of 40%.­ - Instituted reporting and auditing schedules to increase efficacy of data input from personnel causing a decrease in data error by approximately 50%. ­ - Minimized the time for operational analysis by 35% through instituting specifically targeted reports that analyzed and presented the viability of a current procedure or contract. • Instituted and maintained a Support Services Tracking System, Multi-Program Audit Systems, and key MS Access databases to facilitate operations, thus modernizing data management and decreasing audit time by half:­ - Implemented methods allowing for the easy creation of ad hoc reports using predefined search criteria in MS Access, SQL query commands, and lookup functions in Excel. ­ - Developed automated managerial reports that present current statistical analysis of all active contracts, personnel, and support services.

    • Consultant: Project Coordinator/Business Analyst
      • Jun 2006 - Jun 2010

      - Coordinating the development of an in-house software and data package to integrate multiple departments and over 50 executive reports.- Analyze and re-design all reports that are developed and/or utilized within the department to properly assess the operational efficacy and the usefulness of the reporting data.- Institute meetings to ascertain the needs of the managers and abilities of the development teams.- Develop specifications and manage progress of the project.- Developed and maintain a Contract Management, Report Management systems and MS Access databases- Analyze incoming data to determine functionality gaps and data integrity- Develop forecasting calculations for budgetary needs utilizing macros built into MS Access- Maintain proper records and analysis of budgeting needs- Coordinate records from multiple locations and sources - Developed financial and managerial reports based on end-user requirements which include pivot table and pivot chart reports through the utilization of SQL commands- Instituted methods that allow for easy to create ad hoc reports using predefined search criteria in MS Access utilizing SQL query commands and through lookup functions in Excel- Develop and analyze language in contract specifications - Perform budget analysis to determine future funding for contracts- Perform statistical analysis to determine the cost v. effectiveness of service providers- Analyze performances of translators, workers, and usage patterns by multiple criteria- Maintain set billing procedures and money management records - Facilitate meetings with stakeholders and development teams for proper design and implementation from existing technologies to new technologies- Analyze existing Standard Operating Procedures (SOPs) to identify opportunities to increase efficiency

    • Business Analyst
      • Sep 2005 - Apr 2006

      Analyzed cases to assess the qualification needed for arbitration under New York No-Fault Law Analyzed cases and staff productivity to determine the statistical effectiveness based on a set criteriaAnalyzed operations of law firm and developed changes for better profitability Maintained the in-house IT infrastructure

    • Intern
      • May 2004 - May 2005

      - Developed a system for medical professionals to be able to test responses of children under different testing procedures within an MR environment.- Designed and created the Stimuli Presenting and Response Collecting System, SPARCS- Analyzed and validated EEG hardware and software to recommend purchasing decisions- Resolved miscommunication between hardware and software saving the institute from new hardware acquisition- Created and maintained the institute's wireless network and webpage

    • Research Assistant
      • Dec 2003 - Feb 2004

      - Researched and developed a database of biotechnology and pharmaceutical companies- Analyzed the progress of drug and device studies based on FDA regulations

Education

  • Baruch College
    MBA, Finance, Quantitative Methods for Business
    2008 - 2009
  • Rutgers University
    Bachelors of Science, Biomedical Engineering
    2002 - 2005

Community

You need to have a working account to view this content. Click here to join now