Rick Clare Headshot
Report a problem with this profile
[email protected]

Rick Clare  

Rick has over 25 years of experience as a public speaker, a technology instructor, and a business analysis and project manager speaker. He is a routine presenter at the Pittsburgh Oracle User Group and the Pittsburgh chapter of the IIBA. Rick has presen

Richard F. Clare



Professional Summary

·         Over 25 years experience in Project Management, Business Process Management, Business Analysis, technical leadership, integration, requirements definition, user training, support documentation, software design and development

·         Developed project plans specifying goals, strategy, staffing, schedule, risks, and allocation of resources for each phase of development

·         Produced analysis documents and models using many tools and methodologies, including Entity Relationship Diagrams, Process Flows, Functional Hierarchy diagrams, Context diagrams, Flow charts, Activity diagrams, Class models and Dataflow diagrams

·         Excellent interpersonal communication, facilitation, and management skills


Project Management Experience

15Number of Projects Managed

10Number of Projects Managed at One Time

4Largest Budget

1.5 MillionLongest Duration

1.5 YearsAverage Budget

300kAverage Duration

1 YearMulti-Site Projects

YesExperience Teaching Classes

YesExperience Developing Courseware



Professional Certifications

·         Oracle Certified Professional Developer

·         Certified Business Analysis Professional - International Institute of Business Analysis (IIBA)

·         Project Management Professional – Project Management Institute (PMI)


Technical Summary


RDBMS:  ORACLE Server, Oracle Designer, Oracle Developer, SQL, PL/SQL, SQL*Loader, Import/Export, Data Query, Data Browser, Enterprise Manager, Server Manager, Microsoft Access, Paradox for Windows, ObjectVision, dBase III/IV, FoxPro

Languages:  PL/SQL, SQL, Java, Visual Basic, PowerBuilder, UNIX Shell Script, ObjectPAL, Paradox Application Language

Operating Systems:  LINUX, UNIX, Microsoft Windows, DOS, OS/2, ULTRIX, XENIX


Professional Experience


7/00 – Present

ConsultUSA, Inc., Pittsburgh, PA

Project Manager/Business Analysis/Practice Director/Lead Instructor


Assigned to ServiceLink (04/09 – 06/09)

Business Analyst Manager

·         Program Description : Rewrite of Primary Corporate Mortgage Finance Software

·         Team Size : 22

·         Responsibilities:

·         Managed efforts of 22 Business Analysts divided up amongst 6 project teams

·         Provided training and mentoring to project BA and PM resources

·         Personally conducted numerous project facilitation and requirements elicitation tasks, both as part of the training/mentoring effort and to handle emergencies as they arose

·         Brought in to handle four specific tasks:

·         Guide the program team through completion of the elicitation and documentation of the business requirements

·         Handle several personnel problems with the organization of the project teams

·         Steer the BAs correctly into the process of creating functional specifications based on the business requirements, so that the development effort could begin

·         Provide mentoring and guidance concerning the BA profession

·         The engagement ended when the four tasks had been completed, ahead of schedule


ConsultUSA Corporate Headquarters (07/08 – Present)

Director - Business Analysis Practice / Director - Oracle Practice

·         Description : Support Business Analysis Practice. Serve as Project Manager on multiple consulting projects at various companies, providing expertise on Business Analysis best practices and training options

Projects :

·         Customized Business Analysis Training

·         Reviewed BA process at large healthcare insurance company,

·         Documented existing processes

·         Documented disconnects and recommend changes

·         Created 5-day BA training regimen customized to their needs

·         Business Process Improvement

·         Reviewed all corporate processes at large heavy manufacturing firm

·         Documented existing processes in support of SAP implementation

·         Documented disconnects

·         Business Analysis Track Development

·         Produced track of BA training material reflecting new version of the Business Analysis Body of Knowledge

·         Business Analysis Certification Preparation Course

·         Produced 2-day class targeted at ensuring a pass on the Certified Business Analyst Professional exam

·         Business Analyst Screening Test

·         Produced screening test for international screening company, to be used to rate the competency of Business Analysts prior to a hiring decision


Assigned to Giant Eagle (02/07 – 06/08)

Project Manager, Business Analyst

·         Project Description : Various Fuel/Convenience Store projects

        Project Phases
Analysis, Design, Build, Implementation, Production

·         Team Size : 6-12

·         Responsibilities:

·         Elicited project requirements, scoped out projects, completed feasibility studies, assessed software systems and vendors, managed project budgets, evaluated and selected solutions, wrote requirements specifications, and tracked and reported on status

·         Developed project plans specifying goals, strategy, staffing, scheduling, risks, and allocation of resources for each phase of development projects

·         Analyzed business workflows, user profiles, usage scenarios, business rules, and system requirements to identify areas for process improvement

·         Oversaw complete implementation of following projects, managing them all simultaneously:

o        Interactive food ordering system involving touch screens in Fuel/Convenience store chain 

Budget: $650,000.00. Duration: 16 months

o        New sign and replacement tag production system in all Giant Eagle Supermarkets

Budget: $850,000.00. Duration: 18 months

o        New production planning software for Fuel/Convenience stores equipped with kitchens

Budget: $700,000.00. Duration: 18 months

o        Study of viability of unattended fuel stations


ConsultUSA Corporate Headquarters (10/06 – 01/07)

Project Manager, Business Analyst, Course Material Author, Instructor

·         Project Description : Create Business Analysis Practice.  Create, test, and implement complete Business Analysis Certification track including all courseware

·         Project Phases : Strategy, Analysis, Design, Build, Implementation, Production

·         Team Size : 10-15

