Sam Sui

Experience

• 

  DLA Piper

  Jan 2019 - May 2019

  Intellcutal Property and Technology Intern

  - Researched information, gathered data, and prepared basic reports or analyses - Created files, prepared basic correspondence, and accessed document management systems to update and/or create new documents as needed-Participated in meetings to gain an understanding of department/practice group objectives, recent activities, and assist on special projects as needed for the Franchise and Distribution Department

• 

  Aderant

  Nov 2019 - Oct 2021

  Conversion Programmer

  - Responsible for Converting of client data from various legacy systems into a format that is compatible with Aderant solutions. -Analysis of client data and mapping of data to Aderant systems. - Review of formatted date to ensure all records, fields, and tables have been formatted appropriately.- Extraction, transformation, and loading client legacy data into Aderant database -Testing and implementing new and improved methods and procedures to increase the quality of future conversions. Show less

• 

  Applied Systems

  Oct 2021 - Jul 2023

  Data Migration Analyst

  - Convert agencies’ data from various source systems to a format compatible with the company’s flagship product - Write scripts in SQL Server to investigate agency data, make all custom modifications and implement new processes.- Review and modify ETL Mappings to fit customer needs and fix bugs in the conversion code.- Identify and resolve issues with ETL mapping during client migration.- Ensure successful client delivery through effective project management

• 

  CVS Health

  Jul 2023 - now

  Sr. Business Data Analyst

  - Successfully executed data migration and maintenance for 80+ clients in CVS’s program, contributing to the growth of a $10 million industry in year 2023.- Led onboarding of 20+ clients, incorporating custom requests to support a $1 million project enhancing operational efficiency and client satisfaction.- Assisted in validating data ingest processes using SQL and Big Query, contributing to the accuracy and reliability of data.- Conducted data mining exercises to identify trends and patterns within datasets, supporting decision-making processes.- Participated in data mapping projects, mapping files, fields, and attributes for seamless data integration.- Assisted in implementing secure file transfer protocols, ensuring data security and compliance.- Contributed to negotiations with stakeholders to address data validation concerns and ensure alignment with organizational goals. Show less