SUMMARY

• Over 9+ years of experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence applications using Qlikview.
• Certified in both Qlikview and Qliksense.
• Strong knowledge in designing and developing Qlikview and QlikSense dashboards by extracting data from different sources like Sales Force, SQL Server, Oracle, SAP, Flat Files, Excel files, XML Files.
• Worked installation & configuration, environment, system analysis, design, deployment, testing of projects.
• Experience in optimizing Qlikview and QlikSense applications to improve the performance.
• Developed Qlikview and QlikSense objects like Multi Boxes, Straight tables, Pivot tables, Containers, Line charts, Bar charts, Combo charts, Scatter charts, Line objects, Pie charts, Buttons.
• Proficient in troubleshooting and fixing the Qlikview and QlikSense dashboard issues.
• Extensive experience in creating Pixel Perfect reports, Excel reports, Word reports, PowerPoint reports using NPrinting designer and automating the jobs in NPrinting Server.
• Hands on experience in customizing the Qlikview and N Printing reports as per the business requirements.
• Created incremental load process to load the data into Qlikview applications from different source systems.
• Use d3 visualization library (d3vl) with QlikSense extension to achieve goal of how this d3 charts easily integrated
• Defined a script block in the Html header which initializes the reference to the Qlikview application
• In - depth knowledge and understanding of data warehousing concepts, ETL, OLAP, OLTP, Cubes and normalizations to translate business requirements into effective business intelligence solutions
• Involved in Performance Tuning and Deployment of Qlikview and QlikSense applications.
• Hands on experience in Qlikview advanced features like Alternate States and Direct Discovery.
• Worked in Agile methodology environments and involved in scrum meetings.
• Experience on Qlikview Scripting, Set analysis and Section Access.
• Scheduled the jobs and distributed to end users from QMC.
• Experience in database programming, SQL, Tables, Views, Indexes, Joins, and Sub-Queries.
• Trained end users to develop and use Qlikview and QlikSense applications.
• Managing job failure analysis and production support for various applications.
• Involved in Onsite-Offsite coordination in delivering Business Intelligence Solutions.
• Understanding of data modeling, dimensional & relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables; experience in Extract, Transform and Loading process of data.
• Created detailed design, development, testing & migration documents and performing Proof of Concepts (POC).
• Delivered all the projects and assignments within the specified time lines with accuracy.
• Strong ability to work within a demanding and aggressive project schedules and environments.

TECHNICAL SKILLS

Reporting Tools:  Qlikview 9.0 10/11,QlikView Publisher, ETL QlikSense 1.10, 2.0

Languages:  C, C++, Java, PL/SQL, XML, JavaScript, CSS,JAVASCRIPT .NET, AngularJS, HTML/CSS, Hadoop, Ruby On Rails, Shell Scripting

Data Modeling:  Dimensional Data modeling,Star join Schema modeling,snow Fake Modeling,FACT and dimensionas table,Physical and Logical Data modeling

Databases:  Oracle 10g/9i/8i, SQL Server, Salesforce, SAP

Operating Systems:  Windows, Unix

WORK EXPERIENCE

Qlikview Developer

Responsibilities

• Developing the high-end visualization Qlikview Dashboards using Qlikview objects.
• Designing, developing and deploying using Qlikview Server & Publisher.
• Two Dashboards were developed and served to track all the way through Ship to Final acceptance phase, which include Installation.
• Developed Proof of Concepts (POC) for various projects using Qlikview and QlikSense.
• Gained experience in creating mobile friendly applications using QlikSense
• Used master calendar for time related dimensions and a strong source control methodology for tracking changes.
• Extensively worked with Set Analysis.
• Written complex expressions using Set analysis and various Qlikview/Qliksense functions.
• Implement Actions/Triggers in the Qlikview interface.
• Handled the end-to-end implementation of Qlikview /Qliksense dashboard deployment.
• Developing the Qlikview reports, dashboards, building semantic/data models for ado reports, (QVD) generation etc using QlikView.
• Expertise in building QV objects for different requirement such as straight table, pivot table, different charts (Bar Chart, Line Chart, and Scatter Chart).
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Expertise in managing QlikView Server, QlikView Publisher, QlikView Enterprise Version.
• Implemented Qlikview dashboards distribution to business users using Section Access to dashboards, providing CALs to documents
• Working with Star Schema/Snowflake modeling, FACT & Dimensions tables.
• Drill Information by creating Groups/Cycles in QlikView.
• Entitlement and data level security for dashboard using SECTION ACCESS
• Developed QlikView applications creating expressions using set analysis
• Analyzed and developed best practices for data management and Extract, Transform,
• Load (ETL) processes from multiple data sources.

Environment: Qliksense 2.0, QlikView 11.0 SR2, flat files, SQL Server, Oracle, Tera Data, MS Access 2007, MS Excel 2007

Qlikview Consultant

Responsibilities

• Analyzed database, tables and views for the underlying SEIBEL system
• Worked on requirements documents and design documents for the dashboards and reports
• Worked on dashboards for Sales force activities, Account calls, performance
• Created multi - layer data load scripts in Qlikview.

Qlikview Developer

Responsibilities

• Imported data from multiple data sources including Web Services, MS SQL Server and MS Excel through OLEDB and ODBC connections and modeling data as per user requirements.
• Participate in enterprise DW / BI strategy/Dash boarding.
• Qlikview 11 implementation and integration.
• Involved in utilizing Qlikview solutions to develop complex reports and executive dashboard.
• Created Architectural Conceptual documentation and Technical Specification Documents.
• Creating complex data models without synthetic tables and circular loops.
• Developed Qlikview applications creating expressions using set analysis.
• Created and scheduled Complex reports by leveraging the basic components of Qlikview.
• Involved in organizing meetings to know the needs of clients for the Enterprise solution implementation.

Environment: Qlikview 9.0, Qlikview Publisher/Server, Windows 2003 Server/XP, SQL Server 2008, MS Visual Studio, MS Access 2007, MS Excel 2007

Qlikview Developer

Responsibilities

• Involved in gathering and documentation of QlikView application requirements from end users.
• Analysis the business requirement and collect the necessary information for Dashboard building such as Database objects from EDW team, UI design requirement from users.
• Involved in the writing scripts for extracting of QVD's for different cuts of data.
• Expertise in writing complex Set analysis for the KPI calculation in the Dashboard.
• Expertise in building QV objects for different requirement such as straight table, pivot table, different charts (Bar Chart, Line Chart, and Scatter Chart).
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Extracted information from different data sources like Oracle, Teradata and flat files, etc by using different scripts like add, concatenate, resident, qualify, unqualify, etc
• Expertise in defect solving for the Dashboard during the QA testing.
• Involved in publishing of the dashboard to the users using Qlikview Publisher.
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Implemented session access to enterprise level document.

Environment: QlikView 10 SR4, Teradata SQL Connector, Windows 7, Windows Server 2003.

SQL BI/ Qlikview Developer

Responsibilities

• Created, manipulated and supported the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Documented the requirements and prepared various Business Requirement Documents.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Used stored procedures and triggers to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Imported & Exported data from one server to other servers using tools like Data Transformation Services(DTS)
• Explored the use of User Defined Functions to encapsulate commonly used logic in the stored procedure and maximized the readability of such Stored Procedures.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning ofT-SQL queries and • Stored Procedures. Optimized query performance by creating indexes.
• Performed daily database backup & restoration, monitored the performance of the Server.
• Handled development and production support, document reviews, test plan, integration of the system.

Environment: SQL server, Jupiter, Windows NT, UML, DTS, Query Analyzer, SQL Profiler

SQL Developer

Responsibilities

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and views using T-SQL in Development and Production environment
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity
• Wrote Transact SQL utilities to generate table insert and update statements
• Used SQL Profiler and Query Analyzer to optimize SSIS package queries and stored procedures
• Migrated DTS packages to SSIS Packages
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data

Environment: SQL Server 2008, DTS/SSIS, HTML, Java Script, VB Script