Home

Bhavana - QlikSense / Qlikview and Tableau Admin

[email protected]

Location: Petersburg, Pennsylvania, USA

Relocation: Pennsylvania

Visa: L2S

Name: Bhavana R Experience Summary Over 9+ years of experience in Analysis, Design, Development, Testing, and implementation of Business Intelligence applications using QlikView, QlikSense & Tableau visualization tools. Experience in various industries like Finance, Pharmaceutical, Manufacturing & Banking. Managed Onsite/Off-shore teams, delivered all projects and assignments within specified timelines and accuracy. Worked in Agile methodology environments and involved in Scrum meetings. Created detailed design, development, testing & migration documents and performed POC. Worked in Development, Application Support and Administration projects for Tableau and QlikSense applications. Extensive exposure to different phases of SDLC process starting from analysis through evolution in various domains. Expertise in designing efficient Data-Models by extracting data from different sources like flat files, Google sheets, SQL Server, Oracle database, Teradata Database, Snappy Database. Worked with Google drive connector in Qlik sense to load the data from Google sheets, updating the data in google sheets and saving QVDs to google drive Experience in Optimizing QlikView and QlikSense applications to improve performance. Developed QlikSense dashboard using objects like Combo charts, bar charts, Pivot tables, straight tables, containers, scatter charts. Worked on Writeback functionality, Ad-hoc reporting, Conditional show/Hide of columns in Pivot and Straight tables, Mashups and Extensions. Well versed with QlikSense Schemas like Star and Snowflake Schemas and loading techniques like Incremental, Buffer, Preceding, and Binary loads. Proficient in troubleshooting and fixing QlikSense application issues. Experience in QlikSense scripting, Set analysis and Section Access Implemented 3-tier architecture with Data-Extraction, Data-Modeling and Application Development to modularize the development and improve reusability of the data model across application. Extensive experience in creating Pixel Perfect reports, Excel reports, Word reports, PowerPoint reports using NPrinting designer and automating the jobs in NPrinting Server. Worked on administration activities like upgrading QlikSense enterprise, QlikSense Repository Database upgrade, Task management, License management, creating new streams, Custom properties, Security rules, administrating and maintaining various environments like Dev, Stage, Prod and NPrinting Prod servers. Raised support cases with Qlik.com and worked with them in resolving various issues related to performance, configurations, Qlik functionalities. Worked with various teams like Windows team, AD group team, Database teams to resolve Qlik application and administration issues. Involved in creating Dashboards, reports as needed using Tableau Desktop and Tableau Server. Administered user, user groups, and scheduled instances for reports in Tableau. Preparing Dashboards using calculations, parameters in Tableau. Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau. Created incremental refreshes for data sources on Tableau server. Technical Skills BI Tools: QlikSense November 2022, QlikSense November 2021, QlikSense September 2020, QlikSense February 2019, QlikSense 3.1, QlikView 11, QlikView 11.2, Tableau 2019.3,2018, 10.0 Databases: SQL Server, Oracle Database, Teradata, Google sheets Education Completed Graduation (Bachelor of Technology) from JNT University, Hyderabad, India Work Experience Client SEI, Oaks PA Oct 2022 till date This project includes development, application support and administration of QlikSense applications for different business groups. Role: Project Lead - QlikSense Responsibilities: Worked as project lead for Involved in designing, developing, testing, publishing, maintaining, and supporting QlikSense applications. Responsible for gathering business requirements and technical specifications from the users. Managed Onsite/Off-shore teams, delivered all projects and assignments within specified timelines and accuracy. Worked in Agile methodology environments and involved in Scrum meetings. Created detailed design, development, testing & migration documents. Worked on new developments and enhancements for different business groups like PMO, PE, Operations, Corporate accounting teams. Worked with Google drive connector in Qlik sense to load the data from Google sheets, updating the data in google sheets and saving QVDs to google drive. Worked on Writeback functionality, Ad-hoc reporting, Conditional show/Hide of columns in Pivot and Straight tables, Mashups and Extensions Worked on upgrading QlikSense enterprise from Nov 2021 to Nov 2022 version. Worked on upgrading QlikSense repository database to PostgreSQL 12.5. Administered and managed 22 streams, 242 applications and 353 users. Worked on setup of new applications in production like creating new streams, updating security rules, creating data connections, publishing the applications to the stream, granting access to users, and scheduling the jobs. Worked on analyzing RCA for task failures and provided solutions for permanent fix on recurring issues. Worked on optimization of long running apps. Involved in user training sessions on the usage and analysis of the dashboard. Environment: QlikSense November 2021, QlikSense November 2022, Oracle 22.2, Rally, Confluence, Google Sheets Client Cisco, Atlanta GA Dec 2021 Sep 2022 This project is to analyze dataset of product-related information. The project s primary goal is to analyze the trends and showcase the availability of products in different departments. Role: Project Lead QlikSense Responsibilities: Involved in design, development & testing of QlikSense applications. Involved in the requirement analysis and identifying sources and targets. Created QlikSense dashboards using different objects like List Boxes, Multi Boxes, Pie charts, Line charts, Funnel charts, Scatter charts, Bar charts, Combo charts, Straight tables, Pivot tables, Buttons, Containers. Involved in performance tuning of applications for faster data reloads and efficient response times. Created tasks and set dependencies using QMC. Involved in optimizing the existing data models and load scripts to improve the performance. Simplifying complex expressions in the dashboards and improving the front end. Implemented section access to make the application available to the desired users. Responsible for validating the developed applications against the predefined design standards. Perform error handling process, debugging, and troubleshooting the applications. Sending the updated status report to the managers on a daily, weekly, and monthly basis. Environment: QlikSense September 2020, SQL server 2012 Client - Johnson & Johnson, India Jan 2020 Feb 2021 This project is to support all the Pharma applications which includes both Tableau & QlikSense applications in J&J Role: Lead QlikSense and Tableau Admin Responsibilities: Providing application support to all the QlikSense and Tableau applications for Advance planning POD. Worked on Job monitoring, handling data issues in Production for all the applications. Worked on Change requests for Tableau and QlikView applications. Taking over the new applications from Dev teams which involves KT, reverse KT, and documentations. Working on Operational requests like pre-upgrade and post- upgrade testing for the reporting tools in case of any upgradations/Patch-ups. Implementation of SLT in the applications for scheduling of the reports in Control-M Environment: Tableau 2018, Tableau 2019.3, QlikSense February 2019, Teradata 16.10, Oracle 18 Client - Johnson & Johnson, India Oct 2018 Dec 2019 EDG Reporting: This project is to build financial reports on the consolidated data from multiple SAP ERP Systems and validate the balances for all the accounts. Role: Tableau Developer Responsibilities: EDG reporting is a development project to build financial reports using Tableau. The main objective of this project is to build reports for Global service Financial (GSF) Analyst to view the data consolidated from different source systems and validate the balances on global and local accounts. Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed. Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently. Published Workbooks by creating user filters so that only appropriate teams can view it. Worked with various teams to build complex reports like Trial Balance Report and Monthly Net Trade Sales report. Created adhoc reports to users in Tableau by connecting various data sources. Generated context filters and used performance actions while handling huge volume of data. Introduced several Levels of Dashboard Drill Down. Performed unit testing and created test case documents for all the reports. Environment: Tableau 10.0, Snappy database Client Catalent, India Dec 2017 Sep 2018 Role: QlikView & BO Admin Responsibilities: Administrating and maintaining various environments like Dev, Stage, Prod and NPrinting Prod server for Qlik and BO Dev, Stage and Prod Servers. Involved in user management activities like providing the licenses, access to the requested applications and providing the Security. Worked for Change Requests and Enhancements in Qlik and BO. Monitoring Qlik and BO jobs refresh. Initial investigation of application error and End-to-end process of a service request. Worked on Admin tasks like Cleanup of all the deleted tasks in production, removing the Licenses for Inactive users, taking backup of the existing Qlik reports in Prod using TFS, added Security for 40 apps in Production, restarting of the Qlik and BO services when required. Worked on creating the new Qlik reports from the existing BO reports. Involved in Informatica job monitoring activities like on-demand run of the workflow, scheduling the workflows. Managing BO server using CMC, CCM and Import wizard. On Demand changes on existing BO Reports using Infoview. Created the NPrinting tasks for Qlik reports to distribute in excel format with business users. Environment: QlikView 11.20, SAP BO XI R2. Client SuperGros, India Sep 2016 Nov 2017 This project is to migrate Cognos reports to QlikSense. Role: QlikSense Developer Responsibilities: Extracted large volumes of data from the database and QVDs were generated for creation of datamodel. Used various techniques to optimize the datamodel and to reduce the volume of data load. Created datamodel for complex reports with static filters embedded. Have successfully migrated data model from Cognos to QlikSense. Created sheets with filter objects, Pivot tables, KPI objects, Table box, Text box, combo charts. Used various calculated expressions, grouping and sorting is done in the data model and report level. Worked on creation of crosstab, conditional formatting in Pivot tables. Linked objects for Images, titles, headers, and footers were created. Used various extensions in creating advanced/complex reports solutions and Involved in the deployment of the dashboards. Environment: QlikSense 3.1, Teradata Client - Colgate Palmolive, India Sep 2015 Aug 2016 This project is to create dashboards for displaying the data related to production & distribution of household, health care and personal products. Role: QlikView Developer Responsibilities: Created Dashboards with various chart types to display the Audit, Survey and Activities information. Created charts for various analysis with Cyclical and drilldown features. Audit dashboard is built to display KPIs like SKU count, OOS % and In distribution% of the products. Activities and Survey dashboards are built to provide the Visits information and Survey results. Involved in Data modeling for Dashboard design. Implemented Section Access and Document Chaining. Analysis of the specifications provided by the client and understanding the business. Delivered advanced/complex reporting solutions and Involved in the deployment of the dashboards. Environment: QlikView 11, SQL server 2008 Client - Deutsche Bank, India Jan 2015 Jul 2015 This project is to support all the QlikView applications for Deutsche bank financial reports. Role: QlikView Admin Team member Responsibilities: Worked on Symphony Ticketing Tool and Service Now tools for Service Requests and Incident Management Worked on administrating and maintaining various environments like Dev, Stage, Prod and NPrinting Prod server for QlikView Handling various applications reload process. Created QMC tasks to schedule QVW task for reload, publish and distribution. Involved in QlikView management console activities. Experience in handling Access point Issues, Production Issues, analysing document and server logs User Management in QMC including Onboarding users, off boarding users, provided Document CALS, Named CALS, Leasing Licenses. Initial investigation of application error and End-to-end process of a service request. Environment: QlikView 11 Keywords: business intelligence active directory rlang information technology Georgia Pennsylvania