As a member of the Research and Risk Management team, there was an increasing need for a system to house both Dow Jones index data and competitor index data into a single, centralized location for research and analysis. In addition, from an operational and marketing perspective, there was a need to have the ability to create custom and standard reports for clients and for promotional purposes.
Both requirements involved index data and various statistical measurements, and with my technical background, I took on the challenge to meet both demands with the creation of a single solution.
The solution involved the development of a SQL Server back-end that aggregated data from FoxPro, SQL Server and various Access database files containing competitor index data. The front-end application was developed in Visual Studio .NET, and was designed to allow the user to customize a report's layout, statistics and indexes displayed. The application was used by the Index Support team and generated monthly performance reports published on the Dow Jones Indexes web site.
About Dow Jones Indexes
Dow Jones Indexes was the manager and publisher of the world’s most famous measure of the U.S. economy, the Dow Jones Industrial Average. Before it was acquired by Standard & Poor's in 2011, Dow Jones Indexes managed more than 100,000 calculated indexes covering the entire global market, and was the leading developer and licenser of benchmarks used as the basis for investment products. Dow Jones Indexes now operates under the name S&P Dow Jones Indices.