Katrina Menne Email & Phone Number

Responsibilities:- Guiding clients in developing tailored business intelligence strategies, ensuring alignment with their objectives.- Collaborating with data and business teams to maintain data quality and integrity, laying the foundation for effective decision-making.- Creating impactful visualizations using diverse data sets and translating complex data.

Automated manual monthly accounting process using Alteryx to create specifically formatted excel files. Created spend driver analysis report to determine if spend increase was driven by price or usage. Joined, cleaned, and transformed several different data source types in Alteryx. Provided executive summary dashboards to categorize spend.

Greater Minneapolis-St. Paul Area

Tessellation was purchased by phData in October 2021.

The sole member of the Business Intelligence team.Maintain data architecture, queries, and views in the data warehouse, Snowflake. Used In-Database tools to extract Snowflake data in Alteryx.Created automated data cleaning process in Alteryx.Design stories and dashboards for cross-functional Business Intelligence Solutions in Tableau.Provide ad-hoc reports.

Project lead for defining business needs and optimizing a collaborative, tri-department ServiceNow workflow Designed Python scripts and Visual Basic for Application (VBA/Macros) for automation of data transformation and analysis Provided and presented analysis of monthly finances, product utilization data, and other metrics to help discover unique insights.

Greater Minneapolis-St. Paul Area

Data management and manipulationRoutinely using v-lookups and functionsWorking with large data sets of 20K+ linesUtilizing Hybris, GGSM, GSDB, and PIM systemsCreating and running database queries

Verify and enter invoices into ERP systemAssist with Month End ClosingPost transactions to journals, ledgers and other recordsOrganize Vendor Records

Greater Minneapolis-St. Paul Area

Analyzed performance to assess trends, risks, and opportunitiesResearched and inspected a decade's worth of telecommunications billing dataIdentified over $185,000 annual savings and $255,000 in billing errorsTransformed and consolidated multiple data sets into single, accurate source of information

Fargo, North Dakota Area

Aided creating and standardizing the payment validation processGenerated, analyzed, and edited monthly financial reports in ExcelProcessed and posted monthly royalties reports and journal entries in SAPFrequently utilized Pivot Tables, v-lookups, h-lookups, other complex formulas, and Visual Basic for Application (VBA/Macros) Developed most of the team’s.

Fargo, ND

Decreased average customer service response time by 60% to 20 minutesCompiled monthly sales progress reports and inspected for accuracy Created and managed internal and customer-facing processing documentationProvided initial troubleshooting support for all customers Frequently lead product demonstration and solution webinarsExplained and aided with.