Andrew J Green

712-***-****

nxcxle@r.postjobfree.com

Career Summary

Andrew is a Project Manager with a background in Project Coordination and Business Analysis. He has used multiple Project Methodologies ranging from SDLC to AGILE to Prince2. During his career he has advanced to become a Project Manager and also gained experience with MS Excel and Access, as well as become an administrator for SharePoint.

Productivity Tools

SharePoint, SAP Business Objects, Microsoft Office Suite – Word, Project, Visio, Access, and Excel (Pivot Tables and Complex Spreadsheets),Clarity, Open Workbench, Lotus Notes, Planview, Crystal Xcelsius, ProgrammeXpress, and ClickTime.

Professional Experience

Wells Fargo Home Mortgage, West Des Moines, IA May 2011 – Present

Project Manager / Implementation Manager (Consultant)

- Managed a team to complete a data transformation project that was On-Release with Wells Fargo’s specifications of on-time and on-budget.

- Implementation Release Manager for Warehouse Releases and maintained Program Schedule in Mortgage Integrated Data Environment (MIDE).

- Administrator for a database that involved Application data for over 1000 Applications.

- SharePoint Administrator for over 30 Project Managers and 50 Projects.

- Created an excel spreadsheet that determines a grading scale for Applications complexity and risk.

- Led a research team that helped clean up the database with new and correct information.

- Led a SharePoint initiative that Archives completed projects into a document management workspace to clean-up the work space.

John Deere, Ankeny, IA November 2010 - May 2011

Program Coordinator (Consultant)

- Used Crystal Xcelsius and SharePoint Designer to make a specialized dashboard for SharePoint.

- Collaborated with the transition from SharePoint 2007 to SharePoint 2010.

- Developed a PivotTable that converted over 45,000 lines of data into an understandable format.

- Created a task completion spreadsheet that determines the length it takes to complete a task per Program.

- Manipulated data to determine where parts were being stuck in the Design phase.

- Built a spreadsheet graph to verify if any parts were behind in each program, and how to bring those parts current.

- Worked with and supported 6 Program Managers to produce reports that focus on each program.

Aviva Investors, Des Moines, IA August 2010 – October 2010

Project Coordinator (Consultant)

- Maintained and created 3 SharePoint workspaces for projects.

- Used SharePoint to communicate with teams regarding project progress.

- Redesigned and coordinated Global Organization Chart by collaborating with multiple department heads.

- Created template for project team to complete to ensure weekly Status Reports were completed uniformly.

- Ad Hoc reporting for head of Project Office and pull information for Managers to use in meetings.

- Processed and tracked invoices for external resources and vendors .

- Entered invoice information into project tracking system, including yearly budget, actual, and scope.

- Work with and support up to 10 Project Managers .

- Captured meeting minutes for team and project meetings.

Wells Fargo Financial, Des Moines, IA May 2009 – August 2010

Consumer Loan Underwriter

- Trained under the FHA guidelines to underwrite mortgages following FHA insured policies.

- Performed tasks as an underwriter to ensure a benefit is received by both customer and organization.

- Assisted in the redistribution of the FHA mortgage reorganization in the home mortgage department .

- Contacted sales and store managers to talk through their loans and advise them on steps needed.

- Responsible for reviewing, analyzing, approving, and underwriting individual FHA home loans.

- Reviewed financial statements, credit reports, and applicable ratios (debt-to-income and loan-to-value) to determine creditworthiness of individuals.

FBL Financial, West Des Moines, IA January 2008 – December 2008

Project Controller / Jr. Project Manager – Project Management Office (Consultant)

- Collaborated with company’s insurance departments to ensure project success.

- Created and maintained project plans from completion to end.

- Utilized different PMO skills and applications including Open Workbench, Clarity, and Lotus Notes.

- Facilitated and organized weekly meeting including agendas, minutes, creating, and distributing documents associated with each meeting.

- Followed up with project team on their deliverables, requirements, and escalated issues where needed.

- Provided Administrative Support and maintenance for Clarity.

FBL Financial, West Des Moines, IA May 2007 – August 2007

Project Coordinator – Project Management Office (Summer Intern)

- Supported large budget project by assisting in project plan maintenance and financials.

- Constructed pivot tables of past PMO data in Excel Databases to determine success of projects.

- Coached Project Managers on correct inputting of time into time management software and how to instruct their teams into following suit.

- Created and maintained issue logs, change request logs, and action item logs.

- Provided Administrative Support and maintenance for Clarity.

- Created training material for Project Managers and team members for use in time management software.

Education

Drake University

Des Moines, IA

Bachelors of Science in Business Administration: Management, Marketing, and Entrepreneurial Management

Honors Received

Eagle Scout Award and Eagle Palm Award

Central Iowa PMI Scholarship Recipient

References Available Upon Request

Contact this candidate