NOROVDORJ(NORO) OTGONBAYAR

669-***-**** • ad0sky@r.postjobfree.com • www.linkedin.com/in/norovdorj

Data engineer

SUMMARY

A Data Engineer with 8+ years of

professional experience in processing

large scale of data by developing and

optimizing Business Intelligence and

Data Warehouse functionality with

advanced SQL hands on expertise.

Skilled in implementing technologies

such as Python, Java, ETL and database

high availability, disaster recovery and

cloud maintenance configuration.

• Data modelling

• Database design & modeling

• Python Development (migration

and data cleansing)

• ETL development and pipeline

• Data migration

• Performance tuning

SKILLS

Language:

Python

SQL (PL/SQL, T-SQL) ...

Java

Databases:

Snowflake

SQL Server

PostgreSQL

MySQL

Oracle

Azure:

Azure Function

AWS:

AWS EMR

AWS Glue

Amazon S3

Amazon Redshift

ETL:

ADF

SSIS

Talend

OLAP Cube SSAS

Linux

Jira, Scrum

PowerBI & SSRS

Big Data:

Hadoop, Map Reduce ..

Spark, Kafka

HBase and Hive

TOOLS

Bitbucket Azure DevOps VSCode

SnowSQL SSMS Toad, Oracle SQL

Developer SSIS Jupyter Notebook

Data profiler DSP SSRS SSAS

PgAdmin Visual Studio GIT

PROFESSIONAL EXPERIENCE

Trellance (Tampa, Florida)

Data Engineer Mar. 2022 – Oct.2023

• Implemented ADF pipeline which deals with various types of databases such as Oracle, SQL server, DB2.

• Involved new design of architecture which make our main product more reliable, performative.

• Designed and developed migration pipeline based on Azure Data Factory.

• Developed extensive functional Snowflake Procedures processes as part of ADF pipeline.

• Converted old C# Ingestion process into Snowflake procedural steps ADF pipeline.

• Developed various types of validation Snowflake procedures in different languages such as SQL, Java script and Python.

• Worked Azure DevOps pipeline which automatically creates prod or non-prod Snowflake environment.

• Tracked and resolved real time client’s major incidents with product owners for our system reliability.

Rio Tinto (Ulaanbaatar, Mongolia)

IT and Data delivery centre in Mongolia for global mining company (Headquarters in London) Data Engineer (Productivity Metric Developer) Jan. 2019 – May. 2021

• Included a team for agile development through Jira (SDLC).

• Implemented a serverless architecture using API Gateway, Lambda and Dynamo DB and deployed AWS Lambda code from Amazon S3 buckets.

• Migrated entire company workload to AWS cloud leveraging EC2 and S3 for efficient scaling, increasing efficiency by 30%.

• Data ingestion from unstructured data to relational database using Python.

• Worked on Advanced SQL query, and Designed data modeling.

• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.

• Provided data cleansing and quality using Python.

• Built any in-house development on Python.

Information Technology Center in General Department of Taxation (Ulaanbaatar, Mongolia)

Database Developer Aug. 2016 - Jan 2019

• Created extensive PL/SQL and T-SQL queries (OLAP & OLTP) for monthly billing process.

• Configured indexing, partitioning and replication for database high availability.

• Optimized DB and SQL Query for effective system usage and DB performance.

• Developed Java jar for database maintenance and migration.

• Deployed necessary procedures, functions, and triggers on Database /Oracle and MSSQL/

• Designed physical database schema and modelled data.

• Taken RMAN actions for Oracle and MSSQL database backup and export, import tasks.

• Monitoring database backup, export, and import with disaster recovery plan with database replication.

Java Backend Developer Jul. 2014 – Aug. 2016

• Used RESTful web services to expose certain functionalities of the application.

• Used Spring Dependency Injection feature for Bean wiring. EDUCATION

Master of Science in Computer Science

Maharishi International University, Fairfield, Iowa (May.2021 – June 2023) Master of Engineering in Space Technology Applications Beihang University, Beijing, China (Sep.2012 – Jul.2014) Bachelor of Science in Software Engineering

National University of Mongolia, Ulaanbaatar, Mongolia (Sep.2007 – Jun.2011)

Contact this candidate