Ketrin Lirovich
Associate Consultant, Health Informatics at Segal- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Native or bilingual proficiency
-
Russian Native or bilingual proficiency
Topline Score
Bio
Experience
-
Segal
-
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
-
-
-
Viacom
-
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
-
-
-
Bank Hapoalim בנק הפועלים
-
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