Dennis Williams Email & Phone Number

Liberty Lake, Washington, United States

Spokane, Wa

Develop, enhance, and maintain customer-facing applications for city/utility billing, management, finance, permits, etc. using VB.Net and C#.Develop SQL stored procedures, triggers, views, indexes, database deployment scripts for customer-facing applications.Develop conversion software for on-boarding new customers using complex ETL processes to import data and processes from competitor's software and databases using SSIS as a framework.Act as Tier III Support for clients with complex issues.

Spokane, Washington Area

Develop and maintain data warehouse tabular cubes, ETL processes, and Business Intelligence reporting across platforms (DB2, MS SQL, Majiq Elixir, PIAF, and Oracle DBs).Develop complex TSQL stored procedures with a high emphasis on performance, maintainability, and industry standard best practices.

Spokane, Washington Area

Develop and maintain database systems (schemas, stored procedures, views, functions, and installers)Gather and negotiate requirements from product owners and web application developers, and plan development and implementations using Agile methodologyGather Business Intelligence requirements from customers and develop reports for them.Document implementations using ConfluenceSupport customer implementations as required

Administer SSQL 2008R2 and Oracle 11G databases hosted on Server 2008. Administer GE Centricity servers and applications (ERP/Medical Records system) for multiple medical clinics.Interface MSSQL, Oracle and MySQL servers, providing real-time ETL across varied platforms. Write and maintain interfaces to external sources (Labs, Specialists, Medical Imaging etc.) using T-SQL scripts, stored procedures and functions.Gather and analyze requirements for tuning existing applications and creating new applications.Create web interfaces to databases using ASP, ASP.NET, PHP, jQuery and HTML.

Administer multiple replicated MSSQL 2000/2005/2008/2008R2 databases hosted on Server 2003 and Server 2008. Administer SunGardHE PowerCAMPUS server and application (ERP system)Interface MSSQL and MySQL servers, providing real-time access to rapidly changing data across varied systems. Administer MS Dynamics Great Plains accounting system. Administer Active Directory and LDAP server.Gather and analyze requirements for tuning existing applications and creating new applications.Program web front-end interfaces to databases using ASP, ASP.NET, C#, PHP, jQuery and HTML.

Sell and service customer accounts ranging from personal savings and checking to multi-million dollar business and investment accounts. Act as ambassador to the public. Handle day-to-day issues such as overdrafts, account closures, etc. Open and close bank (including security procedures and vault opening). Liaison to tech support for office equipment and peripherals (PCs, terminals, phone, fax, copier, etc.).

Sell investments door-to-door; open and maintain customer accounts; act as ambassador to community at various functions (Chamber of Commerce, Rotary, etc.). Provide investment advice at seminars, one-on-one, and over the phone.

Handle day-to-day issues such as overdrafts, account closures, etc. Open and close bank (including security procedures and vault opening).Liaison to tech support for office equipment and peripherals (PCs, terminals, phone, fax, copier, etc.).

Administered the entire life cycle of PCs from procurement through surplusSupported end-users, troubleshooting hardware and software problems on PCs, Unix RS/6000 workstations, telephone, networking, & printing infrastructureMainframe Replacement Team – Replaced IBM mainframes with IBM AIX servers, including procurement of all hardware & software.Led the implementation of CADKEY, a 3D CAD drafting package for PCs.This included procurement, creating large scale TCP/IP network, plotting/printing infrastructure, creating a database system to store digital drawings, troubleshooting & training for Everett site (over 1200 specialized workstations). Teamed with Interiors engineering to streamline their internal processes & saved over $2.5 million by upgrading PCs & automating error prone systems.Performed drafting & 3D lofting for Structures Engineering using both manual & CAD drafting skills.

Certificate, Aerospace Mechanical Drafting, A+

Diploma, Mathematics