Senior Data & Analytics Consultant

• Sep 2020 - Present

Database Administrator

• Sep 2016 - Sep 2020

• Designs, develops, and optimizes queries, procedures, SSIS packages, and other SQL Server objects for a database-backed web solution.• Provides analysis, maintenance, and issue resolution for the production SQL Server environment.• Generates operational and analytical reports for both internal and customer consumption. • Designs, develops, and optimizes queries, procedures, SSIS packages, and other SQL Server objects for a database-backed web solution.• Provides analysis, maintenance, and issue resolution for the production SQL Server environment.• Generates operational and analytical reports for both internal and customer consumption.

Sr. Production Operations Engineer

• May 2015 - Sep 2016

• Hired, trained, and managed a team of employees to pull data onsite at Target Corp’s headquarters.• Ensured departmental objectives were attained while migrating to Target’s new data sources.• Spent two months in RSi’s Shanghai office, working closely with departmental counterparts.• Ported and developed various stored procedures to work with RSi’s Next Generation platform.

Sr. Production Operations Analyst

• May 2013 - May 2015

• Functioned as a subject matter expert for the company’s second largest channel—Target.• Troubleshot issues throughout the ETL path and within various end user applications.• Provided ongoing support of the production data apparatus—from data acquisition to various enduser applications.

Customer Experience Analyst

• May 2012 - May 2013

• Provided the service element in a business intelligence SaaS. company within the CPG industry.• Provided training to new users and ensured any ongoing customer concerns were resolved.• Functioned as a technical resource on the team by developing Sharepoint tracking and automationsolutions, as well as an external facing Excel macro based add-in.

Business Intelligence Developer

• Jun 2011 - May 2012

• Developed SQL Server Reporting Services (SSRS) solutions around aspects such as employee performance,data driven marketing materials, and integration with Microsoft Dynamics CRM.• Wrote and optimized Transact SQL queries, procedures, views, and functions to efficiently retrieveand consume data.

Project Based Role

• Dec 2010 - Jun 2011

• Worked closely with the company’s owner during a restructuring phase of the company.• Rapidly deployed a series of Microsoft Excel based sales dashboards and reports to accommodatemultiple new implementations of Microsoft Dynamics CRM.• Served in an analyst capacity on a sales process management team.

Marketing Account Executive

• Feb 2010 - Dec 2010

• Effectively managed a territory of current and potential customers in the financial advisory industry.• Conducted website consultations to train, update, and ensure websites were being marketed to their fullest potential.