Candidates About

Preethi Manne

Qlikview developer

                                                    

 

●      Over 4+ Years of real time IT experience in Architecture, analysis, design, development and implementation of QlikView and QlikSense applications.

●      Extensively worked on QlikView to implement applications as per client requirement

●      Expertise in QlikView performance optimization.

●      Strong experience in designing and developing dashboards using QlikView by extracting data from multiple sources (Oracle, Flat files, Excel, Access).

●      Extensively worked on Data Analysis/Mining using QlikView.

●      Worked on different QlikView objects like straight tables, line charts, bar charts and pivot tables Etc.

●      Expertise in Installing and Configuring QlikView/QlikSense Desktop, QlikView/QlikSense Server, QlikView Publisher and also QlikSense Server.

●      Designed and implemented the Incremental Loading using QVDs so that instead of reloading the entire data from the database, QlikView would only load the data worth of one day and concatenate it to the Old Data which is already stored in QVDs.

●      Expertise on set analysis, advanced aggregation and section access.

●      Hands on Experience with QlikView Architecture in development and deployment.

●      Expertise in the Qliksense SDLC and governance.

●      Extensive experience with QlikView sheet objects, scripting, and optimizing applications and building QVD’s and QVW’s.

●      Extensive experience in using NPrinting for quick generation of reports and QlikMaps analytics engine.

●      Can write and analyse complex SQL queries.

●      Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports. 

●      Strong understanding of Dimensional Modelling 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.

●      Job roles include gathering business requirements, establishing functional specifications, translating them to design specifications.

 

 

Dash boarding/Analytics	QlikSense, Qlikview 11.0/10.0/9.0, Qliksense 2.0, Tableau, Microsoft SSRS, Cognos, Power BI, Tibco, Spot fire, Micro Strategy, Crystal Reports.
Languages	SQL, T-SQL, PL/SQL, C, C++
Database Technologies	SQL Server, Oracle 10g/11i, SQL Server, Toad, Teradata, DB2, MS Access.
ETL Tools	Informatica, Cognos, SSIS, SSRS
Operating Systems	Windows7/XP/Vista, Windows 2000/2003/2008 Server, UNIX

 

Client: Exelon, Philadelphia, PA                                                                                                       Mar 2017- Till Date                                                                                                     

Role: QlikView /Qliksense developer

 

Responsibilities:

•          Responsible for Building, publishing customized interactive reports and dashboards, report scheduling using QlikView server.

•          Experience in working with QlikView server to create data sources, creating users and QlikView installation   and   providing training to Business users in using QlikView.

•          Have Experience in deploying advanced metering infrastructure (AMI) systems in centralized operations centers that provide real-time, end-to-end monitoring, analysis and management of the systems.

•          Have Experience in management responsibilities for a component of the AMI system to include the meter data management (MDM), information technology (IT), communications and metering hardware.

•           Responsible to convert all business objects and excel reports to QlikView reports and dashboards.

•           Created metrics, attributes, filters, reports and dashboards, created advanced chart types, visualizations and complex calculations to manipulate the data. 

•           Experience in designing and deploying rich Graphic visualizations with Drill Down and Drop down menu option and Parameterization using QlikView.

•           Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire QlikView development life cycle.

•          Responsible for Self-Business analysis tool QlikSense initial setup and end to end development of Qlik Sense applications.

•          Create, manage, clone, and delete nodes in QlikSense sites that are deployed in cloud computing environments.

•           Worked as QlikSense administrator to optimize Qliksense performance.

•           Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server, Oracle, binary QVW, Inline & txt files in creating the QlikSense dashboards.

•            Worked with Dashboards style of reports using all the QlikView components like List Box, Slider, Buttons, and Charts etc. 

•          Developed Set Analysis to provide custom functionality in QlikView applications 

•          Worked towards optimal development of universe by resolving loops through the use of aliases and contexts. 

•          Created daily, weekly, monthly and quarterly reports for the management team based on the Customer requirements. 

•          Experience in Qlikview Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads. 

•           Involved in to create Hierarchies from providing dill down options for the end-user. 

•          Worked with Sheets and Sheet Objects in QlikView. 

•          Designed and delivered complex dashboards.

•          Expertise in ETL (Data Extraction, Transformation & Loading), Data modeling, Report designing and Performance Tuning using QlikView. 

•           Experience in all phases of project life cycle. 

•          Generate QVD files created by ETL logic to feed QlikView applications 

