SUMMARY

• 7 years of IT industry experience involving in ETL, Designing and development of business Intelligence tools like QlikView and SQL.
• Experience covers all aspects of business Intelligence applications with strong background in developing a database and Data warehouse support systems.
• Expertise in configuringQlikViewServer,QlikViewPublisher andQlikViewDesktop and upgrading to the existing versions.
• Experience in sourcing data from disparate systems with a good understanding of their Data models and ETL procedures.
• Ability to offer end - to-end solutions starting from requirements gathering, design, development and deployment of Business Intelligence applications.
• Experience in implementation of BI projects especially in creating KPI’s, reports and dashboards.
• Experience in design and development ofQlikViewfor OLTP and OLAP Systems.
• Experienced in QlikView/ QlikSense visualization and storytelling skills.
• Experience with Creating QVD's and Scheduled jobs for QVD extracts and report loads.
• Well versed withStar and SnowflakeSchemas and loading techniques which includes Incremental, Buffer and Binary loads.
• Good Understanding of QlikView/QlikSense integration issues.
• Experience in creating scripts to resolve circular loops, Synthetic keys and Modeling issues in QlikView.
• Experience in Implemented security using Section Access to restrict unauthorized access in the dashboards depends upon user privileges.
• 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.
• Used various SSIS components or tasks to create a package to handle data flow.
• Strong working knowledge ofQlikView scripting, set analysis, aggregation functions, multi-dimensional objects and layout including chart properties and formats.
• Experience in using Mashup API’s for building client servers and web sites.
• Hands on Creating different templates in Nprintingfor daily distribution of reports.
• Hands on Tableau for creating ad hoc reports.
• Expertise in using Excel in framing VLOOKUP’s, subtotals & conditional formatting.
• Hands on using Section access, set analysis, Access point to provide customized functionality in Qlik
• Experience in creating scheduled jobs through QlikView management console(QMC) for QlikSense.
• Experience in importing the data, removing the data & updating the data from various databases.
• Expertise in reducing the complexity using different methods like using Macros, Set Analysis, Joins, Keep's and Mappings usingQlikView.
• Experience in writing SQL queries, Functions, Views and Stored procedures.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules. Very good Team Player.

TECHNICAL SKILLS

BI Tools: QlikView10/11, Tableau9.0, QlikSense1,2. 2, 3, QlikView Publisher, Nprinting 16.2.

Databases: MySQL, Teradata 14.0, MS SQL Server, Oracle, Toad,MS Access, DB2.

Web Technologies: HTML, Java Script, VB Script, Servlets.

Operating Systems: Windows, Linux & Unix.

Languages: C, C++, SQL, Shell Scripting, PHP, HTML, PL/SQL.

Other Tools: Informatica, MS Visual studio 2008, Salesforce, SSIS, SQL Loader, MS-Excel, MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Woonsocket, RI

Qlikview/Qliksense Developer

Responsibilities:

• Involved in Extracting and loading the data from various sources in to QlikView.
• Created buttons, List boxes, Multi boxes, slider, charts, text objects, bookmarks, etc.
• Implemented Set Analysis to provide the custom functionality in Qlik Applications.
• Eliminated circular loops& synthetic keys in the data model.
• Extensively used Excel for weekly rollout reports.
• Hands on Tableau in creating ad hoc reports.
• Installed and configured QlikSense server on the new machines.
• Worked with QlikView Mashup and workbench for QlikSense dashboards using Eclipse IDE.
• Extensively used Pivot tables for representing the multiple dimensions in the analysis of data.
• Involved in training sessions and prepared documentation.
• Used Incremental load to update the new data in Qlik document.
• Developed dashboards using different QlikView objects like Bar chart, PI chart, pivot table, container etc.
• Involved ininserting the data in the Database. Extracted data from Teradata and stored into QVD’S
• Used set analysis to compare performance between varying time periods, geographic region, and product lines.
• Extracted data from Teradata and stored into QVD files.
• Developed reports using QlikSense and Angular JS QVAngular Module templates and filters.
• Hands on appending the data & queries in the Access database.
• Implemented 3 Tire architecture in deploying QlikView application.
• Involved closely with users when creating the visualization for reaching the expectations.
• Developed mockup dashboards while the client is migrating from Tableau to QlikView.
• Involved in managing data and maintaining the QVDs And QVWs in QlikView deployment.
• Used QMC for configure tasks and publish the QVW files

Environment: QlikView 11, Qliksense 3.0, Teradata 14.0, Excel, MS Access, Tableau 9.0, Informatica, Oracle, MySQL.

Confidential, Farmington Hills, Michigan

Qlikview/Qliksense Developer

Responsibilities:

