Experience

Daisy Brand

• United States
• Food and Beverage Manufacturing
• 200 - 300 Employee

• Business Intelligence Manager

  • Apr 2023 - Present

• Data Architect

  • Feb 2019 - Apr 2023

• Senior Business Intelligence Developer

  • Nov 2015 - Jan 2019

  Our team is responsible for all data related aspects for the companyServer AdminstrationSetup and configured SQL Server AlwaysOn 2016 server for our production data warehouse. Migrated SQL Server 2008 R2 data warehouse to above mentioned environment. Setup and configured Tableau production, development, and test environment. Tested new versions in lower environments before upgrading production. Responsible for managing and monitoring the health of our systems using RedGate. Reports and DashboardsTableauBuild dashboards for all departments in the company. Responsible for ensuring adoption across departments and creating dashboards to meet and exceed requirements.Created sales, logistics, customer relations, product complaints, operations, lab, and budget dashboards that show key metrics for the end user. These dashboards saved the end users many hours worth of time which they used for analysis. SSRSCreated many canned reports for external use to clients and customers. ETL and AutomationWe believe in a single source of truth, so all data was brought into our data warehouse server. Whether in our main DWH database or separate databases. Created many ETL processes to add to our data warehouse.Also created automation packages using SSIS to automate manual processes from departments. Time savings for these ranged from 45 minutes to a couple weeks. Show less



Research Now

• Canada
• Market Research

• Infrastructure Engineer, Big Data

  • Jul 2015 - Nov 2015

• Database Administrator I

  • Sep 2013 - Jul 2015

  Server AdministrationWorking as the only MSSQL Server DBA for the companyCurrently managing 27 SQL instances spread across 5 clusters in various locations, 7 standalone servers, and a total of ~35TB of data.Upgraded and consolidated all 2005 (2), 2008 (4), 2008 R2 (25) production SQL instances to 2012 in one year. Led to savings on licenses and data center costsMigrated 6 standalone virtual dev environments into one physical 3 node SQL clusterStructured 5 main SQL cluster hubs in the Allen, Plano, Canada, London, and China Manage 10 production SQL 2012 servers in various active/passive cluster configurations and a 3 node non-prod active/active/active SQL 2012 cluster. Along with 7 standalone SQL servers.Configured MySQL Master/Slave replication, user access/creation and backupsConfigured Elasticsearch, Logstash, Kibana (ELK) to monitor logs from Windows, MSSQL, Web, MySQL serversReporting and ETLDeveloped a Scaled out SSRS deployment architecture to maximize uptimeCreated SSRS dashboards for various teams in the company.Developed Tableau reports for Mobile datasets that were provided to clientsScheduled SSRS report deliverables to be sent externally and internally.Created package to export survey results to clientsCreated package to export data from Oracle and into SQL server in order to recruit new members into Mobile platform.Monitoring and MaintenanceCreated SQL Server Utility and Management Data Warehouse in order to monitor all 27 Prod and Non-Prod SQL instances Monitor all clusters and databases for fragmentation. Created archival policy for our large databases (5tb+)Created a custom SQL Disk/CPU/Backup monitoring using SSRS, SSIS, and SQL Agent.Created package to archive and log project records and project databases.Worked with development teams to write queries and verify performance with execution plans and tuning adviser.Backups Manage all SQL backups and maximize performance to limit impact to production Show less

• Senior Application Support Engineer

  • Jan 2013 - Aug 2013

  Interviewed and cross trained 4 Global Service Desk team members, including new hires, on existing and new applications; including: 400+ UNIX and Windows servers, 10+ enterprise applications, and different business processes.Developed training manuals and development plans in order to effectively train new hires in a timely manner.Prior to becoming Senior, the team was resolving 82% of issues without development assistance. After working with developers and architects to find the root cause of issues and developing new methods to resolve issues, the team is now resolving more than 95% of issues. Issues are rarely left outstanding for more than 3 days. Led a team effort to create a central location for pertinent information such as application diagrams, SQL queries, knowledge base, event management, and morePresent global operations meeting every morning to review events in the past 24 hours as well as, Problem Management tracking in order to keep high priority system issues. Leveraged SQL to query and report against enterprise Oracle and SQL databases in order analyze data more granularly.Worked directly with Admins and Application Developers/Architects for various server and application issues, outages, and improvementWorked with business to create monthly outage reports, and also notifying user base of system issues. Led various team projects to ensure our Enterprise Monitoring solution, Nimsoft, was running and reporting correctly. Show less

• Application Support Engineer

  • Sep 2011 - Dec 2012