Manage a technical team providing technical direction and product road map. Meet daily with business leaders, clients and 3rd party vendors ensuring our solutions meet the unique challenges and opportunities of our Retail business and empower a data-driven culture.Defined the vision and need for a “Unified” data lake and warehouse project designed to replace on-premise, and on-cloud data warehouses reducing complexity, accelerating delivery, and uniting Retail reporting. Analyzed the cost benefit of transition to using Snowflake, obtained approval for doing the transition and then led the team to convert to Snowflake realizing a 2-year cost savings of nearly $200k, a near 85% increase in performance and providing a modern Massively Parallel Processing system that could grow for future scalability.Helped transform the development culture to a data-centric mentality, developing a self-service BI program supporting team analysts and expanding the use and adoption of data while reducing the overhead of traditional BI development resulting in faster turn around by business units to meet client needs.Lead a project for internal near real-time reporting providing faster response to sensitive client and business objectives – product recalls, and important promotional items, reducing costly rework and improving operational efficiencies.Lead a successful rebuild of Tableau reporting which was initially inaccurate and eroded the trust of internal and external clients resulting in re-established trust and confidence while also creating a robust and highly effective reporting suite that helped accelerate business growth.I build, mentor and lead a team of full time and contracted professionals who support operational and client facing reporting & custom application needs to meet business objectives. Work with business and IT leadership, manage a $5MM dollar budget and provide best-in-class service to the business and its clients.

As a National Manager of Technology at Advantage Solutions, my role was to work effectively as a Player / Coach where I was responsible for building my team, and delivering on the technical solutions needed in the database and BI.Managing a small team of database engineers, my job was to build a sense of collaboration and teamwork - to understand day-to-day roles and responsibilities, challenges, and opportunities where leadership was needed to help advance the vision of the larger Retail Technology team. I defined coding standards, ticketing and documentation standards, and ensured the team cross-trained others, ensuring we were prepared to tackle issues as needed. Soon after establishing the database team, I was asked to step in and lead the BI team which doubled my team size and brought new challenges.In addition to leadership or coaching responsibilities, I was also a technical contributor - I meet with internal users, product managers, and front-end application development teams and implemented new database designs and database structures, procedures, functions and views to meet the needs of new or existing custom applications. I built ETL pipelines, SSRS reporting, tuned performance issues and helped bring stability to nightly data processing loads.I redesigned the back-end data structure of a popular custom application for a $65MM a year client establishing a proper, normalized database design that was driven by a set of configuration tables resulting in a faster and more efficient yearly set up, while still remaining flexible for our client's yearly changes. This same database would later expand to support new application needs by Retail teams.Got involved directly with a major client to understand their reporting needs and challenges, established trust and a strong partnership with weekly meetings, and lead a very successful BI project that ultimately grew our clients business and provided real analytics to the work Advantage was providing.

Sr. SQL Database Developer for a company leading the way in tackling complex retail management challenges for retailers world-wide. Responsibilities include participation in design sessions for database design, JustEnough specific module design and UI usability design. Involved in new module development for the core software suite which involves a large amount of SQL development of stored procedures, functions, tables, indexes and other SQL objects, with UI configuration and design using the DevExpress Pivot Grid controls. Extensive amount of stored procedure development for standard software procedures that allow for flexible reuse across many different client specific business configurations.Involved with and experienced in troubleshooting SQL performance issues, including analysis on locks, waits, and review of Query Execution Plans. Have been successful at implementing better indexing strategies, including Column Store indexing. Helped update existing in-house procedures that allow easy table partitioning and partition maintenance on very large customer tables.Involvement with JustEnough clients in solution design, requirement gathering, analysis, and resolution of advanced customer issues. Involved in supporting our team our consultants on software implementations, best practices and performance related issues.Implemented Red Gate SQL Monitor to establish baseline performance metrics to troubleshooting customer performance and improve overall performance of our standard product through early detecting.Helped implement a method of documenting database objects (tables, procedures, and functions) using the built in MS Extended Properties coupled with Red Gate SQL Document 3. The documentation serves several purposes within JustEnough, including documentation on the purpose, detailed description, and examples of the use of a SQL object which helps support, consultants, and developers when the intended purpose of an object is unknown or unfamiliar.

Microsoft SQL Server 2008R2 Database Developer and Administrator for one of the largest and most influential churches in the United Stated. Responsibilities include schema and ERD design used in various front-end, web-based applications including the design of SQL tables, stored procedures, functions, views, and user defined types. Responsible for maintaining five SQL servers used in both production and development environments, instance installation, backup, disaster recovery, index creation, query performance and optimization of an OLTP database, SSRS report authoring and database monitoring.Key Achievements and Projects:• Improved both the quality and development process of SQL reports by meeting regularly with various teams and staff members and communicating progress, hurdles and successes during report design.• Strategized on, fixed, and developed new tools and applications for our custom built church management solution enabling staff to better manage church membership, events, communications, web content, giving, community outreach, and more.• Played a crucial role in helping to redesign and develop new tools for managing and communicating to a network of over 3,000 small groups by researching and developing new database technologies used in managing hierarchal data in SQL server.• Provided support, and classroom based training to both staff and church members on the use of various features and tools of both our intranet, and our public facing websites.• Migrated and merged data from multiple SQL server environments into one, localized production environment.• Helped design and implement disaster recovery solutions for our production SQL environment.• Promoted from a junior level SSRS report author to the lead Database Developer for the company.

As a technical support specialist, I was responsible for answering incoming phone calls and emails from customers with questions, concerns, and issues related to our front-end website. Issues presented by callers covered a broad spectrum of areas from login issues, to basic instructions on how to use certain features of our site as well as general bug reporting. In addition, I worked as a helpdesk associate solving various issues involving laptops, desktops, printers, phones, other peripherals and computer software.