Clarence Harvard Jr.

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

Raleigh, NC 27609

908-***-****

919-***-****

adrm7q@r.postjobfree.com www.linkedin.com/in/harvardc0211

OBJECTIVE: To obtain a Sr. Systems Developer/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 Plus Years of Business Intelligence Information Systems Development and Analysis experience working with a variety of Mainframe/Fourth Generation Languages and Relational Database Management Systems and ntier architecture applications and a variety of platforms designing financial, sales and marketing ETL/OLAP utilizing Microsoft toolset technology for applications 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, Lotus Notes 4.6, Lotus SmartSuite, Hadoop, Power BI, SQL Server 2005/2008,

Jira, Banner, Qlikview, Agile, Waterfall, Microsoft CRM, BUSINESS OBJECTS, TABLEAU, SSMS, SSRS, SSIS, SSAS,

DBMS-Focus, Oracle, Access 2000, ODBC, VM/CMS, TSO/ISPF, Unix, DB2, SAP R/3, QMF, HTML, Erwin, Toad,

Endevor, Java, VBA, DTS, Visual-Basic 6.0, ASP.NET, Transact-SQL, Windows NT 4.0, Microsoft Project, Microsoft

PowerPoint, Rumba, Sync Sort, Visio, Crystal Reports, Xcelsius, Brio, PL/SQL, COGNOS, UML, XML, TERADATA,

INFORMATICA, SIX SIGMA, WEBSPHERE, APACHE

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, Business Control Machines

PROFESSIONAL EXPERIENCE:

9/19 – 4/21 Conduent Business Services, Raleigh,NC

Sr. Business Analyst

•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 end clients.

•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, Tampa, Fla

BI Lead Systems Analyst

•As Project Lead for The State of North Carolina Government Institutions for State of NC BI Remediation Project, reviewed clients’ information needs and provided analytical reviews for Oracle, Microsoft, Cognos, and SAP platforms.

•Utilized Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel.

•Published reports and dashboards using Power BI.

•Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.

•Responsible for creation of dimensional Star Schema and Snowflakes Schema.

•Implemented processes for data consistency across Data Marts to reduce data issues.

•Established method of addressing the pillars of Governance metadata management, masterdata management, Data Quality, Data Collections, Information Life Cycle, Data Privacy and Security, Data Warehouse and BI utilizing the Collibra software.

•Gathered business requirements for Power BI applications.

•Performed or assisted with the performing of reconciliations of static data between systems and externals sources.

•Performed software updates along with desktop configurations for clients PC’s.

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

•Responsible for development and maintenance of Business Objects/Crystal Reports applications for Financial Applications for Government Agencies.

•Responsible the administration of Cognos platform upgrades.

•Responsible for the remediation of Agencies BI platform, redesigned cubes in SSAS.

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

•Responsible for redesign of Data Load processes utilizing SSIS for population of Data Marts from multiple data sources.

•Responsible for the utilization of SSRS for financial web reporting for published reports.

•Responsible for Regulatory Reporting for all Governmental Agencies.

•Responsible for facilitation of Unit/Master/SIT test plans.

•Performed CRM application analysis/development for Microsoft, SAP, Oracle platforms.

•Responsible for laying roadmap to facilitate project objectives for client and project paperwork deliverables.

•Designed data marts and universes for reporting purposes utilizing Business Objects.

•Performed desktop support duties for several agencies for the State of NC.

•Responsible for development of Supply Chain analytical models.

•Responsible for data extractions from DB2 databases for reporting.

•Responsible for creation of T-SQL queries for financial query process and data maintenance.

•Developed dashboards in Qliksense and Tableau for reporting analytics.

•Developed DMR models for financial analytical reporting.

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

•Responsible for developing Oracle Financial modules for financial reporting.

•Performed training to end users on applications.

Environment: Windows NT, Unix, Oracle 11i, Hadoop, SAP, Collibra, Power BI, Oracle ERP Suite, SQL Server

2005/2008,Qlikview, Tableau, PL/SQL, SSAS, SSRS, SSIS, MDX DB2, Cognos Series 7/8/10, Business Objects XI,

Crystal Reports,

11/11 – 12/11(backfill position) IT Manna Corp, Marietta, GA BI Analyst

•Gathered business requirements for client Dell Computer for the World Trade Center Health Fund and translated those requirements into reporting solutions for Oracle and SAP platforms.

•Responsible for redesign of Data Load processes utilizing SSIS for population of Data Marts from multiple data sources.

•Responsible for financial web reporting utilizing SSRS.

•Responsible for developing Oracle Financial modules for financial reporting.

•Designed Xcelsius Dashboards for financial reporting.

•Responsible for creation of final test plans thru system implementation.

