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 with vendors to ensure they were doing their work in the best interest of the Town of Brookhaven.

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 functional and technical requirements are implemented within the scope of the project. • 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 periodic progress calls, escalatiing issues, and PMO reporting. • Managed server upgrades and datacenter relocation for both the SQL Server environment and the Oracle Data Warehouse to ensure that issues were quickly analyzed and fully resolved, and to ensure that our efforts were fully coordinated with the infrastructure team, database administration, and all data suppliers. • Maintained Issues List and escalated \as necessary to avoid project delays and ensure that all compatibility issues were properly identified and addressed. • Developed and managed Project Plans to track budgets and progress, and to report overall status and coordinate end-user and data supplier testing of all major system enhancements.

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 Interactive Voice Response (IVR) technologies, including Advanced Speech Recognition and voice talent script recording. • 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 daily. • 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 which was not readily available elsewhere in the organization. • 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 Telecommunications Devices for the Deaf (TDD). • Managed hardware installations of IVR switching equipment to work with Sprint Canada's DMS-250 tandem switches for connecting long distance calls. • Developed IVR front-end systems with speech recognition for Great Western Insurance, Verizon Wireless, Newsday, GTE, Pegasys Satellite Television, and the U.S. Patent and Trademark Office to improve caller experience and more efficiently address caller issues and concerns. • Interfaced with internal and external Technical Support, Manufacturing, Sales and Engineering teams to support implementation of MPS switches for Sprint Corporation in Overland Park, Kansas. • Prepared software development quotes and participated in presales meetings with prospective clients.

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 analysis, application and database design, coding, testing, end-user manual creation and rollout to staff in New York, London, Paris and Hong Kong. • 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. Responsibilities included monitoring the daily cycle and working with over 60 data suppliers worldwide to ensure that all feeds were fully processed and passed to the firm's risk management and regulatory reporting systems in a timely manner. • 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 domestic offices. • 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 other internal systems and converted the combined data to the eventual future system repository.

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.