beBee background
Professionals
>
Toledo
Nancy Schwartz

Nancy Schwartz

SQL Server DBA, OnBase Solution Architect

Technology / Internet

Toledo, City of Toledo, Lucas

Social


About Nancy Schwartz:

Skilled SQL and OnBase custom solution architect and database administrator with in-depth experience consulting to a variety of business enterprises.  Excellent reputation for thoroughness in project management and results-driven programming.  IT expertise augmented by 12 years of full-range accounting and financial analysis in top management positions.

Experience

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.

 

Education

Cleveland State University BBA

Microsoft certifications for SQL Server Administration and Dynamics NAV Developer

Regular attendee for PASS SQL Saturday events

Microsoft Convergence 2015, Inforum 2014, SharePoint Fest 2013, MSDN Dev 2010

Professionals in the same Technology / Internet sector as Nancy Schwartz

Professionals from different sectors near Toledo, City of Toledo, Lucas

Other users who are called Nancy

Jobs near Toledo, City of Toledo, Lucas

  • First Solar Perrysburg

    +This is a Database Administrator III position at First Solar. · +Mentor other admins. · Architect solutions and document policies and procedures for major database initiatives. · +,valid_job:1, ...

  • Synergy Perrysburg, OH

    The Database Administrator III will perform advanced level administration activities in the SQL Server database domain. · ...

  • First Solar Perrysburg, OH, United States

    We are seeking a Database Administrator III to join our team. This role will involve performing advanced level administration activities in the SQL Server database domain, developing policies and procedures for best practices in database administration. · Mentor other admins. · A ...