Resume

Data Project

Location:

Buford, GA

Posted:

September 14, 2017

Contact this candidate

Resume:

SR. BUSINESS INTELLIGENCE LEAD ARCHITECT - TABLEAU

DENNIS SCHWARTZ

480-***-**** ac2aox@r.postjobfree.com

PROFESSIONAL OBJECTIVE

I am a functional Senior Business Intelligence Lead Architect that uses my specialized experience to help my client’s identify useful data for the purposes of marketing, analytics, process improvement, and KPI’s. Managing the process from raw data through gathering requirements, organizing & structuring relevant data, then developing reports & dashboards to present to leaders and decision makers a set of data full of key metrics and useful information to analyze. My goal is to provide informational support to an organization’s leaders and decision makers by arming them with valuable information to use that will provide the organization with a competitive advantage in their respective markets.

PROFESSIONAL EXPERIENCE SUMMARY

03/2017 – 07/2017 Business Intelligence Consultant / Tableau Developer – NCR CORP, Duluth, GA

02/2011 – 03/2017 Business Intelligence Principle Consultant / Team Lead – ACXIOM CORP, Remote

PROJECT SUMMARY FOR ACXIOM CORP.

06/16 – 03/17 MACY’S Marietta, GA

06/15 – 06/16 GEORGIA STATE UNIVERSITY Atlanta, GA

01/15 – 06/15 CANADIAN TIRE BANK Toronto, ON

12/14 – 01/15 AFFINION GROUP Stamford, CT

06/14 – 12/14 BEATS by DR. DRE / APPLE Santa Monica, CA

10/13 – 06/14 JM FAMILY ENTERPRISES, INC Alpharetta, GA

10/13 – 10/13 BLUESTEM BRANDS, INC Eden Prairie, NM

06/13 – 10/13 TOTAL WINE & MORE Potomac, MD

01/13 – 06/13 APPLE INC. Cupertino, CA

04/12 – 01/13 US BANK Minneapolis, MN

11/11 – 04/12 HARLEY DAVIDSON Milwaukee, WI

07/11 – 11/11 MACY’S Marietta, GA

06/11 – 07/11 HOME DEPOT Atlanta, GA

04/11 – 06/11 STATE FARM / NATIONWIDE Little Rock, AR

02/11 – 04/11 AT&T / CONSUMERS REPORT Little Rock, AR

END PROJECT SUMMARY FOR ACXIOM CORP.

02/10 – 2/11 Business Intelligence Consultant / Team Lead – TD BANK, Mount Laurel, NJ

02/09 – 02/10 Business Intelligence Developer / Team Lead – LIFELOCK, Tempe, AZ

03/08 – 01/09 Business Intelligence Consultant / Developer – PRUDENTIAL, Scottsdale, AZ

01/07 – 03/08 Business Intelligence Developer – COMPUTER GUIDANCE, Scottsdale, AZ

07/04 – 01/07 Business Intelligence Developer – JFSHEA INC., Scottsdale, AZ

EDUCATION

Bachelor of Science, Information Technology – University of Phoenix

TECHNICAL SKILLS

BI Tools: Tableau Server & Desktop 7/8/9/10, Business Objects 5.x /6.5/XI R2/R3/BI 4.0/4.1/4.2 (Designer, CMC, Deski & Webi, CCM, Deski to Webi Conversion Tool, IDT & UDT), Crystal Reports 10/XI R2/2008/2011, Lumira, Microsoft SQL Reporting Services (SSRS), IBM Cognos 8/10 BI/10BI, Xcelsius 2008/Dashboard Designer BI 4.0, Birst, Salesforce Analytics.

ETL Tools: Data Integrator XIR2, Informatica Power Mart/Power Center 5.1,

Data Modeling: Data Warehousing Methods, Enterprise Data Modeling (Data Marts) / Inmon Dimensional Modeling (Star/Snowflake)/Kimball

Operating Systems: Red Hat Enterprise Linux, Windows, Mac

Data Sources: MySQL, Oracle 9i/10g/11g, MS SQL Server 2000/2005/2008, MS Access, DB2, SAP BW, Hadoop, Microsoft Excel, Amazon Web Services (AWS), Salesforce, Teradata

Query Tools: SQL Developer, TOAD, Query Analyzer, iSeries Navigator, Enterprise Manager

Programming Languages: SQL, Transact-SQL, PL-SQL, MySQL

Development Methodology: Agile

