Uploaded File
add photo
David
davidadumas@gmail.com
303-902-9384
Pompano Beach, FL 33062
Sr. Solutions Architect
23 years experience W2
0
Recommendations
Average rating
6
Profile views
Summary

QlikView 11 Certified Developer and Designer with over 15 years architecting and coding BI Solutions and Data Warehouse Architecture. Exceptional at partnering with diverse industries such as Retail, Healthcare, Logistics, and Telecommunications. Adept at translating complex business problems into effective technical solutions. Hands on technical leader who can architect, design and code and consistently delivers high ROI solutions to customers by pushing Business Intelligence tool sets to their limits. Many QlikView architects have no expertise in Data Warehousing, Data Modeling, SQL, Database development, or ETL. I have 15 years' expertise in these skills, ensuring your QlikView projects have the highest rate of success, flexibility, and expansion possibilities, as requirements expand. QlikView Architect with many successful implementations. Experience in all phases of design, and development including requirements gathering, data preparation, SQL, ETL, data modeling, scripting, dashboard design, nPrinting, server and publisher.
• Database Architect and Developer with high level skills in Relational and Dimensional Design. High level of competency in SQL, PL/SQL, and T-SQL. Experienced in creating sophisticated Packages and Stored Procedures supporting complex design requirements.
• ETL Design and Development using Talend, and SSIS. Experienced in developing elegant ETL workflows, data mappings, and transformations across diverse data sources.
• Highly experienced Data Modeler proficient in Logical and Physical Data Models using Relational and Dimensional designs, across enterprise databases. I am comfortable in the industry leading tool PowerDesigner. SDLC Data Warehouse Architecture, Design and Development. Experienced in building Inmon and Kimball DW and Data Mart architectures, utilizing relational and dimensional models.
• Best practice Dashboard and Analytic Visualization Design and Development using Qlikview.
• Over 10 years' experience in developing data warehouse and BI solutions.
• Motivated team leader who enjoys mentoring and training others.

