Oleg Samuylin

**** ***** *******, ***. **, Brooklyn NY 11235

email: ac4id1@r.postjobfree.com phone: 646-***-****

EXPERIENCE AND SKILLS SUMMARY:

Profile:

• SYBASE application developer with 17+ years of experience in analysis, design and development as well as production support of various software products, specializing in market data processing – End of Day Pricing and Fundamentals:

• Stored Procedures, Triggers, Ad-hoc Queries

• Fundamental Data (Shares Outstanding, Market Cap, Indicators based on pricing and fundamental values, etc.)

• Many Instrument Types - Equity, Options, Futures, Fixed Income (Mutual Funds, Bonds, Collateral)

• Thomson Financial History and Fundamentals System

• Moody’s Credit Rating System

• Goldman Sachs Feeds

• Experience with Credit Suisse credit risk applications

• T. Rowe Price, TradeWeb and Piper Jaffray Online Trading Systems

• Mortgage, triparty and finance trading

• Experienced in:

• Developing of back-office applications for investment banking and brokerage on-line trading systems and applications support

• Developing, unit-testing of enterprise-scale distributed system

• Production support of SYBASE, Shell, Perl and Windows applications

• Production support of JP Morgan Chase Enterprise System - Private Banking, Public Wealth Management, Client Central, Mosaic middleware, APPWAY administration console and Client On-boarding

• Developing, and supporting UNIX/Linux Korn shell scripting

• Direct Interaction with Brokers and Traders

• Working knowledge with:

• Perl Scripting applications

• Creation of Excel reports for the clients using Perl Modules

Areas of expertise:

• Full Life Cycle of Application Development (Requirements Review, Research and Analysis, Software Design, Development, Implementation, Unit and Inter-System Testing, and Technical Documentation Writing, User Training, Deployment)

• All aspects of SYBASE-based Development, extensive usage of C, UNIX/Linux Korn Shell and Perl scripts

• Monitoring, 24x7 production support, Troubleshooting and Problems Solving

Languages: SQL (Oracle Pro*C, PL*SQL, Transact SQL), Unix/Linux Shell Scripting (C shell, ksh), C, Perl, Java, awk, XML, HTML, some Windows batch scripts

Platforms: Solaris, Linux, and Windows 2000/NT, Windows 7

Database and related libraries and tools: Aqua Data Studio 7.0.39, Embarcadero Rapid SQL 7.6.1, Oracle 10i, SYBASE ASE 12.5, 15.7, UNIFY Dataserver / ELS, MS SQL Server, JDBC, MS Access, Erwin, TOAD, Oracle SQL Developer, SYBASE SQL-Advantage, ASE isql, MS Visio, FileZilla, ASA 9.1 server, Autosys, SYBASE Central, MongoDB (finished class), Splunk, SQL Browser, HP Management System

Frameworks and Libraries: Sockets, J2EE, Xerces, AWT, Applets, LU6.2, and MQ Series, Lotus Notes, Websphere MQ

PROFESSIONAL EXPERIENCE

11/14/2016 - 01/31/2018 Deutsche Bank Jersey city

UNIX/Linux shell,SYBASE, and Perl developer, Application support

• Create new MBSE trade mortgage design, using Korn shell scripts sftp daily, weekly, and monthly file to IBM Ondemand server

• Large-scale SYBASE to Oracle Migration: converted SYBASE stored procedures, with SYBASE code to Oracle and support them on production systems. Utilized sqlldr to load data into database tables in required format.

• Production applications support of mortgage trading applications, triparty, finance trade level 3

• Migration from AIX UNIX to Linux OS, converting shell script to Perl CGI for Apache server, Korn shell to bash scripts

• OCI C program description and support migrating them to JAVA (there are mortgage and all other trades)

• Non-production test support for TOMS decommissioning system, ATS and TOB indicators for FINRA development and testing support, triprty test support

• Migration C programs for all kind of trades from UNIX solaris to AIX server, compilation and testing

5/23/16 - 7/24/16 Mutual of America New York NY

Perl applications developer

• Develop Perl packages and scripts to access the databases MS SQL 2008 server, create PDF files and excel reports for clients

• Troubleshooting existing Perl programs, create documentation

11/15 – 12/15 JP Morgan Chase, Consulting New York, NY

Production application support

• 24x7 Production Support of Enterprise System resolving issues with all parts of the system helping users, bankers, and account owners to identify and fix the problems using UNIX scripting, SYBASE, ad-hoc queries, APPWAY admin console, Splunk, other JP Morgan Chase tools.

• Solve for the user, bankers, clients, the problems with Client on Boarding, client create, account opening, CRM, KYC and many others.

• Explain the user, bankers, clients, the problems and the rules, under which the problems can be solves

• Work closely to development team to help them identify problems and make necessary changes in software applications. Client on Boarding, account opening, CRM, KYC and many others. Open/close tickets using JIRA ticketing system

• Support UAT and production, making regression and sanitation tests during and after deployment, testing programs, UNIX/Linux shell scripting on UAT environment, make changes,when needed.

• Successfully completed project of UNIX to Linux migration, testing and fixing some Korn Shell scripts, configuring Linux environment and setting up Linux environment variables, changing Oracle and SYBASE queries using sqlplus connection, isql

01/15 – 06/15 Credit Suisse, Consulting New York, NY

UNIX/Linux shell, SYBASE and Perl developer, Application support

• Employee data maintenance: loading large scale data into several tables using UNIX Korn shell and Perl scripts, supporting various groups of employees

