Resume

Sign in

Oracle Developer/ Database Engineer

Location:
Centennial, CO
Salary:
TBD
Posted:
January 15, 2020

Contact this candidate

Resume:

Kesinee Tantisewie

**** *. ****** *** **** D

Centennial, CO 80121

Tel. 720-***-****

adbbdn@r.postjobfree.com

SUMMARY OF QUALIFICATIONS

Oracle Advanced PL/SQL Developer Certified Professional and SQL Certified Expert with advanced skills in various technical areas and passion in new technologies. Strong analytical, quantitative, and problem solving skills with creativity, critical-thinking, and very detail-oriented. With attitude ‘can-do’ and think outside the box, I have surprised many by achieving things they thought not possible.

Experience:

ABB, Enterprise Software (Nov 2017 – Dec 2019)

Colorado, USA

Data Acquisition Developer

Perform web scraping for energy data acquisition using Perl and the first developer to porting codes to Python for scraping which results in significantly reduce amount of effort and time for new scrapes.

Using Python modules e.g. using BeautifulSoup, JSON, Pandas, Selenium, Multithreading, etc.; to extract and transform data in various formats

Develop ETL work to import the acquired data into Oracle database using PL/SQL Comcast (Sep 2017 – Nov 2017)

Colorado, USA

Sr. ETL Developer (Contract)

Designs, develops, and supports new and existing ETL processes for CAD-AUPM project using PL/SQL

Charles Schwab (Apr 2013 – Aug 2017)

Colorado, USA

Staff Database Engineer/ Application DBA

As a member of Agile Development Team, developed codes in PL/SQL, Shell, and Perl to purge or rebalance records between millions to billions rows across 32 partition schemas within reasonable time that could not be previously achieved in the project which owns the biggest database across Schwab

Provided a new approach on updating Materialized View across single Database Link. Significantly reduced the update time as job run in parallel instead of single stream

Performed database and SQL performance analysis and tuning where most tables have number of records in ten to hundred millions ranges

Worked with Java/MongoDB Team to transition Data Warehouse from Oracle to MongoDB. Provided solution on propagation data from Oracle sent to RabbitMQ via RESTful WS

Redesigned new codes that improved Check and Contribution matching processes for Schwab Charitable Fund using Advanced Oracle skills. Result in more accurate matching and ability to re-match, less maintenance work for the representatives

Supported production systems with thorough investigation and ability to find the root causes within short period of time

Colorado Access (Mar 2013 – Apr 2013)

Colorado, USA

Oracle Developer (Contract)

Developed ETL process for Healthcare Data Warehouse using Data Vault model in PL/SQL Thomson Reuters Company (2002 – 2013)

Lipper, A Thomson Reuters Company

Colorado, USA

Software Engineer/ Oracle Developer (Dec 2007 – Jan 2013)

Developed, designed, and supported of Custom Feed Generator and Factsheet products

Developed ETL processes, and backend code for Lipper for Investment Management project

Provided production support, troubleshoot, and fix codes on various production systems

Developed various financial datafeeds using PL/SQL, Oracle APEX Lead Quality Engineer/ Global Test Lead (Jan 2005 – Nov 2007)

Developed and implemented automated and manual tests for various projects using Oracle, Sybase, VB, Perl/Tk

Mentored and provided technical support and training to fellow testers

Assisted in hiring and training for Lipper’s new development center in Bangkok, Thailand Reuters Software (Thailand)

Bangkok, Thailand

Senior Test Engineer/ Test Group Lead (Oct 2003 – Dec 2004)

As a lead of a test team that compiled with CMMI Level 5 using SDLC, designed and developed test plans, test strategies, test cases for financial applications

Supervised test teams of 10 staff for Web View and Bridge Feed Broadcast projects Senior Software Engineer/ Senior Support Engineer (Nov 2002 – Aug 2003)

Provided 3rd level product support and troubleshoot for Automated Dealing system

Assisted oversea 1st and 2nd level support teams for clients e.g. HSBC in Europe and Asia Lipper, A Thomson Reuters Company

Colorado, USA

System Tester (Aug 2001 – Aug 2002)

Software testing for Lipper products e.g. Lipper Leaders, datafeeds Janssen Pharmaceutica (1995 – 1997)

Pharmacist/ Product Specialist

Thai Red Cross, National Blood Center (1993 – 1995) Lead Production Pharmacist for Blood Plasma Fracination (Government Contract) Education:

University of Colorado at Denver, Colorado, USA (May 2001)

Master of Science, Information Systems

Master of Science, International Business

Chulalongkorn University, Bangkok, Thailand (Mar 1993)

Bachelor of Science, Pharmaceutical Science (5yr Program) Certifications:

Oracle Advanced PL/SQL Developer Certified Professional (Feb 2010)

Oracle Database 10g Administrator Certified Associate (Oct 2008 – Expired Mar 2016)

Oracle PL/SQL Developer Certified Associate (Jul 2008)

Oracle Database: SQL Certified Expert (May 2008) Coursework:

M312: Diagnostics and Debugging (Completed April 2017)

M201: MongoDB Performance (Completed March 2017)

M101J: MongoDB for Java Developers (Completed March 2017)

M202: MongoDB Advanced Deployment and Operations (Completed July 2016)

M102: MongoDB for DBAs (Completed May 2016)

M101P: MongoDB for Developers using Python (Completed Feb 2016) Work Authorization: US Citizen

Technical Skills:

Advanced Oracle Skills that have been used extensively

Complex queries

PL/SQL Collections and Records as variables and input/output parameters

Nested tables and DML operations, including multilevel of nested table

Object Type, PL/SQL table

BULK Operation

REGEXP

UTL_FILE, UTL_MAIL, UTL_SMTP to send email with attachment in various formats e.g. .csv

UTL_HTTP to send request to RESTful service for changed details to pass to RabbitMQ

DBMS_XMLDOM to generate XML document

Partitioned table and Partition exchange

Java Stored Procedure

Analytic Functions

Database Objects e.g. Package, Stored Procedure, Function, View, Index, Synonym, Sequence, Trigger, Materialize View, Database Link, Type

Hierarchical Query

Job Chain, Job Scheduler

Data Pump, SQL*Loader, export/ import utilities, OEM, Oracle Installation

Experience in working with RAC, multi-servers, and Web Services environment on Linux System

Programming Languages

Expert: PL/SQL, SQL

Regularly Use: Shell, Perl, Python

Proficient: Java, C/C++, JSON, T-SQL (Sybase, SQL Server), RabbitMQ Database

Oracle 8i, 9i, 10g, 11g, 12c

MongoDB

Sybase

MS Access, MS SQL Server

Software Development Tools

Database: Toad for Oracle, PL/SQL Developer, SQL Developer, SQL*Plus, Oracle VM

Java: Eclipse, Spring Tool Suite (STS), IntelliJ IDEA

.Net/ TFS: Visual Studio, Fiddler

Project Management Tools

Agile with VSTS (current), Jira and Confluence, TFS, ClearQuest, Bugzilla, SharePoint Version Control

Git (current), TFS, SVN, CVS, VSS



Contact this candidate