PROFESSIONAL SUMMARY:

• 7+ years of working experience in IT industry as BI Developer, Tools including QlikView, Nprinting, Qlik Sense and Tableau with strong background in Databases and Data warehousing concepts.
• Over 5 + years of Business intelligence and analytics experience with strong experience on QlikView to develop, design and support reports, dashboards and scorecards for a variety of business users.
• QlikTech Certified Professional in Qlikview Development & Design.
• Excellent knowledge in designing and developing dashboards using QlikView by extracting the data from multiple sources (Flat files, Excel, Access, SQL server, Oracle).
• Involved in Performance Tuning and Deployment of QlikView Applications.
• Involved in creating Dashboards using Qlikview, Tableau and Hyperion.
• Created Dashboard’s using multiple BI Tools with Drill - Down capabilities using Dashboard prompts, Local and Global Filters.
• Experiencein training Business users through online and in-class sessions.
• Excellent understanding of concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Teradata, MS Access and client/server applications.
• Having working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Having strong analytical, logical, Communication and problem solving skills. Ability to adapt to new technologies by self-learning.
• Experience in Insurance, Pharmaceutical, Educational, Banking and Financial Service, Tele Communication Domains and ability to analyze big data.
• Designed and developed the most suitable User Interface such as Dashboards, Multiple charts types, Trends, KPI’s, custom requests for Excel Export and objects for Management Dashboard reporting.
• Hands on experience in QlikView Installation, Configuration.
• Experience in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Experienced in implementation of QlikView security by authentication, authorization at document level and data level to the end users.
• Involved in maintenance of Qlikview services, Servers, Log files.
• Maintaining LADP and ADP group’s users to provide the shared folder access and dashboard access.
• Experience in Providing the Doc admin access and user licenses and
• Hands on experience in handling the access point issues.
• Experience in Migration of applications from Test Environment to Production environment.
• P roficient in creating QV data models, QV objects, reports, graphical interactive UI and dashboard using different data sources like Oracle, SQL Server, QVD files, Access, text files, excel documents etc. as per the user requirement.
• Ability to work independently, excellent communication and strong team-building management skills.
• Expertise in ETL (Extraction, Transformation and Loading), Data modeling and Report designing using QlikView.
• Good knowledge on Data Quality Assessment & Data Cleaner Tool, Data Model Creation. Written SQL queries to test the OLTP & OLAP Databases based on changes of the functionality.
• Knowledge on SSAS/SSIS and Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.
• Extensively worked on databases like Oracle, SQL Server, DB2, and Teradata. Strong programming and debugging skills in PL/SQL, SQL and UNIX shell scripting.
• Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
• Had an experience in leading a small team and Knowledge in Medical Information domain (Health Insurance and Clinical Data concepts and terminology).
• Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.
• Hands on experience in Nprinting Installation (Designer and Server), Qlikview Report Generation (Using Designer) and scheduling the jobs (Nprinting Server).
• Assisted users in using QlikView and Qlik Sense. Gave demo sessions to users to enhance their knowledge on all the key capabilities of QlikView and Qlik Sense.
• Involved in develop Proof of Concepts (POC) for various projects using QlikView and Qlik Sense.
• Experience in implementing the new features of Qlik Sense like Story Telling, Beta maps integrations, Pivot Table, KPI Object.
• Extensive experience in creating QV data models, QV objects, reports, graphical interactive UI and dashboards using Qlik Sense from multiple data sources like SQL, Oracle, SAP BW and Flat Files (XML, CSV, Excel).
• Knowledge of Qlik Sense security features.
• Extensive experience with various data modeling paradigms for both structured and unstructured data
•  Advanced knowledge of technical aspects of Qlik Sense application development, including design, data modeling and scripting and Knowledge on Qlik Sense Applications.
• Knowledge on Rev Cycle management concepts.

TECHNICAL SKILLS:

ETL Tools: IBM Info Sphere / Web Sphere

Datastage: 8.5 /8.1/8.0 /7.5 (Designer, Director, and Administrator), Info Sphere, Informatica

Reporting Tools: QlikView, Qlik Sense, Nprinting, Tableau, Hyperion IR,

Database: Teradata, MS SQL Server 2005/2000, DB2, Oracle, Hadoop, SAP BW, Sales Force

Languages: SQL, PL/SQL, UNIX Shell Script, PERL, Teradata-BTEQ, TPT,Python, PHP