• Involved in requirements gathering, analyzing, and documenting business requirements and data specifications
• Involved in extracting, transforming and loading data from sources into Qlikview/Qliksense applications
• Worked on deployment of Qliksense/Qlikview dashboards from Dev to UAT and UAT to PROD
• Worked extensively on complex Data models as per client requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Created scheduled jobs through QlikSense management console (QMC).
• Extracted data from the database and stored into QVD files.
• Created Complex data model with necessary fact tables and dimension tables.
• Extensively used Qlik functions such as Date and Time, Keep, join, Concatenate, Mapping Load, Inline Load etc.
• Assist with QlikSense Server integration issues.
• Connected to oracle database using ODBC and OLEDB data sources and tables
• Analyzed the existing QlikView data model, script logics and the ETL business logic for the existing QlikView applications using Document Analyzer.
• Executed the scripts and checked the incorporated script changes in the application.
• Developing Set Analysis to provide the custom functionality in QlikView Applications.
• Implemented incremental load for the Update of QVD’s.
• Supported in modifying, testing and implementation of existing reports.
• Developed different dashboard with a complex database system which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI per user requirements.
• Used set analysis to compare performance between varying time periods, geographic region, product lines, etc.
• Created different templates in nprinting for daily distribution of reports
• Worked on nprinting trouble shoots.
• Implemented security using section access that dynamically hides selected areas of dashboard depending up on user privileges
• Created Objects like List boxes, Multi boxes, slider, buttons, charts, text objects, bookmarks, etc.
• Developed graphs and pivot tables to summarize the outlying data points to perform exploratory data analysis.
• Worked with Business Analyst and the Business user to understand the user requirements, layout, and look and feel of the application to be developed.

Environment: Qliksense 2.2, Qlikview 11, Nprinting 16.2, Oracle 11g, SQL Server, Informatica Power Center.

Confidential, Reston, VA

QlikView/Qliksense Developer

Responsibilities:

• Understanding business requirements and translate into application and operational needs using QlikView/QlikSense
• Worked on the documentation for application development.
• Installed and configured QlikView Server Small Business Edition.
• Involved in extracting, transforming and loading data from sources into QlikView/QlikSense applications
• Generated ODBC Connections to extract from data bases and store them in QVDs.
• Extracted data from multiple data sources (SQL Server, Excel) and designed data model.
• Implemented Star Schema and Snow Flake schema in designing the data model.
• Used Link Tables to avoid circular reference and Loop issues.
• Developed Dashboards using differentQlikViewObjects Line Chart, Bar Chart, Gauge Chart, Pie Chart, List box, Multi box, Table Box, Container etc.
• Implemented Security involved in Deployment ofQlikViewApplications.
• Extensively implemented advanced SET Analysis for aggregation calculations.
• Automated and Scheduled data loads and Dashboard Applications weekly and Notifications by email to assigned users using Server.
• Hands on creating templates in Nprinting for daily distribution of reports.
• Worked on deployment of QlikSense dashboards from Dev to UAT and UAT to PROD
• Modified Existing Login page to Access point to Client Specific Login Page.
• Experience in working with Nprinting trouble shoots.
• Responsible for the performance and tuning of the application, including performing maintenance upgrades on applications programs and systems as required.
• Converted Excel and crystal reports toQlikViewdashboards.
• Experience in reporting activities which involved Business score card, sales and operations report.
• Coordinated with Business users in development process to integrate with the Test and Production Servers and helped creating use cases.
• Involved in User Training Sessions and Preparing Documentation.

Environment: QlikView10/11,QlikSense,Informatica,HTML, Excel, MS Access, Oracle 11g, SQL Server 2008.

Confidential, San Francisco, CA

QlikView Developer

Responsibilities:

• Extracted the data from various data sources such as databases, Excel documents and CSV files, transforming the data into standard format and load the data so that it is available for analyzing and creating reports.
• Finding and Understanding the essential data, eliminating the data which doesn't suit the requirement.
• Designed and development of QlikViewplatform to integrate with Expandable Databases.
• Generated ODBC and OLEDB connections to extract data.
• Imported Data from Multiple data sources which also includes Web files, MS-SQL Server, MS-Excel through OLEDB and ODBC connections, Text, CSV files.
• Converted excel and crystal reports toQlikView.
• QlikViewImplementation and Integration.
• Wrote SQL Scripts to load relevant data inQlikViewApplications.
• Implemented advanced SET analysis for aggregation calculations.
• DevelopingQlikViewsolutions and utilize them to develop complex reports and executive dashboard.
• Extensively used MACROS, Set Analysis and experience in creating expressions.
• Developed Dashboards using differentQlikViewObjects Line Chart, Bar Chart, Gauge Chart, Pie Chart, List box, Multi box, Table Box, Container etc.
• Documented Architectural Concepts and technical specifications.
• Create and ManageQlikViewScripts.
• Creating the data models, handling synthetic keys and circular loops.
• Experience in reporting activities which involved Business score card, sales and operations report.
• Involved in Training Sessions and prepared documentation.
• Implementing the reload tasks and distribution tasks using theQlikViewpublisher.

Environment: QlikView 10, MS Access 2005, Salesforce, Windows 2000 Server,SSIS, Informatica Power center 8, Oracle 10g.

Confidential

SQL Developer/Data Analyst

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of end user requirements and system specifications.
• Modified SQL queries and appended the data in databases.
• Identify, propose and implement enhancements over the existing reports to improve user experience.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Ensured that weekend data loads, end-of-month & end-of-quarter processing ran successfully and completely, transparent to user community.
• Defined requirements for a daily feed of fund performance data from the fund data warehouse, coordinated systems testing, and supported UAT.
• Generated weekly reports by filtering the data
• Gathered requirements and managed the implementation of a private, secure ftp site allowing authorized print vendors to download files containing sensitive shareholder information.
• Worked with client and off shore team to make sure that the reports and dashboards are delivered on time.

Environment: Oracle, SQL Server 2007, MS Access, Salesforce, PL/SQL, MS Excel, and MS Visio.