Data Analyst Peoplesoft

Nikki Rubin

*** ******* **. 314-***-**** Florissant, MO 63034

education

Bachelor of Science Business Management, Western Governors University, July 2020

Associate degree, Saint Charles Community College, January 2005 – May 2007

Professional Certification/Training

Lean Six Sigma Greenbelt Certified – December 2021

Project Management – Accelerate U – December 2020

Resume Training – Accelerate U - September 2020

Leadership Development – Accelerate U - July 2020

Business Writing – Accelerate U- April 2020

PROFESSIONAL EXPERIENCE

Ascension – The Resource Group January 2013 – Current

MDM Surgical Support, Analyst II January 2022 – Current

●Assisting team in mapping, reviewing, and cleansing over one million items to ensure items are available and accurate in Product Hub Cloud.

●Utilizing Excel daily to cleanse and compare data values using advanced functionality and formulas.

●Running approximately 80,000 items monthly through an intake tool to verify items loaded in Product Hub Cloud.

●Supporting team in the research of over 10,000 items via Google/supplier website for validation.

●Verifying and updating manufacture information to confirm it aligns with FDA.

●Submitting over 2,000 requests monthly to add items to the Global Item Master for all valid items not currently in Product Hub Cloud.

●Providing feedback on over 100,000 items to the Health Ministries advising of those items we’ve mapped in Product Hub Cloud as well as the items needing more information to validate accuracy.

MDM Contract Cleansing, November 2021 – January 2022

●Managed and maintained all item changes and additions on a daily basis.

●Cleansed item descriptions by removing special characters, assigning nomenclature, and adding additional descriptive words necessary to accurately identify an item.

●Reviewed, verified, and updated pricing to confirm it reflects current contract.

●Verified unit of measure accuracy by looking at product images, validating packaging, signed contract, viewing Pilot, and contacting the manufacturer as needed.

●Confirmed contract start date and expiration date aligns with current contract.

Reconciled data uploaded in Product Hub Cloud, PeopleSoft Item Master and the contract, daily.

Pilot Cleanser, Contract Data Analyst, January 2013 – November 2021

●Reviewed Novatus daily to identify signed contracts and amendments; making all changes requested.

●Utilized SQL scripts to manipulate and compile data.

●Collaborated with Sourcing Agents and Analysts to verify the accuracy of contract items.

●Manually entered 20-50 new contract headers in Pilot and Product Hub Cloud per week.

●Extended 50-150 contracts per month in both Pilot and Product Hub Cloud.

●Processed 1000 - 5000 item changes in Pilot on a weekly basis.

●Updated admin fee changes in Pilot, daily as needed.

●Performed 30 to 50 peer reviews in Pilot on a weekly basis.

●Assisted the team in all requests sent to a contract shared mailbox.

●Identified approaching expiring contracts through OBIEE/Tableau and addressed as necessary.

●Actively participated in the Pilot sunset project which was an initiative to standardize duplicate data systems managed by Master Data.

●Assisted team in reconciliation of over 800 contract headers across Pilot, Product Hub Cloud, and PeopleSoft to prepare for Pilot sunsetting.

●Successfully reconciled 8,000 - 11,000 item discrepancies between Product Hub Cloud and Pilot.

●Served as the IT contract subject matter expert regarding contract issues or questions.

●Successfully trained and mentored 8 new employees for Pilot processing.

● Continuously lead a Pilot training overview for over 60 new employees and trained colleagues to lead training sessions.

●Served as a G-Suite expert during the transition from Microsoft to Google.

●Assisted in helping identify fields and data needed to retrieve out of systems to create daily queries to improve data quality.

●Maintained and submitted supplier updates for the participant roster used to manage contract memberships within The Resource Group’s participants.

●Reviewed and updated Pilot to identify all diverse suppliers.

SKILLS:

Pilot, Novatus, PeopleSoft, Microsoft Office Applications, Outlook, SharePoint, Kronos, Product Data Hub, PeopleSoft Supply Chain, G-Suite applications

VOLUNTEER:

St. Louis Food Bank, Marian Middle School

Contact this candidate