Project Manager

JOHN M. CRUMPTON, III

**** ***** *** ***

Mount Pleasant, SC 29466

Cell 917-***-****

****.*.********@*********.***

HIGHLIGHTS OF QUALIFICATIONS

. 20+ years of Fortune 500 experience with a strong background in

Trading Systems, Accounting, Finance, Operations, Direct Marketing,

and Technology.

. 10 + years of technology experience as a business analyst defining and

documenting user requirements, functional specifications, and use

cases.

. 5+ years experience designing and developing databases and user

interfaces, mapping data, and working with MS Access, SQL Server, and

Oracle.

. Fluent in a broad range of technologies including Business process

tools such as Microsoft Project, Microsoft Access, Microsoft Excel,

Microsoft Word, Microsoft Power Point, Microsoft Visual Basic 6.0,

Visio, Oracle, Momentum Financials, and SQL

. Excellent verbal and written communication skills.

. Exceptional analytical skills.

. Experience managing UAT testing initiatives.

. Exceptional ability to build productive relationships with colleagues

and clients across all functional and technical disciplines.

. Experienced with all phases of the System Development Life Cycle.

EXPERIENCE

CGI Federal - Charleston, SC

Consultant/Business Analyst - Software Support - January, 2010 to Present

. Provide on-site Momentum Financials support for the United States

Department of State Charleston Financial Service Center. Interact

with Post Accountants to resolve Accounting errors and provide

transactional reports using Oracle SQL.

. Perform tasks related to Annual Close,including gathering closing

requirements; testing automated closing processes; providing support

and analysis during closing.

. Capture and analyze business requirements for process improvements and

system upgrades.

BLACKBAUD, INC. - Charleston, SC

Business Analyst/Interaction Designer - Software Development - April,

2008 to December, 2010

. Developed designs for new functionality and to improve existing

functionality for a direct marketing application. Interacted with the

application's Product Manager, Program Manager, System Architect,

Application Developers, Quality Assurance team, and clients to

translate Marketing requirements into a usable design. Designs

included improving existing vendor functionality, adding functionality

to capture source analysis rules for direct mail campaigns, and adding

direct marketing functionality for sponsorship programs and membership

programs.

. Worked with existing clients to document and develop an understanding

of their processes and how the direct marketing application is used in

a client setting. Documented client concerns, captured ideas for new

product features, and provided suggestions on how to better use the

application. Worked with the application's Product Manager to

prioritize captured client information for product roadmap.

. Engaged in Enterprise sales pursuits during initial requirements

gathering phase. Captured direct marketing requirements. Worked with

the application's Product Manager to log requirements for

prioritization.

JOHN M. CRUMPTON, III

1412 Water Oak Cut

Mount Pleasant, SC 29466

Cell 917-***-****

EXPERIENCE (continued)

BANK OF NEW YORK/MELLON CORP. - New York, NY

Technology Project Lead - Investment Banking - October, 2006 to April,

2008

. Lead project to develop a browser-based, Fixed Income Trade Reporting

Application for Capital Markets Group to automate regulatory

reporting. Analyzed Bloomberg trade data feeds and Pershing settlement

files to map data to SQL Server database. Worked with business

partners to capture user requirements. Designed and developed

prototype user interface and reports. Worked closely with off-shore

development team to further clarify specifications. Developed project

plan and reporting project status to Technology and Business

management.

. Managed project to install Collateralized Loan Obligation tracking

system for Capital Markets Fund Group. Installed and tested

development version of application and database. Learned application

functionality. Determined data requirements. Loaded data and

reconciled data. Developed and executed test scripts. Developed and

maintained project plan. Reported project status to Business and

Technology management. Assisted vendor with user training and

application demonstration.

. Closed project requirements for application to support nightly file

downloads for Trade Support Group. Developed and executed test

scripts to test application functionality. Learned functionality of

Bloomberg Integrated Gateway application. Reported status of project

to Technology management.

UBS INVESTMENT BANK - Stamford, CT

Technology Project Lead - Investment Banking - August, 2005 to October,

2006

