SUMMARY:

Over 8 years of experience as QlikSense/QlikView expert with Development and Administration skills. Business intelligence skill includes design, development and administration in SQL Server.

TECHNICAL SKILLS:

BI tools: QlikSense, QlikView

Databases: MS SQL Server 2008/2005/2000 , MS Access, mysql, DB2, Informix

ETL tools: SSIS

Programming: .NET, SQL, T - SQL, and PL/SQL, HTML, XML

EXPERIENCE:

QlikSense/Tableau Developer

Confidential, Boston, MA

Responsibilities:

• Develop Tableau workbooks from multiple data sources using Data Blending, create action filters, parameters and calculated fields and sets for preparing dashboards and worksheets in Tableau.
• Migrated majority of QlikView applications into QlikSense and smoothly transitioning users to QlikSense.
• User training for dashboard development under Self Service BI model to onboard power users.
• Used d3 visualization library (d3vl) with QlikSense extension to achieve goal of how this d3 charts easily integrated.
• Tested debugged and deployed existing QlikSense extension.
• Built and created custom QlikSense Infrastructure Monitor with attention to details.
• Developed a dashboard for Sales team to determine the pricing of current parts depending on different factors.
• Provided User training for dashboard development under Self Service BI model to onboard power users and help them build complex dashboards with KPIs, SET ANALYSIS and provide custom functionality in QlikSense Applications.
• Built dashboards for newly on - boarded users, Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimizing reports.
• Trained end users to develop and use QlikSense applications.
• Handled the end-to-end implementation of Qliksense dashboard deployment.
• Installed and configured QlikSense and Scaled up both reload and user loads in internal production deployment to build multi-node (6 nodes) QlikSense servers keeping capacity and resilience in mind. Implemented QlikSense Security. Evaluated QlikSense as Self-Service BI tool for business users. Built 2 executive dashboards and successfully migrated 4 from QlikView.
• Gained experience in using QlikView functions (Date and Time, Keep, Join, Mapping, input Fields etc.)
• Utilized Set Analysis to create custom functionality for users. Implemented section access to give access of these reports to only a certain number of users and developers
• Integrated Autosys with QlikView publisher using EDX based tasks.
• QlikView Administration from server/desktop installation to server clustering and horizontal scaling.
• Applied Mapping Function to eliminate certain dimension tables and reduce the clutter in the QlikView data model.
• Rebuild dashboard applications on both frontend UI and backend, developing scripting templates, UI design and coding standards, design guidelines, migration strategy and implementation plan.
• Extensively worked on QlikView Set Analysis, Macros and advanced Aggregate Functions to provide custom functionality.
• Implemented Section Access, Section Authorization and Sheet access to make the application available to desired users.
• Utilized Loop/Reduce functionality for creating multiple documents and distributed based on Section Access user privileges both by using Field and Bookmark criteria.
• Incorporated Comparative Analysis and Adhoc Analysis as per the requirement.

QlikView Developer

Confidential, Waltham, MA

Responsibilities:

• Multiple tier of QVD architecture is implemented depending upon the complexity of the application and the final application reload duration was 4 Hours.
• The application is used by 46 Named CALs and 30 Document CALs licensed users with additional session licensed users as needed.
• Task set up are done using QEMC and created architecture for the interdependent applications and execute in proper order.
• Create BI solutions including Executive Dashboards and Business Scorecards with MS Excel, BI solutions including ETL, OLAP, and Reporting Requirements, detail and summary reports, line and Pie Charts, trend analysis reports and sub reports using SQL Server 2000 Reporting Services (SSRS).
• Responsible for DB performance tuning / trouble-shooting of database related software. Tuned long-running SQL queries to cut execution time, ease database load and improve scalability. Developed DTS packages to ETL DW from OLTP database and flat file sources.
• Designed & developed various SSIS packages (ETL) to extract & transform data & involved in Scheduling SSIS Packages.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Played Key role in team of ETL developers for re-writing DTS packages and updating them to SSIS packages.
• Consult with both client and internal team to understand data requirements, sources, and flows.
• Work with clients in resolving data hygiene and/or configuration issues.
• Configure system and troubleshoot data loads.
• Ad hoc excel reports are created based on the business user requirements.

QlikView Developer

Confidential, NYC

Responsibilities:

• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Design, Develop, Test, debug and implement QlikView solutions based upon specified requirement.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimizing reports.
• Used QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.)
• Worked on T-SQL skills in creating stored procedure, functions, views, triggers.
• Collaborate with business users and analysts to validate business requirements and translate them into technical specifications.
• Document Business Requirements (BRDs) and Report specifications technical Designs (TDDs)
• Developed standard and ad hoc reports using IBM Cognos Report Studio and Business Insight Advanced tools
• Added Drill Through, Drill Up and Drill Down functionality to the reports using Report Studio
• Added advanced functionality to Prompts using Cascading property and use of style and render variable properties.
• Wrote SQL Queries for validating the reports against EDW and back end databases
• Generated new QVD files from the EDW by writing scripts in QlikView applications. Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys.
• Developed KPIs, SET ANALYSIS to provide custom functionality in QlikView Applications
• Create PDF push reports using QlikView report editor
• Develop, troubleshoot and fine tune existing and new reports
• Troubleshoot data integration issues and bugs, analyze reasons for failure, implement optimal solutions, and revise procedures and documentation.
• Develop detailed technical specifications and ETL documentation in collaboration with data analysts and Business Intelligence developers
• Worked with the team to identify the business reporting needs and studied current reporting practices outside of QlikView through pivot tables.
• Participated in business requirement document preparation.
• Performed redesign of the existing QlikView BI associative model to improve availability, scalability and performance by eliminating Synthetic keys and Circular Loops in the data model.
• Applied Mapping Function to eliminate certain dimension tables and reduce the clutter in the QlikView data model.
• Rebuild dashboard applications on both frontend UI and backend, developing scripting templates, UI design and coding standards, design guidelines, migration strategy and implementation plan.
• Developed scripts for data reloading, mapping and transformation by using joins, concatenations, resident loads and temporary tables.
• Extensively worked on QlikView Set Analysis and advanced Aggregate Functions to provide custom functionality.
• Experienced in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS)
• Implemented Section Access, Section Authorization and Sheet access to make the application available to desired users.
• Utilized Loop/Reduce functionality for creating multiple documents and distributed based on Section Access user privileges both by using Field and Bookmark criteria.
• Incorporated Comparative Analysis and Ad-hoc Analysis as per the requirement.