SUMMARY:

• 4 years of experience in Designing and development of business Intelligence application with Qlikview
• Experience covers all aspects of business Intelligence applications with strong background in developing a database and Data warehousing support systems.
• Expertise in configuring Qlikview Server, Qlikview Publisher and Qlikview Desktop 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 end to end implementation of BI projects especially in creating KPI’s, reports and dashboards.
• Experience in design and development of Qlikview for OLTP and OLAP Systems.
• Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys& Modeling Issues.
• Experienced in Qlikview/ Qliksense visualization and storytelling skills
• Experience with Creating QVD's and Scheduled jobs for QVD extracts and report loads.
• Well versed with Qlikview Schemas like Star and Snowflake Schemas and loading techniques Incremental, Buffer, Preceding, and Binary loads.
• Good Understanding of Qlikview/Qliksense integration issues.
• Experience in creating scripts to resolve circular loops, Synthetic keys and Modeling issues inQlikview.
• Implemented security using Section Access to restrict untheorized access in the dashboards depends upon user privileges.
• Experience in using Mashup API’s for building client servers and web sites.
• Hands on Creating different templates in nprinting for daily distribution of reports
• Hands on Tableau for creating ad hoc reports.
• Expertise in using Excel in framing VLOOKUP’s, subtotals & conditional formatting.
• Extensive knowledge in Sheet objects, Charts, exporting the reports to MS-Excel, handling the variables and aggregated functions of Qlikview.
• Hands on using Section access, set analysis, Access point to provide customized functionality in Qlik
• Experience in creating scheduled jobs through Qlikview management console 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 using Qlikview.
• 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

TECHNICAL SKILLS:

BI Tools: QlikView 10/11,Tableau 9.0, QlikView Publisher, QlikSense 2.24, nprinting 16.2.

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

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

Operating Systems: Windows, Linux & Unix.

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

Other Tools: MS Visual studio 2008, SQL Loader, MS-Excel, MS Access, MS Office.

WORK EXPERIENCE:

Confidential, Woonsocket, RI

Qlikview Developer/Reporting Analyst

Roles and Responsibilities:

• Involvedin extracting, transforming and loading data from sources into 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.
• Extensively used Pivot tables for representing the multiple dimensions in the analysis of data.
• Involved in Training Sessions and prepared documentation.
• Developed Dashboards using different Qlikview Objects like Line Chart, Bar Chart, Pivot table, Pie Chart, Container etc.
• Used Incremental load to update the new data in Qlik document.
• Involved in updating and inserting the data in the Database.Extracted data from Teradata and stored into QVD files.
• Used set analysis to compare performance between varying time periods, geographic region, and product lines.
• Extracted data from Teradata and stored into QVD files.
• 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, Teradata 14.0, Excel, MS Access, Tableau 9.0, SQL Server, MySQL.

Qlikview/Qliksense Developer

Roles and Responsibilities:

• Involved in requirementsgathering, analyzing, and documenting business requirements and data specifications
• Involvedin 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.24, Qlikview 11, nprinting 16.2, Oracle 11g, SQL Server, Informatica Power Center, PL/SQL Developer,

Qlikview/Qliksense Developer

Roles and Responsibilities:

• Understanding Business requirements and translate into Application and operational needs using Qlikview reporting tool.
• 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 different Qlikview Objects Line Chart, Bar Chart, Gauge Chart, Pie Chart, List box, Multi box, Table Box, Container etc.
• Worked with Alternate States to distinguish the selections for different charts with in a sheet.
• Implemented Security involved in Deployment of Qlikview Applications.
• 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.
• 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.
• 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 to Qlikview dashboards.
• 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: Qlikview 10/11,Qliksense 2.0, Oracle 10g, SQL Server 2008, SQL, HTML, Excel, CSV Files.

Qlikview Developer

Roles and 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 Qlikview platform 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.
• Participation in enterprise BI strategy developments.
• Converted excel and crystal reports to Qlikview.
• Qlikview Implementation and Integration.
• Wrote SQL Scripts to load relevant data in Qlikview Applications.
• Implemented advanced SET analysis for aggregation calculations.
• Developing Qlikview solutions and utilize them to develop complex reports and executive dashboard.
• Extensively used MACROS, Set Analysis and experience in creating expressions.
• Developed Dashboards using different Qlikview Objects Line Chart, Bar Chart, Gauge Chart, Pie Chart, List box, Multi box, Table Box, Container etc.
• Documented Architectural Concepts and technical specifications.
• Create and Manage Qlikview Scripts.
• Creating the data models, handling synthetic keys and circular loops.
• 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 Training Sessions and prepared documentation.
• Implementing the reload tasks and distribution tasks using the Qlikview publisher.

Environment: Qlikview 10, MS Access 2005, Windows 2000 Server Informatica Power center 8.6, Oracle 10g.

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.
• 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.
• Managed the development of a reporting capability of current and historical fund performance prices made available on restricted web sites for viewing by client customers.
• Defined requirements for a daily feed of fund performance data from the fund data warehouse, coordinated systems testing, and supported UAT.
• 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, Visio, Test Director, MS Excel, and MS Visio.

SQL Developer

Roles and Responsibilities:

• Responsible for installation, configuration and maintenance of MS SQL Server on various environments.
• Analyzed business requirements and coordinated with the business analyst to develop ETL procedures that confirm to the enterprise standards while maintaining consistency across all applications and systems.
• Developed stored procedures and T-SQL code to accomplish various tasks.
• Created the different user defined functions in the application.
• Prepared Business Requirement Specification that gives the comprehensive details about the requirements.
• Created various complex stored procedures for ETL as well as maintenance of the database.
• Developed and modified scripts to create tables, views and executed them using SQL plus.
• Created SQL loader control files for moving the data from flat files to staging area tables.
• Used PL/SQL tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process and oracle objects including collection, types and creating objects
• Prepared the procedures to update the internal structures to reflect the newly loaded data.
• Transformed data from various data sources using OLEDB connection by creating various DTS packages.
• Worked under the supervision of DBA and created database objects such as tables, views and sequences
• Used Different functions such as Data & Time, Conditional, Aggregation functions, Analytic Functions.

Environment: Oracle 9i, TOAD, SQL Navigator, UNIX, Informatica power center manager.