Liz Mcgary Email & Phone Number

Austin, TX, US

Austin, TX, US

New York, New York, US

Manage workload across 8-person team for the Insurance Solutions Data & Analytics team's portion of NYL programs.Current project work includes:1) Create third party vendor feed ingestion and downstream NYL feed generation processes to support launching new Individual Disability Insurance product in Q3 20212) Support testing and development needs for Long.

Managed a project team of three workstreams to confirm the completeness, uniqueness, and validity of data conversion from legacy systems to future systems, via the following: 1) Validated new BI structures successfully consume all subject areas required for BI reporting; 2) Developed reports, sourcing from the new BI structures, to ensure business.

Austin, Texas, US

Managed a project team of three parallel but independent workstreams, accomplishing the following: 1) Established a sales data mart in SQL Server, based on interviews with business SMEs, to ensure reporting needs are accommodated in reporting pilot, including reporting requirements, data architecture design document, data model, and DDL scripts; 2).

Analyzed and identified automation opportunities for existing ROI reporting, based on an ongoing conversion of construction management application.Drafted ROI reporting data compilation process flow mappings based on interviews with Divisional and Regional stakeholders.

Inherited management/functional lead role of ongoing client project intended to adhere to CMS-mandated standards of file submission formats for encounter claim data and associated chart reviews.Participated in and influenced project planning for iterative project delivery, including cost estimation, resource planning, and task creation.

Assessed current state Data Layer with a focus on current materialized views; assessed current state Reporting Layer to determine complexity of Data Layer sourcing.Recommended and advised on future state Data Layer architecture and solution design that would enable the company to improve performance and maintain existing Reporting Layer.Assisted in.

Owned the creation of the data mart needed to create Executive Reports focused on Sales and Marketing metrics, fed from a Finance Feed dataset.­Documented requirements from client executives to satisfy reporting requirements.­Designed and constructed data model to integrate existing model with Finance feed.­Constructed ETL to load data models.

Managed two workstream timelines, scope, and status reporting: Sales/Marketing workstream and Customer Operations/Field Operations workstream.Documented requirements from external providers and client executives to satisfy reporting requirements.­Performed gap analysis to validate incoming data feeds align with required KOMs and dimensionality.Designed and.

Conducted gap analysis for reporting needs and deliver reporting project timeline.Gathered report requirements from client SMEs, end users, and third party consulting firm.Documented business requirements and technical design.Mapped report fields and aggregations.Assisted in OBIEE report front-end development.Developed and executed unit testing phase.

Led, coached, and developed a team of 5 first-year analysts to successfully deliver a Salesforce CRM implementation tailored to satisfy client business requirements.Managed project timeline, project scope, client communication, and project risk mitigation tactics.

- Managed project tracker and weekly status reports - Developed and delivered monthly ad-hoc reports- Consolidated and categorized reject claim spreadsheets to upload to information warehouse- Enhanced/supported daily reject claim table refresh- Supported staff requests for reject claim analysis

- Developed a data assurance tool to help measure enrollment and eligibility and confirm the completeness, uniqueness, and validity of the data conversion from legacy system to future system- Interacted with business and functional SMEs to understand business and technical requirements- Created and analyze reports to measure the reconciliation of the.

- Assisted in the design of a clearing and settlement facilitation application- Provided technical design document and source-to-target mappings for future implementation

- Developed and deployed ETL mappings to integrate product and customer data into existing EDW for new reporting requirements- Provided source-to-target mappings for new data integration

- Analyzed medical claims data files from multiple payers to determine data quality and optimal ETL mappings- Developed and deployed ETL mappings to integrate medical claims data into existing EDW on a monthly basis- Provided functional specifications and source-to-target mappings for each data file integration

- Designed, developed, and implemented a human resource data warehouse solution- Developed ETL mapping templates for data flow between original data sources, operational data store, and data warehouse- Analyzed data from several global HR systems to determine data quality and optimal ETL mappings