Candidates About

 

 

 

 

Nandita Reddy

E

 

Professional Summary:

·      7+ Years of experience QlikView Development and administration with a strong background in Database development, Data Warehousing and Business Intelligence.

·      Experience in database design & development, database programming, data modeling, business process analysis, and application development.

·      Expertise in Creating QV data models, QV objects, Adhoc Reports and Data Visualizations using different data sources like Oracle, SQL Server, Cognos, QVD files using incremental load, Access, text files, excel documents as per the user requirement.

·      Experience in designing different Dimensional Data Modeling techniques (Star & Snow Flake Schema’s) based on need.

·      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 developing QlikView Applications by following Tier architecture.

·      Well-versed with Qlik View/Qlik Sense server architecture.

·      Worked on data modeling and developed different complex models as per given user requirement without any closed loops, synthetic tables and ambiguous relationships.

·      Experience with QlikView Sheet objects including like multiple Chart types, Bookmarks, Buttons, Containers, Trends, KPI’s, custom reports for Excel Export, Fast Change, Data Islands, variables, calculated expressions and aggregated functions for Management Dashboard reporting.

·      Expertise in using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc) and subroutines. 

·      Experienced in Incremental Loading using QVD files for optimizing data models.

·      Extensively used SET analysis expressions to develop different KPI's like MTD, QTD etc. over accountable Zones & time periods.

·      Developed Macros/Triggers, Java Script extensions and Section Access to provide custom functionality in QlikView Applications. 

·      Expertise in Optimizing QlikView Dashboards with a focus on usability, performance, flexibility, testability, and standardization using Document Analyzer.

·      Experience in QlikView Server and Publisher maintenance – scheduling and monitoring Incremental Loads and Report Reloads.

·      Expertise in creating databases, schema objects and optimizing SQL statements.

·      Implemented document chaining to drive through the channel and direct dash boards.

·      Extensive experience in Data Analysis, Reporting, ETL, Data Modeling, Maintenance, Testing and Documentation.

·      Experienced in Reduce Data, Distribute QlikView applications on to the Access Point using QlikView Management Console(QMC).

·      Hands on experience in customizing the QlikView and NPrinting for quick generation of reports as per the business requirements.

·      Solid hands-on experience in implementing new features of Qlik Sense like Storytelling, Pivot Table, KPI Object etc.

·      Extensive knowledge in CSS, HTML 5 and JavaScript which are highly useful in implementing Qlik Extensions and Sense solutions in an optimal way.

·      Excellent knowledge in Implementation of Relational Database (OLTP), Data warehousing systems (OLAP), FACT & Dimensions tables, Physical & Logical data modelling, Data Marts.

·      Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem-solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.

 

Trainings:

 

·         Underwent Qlik Designer Training by QLIK.

·         Underwent Qlik Developer Training by QLIK.

·         Underwent Qlik Master’s Training by QLIK.

 

Technical Skills:

 

Educational Details:

·         Master’s in Computer Science from University of Houston Clear-Lake, Houston, Texas.

 

Professional Experience:

 

Anthem Inc, Norfolk, VA                                                                                                            Dec 2016 –  Present                                     

Sr. QlikView /Qlik Sense Developer

 

Responsibilities:

 

·      Evaluate business requirements & perform impact analysis design and develop QlikView dashboards as per the business requirement.

·      Preparing system and unit test plan to ensure all the business logic and implemented correctly.

·      Implemented Section access and hidden scripting for the Application Security.

·      Designed various types of reports with Complex formulas and Custom Functions.

·      Designed reports with conditional formatting, Set analysis etc.

·      Monitoring of the QVS (Access Point), QVW’s and user accounts for the usage of the applications.

·      Wrote SQL Scripts to load relevant data in QlikView Applications.

·      Implemented the 3-tier architecture (Data Extract, Data Transform, Data model & Application) to develop different dashboards with a complex database system behind it which includes extracting data from the SQL Database and flat files, storing into QVD files, write load scripts, and develop UI according to user requirements.

·      Loaded the Extract QVDs into Transform QVWs and performed necessary transformations such as renaming the columns, Apply Maps, text to number or number to text conversions. Also performed Inner Joins, Left Joins and Right Joins to attain the desired resultant Data Set and stored it into Transform QVDs.

·      Loaded the Transformed QVD into a QVW and designed the Data Model as per the business requirement.

·      Used Apply Maps, Right Joins and Left Joins wherever necessary to reduce the no of tables in the Data Model to aid better performance of the Dashboard.

·      Resolved and removed any Circular Loops, Synthetic Keys by renaming or removing unwanted columns, using Qualify statement, performing Join operations and by concatenating the tables, using data islands.

