Lee Wade Email & Phone Number

Raleigh, Nc

•Manage the NCEL Applications Development team consisting of programmers, database administrators and a business analyst. •Work with leadership to assess the needs of the organization and deliver tailored solutions to meet those needs. •Report project statuses and obstacles to the director of MIS. •Manage all aspects of projects throughout the systems development life cycle.•Mentor team members and ensure their growth and development. •Conduct employee evaluations for annual reviews. •Act as key contact for issues involving external agencies.•Develop and maintain SharePoint intranet sites, forms, workflows and farm servers.•Review and create automated scripts/processes for file transfers to and from the agency across distributed systems.•Create and submit tax files for end of year reporting in the formats specified by the IRS and DOR.

•Designed and developed databases using relational database models for all internal business departments using SQL Server.•Developed web applications for data entry for internal departments using C# and ASP.net. •Configured database servers to ensure high availability and disaster recovery across multiple subnets.•Developed SSIS packages, TSQL and VB scripts for importing, manipulating and transferring data between multiple SQL Servers, SQL Server Instances and secure FTP servers.•Created and maintained tables, stored procedures, views, functions and triggers for SQL Server databases.•Maintained SQL Server security logins and roles.•Created and monitored jobs in SQL Server for backups, import, export and manipulation of data.•Developed and maintained reports for the following departments: Finance, Retailer Contracts, Retailer Services, Sales, Marketing and Communications using SQL Server Reporting Services and SQL Server Business Intelligence Development Studio.•Monitored and tuned SQL Server databases and queries for optimal performance.•Managed confidential incoming and outgoing retailer and financial data to and from outside agencies.•Documented all database and report structures for audits.•Assisted in the installation and setup of a SharePoint 2013 farm.•Developed SharePoint forms, lists and workflows for approval automation.

Taught the following courses:•Introduction to Computers •Spreadsheets•Database Concepts and Applications •Introduction to Business•Database Development Theory and Implementation with MS Access (Professional Development)•Introduction and Advanced Use of Microsoft Excel (Professional Development)•Database Development Theory and Implementation with MS Access(Professional Development) •Advanced Excel for Corporations (Professional Development)

•Maintained and updated website content and design.•Maintained and updated databases for the website.•Oversaw Pay-Per-Click advertising campaign for all major search engines.•Managed the Search Engine Optimization company’s efforts to improve the website’s organic rankings in search engines.•Analyzed and reported Pay-Per-Click and referring URL data collected from website.•Performed detailed analysis of online sales lead conversions.

IT Manager: •Developed and managed the Timberline estimating, purchasing, and accounting database systems.•Designed, installed and managed the division’s computer and phone networks.•Responsible for the setup and maintenance of all printers, computers, peripheral hardware and software.Estimating/Purchasing Manager: •Managed estimators by assigning and prioritizing jobs and reviewing purchase orders and budget accuracy.•Prepared base house budgets and gross margin reports.•Reduced construction costs by 5% using various negotiating tactics with suppliers and subcontractors.

Mba, Business

Activities and Societies: Leadership Development

Bsba, Management Information Systems, Business

Activities and Societies: Leadership Development program participant and mentor