JOANNE SHULL - ** Pingree Hill Road, Derry, NH ***38 603-***-**** (c)

acvk4e@r.postjobfree.com http://www.linkedin.com/in/jshull

JSBBVEIS/125540957 – Administrative Assistant Data, Waltham, MA (Full Time) (Actifio, Inc.)

Detailed-oriented and reliable data reporting analyst/senior administrator seeks full-time and possibly remote part-time position in providing the following assistance:

-Enter data into specific data fields using specific software programs.

-Verify accuracy and completeness of data being presented.

-Maintains training plans/paths for various department positions.

-Monitors and reports employee training status.

-Compares data entered with source documents, or re-enters data in verification format on screen to detect errors.

-Deletes incorrectly entered data, and re-enters correct data. May compile, sort, and verify accuracy of data to be entered.

-Track documents received and completion dates.

-Reviews drafts and finished documents for appropriate grammatical usage;

-Writes production reports based on data compiled, tabulated and computed, following prescribed formats.

-Collates, processes and stores data appropriately into computer system or provided storage for subsequent entry with the use of provided software programs

-Inputs customer or product related data and applicable operational documentation for the company.

-Verify accuracy of data inputted into the database.

-Completes reports and backs up files.

JOB DUTIES FOR ADMINISTRATIVE ASSISTANT

-Maintains and controls department training files.

-Performs a variety of secretarial and administrative duties for senior managers.

-Answers questions relating to office operations and established policies and procedures.

-Assist in maintaining accurate overtime distribution listing for the department.

-Miscellaneous filing.

-Support HR functions of on-boarding new employees and setting up benefits, etc.

-Provide administrative support by performing standard, advanced & confidential administrative duties requiring broad experience, skill, & knowledge of organizational policies & procedure.

-Review documents, reports, forms, records or other materials for content, completeness and accuracy.

-Locate, compile information and format reports, records and other sources of information.

-Candidate must also take initiative and have the ability to prioritize, attention to detail and excellent analytical skills are required.

-Performs clerical activities which may include answering and directing phone calls, taking and distributing messages, receiving, sorting and distributing incoming and outgoing mail, maintaining filing systems, photocopying, scanning and faxing, and checking and entering data.

QUALIFICATIONS, SKILLS AND ABILITIES

-Bachelors’ Degree and extensive senior administrative/analytical experience

-Strong user of MS Office applications: Word, PowerPoint, SharePoint, Visio, Advanced Access, Advanced Excel); PeopleSoft; Remedy; SAP Business Objects, Salesforce (generalist); RDBMS baclground

-Experienced migrating data from various sources (SAP Business Objects, PeopleSoft, SalesForce, Oracle Inventory) into Excel and performing data sorts, cleansing; also utilizing Access for additional sorting and data validation

-Calendar and meeting management, event organization, advanced administration

-Exercise judgment to shift priorities and organize multiple tasks simultaneously

-Strong proofing skills when reviewing and/or editing documents for accuracy and completeness

-Maintain confidential information

-US Citizen – able to pass Background Check and Substance Testing

WORK EXPERIENCE

9/2015 – 2/2016

NaviSite/TWC Data Center Administrator/VP & Directorate Support Andover, MA

-Support Data Center Director, local manager and data center employees in Facilities Management

-Create reports and graphs from a number of databases (Oracle, Remedy, Concur, PeopleSoft)

-Coordinate customers and visiting executive and customer needs, ensuring meeting venues and conferencing

-Project tracking, purchasing, procurement; track efiles and hard copy reference materials

-Proofreader, write, editing, test, technology knowledge, special projects

-Integrate TWC managerial, budgeting and financial policies and procedures

03/2015 06/2015

EMD Millipore/Merck Data Analyst/Administrator Compliance Dept., Billerica, MA (Randstad Contract)

-Supported 2 lawyers and senior reporting analyst for EMD Legal Compliance Department

-Assisted in development of federally mandated regulatory reports to CMS (Centers for Medicare & Medicaid Services) tracking relationships with teaching hospitals

