SUMMARY

• 8+ Years of real time IT experience in Architecture, analysis, design, development and implementation of QlikView and QlikSense applications.
• Including 4+ years of experience as a QlikView Developer.
• Extensively worked on QlikView to implement applications as per client requirement
• Expertise in QlikView performance optimization.
• Strong experience in designing and developing dashboards using QlikView by extracting data from multiple sources (Oracle, Flat files, Excel, Access).
• Extensively worked on Data Analysis/Mining using QlikView.
• Worked on different QlikView objects like straight tables, line charts, bar charts and pivot tables Etc.
• Expertise in Installing and Configuring QlikView/QlikSense Desktop, QlikView/QlikSense Server, QlikView Publisher and also QlikSense Server.
• Designed and implemented the Incremental Loading using QVDs so that instead of reloading the entire data from the database, QlikView would only load the data worth of one day and concatenate it to the Old Data which is already stored in QVDs.
• Expertise on set analysis, advanced aggregation and section access.
• Hands on Experience with QlikView Architecture in development and deployment.
• Expertise in the Qliksense SDLC and governance.
• Extensive experience with QlikView sheet objects, scripting, and optimizing applications and building QVD’s and QVW’s.
• Extensive experience in using NPrinting for quick generation of reports and QlikMaps analytics engine.
• Can write and analyse complex SQL queries.
• Trained the end users effectively to use the reporting tool, to build and customize their ad - hoc reports.
• Strong understanding of Dimensional Modelling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, Automation and Macros interface, Section Access, Set Analysis in QlikView and DW concepts.
• Job roles include gathering business requirements, establishing functional specifications, translating them to design specifications.
• Extensive experience in using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading.
• Improved Performance of the queries by creating Clustered and Non Clustered Indexes and by optimizing the T-SQLstatements using MSSQLprofiler, Job Activity Monitor and Performance monitor.
• Developed Triggers, Stored Procedures and Functions for the custom database objects.
• Customized and optimized the existing stored procedures according to the Technical specifications and performed performance tuning on the existing stored procedures using performance monitor,SQLprofiler, query execution plan, Query Analyzer.
• Extensively used triggers, transaction in stored procedures which involves complex joins and Sub-Queries to simplify complex queries involving multiple tables.

TECHNICAL SKILLS

Dash boarding/Analytics: QlikSense, Qlikview 11.0/10.0/9.0 , Qliksense 2.0, Tableau, Microsoft SSRS, Cognos, Power BI, Tibco, Spot fire, Micro Strategy, Crystal Reports.

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

Database Technologies: SQL Server, Oracle 10g/11i, SQL Server, Toad, Teradata, DB2, MS Access.

ETL Tools: Informatica, Cognos, SSIS, SSRS

Operating Systems: Windows7/XP/Vista, Windows 2000/2003/2008 Server, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Sr. QlikView Developer/Admin

Responsibilities:

• Responsible for Building, publishing customized interactive reports and dashboards, report scheduling usingQlikViewserver.
• Experience in working withQlikViewserver to create data sources, creating users andQlikView installation and providing training to Business users in usingQlikView.
• Responsible to convert all business objects and excel reports toQlikViewreports and dashboards.
• Created metrics, attributes, filters, reports and dashboards, created advanced chart types, visualizations and complex calculations to manipulate the data.
• Experience in designing and deploying rich Graphic visualizations with Drill Down and Drop down menu option and Parameterization usingQlikView.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entireQlikViewdevelopment life cycle
• Worked with Dashboards style of reports using all theQlikViewcomponents like List Box, Slider, Buttons, and Charts etc.
• Developed Set Analysis to provide custom functionality inQlikViewapplications
• Worked towards optimal development of universe by resolving loops through the use of aliases and contexts.
• Created daily, weekly, monthly and quarterly reports for the management team based on the Customer requirements.
• Experience inQlikviewServer and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Involved in to create Hierarchies from providing dill down options for the end-user.
• Worked with Sheets and Sheet Objects inQlikView.
• Designed and delivered complex dashboards.
• Expertise in ETL (Data Extraction, Transformation & Loading), Data modelling, Report designing and Performance Tuning usingQlikView.
• Experience in all phases of project life cycle.
• Generate QVD files created by ETL logic to feedQlikViewapplications
• Experience in Incremental Loading &QlikViewdocument Versioning.
• Strong understanding of Dimensional Modelling technique, Multi-dimensional database Schemas like Star Schema, Snow flake Schema, Fact and Dimensional tables, Section Access, Set Analysis inQlikViewand DW concepts.

Environment: QlikView 13,QlikMaps, SQL Server 2008 R2, MS Access, MS Excel, Flat Files, Windows Server 2008, .PL/SQL, CSV Files.

Confidential, Atlanta, GA

Sr. QlikView (QlikSense) Developer

Responsibilities:

