SUMMARY

• More than 8 Years of real time IT experience in analysis, design, development and implementation of Database/BI Applications.
• Worked on QlikView versions 9.x,10.x,11.x,12.1 and QlikSense versions 1.x,2.x,3.x, 3.1.X and 3.2
• Expertise in Installation, Configuration, Clustering, Load Balancing and Multi Node installation of QlikView and QlikSense Environment.
• Expertise in things like QlikView performance optimization, QlikView Management console, QlikView Administration and QlikView Data Modelling.
• Extensively worked on QlikView and QlikSense upgrades.
• Experience in Qlik Data Connectors & Qlik Web Connectors.
• Expertise in QlikView and QlikSense Extensions.
• Extensively worked on Data Analysis/ Mining using QlikView.
• Experience on set analysis, advanced aggregation and section access.
• Expertise in Qlik APIs, building the custom solutions, QlikView and QlikSense Extensions.
• Expertise in the QlikSense SDLC and Governance.
• Experience in error handling and debugging of QlikView reports.
• Strong experience in designing and developing dashboards using QlikView by extracting data from multiple sources (Oracle, Flat files, Excel, Access).
• Extensive experience wif QlikView sheet objects, scripting, and optimizing applications and building QVD’s and QVW’s.
• Expertise in the QlikSense Apps, Stories, KPI, N - Printing and Story Generation
• Expert in handling production issues like report failures, missing counts in reports, resolving synthetic keys, Loops.
• Worked on different QlikView objects like straight tables, line charts, bar charts and pivot tables Etc.
• Strong experience in data analysis, reporting, warehousing and modelling.
• Expertise on set analysis, advanced aggregation and section access.
• Implementing Mashups and geoanalytics in QlikSense.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Ability to work wif team and independently. Able to manage multiple projects.
• Experience wif implementing QVD architecture (3 tier).
• Involved in Optimization of QlikView Dashboards wif a focus on Visualization, usability, Performance, Long-term, Flexibility, Accuracy and Standardization.

TECHNICAL SKILLS

Tools & Technologies: QlikSense2.2, 3.0, 3.1.3, QlikView 11.0,12, N-printing, SQL BI.

Languages: SQL, T-SQL, PL/SQL, C, C++

Database: SQL Server, Oracle 11g, Big Data, Teradata, DB2, SAP BW.

ETL Tools: SSIS, SSRS, Informatica.

User Interface: HTML, CSS, Java Script, XML.

Operating systems: Windows NT, XP/ Windows 2003, 2007, 2008.

Others: MS Access, MS-Excel, MS InfoPath, Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

QlikView/QlikSense- Admin/Developer

Responsibilities:

• Involved in Upgradation, Installation, Configuring, Clustering, Load balancing and Multi-node installation of QlikView and QlikSense Environment.
• Connected to different ODBC, OLEDB data sources and Flat files as per requirements by using components of QlikView.
• Designing Data Modelling and Loading data for Multiple Data sources.
• Installed QlikSense Desktop 3.x,3.1x and 3.2 and developed applications for users.
• Configured different QlikSense roles and attributes based access control.
• Developed Proof of Concepts (POC) for various projects using QlikSense and QlikView.
• Implementing Mashups and geoanalytics in QlikSense.
• Good knowledge of deploying QlikSense dashboards on the QlikSense server.
• Designed and Developed QlikView reports, Dashboards using Chart box (Drill down, drill up & Cyclic Grouping), List, Input Field, Table box, Calendar & Date Island meeting the business requirements.
• Involved in performing tuning of various QlikView and QlikSense applications.
• Upgrading QlikSense server by following feature release paths to inherit the latest features dat are available for consumption.
• Good knowledge in creating Data Connections and Folder Connections wifin the QlikSense.
• Developed dashboard for manual testing as complexity index which is integrated wif QlikSense Governance Dashboard.
• Leveraged existing QlikView DataMart’s to migrate Qlik Dashboards onto QlikSense environment.
• Involved in extracting, transforming and loading data from source into QlikView and QlikSense applications.
• Implemented Application Level Section Access and configured security rules on QlikSense streams to control user actions over QlikSense hub.
• Expertise in QlikSense SAML implementation and Security Rules.
• Good knowledge on trouble shooting QlikSense server related issues like sync issues, App Duplications etc.
• Managed the QlikView server and QlikSense tasks developing tasks, assigning license, creating user groups etc.
• Used Section Access in both QlikView and QlikSense applications to do data limitation based on the user group, domain.
• JMETER setup and Scalability Tests for QlikView and QlikSense dashboards.
• Implemented QlikView and QlikSense Set analysis, Data Modelling.
• Hands on experience in setting up QlikSense for external users/providers.
• Developed dashboards in QlikSense and QlikView for business users (KPI, Scatter plot, bar chat, pivot table & maps).
• Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team.
• Published dashboards on Access point. Deployed QVW’s on the production server, Created reload and Distribution tasks on QlikView server/publisher.
• Debugging the QlikView server issues through server logs, Fiddler logs.
• Involved in Onsite and Offshore coordination to ensure the completeness of Deliverables.
• Prepared monthly status reports for Enhancement requests to the project team dat was used in efficient tracking and monitoring of open issues of the project.
• Expert in handling production issues like report failures, missing counts in reports, resolving synthetic keys, Loops.

