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.

PROFESSIONAL EXPERIENCE

Qlikview Developer

Confidential -Eden Prairie MN

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

Confidential -Atlanta, GA

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

Confidential, IL

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

Confidential, NC

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

Confidential

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 of
• T-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

Confidential

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

SKILLS

Qlikview (7 years), Business requirements (6 years), Documentation (6 years), Data modeling (5 years), Microsoft SQL Server (5 years), Database (5 years), Reporting (5 years), Publisher (4 years), Dashboard (4 years), Data warehouse (4 years), SQL (4 years), Scripting (4 years), SQL Query Analyzer (3 years), Data

Transformation Services (3 years), Business intelligence (3 years), DML (3 years), UI (3 years), Transact-SQL (3 years), Data manipulation (3 years), Oracle (3 years)

ADDITIONAL INFORMATION

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/CSSHadoop, 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