Summary: Over 3 years System and Oracle Database Administrative (Oracle DBA) support for the MCP system. Over 12 years software design, test and support experience in complex and large scale systems, in which over 3 years in Multimedia Communication Platform (MCP/VOIP) using PERL, ORACLE PL/SQL and Java, 5 years in GGSN and SGSN for GPRS/UMTS using C++/C, 1 years in wireless prepaid using C++/C, DB2 and IBM DirectTalk, and over 3 years in remittance system using C++/C, Informix database/SQL, HTML and UNIX shell script. 

Perform varied functions crossing all aspects of software development cycle: writing feature technical requirements, design, coding, feature and traffic testing, system sanity, lab prime, source code management, load build, training, documentation, design and customer support. Perform system and Oracle DB installation and upgrade.

Objective: Full-time or contract position in Oracle DBA, Oracle database design, software & IT design, test and support.

Certificate: Passed Oracle Certificate Exam: Introduction to Oracle: SQL and PL/SQL. Working toward Linux + and Oracle OCP certificates.

Experience History:

Confidential, Richardson, TX. Member of Scientific Staff
(June 2000 – September 2009)

Provided system and Oracle Database Administrative support for the MCP system. Designed, developed and maintained the software and documentations for the MCP (Multimedia Communication Platform) system on the Linux platform using PERL, ORACLE PL/SQL, and Java.

• Provided system and ORACLE DB Administrative support (Oracle 9i/10g install/upgrade, backup/restore using import/export/Datapump/RMAN, Advanced replication/Streams, OEM Grid Control/Database Console, Dataguard, generate Oracle installer/patch, write store procedures, functions, utilities, help with performance tuning and etc.) for the labs, WIPRO, NETAS, product test, design/support, and VO team. Performed mock DB upgrade testing using customer site data. Be an interface between design and documentation to generate the customer facing documents and solve system upgrade and documentation issues stemming from system test and customer. Familiar with Oracle Support processes for technical requests with Metalink.
• Developed multiple features including “AS5300 1.0 Base and OAM Security” using PERL and Oracle PL/SQL. Implemented the ORACLE Database auditing, DB account encryption and decryption, profiles and associated password policies, user roles, privileges and alias, DB install and upgrade scripts. Wrote DB Store Procedures, functions and DB script utilities. Solved Federal Oracle STIG findings.
• Be the feature prime of system/Oracle upgrade features cross different MCP releases and products such as AS 5200 Standalone/IMS, CS2K-A2E and AS5300 Federal and Defense. Led a remote team of 3 WIPRO contractors in India. Assigned tasks and provided training and guidance to them. Supported and solved any issues they had via phone, IM or Netmeeting. Worked nightly to closely coordinate with the remote team. Held the weekly feature meeting. Made sure feature contents were delivered on time and with high quality.
• Be responsible for the design compliancy to the feature requirements, generating feature technical requirement specification, implementing the feature (by generating the system/Oracle upgrade procedures for different products and changing codes by using PERL and Oracle PL/SQL), writing high level feature test strategy, test plan and test cases, setting up the lab (installing OS, Oracle and MCP system), performing pre-upgrade and post-upgrade system sanity and running CallP traffic.
• Took on the self-motivation to improve the upgrade procedures. Significantly reduced manual steps and upgrade time by introducing new customer PERL scripts and procedures.
• Enhanced the tool that generated the logs and alarms automatically for the MCP system using Java.

Designed, developed, tested and maintained the software for GPRS/UMTS GGSN(3GPP Interfaces Gn, Ga, Gx, Gy) on the MPE (Multiservice Provider Edge) and Shasta platforms using C++/C.

• Be the sole designer in the GGSN IPv6 CSC redundancy project: Design and develop the IPv6 redundancy feature for the GGSN product. Write the DD and DT documents and performed unit and integration test using Radius authentication/accounting and Diameter prepaid.
• Be the sole designer in the carrier grade SPM and RMS failure handling project: Design, develop and test the feature such that all calls will continue when SPM or RMS recovers.
• GGSN5.1 release (on Shasta) design support: Solve CRs that are opened by the tester or customer.

Designed, developed, tested and maintained the software for GPRS/UMTS SGSN(3GPP Interfaces Gb, Iu, Gr, Gd, Gs, Gn, Ga, X1_p) on the Passport VxWorks platform using C++. Assumed group head responsibility, source code management and load build with ClearCase, load and stress traffic test using K1297 and MGTS, and switch performance profiling and improvement.

