Ny -

TM Consultant #NT10004 SUMMARY Innovative and results driven Senior Developer with excellent technical, business, and communications skills. Adept at building mission-critical, internet/intranet solutions for a broad range of industries. Extensive qualifications in all phases of project life cycle from requirements analysis, concept design and implementation to QA and user training. Specialist in Microsoft technologies, with over 9 years of hands-on experience. TECHNICAL EXPERTISE Languages / Object Models: .NET Framework 2.0, .NET Framework 1.1, C#, ASP.NET, AJAX, AJAX.NET, ASP 3.0, ADO, ADSI, SQL, SQL FOR XML, XML, SOAP, Web Services, MSXML DOM, XML WebDAV, XSL, XPath, JavaScript, HTML, DHTML, VB.NET, VB 6.0, VBA, VBScript, Office Interop Server Applications / Operating Systems: Windows 2000 Server, SQL Server 2005 / 2000 / 7.0, SQL Server 2005 Reporting Services, SSIS (Integration Services), DTS, RedGate, Windows Communication Foundation (WCF), Web Services, IIS, Active Directory, Exchange 2000, Indexing Service, Visual Studio 2005 / 2003, Visio, Team Foundation Server, Visual SourceSafe, TortoiseSVN Subversion, Rational ClearCase, Crystal Reports, ActiveReports, ComponentArt, Infragistics PROFESSIONAL EXPERIENCE 11/07 – Present

Consultant Developer Lehman Brothers – New York, NY Investment Management Division, IT Client Reporting Group Participating in the build of a new enterprise-level reporting system. This new web-based, service-oriented platform supports periodic and on-request portfolio reports for high net worth clients of the firm. These reports consolidate and summarize client investments in a manner consistent with the current Private Investment Management business offering: fee based discretionary management of multi-strategy portfolios, which include asset allocation and a selection of proprietary and third party managers. Technologies used: .NET Framework 3.5, 2.0, C#, ASP.NET, IBM DB2, XML, XSL, XPath, Windows Communication Foundation (WCF), Web Services, SOAP

8/07 – 10/07

Consultant Developer (Short-term contract) Arnhold and S. Bleichroeder Advisers, LLC - New York, NY Daily Pricing Reporting System Created an intranet reporting application, to provide current and historical reporting on Mutual Funds and Index Funds, for internal departments and senior management. Nightly data feeds populate the database from various sources (Bloomberg, StateStreet) with end of day funds pricing data. Previously, this data was manually entered into Excel reports, for both trend analysis and performance reporting, with each day’s report stored separately. Upper management requested that a secured, centralized web-based reporting platform be built, to eliminate the need for manual data entry, show historical fund performance, and automate report distribution to both internal and external users (PDF, Excel, Web).

11/06 – 6/07

Technologies used: .NET Framework 2.0, C#, ASP.NET, AJAX, SQL Server 2005, XML, XSL Senior Developer (AVP) Merrill Lynch - New York, NY

Sales Analytics Reporting System The Fixed Income Sales group bids on pools of loans. The awarded bids are then securitized, and re-issued as mortgage-backed securities at market. Provides current and historical reporting for the three desks of the Fixed Income Sales group and senior management regarding bid status, and bids won and lost. Previously, management had received manually generated Excel bid reports. These reports contain current information only and provide no historical or trend analysis. The main goal is to track both sales force performance and bid trends over a period of time. All users will be provided with the analytical tools they need, to identify opportunities for improvement and areas of concern, both at the salesperson and pool characteristic level. Just released to production, the new web-based version of ‘SAR’ provides an easy to use reporting portal, with the following features:

-

basic and advanced search filter criteria the ability to save and name custom reports, per-user the ability to export reports to various formats (PDF, Excel, etc)

Technologies used: .NET Framework 2.0, C#, ASP.NET, SQL Server 2005 Reporting Services, SQL Server 2000, XML, XSL 5/05 – 10/06

