SUMMARY:

• 8 years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing/ Decision support systems and Business Intelligence (BI).
• 6+ years of experience in Designing and Development of Business intelligence applications with Qlikview 12.10/11.2/10.0/9.0 as BI tool.
• QlikView Developer experience in all aspects of Business Intelligence applications with a strong background in Database development, Data Warehousing/ Decision support systems and Business Intelligence (BI).
• 2+ years of experience in preparing dashboards using Qliksense 3.1/3.0.4/2.2/2.0 extension objects.
• Actively participated in Production meeting for requirement gathering and worked closely with IT Director, Vice - President of Operations, Planning team and stakeholders to know their business requirement specifications.
• Experience in using QVW, QVD, QVX and QVF (Qliksense) files effectively.
• Expertise in design/development of Business Intelligence Applications with QlikView 12.10/11.2/10.0/9.0 as BI tool.
• Strong knowledge/experience in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production support.
• Strong experience in QlikView Product family such as QlikView Desktop Client, QlikView Management Console, QlikView Server.
• Strong experience in Scripting, developing and designing Dashboards using QlikView by extracting data from multiple sources (QVD files,Oracle, Flat files, Excel, Access) by connecting through ODBC and OLEDB.
• Created scheduled jobs for QVD extracts and report reloads.
• Hands on experience in SDLC processes and methodologies in Business Intelligence domain.
• Developed business requirements, Dashboard development, and data verification and analysis.
• Deployed QVWs on the production server, Created Reload and Distribution tasks on QlikView Server/publisher.
• Experience with Multiple Relational Databases including Oracle, MS SQL Server, DB2 and MS Access.
• Experience with QlikView sheet objects Pivot, List, Multi-box, multiple charts types, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Experience in using ETL Tasks such as data cleansing, joins aggregation tables using QlikView.
• Designing Data Mart and Data Warehouse and Implementation of QlikView for BI Reporting Solutions.
• Extensive use of Set Analysis expressions in the charts for achieving complex logics.
• Implemented Best Practices to resolve Circular Relationships, Synthetic Keys in QlikView and designing an optimized Data Model.
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas, Fact and Dimensional Tables.
• Strong experience in writing SQL Queries, Views, and Stored Procedures.
• Self-Starter with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Reporting Tools: QlikView -9/10(SR3/4)/11.2(SR2)/11.2(SR10)/11.2(SR12)/12.10, Qliksense-

3.1/3.0.4/2.2/2.0 , Nprinting- 17.2 :

Operating Systems: Windows 98/NT/XP/2000/ 2003, 2008,Linux

Databases: Oracle 12c/11g, MS SQL Server 2008/2005, DB2, MS-Access-

Database Tools : SQL * PLUS, Toad for Oracle Base (10.6.1.3)

Other Tools: Hyperion Essbase, Planning, Smart view, 9.2/9.3.1/11.1.2.1 ,

Office Tools : MS Word, Excel, Power Point

PROFESSIONAL EXPERIENCE:

QlikSense Developer

Confidential, NC

Respnsibilities:

• Actively participated in Production meeting for requirement gathering working closely with business users and stakeholders. 
• Involved in full project life cycle implementation (requirement gathering to production) QlikSense dashboards. 
• Participated on business requirement document preparation. 
• Responsible for Self-Business analysis tool Qlik Sense initial setup and end to end development of Qlik Sense applications.
• 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 QlikSense dashboards. 
• 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 QlikSense. 
• 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. 
• Created Data Connection from MRP tool Process Pro to QlikSense.
• Extensively worked with QlikSense functions, objects, Set Analysis, Variables to generate different kinds of charts. Also generated QVD files by writing scripts in QlikSense applications. 
• Used a KPI/gauge object which has built in color switching to color code the fonts. 
• Extracted data from multiple complex hierarchies from cross table excel files. 
• 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. 
• Worked as QlikSense administrator to optimize Qliksense performance.  
• Trained users to build their own apps in QlikSense. 
• 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 QlikSense 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. 
• Create, manage, clone, and delete nodes in Qlik Sense sites that are deployed in cloud computing environments. 
• Installation of IE plugins and 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, Data Modeling, Oracle 10g, DB2, MS SQL Server 2016, Process Pro,Windows 2008 R2, Excel, MS Access, Flat files.

QlikView/QlikSense Developer

Confidential, GA

Respnsibilities:

