Software Engineer(PL/SQL developer)

Resume

JAMSRANDORJ BATBAYAR

************@*******.*** 1000 North 4th Street, MR 219

https://www.linkedin.com/in/jamsrandorjb/ Fairfield, Iowa 52557 https://www.hackerrank.com/jamsrandorjb 319-***-**** SOFTWARE ENGINEER (Java PL-SQL Developer)

Skilled Software Engineer with total 3 years of hands on experience in software development and 2 years of PL/SQL development experience managing data mining and database development projects. Proven ability improving system efficiency and functionality by optimizing queries and removing unused data. Experienced in client-side and server-side development while implementing technologies such as Java, C# .Net, MS SQL, and OracleDB. Database Management • Architecture Design • UI Development • Unit Tests • Backend Development Data Mining • Stored Procedures • Desktop Application Development • Integration Databases: Oracle PL/SQL – 2 years, MSSQL – 2 years, MySQL – Knowledge, HBASE - Knowledge Languages: Java – 3 years, C# .Net – 2 years, Spark - Knowledge, Scala - Knowledge Web: AngularJS, PHP, XML, JSP Web Services: JSON, RESTFUL, SOAP Web/app Servers: Apache Tomcat, JBoss Tools: Eclipse, Oracle Database 11g, Microsoft Visual Studio, MSSQL Server R2 2008, Workbench, Hive, Flume, Hadoop, Zookeeper, Kafka, MapReduce

PROFESSIONAL EXPERIENCE

Database Developer / Billing Engineer UNITEL GROUP, Ulaanbaatar, Mongolia • 2016-2017 Led database development by creating stored procedures on Oracle Database. Mined useful information from raw and real time data for targeted campaigns for more than 1.1 million subscribers. Tasks Performed:

• Maximized old running campaigns by improve PL/SQL stored procedure code from previous versions.

• Enhanced billing system speed by ensuring query optimization and backing up unused data.

• PL/SQL Jobs, Sequences, Indexes, Partitions, Package and Stored Procedure and Function development on Oracle Database with data mining from raw and real time data.

• Generated campaign reports and presented results to other units and divisions.

• Designed and maintained internal web platform, I was responsible for OracleDB database management.

• Bulk data loading and transforming through Databases and Shell programming for automation. Upgraded system operations and server version.

• Performed unit tests. Developed new window for direct campaigns to streamline rewards and promotion programs. Technologies Used: Oracle DB, Oracle Database 11g, PL SQL, PowerShell, Java, REST API, AngularJS, PHP, Eclipse, Windows, Windows Server.

Software Engineer INTERACTIVE BI LLC, Ulaanbaatar, Mongolia • 2014-2016 Developed desktop applications as part of team by implementing JavaEE for server-side development, C# .Net for client-side development, and MS SQL for database management.

Tasks Performed:

• Created mobile and desktop version for various projects. Integrated system modules with 3rd party applications by establishing public functions and APIs.

• Implemented REST API development. Performed Unit tests and debugging before quality and monitoring processes.

• Identified best database structures and table relations with Senior Engineer and created tables, indexes, primary key, and foreign keys.

• Monitored table data and implemented corrections as needed. Technologies Used: Java, JavaEE, C# .Net, REST API, MS SQL, REST API Eclipse, MS Visual Studio, MS SQL R2 2008, Windows, Windows Server.

EDUCATION

Master of Science in Computer Science

Bachelor of Science in Computer Science

Maharishi University of Management

Fairfield, Iowa, USA

Mongolian University of Science and Technology

Ulaanbaatar, Mongolia

In progress via distance education; expected completion 20 June 2020

Graduated in Jan 2015

Contact this candidate