Bill Weinfurter

***** ***** ****** - *********, ****** 99515 – 907-***-**** adza3e@r.postjobfree.com

OBJECTIVE:

Database Administrator, Developer, Analyst, and Data Processor with more than 25 years of data collection, analysis, reporting, and compliance.

SUMMARY OF QUALIFICATIONS

Data Roles

Database Administrator - Manage SQL Servers

Database Developer - Design, create and maintain databases.

Application Development - Designed, built, coded, tested, debugged, documented, and supported application life cycles.

Analyst - Gather requirements, worked with business to analyze, improve, and implement business process efficiencies.

Data Analyst - Data collection, cleaning, processing, analysis, reporting, dashboards, and compliance.

Management

Director of the Management Information Systems (MIS) team for seven years. (2006 - 2013)

Provided leadership and direction of MIS needs.

Led and managed a team to include performance evaluations, salary recommendations, and decisions on staff assigned.

Supervised diverse team for more than 15 years.

Worked with the Chief Financial Officer on the department budget.

WORK EXPERIENCE

Application Development, Data Collection, Processing, Reporting, Compliance

Consolidated varied data collection and reporting efforts of more than 25 programs into a centralized database.

Designed and developed front-end applications with VBA in MS Access.adp files with SQL backend including business requirements, financial tracking, form letters, check requests, data quality, reports, and dashboards.

Built and coordinated financial data collection with accounting systems and staff.

Translated customer needs, provided recommendations for system features and functionality. Designed, developed, documented, tested, and trained diverse staff.

Tested software for ease of use, accuracy, bugs, and troubleshooting as needed.

Coordinated application development, data collection, quality control, processing, reporting, dashboards, and compliance between stakeholders, directors, managers, and frontline staff from multiple departments and programs.

Evaluated data for data quality improvements, inefficiencies, trends, compliance, workflow impacts, and system risks.

Developed policies, procedures, and technical assistance.

Developed applications in compliance with Personally Identifiable Information (PII), HIPAA and FERPA requirements.

Successfully exchanged and processed data files with the State of Alaska, Wells Fargo, KeyBank, and JP Morgan.

Designed and supported data collection and reporting for Tribal Assistance for Needy Families (TANF).

Built application for the Native Youth Olympics (NYO) to collect data, produce scoresheets, and track financial data.

SQL Server - Database

Administered SQL Server to include installs, security, logins, roles, backup, restore, database mail, and maintenance.

Developed and maintained relational databases in SQL Server working with tables, schema, jobs, synonyms, security, diagrams, XML, DTS packages, linked servers, SSIS packages, constraints, and indexes.

Used T-SQL for developing stored procedures, functions, synonyms, views, triggers, and jobs.

Normalization, defining relationships, referential integrity, primary keys, foreign keys, data validation, security, archiving, linking tables, importing, data types, and record locking.

Designed extensive databases to eliminate redundant data, maintain data accuracy, and integrity.

Used Data Dictionaries to document database design, structure, relationships, and data flow.

Other Experience

Confluence, Jira, Jira Kanban Boards, and MS Teams, to manage and document standards, requirements, and compliance.

Working knowledge of Tableau and Power BI.

Built basic forms in Panda Docs and JotForms.

Led technical trainings and discussions for both technical and non-technical staff based on the audience.

Developed communication skills to work with business staff at all levels to work toward common goals and resolve conflict.

Social Solutions - Apricot Case Manager Application - Administrator.

Experience working with contractors and vendors.

Managed Helpdesk tickets with timely response, determining priorities, and providing exceptional customer service.

SOFTWARE

SQL Server Management Studio, SQL Server 2000, 2005, 2008, 2008R2, 2016, Enterprise Manager, MySQL, Social Solutions Apricot, Asana, Teams, Jira, Confluence, Slack, DocuWare, MS Office, MS Project, DocuSign, Visual Studio, Idera SQL Compare, Idera Toolset, SharePoint, Visio, Crystal Reports.

EDUCATION

Masters of Information Systems, University of Phoenix

Bachelor of Science, Computer Science, University of Maryland

Associates Degree, Applied Science, Intelligence Collection

WORK HISTORY

March 1987 – July 1999- United States Air Force, Air Intelligence Agency.

July 1999 – June 2023 – Cook Inlet Tribal Council Inc.

Contact this candidate