SUMMARY

• Certified QlikView Developer/Designer with 71/2 years of experience in design, development, and deployment of information using QlikView 12/11/10 as BI tool.
• Good hands on experience on Qlik Sense.
• Proficient in understanding the business community and translating the requirements into functional and technical specifications.
• Strong knowledge in Data Modeling, Data Mart and implementation of QlikView for providing Business Intelligence Reporting Solutions.
• Extensive experience in developing different analytical applications using QlikView suite of products.
• Strong skills in Data Modeling (Star Schema, Snow Flake Schema) & loading data from multiple data sources.
• Experience with QlikView sheet objects including multiple charts types, Trends, KPI’s, custom requests for Excel Export, and objects for Management Dashboard reporting.
• Strong experience in loading data using scripts like automate QVD’s, custom scripting to implement SQL functionalities.
• Extensively worked on developing dashboards, and metrics using performance management and QlikView, Qlik Sense enterprise.
• Expertise in using QEMC & QMC for creating tasks, managing schedules.
• Extensively used SET analysis expressions to develop different KPI’s like MTD, QTD etc. over zones & time periods.
• Good experience in QlikView development, analysis, server/publisher support.
• Worked on developing Qlik Sense reports using extensions like Idevio Map, Idevio Heatmap Layer, Idevio Area Layer, Images, and Gauge charts.
• Good experience and understanding of data warehousing concepts, ETL, Cubes and normalizations to translate business requirements into effective business intelligence solutions
• Strong skills in application development and extensive skills in OLTP/OLAP systems.
• Excellent skills with expertise in Data design and analysis using Oracle 10g/9i, MS SQL Server 2008/05, Excel, PL/SQL
• Goal oriented team player and a leader, with strong analytical & excellent communication skills.

TECHNICAL SKILLS

BI Tools: QlikView 11/10, Qlik Sense 3.1

Databases: Oracle 11g, 10g, MS SQL Server, MS Access

Packages: MS - Office (MS-Access, MS-Word and MS-Excel)

Languages: SQL, PL/SQL

Operating Systems: Mac OS, Windows 2008/2007/2005/XP

PROFESSIONAL EXPERIENCE

QlikSense Developer

Confidential, Chicago

Responsibilities:

• Worked with data solution architect to familiarize with the data structure maintained at Confidential
• Familiarized with the KPI of the health sectors
• Took training on the HIPAA regulations
• Majorly involved in front end visualization and data modeling.
• Developed clinical report called Ascension as per Qlik standards and business requirements.
• Implemented star schema.
• Dashboard was developed with charts like pivot table, combo charts and used extensions like simple field selection.
• Developed master items- Dimensions, Measures and visualizations, which were reused and was part of the Unit testing and UAT and supported in Prod environment.
• Prepared user training documents and involved in tool training to the users.

Environment: Qlik sense July 2017, cloud, python, Mac OS.

QlikView Developer

Confidential, Buffalo Grove

Responsibilities:

• Worked with Procurement team and gathered business requirements and created proof of concepts as per the requirement
• Majorly involved in data profiling and suggesting the format for data as per the business requirements.
• Developed reports for the Confidential financial team for its individual initiatives like Automation, Fire, Security and CoC. Reports for risk analysis team and legal team.
• Created reports as per the QlikView standards and business requirements.
• Implemented star and snow flake schema.
• Dashboard was developed with charts like pivot table, Line graph, and color trends.
• Was part of the Unit testing and UAT and supported in Prod environment
• Created various mappings and developed mapping reusability using mapping parameter and variables.
• Analyzed the existing data model, script logics and ETL logics for the existing dashboards

Environment: QlikView 12, Excel, flat files, MS Office, Windows7.

Data Warehousing - QlikView Developer

Confidential, North Chicago, IL

Responsibilities:

• Developed QlikView and Qlik Sense reports for the Confidential Supply Chain Planning Team.
• Collaborated with business users and cross functional teams to develop business requirement documents (BRD), define KPIs (Key Performance Indicators), and identify data sources.
• Dashboard gave the details of Forecast Error, Backorder and Customer Service KPI (Key Performance Indicators), Lead Times for the products of Confidential .
• Worked on the installation and license leasing for the QlikView 11.2 V and Qlik Sense 3.1
• Involved in analyzing the existing data model, script logics and ETL logics for the existing dashboards
• Knowledge of industry best practices in both business management and technology domains and developed the dashboard according to the Confidential Standards.
• Was part of complete project life cycle including documentation, analysis, and development and testing.
• Dashboard was developed with charts like pivot table, Line graph, and the color trends according to the business requirements.
• Implemented google maps using extensions like Idevio Map in Qlik Sense.
• Suggested the best UI for the business users and developed detailed design document, unit test document.
• Developed and conducted training programs for QlikView user groups and administrators.
• Successfully performed UAT before releasing it to the production environment.

Environment: QlikView 11.2, Qlik Sense 3.1, SQL Server, Oracle 11g, Toad, Excel, flat files, MS Office, Windows7.