•Responsible for creation of T-SQL queries for financial query process and data maintenance.

•Responsible for data extractions from DB2 databases for reporting • Responsible for developing BI financial reports utilizing Crystal Reports.

•Developed ETL processes of overnight data loads.

•Developed queries to analyze financial data.

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

09/11-11/11 (backfill position) National Systems Consulting, Windsor Locks, Ct

Systems Analyst

•Gathered business requirements for their several business units.

•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. Environment: Windows NT, UNIX, Oracle, Business Objects, Crystal Reports

1/06 – 1/11 Snap Computer Concepts Inc, Raleigh, NC

Senior Systems Developer

•As Project Lead at Arlington Pharmaceutical Company, reviewed clients’ information needs and provided analytical reviews for HIPPA reporting analysis for clinical drug trial studies.

•Responsible for the configuration, testing and implementation of reporting needs for the CLv2 (CORE LIMS V2) implementation in a GxP environment for a Microsoft BI and COGNOS platforms.

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

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

•Responsible for design of Data Load processes utilizing SSIS for population of Clinical Data Marts from multiple data sources.

•Responsible for facilitation of system wide testing UAT plans.

•Responsible for data extractions from DB2 databases for reporting

•Responsible for creation of T-SQL queries for financial query process and data maintenance.

•Designed Business Objects reports for financial reporting.

•Designed data marts and universes for reporting purposes utilizing Business Objects.

•Responsible for designing complex data models utilizing Erwin.

•Responsible for Designing and implementing data warehouse utilizing ETLsolutions on Microsoft BI Stack using SSIS and building SSAS cubes with complex data (dimensions, measures, data source views).

•Responsible for performance tuning and deploying and processing SSAS cubes. Designed MDX queries for analysis in SSAS.

•Creating SSRS reports using SSAS as data source; passing parameters to drill-down reports

•Responsible for utilizing Oracle Streams for data capture for clinical trial databases.

•Responsible for development of Supply Chain analytical models.

•Developed action plans and service level agreements with internal customers. Built long-term relationships with key

•Responsible for implementing sales call tracking reporting application.

•Designed and implemented database design for financial and marketing applications in COGNOS. Performed SDLC system development life cycle duties for COGNOS Financial Reporting System applications. Responsible for final system testing and implementation of COGNOS applications.

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

•Responsible for making recommendations for utilization of 3rd party tools which resulted in 50% overall system enhancement.

•Designed complex reports utilizing SSRS.

•Designed queries to extract data using SQL Server 2008.

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

•Created detailed, clear and thorough specifications for all systems change requests.

•Responsible for troubleshooting software problems.

•Responsible for resolving network issues and end user system problems.

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

Environment: Windows NT, Unix, Oracle 11i, ProClarity, Oracle ERP Suite, Microsoft CRM, SQL Server 2005/2008, PL/SQL, SSAS, SSPS, SSRS, SSIS, MDX, Perl, JAVA, DB2, Cognos Series 7/8, Business Objects, Xcelsius, XI, Data Integrator, UNIX, MS-ACCESS 2003

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

Database Analyst

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

•Assisted in database tuning and optimization for reporting purposes.

•Responsible for supporting IT marketing applications.

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

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

•Developed and maintained CRM Marketing sytems.

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

•Utilized TOAD for database development.

•Responsible for schema and data modeling development in Oracle 9i.

•Responsible for Oracle Forms development for front end process.

•Designed queries utilizing Oracle Discoverer 4.1 for financial reporting.

•Responsible for creating UNIX scripts for historical data load processes.

•Designed queries to extract data using SQL Server.

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

•Designed data marts and universe structures for reporting purposes utilizing Business Objects.

•Utilized Business Objects SDK/Enterprise for application design.

•Responsible for UAT process.

•Utilized Crystal Xcelsius to create dashboards to reflect donor donations.

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

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

•Responsible for creating financial reports using COGNOS Impromptu.

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

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

•Responsible for building and testing of COGNOS cubes.

•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, PL/SQL, Cognos Series 7/8, Autosys, AS400, UNIX, Business Objects/Crystal Reports, Xcelsius

1/05 – 6/05 PeopleLink Staffing Inc, Charlotte, NC

Sr. Hardware Technician

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

•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

2/04 – 9/04 TSG IT Resources, Charlotte, NC Senior Application Developer

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

•Designed data marts and universe structures for reporting purposes utilizing Business Objects.

•Responsible for ownership and support of sales and marketing applications.

•Served as lead person for all sales and marketing IT applications.

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

•Responsible for UAT plans.

•Responsible for creation of T-SQL queries for financial query process and data maintenance.

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

•Created detailed, clear and thorough specifications for all systems change requests.

•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.

•Responsible for backend development process.

