SUMMARY

• A Qlik specialist with 8+years of total IT experience in analysis, design, testing, development and implementation of client/server Business Intelligence applications.
• Expertise in working with DWH and BI tools for developing various reports using QlikView and QlikSense.
• 4+ Years of experience in working with QlikView desktop and Management Console in several domains like pharmaceutical, bank, supply chain management and health care etc.
• 1+ Year of experience in working with QlikSense.
• Highly expertise in migrating dashboards from any other BI tool to QlikView/QlikSense with better visualization.
• Used Qliksense to generate immediate analyses and insights for reporting from mobile platform.
• Experienced in different SDLC methods like Agile Methodology and involved in full life cycle project development, including design, coding, testing and implementation with ongoing product support.
• Good Understanding of Relational and Dimensional Database Concepts.
• Excellent understanding of data warehouse Architecture, Design and Procedures, ETL and Workflow.
• Expertise in MS SQL Server (BI) and SQL Programming.
• Proven capability in designing and creating database objects such as Tables, Views, Indexes, stored procedures, functions in SQL Server based on logical design model and business requirements.
• Experience in extracting data from various databases like SAP, Oracle, Terradata, Amazon RedShift etc.
• Hands on experience retrieving of external data to Qlikview Dashboard in terms of QVDs by making connection through ODBC and OLEDB.
• Expertise in installing and using third party connectors like SAP connector etc.
• Expertise in ETL (Data Extraction, Transformation& Loading), Data modeling, Report & Performance Tuning using QlikView.
• Involved in implementing the 3 - tier architecture (QVD Generator, QlikMart and UI application) as recommended in QlikView best practices guide.
• Strong analytical database design and Data Modeling (Star Schema, Snow Flake Schema) skills in QlikView and QlikSense.
• Expertise in designing in Qlikview with complex multiples data sources (SQL, Flat Files) relational designs and optimizing applications by using QVD's, removing non key fields and script variables (Loading phase).
• Expertise in using various loads such as incremental load, binary loads, partial load and preceding load etc. in QlikView.
• Expertise in using various functions in development of data model like Where Exists(),Get selected functions, If(), Distinct, Join, Concatenate, Resident, AutoNumber, Mapping load, ApplyMap, ceil, Len, calendar functions.
• Implemented, optimized large volume data models in Star, Snowflake format. Followed Best practices to eliminate synthetic keys and circular references in the model.
• Handled user security using section access.
• Designed QlikView Dashboards using Chart Box (Drilldown & Cyclic Groups), List, InputField, Table Box and Calendar & Data Island.
• Implemented DAR (Dashboard, Analysis and Reporting) approach across dashboards for better analysis.
• Expertise in showing the comparison analysis between the years, possible and excluded selections using Set Analysis and Alternate States.
• Developed so many extensions using Jscript like cloud charts, Venn diagrams etc. as per user requirements.
• Developed Macros to provide custom functionality in QlikView Applications
• Developed User Interactive Sheets & Reports as business needs.
• Experienced in Document Chaining.
• Expertise in QlikView Management Console.
• Expertise in configuration of server, publisher settings and configurations.
• Expertise in QlikView publisher executing PDF Distribution and Data Reduction.
• Experience in scheduling the task and setting up the triggers.
• Experience in configuration of NPrinting server, outlining with QlikView machine.
• Frequently used statements understanding Business Applications, Business Data flow and Data relations, Exception ability to quickly master new concepts and capable of working in-group as well as independently.
• Installation and configuring of Qliksense Desktop on Windows Server 2008 R2 Enterprise/cloud.
• Worked with Qlik technical support, any bugs related issues.
• Strong communication and Interpersonal skills and capable to collaborate with various stakeholders.

TECHNICAL SKILLS

Operating Systems: Windows XP, Windows Server 2003/2008, Unix, Solaris, AIX, and Linux

BI Tools: QlikView Desktop 10/11/12, QlikView Server 11, QlikView Publisher 11, QlikSense 2.0, Tableau, MicroStrategy

ETL Tools: Informatica