Senior QlikView Developer

Confidential, Austin, TX

Responsibilities:

• Worked with the QlikView team in gathering and analyzing business requirements from various sources, ensuring the business needs and delivery feasibility.
• Worked on installation and configuration of QlikView.
• Created Dashboard of reports usingQlikViewcomponents like List Box, Slider.
• Developed Variables, Input boxes, calendar & Macros.
• Implemented Star schema.
• Developed linked tables, concatenation and solved the loops issues.
• Extensively worked on data modeling, star schemas, and optimizing data models for query performance.
• Extensively worked on extract,transform and load data usingQlikView scripting language.
• Developed analytical dashboards and reports that meet customer requirements.
• Delivered advanced/complex-reporting solutions such as Dashboards and Standardized reporting usingQlikView.
• Checked and updated environmental file, assigned task, path for QMC, QEMC.
• Worked on setting up new task, mounting on Access Point, troubleshooting already existing task setup and other issues.
• Good knowledge on NPrinting.
• Worked on in understanding the functional capabilities, interfaces, and considerations and determined the optimal design strategy for implementing requirements

Environment: QlikView 11, SQL Server, Oracle, MS-Access 2000 & Windows XP Professional.

Senior QlikView Developer

Confidential, Dallas, TX

Responsibilities:

• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Gathering business requirements and created functional and technical specs and worked with business clients to confirm and clarify requirements and business logic.
• Extracted information from different data sources like SQL Server, MS Access and flat files, etc. by using different scripts like add, concatenate, resident, qualify, un-qualify etc.
• Customized and tweaked the scripts and necessary data transformation, created simple and complex expressions (using Set Analysis).
• Worked extensively on data modeling and built QVDs as per business requirement. Optimizing applications by using QVD’s, removing synthetic keys and circular loop (Loading phase).
• Created dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Developed QlikView applications based on Incremental Load Transactions using QVD files.
• Involved in daily standup with business analysts and data architect to resolve the business issues and Data challenges. Worked independently and capable of multitasking & prioritizing in a fast paced and agile work environment.

Environment: QlikView10, MS SQL Server 2005, Oracle 10g, SQL, MS-Access 2000 & Windows XP Professional.

QlikView Developer

Confidential, Raleigh, NC

Responsibilities:

• Worked with Business Analyst and the Business user to understand the user requirements layout, and look and feel of the application to be developed
• Dashboards were developed and served to track all the way through Ship to final acceptance phase, which include installation, pre-warranty aging etc. Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms
• Setting up New task, mounting on Access Point, troubleshooting already existing task setup and other issues
• Participated in pre-sales activity working with prospective client, assisting with Technical contributions to win new business.
• Maintained Server for smooth QlikView development. Checked and updated environmental file, assigned task, path and triggers for QMC, QEMC
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources
• Helped end users to design test cases and worked through multiple UAT cycles
• Worked with QlikView 10.x, SQL Server, Oracle, SAP, Excel, flat files.

Environment: Oracle 11g, SQL Server, MS Office, Windows XP, QlikView 10

Developer

Confidential, CA

Responsibilities:

• Involved in Business requirement gathering and participated in process with different Business Segments in designing QlikView applications.
• Worked with business analyst to gather requirements.
• Extracted data from the SQL Server database wrote SQL load scripts and used joins to join the tables.
• Developed a Star Schema Data Model that suits the business requirements by eliminating synthetic keys and circular loops.
• Developed dashboard using Bar Charts, Line Chart, Text Boxes and List Boxes.
• Used Alternate States and Set Analysis to get the needs of the end users.
• Good experience in using the QlikView functions (Trim, Match, Like, etc.)
• Involved in enhancement of existing dashboards with new functionalities.
• Involved in analyzing the existing data model, script logics and ETL logics for the existing dashboards
• Oversee the development of QlikView applications
• Defined and maintain architecture and development standards for the QlikView environment
• Maintain and execute the technology roadmap for the QlikView environment
• Effectively identify and remediate issues and risks that impact the performance and reliability of the QlikView solution.
• Ensure consistency across applications as they are developed

Environment: QlikView 10, MS SQL 2005/2008, CSV files, MS Access, MS Excel.

Report Developer

Confidential

Responsibilities:

• Requirement gathering from the Clint side as per Customer Perspective.
• Preparing BRD’s as per the Business logics.
• Creating and validating the mappings from source systems to target systems.
• Designed Data modeling architecture.
• Worked on hierarchy Levels and developed hierarchies to support drill down reports.
• Creating reports with Cross-tabs and Sub reports.
• Involved in developing mapping to get the related values from source system.
• Designed the mapping with Filter and Expression, transformation to perform the data cleansing and scraping.
• Design the test mapping to perform various tuning operation.
• Perform unit testing on various development mapping.
• Involved in creating user access and supporting application.
• Involved in identifying the bottlenecks at the mapping level and session level.

Environment: Sql, Windows XP, MS Access, MS Excel.