SUMMARY

• Over 9 years of strong experience in IT industry in the fields of Qlikview, Business Intelligence, Business Analysis with full project lifecycle implementation.
• Around 5 years of experience in Designing, developing and deploying of QlikView.
• Extensive experience in all aspects of Qlikview Development - Data Modeling, Scripting, UI Design, Development and Optimizing.
• Experience in all aspects of SDLC right from Requirement Gathering, BRD, Prototyping, Design, Development, Testing, and Deployment with effective communication.
• Good knowledge and understanding of QlikView server, QlikView publisher and QlikView enterprise version.
• DevelopedQlikViewDashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Data Island.
• Strong Skills in Data Modeling including Star Schema and Snow Flake Schema and also in loading data to QlikView from multiple data sources and data files.
• Implemented features such as incremental load, binary loads, alternate states and set analysis in Qlikview.
• Implemented the 3-tier architecture (Data-Extract, Data-Modeling and Application Development) as recommended in QlikView best practices guide.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers.
• Well experienced in design, development & Administration of QlikView for OLTP and OLAP Systems
• Good communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.
• Excellent Interpersonal and Customer Relational Skills. Proven Communication, Presentation Skills and Leadership Qualities.

TECHNICAL SKILLS

BI Tools: QlikView Desktop (9/10/11), QlikView Server (9/10/11), QlikView Publisher

Programming Languages: HTML, CSS, JQuery, JavaScript, Flash

Operating System: Windows 2K/XP/Vista/7/Server2003/2008, LINUX

Databases: SQL Server, MS-Access, MySQL

MS Office: MS Project, MS Visio, MS Word, MS Excel, MS PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. Qlikview Developer

Responsibilities:

• Involved in business requirement gathering and development of functional and technical specification documents.
• Involved in developing Dashboard standards such as Template designs, User Interface and Navigation Design patterns.
• Created QlikView dashboard user interfaces as per the business requirements.
• Developed different dashboard 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.
• Extracted information from different data sources like Teradata, SQL Server, MS Access and flat files, etc. by using different scripts like add, concatenate, resident, qualify, unqualified etc.
• Used Incremental loading to handle large volume delta loading to reduce reload time and have a cumulative data for the dashboard. Also periodically archived the data based on data retention standards.
• Coordinated with Database and ETL teams for Data and Structural follow-ups and Design.
• Implemented Section Access to filter data based on Document Level, Sheet Level and Data Level depending upon user privileges.
• Created publisher tasks for PDF Distribution, Loop and Reduce for Data Reduction.
• Written Qlikview Macros to achieve functions such as Copy Objects to Office documents, Screenshot of Dashboards to Email Body and PDFs etc.
• Build reusable macros to control Qlikview objects for ease of use by the users.
• Involved in multiple phases of project like Requirement gathering, Resources evaluation, Designing, developing, application-testing, bug-fixing, UAT and end-user training.

Environment: QlikView 10/11, Oracle 9i/10G/11G, SQL Server 2005, Windows 2003 Server.

Confidential, Irvine, CA

Qlikview Developer

Responsibilities:

• Interacted with End Users and Documented the Requirements.
• Developed various internal prototypes for acceptance testing.
• Followed the agile pattern of working and work execution.
• Played a part a Business support solution provider and closely work under the environment of WAR room meeting, complete brain storming.
• Connected to multiple data sources such as Oracle, DB2, Flat files, Excel Spreadsheet’s and prepared close to business requirement like model. (Especially star model and snowflake).
• Established a Standard structure for Test and working files(QVW) and version controlling to maintain parity between production and Test environment.
• Used QlikView direct discovery along with Document chaining to fetch on-demand report from linear database after creating View inside the database to protect performance from huge data loading during mass data accumulation due to Granular data fetching.
• Implemented 3-Layer architecture, Binary loads and Incremental Loads for optimal performance of the Dashboard reloads, rescaling and to adhere to data retention standards.
• Incorporated necessary log files and failure mailing mechanisms for smooth day to day operations.
• Worked on data model according to the user requirement and successfully created an optimized QlikView application.
• Developed Dashboard and What-If predictive analysis based on complex price calculation.
• Developed reports / KPI’s for Supply Chain mechanism, including supply demand GAP and self-life stock monitoring reports.
• Developed dashboards and KPI’s using set analysis, variable creation etc. for individual payroll details, comparison with peer and comparison with the market.
• Performed testing of dashboards for functionality, data, performance, and UI design.
• Created weekly PDF report distribution for a set of users using Loop and Reduce functionality through QV Publisher.

Environment: QlikView 11/10, Oracle 9i/10G/11G, SQL Server 2008, Access, CSV Files, Windows 2008 Server, SharePoint.