• 24/7 Production Support of Spider Credit Suisse Web Applications for Equities, Fixed Income, Foreign Exchange, Pirate Banking Web on UNIX/Linux. Solving problems with the clients, who are supposed to belong to different level groups, but cannot be found in one or more of them.

• Developed, and supported SYBASE stored procedures to create reports for clients in converting in excel format using special Credit Suisse utilities, UNIX/Linux Shell and Perl scripts to load Data Feeds for clients

• Credit Suisse Spider system support - powerful information ports that combine with internal client information: create new and fix existing SYBASE stored procedures, queries, monitoring stock prices and major indices

• Production support of Spider Credit Suisse product on UNIX/Linux, fix SYBASE stored procedures with necessary reports for client

• Production support credit risk applications, stored procedures, UNIX shell scripts

06/14 – 01/15 Pearson Publishing, Consulting Old Tappan, NJ

UNIX/Linux shell, SYBASE and Perl developer, Application support

• Production support of Sales and Marketing applications for Pearson Education sales and product management system, “Sales Force” CRM tools. Work with users’ remote system, help to extract and synchronize remote system with individual laptops, check extraction process, correctness of it for various markets

• Create the sampling and BUI courses reports (short description of books for schools professors) for Pearson Socrates system for representatives, using shell scripting

• Investigate various issues and fix existing problems using batch, shell, Perl script and SYBASE stored procedure.

• Production support of Pearson online program management, tailored Services, Digital resource using Perl scripts and SYBASE, Oracle databases, developing and supporting SYBASE and Oracle stored procedures

• Create new projects in Perl, UNIX/Linux shell, Windows batch scripting to make automated cover-images files process for eCatalog Socrates Pearson system, for sales representatives and college professors.

• Administrative support of remote Pearson SYBASE ASA 9.1 server, UNIX/Linux application support

08/13 – 06/14 Goldman Sachs, Consulting Jersey city, NJ

SYBASE, UNIX/Linux shell and Perl developer, Application support

• Reconciliation process: create Perl reconciliation script to compare data on primary and snapshot databases and other scripts to re-load the correct data.

• Work on new project End of Day checker with the purpose to check the processing steps on incoming feeds and fire appropriate events. Project includes Java and SYBASE stored procedures

• End of Day Job: create Perl script with SYBASE statements to publish the result of core processes by the end of the day.

• Autosys support: create scripts to add/delete jobs to/from Autosys using JIL processor

• Goldman Sachs data feeds: create the system to extract, transform and load market data, check correctness of data loading, use UNIX Korn shell and Perl, Oracle stored procedures.

• Create UNIX shell batch process to load huge GS feeds to the database overnight

• Obtain working knowledge with JIRA ticketing system: update ticket, explain problems and the ways it was fixed

• Provide incident management, detecting and resolving incidents; perform root cause analysis to prevent similar incidents

• Support large scale Linux environment with SYBASE stored procedures on 24 production servers

06/11 – 04/13 Moody’s, Consulting New York, NY

Senior SYBASE Database developer

• Coordinate work of development team with Moody’s managers and SME, project and production management, Global management office, acceptance testing and sign off teams. Define project scopes and ensure timely closure on all phases of them. Provide production support for all systems and processes

• Develop 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

• Upload large scale of data to new database, compare against legacy database system, fix existing difference

• Lead the project of SYBASE stored procedures, triggers, views migration from SYBASE 12.5 to SYBASE 15.7 and production applications support

• Create and develop data changes reports using Perl; create weekly correction report and Disclosure Form Correction Report according the request of Dodd-Frank law. Perl script connects to SYBASE database, selects necessary data and loads it to Excel sheet for clients. Email the Excel sheet to customers and analytical team

• Develop multiple SYBASE stored procedures to calculate Fixed income maturity, return of principal at maturity, total return, redemption, managing risk and diversification. Manage and support UNIX/Linux existing application

12/04 – 06/11 Thomson Reuters / Thomson Financial New York, NY

UNIX/Linux shell, SYBASE and Oracle developer, Application support

• Large-scale SYBASE to Oracle Migration: converted multiple SYBASE stored procedures, shell scripts and executables with SYBASE code to Oracle and support them on production systems. 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 stored procedures

• Pricing Data Maintenance: Developed and implemented Short Interest Data integration into ThomsonOne including regular processing of exchange-provided data files, adjustment for corporate actions, storing in History Databases and making historical content available for demonstration in ThomsonOne Charting and Thomson Data Feeds. The system developed using Transact-SQL, UNIX/LINUX Korn shell scripts, SYBASE 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 UNIX Korn shell, Transact-SQL, and SYBASE stored procedures

• Experience with development of Fixed Income (Mutual Funds, Bonds, Collateral), creation the price file, load data to the database and send flat file report to the front end to display it in ThomsonOne platform

• 6+ years experience with development of SYBASE and Oracle stored procedures, triggers, performance tuning and optimization, query plans analysis, database modeling

• 6+ years experience with 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 to display in ThomsonOne using ad-hoc queries and stored procedures, C, 24x7 UNIX/LINUX, SYBASE, Oracle production application support

02/00 – 12/04 digiTRADE New York, NY

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 that was done over TCP socket

• Responsible for development of 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 that 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 back office using LU6.2 mechanism. The system was redesigned to utilize MQ Series files transportation system along with Oracle DB and Oracle Pro*C.

• Developed and maintained the system to provide aftermarket hours and overnight account information that allows client to trade equity and options on-line during market 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 Unify DB, updating account information for each customer, customer position, and summary result of previous day trading. Redesigned the system to Pro*C PL/SQL blocks. Working on UNIX/Linux application support

EDUCATION

1997-2000 Brooklyn College (CUNY), Brooklyn

Contact this candidate