SUMMARY:

• SYBASE Database application developer with 15+ years of experience in analysis, design and development of various software, specialising 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
• Experience in production support SYBASE, shell, Perl, windows applications
• Experience in development SYBASE stored procedures,ad-hoc queries
• 15+ experience to create UNIX/Linux Korn shell scripting
• Working knowledge with Perl scripting, creating Excel reports for the clients using Perl scripts
• Experience with SYBASE client utilities like BCP,Defncopy and others
• Full life cycle of application development (requirements review, research and analysis, SYBASE database and software design, development, implementation, unit and inter-system testing, technical documentation writing, user, deployment)
• Different kine of applications using UNIX/Linux Korn shell, Perl scripts
• Monitoring, 24x7 production support
• Troubleshooting and problems solving

TECHNICAL SKILLS:

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

Platforms: Solaris, Linux, and Windows 2000/NT, Winodows 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, UNIFY Dataserver/ELS, MS SQL Server, JDBC, MS Access, Erwin, TOAD, Oracle SQLDeveloper, SYBASE SQL-Advantage,ASE isql, MS Visio, FileZilla, ASA 9.1 server, Autosys, SYBASE Central, MongoDB (finished class)

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

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

UNIX/Linux shell, perl developer, Application support

Responsibilities:

• Employee data maintenance: Load large scale data into several tables using UNIX Korn shell script and perl script.
• Maintenance OS Spider system support - powerful information ports that combine with internal client information: create new and fix existing SYBASE stored procedures, monitoring stock prices and major indices
• Production support of Spider Credit Suisse product on UNIX/Linux, develop SYBASE stored procedures with necessary reports for client
• Data feeds: Developing UNIX/Linux shell, Perl scripts to load clients data Feeds Troubleshooting: isolating problems recommending and implementing correct solution of the problems

Confidential, Old Tappen, NJ

SYBASE shell, perl developer, application support

Responsibilities:

• Production support of Sales and Marketing applications for Pearson sales and product management system, Sales Force CRM tools. Work with users remote system, help to extract and synchronise remote system with individual laptops, check extraction process, correctness of it for different markets
• Create the sampling and BUI courses reports for Pearson Socrates system for representatives, using shell scripting
• Working to clean Windows servers directories, deleting old files to make sure, there are enough places to process jobs.
• Investigate different issues and fix existing problems using batch, shell, Perl script and SYBASE stored procedure.
• Support product system using Perl scripts and SYBASE, Oracle database, developing SYBASE, Oracle stored procedures
• Create new projects in Perl, UNIX/Linux shell, batch scripting to make automated coverimages files process for eCatalog Socrates Pearson system, for sales representatives and college professors.
• Administrating support of remote Pearson SYBASE ASA 9.1 server, UNIX/Linux application support
• Using SYBASE tools like BCP, Defncopy and others

Confidential, Sachs Jersey city, NJ

SYBASE shell, perl developer, Application support

Responsibilities:

• Reconciliation process: Working for Goldman Sachs project to create Perl reconciliation script to compare data on primary and snapshot databases and scripts to re - load correct data.
• Working on new project End of Day checker with 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 result of core processes by the end of the day.
• Autosys support: Create scripts to add/delete jobs to/from Autiosys using JIL processor
• Goldman Sachs data feeds: Create the system, to extract, transform and load market data, check correctness of loading data, UNIX Korn shell and Perl,Oracle stored procedures.
• Working knowledge with Jira ticketing system: update ticket, explain problems and ways it was fixed
• Provide incident management, detecting and resolving incidents, perform root cause analysis to prevent similar incidents.
• Support large scale Linux environment on 24 production servers
• Experience with SYBASE utilities like BCP, DEFNCOPY and others

Confidential, New York, NY

SYBASE Database developer

Responsibilities:

• 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 project scopes and ensure timely closure on all phases of them. Provide production support for all systems and processes
• 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.
• Uploading large scale of data to new database, compare against legacy database system, fix existing difference.
• Lead the project of SYBASE upgrade and stored procedures, triggers, views migration from SYBASE 12.5 to SYBASE 15.7
• Create and developer data changes reports using Perl: create weekly correction report and Disclosure Form Correction Report according request of Dodd-Frank law. The Perl script connects to the SYBASE database, select necessary data and load it to Excel sheet for clients. Email the Excel sheet to customers and analytical team.
• Developing multiple SYBASE stored procedures to calculate Fixed income maturity, return of principal at maturity, total return, redemption, managing risk and diversification. Managing and supporting UNIX/Linux existing application.
• Experience with SYBASE utilities like BCP, DEFNCOPY and others

Confidential, New York, NY

SYBASE Database application developer

Responsibilities:

• : 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 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, 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), creating the price file, load data to the database and send flat file report to the front end developer to display it in ThomsonOne platform.
• 6+ experiences with development SYBASE,Oracle stored procedures, triggers, performing, tuning and optimisation, query plans, database modelling.
• 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 using ad hoc and SYBASE stored procedures c, 24/7 UNIX/LINUX, SYBASE,Oracle production application support

Confidential, New York, NY

Database application developer

Responsibilities:

• 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. Working on UNIX/Linux application support