PROFESSIONAL EXPERIENCE DETAILS

03/2017 – Present NCR CORP Duluth, GA

Business Intelligence Consultant – Tableau Developer / Analyst

Was brought on to assist with an initiative to migrate legacy data into a newly constructed data lake, specifically into Hadoop, and then utilize Tableau to develop dashboards. I was tasked to take old existing reports and create Tableau visualizations to replace the old reports. Also responsible for documenting all reporting requirements, testing data results and demoing new dashboards to Business partners.

Business Objects – Teradata - Recreated 10 Business Objects reports, with Teradata as the data source, with Tableau and Hadoop as the data source for the new visualization.

Website – SQL Server 2014 - Recreated 1 Website report and 3 dashboards, with SQL Server 2014 as the data source, with Tableau and Hadoop as the data source for the new visualization.

Excel - Recreated 12 Excel reports and 8 dashboards, with Excel as the data source, with Tableau and Hadoop as the data source for the new visualization.

07/2011 – 03/2017 Business Intelligence Principle Consultant / Team Lead – ACXIOM CORP. Little Rock, AR

Remote Business Intelligence (BI) Team Lead and Consultant for all of Acxiom’s Clients that leverage such BI tools as Tableau and Business Objects in their BI Solutions. I am the subject matter expert for Tableau and Business Objects who resolve all issues that cannot be resolved by junior associates, and I mentor / train all junior associates on best practices in utilizing Tableau and Business Objects. I am the Acxiom’s liaison and Administrator to Tableau and SAP (Business Objects) maintaining partnerships with both companies. I also serve as a trusted resource to the company’s sales team and provide services that are instrumental in winning new projects and customers. I manage all of my own projects and oversee the projects of junior associates.

Note – Below is a break out of each engagement during my tenure with ACXIOM CORP.

06/2016 – 03/2017 MACY’S Marietta, GA

Business Intelligence Principle Consultant / Team Lead via ACXIOM CORP

Responsible for managing all related tasks in performing a successful upgrade of client’s complex, multiple server cluster, SAP Business Objects (BO) environment from version 3.1 to 4.2, converted over 120 reports from Desktop Intelligence to Web Intelligence. Conducted training with client on new BO environment. Currently converting Business Objects reports Web Intelligence reports to Lumira Dashboards.

Business Objects Upgrade – Configured the Business Objects environment to execute at maximum performance and efficiently ahead of scheduled delivery date.

Converted BO Deski to Webi Reports – Converted 122 complex Deski reports to Webi reports using the combination of the conversion tool and then a manual process I developed for the team to follow when resolving those reports that did not convert using the conversion tool. The project pledged to convert 25 due to complexity of reports, but I delivered 122 converted reports.

Webi Report and Lumira Dashboard Development – Currently replacing old BO reports with Lumira visually dynamic dashboards using the iterative “Agile” methodology to meet customer expectations and achieve complete customer satisfaction.

Conducted New Version Business Objects Tool Training – Performed multiple Business Objects training sessions and created training document as a reference to the corresponding training for client class attendees.

06/2015 – 06/2016 GEORGIA STATE UNIVERSITY Atlanta, GA

Business Intelligence Principle Consultant / Team Lead via ACXIOM CORP

Installed and configured Tableau Desktop and Server (version 9.1) then migrated to the Tableau Online environment. Used Salesforce and Oracle data sources to develop and automate 5 Production Tableau Dashboards for the Universities Executives. Participated in the Tableau version 10 beta team, and then upgraded Tableau Server to version 10. Worked with the Admissions office to develop a set of automated “Daily Work Lists” that are emailed to employees via Tableau Server. Structured the source data for each Tableau dashboard and report view for Tableau to consume properly. Negotiated with Tableau for server licenses and reduced the initial cost saving the client 25% of the total price of Desktop and Server licenses.

Development of Tableau Dashboards – During the course of gathering the reporting requirements for the Tableau dashboards I uncovered some business processes that were invalid and as a result the client corrected the processes company wide.

Development of Tableau “Daily Work Lists” – I met with the Admissions Director and listened to challenges his department was having and I developed and delivered a set of Tableau reports that reduced 2 hours of work time daily for 2 resources by automating the Daily Work Lists and having them delivered to intended recipients. I also created a dashboard that would track the progress of each associate for the managers and the director to view readily.

01/2015 – 05/2015 CANADIAN TIRE BANK Toronto, ON

