SUMMARY

• Around 9 years of IT experience in the areas of business intelligence, data modelling, requirement Analysis, quality assurance and system integration
• Involved in UI Designing & developing of variousQlikViewdashboards such as Sales Dashboard, Order Management Dashboard, Marketing Dashboard, Project Management Dashboard, Executive Dashboard
• Extensive experience in creating QlikViewdata models,QlikViewobjects, reports,
• Graphical Interactive UI and dashboards using QlikViewfrom multiple data sources like SQL SERVER, Oracle, and Flat Files
• Good Knowledge on Hadoop.
• Experience in creatingQlikViewDashboards using Chart Box, List, Input Field, Table Box, And Master Calendar. BI / Data Analyst and Technical Lead wif Various domain exposures in Banking / Finance, Insurance, Health Care, Retail, Automobile
• Extensively worked on set analysis, advanced aggregation and section access
• Strong skills in providing custom functionality forQlikViewapplications using Triggers, Macros, Set Analysis
• Experience in UsingQlikViewFunctions (Date and Time, Keep, Join, Mapping, String & input Fields)
• Expertise in designing and creating various analytical reports and Dashboards to help
• Users to identify critical KPIs and facilitate strategic planning in the organization UsingQlikView
• Experience inQlikViewServer and Publisher maintenance - Creating scheduled jobs for QVD Extracts and report reloads
• Expertise in designingQlikViewapplications usingQlikViewData (QVD) files generated By ETL logic
• Experience in Qlik Sense Administration like installing, configuring and upgrading the Qlik
• Sense setup in windows operating systems.
• Worked on multi-node and Signe node clustering using postgres data base.
• Hands on experience wif writing security rules in Qlik Sense.
• Implemented Nprinting 16.x & 17.x installing, configuring in windows OS.
• Installed & Configured Geo Analytics.
• Experience in creating virtual proxies and Single Sign on (SSO).
• Experience in creating certificates (PKCS12) for Qlik Sense to Autanticate Secured Gateway to login Qlik Sense Hub.
• Experience in implementing F5 Load balance for Qlik Sense
• Expertise in Qlik Sense data modelling, Qlik Sense Development, Qlik Sense SDLC and Governance, Qlik Sense apps, stories, KPI and Story generation
• Developed Qlik Sense applications using various Qlik Sense extensions to reach the expectations.
• A well-organized, goal-oriented team member wif excellent verbal, written and Interpersonal skills and motivated to learn new technologies and get proficient in the Very quickly

TECHNICAL SKILLS

Tools: & Technologies: QlikSense 1.x/2.x/3.x/September Release 2017, QlikView11.x/12.x, N-printing 16.x/17.x, Micro Strategy, Tableau, cognos 10, SAP BO, SAP BW. Power BI

Languages: SQL, T-SQL, PL/SQL, JSS, HTML, D3 Library.

Database: SQL Server, Oracle 11g,Big Data, SQL Server, Teradata, DB2, MS Access, HP Vertica

ETL Tools: Informatica.

Operating systems: Windows 2008/2012 Server

PROFESSIONAL EXPERIENCE

Confidential, Detroit, Michigan

QlikView/Qlik sense Developer

Responsibilities:

• Responsible for gathering business requirements and technical specification from the users
• Created task and set dependency using qlikview publisher.
• Building front - end user interface application based on user requirement stories.
• Assisting business users in troubleshooting application issues. implemented section access to make application available to desire users
• Creating multi-dimensional data models based on the STAR and Snowflakes schemas.
• Working on Alteryx workflow to transform the data from different data source dashboard.
• Simplifying complex expression in the dashboard and improving front end.
• Assisted user wif demo session in using qlikview/qliksense.
• Sending the update status report to the manager on daily, weekly and monthly basis.
• Coordinates wif onsite team on project development tasks and provided updates to the manager.

Environment: Qlikview, Qlikview server, Qlikview Publisher, Qlik Sense, Hive, Alteryx,Talend, Informatica, SQL Server, Oracle 11g, MS- Access, Excel, SharePoint, QMC, Windows Server.

Confidential, San Jose, CA

QlikView/Qlik sense Developer

Responsibilities:

• QlikView and Qlik Sense Administration and Attribute based access control and role creation
• Performance tuning by analysing and comparing the turnaround times between SQL and QlikView.
• Installed and configured Nprinting and built reports to replace QlikView macros / SAS Code to generate reports
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
• Worked as a Business Systems Analyst and/or Lead Business Systems Analyst on multiple projects supporting multiple business partners
• Worked wif Section Access so dat the data security defers to each user.
• Optimized existing Data Models like changing Load scripts to load data in optimized way
• To achieve reduction of loading time, simplified complex expressions in the front - end And Improved layout structure.

Confidential - Houston, TX

QlikView/Qlik sense Developer

Responsibilities:

