Ben Rendleman Email & Phone Number

New York, Ny

Full lifecycle software development (requirements \ analysis \ development \ testing \ deployment) for custom in-house software systems as needed.Maintain and customize Equity & Fixed Income Research department tools, including custom XLS reports and the Red Alerts (3rd Party) research repository.Created Portfolio Optimization engine written in C# and Sql Server, using the IMSL math library.Developed custom reporting platform for Client Relations department.Participated in team effort to redesign and modernize custom in-house reporting for Risk Department.Created backtest data platform with custom ETL components written in Sql Server. Used advanced database optimization techniques for operations on tables with 150+ million rows.

New York, Nj

Designed and developed a Business Intelligence (BI) reporting application in SQL Server 2005. The data warehouse shows allocations of fixed income investments, assets under management and total assets for $41 billion assets under management. Reports include resource allocation, human resources and analyst credentials over time. Data sources include Sql Server, Excel, Geneva & Access. Developed architechture, data model, functional design, ETL design and all aspects of implementation. Designed and implemented OLAP cube using SQL Server 2005 Analysis Services (SSAS) including calculated measures using MDX. Data transformation implemented with SQL Server 2005 Integration Services (SSIS). Developed and deployed business component layer using C#.NET.

New York, Ny

Working for Netik, Inc., developed SQL Server 2000 and 2005 stored procedures for commercially distributed enterprise investment banking and securities portfolio reporting product (Interview 7.0), using periodic snapshot and transactional data. Reports include valuation, gain\loss, position, cash flow, reconciliation, equity, corporate actions, book cost and foreign exchange. Delivered timely and successful product updates. Wrote RAD utilities in C#.net for script management and internet data acquisition. Created Excel\VBA macros for data management, analysis and comparison.

Jersey City, Nj

Designed and developed Business Intelligence reporting application using SQL Server 2005. A SQL Server 2005 datamart on Windows Server accessed a Sybase ASE 12.x source system on AIX. Created ETL component using SQL Server 2005 Integration Services (SSIS), featuring parameterized connection objects, iterative processing and transactional error handling. Designed and implemented OLAP cube using SQL Server 2005 Analysis Services (SSAS).

New York, Ny

Developed custom Pension Fund Management Software System for 5 billion dollar pension fund written in C# with a Sql Server database. Performed business & function analysis and produced technical and user specifications. Gathered and documented functional, logical, and user requirements from business area leaders and end-users. Performed data design and prototyped the data model using case tools. Developed software components, including business layer and user interface, using Visual Studio. Responsible for test plans and managed QA release cycles. Extensive use of object oriented design and code reusability. Areas of concentration include annuity purchasing, retirement estimates, interest compounding, fixed income, forecasting, equity appreciation, annuity payroll, check generation, check voiding, creating EFT banking files.