• Understanding source systems and customer requirements.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Gathering data sources like QVD files, Excel, Oracle, binary QVW, Inline & txt files in developing the QlikView/QlikSense Data Models.
• Implemented Multi-Tier Architecture to create QVDs, Data Models, and reports.
• Used Sql query’s extensively to retrieve the required data from Sql Server.
• Created a Data Model for an application by using various functions.
• Eliminated Synthetic keys, ambiguous relationships.
• Assisted in performance of QlikView&Qliksense applications for faster data reloads and efficient respond times.
• Applied mapping function to look up and fetch the required field.
• Involved in converting the existing Qlikview applications to Qliksense.
• Used Set analysis to write complex logic according to requirement.
• Worked with Sheets and Sheet Objects in QlikView.
• Created dashboards using Qliksense extension objects and mashups.
• QlikSense App development, templates, themes, master library items and story generation.
• Worked with Section Access so that the data security defers to each user.
• Used QlikView Scripting and Complex SQL coding for loading, and transforming.
• Worked with Variables to hide/show the necessary objects and perform logics according to requirement.
• 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.
• Developed applications and manage security for all required applications.
• Worked on deployment of QlikView Applications in the production.
• Maintained an environment for the authoring of QlikView reports in QMC.
• Created tasks and reduce, reload, and distribution of Publish the Reports using QMC.

ENVIRONMENT: QlikView-11.2 (SR12), QlikView Server/Publisher (QMC), SQL Server 2008 R2 Enterprise, Windows 2008 Enterprise, Qliksense-2.2.

QlikView Developer

Confidential, TN

Respnsibilities:

• Gather customer requirements from Business Analyst.
• Understand the data from different source systems.
• Extract data from the database, stored into QVD files, and wrote Load scripts.
• Identify Dimensions/Fact Tables form of source tables and implement Multi-Tier Architecture to create QVDs, Data Models, and reports.
• Create link tables on the needed basis and as per the data.
• Develop executive Dashboards in QlikView delivered through the web.
• Work with Sheets and Sheet Objects in QlikView.
• Create Dashboards with Complex Sheets which include List boxes, Statistic boxes, and containers, different charts (bar charts, scatter charts and pie charts) to show the statistics on different kinds insurances and loans in various years.
• Use layout conditions to meet various requirements.
• Develop Set Analysis to provide custom functionality in QlikView applications.
• Implement Document Event Trigger and Field Event Triggers.
• Extensively use variables to meet various requirements.
• Use different color schemes for charts according to meet requirements.
• Create daily, weekly, monthly and quarterly reports according to the customer requirements.
• Back tracking QlikView Data Issues by comparing QlikView Reports with Database Tables output using SQL Queries through TOAD.
• Work on QlikView Server/Publisher to automate the QlikView Jobs and define the user security and data reduction.
• Deploy QVWs on the production server, create Reload and Distribution tasks on QlikView Server/Publisher.
• Manage user’s access to the QlikView Server and QlikView Access Point.

ENVIRONMENT: QlikView 11.2 (SR10), QlikView Server/Publisher (QMC), TOAD for Oracle Base (10.6.1.3), MS Excel, Windows 2008 Enterprise

QlikView Developer

Confidential, CO

Respnsibilities:

• Gathered the requirements from Business Users and passed on the requirements to the team.
• Worked on designing the Data Model and Construction of the Data Model and implemented the Star schema for QV better optimization.
• Installed, configured and deployed the application on QlikView server and Imported data from different sources such as Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Created Dashboard reports to track all the way through 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.
• Created Dashboards with complex sheets which include List boxes, Statistic boxes, and containers, different charts (bar charts, scatter charts, Heat charts, and Block charts and pie charts) to show the statistics of the sales held on different products in different years.
• Created static reports using straight tables and pivot tables with spark lines and mini charts
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Worked on upgrade of QlikView environment from QV 10.0, QV 11.0 versions.
• Designed, developed, implemented and tuned multiple QlikView applications for the Sales, IT.
• Used advanced scripting, Alternate states for comparative analysis, set analysis, VBScript and JavaScript macros, advanced aggregation functions, advanced charts for applications and Document chaining
• Created Layout themes and applied it to several QVW’s
• Involved in performance tuning of Dashboards to improve the response time for the users accessing the documents via access point by reducing the size of the QVW
• Good understanding in the area of monitoring the various services in QMC, Task setup, Managing client licenses, Mounting folders, session collaboration, enable session, performance and audit logging, type of authorization (NTFS and DMS), loop and reduce and Section access management in PAT