Environment: QlikSense 3.x,3.1x and 3.2, QlikView 12.1, Qlik Web Connectors, MS Access, MySQL 5.3, Qlik SAP Connector, MS SQL Server.

Confidential, Hoboken, NJ

Sr. QlikView/QlikSense Developer

Responsibilities:

• Designed different set of reports and interacting wif client for requirement analysis and delivery project of QlikView application.
• Designed and developed dashboards wif various levels of complexity including different kinds of charts and extensions.
• Extracted the data from various data sources such as databases, CSV files and Excel documents transforming the data into standard format(QVD’s) and load the data so dat it is available for analyzing and creating reports.
• Expertise in Load Script and Data Modelling.
• Installed QlikSense Desktop 1.1/2.1 and developed applications for the users.
• Developed Proof of Concepts(POC) using QlikView and QlikSense.
• Used different components of QlikView like List boxes, Slider, Current selection box, buttons, charts, text objects, bookmarks etc., to develop dashboards.
• Designed Schema using Dimensions, Fact, Logical, Physical, Alias and extension tables.
• Eliminated Synthetic Keys using Concatenation, Renaming, Qualify, Unqualify methods.
• Converted huge tables into multiple QVD’s, so dat only recent ones needed to be refreshed for data accuracy.
• Used SQL Developer for developing and managing PL/SQL scripts.
• Designed user interface and prepared layouts for the system using QlikView.
• Expertise in developing Star schema and Snowflake schema dimensional data model.
• Written complex expressions using Set analysis and various QlikView functions.
• Designed and Created distributed reports in multiple formats such as Excel, PDF, XML, HTML, .doc and CSV using SQL Server Reporting Services(SSRS).
• Performed many functions in both Front end and Back end.
• Connected to different ODBC, OLEDB data sources (SQL Server, Oracle and SAP BW) and Flat files as per requirements by using components of QlikView.
• Implemented incremental load by creating QVD’s and Optimized the periodic data additions.
• Worked wif QlikView/QlikSense to optimize QlikView performance.
• Implemented Application Level Section Access and configured security rules on QlikSense streams to control user actions over QlikSense hub.
• Debugging the QlikView server issues through server logs, Fiddler logs.
• Developed KPI’s and Set analysis applications. Experience in using QlikView Functions (Date and Time, Keep, Join, Mapping, String and Input Fields etc.)

Environment: QlikView 11x/10(Desktop, Server/Publisher, Access Point), Nprinting for QlikView (14.03.), QlikSense 1.1/2.1,2.2, SQL Server/2008/12, AS400 (I series), Windows XP/8.

Confidential, Manhattan, NY

Sr. QlikView Developer

Responsibilities:

• Involved in the requirements gathering, analyzing and documentation business requirements and specifications.
• Understanding source systems and Designing Data Modelling and Loading data for Multiple Data sources.
• Connected using OLE DB and ODBC data sources connector and tables.
• Created POC to the client based on their requirements.
• Developed SQL Scripts, Database objects, procedures, functions and packages.
• Designed and developed extensive QlikView reports using combination of charts and tables.
• Developing Set Analysis to provide the custom functionality in QlikView Applications.
• Installed, Configured and deployed the application on QlikView server and imported data from different sources like Oracle, SQL Server, MS Access, XML files and Flat files using OLE DB/ODBC.
• Worked on data modelling and developed different complex models as per given user requirement wifout any closed loops, Synthetic tables and ambiguous relationship.
• Mainly designed and developed QlikView software application and complex server-based QlikView dashboards from scratch to support reporting and Business Intelligence initiatives.
• Created link tables on the needed basis and as per the data.
• Created Master Calendar and worked wif date fields as per the user requirement.
• Applied mapping function to look up and fetch the required field.
• Creating complex expressions for dynamic aggregation and Actions and Triggers, Document Chaining & linking experience
• Designed a comprehensive and easy to use Mortgage analysis dashboard for client to keep track of sales representative performance, and efficiency of converting customer leads into revenue and optimization of data model for performance.
• Implemented security using QlikView section access technology dat dynamically hides selected areas of the dashboard depending upon user privileges.
• Developed link tables and Incremental loading on the needed basis.
• Published dashboards on Access point. Deployed QVW’s on the production server, Created reload and Distribution tasks on QlikView server/publisher.
• Extensively implemented section access for row, object, column and sheet level security.
• Automated QlikView jobs in QlikView publisher and rolled out to QlikView Access Point and administered Security using Active Directory.
• Written SQL Scripts to load relevant data in QlikView Applications.
• Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team.