• Involved in the Requirements gathering, analysing, and documenting business requirements and data specifications.
• Implemented Star Schema & Snow Flake for Dimensional Data Modelling in QlikView and QlikSense.
• Responsible for theQlikViewDashboard & Report development, which includes dashboard design /QlikViewScript writing.
• Created optimized QVD's which loads faster and helps to improve the performance.
• Implemented 3-tier architecture different load scripts so that data stored as QVD's. ManyQVDfiles will be shared between applications build an elaborate structure.
• Distributed QV reports usingNPrintingin the form of Excel/PDF/Power Point/Word etc. to users through email or publish to a folder on the scheduled time.
• Experience in NprintingQlikviewReporting (NPrintingis the most advanced report generation, distribution and scheduling application forQlikview).
• Have experience with Master Data Dictionary creation and maintenance.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Developed the high-endvisualizationQlikviewDashboards usingQlikviewobjects.
• Built theSSISreports and extracted data UsingSSISand transformed & loaded into QlikSense.
• Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel and .Net.
• Developed reports in SQL Server Reporting Services (SSRS).
• Designing & developing of QlikView dashboards for Operations & Marketing business groups.
• Involved in full project life cycle implementation (requirement gathering to production) of QlikView/ QlikSense dashboards.
• Implemented the Various scenarios of section access and security levels.
• Creating dashboards by extracting data from database and externalize the load scripts, store the data as QVD files and designing the UI based on business/user requirements.
• Use of Set analysis and aggregation functions for sheet objects.
• Installing, configuring and maintaining the QlikView infrastructure.
• Used Set Analysis and various QlikView and QlikSense functions in writing expressions for sheet objects.
• Using QlikView and QlikSense functions such as Date and Time, Keep, Join, Mapping, and String & input Fields etc.
• Used QlikView Maps to show the reports and dash board for good visualization to the managers.
• QlikSense app performance optimization.
• Designed the QlikSense Governance and development cycle.
• Configured different QlikSense roles and attribute based access control
• Performed architecture, redesign of QlikView / QlikSense BI platform running 60+ dashboards that improving availability, scalability and performance to accommodate high volume data

Environment: QlikView 11.2, QlikSense3.2, NPrinting, QlikMaps, SQL Server 2008 R2, MS Access, MS Excel, Flat Files, Windows Server 2008, .CSV Files, Oracle 10g,SQL Scripting.

Confidential, Buffalo, NY

Sr.QlikView /Qliksense Developer

Responsibilities:

• Full life-cycle development and implementation of QlikView for a packaged Help Desk/Service Desk module. Involved in Analysis, design, installation & implementation of the BI solution. Converted and enhanced an older Oracle Discoverer BI solution and implemented QlikView.
• Use of Set analysis and aggregation functions for sheet objects.
• QlikSensedata modelling.
• Hands on experience in implementing the new features ofQlikSenselike Story Telling, Beta maps integrations, Pivot Table, KPI Object etc.
• QlikSenseapp performance optimization.
• Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView/QlikSense.
• Designed theQlikSenseGovernance and development cycle.
• Configured differentQliksenseroles and attribute based access control.
• Expertise inQlikSensedata modeling, master items and maps
• Extracted data from the database, stored into QVD files, and wrote load scripts.
• QlikView data modeling by building the Star schema and resolving loops/synthetic keys.
• Used QlikView Scripting and Complex SQL coding for loading, and transforming.
• Use of Set analysis and aggregation functions for sheet objects.
• QlikView dashboards optimization.
• Involved in analyzing existing complex systems to understand and document data elements, relationships, data flow, dependencies related interfaces and datavisualization.
• Strong working experience in Load script and Data modeling.
• Building the QlikView extensions.
• Working with all types of data loads and functions like Automap.
• Working experience with SQL/Server T-SQL,SSISand SSRS (MSBI).
• Enhanced existing dashboards with new functionalities and established a secure environment using QlikView Section Access.
• Implemented drill down and cyclic dimensions.
• Excellent knowledge ofJavaScript, CSS and their behaviour on different browsers.
• Extract, transform, cleanse, and load (ETL) data into Microsoft SQL Server, Staging Databases using MicrosoftSSIS.
• Developed dashboards for data analysis with strong programming skills.
• Creating dashboards by extracting data from database write and externalized the load scripts, store the data as QVD files.
• Use of Set analysis and aggregation functions for sheet objects.
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sourcesthere were 4 million records with incremental loading of … Enhancement and translation of the already existing Dashboards in Business Objects into QlikView.
• Debugging the QlikView server issues through server logs, Fiddler logs.

Environment: QlikView 10, QlikView dashboard, Qliksense 3,Business Objects, SVN, Oracle 10g/11g, Subversions, MS Access, MS SQL server, Agile Methodology.

Confidential, Libertyville, IL

QlikView Developer

Responsibilities:

