SUMMARY:

• Over 8 plus years of experience in state - of-the-art mission critical and scalable end-to-end Business Intelligence/Data Warehousing/Analytics industry solutions with expertise in QlikView, hands-on experience in analysis, and development for BI project solutions in banking, insurance, retail, Healthcare.
• Expertise in Full Life Cycle Development which includes Planning, Analysis, Design, Implementation and Maintenance of a data warehouse project.
• Expertise in Installing and Configuring QlikView10.x/11.x Desktop, Server and Publisher in Development, Test and Production environment.
• Expertise in designing QlikView and Qlik Sense applications with multiples data sources like SQL Server, Oracle, Flat Files, and optimizing applications by using various performance tuning techniques at load script and at UI level.
• Expertise in Full Life Cycle implementation of a data warehouse project that includes Planning, Analysis, Design, Implementation and Maintenance.
• Resolved complex issues w.r.t circular references, pivoting, data modeling, incremental loading, set analysis, data uniformity, handling Multiple Fact table, Linked tables, complex formulas and performance.
• Customized Qlikview applications as per client requirements by implementing Macros and extension objects.
• Involved in Optimizing existing QlikView Dashboards with a focus on usability, performance, long-term, flexibility, and standardization.
• Strong experience in Data Warehousing concepts - Star Schema, Snow Flake Schema and Data Modeling( Normalization/ De-normalization, ER Diagrams, Keys Excellent knowledge in Implementation of Relational Database (OLTP), Data warehousing systems (OLAP) and Data Marts.
• Deployed application across various environment's (Dev, QA & PROD). Configured, scheduled and monitored various jobs using QlikView Management Console (QMC/QEM).
• Well versed in Business Objects (XI R2) with experience in Designer, BCA, Server, Web Intelligence, Info view, Xcelsius Dashboards, and Schema Design.
• Extensively used QAAWS and LO connection to leverage corporate data into Xcelsius dashboard and also used feature like dynamic visibility, alerts, drill-down, filtered rows, formula at Excel level.
• Good experience in migrating qlikview 10 to qlikview 11 server, implemented alternate states, conditional visibility of dimension and expressions, other new features during the migration process.
• Good knowledge of deploying Qlik Sense dashboards on the Sense Server. 
• Experience in working on implementation of Data warehouse and strong understanding of Data warehouse concepts, data modeling experience using star schema/snowflake modeling for OLAP systems, ER Diagrams, Dimensional modeling, Fact & Dimensions tables, physical & logical data modeling.
• Expertise in working with relational databases like Oracle, MS SQL Server, Teradata, DB2 and MS Access.
• Expertise in Qlik sense data modeling, Qlik sense development, Qlik sense SDLC and governance, Qlik sense apps, stories, KPI and story generation.
• Experience in creating mashup and integrations in Qlik sense and Qlik sense web services
• Experience in deployment and configuration of application in IIS server.
• Extensive experience in developing stored procedures, functions, triggers, cursors and joins, SQL Queries with T-SQL, PL/SQL and working with TOAD, SQL Developer, SQL*PLUS.
• Trained end users on QlikView report functionalities for their analysis.
• Configured various Qlik sense roles and attribute based access control.
• Highly self-motivated, team player, outstanding organizational and interpersonal skills with result oriented dedication towards goal.
• Proven problem solver with excellent communication, analytical, presentation and multi-tasking skills.
• Enjoy accepting challenges, meeting deadlines, and fulfilling client’s requirements.

TECHNICAL SKILLS:

BI Tools: QlikView 10.x/11.x,Qlik sense 3.0

Databases: MS SQL Server, Oracle, DB2, Teradata.

Web Technologies: HTML, Java Script, VB Script.

Data Modeling Tools: Erwin, Visio 2000.

Operating Systems: Windows 95/98/2000/XP/NT, UNIX.

Languages: SQL, PL/SQL, Unix.

Other Tools: Informatica 7.x/8.x, Toad, DAC, SQL Developer, Putty.

PROFESSIONAL EXPERIENCE:

Confidential, New York

Qlikview Developer

• Worked on Star Schema Data Model that suits the business requirements by eliminating synthetic keys and circular loops.
• Participated in deploying the Qlikview applications on the Qlik Server.
• Connections to OLE DB/ODBC, XML files, MS Access and Oracle 10g.
• Based on the required KPI’s, created Dashboards in QlikView.
• Extensively used various Chart types (straight, pivot, bar, Pie, gauge, combo etc.), List boxes, Input Field, Table Box, sliders, etc for developing Qlikview dashboards.
• Extensively used set analysis, triggers (document level, field level), Macros and aggregation functions.
• Refined the existing data model and ETL logic for enhancing the existing dashboards.
• Implemented security on user privileges using QlikView section access technology that dynamically hides selected areas of the dashboard.
• Worked on Incremental Load to decrease the load time / increase loading performance.
• Performed different tasks like extraction, reload tasks, distribution tasks, reduction, deploying apps, scheduling, User management, license managment, Clustering and licensing using QMC.
• Created standard Layout themes and applied it to several QVW’s
• Qlikview recommended best practices were used in implementation of scripting, set analysis and usage of variables. 
• Worked with Business Analysts in creating the BRD (Business Requirements Document) and UAT test cases
• Qlik sense POC - Working on qlik sense proof of concept by importing and also creating new dashboards and data models for the business teams to evaluate.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Qlik view/Qlik sense.

ENVIRONMENT: QlikView 11, Oracle 10g, MS Office, Windows 2008 R2 Server, Toad, Data Stage, Qlik view 11/Qlik sense 3.0.,

Confidential, New York

Qlikview Developer

• Worked with the user community and executive management to identify the business’reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business.
• Responsible for gathering requirements, business and technical rules, implementing QlikView and Qlik Sense applications. 
• Built multiple dashboards and presented to different user groups to make them understand the functionality of dashboards.
• Assisted associate qlikview developers, business analysts, targeted for a self service BI system.
• Created a reporting process which will constitute as a measurable success for business unit by having the most updated and accurate information that will help in more intuitive decision making. 
• Actively participated in full life cycle of QlikView application implementation and was responsible for Design, Development and Delivery.
• Extracted data from different systems like oracle, Flatfiles, textfile e.t.c and integrated in the QlikView.
• Designed star Data-Model using, ensured its performance is good.
• Developed a standard/optimized theme which is further used across the system.
• Extensively used set analysis to calculate/aggregate the fact data as per the requirements.
• Developed QlikView Dashboards using Charts (Straight table, pivot table, Line, combo Chart etc.), List Boxes, Multi Box, Input Field, Table Box, Statistics Box etc.
• Resolved synthetic keys using various techniques such as aliasing, join, concatenation, dropping fields, etc.
• Provide support analyst when internal teams have enquiries and trained business users.
• Installed Qlik Sense desktop 1.1/2.1 and developed applications for the users. 
• Developed Proof of Concepts (POC) for various projects using QlikView and Qlik Sense in creating Dashboards using chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box and Calendar & Date Island.
• Customized governance Dashboard for analyzing usage of various dashboards by various users, system performance based prioritization of dashboards has done.
• Extensively done business user support, resolved various issues for accessing dashboard and enhanced the dashboard as per user needs.
• Suggested various performance tuning techniques on database to DB teams.
• Implemented Incremental Loading and updated the data in the dashboard as close to real time as possible.
• Implemented the 3-tier architecture, Data Extract, Data transform and Data model & Application. Data Extract would load the Data from the data sources into the QVDs. Data transform will transform the data and Appon databalication layer is User Interface Design layer where we layout all our Charts, Tables and List Boxes.
• Good usage of SET ANALYSIS functionality in most of the applications across different objects to achieve simple to highly complex KPIs.
• Created batch scripts to process the data periodically as per the business requirements.
• Extensively implemented section access for row, object, column and sheet level security.
• Extensively worked on performance (DB, Design and UI level) for fast response of the application/dashboard (Qlikview/Qliksense) based on the end user selection.
• Deployed the QlikView applications in the server. Created Publisher Tasks in QMC for the QlikView Application to Reload and Distribute the QlikView Application on to the Access Point.
• Migrated existing QlikView 10 dashboards to QlikView 11 environment, also added new QV11 features to the Dashboards.
• Experience in designing QlikView and Qlik Sense Document/User Setting, Layouts to make consistent and professional optimized look to clients. 
• Scheduled the Publisher Tasks Daily/ Weekly/ Monthly on various Dashboards based on the Database updates.
• Involved in setting up the Development and Production Environments for QlikView. Responsible for user and server management.
• Helped end users to design test cases and worked through multiple UAT cycles.

ENVIRONMENT: QlikView 11.x/10.x/Qlik Sense, Oracle 11g, DB2 9.7, MS Office, Windows 2008 R2 Server, Toad, Informatica Power Center, Agile methodology.

Confidential, New York

Qlikview Developer

• Developed proof of concept to check the functional feasibility of the QlikView implementation.
• Studied QlikView and its components and worked closely with the QlikView Implementation partners.
• Developed a Star Schema Data Model that suits the business requirements by eliminating synthetic keys and circular loops.
• Participated in Installing and configuring Qlikview server and deployed the applications.
• Strong understanding in creating Dashboards for the required KPI’s in QlikView.
• Deployed the application on QlikView server and imported data from different sources like Oracle 10g, MS Access, XML files and flat files using OLE DB/ODBC.
• Involved in analyzing the existing data model, script logics and ETL logics for the existing dashboards and enhanced them.
• Developed ad-hoc reports to see how revenue, cost and gross profit are comparing against forecasted budgets and actuals.
• Mainly designed and developed QlikView applications from scratch, to support reporting and Business Intelligence initiatives.
• Used advanced scripting, set analysis, VBScript and macros, advanced aggregation functions and advanced charts.
• Implemented advanced Set Analysis for aggregation calculations so that set of possible or alternate records can be defined in an expression.
• Developed QV Dashboards using various Chart types (straight, pivot, bar, Pie, gauge, combo etc.), List boxes, Input Field, Table Box, sliders, etc.
• Used Document level and Field level triggers based on the requirements.
• Experience in using QV Functions related to string, date, color, formatting etc.
• Involved in analyzing the Business objects reports to convert them to Qlikview Having knowledge on ETL tools like Informatica.
• Developed User Interactive Sheets & Reports as per business needs.
• Developed views in DB to load the relevant Data in QlikView Applications.
• Developed Macros and implemented extension objects to provide custom functionality in QlikView Applications.
• Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Worked on complex aggregate functions and gave the desired output across the combinations.
• Designed Executive Sales Analysis Dashboard that offers fast and flexible access to all key information across the enterprise.

  Involved in Deployment of QlikView Applications into the server.

• Extensively implemented incremental loading to decrease the load time / increase loading performance.
• Install QlikView Products across Dev, QA & Prod environments.
• Performed different tasks like extraction, reload tasks, distribution tasks, reduction, deploying apps, scheduling, User management, license managment, Clustering and licensing using QMC.
• Worked with clients to migrate from traditional static Excel reporting to a more interactive and powerful dashboard solution.
• Dynamically creating the WHATIF analysis reports by modifying the input data though slider object and input boxes
• Created standard Layout themes and applied it to several QVW’s
• Qlikview recommended best practices were used in implementation of scripting, set analysis and usage of variables. 
• Testing Applications using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.

ENVIRONMENT: QlikView 10.x, Oracle 10g, MS Office, Windows 2008 R2 Server, Toad, Informatica Power Center.

Confidential

Business Objects/Qlikview Developer

• Gathered & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files.
• Tested Applications, ensuring the application met the requirements, Data quality for Quality Assurance before delivering to the end users.
• Participated in the UAT process along with business users.
• Supported multiple clients and responsible for ad-hoc queries which were raised by client users.
• Creating client setup on server for different clients and providing the access to the users, distributing the application.
• Converted existing Business Objects reports to QlikView.
• Worked on SQL and executed them for Reports validation and resolved if any issues with reports.
• Efficient in Optimizing, Debugging and testing SQL queries written in Oracle
• Developed strategies and plan for migration of the reports from BO XI R2 to BO XI R3 and later BO XI R3.1
• Production Support and data validation of Business Objects reports and QlikView models.
• Delivered advanced and complex-reporting solutions such as Dashboards and Standardized Reporting using QlikView 11.

ENVIRONMENT: QlikView8.5, SQL Server 2005/2008 Enterprise Edition, MS SQL Server Management Studio, Erwin Data Modeler, MS PowerPoint, MS Excel

Confidential

BO Developer

• Interacted with Users and Business Analysts to understand and document the requirements and translate these to technical specifications for designing Universes and Business Object Reports.
• Designed and implemented Data Models to meet existing and future anticipated reporting requirements.
• Designed Universes using BO XI R2 designer by retrieving data from database, using Derived tables, defining the necessary connections and exported them to specific universe domains.
• Extensively worked with Web Intelligence XI R2 and Info View to create thin client reports based on the business requirements.
• Designed and Developed WebI Reports as per the Users Requirements using the features in Business Objects including: Master/Detail, Charts, Cross Tabs, Slice and Dice, Drill Down, @Functions and Formulae to analyze the data.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and requirements of the end users.
• Mocking up the data considering security and confidential data. Thorough Documentation of all the Reports with Report definition, field definitions and layouts.
• Created Crystal Reports Templates to support Corporation Report Standards and color scheme.
• Used Dashboard Manager to build Dashboards and deploy them across the organization to monitor business performance.
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Crystal Xcelsius.
• Development confirmation with users and modification if required accordingly.

ENVIRONMENT: Business Objects 6.5, MS.NET, C#, VB, SQL Server 2000, Photoshop, Flash 

Confidential

SQL Developer

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Involved in the design and implementation of database.
• Wrote validation scripts to check the data integrity and packages for other entitlement programs as per guidelines and Gained knowledge in handling Bulk data.
• Involved in coding, unit testing, and end-to-end testing of the developed modules.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling and Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization and created some Custom reports and Forms for the end users to check the details and errors.

ENVIRONMENT: Oracle 9i, SQL* LOADER, Forms 6i, Reports 6i, Discoverer 10g, XML Publisher.