Resume

Manager Data

Location:

Texas City, TX

Posted:

November 15, 2017

Contact this candidate

Resume:

Dharma

QlikSense/ Qlikview Developer /Admin

{Kavitha Priya/ ac3b1l@r.postjobfree.com/ PH no: 469-***-*****112}

Professional Summary

Over 10+ years of IT experience in Requirement Analysis, Designing, Development, Administrator and Testing

Extensive experience in Business Intelligence Solution with packages including Cognos BI, 5+ Years of experience in Qlikview and 2+ years in QlikSense

Good experience in Insurance, Finance, Health Care and Networking Services domains

Expertise across all stages of the Qlikview lifecycle (sourcing data, QVD generation, and dashboard design) and implementation of complex Qlikview functions set analysis advanced scripting, etc.

Expertise with section access and implementing data level security

Experience in migration, deployment and Job scheduling of Qlikview applications through QMC (Qlikview Management Console) and Qlikview application refresh through trigger based schedule

Implemented secure environment using Qlikview Section Access

Worked on Qlikview server and publisher to automate the Qlikview jobs and define the user security and data reduction

Deployed QVW's on the production server, Created Reload and Distribution tasks on Qlikview Server/publisher

Troubleshooting the issues and reviewed the log files to resolve the issues

Extensive experience in Prototyping QlikSense dashboards using Story Telling, Beta maps integrations, Pivot Table, KPI Object etc. for evaluation to Business

Implemented the Various scenarios of section access and security levels

Creating dashboards by extracting data from database and externalize the load scripts, store the data as QVD files and designing the UI based on business/user requirements

Use of Set analysis and aggregation functions for sheet objects

Installing, configuring and maintaining the Qlikview infrastructure

Used Set Analysis and various Qlikview and QlikSense functions in writing expressions for sheet objects

Solid hands on experience designing mobile friendly dashboards using QlikSense

Actively participation in migrating applications from Qlikview to QlikSense and took part in resolving critical compatibility issues during migration

Gained experience in configuring QlikSense clustered environment and involved in trouble shooting issues like Sync issues, App Duplication issue, SSL certificates, SAML issues etc.

Solid Hands on Experience in handling QlikSense Eco System (Hub, Sense QMC, Engine, Proxy, Scheduler etc.)

Worked with Qlikview/QlikSense administrator to optimize Qlikview / QlikSense performance

Adapt in reviewing and analyzing Data, Business Processes, and Business Requirements

Good hands on Experience in managing and distributing User Access Pass (1:1 w.r.t Tokens) and Login Access Pass (1:10 w.r.t Tokens) on Sense Server

Implemented Qlikview 11 advanced features like Auto Refresh, Direct Discovery, Document Chaining, Grid Container, Dimension Limits, Write back functionality using Macros, On Demand extensions for NPrinting reports etc.

Created and Scheduled Weekly Qlikview reports to distribute on email using NPrinting and publisher

Involved in managing the Qlikview Licenses to the users (Named CAL, Session CAL, Document CAL)

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

Eliminated Synthetic keys, ambiguous relationships and closed loops. Designed proficient dashboards according to the requirements

Enhanced existing dashboards with new functionalities and established a secure environment using Qlikview Section Access

Implemented drill down and cyclic dimensions

Worked with bulk volumes of data and extracted them from various sources like excel, Oracle, SQL Server through ODBC and OLEDB connections

Manages user's access to the Qlikview Server and Qlikview Access Point.

Environment like QlikView11.0 (SR2), Qlikview Server and Publisher (QMC)

Familiar with Data warehousing concepts along with implementation of Business Intelligent systems, Operational Databases, Data Marts, understanding of Star and Snow Flake schemas.

Working experience in developing Relational and Dimensional models using Framework Manager and Transformer by connecting to multiple data sources

Experience in Cognos BI Server Installation and Configuration, configuring database server and web server connectivity for use with Cognos

Experience in setting up Security prototype for Cognos business intelligence environment incorporating data level, object level, and package level and report level security

