Ketrin Lirovich

Associate Consultant, Health Informatics at Segal
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
New York City Metropolitan Area, US
Languages
  • English Native or bilingual proficiency
  • Russian Native or bilingual proficiency

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
    • Human Resources Services
    • 400 - 500 Employee
    • Associate Consultant, Health Informatics
      • Oct 2022 - Present

    • Senior Health Benefits Analyst
      • Oct 2020 - Oct 2022

    • Health Benefits Data Analyst
      • Oct 2017 - Oct 2020

    • United States
    • Entertainment
    • 700 & Above Employee
    • Data Analyst
      • Oct 2016 - Sep 2017

      Assisted with managing the Global Content Catalog for Viacom's properties.Simultaneously worked across several internal systems (GCC, PTS, RightsLogic, ARC and VMN Web/Alias) in order to accurately capture media metadata and resolve discrepancies between Viacom’s legal, financial and programming departments. Confirmed and updated metadata information in the GCC according to acquisition documents, production agreements and internal deal memos.Researched, collected, evaluated and ensured metadata quality for high priority Viacom properties.Presented research to team and management with visual aids from Word and Excel.Processed user workflow requests submitted through EBX.Participated in long-term Data Governance projects and the communicated status to all necessary parties.Used advanced Excel formulas to analyze and track data changes (VLookup, HLookup, Nested Statements, Pivot Tables). Contributed to a proprietary content management system (ARC) that is the backbone to Viacom’s digital media presence.

    • Data Consultant
      • Mar 2016 - Oct 2016

      Increased producers’ efficiency through metadata propagation and economies of scale.Participated in multiple mass-data migrations and individually reviewed thousands of records.Had a direct effect on Viacom’s online offering by working with Viacom’s Content Management System (ARC). Provided data statistics, data quality issues and completion time estimates to management.

    • Data Analyst/Administrative Assistant
      • May 2012 - Mar 2016

      Employ Excel and Access to organize and analyze complex data sets Create interactive user reports in Excel with the use of charts, slicers, and Visual Basic enabled entry forms and buttonsAutomate large reports with the use of macros to increase company efficiencyTake careful and organized notes during meetings with clients to ensure that all their needs are properly addressedMake appropriate changes to Access Databases in both design view and with SQL queries.

    • Administrative Assistant
      • Jan 2011 - Apr 2011

      Assisted with the preparation of client's personal tax returns, ensuring that the time clients spent with tax specialists was utilized to its full capacityScheduled and managed appointments with clientsOversaw office’s filing and record keeping needs Assisted with the preparation of client's personal tax returns, ensuring that the time clients spent with tax specialists was utilized to its full capacityScheduled and managed appointments with clientsOversaw office’s filing and record keeping needs

    • Banking
    • 700 & Above Employee
    • Risk Management Intern
      • Jun 2007 - Jul 2007

      Entered and analyzed data in Microsoft ExcelUtilized Bloomberg Terminal for researchCreated Crystal Reports using existing databasesDeveloped instructions on working with data for new interns Entered and analyzed data in Microsoft ExcelUtilized Bloomberg Terminal for researchCreated Crystal Reports using existing databasesDeveloped instructions on working with data for new interns

Education

  • Baruch College, City University of New York (CUNY)
    Master’s Degree, Information Systems
    -
  • Baruch College, City University of New York (CUNY)
    Bachelor of Business Administration (BBA), Finance and Investment
    -

Community

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