Experience

Trellance

• United States
• Financial Services
• 100 - 200 Employee

• Data Engineer

  • Mar 2022 - Present

  United States



Rio Tinto

• United Kingdom
• Mining
• 700 & Above Employee

• Data Engineer

  • Jan 2019 - Apr 2021

  Mongolia • Advanced SQL, query, data modelling • Relational databases and the Structured Query Language (SQL) • Microsoft SQL Server 2012 or later, T-SQL • Extract, Transform and Load (ETL) concepts and design patterns • Microsoft SQL Server Integration Services (SSIS) 2012 or later • Tabular modelling and querying, basic familiarity with DAX • Microsoft SQL Server Analysis Services (SSAS) 2012 or later • Basic familiarity with Microsoft Power Platform would be desirable •… Show more • Advanced SQL, query, data modelling • Relational databases and the Structured Query Language (SQL) • Microsoft SQL Server 2012 or later, T-SQL • Extract, Transform and Load (ETL) concepts and design patterns • Microsoft SQL Server Integration Services (SSIS) 2012 or later • Tabular modelling and querying, basic familiarity with DAX • Microsoft SQL Server Analysis Services (SSAS) 2012 or later • Basic familiarity with Microsoft Power Platform would be desirable • Strong problem solving and analytical skills • Enhance Metrics Engine: continue to implement additional solution features and enhancements to improve Metrics Engine robustness, maintainability and flexibility to meet project requirements. Basic Metrics Engine development activities include • Analyze requirements for and implement new metrics based on existing atomic dimensional data in Metrics Engine • In-house development in Python • Bring in new data sets, up to the Metrics Engine atomic dimensional layer • Make necessary modelling changes to the existing data model to meet project requirements • Provide additional ongoing support for the Metrics Engine technical solution: The objective is to address any issues, questions and changes arising from the previously published Metrics Engine -driven reports and metrics. Core Metrics Engine maintenance activities include: • Query and interpret Metrics Engine metrics data • Work with the various Metrics Engine environments • Monitor and troubleshoot regular data loads • Develop External Metrics Technical Proof-of-Concepts (PoC): deliver PoCs as necessary demonstrating the ability to use MDS - defined metrics outside of the core Metrics Engine solution Show less



Information Technology Center in General Department of Taxation

• Database Developer

  • Aug 2016 - Jan 2019

  Mongolia VAT promotion system(www.ebarimt.mn) Database : Oracle and MSSQL - DBA tasks on Oracle databases. - To deploy necessary procedures, functions and triggers on Database /Oracle and MSSQL/. - To provide necessary SQL queries and scripts to development team. - Oracle and MSSQL database backup and export, import tasks, RMAN actions - SQL tunning (Query analyzing and generate) and PL/SQL developing, Transact-SQL developing.

• Java Developer

  • Jul 2014 - Aug 2016

  Ulaabaatar, Mongolia o Used RESTful web services to expose certain functionalities of the application. o Implemented Spring Dependency Injection feature for Bean wiring. o Worked with Hibernate Query Language HQL to query the database for complex data. o Developed using Agile software development methodology on Spring framework.