•          Experience in Incremental Loading & QlikView document Versioning. 

•          Strong understanding of Dimensional Modeling technique, Multi-dimensional database Schemas like Star Schema, Snow flake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts.

Environment: QlikView 13,QlikMaps, Qlik Sense 3.1, SQL Server 2008 R2, MS Access, MS Excel, Flat Files, Windows Server  2008, .PL/SQL, CSV Files.

 

Client: Capital Groups, SanAntonio, TX                                                                                Sep 2015-Feb 2016                                                                                                                                                                     

Role: Qlikview Developer

 

Responsibilities:

·         Developed Scripts to load the relevant Data in QlikView Applications. 

·          Implemented set analysis in QlikView Applications. 

·         Experienced in migrating reports from Business Objects to Cognos. 

·         Maintain Cognos Roles and groups within cognos environment. 

·         Used Cognos SDK to customize the cognos connection Portal. 

·          Knowledge of metrics and values calculated for financial documents/statements.

·           Experienced in balance sheets, income statements, cash flow statements.

·         Developed dashboards for data analysis with strong programming skills.

·         Created QVD'S & updated on timely basis as database updates.

·         Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys. 

·         Data Extract would load the Data from the data sources into the QVDs, Data Model will define the relationships between the tables(QVD) and Application layer is User Interface Design layer where we layout all our Charts, Tables and List Boxes. 

·         QlikView data modeling by building the Star schema and resolving loops/synthetic keys.

·         Performance tuning of dashboards was carried out to limit the response time to well under 5 seconds on calculation and defining server sizing for optimal performance of QlikView dashboards. 

·          Maintain tested applications for quality assurance and production support. 

·         Creating mock up with the sample data, created model with Extract, Transformation and Data Model in QlikView.

·         Debugging the QlikView server issues through server logs, Fiddler logs.

·          Developed SQL scripts to load business data and used VB macros and set analysis to create customized reports for regulatory reporting.

·         Developed KPIs and set analysis application with QlikView functions (join, concatenate, keep, apply map). 

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

·         Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.

·         Expertise in working with multiple modules of business with QlikView. 

·         Optimizing 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. 

·         Experience working in Agile environment with user stories executed in 2 week sprint cycles.

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

·         Stored the tables as QVDs and used Scripts to generate appropriate fields that help in modelling the data accordingly the requirements. 

 

Environment: Qlikview11, QV publisher, QV access points, QMC, QVWS, SQL server2008, CSS, HTML.Server 2008, .CSV Files, Oracle 10g,SQL Scripting.                                                                                 

Client: New Zen InfoTech, Hyd India                                                                                   Aug 2012–May 2014.           

Role:  Qlikview Developer

 

Responsibilities:

·         Full life-cycle development and implementation of QlikView for a packaged Help Desk/Service Desk module. Involved in Analysis, design, installation & implementation of the BI solution. Converted and enhanced an older Oracle Discoverer BI solution and implemented QlikView.

·         Use of Set analysis and aggregation functions for sheet objects. 

·          QlikSense data modelling.

·         Hands on experience in implementing the new features of QlikSense like Story Telling, Beta maps integrations, Pivot Table, KPI Object etc. 

·         QlikSense app performance optimization.

·          Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView/QlikSense. 

·         Designed the QlikSense Governance and development cycle. 

·         Configured different Qliksense roles and attribute based access control.  

·          Expertise in QlikSense data modelling, master items and maps 

·         Extracted data from the database, stored into QVD files, and wrote load scripts.

·         QlikView data modeling by building the Star schema and resolving loops/synthetic keys.

·         Used QlikView Scripting and Complex SQL coding for loading, and transforming.

·         Use of Set analysis and aggregation functions for sheet objects.

·         QlikView dashboards optimization.

·         Involved in analyzing existing complex systems to understand and document data elements, relationships, data flow, dependencies related interfaces and data visualization. 

·         Strong working experience in Load script and Data modeling.

·         Building the QlikView extensions.

·         Working with all types of data loads and functions like Automap.

·          Working experience with SQL/Server T-SQL, SSIS and SSRS (MSBI).

·         Enhanced existing dashboards with new functionalities and established a secure environment using QlikView Section Access.

·         Implemented drill down and cyclic dimensions.

 

  Environment: QlikView 10, QlikView dashboard, Qliksense 3,Business Objects, SVN, Oracle 10g/11g,Subversions, MS Access, MS SQL server, Agile Methodology.

 

_____________________________________________________________________________________________