Dawn Bartell Email & Phone Number

Partnered with IT, Client Data Management, and Sales to provide accurate, timely data. Identified data issues and worked with multiple departments to make corrections. Wrote and tested scripts to update data. •Automated and improved processes for loading Provider Master Lists (PML); outreached to field sales to identify source of PML. •Performed weekly/monthly comparisons between company data and the PML to ensure providers were correctly active in the system. •Collaborated with healthcare clients to receive files via FTP and setup file mappings; testing and monitored files. •Authored instructions, unique to each client, for internal users to use to identify active Providers.•Developed a reporting and tracking process for Disclosures of Ownership to consolidate data and provide actionable reports to senior managers; performed data cleanup in existing systems.•Collected data from 4 sources utilizing 11 different reports and created a process to consolidate the data, track and document incoming DOOs into one source. •Worked with IT to create internal process for on-going provider sanctions and license monitoring to eliminate the use of a 3rd party vendor. •Researched rejected claims, identified trends; performed data cleanup projects to eliminate rejections.•Using VBA, reduced turnaround time by manipulating exported data into format required for importing.

Menomonee Falls

Performed EDI trading partner setup, transaction set mapping, testing and implementations. Managed data analysis, standardization, clean up, and consolidation. Developed and executed SQL queries to identify and resolve technical issues. Oversaw inbound and outbound paper claims, preauthorization and EDI transactions (837D, 835, 834, 277ca) processing from trading partners such as clearinghouses, software vendors, providers and third party billing services. Identified and resolved technical issues for successful data transport.•Utilized inhouse IT applications and BI tools to support data mapping, business rules, and HIPAA compliance.•Partnered with IT to implement new requirements; defined requirements, approved use cases, performed user acceptance test (UAT), and approved code fixes into production.•Authored DQ technical specifications for Trading Partner transactions that enabled clients to comply with processing requirements and reduce errors.

Milwaukee Wi

Promoted multiple times over tenure: Senior EDI Specialist > Lead EDI Specialist > EDI Systems Supervisor. Awarded highest honors in Lean Manufacturing Program; won 2 of the 4 projects of the year awards, resulting in a savings of $200,000 annually. Considered the subject matter expert for EDI and JDE systems. Key liaison between all business units and customers. Negotiated all EDI related contracts. Supervised EDI team, vendors and consultant resources. Analyzed and identified ways to improve EDI processes and develop solutions for more efficient processing.•Set up EDI trading partners, performed transaction set mapping, testing and implementations. Mapped EDI Document Types: 830, 862, 850, 855, 856, 810, 824, 820, DELFOR, DELJIT, DESADV in a manufacturing environment and complex Automotive EDI specifications.•Managed technical aspects and work associated with the implementation and ongoing support of EDI and systems integrations. •Translated EDI requirements into technical specs; helped create and modify application architectures.•Managed data: data analysis, data standardization, data clean up, and data consolidation. •Integrated EDI and JD Edwards across business units; designed, evaluated and interpreted data relationships and related business processes. •Analyzed JD Edwards’s data for New Trading Partners prior to on boarding to identify any data sourcing issues. •Resolved EDI issues by performing root cause analysis.•Eliminated 80+ hours a week of manual data entry by developing solutions for more efficient processing. •Developed and tested new data source locations for ASN data with IT, CSR, Labels, Warehouse, JD Edwards and Shipping software.•Eliminated 40+ hours a week of data entry by designing VBA programming for special requirements. •Reduced forecasting time by 2 weeks by creating a program to eliminate manual entry of forecasting data.

Grafton Wi

Coordinated with account executives, project managers, production coordinators, vendors and carriers to plan and execute rollouts of 100 to 3500 displays. Controlled finished product distribution by scheduling, purchasing, and negotiating shipping services domestically and internationally. Monitor inventory levels and forecasted client’s needs.Optimized loads to reduce fright costs and tracked on time deliveries. Created client specific reports using; SQL, Crystal Reports, MS Excel, and Visual Basic. •Researched and selected third party EDI company and implemented EDI processes with key customers.•Investigated and coordinated program changes with 3rd party software company to increase efficiencies. •Actively involved in team building events: cookbook days, book club, blood drive, wellness events.

Menomonee Falls, Wi

•Coordinated with sales and clients to determine their requirements for freight bill payments. •Unified forms and developed procedures to translate client specific requirements throughout seven departments. •Initiated and monitored direct mailing campaign to generate sales leads. •Audited invoicing to analyze customer’s profitability and implemented price increases. •Created written instructions and facilitated training sessions to educate clients on how to utilize our websites extensive reporting capabilities.

Cedarburg Wi

•Responsible for developing, assessing and prospecting new & existing client business to meet sales and profit objectives.•Established prospect base of 2,200 clients and setup a database to monitor customer activity.• Assisted clients in creating and implementing marketing plans and promotions.•Prepared quotes, proofed orders, and attended press checks with clients.

Cedarburg Wi

•Managed inventory for three locations; transfers, adjustments, BOM, physical inventory and reconciliation. Established a physical inventory variance of <1%. •Coordinated importation of products from France. Resolved customs and FDA issues.•Managed customer service and warehouse associates. •Decreased order-processing time from 4 days to 48 hours and reduced shipping errors by 75%. •Responsible for logistics budget and negotiating contracts. Reduced logistic costs by 24%. •Developed sales forecasting method to improve inventory management. •Collaborated with marketing manager to create monthly promotions. Assisted Marketing manager in the planning and execution of annual trade shows.•Established reporting parameters and analyzed sales reports, three year forecast, monthly budget, CO-OP rebate and commission report. •Implemented EDI process with key customers. Ensured routing guide compliance.•Responsible for implementation of inventory/accounting software, establishing reporting parameters, troubleshooting hardware and software, training and written procedures.

Theinsville Wi

•Managed inventory for three locations; transfers, adjustments, conversions, BOM, coordinate physical inventory and reconciliation. •Maintained accounts receivable for two companies; estimating, invoicing, applying cash. •Responsible for implementation of inventory/accounting software and establishing reporting parameters. •Created monthly newsletter, member of the safety committee and coordinated company functions for employees and customers.

Associate’S Degree, B To B Marketing

Computer Operations