• Analyze, design, develop, test, implement and maintain detailed Business Intelligence solutions using Qlik sense under windows operating systems
• Develop technical and functional requirements and design specifications to develop custom Qlik sense applications
• Create Qlik sense extract layers, Logical layers, Star Schema/Snow flake Schema data models and developing functional reports in user interface in Qlik sense Application
• Provide Qlik sense configurations and maintain Qlik sense instances and cluster monitoring
• Deploy the designed reports into integration and implement the performance test, Response index test, Governance test, User validation of data accuracy
• Develop and implement automation and efficiencies wif Qlik sense API’s (Application Program Interface)
• Design and develop dashboards and monitor and track Qlik sense performance issues; provide strategic support of Qlik sense integrations, deployments, and configurations
• Prepare workflow charts and diagrams to specify detailed operations to be performed by the Qlik Applications
• Plan and prepare technical reports, instructional manuals as documentation of program development
• Migration the Qliksense dashboard to Power BI.

Environment: QlikView 12.x,Qlik Sense 2.x/3.x, Business Objects, SVN, Curran 5.2, Vertica, Subversions, MS Access, Ms SQL Server.

Confidential - Charlotte, NC

QlikView/Qlik sense Developer & Administration

Responsibilities:

• Interacted wif end users in gathering requirements.
• Involved in Qlik Sense administration.
• Installed and Configured multi-node environment for Qlik Sense 3.x, September Release 2017 and February Release 2018 in windows operating Systems
• Implemented Qlik Sense wif Azure and AWS.
• Worked on writing security rules, Customs properties, configuring task failure email Alerts and load balancing rules.
• Installed and configured postgres data base for Qlik Sense in MSCS Cluster.
• Implemented Governance dashboard for Qlik Sense and along wif performance tuning For Qlik Sense dashboards.
• Worked on Single Sign on (SSO) Autantication and creating the certificates (PKCS12).
• Installed and configured Nprinting 17.x and generated reports (HTML, EXCEL, PDF) Integrated wif QlikView and Qlik Sense
• Implemented Geo Analytics, Qlik Web connectors 2.x and QMC Utilities.
• Performed in importing the extensions into Qlik Sense.
• Created Dashboards usingQlikViewcomponents like List Box, Slider, Buttons, Charts, and Bookmarks.
• Involved in gathering data sources like QVD files, Excel, Oracle, binary QVW, Inline & txt Files in developing theQlikView/Qlik Sense Data Models.
• Implemented 3-Tier Architecture to create QVDs, Data Models and reports.
• Used SQL queries extensively to retrieve the required data from SQL Server.
• Created a Data Model for an application by using various functions.
• Assisted in performance tuning ofQlikViewand Qlik Sense applications for faster data Reloads and efficient respond times.
• Performance tuning by analysing and comparing the turnaround times between SQL and QlikView.
• Installed and configured Nprinting and built reports to replaceQlikViewmacros / SAS Code to generate reports
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
• Worked on Publisher to Automate and scheduled daily/weekly/monthly data loads of QVW documents and error notifications by email to assigned users.
• Applied mapping function to look up and fetch the required field.
• Involved in converting the existingQlikViewapplications to Qlik Sense using QlikView Converter.
• Building the Qlik Extensions using Java script and D3.
• Handled big data in QlikView andQlik Sense.
• Used Set analysis to write complex logic according to requirement.
• Created dashboards using Qlik Sense extension objects and mashups.
• Qlik Sense App development, templates, themes, master library items and story Generation.
• Worked as a Business Systems Analyst and/or Lead Business Systems Analyst on multiple projects supporting multiple business partners
• Worked wif Section Access so dat the data security defers to each user.
• Optimized existing Data Models like changing Load scripts to load data in optimized way
• To achieve reduction of loading time, simplified complex expressions in the front-end And Improved layout structure.
• Worked on deployment ofQlikViewApplications in the production.

Environment: QlikView-11.2 (SR12),QlikViewServer/Publisher (QMC), SQL Server 2008 R2 Enterprise, Qlik Sense 3.2/3.2.3/September Release 2017/February Release 2018, HiveTableau, SAP BO, Cognos 10, Oracle, Teradata, Informatica, Web Connectors, Qlik API’s, D3. Library visualizations, Mashups, QlikView Converter, SSO.

Confidential, San Diego, CA

QlikView/Qlik sense Developer

Responsibilities:

• Work directly wif business users to define and build QlikView Applications.
• Leading the QlikView andQlik Sensedevelopment environment.
• Creating the QlikView andQlik Sensedashboards and charts.
• Building the QlikView andQlik SenseExtensions using Java script and D3.
• Handled big data inQlik Sense.
• QlikView data modelling by building the Star schema and resolving loops/synthetic keys.
• Creating new extensions using the QlikView API and using them TEMPeffectively in Dashboards.
• Building the user-friendly interface by modifying the QVP files in the extension.
• So dat users can use the extensions TEMPeffectively.
• Implemented the Various scenarios of section access.
• Experience in QlikView/ Qlik Sense administration.
• Experience in installation, upgrades and configuration of QlikView setup in windows Operating systems.
• Worked on multi-node installation of Qlik Sense 3.2.1 and also upgraded to Qlik Sense 3.2.3.
• Worked on writing the security rules for Licenses, LDAP Groups and Streams.
• On boarding the user’s to Qlik Sense adding the different group into LDAP directories Using filter conditions.
• Implemented the Single Sign On (SSO).
• Troubleshooting the server logs for Qlik Sense task failures, User Access, App Import and other failures in Qlik Sense
• Hands on experience wif QlikView upgrades and Nprinting installation 16.x. to 17.x.
• Implemented Qlik API’s for Auto deployment.
• Worked independently in building the Self-service template for users. So dat it can reload the data sources per user requirement wifout any need of load script.
• Creating the Utilities using QMS API for bulk insert of Users and extracting the Meta Information from QlikView server.
• Installing, configuring and maintaining the QlikView infrastructure.
• Training the end users on the QlikView Tool for using it TEMPeffectively and provide customer support.
• Installing and configuring complete QlikView server setup, IIS web server.
• Experience in debugging the QlikView server issues through server logs, Fiddler logs.
• Experience wif QlikView management console.
• Experience in error handling and debugging ofQlik Senseand QlikView reports. Expert in Handling production issues like report failures, missing counts in reports, resolving Synthetic keys, Loops.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Created Qlik scorecards, dashboards, Heat maps using show me functionality.
• Created complex data Views Manually using multiple measures also used sort, filter, Group, set functionality.

Environment: QlikView 12.x,Qlik Sense 2.x/3.x, Business Objects, SVN, Curran 5.2, Oracle 10g/11g, Subversions, MS Access, Ms SQL Server, SAP BW, Hive, Tableau, Teradata, Informatica

Confidential -Plano, TX

QlikView Administration / Developer

Responsibilities:

• Installing, configuring, Clustering, Load balancing and Multi-node installation of QlikView and Qlik Sense Environment.
• License Modelling for both QlikView and Qlik Sense.
• Server Sizing.
• QlikView and Qlik Sense Security Implementation. implementing the governance
• QlikView and Qlik Sense Administration.
• Attribute based access control and role creation.
• JMETER setup and Scalability Tests of Qlik View dashboards.
• Performance optimization
• QlikView and Qlik Sense Extensions.
• Qlik APIs and building the custom solutions.
• Experience in error handling and debugging of QlikView reports. Expert in handling production issues like report failures, missing counts in reports, resolving synthetic keys, Loops.
• QlikView and Qlik Sense development.
• QlikView and Qlik Sense Seta analysis, Data Modelling.
• Handling big data loads to QlikView and Qlik sense and implemented impactful solutions.
• Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques
• Having experience in developing the Qlik sense/QlikView environment and supporting the business decisions process.
• Developed Many Qlik sense templates, themes, master library items and story generation.
• Studied the existing data model and incorporated the new fields including static and dynamic flag fields to meet wif the business requirements
• Worked on bulk volume of data sets and different data sources like .csv files, oracle tables, excel files, images, etc…

Environment: Qlik sense, QlikView dashboard, Business Objects, SVN, Curran 5.2, Oracle 10g/11g, Subversions, MS Access, Ms SQL Server, SAP BW

Confidential

QlikView Developer

Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• To keep track of data manipulations using Audit functionalities.
• Generated custom and parameterized reports using SSRS.
• Created reports dat call sub reports in SSRS.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Responsible for creating datasets using T-SQL and stored procedures.
• Created several packages in SSIS.
• Scheduled the packages to keep extracting the data from OLTP Confidential specific time intervals.
• Used various transformation tasks to create ETL packages for data conversion.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Used SQL Server Agent for scheduling jobs and alerts.
• Performed Query optimization & Performance Tuning.
• Optimized queries using SQL Profiler and Database engine tuning advisor.
• Experience in optimizing QlikView applications to improve the performance.
• Developed User Interactive Sheets & Reports as per business needs.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks. Developed KPI's and set analysis applications.
• Gathered & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, CSV and Excel files).
• Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server, Oracle, binary QVW, Inline & txt files in creating the Qlik Sense dashboards.
• Connected to different ODBC, JDBC, 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 Qlik Sense.
• Created multiple tab dashboards. Created Pivot Tables, Trend Graphs, Bar Graphs, Stacked Graphs, containers and so on.
• Extensively worked wif QlikView functions, objects, Set Analysis, Variables to generate different kinds of charts. Also generated QVD files by writing scripts in QlikView applications.
• Used a KPI/gauge object which TEMPhas built in colour switching to colour code the fonts.
• Built several Dashboards wif current year statistics and trending information wif the ability to toggle between different metrics and drill down sheets and report detail charts for further analysis.
• Analysed the existing QlikView data model, script logics and the ETL business logic for the existing QlikView applications.
• Working noledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Developed SQL Scripts in validating data from different data sources. Mentoring Business User Groups

Environment: SQL Server 2008 Enterprise Edition, SQL Server Agent, SSIS 2008, SSRS 2008, C#,T-SQL, Windows 2000/2003 Server, XML, MS Excel, MS Access, QlikView 9.x.