Systems Developer SMPL Technologies / Rafferty Capital Markets, LLC - New York, NY Onsite technical lead, for brokerage client Rafferty Capital. Designed and developed new intranet systems, replacing outdated legacy applications and to provide new online functionality, for different profit centers and departments throughout the company. Initiatives included: Bonds Order Management System RCTM (Rafferty Capital Trades Manager) is a web based solution whose aim is twofold: eliminating all limitations of the legacy desktop application, as well as providing new, optimal functionality to broker and management end users. A continuing effort, with the end goal being the complete replacement of the desktop application, through phased releases. In-depth analysis of legacy application revealed key areas for improvement, namely: monolithic EXE logic, single-user support, lack of business rules enforcement, lack of error handling and recovery, redundant data in database tier, slow performance. The benefits of redesign include: a clean separation of logic into structured, modular tiers, multi-user support, business rules enforcement at all tier levels, normalization and performance optimization of the database tier, usage of web cache, fast application response time, intuitive user-interface, UI enhancements for automatic data entry, real-time error alerts sent by separate application, which polls for 'red-flag' items. In addition to the above, major areas of functionality were also completed: •

Automatic Posting of Trades to Third-Party Clearinghouse

•

Scheduled process sends new trades every five minutes to third-party firm, who manages trade clearing with the DTC (Depository Trust Company) and the GSCC (Government Securities Clearing Corporation). o The above ETL (Extract, Transform, Load) process submits files over secured T-1 connection via FTP. Implemented as DTS package. o Users are now freed from the manual double-entry of all new trades, as previously required, into the separate clearinghouse terminal. Automated Trades Reconciliation o

o o o o •

Reconciliation engine compares published clearinghouse trade records with web trade records. Nightly process first downloads close-of-business trade activity file from clearinghouse. Parser utility loads all relevant data into web database. Reconciliation engine then applies a series of business rules to find 'best-matches' for record pairs. Any discrepancies between records, are highlighted and clearly shown on web reports.

Parallel Support for Legacy Application o o o

Current production usage is of both web and legacy systems, with the web front-end used exclusively. Web SQL database updates all data in legacy SQL database, through real-time triggers - differences in table schemas fully supported. Legacy application currently used for reports.

Technologies used: .NET Framework 2.0, C#, ASP.NET, SQL Server 2000, DTS, T-SQL CROSS JOIN, AJAX, XML, XSL Automated T & E Expense Reports Created online T & E application to streamline the expense reporting process for all end users. Replaced the time-consuming, error-prone process of handwritten paper forms and manual entry of these into shared Excel spreadsheet by admin staff. Features summary: o o o o o

o

Intuitive web interface enables users to submit reports anytime Upon status changes, real-time email notifications are sent to appropriate parties Managers can easily review, approve or decline reports Accounts payable staff reviews receipts and records payment on approved reports Secured, multi-company usage supported (available to both Rafferty Capital and SMPL Technologies) Roles-based logic governs page security, dynamic page content, and notification routing

Benefits of new system are: o o o

o

Fast, accurate and personalized ease-of-use for all Comprehensive management reporting, cost tracking and trend analysis Quick turnaround time from report submission to reimbursement Straightforward, paperless audit trail for regulatory compliance

Technologies used: .NET Framework 2.0: C#, ASP.NET, SQL Server 2000, AJAX, JavaScript, Membership and Roles, User Controls 1/05 – 5/05

Consultant Developer (Short-term contract) C2 Creative / Omnicom Group, Inc - New York, NY Client site – Comcast Spotlight Originally hired to troubleshoot and remedy many weaknesses and inconsistencies in existing architecture, due to recent staff turnover. Added feature enhancements for public Comcast Spotlight site and backend Content Manager Administrative application: Content Search and Integration of External News Feed. Technologies used: C#, ASP.NET, ADO.NET, SQL Server 2000

Client site – The Hartford Financial Services Group

Hartford Financial's annual 'March Madness' site, hosted a Tournament Contest and Sweepstakes. Available to the firm's clients, it also contained promotional content for Hartford Financial's products and services. Contributed main deliverables:

• • • •

Client-facing tournament bracket selection page; read-only reporting page Database table schema setup and storage of each user's hierarchical set Secured administrative page to record winning teams User-score calculation and database storage upon each game's completion

Technologies used: C#, ASP.NET, ADO.NET, SQL Server 2000, JavaScript 5/04 – 12/04

Consultant Developer System Management Arts, Inc. (SMARTS) - White Plains, NY

(company acquired Dec 2004)

