SUMMARY:

• Good experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing / Decision support systems and Business Intelligence.
• Experience in designing and modeling of QlikView Applications using QlikView with complex multiple data sources (SQL, Flat Files, Excel and Access) relational designs.
• Experience in working with QlikView Desktop, QlikView Enterprise Management Console (QEMC), QlikView Publisher, and QlikView Web Server.
• Good working knowledge in all components of QlikView and interaction on Server and Publisher.
• Experience with QlikView sheet objects including Pivot, List and Multi box, multiple chart types, Trends, KPI's, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting.
• Strong knowledge on QlikView scripting, set analysis, aggregation functions, multi - dimensional objects, layout and design including chart properties and formats.
• Strong understanding in creating Dashboards and scoreboards for the required KPI's in QlikView .
• Experience in designing QlikView Document/User Setting Layouts to make consistent and professional optimized look to clients.
• Proficient in migrating reports from different platforms (such as Excel, Crystal reports) to QlikView.
• Ability to offer end-to-end solutions starting from requirements gathering, design, development and deployment of Business Intelligence applications.
• Experience in the creation of Extension objects using Qlik Capability APIs and QLIK Engine API
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC). Experience in Planning, Analysis, Design, Implementation and Maintenance using QlikView.
• Good Understanding of QlikView/QlikSense integration issues.
• Experience in1 tier, 2tier as well as 3 tire architectures of the QlikView.
• Good experience with the development and design of QlikView and Qliksense applications.
• Used QLIK Engine API to pass information between the Qlik Sense engine and the clients.
• Experience in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Experience in working with Data Warehousing and business intelligence tools for developing various reports using QlikView.
• Experience in Installing and Configuring QlikViewDesktop, QlikView Server and QlikView Publisher.
• Experience in writing SQL queries, Functions, Views and Stored procedures.
• Experience working within an Agile/Scrum environment.
• Experience in data modeling, data loading, data migration, data analysis.
• Performed different types of loads Partial Load, Optimized Load & Binary Load.
• Strong skills in providing custom functionality using Triggers, Set Analysis.
• Worked in close association with customers for requirement gathering and effective analysis.

TECHNICAL SKILLS:

Web Technologies: HTML, CSS, JAVA SCRIPT, PHP

Data Modeling tools: Dimensional Data Modeling Star Schema Modeling

Programming Languages: C, C++, SQL server

Databases: MS SQL Server 2012/2008

Visualization Tools: QlikView 11.2/11/10, Qliksense

Operating System: Windows XP, Windows Vista, Windows 7

QlikView Administration Tools: QlikView Server 11, Publisher, QEMC.

QlikView Security: Section Access, Conditional Hide/Show, Hidden scripting

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

QlikView Developer

Responsibilities:

• Extensively worked to confirm and clarify requirements and business logic.
• Analyzed the reporting requirements with the business users and came up with the technical specifications.
• Strong understanding in creating Dashboards, scoreboards for the required KPI’s in QlikView.
• Developed load scripts to work with multiple data sources (SQL, DB2, AS400, Excel, and Share point site).
• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Designed some applications to support the lending process and dashboard style of layouts using different components of QlikView Enterprise like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks etc.
• Involved in QV server administrator, administration for QV services, integration into IT infrastructure etc.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher
• Involved in End to End Unit testing when migrating the applications.
• Designed, developed, implemented and tuned multiple QlikView applications for the Sales, IT, Manufacturing, Purchasing & Finance QlikView applications.
• As a QlikView Admin Monitored reloading tasks, ram usage, access restrictions to the document and also involved in managing the server components. working with the 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
• Analyze customer requirements and develop proposals of technical solutions as needed.
• Wrote SQL Scripts, procedures and views which are required for QlikView projects.
• Good understanding in the area of monitoring the various services in QMC, Task setup, managing client licenses, mounting folders, session collaboration, enable session, performance and audit logging, type of authorization, loop and reduce and Section access management.
• Configured and deployed the application on QlikView server and Imported data from different sources like SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.
• Mainly designed and developed QlikView software applications and complex server-based QlikView dashboards from scratch to support reporting and Business Intelligence initiatives.
• Worked on dashboards related to Sales Analysis, Production over time and implemented performance tuning that offers fast and flexible access to all key information across the enterprise.
• Testing dashboards and data validation.

Environment: QlikView11.2 (Desktop, Server/Publisher, Access Point), SQL Server 2012

Confidential, Virginia, VA

QlikView Developer

Responsibilities:

• Involved in full project life cycle implementation (requirement gathering to production) of QlikView dashboards.
• Planned, designed, and developed QlikView BI dashboards and data integration in a highly complex global services environment, interfacing QlikView.
• Participated in Business Processes with the Business Analyst to understand the requirement and Reviewed High Level Design Documents, Functional Specifications documents with the Technical Manager.
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks.
• Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
• Review remaining requirements and evaluate feasibility, data elements and priority
• Used QlikView Functions (Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous etc.) and Created Variables using LET, SET or control statements in the scripts.
• Used advanced scripting, set analysis, VBScript macros, advanced aggregation functions and advanced charts for applications.
• Gathering data sources like QVD files, Excel, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Created QVD's & updated on timely basis as database updates.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Experiences on setup and maintain security for Dashboard
• Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team
• Prepare checklist full work that has been completed.
• Maintain and execute the technology roadmap for the Qlikview environment
• Created tasks for the auto reload/using create task wizard via QMC for couple of applications and Batch files (on servers) and used them to auto reload the QVW's while automating the ETL process.
• Used Section access and Sheet access to make the application available to desired users.
• Created weekly PDF report distribution for a set of users using Loop and Reduce functionality in QV Publisher.
• Successfully performed transition of knowledge from onsite to offshore team.

Environment: QlikView 11.2, QlikView Server / Publisher, QlikView Management Console, MS Excel, SAP, SQL Server, Windows Server 2008

Confidential

Business Analyst/ QlikView Developer

Responsibilities:

• Developed proof of concept to check the functional feasibility of the QlikView implementation.
• Strong understanding in creating Dashboards for the required KPI's in QlikView.
• Work directly with business users to define and prototype QlikView Applications .
• Work with senior management to plan, define and clarify dashboard goals, objectives and requirement
• Design, Develop, Test, debug and implement QlikView solutions based upon specified requirement.
• Extract, transform and load data from multiple sources into QlikView applications .
• Created QVD's & updated on timely basis as database updates.
• Deploy applications on production server and set up automated data reloads
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.
• Developed QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.)
• Set Analysis in providing custom functionality to QlikView Applications.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String& Input Fields).
• Created different publisher tasks like reload tasks, reduction tasks and distribution tasks using QlikView Enterprise Management Console.
• Gathered & loaded data into QlikView from various data sources (SQL server 2008, CSV and excel files).
• Monitoring of the QVS (Access Point), QVW's and user accounts for the usage of the applications.
• Developed User Interactive Sheets & Reports as business needs
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros
• Implemented Star & snowflake schema (confirmed dimensions). Writing SQL Scripts to load the relevant Data in QlikView Applications
• Developed Macros, SET ANALYSIS to provide custom functionality in QlikView Applications
• Testing Applications using review checklists, Data quality for Quality Assurance before delivering to the end users.

Environment: SQL Server 2008, Excel, Windows Server 2008, QlikView10