Brian Andrews
abl66n@r.postjobfree.com
Professional Results-driven senior Project/Program Manager with 14 years of
Profile Information Technology and business management experience in both the
public and private sector. Extensive experience in managing enterprise
IT projects through all phases of SDLC and execution of project
artifacts; i.e.: charter, budget, master schedule, WBS, resource
management, risk management, issue management, and the integration of
Project multiple SDLC methodologies. Adept at politically astute;
Highlights value-focused leadership with both off-shore and matrixed resource
pools.
Assess project feasibility, gather business requirements, and execute
project plans for the coordinated management of multiple projects of
varying sizes from $100k to $5m with emphasis on business value
realization.
Perform value analysis across portfolio of projects to determine most
efficient use of capital.
Develop and enforce quality assurance procedures and processes required
for project.
Perform gap analysis on statement of work to ensure success criteria
are well defined.
Drive objective hierarchy workshops to produce project plans, and
assign cross functional teams WBS-based work packages.
Deployed applications on multiple platforms LAN, WAN, Citrix thin
client & virtualilzed servers.
Build credibility, establish rapport, and maintain communication with
stakeholders at multiple levels, including those external to the
organization.
Develop master risk register, mitigation plans, and monitor costs and
escalate if variances are outside of established parameters for CPI,
SPI, DPI, ROI, NPV.
Created MS Project interfaces to post actual costs to individual tasks
and ensure appropriate accounting is applied for each schedule
activity.
Maintain continuous alignment of program scope with strategic business
objectives.
Implemented TSA mandated Planning, Programming, Budgeting, and
Execution System (PPBES) across multiple DHS projects.
Experience in project oversight and independent validation &
verification (IV&V).
Organize and manage supporting project resources, including both
on-shore and off-shore staff and internal resources from PMO and
functional organizations.
Instumental in developing PMO dashboard view of portfolio and ensuring
PM compliance with PMO metrics and reporting processes.
Managed training of help desk and contact center specialists on
redesigned Remedy ticket processing.
Employment April 2009 to June 2010 - Conversion Project Manager
Development Managed the automated assessment and conversion of Unemployment
Department Insurance and Disability Insurance Systems using the Ateras DB-Shuttle
State of tool suite.
California. Analyzed legacy IDMS DB and developed data migration rules and
strategies.
Managed the conversion of the IDMS database schema design to the DB2
DDL and the modification of COBOL programs required to extract the IDMS
data from the IDMS database.
Developed and maintained 700 task MS Project Plan for collection and
classification of 3 million lines production code and installation of
converted software and data migration.
Coordinated issue identification, escalation, and delivery of
resolutions by vendor Ateras to EDD.
Assisted in the creation of HP Quality Center Test Plans and Quick Test
Professional scripts with over 1500 checkpoints for the testing of the
converted UI / DI applications.
Built credibility, established rapport, and maintained communication
with stakeholders and the EDD division chief.
Managed the data migration of MS Dynamics CRM & ERP accounting system
to NetSuite cloud computing platform.
Chevron, Inc. November 2007 to March 2009 - Business Case Analyst
San Ramon, CA Initiated value-based trade-off discussions with project teams based on
Major oil a stochastic business case modeling including Monte Carlo probabilistic
exploration, range assessments, value-ranging uncertainties, validating capital
production, costs, estimating operating costs, calculating and managing earned
refining and value metrics.
marketing firm. Facilitated stakeholder workshops utilizing objective hierarchy tools,
strategy table tools, range value assessment tools to create
hybrid-alternatives in the project design phase.
Performed Value Chain analysis, and developed Tornado Charts, Cash Flow
Waterfall Charts, and Cumulative Probability Curves (S-Curves) to track
the NPV/ROI of projects within the portfolio.
Deployed 100+ Business Value Realization (BVR) processes created to
assist portfolio of major capital projects in attaining and sustaining
value to the business units.
Managed portfolio of projects based on Earned Value metrics CPI and
SPI.
Assisted business units in performing the ten-step BVR Value Curve
process to deliver exceptional value to the most important customer.
Audited CMMI control processes and BMP metrics for new product
development.
Instrumental in the successful implementation of SAP Solution Manager
Business Blueprint.
Embarcadero System August 2004 to October 2007 - Project Manager
Corporation Created / Managed 2700 task project plan utilizing TSA mandated
Alameda, CA Planning, Programming, Budgeting, and Execution System (PPBES).
Systems Integrator Supervised and coordinated the activities of multiple project teams of
- Transportation field engineers in order to meet both schedule and budget targets on
Industry. three projects with a combined value of over six million dollars.
Procured materials, coordinated shipping, and secured human resources
for meeting the demands of projects located in the pacific northwest.
Implemented oversight tracking process to ensure compliance with
independent validation & verification (IV&V) and significantly reduced
non-conforming items (NCR) .
Accelerated the Pierce County Terminal project plan to complete in half
the scheduled time. Initially, the terminal was scheduled to be
operational in four months; my team achieved operational status in
sixty-five days.
Utilized Government Accountability Office's (GAO) Principles of Federal
Appropriations Law; aka "the Redbook" related to TSA funded projects.
Designed project specifications had to include specific management
controls to ensure GAO transparency as to what was being deployed, the
type of software license, and who held the license on integrated
components.
Developed strategy for deployment of Citrix App-V virtualized clients
across multiple sites.
Implemented AXE Enabler to manage VOIP traffic and replace PBX analog
dialer.
Managed portfolio of projects based on Earned Value metrics CPI and SPI
Designed data warehouse / data marts for TWIC card transactions for
Port of Oakland.
Analyzed customer DB and developed migration scripts for initial load
and referential integrity.
Utilized LDAP to model DNS directory trees including dual
authentication for role based access for Transportation Worker
Identification Credential (TWIC) card users.
Designed, developed, and deployed TWIC compatible access control card
system for six marine terminals at the Port of Oakland.
Contributed to the design, development and implementation of PMO
dashboard. This tool facilitated PMO project audits, PM
accountability, ITIL compliance.
The Doctors August 2003 to January 2004 - Project Manager
Company Redesigned deployment process of medical malpractice insurance forms.
Napa, CA Reengineered the form update process in response to changing state
Physician-owned requirements while supervising a team of 10 consultants. Established
professional tangible success criteria and redesigned the quality assurance testing
liability plans for individual medical malpractice insurance policy forms.
insurer. Implemented a Rational Robot script engine as a business rule
repository to dynamically create anticipated baseline results and
generate quality assurance scripts. Developed regression test scenarios
Accomplished IT to ensure core application functionality and data accuracy of form
Manager: generation in complex healthcare billing system.
. Created quality
assurance Created quality assurance test plans to accommodate 400 insurance
test plans to policy forms with over 30,000 text combinations.
accommodate Developed data migration scripts to load data through the application.
400 insurance
policy forms Performed use case analysis for billing system in an environment with
with over 30,000 frequently evolving business rule requirements.
text Managed projects based on Earned Value metrics CPI and SPI
combinations. Managed and tracked version control of multiple releases of software
components from development through the SDLC into production using
Borland's StarTeam.
April 2001 to July 2003 - Project Manager / Oracle, SQL Server / Visual
Chevron, Inc. Basic, Powerbuilder Developer.
San Ramon, CA Recruited initially on a six month contract and subsequently renewed
Major oil for an additional twenty-one months based on performance. SDLC
exploration, responsibilities included business analysis, requirements gathering;
production, project planning, budget estimating, development, coding, testing,
refining and deployment and training. Conceptualized, developed and managed 2100
marketing firm. task project plan for $4m SAP interface for asphalt division.
Developed and maintained vendor master schedule for TATA consulting
with a 15+ sub-project rollup into the master project
Deployed Citrix thin client platform to vendor partners in 9 locations
. across the US.
Performed data analysis, data modeling and technical writing to create
requirements, use cases, business specifications, system/functional
requirements and technical specifications for both on-shore and
offshore Powerbuilder development.
Managed projects based on Earned Value metrics CPI and SPI.
Effectively managed and set milestones on over 30 V/B and Powerbuilder
projects in both onshore and offshore project portfolios via in-house
CPDEP process.
Documented and implemented BMPs for product quality automated test
system.
Developed data migration strategies for data loads into SAP and
Business Objects data mart.
Regression tested desktop applications for 100+ desktops in new XP
environment tracked and resolved issues related to platform upgrade.
Merrill Lynch December 1996 to April 2001
San Francisco, CA Project Manager / Lead Developer - Benefit and Investment Solutions
Global financial Hired initially under the auspices of Wells Fargo Bank prior to
Management & divestiture of the 401(k) group. Oversaw a production support team
Advisory comprised of 12 directly reporting IT professionals furnishing 24/7
Company. support of an accounting system providing daily valuations of an $18
billion portfolio. Resolved conflicts in task priorities, resources,
and/or technical requirements. Managed a re-engineering and
implementation initiative of PeopleSoft payroll deduction EDI data
feeds to multiple clients represented by Safeway and AAA Autoclub.
Designed and deployed a Microsoft Access issue tracking system for
tracking requests, approving software changes, scheduling software
deployments and providing metrics by business group of services
rendered by technology group.
Acted as system liaison between six business groups and the technology
group.
Saved $1.8 million in expenses related to fractional share accounts.
Interfaced with user communities to develop data flow processes and
logical data models.
Manage the application and data migration of a COBOL/VSAM 401K
accounting system to an HPUX Oracle/PowerBuilder client server
application.
Designed and developed a MS Access and VB Script print application to
generate buffet style healthcare enrollment forms and fulfillment
forms.
Southern Pacific September 1990 to December 1996
Transportation OS/2 DBA, LAN Administrator, Fleet Management Department
Company Recruited to project manage the design and re-engineering of mission
San Francisco, CA critical accounting applications. Acted as OS/2 LAN administrator and
Rail DB2/2 database administrator for 80 OS/2 and DOS clients, utilizing
transportation PowerSoft PowerBuilder, Microsoft Access, Fox Pro, MVS Nomad, MVS
firm. Mark4, DB2/2, and Data Warehouse GQL.
Developed unit test plans and integration test plans to ensure
functionality of code.
Performed installation of hardware and support function for end-user
applications including MS-Office, Word Perfect, and Lotus Smart Suite.
Developed and maintained Unix shell scripts and UNIX Chron jobs to
perform data migration, referential integrity checks, and
reconciliation on the client server platform.
Dole 1988 to September 1990
(Packaged Foods Budget Analyst/Programmer, Transportation and Operations Department
division) Hired to provide data modeling and budget analysis of transportation
San Francisco, CA and warehousing costs associated with inbound pineapple product lines
from Thailand and the Philippines. Developed and launched standardized
rate input system to track freight rates.
Technical Profile
Frameworks: PMBOK, CPDEP, ITIL, ITSM, RAD, JAD, Scrum, RUP, XP, CMMI,
DW
Project Metrics: EVM, CPI, SPI, NPV, DPI, ROI, ETC, EAC, Effort Driven
Scheduling, LOE
Platform/ Language: VB, ASP, VBA, COBOL, .NET, Client Server, PLSQL,
Transact
Network Platforms: Cisco 4500 LAN / WAN, Cisco Aironet Bridge, Citrix
App-V Client
Tools: Rational Robot, MS Project 2003/2007, Visio, Quick Test
Professional QTP, Business Objects, Crystal Ball, Project Server 2003
Databases: Informix, Oracle 9.x, SQL2003-2008, IDMS, DB2, MSAccess,
ETL, DTS
Security: LDAP, Active Directory, Pelco Video Analytics; VistaScape
Education BA, Business Administration (Management Information Systems and
Certifications Accounting
Concentrations - passed CPA Exam), 1987 California State University,
Sacramento, CA
MBA, Technology Management, 2000 University of Phoenix, Phoenix, AZ
PMI member - certified PMP.
Languages Proficient in conversational Spanish.
http://www.linkedin.com/in/brianandrewspmp