Principal developer charged with the rebuild of the SMARTS corporate intranet. Designed and developed new web applications to eliminate administrative overhead and to improve operational efficiency, for different departments throughout the company. Automated “Paid Time Off” Tracking and Reporting Application Flexible rules engine supports different accrual levels per accrual year, group policy, and time served with company. Regional and floating holidays for US and international employees also supported. Replaced the previous manual process of tracking employee time through Excel. Application included HR administrative section, and User-facing section. Technologies used: C#, ASP.NET, ADO.NET, Active Directory ADSI, SQL Server 2000, SQL User Defined Functions, SQL Views, Office XP Web Components Online Course Calendar and Registration SMARTS offers technical training on its core product line. New application leverages existing applications - Outlook for data entry and Exchange as data store. Lightweight SQL Server database keeps admin data, and records user registration detail. Replaced the static, manually updated HTML course calendars. Enabled internal users to register online using the intranet. Technologies used: C#, ASP.NET, ADO.NET, Exchange 2000, XML via WebDAV protocol, XSLT, XPath, SQL Server 2000 1/03 – 3/04 Senior Web Applications Developer Byte Interactive - Norwalk, CT Technical lead for client Nestle Waters North America consumer sites. Responsible for the overall development and management of e-Service, composed of the six regionally branded Home and Office sites. Sites supported over 100,000 business and individual users nationwide. Technologies used: SQL FOR XML, XML DOM, XSL, DTS, Classic ASP 3.0, Visual Basic 6.0 (COM) 5/01 – 11/02 Web Technologies Specialist Graham Capital Management - Stamford, CT Directly contributed to all areas of Technology, including n-tier architectural design, new application development, performance optimization, and process automation. Provided custom solutions, utilizing current server-based technology to replace legacy desktop applications. Handled all phases of full project life-cycle for: New www.GrahamCapital.com Site -and- Site Manager/Content Management Application

Redesigned main corporate web site from static HTML into a dynamic data-driven site. Built custom template-based application to manage its content, replacing inadequate SiteStation content editor. Designed for non-technical staff users, hosted on secured intranet server. Separate SQL server stored published HTML content, retrieved by ASP pages on public webserver. Technologies used: XML, MSXML DOM Parser, XSLT, XPath, HTML, ASP, JavaScript and SQL Closest Actions Application Developed real-time price quote alert advisory, comparing live quotes with pre-established price alert levels, to visually highlight pending buy/sell order actions with alert color coding. Assessed legacy desktop application and identified key areas for improvement, namely: Separating previous EXE logic into structured, modular tiers, Replacing outdated platform (VB, DAO, Access 97) with current technology (ASP, ADO, JavaScript, SQL Server), Revamping actions alert-state calculation process (DTS and Transactional T-SQL), Normalizing database tier to eliminate redundancy Benefits of redesign: Significant boost in performance speed - at all tier levels, Improved efficiency, scalability and code manageability, Greater ease-of-use for Trading end users, 24-hour uptime accessible locally and remotely through VPN. Technologies used: Classic ASP 3.0, Visual Basic 6.0 (COM/EXE), XML/XSL XML DOM, SQL Server 7.0 10/00 – 5/01 Applications Developer e-Media, LLC - Stamford, CT

(company closed Jan 2002)

Principal developer for clients WWF, XFL, and House of Blues. Directly responsible for the technical design, coding, testing and implementation of data-driven custom solutions for high traffic, e-commerce sites. Projects included: Online Payment Methods implementation of Flooz and InternetCash (WWF), and Web Content Editor management application (WWF, XFL). Technologies used: Classic ASP 3.0, Visual Basic 6.0 (COM), VB Script, SQL Server 7.0 7/99 – 8/00 Applications Developer SOLDOUT.com - Norwalk, CT

(company closed Aug 2000)

Directly contributed to all areas of development, including database design, n-tier architecture of ecommerce web site and internal application development. Sole developer of site from July ’99 to Dec ’99, coordinating efforts of four consultants. Handled all phases of web site development. Complete redesign of site - from user interface design, to middleware, to backend replicated SQL Servers. Technologies used: ASP 3.0, Visual Basic 6.0 (COM), VB Script, SQL Server 7.0, DTS EDUCATION Pace University, Pleasantville, NY Bachelor of Arts in Computer Science, Minor: Accounting Graduated: May, 2001 REFERENCES Available upon request