Douglas T. Lee Email & Phone Number

Farmingville, New York, United States

Led team of 5 developers and supervised 2 GIS Technicians for New York's largest town. Assisted in development and scheduling of application enhancements and reports. Worked with business teams to understand their needs and troubleshoot reported system problems. Assisted in the evaluation of vendors and the upgrade of existing applications. Worked closely.

Led Ethics committee reviews of processes within the organization supporting sharing of documents and evaluation of potential infractions. Developed and led courses for members in Ethics topics and issues related to extended family structures. Also served as Ethics Chair for the New York State Society of Enrolled Agents.

Greater New York City Area

• Managed complex consolidation, development, and system upgrade projects for the Business Intelligence Department supporting the Treasury Services Division of the Corporate and Investment Bank.
• Managed integration efforts for combining Bank One, First Chicago, and JPMorgan Chase Data Warehouse and Business Intelligence applications for Treasury Services, Client Onboarding, and Investment Banking.
• Organized Warehouse Development efforts for projects to implement major software enhancements for Business Objects reporting with enterprise-wide cross-impacts.
• Responsible for implementing full SDLC project to derive a "360 Degree" view of Treasury Services Clients to help categorize clients by type for better targeting and marketing of products.
• Managed scope carefully to avoid scope creep. Interfaced with cross-functional team (client senior functional managers, other project managers, business analysts, and off-shore development team) to ensure the.
• Developed and monitored Implementation Plans supporting department efforts with multiple external team cross impacts across five-day deployment periods every four months including end-user communication, hosting.

Long Island

• Directed Systems Integration projects for major clients of this multinational firms, including banks, government agencies and telecommunications firms
• Developed and implemented detailed Statements of Work in response to customer requests for solutions and built detailed project plans for implementation of accepted projects integrating host systems and databases with.
• Managed project to implement hardware and develop IVR software to support New York City's 311 System which provides public access to non-emergency municipal services there, and which currently handles over 50,000 calls.
• Led team that completely replaced the Toronto Dominion Bank Telephone Banking System with new IVR system integrating a mainframe DB2 database, a SYBASE database, and local data files to provide information to callers.
• Led hardware and software efforts to provide IVR capabilities for the Maryland Department of Labor including installation and configuration of a replicating Oracle Server, enhanced faxback capabilities, and support for.
• Managed hardware installations of IVR switching equipment to work with Sprint Canada's DMS-250 tandem switches for connecting long distance calls.

Greater New York City Area

• Managed multiple Financial and Administrative systems development efforts for this leading Financial Institution
• Managed project and was lead developer for international Client-Server based expense capture, billing and reporting application for Investment Banking division using PowerBuilder and SYBASE. Responsibilities included.
• Managed team of 10 programmers and analysts supporting bank's Financial Control System that maintained the firm's financial data and provides all of the firm's automated internal and regulatory financial reporting..
• Led development team in the development and implementation of DB2-based Human Resources system tracking data for all worldwide personnel including conversion of records from legacy databases in other foreign and.
• Developed processes to transfer data from the bank's IBM VM/XA environment to their MVS/SP environment to allow sharing of common reference data among systems in both environments.
• Designed and built FOCUS-based relational database to support information needs of the New York Human Resources Department including Data Entry and end-user reporting tools. Built interfaces to import key data from.

Greater New York City Area

• Managed and coordinated all programming efforts to support the information needs of the Telecommunications Services Division
• Managed staff of 3 programmers in the development of on-line FOCUS-based systems to monitor all corporate network components including data circuits, nodes, backup phone lines and equipment
• Developed and maintained Project Progress Reporting system to track network engineering projects involving changes and enhancements to the data network.
• Designed and built interfaces to import data from the corporate DP Planning system to obtain financial data for inventoried equipment.
• Developed reconciliation system to flag discrepancies in circuit charges from communications vendors.
• Trained end-users in system usage and FOCUS reporting.

Greater New York City Area

• Designed, coded, and tested applications to support the Pensions and Investment Areas of the firm including the documentation of requirements, development of user manuals, and training of users
• Designed, coded, and tested FOCUS-based decision support systems for Securities Investment Department.
• Designed and developed FOCUS database and developed on-line files maintenance programs for Real Estate Asset Management Department
• Coded production JCL and designed report layouts for year-end Actuarial Pension Valuation System.
• Acted as Lead Programmer for enhancements to production batch COBOL systems including IMS and VSAM data stores.

Long Island

• Designed and developed manual systems and procedures to support the Treasury Services Division of the firm
• Documented requirements, tested, and trained end-users for new on-line interbank payment system.
• Developed functional specifications for system to analyze errors made in processing interbank payments and their resulting penalty costs.
• Proposed extensive accounting revisions to improve efficiency and reduce errors in the processing of Federal Fund Trades including the design of processes and forms necessary to properly handle them.

Greater New York City Area

• Researched and documented system requirements in the Service Administration Area of Group Pension Department
• Documented system requirements for development of on-line group pension administration system including Service Investigation Reports and enhancements.
• Developed detail business requirements for determining maximum contributions to Tax Sheltered Annuities, ensuring that these computations comply with the Employee Retirement Income Security Act of 1974.
• Evaluated vendor packages providing contribution projection tools and provided recommendations for their selection.