BRYAN WACHIRA

Phone: (***) ***–**** Email: adefou@r.postjobfree.com

Professional Summary

* ***** ** ********** ** Analysis, Design, Development, Testing and Implementation of Business Intelligence applications using Qlik Sense and QlikView applications.

Experience in installing and configuring Qlik Sense Enterprise.

Strong knowledge in designing and developing Qlik Sense and QlikView dashboards by extracting data from different sources like SQL Server, Flat Files, Excel files, and XML Files.

Worked in installation & configuration, environment, system analysis, design, deployment, and testing of projects.

Experience in QlikView Scripting, Set analysis, and Section Access.

Scheduled the jobs and distributed to end users from QMC.

Trained end users to develop and use QlikView and QlikSense applications.

Experience in optimizing Qlik Sense and QlikView applications to improve the performance.

Experience in developing Load Scripts, advanced loops and automating loads.

Developed QlikView and QlikSense objects like Multi Boxes, Straight tables, Pivot tables, Containers, Line charts, Bar charts, Combo charts, Scatter charts, Line objects, Pie charts, Buttons and added advanced functionality and macros assignment.

Ability to read and interpret Complex Data Models, and Data Modeling.

Expertise in Designing FACT Tables, Dimension Tables, Summary Tables.

Expert in Creating complex expressions for dynamic aggregation

Customized the reports by using Open Document syntax to create a hyperlink in one Document that created Drill-Through reports to provide users with more detailed information and query linking.

Proficient in troubleshooting and fixing the Qlik Sense and QlikView dashboard issues.

Experience in complete life cycle including documentation, analysis, developing, and testing.

Business Intelligence experience in Development, Client Analysis, Database Design, Reporting and Presentation using SQL Server 2012/2014, SSIS, SSAS and SSRS.

Experienced in creating complex SSIS and DTS packages for ETL purposes. Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS and SQL Scripts.

Worked on T-SQL programming, stored procedures and views in the process of developing reports.

Deployed and configured the reports in the Report Server.

Worked in Agile methodology environments and involved in scrum meetings.

Delivered all the projects and assignments within the specified time lines with accuracy.

Strong ability to work within demanding and aggressive project schedules and environments.

Education

University of Nairobi

Colaberry School of Data Analytics Plano, TX

Qlik Sense Developer

QlikView Developer

Microsoft SQL Server 2008 – Business Intelligence Implementation and Maintenance

Microsoft SQL Server 2008 – Implementation and Maintenance

Microsoft SQL Server 2008 – Database Administration

Microsoft SQL Server 2008 – Database Developer

Microsoft SQL Server 2008 – Technology Specialist

Technical Skills

ETL : SQL Server Integration Services (SSIS), T-SQL Stored Procedures

Languages : SQL, QlikView, Qlik Sense

Operating System’s: Windows server 2003/XP/NT 6.0/98/Vista,7,8,10, Mac OS

Data Modeling : Microsoft Visual Studio 2012/2014/2016, SSAS

Office Tools : MS Word, PowerPoint, Excel, Visio, One note, Service Now, SharePoint.

Domains : Health Care, Real Estate & Auto Repair.

Professional Experience

SEAGATE FREIGHT February 2014 – March 2020

Qlik Sense/ QlikView Developer

SQL Business Intelligence/ Qlik Sense/ QlikView Developer

Responsibilities:

Worked closely with all levels of business, with varying levels of technical knowledge, to gather accurate and actionable business and technical requirements.

Created mock-ups showing the intended functionality, visual aspects of the dashboards to be developed.

Created report based on dimensional, and relational models.

Handled performance tuning and optimization, with strong analytical and troubleshooting skills for quick issue resolution.

Developed Reports in Visual Studio by using the variety of tools such as charts. map, matrix, indicator and more.

Perform the system testing and assist application developers and technical support staff in identifying and resolving defects

Deployed and configured reports in Report Server configuration and make it ready for the end user.

Involved in designing, developing, testing, publishing, maintaining, and supporting QlikView & QlikSense applications.

Developed Proof of Concepts (POC) for various projects using QlikView and QlikSense.

Building QVDs, QVWs, QVFs using source systems like SQL Server and Excel files.

Developed dashboards pertaining to KPI monitoring using Qlik Sense.

Developed dashboards with next level Map visualizations (Geo Analytics).

Optimized existing data models and load scripts to improve performance.

Created Input boxes, Pivot Tables, Straight Tables, Bar Charts, Buttons, Multi boxes on the User Interface to make the data easily accessible to the users. Implemented data level security using Section access.

Analyzed the Qlik Sense/QlikView data model, script logics and the ETL business logic for the existing Qlik Sense/QlikView applications.

Developed complex Qlik Sense scripts to build model, to support various KPIs and time comparison.

Responsible for positioning and delivering Qlik Sense projects and cross building applications into new and existing customer base.

Designed the daily refresh process and created tasks and triggers using QMC.

Generated, scheduled, and distributed customized reports using NPrinting.

There were millions records with daily incremental reload schedule.

Emphasized on Data Integrity to good chart aesthetics.

Worked with Qlik Sense, QlikView, SQL, Excel files, CSV files and flat files.

Environment: MS SQL Server 2012/2014/2016, Qlik Sense, QlikView, QlikView Management Console, Reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS)

We have a long-term consulting role for an Qlik Sense Developer with strong data modeling experience.

Contact this candidate