Emmanuel Ngwasiri

972-***-**** Royse City, TX ad3h38@r.postjobfree.com

Professional Summary

Experienced and motivated Qlik Sense/SQL Developer with 8 years of Database Design Development, ETL Implementation, Data Modeling, Designing and Reporting and support of OLAP/OLTP using QlikSense / N-printing, Microsoft SQL Server 2012-2019 and Snowflake. Recognized for assessing operational needs and developing solutions to save costs, improve revenues, and drive customer satisfaction. Resourceful and well organized with excellent leadership virtues and team player, Strong Problem solving skills, Excellent work and communication ethics.

Education\Certification

Bachelor's Degree in Computer Science

University of Buea 2004 - 2007

Technical Skills

BI Solutions: SQL Server BI Development Studio, Qlik Sense Enterprise 13.51.10, QMC, N-Printing, R integrated with Qlik Sense and Power BI Service.

Database Tools: SQL Server Management Studio, Snowflake, Denodo

Languages: SQL

Operating Systems: MS Windows

Office Tools: PowerPoint, MS Word, Excel, MS Access, Outlook.

Professional Experience

Republic Services – Phoenix AZ Feb 2023 - Present

Support Engineer – QlikSense and Power BI

•Define application system scope and objectives through research and fact-finding and make recommendations pertaining to system design and solutions.

•Use business intelligence tools such as QlikSense and Power BI to troubleshoot admin issues and provide guidance to the BI development team. Design, schedule and validate automated reporting systems.

•Maintain, patch and monitor performance of the BI environment and the connected databases.

•Collaborate and support offshore admins for tool upgrades, deployments, and any design changes to the environment.

•Integrate, normalize, and update data across sources. Monitor data refreshes, identify any bottlenecks, and communicate findings Diagnoses and resolves software application issues of end users promptly and professionally.

•Engage appropriate IT and business resources to resolve technical issues and support business processes, while updating users on progress toward resolution.

•Provides technical direction related to deliverables for both on-shore and offshore team members.

•Identify and recommend system modifications to reduce user issues.

•Fully document and create defects of each issue and resolution using the incident tracking system.

•Keep support desk team, peers, and management apprised of any new support issues in a clear and timely manner.

•Provided accurate and effective solutions that end user support needs with a consistently high quality of service.

•Performs other job-related duties as assigned or apparent.

•Provide ticket support to business users.

Rimini Street Inc. – Pleasanton CA Sept 2019 – Jan 2023

Business Intelligence Analyst - Qlik Sense

Essential Duties & Responsibilities

Work with various business units to identify their analytics needs, gather requirements and create functional specifications document.

Evaluate, design, and develop business intelligence reporting and dashboards according to functional specifications while maintaining data integrity and data quality.

Identify, analyze, architect and develop data models, and deliver integrated, scalable BI solutions mainly based out of QlikSense.

Develop and support data governance processes, analyze, normalize data to identify and articulate trends, patterns, outliers, quality issues, and continuously validate reports, dashboards and suggest improvements.

Definition of project schedule and timelines, and publishing of progress reports.

Ability to abstract business issue and using data analysis techniques determine the root cause and possible solutions.

Provide research, high-level design and estimates for data transformation and data integration from source applications to end-user BI solutions.

Evaluate, design, and develop business intelligence reporting and dashboards according to functional specifications while maintaining data integrity and data quality.

Work collaboratively with key stakeholders to translate business information needs into well-defined data requirements to implement the BI solutions.

Leverage transactional information, data from ERP, CRM, HRIS applications to model, extract, and transform into reporting & analytics.

Define and document the use of BI through user experience/use cases, prototypes, test, and deploy BI solution.

Hands-on experience on QlikSense extension development in JavaScript / Angular.JS or UI Frameworks.

Create mashups, widgets using angular/angular.JS and SQL server/Snowflake for web integration of Qlik Sense apps and its objects. Work with Qlik Admin to test the application of critical patches.

