Minnesota Army National Guard

Minnesota Army National Guard

Minnesota Army National Guard - Phase 1 of Region E State Officer Candidate School (OCS) was conducted at Camp Ripley, MN between June 5, 2021 and June 18, 2021. - Phase 2 of State Officer Candidate School (OCS) was conducted at Camp Ripley, MN between July 2021 and July 2022. - Phase 3 of State Officer Candidate School (OCS) was conducted at Joint Base Lewis-McChord (JBLM), WA between July 15, 2022 and July 29, 2022.

Minnesota Army National GuardMaintained inventories and coordinated maintenance program for US Army assets valued more than $150M. Demonstrated leadership ability. - Maintained Secret Security Clearance with the Department of Defense and United States Federal Government.

United States Army Reserve - Revealed inefficiencies in vehicle issue process. Developed reporting that provided leadership with insight into vehicle availability, and sensitive item accountability. Reduced key-retrieval and research times by more than 90%. - Personnel files for Unit of 150+ soldiers fell out of compliance of unit standard operating procedure. Established and implemented a compliant and standardized personnel file format; improved personnel file compliance by 40%.

As the go-to person for Tableau at DataDrive, I communicated Tableau product roadmap changes, developed internal and external training programs, contributed to local and nationwide User Groups, and supported internal marketing efforts. I created packaged solutions, developed sales demonstrations, and provided technical support for a team of 12 consultants.

Partnered with clients across the United States to help them achieve self-service analytics objectives. Created visually appealing interactive dashboards with Tableau Desktop to clearly communicate insights to client and public audiences. Facilitated project planning sessions, data preparation, data analysis, visualization development, user testing and training, and data-driven strategy discussions. - Developed 10 dashboards to be used in sales demonstrations across numerous industries including Consumer Packaged Goods, Retail, Financial Services, Sports Operations, and Food & Beverage Distribution. - During engagements across with clients in Healthcare, Finance, Social Media Marketing, Food & Beverage Distribution, and Sporting Goods Sales industries, I partnered with stakeholders and business users to wireframe and develop more than 30 dashboards. These dashboards replaced ineffective processes, communicated key insights to leaders and their companies, and presented data in new ways which improved data comprehension and data literacy. - Conducted training in Tableau Desktop and Alteryx Designer for beginner and experienced developers on topics ranging from streamlining ETL processes, data visualization best practices, dashboard design strategy, and user experience improvement.

Established systems and standards necessary for reporting and visualization within Microsoft Power BI. Collaborated with Sales Operations, Market Insights, and Research & Development leaders to gather requirements, develop solutions, and deliver insights. - Sales representatives received incentive statements which required an analyst to commit 3 days every month to generate 100+ rep-specific Microsoft Excel workbooks. Partnered with Sales Operations team to develop a product roadmap. This reporting permits in-depth analysis using Microsoft Power BI. New process requires 97% less time and includes row level security. - Competitive industry analyses required an analyst committing more than 10 hours every month to build static reporting. Upgraded to robust and dynamic Microsoft Power BI reporting, and reduced time necessary to update these reports by 95%. - Research and Development (R&D) leadership had been challenged when analyzing product launches and cannibalization. Constructed reporting that improved product research and aided leadership in determining proper manufacturing levels.

Conducted ETL data structuring, data integrity verification, and business analytics. Collaborated with CX, Pharmacy Network/Pricing, and Member Marketing teams to establish project requirements and develop innovative solutions. - Pharmacy Networks were constructed by a pharmacy networks analyst requiring 10+ hours per week. Developed a tool to replicate this process, saving the team an estimated 450 to 600 hours per year. - NetResults formulary (2M+ members) change identification and notification process required 3 pharmacist teams and 120 calendar days. Developed a series of Alteryx Macros and Workflows which greatly minimized pharmacist involvement and is executable in under 15 calendar days. - FileMaker campaign job report creation was time-intensive and took marketing specialists an estimated 250 hours per year. Developed an Alteryx process streamlining the reporting, auto-generating emails and reduced time by 91%. - 3 employees on Campaign Execution team were out on parental leave synchronously over 5-month period. Coverage was key issue for senior leadership of marketing team. Executed 650+ mail campaigns about plan-specific information about drug lists, pharmacy networks, and onboarding communications to 319k+ members and prescribers.

Directed most active financial planning practice among 26 first-year advisors. Aligned client behavior with objectives. Maintained highest level of data privacy and data integrity when tracking sales opportunities, client correspondence, and demographics. - Identified gaps in advisor sales goal success rate. Developed dashboard that provided peers and coaches with a live view toward goal accomplishment. Improved peer accountability and increased goal success rate from 36% to 88%.

- Generated channel-level forecasts for more than 400 SKU’s for assigned business groups, amounting to $130M of annual sales. Negotiated promotional and inventory strategies with internal and external business partners to improve financial performance. - Cutting-edge Oracle-developed forecasting methodology failed to produce results as programmed. Duplicated the concept manually and developed an Excel-based workaround, improving forecast accuracy using this method by 30%.

- Evaluated 75+ lease, service, and construction contracts for properties within a commercial real estate portfolio valued over $1 billion. - Established weekly planning and decision sessions with Asset and Property Managers to ensure contract compliance and smooth operation of commercial real estate portfolio. - Communicated directly with commercial tenants to request and procure documentation necessary for lease agreements.

- Analyzed Damaged and End-of-Life products and collaborated with vendor management leadership throughout the organization to save the company more than $1M in expense by improving reverse supply chain operations. - Improved forward looking promotional reports to automatically identify potential constraints in the supply chain. - Supported Demand Planning Operations team by conducting statistical analysis which guided the selection of replenishment methods.

Received inbound equipment, distributed and maintained equipment for approximately 125 college football players, 20 athletic training personnel, and 20 coaching and support staff. - Facilitated position-group specific training with 3 assistant coaches (Courtney Messingham, Bob Elliott, and Troy Douglas) and 5 graduate assistants (Nick Caley, Derek Day, Ben Barkema, Michael Conrad, and Mitchell Moore) to prepare student-athletes for competition against non-conference and Big 12 Conference opponents. - Volunteered more than 300 hours by scripting and analyzing future opponent passing-game and special-teams film.