PL/SQL, Data Modeling

Jaemyeong Jeon

**** ****** **. ******, ** *****

253-***-**** • ac2ak8@r.postjobfree.com

Visa Status: Permanent Resident

Oracle PL/SQL Developer

Strong technical skills with advanced education and current and in-depth knowledge of diverse development methodologies

Technically sophisticated with extensive experience in development of full life-cycle project. Diverse development encompassing project life-cycle development; database design, implementation and delivery. Good problem solving skills with enthusiastic and self-starter. Cooperate well with team members.

Design and Development

Troubleshooting / User Training and Support

Technical Proficiencies

●Platforms: Unix/Linux(including shell script)

●Database: Oracle 11g/12c (SQL and PL/SQL)

●Language: C/C++, XML

●Tools: PL/SQL Developer, eclipse, TOAD

●Microsoft Office software (Word, Excel, PowerPoint)

Area of Interest

●Query Optimization, Tuning, Indexing

●Big data, Statistics

Professional Experience

Vitech, Oklahoma city, OK 2015 -

Successfully developed an administrative software for teacher’s retirement system as a PL/SQL developer. The system receives funds from their members and pays the money and its interest to the retired members or designated beneficiaries as a pension or a lump sum. The system consists of several hundreds of tables, some of which contain tens of millions of records.

●SQL: Query optimization, performance tuning, indexing, and etc.

●PL/SQL: Script, Function, Procedure, Package, Trigger and etc.

●SVN and Data transformation (ETL).

●Data Modeling and Reporting

University of Oklahoma, Norman, OK 2013 – 2014

Postdoctoral Scholar

Performed on Mobile Cloud project as a team member. Found a new and efficient way to maximize the Cloud owner’s profit while providing fast and exact answers of the query to the mobile users with smartphones.

●Big data

Oklahoma State University, Stillwater, OK 2010 – 2012

Postdoctoral Scholar

Researched on Quantitative Finance. Developed a stock investment model in C on Unix environment. The annual profits of the model were approximately 25% above the market average profits from 1996 to 2011.

●statistical modeling techniques

Defense Acquisition Program Agency, Kent, WA 2006 - 2009

Communication equipment Officer

Succeed in purchasing of $1.6-billion AEW&C (Airborne Early Warning and Control) System as a member of negotiation team. Managed the configurations of communication subsystem including satellite communication equipment that was delivered as scheduled, passed every test and has been operating successfully.

Korean Air Force, Kyeryong, Korea 1998 – 1999

System Software Management Officer

Succeed in purchasing of MCRC (Master Control Report Center) system as a member of negotiation team. Supported successful integration of MCRC software.

Republic of Korea Air Force, Taejeon, South Korea 1996 – 1997

Database developer

Successfully developed and maintained Human Resources System. Experience in System Analysis, Design, Development, Maintenance and Support using Oracle Database.

●Data modeling

●coding SQL and PL/SQL

Republic of Korea Air Force, Taegu, South Korea 1988 – 1992

COBOL programmer

Successfully developed and maintained Logistics System.

Education

Ph.D. (Computer Science, Database), 2005

KAIST (Korea Advanced Institute of Science and Technology), Taejeon, South Korea

Dissertation: Filtering Query XPath Expressions for Efficient Access Control of XML Documents.

MS (Computer Science, Database), 1995

Oklahoma State University, Stillwater, OK

Thesis: Multi-disk Allocation Methods for Bang Fiiles.

BS (Computer Science), 1988

Air Force Academy, Cheongju, South Korea

Contact this candidate