Sam Yi Email & Phone Number

Northbrook, IL, US

Boston, MA, US

Chicago, Illinois, US

Helping customers unlock their data using dbt and Snowflake. Starting from data assessments, to identify where they are in data maturity, to implementing and productionizing data warehouses.

Greenwich, CT, US

Managed analytics and applications data for XPO Logistics Intermodal business.

London, GB

Operated as part of the data modeling team to implement Global Tax Platform on Azure. Including PowerBI embedded. Using SAFe Agile. Also performed performance tuning to get system IO down to a lower tier subscription; saving the project tens of thousand dollars.

New York, New York, US

Modernization of their SSIS system with emphasis on simplification and maintainability. Moved all parameters to a database table so there would be no need for multi-level configuration. Greatly simplify the system and making it less error prone. Moved custom logging to the database for ease of failure identification.

Miami, Florida, US

Design and implementation of an onboarding system using SSIS. They were in the middle of transitioning from an archaic system with repeated failures. SSIS was able to expedite development and successfully migrate its hedge fund customers to the new accounting platform.

US

Infrastructure consolidation; 50 SQL Server to 23 Servers. Reducing licensing fees. Implementing proper DEV/QA/UAT/PROD separation and isolation. Design/develop/implementation of database restore automation using SSIS. Design and implementation of production 3 node AG group (2 synchronous nodes and 1 asynchronous disaster recovery node).

Schaumburg, Illinois, US

Modernization of their infrastructure. Implementation of executive KPI dashboard using DOMO. All levels of SQL optimization.

Chicago, US

Provide client with a full reporting solution using JasperReport Server and PostgreSQL backend. Designed and developed a system, based on requirements of the business, to ingest series of text files to be made available for reporting. Linux, JasperReports, Java and Postgresql.

New York, NY, US

Paris, FR

New York, NY, US

Database administrator for PaymentNet 3.0. Converted 1.5tb backup (that was constantly failing and bleeding past the maintenance window) to a differential backup; alleviating our risk exposure.

Zurich, CH

Upgraded Longview portfolio management system to the latest version. Including series of custom add-ons.

New York, NY, US

Production Database Administrator. Reviewed database design and reviewed code in preparation for releases. Daily monitoring of various backup jobs. Modified backups of a large 1.5TB database to differential backup to avoid bleeding past its maintenance window.

Worked on data reconciliation engine to verify the trades are in sync with the exchanges. Additionally, worked as an operational DBA. Upgraded a 5 server farm from SQL Server 2000 to 2005 with clustering using EMC SAN. Provided guidance to other developers on TSQL development. Performance tuning.

US

Worked mostly with VB, VB.NET, SQL Server 2000, DTS, Analysis Services to deliver financial reporting applications.