Thomson Reuters Work Values

Daily Duties at Thomson Reuters:

• September 2010 – March 2011: 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 with development Sybase stored procedures, triggers, performing, tuning and optimization, query plans, database modeling. • 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 • 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

What they like about Thomson Reuters:

Working in an organization that is technologically advanced, creative, and innovative is critical in your assessment of hiring companies. Less important to you are stability of the organization, the length of time an organization has been in business, and the business' plans for the future. You prefer a fast-moving company that will take risks to achieve its goals and objectives. The length of time the company has been in business is irrelevant. Maintaining status quo is unnecessary. You thrive on change, uncertainty and the upside of potential business risks, especially those associated with innovation. Stability for the long haul is not nearly as important as is working in an atmosphere that is charged with a sense of urgency and constant change.

Tags

Skills

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

These are some of the questions we asked our climbers about their experiences with Thomson Reuters: