Susan Austin Email & Phone Number

Los Angeles, Ca, Us

Some of what I have been working on for my clients.• Developing dashboards in Power BI with medical data so the client can communicate more effectively with their clients on how well each medical provider group is performing to state regulations.• Working with a small non-profit creating both digital and print event maps.• Creating customer feedback surveys and collecting the responses for an event so the client can improve their event going forward.

Oakland, California, Us

Temporary, fully remote, agency placement through Sedaa Consulting to create dashboards using Microsoft Power BI in the Compliance Strategy & Governance department.• Designed a department financial dashboard in MS Power BI wrote DAX formulas to format the data. This is used ensure department stays on the budget to for financial reporting to senior leadership.• Pioneered a dashboard in MS Power BI to show the utilization of an internal application and the trend in reducing the number of calls to the help line.• Compiled multiple MS Excel reports into a single file and created a dashboard in MS Power BI to show the open and article click-rate metrics for a daily, emailed employee newsletter.• Connected to a MySQL Server, utilized a query, and created dashboards to show the status of internal employee training courses.• Developed new SharePoint pages in SharePoint Online to migrate current pages, data, and files to the new platform.• Collaborated with a team member to document the process for uploading templates into an internal system in MS Visio.

Rosemead, Ca, Us

Temporary contract position (Project Regular) in the Customer Service Information Governance Department planning and creating CCPA reports for state law compliance.• Wrote a comprehensive training document used by administrators to follow established processes in the creation of California Consumer Privacy Act (CCPA) personal information reports.• Created a database search and compiled customer data to fulfill over one hundred CCPA Personal Information reports for customers since Jan 1, 2020, within 20 days of the initial request.• Developed a dashboard in MS Power BI utilizing DAX modeling techniques and incorporating feedback from senior leadership to make it easier to read; sent weekly to senior leadership to update them on CCPA program status.• Improved the process of CCPA report creation by creating a macro in MS Excel to format CCPA reports, which reduced report completion time from 1 hour to 10 minutes. This also mitigated the risk of the “copy and paste” method which could result in a customer receiving the wrong data.• Collaborated with outside vendors for printing and mailing paper copies of CCPA reports.• Conducted UAT testing on CCPA page imbedded within SCE website. Collaborating with the team on issues and working with outside vendor to fix bugs.• Created newsletters in Canva to keep stakeholders up to date on the project progress during the planning phase of the project.• Worked with the team to screen resumes and interview contactors that were added to the team.

Los Angeles, Ca, Us

Temporary agency placement through Syndicate Bleu to prepare and track client donor data files for print and digital marketing campaigns.• Compiled data from numerous sources into a comprehensive single daily project tracking report utilized by senior leadership to resolve issues within the client data file process for on-time delivery.• Created custom selection codes in Sales Force which were utilized to communicate with vendor which segments of the donor data to use for each campaign.• Edited and formatted client donor data files for monthly print and digital direct marketing campaigns.•Performed quality assurance on data files to ensure client data was mapped to the correct print field for monthly print direct marketing campaigns.

Oakland, California, Us

Managed software/hardware upgrade and paper records management projects within the Supply Chain Buy to Pay Department.• Successfully implemented a paper medical records retention process for the Kaiser Permanente Southern California region, resulting in an annual cost savings of $2.5M. • Developed and implemented the project plan for the hand-held scanner software and hardware upgrade project. Facilitated and ensured couriers received all equipment and training throughout all Kaiser Permanente Southern California region medical facilities, resulting in 90% communication improvement between couriers and dispatch.• Created the strategy, implemented and guided the divested regions business and medical records project through all phases, resulting in an operational cost reduction of $336K.• Managed allocation of $3.7M budget for the Southern California region medical record retention project.• Created presentations to effectively communicate to senior leadership, and project sponsor the budget and the project status.• Scheduled and facilitated project team status update meetings.• Tracked action items for each project, followed up with team members.• Liaised with the procurement department to facilitate obtaining iPhone's, email accounts and attachment for courier hardware/software project.• Developed standard operating procedures (SOP) for standardization of processes and trained staff.• Managed project budgets and worked with accounts receivable and payable departments to ensure payments were made on time.

Bachelor Of Science - Bs, Organizational Leadership

Associate In Arts, Fashion/Apparel Design