Business Intelligence Principle Consultant / Team Lead via ACXIOM CORP

Consulted with client and provided guidance during report requirements gathering exercise leading them towards most identifying the most useful metrics to explore and report on. I directed the client to purchase the most suitable Business Intelligence tool for sustainable and practical use. Installed and configured Tableau Desktop & Server, and trained the client’s staff on Tableau Desktop & Server (version 8 and then 9).

Data Validation - Gathered Data Mart & Reporting requirements then documented all reporting requirements, and generated a Data Dictionary.

12/2014 – 01/2015 AFFINION GROUP Stamford, CT

Business Intelligence Principle Consultant / Team Lead via ACXIOM CORP

Guided the client to determine relevant reporting requirements then developed 5 Tableau assorted dashboards for client to use internally. The Tableau dashboards and reporting requirements work was instrumental in acquiring a multi-million dollar contract. Installed and configured Tableau Desktop and Tableau Server. I trained the client’s staff on Tableau Desktop and Server (version 8).

06/2014 – 12/2014 BEATS by DR. DRE (APPLE Inc.) Santa Monica, CA

Business Intelligence Principle Consultant / Team Lead via ACXIOM CORP

Managed the BI project proposed by client, ensuring that project successfully passed through all project processes in the project lifecycle. Orchestrated the collaboration of outside groups that performed dependency tasks that contributed to the solution, implementation and delivery of the SAP Business Objects BI 4.1 environment, 6 universes and 4 complex reports, a security model for internal and external users, and a secure channel for users to enter the Business Objects environment to retrieve reports.

10/2013 – 06/2014 JM FAMILY ENTERPRISES, INC Alpharetta, GA

Business Intelligence Expert Consultant / Team Lead via ACXIOM CORP

I was brought in to assess existing Business Objects (BO) environment, identify and solve numerous performance issues in existing Business Objects environment. I assessed the old environment and the performance requirements, and then implemented a new BO environment with vastly improved performance of report processing and environmental stability. It was taking 12 to 15 hours to process between 90K – 120 reports and now the same number of reports can be processed within 2-3 hours and environment no longer crashes during the processing of the many reports. I also established a clear path for upgrading Business Objects 3.1 to 4.1. Configuration of SAP Business Objects 3.1 Servers.

10/2013 – 10/2013 BLUESTEM BRANDS, INC Eden Prairie, NM

Business Intelligence Expert Consultant / Team Lead via ACXIOM CORP

Performed the Tableau Server & Desktop upgrade from version 7.0 to 8.1, and performed training session on new features. Upgrade and Configuration of Tableau 8.1

Performed Discovery Analysis on Tableau Environment Requirements - Documented the requirements for the new Tableau environment for software and license acquisitions. Planned and documented all the defined related tasks associated with the upgrade. Reviewed software and hardware requirements for Tableau Server and Tableau Desktop. Performed Offline License Activation. Conducted testing of upgraded server and desktop. Lead training on upgrade and new functionality of both Server and Desktop.

06/2013 – 10/2013 TOTAL WINE & MORE Potomac, MD

Business Intelligence Expert Consultant / Team Lead via ACXIOM CORP

Managed the BI portion of a client proposed CRM solution through all life cycle phases to the support of the solution. Responsibilities included the installation and configuration of Tableau version 7.0 environment (Server and Desktop) on a Citrix terminal server, requirements gathering for data mart design, participation with generating a data dictionary, perform Tableau training and document training material, and creation of complex reports.

Discovery Analysis on Tableau Environment Requirements - Documented the requirements for the new Tableau environment for software and license acquisitions. Planned and documented all the defined related tasks associated with the installation. Reviewed software and hardware requirements for Tableau Server and Tableau Desktop. Submitted internal requests for Fire-wall modifications and ports to be opened to support Tableau Server and all its features. Set up users and constructed a security model for client. Created Schedules, Tasks, Subscriptions and Data source connections for end users to utilize.

Reporting & Data Mart Requirements Gathering - Documented all reporting requirements, and generated portions the Data Dictionary.

Complex Report Development - Created several complex reports that were used for data validation. Scheduled standard monthly reports to be refreshed and delivered via email to intended recipients.

