SUMMARY:

• Over 8 years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing /Decision support systems and Business Intelligence.
• Expertise in QlikView 12.0 SR4, 11.0 SR5/SR12, 10.0 SR3, Qliksense 3.0,3.2 (Using Extensions) installation and upgrading existing version.
• Expertise in designing in QlikView & Qliksense data model using three layered architecture with complex multiples data sources (SQL, Flat Files, CRM,ERP, Web files) and optimizing applications by using QVD's, removing non - key fields and script variables (Loading phase).
• Experienced in developing or utilizing the Extension objects for Qlik sense as per the user requirements and modifying the extensions using Java script and HTML.
• Experience with QlikView & Qlik sense sheet objects including multiple charts types, Trends, KPI's, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI's.
• Experience in working with Data Warehousing and business intelligence tools for developing various reports using QlikView.
• Expertise in Installing and Configuring QlikView/Qlik sense Desktop, QlikView Server and QlikView Publisher.
• Proven expertise in analysing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Worked in close association with customers for requirement gathering and effective analysis.
• 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.
• Experience in database design & development, database programming, data modeling , business process analysis, and application development.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle ( SDLC ). Experience in Planning, Analysis, Design, Implementation and Maintenance using QlikView.
• Strong experience in UI Design by using different QlikView and Qlik sense sheet objects including multiple charts types, Trends , KPI's , custom requests for Excel Export , and Fast Change.
• Experience in 1 tier, 2tier as well as 3 tier architectures of the QlikView/Qlisense.
• Good expertise with the development and design of QlikView and Qlik sense applications.
• Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse
• Experience in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Developed and scheduled reports using NPrinting tool and implemented user security for the reports.
• Experience in working with Data Warehousing and business intelligence tools for developing various reports using QlikView.
• Expertise in Installing and Configuring QlikView Desktop, QlikView Server and QlikView Publisher.
• Experience in writing SQL queries, Functions, Views and Stored procedures.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Expertise in Installing and Configuring QlikView Desktop, QlikView Server and QlikView Publisher.
• Experience in data modelling, data loading, data migration, data analysis.
• Performed different types of loads Incremental Load, Optimized Load & Binary Load.

TECHNICAL SKILLS:

Web Technologies: HTML, CSS, JAVA SCRIPT

Data Modeling tools: Dimensional Data Modelling Star Schema Modelling,Snow Flake Modelling

Programming Languages: C, C++, SQL, QlikView Desktop

Databases: MS SQL Server 2005/2008

Visualization Tools: QlikView 11.2/11/10, Qlik Sense 3.x

Operating System: Windows

ETL Tools: Sql Server Integration Services (SSAS), SSRS

PROFESSIONAL EXPERIENCE:

Confidential, Jamesburg, NJ

QlikView/Qlik sense 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.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized QlikMarts.
• 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).
• 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.
• Evaluate the relevance of the data to support a specific investigation, to analyze, to determine the performance and sensitivity of the analysis, and to project next steps for refinement, or proxies to achieve the needed results.
• Determine appropriate tools and methods for specific projects to identify networks, predict future threats, or isolate and evaluate threat scenarios.
• Responsible for analyzing business needs to identify and propose solutions for business problems.
• Typically defines business requirements in the context of Data visualization tool like Qlikview, the role includes below responsibilities but not limited to Design and development of reliable, flexible, scalable and responsive Qlikview Reporting solutions
• Work with BI team and other functional teams on solution designs, business warehouse strategy and end-to-end testing
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, 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.
• Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team
• 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.
• Using QlikView and QlikSense functions such as Date and Time, Keep, Join, Mapping, and String & input Fields etc.
• Using QlikView Maps to show the reports and dash board for good visualization to the managers.
• QlikSense app performance optimization.
• Designed the QlikSense Governance and development cycle.
• Configured different QlikSense roles and attribute based access control
• Successfully performed transition of knowledge from onsite to offshore team.

Environment: QlikView 11.2, QlikView Server / Publisher, QlikView Management Console, Toad, SQL Server, Windows Server 2008, SME.

Confidential, Chicago, IL

QlikView/Qlik sense Developer

