LinkedIn Profile (w/ recommendations):
http://www.linkedin.com/in/williammercado
SUMMARY
Project management professional (PMP) with first rate skills in directing
vendor and/or in-house teams through the various software life-cycle phases
utilizing the Project Management Institute's framework. This includes
scope definition, identification of business goals, risk management,
project planning, issue management, tracking and reporting, coordination
with interfacing projects/departments, project evaluation and project
change management.
Accomplished at maintaining healthy stakeholder relations via timely
communication to deliver a product that satisfies the customer's needs.
Excellent communication, organizational, and leadership skills with
expertise in:
. Project Management following the PMI knowledge areas
. Software Development Lifecycle (SDLC)
. Process definition and improvement
PROFESSIONAL EXPERIENCE
PMI SVC - Sacramento
Program Mgr (volunteer) for Content Management for an EPM Live SharePoint
implementation. 2009 - present
CAISO - Folsom, Ca 2006-2009
Project Manager
. Managed a cross-functional project team through the system development
life cycle to create an enterprise-wide centralized Enterprise
Dictionary (Casewise) and Enterprise Repository using Oracle DB w/
Streams to relieve (17) production systems from the burden of report
generation and adhoc queries. This resulted in a decision to change
the recommended technology since the team identified instabilities in
the technology that would have crippled the company during production.
. Managed multiple small power industry projects at the same time for a
period of 7months contributing to a reduction in strategic project
list backlog.
. Managed a 15-person cross-functional team through the full system
development life cycle, for a previously failed project, to replace
hardware and implement a web enabled, enterprise-wide, employee time-
reporting module addition to the Oracle E-business ERP suite. The
project was completed on time, under budget and resulted in payroll
efficiencies.
. Participated in a Process Improvement Change Advisory Board which
provided templates and guidelines for the Project Development Cycle.
This helped improve the skill set among project managers.
Amerit Consulting 2005-2006
Project Manager Contractor at CAISO, Folsom, Ca
. Managed a cross-functional project team through the Requirements phase
of the project to configure Charge Codes (150) for a new power market
using a customized Settlements & Clearing Product. While this provided
a clear picture of what needed to be done it also provided
understanding of the dependencies to other projects in the MRTU
program thus establishing clearer program priorities.
Sapphire Technology 2003-2005
Sr. Systems Analyst Contractor at CAISO, Folsom, Ca
. Provided scope definition, identification of risks, Requirements
Management Plan, task work-breakdown structure, time durations and
time tracking thus providing the project with key artifacts for the
initial phases of the project. This provided a clear way to determine
if the project had implemented everything it promised.
. Collaborated with other analysts to produce a Use Case Guideline
document which resulted in consistent requirements documentation from
project to project.
Paragon Data Inc 1995-2003
Principal Consultant (owner)
Provided consulting services in the area of Business/Systems Analysis. This
included meeting facilitation, scope definition, requirements management,
work-breakdown structure and data modeling. These were achieved using
Jacobsons Use Case techniques and the RUP methodology for Software
Development Lifecycle. The use of best practices resulted in higher
probability of project success.
Senior Analyst at County of Santa Clara (2002 - 2002)
. Produced an enterprise wide conceptual data model as part of the IT
Strategic Plan.
Lead Analyst at Westin Engineering Inc. (2000 - 2001) Rancho Cordova, Ca
. Managed requirements (including the task work-breakdown structure,
time durations and time tracking) using the RUP methodology on a web
portal project for the Detroit Waste Water District, using TIBCO
middleware technology and Java.
Use Case Mentor at Airtouch/Vodafone (2000 - 2000) Walnut Creek, Ca
. Mentored Business Analysts on the Global Wireless Internet Portal
project on how to represent requirements using the Use Case technique.
This resulted in a very successful implementation of wireless access to
a number of third party services integrated as one on the Vodafone web
portal in Australia.
Lead Systems Analyst at International Billing Systems Inc. (1998 - 2000)
El Dorado Hills, Ca
. Managed requirements on a number of projects aimed at Factory
Modernization and Factory Integration solutions including e-commerce.
This resulted in a number of factory improvements in production time
and cost.
Lead analyst at Ca. Dept. of Industrial Relations, Division of Workers
Comp.( 1998 - 1998) S.F., Ca
. Collaborated with the project manager, and project architect to write a
Concept of Operation Document for the submission of Workers
Compensation Information via an EDI interface, based on IEEE P1362, to
the Workers Compensation Information System to enable Decision Support
Analysis. This resulted in approval of the project to be funded.
IV&V Analyst at Ca. Dept. of General Services (1997- 1998) Sacramento,
Ca.
. Provided guidance/feedback on requirements creation for the Feasibility
Study Report (FSR), RFP and processes used for the CSPN (California
Statewide Procurement Network) program as per IEEE standard 1012 to
review Feasibility Study Report (FSR).
Analyst/Data Modeler at Ca. Dept. of Motor Vehicles (1997 - 1997)
Sacramento, Ca
. Managed requirements at the State of California Department of Motor
Vehicles for the Motor Carrier of Permit program and provided logical
data model using standard relational methodology.
JAD (Joint Application Design) Lead at Ca. Department of Corrections
(1995 - 1997) Folsom, Ca
. Designed the Transportation Subsystem that was part of an overall $45
Million System Integration Program for the State of California
Department of Corrections.
TOOLS USED
Programming Languages: Oracle PL/SQL, FORTRAN, C, PASCAL, Assembly
language and Firmware
DBMS's: Access, Oracle, DB2 UDB and Rdb
CASE Tools: Rational Rose, Oracle Designer 2000, Oracle
Developer 2000, Oracle Case 5.1
Requirements Tool: Rational RequisitePro
Office Tools: Microsoft Office, Visio, Microsoft Project,
Microsoft Project Server
Document Control: Documentum, SharePoint
EDUCATION
- B.S. in Information and Computer Sciences, U.C. Irvine
- U.C Davis - Project Management courses: Time & Cost Management, Risk
Management, Quality Management
- Graduate Level Courses: Operations Management, Macroeconomics, and
Introduction to Software Engineering
- Coursework on Object Oriented Project Management (OOPM) at Advanced
Programming Institute Inc., El Dorado Hills, Ca.
Certificates
- Project Management Professional (PMP since 2003)
- ITIL Foundation Certification 2007
- CMMI class Certificate of Completion - 2007
- OOPM certificate in 2000.
Language Proficiencies: English, Spanish, some Portuguese