Clarence Harvard Jr. *** Sunnybrook Rd.

Raleigh, NC 27609

984-***-****

919-***-****

ad01vc@r.postjobfree.com

www.linkedin.com/in/harvardc0211

OBJECTIVE: To obtain a Business Analyst/Lead position working with Business Units, Project Teams, Process Teams to ascertain initiatives relative to the improvement of Business Processes across the organization with a growing dynamic company offering potentials for technological enhancement and career advancement.

SUMMARY: Twenty-Five Years of Business Information Systems Analysis experience working with a variety of

Mainframe/Fourth Generation Languages and Relational Database Management Systems and n-tier architecture applications gathering requirements for financial, sales and marketing applications designing ETL/OLAP applications along with Data Visualizations Processes utilizing Microsoft toolset technology on various platforms in the Healthcare, Insurance,

Telecommunications, Banking and Pharmaceutical industries. Excellent balance of business and technical knowledge and outstanding analytical skills. Excellent verbal and written communication skills.

SOFTWARE: Microsoft Windows/NT, DBMS- DB2, Salesforce, Power BI, Oracle, Agile, RUP, Waterfall, Scrum, Tableau,

Jira, Qlikview, Qliksense, JAD, Six Sigma, SQL Server 2008/12, Agile, SSRS, SSIS, SSAS, Unix, DB2, SAP R/3, Toad,

VBA, Visual-Basic 6.0, SQL Server 2012, Windows NT 4.0, Microsoft Project, Microsoft PowerPoint, Lotus Notes 4.6, IBM 3270 Emulation, Crystal Reports, BUSINESS OBJECTS, COGNOS, TERADATA, INFORMATICA, SIX SIGMA,

WEBSPHERE, SHAREPOINT

HARDWARE: IBM 370 Architecture, IBM 30XX, MVS/ESA, IBM 4341, IBM PC's & Laptops Compatibles, UNIX Client Server Environment, Laser Jet Printers, IBM AS400, IBM 3090, OS/390, Novell, Client/Server, OS2, HP/UNIX, AIX

PROFESSIONAL EXPERIENCE:

09/19 - 4/21 Conduent, Raleigh, NC

Sr. Business Analyst

•Partner with Business teams and Process Experts to write requirements for Customer Success Platform

•Engagement with System and Process experts to help identify solutions to business pain points

•Hands-on configuration experience on SFDC Platform

•Engagement with Change Management team to plan for Change Management as needed for each initiative

•Drive systems-related project execution in direct partnership with IT (development scrum teams)

•Lead UAT business planning, execution, and go live

•Partner with project stakeholders, IT, and System Administrator teams to prepare for Go-Live and post-go live support

•Assisted in developing Project Scope, Business Requirements and Functional Requirements for Salesforce applications with internal teams and clients.

•Responsible for the utilizing Agile/Waterfall methodologies for client’s business units Depts.

•Facilitated the creation of test scenarios and test scripts.

Environment: Windows NT, UNIX, Oracle 11i,Oracle CRM, Microsoft Dynamics, SAP CRM, Salesforce, Oracle ERP Suite, Agile, Scrum, Waterfall,

5/12 – 12/18 Career Match Solutions, Raleigh, NC

Sr. Business Analyst

•As a Business Lead for The State of North Carolina Government Institutions, reviewed clients’ information needs and provided feasibility studies and analytical reviews.

•Partner with Business teams and Process Experts to write requirements for Customer Success Platform • Engagement with System and Process experts to help identify solutions to business pain points • Hands-on configuration experience on SFDC Platform.

•Engagement with Change Management team to plan for Change Management as needed for each initiative • Drive systems-related project execution in direct partnership with IT (development scrum teams)

•Lead UAT business planning, execution, and go live.

•Applying good judgment in balancing and advocating for the use of Agile delivery concepts and business analysis tools and techniques.

•Responsible for eliciting requirements from customers and subject matter experts and writing business requirements documents for Government Agencies.

•Leveraged clients existing IT framework/CRM systems for better data visibility and system integration for Salesforce systems.

•Assisted in developing Project Scope, Business Requirements and Functional Requirements with internal clients for Salesforce Applications.

