SUMMARY:

• Extensive working experience in software design, development, testing, implementation and production/application support in financial industry.
• Advanced knowledge of database skilled in performance and tuning, data analysis and management.
• Experienced team leader to resolve critical production issue in timely manner and provide permanent solution to make production system reliable.
• Batch Development: Designed and implemented batch to meet requirements of system and OMS applications on Linux platform. Created global batch management tools and checking system with Shell Script and PERL.
• Report Generation: Created report control program with Shell Script, PERL, SQL and SQR for parallel running multiple client reports, monitoring status, backing up to archive system and delivering to client or venue.
• Database development: Designed data backup and recovery system for different levels and created data rollback procedure for applications on Sybase ASE and Sybase IQ.
• Designed and implemented database monitoring and automated maintenance system.
• Reference Data Loading: Created data loading system for data of stock symbol, dividend, broker info, closing price, compliance data and trading calendar with PERL, Python and SQL.
• Created automated system of global data consistent checking and maintenance with PERL and Csh.
• Disaster Recovery Planning: Conceptualized and designed database switch and scheduled process fail - over for system failure or DR situation.
• Created fail-over procedures for Operation team and Support teams.
• System Integration: Designed template scripts for scheduled job and file transfer to control system programming standard and quality.

SKILL:

Java/C/C++, Shell Scripting, Database Performance and Tuning, Troubleshooting and Debugging, PERL, Python, PowerShell, UNIX/Linux/Windows, T-SQL, PL/SQL, Sybase, SQL Server, DB2

EXPERIENCE:

Confidential, Charlotte, NC

Application System Engineer

Responsibilities:

• Developing Java application combining OpenText technology to realize conversion between AFP file and PDF file as required from customer.
• Developing application with Java to generate XML document for client.
• Developing tool scripts with ksh and PERL for document system to optimize document processing and delivery.
• Supporting and trouble shooting production system for documnet processing and delivery.

Environment: Linux, Windows, Java, Ksh,PERL, OpenText, WinSCP,CA, AntHill, Pac2000

Confidential, New York City, NY

Production Support Analyst

Responsibilities:

• Provided continued maintenance for GSAM QIS production system with tools AutoSys, Procmon and JIRA.
• Improved and enhanced supporting tool with Shell Script, PERL and Slang.
• Diagnosed and troubleshot Java application, Tomcat and Apache server on Linux and applied solutions to ensure the stability and the efficiency of production system.
• Monitored Sybase and DB2 database performance. Made data issue analysis and data recovery.
• Controlled and implemented changing with T-SQL and PL/SQL in database level for Research teams.
• Supported reference data loading from vendors to various internal application systems.
• Ensured data integrity and consistency on multiple platforms.

Environment: Linux, Java, Windows XP, C#, Oracle database, FIX 4.4, Mercury Quality Center, VeriFIX

Confidential, Jersey City, NJ

Application and Production Support Analyst

Responsibilities:

• Worked as Level 2 application and production support for VALDI order management system for continued maintenance, performance tuning, data analysis with T-SQL and PL/SQL, troubleshooting and data recovery for production, UAT testing, QA and Development team.
• Maintained and enhanced Java application for P&L server for VALDI OMS system.
• Trained offshore team for DBA task, FIX online interface supporting and back end system operation.
• Successfully managed domestic and offshore teams to realize the transition from regular market hour to 24/6 support for international trading system.
• Coordinated with Client Service team with Remedy tool serve the need from client and to develop Ad-Hoc reports with SQL for client's special need.
• Built billing information database and support billing information collection and analysis for management and accounting.
• Designed and implemented batch component for VALDI NGO system with Shell Script, PERL and SQL.
• Created global batch management tools and checking system which reduced the need for operational resource.
• Designed data backup and recovery system for different levels and created data rollback procedure.
• Designed and implemented database monitoring and automated maintenance system.
• Developed automated daylight time switch in database level for the need of international trading system.
• Developed automated trading calendar information loading program that provided trade-day, settlement-day and local holiday info of global more than 180 exchanges for the need of international trading complexes.
• Created reference data loading system with Shell Script that import data of symbol, Cusip, ISIN and Sedol from vendor, update system's security master and realized dynamic update to back end servers.
• Created dividend corporate-action data loading batch with Python that loaded vendor's source data to production system and update GTC orders in OMS system.
• Created end-of-day market data loading system that parse closing price info and market maker info from central price feed and load data to each OMS complex.
• Created automated system of global data consistency checking and maintenance.

Environment: Unix, Windows, C/C++, Java, Sybase database, Oracle, SQL, SQR, Unix Shell, Perl, Python, PowerShell, FIX

Confidential, Weehawken, NJ

Senior Program Analyst

Responsibilities:

• Enhanced Confidential online interface program for sending ACT reports to Confidential .
• Provided continued support on ACT message analysis, re-transmission, connection recovery and generation discrepancy reports for customer.
• Developed real time interfaces with FIX protocol for execution drop copy from Confidential (Instinet, ARCA, Bloomberg and BRUT).
• Developed real time order flow interfaces for dealers routing orders to/from order manage system.
• Developed hourly intra-day execution report and sent to clearing offices (Merrill Lynch, ADP and Pershing).
• Created end-of-day S-track files for dealers to report executions to clearing offices (ADP, Pershing, Merrill Lynch, Spear Leeds, Bear Stearn and Paine-Webber) and supported to create as-of file for customers.
• Improved database usage by applying performance and tuning techniques.

Environment: C, C++, Unix, Shell Script, Sybase database, T-SQL, SQR, FIX