Wendy Sue Vorce

Commerce, MI

ac3jrq@r.postjobfree.com

248-***-****

Summary:

Wendy is a strong experienced Business Analyst with strong accounting skills working in enterprise organizations such as General Motors and EDS.

Her strengths include requirements gathering, data management, teamwork, facilitation and strong written and oral communication skills.

She has experience working with Requirements Analysis, Testing, Traceability Matrix, and RUP

Skills:

Accounts Payable, Adobe Illustrator, Agile, Audio Conferencing, BOM, Change Management, CMM Levels 2 and 3, COTS, ecommerce, EDI, ETL, FTP, HIPAA, HTML, IPACS Management System, Instant Messaging, Lotus Notes, Microsoft Access, Microsoft Excel, Microsoft Outlook, Microsoft Project, Microsoft SharePoint, Microsoft Word, ODBC, Oracle, Photoshop, Presage, Primavera Scheduler, PVCS, Quality Assurance, Quick Place, Rational Unified Process (RUP), Regression Testing, Resource Allocation, Information Security, IT Service Management (ITSM), SDLC, SDP-21, SQL queries, TSO, UAT, use cases, user stories, Visio, WebEx

Experience:

EDUstaff, MI May 2017 – present Substitute teacher for students in kindergarten through 6th grade

Blue Care Network, Southfield, MI Aug 2015 – Mar 2016

Change Control Coordinator

Directed and coordinated work activities of multiple project teams

Coordinated resources across one or more projects

Utilized change management in processing application developers’ requests

Managed project scope when assessing the feasibility of the developer’s request

Communicated results of analysis and recommendations to management via presentation and reports

Participate in ongoing data validation to ensure data integrity and reliability

Assisted management with the implementation of solutions for identified problems/issues

Assisted personnel (both internal and external) by answering questions, supplying information and training

Worked with BCBSM (Blue Cross Blue Shield of Michigan), testing and development teams to coordinate promotion activity timelines and promotion results

Created builds for promotion activity into testing environments

Performed UAT testing

Environment: Microsoft Excel and Outlook

West Bloomfield School District, MI Sep 2014 – Jun 2015

General Dynamics, Farmington Hills, MI Jun 2012 – Aug 2014

Business Analyst

Subject Matter Expert in Excel

Managed financials for payroll

Handled accounts payable for mobile phones

Facilitated microwave uploads and notification to Siterra and to the shared drive

Reported daily 594 project status to multiple managers

Supported corporate and remote staff associated with procuring, distributing and maintaining inventory control of office equipment, computers, and mobile phones

Utilized Ariba when onboarding new employees

Environment: Ariba, financial systems and Microsoft Excel

Chrysler Motor Division, Auburn Hills, MI Mar 2012 – May 2012

Business Analyst

Provided business expertise necessary to migrate new and existing functionality to the new Digital Asset Management (DAM) application

Supported the conversion of a client server application to a SharePoint based application

Developed my SharePoint skills so that I could support the conversion

Prepared and gathered detailed specifications, documents, spreadsheets, and charts that included the implementation requirements

Developed and maintained all the analysis documentation associated with the implementation

Developed approach documentation detailing the process associated with the migration

Environment: SharePoint and Microsoft Excel

PSI Center, West Bloomfield, MI Mar 2010 - April 2010

Business Analyst

Surveyed several Meals on Wheels facilities and was evaluated on the number of calls completed

Achieved highest call volume

Documented number of calls and analyzed and documented the results

Environment: MS Office and MS Excel

Edwards, Ellis, Stanley, Koshiw, Armstrong, Bowren, P.C., Troy, MI Feb 2008 – Apr 2008

Staff Accountant

Entered data into system to create accurate tax returns using Ultra Tax

Learned Ultra tax quickly to complete returns efficiently

Researched property values with county departments to complete tax returns

Environment: Ultra Tax, MS Excel

Comerica Bank, Auburn Hills, MI Aug 2007 – Oct 2007

Project Coordinator for NGN Project

Learned Visio quickly and utilized Visio in creating work flows and in creating and maintaining project calendar

Interfaced with project managers to perform needs assessments and gather project requirements

Developed a project portfolio spreadsheet after gathering project forecast information from several Comerica Bank supervisors and managers

Published meeting minutes in a timely manner for NGN Management Meeting and NGN Steering Committee

Tracked site adds, deletes, and closures and documented process flow in Microsoft Visio

Completed review of 150 site surveys and developed a detailed listing of each survey

Tracked and corrected resource work and time keeping

Environment: Microsoft Excel, Microsoft Visio, Microsoft Word, and Lotus Notes

General Motors, Warren, MI Sep 2006 – Dec 2006

Business Analyst for Manufacturing and Quality Wan Refresh Project

Participated in Plan and Define phases of GM Manufacturing and Quality Wan Refresh Project

Created, updated and distributed weekly project overview reports

Gathered status requirements for 18 projects from GM and AT&T project managers on a weekly basis for reporting

