Candidates About

Technical summary

Experienced Business Intelligence leader with strong people and project management skills.  Advanced knowledge of Business Intelligence Tools including Cognos Business Intelligence, QlikView, Qlik Sense and data warehouse methodology and development using various data sources including DB2, Oracle and Microsoft SQL Server databases.  Experience managing data warehouse environments in excess of 100 TB, vendor relations including software evaluation, recommendation and contract negotiation for enterprise licensing.  Additional expertise in project management, installation, configuration, data modeling, report and cube development, implementation and administration of multi-tier Cognos environments on AIX UNIX, Red Hat Linux and Microsoft Windows Servers.  Additional skills include SQL scripting to update and query various databases including design and development of data mart tables.  Active Steering Committee member and guest speaker for Southeast Cognos User Group.

Professional experience

Genuine Parts Company – Advance Parts Group/Napa

Senior Business Intelligence Reporting Manager

July 2015 to present (current position)

·         Key IT leadership role with high exposure to business executive leadership across the organization.

·         Responsible for both operations and development BI resources, creating an open analytical culture across the enterprise and providing leadership on tools, technologies, and development methodologies.

·         Manage a team of 4 Report Developers / Analysts; supplement additional resources with contractors.

·         Implemented Offshore Support model for first and second tier support and operations.

·         Manages personnel administration including staffing, compensation, training, & performance evaluations

·         Reviews and explores data quality issues as it relates to business requirements for establishing golden data sources.

·         Develops and maintains short and long-range plans.

SunTrust Bank

Vice President - BI Tools Team (Enterprise B.I. Center of Excellence)

May 2010 to July 2015

·         Manage multiple teams of developers through various stages of the Software Development Life Cycle including code advisement, code review, code approval

·         Cognos development and mentoring using tools such as Report Studio, Business Insight Advance, Framework Manage, Transformer, Dynamic Cube Designer

·         Customize Cognos Portal and implementation of external portals using Cognos API calls.

·         Development of QlikView dashboards and multiple level scripting of QVDs.

·         Administration of Cognos BI including deployments, users, data source, security roles and groups

·         Managed team of 8 including DBAs, AIX System Engineers and ETL developers and QA Testing for expansion of IBM ISAS 7700 from 60 TB to 140 TB including managing the additional hardware and redistribution of data

·         Vendor relations including support, licensing negotiations, upgrades and evaluations

·         Responsible for writing and enforcing best practice policy for BI Tools including code review, migrations and unit testing

·         Responsible for the design, development, optimization, maintenance, and scaling of the infrastructure

·         Responsible for the design, development, implementation, and support of source data and its modeling and transformation to support new sets of business intelligence solutions

·         Maintains system resources for maximum throughput including system optimization, network utilization, back up and recovery, device management, fail-over, and application and data management.

·         Plan and coordinate performance testing to meet performance requirements and analyze performance impact of growing deployment

·         Confirms that user requirements are fulfilled through planned testing efforts that include the verification of report contents, data accuracy, report environment set-up, and the control and security implementation

·         Develop and maintain control and security plans that can be applied to individual reports, the reporting environment, and the portal. The changing security requirements during the sustaining phase must be accounted 

·         Coordinate training/education for all sustaining organization members and other users; responsible for skills management practices within the company

McKesson subsidiary RelayHealth - Nation’s leading health care IT company

Cognos Developer

Contract Position – Dec 2008 to May 2010 (contract was extended 3 times)

·         Development of reports using Cognos 8 Report Studio for outside customers

·         Understanding of HIPAA Privacy and Security polices in regards to report development

·         Installation of Cognos 8 on Red Hat Linux including Oracle 10g, Apache 2.2 and OpenLDAP

·         Advanced Cognos 8 package filtering to help ensure security of data

Alston & Bird LLC - A Top 50 Law Firm and Top 2 in Georgia

Financial System Lead Analyst/DBA

Nov 2003 to Feb 2009

·         Database Administration of Financial System including Business Intelligence/Data Warehouse

·         Lead contact between the IT Department, Finance Department and Portal Developers

·         Development of reports using Cognos 8 Report Studio using Financial data

·         Converted from ReportNet 1.1 and PowerPlay series 7 to Cognos 8 platform including installation and configuration of Cognos server as well as design of cubes, reports and dashboarding

·         Database Administrator for supporting Financial databases including the data warehouse

·         Created and maintained dimension tables using SQL DTS/ SSIS tools

·         Extensive SQL scripting to update and query the financial and data warehouse DBs

·         Server architecture design and installation of server related software including multi-node SQL 2005/Windows 2003 Server clusters

Technical Skills

Cognos Series 7, Cognos 8, Cognos 10– 2003 to Present

·         Report development and design using various Cognos tools including Report Studio, Query Studio, and Business Insight Advance with various distribution methods including bursting.  Data sources for developed reports include DB2, Oracle and SQL Server transactional, data warehouse and data mart databases and cubes

·         Server installation and deployment on Red Hat Linux and Windows 2003 Server in both single and multi-server environments

·         Cognos Server Administration on various platforms including AIX, Red Hat Linux, Windows 2003 and 2008 Servers with multiple servers and tiers

·         Dynamic Cube Designer and Transformer PowerCube modeling

·         Metadata modeling using Framework Manager

·         Dashboard design and development of the Cognos Connection pages to display customized content

·         Several Cognos upgrades from ReportNet to Cognos 10.1.1

QlikView and Qlik Sense

·         Implemented Qlik Sense implementation enterprise strategy including Self Service, Ad Hoc and traditional project development of Qlik applications

·         Experienced in QlikView  and Qlik SenseServer and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.

·         Good presentation, summarization, structuring and refinement skills. Proven track record of execution capabilities for strategic as well as tactical plans, both within and through functional boundaries.

Microsoft SQL Server Administration version 6.5, 2000, 2005, 2008, 2010 – 1994 to present

·         Responsible for maintenance and design of SQL Server Reporting Services and SQL Server Analytical Services

·         SQL server installation and configuration including multi-node SQL 2008/Windows 2003 Server clusters

·         Database design and implementation

·         Data warehouse design, implementation and ETL using SQL DTS/ SSIS tools from various databases

·         Extensive SQL scripting to update and query the transactional, data warehouse and data mart databases

Oracle 10g – 2008 to present

·         Installation of Oracle 10g tools for integration with Cognos 8 and 10 application servers

·         Extensive use of Toad for Oracle and Toad Data Point to write SQL queries and validation of data

IBM DB2 – 2010 to present

·         Installation of IBM DB2 tools for integration with Cognos 8 and 10 application servers

·         Extensive use of DB2 tools and Toad Data Point to write SQL queries and validation of data

Education

·         University of Arizona  - Bachelor of Science in Business Administration, Management Information Systems

Publications and Professional Memberships

·         Southeast Cognos User group – Steering Committee Member and guest speaker – 2004 to present

·         International Legal Technology Association – general member – 2003 to 2009

·         Member of Management Information Systems Association