SUMMARY

• Around 9 Years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing/Decision support systems.
• 5+ years of most recent experience in QlikView/QlikSense Desktop, QlikView Server & QlikView Publisher in aspects of development, deployment and administration.
• 1+ year in QlikSense, gave demo's to the developers on how QlikSense is more user friendly in terms of visualization and no limitations in sharing applications between different installations.
• Experience in QGis, Qlik Maps, Geo Qlik mapping extensions and also different types of extension objects in Qlik Sense
• Handled different types of polygon files including, SHP, KML and converting those using Vector layer for Qlik Sense.
• Also have knowledge on SME. Responsible for defining business requirements and recommending a technical approach to meet the needs of end users.
• As an SME I used to oversee the development, testing and implementation of technical solutions and validation of final requirements.
• Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance using Qlikview/Qliksense. Good at working with Data Warehousing and business intelligence tools for developing various reports using Qlikview BI.
• Experienced in data - modeling. Data-marts and data-warehouses.
• Using Agile Methodology
• Extensive experience in QlikView/QlikSense Scripting using with best practices, used to create complex data cleansing, transforming functions for achieving an effective data model.
• Experience in scheduling jobs in QlikView Enterprise Management Console (QlikView Publisher)and managing user accounts in QlikView Management Console.
• Explored intensively and implemented QlikView 11 advanced features like Set Analysis, Alternate states, integrating Google Maps, Dimension Limits and creating Ad-Hoc Reports for end user easy analysis
• Experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating database objects like tables, constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Business Analysis experience with excellent communication & interpersonal skills and broad understanding of business operations and requirements
• Experience in developing User Interfaces and QlikView Dashboards using Chart-Box (Drill Down, Drill up, & Cyclic Grouping), List Boxes, Input Fields, Table Boxes, KPI’s, Bookmarks, Calendars, and Date Islands.
• Good Exposure to working with QlikView/QlikSense Functions and Expression Scripts and Streamlining Reporting operations of QlikView Applications
• Strong understanding of Dimensional Modeling technique, Multi-dimensional database Schemas like Star Schema, Snow flake Schema, Fact and Dimensional tables
• Strong Experience in working with Charts(Table Box, Pivot Tables, Straight Tables, Pie-Charts, Gauge-Charts, Trellis)
• Created QVD’s& updated on timely basis as database updates.
• Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Experience in development of ETL scripts for Data Modeling along with resolving Synthetic Key and Circular Loop issues.
• Good understandings in Financial statements, Derivatives and Structured Fixed Income
• Developed QVdatamodels,QVobjects,reports,graphicalinteractiveUIusingvarious datasourceslikeOracle,SQLServer,Access, Big Data,textfiles, Excel documentsetc.
• Used advanced scripting, set analysis, VBScript and JavaScript macros, advanced aggregation functions and advanced charts for applications.
• Implemented Section Access, Binary Loads and abstracting the data layer using QlikView library and QVX files Implementation of security in QlikView Applications at Document and Server Level.
• Proficient on NPrinting and Omniture.
• Worked on NPrinting Server to deliver reports to the clients via e-mail by saving it into specific directories or also by publishing them on websites.
• 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:

QlikView: QlikView Development (Version 10/11), QlikSense desktop, QlikView Server (Version 10/11)/Publisher.

Databases / DB Tools: SQL Server 2000/2005, DB2 8.0/7.0, Oracle 8i/9i/10g/11g,DB2, Teradata, Big Data, SAP, MS Access 2003, MS Excel, JDE, Hadoop, Amazon AWS/RedShift

Languages: QlikView/QlikSense Scripting, SQL, HTML, C, C++, JAVA.

Front end tools: Microsoft Project, MS Visio, HP Quality Center

Web Analytic tools: Omniture, NPrinting MS Outlook, MS Word, Ms Excel, MS Access, MS PowerPoint MS Office Tools

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

Sr Qlik View/Qlik Sense Developer/Admin

Responsibilities:

