SUMMARY:

• More than 9+ Years of IT experience in Business Analysis and Business Intelligence Projects, along with 4+ years of Qlikview and Qliksense Development/Admin.
• Expertise in working with Data Warehousing and business intelligence tools for developing various reports using Qlikview/Qliksense BI.
• Experience in full life cycle project development, including design, coding, testing and implementation with ongoing product support.
• Strong analytical database design and Data Modeling (Star Schema, Snow Flake Schema) skills in Qlikview.
• Experience on MS SQL Server (BI) and SQL Programming.
• Expertise in ETL (Data Extraction, Transformation Loading), Data modeling, Designing Visualizations and Performance Tuning using Qlikview
• Good Understanding of Relational and Dimensional Database Concepts.
• Excellent understanding of data warehouse specific Architecture, Design and Procedures, ETL and Workflow Development, data cleansing, data quality validation and unit testing.
• Expertise in Installing and Configuring Qlikview Desktop, Qlikview Server and Qlikview Publisher
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Interacted with Customers for requirement gathering and effective analysis.
• Supported all phases of a project life cycle including analysis, design, development, testing, deployment of solutions, and postproduction support/maintenance functions.
• Developed User Interactive Sheets & Reports as business needs.
• Developing SQL Scripts to load the relevant Data in both Qlikview and Qlik Sense Applications.
• Developed Macros, set analysis to provide custom functionality in Qlikview Applications
• Developed Qlikview Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Data Island
• Experience in designing Qlikview Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services (DTS), SSIS, BCP and Bulk Insert).
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
• Expert in Data warehousing concepts - Star Schema, Extended Star Schema, Snowflake Schema, Multi-Dimensional modeling & Entity-Relationship modeling.
• Exceptional analytical, troubleshooting and communications skills to communicate directly or remotely with business partners/clients to identify key areas where Business Intelligence can solve business problems by delivering pertinent and timely information.

TECHNICAL SKILLS:

DASHBOARDING/ANALYTICS: Qlikview 10.x, 11.x, 12.x, Qliksense 2.x, 3.x, Tableau, Microsoft SSRS, Cognos.

Others: Informatica, Teradata.

Operating Systems: Windows NT XP/2000, Windows 2003, 2008 R2, Windows 7

Web Technologies: HTML, CSS, XML, Java Script/JQuery

Database: MS SQL Server 2005, 2008, R2, 2012, MS Access 2000, 97, Oracle.

User interface: HTML, CSS, XML, Java Script/JQuery

PROFESSIONAL EXPERIENCE:

Confidential, Montvale, NJ

Sr.Qlikview/Qliksense Developer/Admin

Responsibilities:

• Qlik view and Qlik sense point of View developing, performance tuning, capacity planning and Problem solving.
• Extensive Experience of working with Qlik Sense sites and the Qlik Management Console (QMC), to provide IT and data governance, library of QVD maintenance, as well as user and application security.
• Architected the design of Multi-layered QVD architecture across the functional.
• Actively part of business requirement elicitation and discovery workshops to gather the functional & non-functional requirements.
• Responsible to create the Access control list (ACL) & security rule provisioning.
• Responsible to maintain the Qlik Sense operations, licenses, log and session monitors.
• Part of design team to provision High Availability (HA) architecture with F5 & fail-over clusters.
• Administered multiple Qlik sense and Qlik view farms consisting of load balanced dashboards and Mashups external Back end application Servers (Dev/QA/UAT/ PROD) monitoring via Dynatrace Monitoring tool.
• Custom Mashup Solutions to retrieve the business data from Qlik view applications Into Qlik sense.
• Qlik Sense Server Installation and Migration and Defining Guidelines for Migration
• Troubleshooting capabilities to research Qlik Sense audit logs to resolve & remediate issues.
• Responsible to replicate Qlik sense application installation and upgrades in various pipelines (Dev, QA, UAT, & Prod Environments).
• Managing and allocating Qlik sense tokens and Access pass.
• Monitoring of the Qlik Sense server platform for performance and availability
• Managing of all Qlik Sense server configurations.
• Management of the reload schedule for all Qlik Sense documents.
• Working knowledge of Qlik view Publisher (QMC) - Adding Tasks, Adding Users, EDX triggers, troubleshooting.
• Silo responsibility to deal with Qlik vendor support.
• Manage deployments of Qlik applications / Create a streams and publish the application and deploy the CSS files. And built QVD’s from Hadoop sources on Qlik view, web configs, Info path forms, Qlik view and Qlik sense services and Infrastructure up dates.
• Create deployment strategy for the Mashups of the development, quality assurance and staging and Production environments.
• Handled the administration responsibilities for 24 Qlik team members & handled requests of external team on-boarding into the Qlik farm.
• Knowledge of networking and Active Directory configuration, proxies, intermediate web servers etc.

