PROFESSIONAL SUMMARY:

• 6+ years of IT professional experience with 5+ years of rich experience in Designing and Development of Business Intelligence application with QlikView, QlikSense.
• Strong Knowledge & experience in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production support.
• Expertise in Creating Documents using QlikView 11.0/11.2/12 , QlikSense 3.1, using different data sources like SAP BW, Oracle, SQL Server, QVD files, text files, excel and generated dashboard as per the user requirement.
• Ability to write complex front - end QV scripting and expressions
• Partner with business leaders to establish or improve necessary Key Performance measures and develop optimized solutions for delivery of all measures
• Extensive knowledge with Dimensional data modeling, star schema, snow flake schema, Fact and dimensional tables.
• Experience in designing different types of charts (drilldown, cyclic groups) such as Bar charts, Line charts for Trend Analysis, Straight Tables, Pivot Tables, Pie charts etc.
• Ability to handle complex calculations and point in time reporting using Set Analysis (Set Expressions).
• Strong experience in UI Design by using different QlikView sheet objects including multiple charts types, Trends, KPI’s, custom requests for Excel Export, and Fast Change.
• Experience in working with extension objects.
• Performance tuning QlikView Applications for faster data reloads & efficient response times.
• Experience in Creating and scheduling jobs using Qlikview Publisher.
• Involved in Optimizing existing QlikView dashboards with a focus on usability, performance, long-term, flexibility, and standardization
• Implemented data and object level Security in Qlikview applications with section access method.
• Was actively involved in server migration and the fresh QlikView installation process
• Created Triggers and Distributed QV applications to production using QEMC.
• Excellent working knowledge in BI Analytics, Data Warehousing Models, RDBMS concepts, SQL, PL/SQL.
• Strong data analytical and debugging skills to ensure accuracy and data integrity.
• Ability to adapt quickly to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem-solving skills, ability to adapt, learn new technologies and get proficient in them very quickly

TECHNICAL SKILLS:

Business Intelligence Tools: QlikView 12.0,11.2,10, QlikSense 3.1

Languages: SQL, PL/SQL, C, Java

Database Technologies: SAP BW, Oracle 12c/11g/10g/9i, SQL Server 2008/2005

Operating Systems: Windows, UNIX

Scripting Languages: HTML,XML

Domains: Healthcare, Pharmaceutical, Retail

Others: MS Access 2013, MS: Excel 2013, MS Visio 2010

WORK EXPERIENCE:

Confidential, Pleasanton, CA

Qlik Consultant

Environment: Qlikview 12, SQL Server, Teradata, Oracle, Windows Server 2008 SR2, MS Excel

Responsibilities:

• Actively involved in Item Conversion project.
• Work closely with our Data Conversion team to develop our data infrastructure to provide access to information and expand reporting capabilities.
• Extracted data from Oracle, Teradata, SQL Server and stored the tables in QVD’s
• Used Link tables to resolve loop issues and synthetic keys and built suitable data model.
• Worked on Document chaining to link one application to other.
• Performed redesign of QlikView BI platform to improve availability, scalability and performance to accommodate high volume of data.
• Optimized existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Implemented Data and sheet level Security & involved in Deployment of Qlikview Applications
• Managed schedules and reloading of Qlikview data model QVDs and QVWs through Qlikview Management Console (QMC).
• Responsible for providing QlikView training for coworkers.
• Created Ad Hoc reporting for better serving the customers.
• Responsible for deploying the applications, creating tasks and publishing them.

Confidential, Fort Worth, TX

Qlik Consultant

Environment: QlikView 11.2/12, QlikSense 3.1, SAP BW, Oracle, Windows Server 2008 SR2, MS Excel

Responsibilities:

• Extracted the data from various data sources such as databases, CSV files, and Excel documents, transformed the data into standard format (QVDs) and load the data so that it is available for analyzing and creating reports.
• As a part of Support team was involved in supporting the existing QlikView applications and worked on complex enhancements and delivered them in time.
• Was responsible for interactions with business users and gather requirements.
• Create and leverage analytical approaches to perform analysis of domain specific source data to provide accurate statements and conclusions
• Involved in QlikSense initial setup and end to end development of QlikSense applications.
• QlikSense App development, templates, themes, master library items and story generation.
• Developed load scripts using functions like For loop, Apply Map etc.
• Developed Link Tables, Concatenation and solved the loops issues.
• Implemented Incremental loads to improve the load time.
• Worked on using extension objects in the front end for better visuals.
• Implemented advanced SET Analysis for aggregation calculations so that set of records can be defined in an expression.
• Testing Applications, reports using review checklists, Data quality for quality Assurance before delivering to the end users.

Confidential, Phoenix, AZ

QlikView Developer\Administrator

Environment: Qlikview 11.2 SR5, SQL Server 2008, Windows Server 2008 SR2, MS Excel

Responsibilities:

• Communicated with the business users to comprehend the requirements and Designed Functional.
• Developed different dashboards 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.
• Worked on Incremental loads which updates the QVD’s with new data to improve the load time in live data and also worked on large data warehouse.
• Developed load script using QlikView Functions (Date and Time, Keep, Join, Mapping, String, Interval match etc...)
• Developed Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island
• Setting up tasks using QEMC and created architecture for the interdependent applications and executed in proper order
• Created document chaining, linking to navigate from one application to another
• Also distributed respective pdf files from QVW’s to respective users through PDF Distribution
• Implemented data level and object level security with section access method
• Involved in Production Support for QlikView applications & Server.
• Performing Unit and Integration testing, validation and sanity checks on the deliverables
• Work with existing systems to track and manage requests and issues. Pro-active monitoring to ensure performance on the server

Confidential

BI Developer

Environment: QlikView 10 SR4, SQL Server, MS Excel, Windows Server 2008 SR2

Responsibilities:

• Analyzed the reporting requirements with the business users and came up with technical specifications.
• Extracted data from Oracle through OLEDB connectors, stored tables in QVD’s
• Responsible for creating effective Data Models as per the requirement.
• Designed and Customized Dashboard pages like Forecast Analysis, Budget Vs Actuals, Supplier Report, Invoice Details etc.
• Used different sheet objects such as Straight table, Pivot table, Pie Chart, Bar chart, line chart and gauge charts.
• Experience with Set Analysis to provide custom functionality in applications
• Involved in production support for various applications
• Improved the overall application performance by redesigning the data model using QlikView performance tuning techniques.
• Extensively used SQL to create Insert programs for loading data.
• Modified existing procedures according to new enhancements.
• Performed data partitioning.
• Assessed the pros and cons of migration and conveyed the same to the Business Analyst.
• Developed complex Stored Procedures, Triggers, and Functions.
• Written stored procedures for those reports which use multiple data sources.
• Worked on Joins for many tables in SQL (Self joins, Left joins, Right joins…. etc.).