Home

Vara Prasad - Lead Qliksense &Tableau Developer

[email protected]

Location: Columbus, Ohio, USA

Relocation:

Visa: H1B

Vara Prasad G +1 732-769-8916 [email protected] Summary: 11 years of experience in Business Intelligence tools (Tableau, Qliksense, TABCMD, TSM, Qlikview, Nprinintg, Oracle SQL, Power BI, MicroStrategy etc..), having knowledge of Data Science (Python, R, Machine Learning, Statistics, Deep Learning and Neural Network) Professional in designing, development, reporting and understanding the customer's business requirements. Worked as a Technical Architect, Project Lead and Business Analyst for different projects in BI tools such as Tableau, Qliksense Develop and maintain Qliksense and Tableau dashboards, reports, and data visualizations based on business requirements by loading different types of data sources. Having knowledge into Cloud Computing tools such as AWS S3, EC2, Redshift & EMR Having experience into migration project from Qliksense to Tableau and involved into other migration projects like changing the connections string from Hive Data base to Redshift SQL Combined all the files together into one Input step in Tableau Prep Strong experience of financial data analytics and reporting Assist in functional, performance, ADA testing, governance, data quality, training, and documentation efforts Having experience in Migrating from Tableau on Premise Server to Tableau Cloud platform Analyzed existing requirements with end user and documented them for Qliksense and Tableau. Strong proficiency in Qliksense, Tableau Desktop, Tableau Server, and Tableau Online, TABCMD and TSM, Qlikview and NPrinting suite of products (QlikView Server, Publisher and QlikView Enterprise). Strong experience in Qlikview/Qliksense qualifiers like Joins, Keeps, Concatenation, Interval Match, Interval Match Extended Keys, Mapping, Map Using Statement, ApplyMap function, Generic, Cross Table, Info & Bundle Info Worked on LOD functions (Fixed, Include, Exclude), Aggregate functions (Sum,Min,Max,Avg), Hide/Show filter conditions by using Parameters, Inner/Outer Padding, Horizontal/Vertical Containers and etc. in Tableau Desktop. Involved in tuning the performance issues in Qlikview, Qliksense and Tableau applications at Data Model level, Application level and Server Level. Experience in creating testing document and involved in System Integration Test (SIT), User Acceptance Test (UAT) Unit Test which includes field level, record level functional level tests. Created different Action filters, Parameters, and calculated fields to create complicated tableau dashboards. Worked with Tableau administrator in managing Production, Test and Development environments. Extensive experience in developing, maintaining and managing Tableau driven dashboards & analytics and working experience of Tableau administration/architecture As per client requirement, loading data from multiple data sources like Hive Database, Redshift SQL Workbench, Sales force, Oracle SQL, QVD files, Text files, Excel by making connection through ODBC, OLEDB. Performed different types of loads such as incremental load, binary load, resident load and partial reload. Implemented alternative states and What-if analysis to provide custom functionality in Tableau, QlikView Applications and hands-on experience on Set Analysis and Link Table. Strong experience in Data Warehousing concepts - Star Schema, Snowflake Schema and Data Modeling (Normalization/De Normalization) Dimension tables and Fact tables. Created many charts and analyzed that include Bar Chart, Line Chart, Pie Chart, Donut Chart, Combo Chart, Scatter Chart, KPI Boxes, Straight Tables and Pivot Tables in Qliksense and Tableau Applications Created many boxes that include List Box, Statistics Box, Multi box, Input Box, Current Selection Box during dashboard creation and familiar with box properties in Qlikview/Qliskense Created Master Calendar in data modeling involves dealing with dates and times. Having experience to provide security permissions by using Section Access in row/column level & sheet level. Working on NPrinting where creating applications, connections, reports, tasks, and triggers. Reloading the meta data in NPritning by giving Proxy address, Identity and Qlik app ID in respective columns. Creating Pixel perfect report, excel reports in NPrinting etc. Making different types of tables and objects according to our requirement in NPrinting designer. Skill Set: Business Intelligence Tools : Tableau, Qliksense, TABCMD, TSM, QlikView, N Printing Data Science Skills : Statistics, R, Python, Machine Learning, Deep Learning, Neural Networks Databases : Snowflake, Sales force, AWS Redshift SQL Workbench, Oracle 11g, Hive Database, Matillion Cloud Computing Tools : AWS S3, EC2, Redshift & EMR Operating System : Microsoft; Windows 95, 98, XP, 7 Desktop Applications : Microsoft Office 2007 & 2010; Excel Domains : Life Science, Pharmaceutical, Airline Solutions, Manufacturing, Philips Lighting, Retail Education: B. Tech from Kamala Institute of Technology & Science (S), Karimnagar, India JNTUH, 2009, India. Training: Project Management Professional (PMP) Education for 35 PDU contact hours of formal education from Moulik IT Services LLP, Hyderabad, Project Management Institute in Jul 2016. Got Completion course badge and certified on Tableau from Skillsoft with 100 % marks. Professional Experience: JP Morgan Chase & Co, USA Aug 2023- Present Mphasis Responsibilities: Working on Qlik sense Management Console (QMC) with Working on Qlik Sense installations (Feb 2023) & configuration by updating power shell scripts Updated Qlik Sense configuration with central node, work environment, host name, NAS locations, Service account details (Safe Value, object value, EPV vault), license serial number & LEF details, creating symbolic links, updated pgbase back up script for DR failover Working on migration of all Qlik Sense applications from one server (Dev, UAT, Prod & DR) to New Server ((Dev, UAT, Prod & DR)) Stopping & Starting all Qlik Sense Services from service manager Taking back up of existing Qlik Sense server Restoring PostgreSQL from existing Qlik server to newly installed Qlik Sense server Creating service account role to PostgreSQL and providing privileges in PG Admin Updating service account with GMSA account in all Qlik Sense Services Updating Qlik Sense cluster services from Qlik Util in the server Configured and deployed the application on Qliksense server and Imported data by using Microsoft SQL Server Management Studio with OLEDB provider. Creating connection string with Group Managed Service (GMSA) account with GSS data by using windows integrated security Uploaded Vizlib Extensions (Jul 23) and custom Qlik objects Worked on certificate generation by creating CSR file (from mmc.) in the server, get the certificate (Private Key, Root Key, Intermediate Key) details from internal request portal and imported certificate details to get thumbprint key and updated in security, Proxy section in QMC for secure the connection Creating new User Directory Connectors (UDC) from Gaia SQL Server (GSS) through ODBC drivers Worked on creating new apps, adding of users with respective roles, crating new tasks, updating data connections, UDC connections, Proxy settings, updating server & DNS details in virtual proxy, Updating cluster service details as per Network Attached Storage (NAS) shared folder structure, publishing apps into Prod, UAT, Dev Created Testing document with required screenshots of applications for user sign off Analyzed requirements and gathered data for designing Qliksense applications. Configured and deployed the application on Qliksense server and Imported data by using Microsoft SQL Server Management Studio with OLEDB provider. Working on migration from one environment to another environment Prepare data model and dashboards as per business logics and business requirements. Worked with different chart objects like bar, line, combo, straight table Having experience in Qliksense Management Console (QMC), adding users, creating, scheduling & reloading tasks, publishing into prod and etc.. Technical Skills: Qliksense, Qlik Management Console (QMC), SQL Server Management Studio, SSIS, Tableau Axtria India Pvt Ltd Mar-2020 to Jul-2023 Client : CSL Behring Biotherapies for Life Mar 2022 to Jul-2023 Project: Insights 360 Analytical Dashboards (Market Access, Finance, Medical, Sales, Marketing) Technical Architect, Lead Tableau & Qliksense Developer Responsibilities: Worked cross-functional with leadership, program managers, and other stakeholders to understand and achieve business priorities Developed Migration project from Qliksense to Tableau Develop, maintain, and manage advanced reporting, analytics, dashboards, and other BI solutions Creating users, groups, projects, sites, publishing projects, providing user permissions, deleting user access in tableau server as well as by using TABCMD commands from Tableau Command Line Utility Managing installation and configuration of Tableau Server by using TSM Having knowledge in Tableau prep builder Implemented a reporting and analytic solution for a financial DataMart solution Translate abstract data into easily digestible and highly visual Tableau dashboard applications and executive-level report deliverables. Assist in functional, performance, ADA testing, governance, data quality, training, and documentation efforts Gathering of reporting requirements for a Financial Data Warehouse using Tableau software tools Developing new versions of reports in Qliksense & Tableau by loading different types of data sources. Strong experience with Tableau metadata model, dashboards, and reports Involved in data warehousing, DataMart s, and dimensional models Analyzed existing requirements with end user and documented them for Qliksense & Tableau. Involved into Migration plan activities, Create and Configure a Tableau Cloud Site. Migrated data sources and workbooks to tableau cloud and recreate refresh schedules for tableau cloud. Configured permission and content access for migrated users and added remaining users to tableau cloud. End-user migration checklist is prepared and submitted testing document accordingly to respective client Created different Action filters, Parameters, and calculated fields to create the most complicated dashboards. Created Hide/Show condition sheets based on business requirements. Working on new requirements, new enhancement in developed Qliksense & Tableau applications and doing monthly and quarterly maintenance of existing tableau dashboard Worked with Tableau administrator in managing Production, Test and Development environments. Creating user groups, adding users into them, and providing permissions /access to respective groups to specified tableau applications at screen level. Involving daily manual refreshing all tableau dashboards once backend final Reporting table is got refreshed. Automated most of the dashboards as part of daily refresh. Involved in Row Level Security (RLS) and Column Level Security (CLS) tasks in Qliksense & tableau applications. Worked End to End project (Developing, SIT, UAT, Testing, Production, Admin Related tasks, creating user groups, providing permissions to users for specified screen level) Involving Qliksense & Tableau Production Deployment. Providing Tier 1 support for Tableau issues reported by departmental or group personnel. Highly skilled Tableau Administrator with extensive experience in developing and implementing data visualization solutions that drive business growth Proven track record in optimizing Tableau Server performance, reducing server downtime, and improving data accuracy and availability Experience in creating testing document and involved in System Integration Test (SIT), User Acceptance Test (UAT) unit test which includes field level, record level functional level tests. Develop and maintain Qliksense & Tableau data extracts, workbooks, data visualizations, data models, calculations, data blending, security roles and permissions. Technical Skills: Tableau, TABCMD, TSM, Tableau Cloud, Qliksense, Snowflake, Matillion. Client : Johnson and Johnson Pharmaceutical Company Jun 2021 to Mar 2022 Project: Analytics Dashboards, MDP Consumption Layer Project, CDP DQ Dashboards Lead Qliksense &Tableau Developer, Project Management Responsibilities: Worked in respective areas to develop and modify reports and dashboards. Provided connections to new and existing data sources, prepared data for use in Tableau, developed extracts, published data sources and workbooks, develop custom scripts, coordinate releases of data and workbooks, as well as perform complex technical tasks. Worked on Migration project by replacing with Hive data base connection string around for 35 tableau workbooks. Developing new versions of reports in Tableau and Qlik by loading different types of data sources. Analyzed existing requirements with end user and documented them for Qliksense & Tableau. Created different Action filters, Parameters, and calculated fields to create the most complicated dashboards. Worked with Tableau administrator in managing Production, Test and Development environments. Involving Qliksense & Tableau Production Deployment. Providing Tier 1 support for Qliksense & Tableau issues reported by departmental or group personnel. Technical Skills: Tableau, Qliksense,Oracle SQL Developer, Hive Database, Redshift SQL Workbench, EMR, Putty. Client : Sunovion Pharmaceutical Company Sep 2020 to May 2021 Project: Analytics Sunovion 360 Dashboards Lead Qliksense &Tableau Developer Responsibilities: Created visualizations for the data extracted with the help of Qliksense and Tableau. Designing dashboards in Qliksense & Tableau Desktop Twisting SQL queries for improving performances Created Stored Procedures by using SQL queries and created final reporting table. Developing reference documents or reports for the finalized project. Preparing data for use by Qliksense & Tabeau and Establishing connections to Data Sources. Performing Data Modeling in Qliksense & Tableau Desktop. Developing Workbooks and Hyper Extracts on Tableau Desktop. Publishing Workbooks and Data Sources to Tableau Development and QA sites. Refreshing Extracts, Monitoring the status of extract schedules and Performing Unit Testing on Development and QA / Production sites. Implemented set analysis, security rules (RLS,CLS and etc ) in Qliksense Resolving any data or performance issues related to workbooks and data sources. Cataloging measures and dimensions in Collibra and Requesting access for Interactors and Viewers. Involving Qliksense & Tableau Production Deployment. Providing Tier 1 support for Tableau issues reported by departmental or group personnel. Monitoring Usage Report of their Workbooks and Data Sources. Technical Skills: Tableau, Qliksense,Oracle SQL Developer. Client : Novartis Pharmaceutical Company Mar 2020 to Aug 2020 Project : Novartis HQ ENTRESTO Qliksense & Tableau Lead Responsibilities: Performing Data Modeling in Qliksense & Tableau Desktop Have been part of the Qliksense & Tableau development team for exploiting the data available on various platforms. Implemented set analysis, security rules (RLS,CLS and etc ) in Qliksense Created Master Calendar in data modeling involves dealing with dates and times. Roles and Responsibilities Experience in Creating Aggregates, Hierarchies, Charts, Filters, Quick Filters, Table Calculations and Trend Lines Calculated Measures Data Representation using Visualization Techniques in Tableau using Alteryx (Graphs, Charts etc) Experience with PowerBI Implemented parameters and input controls. Developed & Implemented Reports using Qliksense & Tableau Server Creating of Users, Groups and Projects on Qliksense & Tableau Server Created Customized and interactive dashboards (pulling data from multiple data sources) Design, Development, and implementation of BI Reports. Technical Skills: Tableau, Qliksense, Oracle SQL Developer. Sabre Travel Technologies Pvt Ltd Jul-2018 to Jan-2020 Project : Airline Solution Business Operations Sr. Business Analyst in BI Tools (Qliksense, Qlikview, Nprinting,Tableau), Salesforce Responsibilities: Have been part of the Tableau development team for exploiting the data available on various platforms. Created Hide/Show condition sheets based on business requirements. Created different Action filters, Parameters, and calculated fields to create most complicated dashboards. Created qvd files, Transformation, different types of charts for Tableau and QlikSense Dashboard Analysis Implemented set analysis, security rules (RLS,CLS and etc ) in Qlikview/Qliksense Created Master Calendar in data modeling involves dealing with dates and times Extracting, transforming, and loading data from multiple sources into Tableau and QlikSense applications Technical Skills: Tableau, Qliksense, NPrinting , QlikView12, Salesforce Logus Tech Solutions May-2018 to Jul-2018 Client : Imerys Sr. Qliksense Consultant Responsibilities: Hands on experience in Qlik Sense development, dashboarding and data modeling and reporting (ad hoc report generation) techniques. Must be good at Data transformation, the creation of QVD files and set analysis. Experienced in application designing, architecting, development and deployment using Qlik Sense. Must be efficient in front-end development and know visualization best practices. Strong database design and SQL skills. Experienced in RDMS such as MS SQL Server, Oracle etc. Leadership qualities and thoughtful implementation of Qlik Sense best practices to deliver effective Qlik Sense solutions to the users. Created Master Calendar in data modeling involves dealing with dates and times. Experienced in data integration through extracting, transforming, and loading (ETL) data from various sources. Technical Skills: Qliksense, QlikView12, Oracle SQL Developer Wipro Technologies Sep-2017 to Mar-2018 Client : Philips Jan 2018 to Mar 2018 Project: Xcellent Care and Home Monitoring QlikView Consultant Responsibilities: Analyzed requirements and gathered data for designing QlikView applications. Configured and deployed the application on QlikView server and Imported data by using Salesforce connectors, QVDs files using OLEDB/ODBC. Knowledge of installing/configuring QlikView and Knowledge on migration from Qlikview to Qliksense Involved in gathering data from sources like QVD files, Excel, binary QVW, Inline & txt files in developing the QlikView Data Models. Proposed and created new business analysis for data, which has no prior reports. Technical Skills: QlikView12, Qliksense, Salesforce Client : Becton Dickinson Sep 2017 to Dec-2017 Project: Work Environment Assessment (WEA) QlikView Consultant Responsibilities: Created QVDs by importing data from the database tables using Qlikview script. Study and analyse Business Requirement Document (BRD) and functional requirement document. Loaded respective files from Hive Data Base by connecting through ODBC connection. Prepare data model and dashboards as per business logics and business requirements. Worked with different chart objects like bar, line, combo, straight table, and funnel chart. Hands on experience in removing synthetic keys and circular loops. Developed Qlikview Dashboard using chart Box (Drill Down & Cyclic Group), List box, Input box, Table Box, and created filters and containers. Reports are created using Qlikview to the requirement of end user. Understanding and preparing technical documents based on the requirements gathered from business. Involved in Qlikview management console activities. Involved in data cleansing and prepared Unit Test cases for all the dashboards which are submitted to client. Technical Skills: QlikView 12, Hive Database Sonata Software Ltd Mar 2013 to Aug-2017 M&T Bank Corporation Apr 2016 to Aug 2017 QlikView Developer Responsibilities: Gathering requirements and analyzed data for developing and designing QlikView applications. Configured and deployed the application on QlikView server and Imported data from different sources like Oracle, SQL Server, QVDs and flat files using OLEDB/ODBC. Working knowledge on Installing, configuring QlikView server Involved in gathering data from sources like QVD files, Excel, Oracle, binary QVW, Inline & txt files in developing the QlikView Data Models. Experience in creation of QVD's for the QlikView applications following three-tier architecture. Monitoring of the QVS, QVW's and user accounts for the usage of the applications. Created KPI's and set analysis applications, according to user needs. Designed and developed different types of charts such as Bar charts, Straight Tables and Pie charts etc. Used different functions such as counter, date and time, conditional, aggregation functions etc., for data transformation. Designed an application to support the lending process and dashboard style of layouts using different components of QlikView Enterprise like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc. Performance tuning by analyzing the data model and design. Technical Skills: QlikView 11.2, SQL Database Modi Builders Jul 2014 to Mar 2016 QlikView Developer Responsibilities: Created QVDs by importing data from the database tables using QlikView script. Worked with different chart objects like bars, line, pie chart, scatter chart, grid chart etc. Hands on experience in removing synthetic keys and circular loops. Developed QlikView Dashboard using Chart Box (Drill Down & Cyclic Groups), List box, Input Field, Table Box and Calendar and Drill Information by creating Groups/Cycles in QlikView. Worked on Incremental Loading to reduce the reload time of different applications. Reports are created using QlikView to the requirement of end user. Involved in QlikView management console activities. Environment: QlikView 12, SQL Database Project: Transactions & Relations Management System Mar 2013 to Jun 2014 QlikView Developer Responsibilities: Created user interactive sheets & reports as business needs on dynamic. Understanding the functional requirements and understanding the customer requirement. Writing SQL scripts to load the relevant data in QlikView Application. Extracted information from disparate data sources like Excel, QVD, flat, XML files etc by using different ETL script statements like Resident, Concatenate, Join, Keep, Mapping Load, Interval Match, Info Load, input field etc. Created Dashboard using different components of QlikView like List boxes, Multi boxes, slider, and buttons, charts (Bar, Line, Combo, Gauge, Scatter, and Straight/Pivot table) etc. Created QVD's and updated them on timely basis as database updates. Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users and Drill Information by creating Groups/Cycles in QlikView. Entitlement and data level security for Dashboard using Section Access. Environment: QlikView 11.2, Redshift SQL Database Keywords: quality analyst business intelligence sthree active directory rlang information technology microsoft Colorado Delaware Idaho