Marc Bouchard Email & Phone Number

West Jefferson, Nc, Us

Design and implement cooperate SSRS server with the inclusion of over 300 reports that are activethat include everything from medical reporting, Sales, Insurance to financial and membershipmanagementEngineer SQL Server adulting system that imports all database login information into a centraldatabase for management and reportingManage Dynamics 2010 and 2018 systems for all DAN financesGenerate star cluster Data warehouse in order to generate a central warehouse for all insuranceProducts, Product Sales and Online education. This system pulls data from 10 distinct databases inorder to feed the new finance package from Acumatica. This is a automated ETL.Implement sliding window database tables for all Website, email and internal system loggingIntegrate DAN and DANAP with data replication from Microsoft Azure to our local SQL Server2018 database servers.Allow all DAN system to pull Stripe and PayPal transactions to a master transaction database inorder to check for exceptions and allow for local reporting.Upgrade all primary database Server to SQL server 2018 from SQL Server 2008 and 2005Automate restore of CRM database for reporting and Data warehouse, Current CRM system isincompatible with any replication processesPreliminary design of system wide Power-Bi methods.

Raleigh-Durham, North Carolina Area

Raleigh-Durham, North Carolina Area

SQL Server Consultant with the Divers Action Network

Raleigh-Durham, North Carolina Area

Member of TMW Systems DBA group which does customer database tuning, trouble shooting, high level support and consulting.Member of TMW Systems high availability design groupResearch use of Hadoop with TMW products with SQL Server 2016Work with TMW Systems DBA group to implement standard testing and processes company wideDesign scripting and repeatable processes for monitoring and analyzing database schemes.Design and create performance and metadata metrics as they relate to software development and QA processes.Mentoring, Support and Services

Durham, Nc

Design and implement SQL upgrade process for 500+ customers.Design and implement database changes to fit the changing needs of the customers.Design and implement the migration from a single primary database file to multiple files and file groups.Design, maintain, performance tuning and support of the Transman (AMS) SQL Server database.Design and develop continuous automated database build system. The ALM system would update 20 databases, build update script for to update to the current system in order to update developers working databases and would create a demo and blank database. This system could be run every 2-4 hours or as needed. This system used TSQL, Redgate, PowerShell and batch scripts. Maintain DBA Tools database which is shipped with all products if requested by customer.Maintain minimal database server requirements based on expected load based on customer needs.Maintain and enforce database standards and processes.Maintain database documentationDesign SSIS imports for customer systemsFacilitate the design of queries for SSRS reports that will be used by SSRS report developers.Work with customers to design workflow, estimate time and cost for custom development. This development would be scheduled with the DBA group or development based on requirements.Design and develop quality assurance automated backup and recovery systemCode Review of all incoming database changes to meet performance objectives and standardsDesign and develop published external API for direct communication to Transman database

Castle Hayne

Software developer for Computer Aided Dispatch group (CAD). Was in charge of reporting and Database changes.

Bachelor Of Science (Bs), Mathematics And Computer Science

Bachelor Of Arts (Ba), History