Profile:

• Database application developer with 12 years of experience in analysis, design and development of various software, specializing in market data processing end of day pricing and fundamentals
• Experience in back-office applications for investment banking and brokerage on-line trading systems
• Experience developing enterprise-scale distributed system

Areas of expertise:

• Full life cycle of application development requirements review, research and analysis, database and software design, development, implementation, unit and inter-system testing, technical documentation writing, user training, deployment
• Monitoring, 24x7 production support
• Troubleshooting and problems solving
• Languages: SQL Oracle Pro C, PL SQL, Transact SQL , Unix Shell Scripting ksh, bash and borne , C, Perl, Java, awk, XML, HTML
• Platforms: Solaris, Linux, and Windows 2000/NT
• Database and related libraries and tools: Embarcadero Rapid SQL 7.6.1, Oracle 10i, Sybase ASE 12.5, 15, UNIFY Dataserver/ELS, MS SQL Server, JDBC, MS Access, Erwin, TOAD, Oracle SQLDeveloper, Sybase SQL-Advantage,MS Visio
• Frameworks and Libraries: Sockets, Posix Threads, J2EE, Swing, Xerces, AWT, Applets, LU6.2, and MQ Series, Lotus Notes

PROFESSIONAL EXPERIENCE

Confidential

Sybase Database developer

• Create and developer data changes reports using Perl
• Lead the project of SYBASE upgrade and stored procedures, triggers, views migration from Sybase 12.5 to Sybase 15.7
• Uploading large scale of data to new database, compare against legacy database system, fix existing difference.
• Developing Dodd Frank project, new Moody's credit rating system, Rating outlook and other indicators: multiple SYBASE stored procedures, triggers, ad-hoc queries, and UNIX shell scripts.
• Coordinate work of development team with Moody's managers and SME, project management and production management, Global management office, acceptance testing and sign off. Define projects scopes and ensure timely closure on all phases of them. Provide production support for all systems and processes

Confidential

Database application developer

• Large-scale Sybase to Oracle Migration: converted multiple SYBASE stored procedures, shell scripts and executables with SYBASE code to Oracle. Utilized sqlldr to load data into database tables in required format. Implemented multi-threaded Java loading programs to parse input XML files performing time-efficient parallel processing.
• Fundamental Data Maintenance: Loaded and/or calculated several types of Fundamental Data Shares Outstanding, Market Cap, various indicators based on pricing and fundamental values, etc. into Historical Databases, adjusted if needed for corporate actions, made them available for demonstration in ThomsonOne Charting and Quote applications. The system implemented using Java loading programs, shell scripts and Sybase SQL stored procedures.
• Pricing Data Maintenance: Developed and implemented Short Interest Data integration into ThomsonOne including regular processing of exchange-provided data files, adjusting for corporate actions, storing in History Databases and made the historical content available for demonstration in ThomsonOne Charting and Thomson Data Feeds. The system developed using Transact-SQL, shell scripts, Sybase SQL stored procedures.
• Continuous Futures Rollover Algorithms and Processing: Developed and maintained an automatic algorithm and processing to roll over continuous futures for ThomsonOne by requests of many clients like TradeWeb and Piper Jaffray that allows users not to change the future contract symbol every time the near active month expires but use continuous future symbols that are mapped to the right contract. The project was done using C, ksh, Transact-SQL, and Sybase stored procedures
• 6 experiences development shell scripts to load flat files data to Sybase database and unload database tables and views to the files in order to send them to front-end developers to display in ThomsonOne charting and Quote applications
• 6 experiences with development Sybase stored procedures, triggers, performing, tuning and optimization, query plans, database modeling.

Confidential

Database application developer

• Developed the database/backend portion of the T1link block trading system that allowed real-time order submission of one or many stock orders concurrently. Core of this system is to allow the broker the ability to trade stocks of one or several brokerage clients at the same time and to see the result of this trade on the website
• Developed systems to provide real-time updated brokerage account information such as client's account balances, portfolio holdings, trade statuses and historical information. This application consists of multithreaded server communications between a client and a server was done over TCP socket
• Was responsible for development the trading system portion of T.Rowe Price's online brokerage website. Developed broker management tools, various maintenance applications, backend processes for communications with back office using LU6.2 mechanism which I redesigned for MQ Series, using C and Unify database. The system was designed to receive order from brokerage client or a broker, parse it, update the database, create and send order to the back office using the LU6.2 mechanism. The system was redesigned to utilize MQ Series files transportation system along with Oracle database and Oracle Pro C.
• Developed and maintained the system to provide aftermarket hours and overnight account information, which allows client to trade equity and options on-line during hours, to see trade results next day after trading, and provides likely scenarios for the next session, including statistics, history, account information and reports for the customers. The systems were designed in C using a Unify database, updating account information for each customer, customer position, and summary result of previous day trading. Redesigned the system to Pro C PL/SQL blocks