• 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/QlikSense.
• Work directly with business users to define and prototype QlikView/QlikSense Applications .
• Work with senior management to plan, define and clarify dashboard goals, objectives and requirement
• Design, Develop, Test, debug and implement QlikView/QlikSense 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 QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.)
• Created Pixel Perfect reports, Excel reports, PowerPoint reports and Word Reports using NPrinting tool.
• Determine appropriate tools and methods for specific projects to identify networks, predict future threats, or isolate and evaluate threat scenarios.
• Work in teams that include intel analysts, data and visualization experts, and software developers.
• Contribute to documentation validating reasoning, certainty, and completeness in synthesized information for technical validation as well as for briefings for CBP Officers.
• 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 2012, Oracle 10g, .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/Qlik Sense components like List Box, Slider, Buttons, Charts and Bookmarks
• Support the identification and analysis of transnational criminal organizations, their future actions, and their methods.
• Evaluate the relevance of the data to support a specific investigation, to analyze, to determine the performance and sensitivity of the analysis, and to project next steps for refinement, or proxies to achieve the needed results.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros
• Implemented Star & snowflake schema (confirmed dimensions). Writing SQL Scripts to load the relevant Data in QlikView/Qlik Sense 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, QlikView11.2, Qlik Sense.

Confidential, NYC, NY

QlikView Developer

• Created Proof of Concept to give a preview to business users on how the dashboard will look like.
• Gathered business requirements from business users by showing proof of concept, scheduling meetings and showing sample business case scenarios.
• Developed Data Model by integrating data from multiple data sources and developed visualizations based on the company’s 3 tier architecture.
• Audit Insight dashboards are designed to display important information across Audit Engagements, content management systems and data warehousing applications in one glance.
• Developed What if analysis to know the forecast of the business and answer different business questions.
• Automated report generation to user’s inbox and network folders using NPrinting.
• Created Qlik Sense applications by replicating the existing QlikView applications.
• Integrated data from different sources and RESTful web services using GET and POST methods.
• Designed security for the Qlik Sense applications using Section Access to restrict access to users based on their user id. This also reduces the data based on the permission defined in the security.
• Created Mash-ups for Qlik Sense applications where objects from Qlik Sense can be exported and viewed on an HTML page.
• Created training/user manuals and power point presentation for business users to help them understand the details in the dashboard.
• Used Extensions to create visualizations not available with out of box capability in Qlik Sense.
• Integrated Qlik Sense with R using connector to display visualizations using Predictive Analytics.
• Worked on allocating licenses, creating streams, access restrictions to streams and applications, scheduling tasks using Qlik Sense Management console.
• Worked on Team Foundation Server administration which included users and groups’ management to define security on applications, creating notifications and triggers and check-in policies.

Environment: QlikView 12, Qlik Sense 2.2, Sales Force, REST API, R Connector, MS Access, QVD, SQL Server 2011, SSRS, Salesforce, NPrinting 16, Jira, Agile Methodology, Microsoft Team Foundation Server 2012.

Confidential

QlikView Admin/Developer

• Provided complex KPI’s (Penetration) using set analysis.
• Requirements gathering, Impact Analysis and solution designing to in corporate the Business requests.
• Understanding the business functionality & Analysis of business requirements.
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports.
• 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.
• Create PDF push reports using QlikView report editor.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins. Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.)
• 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.
• Worked on Publisher to Automate and scheduled hourly/daily/weekly/monthly/EDX data loads of QVW documents and error notifications by email to assigned users.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher. Automated and scheduled daily/weekly/monthly data loads of QVW documents using QlikView Publisher.

Environment: QlikView 11.2, Remedy, SQL Server, Excel, CSV files, QlikView Enterprise Server, QlikView Server and Publisher.

Confidential

QlikView Developer

• Followed the agile pattern of working and work execution
• 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.
• Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Enhanced existing dashboards with new functionalities and established a secure environment using QlikView Section Access.
• QlikView data modeling by building the Star schema and resolving loops/synthetic keys.
• Extract, transform, cleanse, and load (ETL) data into Microsoft SQL Server, Staging Databases using Microsoft SSIS.
• 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, CSVFiles, Windows 2008 Server.

Confidential

SQL Server Developer

• Developed T-SQL code for the application.
• Modified the existing database by adding the tables and maintained relationships between the tables.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like billing, customer, and requests from the residential, business and large business databases.
• Created SSIS Dynamic Packages using variables and deployed the SSIS packages.
• Implemented Incremental loads using different kind of tasks using SSIS.
• Used Event Handlers for Exception Handling in SSIS packages.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created, Managed and Support existing reports using SSRS.
• Involved in creating, deploying and configuring reports according to the requirements using SSRS.
• Developed different types of Tabular Reports, Matrix Reports, and Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Developed cubes using SSAS involving multidimensional data.
• Supported various sectors like Development, testing, Production, Maintenance and Application teams.
• Conducted performance tuning by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Executed Test cases manually Using Quality Center.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Managed requests that came from the development team.

Environment: MS SQL Server 2005, ASP.Net, Management Studio, BIDS, Visual Studio 2005, MOSS, Integration Services, SSRS, SSAS, T-SQL, DTS, ETL, SQL Profiler, Windows 2003.