Dave Kircher Email & Phone Number

Carpentersville, Il, Us

•Involved in all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, support and efficiency •Designed, executed and performed data performance techniques on the data load process that automates and streamlines the ETL (Extract, Transform and Load) of raw data on a nightly basis using SSIS (SQL Server Integration Services) •Created and developed star and snowflake data models for all Power BI reports and Excel (Power Pivot models) files•Interacted with users from all levels, gathered requirements and translated their business needs into Power BI reports, dashboards and KPI’s in Quality, Sales, Purchasing and Engineering•Created and developed complex and advanced level SSRS (SQL Server Reporting Services) reports•Created and implemented Excel Power Query files that extracted data from the ERP system that give up to the minute reporting on critical data.•Strong leader with experience training developers and advising technical groups on all phases of Business Intelligence concepts.•Team player with excellent communication and problem solving skills in all areas of Business Intelligence.•Created, upgraded and modernized all aspects of existing Microsoft Access Databases

• Developed, tested and implemented a Supplier Quality Management System database utilizing a Microsoft Access 2007 front end with a 2012 SQL server backend (ADP), using stored procedures, views, functions.• Designed and implemented the Quality Management System (QMS) database which included the modules: Device Evidence Reporting (DER), Product Review Report (PRR), Change Impact Assessment (CIA), Root Cause Investigations (RCI), Corrective and Preventative Actions (CAPA) and Internal and External Audits in Microsoft Access 2007.• Developed security that was integrated with Active Directory and created an audit system to track all changes in all modules of the database.• Developed, tested, implemented and validated a Document Management System utilizing a Microsoft Access 2007 front end with a 2012 Microsoft SQL server back end (ADP) using stored procedures, views and functions, the system has a complete audit system to track all changes and the system utilizes Microsoft SQL server security.• Document Management System was developed using Cosign Digital Signatures software for digitally signing electronic documents.• Developed SSIS packages to (ETL) extract, transform and load data to a centralized 2012 SQL server database from existing diversified data sources.• Experience in creating SQL jobs, Alerts and Database Mail• Experience in database activities including database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Backup/Restore• Developed VB scripts to migrate data from the QAD ERP system into a SQL server database

• Key player on the AMS Core PLM Business Process Team that took Agile PLM 9.3 live • Provided technical leadership, problem solving, planning and support in AMS Core PLM Business Process team• Designed and implemented Microsoft Access database to Class & Subclass all part numbers and document numbers• Designed and implemented Microsoft Access database to connect all files on file server to part numbers and document numbers with a 99% match rate• Provided problem solving solutions to cleaning up data to increase migration completeness• Involved in creating formal data migration plans, validation and formal business process documents• Designed and implemented PDM process to ensure part numbers are entered into JD Edwards correctly and efficiently • Created part numbers in JD Edwards ERP system and worked with all departments affected to ensure information accuracy for all fields• Designed and implemented Cognos reports to increase part number information correctness• Agile Administrator for version 8.5

•Planned, managed, implemented and validated numerous Microsoft Access databases for Quality, Packaging, Human Resources and Manufacturing Employee Training.•Created formal documentation and provided training for all databases

•Provided technical leadership, problem solving, planning, support and training in OnBase Document Management Core team•Worked with vendor in data migration and implementation of the OnBase Document Management system•Created formal documentation and validation of OnBase Document Management System•Planned, developed and implemented Technical Report system from paper to electronic using OnBase Workflow & Electronic Forms modules•Planned, developed and implemented Accounts Payable check processing system with OnBase Workflow