•Responsible for creating Data Governance Policies, Business Glossary, Data Dictionary, Reference Data, Metadata, Data Lineage, and Data Quality Rules.

•Responsible for Traced and catalogue data processes, transformation logic and manual adjustments to identify data governance issues.

•Assisted in developing Project Scope, Business Requirements and Functional Requirements for Salesforce applications with internal teams and clients.

•Responsible for the utilizing Agile/Waterfall methodologies for Agency’s Revenue Depts.

•Facilitated the creation of test scenarios and test scripts.

•As Business Lead, created Gantt charts to manage milestone progress.

•Responsible for gathering business requirements for government agencies.

•Performed business requirements gathering utilizing Agile, Waterfall methodologies.

•Responsible for the Procurement for external services for finding, agreeing terms and acquiring goods, services or works from external sources, often via a tendering or competitive bidding process for Governments Agencies.

•Gathered requirements for State Government Clients Payroll, Human Resources, Finance, Benefits, SAP CRM/ERP Modules platforms.

•Utilized SSAS for moving relational data into multidimensional databases (cubes).

•Responsible for gathering requirements for State Payment Systems and Vendors.

•Met with business stakeholders to determine long-term software needs.

•Performed analysis and demonstrations of software as needed to help explain functionality.

•Worked with businesses to prioritize feature requests.

•Gathered business requirements for Government clients multiple CRM platforms.

•Responsible for standards creation for Government Clients Data Dictionary.

•Created Functional Requirements, Business Requirements documents and test documents.

•Worked with external vendors to research viability of software solutions to meet the business needs.

•Analyzes new requests for data and reporting, work with business units to elicit and document business requirements for handoff to technical teams.

•Responsible for creating Functional Requirements Documents and Business Requirements Documents for Government Agencies.

•Responsible for gathering requirements for Regulatory Reporting for all Governmental Agencies.

•Responsible for maintaining Scrum and Agile product backlogs documents.

•Design layouts for the system and define data requirements to support design.

•Responsible for data reporting utilizing Excel for pivot tables, charts, graphs, formulas, exporting, VLOOKUPS.

•Identifying, evaluating and developing systems and procedures, which are cost effective and meet user requirements?

•Responsible for development of Elkview financial reporting dashboards.

•Utilized Agile, Waterfall and Scrum methodologies.

•Create specifications (Use Case, User Interface Specifications, Data Mappings, Swim Lanes, etc.) for systems to meet business requirements.

•Assist in testing application to ensure that the application meets the functional requirements (traceability).

•Responsible for Q&A process thru implementation.

•Responsible for gathering requirements for Supply Chain Systems.

•Responsible for developing BI reports financial reports utilizing Business Objects, Crystal Reports.

•Developed Cognos reports for financial reporting purposes.

•Performed training to end users on applications.

Environment: Windows NT, UNIX, Oracle 11i,Oracle CRM, Microsoft Dynamics, SAP CRM, Salesforce, Oracle ERP

Suite, Agile, Scrum, Waterfall, SQL Server 2005/2008, SSAS, SSRS, SSIS, DB2, Cognos Series 7/8/10, Business Objects XI, Crystal Reports, Qlikview

1/12 – 5/12

Sabbatical (Been under a doctor’s care (cardiologist) but been cleared to go back to work as of May 2012, I have keep abreast of my skills by reading White Pages on IT tools sets on the last technology trends and also by talking with colleagues.)

9/11 – 12/11 IT Manna Corp, Marietta, GA

BI Analyst

•Analyzes new requests for Dell Company for data and reporting, work with business units to elicit and document business requirements for handoff to technical teams.

•Utilized Business Objects SDK/Enterprise for application design.

•Utilized Crystal Xcelsius to create dashboards to reflect KPI’s.

•Utilized Business Objects/Crystal Reports to develop extensive financial reports.

•Design layouts for the system and define data requirements to support design

•Identifying, evaluating and developing systems and procedures, which are cost effective and meet user requirements?

•Assist in testing application to ensure that the application meets the functional requirements (traceability).

•Responsible for Q&A process thru implementation.