• Provided complex KPI’s (Penetration) using set analysis.
• Requirements gathering, Impact Analysis and solution designing to incorporate the Business requests.
• Understanding the business functionality & Analysis of business requirements.
• Creating mock up with the sample data.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Assist with schema design and development of ETL processes.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized QlikMarts
• Implemented Data Modeling by using Star Schema.
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports
• Used QlikView Scripting and Complex SQL coding for loading, and transforming
• Designed and developed QlikView dashboards using different Charts (Drill Down, Cyclic Field grouping), Sheet Objects (List Box, Input Field, Table Box, Calendar & Date etc.) and extensions
• Used QlikView Functions (Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous etc.) and Created Variables using LET, SET or control statements in the scripts
• Developed Set Analysis providing custom functionality in QlikView Applications
• Designed and developed the incremental loading where applicable
• Created QVDs, QVW files and scheduled the tasks in Publisher to reload them
• Developed required user interactive Sheets/Reports & categorized as per business need
• Implemented Data Level Security, Object Level Security & Document Data Level Security
• Created model with Extract, Transformation and Data Model in QlikView.
• Enhancements to existing reports/analytics.
• Executing the Test scripts and maintaining the Log files.
• Deploying the code from Development environment to test environment and provide developer support for UAT teams till the code moves to production.
• Identifying feasible areas of project for improvement.
• Updating the test cases as per the review comments.
• Preparing required documents related to the project
• Resolving the client issues spontaneously without any delays.

Confidential, Princeton, NJ

Sr. Qlik Sense/QlikView Developer/Admin

Responsibilities:

• Interacted with business representatives and business analysts for requirements analysis and to define business and functional specifications.
• Analyzed the Reporting Requirements and participated in the documentation of Business Requirements.
• Developed Oracle BI Metadata repository using BI Administration tool.
• Developed interactive Dashboards and Reports in Oracle BI Answers as per the reporting specifications.
• Scheduling and managing Qlik Sense jobs using Qlik Sense Scheduler for Qlik Sense application dashboards.
• Daily scrum call with off shore colleagues on project status and reviewing daily task.
• Using of QGis to use latitude, longitude, shape files, KML files to load it into Qlik Maps to render different data sets based on user requirements.
• Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
• Extraction of data through different sources like SQL Server, Amazon AWS Redshift, MS Excel, CSV files.
• Publishing of scheduled reports using Nprinting.
• Giving roles based access to user upon the client requirement.
• Developed measure for time comparison using time functions.
• Optimizing the backend script by converting files to QVD and by using Variables.
• Publishing the app to DEV and assigning reload time and then pushing the file to UAT and Production in QMC environment.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Performed the Performance Tuning of Dashboards and Reports and made required changes to repository and database in consultation with DBA.
• Implemented security based on Section Access.
• Configured Measures in the Business Model Layer and mapped to multiple logical table sources..
• Created report prototypes and presented them to users to get approval.
• Attended weekly scrum meetings with BA and Stakeholders for project status updates.
• Performed unit and integration testing of reports and dashboards.
• Created Requirements Traceability Matrix and Mapping Document to trace requirements in BI implementation.
• Conducted Functional Requirements review and walk through with BI Architect, Designers, and Stakeholders.
• Analyzed the data and developed Logical Star Schema model with consultation from Data Modelers and Business Analysts using Agile Methodology.
• Developing the dashboard based on different KPI's Charts, Tables, list/filter boxes etc based on user stories which are shared on Amazon S3 bucket.

Confidential, Columbus, OH

Sr. QlikView Developer/Admin

Responsibilities:

• Data extraction from different sources
• Data validation depending on the data model provided
• Providing training to new employees at work, collaborating with the team and having daily scrum meetings on project status
• Creating of dashboard based on the wireframes/visualization as per end users requirement
• Using of 3 Tier Architecture method to optimize the final QVW file, use of Agile methodology
• Weekly review/meeting with end users about project updates and going through the user stories (end user requirement) on SharePoint.
• Creating QVD, QVT, Inline statements to further optimize the script for faster reload.
• Use of binary load, resident load, preceding load etc depending on the requirement.
• Working on various kinds of charts like Bar, Pie, Straight, Pivot & KPI's
• The dashboard is being created using various expressions. And variables are being used to again optimize the data
• Deployment of QVW file on the server and adding security to the file in the access point.
• Involved in performance tuning to optimize the functionality of dashboards.
• Installation and configuration of QlikView Server and Publisher
• Testing, reloading of QVW in QMC. Providing the user access as per requirements.
• Using Inline load to give access to users to view QVW file on Access Point.
• Providing Incremental load after the qvw files is deployed onto the server and adding the timely automatic refresh data setting into the QMC.
• Defining best practices for QlikView development, deployment and create reusable templates
• Participation in overall architecture and strategy for the development of QlikView suite of products.
• Manage security for all QlikView applications and documentation for supported applications
• Assisting my team of developers with troubleshooting and offer development and deployment improvements
• Environment monitoring, pro-active monitoring to ensure performance on the server is optimized for the end users.
• As an admin I managed the security of the application using different methods which also includes section access.
• Implementation of Data Level Security, Object Level Security & Document Data Level Security.
• Used NPrinting to send reports to the clients by setting cycles and filters.