. Led data loading stream of project to merge client data systems, as

part of an effort to move Municipal Securities Group into Investment

Bank. Managed a team of Analysts to develop testing approach, test

scripts and perform user acceptance testing. Tracked and reported

results of user acceptance testing, using Mercury Test Director, to

Business and Technology management. Worked with Technology Group to

scrub and verify data. Managed a team of Analysts during

implementation testing effort and post-implementation data input.

. Served as co-stream lead to set up of static data in client

information repository for "in-sourcing" of Dillon Read Capital

Management Business. Worked with Business and Project Leads to

capture "fluid" data stream requirements. Analyzed with subject

matter experts best approach for setting up client data. Communicated

with Data Entry Group Management to acquire resources. Tracked and

reported data input required volumes and reported status to Data Entry

Group Management and Project Office.

. Closed troubled project to transition settlement instruction creation

to a new functional area to meet Sarbanes-Oxley regulatory

requirements. As part of a project team, captured existing process

to create settlement instructions, developed new process, identified

and trained new users. Tracked and reported results to Head of Global

Data Management.

. Served as stream lead for closing troubled project to install ADP's

ICI/IMPACT product for Fixed Income Securities Group. Led a team to

close reconciling requirements, static client data requirements, and

user training requirements. Managed user acceptance and

implementation testing efforts for Data Entry stream. Developed and

maintained project plan. Reported status to Global Head of Data

Management and Global Fixed Income Management.

. Presented relevant documentation to the Data Management Compliance

Group to assure all project deliverables met Sarbanes-Oxley

requirements.

JOHN M. CRUMPTON, III

1412 Water Oak Cut

Mount Pleasant, SC 29466

Cell 917-***-****

EXPERIENCE (continued)

WACHOVIA CORPORATION - Charlotte, NC - 1990 - 2005

Wachovia Corporation - January 2003 to August, 2005

Senior Business Analyst - Retail Mortgage

. Led requirements gathering, user testing, and implementation of link

between two legacy loan origination systems and general ledger systems

during South Trust Bank merger.

. Managed initiative to develop reporting structure for measuring cross-

selling mortgage and retail banking products.

. Coordinated user acceptance testing for bi-monthly POLARIS loan

origination system upgrades.

. Supported and performed testing for Mortgage Accounting Group during

PTP/Impact loan origination system releases.

. Developed and delivered training and training documentation to

Business partners.

Wachovia Corporation - June 1998 to January, 2003

Application Developer/Business Analyst - Credit/Online Operations

. Analyzed Business Processes, documented, designed, developed,

implemented, and supported applications on a departmental level to

automate manual accounting and reporting processes.

. Served as a beta test client for First Data Resources' Report

Organizer and Writer software.

. Facilitated conversion of departmental applications from Card

Processing Solutions to First Data Resources.

. Facilitated conversion of departmental applications for sale of credit

card assets to MBNA, NA.

. Software used included MS Access, Visual Basic for Applications,

Visual Basic 6, Rumba ObjectX, Oracle, Mobius Document Direct, and

Mobius DocuAnalyzer.

First Union National Bank/First Union Home Equity Bank - September, 1990

to June, 1998

Accountant - Retail Credit

. Coordinated and expedite month end closing process, including the

participation of assets, income and expense allocations, and

amortizations

. Coordinated the sale of assets.

. Reconciled general ledger accounts.

. Performed monthly review of loan loss charge-offs to assure compliance

with legal agreement between the Federal Deposit Insurance Corporation

and First Union National Bank.

. Performed user acceptance testing on systems development projects.

. Developed system queries for ad hoc reporting Process invoices.

. Performed special projects as requested by management.

EDUCATION

MBA - University of North Carolina at Charlotte, 1997

BA, Government - Campbell University, 1987

PROFESSIONAL TRAINING

Introduction to Oracle: SQL and PL/SQL, 1999

Develop PL/SQL Program Units, 1999

Dale Carnegie, 2000

Fundamentals of Consulting, 2003

Introduction to Project Management, 2004

Management Essentials, 2006

Contact this candidate