EXPERIENCE SUMMARY:

• Over 8+ years’ experience in Information Technology with proven ability to implement Qlik Business Intelligence solutions aligned with business objectives and innovative analytical reporting. Capable of managing projects while leading cross - functional teams and competent in all aspect of Qlik Development, Administration implementation, Deployment, Testing and Migration.
• Around 8+ Years of IT experience in Analysis, design, development administration and implementation of QlikView and Qlik Sense applications.
• Extensively worked on QlikView to implement applications as per client requirement
• Expertise QlikView/Qlik Sense performance optimization, QlikView Management console, QlikView Administration and QlikView Data Modeling.
• Strong experience in designing and developing dashboards using QlikView/Qlik Sense by extracting data from multiple sources (Oracle, Flat files, Excel, Access).
• Extensive experience with QlikView sheet objects, scripting, and optimizing applications and building QVD’s and QVW’s.
• Worked on different QlikView objects like straight tables, line charts, bar charts and pivot tables Etc.
• Involved in Optimization of QlikView Dashboards with a focus on Visualization, usability, Performance, Long-term, Flexibility, Accuracy and Standardization.
• Extensive Experience with QlikView sheet objects including multiple charts types, Trends, KPI’s, custom requests for Excel Export, Fast Change and other objects for Management Dashboard reporting.
• Extensive Experience in developing User Interfaces and QlikView Dashboards using several sheet objects Chart-Box (Drill Down and Cyclic Group), List Boxes, Input Fields, Table Boxes, Calendars and Date Islands.
• Strong Experience in working with various Charts (Pivot Tables, Straight Tables, Pie-Charts, Gauge-Charts, Line-chart, Combo-chart, Bar-chart, Scatter-chart).
• Good experience in using the functionality Join, Concatenate, Keep in the preparation of QlikView data model.
• Comfortable to use various sources like QVD files, MS Excel, Relational Tables, Binary QVW, Inline & txt files in developing the QlikView reports.
• Hands on experience in various loads - Binary Load, Inline Load, Partial Load, Incremental Load.
• Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, Automation and Macros interface, Section Access, Set Analysis in QlikView and DW concepts.
• Experience in Database design, Development, Data Modeling, Administration, ETL packages using DTS / SSIS, Performance Tuning, Stored Procedures for Database applications using MS SQL Server 2012, 2008 R2, 2008, 2005 .
• Experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer.
• Experienced in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using tools like SSIS import and export and SSIS packages.
• Job roles include gathering business requirements, establishing functional specifications, translating them to design specifications.

TECHNICAL SKILLS:

Dash Boarding / Analytics: QlikView 12.0/11.0/10.0/9.0 , QlikSense 2.0/3.0, Tableau, SQL BI, BO.

Operating Systems: Windows, UNIX, Linux 7.0, Sun Solaris

SQL, PL/SQL, T: SQL, UNIX Shell scripting, Python, VB Script

Database Technologies: Oracle9i/10g/11g, SQLServer, Teradata, MySQL, DB2.

ETL Tools: SSIS, SSRS, Informatica, Cogno s.

MS Access, MS: Excel, MS InfoPath, Visio

PROFESSIONAL EXPERIENCE:

Sr.QlikView / Qlik Sense Developer

Confidential, San Jose, CA

Responsibilities:

• Involved in full project life cycle implementation (requirement gathering to production) QlikView and Qlik Sense dashboards.
• Participated on business requirement document preparation.
• Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server, binary QVW, Inline & txt files in creating the QlikView and Qlik Sense dashboards.
• Connected to different ODBC, OLE DB data sources (SQL Server) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of Qlik Sense.
• Created multiple tab dashboards. Created Pivot tables, Trend graphs, Bar graphs, Stacked Graphs, containers and so on.
• Created SQL Stored Procedures and Views to fetch the data from database to build reports.
• Extensively worked with Qlik Sense functions, objects, Set Analysis, Variables to generate different kinds of charts. Also generated QVD files by writing scripts in Qlik Sense applications.
• Used a KPI/gauge object which has built in color switching to color code the fonts.
• Created Line Charts to show different trends of finance information over years using set expressions, year function, max() function etc.
• Built several Dashboards with current year statistics and trending information with ability to toggle between different metrics and drill down sheets and report detail charts for further analysis.
• Trained users to build their own apps in Qlik Sense.
• Worked on Qlik sense new objects Maps, KPI and object and document extensions for wire frames, and proof of concept applications.
• Implemented optimized loadings and performance tuning with the help of Qlik support.
• Security and mobile ability enabling and taken care of Qlik Sense QMC, repository and hub access.
• Used Set Analysis in the Line and Bar charts (Combo Charts) to show the user different trends of product sales over years.
• Worked on NPrinting Tool and created Pixel Perfect customized reports as per the client requirements using the rich NPrinting reporting features.
• Distributed QS reports using NPrinting in the form of Excel/PDF/Power Point/Word etc . to users.
• Worked with business analysts to train the end users to use the reports effectively to build and customize their ad-hoc reports.