Confidential, Memphis, TN

Qlikview Developer

Responsibilities:

• Involved in gathering requirement from Business Users and Developed Technical Documentation for the Business and Team.
• Created dashboards style of reports using QlikView components like Slider, Buttons, Charts and Bookmarks.
• Imported data from multiple data sources including Web files, MS SQL Server and MS Excel through OLEDB and ODBC connections and modeling data as per user requirements.
• Customized Qlikview Connection with appropriate reports and security measures.
• Developed QlikView (dashboards, reports etc), analyzed the Data and involved in gathering requirement.
• Designing the Logical model that conforms to star schema concepts, different views (Import, Business and External) as per Business requirement.
• Designed and developed dashboards with various levels of complexity including different kinds of charts and extensions.
• Maintained Row, Column and Sheet level Securities for all Major Dashboards using Section Access.
• Implemented incremental load by creating QVDs and some cases of Incremental Load such as Insert, Insert & Update and Insert, Update & Delete.
• Modifying the existing reports based upon the change requested by the user. Involved in resolving Performance issues with various reports.
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.
• Writing the test cases for SIT (System Integration testing) and UAT (User Acceptance testing).
• Resolved issues resulting from User Acceptance Testing (UAT).

Environment: QlikView 9/10, Oracle 10g, SQL Server 2008, Access, MS Excel, XML Files, Windows 2003 Server, SharePoint

Business Analyst

Responsibilities:

• Gathered, Detailed and Documented requirements related to online sales and Distribution of different products in order to develop Marketing Websites
• Facilitated with team of two business analyst to elicit requirements in Joint Application Development (JAD) sessions by communicating with various background and skills, documented Scope Definition, Functional Specifications, Use Case document, Software Requirements Specification (SRS) and created User Interface Mockups/Prototypes using Ms Visio.
• Performed the full spectrum of Web-related tasks, including rapid prototyping, design and layout, graphics creation and optimization, standards-compliant HTML and CSS, testing, training, hosting, security, traffic generation and ongoing updates.
• Maintained project plans, task, defect and issues lists, lead meetings to discuss all aspects of the project’s execution, developed test scripts, executed UAT, participated in the QA process, and developed training materials and system documentation.
• Designed different types of triggers at the sheet level and document level of dashboard.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• Developed test scenarios and implemented test plan. Assisted in testing the application and
• Setup Mercury Quick Test Pro to Regression test functionalities of the ecommerce portal
• Configured Mercury LoadRunner, developed scripts and executed these scripts to load test the ecommerce portal
• Performance tuned SQL queries to improve build process on large amounts of data. Also helped business to improve the adhoc sql process retrieval time.
• Configured UI, transaction flow and business rules on JDA Win/DSS as per specifications provided by business users

Environment: Microsoft Suites (Word, Excel, PowerPoint, SharePoint, Visio) HTML, CSS, MySQL, Web Forms, JavaScript, PHP, Adobe Dreamweaver, Microsoft FrontPage, Adobe Photoshop, JDA, Windss, Magic (CRM application), LoadRunner

Confidential

Business Analysts/Project Coordinator

Responsibilities:

• Led requirement gathering and documentation for Project Charter, Business Case, Business Requirements, Business Rules, and Functional Requirements, Supplementary Specifications, Activity diagrams, Use Case diagrams and process flows
• Facilitated business requirements gathering sessions with the client, and overlooked the creation of Use Cases/Activity Diagrams, Functional Specifications using UML/Visio.
• Utilized Agile methodology to configure and develop process, standards, and procedures
• Generated MIS for M-Xtasy World (Customer Loyalty Program) of Planet M & Data Analytics for the same including RFM
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based Business Requirements, technical specifications and/or product knowledge.
• Used MS Office suite (Word, Excel, Access, Visio, Power Point, Outlook, and Project) for project tracking, documentation, and presentation to senior management.
• Extensive Business Process Modeling. Authored detailed business process documents to document existing business process and developed efficient to-be business process models.
• Customized UI and workflow on Retail Pro software as per specifications provided by business users
• Created career application web form using HTML, JavaScript
• Involved in integration of the Retail Pro software with payment gateway
• Key achievements: Successfully configured Retail Pro third party software without prior knowledge or training of the tool. Was given additional responsibilities of managing the portal team and MIS reporting within one year.

Environment: MS Visio, DreamWeaver, SQL, PLSQL, XML, VB, ASP, Adobe Photoshop, Mercury TestDirector, WinRunner, LoadRunner HTML, CSS, Adobe Dreamweaver, Microsoft FrontPage, Adobe Photoshop, RetailPro, Magic.