SUMMARY

• 5 plus years of experience in IT involving Business Requirement Analysis, ETL, Data Modeling, Implementing Business Intelligence Applications using various tools like, QlikView and SQL, PL SQL.
• Expertise in Developing QlikView Applications using QlikView using different data sources like Oracle, SQL Server, Text files, Excel documents and generated different Dashboards as per the user requirement.
• Experience in using sheet objects of QlikView like List Boxes, Multi Boxes, Tables, Charts, Current Selection Boxes, Buttons, Calendars, Data Islands and experience in editing scripts for creating variables, fields, and calculated expressions, basic and aggregated functions.
• Experience in developing different analytical applications using QlikView suite of Products (QlikView Desktop, QlikView Server, QlikView Publisher and QlikView Enterprise Management Console).
• Used QlikSense to generate immediate analyses and insights for reporting from mobile platform.
• Strong experience in implementing dashboards in QlikSense using latest features like Data mart and data profiling.
• Strong experience in QlikView with data modeling, analysis, design, testing, development and implementation of client/server applications, administration of QlikView for OLTP and OLAP Systems.
• Strong Experience in Extract, Transform & loading (ETL) data in QlikView Applications & Develop Data models using Star Schema & Snow Flake Schemes.
• Strong working knowledge of QlikView scripting, set analysis, aggregation functions, multi - dimensional objects and layout including chart properties and formats.
• Working knowledge of QlikView applications using QlikView Data (QVD) files, different Databases and creating reusable variables.
• Managed user's access to the QlikView Server and QlikView Access Point.
• Created ad-hoc and dynamic reports.
• Involved in the financial cost modelling and created data models. Expertise in the Qlik Sense SDLC and governance.
• Experience in reviewing and analyzing the Business Processes, Business Process Flows and implementing QlikView Solutions.
• Created different publisher tasks like reload tasks, reduction tasks and distribution tasks using QlikView Management Console.
• Expertise in ETL (Data Extraction, Transformation & Loading), Data modeling, Report and Performance Tuning using QlikView.
• Expertise in working with DWH and business intelligence tools for developing various reports using QlikView BI.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in designing, developing, testing, publishing, maintaining and supporting QlikView and QlikSense applications
• Developed applications in QlikSense Desktop as well as in the QlikSense Hub and shared the apps with the team through QlikSense Cloud.
• Maintenance of data in form of QlikSense data files, pulling the data from relevant database
• Created QlikSense Dashboards as a Migration Project and Source change as well, including extension Object.
• Wrote SQL Scripts with preceding Loads to extract relevant data in QlikView Applications.
• Extensively worked with SQL Queries, and capable of handling SQL Server, MS Access databases and have good experience in database tuning and performance techniques.
• Designed graphs and visuals to summarize data, identify outlying data points, and perform other exploratory data analysis.
• Excellent understanding and expertise in writing complex SQL queries to perform backend testing and strong Database Development skills using SQL Server 2008.
• Business Analysis experience with excellent communication & interpersonal skills and broad understanding of business operations and requirements.

TECHNICAL SKILLS

BI Tools: QlikView, QlikSense, QlikView Server/Publisher, SSRS, Cognos, Micro Strategy

Operating Systems: Microsoft Windows, XP, 7, 8.1, 10, Ubuntu

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

Databases: Oracle TOAD, MS SQL Server, Teradata, MS Access 2000, Excel, DB2, SAP BW

Data Modelling Tools: Erwin 9.x, M.s Visio.

Web Technology: HTML, Java Script, VB Script

PROFESSIONAL EXPERIENCE

Confidential - Norwalk, CT

Senior QlikSense Developer

Responsibilities:

• Involved in gathering the Business requirements and developing the dashboards.
• Implemented and managed section access and security by implementing Section Access and tested the module in production.
• Created story board, user stories and documented for existing apps.
• Worked on QlikView Server and Publisher, to manage user access, schedule refreshing of documents, mount completed applications. Applications were refreshed monthly and used by a group.
• Worked in both ETL and UI of QlikSense.
• Populated Metrics in the master library required for developing the apps.
• Migrated existing apps in QlikSense 2.2 to QlikSense 3.0 and tested their performance.
• Developed different kinds of widgets using HTML & CSS in QlikSense 3.0.
• Installed all the extensions in QlikSense 3.0 in the QMC and used them in creating various visualizations in different apps.
• Designed the Qlik Sense Governance and development cycle.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Developed SQL script through Oracle Toad and exported the data for loading into QlikSense.
• Worked on the front end of Micro strategy for creating users, providing access and pulled data to the Qlik Schema.
• Configured and installed all the required extensions along with other extensions based on the requirements by using HTML and Java scripting.
• Loaded the Java Scripting file for creating widgets in the widget editor and configured them into QlikSense.
• Involved in preparing the Business Requirement Document (BRD).
• Created Tasks for reloading of QlikView data to QVDs and QVWs through QMC.
• Developed QlikSense Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, Statistics Box, Multi Box and Calendar & Date Island.
• Experience in developing dashboards using different inbuilt QlikSense API's.
• Developed complex SET ANALYSIS to provide custom functionality in QlikSense Applications.

