Ken L. Email and Phone Number

- Architect and develop modern data pipelines for structured, semi-structured, and unstructured data from internal and external sources for the Department of Safeguards.- Shape and maintain the information ecosystem to ensure coherence and consistency in data processing pipelines.- Facilitate effective dissemination of information across various organizational domains.- Optimize data quality, usability, and accessibility to support analytics, data science, machine learning, and operational needs.- Enhance the Department's ability to draw strong safeguards conclusions and prioritize verification activities.

- Lead the design, development, and implementation of scalable and securedata pipelines- Promote best practices in data engineering, including data as product, datacontract, data quality, version control, and documentation- Oversee the data architecture and ensure it aligns with concrete andmeasurable business use case- Work with data scientists, data engineers, analysts, and stakeholders tounderstand data requirements and translate them into technical solutions- Work with team to resolve data synchronization and consistency issues from salesforcedynamic values changes to snowflake- Collaborate with Platform engineers to ensure seamless integration anddeployment of data pipelines via common CI/CD toolkits like Terraform andGithub Actions- Monitor and troubleshoot data pipelines, proactively identifying and resolvingissues- Develop and maintain documentation for data pipelines and processesTech Stack:- Fivetran, Airflow, DBT, Snowflake (Data Mesh & Data Sharing), Data Lake,S3- AWS Aurora PostgreSQL- Salesforce CRM Data Platform- Amazon Web Services, Lambda- CI/CD, Github Actions, Sentry, Data Dog- Python, SQL, Bash, Terraform- Power BI

- Kaia Health is Munich based startup as the first musculoskeletal digital therapy to deliver best-in-class cost saving and health outcome through proprietary AI algorithm.- Architect, build and productionize Kaia's new data platform (end-to-end from scratch) -Develop roadmap, strategy, execution plan and tasks prioritization- Develop custom data pipeline - Research and develop data contract Tech Stack:- Airflow, Stitch, AWS DMS- DBT, Great Expectation- Sentry, Slack Alert- Looker- Python, SQL, Bash, Jinja, YAML - Amazon Web Services- Snowflake, Redshift, Aurora Postgres- Kinesis, Snowplow- Data Lake, S3, Parquet- Data Contract (Json-Schema)- Cloud Watch, Secret Manager, SSO- Kubernetes, Docker, Helm, Rancher, Terraform- Github, Git Action

- Architected, built & productionized custom data pipeline (airflow/s3/snowflake) from ground up.- Built docker container deployment workflow - Standardized and developed reusable data pipeline design patterns for airflow- Upgraded and migrated from airflow1 to airflow 2- Developed third party vendor custom data pipeline: 1) Tatari (7+ billions TV streaming impression records)2) Delighted3) Friendbuy 4) Loop5) Aftership6) Formkeep 7) Netsuite (ERP)Tech Stack:- Airflow- Snowflake, RDS Postgres- DBT- Looker- Docker- Python, SQL, Bash, Jinja, YAML- S3- Github, Git Action- Amazon Web Services- Amazon Cloud Watch, Sentry

- N26 is Berlin based unicorn neobank backed by Peter Thiel (PayPal)- Responsible for US N26 bank operation database, data-warehouse and data pipelines. (hands-on)- Work with Deputy compliance manager to help audit security and/or fraud risks Tech Stack: - Microservice Architecture- Data Modeling- Redshift, Amazon RDS (PostgreSQL)- SQL, Python, Bash- Custom Built Pipeline- Airflow- S3- Metabase- Snowplow- Kubernete, Docker- Terraform/Saltstack- CI/CD, Jenkins- Datadog

- Cherre is an award-winning AI startup platform in real estate industry. - Core data engineering team: Built ELT pipeline to ingest datasets released by the City of New York and private data partners. - Resolved data from tax assessments, building records, and public transactions data to build a comprehensive database of all units, buildings, and owners in the NYC market. Tech Stack: - Microservice Architecture- Google Cloud Composer (Airflow)- Google Cloud SQL (Postgres), Google Bigquery, MongoDB- Hasura- Looker- Docker- Python, SQL, Bash- GraphQL- Google Cloud Monitoring

- ABC Fitness Solutions offers the most proven club management solution in the fitness marketplace.- Team leader and data architect for core data team of 5 and overseeing offshore contractors (Exadel, Infosys) - Direct report to CTO - Built and scaled team from scratch for operation, data warehouse and business intelligence departments - Architected next-generation data infrastructure platform and data model blueprint - Created roadmap, strategy, execution plan and tasks prioritization - Lead and support in house and offshore team to complete prioritized backlog tasks - Conducted interviews and hiring initiatives through human resource and recruiting agency - Conducted onboarding training, 30-60-90 roadmap, team building and weekly 1:1 with core team members. - Conducted research and proof of concepts - Data architecture, modeling and database administration - Established and enforced data integrity, data consistency, data quality - Consolidated, streamlined and migrated micro-service architecture design to domain level - Established database standards and best practices - Conducted data cleansing, consolidation and data migrationTech Stack: - Microservice Architecture- Amazon Redshift (OLAP), Amazon Aurora PostgreSQL (OLTP)- Pentaho- Kafka- Spark - Domo- Liquibase/Flyway- Kubernete, Docker- CI/CD, Jenkins- Terraform- Python, SQL, Bash- ELT- PCI compliant

Notable Clients:- Federal Reserve Bank of Philadelphia- Australian Tax Offices - British Columbia Hydro - Department of Defense

- Dell EMC is a American multinational technology company that offers products and services across a data storage, information security, virtualization, analytics, cloud computing and other data related solutions. - Led, designed and implemented Big Data projects on Pivotal Greenplum (MPP) database solutions for startups and Fortune 500 clients companies. Responsibilities includes:- Requirement Analysis - Roadmap, Statement of Work (SOW)- Architecture Design- Conduct Proof of concept (POC) and validation - Cross platform data migration- Scalable Data pipeline (high frequency batch)- Tuning/Automation - Mentoring and documentationNotable Clients:- NYSE Euronext- Wellington Management- Pitney Bowes- Orbitz - KNotice (acquired by IgnitionOne)- INTTRA

- McKesson Corp. is one of the largest providers of medicines, pharmaceutical supplies and health information technology (IT) products and services.- Led, designed and developed backend automation, ELT and reporting module for MedGift social networking project. - Developed database business logic for HIPAA compliant EDI healthcare eligibility (270) and claim status notification (277).

- US Bank is a diversified financial services company that offers retail and commercial banking, private banking, and wealth management solutions through its subsidiaries.- Led and completed technical implementation for 2 banks acquisition data conversion and migration projects with over 2 billion dollars of credit card processing revenues. - Implementation includes working with stakeholders from banks, credit card processing companies and merchants to perform data analysis, write database code to extract, transform and load processed data into database.

- Embarcadero Technologies is company that develops, manufactures, licenses, and supports products and services related to software through several product divisions.- Researched and developed index tuner simulator, the tool suggests new index type for particular column(s) to help improve query performance. - Designed and developed a versioning tool to enable multiple version of the same native product to co-exist concurrently. - Served as DBA to administer, automate, monitor, troubleshoot and tune all research and development databases.