BI Consultant/Team Lead QlikView | QlikSense | Nprinting
MUSHKO Electronics Pvt Ltd
Total years of experience :10 years, 11 Months
Software Engineer & BI consultant
Core Responsibilities:
• Data Modeling using Dimensional Modeling, Star Schema, Snowflake schema
• Writing Scripting (Using Joins and many other QlikView Functions)
• Designing & Development of Analysis Reports, Charts, Scorecards, Dashboards
• Working on different Qlikview features like Linked Table, Associative search, Charts, Set Analysis, Created PDF push reports, Email Automation, Generating Alerts etc., also work on Variable and generating Triggers.
• Created and maintained user guides and documentation for QlikView applications.
• Understand Requirement, Analyzing Systems and Source Databases.
• Strong understanding on BI architecture
• Maintain security and controls and access (Section Access)
• Generate report of activity
• Do RND and Testing on different scenarios and reports and making reports for their solution.
• Manage overall Project on client side as a Team-Lead.
• Training to IT and Business user Team before deploying project.
Projects
Al-Meezan Bank
Implement Qlikview as BI Solution in Al-Meezan Bank on their SQL data ware house.
I have implemented 7 Dashboard that includes:
1) Deposits Dashboard
2) Trade & finance Dashboard
3) Bank PNL Dashboard
4) Assets Dashboard
5) Customer PNL Dashboard
6) Consumer Finance Dashboard
7) Treasury Dashboard
• Also I have implemented Qlikview Nprinting and create different types of Reports using QlikView Nprinting such as, Pixel Perfect Report (PDF Report), Power Point, Excel Reports, HTML Reports.
Hilal Foods
Provide support for Sales Dashboard using Qlikview11 as BI Solution in Hilal Foods on their Oracle Data Ware house.
TPL Holdings
Provide support for Qlikview11 in TPL Holdings on their Oracle Data Ware house.
Glaxo Smith Clien(GSK)
Provide support for Qlikview11 in Glaxo Smith Clien (GSK).
POC/Pilot Project
National Bank of Pakistan
Create POC and make Demo Dashboard using Qlikview11 as BI Solution in National Bank of Pakistan on their SQL data ware house.
Hilal Foods
Create POC using QlikView and Oracle as a Data source for Hilal Foods.
Jamjoom Pharma (Saudia arabia)
Create POC using QlikView and make dashboards of SAP MM, PP, FI, SD for jamjoom Pharma (Saudia Arabia) using Sap Database.
Training
During Mushko I have delivered QlikView Training in following Organizations to IT/Business User.
Hilal foods
Smollan
Ali Gohar Pharma(AGP)
TPL Holdings
Glaxo Smith Klien (GSK)
Core Responsibilities:
• Working on different project using visual studio and sql server also worked on telerik data access and Entity Frame work 4.0
As a PRODUCTION INCHARGE & ERP CO-ORDINATOR where my responsibilities is
* To generate daily production Report
* To generate daily wages Repots
* To generate daily Labour Cost Report
* To generate daily Maintainance Report
* To generate daily Profit/Loss RSeport
And manage all records of Production
also coordinate with senior software engineers for any bugs and error in ERP system and solve it
SKILLS & EXPERTIES EXPERTIES • BI tools like QlikView11, QlikView Sense, • QlikView Nprinting • SQL Server 2005,2008,2012 • ORACLE 10g,11g • SQL Query & Oracle Query writing. • Dashboard Designing with Microsoft SQL Report Server Builder • QlikView Trainer Training & Certifications • Attend training for Qlikview11. • MCTS Certification (OOP, C#, ASP.NET 3.5, SQL Server 2010, HTML.CSS). • Two Months Certification in HARDWARE & NETWORKING from Farooq-e-Azam Institute affiliated with Skill Development Council Karachi. • 6 Months Certification in Specialization in Graphics (Adobe Photoshop, Adobe Premiere, Adobe Illustrator and Adobe Freehand, Adobe After Effect) from 3D Coaching Centre affiliated with Skill Development Council Karachi. • Win Second prize in I.T fair. SKILLS • Proficient Business Analysis skills. • Attend training for Qlikview11. • Team Management • Project Management • Sound knowledge of RDBMS and stored procedures • Delivered training of QlikView11 in various organizations. Tools • MS Office, MS Visual Studio, Crystal Reports,MS Sql Server 2008,2010, Oracle 10g, QlikView 11.2,QlikSense, QlikView Nprinting .