• Creating dashboards by extracting data from database write and externalized the load scripts, store the data as QVD files.
• Experience in generating of QVDs.
• Experience in working withQlikViewFunctions.
• Experience in Incremental Loading to reduce the reload time ofQlikViewapplications.
• Developed Scripts to load the relevant Data inQlikViewApplications.
• Implemented set analysis inQlikViewApplications.
• Developed dashboards for data analysis with strong programming skills.
• Created QVD'S & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Data Extract would load the Data from the data sources into the QVDs, Data Model will define the relationships between the tables(QVD) and Application layer is User Interface Design layer where we layout all our Charts, Tables and List Boxes.
• QlikView data modeling by building the Star schema and resolving loops/synthetic keys.
• Performance tuning of dashboards was carried out to limit the response time to well under 5 seconds on calculation and defining server sizing for optimal performance ofQlikViewdashboards.
• Maintain tested applications for quality assurance and production support.
• Creating mock up with the sample data, created model with Extract, Transformation and Data Model in QlikView.
• Debugging the QlikView server issues through server logs, Fiddler logs.
• Developed SQL scripts to load business data and used VB macros and set analysis to create customized reports for regulatory reporting.
• Developed KPIs and set analysis application withQlikView functions (join, concatenate, keep, apply map).
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using theQlikView publisher.
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Expertise in working with multiple modules of business withQlikView.
• 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.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using theQlikView publisher.
• Stored the tables as QVDs and used Scripts to generate appropriate fields that help in modelling the data accordingly the requirements.
• QlikView data modeling by building the Star schema and resolving loops/synthetic keys.
• Implemented the Various scenarios of section access.
• Use of Set analysis and aggregation functions for sheet objects.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using theQlikView publisher.
• Working knowledge in SAP Business Objects (3.1, 4.0) and CMC.

Environment: Qlikview11, QV publisher, QV access points, QMC, QVWS, SQL server2008, CSS, HTML.

Confidential, Bloomfield, CT

Qlikview Developer

Responsibilities:

• Created and Monitored Batch processes and Sessions.
• Created Proof of Concepts, Prototypes, and Business rule documents.
• Designed and populated Time hierarchy, Geography hierarchy, and Transformation tables.
• Experience in Healthcare payer used in the transactions.
• Experience in medical claims and created reports on claims database.
• Used HIPAA rule for personal health information held by covered entities and gives patients an array of rights with respect to that information and also claim according to the plan benefits.
• Scheduling the created reports to users by creating Narrowcast Subscriptions and Services.
• Tested Micro Strategy Reports.
• Responsible for interacting with the Business Users regarding information about the Project Deliverables, and on finalizing System and Reporting Requirements.
• Highly involved in working with Multi-Dimensional Model, Star & Snow Flake Schemas and other Data Modelling and Data Warehousing applications.
• Responsible for designing and executing Application objects and Schema objects using Micro Strategy Desktop.
• Retrieving of external data toQlikViewDashboard in terms of QVDs by making connection through ODBC and OLEDB.
• Developed different types of dashboards usingQlikviewlike charts Bar charts, Line charts for Trend Analysis, Straight, Tables, Pivot Tables, Pie charts etc.
• Responsible for efficient design and usage of various attribute dimensions like Customer, Product, Payment, Geographic and Time dimensions, and integrating them into reports displaying forecasting metrics.
• Designed and deployed customized reports and Documents into Micro Strategy web.
• Highly involved in creating Advanced Reports in the desired formats (Grid, Graph, or SQL) involving multifaceted data analysis using Micro Strategy Desktop and Web.
• Responsible for improving the performance of the reports by efficient usage of Data Marts and Report Cache Sharing.
• Involved in extraction of data from different Sources like SQL Server, Oracle, Flat Files into Teradata Global Repository Database, using Informatics.

Environment: Micro Strategy 7.5 (Administrator, Architect, Desktop, Object Manager), SQL ServerInformatica, Oracle 9i, HTML & DHTML.

Confidential

SQL Server Developer

Responsibilities:

• Responsible for installation, configuration and maintenance of MS SQL Server on various environments
• Created various complex stored procedures for ETL as well as maintenance of the database
• Developed stored procedures and T-SQL code to accomplish various tasks
• Created the different user defined functions in the application.
• Created triggers, UDF, views, tables and generated T-SQL script for application and indexes for better performance.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
• Monitoring nightly ETL process from various highly different source systems. Sources included SQL based databases and Excel Files. Also ensured that nightly backup jobs or other ETL jobs didn’t interfere with each other.
• Tuned SQL statements and Stored Procedures.
• Posted HTML files to server and updated database and returned the response back to ASP.NET.
• Involved in designing and creating Web UI screens using ASP.Net.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Combined a few simple, unrelated Database Accesses to improve performance.
• Managing disk space on Windows NT systems.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server 2000, DTS, .NET Framework, HTML, MS Excel, MS Access, SQL, Visual Basic 5.0, ASP/VB.NET