Master certificate in C# by brainbench.com
http://www.brainbench.com/transcript.jsp?pid=1884076
Web/Windows/Wpf multi-tier,
multi-threading applications developer.
Address:
E-mail: anatolijob@optonline.net
Summary:
◊
Over a 12 years of Internet and 18+ Intranet projects development,
with the during last 12 years focus on Financial/Fixed
Income Markets.
◊
Over a 15 years of database development.
◊
Over a 13 years of work experience in developing GUI for Windows Applications
and Windows Forms.
◊ Extensive using of RAD
(Rapid application development).
◊
Experience in developing web and windows enterprise applications
◊ Experience in redesigning old Legacy systems,
converting it to the new more reliable and robust solution.
◊
Experience with software lifecycle
(taking projects from initiation to product release
through design, implementation, and testing).
◊ Extensive experience working closely with both
business and technical teams.
◊ Strong commitment to delivering quality
applications within aggressive project timelines.
My experience is based on dozens of sites produced, quantity of dynamic pages
written,
developing 2 big and hundreds average size database
driven applications by myself,
and developing at least 2 large applications in
collaboration with other specialists.
Primary Technology:
DOTNET Framework (versions: 1.0, 1.1, 2, 3, and 3.5) Visual Studio (2002-2008)
with C#/VB.NET/SQLServer/XML/XAML/Wpf/Windows
forms/GUI multi-threading applications with multi-tier components. ASP.NET
applications, using on Server-side multi-threading with multi-tier components
and on Client-side coding with VBScript and Javascript
SKILLS: Windows, Windows forms, Visual Studio(any edition), C#, VB.NET,
WPF, XAML, WCF, .NET, LINQ, MS Access, Visual Basic, Crystal Reports, SQL
Server, Sybase, RDMS, OOP, OOD, VBA, Transact-SQL, XML, XSLT, DHTML,
XHTML, ASP, Web Methods, Web Services, JavaScript, VBScript, Excel, API,
HTML, ADO, ADOX, SOAP, OLE, COM, ODBC, DDE, RDO, DAO
Special Skills/Knowledge: Reuters Triarch
and TIB/RMDS, TCP/IP, Bloomberg Multi Product Feed, Windows Sockets, Thomson TradeWeb Dealer Pricing Feed, Bloomberg TSAPI, MarketAxess Messaging protocol
EXPERIENCE:
12/2008
– Present. (Freelance programmer)
◊
Designed and constructed several custom controls for Wpf
(Windows Presentation Foundation), including e-Mail client to send mails from xbap sites, popup calendar, date picker, etc. For this
project I was using Xaml with c# Visual Studio 2008
and .Net framework version 3.5.
Sample
site: http://soft-custom.com/WpfSolution/WpfSolution.xbap
Note:
to view this site you need .Net framework vr. 3.5
install.
◊
Designed constructed and implemented photo stock site for individual
photographers. Site allows for photographer to display and sell their work.
Technology
and tools used for this project was: ASP.Net, C#, JavaScript, Visual Studio
2008, .Net framework version 3.5.
Sample
of the site http://soft-custom.com/PhotoPortfolio/
◊
Designed DataEngine and Data Objects Generator Tool
for developers- is a powerful development application that auto-generates a
data layer object model based on your SQL database schema. The generated
run-time component exposes all tables, views and stored procedures as classes
and columns as properties.
With DataEngine No need to write any SQL, Simply set
the criteria on your data objects, and get the objects you want without having
to write any SQL queries or stored procedures. Make changes to the object, and
commit it all back to the database without any SQL.
Technology used for this project was: C#,
Visual Studio 2008 and DOT Net framework version 3.5.
1/2005
– 11/2008. EDS (on Client Side. ABN AMRO account)
(Employee. Senior
Developer, Programmer/Analyst. Market Data/Trading floor support)
◊
Troubleshooting and supporting existing VBA Excel-based trading applications
◊
Developing “Inventory tracking” system using MS Access.
◊
Troubleshooting and supporting existing MS Access applications
◊
Developed listener that runs as Windows service. That listener reads requested
real time data from Reuters TIB/RMDS and sends it to different specified
destination, using sockets/ftp/sftp.
◊
Created mechanism for publishing real-time data directly to the Bloomberg from
Excel spreadsheet through “Bloomberg Multi Product Feed”, using “Windows
Sockets API” and C#.
◊ Created API and Publisher/Listener for
publishing real-time corporate data, directly to the MarketAxess
through “MarketAxess Messaging protocol”, using
“Windows Sockets API” and C#.
◊
Created API and Publisher/Listener for publishing real-time USD (DSWP) Interest
Rate Swaps data directly to the Thomson TradeWeb
through “Thomson TradeWeb Dealer Pricing Feed”, using
“Windows Sockets API” and C#.
◊ Created API and Publisher/Listener for
publishing real-time US Credit Default Swaps (UCDS) data directly to the
Thomson TradeWeb through “Thomson TradeWeb
Dealer Pricing Feed”, using “Windows Sockets API” and C#.
◊ Created API for publishing real-time data
directly to the Bloomberg through “Bloomberg Multi Product Feed”, using
“Windows Sockets API” and C#.
◊
Created Api using tcpip
programming model, Visual Studio 2005, “Windows Sockets API” and C# for real
time Bloomberg Price engine feed.
◊
Designed and developed various tools for IT support as Windows Applications
using Windows Forms and c#.
Tools
include ability from user desktop be able manipulate (update) data files
remotely on the specified server.
◊
Designed and created a fixed income securities SQL database, using vendor and
internal data, which was used as the data source for various thin and fat
client systems on a fixed income trading desk.
◊
Developed a pricing engine that combines static data
via the Bloomberg TSAPI and dynamic parameters via trader input and calculates
core analytics such as yield to maturity YTM, CF, YTW.
◊
Constructed a series of multi-tier applications using
SQL Server, C sharp, HTML, XML and ASP.NET from existing Excel-based models
which significantly reduced the amount of risk associated with fat-client
solutions.
◊
Created middle tier, which retrieves requested data from Bloomberg for selected
cusip or isin number using
Bloomberg DDE server and “Open Bloomberg API” and stores data into Sql Server Database.
◊
Created Thin-Client CDX Position System for trading desk, which creates and
stores front-end relative pricing for High-Volume and Institutional-Grade
Credit Default Swaps Indices, using Visual Studio 2003, HTML, XML, JavaScript
and C# with ASP.NET.
◊
Created Thin-Client CDX Contribution System which enables front-end traders to
archive and contribute to Bloomberg and Reuters, High-Volume and
Institutional-Grade Credit Default Swaps indices and Sectors. System was
created using Reuters SSL Library in reference with middle tier also using Visual
Studio 2003, HTML, XML, JavaScript and C# with ASP.NET.
1/2004 – 1/2005 Fidelity Information Services.
(Employee. Developer/Programmer/Analyst. )
◊ Developed Objects Generator Tool - is a powerful development
application that auto-generates a data layer object model based on your SQL
database schema. The generated run-time component exposes all tables, views and
stored procedures as classes and columns as properties.
With DataObjects Tool No need to write any SQL,
Simply set the criteria on your data objects, and get the objects you want
without having to write any SQL queries or stored procedures. Make changes to
the object, and commit it all back to the database without any SQL.
◊ Worked on web FIMIS application.
Using technology such: Visual Studio 2003 with VB.Net, C#,
HTML, ASP.NET, Sql Server, dot net framework.
Responsible for: development, programming, analysis, testing, creating reports,
hands on code and all internet related development, creating stored procedures,
views and queries.
FIMIS is application that provides management, regulatory, and risk reports for
High Grade Credit (High Grade and Short Term Fixed Income), High Grade Rates
(Global Funding, Treasury and Agency), Mortgages
(Asset Backed and Mortgage Backed) High Yield/Distressed (Bonds and Loans).
Reports are provided for BAS, BASL and BA Asia. FIMIS also provides sales and
trading reports for Municipals and sales reports for CIS.
There are currently more than 175 canned reports being produced serving more
than 300 salespeople and traders worldwide.
◊ Created web forms, reusable custom and users controls for existing web
interactive .Net asp application, using C# and VB code concentrating on object
oriented programming.
Controls were created such: CalendarBox, Searchable
dropdown box, Double list box, filter for email, internal email, Combo with
list box, etc.
◊ Created dozens stored
procedures on Sql Server, that returns data from
database into reports that runs on internet application.
◊ Created stored procedures for different backup jobs, that generates and
saves script to create different Sql Server objects,
such: Views, Stored Procedures, Schema, etc. into the text file.
◊ Created hundreds of reports for internet
application using: Sql Server, vb,
c#, .NET and ActiveReports engine.
10/2002 - 1/2004 Customized Database Systems, Inc. 254
West 31 Street,
(Consultant, Programmer/Analyst. In-house Project)
◊ Worked on instance messaging system. System
allows users of desktop application instantly communicate with visitors of web
site.
◊ Designed and developed a messaging system that allow users of same web
site instantly communicate with each other. Technologies used for this project
are: Visual Studio 2003, ASP.Net, VB.Net, C#.Net, XML, JavaScript, DHTML, and
SQL Server 2000.
◊ Designed and developed instance messaging system “SyndChat”,
system allows worldwide users of same application instantly communicate with
each other and with other people who don’t have same application, but have
e-mail address. Technologies used for this project are: ASP.Net Web Service,
VB.Net, C#, XML, SQL Server 2000, and Windows Service.
◊
Rewriting hundreds of excel macros in to VBA functions for Excel.
Working
on VBA functions for Excel to do custom analysis of Bond Portfolios, including
functions that generate graphs from the data imported from backend database
into Excel spreadsheet.
12/2001 - 10/2002 Customized Database Systems, Inc. (Working on
client side for Bank Of America NY, NY)
(Consultant, Financial Programmer/Analyst)
◊ Substantially revised and converted existing multi-securities fixed
income MS Access Trading system (FIMIS) into thin client application. Using technologies: ASP.Net, VB.Net, DHTML, XML, XSLT, Javascript, Vbscript, ComponentOne Reporting, and SQL Server 2000. The
application is a Fixed Income reporting tool that imports trade information
from Bloomberg, as well as 5 other databases, for a wide range of security
types into a SQL Server 2000 database. The application calculates sales
credits, P&L, etc and then utilizes the SQL Server job scheduler to
auto-generate and e-mail daily reports to various departments in the bank. The
GUI interface allows manual entry of trade, security, portfolio, trader, and
salesperson information. The GUI also allows manual report generation and
exports data and reports to different file format such: .pdf,
.xls, .txt, .csv. Made extensive use of IE's client side scripting capabilities and
MSXML functionality to update data without reloading pages to create a highly
responsive "desktop app".
◊ Involved in redesign of existing SQL stored procedures. After redesign
completed, stored procedures increased in speed up to 80%.
1/1998 - 12/2001 JPMorgan 270 Park Avenue,
NY, NY
(Consultant, Financial Programmer/Analyst)
◊ Designed and developed Equity Index using Oracle Database as back-end
and Visual Basic as front-end.
◊ Designed and developed multi-currency JPMorgan
High Yield Index Database in Oracle for high Yield research department. Using
SQL Navigator as tool for PL/SQL, Visual Basic as front end, MS
Access as report tools and Oracle as back end. To complete this task, the
application maintains a historical data prices, Issue size, ratings, defaults,
etc., measures bond performance, included total return, interest return,
reinvestment return, spread to worst, different kind of yields etc., using
custom made analytical functions and measures groups performance, using
utilizing advanced analytic. This application produces thousands of research
reports as well as outputting selected data and reports to different file
format included XLS, RTF, PDF, TXT, etc. In addition application can measure
and analyze any given portfolio for any time period. Also Project involves
retrieval of static and trade data from an underlying database, populating a
spreadsheet and exposing the models to the data.
◊ Involved in project to help High Grade department design High Grade
Index Database.
◊ Designed and developed Market Risk Limits System - The market risk
limits system analyzes the company's high yield bond portfolio and identifies
potentially distressed issuers within the portfolio. The system will calculate
the spread-to-worst over appropriate treasuries for each bond in the system and
for each industry group. Distressed issuers will be identified as 50% over the
spread-to-worst of the industry group that any bond is within.
◊ Designed and developed Bond P&L System - The bond p&l system calculates total return of all bonds within
a portfolio. This p&l consists of principal,
interest and reinvestment returns. A front end allows the user to enter initial
positions (both long and short ). It also calculates
total return when the position is closed. For those bonds in the portfolio at
any point in time, the system will retrieve the market price from EJV data and
calculate the total return to date of those bonds.
◊ Substantially revised an existing (6 Gigabits)
MS Access database application for high-yield research department of Chase
Securities, Inc. This application produces all the supporting data for the
weekly and daily CSI High Yield Index, an essential source of analytical data for
the high-yield bond investor community. To complete this task, the application
maintains a price, amount outstanding, ratings etc. history of several thousand
corporate bonds, identifies the bonds to be included in the index, measures
bond performance utilizing advanced analytical functions as well as original
functions, calculates and produces thousands of research reports from Access.
◊ Used OLE automation between Access, Excel and MS
Word. Recreated 100's Excel macros as Visual Basic for
Applications functions.
◊ Fixed Income Analysis and Portfolio Management.
1/1997 - 1/1998 Customized Database Systems, Inc 400
(Consultant Programmer/Analyst. Working for Various clients on client side
including: Citicorp, CSFB)
◊ Created DLLs (in process-server) for SIA Standard Securities
Calculations Methods.
◊
Converted existing MS Access application to MS SQL, using MS SQL as back end
and Visual Basic as front end.
◊ Worked on Trade Adviser, an application that
calculates yield, yield to worst, spread, spread to worst, accrued interest,
different kinds of duration and other fixed income securities analyses for
different kinds of bonds.
◊ Worked on LoanTrak,
an application that calculates and makes different kinds of reports: for profit
and lost, outstanding, etc., keeps track of loan trading.
◊ Converted loan application from Access 2.0 to Access 97.
◊ Troubleshooting, updating and supporting different
kinds of customized database management systems.
◊ Created interface between Excel spreadsheet and Paradox table
10/1996 - 1/1997 Citicorp Securities, Inc. (Trading Floor) 399 Park
Avenue, NY, NY
(Financial Programmer/Analyst)
◊ Worked on and finally finished MS Access 2.0 database application for
commercial paper department of Citicorp Securities on trading floor. This
application calculates core analytic such as yield to maturity, spread, yield
to worst etc. and runs reports: current, daily, monthly outstanding, issuer
comparison, outstanding for selected date, maturing in selected date range,
transactions-last activity and for selected date range, issuer summary report,
split report etc.
◊ Responsible for development, support and troubleshooting.
8/1989 - 10/1996 Independent Consultant
(Consultant)
◊ Created customized Database Management Systems for small businesses. Used Access and SQL to create tables, forms and queries.
Generated reports about orders received and shipments made during specific
periods of time. Designed and developed user interface using Visual Basic as a front-end,
and MS Access as a back-end.
◊ Involved in the development of the store’s inventory control system
using Visual Basic and Access. Created queries and reports,
which calculated values, such as the total amount of unpaid invoices and the
average number of days between the invoice and payment dates.
Participated in all aspects of data processing; designed user interface for
input-output, searching and viewing data. Generated daily,
quarterly, semi-annual and annual reports.
◊ Designed and developed a Relational Database Management Systems using
Visual Basic and MS Access. The system maintains database files, sorting.
Searching, adding, deleting and retrieving data from other environments such as
dBase IV, Paradox, FoxPro, Excel, ASCII files into a tabular format.
◊ Responsible for hardware and software installation
and configuration, memory management, PC upgrades and troubleshooting, hands-on
training and supporting users.
ADDITIONAL INFORMATION
Microsoft Certified Professional in:
Visual Basic
MS Access
Windows/Dos