Project Quality Assurance

ROSSLAND BALLARD

310-***-**** • **********@*********.***

• www.linkedin.com/in/rossballar

Objective: Director of Continuous Improvement

Professional Summary

A versatile, resourceful Information Technology Systems Professional with over 15 years of experience including:

• Solid Financial, Manufacturing, Process Improvement, Inventory Control, Distribution and Business

Intelligence/Data Warehouse experience.

• Utilized LSS tools such as Value Stream Analysis and DMAIC(Define, Measure, Analyze, Improve and Control)

for process improvement and the elimination of wasted steps.

• Utilized SWOT (Strengths, Weaknesses, Opportunities, and Threats) to evaluate business processes.

• Ability to work within the organization at all levels utilizing a “hands on” approach to create value and buy-in

as the lead change facilitator. Collaborated with IT infrastructure on implementing project required servers and re-

designing data centers.

• Having a 'Solutions Orientated' mindset, I have identified manufacturing waste and scrap issues while

implementing IT system improvements for Nestle and Northrop\Grumman.

• Worked with the Purchasing Department to enhance the 'Order point' and Vendor selection processes.

• Interfaced with Engineering to enhance the Product as Engineered can be built with the current

Manpower/Equipment.

• Demonstrated ability to analyze, coordinate, plan, and execute multiple projects simultaneously using MS

Project.

• Have extensive knowledge and experience with Access, Excel, Project, SQL, WORD and Visio.

• Have used MS Access to: create Forms, Reports, Tables, Databases, exported and imported tables to using

Excel

• Have created and worked with in Excel: Reports, formulas, Macros, Pivot tables

• Contributed to multiple projects valued from $10K to $400K+, for Nissan, Toyota, Countrywide, Kinecta,

DirecTV and Quicken Loans.

Professional Certifications:

• MS Office Specialist (Access, Word and Excel) and OutlookSoft (Business Intelligence)

• Lean Six Sigma Black Belt Certification

• Currently hold a California Vocational Teaching Credential to teach Computer Applications.

Key Competencies:

• Extensive knowledge of: JIT, KANBAN, TQM (Total Quality Management), SDLC, Quality Assurance

• Value Stream Operations Analysis, SWOT Analysis, Process Modeling

• Databases: Oracle 11g, Business Objects, SQL Server 2008, COGNOS/OLAP and Access

• Software: MS Word, Excel, PowerPoint, Project, Access Visio, HTML, Dreamweaver

• Extensive use of BPM (Business Process Modeling).

•

Professional Experience and Accomplishments:

• State of Michigan/Michigan Gaming Control Board Lansing, Michigan via DPM Consulting Services

11/2012 - 03/2013

Business Analyst

Provided Business Analysis, developed Data Mapping, Systems Test Cases, System Training Plans and user

Training documents for the major project for MGCB(Michigan Gaming Control Board).Maintained project

documents on MS Share/Point. Worked with developers to ensure Data Quality and verifiable unit testing of

screens. Used SQL Developer to write SQL queries against an Oracle 11g database to validate data migration

from the old system to the new WEB enabled system. Provided project progress status reports using MS Project.

• Quicken Loans - Detroit, Michigan

1/2012 - 7/2012

Business Intelligence\Business Analyst

Provided BI support to business users of the QL BI platform. worked with QL team members on using

analytical, performance trending and the predictive analytical tools provided by the QL Business Intelligence

platform. Developed Use Cases and User Stories for the AGILE/Iterative development process. Worked with

SCRUM Master. Developed Ad-Hoc reporting in support of the Loan Servicing (LPS/MSP system) and Investor

reporting teams. Accessed Data Cubes via Excel Pivot tables. Performed data mapping and data quality

assurance. Developed a critical business compliance reporting solution that would save up to $77,000

annually.

• Bank of America Agoura Hills, California via Apex Systems

12/2011 - 01/2012

Systems Analyst Worked on BASEL project initiatives and data quality assurance where needed.

Rossland Ballard **********@*********.***

Page 2

• Bank of America Corporate, Simi Valley, California via APEX Systems Inc.

11/2010 - 3/2011

Systems Analyst/Project Coordinator/Contractor

Collaborated on projects using the banks ECMS (Enterprise Change Management System) system ECMS is

designed around Lean Six Sigma DMAIC Methodology. Clarity and Nexus was used to track project activity.

Collaborated with systems users and application developers to create work, data and process flow diagrams.

Worked with project team to develop solutions for iSeries/AS400 back-end Mortgage, HUD, Assumptions, and

HELOC applications. Insured high quality business solutions. Used the HP Quality Center.

Collaborating/ facilitating a Career Forum with the SBPA of Torrance and the City of Carson,

