SUMMARY:

• Around 5+ years of IT experience in all aspects of Business Intelligence applications with a strong background in Database development, in Business Analysis, System Analysis, Data analysis, software design, Data warehousing and Business Intelligence environment.
• 4+years of experience in designing, implementing and maintaining QlikView suite of Products (QlikView Server, Publisher and QlikView Enterprise) with comprehensive experience in planning, designing and building BI Dashboard and Analytics Reporting solutions with both QlikView and Tableau.
• Experienced in gathering user requirements, analyzing and preparing Project Deliverables and proposed changes for process improvement.
• Worked with user groups to provide training, resolve questions, assess user needs, and recommend changes.
• Participates in transforming strategic enterprise architecture and design principles into specific system requirements and specifications.
• Work with business community to document functional Test scenarios , Test plans , and end - user acceptance testing criteria .
• Summarizes moderately complex business cases, system information and concepts and clearly communicates to leadership.
• Worked on different QlikView Version QV 12/11.2/11.0/10 and QlikSense 2.2/3.0.
• Experience in Full Life Cycle development including Planning, Analysis, Design, Implementation and Maintenance using QlikView.
• Good at working with Data Warehousing and other business intelligence tools for developing various reports using QlikView BI.
• Excellent knowledge in designing and developing dashboards using QlikView by extracting the data from multiple sources (Oracle, Flat files, Excel, Access).
• Good Knowledge and experience of 1 year in Creating Dashboards in Qlik Sense.
• Maintained Three-Tier architecture across all QlikView dashboards.
• DAR (Dashboard, Analysis and Reporting) approach is maintained throughout dashboards.
• Hands on experience with SQL Database. Strong skills in designing and developing of relational database management objects and database design principles using SQL database system.
• Actively participated in migrating applications from QlikView to QlikSense and took part in resolving critical compatibility issues during migration.
• Experience with Qlikview sheet objects Pivot, List, Multi box, Multiple charts types, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Review monthly, quarterly and annual operations metrics and present analytical results to senior management
• Experienced in implementation of QlikView security by authentication, authorization at document level and data level to the end users.
• Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, Automation and Macros interface, Section Access, Set Analysis in QlikView and DW concepts.
• Experience in developing Story Boards, Screen Mockups, and Screen Flows for design feedbacks.
• As a key member of Agile Team actively participate in user story Backlog Grooming, Sprint Planning, Retrospective and other ceremonies.
• Collaborate with Agile Team and business stakeholders to ensure quality and value of Agile Team deliverables
• Good in validating (Tracebility Matrix, Design Indexes) the BI reports/dashboards.
• Excellent work ethics, self-motivated, quick learner and team oriented. Continually provided value added services to the clients through thoughtful experience and excellent communication skills.

TECHNICAL SKILLS:

ETL Tools: QlikView (12.0/11.20 SR3, 11 SR1, 10 SR4), QlikView Management Console, Tableau (9.x 8.x / 7.x),ServiceNow, Informatics Power Mart 4.5.2, 4.7.3 and 5.1.1, Power Center 1.7 and 5.1.2.

Database Technologies/RDBMS: Oracle 9i/10g/11g, SQL Server, Teradata, MySQL, DB2, SSIS, Teradata,PL/SQL

Documenting and Data Modeling Tools: MS Visio, MS Project, MS Office(Word/ Excel/ Access/ Power Point), SharePoint, Documentum.

Scripting/Language: C, C++, HTML, SQL, PL/SQL, XML

Operating Systems: Windows 10/7/Vista/XP/2000/NT, Server 2014/2012/2008 R2/2003, Exchange 2003.

PROFESSIONAL EXPERIENCE:

Confidential, Milan, IL

Business Support Analyst/QlikView Developer

Responsibilities:

• Act as a strategic partner between the business community and IT development teams to resolve functional and technical issues related to business applications, to troubleshoot data or transaction issues within the context of projects; promote use and acceptance of project methodology and documentation standards.
• Involved in reviewing business requirements and analyzing data sources from Excel/SQL Server for design, development, testing, and production rollover of reporting and analysis projects using QlikView Desktop .
• Worked closely with Business to design, develop and enhance the Reports.
• Excellent technical, analytical, and problem solving skills. Strict attention to detail and ability to work independently as well as within a team environment.
• Work closely with business partners to understand their needs.
• Creates weekly and monthly project reports that include correlation trends analysis and Sprint updates of the Agile teams.
• Contribute extensively to project charters, project plans and schedules in collaboration with project managers, sponsors, and business team members.
• Conducts follow-up meetings to solicit feedback from users and management to gauge the success and acceptance of projects.
• Involves in Developing and updating key performance metrics, perform analysis.
• Facilitates project scope changes, and prioritization.
• Works with user groups to provide training, resolve questions, assess user needs, and recommend changes.
• Participates in transforming strategic enterprise architecture and design principles into specific system requirements and specifications.
• Provide Tier1 support for ServiceNow resolving functional and system errors/issues tickets and identifying or escalated by Business Partners
• Develops QlikView scripts to load the transformations and make enhancements to the user interface of the desktop application.
• Summarizes moderately complex business cases, system information and concepts and clearly communicates to leadership.
• Work with business community to document functional test scenarios, test plans, and end-user acceptance testing criteria.
• Creates Test Plan, Test Case, Test Procedures and Test Metrics.
• Administered user, user groups, and scheduled instances for reports in QlikView.
• Trained Distribution Center, Planning and Purchasing & Finance Teams on how to use QlikView applications.

Confidential -San Diego, CA

QlikView |Qlik Sense Developer

ROLES AND RESPONSIBILITIES:

• Analyzed the reporting requirements with the business users and came up with the technical specifications.
• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Designed 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.
• Implemented Qlik Sense Extensions, workbench and embedding in websites.
• Converted the QlikView documents into QlikSense apps using the QlikView converter tool in the Dev Hub.
• Worked on Qlik Sense App development, templates, story generation, data modeling and Qlik Sense app performance optimization.
• Developed dashboards in QlikSense to replicate existing QlikView Dashboards/reports.
• Designing and building of Dashboards & Scorecards, KPI's based on an existing Semantic layer in QlikSense.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher
• Involved in up-gradation of QlikView environment from QV 10.0, QV 11.0 versions.
• Actively participated in migrating applications from QlikView to Qlik Sense and took part in resolving critical compatibility issues during migration.
• Designed, developed, implemented and tuned multiple QlikView applications for the Sales, IT, Manufacturing, Purchasing & Finance QlikView applications.
• Performed NPrinting reports in a number of formats, including Word, Excel, PDF, JPG.
• 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
• Wrote SQL Scripts, procedures and views which are required for QlikView projects.
• Monitored the various services in QMC, Task setup, Managing client licenses, Mounting folders, session collaboration, enable session, performance and audit logging, type of authorization(NTFS and DMS),loop and reduce and Section access management in PAT.
• Configured and deployed the application on QlikView server and Imported data from different sources like Oracle, 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.
• Trained Distribution Center, Planning and Purchasing & Finance Teams on how to use QlikView applications.
• Testing dashboards and data validation.

Environment: QlikView12,11x/10(Desktop, Server/Publisher, Access Point), Nprinting for QlikView (14.03.), Qlik Sense 3.0/3.1, SQL Server/ 2008/12, Tableau, Informatica, Windows XP/7.

Confidential -Santamonica, CA

QlikView Developer

ROLES AND RESPONSIBILITIES:

• Consolidated two existing QlikView applications into one.
• Created POC’s, proposed and documented the requirements to the user for consolidated application.
• Did the analysis of the application regarding user experience (Front end), QlikView data model change, volume estimation, QVW size estimation, BI processing time saved after consolidation.
• Did testing in two different servers and validated the data.
• Resolved the failure issue of existing publisher job in Production server.
• Validated the data of the reduced QlikView files.
• Performed NPrinting reports in a number of formats, including Word, Excel, PDF, JPG.
• Created User Interface and prepared layouts for the system by using QlikView.
• Performance tuning of QlikView & Qlik Sense apps for faster data reloads and efficient response times.
• Trained all End Users on how to use Qlik and handle troubleshooting.
• Implemented security using QlikView section access that dynamically hides selected areas of the dashboard depending upon user privileges.
• Analyze customer requirements and develop proposals of technical solutions as needed.
• QlikView best practices were used in implementation of scripting, set analysis and usage of variables.
• Involved in performance tuning of dashboards to limit the response time and enhance the functionality.
• Designed and developed QlikView software applications and server-based QlikView dashboards from scratch to support BI initiatives.
• Implemented Section access and hidden scripting for the Application Security.
• Hands-on experience in setting up new task and troubleshooting existing task setup and other issues.
• Configured and deployed the application on QlikView server and Imported data from different sources like Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.
• Identified data sources and targets for data modeling and solution architecture.

Confidential -Warrendale, PA

QlikView Developer

ROLES AND RESPONSIBILITIES:

• Extracted the data from various data sources such as databases, Excel documents and CSV files, transforming the data into standard format and load the data so that it is available for analyzing and creating reports.
• Excellent technical, analytical, and problemsolving skills. Strict attention to detail and ability to work independently as well as within a team environment.
• Worked closely with Business to design, develop and enhance the Hyperion Reports.
• Strong understanding in creating Dashboards for the required KPI’s in QlikView.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Developed QlikView scripts to load the transformations and make enhancements to the user interface of the desktop application.
• Application processed tables with over 20 million records.
• Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys.
• Created Dashboards style of reports using QlikView /Qlik Sense components like List Box, Slider, Buttons, Charts and Bookmarks.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Involved in performance tuning of dashboards to improve the response time for the users accessing the documents via access point by reducing the size of the QVW
• Created batch scripts to process the data periodically as per the business requirements.
• Performed visualizations with self-service capabilities, where end users can create reports and dashboards by themselves
• Split the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Experience in scripting QlikView Set Analysis.
• Performed NPrinting reports in a number of formats, including Word, Excel, PDF, JPG
• Created User Interface and prepared layouts for the system by using QlikView.
• Participated in the developing/enhancement of star schema dimensional data model.
• Used MS Access and QlikView extensively as reporting tools and to create user build specification.
• Wrote scripts and created batch files for automatic running of QlikView scripts.
• Worked on the UI for various applications

Environment: QlikView 10, Oracle 10g, MS Access, SQL Server, CSV files, QlikView Server and Publisher, Teradata, Power BI, AutoSys.

Confidential

SQL Developer/Tableau Developer

ROLES AND RESPONSIBILITIES

• Created T-SQL scripts to generate all the tables and relationships based on the finalized ER-Diagram.
• Created Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by a front end application.
• Utilized the Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Created database documentation for table and column dictionaries and other reference material.
• Implemented indexes on tables and views for optimum performance tuning.
• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop .
• Created dashboards by extracting data from different sources using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging different sources.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Optimized the existing queries to improve performance with the use of Profiler and Execution Plans.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: MS SQL Server 2012/R2,2010,2008, SQL Server management studio, Tableau Server 8.1/8.2, Tableau Desktop 8.1/8.2, Windows Server Standard R2,, Excel, MS SQL Server 2008R2.