Utilized strong oral and written skills when communicating with the GM plants as the AT&T project managers

Ran Pivot tables to extract business unit and site information from SOX reports to research what circuits were used for and to determine type of circuit

Kept informed of latest industry news, trends, products, services, competitors and relevant existing and emerging technologies that may impact present and future account and business performance

Analyzed data (pivot tables, sorts, and macro’s)

Created pivot tables to analyze circuit information

Communicated with global GM Business Units and Functional Skill Team staff to identify, collect and input demand and supply circuit data into the Tactical Database

Environment: Microsoft Excel, Hyperlinks, and Pivot Tables

Birmingham Bloomfield Audiology, Birmingham, MI Oct 2005 – Dec 2005

Client Associate

Scheduled, rescheduled, and reminded clients of appointments

Interfaced with NASCO while processing claim forms

Prepared ear mold repairs for timely shipment to manufacturer

Loaded invoices into Quick Books in managing client accounting

Environment: Quick Books, Photoshop and NASCO

General Motors, Grand Blanc, MI Aug 2004 – Sep 2004

Project Manager for CMM level 3 conversion project

Conducted WebEx meetings with project managers to discuss new process implementation

Created and ran macros to run reports

Documented and tracked training requirements and ran customized reports for management

Utilized project management experience, SDP21 knowledge and CMM background to identify project execution or process deficiencies in areas of training, measurement and analysis and Configuration Management tools

Downloaded, reformatted, and distributed customized GM Service Parts Operations Status Reports in support of weekly senior management review meetings for active projects

Participated with General Motors’ personnel, Quality Assurance representatives, and Mentors to define, document, and help implement new processes to correct quality gaps

Adhered to Project Management Office policies, procedures and methodologies

Environment: Microsoft Excel, Lotus Notes, WebEx and Quick Place

General Motors, Pontiac, MI May 2004 – Jul 2004

Business Analyst

GM Weld Tool, Tool Control System Enhancements Project

Facilitated meetings with the GM customer to gather user stories

Synthesized complex information into concise, readable, unambiguous language

Elicited information based on client and/or internal business needs, documented requirements and translated requirements into functional specification adhering to GM’s Software development methodology

Owned written requirements and specifications, acceptance, Requirements Traceability Matrix (RTM) and related documents from creation and modification through solution delivery

Showed a high degree of initiative in learning Caliber RM in a short amount of time and in populating SDP-21 documentation in support of Tool Control System Enhancements Project

Acted as a liaison between GM Weld Tool customer and IT Web technical team in gathering business and functional requirements from GM Weld Tool customer and in reporting project status to management

Strong understanding of technology as it relates to facilitating systems design

Defined and refined business requirements on the Tool Control System Enhancement Project, a large and complex development project

Utilized ETL in managing requirements so the Tool Control System Enhancements Project progressed successfully

Environment: RTM, SDP 21, ETL, HTML, PVCS, Lotus Notes, and user stories

Electronic Data Systems, Warren, MI Nov 1988 – Nov 2003

Business Analyst

Vehicle Transportation Information Management System (VTIMS) Business Operations and Support Service (BOSS), (June 2002 – November 2003)

Tracked railcar carriers’ payments in the VTIMS mainframe system

Interfaced daily outbound logistics with GM’s new vehicle carriers to resolve logistical issues which resulted in successful delivery of GM new vehicles to dealerships and cost savings for GM

Analyzed and developed solutions for GM new vehicle carrier’s requests for assistance with payment concerns

Corrected data so that GM new or used vehicle carriers can accurately account for movement of GM vehicles

Intervened on behalf of GM to correct vehicle shipping errors via railcars and trucks

Provided second level support for GMs new vehicle carriers

Streamlined process documentation for creating adhoc jobs which improved accuracy and efficiency of data change requests to VTIMS, a mainframe system

Reported metrics to GM regarding any contact about inquiries made to the VTIMS BOSS

Attended PMI training classes in preparation for Project Management Professional Certification

Environment: PVCS, TSO, IPACS Management System, VTIMS (mainframe), Microsoft Excel, Lotus Notes, and Microsoft Outlook

Executive Business Continuity Planning and Status Reporting Project, Troy, MI Mar 2002 – Jun 2002

Project Coordinator

Documented processes with information provided from the business SME

Collaborated with project team to define, develop, document, and test processes needed to support Executive Business Continuity Planning and Status Reporting project

Defined layout of the process definition and of the processes that were needed to support the Executive Business

Reviewed and tested integration of processes needed to support the Executive Business Continuity Planning and Status Reporting project

Collected and assimilated data from several resources into 20 customized reporting spreadsheets containing up to 40 sites per business unit resulting in a successful project launch

Performed Database mining, manipulation and alternative scenario calculations to support user requests

Environment: Information Security, Microsoft Excel and Microsoft Outlook

Pontiac and Warren Data Centers Disaster Recovery plan completion project, Warren, MI Nov 2001 – Mar 2002