Training for Tableau Server & Desktop Users - Provided class participants with a 2 optional online perquisite introduction classes before the scheduled training. Provided class participants with pre-requisite training videos to watch, at their convenience, before scheduled training. Conducted a 3 day in depth Tableau training session onsite for client. Training included overview of both Tableau Server and Desktop. Provided class participants with best practices in regards to using Tableau. Shared with class participants’ helpful tips and tricks when using certain Tableau features. Also created a training document for client for a reference during training class.

Post implementation Support – Provided additional support to the client to provide and promote a smooth transition.

01/2013 – 06/2013 APPLE INC. Cupertino, CA

Business Intelligence Expert Consultant / Team Lead via ACXIOM CORP

Hand selected from Apple Executives to work on a team combined of Acxiom and Apple associates for Apple Maps. My responsibilities were to Install and configure a Tableau environment (Desktop and Server version 7.0), assist in data validation, and the creation and automation of complex Tableau reports.

Tableau Desktop and Server Install and Configuration- Performed Discovery Analysis on Tableau environment requirements, and documented the requirements for the new Tableau environment for software and license acquisitions. Planned and documented all the defined related tasks associated with the installation and configuration. Reviewed software and hardware requirements for Tableau Server and Tableau Desktop. Submitted internal requests for Fire-wall modifications and ports to be opened to support Tableau Server and all its features.

Data Validation - Gathered Data Mart & Reporting requirements then documented all reporting requirements, and generated a Data Dictionary.

Complex Report Development - Complex Report Development - Created several complex reports that were used for data validation. Scheduled standard monthly reports to be refreshed and delivered via email to intended recipients.

04/2012 – 01/2013 US BANK Minneapolis, MN

Business Intelligence Sr. Consultant / Team Lead via ACXIOM CORP

Managed the BI project proposed by client, ensuring that project successfully passed through all project processes in the project lifecycle. Orchestrated the collaboration of outside groups that performed dependency tasks that contributed to the solution, installation and configuration of the SAP Business Objects BI 4.0 environment, 4 Universes and 12 Essential Reports, Security Model for internal and external users, and a secure channel for users to enter the Business Objects environment to retrieve reports. Also responsible for all post upgrade testing and training on new version of Business Objects.

Discovery Analysis on Business Objects Environment Requirements - Documented the requirements for the new BO environment for software and license acquisitions. Planned and documented all the defined related tasks associated with the installation. Reviewed software and hardware requirements for BO servers.

Completed Preparatory Tasks for Installation - Created 2 empty Oracle Schemas necessary for the BO metadata databases (CMS and Audit). Installed and configured Oracle Client then added required tnsname.ora file entries for the CMS and Audit Database. Initiated tickets for dependency tasks related to server set up for installation and access rights. Moved install files and license keys to servers in the Business Objects Node Cluster.

Successfully Performed the BO Installation and Configuration - Installed and configured the new version of SAP Business Objects for optimum performance. Tested every aspect of the application, including authentication, navigation, migrated security model, report formatting, report scheduling and emailing.

Gathered Universes/Reports Requirements - Gathered, defined and documented requirements. Conducted a Discovery Phase in order to gauge the scope, complexity and cost of project. Created report samples with users, completed documentation for reporting requirements.

Completed Gap Analysis - Compared reporting requirements with data available in the Data Mart, and documented results in the reporting requirements document.

Created Data Model - Created Data models for the universes using Dimensional Modeling / Star Schemas

Developed Logical/Relational Universe Model - Created logical/relational universe model based off of the reporting requirements document and sample reports. Developed the universe structure inserted necessary joins, conditions and contexts. Defined and provide with user friendly descriptions for each object, either typical or custom object.

Tested Universes - Performed integrity check on universe, which included testing the universe structure, parsing objects and joins, checking for loops and utilizing contexts when necessary, parsing conditions and verifying cardinalities.

Implemented Production Ready Universes - Using version control to create a working copy of the completed and tested universe/s and then exported the universe/s to the production environment for production use.

Developing and Implementing Reports into Production - Created reports based off of the reporting requirements document and sample reports. Performed data integrity tests on reports created to reconcile the data against the data source. After acquiring sign off from client on report then published report into the production environment.

Gathered and Documented Security Model Requirements - Documented security requirements using a security requirements document then created a security model based off of documented requirements. Created groups and folders for each affiliated security group and then assigned necessary security access/privileges. Assigned each of the groups the necessary security access/privileges to each of the appropriated BO applications, server groups, universes and universe connections.