Desire to learn new skills, technologies, and adapt to new information demands

Excellent oral and written communication skills and inter-personal skills

Have the strength to handle the project independently as well as handling/managing the team.

Strong in design, development and implementation of applications on Microsoft technologies using different versions of MS Operating Systems

Self-starter and Team player, capable of working independently and motivating a team of professionals

Corporate Trainings & Certifications:

IBM Cognos BI Administrator training

Qlikview Server publisher Training

Education:

Master of Computer Applications from Osmania University, Hyderabad

TECHNICAL SKILLS:

BI Tools

Qlikview :

Qlikview 11,12, Qlikview Developer, Qlikview Server Admin / Publisher, QlikSense(Nprinting ), Qlikview Management console, QlikSense:2.1.1/2.2.4/3.1,

COGNOS 10 BI Suite

(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Administration, Metric Studio, COGNOS Connection), COGNOS Content store, LDAP Server, Deployment Tool)

Data Base Applications

Oracle 11g/10g/9i/8i/7.x, SQL Server 2000/2005, Teradata, DB2, Sybase, MS Access.

Programming Languages

SQL, PL/SQL C

Web Technologies

HTML, XML, JavaScript

Other Tools

MS Project, TOAD, WINSQL, IBM Data Studio

Operating Systems

Windows 2000/NT/98/95, UNIX / Linux /AIX.

Professional Experience

Oceans Health Care, TX Jul 2017 to Present QlikSense/ Qlikview Developer/Admin

Responsibilities:

Installing, configuring and maintaining the Qlikview/QlikSense infrastructure.

Worked on installation & configuration, environment, system analysis, design, deployment, testing of projects.

Experience in optimizing QlikSense applications to improve the performance.

Developed QlikSense objects like Multi Boxes, Straight tables, Pivot tables, Containers, Line charts, Bar charts, Combo charts, Scatter charts, Line objects, Pie charts, Buttons.

Proficient in troubleshooting and fixing the QlikSense dashboard issues. Worked on building QV objects for different requirement such as straight table, pivot table, different charts (Bar Chart, Line Chart, and Scatter Chart, KPI).

Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.

Extracted information from different data sources like Oracle, Teradata and flat fileWorked on Qlikview server and publisher for Qlikview jobs and define the user security and data reduction.

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

Eliminated Synthetic keys, ambiguous relationships and closed loops. Designed proficient dashboards according to the requirements.

Enhanced existing dashboards with new functionalities and established a secure environment using QlikSense Section Access

Implemented drill down and cyclic dimensions.

Worked with bulk volumes of data and extracted them from various sources like excel, Oracle, SQL Server through ODBC and OLEDB connections.

Deployed QVW's on the production server, Created Reload and Distribution tasks on Qliksense Server/publisher.

Involved in Onsite-Offsite coordination in delivering Business Intelligence Solutions.

Understanding of data modeling, dimensional & relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables; experience in Extract, Transform and Loading process of data.

Troubleshooting the issues and reviewed the log files to resolve the issues.

Involved in managing the QlikSense Licenses to the users (session access, login user access )

Manages user's access to the QlikSense Server and QlikSense Management Console.

Creating dashboards by extracting data from database and externalize the load scripts, store the data as QVD files and designing the UI based on business/user requirements.

QlikSense App development, templates, themes, master library items and story generation

Extensively worked on data modelling & performance optimization QlikSense

Configured different QlikSense roles and attribute based access control

Implemented the Various scenarios of section access and security levels. Use of Set analysis and aggregation functions for sheet objects.

Handled Production Support issues.

Worked with Business users to analyze the business process and user requirements.

Managed the on-site and offshore team and developed client relationship through all phase of the implementation cycle.

Expertise in defect solving for the Dashboard during the QA testing.

Working closely with the Business users to get the requirements for managing Qlikview Server and publisher.

Extensively used different Qlikview features and scripting statements (Different Load Techniques, Keep, Join, Concatenate, Apply Map, Set Analysis, Drill Down Groups, Cyclic Groups and Actions)