Data Modeling Tools: Erwin 4.0/3.5, Star Schema, Snowflake Schema, OLAP, OLTP

Tools: TOAD, WinSQL, MS Office, Autosys, SQL*Plus, SQL*Loader

Operating Systems: Windows NT, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Qlikview/ QlikSense Developer

Responsibilities:

• Gathering requirements from business users and developed technical specifications.  
• Developed Service Request dashboard, which includes extracting data from the database, storing into QVD files, write load scripts, develop UI according to user requirements and trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.  
• Automated and scheduled daily load of QVW documents using Qlikview Publisher and notified load status by email.
• Research and troubleshoot technical problems and provided ongoing Qlikview consultation to the development team.
• Involved in training sessions to users on Qlik Sense usage.
• Hands on experience in Qlik Sense 2.1 installation and configuration.
• Developed applications using different components of Qlik Sense.
• Experience in implementing the new features of Qlik Sense like Story Telling, Beta maps integrations, Pivot Table, KPI Object.
• Implemented Qlik Sense security.
• Designed an application for to support the Funding and dashboard style of layouts using different components of Qlikview Enterprise like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• 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.
• I have worked on Qlikview Installation, Configuration and upgradation.
• Involved in maintenance of Qlikview services, Servers, Log files.
• Experience in providing Doc admin access and user licenses.
• Hands on experience in resolving access point issues.
• Experience in Migration of applications from Test Environment to Production environment.

Environment: Windows 2008 Server, Oracle, QlikView 11, MS Office Suite, File Maker Pro, Qlik Sense.

Confidential, Louisville, KY

Qlikview Developer/ ADMIN

Responsibilities:

• Gathering requirements from business users and developed technical specifications.
• Involved in extracting data from the database, storing into QVD files, write load scripts, develop UI according to user requirements and trained the end users effectively to use the reporting tool.
• Involved in preparing the Business Requirement Document (BRD).
• Extracted data set from SAP BW and build a data model with Link Table and Master Calendar to connect the various fact tables with the master tables.
• Use SAP ReloadDD and Script Builder (SAP Connector) to connect to SAP BW DSO’s and generate QVD’s.
• I have worked on enhancement of few dashboards.
• Implemented alternate states to simplify application design and reduce on-going maintenance.
• I have worked on security implementation to restrict the data for Business users.
• Automated and scheduled daily load of QVW documents using Qlikview Publisher and notified load status by email.
• Research and troubleshoot technical problems and provided ongoing Qlikview consultation to the development team.
• Developed complex SET ANALYSIS to provide custom functionality in Qlikview Applications.
• I have worked on Qlikview Installation, Configuration and upgradation.
• Experienced in implementation of Qlikview security by authentication, authorization at document level and data level to the end users.
• Involved in maintenance of Qlikview services, Servers, Log files.
• Experience in providing Doc admin access and user licenses.
• Hands on experience in resolving access point issues.
• Experience in Migration of applications from Test Environment to Production environment.
• Managed schedules and reloading of Qlikview data model QVDs and QVWs through Qlikview Management Console (QMC).
• Installed and configured NPrinting server and designer on windows server and desktop.

Environment: SAP, SALESFORCE.COM, Excel, Qlikview 11, Nprinting.

Confidential, San Francisco, CA

Qlikview/ Qlik Sense Developer

Responsibilities:

• Gathering requirements from business users and developed technical specifications.
• Involved in extracting data from the database, storing into QVD files, write load scripts, develop UI according to user requirements and trained the end users effectively to use the reporting tool.
• Involved in preparing the Business Requirement Document (BRD).
• Extracted data set from SAP BW and build a data model with Link Table and Master Calendar to connect the various fact tables with the master tables.
• Use SAP ReloadDD and Script Builder (SAP Connector) to connect to SAP BW DSO’s and generate QVD’s.
• Involved in requirement analysis and effort estimation for new dashboards.
• I have worked on design and development of two new dashboards from scratch.
• I have worked on enhancement of few dashboards.
• Developed applications using different components of QlikView Enterprise like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, Calendar, Cyclic and Drill down groups, bookmarks, etc.
• Implemented alternate states to simplify application design and reduce on-going maintenance.
• I have worked on security implementation to restrict the data for Business users
• Applied mapping function to look up and fetch the required field.
• Automated and scheduled daily load of QVW documents using Qlikview Publisher and notified load status by email.
• Research and troubleshoot technical problems and provided ongoing Qlikview consultation to the development team.
• Developed complex SET ANALYSIS to provide custom functionality in QlikView Applications.
• Implemented best practice methods to resolve Synthetic Keys and Circular loops in Qlikview.
• I have worked on Qlikview Installation, Configuration and upgradation.
• Experienced in implementation of QlikView security by authentication, authorization at document level and data level to the end users.
• Experienced on Rev Cycle management concepts like patient payment process, goods and Services from beginning to end.
• Involved in maintenance of Qlikview services, Servers, Log files.
• Maintaining LADP and ADP group’s users to provide the shared folder access and dashboard access.
• Experience in providing Doc admin access and user licenses.
• Hands on experience in resolving access point issues.
• Experience in Migration of applications from Test Environment to Production environment.
• Managed schedules and reloading of QlikView data model QVDs and QVWs through QlikView Management Console (QMC).
• Hands on experience in Qlik Sense 2.0 installation and configuration.
• Developed applications using different components of Qlik Sense.
• Experience in implementing the new features of Qlik Sense like Story Telling, Beta maps integrations, Pivot Table, KPI Object.
• Extensive experience in creating QV data models, QV objects, reports, graphical interactive UI and dashboards using Qlik Sense from multiple data sources like SQL, SAP and Flat Files (XML, CSV, Excel).
• Implemented Qlik Sense security.
• Installed and configured NPrinting server and designer on windows server and desktop.
• Presented Nprinting demo to Business users.
• Hands on experience on development of Nprinting reports and ON DEMAND.
• Involved in testing process and performing the Unit testing and System testing.
• Involved in training sessions to users on Qlik Sense usage.

Environment: SAP BW (Data Source), Qlikview SAP Connector Excel, Qlikview 11, Oracle, Nprinting.

Confidential, San Jose, CA

Qlikview/ QlikSense Developer

Responsibilities:

• Gathering requirements from business users and developed technical specifications.  
• Developed Service Request dashboard, which includes extracting data from the database, storing into QVD files, write load scripts, develop UI according to user requirements and trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.  
• Automated and scheduled daily load of QVW documents using Qlikview Publisher and notified load status by email.
• Research and troubleshoot technical problems and provided ongoing Qlikview consultation to the development team.
• Involved in training sessions to users on Qlik Sense usage.
• Hands on experience in Qlik Sense 1.0 installation and configuration.
• Developed applications using different components of Qlik Sense.
• Experience in implementing the new features of Qlik Sense like Story Telling, Beta maps integrations, Pivot Table, KPI Object.
• Extensive experience in creating QV data models, QV objects, reports, graphical interactive UI and dashboards using Qlik Sense from multiple data sources like SQL, SAP and Flat Files (XML, CSV, Excel).
• Implemented Qlik Sense security.
• Designed an application for to support the Funding and dashboard style of layouts using different components of QlikView Enterprise like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• 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.
• I have worked on Qlikview Installation, Configuration and upgradation.
• Involved in maintenance of Qlikview services, Servers, Log files.
• Experience in providing Doc admin access and user licenses.
• Hands on experience in resolving access point issues.
• Experience in Migration of applications from Test Environment to Production environment.

Environment: Windows 2008 Server, Oracle, QlikView 11, MS Office Suite.

Confidential 

Qlikview Developer

Responsibilities:

• Involved in creating dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, Containers, Calendar object, Fast Change objects etc.
• Implemented Direct Discovery Feature extensively in order to fetch the Live Data from a huge fact table that consists of users Account information.
• Built QVD’s from SQL Server, Teradata, Oracle, and Sales Force.
• Developed different KPI’s as per requirement using advanced set analysis.
• Wrote several macros for the dynamic construction of Multi Box based on the user selections, for triggering External Web services using SOAP request, exporting data to excel etc.
• Interacting with end users to gather the functional requirements and customize Qlikview dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting Qlikview applications.
• Involved in maintenance of Qlikview services, Servers, Log files.
• Maintaining LADP and ADP groups users to provide the shared folder access and dashboard access.
• Experience in Providing Doc admin access and user licenses.
• Hands on experience in handling access point issues.
• Experience in Migration of applications from Test Environment to Production environment.
• I have worked on Upgradation of Qlikview versions.
• Automated and scheduled daily data loads of QVW documents using QlikView Publisher.
• 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.
• Automation of PDF reports distribution to the users based on their region.