Data Sources: SQL Server 2008, Oracle 10g/11g, MS Excel, MS Access, SAP, Red Shift

Domains: Financial, Banking, Food, Hospital, Supply Chain Management, Pharmaceutical

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. QlikView Developer/Admin, Qliksense Developer

Responsibilities:

• Involved in full project life cycle implementation(requirement gathering to production) of QlikView dashboards.
• Ensure that the QlikView server processes continue to run and operate in the most efficient manner extracting, transforming and loading data from multiple sources into QlikView applications
• Monitoring and maintenance of all components that make up the QlikView platform
• Mentoring Company’s resources in the development and support of QlikView applications
• Driving the adoption of standards and governance to ensure company’s QlikView platform remains stable, reliable, and secure for all users
• Active participation in a collaborative work environment, across both IT and the business
• Integrated the data from different sources including Oracle, SQL server, excel, pipe delimited files as well.
• Created drill down group for customer level hierarchy.
• Pushed the application on web through access point.
• Implemented Security & involved in Deployment of QlikView Applications.
• Created Dashboards style of reports using Qlikview components like List Box, Slider, Buttons, Charts and Bookmarks.
• Performed architecture redesign of Qlikview BI platform running 60+ dashboards that improving availability, scalability and performance to accommodate high-volume data.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Created some triggers like Document on Open Action trigger to set current date, Field Event Trigger - on Select and On Change etc.
• Used Apply Map(), Map Substring(), Auto number () as part of some data modeling techniques while creating composite keys.
• Developed Fast Change Charts by using both Cyclic Groups (merged Expressions and also the fields) and Drill Down groups.
• Design, Build, Test, Debug the Qlikview application in QV Test server environment.
• Implemented Security & involved in Deployment of QlikView Applications.
• Enterprise Security: Domain security and Group Policy configurations.
• Resolved the QV CALs wipe out issue on Dev and prod Servers.
• Provided in-depth analysis for Low CPU RAM Utilization on Prod server and resolved the existing issue on same.
• Resolved the issue of Document Clear State with help of document trigger, conditional Variables/On Open of dashboard on the QV Acesspoint.
• Provided/revoked licenses (CALs) to the users on different server's application via QMC.(1100CALs n Cluster, 27, 96,250, 260 CALs on Dev, QA, Prod1, Prod2 respectively)
• Majorly involved in migration of dashboards from QlikView 11 to QlikSense 2.0.
• Installation of Qliksense Desktop on Windows Server 2008 R2 Enterprise.
• Developed the report by passing a Parameter Value to navigate from one KPI in Dashboard to another.
• Used a KPI/gauge object which has built in color switching to color code the fonts.
• Scripted using dollar sign expansion which is a text replacement that happens before the actual statement is parsed and evaluated.
• Implemented performance tuning techniques both in the scripting and UI.
• Created Line Charts to show different trends of Product Sales over years using set expressions, year function, max() function etc.
• Involved in the business requirement gathering and development of functional and technical specification documents.
• Extracted data from multiple complex hierarchies from cross table excel files.
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Multiple levels of Hierarchies are implemented such as Sales, Products, Partner, Customers and Service Hierarchy etc.
• Developed Fast Change Charts by using both Cyclic Groups (merged Expressions and also the fields) and Drill Down groups.
• Developed Bar Charts to show the total/Average sales of products for the current and previous years.

ENVIRONMENT: SQL Server 2008 R2, Excel, Windows Server 2008, QlikView 11.2, Red Shift, Toad, NPrinting, QlikView Server / Publisher, QlikView Enterprise Management Console, Qliksense.

Confidential, Reading, PA

Sr. QlikView Developer/Admin

Responsibilities:

• Involved in full project life cycle implementation (requirement gathering to production) of QlikView dashboards.
• Ensure that the QlikView server processes continue to run and operate in the most efficient manner extracting, transforming and loading data from multiple sources into QlikView applications
• Monitoring and maintenance of all components that make up the QlikView platform
• Mentoring Company’s resources in the development and support of QlikView applications
• Driving the adoption of standards and governance to ensure company’s QlikView platform remains stable, reliable, and secure for all users
• Active participation in a collaborative work environment, across both IT and the business
• Used advanced scripting, set analysis, VB Script and JScript macros, advanced aggregation functions and advanced charts for applications.
• Involved in performance tuning of dashboards to limit the response time and enhance the functionality.
• 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.
• Successfully passed through the QA Environment and implemented on Production and currently working as post production support
• Research and troubleshoot technical problems and Provided ongoing QlikView consultation to the development team
• Conducted User Acceptance Testing as part of SDLC process
• Good Experience in all QlikView functionality and knowledge in QlikView sever and publisher.
• Participated in daily scrums meeting.
• Strong team player working on all the areas of the project.
• 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.

ENVIRONMENT: QlikView 11 Desktop, QlikView Management Console, SAP, Microsoft Access, Excel, CSV.

Confidential

QlikView Developer

Responsibilities:

• Included the enhancement scripts to the existing QV scripts and performed the actual load to test the overall functionality of the application.
• Analyzed the existing QlikView data model, script logics and the ETL business logic for the existing QlikView applications.
• Imported data from multiple data sources including Web Services, MS SQL Server and MS Excel through OLEDB and ODBC connections and modeling data as per user requirements.
• Participate in enterprise DW / BI strategy/Dash boarding.
• Involved in utilizing QlikView solutions to develop complex reports and executive dashboard.
• Created Architectural Conceptual documentation and Technical Specification Documents.
• Creating complex data models without synthetic tables and circular loops.
• Create and manage ETL script generation using QlikView Script Builder Application.
• Provided ongoing QlikView consultation to the development team.
• Provide support analyst when internal teams have enquiries and trained business users.
• Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team.
• Extracted information from disparate data sources like excel files, QVD files, flat files, etc. by using different scripts like add, concatenate, resident, concatenate, qualify, unqualify, etc.
• Customized and tweaked the scripts for cross-tables and generic loads and created simple and complex expressions.
• Provided support analyst when internal teams have enquiries
• Research and troubleshoot technical problems Trained and users.
• Mentored and trained Business User Groups on using QlikView Tools.

ENVIRONMENT: QlikView10.0, SQL, PL/SQL, SQLLoader.

Confidential, St. Louis, MI

Informatica Developer

Responsibilities:

• Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectations.
• Analyzed the source data and identified business rules for data migration for developing data ware house and data marts.
• Used Informatica for Data Integration and ETL Purposes. Prepared design documents, ETL specifications and migration documents.
• Involved in Informatica Administration Tasks including Importing/Exporting mappings, copying folders over the DEV/QA/PRD environments.
• Created different Transformations for loading the data into target like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Created and monitored workflows/ sessions using Informatica Server Manager/ Workflow Monitor to load data into the Target Oracle database.
• Worked with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic, Persistence, Shared and Recache from Database), and Join cache while developing the Mappings.
• Handled slowly changing dimension (Type I, Type II and Type III) based on the business requirements.
• Performed unit testing on the Informatica code by running it in the Debugger and writing simple test scripts in the database; thereby tuning it by identifying and eliminating the bottle necks for optimum performance.

ENVIRONMENT: Informatica Power Center 6.2/7.1, Cognos 7.0, Erwin 3.5, SQL, PL/SQL, SQL Loader, Oracle9i, DB2 8.0, SQL Server 2008/2005, Windows 2000, Sun Solaris, Shell Scripting, Autosys.

Confidential

SQL Server Developer/SSIS/ SSRS

Responsibilities:

• Developed complex T SQL code for the application.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables
• Conducted performance tuning by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Design and developed reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Involved in the full development cycle process of Planning, Analysis, Design, Development, Testing and Implementation.
• Implemented star schema & snow flake schema (confirmed dimensions)
• Migrated databases among the servers using copy, attach/detach, copy/restored utilities.
• Developed Linked Tables, Concatenation and solved issues with loops.
• Executed Test cases manually Using Quality Center.
• Actively participated in full life cycle of QlikView application implementation and was responsible for design, development and delivery.

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