ENVIRONMENT: QlikView 11.0 (SR2), QEMC, SQL Server, DB2, Windows 2008 Server, HTML, VBScript, JavaScript, Qviewer, MS TFS, MS Excel

Qlikview Developer

Confidential, OH

Respnsibilities:

• Gathered customer requirements from Business Analyst and understand the data from different source systems.
• Extracted data from the database, stored into QVD files, and wrote Load scripts.
• Implemented QlikView three tier architecture Data Model.
• Eliminated Synthetic keys and circular loops in the Data Model.
• Created link tables on the needed basis and as per the data.
• Created Master Calendar and worked with date fields as per the user needs.
• Applied mapping function to look up and fetch the required field
• Created User Interface of reports and designed the Dashboard according to the requirements.
• Created Dashboard style of layouts using various components of QlikView like List boxes, Multi-boxes, Slider, Current Selections Box, Buttons, Charts, Text Objects, and Bookmarks.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping).
• Constructed various graphs such as Straight table, Bar graphs, Pie charts, Line charts Gauge charts.
• Implemented Pick Dimensions and Pick Measures as Custom reports tab at the Dashboard.
• Extensively used variables to meet various requirements.
• Worked on set analysis and advanced aggregation functions.
• Implemented document event trigger and field event triggers.
• Implemented secure environment using QlikView Section Access.
• Worked on QlikView server and publisher to automate the QlikView jobs and define the user security and data reduction.
• Deployed QVW’s on the production server, Created Reload and Distribution tasks on QlikView Server/publisher.
• Troubleshot issues and reviewed log files to resolve the issues.
• Managed user’s access to the QlikView Server and QlikView Access Point.

ENVIRONMENT: QlikView11.0 (SR2), QlikView Server and Publisher (QMC), TOAD for Oracle Base 10.6.1.3, MS Excel, Windows 2008 Enterprise

SQL DBA

Confidential, CT

Respnsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model. 
• Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data
• feeds to/from data warehouse and claim systems. 
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server. 
• Created SSIS packages to export data from Oracle to SQL Server Database. 
• Performance: Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries. 
• Supported clustering and replication for servers. 
• Generated database SQL scripts and deployed databases including installation and configuration. 
• Responsible for tier 2 support for more than 10 SQL Servers in a 24x7 mission-critical/production environment. 
• Worked on CDC(Change Data Capture) 
• Maintained cluster servers to provide high availability. 
• Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from data warehouse and claim systems 
• Created and tuned stored procedures, triggers and tables. 
• Created several materialized views and UDF's to be accessed by the new front end applications. 
• Managed Materialized and Partitioned views for better performance. 
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases. 
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA 
• Provide 24 X 7 supports to all production, development, staging and clustered servers. 
• Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL on windows enterprise edition. 

ENVIRONMENT:  SQL Server with clustering, Replication, ETL, Sybase, T-SQL, Windows 64 bit,SQL/PLSQL, DTS.

Confidential

Respnsibilities:

• Converted Data Transformation Services (DTS) application to SQL  Server Integrated Services (SSIS) as assigned. 
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL  Server 2005 Integration Services (SSIS).  
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.  
• Configured load balancing, backup/recovery, sizing and space management, PL/SQL tuning, diagnostics, and proficient with the use of Oracle's Enterprise Manager Tool. 
• Worked on Migration of packages from DTS using SQL  Server Reporting Service (SSIS).
• Generated reports using SQL  Reporting Services (SSRS) for customized and ad-hoc Queries.
• Involved in creating calculated members, named set, advanced KPI'S for the SSAS cubes. 
• Experience with configuration, load balancing, backup/recovery, sizing and space management, PL/SQL tuning, diagnostics, and proficient with the use of Oracle's Enterprise Manager Tool.
• Designed and created the table schema and stored procedures that will be used in Data QC. 
• Integrated SharePoint Server with SSRS and deploying SSRS reports on to SharePoint Server. 
• Created and Maintained SharePoint Site for Issues Tracking and Reporting Weekly & Monthly Status & Metrics. 
• Designed and developed the Data QC Maintenance website that will be used to maintain the application tables, execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file. 
• Responsible for documentation of system related activities.
• Setup replication within the SQL  databases.  

ENVIRONMENT: DB2, SQL  Server, Enterprise, Windows Enterprise Server, BizTalk Server, Erwin, IIS 6.0, .NET, Erwin, Microsoft Visio, SFTP, Microsoft Reporting Service