Mark Wexelberg
Lake Orion,MI
Summary
13 years of providing BI solutions, leadership and development to the healthcare, insurance, publishing, and automotive sectors. I am a customer centric, solutions oriented, BI architect / administrator / developer with a successful track record in setting corporate policy, governance, and best practice standards for optimal performance and usability for users who are on the front lines.
Overview
16
16
years of professional experience
Work History
Qlik Architect / Administrator / Product Lead
WIT, Inc at Stellantis
Troy, MI
01.2016 - Current
- Architect and Administrator of 10 Qlik production environments, 2 test environments and 6 development environments
- Environments make up 2 external and 8 internal environments
- A total of 32 dedicated servers, 10,000+ global users, 2,300+ applications and 15 terabytes of data
- Responsible for the overall integrity, performance health, optimization, and stability of these environments
- Established corporate policy, governance, and best practice standards for all things Qlik such as architectural and code reviews as well as production release schedules for all business areas
- Oversee the application build quality of 40+ developers from all over the world
- Responsible for the review and approval of any new Data Integration and BI 3rd party products such as Qlik Replicate, Compose, Catalog, Motio, Vizlib, GeoAnalytics, Telemetry, TreeSize, and Power BI
- Lead a team of 3 other Qlik Administrators.
Sr. Business Intelligence Analyst / Developer
University of Colorado Health at Memorial
Colorado Springs, CO
07.2012 - 11.2016
- Scope and manage Directors BI requests/needs
- Translate and document business requirements into BI technical requirements
- Extract data from multiple, desperate EHR data sources to create unified data models for single source of truth reporting and analysis
- Perform data cleansing, data validation and full ETL process
- Create and maintain complex enterprise data warehouse solutions with supporting metadata, corporate data governance and compliance
- Manage business user security and distribution rights to the BI data
- Teach best practice development to peers and help troubleshoot and support existing BI applications.
QlikView Technical Consultant
Intellisight, Inc.
Princeton, NJ
11.2011 - 07.2012
- Provide pre-sales support by demonstrating the value of QlikView to potential clients and building proof-of-concept applications against client’s live data.
Business Intelligence Consultant
Symphony Business Intelligence, LLC at Memorial Health Systems
Colorado Springs, CO
03.2009 - 10.2011
- Produce Proof of Concept analysis and reports BEFORE the need to create final data warehouses/marts
- Very fast and saves a lot of time and money
- Work with end users and architects to translate business requirements into technical requirements and specifications
- Able to profile data to verify business rules and resolve discrepancies with the business
- Knowledge of key data warehousing processes
- Experience pulling different types of data from desperate data sources
- Performed in-depth ETL process
- Deep front-end BI analysis and development experience with multiple BI visual tools
- Continue to provide BI consultation to Memorial Health System and act as liaison between Memorial Health System and 3rd party QlikView vendor.
Business Systems Analyst / Business Intelligence Developer
Group Publishing
Loveland, CO
09.2007 - 03.2009
- Spearheaded, developed and implemented QlikView which overcame a 7 year BI gridlock
- Provided daily, ad-hoc sales reporting, campaign ROI’s, predictive inventory analysis, pricing and quantity price break for wholesale and retail channels, commission reporting to COO, CFO, Corporate Sales division and Strategic Business Unit Managers
- Performed daily ETL of data from Oracle 10g, SQL Server, Data Warehouse, Access and XML, CSV, Excel data sources
- Developed QlikView training curriculum and taught weekly training classes.
Supply Specialist
US ARMY
Fort Ord, CA
- Managed inventory of 10,000 SKU items
- Received Special Accommodation Award for assuming and carrying out my leader’s responsibilities in his absence during Desert Shield Operation
- Received Commander’s Physical Training Award for highest scores in physical training
- Honorably discharged
- Raised money for college.
Education
Business Intelligence Master’s Program -
SetFocus, LLC
04.2011
Bachelors in Public Administration -
Dallas Baptist University
12.1998
Skills
- Qlikview
- Qlik Sense
- Replicate
- Compose
- Telemetry
- Business Objects
- Java
- Talend (Data Integration and CDC)
- QA and QC Processes
- Snowflake on AWS
Additional Certifications And Training
- Crystal Reports (Business Objects)
- QlikView Business Intelligence
Ehr Systems
- Cerner
- HIS
- AllScripts
- Epic
Business Intelligence Experience
Design and administered large BI environments for optimal performance and stability. Established corporate policy, governance, and development best practices. Comfortable with scoping, documenting and managing BI initiatives. Understand the importance and management of data quality, data governance and data reusability. Experience in the full cycle of Business Intelligence development. Extracting and unifying data from desperate data sources, data modeling, data validation, deep ETL experience, development of proof-of-concepts, developing custom dashboard/KPI’s, leveraging Build/UAT/Production environments, and managing user security rights to data and BI applications. BI tools I have experience working in: Microsoft BI stack (SSIS, SSAS, SSIS, Power Query, Power Pivot, Power Maps, Power View), BOE (Crystal Reports), QlikView, Qlik Sense, TIBCO Spotfire, Tableau, Oracle Discoverer, Power OLAP and Power BI.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
The ultimate goal, reward and joy is to serve others and to ensure their success.
Mark Wexelberg
Timeline
Qlik Architect / Administrator / Product Lead
WIT, Inc at Stellantis
01.2016 - Current
Sr. Business Intelligence Analyst / Developer
University of Colorado Health at Memorial
07.2012 - 11.2016
QlikView Technical Consultant
Intellisight, Inc.
11.2011 - 07.2012
Business Intelligence Consultant
Symphony Business Intelligence, LLC at Memorial Health Systems
03.2009 - 10.2011
Business Systems Analyst / Business Intelligence Developer
Group Publishing
09.2007 - 03.2009
Supply Specialist
US ARMY
Business Intelligence Master’s Program -
SetFocus, LLC
Bachelors in Public Administration -
Dallas Baptist University