Sr. Qlikview Programmer Analyst Resume
SUMMARY
- Over 3 years of experience providing expertise in design, development and support with Qlikview application.
- Developed User Interactive Sheets & Reports as business needs.
- Knowledge on how to import data from different sources like SQL Server, Oracle, QVDs, and flat files using OLE DB/ODBC connection through Qlikview.
- Experience with Qlikview sheet objects including multiple charts types, Trends, KPI's, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI's.
- Good Understanding of Relational and Dimensional Database Concepts.
- Optimizing existing Qlikview dashboards with a focus on usability, performance, long - term, flexibility and standardization. Extensive knowledge and experience in developing scripts using testing SQL queries and debugging.
- Involved in Requirement Gathering, Business Analysis, functional and Technical Documentation by interacting with Business users and Stakeholders.
- Experience in creating and using of variables, fields, and calculated expressions, aggregated functions, joins, concatenation and mappings using Qlikview.
- Extensively used various Qlikview Scripting and UI functions such as aggregations, sum, rank, range sum, firstsortedvalue, apply map, match, concatenate, no concatenate, numeric and date functions, etc.
- Experience in designing Qlikview Document/User Setting Layouts to make consistent and professional optimized look to clients .
- Team oriented individual with a results driven attitude, strong interpersonal and communication skills in effective information exchange and interaction with clients at all levels of management.
TECHNICAL SKILLS
Languages: SQL, C, C++
Databases: MSSQL Server, MS Access, Oracle, PostgresSQL
BI Tools: Qlikview 11x/10/9x (Desktop Server Publisher, Access Point), QlikSense, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis services (SSAS), Power BI, QlikSense and Visual Studio.
Design: SolidWorks, AutoCAD, CAM, Pro-E, Computer Aided Machine Drawing, GD&T
Computer Skills: MS Word, MS Excel, PowerPoint, Minitab, MS Project
PROFESSIONAL EXPERIENCE
Confidential
Sr. Qlikview Programmer Analyst
Responsibilities:
- Working with the Mopar branch of Confidential .
- Involved in building two dashboards namely Quality and Operations for various teams in Mopar to help them analyze the information related to quality, finance, errors and damages pertaining to motor parts.
- Analyzed the reporting requirements with the business users and came up with the technical specifications.
- Actively participated in full life cycle of Qlikview application implementation and was responsible for Design, Development and Delivery.
- Implemented the 3-tier architecture, Data Extract, Data Transform and Data model & Application.
- Implemented the Incremental Load using QVDs to maximize the efficiency of the load.
- Extensively done business user support, resolved various issues for accessing dashboard and enhanced the dashboard as per user needs.
- Created a Master Calendar table to standardize throughout the dashboard.
- Implemented best practices for Qlikview Dashboard and QVD development, sizing and configuration
- Deployed the Qlikview applications in the server. Created Publisher Tasks in QMC for the Qlikview Application to Reload and Distribute the Qlikview Application on to the Access Point.
- Scheduled the Publisher Tasks Daily/ Weekly/ Monthly on various dashboards based on the database updates.
- Ability to multitask, self-motivating and accomplish tasks in time.
- Creative, quick learner and a team player
- Strong oral and communication skills.
Environment: Qlikview 11.2, Windows 7, Qlikview Management Console, Postgres, MS Access
Confidential
Qlikview Developer
Responsibilities:
- Developed dashboards for clients to see all the information related to the trends of the make and model of the car, finances of the customers.
- Involved in Extracting, Transforming, and Loading data from different data sources like SQL Server, Flat Files, Excel Files.
- Followed step by step procedure of extracting, transforming and loading the data into the application.
- Designed and implemented the Incremental Load using QVDs wherever necessary to reduce load times and improve the speed.
- Experience in using ETL Tasks such as data cleaning, joins, keeps, concatenate, aggregation tables, Mappings using Qlikview.
- Implemented scheduling the tasks with the help of Qlikview Management Console.
- Involved in daily standup with business analysts and data architect to resolve the business issues and Data challenges.
Environment: Qlikview 11.2, Windows 7, Qlikview Management Console, Postgres, MS Access
Confidential
Qlikview Developer
Responsibilities:
- Worked on the performance tuning of the applications to improve the performance and also optimize the data models.
- Worked mostly on the front end development of the application showing the sales and trends for the company.
- Used various graphs and tables to display the KPI’s.
- Made use of the best practices for a high performance data model by eliminating synthetic keys, circular loops and creating composite keys.
- Used different data sources such as excel files, text files, etc.
Environment: Qlikview 10/11, MS Office, Windows 2008 R2 Server
Confidential
BI Developer
Responsibilities:
- Extracted data from different systems transformed and integrated in the Qlikview.
- Designed the Data-Model using data from various sources like Oracle 10g Database and flat files.
- Data Modelling using Dimensional Modelling, Star Schema, Snowflake schema.
- Extensively used set analysis to calculate/aggregate the fact data as per the requirements.
- Developed Qlikview Dashboards using Charts (Straight table, pivot table, Line, combo Chart etc.), List Boxes, Multi Box, Input Field, Table Box, Statistics Box etc.
- Resolved synthetic keys using various techniques such as aliasing, join, concatenation, dropping fields, etc.
- Scheduled the Publisher Tasks Daily/ Weekly/ Monthly on various Dashboards based on the Database updates.
Environment: SQL, SQL*Loader, ETL.