– Wrote production code for major index products, including the Russell 3000, Russell Growth & Value indexes, and international indexes. These indexes are benchmarks for ETFs and funds with a total AUM of over $5.7 trillion– Produced research code in Sql, C#, and Java for new index products for clients like iShares, State Street, and other financial institutions– Transition new indexes from research to development and production by performing code review, data analysis, and creating accurate and production ready processes for future rebalances– Coordinated research and analysis activities with global sales and operations offices– Supported sales and client service to fulfill custom analysis requests or build customized indexes for clients– Created, tested, and maintained fundamental data calculations for strategic beta index products– Integrated databases and transfer indexes and proprietary code from Russell to FTSE systems– Began the construction of fixed income indexes for FTSE

– Managed data collection and reporting for Microsoft’s annual customer segmentation process for approximately20,000 client accounts based on revenue potential and product allocation to improve sales productivity– Developed and maintained an ASP.NET Web GUI used by sales offices in over 30 countries for segmentation, enabling efficient communication and replacing a cumbersome manual process– Worked with vendors to build data matching procedures and business logic to integrate Microsoft and Yahoo search engine advertising client lists– Designed, built, and maintained a Sql database and ETL packages to manage worldwide customer segmentation data

– Analyzed credit and prepayment risk for mortgages, corporate bonds, and asset-backed securities– Executed trades on mortgage bonds, asset-backed securities, and government debt– Performed sector weighting and risk comparisons with a custom benchmark, assisting portfolio managers in selecting investments and explaining relative performance– Produced reports to monitor market risk on a $25 billion securities portfolio that were distributed to treasury, risk management, and the board of directors– Created a position data management system with SQL Server to track P&L, prices, and trades for more than2,000 security holdings and provide data input to analytics and risk management software

– Presented financial results and statistical analysis of customer data to senior executives– Performed capital budgeting and return on investment analysis for product offerings and store upgrades