Robert Berman

** ***** **.

Syosset, NY *****

516-***-**** (H)

516-***-**** (C)

aczhix@r.postjobfree.com

An experienced, hands on SQL developer, Geneva accounting platform expert, skilled in Unix and Windows environments. A senior developer/manager seeking a position as a team lead or hands on developer in a financial services environment. Experienced in trading system, securities operations working with business people from junior to senior management. Seeking a SQL Server intensive position.

Skills summary

Microsoft SQL stored procedures, triggers, functions, design, optimization

SQL Server, Oracle, Sybase – architected tables, indexes, performance tuning, DBA skills as well

Extensive Securities trading and operations support. Understanding of financial markets and securities.

Advent Geneva RSL, loader

Powershell, .NET, bat files; all Unix shells – developed complex Unix scripts

Java, Python, some C#

Markit EDM development

DSeries, Maestro scheduling; JIRA for issues tracking

Strong Unix/Linux background including sys admin.

MS Office, Excel

New York Life Investments: Director

Developer – Geneva accounting developer – RSL, loader. Developed Microsoft SQL Server reports, extracts from Geneva accounting. Strong knowledge of SQL query optimization, design. Usage of RSL, RDL, SQL CLR, stored procedures. Investigate accounting related issues. Scripting languages in Unix and Windows including Powershell, ksh, bash, csh. Geneva upgrades/installations. AGA backups, duplicating environments. Primary contact with Advent.

Developed Python BobCAT file transfer utility – now widely used across NYL – transfers files using copy, FTP, secure FTP, email construction. Similar packages available on the open market were prohibitively expensive, less functional – my software saved NYL significant money.

Developed support utilities in Java – date calculation utilities, Java command server which runs on Unix. This allows Windows client apps to run Unix commands without logging onto Unix machine directly.

Developed financial reconciliations – import files from CAMRA, BBG, custodians. Investigate breaks, processing issues. Schedulers including Maestro, DSeries: set up streams, dependencies, jobs. Wrote some basic CAMRA queries in SQL to pull data into SQL database locally. Developed Markit EDM reconciliations, dashboards. Powershell/.NET scripts to support various needs. Version control using TFS. Project management and issues management using JIRA. Interfaced with senior management to hands on operations specialists.

Experienced taking lead on projects, coordinating roles and responses. Supervised/trained offshore team, reviewed, coached/developed them to work to NYL standards. Provide technical support, client management skills.

Worked on upgrades, migrations, all sorts of problem resolutions. Significant business interfacing. Working on multiple tasks at once. Highly experienced in working in understaffed situations, setting priorities, planning, managing expectations, getting job done. Meeting tight deadlines, estimating project requirements, specs.

Significant change control experience. Project lifecycle, audit requirements.

Experienced in SQL, Oracle, Sybase, C, C#, Python, Java, Geneva, investment accounting, scheduling, client focused. Excellent client interface skills. Embracing change.

Sybase DBA – develop/maintain databases for LET system – TBAs, MBS. Wrote stored procs to support reporting; Database query optimization, database upgrades, query troubleshooting and problem resolution

J.P. Morgan & Co. : Associate

Sybase DBA for Fixed Income trading system – develop stored procedures, tune queries, work with C developers in database access. Set up new users, perform upgrades, develop tools to monitor databases, wrote Perl scripts, backup/restore of databases, monitored locking, performance issues. Heavy Unix involvement including admin functionality.

Education

B.S. : Rensselaer Polytechnic Institute, Troy N.Y. – Extensive science curriculum, including some Computer Science courses.

Contact this candidate