Jennifer A McClelland

Media, PA, US, *****

Summary:

●15 years of experience in a successful office environment working as a Data entry specialist, Excel specialist using VLOOKUP and pivot tables as well as formulas, sort, filter and IF statements.

●File New hire paperwork, background checks and add new hires to Active Files.

●Worked with data sets as diverse as customer relations and data, gathering, analyzing and verification of marker data in different marketing capacities.

●Worked with SharePoint and Ariba at Teva and Jansen Research Master Data recording and manipulation.

●Utilized SAP for publishing and data updating, as well as data analysis. And Master Data.

●Excel and Word for label verification and design At IMS Health, enters data into database which may include scanning and uploading of documents.

●Corporate Debt Collection composed correspondence, compiled, and coordinated pertinent documents.

●Create excel spreadsheets to track customer tax eligibility.

●BRQC CAPA Forum Coordinator Schedule and prepare meeting, gather data from Track wise and CAPA weekly tracker, organize presenters, prepare PowerPoint presentation, rollcall for meeting, prepare meeting minutes utilizing Word, Coordinate CAPA Forum Membership.

●Recorded Transfers and Exchanges regarding American Funds.

●Phone Bank Experience in getting out the vote for Delaware County Republican Party.

Technical skill:

●Proficient in all aspects of Microsoft Office; Word, Excel, Power Point, Outlook

●SAP entry, publishing, reporting

●Track wise Queries

●SharePoint and RND Docs

●Typing speed – 7200kph.

Education:

American InterContinental University – Hoffman Estates, IL – Aug 2009

●Associate of Arts in Business Administration – GPA: 35

Certifications:

Mastering Data Analysis in Excel – Duke University (Coursera) – Feb 2016

●Communication with Tableau Duke University (Coursera) – Apr 2017

Professional Experience:

Sitel Customer Service

October - December 2022

●Zendesk chat 2 chats simultaneously

●SAP Epiphany CRM, Customer Loyalty app and assistance

●Salesforce updating customers sales and data

NewYork State Office of Temporary Disability Assistance

May 2021 – Feb 2022

Emergency Rental Assistance Program Housing Specialist/Data Entry/Remote Guide house

●Update and electronically file supporting documents

●Support the ERAP applications and move applications toward next steps utilizing VLookup and arranging pivot tables

●Work with confidential data of applicants

●Communicate with applicants as to which documents are still needed for qualification

●Pod B Brooklyn Borough LRAP 2

●Data Entry of notes and equations to move applications toward payment

Pfizer Collegeville, PA

Apr 2019 – Aug 2019

Central Records Assistant

●Update and File New and updated records for US and Puerto Rico Utilizing Excel files Vlookup and IF Then Formualas

●File New hire paperwork, background checks and add new hires to Active Files

●Select and Archive terminated employees 2017, 2018, 2019

CertainTeed/Saint Goblin Malvern PA

Oct 2018 – Jan 2019

Human Resource Assistant

●Creation of New Hire Employee Files

●Archival of Terminated Employee Files for 2016 2017 with Iron Mountain

●Set up and maintain candidate files Utilize Excel Files and pivot tables

●I-9 Audit of Siding Employees

Glenmede Tax Department Philadelphia, PA

Feb 2018 – May 2018

Tax Administrative Assistant

●File Tax with taxing Authority State and Federal

●Organize tax forms to be sent

●Mass mailing of 1099

●Spreadsheet to track 1099s returned research of 1099s returned Excel Pivot Table

●Scanning and uploading of documents in Gforce (Salesforce for Glenmede)

Teva Pharmaceuticals Frazer, PA

July 2017 – Sept 2017

Data Entry III Document Control Contracts Procurement Department

●Load Contracts into Ariba for Master Data Analysis

●Keep record of progress and data concerning uploaded contracts in Excel Utilize VLOOKUP and sorting and filtering

●Report Progress in Excel with spreadsheet covering the project

Janssen a JNJ Company Spring House PA

May 2016 – Dec 2016

Data Analyst/Quality Control Research and Development

●Quality Check Data for Pharmacovigilance System Master File utilizing Excel

●Data Cleanse list of all audits Utilizing Excel

●BRQC CAPA Forum Coordinator Schedule and prepare meeting, gather data from Track wise and CAPA weekly tracker, organize presenters, prepare PowerPoint presentation, rollcall for meeting, prepare meeting minutes utilizing Word, Coordinate CAPA Forum Membership

●File PSMF Data in RnD docs

●2017 Audit Schedule Spreadsheet and Pivot Tables

Paychex Norristown, PA

Dec 2015 – Jan 2016

Data Entry

●Data Verification and Entry Concerning New Clients

●Verify Data for new client payrolls

●Update 401K and direct deposit information

●Assist in entering new payroll clients’ employees

●Implementation Specialist Assistant

Arkema King of Prussia PA

Mar 2015 – Sept 2015

Product Safety and Toxicology Data Specialist

●Utilize SAP for publishing and updating Product Safety Data

●Excel spreadsheet design and implementation

●SharePoint to update certain files for Products Concerning GHS compliance

●Word formatting of Product Safety Labels

●Filing, Publishing, and confirming chemical data for Global Harmonization System compliance