•Responsible for extracting large historical data sets databases into data repositories.

•Responsible for data warehouse development utilizing Oracle Warehouse Builder.

Responsible for schema and data modeling development in Oracle 9i.

Wrote PL/SQL queries for data extractions.

Responsible for writing SQL to extract data from and import to DB2, Oracle & Teradata Performed data profiling utilizing Teradata for financial data.

•Utilized MLOAD, FASTLOAD, and TPUMP utilities for Teradata.

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

•Designed data marts and universe structures for reporting purposes.

Environment: Windows NT, UNIX, ORACLE 9i, PL/SQL, COGNOS Series 7, SSAS, SSIS, PERL, ERWIN, DB2, BUSINESS OBJECTS, Xcelsius, SQL SERVER

1/02 – 9/03 HCS Consulting Svcs, Newark, NJ

Sr. Systems Developer

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

•Responsible for ownership and support of sales and marketing applications.

•Served as lead person for all sales and marketing IT applications.

•Responsible for Final UAT facilitation process.

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

•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 data loading into Staging and Star Schemas correctly for operational system.

•Responsible for establishing and maintaining standards for data quality and data validation in the data warehouse.

•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.

•Responsible for setting up ETL process using COGNOS Decision Stream.

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

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

•Performed Full Data Warehouse Development Life Cycle processes.

•Responsible for setting access permissions and report properties within the COGNOS environment.

•Translated business intelligence requirements into logical/physical data models.

•Assisted in the building of custom data marts and data warehouses.

•Designed drill down sales reports for region managers utilizing COGNOS Report Net.

•Responsible for creating extensive sales reports using COGNOS Impromptu.

•Utilized Business Objects SDK/Enterprise for application design.

•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 utilizing Business Objects.

•Provide weekly project management reports utilizing MS-PROJECT.

Environment: Windows NT, UNIX, COGNOS Series 7, BRIO, TERADATA, BUSINESS OBJECTS, INFORMATICA, ERWIN, MODEL NAVIGATOR, ORACLE 9i, POLYANALYST, MS-PROJECT, NCR SERVER, SQL SERVER

2/01 – 12/01 Megaforce Staffing Svcs, Goldsboro, NC. Sr. Systems Analyst

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

•Responsible for design of front end utilizing Visual Basic.

•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, VISUAL BASIC, MICROSOFT VISUAL FOXPRO, SQL SERVER, ORACLE, MSACCESS

1/00 -1/01 CTG, Raleigh, NC

Systems Analyst

•For IBM Corporation, responsible for Database Administration on the IBM-Microsoft Royalty Payment project, allowing IBM to pay Microsoft royalties for Microsoft software installed on IBM equipment on multiple platforms.

•Created functional design specifications.

•Responsible for ownership and support of sales and marketing applications.

•Assisted in preparation and execution of testing activities.

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.

•Worked with business units to gather functional business requirements, develop process and application design.

•Responsible for designing COGNOS cubes for OLAP reporting purposes.

•Designed and customized COGNOS Series 7 query reports for financial reporting purposes.

•Responsible for setting access permissions and report properties within the COGNOS environment.

•Set up ETL process using COGNOS Decision Stream.

•Performed Full Data Warehouse Development Life Cycle processes.

•Set up scripts for the extraction process to data warehouse.

•Created extensive royalty payment reports using COGNOS Power Play, COGNOS Impromptu, and COGNOS IWR.

•Created and developed custom data marts and data warehouses.

•Developed design recommendations that provided a 50% overall system improvement.

•Created database design for worldwide COA Tracking System utilizing MS Access within a SQL Server environment.

•Performed maintenance of Access databases; made enhancements to VBA Code.

•Responsibilities included overall database development for Royalty Payment database project in Oracle 8.1 within an UNIX environment.

•Responsible for data normalization and physical and logical design of databases.

•Performed data modeling activities utilizing Erwin for database design.

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

•Performed for data extractions from DB2 UDB from data warehouse utilizing SAP BW for reporting purposes.

•Responsible for planning and designing of layout of DB2 UDB databases, defined scheduled maintenance procedures.

•Responsible for database schema design in SQL Server.

•Designed queries to extract data using SQL Server.

•Responsible for upgrades to DB2 UDB databases, worked closely with vendors to coordinate software upgrades.

•Responsible for establishing reorganization, backup and recovery procedures of DB2 UDB databases.

•Designed dataflow, data feeds processes for sites to adhere to, and for creating process for uploading of data feeds into databases.

•Design Excel spreadsheets for reporting purposes.

•Performed weekly reviews with worldwide sites to ensure data integrity.

•Ran weekly reports for management review.

•Created worldwide templates for site locations to input data in.