-Imported CMS data for Excel comparisons; performed VLookups to check and cleanse data; prepared regulatory report submissions, compiling, organizing and extracting data for comparison to customer data (Oracle, SalesForce)

-Track reporting deadline through knowledge of regulatory compliance laws

-Log patent application initiatives; maintain timeline and matrix

-Utilized MedPro and CMS third party databases to confirm medical status and taxonomy codes

-Initiated use of Excel Power Query app to set up data and compliance legal libraries for department

07/2014 Present (volunteer)

Study Group Coordinator/Blogger for PMP and SalesForce Admin Certification Preparation, Derry, NH

Assist with LinkedIn blog groups seeking to prepare for certifications; network about upcoming project management and software skill sets; share information about SQL and VP coding

4/2014 6/2014

Philips (Supplier/Manufacturing), Andover, MA Data Analyst II for Pharmaceutical Sales Project (Contract)

-Performing data cleansing and migration using SAP Master Data sets

-Performed data migration updates on SAP and SalesForce data, enabling Sales to target profitable customer bases

-Analyzed and entered record information to resolve duplicate customer records within Master Data customer database

-Updated databases (SAP and SalesForce) and Excel files using advanced spreadsheet functions (Conditional Formatting, COUNT, SUMPRODUCT)

12/2013 3/2014

BAE Systems ES, Nashua, NH Procurement Assistant/Supplier Risk Management Reporting (3 month Contract)

-Responsible for monthly Dun & Bradstreet financial risk analysis of suppliers using Access database

-Performed system auditing, SharePoint site development and procedure review and development

-Utilized MS Access DB development, Noetix, SharePoint, Oracle ERP; data migration for monthly risk comparison

-Developed general SOPs; achieved goal to have data pull structure understandable for average administrator

10/2013 12/2013

Ameriprise Financial Group, Bedford, NH Customer Services Coordinator (Randstad Contract)

-Project support to Employee Financial Field Office involving archival of confidential client records

-Distributed/tracked correspondence, setup and ongoing maintenance of supervisory jurisdiction and client files, inventory, office

-machine/computer maintenance, processed expenses

3/2013 7/2013

National Visa Center (NVC), Portsmouth, NH Visa Processing Specialist (Contract)

-Created unique computer record of each immigrant visa petition to NVC from the Immigrant and Naturalization Office

-Utilized analytical and data reporting skills; performed investigations

-Handled daily work according to productivity and quality mandates from Department of State

8/2012 3/2013

Various Agency Contract Positions

Temporary administrator/project coordination positions (communications, data migration; HR health enrollment benefits; data

Migration and database reorganization in mortgage environment, event management, technical customer service support)

Position durations ranged from 1 to 4 months in length

1/2008 8/2011

National Passport Center/Department of State, Portsmouth, NH Passport Specialist (Federal Government)

-Responsible for thorough review of passport applications

-Applied rules and regulations of the FAM (Foreign Affairs Manual)

-Applied SOP and passport law for adjudication and in determining derivative citizenship

-Network Knowledge: SharePoint / Databases: CCD, NLETS, TDIS, LexisNexis, CLEAR, various law enforcement databases

3/2002 11/2007 (2 positions)

Lockheed Martin IT, Nashua, NH - Senior Program Analyst, FAA Configuration Management

-Responsible for reviewing/updating CAD drawings and change specifications within FAA's buildings and towers; mark up hard and electronic copies; submit to CAD for printing and e-filing; distribute to relevant FAA facilities staff; maintain and updated

E-drawing libraries; plans and specifications; document radar changes and logistics within air traffic tower configuration changes (ARTCC)

Lockheed Martin IT, Burlington, MA - Senior Program Analyst, STARS FAA Program

-Provided program management support to the FAA (Federal Aviation Administration) New England Region

Terminal Business office (ATB ARTCC); achieved goal coordinating integrated terminal air traffic control capabilities

-Identified/tracked project status and cost issues under direction of Senior Project Engineer and Program Manager

-Updated project information via ODBC connection between Oracle and Access databases

Contact this candidate