Ca. 1/2010 – 10/1010

• Directing the Registration team and Hosting select employers for the Career Forum.

Consultant – Ballard Business Solutions Services

Consult with various organizations to address Lean project requirements and provide business solutions. Activities

included:

• Interpreted business requirements then developing requirements

documents.

• Creating viable business process improvement solutions. Writing User

Business requirements.

• Developing business performance reporting using MS Access such as:

Inventory usage and control, Procurement performance, Vendor management performance.

o

•

Ocean400 User Group – An IBM system I, AS/400 Network, Santa Ana, California

7/2009 – 7/2010

• Consultant - Data Analyst

• Developed and enhanced the User groups' National annual seminars MS Access

database. Developed tables, forms, queries, reports and macros in support of the National annual seminar held

in Irvine, California in July 2010.

•

Kinecta Federal Credit Union, Manhattan Beach, California

•

7/2007 - 4/2009

Lead Business Systems Analyst

• Provided vital technical and business leadership on high-profile projects that included Value Stream

Mapping, elimination of process and data redundancy. Charged with supplying project management and

training. Directed Process Testing and Quality Assurance with in-house staff and systems users during system

implementation.

Key Accomplishments:

• Led implementation team in the installation of the data warehouse and business

intelligence tool (Business Objects Business Intelligence XI 3.0), requiring data import from a number of non-

linked source systems involving vendors like FiServ and Business Objects and in-house Excel spreadsheets

and Access databases. BI/DW built on a SQL Server 2005 platform.

• Collaborated with the implementation team in designing the Enterprise Data Warehouse

including:

• Identifying Source feeder systems. Built Data mapping tools to document what is

required for the Data Warehouse.

• ETL data extraction rules to create feed files to the Data Integrator Server Job Server Engine.

• ETL data extraction rules to build the Metadata in MS SQL Server.

• Maintained Project Deliverables, Schedule and Scope in MS Project.

• Establishing the rules and processes with IT Infrastructure for nightly data extraction to

update the Data Warehouse.

• Provided training for key systems users, IT support, IT Development and Database

Administrators.

• Provided weekly status reports to all Key Stakeholders and Project team.

• Established processes which streamlined the operational systems and provided better

input for Business decision-making.

• Managed a project budget of over $400K.

• Utilized SWOT analysis while serving in key roles in the success of multiple projects for

account fee tracking, ecommerce, online banking, membership profitability, and OFAC review.

• Received a performance bonus for directing systems revisions to pass the corporate

NCUA audit on time.

• Worked on a project to provide QA assured mortgage loan data to the FHLB of San

Francisco.

•

Independent Short term Contract assignments

•

11/2006 – 4/2007

Developed Business solutions and developed Databases, Queries and forms using MS Access. Developed

Business Requirements documents.

•

FS Systems: An OutlookSoft Business Partner Newport Beach, CA.

•

7/2006 – 10/2006

Contract- Systems Integrator/Project Coordinator

Implemented, configured and installed OutlookSoft 4.2., used to manage financial and operational planning,

budgeting, reporting, and analytic requirements. Developed reports with OutlookSoft WebExcel Developed

reports and built Dimensions over OLAP tables in SQL Server 2000 enterprise environment. MS Project was

used to track project deliverables, status and scope.

•

Rossland Ballard **********@*********.***

Page 3

•

OCJ Group Reseda, California

•

7/2005 – 6/2006

• On assignment at Countrywide Treasury Bank as Contract-Business Analyst

Developed test plans and test scripts using Mercury Test Director for testing the Collateral Tracking System

and ON-Line Review testing of Loan products. Successfully completed multiple data migrations from MS

Access to SQL Server, including data mapping, data quality assurance, test planning and ETL development.

This work provided Countywide a more robust and centralized database. Developed System flows with Visio.

Used Altova XML editor to edit screen code.

•

Toyota Financial Services: Torrance, CA

•

3/2005 – 6/2005

• Contract-Data Analyst/Project Coordinator

• Successfully tracked resource allocations and resolved reporting issues

using Niku Workbench and used MS Excel for project reporting tracking. This activity provided the group with

a bird’s eye view of the project performance.

•

Direct TV Cable/Entertainment: El Segundo, CA

•

12/2004 – 3/2005

Contract- Financial Analyst

Used the CTQ (Critical to Quality) tools and developed metrics for migrating COGNOS and Hyperion databases to SAP;

built reports and worksheets in Excel incorporating V-Lookup and H-Lookup for monthly, quarterly and YTD trend

analysis. Simplified database process & enhanced financial management reports using the Lean process

improvement techniques.