Experience
Sr. Solutions Architect (FTE)
Banking/Financial
Jan 2015 - present
QlikView (Private). Ongoing Design and Development of QlikView Financial CRM and Help Desk Ticketing applications. Created a SQL Server Operational Data Store utilizing PowerDesigner SSIS ETL packages and SQL Server job scheduling. ETL takes advantage of incremental loading and SQL Server change tacking. Design and Development of all QlikView related work including the setup of jobs and tasks in Server/Publisher data model and variables scripting UI Dashboards and nPrinting reports.
• * IPC Global, QlikView 2014
• Client: Southern Illinois Healthcare. Design and Development of a Sepsis QlikView application to track cycle time metrics designed to improve the care of Sepsis patients of this multi-hospital Healthcare Group.
• * *
Solutions Architecture SQL ETL Scripting SQL Server SSIS
Remove Skill
QlikView Expert Services Consultant (FTE)
Jan 2014 - Jan 2014
Various. Designed and Developed: QlikView applications for enterprise clients including a KPI dashboard analytic and reporting solution for a large telecommunication integration firm focused on Telecommunications service delivery call center help desk ticketing resolution and customer satisfaction.
No skills were added
Remove Skill
Independent Consultant
Jan 2013 - Jan 2013
Sun Country Airlines. Refactored existing Talend Data Warehouse ETL for an airline to a best practices design for Dev/Test and Production environments. Redesigned to modular and maintainable ETL code. Also created additional ETL jobs for Talend ETL jobs moving and transforming airline flight and passenger data.
No skills were added
Remove Skill
Lead OBIEE Architect
Jan 2013 - Jan 2013
QlikView Rosslyn Analytics. Designed and Developed: A multi-tenant QlikView application complete with dashboards analytics and ad-hoc reports for a global logistics firm for client of this Qlik partner. Enabled instant visualization and exploration of weight cost and route data across worldwide shipping carriers allowing the business to better consolidate routes and save costs.
OBIEE
Remove Skill
Data Warehouse Architect (FTE)
Banking/Financial
Jan 2012 - Jan 2013
NREL. Designed and Developed: An OBIEE based financial reporting solution and dashboard enabling financial control of all government projects. Project based on Oracle EBS financial data and still used daily by hundreds of users. Built and maintained repository metadata layer security numerous frontend dashboards agents and reports enabling rich ad-hoc reporting for financial analysts and hundreds of project managers.
Data Warehousing Metadata OBIEE Oracle
Remove Skill
Jan 2009 - Jan 2012
* Created a new Oracle OBIEE based Data Warehouse and Business Intelligence solution marketed to thousands of customers and thus creating a new revenue stream. Designed and developed ETL framework used by multiple teams. Created PL/SQL package to dynamically create parameterized Oracle scheduler ETL jobs. Modeled the data warehouse and dimensional schemas in PowerDesigner. Designed and developed numerous ETL jobs ETL. Developed the OBIEE metadata layer, dashboards and reports, enabling rich ad-hoc reporting. Skills and tools used: SQL, PL/SQL (numerous packages), OBIEE, Talend, and PowerDesigner. *
No skills were added
Remove Skill
Information Technology
Jan 2009 - Jan 2009
Ball Corporation. Refactored a PL/SQL ETL solution to highly maintainable SSIS ETL packages for several SQL Server Data Marts, from diverse data sources, including JD Edwards, and SAP. Mentored and trained several staff developers in the mew SSIS ETL solution.
No skills were added
Remove Skill
Sr. BI Architect (FTE)
Information Technology
Jan 2008 - Jan 2008
Quiznos. Developed: a BI solution for revenue and compliance at Quiznos. Designed and developed database architecture SSIS ETL and SSAS OLAP Cubes for the new data warehouse and BI solution. Project integrated data from multiple diverse source systems and incorporated OLAP Cubes in executive dashboards and analytics.
BI Architect Compliance Data Warehousing ETL SSIS
Remove Skill
Independent Consultant
Information Technology
Jan 2007 - Jan 2008
ACS Software. Designed and Developed: The key database architecture and subsystems for ACS's Oracle and SQL Server based commercial document management software product for the trucking industry. Designed database structures complex data flows and complex SQL process in stored procedures and functions. Architected and coded an automated ETL solution integrating SQL Server and Oracle data enabling a closed loop for the document data thus enabling the business to provide online document management to their major customers.
SQL SQL Server
Remove Skill
Information Technology
Jan 2004 - Jan 2006
Designed an Analytic solution integrating data from, Implemented Tableau visual data analysis software into key areas of the business, and developed reports to key executives within the organization. Extensive Enhancement of the Call Center Order Management system to include a C.R.M. system. Modules added include Customer Case Management, Sales Campaign, and Email Campaign Management. *
No skills were added
Remove Skill
Jan 2003 - Jan 2004
Architected, designed and developed Infospot's Call Center Order Management system used by Startek, Denver, for their clients at various locations. Modules include Call Center Order Management, and fulfillment Interface to SAP. As a product of Infospot, I was responsible for all phases of design and development. *
No skills were added
Remove Skill
Information Technology
Jan 2000 - Jan 2002
Architected, designed, and developed the Oracle based Tupperware US Sales Commissions System. This is utilized by their US sales force nationwide. System calculated commissions to compensate over 25,000 representatives each month. Software was designed using Oracle Designer. Design, development and deployment of numerous complex Oracle PL/SQL packages.
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Computer Science
UNIVERSITY OF FLORIDA
Certifications
QlikView 11 Certified Developer
Skills
SQL Server
2021
7
ETL
2021
6
Scripting
2021
6
SSIS
2021
6
SQL
2021
5
Solutions Architecture
2021
4
Data Warehousing
2013
1
Metadata
2013
1
OBIEE
2013
1
Oracle
2013
1
BI Architect
2008
1
Compliance
2008
1
Data Modeling
0
1
Database Architect
0
1
PL/SQL
0
1
T-SQL
0
1