Julie Leaf Email & Phone Number

United States

• Participate in data requirements gathering discussions with data consumers.• Develop and maintain SQL queries and scripts to extract, manipulate, and transform data from various sources, ensuring data quality and consistency.• Analyze data sources and document the outcome of data analysis to meet the requirements of the department engagement.• Maintain and support monthly data extracts and reports.• Conduct analysis and provide actionable recommendations to the business that will support strategic decision-making.• Create and maintain business objects reports and dashboards using tools such as Business Objects and Tableau, as needed.• Participate in discussions to explain/demonstrate to data consumers how the data interfaces/models are meeting their requirements.• Participate in user acceptance testing on behalf of data consumers as necessary.• Represent department on various cross-departmental projects as an active contributor and supporting resource.

Saint Paul, Mn

• Participate in encounters reporting efforts for UCare. Develop, improve, and monitor reports and analysis related to encounter submission performance and other assigned projects.• Maintain strong understanding of encounter submission requirements (DHS, CMS, MDH & Exchange) per associated contract. Work with UCare internal staff and Delegates to ensure any proposed changes to encounter submissions are remediated. Work with Information Technology (IT) to ensure submission process is compliant and deadlines met. Help implement changes and improvements developed by the SCRUM team.• Monitor completeness of the encounter submission, including both UCare and delegate claims, through a reconciliation process. Identify variances through reporting and resolve through the Encounter project team.

Greater Minneapolis-St. Paul Area

• Established pricing for the Allina hospitals• Worked with chargemaster staff, hospital department managers, and hospital finance staff to gather information about the services represented by the charge codes.• Gathered, processed and analyzed Allina Hospital and industry data to help develop appropriate pricing for hospital activities.• Assisted in the price change process, including preparation data files of prices to be loaded and follow-up reporting to ensure accuracy and identify discrepancies.• Summarized the gross revenue impact of pricing changes, for both individual changes and at a project level, and participate in the communication of these changes to the sites and other interested parties.• Maintained the central database of Allina Hospital prices.

Greater Minneapolis-St. Paul Area

Support management planning and decision making by identifying, maintaining, and evaluating information. Utilize strategic pricing applications to maximize reimbursements, analyzing and researching reimbursement issues, custom report design, internal audit, and general support of the Financial Planning & Analysis Manager and Senior Financial Analysts• Defined financial situations by completing quantitative analysis.• Prepared financial reports by collecting, formatting, analyzing, and explaining information.• Analyzed health care costs and utilization trends to maximize ROI.• Analyzed Federal and State level reporting requirements and prepares report filings as well as documenting Filing procedures as they applied to Gillette.• Oversee the calculation of estimated patient net revenue and account receivable reserves for monthly, quarterly and annual reporting and budget.• Analyzed various options and create reports to help departments decide which should be implemented.• Formulated proforma analysis on new business expansions.• Provided analytical expertise including research, accurate interpretation, documentation, and training.

Greater Minneapolis-St. Paul Area

Provided support to Senior Financial Analysts by collecting, analyzing and interpreting data. • Collected, validated, analyzed, interpreted, and organized various types of data into meaningful reports and/or summaries for various uses • Designed, developed, test and deployed standard and custom reports to internal and/or external end users for strategic and operational analysis.• Used statistical analysis and other data analysis methods to identify quality issues and possible solutions or process improvements.• Defined department specific report requirements and performed supplemental process and business analysis as required.• Worked with other analysts to profile data and develop data quality definitions, thresholds and certification procedures.• Participated in discussions concerning data collection, design, methodology, and data analysis.• Analyzed the integrity of data, including data extraction, storage, manipulation, processing and analysis.• Updated and created training materials and executed reports in accordance with the various system release cycles.

Roseville, Mn

Elicit and fully document end user requirements and test cases using a variety of techniques, including interviews, document analysis, business process descriptions, use case scenarios, business analysis, task and workflow analysis. Created complex customized reports as requested. Maintained and updated data in ERP system.• Created documentation to ensure all requirements for corporate and legal letter campaigns were met, testing and constant review for accuracy. Worked with letter vendor to facilitate timely turnaround.• Responsible for several monthly and daily reports as well as requests for customized information.• Created spreadsheets in Excel pulling data from various sources including SQL. Use formulas, vlookups, pivot tables, charts / graphs and many other Excel functions as needed to make data easy to understand.• Wrote business process documents and managed projects from kick off to post implementation testing. Performed quality testing throughout project as well as pre and post implementation testing.

Seized an opportunity to start my own business offering Professional Pet Sitting services in the Stillwater area. • Over 30 clients at the end of first year of business• Designed all marketing and promotional materials• Calculated and paid quarterly Income Taxes and managed all financial records• Actively sought new business and areas of growth

Managed all corporate price lists. Consistently delivered a quality product on schedule. Facilitated quarterly corporate price list and product training. Managed McAfee’s Promotional price lists and worked with Global Pricing Administrators on strategy and maintenance.• Coordinated all new product and product change releases. • Designed, created, managed and generated several corporate price lists (and other specialty price lists on request). Significantly improved product and SKU understanding by detailed communication and training.• Managed dBase SKUs / part numbers set-up, structure and pricing as well as dBase Administration position. Enhanced data quality through automated data quality checks through SQL / Excel.• Created processes to ensure proper set up of fields. Significantly decreased errors in revenue recognition.• Implemented queries to ensure proper set up of export requirements / ECCN codes for all SKUs. Resulted in ability for shipping to follow U.S. export laws for each product line. • Created customized complex queries, tools and reports, queried relational databases for product sale, analysis and trend report details. Enhanced sale team ability to see customer details and trends.

• Maintained quarterly Corporate PriceList, Excel based with Macros, consistently met quarterly deadlines.• Quarterly training on Corporate PriceList • Created and manage all corporate SKUs in system’s database.• Weekly reports for Management.• Experience in Excel (Intermediate), Office 2007 (Intermediate), Epicor, Salesforce.com, WebCom CPQ• Successes: consistently met all scheduled deadlines, assembled a team to proactively handle new SKU requests and define requirements for Manufacturing/backend systems

Managed Data Processing Department, including employees and workflow. Created all documentation and procedures, including processing requirements for phone card and gift card data. Maintained and established customer relationships. Over 18 years of employment with Taylor Corporation.• Facilitated department growth from 1 employee to 4 employees by time of departure• Created all documentation and requirements for the processing and encoding variable data received from a variety of customers in diverse formats• Experience in Excel (Intermediate), Office 2003 (Intermediate), FoxPro, FTP