Danny
Available only for C*C
acfvdk@r.postjobfree.com
Experience
March 2014-Present Application Architect Tableau Developer
American Express - Enterprise Business Analytics and Insights - TVO
Phoenix, AZ
. Designed dashboards tracking and highlighting application portfolio
actuals, estimated, and past dollar amounts
. Created visuals for AMEX team workflow optimization using custom
non-native Tableau charts such as Radar Graphs and Control Charts
. Developed Cumulative Flow Diagrams for Kanban workflows to track
work items
. Consolidated multiple Tableau workbooks into single workbook for
Amex TVO group single source Tableau report central
. Developed Tableau visuals for Controls and Compliance team mapping
banking regulations to internal policies, standards, and processes
to be used in presentations for AMEX leadership
. Cleaning and Blending multiple data sources to allow for different
views on application data in a single dashboard
. Designing data model from scratch to aid team in data collection to
be used for Tableau visuals
. Conducted presentations to other lines of business as a meta role
to show value of Tableau as a BI tool
. Kept track of own work effort with lean project management on
Kanban board
. Participated in daily stand-ups with clients on daily design and
development effort
January 2014-March 2014 Business Intelligence Tableau
Reporting
American Realty Capital Products
Phoenix, Arizona
. Designed dashboards for property management, accounting, and
infrastructure strategy groups within the commercial real estate
domain
. Created geographical analysis of business risks, highlighting map
location density of vacancies and accounts outstanding customers in
North America
. Improved reporting structure by consolidating 12 separate reports
into one dashboard view using filters, actions, and parameters for
the user to customize inputs to the dashboard layout
. Customized Tableau Server for Report Repository with Interactive
Dashboards and Reports
. Demonstrated Proof of Concept to clients
. Met with clients for requirements and scope gathering
. Created access groups as Tableau Server administrator for Asset
Manager, Property Manager, and Investor
. Created 12 reports and 2 dashboards from Property Management data
. Used Action Filters for interactive drill-down reports from summary
to detailed data
. Created KPI's for Accounts Receivable data using Custom
Calculations
. Used Tableau's Javascript API to create pop-up box drill-downs from
user clicks
. Created custom background images and WMS world maps
Technologies: Tableau Server, Javascript API, HTML
RIIM LLC, Business Intelligence Developer,
Scottsdale, AZ
Portfolio Management system
. Portfolio Management with dashboard reporting
. Data modeling with ERD to create logical view of data to be stored
in OLTP
. Created a relational database OLTP using MySQL
. Designed a star schema data warehouse linking multiple dimensions
to fact table based on requirements gathering for reports and
dashboard proposal
. Created two dimension tables with a Type 2 Slowly Changing
Dimension scheme in order to be able to report on historical data
and track changes
. Created a view on the database to join the dimensions to the fact
table and import the data to Tableau 8.1 by connecting to MySQL
back-end
. Created hierarchies of data to reflect higher to lower level
segments within organization
. Created field calculations to display margin within company
Portfolio
. Created custom calculation at the table level to reflect gross
margin as a percentage of revenue for each portfolios generated
revenue
. Created worksheet view reporting revenue for each project grouped
by the location of that project within the United States.
. Created a geo-map report which displayed the density of project
distribution throughout the US being highlighted on the map with
tooltip information about each point on the map
. Created dashboard at project level allowing user to customize view
based on parameters and various radio button, and slide filter
options
. Created dashboard at Portfolio level using highlight tables, area
charts, and tree maps
. Linked 3 reporting sheets together using action filters allowing
drill down mechanism in one sheet to be reflected across all 3
Technologies: SQL, MySQL, Access, Excel, Tableau
Skills
Tableau Data Visualization SQL R Programming Data Warehouse
design and concepts Kanban Agile Scrum Development Linux OS
Education
Griffith University, Gold Coast,
Australia
Aug 2012 Master of Information Technology
Arizona State University, W.P. Carey School of Business, Tempe,
AZ
May 2011 Bachelor of Science in Computer Information
Systems
Internship
April 2010-Aug. 2010 System Engineer Intern Charles
Schwab & Co, Inc.,
. Server administration using 5 versions of Red Hat
Enterprise Linux
. Built development servers running database, reporting, and
virtual platforms