•Responsible for developing BI reports financial reports utilizing Crystal Reports.

•Developed ETL processes of overnight data loads.

•Developed queries to analyze financial data.

Environment: Windows NT, Unix, Oracle 11i, Oracle ERP Suite, SQL Server 2005/2008, PL/SQL, SSAS, SSRS, SSIS, MDX DB2, Cognos Series 7/8/10, Business Objects XI, Crystal Reports,

01/06 – 9/11 Snap Computer Concepts Inc., Raleigh, NC Sr. Business Analyst

•As a Project Lead at Arlington Pharmaceutical Company, reviewed clients’ information needs and provided analytical reviews.

•Responsible for initiating JAD sessions.

•Design layouts for the system and define data requirements to support design

•Identifying, evaluating and developing systems and procedures, which are cost effective and meet user requirements?

•Performed business requirements gathering utilizing Agile, Waterfall methodologies.

•Met with business stakeholders to determine long-term software needs.

•Performed analysis and demonstrations of software as needed to help explain functionality.

•Worked with business to prioritize feature requests.

•Created Functional Requirements documents and test documents.

•Worked with external vendors to research viability of software solutions to meet the business needs.

•Utilized Agile, Waterfall and Scrum methodologies

•Created specifications (Use Case, User Interface Specifications, Data Mappings, Swim Lanes, etc.) for systems to meet business requirements.

•Assist in testing application to ensure that the application meets the functional requirements (traceability).

•Responsible for user acceptance testing, developed user guides, provided user training, and supported the user in development of work processes.

•Responsible for development and maintenance on Supplier Management software.

•Design and implement basic SQL queries for QA testing and report/data validations.

•Chaired meetings with end users and management to ascertain reporting requirements.

•Responsible for maintaining compliance requirements for all application development.

•Responsible for creating Business Requirements Documents (BRD), Functional Requirement Documents (FRD), Requirements Traceability Matrix (RTM),

•Utilize RUP to document project status.

•Wrote Statement of Work, Business Requirement, UML diagrams, UML OO Analyst, activity diagrams, Use Case, Test Case, Mercury Test Director/Test, RUP Waterfall methodology, Statement of Process, and Enhancement specifications.

•Utilized DataFlux for data migrations from different platforms.

•Assisted in the configuration of WCC and WebSphere Server for web applications.

•Design and implement basic SQL queries for QA testing and report/data validations.

•Chaired meetings with Management and End-user, Technology, Third party Vendors, and Management Team.

•Elicited and wrote requirements for new concepts and business ideas.

•Utilized Business Objects/Crystal Reports to develop extensive financial reports.

•Create flowcharts with Visio as needed and managed deadlines for software releases.

•Participated in the system design.

•Elicited business requirements for COGNOS applications.

•Adhered to GMP 21 CFR 210 and 211 regulations thru SDLC process.

•Escalate incidents to problem management groups. Identify trends and work with members of escalation team to implement solutions or temporary workaround procedures.

•Designed and implemented database design for financial and marketing applications.

•Adhered to SDLC techniques for reporting applications.

•Utilized MS-SHAREPOINT for reporting purposes.

•Responsible for UAT of COGNOS applications.

Environment: Windows NT, Oracle 9i, SQL Server, SQL Reporting Services, UML, Dataflux, COGNOS, WebSphere 6.0, Visio, DB2, Business Objects, UNIX, MS- SharePoint

10/05 – 1/06 Samaritans Purse, Charlotte, NC

Business Analyst

•Responsible for maintaining an Oracle 9i database, which tracks donor donations for Samaritans Purse organization.

•Reviewed clients’ information needs and provided analytical reviews.

•Utilize RUP to document project status.

•Responsible for acceptance testing, developed user guides, provided user training, and supported the user in development of work processes.

•Wrote Statement of Work, Business Requirement, UML diagrams, UML OO Analyst, activity diagrams, Use Case, Test Case, Mercury Test Director/Test, RUP Waterfall methodology, Statement of Process, and Enhancement specifications.

•Utilized Agile, Waterfall and Scrum methodologies

•Assisted in database tuning and optimization for reporting purposes.

