Janusz Golian

*** ****** ******

Clifton, NJ ****1

973-***-****

acghh7@r.postjobfree.com

PROFESSIONAL PROFILE:

• 19 years of IT experience working for New York City finances, High Yield

Research Group, Repo Desk and Emerging Markets Group.

• Background in the design, development, testing and implementation of diversified

financial applications using MS SQL Server 2000/2005/2008/2012, MS Access,

C#.Net 2005/2010/2012 WinForms, VB6, Excel, VB.Net 2005/2010, ADO, VBA,

C++, XML, Erwin, Visio, SVN, VSS and Clear Case.

• Extensive operational knowledge of servers established via creating complex

client - server solutions. Practical application of highly efficient data access

process using stored procedures, triggers, views and table indices on server

side. Employment of object oriented solutions for clients’ applications to produce

efficient and reusable codes for the front-end side.

EXPERIENCE:

Financial Information Services Agency, New York

December 2009 – Now

Consultant, Senior Developer

Debt Management System:

• Converting VB6 into C#.Net 2012 utilizing MS SQL Server 2012. Replacing Third

Party Controls with Native MS Controls. Created framework to data access

between C# and SQL Server. Leading Role in Development.

• Optimized process, which originally was running 22 hours, after recoding is

running 13 minutes.

• Reports development to improving data analysis.

• Create complex date structures by designed tables, stored procedures and user

interfaces.

Credit Suisse, New York, NY August 2000 – February 2009

Assistant Vice President, Senior Developer

High Yield Research Group:

• Created databases from scratch to support two different business units: High

Yield Bonds Indexes and Leveraged Loans Indexes. That development included

design tables with indexes, stored procedures, views and triggers.

• Conducted replications between MS Access and MS SQL Server. Process

captures any changes in data and table schema that were advanced beyond

Microsoft’s operational functionally.

• Produced publishing reports through the design of the High Yield Bonds

Recommended List system that collected and tracked issues recommended by

the analysts. The entire application was written in VBA for Excel with MS SQL

Server as the back-end. This application contained a number of screens and was

used to collect data and to produce reports. It also contained a special report that

caught any changes in the recommended list since the last Supervisor Analysts

check.

• Created processes to acquire price values from different sources including

LoanX, Reuters, MarkIt Partners and Intex. The values were collected using

several methods such as servers, URL locations and direct data feeds from

external sources. The formats for the tacked amounts were raging from flat text

files to complex XML structures.

• Build processes that collected and managed data using Moody’s and S&P

Ratings.

• Formulated reports for Biggest Movers for High Yield Bonds and High Yield

Loans that were produced via overnight processes and distributed by e-mail in

HTML format. The reports were prepared for the daily, month-to-date and year-

to-date ranges and were distinguished between Best Gainers and Best Losers.

• Composed reports for High Yield Loans to improve diagnostic of loans from

different sources and to prepare for monthly Loans Indices.

• Generated Excel reports for daily, weekly, month to date and year to date

Leveraged Loans indexes.

• Created fuzzy matching algorithm for Leveraged Loans, which have not unique

identifier. That was large stored procedure, which makes mapping from very

restrictive conditions to more liberal.

• Instituted a report for Risk Management to reevaluate the risk of High Yield

Loans.

• Created searching for defaulted loans based on Moody’s ratings and other

criteria.

• Generated complex reports using Excel, such as a report containing more

columns than maximum allowable columns per spreadsheet, to maintain results.

• Created specialized Excel Ad-ins to support the analysts. For example, a large

amount of data which was presented on the chart labels overlapped and wasn’t

readable. A request was made to help organize all the labels within the chart. In

a specialized routine written in VBA the user can select any part of the chart and

request to spread the labels within that section. The labels are rearranged by

code and if the user is not satisfied with the solution he has the option to undo

the labels relocation and select a different region within the chart.

• Created over 50 fully automated overnight scheduled task used to load and

maintain data.

Donaldson, Lufkin & Jenrette, New York, NY December 1996 – August 2000

Senior Programmer Analyst

Repo Desk and Emerging Market Group:

• Created entry, lookup, and report screens for the Main System Application.

• Parented a Trading Entry Automation tailored towards specific business

requirements.

• Formulated a module to e-mail reports directly from the Main Application to the

customers.

• Designed forms to communicate with Excel spreadsheets for the importing and

exporting of data using OLE Automation.

• Used multi-thread programming to compose Blotter Trade Entry Application for

expeditious trade entry.

• Developed a Near Real Time Position/Risk Exposure Application utilizing Chart

for graphic data presentation with ability to drill down to detail level. Enclosed

specific solutions to distinguish between settled and unsettled trades.

• Originated reconciliation trades with customers’ data module.

• Converted End Of Day and Minute-By-Minute values for selected securities

including collection and storing of data on the server and production of the ad-

hoc and summary reports.

• Removing price spikes from Minute-By-Minute prices stored on the server.

• Established a Reporting Application that presented the detailed and summarized

positions for specific securities.

• Responsible for backups and reconciliation for 12 servers, 8 in New York and 4 in

London.

The Princeton Review Management, New York, NY May 1994 – December 1996

Senior Programmer Analyst

• Focused on specific marketing subsystem including report and statistical analysis

for projections of business development.

• Created programs for mailing lists that included merge and purge functions.

• Participated in the design of the website and programmatically created scheduling

frames that were mailed from the sites to the FTP server.

• Designed a program for importing students from the web into the company’s

system and distributed them to particular sites.

EDUCATION:

Computer Learning Center

Paramus, NJ

Diploma in Computer Programming, Graduated with Distinction

Warsaw Engineering College

Warsaw, Poland

Master of Science in Mechanical Engineering

Contact this candidate