SUMMARY

• Over 9 years of strong experience in IT industry in the fields of Qlikview, Business Intelligence, Business Analysis with full project lifecycle implementation.
• 4+ 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, My SQL, Oracle 10G/11G

MS Office: MS 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, and bug-fixing, UAT and end-user training.

Environment: QlikView 10/11, Oracle 10G/11G, SQL Server 2008/2012, Windows 2008 Server, Hadoop and Netezza.

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.
• 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 10/11, Oracle 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

Confidential

Business Analyst

Responsibilities:

• Gathered, Detailed and Documented requirements related to online sales and Distribution of different products in order to develop Marketing Websites
• 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:

• 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.