Chris Krempel

Experience

• 

  Blue Hand Technologies

  Apr 2006 - Dec 2010

  Business Owner/Partner – Quality Control

  Managed the workload of two Visual Basic developers.• Performed documentation and customer relations activities, including assessment of technical needs, process analysis, training and support. • Ensured that developers managed liability and copyright issues and interacted with customers professionally. • Oversaw projects and resources by reviewing and documenting repairs to National Gypsum’s Curve Solver web application and overseeing changes to a print management system for the United Church of Christ. Show less

• 

  European Adoption Consultants

  May 2007 - Aug 2009

  Business Process Analyst & Database Administrator

  Provided support of company adoption database in addition to other requested duties.• Created a Problem/Change database to track all changes made to adoption databases.• Led the formation of the Office Process Team and implementation of inter-departmental communication processes, improving call and paperwork management between two main offices.• Oversaw centralization of business expenses, allowing reduction in redundant and unneeded servers and providing the organization’s founder with a single budget data spreadsheet.• Synchronized the processing models between the US and Russian office FileMaker databases. Show less

• 

  Weltman, Weinberg & Reis Co., LPA

  Aug 2009 - Feb 2015

  Business Systems Analyst

  Responsible for security, menu and user interface display changes in Artiva (collections management application) and Network Database Administrator duties for Intersystems Cache and Microsoft SQL server products. • Created opportunity to learn Microsoft SQL server and manage 95 database instances (SQL 2000 through SQL 2012), providing workload balancing to relive the sole Senior Microsoft DBA. Managed the installation, configuration, backups and restores. Managed disk utilization, user security and SQL Agent job management. • Oversaw management of 5 Artiva/Cache instances in addition to providing Artiva interface and user support, reducing payroll costs associated with replacement of full-time Cache DBA.• Managed Corporate Online Director (a SQL stored procedure) including maintenance of VISIO documentation and performance of ongoing maintenance. • Standardized and documented Artiva user security (1600 users x 125 permission codes) to satisfy client and federal regulatory audit requirements, permitting Security Manager and line managers to immediately respond to questions with informed responses. • Improved business team “bench test” flowcharting via note card charting, allowing developers to quickly identify bottlenecks and accurately transfer requirements to working code, saving considerable development/testing effort. • Collaborated with Company attorneys to identify and standardize Artiva systems tables used to manage case assignments, eliminating manual data correction and maintaining integrity between physical court documents and the system of record.• Aided developers and business units to create Artiva custom menus and security controls for payment process, resulting in accounting data protection from unauthorized access.• Performed data mapping from COBOL to prepare for SSIS development. Show less

• 

  AmTrust Financial Services, Inc.

  May 2015 - Oct 2023

  SQL Database Administrator

  • Utilized Microsoft SQL as member of team supporting 250 SQL servers and performed SQL Server software upgrades. • Managed multiple projects via Agile/SCRUM while performing day to day responsibilities. • Managed disk space by interfacing with storage team.• Assisted developers to identify and delete obsolete code. • Identified solutions when servers failed; worked with developers to implement solution. • Oversaw database security and worked with senior level leaders to streamline security while ensuring functionality after changes. • Worked with business unit legacy systems to ensure that systems continued to run properly and user ID access functioned successfully. Created VISIO documentation of the system and process. • Served as a liaison with off-shore team members during onboarding. • Supported SOX compliance by providing data to internal and external auditors. • Supported efforts to tighten database security by replacing general-access security groups with ones specific to job function and obtaining user buy-in on the importance/advantages of these changes. • Worked with management team to determine onboarding processes; granted necessary permissions depending on job title and scope.• Communicated with end-users to troubleshoot issues and assisted remotely through phone or video calling. • Collaborated with development teams and business users to decommission/replace servers as needed. • Developed documentation where no one had existed previously. Show less