Create tables and views used by Qlik sense reports in Snowflake.

Work with Business users and IT team for upgrading the software, testing and training the users.

Integrate N-printing with Qlik sense to create On-Demand report generation functionality by users

Create parametrized N-printing reports on various templates for On-demand report creation and distribution of reports from Qlik environment.

Work with Qlik Sense sites and the Qlik Management Console, to provide data and application governance, library maintenance, as well as user and application security.

Use of R in integration with Qlik sense to generate Statistical analytical reports as per business needs.

State Farm – Minneapolis MN Jan 2018 – June 2019

Qlik Sense Developer

Roles & Responsibilities:

Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server, Oracle, binary QVW, Inline & txt files in creating the Qlik Sense dashboards.

Connected to different ODBC, OLEDB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of Qlik Sense.

Involved in Data modelling and worked on various complex models, which involved in eliminating Circular keys, Synthetic keys.

Developed charts as per the customer requirements as Monthly, Quarterly and Yearly for report analysis with charts provided by charts in Qlik Sense.

Developed Drill through Dashboards, which enabled users to drill down between dimensions for better visualization.

Used Set Analysis in the charts as per the customer requirement.

Worked with Variables to hide/show the necessary objects and perform logics according to the user requirement.

Implemented the concept of Master Library items and used the concept of Story generation to meet the user requirement.

Optimized existing Data Models like changing Load scripts to load data in optimized way to achieve reduction of loading time, simplified complex expressions in the front-end and improved layout structure.

Implemented the various types of loads to improve the performance of the dashboards like Binary Load, Partial Load, Inline Load, Incremental load.

Implemented optimized loadings and performance tuning with the help of Qlik Support.

Performed error handling process and debugging the applications.

Use different color schemes for charts according to meet requirements.

Worked on Qlik Sense new objects Maps, KPI, object, and document extensions for wire frames and proof of concept applications.

Involved in converting Qlik View applications to Qlik Sense.

Extensively worked with Qlik Sense Functions to meet the user requirements.

Trained users to build their own apps in Qlik Sense.

Involved in client communication sessions to evaluate client needs & ensure timely project delivery

Tools: : Qlik Sense 13.2.2, 3.2.1, SQL Server 2016, Excel, Flat files, MS Project, MS Office suite (word, Excel, PowerPoint)

7 - Eleven Irving TX Mar 2015 – Dec 2017

QlikSense Developer

Roles & Responsibilities:

Developed Qlik Sense Dashboards using various functionalities of Qlik Sense - Chart types: Line, Bar, Combo, Map and Gauge charts, drill down, drill up.

Designed Develop and tested Qlik Sense scripts to import data from source systems and test Qlikview dashboards to meet business requirements.

Managed Data in Qlik Sense application from QVDs, excel files, database and external loading files.

Worked on Qlik Scripting, data analysis, BI Data Models.

Developing/Creating Qlik Sense Extensions to meeting business requirements.

Developed/built dimensional model for facts and dimensions tables.

Worked on the creation of the tasks, scheduling of the applications, reloading of data, distribution of applications and reducing the size of application. Created scheduled jobs through Qlik Management Console(QMC).

Developed brand new Qlik Sense Apps with the help of D3 Visualizations, Extensions available in the Qlik-branch, new Qlik Sense framework default functionality like Beta Maps, KPI Object, Export to PPT/PDF, storytelling etc.

Involved in the installation, upgradation of the Qlik Sense server.

Business User Engagement for overview of Qlik Sense and performing training sessions for End Business users.

Managed security layer with access management at the user level.

Image Insertion into Pivot table, creating scattered charts based on requirements.

Modified existing Qlik Sense dashboards, communicate with the business users in case of any issues with using the applications and providing solutions.

Performed detailed analysis of source systems, source data and model that data in Qlik Sense.

Performance tuning of Qlik Sense dashboard in order to reduce the calculation time and improving the overall performance of the dashboard.

Contact this candidate