QlikView Developer Resume

SUMMARY

Over 2 years of experience in IT Technology with strong background in Analysis, Design and Development in the field of Database, Data Warehouse & Data Modeling in QlikView tool.
Hands on retrieving of external data to QlikView Dashboard in terms of QVDs by making connection through ODBC and OLEDB.
Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
Developed QlikView Dashboards using Chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box and Calendar & Date Island.
Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.
Created various sheets objects like Bar chart, Line graph, Straight table, pivot table, combo chart, created complex expressions in charts.
Created QVD’s & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
Design and development of dashboards withinQlikView using the objects available in QlikView, customizing the dashboards as per the user requirements.
Assist users in navigating within the dashboards, pivot tables, details result and the exports Into Excel.
Proficient in SET ANALYSIS to provide customized functionality in QlikViewApplications.

TECHNICAL SKILLS

Dash boarding/Analytics: QlikView Desktop 11,12

Languages: SQL, C

Database technologies: SQL Server, MySQL, MS Access 2010, Oracle

Platforms: Windows Server 2008, Windows 2003, Windows XP

Operating Systems: Windows

PROFESSIONAL EXPERIENCE

Confidential

QlikView Developer

Responsibilities:

Interacting with client including Directors, Channel managers to gather and understand the requirements and consolidate existing reports.
Gathered and documented business requirements to design and develop applications
Extracted data from Oracle database and loaded into QlikView
Used SET Analysis to perform time series analysis and get the required information
Worked with SET Analysis to include or exclude selections and Dimensions
Used Store function to store QlikView Data into CSV files to create other reports
Imported data from sources like QVD files, Excel, Oracle & Inline & txt files in developing the QlikView Data Models
Developed load scripts to work with multiple data sources (SQL, Excel, and Share point site)
Utilized QlikView Management Console (QMC) to reload and distribute tasks for QlikView documents.
Showed the statistics in bar charts and pie charts as per the client needs.
Maintained user guides and documentation for QlikView applications.
Created List boxes, Statistic boxes to show the statistics of the sales held on different products in different years.
Communicated with the Users to evaluate satisfaction and Identify issues
Developed ETL Scripts while loading the data, resolving loops and ambiguity joins
Implemented security in QlikView Applications

Environment: QlikView 11/10Desktop, SQL Server, Excel, MS Visio, Oracle, Windows XP

Confidential

QlikView Developer

Responsibilities:

Extracted/Transformed/Loaded data into QlikView from multiple data sources.
Worked on different types of functions in QlikView.
Optimized various applications by using QVD’s and QVWs.
Involved in analysis, design and development of the system.
Involved in Data Modeling & Loading data from multiple data sources (SQL server, Flat Files, Excel and Access) using OLEDB/ODBC connections.
Well Versed with advance functions like SET analysis, Apply - Maps, What-if Analysis.
Created database Objects Tables, Indexes, Views, Synonym.
Used SQL Developer to Load / Extract data into and from Excel files.
Used Hints, Explain Plan, and Indexes for query tuning and optimizations.
Created stored Procedures, Functions, and Triggers by generating the specified reports.
Modifying the database design and structure, as necessary, from time to time upon information given by application users and developers.
Implemented integrity Constraints on database tables.
Involved in preparing documentation, Testing and debugging.

Environment: QlikView, SQL Server 2005, Windows Server 2003, Windows XP, MS Access, XML.