·      Designed the Dashboard with various objects such as Pie Charts, Line Charts, Bar Charts, Combo Charts, Gauge Chart, Table Object, Straight Table, Pivot Table, List Box, Multi-Box,

Current Selection Box, Buttons, Slider Object, Text Objects, Bookmarks, Calendar Object, Search Object etc.

·      Aggregated the day level (Report Date) data to the month level (Report Month) to improve the Performance of the Dashboard.

·      Used Drill Down and Cyclic groups in Charts for better Data analysis. Used Set Analysis in the Expressions for various charts.

·      Followed best practices by documenting the Field Names and the Expressions in an Excel sheet.

·      Involved in Performance Tuning of QlikView dashboard.

·      Wrote an Include Script to rename the columns into proper business names for the better understanding of the users.

·      Experience in handling large applications with over 20M rows and associated with 98% density.

·      Interacted actively with the Testing Team and performed Data Validation, Identified and analyzed the data irregularities and pointed out key solutions.

·      Implemented Section Access on the QlikView Application.

·      Scheduled Data Extractions, Data Model and Dashboard Reloads using QlikView Management Console (QMC).

·      Test the applications using unit test cases, review checklists and data quality for quality assurance before delivering to the end users.

·      Used extension objects for creating custom charts in Dashboards.

·      Interacted with the Users on a weekly basis to get their feedback and made the requested changes.

·      Created and Scheduled Weekly QlikView custom reports extensions to distribute on email using NPrinting.

 

Qlik Sense Developer:

 

·      Actively involved in requirement gathering sessions with business analysts for Document preparation.

·      Developed Qlik Sense dashboards by importing QVDs and binary load to compare Qlik Sense design over QlikView.

·     Used a KPI/gauge object which has built in color switching to color code the fonts. 

·      Used QlikSense Functions (Date and Time, Join, Aggregation, Peek, Previous, Class, FirstSortedValue etc.) and Created Variables using LET, SET or control statements in the scripts. 

·      Worked with various Sheet Objects, Charts (including Drill Down and Cyclic field grouping), Treemap and Master Calendar.

·      Implemented Incremental load for the update of QVD’s, used Set Analysis for aggregations at granular levels.

·      Considered best practices of QlikSense and created heat map and KPI graphs.

·     Migrated applications from QlikView environment to Qlik Sense.

·      Experience in implementing Qlik Sense extensions using CSS, HTML and JavaScript. Obtained knowledge in creating, handling and troubleshooting of Workflows.

·      Hands-on experience in implementing new features like Creating Stories, Pivot Table, KPI Object etc. in QlikSense. 

·      Created Mashups to display visualizations from Qlik Sense Applications using Single Configurator and Mashup Editor (Qlik Dev Hub).

·      Implemented security through Qlik Sense scripting as well as QMC to restrict data as per users’/group privileges.

·      Conducted training sessions to users about the functionality and usage of application.

 

Environment: QlikView 12, NPrinting 16.6, Qlik Sense 3.1, MS Office, Windows 2008, SQL Server, HTML, CSS & Java Script.

 

International Finance Corporation, WASHINGTON, D.C.                                               Mar 2015 – Nov 2016                  

QlikView Developer

 

Responsibilities:

 

·      Collaborated with Business Leaders to share and gather QlikView requirements.

·      Worked on data modeling by extracting data from different data sources like SQL Server, MS Access and flat files as per the business requirements.

·      Wrote, Edited and Debugged ETL Scripts for data cleansing, resolving synthetic keys & circular loops.

·      Developed dashboard with a complex database system behind it which includes extracting data from SQL Database and flat files, storing into QVD files, write load scripts, and develop UI according to user requirements.

·      Developed straight table and bar charts for computing Year Ago, YTD, MTD, WTD measures.

·      Designed and developed different types of charts such as bar charts, straight tables, pivot tables, pie charts and gauge chart etc.

·      Created different types of sheet objects like list boxes, Buttons, Multi-box etc.

·      Developed set analysis and used macros to provide custom functionality in QlikView Applications.

·      Implemented section access, section authorization and sheet access to make the application available to desired users.

·      Configured and deployed the applications in the access point using QlikView server/publisher.

·      Scheduled jobs for incremental and full loads using publisher.

·      Successfully performed UAT before releasing to Production environment.

·      Involved in production support for various applications - Failure Analysis using error logs.

·     Improved the overall performance of the application and redesigned data model by applying QlikView performance tuning techniques using document analyzer.

·      Supported in modifying, testing and implementation of existing reports.

·      Communicated and trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.

·      Created daily, weekly and monthly reports for the management team based on the client requirements.

 

Environment: QlikView 11.2, NPrinting, PostgreSQL, MS-Access, MS-Excel, VB Script.

 

GlaxoSmithKline, RTP, NC                                                                                                                      Oct 2013 – Feb 2015