Created Administration and Security Model - Modified the Business Objects Server Setting to Meet Clients Performance Requirements. Documented the clients input on performance requirements and was asked to exercise my expertise on applying settings. Modified BO Server settings to tailor to the usability of the client and to employ the best performance achievable. Created Server Groups to Assign Job Resources. Created two server groups (corporate and divisional) to divide resources in order to process large number of simultaneous jobs.

11/2011 – 04/2012 HARLEY DAVIDSON Milwaukee, WI

Business Intelligence Sr. Consultant via ACXIOM CORP

Managed the BI project proposed by client, ensuring that project successfully passed through all project processes in the project lifecycle. Orchestrated the collaboration of outside groups that performed dependency tasks that contributed to the solution, implementation and delivery of the SAP Business Objects BI 4.0 environment, 16 Universes and 7 Essential Reports, and a Security Model for users. Installation and Configuration of SAP Business Objects Version 4.0. Also responsible for all post upgrade testing and training on new version of Business Objects.

Completed Gap Analysis - Compared reporting requirements with data available in the Data Mart, and documented results in the reporting requirements document.

Created Data Model - Created Data models for the universes using Dimensional Modeling / Star Schemas

07/2011 – 11/2011 MACY’S Marietta, GA

Business Intelligence Sr. Consultant via ACXIOM CORP

Performed a complex Business Objects 4 Node Cluster Configuration Upgrade from Version XI R2 to Version XI R3.1 SP4 successful upgrade and configuration of SAP Business Objects Version 3.1 SP4. Also responsible for all post upgrade testing and training on new version of Business Objects.

Discovery Analysis on Business Objects Environment Requirements – Completed and documented the existing (old) BO environment to use as a basis for configuring the new environment, and for deciding the upgrade approach. Prepared a risk analysis and contingency plan for each of the upgrade approaches, and shared results with client. I proposed a side by side upgrade approach which was accepted by client. I then planned and documented the upgrade approach chosen and defined all related tasks associated with upgrade.

Completed Preparatory Tasks for Installation/Upgrade - Organized the collaboration of different groups included in the upgrade process by ensuring that each group attended meetings and understood their roles in the project. Also, provided each of the different groups, involved in the project, a project plan outlining what was needed from each group and the due date for each task. Coordinated with DBA to create two necessary databases for the BO upgrade (CMS and Audit). Ensured that I was granted Administrative rights on the BO application server being used for the upgrade. Installed and configured Oracle Client then added required tnsname.ora file entries for the CMS and Audit Database.

06/2011 – 07/2011 HOME DEPOT Atlanta, GA

Business Intelligence Consultant via ACXIOM CORP

Oversaw the BI project proposed by client, ensuring that project successfully passed through all project processes in the project lifecycle. Orchestrated the collaboration of outside groups that performed dependency tasks that contributed to the solution, installation and configuration of the SAP Crystal Reports Server 2008 environment, 4 essential Crystal Reports and 3 Cognos Reports, and security model for users.

Performed Discovery Analysis on Crystal Reports Server Environment Requirements - Documented the requirements for the new Crystal Reports Server environment for software and license acquisitions. Planned and documented all the defined related tasks associated with the installation. Reviewed software and hardware requirements for Crystal Reports server.

Completed Preparatory Tasks for Installation - Installed and configured Oracle Client then added required tnsname.ora file entries for the CMS and Audit Database. Initiated tickets for dependency tasks related to server set up for installation and access rights. Moved install files and license keys to Crystal Reports server.

Successfully Performed the BO Installation and Configuration - Installed and configured SAP Crystal Reports Server 2008 for optimum performance. Tested every aspect of the application, including authentication, navigation, migrated security model, report formatting, report scheduling and emailing.

Modified the Crystal Reports Server Setting to Meet Clients Performance Requirements - Documented the clients input on performance requirements and was asked to exercise my expertise on applying settings. Modified Crystal Reports Server settings to tailor to the usability of the client and to employ the best performance achievable.

0/2011 – 06/2011 STATE FARM / NATIONWIDE Little Rock, AR

Business Intelligence Consultant via ACXIOM CORP

Performed a Business Objects Upgrade from Version XI R2 to Version XI R3.1 SP4 successfully for each of the clients (State Farm & Nationwide). Upgrade and Configuration of SAP Business Objects Version 3.1 SP4

Performed Discovery Analysis on Existing BO Environment - Completed a full analysis and documented the existing Business Objects environment, then proposed a side by side upgrade approach which was accepted by client. My discovery was on

Contact this candidate