Oleg Boksner

**** ***** ****** ******* *** #*A

Bronx, NY 10463

EMAIL: ac86t3@r.postjobfree.com

917-***-****

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