Environment: Qlik Sense 3.1, Nprinting 17.2, Data Modeling, Oracle 12g, DB2, MS SQL Server 2016, Windows 2008 R2, Excel, MS Access, Flat files.

Sr.QlikView Developer

Confidential, San Diego, CA

Responsibilities:

• Collaborated with Business Intelligence team to learn current processes and practices.
• Responsible for the implementation, administration, Deployments and support of the QlikView systems suite of products - QlikView Developer, QlikView Server, Publisher and QlikView Enterprise Management Console.
• Define best practices for QlikView development, deployment and create reusable templates for supported applications
• Designed and implemented the Incremental Loading using QVDs.
• Implemented the 3-tier architecture, Data Extract, Data Model and QVD/QVF.
• Developed Dashboards included customer detail drilldowns, threshold gauges and Alerting mechanisms.
• Enhanced existing dashboards with new functionalities and established a secure environment using QlikView Section Access.
• Code review as well as fine tuning of applications as well as fixing data model.
• Implemented section access to enforce row-level data security .
• Designed and developed the Data mart for the QlikView dashboards in star schema/snow-flake schema . Identified various sources and designed the data transfer and transformations with in QlikView
• Developed dashboard's using different components of QlikView like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc .
• Involved in gathering data from sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Created daily, weekly, monthly and quarterly reports for the management team based on the Customer requirements.
• Coordinated with Offshore and Onsite teams to discuss on the requirement and get clarifications from business stakeholders.
• Provided Production support to the existing QlikView applications.

Environment: QlikView 11,12, Qlik sense 2.2, 3.0, Oracle 11g, DB2 9.7, SQL Server 2008, MS Office, Windows 2008 R2 Server, Toad, SharePoint, Agile methodology, Java Script.

QlikView Developer

Confidential

Responsibilities:

• Interacted with customers to gather business requirements and developed functional and technical specification document, Participated and proposed new business analysis for data which has no prior reports.
• Extracted data from the database, stored into QVD files, and wrote load scripts.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports
• Eliminated Synthetic keys, ambiguous relationships and closed loops and Designed proficient dashboards according to the requirements
• Developed QlikView applications based on Incrementally Load Transactions using QVD files.
• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Created dashboards using Macros to meet the reporting requirements, Tuning data loads and QlikView application for efficient performance and documented report requests in the form of Functional and Technical specifications.
• Established a secure environment using QlikView Section Access and Wrote QlikView macros, variables, user friendly functions, and built reusable master framework
• Collected and analyzed business requirements, developing engineering prototype and using POC to facilitate KPI Metrics dashboard design across different regions and business units.
• Participated in design and code reviews, QA/UAT testing, enhancement design and development, and deployment to support day-to-day business operations
• Involved in performance tuning of dashboards to limit the response time and enhance the functionality and Enhanced existing dashboards with new functionalities and tuned ETL scripts for better performance.
• Enhanced and translated existing dashboards in SSRS into QlikView and worked extensively with the set analysis.
• Successfully passed through the QA Environment and implemented on Production, Provided training and supported client in house business users.

Environment: Qlikview10.2, SQL server2008, .NET, Windows 7/2008.

SQL Developer

Confidential

Responsibilities:

• Worked in Requirement Analysis, Design, Development, Integration & Testing, Implementation and Operations & Maintenance phases of the project.
• Created Tables, Stored procedures and defined functions.
• Created SQL scripts for tuning and scheduling.
• Provided assistance for development teams on tuning data, indexes and queries
• Created indexes on the tables to remove unnecessary columns and to eliminate redundant and inconsistent data.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created parameterized, drill down reports, matrix reports and table formatted reports to changed old reports as per requirements using SSRS.
• Actively participated in developing efficient use of Joins and sub-queries in queries that involve data from multiple tables, also developed T-SQL queries involving joins, Stored Procedures and Views to implement security.
• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database object.

Environment: ASP.Net, MS SQL Server 2012, T-SQL, BIDS2008 R2 / Visual Studio 10.0, SSIS, SSRS.