Scott Lee Email & Phone Number

Boston, Massachusetts, United States

-Clients include well-known fintech, investment firm, and retail organizations-Implement, configure and Maintain Microsoft SQL in the Cloud using AWS (RDS, S3, Route 53)-Implement, configure and Maintain Microsoft SQL in the Cloud using Azure (Backup and Recovery)-Network Routing and DNS (ODBC, TCP/IP, VPN, Route 53) -Client/Server and Web-Based Application Support and Development

-Maintain scheduled backups, reporting and verification. Provide and adhere to strict SQL security measures. -Support daily data feeds (extractions) from vendor’s secured FTP sites.-Provide data security and integrity for SQL Server environment (including patching, routine maintenance plans, backups and reporting on various maintenance tasks, backups and verification). -Provide data integration support for internal applications. -Develop infrastructure enhancements for systems and database architecture. -Develop SSIS data extractions (ETL) for financial reporting purposes. -Develop reports using Crystal Reports, Hyperion Designer, SSRS and MS Access. -Develop email alerts and notifications.-Support financial portfolio and trading software. -Maintain inventory of all SQL database systems, creates and administers routine maintenance plans, backups and DR recovery (log shipping, UNC backup generation, database mirroring, high-availability). -Provide database infrastructure security patching, administration and reporting. Speak for all security related items/issues regarding patch management meetings and FDIC regulations. -Create, maintain and administer automated backup and user access reports.-Create, maintain and administer SQL SSIS integration packages used as automated data loads for critical business solutions. -Project Management skills - work closely with customers to meet their business needs using a wide breadth of technologies.-Implement, maintain and upgrade a variety of financial related systems and 3rd party, proprietary banking software applications. -Support client/server banking systems (Fiserv Teller/Sales, Centrix Solutions ExactTMS, CRA WIZ, ActWeb CRM and Sales software as well as Investment Management products including; Thomson Baseline, Advent APX, Advent Moxy (trade order system) and various CRM and AML systems). -Network Routing (ODBC, TCP/IP, VPN).-Numerous 3rd Party software experience. -Local Desktop and Software Support.

-Oversaw all Database Administration and Application Architecture for the College’s databases, which include 3rd party software setups, scheduling of routine maintenance and backups. -Provided upgrades to database and internal software applications for both primary and custom applications. -Created reports for faculty and staff using various software applications on SQL based platforms -Processed exports, imports and formatting of data (data mining) for informational update purposes and/or outside service requests. -Supported all SIS System, Financial, Alumni, Survey and Custom MS Access applications and software. -Supported “Blackboard” Online Learning Software including processing of enrollment, usernames, course creations and general support for faculty and staff. -Supported ADP Payroll, E-Time systems and Report Smith applications. -Provided 1098T processing for tax purposes, annually. -General Desktop Support (Help Desk).

-Provided final version of a sample database for the CRM product release used during client installation and setup. -General maintenance and administration of development and testing databases including scheduling of events, re-indexing, archiving and compressing data in order to allocate more available table space. -Designed “Target” database for multi-platform functionality prior to database conversion and product release. Database platforms include: Oracle 8i, and 9i, SQL Server 7 and 2000, DB2 (UDB) and Informix. -Installed development and testing databases which included configuration of operating system settings prior to setup in order to meet requirements necessary for best performance. -Created custom database schemas, indexes and other various relationships to enhance database efficiency after installation. -Setup ODBC connections: Provide both internal and external support with database network configuration and routing on UNIX, Win2000 and NT. -Created SQL scripts used for verification, analysis and reporting on database objects and schemas after migration. Such reports are used for briefing management and clients on database status. -Client support: supported client with database setup, installation, CRM software workflow processing and configuration. Assist client troubleshoot software, network and operating system issues. Brief clients on possible solutions to such issues. Summarize and track process of product issues reported by the client for product enhancement purposes. -On site custom installations which commonly required system analysis, upgrades to newer versions of software and installation of latest patches. -Provided UNIX shell scripts and knowledge of commands used for general system and database maintenance to both internal developers and external clients. -Provided Win2000 and NT server administration including disk partitioning, software upgrades and patch installations.

-Administered Site server, which contained client's Web Site directories and files for internet services (ASP). -Set up HTML forms using PERL .cgi features, including custom thank-you and submit file and template to control output from the online application to transaction databases. -Used FTP Valet to create secure accounts with certain levels of authorized access allowing clients to transfer files from FTP inboxes to the test and live systems on the Site server. -Utilized Webtrends Log Analyzer: used to interpret statistical data log files into detailed diagrams and charts. -Real Audio/Video setup which included dynamically linking files within stored UNIX directories to client's sites.