Developer Manager
Resume:
Oleg Boksner
**** ***** ****** ******* *** #*A
Bronx, NY 10463
EMAIL: ********@*****.***
TECHNICAL SKILLS
Programming Languages: C#, VB.NET, ASP.NET,
Databases: MS SQL Server, Sybase Adaptive Server 15
Data Base Languages and Tools: T-SQL, SSIS, SSRS, RSL
Data Warehouse Integration: IVP Polaris, IVP SecMaster
Reporting: Tableau, SSRS
Source Safe Systems and Bug Tracker: TFS, Visual Source Safe, CVS, JIRA
Windows: Excel VBA, Word VBA, PowerShell
API Integration: Eze OMS, Bloomberg DLWS, S&P CapiIQ
GDAX Rest API, GDAX TCPIP Streaming
Hedge Fund Accounting: Advent Geneva
Private Equity Accounting: SunGard Investran 5.3
Project Management: Microsoft Project
Jana Partners LLC
Advent Geneva Specialist / Senior Application Software Developer (Feb2013 – April 2019)
Investment Peer Review Market Analysis
C# Winforms application / SQL server 2014/ Telerik
Utilize Api Web service calls to S&(CapIQ) gathering market specific data points and then applying the dataset /xml to DB / Winforms for further analysis on returns, composite rankings within investment peer group and total composite across time frames.
Geneva ETL application
WinForms C# /TLSQ DB application to facilitate and keep track of backup office processes and operations,
Integration with Eze OMS api via for verification of trade processing via blotter review as well as secmaster downstream flow testing.
Enabling multiple ETL processes via XML Geneva WFM loader and customized SQL database stored procedures that generate xml, including bulk transaction strategy updates, transfer updates. transaction and price updates, tax lot specification GUI for head of accounting. UNIX maintenance monitor, file manager and file task scheduler, reconciliation reviewer as well as a visual process tracking dashboard.
R/D Crypto Pricing Tool & order entry.
Created win forms app to connect to GDAX (Coinbase Pro) via JSON API, as well as TCPIP direct streaming.
Geneva To SSNC Onboarding
Engaged accounting/operations staff including CFO, fund controller as well as SSNC managing directors.
Created C# exe to download and PGP decrypt and encrypt file transfers between JANA and SSNC
Report Viewer
PDF and Excel preview application for files dropped in folders
C# win forms using Telerik tools, simple file watcher application displays PDF and Excel reports.
Enso Stock Margin ETL and processing of data into IVP Data warehouse .
C# win forms application manages data flow relating to short selling borrow cost into data warehouse
IVP Secmaster and Data warehouse implementation
Successfully implemented data warehouse and secmaster project sourcing Geneva, BBG DLWS and EZE Oms
Reporting in SSRS and Tableau, Geneva RSL extracts and reports consumed by Data warehouse
Created variety of reports for daily consumption by partners in both SSRS and tableau sourcing IVP data warehouse and semester,
Positions Rec Between Risk Application and Geneva
Automated rec process using sql server utilized SSIS for data load to sql server, unix shell scripting, Unix crontab scheduling
Completed and supervised upgrade migration from Geneva 8.5 to Geneva 15.2
Implemented QA Environment 8.5 core and application server
Setup, configured full qa environment for UNIX and application
HBMJ Consulting (April 2012 – Jan 2013)
Senior Geneva Programmer Consultant
Project Manager / Lead Developer Dashboard Run and Deliver Application
Lead a small team of developer’s one junior and one rsl/sql
Custom Win forms / Windows Service c# application to compliment the Advent Geneva portfolio accounting software,
Extracting custom RSL extracts, encrypting the extract, and then delivering it via ftp/ sftp
Created / Tested and Designed Loading 7.6 Geneva Aga via Xml / Sql Server including specific mapping requirements
ETL Into Geneva version 8 Aga (at fund admin) database along with change of xml format from earlier to later loader version. Created extract rsl for open tax lots, along with other minor changes to transmaker.rsl in order to load open tax lots by asset type in to intermediate data warehouse sql server database for mapping to be applied and then loaded in xml format to Bank Of New York.
Blackstone Capital Management
C# Developer / SQL / SunGard Investran Dev. (Princeton Grp Consulting Contract Position July 2011 - April 2012 )
Configured and setup deployment / scheduling of Investran reporting packages
Developed several C# utilities to complement reports streamlining to BXACCESS intranet CMS system
C# file monitor utility, prototype for static data updates to Investran sql server database
Integrated with Active Batch V8 software to monitor folders.
Enhanced validation process for end of quarter transaction upload data using stored procedures.
Fidelity Investments
C# / Advent Geneva ( Consulting Contract Position) (June 2010 – March 2011)
SSIS / Geneva Extract
Extracting open and closed tax Lots from Geneva using SSIS / Geneva Data Flow for Wash Sale records
Reduced error occurrence due to large rsl extract by breaking down the query flow into portfolio / investment Identifiers.
BizTalk /C# / Interactive Data creation of Geneva Objects
Improved and enhanced BizTalk orchestration data import with customized
Excel Reconciliation Utility
GUI Win forms C# tool, for running various transaction file comparisons
Xml Import Batch Utility
C# Batch tool for command line use in automating, import of various Geneva transaction xml files for data massaging
Then bulk import into SQL server database with sqlbulkcopy.
Created Unix script to monitor and restart db_server for loading data into Geneva
Barclays Capital
Advent Geneva Team (Consulting Contract Position) (Dec 2009-June 2010)
Enhanced legacy JAVA code market data feed into Geneva loader. Support of Advent Geneva standard report output and custom reporting solutions, as well system maintenance, including various data feeds via Autosys scheduler.. Also support the underlying database processes surrounding a custom reconciliation system.
NoProblemDivorce.Com / Document Preparation Website
Owner/Developer/ Entrepreneurial Project (March 2009 – Dec 2009)
Developed and created online document preparation service for New York uncontested divorce, using Aspose Components, asp.net
Och-Ziff Capital Management Group (Jan 07 – Dec 2008)
Geneva Financial Reporting Developer
(24 Systems Consulting) from Jan 07- May 07
(Full Time Employee May 07 – Dec 2008)
FCIS Project Portfolio Accounting System
Supported and enhanced reporting aspects of the in house portfolio accounting reporting system.
C# /VB.NET /Crystal Reports, and customized/manipulated data with two back end SQL Servers
(T-SQL) and Advent Geneva DB (RSL).. Developed multi-threaded optimized reports for the Advent Geneva portfolio accounting
Trilogy Global Advisors (June 2006 – Jan 07)
Application Developer ( Consulting Contract Position, M-Logic)
Trade System Applications
C# /VB6 application to support/enhance the back-end accounting application
Created and modified key database stored procedures, triggers and custom SQL functions.
UBS Financial (Full Time Employee)
Senior Application Developer (Dec 2003 – June 2006)
CDO /MAPI Exchange Utility
Developed utility for quickly retrieving and manipulating various Exchange store data.
Kofax Ascent Capture
VB.NET/ Kofax Imaging Scripting Development
Relationship Manager Exchange Log Monitor Utility
Monitored Utility to keep track of public folders and in boxes as well maintain and update custom log.
Custom Outlook forms and templates
Customized internal outlook forms and templates to meet user requirements within the RM application
VERIZON (Jailor Consulting)
Senior Application Consultant (Jan 2003 - July 2003)
Matrix Pricing Intranet System
Developed user friendly system to create browse and quote features for sales force use, and automated pricing deployment.
High Speed Private Corporate Account Pricing Systems
Implemented intranet-based ASP/SQL pricing automation system based on existing Excel/VBA templates.
CIBC World Markets (Concepts In Staffing Consultant) April 2002 - Nov 2002
Senior Consultant/Programmer Analyst
Crystal Reports for Imperial Hedging Facilities
Developed stored procedures relating to the Imperial Account defining amounts allocated for hedging in US and Canadian Funds in relation to authorized loan amounts.
C.A.T.S SYSTEM (Credit Application Tracking System)
Enhanced intranet commercial credit and loans application with various new requirements and additional Crystal reports.
Email Client App (Using CDO/MAPI Object Model)
Nightly exe setup to access Exchange folder emails and convert and save as Word documents
LEHMAN BROTHERS (Employee) (Feb 2001- Feb 2002)
Programmer Analyst
Government Analysis Reporting System, Equity Country Manager Reporting System
Crystal Enterprise 8.5, integrated components object model DLLs with Crystal Reports and CSP/ASP pages.
Developed complex dynamic stored procedures; data mining through historical databases (Sybase /UNIX)
Trade Query
Created Broker/Trader intranet query and report tool for equity databases (Sybase/Unix)
ZAGAT SURVEY (Employee) (April 2000-Feb 2001)
Software Engineer
Internal IIS Web Parser and Report System
Created client/server utility tool to parse large text web log files using VB6 and Regular expressions.
Developed com objects to be integrated into new site revision maximizing XML/XSL technologies for the Zagat Survey Site Version 1.5
A.I.G. GLOBAL INVESTMENT GROUP (Dec 1998-April 2000)
Programmer Analyst (Full Time Employee)
Consolidated Securities System
Developed a Sybase Database and VB Client server front-end with Crystal Reports as final product
PIMS Portfolio Investment Management System
Developed a portfolio tracking and management software for the global hedge fund team.
Citicorp Investment Services (Nov 1997 – Dec 1998)
Citicorp Investment Services Investment Specialist Registered Representative
Provided direct customer guidance with bank to brokerage transactions, including equities, options and fixed income transactions.
TD WATERHOUSE SECURITIES INC (Jan 1996 - Jul 1997)
Stockbroker/Investment Specialist Registered Representative (Night Shift Desk)
Completed series 7 and 63 license requirements. Provided courteous and accurate trade placement.
EDUCATION/TRAINING
Udemy Online: Learning Python for Data Analysis (Currently Enrolled)
New York University (School of Professional Studies)
Swift Intensive App Development (July 2017)
C#(July 2010)
Derivatives and Beyond Course(July 2005)
Long Island University (Jan 1992 - Dec 1992)
Computer Science
Sybase, NY
Fast Track to Advanced Server Enterprise 11.9.2
Professional Licenses
Series 7 NASD General Securities (exp),
Series 63 Blue Sky Securities
http://www.instadocx.com/
Contact this candidate