Implemented data level security using Section access that hides selected areas of the dashboard & filters data dynamically depending upon user privileges.

Developed Unified Qlikview Dashboard's and worked with various sheet objects like list boxes, bar charts, combo charts, radar charts, pie charts, straight table, pivot table, container, current selection box, Search and so on

Environment: QlikSense: 3.1 June 2017/2.2.4/2.1.1,Qlikview 11.2 SR 8, Qlikview Management Console, SAP Business Objects, Crystal reports, Informatica, IBM DB2, SQL/PLSQL, SQL Server, Oracle 10g/11i and Windows server and UNIX

Qualcomm San Diego, CA Aug 2013 to Jun 2017

Sr. Qlikview/QlikSense Developer/Admin

Responsibilities:

Worked on building QV objects for different requirement such as straight table, pivot table, different charts (Bar Chart, Line Chart, and Scatter Chart).

Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.

Extracted information from different data sources like Oracle, Teradata and flat fileWorked on Qlikview server and publisher for Qlikview jobs and define the user security and data reduction.

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

Eliminated Synthetic keys, ambiguous relationships and closed loops. Designed proficient dashboards according to the requirements.

Enhanced existing dashboards with new functionalities and established a secure environment using Qlikview Section Access

Implemented drill down and cyclic dimensions.

Worked with bulk volumes of data and extracted them from various sources like excel, Oracle, SQL Server through ODBC and OLEDB connections.

Deployed QVW's on the production server, Created Reload and Distribution tasks on Qlikview Server/publisher.

Troubleshooting the issues and reviewed the log files to resolve the issues.

Involved in managing the Qlikview Licenses to the users (Named CAL, Session CAL, Document CAL)

Manages user's access to the Qlikview Server and Qlikview Access Point.

Creating dashboards by extracting data from database and externalize the load scripts, store the data as QVD files and designing the UI based on business/user requirements.

QlikSense App development, templates, themes, master library items and story generation

Extensively worked on data modeling & performance optimization QlikSense

Configured different QlikSense roles and attribute based access control

QlikSense and Qlikview Server Sizing.

Implemented the Various scenarios of section access and security levels. Use of Set analysis and aggregation functions for sheet objects.

Installing, configuring and maintaining the Qlikview/QlikSense infrastructure.

Handled Production Support issues.

Worked with Business users to analyze the business process and user requirements.

Managed the on-site and offshore team and developed client relationship through all phase of the implementation cycle.

Expertise in defect solving for the Dashboard during the QA testing.

Working closely with the Business users to get the requirements for managing Qlikview Server and publisher.

Extensively used different Qlikview features and scripting statements (Different Load Techniques, Keep, Join, Concatenate, Apply Map, Set Analysis, Drill Down Groups, Cyclic Groups and Actions)

Implemented data level security using Section access that hides selected areas of the dashboard & filters data dynamically depending upon user privileges.

Extensive use of advanced Qlikview features like Alternative State, Incremental Load, Interval Match, Link Table, Document chaining and so on.

Always worked in close association with customers and a single point of contact for many major implementation projects

Expertise in managing Qlikview Server, Qlikview Publisher, Qlikview Enterprise Version, Qliksense.

Implemented session access to enterprise level document

Environment: Qlikview 11.2 SR 8, Qlikview Management Console, QlikSense:2.1.1/2.2.4/3.1, SAP Business Objects, Crystal reports, Informatica, IBM DB2, SQL/PLSQL, SQL Server, Oracle 10g/11i and Windows server and Unix

JPMC, Lewisville, TX Jun 2012 to Jul 2013

Sr. Qlikview Developer/Admin and Cognos Consultant

Responsibilities:

Worked on Qlikview server and publisher to automate the Qlikview jobs and define the user security and data reduction.

Deployed QVW's on the production server, Created Reload and Distribution tasks on Qlikview Server/publisher.

Troubleshooting the issues and reviewed the log files to resolve the issues.

Involved in managing the Qlikview Licenses to the users (Named CAL, Session CAL, Document CAL)