Environment: Qlik view 11 SR2/11.2/12, Qlik sense 2.0/2.2/3.0/11.24.1 , MS Office, SQL server 2016, Web UI, Windows server 2008, Windows server 2012, Windows 7, and Windows 10

Confidential, Arlington, VA

Sr.Qlikview/Qliksense Developer/Admin

Responsibilities:

• Understanding the requirements from the business users and their reporting needs. Suggested better way of presenting layout /Sheet Objects and developed the architecture of prioritized reports which were accepted and successfully implemented in the dashboards.
• Installation and configuring of Qliksense Desktop on Windows Server 2008 R2 Enterprise/cloud.
• Developed the report by passing a Parameter Value to navigate from one KPI in Dashboard to another.
• Analyzed the source data coming from various heterogeneous data sources to be consumed in the ETL procedures to load data into data warehouse.
• Used a KPI/gauge object which has built in color switching to color code the fonts.
• Scripted using dollar sign expansion which is a text replacement that happens before the actual statement is parsed and evaluated.
• Developed executive dashboards in Qlikview delivered through the web, enabling to measure.
• Performance the performance of the business with analytical capabilities.
• Dashboards were served to track inventory and sales as well as to monitor various KPIs. Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Implemented performance tuning techniques both in the scripting and UI.
• Created Line Charts to show different trends of Product Sales over years using set expressions, year function, maxfunction etc.
• Involved in the business requirement gathering and development of functional and technical specification documents.
• Created connections and Extracted data from multiple complex hierarchies from cross table excel files.
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Multiple levels of Hierarchies are implemented such as Cohorts, Sales, Products, Partner, Customers and Service Hierarchy etc.
• Provided custom functionality in Qliksense Applications.
• Developed Fast Change Charts by using both Cyclic Groups (merged Expressions and also the fields) and Drill Down groups.
• Developed Bar Charts to show the total/Average sales of products for the current and previous years.
• Frequently used statements/functions while developing were Where Exists), Get selected functions, If, Distinct, Join, Concatenate, Resident, AutoNumber, Mapping load, Apply Map, ceil Len, calendar functions.
• Used Set Analysis in the Line and Bar charts (Combo Charts) to show the user different trends of product sales over years.
• Used Calendar/Slider Object to set a custom Date in the Adhoc tab, a tab which is specially designed where the users can create their own graphs/charts.
• Created Dashboard reports to track all the way through the ship to final acceptance phases.
• Developed executive dashboards in Qlikview delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• The Process was Agile and strict time line oriented. Worked closely with Project manager.
• Performed technical leadership in dashboard application design, visualization, automation, e - mail alert and notification, data modeling and the integration with the Portal platform.
• Used Data Model Optimizing techniques to reduce the size of the application, improve the performance/speed of the application and was involved in performance tuning of dashboards to limit the response time and enhance the functionality.
• Created List boxes, Statistic boxes to show the statistics of the sales held on different products in different years. Also showed the statistics in bar charts and pie charts as per the client needs.
• Converted A Pivot Table into a Static Selection table box using some techniques like conditional Show, Multiple Dimensions imposed with conditional calculations etc.
• Developed heat maps (Google Maps and also Picture embedded text objects) with alert mechanism to show US State wise and scatter maps. Also Various KPI graphs were drawn. Kept eye on Qlikview best practices.
• Used svg map with qar extensions to design a web view heat map/Choropleth using Qlikview.
• Developed an Ad hoc sheet where the users have the freedom to select their own dimensions and metrics to create their own personalized Pivot/straight table.
• Developed nsq files to export the excel reports based on the business requirement.

Environment: Qlikview 11.2 - SR12, Qliksense 3.0, Printing, Oracle SQL Developer 3.2.20 TSQL, HTML, CSS, JQuery, JSFiddle, Windows 2012 Enterprise server, Excel.

Confidential, Columbus, IN

Qlikview Developer/Admin

Responsibilities:

• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Qlikview desktop.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Qlikview BI suite.
• Functional Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards.
• Generate new QVD files created by ETL logic to feed Qlikview applications.
• In charge of the team that builds tableau architecture and dashboards using Tableau desktop, Tableau Server and Tableau Online.
• Working with User for requirements and part of the team developing the software.
• Publish Qlikview workbooks to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Created Qlikview scorecards, dashboards, Heat maps using show me functionality.
• Good Experience in publishing reports and dashboards to Tableau server
• Created complex data Views Manually using multiple measures also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Developed and created classes with Dimension, Detail & Measure objects and developed Custom hierarchies to support drill down reports
• Troubleshoot issues with existing reports in the production environment.
• Created Views, Stored Procedures and validated data for the Performance.
• Developed various types of complex reports like Standard reports, Group reports, Detail and Summary reports, Crosstab reports, Graphical reports, drilldown reports, on Demand and Linked sub reports using crystal reports, tables, views, stored procedures, business views.
• Provided daily production support and administration of portal operations, such as problem resolution.
• Worked closely with Data Modelers in designing various data warehouse schema techniques.
• Worked on the data provider that forms the basis of the ad-hoc analysis.

Environment: Qlikview 11, 10 ETL, Oracle 10g, SQL Server 2008, Windows 2003Server, Data modelling.

Confidential, Milpitas, CA

Qlikview-Developer/Admin

Responsibilities:

• Designed, developed, implemented, and supported Qlikview dashboards and integrated data sources and databases with Qlikview.
• Installed and configured Qlikview Server to document application development. ETL extractions and generating ODBC Connections to extract from databases and QVD storage were part of daily tasks. Implemented Star and Snowflake schema to render data model.
• Answer technical support queries and implements fixes for application problems.
• Reduced the turnaround time of bi-weekly reports by 30% by using dashboards in Microsoft Excel.
• Building Cognos cubes using Impromptu and maintaining them on a day-to-day basis.
• Responsible for the analysis, in terms of both structure and content, of the medicine related sales data that are held up by the system due to tariff deviations.
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Increased the throughput of ticket management system used by clients by using filters on reports pulled from database using SQL querying.
• Promoted dashboards to production environment and manage user access.
• Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Developed Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Created Drill-down and Sub-Report using SSRS.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data.
• Builtdashboards for measures with forecast, trend line and reference lines.
• Define best practices for creating Tableau dashboards by matching requirementsto the charts to be chosen.
• Developed Ad-hoc reports using Tableau Desktop, Excel.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis using SQL/PLSQL.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Provide technical second-level support for ETL (Informatica, Datastage) applications.
• Responsible for tracking of trouble tickets and resolution of escalated incidents using BMC Remedy.

Environment: Qlikview 11, Qliksense 2.0, MS Access, Windows Server 2012, Informatica, SQL Server 2012.

Confidential, Chicago, IL

Qlikview-Developer/Admin

Responsibilities:

• Involved in business requirement gathering and development of functional and technical specification documents.
• Developed different dashboards with a complex database system behind it, which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Created Dashboards style of reports using Qlikview components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of Qlikview.
• Gathered & loaded data into Qlikview from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using Qlikview Publisher and notified load status by email.
• 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.
• Build reusable macros to control Qlikview objects for ease of use by the users.
• Delivered advanced/complex reporting solutions such as Dashboards and Standardized Reporting using Qlikview 8.5
• Implemented Star schema & snow flake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation and solved the loops issues.
• Read and gather Qlikview Planning requirements.
• Used to solve the issues related to the end users.
• Installation/Configuration of Qlikview 8.5.
• Working knowledge of Qlikview Server, Qlikview Publisher, and Qlikview Enterprise Version.
• Research and troubleshoot technical problems and provided ongoing Qlikview consultation to the development team.

Environment: Qlikview 11, 10 ETL, Oracle 10g, SQL Server 2008, Windows 2003Server, Data modelling.

Confidential

BI Developer

Responsibilities:

• Worked on Qlikview sheet objects, Pivot list, Multi box, multiple chart types using complex multiple data sources like SQL, Flat files, Excel and access for deigning and modeling of Qlikview.
• Worked on eliminating synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys.
• Designed the data model and implemented Star schema for QV better optimization.
• Developed on Qlikview applications using different functions like AGGR, First sorted value, Apply map, Match, Pick, Value List, Value Loop and many other Script and UI level functions.
• Responsible for creating and delivering recurring as well as ad hoc marketing campaign programming within strict timelines while under constantly changing requirements using SAS, SAS SQL, and Teradata SQL in a UNIX environment with Oracle, Informix, and Teradata relational databases.
• Debugged, created maintained and documented Adhoc reports on demands.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.

Environment: Informatica, ETL, Microsoft SSRS, Cognos, SQL/PLSQL, Datastage, Control-M,Peoplesoft, DWH, Data modeling, UNIX.