Uploaded File
Xiaoyi
wangxiaoyi0918@gmail.com
201-637-2320
220 Congress Street
Jersey City, NJ 07307
Oracle PL/SQL Developer
10 years experience W2
0
Recommendations
Average rating
85
Profile views
Summary

An IT professional with more than 3 years of experience as Oracle Developer for System Analysis, Designing, Testing Development & Support of Oracle 11g & 12c in Production, Staging, Development environments. * Extensive domain knowledge in Retail and Insurance industries. * Over 3 years of experience in Data Migration, Data warehousing and ETL (extraction, transformation and loading operations). * Over 2 years of experience in UNIX Shell-Scripting.

Experience
Oracle PL/SQL Developer
Information Technology
Sep 2015 - May 2016

This project involved developing an automated interface between the UniClaim (UCP) system and the Policy Data Mart (PDM). This UCP to PDM interface allowed all policy information needed to establish a Business Owner Policy (BOP) loss on the UCP system to be added to UCP through an automated process. The project further developed the PDM to a single repository used to store all commercial and personal lines business. This centralized database provided any external source that needs to obtain complete details on a policy.

Responsibilities:

Responsible for requirements gathering, analysis, design and development of any enhancements in the application.

Created and maintained database objects like Tables, Views, Materialized views, and Synonyms to support business requirements.

Developed Stored Procedures, Functions, Triggers and Packages to meet the business requirements and update the existing objects based on change requests.

Utilized database links to accommodate cross-database transactions.

Extensively used PL/SQL Collections and Records, Partition methods for oracle tables and indexes.

Worked with Bulk Collect to improve the performance of fetching data.

Performed Oracle Performance tuning using SQL_TRACE and EXPLAIN PLAN.

Implemented table partitioning and sub-partitioning to improve performance and data management.

Handled errors using Named System Exceptions such as INVALID_NUMBER, NO_DATA_FOUND and PRAGMA EXCEPTION_INIT.

Created aggregate materialized views in Data Mart.

Designed and developed data loading processes using PL/SQL and UNIX Shell scripts.

Involved in developing ETL Process to load the data from different sources.

Used SQL*Loader and external table to successfully massive data migration.

Used AUTONOMOUS_TRANSACTION PRAGMA to log the status when error occurred.

Triggers TOAD Stored Procedure SQL Loader SQL Shell Scripts PL/SQL Oracle 11i Oracle ETL SQL Developer UNIX Data Marts PL/SQL Developer Requirements Gathering Data Migration Database Design Performance Tuning
Remove Skill
Oracle PL/SQL Developer
Information Technology
Jul 2011 - Apr 2013

The BI solution will help the customer to define and setup a shared service environment for BI to get a greater return on existing information assets through better control, fewer data inconsistencies and greater alignment with business users. The engagement defined best practices for OLAP/reporting architecture and reduced BI proliferation through standardization of business intelligence products in the organization.

Responsibilities:

Gathered development requirements from client’s functional team and functional design specification documents.

Created logical and physical database objects - table spaces, tables, indexes, referential integrity constraints, and triggers to development needs.

Responsible for the development of pipelined functions using ref cursors and PL/SQL stored procedures as per client requirement.

Construct complex queries to classify customers based on the location and allocate a biller.

Optimized the Oracle PL/SQL queries by Performance Tuning.

Fine-tuning of PL/SQL Stored Procedures using Hints in EXPLAIN PLAN.

Authored the technical design documents for the given functional design.

Responsible for developing technical components for the following Oracle Applications modules: Custom Char Resolve, Conversion Resolve, Upc Resolve, Scope Resolve, View/SubTotal Resolve, Hierarch Resolve.

Run batch jobs for loading database tables from flat files using SQL* Loader.

Tested codes developed by self and team.

Fixed bugs while in production with top priority.

Triggers TOAD Stored Procedure SQL Loader SQL PL/SQL Oracle Oracle 11i Business Intelligence OLAP ORM SQL Developer PL/SQL Developer Database Design Performance Tuning
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Electrical Engineering
Stevens Institute of Technology 2015
Information Engineering
Beijing University of Posts and Telecommunications 2011
Skills
Database Design
2016
3
Performance Tuning
2016
3
PL/SQL Developer
2016
3
SQL Developer
2016
3
Oracle
2016
2
Oracle 11i
2016
2
PL/SQL
2016
2
SQL
2016
2
SQL Loader
2016
2
Stored Procedure
2016
2
TOAD
2016
2
Triggers
2016
2
Business Intelligence
2013
1
Data Marts
2016
1
Data Migration
2016
1
OLAP
2013
1
ORM
2013
1
Requirements Gathering
2016
1
UNIX
2016
1
Data Warehousing
0
1
ETL
2016
1
Shell Scripts
2016
1
System Analysis
0
1
Languages
English, Fluent/Bilingual
Mandarin, Fluent/Bilingual