Environment: QlikView 11, Set Analysis, Teradata, Web Services, Oracle, Excel, SAP BW.

Confidential, NJ

QlikView Developer/ BI Consultant

Responsibilities:

• QlikView designing and modeling using multiple data sources relational designs.
• Involved in Performance tuning at database level, Script level and Application level.
• QlikView Administration - Creating scheduled jobs for QVD extracts and report plus reloads.
• Gathering, managing and documenting business and functional requirements, communicating effectively with upper management, developers and Subject Matter Experts (SMEs).
• Converted the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy.
• Involved in the developing of star schema and snow flex schema dimensional data model.
• Developed KPI’s and set analysis applications.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Performed optimization of the QlikView Application by removing unnecessary fields, avoiding complex joins, avoiding date functions, avoiding conditional functions inside the application using mapping load.

Environment: QlikView, Oracle 10g, SQL Server, PL/SQL, SQL*Plus, SQL Developer, MS Access.

Confidential

QlikView Developer/ BI Consultant

Responsibilities:

• Extracted the data from various data sources such as databases, CSV files, and Excel documents transforming the data into standard format (QVDs) and load the data so that it is available for analyzing and creating reports.
• Designed Schema using dimensions, fact, logical, physical, alias and extension tables.
• Developed QlikView scripts to load the transformations and make enhancements to the user interface of the desktop application.
• Installed and configured QlikView 9.0. Assisted in upgrading from QlikView 8.2 to version 9.0.
• Application processed tables with over 10 million records. Experience in scripting QlikView Set Analysis and Macros.
• Eliminated synthetic keys using QVD concatenation and by renaming the fields.
• Wrote scripts and created batch files for automatic running of QlikView scripts.
• Converted the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy.
• Designed user interface and prepared layouts for the system using QlikView.
• Involved in the developing of star schema and snow flex schema dimensional data model.
• Used MS Access and QlikView extensively as reporting tools and to create user build specifications and customized QlikView reports to interact with Hyperion.

Environment: Qlikview, Oracle 10g, SQL, Hyperion MS Access.

Confidential

Datastage/ SQL Developer

Responsibilities:

• Participated in discussions with Team leader, Group Members and Technical Manager regarding any Technical and Business Requirement issues
• Used Datastage to extract client data from Oracle and mapped the data into a target business warehouse
• Used Datastage Director to view logs for any errors and warnings
• Used Surrogate Keys to keep track of Slowly Changing Dimensions (SCD)
• Used Quality Stage components like Match Designer for designing and testing match passes
• Business-oriented approach: this has task-based user interface, it aided business users in reviewing data for anomalies and changes over time, and provided key functional and design information to developers.
• Used development/debug stages to test the environment by creating samples of data from given high volume data or by creating mock data
• Performed parallel processing of data extraction and transformation
• Extensively worked with various stages like sequential file, dataset, lookup, peek, transformer, merge, aggregator, row generator, surrogate key generator and many more to design jobs and load the data in to fact and dimension tables
• Implemented Local containers for same job and Shared Containers for multiple jobs, which have the same business logic.
• Extensively used Datastage Director and Autosys for Job Scheduling, emailing production support for troubleshooting from LOG files.
• Extensively used PL/SQL Developer for creating database objects, running the command scripts for inserting the configuration data items.
• Designed Web-based Internet applications linked to firm-wide SQL databases.
• Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
• Involved in analysis, coding, testing and Implementation of various modules and reverse engineering of the application using Erwin. Used Erwin to transform data requirements into data models.
• Automated data loading, extraction, reports generation using UNIX Shell scripting and loading data by using SQL* Loader to custom tables.
• Worked on materialized views, DBMS SCHEDULER for scheduling jobs and UTL MAIL to send mails using oracle 10g.
• Implemented shell scripts for trouble shooting Oracle Errors with the help of trace files and scheduled them.

Environment: IBM Info Sphere Datastage 8.0 (Designer, Administrator, Director), Quality Stage, Audit Stage, Information Analyzer, Oracle OBIEE 10g/11g 11g/10g, Teradata, DB2 UDB 8.1, Autosys, Windows Server 2003, AIX 6.1, SQL Plus, UNIX Shell Scripting, SQL Loader