Administrative Assistant Data Analyst

Wendy Mottershead

**** ****** ****** **********, *.J. 08109

609-***-**** *****.***********@*****.***

Data Analyst

Data Analyst Professional with excellent Microsoft Excel, Word, PowerPoint and Access skills with emphasis on executive and client level presentations and spreadsheets. Analytical thinker with proven track record of process improvement abilities.

Value I bring to your organization:

Computer Skills: Proficiency in Microsoft Excel, Word, PowerPoint, Outlook and Access

Process Improvement: Streamlined or automated current processes to improve productivity

Analytical Thinker: Analyze massive amounts of data to improve processes, suggest conclusions, and support decision making.

PROFESSIONAL EXPERIENCE:

Marlectrics, Inc./P&L Alarms, Inc., Marlton, NJ

Office Manager 2014 – Present

Provide day to day running of office for Electrical Contractor, preparing bids and proposals for residential and commercial projects.

Improved office efficiency 100% by designing and implementing an Excel customer database for two (2) businesses where none previously existed.

Improved cash flow 75% by setting up accounts receivable Excel database for over 250 accounts where invoicing was previously done sporadically and inefficiently.

Horizon Blue Cross Blue Shield of NJ – Mt. Laurel, NJ 2003 – 2014

Data Analyst / Administrative Assistant

Analyzed data to create process improvements to create efficiency and reduce administrative costs.

Reduced administrative costs by 75-80% by automating multi-tier approval process for high dollar claims.

Increased financial accuracy by 25-30% and reduced processor errors 20-25% by creating Excel database for performing trending analysis and identifying training needs.

Created training cheat sheets for new clerical staff, increasing productivity and reducing the need for extensive training.

Reduced administrative costs for completion of quarterly incentive program 35%-40% by automating process for 350 non-exempt employees in 3 locations throughout New Jersey. Additionally, date accuracy was improved and approval times were expedited.

Developed program and trained management staff in the new automated process for incentive program.

Administrative Assistant

Provided exceptional administrative support to Claims Operations Department Management

Created Sales and financial presentations, spreadsheets and organizational charts using Excel, PowerPoint and Visio.

Prepared daily, monthly, weekly and quarterly reports using Excel and Access for Director.

Assisted Sales and implemented RFPs (Request for Proposal).

Managed and obtained all network securities, accesses and license requests.

Maintained inventories for all technical equipment, keys and office supplies.

Liaison to Senior Management, Sales, Information Technology and Implementation.

WendyLou Office at Home – Pennsauken, NJ 1999 – 2003

Owner/Operator

Owned and operated home virtual assistant business providing such services as database solutions, mailing lists, mail merges, and web-based services.

Computer skills:

Microsoft Word, Excel, PowerPoint, Access, Visio and Outlook

Lotus Notes, Internet Explorer, Firefox, Google Chrome

Contact this candidate