Business Analyst

Collected and reported metrics in support of GM Disaster Recovery Plan Quick Hits initiative

Coordinated and served as the focal point for all communication in developing Site Disaster Recovery Plans (DRPs) for Pontiac and Warren Data Centers

Planned and tracked work schedule for delivery of Site DRPs for Pontiac and Warren Data Centers

Environment: Microsoft Excel, Lotus Notes, and Outlook

Container Planning and Development (CPAD) Project, Madison Heights, MI Jun 1995 – Nov 2001

Business Analyst

Adhered to Agile methodology when developing and maintaining the CPAD application

Utilized SQL queries when creating reports from the Oracle database

Established the CPAD project communication plan across the business, support and technology groups

Managed project risks and issues and engaged the appropriate stakeholders in risk identification and

mitigation

Provided direction and oversight throughout the project lifecycle to the project team

Well versed in inbound logistics when supporting the GM NAO Containerization customer

Queried the Oracle database when researching issues

Defined and managed the CPAD project schedule Primavera Scheduler

Defined the resource and delivery commitments in Microsoft Project

Worked with and managed third party vendors

Worked with the EDS technical group to ensure requirements understanding, ensuring test process execution, review test requests, performed IT acceptance, and coordinated release with Release Team

Test Lead for User Acceptance Testing (UAT) to verify that requirements were met

Interpreted requirement documents and updated the test scenarios accordingly

Collected and analyzed test data resulting in successful releases

Demonstrated strong analytical skills and problem solving skills when analyzing problems with CPAD

Gather and documented CPAD requirements in MS Access and built releases from the requirements listing

Tracked requirements in MS Access and created CPAD requirements reports for GM

Analyzed feasibility and resource changes because of requirements modifications through impact analysis reporting

Developed and maintained cost estimates for each CPAD release

Managed CPAD release budget for assigned projects, developed and monitored project plans, and adjusted resources and priorities.

Completed assigned CPAD release projects within budgetary and scheduling guidelines

Provided monthly status reports which included quality metrics regarding CPAD

Defined and refined business requirements on the CPAD project a large and complex development projects

Employed various business processes and applied this knowledge to use cases, supplemental specifications, process flows, data models, and test cases

Set priorities based on meeting action items and provided weekly progress updates

Documented and presented data model for GMNAC management

Updated the regression test for CPAD

Informed and advised affected parties of business impact

Championed the business needs of the client and internal team while balancing the climate, priorities, capabilities and constraints of client

Conducted Software Configuration Management audit to ensure compliance with software quality standards

Authored and tested Distributed Application Disaster Recovery Plan for CPAD

Planned and managed several releases of CPAD for GMNAC customer both locally and remotely

Monitored and assessed progress of CPAD releases during project implementation

Deployed several successful versions of Consistent Office Environment (COe) in support of GMNAC customer

Tracked and billed the COe equipment and software to GM

Ensured Software Quality Assurance by conducting a PVCS configuration audit of items in GM North American Logistics Inbound Parent project

Continually contributed to the improvement of client Database development and capacity analysis capability

Performed gap analysis on the final requested requirements

Environment: Primavera Scheduler, Microsoft Project, Microsoft Access, UAT, Lotus Notes, Microsoft Outlook, Microsoft PowerPoint, SQLqueries and PVCS

Business Analyst, Pontiac, MI May 1994 – May 1995

GM Pontiac West Assembly

Managed the plant’s Telephony projects from initiation through implementation

Contributed to Quality Review sessions on how to improve existing plant support processes

Developed and implemented shut down plans for entire Pontiac West Assembly’s computer inventory and Corporate Video Services Network (CVSN)

Evaluated and monitored maintenance contracts for cost savings resulting in reduction of EDS’ expenses

Diagnosed and repaired workstation hardware related problems

Environment: Telephony, Microsoft Word, and Microsoft Excel

Business Analyst, Troy, MI Nov 1988 – May 1994

GM Chevrolet Customer Assistance

Authored VISS procedure manual which improved efficiency of VISS support

Managed vehicle recall communication with Chevrolet vehicle owners

Trained new advisors in Chevrolet’s and Vehicle Information Service System (VISS) policies and procedures, call handling, and system utilization

Negotiated reimbursement and goodwill requests with Chevrolet Executive referral customers

Revised VISS training tools to provide most useful procedure for handling a VISS inquiry

Authorized goodwill adjustments for Chevrolet owners with Chevrolet Dealers on behalf of Chevrolet Motor Division

Assisted hearing impaired Chevrolet customers utilizing Telecommunications Device for Deaf (TDD)

Environment: Telephony, Vehicle Recalls, Microsoft Excel, and Microsoft Word,

Biller Nov 1987 – Oct 1988

Interfaced with NASCO while processing insurance claim forms for a physician

Education:

Bachelor of Business Administration, Concentration in Marketing and Human Resources, the University of Michigan, Ann Arbor, Michigan

Contact this candidate