Environment: QlikView 11.20 64 Bit, SharePoint, MS Excel, Oracle 11g, SAP connectors, Big Querry Conectors, Hadoop.

Confidential, Charlotte, NC

Sr. QlikView Developer/Admin/Business Analyst

Responsibilities:

• Analyzed requirements and gathered data for designingQlikViewapplications.
• Working knowledge with QlikView Server Administration
• Experience with QlikView Management Console (QMC)
• Followed DAR (Dashboard, Analysis, Reports) methodology to meet the varying requirements of Client.
• Implemented report development methodology for operational analytics group.
• Provided business intelligence guidance to business operation analyst groups.
• Conduct demonstration for business users and interacted with end users.
• Actively participated in clarification meeting with the Clients.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.
• 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.
• Involved in gathering data from sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing theQlikViewData Models.
• Proposed and created new business analysis for data, which has no prior reports.
• Experience in creation of QVD's for theQlikViewapplications following two-tier architecture.
• Wrote, Edited and Debugged ETL Scripts for data cleansing, resolving synthetic keys & circular loops.
• Monitoring of the QVS, QVW's and user accounts for the usage of the applications.
• Created User-friendly Interactive Sheets & Reports as per the business needs and requirements.
• Created KPI's and set analysis applications, according to user needs.
• Designed and developed different types of charts Bar charts, Straight Tables, Pivot Tables, Pie charts and Radar charts etc.
• Used different functions such as counter, date and time, conditional, aggregation functions etc., for data transformation.
• Performance tuning by analyzing and comparing the turnaround times between SQL andQlikView.
• Used NPrinting/NPrinting Server to send reports to the clients by setting cycles and filters.
• Allowed user to request on demand reports on web based environment like Ajax, IE Plugin, Workbench.
• Sound knowledge of various functions ofQlikViewtechnology.
• Installed IE plugins and trained the end users to use the reports effectively, to build and customize their ad-hoc reports.
• Assisted the end users if there were any problems very effectively and efficiently.

Environment: QlikView 11/11.2, Oracle 10g,SQL Server 2005, MS Access, MS Excel, .CSV Files, Oracle Loader for Hadoop.

Confidential ., Miami, FL

QlikView Developer/Admin/Business Analyst

Responsibilities:

• Provided complex KPI’s (Penetration) using set analysis.
• Requirements gathering, Impact Analysis and solution designing to incorporate the Business requests.
• Understanding the business functionality & Analysis of business requirements.
• Creating mock up with the sample data.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Assist with schema design and development of ETL processes.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized QlikMarts
• Implemented Data Modeling by using Star Schema and Snowflake Schema
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports
• Used QlikView Scripting and Complex SQL coding for loading, and transforming
• Designed and developed QlikView dashboards using different Charts (Drill Down, Cyclic Field grouping), Sheet Objects (List Box, Input Field, Table Box, Calendar & Date etc.) and extensions
• Used QlikView Functions (Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous etc.) and Created Variables using LET, SET or control statements in the scripts
• Developed Set Analysis providing custom functionality in QlikView Applications
• Designed and developed the incremental loading where applicable
• Created QVDs, QVW files and scheduled the tasks in Publisher to reload them
• Developed required user interactive Sheets/Reports & categorized as per business need
• Implemented Data Level Security, Object Level Security & Document Data Level Security
• Created model with Extract, Transformation and Data Model in QlikView.
• Enhancements to existing reports/analytics.
• Executing the Test scripts and maintaining the Log files.
• Deploying the code from Development environment to test environment and provide developer support for UAT teams till the code moves to production.
• Identifying feasible areas of project for improvement.
• Updating the test cases as per the review comments.
• Preparing required documents related to the project
• Resolving the client issues spontaneously without any delays.