QlikView Developer

 

Responsibilities:

 

·      Involved in Requirements Gathering, Analysing and Documenting Business and Functional Requirements and Data Specifications for Data Visualization Analytics using QlikView.

·      Documented report requests in the form of Functional and Technical specifications.

·      Adopted Scrum methodology in the system development process.

·      Involved in Optimizing, Debugging and testing SQL queries written in Oracle.

·      Created Dynamic & customizable data visualization Models using QlikView against data sources including QVD, MS Excel, SQL Server and Oracle.

·      Designed QVWs to generate QVDs for faster and efficient data reloads.

·      Created different Metrics, Dimensions, Filters, Search objects, document and field event triggers, multiple charts (scatter, combo, pie, bar, straight, pivot using Drill down & Cyclic groups) and security filters allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.

·      Used QlikView Functions (Date and Time, Keep, Join, Mapping & String etc.) for creating dashboards, and designing the User Interface based on business/user requirements.

·      Implemented multiple levels of hierarchies.

·      Created User groups & data reduction to apply the data security for users.

·      Improved the overall performance of the application and re-designed data model by applying QlikView performance tuning techniques.

·      Converted Cognos reports to QlikView dashboards.

·      Manage, Schedule and Distribution of QlikView applications using QlikView Management Console (QMC). 

·      Co-ordinate with Testing team for QA and UAT.

·      Assisted less experienced Business users in using QlikView applications.

·      Tested QlikView Applications and reports using review checklists before delivering to the end users.

·      Allowed users with an ability to export/print PDF reports from the application.

 

Environment: QlikView, Cognos, SQL, Oracle 11g, CSV files, MS Office.

 

 

Gilead, Foster City, CA                                                                                                                   Oct 2011 – Sep 2012

QlikView Developer

 

Responsibilities:

 

·      Worked with business user to understand the user requirements, layout, and look and feel of the application.

·      Gathered & loaded data into QlikView from various data sources (SQL SERVER 2008, Oracle 10g, CSV, XML and Excel files).

·      Worked on large scale and data volume-based applications.

·      Provided executives and operational users with powerful analytic capabilities and detailed information on their operational performance.

·      Dashboards were served to track inventory and sales as well as to monitor various KPIs. Dashboards included customer detail drilldowns, threshold gauges.

·     Developed QlikView Dashboards using Chart Box (Drill & Cyclic Grouping), List, Input Field, Table Box, Buttons and Bookmarks.

·     Used Apply Maps, Right Joins and Left Joins wherever necessary to reduce the no of tables in the Data Model to aid better performance of the Dashboard.

·      Implemented advanced SET Analysis for aggregation calculations so that set of records can be defined in an expression.

·     Performance tuning by analysing the QlikView application using document analyzer.

·      Developed User Interactive Sheets & on demand Reports as per the business needs.

·      Communicated and trained the end users effectively to use the QlikView application, to build and customize their ad-hoc reports.

·      Performed different tasks like reload and distribution tasks using the QlikView publisher.

·      Scheduled QVW reloads on server and handled troubleshoot errors.

·      Rectified irregularities in existing mappings by analyzing the data flow. Redesigned and made necessary changes for improving the performance.

·      Migrated existing QlikView 10 dashboards to QlikView 11 environment, also added new QV11 features to the Dashboards.

·      Successfully passed through the QA Environment and implemented on Production and worked as post production support.

 

Environment: QlikView, SQL Server, Oracle, MS Office, HP Quality Center.

 

 

Value Labs, India                                                                                                                            Apr 2009 – Sep 2011                            

BI/QlikView Developer

 

Responsibilities:

 

·      Gathering and documenting requirements from the users and developed Complex Graphical User Interactive reports using various QlikView Objects.

·      Developed SQL Scripts, database objects, procedures, functions and packages to support the QlikView reports and dashboards.

·      Strong Skills in Data Modeling & Loading data from multiple data sources.

·      Worked with Incremental Loading & QlikView document Versioning.

·      Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.

·      Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.

·      Worked on requirement specifications for the strategic KPI's that drive performance and profitability in the division. Waterfall methodologies were followed during course of the project.

·      Performed analysis, documentation for calculation of various attributes.

·      Performance tuning of dashboards was carried out to limit the response time to well under 2 seconds.

·      Implemented Section access and hidden scripting for the Application Security.

·      Performed testing of dashboards for functionality, data, performance, look and feel.

·      Promoted dashboards to production environment and manage user access.

·      Developed Heat map charts with Alternate states for data visualization.

·      Developed KPI's, User Interactive Sheets as needed by the business.

·      Identified the highly memory consumption objects and performed necessary steps to reduce memory used by objects.

·      Analyzed end user requirements and developed technical solutions.