Dennis Mcclure Email & Phone Number

Wadesboro, Nc, Us

Charlotte, North Carolina, United States

• Maintains an IBM Cognos Analytics 11.2.4 reporting environment.• Currently migrating our entire repository from IBM Cognos Analytics to Microsoft Power BI platform using MS Visual Studio.• Regularly use MS Access to perform cross-platform reporting where a Cognos data source does not exist.• Administers user and group access via active directory roles.• Facilitated Jira project tracking for team collaboration.• Continuously identifying opportunities for improvement of processes and reporting output.The Credit Management Group (CMG) within the commercial banking division is responsible for the management of commercial loans that have exhibited distress either through balance sheet exams or prolonged non-payment. As the nation’s largest SBA lender, we regularly experience independent auditing of our process and change management procedures and reporting accuracy.

Winston-Salem, North Carolina

Leading the initiative to incorporate an IBM Analytics solution into the effort of consolidating several content management repository infrastructures into one “Global 360” unified Enterprise Content Management infrastructure for the entire Wells Fargo organization utilizing IBM FileNet 8 and IBM Case Manager 5.2 to create a hybrid workflow/case management framework.Successfully implemented Cognos Real-Time Monitoring (RTM) 10.2.1 and Cognos Business Intelligence 10.2.1 on Oracle 11g RDBMS for the consumer lines of businesses that was previously using .CSV delimited files derived from SQL queries before the implementation. We provide remote training and support for Cognos BI as well for end user ad-hoc reporting capabilities.Responsible for the successful implementation of analytic solutions as part of the Customer, Deposits, and Operations Imaging Technology (CDOT) group at Wells Fargo, namely Altosoft Analytics Suite on SQL Server 2012, to manage the workflow of Document Imaging and emerging Mobile Capture services that is quickly becoming commonplace in the banking industry.Teams closely with business partners to determine any performance gaps within workflows and establish analytic solutions to track key performance indicators (KPIs) that will assist management in identifying the source of their issues in a proactive manner.Regularly perform presentations of new products, using dashboards, to assist lines of businesses at getting familiar with the workflow of each new service they will offer.Creates Technical Design Documents (TDDs) based on requirements from business partners and establish traceability to other goals they may have established.

Winston-Salem, North Carolina

Develop Cognos 10 Report Studio reports for all areas of finance (Purchasing, AP, AR, Endowments, Encumbrances, Ledger (GL & OL), etc.) based on user input from an Ellucian Analytics (Banner) interface on an Oracle 11g RDBMS. Utilized Framework Manager to design and publish packages in a snowflake schema based on a fact-dimension relationship design.Establishing all stages of SDLC directly with end users from the initial end user request, requirements, end user acceptance testing, to the final deliverable. Introduced versioning techniques as well as JavaScript in the report development to provide added functionality to end users. Report bursting delivered to end users based on role security to various managers to reduce licensing costs. Extensive use of SQL, ERDs, and data dictionaries for gathering requirements & QA testing. Utilizing MS Excel analysis tools for testing. Performed integrity & compatibility testing for upgrading from 8.1 to 8.4 to 10.1 as well upgrading the RDBMS from Oracle 10g to 11g.

Elizabeth City, Nc

Create, maintain, and provide change management for Decision Support Systems pertaining to asset logistics, maintenance, personnel training, procurement, and fiscal accounting. Migration from Cognos 7.4 on an INGRES database as well as SQL Server 2005 data sources to Cognos 8.4 BI on an Oracle 10g data warehouse using SAS Data Integration Studio as the ETL tool.Implemented BI methodologies such as dashboards (Report Studio), scorecarding (Metrics Studio), ad-hoc reporting, and multidimensional cubes (Transformer) to streamline coordination between Aviation & Naval operations for the U.S. Coast Guard. BI development included the design and publishing of Framework Manager packages for relational and dimensional data as well as designing list and crosstab reports in Report Studio .

Chesapeake, Virginia

Contracted with the U.S. Dept. of Homeland Security to administer user roles & privileges for DHS Core Accounting System (CAS) and Federal Procurement Documents (FPD) financial interfaces on an Oracle 10gR2 RDBMS. Diagnosed & resolved field issues with accounting systems in areas such as purchase orders, contracts, and internal funding for all DHS agencies. Adopted Six Sigma efficiency guidelines to deliver superior, low-cost system support.

Newport News, Virginna

Provided warehouse management software (WMS) support for an international firm grossing 9.6 Billion in annual sales of HVAC, plumbing, and home improvement supplies. Upon initial employment there were 5 distribution centers serving 35 warehouses throughout the United States which grew to 7 distribution centers serving 63 warehouses in every state including Hawaii and Alaska.Addressed the logistical support technologies for the WMS using 3M HighJump in diagnosing issues with Intermec printers, Teklogix RF scanner handheld guns, and an Oracle 10g RDBMS with fail-over redundancy.Call tracking maintained by HP OpenView software suite.Periodically travelled to new warehouses to provide training to new associates as well as implement new WMS systems at the location.Implemented best practices based on ITIL guidelines.

Bachelor Of Science (B.S.), Management Of Information Systems, 2.8

Associate In Applied Sciences, Information Systems Technology, 3.2

Activities and Societies: Phi Theta KappaConcentration in Oracle 9i RDBMS