Angela Harkness

Experience

• 

  CWU Financial Aid

  Jun 2012 - Aug 2012

  Office Assistant

  •Assisted with the reorganization of three different departments and prepared and tracked their budgets, payrolls and expenditures using Excel •Given duties previously done only by financial aid counselors such as manually awarding students and auditing files•Customer service skills required in assisting parents and students •Professionalism and good oral and written communication skills necessary in daily communications

• 

  Wetpaint

  Sept 2012 - Sept 2013

  Analytics Intern

  • Project management stressed as the analyst largely responsible for client-facing analytics which required fulfilling their requests in addition to coming up with analyses that would be beneficial• Has acquired in-depth knowledge on social media and its associated business intelligence metrics as well as how social media relates to being profitable for a business• Distributed multiple dashboards with insight summaries on a daily basis, using appropriate KPIs • Created dashboards using a combination of SQL, Excel and PowerPivot• Familiar with analytic tools like Google Analytics (GA), Excellent Analytics (EA) and Omniture and knows how to segment and export data• Analyses have covered multiple channels: Facebook, Twitter, Google and Google+• Ran analyses related to Search Engine Optimization (SEO) experimentation Show less

• 

  Amazon

  Oct 2013 - Dec 2013

  Buying Analyst

  • Identified and resolved vendor disputes• Used forecasts and other variables in preparing seasonal as well as non-seasonal orders• Assisted with the reorganization and subdivision of products as they appear on the website• Investigated requests from vendors and Amazon employees regarding duplicate listings

• 

  Milliman MedInsight

  Jan 2014 - now

  MedInsight Senior Client Services Program Manager

  • Direct contact, managed client data in production and UAT environments• Transitioned clients from on prem to Azure Databricks• Highly experienced with the ETL process, reviewed and modified existing code • Managed various client software products• Assisted and led implementations • Partnered cross-functionally on a daily basis both to technical and non-technical team members• Managed a variety of healthcare clients both in size and in market segment• Knowledgeable with healthcare data and industry solutions/tools• Prepared ad hoc reports that were published • Conducted general training for clients with occasional dives into deeper topics like healthcare risk• Experienced with SharePoint and Salesforce• Experienced with various ticketing systems like Happy Fox, YouTrack, ADManager and Azure DevOps• Analyzed large data sets via SQL Server, Microsoft PDW and Databricks • Created and modified SSIS packages• Responsible for much of the file intake process and incoming data issues• Peer reviewed other people’s work after obtaining Signature Authority• Signature Authority centered around understanding risk management both for the client and individual projects, passed the required auditAccomplishments:•Excellence Award Q3 2018•Signature Authority Q3 2021 Show less