×
Moses Lin

Moses Lin

Data Analyst

New York, USA
1-646-789-2487

Background


About

About

Howdy, I'm Moses and I'm a junior data analyst with a little over a year's experience in Big Data technologies. I have experience in the Finance and Fraud domain, typically with relation to ETL architecture and job monitoring/debugging. Proficient in the importing/exporting of data to/from different RDBMS such as Oracle, SQL Server, Teradata and Snowflake. Skilled in creating documentation for new/existing processes and providing detailed KT sessions for team members.

Work Experience

Work Experience

  • Senior Associate, Infosys

    Aug, 2021 - Present

    Designated as DevOps Engineer aligned with the Finance department of T-Mobile. Involved in developing and testing scripts that were to assist in various finance-related applications such as fraud detection and report generation.

    • Supported gathering details and providing timelines/updates for understanding various business requirements

    • Conducted unit testing and QAT, as well as providing fixes for data defects/failed test cases

    • Analyzed mapping implementations and wrote DML/DDL for data loads from various sources like flat files and tables into target destinations

    • Monitored and actively resolved issues in various development/test environments using Control-M

    • Converted scripts and jobs with migration of data from Teradata to Snowflake

    • Developed UNIX shell scripts for automating processes vital to daily operations

    • Created/Updated various documentations and recordings for ETL processes vital to daily operations

    • Coordinated with geographically distributed teams for successful developments, testing, and deployments of various projects

    • Provided application support and coordinated with various departments to resolve outstanding tickets/issues.

    • Received the RISE Award - Best Collaborator in Regional Quarterly Associate Event FY24Q1 for ability to work well with others

Skills

Skills

  • Languages

    SQL

    Python

    Scala

  • Tools and Software

    Teradata SQLA

    Control-M

    PuTTY

    WinSCP

    Infortmatica PowerCenter

    qTest

    Jira

    Power BI

  • Operating System

    Windows

    Unix

  • Database

    Oracle

    SQL Server

    Teradata

  • Cloud Technologies

    AWS

    Snowflake

    Databricks

Education

Education

  • Biochemistry, Bachelor of Science, Binghamton University

    Oct, 2013 - Aug, 2017

  • Data Science, Bootcamp, Flatiron School

    May, 2020 - Oct, 2020