Business Intelligence Systems

NORMAN T. PRICE, JR.

***** ***** ****** • Lovettsville, VA 20180

Cell: 571-***-****

Email: *********@*****.***

Summary of Qualifications

As a Business Systems Administrator at Creative Associates International, I have over 20 years of experience in managing and supporting various business systems. My expertise includes Unanet, SL Connect, Dynamics SL, ReqLogic, UltiPro, SQL, DataBasics, Business Intelligence, Power Pivot, and MS Power BI. I have also worked as a Sr. Financial Systems Administrator at PAE Group and a Financial Systems Manager at Atlantic Exhibits, where I developed and supported financial systems, managed data management and retrieval, and created Business Intelligence tools. I hold a Bachelor of Science degree in Accounting and Information Systems from Shepherd University. I am passionate about using my skills to help organizations optimize their business processes and make data-driven decisions. Major Accomplishments

Business Intelligence

Designed, programed and rolled out a Business Intelligence reporting system utilizing Power BI as the presentation tool. The system combines over 30 SQL databases and includes data from other systems like the time and expense, procurement, contracts and consultant capabilities. Power BI reports include Dashboard and drill down reports to view transaction level records. The reports are used and trusted by both the Accounting and Finance departments as well as the Project Management and Business Development. Row level security was designed to meet the security standards required by our clients. Training sessions are held monthly for new users. A complete data dictionary is available to ensure user understanding and usefulness. Enhance and Support ERP

Developed customizations to ERP via API and SQL code to improve system functionality and enforce business rules. Supported a worldwide user base.

Forecast and Analysis

Created a Forecasting and Analysis app by utilizing a combination of Power Apps, Power BI and Excel. This app included forecasting inputs, current expense analysis, employee utilization and allow for the addition of TBD staff in the forecast.

Education

Bachelor of Science Accounting/Information Systems Shepherd University, Shepherdstown, West Virginia

Employment History

Creative

Associates

International

Sr. Financial

Systems Manager

(2014-present)

PAE Group

Sr. Financial

Systems

Administrator

(2010-2014)

Atlantic

Exhibits, Inc.

Business Systems

Manager (2007 –

2010)

GeoLogic

Solutions, Inc.

Business Systems

Manager

Oct 2004 to 2007

Intersections

Reporting

Manager/DBA

2004 to 2004

Avectra, Inc.

Accounting

Systems Manager

Dec 1999 to Feb

2004

Sallie Mae

Sr. Accounting

Systems Analyst

1997 to Nov 1999

Developed integration between Dynamics SL and Unanet using SL Connect and SQL. Imported 5 years of historical data from Dynamics into Unanet. Created Project Management reporting system for Executive Committee. Developed a PowerBI dashboard and drill through reports. Implemented DataBasics for timekeeping and expense reports. Implemented Unanet and covered the ERP data to backfill the new system. Maintained and supported ERP, DataBasics and complete system upgrades as needed. Created a self-service Business Intelligence reporting system by combining multiple Dynamics SL database from multiple versions. Used SSIS and SSAS to build an OLAP database and Excel PowerPivot as presentation methods. Develop integrations between Dynamics SL and COTS software. Support worldwide user group.

Managed all business systems support, development, and consultant engagements. Provided support for highly customized ERP system, MS Dynamics SL and CRM 4.0. Developed systems using MS SQL, VB, SSRS, SSIS, OLAP, Crystal Reports, Dynamics SL Customization manager. Developed business intelligence system for Cost Accounting and Project Management staff by creating an OLAP database. Solomon system administrator upgrade from 5.0 to 6.5 including customizations, adding objects and user defined fields and logic using CM and Tools for VB, modify and develop new Crystal Reports. User support for GL, AP, AR, OM and IN modules. Train new users. Design, develop, and implement solutions. Solve complicated system issues. Develop Transaction Imports for AR, GL, and budget. SQL Database administrator develop SQL DTS packages for data updates and transfers, backups and restores, ad-hoc queries, write procedures for reports. Implemented Power OLAP system, designed cubes, dimensions and SQL views. Used VB.net, ASP.net and MS SQL to enhance Fulfillment Web site and Warranty Web site and Usage Billing System: system. Managed CRM (Clarify) system Managed Financial and Call Center reporting system. Managed multiple concurrent requests from various department staff and directors. Database administrator, SQL programmer and report writer. Use Excel and Crystal Reports to generate accurate reports on time. Maintain data warehouse, created views, stored procedures and designed new databases.

Responsibilities included developing, programming, and supporting nonprofit Forum BackOffice’s accounting modules and interfaces using MS SQL, Visual Basic and Crystal Reports. Developed interface between Forum BackOffice and accounting systems such as Great Plains, Solomon, MAS90, MIP and Platinum. Worked with clients during the design study, implementation, testing, integration, training, and support phases. Worked with senior level accounting personnel to tailor procedures and application to client needs, and train client users on software use. Demonstrated accounting software to potential clients. In addition, designed, programmed, and implemented Data Explorer application to maintain a data dictionary and allow for ad-hoc query building and report writing. Worked as a liaison between the Accounting and Technical Service departments. I supported corporate development, implementation, use, and enhancement of mainframe and PC/LAN-based accounting systems. Visual Basic 5/6 applications written for the Accounting Systems group included two Issue Tracking, Y2K Contingency Plan, and Help Call Tracking systems. These systems include Crystal Reports or interface with MS WORD.

Contact this candidate