Summary

• Proven expertise of developing complex queries using PL/SQL, utilizing collections associated array, vaary, and nested tables , forall, bulk collect , result caching method , pipeline, Cursor operator, table function, analytical functions, optimizing PL/SQL performance, materialized views, partition, etc.
• Excellent SQL performance Tuning and query optimization experience by using Explain Plan and caching techniques.
• Ability to be self starter with the ability to investigate and work independently without supervision.
• Master degree in Computer Science and 20 years proven experience in design, development, and implementation.

TECHNICAL SKILLS

Software: SQL plus, Toad, SQR, Aqua data studio, TERADATA, ORACLE 11g, Sybase, SQL Server, UNIX, LINUX, SHELL/AWK, PERL, AUTOSYS job schedule, SCCS, CVS, Agile Development Environment ,TCP/IP, Window NT .

Languages: UNIX/C/C , ASP, JAVA, JSP, J2EE, HTML, XML, ORACLE PL/SQL.

PROFESSIONAL EXPERIENCE

Confidential

Senior Software Developer

• Worked on the Mobility Demanding Forecasting MForecast system. This system collects, analyze and forecast the GSM 2G , UMTS 3G and LTE 4G data usage and voice usage for all US 29 market..
• Get data from various source Excel file, Flat Unix file and Web site to load onto local database periodically.
• Backup and Archived monthly Scamp Calling detail Record CDR data to Unix system storage.
• Extract the small cell data from Unix files and inserted into 24 summary tables aggregate as useid, submarket, market for hourly, daily and monthly sets . Thereafter, refreshed the related 30 Oracle Materialized View.
• Rewrite the PL/SQL scripts to enhance the performance.

Confidential

Senior Oracle PL

• Worked on Pole Record System PRS billing system. This system deals with pole, conduit and combined type on monthly, semi-annual and annual billing frequency. It also handles the advance billing and arrears billing for each billing frequency and agreement type on different attached rate.
• Solely maintaining all the PL/SQL packages over 10,000 lines code which contain 150 stored
• procedures and functions under the version Oracle 11g system.
• Extracting, transforming and loading ETL large data sets from various data sources using UNIX
• tools shell scripts, Awk , Nawk, CVS and Perl , EXCEL and SQL Loaders.
• Using optimization techniques and enhancing the elapsed time over 70 .
• Working with DBA colleague about DB architecture and data modeling.

Confidential

Senior Database Developer

Worked on data mining research projects that require assembling large quantities of data from a variety of sources. Data is queried, filtered, sorted, and merged in preparation for sophisticated analysis.

• Engaging in various databases: SQL Server 2008, Oracle 11, Teradata, Daytona/Cymbal and Hadoop/HIVE and different systems: EDW, eCDW, SCAMP and Yellowpages.
• Coding 40 PL/SQL stored procedures and functions using optimizing technology of Oracle 11 g.
• Manipulating large data files, joining them on an appropriate join keys, transforming data for anonymous purpose.
• Extracting, transforming and loading ETL large data sets from various data sources using UNIX tools shell scripts, Awk , Nawk and Perl and SQL queries and JDBC.
• Engaging in database architecture, building indices, developing stored procedures, monitoring, performance tuning and trouble shooting.
• Developing regular processes and CRON job to extract and manipulate these data.

Confidential

Senior Database Developer

• Worked on the Corporate Repository Architecture CRA Security Policy Strategy SPS application under the

Oracle PL/SQL and SQL Server

• Designed, coded, and implemented ORACLE PL/SQL 120 procedures, functions and triggers.
• Designed code and implemented 65 SQR Structured Query Report which dealing with filtering records, sorting records, joining multiple tables, alias, calculated fields, union queries, grouping and aggregate fields.
• Using DTS package to extract, transform and load data ETL from SQL Sever 2003 to SQL Server 2008.
• Managed a team of 5 developers.
• Troubleshooting and performance tuning the Database stored procedures and complex scripts. The overall enhanced rate is over 60 .
• Provided the Data modeling and analysis consulting to team members. Especially in table schema, index and normalization.
• Worked with Business Analysts and clients to review the business requirements and translate them into database objects.
• First place in the UPS project Lead Campaign picture on the front page of UPS weekly publishing .

Confidential

Senior Software Analyst

• Worked on the Secondary Marketing System SMS of the Capital market Department. This application is under
• Designed and coded the shell scripts.
• Migrated and enhanced the C programs from Sun Solaris 2.4 to 2.8 and Sybase 11.5 to 12.4.
• Monitored production logs.
• Investigated and resolved Sybase issues.

Confidential

Senior Programmer

• Worked on MOL Morgan On-Line project for J.P Morgan Marketing Site. MOL is an Equity financial product system which uses J2EE standards, Servlets 2.2, JSP 1.1, HTML 5.0 and Perl/CGI under Designed and developed programs for Client Request, generating the Server Response.
• Migrated UNIX C/C /SHELL PERL programs from non-Y2K compliant to Y2K compliant.
• Designed and developed programs for JAVA Servlets Cookies and Session Tracking.
• Designed and developed JAVA Beans with JSP, JDBC and Database integration.
• Migrated Sybase stored procedures from non-Y2K compliant to Y2K compliant.
• Maintained and fined-tuned all the Sybase related problems.
• Managed all users, logins, permissions, backup, performance and logs of the Sybase.
• Migrated UNIX/C/C programs to JAVA programs.

Sybase Consultant

Worked on Electronic Communications Request Broker ECRB . ECRB is a data pipeline between AT T and the Local Exchange Companies LECs . It passes information for service orders from AT T to the LEC, and in the other direction. ECRB operates in an HP-UNIX/SHELL/C , and SQL/Sybase 11 environment.

• Managed the db main process, which totals over 200 files including C/C /Rogue Wave, Header, Shell, Perl, AWK, Make, Stored Procedure, and DDL.
• Maintained and administrated five databases, including server, database level and schema level.
• Provided consultation for Sybase related issues.