Manages user's access to the Qlikview Server and Qlikview Access Point Environment

Understanding the customer’s requirement, analyzing whether the requirements are feasible and checking if they are clear and deployable

Worked with Business users to analyze the business process and user requirements to cater their needs for reports and multidimensional cubes.

Extensively used different Qlikview features and scripting statements (Different Load Techniques, Keep, Join, Concatenate, Apply Map, Set Analysis, Drill Down Groups, Cyclic Groups and Actions)

Implemented data level security using Section access that hides selected areas of the dashboard & filters data dynamically depending upon user privileges.

Extensive use of advanced Qlikview features like Alternative State, Incremental Load, Interval Match, Link Table, Document chaining and so on.

Experience in Cognos BI Server Installation and Configuration, configuring database server and web server connectivity for use with Cognos.

Experience in setting up Security prototype for Cognos business intelligence environment incorporating data level, object level, and package level and report level security.

Experience in creating ODBC

Develops and maintains Framework Manager Models and apply proper securities and publishing packages.

Building data source query subjects and using stored procedures to create query subjects that are used to build reports for specific users.

Interacted with business and technical users to gather requirements and created design document

Responsible for creation of metadata models in Framework Manager and cubes in Transformer.

Created database, business and Presentation Layers and defined appropriate relationship between query subjects based on the user requirements.

Upgraded Models and Reports from Cognos 8.4 to Cognos 10.1.1and Cognos 10.2

Developed various dimensional and relational reports by deploying lists, crosstabs, charts, union, joins, burst, master-detail, drill through and drill down, reporting techniques.

Creation of analytical reports, modifications to existing reports in Base Product.

Developed complex prompt report and dimensional reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks.

Created different Dashboards in report studio using combination of List, Crosstab, and Chat and Map reports.

Develop dimensions, measures and calculation using Transformer for OLAP Analysis of data.

Developed dashboards reports using Business Insight, Business Insight Advanced and Cognos Workspace.

Developed UTC (unit test cases) and helped Business Partners in UAT (user acceptance test cases) documentation as part of testing.

Created an implementation plan and component documents for Change Management Approvals.

Handled Production Support issues

Environment: Qlikview 11.2 SR 8, Qlikview Management Console,Cognos BI 10.2/10.1/8.4 (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Business Insight, Business Insight Advance and Event Studio), SAP Business Objects, Crystal reports, Informatica, IBM DB2, SQL/PLSQL and Windows server and Unix

Cisco, San Jose, CA Apr 2011 to May 2012

Sr. Cognos Developer/Admin

Responsibilities

Worked with Business users to analyze the business process and user requirements

Managed the on-site and offshore team and developed client relationship through all phase of the implementation cycle

Planned, and successfully implemented the cross functional projects within defined budgets and timelines

Created the changes and tasks for implementation process

Experience in Cognos BI Server Installation and Configuration, configuring database server and web server connectivity for use with Cognos

Experience in setting up Security prototype for Cognos business intelligence environment incorporating data level, object level, and package level and report level security

Experience in creating ODBC

Designing Relational and DMR models using Framework Manager and deployed packages to the Cognos Connection

Created database layer and business layer, defining start schema by creating appropriate relationship between query subjects in Framework Manager

Applied Security at the package level, query subject level and the query item level

Used Governing techniques for improving performance of the Model and Reports

Designed and implemented the migration and upgrading planning as part of migration from 8.4 and 10

Created various complexes List Reports, Cross tab Reports, Chart Reports and Drill-Through Reports

Customized data by adding prompts, Filters, Calculations, Summaries and Functions

Delivered Advanced Multidimensional reporting solutions using Report Studio

Handled Production Support issues.

Environment: Cognos BI 10.1/8.4 (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, and Event Studio), SAP Business Objects, Crystal reports, Informatica, IBM DB2, SQL/PLSQL and Windows server and Unix.

Dow Jones, South Brunswick, New Jersey Jan 2010 to Mar 2011

Cognos Developer