·         Responsibilities :

·         Developed complete certification-level course curriculum and material for 8 Business Analyst courses, in alignment with the Body of Knowledge of the International Institute of Business Analysis

·         Elicited and documented all project requirements

·         Managed team throughout effort, coordinating their activities and compiling their results into the completed output

·         Monitored and reported on status throughout the project


Assigned to Giant Eagle (07/06- 9/06)

·         Roles:  Project Manager, Business Analyst

·         Project Description:  Upgrade Database and Application Software to support core Giant Eagle System

·         Project Phases:  Analysis, Design, Build, Implementation, Production

·         Team Size:  4-8

·         Responsibilities:

·         Project Manager for an upgrade of the application server software for the Retail Pricing System from Oracle 6i to Oracle 10G

·         Defined and documented proposed business requirements and processes with internal and external customers

·         Provided aggressive, realistic estimates and updates of work necessary to complete all deliverables within targeted timeframes, while minimizing overall cost

·         Created technical documentation and requirements specification for the upgrade

·         Served as a liaison between technical staff and managers/business staff during upgrade


Assigned to Highmark, Inc. (02/04 – 06/06)

·         Roles: Designer/Senior Business Analyst/Developer

·         Project Description: Health Insurance core system - ICIS

·         Project Phases: Requirements, Architecture, Design, Modeling, Prototyping, Coding, and Development

·         Team Size: 35

·         Responsibilities:

·         Provided Oracle knowledge and insight for project team

·         Provide mentoring for UNIX, SQL, PL/SQL and Oracle environment

·         Data Modeling, Process Re-engineering, and Process Flow diagramming

·         Business Analysis, Requirements Elicitation, Solution Assessment and Validation

·         Primary UNIX resource for team

·         Software Configuration Management resource

·         PL/SQL coding

·         General environment troubleshooting


ConsultUSA Corporate Headquarters (11/03 – 01/04)

·         Acted as a Lead Instructor with the following responsibilities:

·         Oracle software installation and maintenance

·         Oracle Instruction

·         Course material preparation and maintenance


Assigned to Giant Eagle, Inc. (10/00 – 11/03)

·         Roles: Technical Lead/Designer/Programmer/Business Analyst

·         Project Description: Grocery chain core system for managing prices

·         Project Phases: Requirements, Architecture, Design and Prototyping, Build

·         Team Size: 30

·         Responsibilities:

·         Technical Lead for project – Oracle and Oracle Designer

·         Provided mentoring for Designer, Oracle, and Oracle web environment

·         Data Modeling, Process Re-engineering, Process Flow and Function Hierarchy diagramming

·         Business Analysis, Requirements Elicitation, Solution Assessment and Validation

·         Function Hierarchy diagram modeling

·         Design, build and maintain security model

·         Configuration management for project

·         PL/SQL coding and Interface design


10/92 – 6/00

Enterprise Information Systems, Inc.

Lead Instructor/School Administrator/Project Manager/Business Analyst/Technical Lead


Chief Instructor and Administrator of ISD School (9/98 – 6/00)

·         Roles: School Administrator/Chief Instructor/Technical Expert

·         Dept Description: High-level Technical School for the production of fully trained Oracle professionals. Students became Oracle Certified Professionals during the course.

·         Course Length: 8.5 months

·         Team Size: 12 instructors and admin staff

·         Responsibilities:

·         Market school and course

·         Production of all course material 

·         Preparation and scheduling of course curriculum

·         Produce and administer examinations and certification testing

·         Run the school on a day-to-day basis and teach courses


CNA Test Admin System (TAS) (4/96 – 6/00)

·         Roles: Technical Lead/Designer/Programmer/Business Analyst/Project Manager

·         Project Description: Administration, examination and scoring for nurses in Canada

·         Project Phases: Requirements, Architecture, Design, Prototyping, Implementation, and Maintenance

·         Team Size: 4-8

·         Responsibilities:

·         Project Management: Schedule and Resources

·         Elicitation of requirements

·         Data modeling and process flow diagramming

·         Development of Oracle database component and front end 

·         PL/SQL coding to support requirements

·         Support and modifications within a highly mutating environment


Web-based Minor Hockey Registration (1/00 – 6/00)

·         Roles: Technical Lead/Designer/Programmer/Analyst

·         Project Description: Registration and Game scheduling for minor hockey players and their teams. E-commerce site

·         Project Phases: Requirements, Architecture, Design and Prototyping

·         Team Size: 4-6

·         Responsibilities:

·         Project Management: Schedule and Resources

·         Elicitation of requirements

·         Data modeling and process flow diagramming

·         Development of report specifications

·         Development of Oracle database components and web-based reports 

·         PL/SQL coding to support requirements


Web-based Task and Hours Management System (1/99 – 6/00)

·         Roles: Technical Lead/Designer/Programmer/Analyst

·         Project Description: Management of a web-based site of employee hours, billing and expense issues, and task assignments

·         Project Phases: Requirements, Architecture, Design and Prototyping

·         Team Size: 3-5

·         Responsibilities:

·         Project Management: Schedule and Resources

·         Elicitation of requirements

·         Data modeling and process flow diagramming

·         Prototyping and testing

·         Development of Oracle database components

·         PL/SQL coding to support requirements


Mutual Fund Management System (1/97 – 10/99)

·         Roles: Technical Lead/Designer/Programmer/Analyst/Project Manager

·         Project Description: Manage investment capital for customers of a large mutual-fund back office

·         Project Phases: Requirements, Architecture, Design and Prototyping

·         Team Size: 3-5


Related Speakers View all

More like Rick