Joseph Melillo Email & Phone Number

New York, United States

Paris, France, Fr

World, Oo

Albany, New York, Us

New York, Ny, Us

Skills Used: Sybase, shell scripting, PERL, Informatica, Pentaho, Java, DevOps, Puppet, Control-M, Jenkins• Supported the Structured Finance Group database and applications.o Performed performance and functionality enhancements to various aspects of database and applications. Designed and developed new data feeds (including designing and building new tables and indexes to hold new data and stored procedures to maintain and access data). Designed automated upload systems to allow users to maintain their own data. Designed and developed infrastructure to maintain the execution history of Control-M jobs and utilized that information in recording the last date for which a job ran successfully, in order not to miss any processing dates.o Enhanced object extraction shell script to report column-level permissions.o Designed and developed several enhancements to SDLC process.• Performed DevOps development for Analytic Harmonization and Sharing system.o Worked on incorporating Puppet into configuration maintenance.o Designed automation of manual processes; utilized the Jenkins CLI.

Skills Used: Sybase, shell scripting, PERL• Supported the Bridge database which is the underlying database for www.moodys.com.• Primary responsibility was supporting the Performance Data Services (PDS) application in www.moodys.com., which reports on over twenty years of performance data for asset-backed securities. The data was loaded from source databases via Sybase triggers into a staging area and loaded from the staging area to the actual database via a C server process.• Incorporated international instruments into the database which included new functionality on the front end, requiring new tables and stored procedures.

New York, Ny, Us

Skills Used: PERL, Sybase, Java, HTML, JavaScript, C/C++, Expect, A+ language, Electronic trade processing, Syndicate business, Fixed Income products• Supported the Trades Completion infrastructure, incorporating Syndicate business.• Implemented various jobs utilizing PERL to access Sybase stored procedures and formatting the data into user-readable reports.• Supported the Global Capital Markets business unit with various technological needs.• Merged separate US and European vendor systems into one, allowing users to view data from both simultaneously. Built system front-to-back, including data loaders from each system into main Sybase database, and Web-based Javascript front-end viewer.o Additionally, integrated after market data, industries, and prices from Firm-wide databases into the system. The availability of this data enhanced the information available to the user.• Enhanced trade booking infrastructure to process different types of instruments and integrate with the new suite of vendor products. This infrastructure was built in–house, and primarily consisted of server-processes written in C++, PERL, and Java. All servers queried and wrote to Sybase databases via stored procedures and were designed to work with the trade booking functionality of the vendor applications.• Developed Trade Booking Debugger in .NET with C#. This allowed users to identify issues with trades that were submitted but not processed yet.• Designed and implemented databases using a variety of database tools to hold a wide variety of data, covering all areas of fixed income trading. Served as sole support for over twenty databases and related procedures and applications, as well as main contact with over fifteen different data vendors.• Designed and implemented loaders, access methods, data maintenance GUI applications, report generators and error notification mechanisms for the above-mentioned databases.

Skills Used: C++, C, Sybase, Fixed Income products• Trained in the financial aspects of the securities industry, with a concentration in bond mathematics.• Developer for a comprehensive trading system for fixed income traders, including:o real-time trade processing, including cancellation and correctiono real-time on-line analytic and hedging calcula¬tionso spread and basis pricing facilities; overnight price submissiono sales and offering maintenanceo real-time broadcast of current positions, accounts and consolidationso interface with real-time price feeds and other trading software• Responsible for software development environment design.