IMS Health – Plymouth Meeting PA

Oct 2014 – Dec 2014

Data Researcher

●Merck Data Research and Verification

●Utilize and update Excel Spreadsheets using information researched on Google and Phoenix database

●Confirms and verifies data utilizing web resources and company data base

Precyse Wayne PA

Oct 2014

Data Entry Associate

●Access Database updating and data entry for employee skills and experience

Citizens Bank Plymouth Meeting PA

Aug 2014 – Sept 2014

Data Entry Associate

●Dispute resolution team Utilized Access Excel and Citizens programs

●Utilized Excel pivot tables VLOOKUP

Thomson Reuters Philadelphia PA

June 2014 – Jul 2014

EndNote Sales Assistant

●Customer Service Telephone EndNote Triage Team and email pdf and web content ordering

●Order Fulfillment elink and electronic shipping and tracking

●Salesforce.com and payment processing

●Customer fulfillment and EndNote Triage Hotline

●Arranged conference calls for Costa Rica and US Teams

Pfizer Zoetis – Exton, PA

Jan 2013 – Jul 2013

Data Entry Associate Document Control Specialist/Customer Service Tax Team

●Mail merge for letter requesting tax permit, scheduling and return receipt tracking

●Analyze and update data for existing customer base

●Customer Service regarding customers tax questions

●Audit for States concerning tax changes

●Create excel spreadsheets to track customer tax eligibility

●Update and manage tax permit filing Master Data

●Document Control Concerning 5013c

●Tax Team telephone contact

IMS Health Plymouth Meeting, PA

Jun 2012 – Sept 2012

Data Analyst, Billing Notification Form Team

Yoh Staffing

●Salesforce CRM

●Prepare Opportunities for BNF

●Bring opportunities to stage 6a (closed won) for inclusion in relevant revenue quarter

●Submit to Revenue Analyst and trouble shoot any questions

●Liaison between revenue analyst and Principal in Charge

●Data scrubbing for Salesforce Contacts

●Set up and coordinated Billing Notification Form Team meetings

●Excel spreadsheet tracking new closed/won contracts

Liberty News Distributors, Inc. King of Prussia, PA

May 2011 – Dec 2011

Data Entry/Customer Service

●Maintains solid customer relationships by handling their questions and concerns with speed and professionalism, track delivery for credit received, research customer disputes and correct or explain credit received

●Communicate with delivery and management regarding customer disputes

Pfizer Collegeville, PA

Dec 2010 – Apr 2011 Kelly Staffing Axelson staffing

Data Specialist

●Enters data into database which may include scanning and uploading of documents

●Ensures quality data conducts ongoing clean-up of database, verifies, tracks, and files data

●Works with team and follows up when needed; resolves issues resourcefully

●Conducts database searches and generates reports based on data Mass necessary

●Effectively prioritizes to complete tasks and avoid delays in workflow

●MS Excel and SAP and Back Office systems

●Research vendors for quality purchasing data

Kelly Staffing Collegeville, PA

Dec 2009 – Jun 2010

Quest Diagnostics

●Purchasing Ariba Implementation project

●Prepare Contracts for electronic scanning

●Excel Catalog and Account for all contracts

●Prepare all contracts for storage

●Search and organize scanned contracts for amendments

●Account for and catalog amendments

●Prepare files for Ariba Implementation

Norristown State Hospital, Chaplaincy Norristown, PA

May 2009 – Dec 2009

Administrative Assistant

●Art Show Committee

●Organize past Art Show files

●Organize past Art Show entries for distribution and sale

●Accept admissions to Art Show, Hang submissions for Art Show

●Creation of documents for chaplains

PNC Global Financial King of Prussia PA

Sept 2008 – Jan 2009

Sub-Accounting/Data Entry

●Recorded Transfers and Exchanges regarding American Funds

●Input and updated data daily for American Funds

●Excel Compiled and printed work for the day’s reconciliation of accounts

Wyeth Malvern, PA

Nov 2006 – Nov 2007

Data Entry

●Analyzed and organized vendor files, utilizing SAP and purchasing agent’s information

●Assessed data for consolidation or purging

●Communicated with purchasing agents at global sites

Reported progress

Instrumentation Associates, Inc. King of Prussia, PA

Administrative Assistant

Aug 2005 – Oct 2006

●Set-up and maintained Technicians Service, Accounting and Customer File Systems

●Processed supply orders, answered invoice inquiries and initiated credit card payments

●Entered and u0pdated Technical Service computer files

●Ordered office supplies

●Updated customer files using Quick books

●Collections

●Posted daily receipts and prepared invoices for accounts receivable/payable

Reliance Electric Service Center Philadelphia, PA

Administrative Assistant

Nov 2002 – Jan 2005

●Performed purchasing duties, researched pricing and availability, prepared purchase orders

●Prepared Excel spreadsheets for Controller and Assistant Controller

●Conducted Power Point Presentations

●Published in-house sales literature

●Corporate Debt Collection composed correspondence, compiled and coordinated pertinent documents

●Coordinated open house events and booked caterers

●Assisted and provided materials for presenters

●Coodinated shop and sales meeting luncheons

Contact this candidate