Environment: QlikSense 3.0, Oracle TOAD, HTML, CSS, Micro Strategy, QlikSense Server/ Publisher, Windows 2003 Server/XP, PL/SQL, MS Excel 2013.

Confidential, Atlanta, GA

QlikView Developer

Responsibilities:

• Responsible for gathering Business Requirements and defining KPIs.
• Recommended and helped to create Multi- Tier QVD architect depending upon applications, which include maintains the QMC, configure tasks; manage the licenses, Implemented Security for applications (Included Section Access, Dynamic Data Reduction and Document level security).
• Performed data validation and worked with users through the UAT cycle. Dashboard was subject to rigorous testing to ensure that data, functionality, look and feel, and performance complied with user requirements.
• Trained QlikView Users in the company on using QlikView and create objects for the daily Business use.
• Created Excel, Word, Power Point reports from QlikView Dashboards and distributed to the users using NPrinting.
• Created tasks for the auto reload/using create task wizard via QMC for couple of applications and Batch files (on servers) and used them to auto reload the QVW's while automating the ETL process.
• Created jobs and scheduled to send daily pdf reports for the user upon reload using NPrinting.
• Used QV Source to generate the QlikView load scripts to download the data from Cloud system like Google Drives, FTP servers, Dropbox services.
• Involved in preparing the Business Requirement Document (BRD).
• Used QlikSense Dev hub to connect to different tools like single configurator, Extensions Editor, mashupeditor.
• Implemented triggers to start the reload task when loading in database completes using batch script.
• Creating Tasks for reloading of QlikView data to QVDs and QVWs through QMC.
• Created customized gauge charts to show the Actual VS Plan for the KPI scores for all the LOBs.
• Implemented Best Practices & Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys in QlikView.

Environment: QlikView 11, QlikView Server/ Publisher 11, NPrinting, Windows 2003 Server/XP, PL/SQL, SAP Connector, MS Access 2007, MS Excel 2010, TOAD.

Confidential - Alpharetta, GA

QlikView Developer

Responsibilities:

• Developed User Interactive Sheets & Reports as business needs.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks. Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Developed Linked Tables, Concatenation (Resolving Loops & model ambiguity).
• Gathered & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files).
• Worked with QlikView administrator to optimize QlikView performance.
• Generate new QVD files created by ETL logic to feed QlikView applications.
• Included the enhancement scripts to the existing QV scripts and performed the actual load to test the overall functionality of the application.
• Coordinated with ETL team and performed integration testing to check data discrepancies.
• Automated QlikView jobs in QlikView Publisher and rolled out to QlikView Access Point and administered Security using Active Directory.
• Analyzed the existing QlikView data model, script logics and the ETL business logic for the existing QlikView applications.
• Executed the scripts and checked the incorporated script changes in the Application.
• Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques.
• Published Client application using QlikView Publisher and rolled out to Shared Drive with security permissions using Active Directory features.
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Developed SQL Scripts in validating data from different data sources.

Environment: QlikView 10 x, Windows 2000 Server, Oracle 10g, MS Access 2005, MS SQL Server 2005, MS Office.

Confidential

SQL Developer

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users.
• Actively involved in developing logical design of database, incorporating new business requirements, and implemented the new design into SQL Server 2000.
• Deeply involved in Data Migration from Oracle Database and flat files into SQL Server 2000 using MS DTS Packages and BCP.
• Wrote complex T-SQL statements to ensure data consistency by filtering corrupt data and implemented various Constrains and Triggers to preserve data integrity.
• Created indexed generic views to facilitate easy user interface implementation, Security, and Triggers on them to facilitate consistent data entry into the database.
• Wrote complex Stored Procedures to balance the processing load between front end and back end.
• Implemented batch processing for approval process using Jobs and DTS.
• Created Stored Procedures for Automatic Scripting to backup transaction logs, flush/grow/shrink log files, maintain archive of objects.
• Identified, tested, and resolved Database Performance Issues (monitoring and tuning) to ensure database optimization.

Environment: SQL Server, Oracle database, SSAS, MS- Excel, MS-Access, T-SQL

Confidential

SQL Developer

Responsibilities:

• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created and when required, modified already existing stored procedures, triggers, views, indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Tested queries to optimize the procedures and triggers to be used in production.
• Used SQL Developer to Load / Extract data into and from Excel files.
• Used Hints, Explain Plan, and Indexes for query tuning and optimizations.
• Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.
• Cleaned the data and created fact and dimension tables, performed calculations required for the reports using SQL Server environment and accomplished data modeling.
• Created dynamic Reports from the cube using SSRS 2005, and stored procedures.
• Troubleshoot the deployment of reports in the test and production environment using SSRS.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent using SSAS.
• Collaborated with Data Warehouse in impact analysis to crystal reports.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.

Environment: MS SQL Server 2005/2008, SQL server reporting Services 2008, SQL Integration Services2008, SQL Analysis Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel.