SUMMARY:

• Around 7 years of IT experience in Business Intelligence (Qlikview & SAP Business Objects) and 4 years’ experience in Designing and Development of Business Intelligence application with Qlikview/QlikSense versions.
• Experience in developing different analytical applications using Qlikview enterprise and proficient knowledge (Qlikview Server, Publisher and Qlikview Enterprise).
• Involved in end to end Qlikview project implementation starting from requirement gathering to deployment.
• Excellent knowledge inimportingdata from variousData Sourceslike Excel Files (.xls), CSV Files (.csv), XML Files (.xml), Oracle10g/9i, SQL Server 2005/2008, DB2 and other Databases.
• Experience Implementing the3 - tierarchitecture(Data-Extract, Data-Modeling and Application Development) as recommended in Qlikview best practices guide.
• Expertise in creating dashboards using Qlikview sheet objects such as List Box, Statistics Box, Multi Box, Table Box, Charts, Current Selections Box, Button, Text Object, Slider/Calendar Object, Search Object.
• Hands on experience in implementing the new features of Qliksenselike Storytelling, Data Profiling Techniques, SmartDataAssociations, Beta maps integrations, PivotTable, KPIObject and Custom Extensions with Workbench Utilities etc.
• Good knowledge of Business Intelligence/Data Warehousing BIDW Fundamental architecture concepts, dimensional modeling, requirement gathering
• Expert in data modeling using Star Schema and Snow Flake Schema and resolving Circular relational traps like, fan trap, chasm trap, Synthetic keys and modeling issues.
• Involved in Optimizing existing Qlikview dashboards with a focus on usability, performance, long-term, flexibility, and standardization.
• Expert in Qlikview Security implementation and Publisher task and Scheduling the sufficient knowledge and expert in Qlikview implementing the loads. Sound skills in writing SQL Scripts.
• Conduct validation of existing reporting, User Acceptance testing and new solutions to ensure continuous accuracy and front end ease-of-use.
• Onsite-Offshore coordination in delivering Business Intelligence Solutions.
• Excellent knowledge in Implementation of Relational Database (OLTP), Data warehousing systems (OLAP) and Data Marts.
• Trained and worked With in N printing V16 and Report Manager.
• Knowledge in data ware housing using Slowly Changing Dimensions (SCDs).
• Highly skilled, self-motivated, outstanding, excellent communication and interpersonal skills with Result oriented dedication towards goals.

TECHNICAL SKILLS:

Business Intelligence/ETL Tools: Qlikview 9.0/10.0/11,12, Nprinting 16,17, Qliksense 2.2/2.0 Business Objects XIR2/3.1, Designer, DESKI, WEBI, Info View, Crystal Reports XI

Operating systems: Windows 2008R 2/2003/2000/2007

Database: Oracle 11g/10g/9i, SQL Server 2008 R 2/2008/2005/2000 , Teradata, Oracle SQL Developer, Teradata SQL Developer, TOAD.

PROFESSIONAL EXPERIENCE:

SR Qlikview Developer

Confidential

Environment: Qlikview 11.0-SR 6, Qlikview Management console, Qlik-publisherOracle11g, Teradata, Windows 2008 server, SQL Developer.

Responsibilities:

• Gather customer requirements and understand the data from different source systems.
• Developed the dashboards, which includes extracting data from the database, storing into QVD files, written load scripts and develop UI according to the user requirements.
• Converted all existing Cognos Reports in to Qlikview Reports.
• Extensively used Heat Maps Extensions to Predict the Data Globally.
• Used all Advanced Aggregations Functions to interpret the data as required by business.
• Have created the dashboard in multi-Language For Global users.
• Created Advanced Ad-hoc Reports For users to create their own report On Demand.
• Implemented Section Access inQlikview dashboards.
• Conduct testing, including unit Testing, business analysis, and client testing.
• Helped team in Documenting the Work for future Support.
• Developed Report Manager POC for users up on request.
• Troubleshooting the issues and reviewed the log files to resolve the issues.
• Managed user's access to theQlikViewServer andQlikViewAccess Point.
• Deployed QVW's on the production server, Created Reload and Distribution tasks onQlikView

SR Business Intelligence Developer

Confidential

Environment: Qlikview 11.0-SR 6, Qlikview Management console, Qlik-publisherOracle11g, Teradata, Windows 2008 server, SQL Developer.

Responsibilities:

• Supporting Existing Applications with Access requests and maintain Dashboards And reloads.
• Scheduling Reports and Updating Section Access for User Access Request.
• Deliver high quality services utilizingQlikviewenterprise-wide Business Intelligence tools.

  Expert level skill in integrating data usingQlikview.

• Developed the dashboards, which includes extracting data from the database, storing into QVD files, write load scripts and develop UI accordingly the user requirements.
• Installed and configured/administering QlikViewDesktop,Qlikview Server, IIS Server andQlikview Publisher.
• Generate new QVD files created by ETL logic to feedQlikview applications.
• Receive business requirements from client via a Business Analyst and build applications, functions, and processes using programming skills/software.
• Distributed QV reports using NPrinting in the form of Excel/PDF/Power Point/Word etc. to users through email or publish to a folder on the scheduled time.
• Conduct testing, including unit, business analysis, and client testing.
• Worked on Incremental Loading to reduce the reload time of different applications.
• Solving Modelling issues like Circular loops and Synthetic keys.
• Implemented security by using section access.
• Maintain tested applications for quality assurance and production support.

Qlik Architect

Confidential

Environment: Qlikview 12.0-SR 4, Qlikview Management console, Qlik-publisherOracle11g, Teradata, Nprinting 16.

Responsibilities:

• Interacting with Business user and Gathering Business Functional Requirements And converting them to Technical Requirements to share with Team
• Maintaining technical team And Driving those congruously to meet the user Requirements in predefined timelines.
• Acted as a business Analyst and solved Technical Work related Queries to team.
• Given ideas For Query performance tuning for dashboards Performance improvements.
• Participated in full SDLC from requirement Gathering to Deploying to production servers.
• Giving inputs for Team to unit test and Full Regression testing.
• Participated in End to end development in Qlikview. Reviewing the Data models. And Design Development to make sure We Met client Requirements.
• Tracking the Everyday Workflow of Team and Solving the Hiccups in Workflow Drive.
• Creating Standalone meetings to make sure no Work delays as Anticipated.
• Suggesting the Users for the Design Charts to bring up the Meaning Full Data for business Insights.
• Working with production related Issues. And coordinating with appropriate teams to solve Them
• Participated in Code review, change Request, creating design Document and reviewing as per Company policy.
• Working with ETL and data base teams to pull Data from Different Source Systems to Qlikview for business Analysis.
• Constructed various graphs such as Straight table, Bar graphs, Pie charts, Line and Gauge charts.
• Converted MSBI reports to Qlik Dashboards and made them Very interactive.
• DevelopedQlikViewDashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping).
• Used Static, Dynamic Variables and Extensively Worked with Set analysis, set expressions and advanced aggregation functions.
• Involved in extracting, transforming and loading data from sources into QlikView/Qliksense applications
• Training the power users about the functionality

BI Developer

Confidential

Environment: Qlikview 11.20: SR 6, Qlikview Management console, Qlik-publisherQlikSense - 2.2, Oracle11g, SAP, Nprinting 16.

Responsibilities:

• Gather customer requirements from Business Analyst and understand the data from different source systems.
• Extracted data from the database, stored into QVD files, and wrote load scripts.
• Implemented QlikView3 tier architecture data model.
• Eliminated Synthetic keys and circular loops in the data model.
• Created link tables on the needed basis and as per the data.
• Created Master Calendar and worked with date fields as per the user needs.
• Applied mapping function to look up and fetch the required field.
• Created User Interface of reports and designed the dashboard according to the requirements.
• Created dashboard style of layouts using various components of QlikViewlike List boxes, Multiboxes, Slider, current selections box, buttons, charts, text objects, and bookmarks.
• DevelopedQlikViewDashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping).
• Constructed various graphs such as Straight table, Bar graphs, Pie charts, Line charts and Gauge charts.
• Involved in converting the existing QlikView applications toQlikSense
• Implemented Pick Dimensions and Pick Measures as Custom reports tab at the Dashboard.
• Worked on set analysis and advanced aggregation functions.
• Implemented document event trigger and field event triggers.
• Implemented secure environment usingQlikViewSection Access.
• Involved in extracting, transforming and loading data from sources into QlikView/Qliksense applications
• Worked onQlikViewserver and publisher to automate theQlikViewjobs and define the user security and data reduction.
• Developed the mobile version dashboards in single land scape models for end users for ease of access. And triggered them technically from desktop versions.
• Training the power users about the functionality
• Troubleshooting the issues and reviewed the log files to resolve the issues.
• Manages user's access to theQlikViewServer andQlikViewAccess Point.
• Deployed QVW's on the production server, Created Reload and Distribution tasks onQlikView

Qlikview /QlikSense Developer

Confidential

Environment: Qlikview 11, QlikSense - 2.2, Qlikview Management consoleN- Printing, oracle11g, SAP-BW.

Responsibilities:

• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• 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.
• Delivered advanced/complex reporting solutions such as Dashboards and Standardized Reporting using Qlikview 10.
• Developed Qlikview Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Worked in Using Qlikview Functions (Date and Time, Keep, Join, Mapping, and String & input Fields.
• Developed Linked Tables, Concatenation and solved the loops issues.
• Used to solve the issues related to the end users.
• Working knowledge of Qlikview Server, Qlikview Publisher, and Qlikview Enterprise Version.
• Research and troubleshoot technical problems and provided ongoing Qlikview consultation to the development team.
• Participate in enterprise BIDW / BI strategy/Dash-boarding.
• Developed User Interactive Sheets & Reports as business needs.

Qlikview Developer

Confidential

Environment: Windows 2008 Server, Qlikview 11, oracle11g, Teradata9i.

Responsibilities:

• Involved in business requirement gathering and development of functional and technical specification documents.
• Developed different dashboards with a complex database system behind it, which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Strong understanding in creating Dashboards, scoreboards for the required KPI’s in Qlikview.
• Worked in designing backend ETL for data extraction & building data model using Qlikview Scripting Design & Develop Qlikview Dashboards.
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Developed load scripts to work with multiple data sources (SQL, Flat Files, Excel, and MS Access).
• Involved in Requirement gathering & designing Qlikview applications.
• Gathering data sources like QVD files, Excel, binary QVW, Inline & txt files in developing the Qlikview Data Models.
• Participate in enterprise BIDW / BI strategy/Dash-boarding.
• Developed Qlikview Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Developed User Interactive Sheets & Reports as business needs.
• Writing SQL Scripts to load the relevant Data in Qlikview Applications.
• Developed Set Analysis in provide custom functionality in Qlikview Applications.
• Implemented Security & involved in Deployment of Qlikview Applications.
• Created QVD’s & updated on timely basis as database updates.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.
• Implemented Star schema & snow flake schema.
• Developed Linked Tables, Concatenation and solved the loops issues.
• Used to solve the issues related to the end users.
• Working knowledge of Qlikview Server, Qlikview Publisher, and Qlikview Enterprise Version.

SAP BO, Qlikview Developer

Confidential

Environment: Windows 2008 Server, MS SQL Server 2008, QlikView 10, Netezza.

Responsibilities:

• Developed different dashboards with a complex database system behind it, which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI as per user Guidelines.
• Connected to different ODBC, OLE DB data sources (SQL Server) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of Qlikview.
• Gathered & loaded data into Qlikview from various data sources (SQL SERVER 2008, CSV and excel files).
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• 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.
• Delivered advanced/complex reporting solutions such as Dashboards and Standardized Reporting using Qlikview 10.
• Implemented Star schema & snow flake schema.
• Developed Linked Tables, Concatenation and solved the loops issues.
• Used to solve the issues related to the end users.
• Working knowledge of Qlikview Server, Qlikview Publisher, and Qlikview Enterprise Version.
• Research and troubleshoot technical problems and provided ongoing Qlikview consultation to the development team.

Confidential

Business Objects developer

Environment: SAP BO XI R2/BO 3.X, Oracle SQL Developer, Oracle 10g/11i.

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Developed complex universes by using features like aggregate aware, Index aware, Conditions and hierarchies to Perform linking of universes to optimize the universe development and performance improvement.
• Developed various Complex Ad hoc and Complex Canned Reports Using Mainly Universe as the main Data Provider.
• Defined Row level and Object restrictions for the Universes using Manage Access Restrictions in Designer to restrict Key Financial information for the various Spectrum bands.
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints.
• Worked extensively with the functionalities like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Extensively applied Filters, Sort, Rank on the data with in information space.
• Created calculated measures, Emailed data to a recipient and exported data in several formats like CSV, Excel, and Image.