Jonathan Szeto Email & Phone Number

Bedford, Massachusetts, US

Weston, Massachusetts, US

• Data engineer for a software company providing an all-in-one service platform for financial planning agencies. Contracted to a project separating data systems from the parent company from which Advisor 360° was spun off.
• Designed a metadata-driven data extraction and ingestion platform in SQL Server Integration Services (SSIS) to export A360 data to the parent client. The metadata system contains information on the tables being.
• Exported the data into native-format binary files. Compressed files using the GZip algorithm. Generated a JSON manifest document to track the files sent. Captured operational metadata for support and documentation.
• Demonstrated the extraction and ingestion processes to technical staff and leadership. Created user stories to track progress and estimate milestone delivery dates. Documented processes on the team wiki.
• Coordinated with operational support staff to create an automated build and release pipeline for continuous integration and deployment (CI/CD) using Microsoft Team Foundation Server (TFS)

Cambridge, Massachusetts, US

• Designed, planned, and developed an enterprise data warehouse (EDW) for startup analyzing clinical health data. The EDW utilized Snowflake to integrate electronic health records (EHR) with medical claims. Implemented.
• Designed a framework to load data from compressed text files into a Snowflake database. The framework is metadata-driven to streamline development, as well as capture data traceability and lineage. Presented the.
• Analyzed vendor data dictionaries and built data models to derive metadata information. Documented source-to-target mapping from vendor data model into the company analytical data model. Data models represented over a.

Louisville, KY, US

• Member of a business intelligence team serving a publicly traded racing and gaming corporation. Designed, planned, and developed an enterprise data warehouse (EDW) powered by MS SQL Server, analyzing racing and casino.
• Led a project to add new metrics from a custom historical horse racing (HHR) casino system into the data warehouse. Met with business leaders and subject-matter experts (SMEs) to identify pain points and desired.
• Led data model development integrating multiple heterogenous data systems, including: casino operations, VIP customer promotions, point-of-sale food and beverage sales, HR employee time, and general ledger accounting.

US

• Designed the database architecture for a banking software administering online bill-payment banking services. Planned and reviewed design and schemas of online-transaction processing (OLTP) databases for a payments.
• Planned database design for a transaction processing engine (TPE) enterprise service. This handled payment transactions for over 4,000 financial institutions, as well as third-party remittance from RPPS and other.
• Coached contract developers on SQL best coding practices. Led peer reviews of database development code scripts. Counseled over a dozen developers on best practices for database development.

Lagrange, Kentucky, US

• Developed ETL packages for a health insurance subrogation firm. Imported files from health insurance providers containing millions of rows of subscriber and claim data in a variety of formats, including EBCDIC, X12.
• Implemented data loading applications using SSIS for loading client insurance data into databases for data mining. Client data received in multiple formats, including fixed-width text files, delimited.CSV files, and.
• Developed SSIS package to unwrap a large-scale electronic data interchange (EDI) file standards 834, 835, and 837.

Dallas, TX, US

• Created automated reports for a company producing software platforms supporting home health and hospice agencies. Developed ad-hoc and preconfigured reports for enterprise-level Software as a Service (SaaS) managing.
• Developed data reports powered by SQL Services Reporting Services (SSRS) reporting clinical and financial data for home health and hospice agencies. Over 60 agencies were served by this platform.
• Developed stored procedures, views, functions, and other SQL data objects providing data for these reports. Developed and deployed data ETL packages to analyze and report internal business metrics and trends. Created.