Julie Leaf Email & Phone Number

• 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.

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.
• 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.
• 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.

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.

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.
• 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.
• 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.

• 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.
• 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