Nancy Schwartz

Hyland – Creator of OnBase

Database Engineer – Global Services

April 2021 – Present

• Project work includes custom scripting, performance tuning, ad hoc data analysis and troubleshooting for customer base, database 32 bit to 64 bit, collation and Unicode migrations.  Specialist for the team in dashboard and reporting.

Solution Consultant – AP Services

January 2019 – April 2021

• Implement and customize Workflow and Workview automation solutions integrating with multiple ERP and financial management systems providing intelligent capture, advanced data integration and validation with ERP including approvals, posting and auditing.

Senior Conversion Engineer 

December 2015 – January 2019 

• Design, develop, and implement solutions for legacy ECM conversion projects.

Buyers Products Company 

Senior Developer / Database Administrator

January 2008 - November 2015

Custom Solutions Architect and Developer

• Strategized and executed data migrations to company ERP systems from acquisition legacy systems.
• Developed custom solution for field sales reps to have access to customer, product and sales information.
• Administrator and developer for Microsoft SharePoint 2007 and 2013, Microsoft Dynamics CRM 2013 environments.
• Managed project to convert entire reporting platform for the company from Crystal Reports to SQL Server Reporting Services.
• Author of dozens of custom tools, integrations, business intelligence and database solutions to manage emails, faxing, banking and automate business, accounting and manufacturing processes.

DBA for multi-server SQL Server environment

• Responsible for hardware specification, installation, maintenance, backup, monitoring and security of all SQL Server instances.
• Maintain production and development environments.  Design custom databases.
• Conducted all performance monitoring and tuning for physical servers and databases including configurations and settings, index and query tuning with native and 3rd party tools.
• Managed replication of multiple databases for reporting purposes.
• Develop strategies for upgrades and database growth for the life of the hardware.
• Review T-SQL programming in addition to coaching and mentoring the IT team.

SB Stone & Company (currently operating as Level Seven) 

Consultant / Application Developer

1996 - 2007

Conducted all facets of technology engagements with clients in diverse industries.  Responsible for identifying functional requirements, conceptualization, design, coding of custom software solutions for our client base.  Established and cultivated relationships with client leadership.  Prepared and presented business case analysis and proposals to business stakeholders.

• Construction – Provided a major re-write and upgrade to SQL Server for a custom MS Access application including integration with commercial ERP software and replication of databases to project managers.
• Manufacturing – Managed SQL Server database and provided custom solutions for barcoding and faxing/email automations.  Managed data migration from SQL Server to Oracle PeopleSoft after company was acquired by Alcoa.
• Farming – Designed and implemented major integration with Microsoft Dynamics NAV and custom order and shipping solution for micro-greens farm.
• Services – Created custom solution for government agency to manage state funded Help Me Grow program.

Controller

Karklin, McClellan, Harris 

1995 - 1996

• Automated manual accounting systems and managed staff and IT functions for this $200M national food broker.
• Presented company systems to national food manufacturers in the broker interview process.

Controller

SS Kemp & Company 

1983 - 1995

• Reported to the President and Chairman of this $30M distributor of foodservice equipment and supply.