Sam Sui

- 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.

- 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

- 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.

- 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