Jessica Claire
Montgomery Street, San Francisco, CA 94105 (555) 432-1000,
  • Extensive working experience in software design, development, testing, implementation and production/application support in financial industry.
  • Advanced knowledge of database skilled in performance & tuning, data analysis and management.
  • Experienced team leader to resolve critical production issue in timely manner and provide permanent soClairetion to make production system reliable.
  • Database performance & tuning
  • Troubleshooting and debugging
  • Root cause analysis
  • Java/C/C++
  • Shell scripting, Perl, Python, PowerShell
  • UNIX/Linux/Windows
  • Sybase, Oracle, DB2, SQL Server
  • Batch Development: Designed and implemented batch for 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 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, trading calendar, etc. 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 faiClairere or DR situation.
  • Created fail-over procedures for operation team and support teams.
2015 to 02/2016 Production Support Analyst Apex Systems | Bedminster, NJ,
Technology: Syabes, DB2, Linux, Windows, Slang, KSH, Perl, PowerShell, Java, XML, TSQL, PL/SQL, Autosys, Procmon, JIRA, Tomcat, Hadoop, MongoDB
  • Provided continued maintenance for GSAM QIS production system with tools Autosys, Procmon, JIRA etc. Improve and enhance supporting tool with Shell Script, Perl and Slang.
  • Diagnose and troubleshoot JAVA application, Tomcat and Apache server on Linux and applied soClairetions 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 TSQL and PL/SQL in database level for research teams.
  • Supported reference data loading from vendors to various internal application system. Ensure data integrity and consistency on multiple platforms.
05/2007 to 06/2014 Application & Production Support Department Of Veterans Affairs | Blue Ash, OH,
Technology: UNIX, Linux, Windows, Sybase ASE, Sybase IQ, Oracle, SQL Server, Java, C, C++, T-SQL, PL/SQL, SQR, Shell Script, Perl, Python, PowerShell, FIX, Remedy
  • Worked as level 2 application and production support for VALDI order management system for continued maintenance, performance tuning, data analysis with TSQL and PL/SQL, trouble shooting and data recovery for production, UAT testing, QA and development team.
  • Maintain and enhance JAVA application for P&L server for VALDI OMS system.
  • As a team lead training offshore team for DBA task, FIX on-line interface supporting and back-end system operation. Successfully managed domestic and offshore teams to realize the transition from regular market hour to 24x6 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, that 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, Sedol, etc. from vendor, update system's security master and realized dynamic update to back-end servers.
  • Created dividend corp-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.
05/2000 to 05/2007 Senior Program Analyst SunGard ASC/Brass | City, STATE, Technology: Sybase, Unix, Shell Script, Perl, C, C++, T-SQL, SQR
  • Enhanced CTCI on line interface program for sending ACT reports to NASD. Provide 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 ECN (Instinet, ARCA, Bloomberg, 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, Pershing).
  • Created end-of-day S-track files for dealers to report executions to clearing offices (ADP, Pershing, Merrill Lynch, Spear Leeds, Bear Stearn, Paine-Webber), and supported to create as-of file for customers.
  • Improved database usage by applying performance & tuning techniques.
Expected in Ph.D. | Applied Mathematics Penn State University, State College, PA GPA:
Expected in M.S. | Computational Mathematics Peking University, Beijing, GPA:
Expected in B.S. | Mathematics Peking University, Beijing, GPA:

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy


Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score
could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:


resume Strength

  • Length
  • Personalization
  • Target Job

Resume Overview

School Attended

  • Penn State University
  • Peking University
  • Peking University

Job Titles Held:

  • Production Support Analyst
  • Application & Production Support
  • Senior Program Analyst


  • Ph.D.
  • M.S.
  • B.S.

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in: