● Supported MRP Project - $21M project entailed fixing PCs through parts vendors with Geek Squad City that would be more cost effective and expedient. Involved 4 subprojects.● PPM Project maintenance – add/ remove resources from project plan, update hours and dates● Timesheet reporting - track weekly resource hours via excel download from PPM if actuals are under or over their committed hours or if timesheet was not complete, follow up and correct with resources● JIRA task creation, queries, metrics –track status of JIRA tasks daily – involved daily download to excel, updating pivot tables and using VLOOKUP to identify number of tasks open, closed or in process ; create JIRA tasks, assign resources and update task status; identify bad data such as missing spaces for VLOOKUP● Functional Design Approval process – send out approval for functional designs, track approval status via excel and archive documents on Sharepoint so developers can use the latest design ● Monthly Financial forecasting – run monthly financial reports, identify 3 week burn via excel using resource actuals and rates, and forecast for last week of month. Forecast to within 10% of actuals

● PPM Project reporting, edits and financials – track spending via excel● Create monthly portfolio decks for capex financial planning● Monthly Roadmaps, Release Control Board updates● Sharepoint document archival● Track approved funding

● Support Asset Transfers and SWP Data Retention Projects● PM support● Meeting set up, agendas and notes● Project status reporting● Sharepoint document archival

● Project plan reporting, PM support● ClearQuest issue and risk queries and reporting● Change requests● Training resources on new application ● Meeting notes and access requests

● Project plan creation and maintenance, gathering PM updates● Weekly program metrics using pivot tables● Google docs use and Google Drive document archival● Resolve time sheet discrepancies● Part of the $83 million Peoplesoft upgrade

● Manage Remedy issue queue● Document processes● Update MS Project Server plans through PM and RM requests● Help resolve issues with Project Web App and MS Project Server

● $21 million project to convert IBM tables to Teradata for Target● Manage Purchase Orders, resource set up and Clarity timesheet reconciliation● Support PMs: financial reporting, communications, ad hoc requests/research● Onboarding of new resources: access, hardware, time entry

● Manage Remedy issue queue● Update MS Project Server plans through PM and RM requests● Help resolve issues with Project Web App and MS Project Server

● Project plan management, resource allocation and leveling● Meeting minutes● Managed SharePoint access, archiving and versioning of project documentation

● Weekly and monthly Executive Reporting of onboarding SLAs ● MS Access DB reporting enhancements and release management● DB documentation and data analysis

● Replacement of legacy systems● Weekly and monthly reporting, assembling project statuses, meeting minutes ● Setting up SharePoint sites, access and documentation archiving● PCR tracking and Clarity time tracking, project timelines

● Worked with PMs in assembling project statuses and reports for monthly leadership reviews● Consulted Project Managers on best practices for creating/maintaining project plans● Developed department project report to identify phase and status of projects ● Maintained program communications, change management plans and program gantt● Managed SharePoint sites for archiving and versioning of project documentation

● Maintained 5 project plans as part of an overall $250 million ADP conversion project● Used MS Project extensively to identify resource allocations, dependencies, milestones, late tasks and upcoming tasks to keep project on schedule● Managed issue and risk logs● Reviewed budgets and resource allocations

● Assisted bringing in Florida and Minnesota for Pharmacy Benefit Mngt● Completed high level business process, system documentation and SOPs● Developed weekly and daily dashboard metrics including data integrity and the creation of ad hoc SQL queries through SPSS to identify out of sync client accounts ● Designed screen to reconcile out of balance client accounts● Tested user roles login and functionality of the web based Benefit Edit Tool

● Helped to manage 6 subprojects for the Day 700 project. This was a $30 million project and involved 60 resources. I reviewed budgets and forecasts with the Program Manager, updated project plans and assembled communications● Managed cross functional SPS New Cash Report project of approximately $1 million● Managed project plan and resources. Resolved issues and risks

● Websphere version upgrade and Online Brokerage UDB Uplift - Coordinated with resources and documented infrastructure requirements. Submitted Service Requests and RFPs● Requirements facilitation, screen design, QA plans and testing of online advisor reporting tool ● Online options trading and advisor online trading - requirements gathering, QA and user testing, change requests● Established project requirements, completed systems documentation and estimated costs with 3rd party vendors, onshore and offshore resources. Created test plans, performed UAT testing and resolved issues with developers. Participated in JAD sessions.