DATA GOVERNANCE: Data Steward for the Agency; participate in organization- wide Informatica meetings to coordinate data requests & improve data cataloging. Coordinate record retention schedules for the Agency to promote compliance with City policies. Document data compliance & data mgmt. best practices procedures.DATA VISUALIZATION: Create interactive Power BI dashboards and reports for the DEDO Agency to gauge progress on KPI's and generate actionable strategies. DATA ETL & ANALYSIS: Extract, collect, clean & transform data sets from various sources (e.g. Snowflake, Zengine & SharePoint folders) for quality and acceptance prior to use in visuals and reports. REPORT BUILDING: Build reports in Zengine and Salesforce to capture relevant data in a standard format to seamlessly connect outcomes to performance metric visuals. Developed comprehensive story maps for individual programs that integrate Power BI reports & visuals into interactive maps built in ArcGIS. STAKEHOLDER ENGAGEMENT: Partner with cross-functional teams to understand their goals and ascertain requirements to create dashboards, reports and story maps that measure their outcomes and performance objectives in a visually coherent manner. Present dashboards and findings to Program Teams.ACCOMPLISHMENTS: • Built robust procedural documentation of Data Visualization & Data Management Standards for knowledge sharing • Lead for several story board projects; created project plans and spearheaded standing meetings to produce relevant, interactive reporting tools• Created a comprehensive grant program dashboard that tracked compliance initiatives, performance metrics & successes. It highlighted positive outcomes of the program which generated more interest in the grant program during the next grant cycle & informed decisions around opportunities & areas for improvement.

DATA ANALYSIS: Analyzed trade data for potential share class conversions. Researched & processed requests for sales compensation exceptions. Analyzed large data sets for trade related anomalies & recommended corrective action. DATA GOVERNANCE: Validated & tested new territory files. Led large- scale territory realignments w/ cross functional departments to certify files integrated to downstream systems seamlessly. Managed data access in SalesConnect. Automated data quality workflows to identify deficiencies in master files.REPORT MANAGEMENT: Analyzed & cleaned monthly/weekly sales reports prior to submittal in an enterprise database. Created ad-hoc reports when requested by stakeholders. Onboarded new sales reports by analyzing & validating data & QC’d file maps in a UAT environment for sign- off.SALESFORCE DATA INTEGRITY: Identified potential duplicate records & performed merges. Updated records with current contact information & monitored incoming requests from sales teams. Managed compensation exception requests & built custom reports to track metrics for compensation exceptions entered in Salesforce by sales teams.PROCEDURAL DOCUMENTATION: Maintained & updated procedures for the Data Ops team. Developed data procedures to ensure data quality & consistency through- out the organization.ACCOMPLISHMENTS: • Transitioned Compensation Exceptions from the BI Department & implemented an automated process to assign trades going forward• Led sales territory realignments, ensuring accurate & current sales compensation for wholesaler teams• Implemented & documented a new process for territory realignments to increase operational efficiency & to better serve all sales teams• Created new Alteryx workflows to streamline redundant/manual tasks, resulting in workforce time savings• Seen as the SalesConnect SME for the entire organization & frequently called upon by management to lead cross functional meetings for change management related to SalesConnect initiatives

PROCUREMENT & SOURCING: Procured items and services that support internal departments. Primary resource for Project Managers of assigned departments regarding procurement processes/policies and drafting SOWs, bids and RFPs. Converted requisitions to purchase orders in JD Edwards and attach all required backup documentation, such as invoices, quotes and Federal Terms and Conditions. Maintained vendor spend reporting.RFP/BID ADMINISTRATION: Crafted and submitted Request for Proposals (RFPs) and bid documents on a public database (BIDNET). Hosted pre- proposal conferences for interested firms/individuals in order to address questions prior to RFP opening. Assisted Project Managers in selecting most responsive/responsible vendor based on submitted proposals. Composed and posted addendums, when necessary, to RFPs/bids. Conducted thorough cost analysis for all proposals submitted in response to RFP and/or Bid solicitations. CONTRACTING & VENDOR COMPLIANCE: After award, selected appropriate Service Agreement template and revised to include specific provisions as needed for the awarded service type. When required, initiated an action plan with vendor to address any issues caused by non- compliance to the contract/scope of work. Launched annual agreement renewal letters to vendors and incorporated any changes to the scope of work as directed by the Project Manager. ACCOMPLISHMENTS: • Implemented a cost analysis worksheet to track activities that avoided City expenditure of approximately $110K by negotiating rate guarantees and/or fees with suppliers• Led an organization- wide Medical Benefits RFP with HR and partnered with internal and external partners to achieve desired outcomes during contract negotiations• Hosted a booth at the 2014 Rocky Mountain High School Career Expo and provided students with information about careers in purchasing and engaged them in discussions about advantageous career paths

DEMAND/INVENTORY PLANNING: Sustained KPI’s by maintaining or exceeding 95% service levels while reducing excess/obsolete stock on 10K+ SKUs. Created & submitted purchase orders based on demand and forecast sets. Updated planning parameters in Oracle to fine-tune ordering frequency and set appropriate stock levels. Utilized exception reports to reschedule PO need- by dates. Worked with suppliers to expedite backorder shipments. Collaborated with Packaging, Marketing and Branding to implement successful product launches. SUPPLY ANALYSIS/REPORTING: Monitored and analyzed excess and aged stock reports and recommended action plans to ensure inventory rotation. Created 12 month rolling sales reports in SQL to identify sales trends and compared with forecast sets in Oracle ERP. Evaluated forecast reports and shared forecasting concerns with Project Managers. Analyzed safety stock levels, supplier performance metrics, reorder points and forecast sets on SKUs with poor service levels to identify root cause and facilitate corrective action plans.SUPPLIER RELATIONS: Tracked supplier performance and shared results with key suppliers. Shared areas of improvement with suppliers such as improving on- time deliveries, shipping complete P.O. lines and communicating backorders and solutions promptly. Reconciled invoice discrepancies to ensure ongoing deliveries from suppliers.ACCOMPLISHMENTS:• Transitioned 300+ SKUs from another Planner and improved the service level from 60% to 95% in three months• Led efforts to automate Master Data Loads to boost data integrity, ensuring accuracy across planning and forecasting models• Seen as a SME for Oracle planning throughout the organization; frequently called on to train other Planners • Reduced Inventory dollars on an inflated product line from $740K to $677K by adjusting safety stock levels using statistical analysis, identifying and correcting forecasting issues and optimizing order frequency