Environment: and Development Tools:QlikView 11.2/11/10.0 , Oracle 10g,DB2, MS SQL Server 2008, Toad, Windows 2008 R2,Excel,MS Access, Flat files.

Confidential, Madison, WI

QlikView Developer

Responsibilities:

• Been part of several meetings with users to identify problems, reporting requirements and problems in existing systems design.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables, using Agile Methodology.
• Identified various KPI’s with businesses users and analyzing existing Business Objects Reports.
• Extensively worked on QlikView Set Analysis.
• Collaborated with Business Intelligence team to learn current processes and practices.
• Created batch scripts to process the data periodically as per the business requirements.
• Applied metrics in the data via QlikView scripts and transformed QVDs to cater the business needs.
• Generated new QVD files from the EDW by writing scripts in QlikView applications. Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys.
• Scheduled and managed QlikView jobs using QlikView Scheduler for QlikView application dashboards.
• Created batch scripts to process the data periodically as per the business requirements.
• Designed and Developed QlikView dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, and Calendar & Date Island meeting the business requirements.
• Published Client application using QlikView Publisher and rolled out to Access point and administered security using Active Directory technology/Access DB integration.
• Monitor computer systems to minimize unscheduled downtimes and ensured availability of resources.
• Involved in performance tuning to optimize the functionality of dashboards.
• Provided production support to the existing QlikView applications.

Environment: QlikView 10(Desktop, Server/Publisher, Access Point),Nprinting for QlikView (14.03.), Oracle 11g, Windows XP/7.

Confidential, Cleveland, OH

QlikView Developer

Responsibilities:

• Collaborated with Business Leaders to share and gather QlikView Planning requirements
• Implemented Star Schema & Snow Flake for Dimensional Data Modeling in QlikView
• Created user interface reports using QlikView sheet objects like List Box, Input Box, Buttons, Text Input, Slider, Bookmarks, Charts (Pivot/Straight tables, Pie, Bar, Line etc.)
• Created QVDs and developed Dashboard style of reports as per business needs
• Developed extensively Variables, Input boxes, Triggers, Macros
• Created Set Analysis for Comparison analysis eliminating additional complex coding
• Wrote SQL Scripts to load relevant data in QlikView Applications
• Created and schedules tasks for reloading and distribution of Data in QlikView Publisher
• Automated jobs in Publisher & rolled out to QlikView Access point & maintained security
• Gathered & loaded data into QlikView from various sources of data like SQL SERVER 2005, Oracle 10g, .CSV and excel files
• Maintained both File and Data Level Security and implemented Data Reduction
• Used to train and solve the issues related to the end users
• Involved in Performance Tuning & Deployment of QlikView Applications
• Intense knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Management Console

Environment: QlikView 10, QlikView Server 10, QlikView Enterprise Management Console, SQL Server 2005, Windows Server 2003, Salesforce (.d11 adaptor), Oracle 10g, SQL Scripting

Confidential

Oracle Developer

Responsibilities:

• Create Users and Responsibilities for Security.
• Involved in design of the application system.
• Involved in developing E-R diagrams, creating tables.
• Enhanced and developed several forms and reports using developer 2000
• Designed and developed library files (PLL) that are commonly used across the application
• Involved in design and development of Menu module
• Created database triggers to validate the complex integrity.
• Created stored procedures, functions and packages for implementing major functions of the system.
• Wrote scripts for populating the database tables with test data.
• Testing and documentation.
• Involved in design and development of Menu module
• Created database triggers to validate the complex integrity.
• Created stored procedures, functions and packages for implementing major functions of the system.
• Involved in design and development of Menu module
• Created database triggers to validate the complex integrity
• Wrote scripts for populating the database tables with test data.

Environment: Oracle 7.3, SQL, PL/SQL, SQL*Net, Windows NT/95, SQL*Loader, Import, Export.