Qlikview Senior Consulatnt/admin Resume
SUMMARY:
- Have 7+ years of overall IT experience and 6+ years of relevant experience as a Senior QlikView Developer/ Designer/ Administrator in various Business Intelligence projects.
- Involved in Requirement Analysis, Development, Testing and Implementation.
- Expertise in Creating Dashboards using Qlikview 11.0, 11.2 using different data sources like Oracle, SQL Server, QVD files, text files, excel and generated dashboard as per the user requirement.
- Have knowledge on ETL tools like Informatica and other BI tools like Tableau, Oracle etc.
- Have extensive knowledge on QlikSense.
- Expertise in Data Modeling techniques (Star Schema, Snow Flake Schema).
- Experience on MS SQL Server (BI) and SQL Programming.
- Experience in Agile and Waterfall project management methodologies.
- Leverage technical, business and financial acumen to communicate effectively with client executives and their respective teams.
- Loaded Data intoQlikViewapplication from different sources like QVD excel files, database, flat files and external files.
- Creation of QVDs and using incremental load from different sources.
- Writing scripts according to requirement.
- Strong knowledge on how to avoid synthetic keys and circular loops using appropriate Joins, Concatenation, Link Table, etc.
- Worked extensively on Variables, Set Analysis, Aggregate functions and several Script functions.
- Worked extensively in almost all charts and objects of QlikView.
- Worked on advanced features of Qlikview like Mapping load, Interval Match etc.
- Implemented security using Section Access and Publisher.
- Strong knowledge on Server, Publisher and QEMC.
- Helped Business Analysts to understand the advanced features and capabilities of QlikView Tool for the successful implementation of QlikView Prototype and PoC (Proof of Concept) projects.
- Trained all our Customers/End - Users on How-To Use the QlikView Tool like making selections and Clearing the selections and also explained them the QlikView Architecture.
- Developed Macros, set analysis to provide custom functionality in QlikView Applications
- Have performed ETL using Qlikview.
- Have installed QlikView Desktop, Server and Publisher.
TECHNICAL SKILLS:
BI Tools: QlikView 10.x, 11.x
Data Bases: Oracle, Teradata, SQL Server
Operating Systems: Windows XP/7
PROFESSIONAL EXPERIENCE:
Confidential
Qlikview Senior Consulatnt/Admin
Responsibilities:
- Analysis of the specifications provided by the clients and already existing reports
- Design and Development
- Scripting and data modeling
- Testing - unit testing & integration testing
- Worked with the team to identify the business reporting needs and studied current reporting practices outside of Qlikview through pivot tables
- Responsible for overseeing the Quality procedures related to the project.
- Manage daily QlikView jobs that update QVD files and Dashboards
- Used Excel functions like VLookup extensively to apply various rules to remove duplicate data
- Qlikview Dashboards with multiple sheets, bar charts, pivot table. Lists and creating custom selection box’s
- Trained users on developed applications on how to use the application.
Confidential
Senior Qlikview Developer / Admin
Responsibilities:
- Involved in Designing, Developing and Deploying QlikView Dashboards and received appreciations from the user.
- Manage daily QlikView jobs that update QVD files and Dashboards
- Creation of reports.
- Involved in analysis phase of designing the universe.
- Produced graphs and visuals using Excel charts and pivot tables to summarize data, identify outlying data points, and perform other exploratory data analysis.
- Extensive experience working onExcel, Pivot tables, VLookupand functions.
- Attended daily call with customer for management of dashboard.
- Testing - unit testing & integration testing
- Responsible for overseeing the Quality procedures related to the project.
Confidential
Qlikview Developer
Responsibilities:
- Analysis of the specifications provided by the clients
- Design and Development
- Scripting and data modeling
- Testing - unit testing
- Designed and developed different types of charts Bar charts, Straight Tables, Pivot Tables, Pie charts and Radar charts etc.
- Used Excel functions like VLookup extensively to apply various rules to remove duplicate data.
- Developed complex reports using features like slice and dice, Drill capabilities, Complex freehand SQL queries, Functions, Master Detail, and Cross Tab tables with multiple breaks.
- Involved in Performance Tuning of QlikView dashboards.
Confidential
Qlikview Developer
Responsibilities:
- Analysis of the specifications provided by the clients
- Design and Development
- Extensive experience working onExcel, Pivot tables, VLookupand functions.
- Testing - unit testing & integration testing
Confidential
Qlikview Developer
Responsibilities:
- Involved in Designing, Developing and Deploying QlikView Dashboards and received appreciations from the user.
- Manage daily QlikView jobs that update QVD files and Dashboards
- Attended daily call with customer and onsite for management of dashboard.
- Involved in QA and UAT
- Involved in Performance Tuning of QlikView dashboards.
- Trained users on developed applications on how to use the application.
Confidential
Qlikview Developer
Responsibilities:
- Scripting and data modeling
- Testing - unit testing & integration testing
- Responsible for overseeing the Quality procedures related to the project.
Confidential
Qlikview Developer
Responsibilities:
- Analysis of the specifications provided by the clients
- Design and Development
- Scripting and data modeling
- Testing - unit testing & integration testing