•Worked with Data Analysts/Modelers with mapping data from source to target systems.

•Develops and tests Mainframe / ETL processes, including program and systems documentation and test plans, according to established IS standards.

•Designed queries to extract data using SQL Server.

•Responsible for database schema design and T-SQL development.

•Utilized Crystal Xcelsius to create dashboards for performance reporting.

•Utilized Business Objects/Crystal Reports to develop extensive financial reports.

•Designed data marts and universe structures for reporting purposes.

•Responsible for application of CMMI methodology techniques for IT applications.

•Responsible for developing COGNOS Contributor datasheets for management comparison reports.

•Support and troubleshoot production systems as required, optimizing performance, resolving production Problems and provided timely follow-up problem reports.

Environment: Windows NT, Oracle 9i, SQL Server, Cognos Series 7/8, UNIX, Business Objects/Crystal Reports

1/05 – 6/05 People Link Staffing Inc., Charlotte, NC

Business Analyst

•Responsible for reviewing schematics of computer hardware of multiple product lines of business control machines for IBM.

•Reviewed clients’ information needs and provided analytical reviews.

•Utilize RUP to document project status.

•Wrote Statement of Work, Business Requirement, UML diagrams, UML OO Analyst, activity diagrams, Use Case, Test Case, Mercury Test Director/Test, RUP Waterfall methodology, Statement of Process, and Enhancement specifications.

•Work with design engineers to ensure that product development is done in timely matter and within budget.

•Responsible for building of computer communications hardware from initial development phase.

•Responsible for loading of software to ensure that products are operating properly.

•Responsible for pretest and final testing of hardware.

Environment: Windows NT, Nortel Hardware, IBM Hardware

3/04 – 9/04 TSG IT Resources, Charlotte, NC

Sr. Business Analyst

•Responsibilities include interpret business requirements and define technical alternatives, tools, and approach for Equifirst Mortgage Brokerage company.

•Chaired meetings with end users and management to ascertain reporting requirements.

•Utilize RUP to document project status.

•Utilized Agile, Waterfall and Scrum methodologies

•Chaired meetings with Management and End-user, Technology, Third party Vendors, and Management Team.

•Elicited and wrote requirements for new concepts and business ideas.

•Wrote Statement of Work, Business Requirement, UML diagrams, UML OO Analyst, activity diagrams, Use Case, Test Case, Mercury Test Director/Test, RUP Waterfall methodology, Statement of Process, and Enhancement Specifications.

•Developed, test, implement and documented the technical solutions to address the defined business requirements.

•Assisted in the configuration of WCC and WebSphere Server for web applications.

•Performed detailed analysis to fully identify customer’s systems change request.

•Utilized Business Objects/Crystal Reports to develop extensive financial reports.

•Participated with the development team and IT staff as appropriate in the design of solutions.

•Collaborated with other technical areas to integrate across tiers, platforms, and responsibilities.

•Provided rotating pager support for front-end Systems by interacting with external and internal customers to resolve end user issues including production problems, process clarification, and training issues.

•Collaborated with other team members to define effort estimates, time tables and project plans.

•Responsible for assisting in testing of all applications. • Managed technical aspects of application to ensure timely and effective implementations.

•Ensured that expected application performance levels were achieved.

•Acted as liaison between business units and the application development area.

•Set up process of extracting mortgage data from mainframe environment down to data warehouse.

Environment: Windows NT, UNIX, ORACLE 9i, WebSphere, COGNOS Series 7, ERWIN, DB2, BUSINESS OBJECTS, SQL

SERVER

1/02 – 9/03 HCS Consulting Svcs, Newark, NJ Sr. Business Analyst

•Responsibilities include interpret business requirements and define technical alternatives, tools, and approach for JC Penney.

•Utilize RUP to document project status.

•Gathered requirements for Credit Card Payments Systems utilizing Agile methodology.

•Chaired meetings with Management and End-user, Technology, Third party Vendors, and Management Team.

•Elicited and wrote requirements for new concepts and business ideas.

•Wrote Statement of Work, Business Requirement, UML diagrams, UML OO Analyst, activity diagrams, Use Case, Test Case, Mercury Test Director/Test, RUP Waterfall methodology, Statement of Process, and Enhancement Specifications.

