Supporting Colorado and Washington Markets

Quality DepartmentSupporting Stroke Service LineTableau Updating and Creating Data Analysis/Ad Hoc QueriesTJC Data Upload Clarity to Caboodle query conversion

For Coordinated Care (Centene Corp)

● Updated monthly scorecards and provided insights on dashboard● Created and maintained PowerBI visualization using multiple data sources● Automated data process using SSIS packages ● Analyzed empowerment data and created PowerPoint slides● Produced a complex analysis using discount data and FX pricing data

● Maintained and manually updated LinkedIn database● Assisted with monthly, quarterly, and weekly cadence reports using MSPeople● Helped resolved data and report request that come into HRReport mailbox● Participated in UAT for ManagePoint HR Reports

● Designed weekly and bi-weekly scorecards for Customer Care and Reverse Logistics departments ● Managed weekly scorecards for executive team● Ran customer reporting and added analysis to report● Assisted with PowerPoint presentations and designed charts ● Suggested and improved reporting solutions for co-workers

● Helped solved data discrepancies, account access, and reporting issues● Participated in UAT testing for new version of MSSales● Documented new process and updated existing documents ● Supported MS Cloud issues and dropped escalation rate from 70% to 20%● Became MS Cloud SME and provided support for offshore analysts

● Developed a monthly dashboard from MSSales and field inputs● Created and trained a sell through data report using data from GFK● Supported tablet tracker tool using Sharepoint and Excel● Assisted in channel mapping project by gathering data inputs

● Converted a reporting suite from Crystal Report to SQL/Excel ● Reviewed and updated SSIS packages from Salesforce to SQL Server● Ran an API program to bulk update records in Salesforce● Constructed reports using Salesforce data and designed bar charts with Salesforce data● Saved users a few hours of work by implementing SQL/Excel reports

· Design and conduct analysis, interpret results and synthesize recommendations the influence business decisions.· Design and maintain easy to read reports that visually display key metrics or trends.· Implement, track, and report on key performance metrics to deliver stated company objectives· Identify the necessary data and equations to answer business questions.· Work with others to obtain data or merge existing data sources to obtain needed data for analysis.· Translate business questions into definable metrics and vice versa. · Import, clean, and transform data into Analytics database· Articulate numerical data in a business friendly manner.· Test hypotheses with numerical data, and identify problem areas using analysis.· Create documentation as instructed using standard procedures· Manage long and short term data projects.· Identify new areas for analysis and opportunities for efficiency.

• Updated and maintained Sharepoint site for US Ops Finance Team• Documented reporting process and procedures• Managed month end financial reports and other one-off reports • Worked on pulling data from Mercury • Created and supported midyear forecasting templates

Run weekly reports Ad-hoc queries from SQL or MDXRun SSIS packagesHelp with access to reports or any discrepancies with reports

Controlled ACS Issue Log and maintained five day service-level agreement Managed Retail Dispute Process and improved the splits process by updating stored proceduresUndertook a documentation project that documented seventy manual processes Created automated reports using Excel VBA and decreased the number of ad-hoc reportsSetup over one hundred products in a month and validated all products in the system

Managed Customer Assistance Portal access and assisted with all technical supportManaged Change Management System and ensured all projects maintained schedule using specialized reports and constant communication with multiple lines of businessAnalyzed system tools and processes Maintained past due tasks and kept past due tasks under one hundred and fifty Created/designed specialized reports using SQL, ASP.NET and Visual Studio

Created reports using Excel and worked with pivot tables in ExcelAudited several Starbucks distributor accountsWorked with customers to resolve pricing errors and pricing identificationDecreased one hundred and ninety distributor accounts in three months