Project Manager Management
Resume:
James Barnes
Email: *********@********.***
Address: *** ****** ***
City: Albany
State: CA
Zip: 94706
Country: USA
Phone: 415-***-****
Skill Level: Experienced
Salary Range: $150,000
Primary Skills/Experience:
See Resume
Educational Background:
See Resume
Job History / Details:
James D. Barnes CPA, MBA, PMP, MCSD
426 Evelyn Ave.
Albany, CA 94706
*********@********.***
HIGHLIGHTS
* Seasoned leader with deep and broad corporate IT experience in business intelligence, web applications, operations, and systems integration domains
* PMI certified project manager with Big 5 management consulting experience
* Results driven, collaborative leader and skilled individual contributor
EXPERIENCE:
Esurance February 2012 - November 2012
Senior Manager - Business Intelligence
Managed the BI organization for Esurance, consisting of 23 full time and 10 offshore contract resources
* Designed reporting platform strategy and execution plan for consolidating/retiring 5 legacy end of life reporting applications onto SSRS platform, including programmatically generating RDL files for 400+ reports from existing application meta data repositories
* Built POCs for elemenets of proposed solution including new report portal and SSRS reports
* Developed innovative approach for calculating Unearned Premium based on audit findings
* Lead migration of legacy VSS database to TFS and updated database deployment process
Wells Fargo - Vice President September 2006 to January 2012
Business Intelligence Capability Development Manager
Built the business intelligence function for the call center sales channel for Wells Fargo Advisors from the ground up
* Developed current state assessment and subsequent BI strategy
* Lead implementation of a SQL Server sales and marketing data mart from scratch, integrating 18 upstream systems to paint a complete end to end picture of the call center sales operation from lead generation through account opening, funding, bank cross sell, and customer satisfaction, for 3 lines of business in the Independent Brokerage Group
* Developed customer segmentation experiment and related analytics to determine effect of Customer Profiling Model script in call center. Model was adopted based on experiment results and script was deployed across the entire organization, fundamentally changing how call center reps interact with customers. Well received by reps, customers, and press.
* Developed operational and executive reporting packages delivered through self service, ad hoc, scheduled subscription, and concierge modes, tailored to consumer requirements
* Implemented all layers of the Microsoft BI stack (SSIS, SQL Server, SSAS, SSRS) on SQL 2008 R2 as well as PowerPivot cubes, Tableau dashboards, and SharePoint distribution site
* Implemented automated data quality tool for testing data mart integrity and validity
* Built relationships with key IT stakeholders, marketing partners, and executive management - provided key interface role between IT and executive management for BI related issues
* Developed work prioritization process to rationalize resource allocation and scheduling
* Recruited all-star delivery team - wrote job reqs, conducted technical interviews, hired staff
BI Application Manager
Lead BI application development team supporting cross sell BI reporting application in Wells Fargo Wholesale Technology Group
* Lead rewrite of classic ASP/SQL 2000 BI application to .NET/SQL 2005 BI stack
* Designed and implemented SSIS ETL, SSRS reports, SSAS cubes, web application enhancements, and lead joint technical/business teams in implementation
* Integrated various new data sources into the application database resulting from Wells/Wachovia merger. Imported approximately 40 million rows/month.
* Managed BI development team and work queue. Implemented Scrum processes.
* Provided tech/business interface role. Managed client relationships.
Senior Project Manager
Delivered various strategic projects for International Financial Services group
* Developed cross sell activity valuation model, pivotal in gaining organizational support for International Cross Sell Strategies operations and projects.
* -Gold Rush to Cross Sell- Incentive compensation plan. Developed financial forecasts. Garnered support for the plan in presentations to senior managers. Negotiated comp rules with IFS senior leaders. Developed payment process, supporting workflow website, and all reporting/analytics for all stakeholder audiences.
* Built and managed the delivery team. Developed job descriptions, interviewed, hired, and managed technical resources.
Fireman`s Fund Insurance Company (Contractor) 2006
Business Systems Analyst/Project Manager
Managed data conversion project for online policy viewing application, converting 6.5 million policies in the production environment. Developed automated approach to mainframe QA testing. Collaborated with LOB leaders to develop use cases/requirements. Developed automated work queue and resource management tool.
Wells Fargo (Contractor) 2004 - 2005
Fraud Prevention Group - Online Bill Pay
Assessed current state of the market for fraud detection and prevention software. Implemented code hardening and testing tool, enhancing security practices of bill pay development team. Managed vendor selection process for Bill Pay business intelligence platform.
Program Management Office - Online Customer Service Group
Facilitated weekly project enhancement/integration sizing meetings. Taught technical managers how to write IT project business cases/NPV analysis. Developed master project list for annual funding approval process.
Chevron (Contractor) 2004
Program Management Consultant - Enterprise PMO Group
Assisted the client in framing and understanding the IT resource management problem domain in the Chevron IT portfolio management context. Developed an application to automate the existing IT resource management process including supply, demand, and availability forecasts. Project scope spanned initial charter through application rollout and end user training.
California State Automobile Association 2002 - 2004
Program Management Office Consultant
Facilitated top to bottom PMO reorganization. Implemented project and portfolio management best practice processes and supporting tools.
* Led a team of 5 senior managers in the development of a current state SWOT analysis for enterprise PMO organization. Developed reorganization action plan based on the assessment. Presented the plan to the executive committee. Plan was adopted.
* Developed PMO service area framework and incumbent organizational model.
* Created and deployed project portfolio master schedule and process, including resource demand/supply and project interdependencies in support of capital budgeting processes.
* Developed a scoring model for assessing project alignment with corporate objectives.
* Led a cross functional team of 8 in the selection of a portfolio management tool. Developed evaluation approach, resource plan, and schedule. Managed the delivery.
* Led a team in developing project budgeting, cost tracking and reporting tools. Developed standardized performance reporting package for all portfolio programs and projects.
Deloitte Consulting 2000 - 2002
Managing Consultant
Provided project management and technical leadership to joint client consultant teams in delivering business results through technical solutions implementations. Leadership responsibilities also included client relationship management, business development, staff development, and recruiting.
* Established a PMO for a large network security program ($24MM) for a national health insurer. Developed security risk mitigation scoring model to measure program progress.
* Established a PMO for the CIO of a major internet startup.
* Managed a team of 18 Deloitte consultants in delivering a large systems integration program.
* Key leader in building DCs position as the dominant WebMethods practice in the Bay Area.
Lante Corporation 1997 - 1999
Senior Consultant
Provided full life cycle application development and systems integration services to clients from startups to Fortune 50 companies.
EDUCATION:
San Francisco State University San Francisco, CA
Master of Business Administration
Golden Gate University San Francisco, CA
Masters in Software Engineering (coursework)
University of California Extension Berkeley, CA
Professional Certificate in Systems Analysis, Design, and Management
Awarded with honors.
University of California Santa Barbara
Bachelor of Arts in Business Economics
Accounting and Finance
CERTIFICATIONS AND LICENSES:
Project Management Institute
Certified Project Management Professional
Microsoft
Microsoft Certified Solution Developer
Microsoft Certified Product Specialist - Access
Microsoft Certified Product Specialist - VB 1998
State of California
Certified Public Accountant (lic. # 50280e - inactive status)
Contact this candidate