•Developed, test, implement and documented the technical solutions to address the defined business requirements.

•Utilized Agile, Waterfall and Scrum methodologies.

•Utilized Business Objects/Crystal Reports to develop extensive financial reports.

•Assisted in the configuration of WCC and WebSphere Server for web retail applications.

•Participated with the development team and IT staff as appropriate in the design of solutions.

•Collaborated with other team members to define effort estimates, time tables and project plans.

•Collaborated with other technical areas to integrate across tiers, platforms, and responsibilities.

•Responsible for application of CMMI methodology techniques for IT applications. • Managed technical aspects of application to ensure timely and effective implementations.

•Ensured that expected application performance levels were achieved.

•Acted as liaison between business units and the application development area.

•Responsible for the technical operation and support of data delivery systems in a UNIX/Oracle data • Warehouse environment.

•Created user documentation for end users and management.

•Responsible for configuration of COGNOS Framework Manager Packages and SDK.

•Designed and created COGNOS Power Play cubes for OLAP reporting process.

•Responsible for creating detailed reports featuring COGNOS Visualizer.

•Set up tuning process of the reporting feature of the data warehouse which resulted in a 50% overall performance enhancement.

Environment: Windows NT, UNIX, COGNOS Series 7, AGILE, BUSINESS OBJECTS, WEBSPHERE, ERWIN, MODEL NAVIGATOR, ORACLE 9i, MS-PROJECT, SQL SERVER

2/01 – 12/01 Megaforce Staffing Svcs, Goldsboro, N.C. Sr. Business Analyst

•Responsible for reviewing client information needs for a Patient Care Information System for 3HC a health care provider within an AS/400 environment.

•Elicited and wrote requirements for new concepts and business ideas.

•Create flowcharts with Visio as needed and managed deadlines for software releases.

•Participated in the system design.

•Created MS-ACCESS databases for Patient Care Information tracking purposes.

•Performed coding of programs for information system in Microsoft Visual FoxPro.

•Performed COBOL programming and maintenance on the AS/400.

•Responsible for designing Oracle databases for clinical trial studies

•Performed system testing and implementation of Patient Care Information System.

•Responsible for troubleshooting end user and hardware problems.

•Designed queries to extract data using SQL Server

•Created daily reports for management which resulted in a 60% overall reporting enhancement.

Environment: Windows NT, AS400, MICROSOFT VISUAL FOXPRO, SQL SERVER, ORACLE, MS-ACCESS

1/00 – 1/01 CTG, Raleigh, N.C.

Sr. Business Analyst

•For IBM Corporation, responsible for Database Administration on the IBM-Microsoft Royalty Payment Project, allowing IBM to pay Microsoft royalties for Microsoft software preinstalled on IBM equipment on multiple platforms. • Utilized Agile, Waterfall and Scrum methodologies

•Created functional design specifications.

•Chaired meetings with Management and End-user, Technology, Third party Vendors, and Management Team.

•Elicited and wrote requirements for new concepts and business ideas.

•Wrote Statement of Work, Business Requirement, UML diagrams, UML OO Analyst, activity diagrams, Use Case, Test Case, Mercury Test Director/Test, RUP Waterfall methodology, Statement of Process, and enhancement Specifications.

•Assisted in preparation and execution of testing activities.

•Responsible for application of CMMI methodology techniques for IT applications.

•Ensured that strategies, plans and deliverables for application design were met on time.

•Delivered training to technical and business users.

•Responsible for creating MS-ACCESS Applications for Royalty Payment Tracking applications.

•Responsible for web application development.

•Coordinated tracking and monitored development of application design.

•Supported development of training materials and participated in training activities.

•Responsible for solving network issues and moving legacy data across multiple platforms via FTP.

Environment: Windows NT, AS400, VISUAL FOXPRO, SQL SERVER, ORACLE, MS-ACCESS

EDUCATION / TRAINING

Certification in Project Management – New Horizons – Raleigh, NC 2008

BS - Computer Science, Seton Hall University - South Orange, NJ

Contact this candidate