• Took a lead role in the SGSN LI (Lawful Intercept) project: designed and developed the feature based on 3GPP standards and 3rd party Gateway interface via TCP/IP. Enhanced the software to support UMTS/GPRS Combo Node, fault management and IPV6. Increased TCP read throughput to overcome buffer overflow during high traffic.
• Took a lead role in the SGSN IMEI project. Enhanced GMM, Context Manager, MAP, LI and Billing. Hold the team together to work through blocking issues and meet the milestones with high quality.
• Assumed LI Component group head responsibility. Acted as the Interface between design, PLM, System Engineer, Field Support and 3rd party. Bridged the communication gaps, coordinated between local and oversea design groups, and facilitated conference calls. Helped to define system dimensioning, shape requirements, answer customer’s RFI, and assist with resource allocation and planning.
• Ran GPRS/UMTS traffic using Tektronic’s K1297 and Catapult’s MGTS. Be a lab prime for the design traffic lab. Worked with design, test and Tektronic support to keep the lab sane by solving hardware or software issues. Trained people on running traffic and did lab scheduling.
• Managed source codes in the ClearCase environment: created the branch strategy, load build, solved compiling and linking errors, sanitized the load, downloaded to multiple traffic labs.
• Sole developer on MAP card enhancement: Performed card CPU profiling. Changed code to improve CPU performance by 20% and eliminated memory leakage in CAMEL TCAP dialogue.
• Be a key patch consultant on the TMO billing fast feature project. Designed, developed and tested the patch solution under extremely short time constraints and high customer expectations with high quality.
• Supported GPRS/UMTS SGSN PC03 and PC04 releases design. Solved problems reported by the customer and tester in Clarify. Analyzed the field data and perform outage/Field issue Root Cause Analysis. Provided complete technical support and training for product test, IOT, End-to-End lab and customer trials.
• Wrote HLD, FN, DD and DT documents according to the TL9000(ISO) design procedure. Prepared test cases and test plans. Also performed integration testing for the feature using GAP/CATT automation tool.

Designed and supported WPP (Wireless Prepaid) project using C++, DB2 and IBM DirectTalk.

• Provided the IVR and ETI patches and emergency fix for RPC server problem.
• Provided second line support for WPP 4.0 and 3.0 releases.
• High level designed the payment server prepaid protocol interface to support both CAMEL and IS41 protocols such as the interfaces among prepaid, account operation and data warehouse modules.

Confidential., Irving, TX. Software Applications Engineer
(January 1997 – June 2000)

Designed, developed and troubleshoot the application software for financial transaction processing systems using C/C++, Informix ESQL/C and 4GL, UNIX Shell script, and TCP/IP on UNIX workstations and Window NT:

• Be a key development engineer in GTE-customized OSA (Open System Architecture) remittance system and American Express-customized MARS (Multiple Application Remittance System).
• Researched on clients’ business requirements and proposed new features to improve the capabilities and reduce costs, such as COINS, CAN, UNID, NODOC, NSF and Archive Retrieval.
• Designed and implemented the new features, such as Archive Feeder which submits data and images to remote server via TCP/IP, NSF, NODOC and GTEC which processes GTE’s new bills.
• Monitored system performance, tuned up Informix database, upgraded hardware and fine tuned operating system (HP-UX) to improve throughput.
• Served as the critical forefront of Banctec’s interface with the client and third party in identifying specification, software development and integration testing.
• Traveled to customer site for software installation, field support and training. Performed on-call support.
• Installed and administrated PVCS for the project source codes version control.
• Took a lead role in interviewing candidates, project evaluation and planning, and document inspection.

Confidential, Grand Prairie, TX. Internet Software Programmer
(June 1996 - August 1996) & System Administrator

Designed and implemented a web-based on-line interactive catalog and secure order processing system running on a Window NT server for Vektron International:

• Automatically updated the company product database using FoxPro 2.6 and Excel 5.0.
• Generated the interactive catalog HTML documents and quotes using FoxPro database and Visual Basic 4.0.
• Took electronic orders and stores them in the database using ICat Commerce Suite software and CGI.

Also being a system administrator, setup and maintained corp. LAN, troubleshot the mail and web servers, backed up/restored Window NT and network file systems, and provided direct support to about 60 end-users.

Platform & Software:

• LINUX/UNIX
• VxWorks
• Mac OS X window
• Window XP/95
• OS/2
• Oracle
• Informix
• DB2
• TCP/IP
• Excel
• FoxPro
• Matlab
• DirectTalk
• Access

Programming:

• Perl
• Oracle PL/SQL
• C++/C
• Java
• Tcl/TK
• HTML/CGI
• UNIX shell script
• Visual Basic
• Yacc/Lex
• Fortran
• Pascal
• dBASE IV
• ICL
• PVM
• Prolog

Hardware Experience:

• CC3310
• HT Langley
• BC-T
• Passport
• SUN SPARC
• HP9000
• Intel iPSC/860
• Intel Paragon
• IBM RS6000
• Cray T3D

Educational Background: M.S., Computer Science 
M.A., Mathematics 
B.S., Computational Math and Applied Software