Environment: QlikView 10/11, Oracle, SQL Server, Informatica power centre Toad/PLSQL Developer, SQL Loader and Sun Solaris.

Confidential, Atlanta, GA

QlikView Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical and functional specifications.
• Customized QlikView dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting QlikView applications
• Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Identified the requirements, business reporting needs, layout and developed the architecture of prioritized reports.
• Followed DAR (Dashboard, Analysis, Reports) methodology to meet the varying requirements of client.
• Involved in Onsite and Offshore coordination to ensure the completeness of Deliverables.
• Designed and Developed QlikView reports, Dashboards using Chart box (Drill down, drill up & Cyclic Grouping), List, Input Field, Table box, Calendar & Date Island meeting the business requirements.
• Implemented security using QlikView section access dat dynamically hides selected areas of dashboard depending upon user privileges.
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Provided end user and production support after deploying the application into the production environment, also provided extensive support for the users on application usage and trained users in the functionality of the software.
• Worked on data modelling and developed different complex models as per given user requirement wifout any closed loops, Synthetic tables and ambiguous relationships.
• Prepared monthly status reports for Enhancement requests to the project team dat was used in efficient tracking and monitoring of open issues of the project.
• Implemented report development methodology for operational analytics group.
• Provided business intelligence guidance to business operation analyst groups.
• Actively participated in clarification meeting wif the clients
• Maintained 3- tier design in method of developing the ultimate application.
• Identify, propose and implement enhancements over the existing reports to improve user experience.
• Configured QlikView Server/Publisher. Scheduled jobs & Security.
• QlikView best practices were used in implementation of scripting, Set analysis and usage of Variables.
• Utilized Incremental Load concept for the update of QVD’s
• Deployed, Maintain the QV Applications/Dashboards to the Development, Test, UAT and into Production environment

Environment: QlikView 11.2, Oracle 11g, QlikView Server and Publisher, MS Excel, TOAD, Nprinting, QlikView Enterprise Management Console.

Confidential, Atlanta, GA

QlikView Developer

Responsibilities:

• Involved in requirement gathering and analyzing business requirements.
• Involved in Extracting, Transforming and Loading data from different data source.
• Worked extensively on extracting data from various data sources like QVD files, Oracle, Excel, CSV File etc.
• Implemented Star Schema data modelling, Removed complex synthetic keys in the existing data models of various dashboards.
• Worked extensively on the oracle database and imported SQL scripts into QlikView.
• Implemented Security using section access dat dynamically hides selected areas of the dashboard depending upon user privileges.
• Developed QlikView Dashboards using Charts, List boxes, Multi box, Input Field, Table box, Statistics box etc.
• Developed KPI’s and set analysis applications. Experience in using QlikView Functions (Date and Time, Keep, Join, Mapping)
• Created optimized QVD’s which loads faster and helps to improve the performance.
• Designed and implemented the Incremental Load using QVD’s.
• Dealt wif various production issues in an efficient manner.
• Developed Linked Tables, Concatenation and solved the loops issues.
• Worked on various QlikView functions like Joins, Mapping etc.
• Implemented security using QlikView section access technology dat dynamically hides selected areas of the dashboard depending upon user privileges.

Environment: QlikView 11.2, Oracle 11g, .CSV Files, Access, Toad, SQL Server, Putty, Windows XP/2008.

Confidential

SQL BI Developer

Responsibilities:

• Responsible for Installation, Configuration and Maintenance of MS SQL Server on various environments.
• Involved in Database design and Data modelling on various databases.
• Understanding Customer requirement via interaction and writing functional specification.
• Created new database objects like Tables, Procedures, Functions, Triggers and Views using T-SQL.
• Wrote complex stored procedures and cursors to implement various business logic as per the client requirements. Created various stored procedures for ETL as well as maintenance of the database.
• Responsible for the creation of SQL procedures, triggers, temp tables and views for the development of reports.
• Involved in designing and creating Web UI screens using ASP.Net
• Responsible for Design and Normalization of the database tables.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Optimizing existing queries and fixing query performance issues.
• Prepared Data Flow Diagrams, Entity Relationship Diagrams and Table Structure.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.
• Worked on crystal reports wif many complex stored procedures. Created multi-format reports using crystal reports.

Environment: MS SQL Server 2000, DTS, HTML, MS Excel, Ms Access, Crystal Reports, T-SQL, .NET Framework, Visual Basic 5.0, and ASP/VB.NET.