Penny Johnson

*** **** *** *

St. Paul, MN *****

651-***-**** acrov3@r.postjobfree.com

Summary Statement

Takes Leadership and ownership of project assuring quality and timely execution.

Excellent communication skill with internal and external client. Received numerous awards for Excellence.

Quickly learns new software technologies.

Skills: Software: TSO/ISPF, JCL, MVS, CICS/ESA,TSM, Autosys, Westlaw/ERD, UAT Testing, Using Data Modeling Techniques, Database Basics & Design,, Intro to Agile, Visio

Clearance: Data Privacy, Confidential

Communication: Lotus Notes, Lync

MicroSoft: MS Office 2010/2013/365, Excel 2010/2013 (Formulas, Pivot Tables, VLookup), MS Power Point 2010/2013 Adv., Quick books,

Relational Databases: MS Access, Access Forms & Reports, Access Queries, Boolean Queries, SQL Language, SQL Queries, MySQL, TSO (Dev, UAT, Prod), JCL, PeopleSoft Oracle, SAP/ERP,

Operating Systems: Windows 9X/NT/XP/VISTA/ 7/8, Unix (exposure).

Business: Managing Business Requirements, Data & Process Modeling, Intro to Business Analysis

Drives: HP, IBM, StorageTek, Sun Systems, AS400, Tandem, Optical disks, Timberline, L7.

Knowledge: Cisco Related Series By Mindleaders BCMSN 642-811, Data Warehousing, Hardware & Operating System, UNIX, UNIX Systems Administration I, II.

Experience

3M, Maplewood, MN June 2014 – Mar. 2015

Source to Pay/IT Analyst I/Business Analyst

Updated locations & addresses of vendors using an Access database and SACR.

Queried PeopleSoft to pull-up vendor info.

Worked with internal clients to resolve PO issues.

Updated UOM (Unit of Measure) using PeopleSoft.

Worked with Excel Spread Sheets and Pivot tables.

General Mills International, Golden Valley, MN Feb. 2012 – Dec. 2013.

Indirect Procurement Shared Services/Purchasing Agent/Business Analyst

Helped with Fiscal Year-end.

Change Requests, Change PO, Cancel PO, Release a Service PO Commitment using BMC Remedy.

Helped resolve Price & Quantity Blocks, PO Exceptions and Aged Report in workflow on SAP/ERP.

Buyer

Helped a product service area meet its deadlines on co-managed products for its client. Placing orders for dry, frozen and pizza product. Ran SAM report on SAP/ERP.

Changed product orders on SAP/ERP. Used GL on Excel Spread Sheets.

Database Specialist

Helped create a global database on SharePoint site using excel and dashboard.

Created private directory DNB.

Imported Files on to a SharePoint site.

Rasmussen College, Bloomington, MN Dec. 2011 – Jan. 2012

Web Testing

Web testing, user acceptance testing (UAT), research for marketing group.

Questar Assessment, Inc, Apple Valley, MN Mar. 2010 – Pres.

Scorer

Scoring various ESL essays and tests for K-12 grades on SharePoint using ScorePoint.

US Bank, St. Paul, MN Sept. 1999 – Mar. 2009

Computer Operations 3/Systems Analyst

Monitored and satisfied all media requests for production, mid-tier and open systems using various tape drives (IBM, HP, AS400, Sun Systems and StorageTek.) In an Enterprise environment for the Command Center.

Processed all foreign and in-house tapes; tracked shipments. Degauss hard drives and tape media. Audited, filed physical media; researched audit items using QwikScan and TMS.

Logged and tracked shipments for management reports using Excel spread sheets.

Generated incident tickets and completed activity records for internal client using Remedy software. Informed management of all activities or issues.

Documented QA for audit purposes. Trained peers, kept documentation current online with company policy.

Numerous reviews leadership and ownership of my projects to completion was noted by managers.

Expedited the resolution of media issues by directly communicating with the impacted department.

Thomson - Reuters, Eagan, MN Sept. 1990 – Aug. 1999

Database Specialist/Analyst

Communicated and prioritized with other groups and departments and reported project status or system problems.

Utilized a broad array of JCL to assist with database activities, audit, character count, compare, embedded reference, null, production load, QA, report verify, sort, document selection, descriptor building, strip ampex, and test load. Converted EBCDIC to ASCII.

Utilized a broad array of software packages (i.e., database, project management, presentation) to assist with database and administrative activities. Initiated and resolved text conversion errors through production database load verification. Recognized and resolved highly technical WESTLAW/CD-ROM data problems.

Understand ongoing system changes and enhancements and communicate these with others.

Supported Database Supervisor with problem reporting, record keeping, and status summaries.

Analyzed department projects procedures and processes and made suggestions for continued improvement. Updated and maintained databases. Analyzed and troubleshot data for test and production loads. Assisted coordinator in procedural documentation and communication with overseas vendors regarding data questions. Resolved data issues. Updated and wrote procedure manuals for projects. Wrote mnemonic specifications (key boarding resource) for overseas vendors through clear instructions.

Trained peers.

Education

Certificate in Business Analysis University of Minnesota, St. Paul, MN

BA in Org. Management & Communication Concordia University, St. Paul, MN

Contact this candidate