Consolidated Leasing Terminal: Newport Beach, CA

•

2/2004 – 9/2004

Contract-Business Analyst

Used Value Stream Mapping techniques, VOC and VOE to deliver analysis and programming to upgrade port-shipping

application from RPG II to RPG-ILE. MS Project was used to track and report on deliverables, scope and status.

•

Nishimoto Foods & Trading Company: Santa Fe Springs, CA

•

1/2003 – 1/2004

Contract-Analyst Successfully migrated AS/400 systems to JD Edwards One World using SWOT, VOC and

VOE, with little to no interruption to critical business processes involving over 75 system users. Used Excel for

data metrics gathering.

Independent Consultant

•

2/2003 – 11/2003

Developed and implemented business solutions to address Windows software issues for small businesses. Defined

requirements developed Access databases and created Visual Basic procedures. MS Project was used to track and

report status of multiple projects.

Toyota Motor Corporation: Torrance, CA

•

9/2000 – 5/2001

Contract-Analyst AS/400

Enhanced a new dealer daily system using the SDLC process involving systems analysis, writing storyboards, testing,

and using VOC and VOE tools. Collaborated with system developers and QA throughout the entire SDLC process.

Successfully developed project documentation using several DMAIC process tools.

•

Quicksilver: Huntington Beach, CA

•

6/1999 – 7/2000

Contract-Systems Analyst/PM/Coordinator – AS/400 dual platforms RPGIV, PC

Pulled together requirements from working with systems users; which helped me to setup a system to deliver

government 941 vendor information thus eliminating $50K in late fees. Led multiple functional project directed teams

of 15+ members to replace the Lawson financial system with COGNOS business intelligence/data warehouse solution,

which enhanced the company’s ability to track financial performance. Worked with team to design and implement the

new data center, including installing user PC/server infrastructure. MS Project was used to track and report on multiple

projects for Key Stake Holders and project team.

•

Nissan North America: Gardena, CA

•

1/1998 – 4/1999

Contract-Analyst-AS/400

Deployed a PC- system to capture bar code information for vehicles shipped to nine distribution centers and transmit

the data via TCP/IP to AS/400. Created and implemented tools for Nissan to track vehicle activity from Production to

Distribution Centers.

Allied/Domecq-Baskin-Robbins. Glendale, CA

•

01/1997 – 12/1997

Systems Analyst/PM - AS/400, PC Researched the impact of Y2K on information and business systems (this

involved plant manufacturing, testing equipment, office automation and computer systems). Traveled to Ice Cream

production plants across the country to gather current and new business requirements and translate them into

business rules for the BPCS systems implementation. MS Project was used to track project status and to create

weekly reports.

Rossland Ballard **********@*********.***

Page 4

Transamerica Corporation. Los Angeles, CA

•

12/1995 – 12/1996

Contract-Analyst

Provided business and programming assistance on a major financial conversion project written in COBOL.

Nestle Foods Company. Glendale, CA.

•

4/1992 – 11/1995

Systems Analyst /PM AS/400

Used the Fishbone diagram to highlight process concerns. Collaborated with SME to develop EDI transactions to

support the Supply Chain Management process used at Nestle`. Worked with Payroll Analyst on Lawson support. Used

MS Project for project control. Conducted site surveys at production plants in several states and used the data

gathered to develop metrics for the project.

•

Northrop/Grumman Advanced Systems B-2 Division. - Pico Rivera, CA

8/1989 – 4/1992

Senior Business/Analyst /PM/Coordinator- attained Secret Security clearance

Used systems analysis, SWOT analysis and developed Value Stream Mapping to develop business solutions for the

areas of Shop Floor Control, Capacity Management and Labor Data Collections applications. My work included

Functioning as QA lead on a project to co-mingle parts from two aircraft (B-2 and F-18) on the same database (PIOS)

and the preparation of progress reports for management which included milestones, project assessments and future

project goals. Developed feasibility studies and created ROI Analysis. Heavy usage of MS Project was required to

provide reporting and maintain the deliverables, status and scope of multiple critical projects. Provided weekly project

reports to Key Stakeholders, SME’s and the project teams.

Education and Training:

•

• California State University, Long Beach, CA – B.S. Business Administration/ Business

Computing

Vocational Teaching Credential- Computer Applications

o

• SSD Global Lean Six Sigma Black Belt training

• Northrop, Pico Rivera, CA – The SDLC (Systems Development Life Cycle) Process

• Kinecta Operations Center, Manhattan Beach, CA

Business Objects Data Integrator, Business Objects Web Intelligence, Universe Design

o

Report Writer and System Implementation

o

• Nestle Foods Company, Glendale, CA – Time Management

Contact this candidate