Environment: Windows NT, AS400, DB2 UDB, BRIO/SQR, SAP, LOTUS NOTES, ERWIN, OS390, UNIX, SQL

SERVER, VBA, MICROSOFT ACCESS 2000, ORACLE 8i, COGNOS

1/99 – 12/99 Sun Information Systems Inc, Huntersville, NC Systems Analyst

•Performed analytical reviews of Cost Accounting System for the NC Department of Health and Human Services.

•Gathered user requirements, developed functional specifications, and developed documentation.

•Designed data entry screens for cost accounting system in Access 97. Modified existing data screens for overall enhanced functionality.

•Responsible for designing Oracle databases for clinical trial studies

•Performed baseline testing for system verification.

•Modified reports for enhanced reporting purposes.

•Designed queries to extract ICD-9 data using SQL Server.

•Performed database maintenance on Accounting System.

•Converted Access databases from 2.0 to Access 97.

•Modified VBA code on applications for better functionality within the overall Cost Accounting System.

Environment: Windows NT, OS390, ORACLE, SQL SERVER, MICROSOFT ACCESS 2.0/97

1/98 – 12/98 SAIC, Raleigh, NC.

Sr. Systems Analyst

•As the Sr. Systems Analyst and Database Analyst, worked with multi-phased projects involving significant changes to the Raleigh United States Postal Service Center's computer systems for maintenance, enhancements and millennium compliance changes. Successfully implemented initiatives critical to the Raleigh USPS business objectives.

•Gathered user requirements, developed functional specifications, and developed documentation.

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

•Evaluated system interfaces for impacts to existing systems for Y2K problems.

•Performed project management duties.

•Coordinated tracking and monitored development of application design.

•Performed helpdesk duties for USPS sites statewide.

•Developed design recommendations that provided systems improvements.

•Performed maintenance and tuning of Oracle 8i databases.

Responsible for planning and designing layout of DB2 UDB databases from testing to deployment Responsible for web application development.

Responsible for designing process and systems flow design for mainframe applications.

Developed assessments on LEGACY applications for Y2K compliance in a TSO/ISPF environment. Performed analysis on applications for potential Y2K problems. Developed conversion and project plans using Microsoft Project and performed code remediation on all Legacy Focus/Cobol applications.

•Performed SDLC system development life cycle process on Focus applications.

•Rewrote Postal Service Financial Reporting System PSFR Focus application.

•Upgraded Focus applications from version 6.8 to 7.08.

•Developed maintenance plan for existing applications.

•Created data dictionary for client server applications.

•Assist technical writers in creating system documentation.

•Wrote enhanced functionality code utilizing VBA for Access applications for SQL Server databases.

•Responsible for designing and customization of COGNOS Series 6 query reports for financial reporting purposes.

•Responsible for setting access permissions and report properties within the COGNOS environment.

•Responsible for creating extensive financial reports using SQL Server.

•Responsible for extensive cube creation utilizing SQL Server and COGNOS Power Play.

•Designed online data entry screens in Access97. Designed adhoc reports in Crystal Reports 8.5. Remediated Access applications for Y2K compliance. Performed Access application conversions from version 2.0 to Access 97.

•Created test scripts and performed baseline and unit testing of applications.

•Provided weekly status reports.

•Designed system and data flowcharts in Visio.

Environment: Windows NT, MS SOFTWARE, Mainframe, FOCUS, COBOL, ASP, COBOL II, DB2, JCL, Procedures,

HTML, JAVA, ACCESS, VB, VBA, EDI, ORACLE 8i, ENDEVOR, REMEDY, INFOMAN, SQL SERVER, COGNOS, JD

Edwards Business Intelligence, CRYSTAL REPORTS CLIST

1/97 – 12/97 Mega Force Staffing Services, Goldsboro, NC.

Database Analyst

•Responsible for designing file structures for PC based reporting LAN network system for Triangle Bank.

•Designed and administered BANKWIDE database. Performed daily database maintenance.

•Wrote adhoc reports for end users.

•Responsible of maintenance of automated financial systems.

•Troubleshooted software and hardware problems.

•Implemented daily downloads procedures from AS400 to PC LAN network.

•Designed PC based Reporting System in Access 97 within an SQL Server environment. Designed Access tables and reporting screens.

•Loaded SQL queries onto server for network applications.

•Responsible for designing reports for Bank wide Reporting System.

•Responsible for system testing of all applications.

Environment: Windows NT, AS400, MS SOFTWARE, ACCESS, VBA, SQL SERVER

EDUCATION / TRAINING

Certification in Database Design, Data Recovery, Focus Database Management

PMP Certification – New Horizons – Raleigh 2008

B.S. Computer Science - Seton Hall University - South Orange, NJ

Contact this candidate