Philana Williams

Experience

• 

  University of Southern California

  Mar 2017 - Jun 2018

  Digitized a wide range of rare materials from rare manuscripts using highly sophisticated imaging equipment, permitting these materials to be accessible via the USC Digital Library website. Post-processed digitized files to ensure accuracy and completeness, using Adobe Photoshop, Adobe Camera Raw, and Adobe Bridge Catalogued collections of 4000+ digitized items, using Content DM project client, allowing these documents to be searchable via the USC Digital Library website

  • USC Digital Library: Imaging Assistant

    Dec 2017 - Jun 2018

  • USC Digital Library: Metadata Assistant

    Mar 2017 - Mar 2018
• 

  SierraConstellation Partners, LLC

  Mar 2018 - Sept 2019

  CRM Administrator/Marketing Intern

  I verified and reconciled data entered into our CRM system and aided the migration of data into our CRM system from other platforms (Outlook, Excel, G-suite, MailChimp, etc). I assessed various options for optimizing and customizing our CRM system to aid the workflow of marketing managers and consultants

• 

  PwC

  Jun 2018 - Jul 2018

  Start Advisory Intern

  Collaborated with our human capital team to assess and meet demand for advisory resources within our Industrial Products and Services market team of 1500+ people. Aided staffing decision by pulling availability, project end dates, and scheduling information from Microsoft Excel and other firm specific software on a weekly basis. Engaged in corporate responsibility by teaching middle-school aged children about financial literacy and budgeting

• 

  University of Southern California

  Dec 2018 - Dec 2019

  USC Trojan Marching Band: Section Leader

  I host weekly sectionals in order to boost the overall playing ability of the clarinet sectionI participate in performances that invigorate school spirit, fundraise, and/or support local community eventsI manage and allocate the limited supply of 18 clarinet players to perform at over 100 gigs throughout the school yearI set and communicate expectations laid out by band leadership to our beginning and general membersI hold myself and others accountable for being a model of musicianship and upholding the Trojan Marching Style Show less

• 

  PwC

  Jun 2019 - Aug 2019

  Forensic Technology Solutions Intern

  Loaded, verified, and reconciled large volumes of data from multiple enterprise data sources using SQL serverProfiled enterprise data for data quality, and corrected data quality issues using Alteryx Designer, a data transformation toolCreated visualizations using Tableau Desktop, in order to summarize key insights from large volumes of enterprise data

• 

  University of Southern California

  May 2020 - Dec 2021

  I provided supplementary instructional support for students taking ISE 382 -- an introductory database systems course. Duties and responsibilities included hosting office hours, exam reviews, and providing timely feedback on ERD models and SQL scripts. Debugged code and provided technical support for students taking ITP 115-- an introductory programming course taught using python Provided timely feedback on student programming assignments and evaluated them for performance, code structure, and styleRegularly communicated student performance and concerns to course instructors to facilitate a better student experience Developed python grading scripts and provide weekly feedback for the 75+ students taking DSCI 510 — an introductory programming course offered to graduate students in the Data Science program. Collaborated with a project team to develop a website for the Center of Systems and Software Engineering at USC.For this project we use HTML/CSS and other technologies for web development and GitHub for project workflow and version control.Project members were also responsible for submitting daily reports to our project lead for progress tracking purposes

  • Course Producer for Database Systems: Concepts, Implementation, and Design

    Aug 2021 - Dec 2021

  • Information Technology Program Teaching Assistant

    Aug 2019 - Dec 2021

  • Computer Science Teaching Assistant

    Aug 2020 - Dec 2020

  • Center for Systems and Software Engineering: Developer

    May 2020 - Aug 2020
• 

  PwC

  Jan 2022 - now

  I use my background in data analytics to help clients fulfill financial reporting requirements required for mergers, acquisitions, and divestitures.

  • Deals Technology & Data Solutions Senior Associate

    Jul 2024 - now

  • Deals Technology & Data Solutions Associate

    Jan 2022 - Jul 2024