SUMMARY

Certified and accomplished Business Intelligence Consultant with an extensive background in Data Modeling, Data Warehousing Business Intelligence Analytics. I'm a SCRUM minded/focused individual that can accurately estimate tasks and successfully deliver projects on time. I possess multiple certifications IBM Initiate, Tableau, QlikView , as well as 3 MCPs towards database administration and application development. My combined expertise as a Data Modeler, ETL Developer, Data Warehouse Engineer, and Report Developer has provided me with the abilities to thoroughly evaluate business requirements, as well as deliver exceptional designs and solutions that are clearly communicated throughout the organization.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

DataWarehouse Developer

Datawarehouse and ETL Development MS BI Stack

• SSIS 2012 ETL development to support ODS, DW Facts Dimensions
• Requirements gathering and analysis
• Data Preparation - Data Profiling, Data Cleansing
• Master Data Services support
• Incremental ETL processing
• SSAS 2012 Cube development to support Commissions and Sales cubes
• Multi-Dimensional and Tabular Model Development
• Report design and generation

Confidential

Sr. Data Analyst/Data Architect

SQL Server 2012 Data Mart / Data Warehouse Implementation Project

• Project Plan creation
• Data and Requirements gathering, analysis, review Requirements document
• Data Dictionary design and creation
• Data Modeling Conceptual, Logical, and Physical Models based on requirements
• ETL Design data profiling, extraction, transformation, loading
• Fact and Dimension table creation for consumption by Tableau, SSRS, LogiAnalytics
• Matching Algorithm creation for binding multiple datasets for data mining
• Predictive Analytics for positional bond trading training set, test set

Confidential

Information Management Specialist Consultant, Initiate MDM- Master Data Management

MDM Implementations Clients: Adventist Healthcare Advocate Healthcare Choice Hotels

• Customer requirements gathering, analysis, review
• Configure Initiate MDM member data model
• Configure Algorithms Standardize data, bucketing, comparison functions
• Clean data extracts data profiling, extraction, transformation, loading
• Data derivation, weight generation, bulk cross matching
• Instance/Hub/Client Tools creation and deployment

Confidential

BI Architect SSIS, SSAS, and SSRS

ASIA Sales/Inventory/ASP SSAS Cube Development

• Requirements document analysis resulting in re-defining scope and deliverables
• Identification of facts and dims with associated source-to-mapping document deliverable
• Conceptual, logical, and physical data model deliverables
• Cube specifications document deliverable
• ETL SSIS Package deliverable
• SSAS Cube creation
• UAT Deployment Testing/Review

Confidential

QlikView Consultant/Developer

Migration of Cognos Reports to QlikView Reports

• Analysis Phase Identified and discussed QlikView system functional technical requirements, proposed possible solutions with positive/negatives and provided a recommended solution, specified the final agreed upon detailed solution requirements
• Planning Phase Established the QlikView project management elements of the project, including communications, roles and responsibilities, initial timeline, processes and procedures
• Design Phase Conceptual, logical and physical data model development. Developed a 3-Tier Mixed qvds QlikMarts blueprint design document for the construction of the QlikView solution QVD Architecture, QVD Reload/Load Methodology, Publisher, and Server implementation performance , including critical elements such as data sources and integration, application workflow, infrastructure, based on requirements
• Checkpoint Phase Assessed the design requirements against resources, timeline, and estimate to completion, making modifications when appropriate
• Build Phase Developed and integrated QlikView solution components to meet design specifications via an iterative development process
• Test Phase Testing of the QlikView system across multiple levels unit, system, functional, user acceptance, performance, security , refined the solution to ensure acceptance
• Deploy Phase Preparation of finished QlikView solution, including design automation, developed required documentation user guide, admin guide, user training
• Review Phase Project team discussions to gather lessons learned and assess project performance in regard to data accuracy application performance

Confidential

Sr. Database Engineer

• Requirements Gathering and Data Modeling
• Worked with business users to define and analyze problems
• Created conceptual, logical, and implemented physical data models
• Develop and Manage Reporting Solutions
• Implement SSRS schedules, subscriptions, and security using Report Manager
• Report creation using Report Designer
• Dataset creation w/ filters, groups, sort, aggregates, parameters
• QlikView Project Solutions Created Sales, Marketing, Finance QlikMarts qvws
• Tableau Reporting Solutions
• Tableau Licenses Activation
• Tableau Server Product and Capacity Key activation
• Tableau Licensing Task automation
• WMS for Integration with Tableau deployment
• Tableau Product Key management
• Tableau Installation, Upgrades Configuration
• Server status automation
• Multi-Interface Network Server Installation
• Tableau Server and IIS Co-existence configuration
• Installation log creation
• Displaying Maps in Tableau Server
• Tableau Server Authentication Method Modification
• Tableau Desktop/Reader repair
• Troubleshooting Server Backup and Restores
• Disk Space Requirements determination/configuration
• Tableau Integration, Maintenance, Security, and Authentication
• Adding Tableau Server Certificates to SharePoint
• Configuring Tableau Server to use the Global Catalog
• Creating Project-Based Permissions
• Resolving IE Warnings when accessing Tableau Server and Views
• Resolving Multiple Prompts for Credentials
• Tableau Server Security Encryption
• Testing Trusted Authentication
• Using Tabbed Views and Security
• Workbook Permissions on Tableau Server
• Tableau Data Connections, Extract Creation, and Performance Optimization
• Adding Data from a second data source to an existing data source
• Analysis services cell-level security
• Combining multiple data sources into a single view
• Data blending with Summarized Data
• Data Connection export
• Normalizing data for use in Tableau
• Workbook creation
• Extracting data, refreshing extracts, incremental extracts, and aggregated extract creation
• Sending packaged workbooks
• Improving database query performance
• Monitoring Tableau Server Performance
• Optimizing Incremental refreshes and Server performance
• Market Basket Analysis
• Stored procedures and function usage
• Develop and Manage Integration Services ETL
• Install, configure, and monitor SSIS
• Package, data flow, control flow, and event handler creation
• Administration and implementation of error handling and debugging packages
• QlikView Scripting
• Develop and Manage Business Intelligence Solutions
• Install, configure, and monitor SSAS
• Creation of QlikView Monitor Capacity Planning qvws
• Configure server and database roles and permissions
• Implement processing for SSAS objects
• Implement disaster recovery tasks
• Data Mining Solutions
• Algorithms development, testing, and implementation
• Selection of a data mining definition method and configuration of algorithm parameters
• Testing and processing of data mining models
• Data mining model querying using DMX Data Mining Extensions
• Developed multiple QlikView What-If analysis qvws for BI Department