Sandhya Giriraj

adbazn@r.postjobfree.com

321-***-****

Professional Summary:

Around 5+ years of experience as a Qlik Sense Developer Tableau Developer, Data Analyst and Business Analyst especially in Business Intelligence applications in steel and finance industries.

Highly proficient in Agile, Scrum and waterfall Software Development Life Cycle (SDLC).

Hands on experience in publishing of various kinds of interactive dashboards and workbooks from Tableau Desktop to Tableau Servers, also in Qlik Sense server and desktop.

Expertise in creating filters, quick filters, context filters and creating Dashboards for key performance Indicators.

Experience in creating Data Blending by merging data from different datasets. Created visualizations using scatter plots, Gantt charts, Bubbles, Bullets, and Heat maps.

Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.

Experience in creating Database Objects like tables, constraints (Primary Key, Foreign Key, Unique, default, Indexes).

Expertise in writing SQL Queries, complex joins for generating complex stored procedures, User-defined functions.

Experience in creating Sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters.

Data migration using Sqoop into the Hadoop platform.

Data manipulation using Hive scripts in the Hadoop platform for Tableau reports.

Experience in the design of Extraction. Transformation and Load (ETL) routines for migrating data.

Self-motivated high-energy person who enjoys challenging assignments and good at working on multiple engagements.

Technical Skills:

BI Tools

Qlik Sense Developer/Admin,Tableau (Desktop/ Server), SSRS, SSIS, SSAS

Databases

Oracle, MS SQL Server, MySQL

Applications

MS Office, MS Visio, Adobe Photoshop

Scripting Languages

C, HTML, SQL

Data Modeling Tools

MS Visio

Design/Version Control

SVN, UML

Operating Systems

Windows Server

Big Data

Hadoop, Hive

Professional Experience:

Markel Corporation, Glen Allen, Virginia Nov 2019 – Till date

Qliksense Developer/Consultant

Markel Corp needs to migrate the Cognos Reports to Qliksense content material answer in which that is capable of the use of by way of unique enterprise Users. This solution is able to turning into an important supply for Cognos Reports to Qliksense which in flip might be used by various different department of Users. One of the high goals of this solution is to take away the Performance issues and the expense to maintain various tools to represent the reports and construct a centralized tool to be able to leverage by using a majority of these reports.

Responsibilities:

Actively involved in requirement gathering sessions with business analysts, business stakeholders, Subject Matter Experts (SME), developers and sponsors.

Involved in assessment of reports that has to be migrated from Cognos to Qliksense and analyzed the number of reports on each packages and cubes in Cognos and the complexity of reports.

Compared Cognos and Qliksense and provided a Gap analysis document with the solution that can be achieved in Qliksense.

Converted the cubes and packages to QVDs in Qliksense

Designed the Snow/Star flake schema in Qliksense by assessing the Cubes and Packages using the framework manager in Cognos.

Designed effective KPI Dashboard (Gauges, Text Objects and Charts) that helps management to make faster and better decisions.

Experienced in SET Analysis to improve the calculation times on the UI.

Experienced with Qliksense sheet objects including multiple charts types, Trends, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI’s.

Used SQL Query’s extensively to retrieve the required data from SQL Server.

Implemented the Incremental Load and ODAG Solution to maintain the History Records in Qliksense.

Worked on showing the filters used by that Specific Business User on that Specific application.

Perform Qliksense administrative tasks such as scheduling automated data refreshes, optimizing data load editor scripts, extension management and troubleshooting, creating security rules, giving access to Users and publishing the apps to that Specific Stream.

Verizon Communications Inc., Irving, Texas July 2017- Nov 2019

Qliksense Developer/Tableau Developer

The venture was to actualize Business Intelligence Application to think about the organization's execution crosswise over different measurements by planning and making reports/dashboards on client, provider, deals, and operations information using Qlik Sense and Tableau.

Responsibilities:

Involved in looking into business prerequisites and breaking down information sources for outline, improvement, testing, and deliver report and investigate extends inside Qlik Sense.

Designed and developed Universes as per report requirements of Business analysis.

Designed and tested the reports against Oracle Database.

Developed reports for end users to analyze invoice data from HIVE tables with over 80 million rows and 120+ columns, while also empowering users with self-service capabilities for ad hoc analysis resulting in users spending 90% of their time analyzing data instead of doing manual data manipulation in Excel

Created drill through reports in dashboard.

Designed and created different systematic reports from numerous information sources by mixing information on individual worksheet in Qlik Sense server.

Develops visualization tools to manipulate complex data sets in a simple and intuitive format.

Debugging the reporting problems and issues.

Provides support to ensure the optimal performance of reports and dashboards.

Develops and implements visual data reports and creates personalized, interactive data visualizations, reports and dashboards from multiple data sources.

Publishes the apps developed and creates the security rules as per the User requirement.

Also will extensively work on Mash ups and extensions.

Understand, and implement business requirements, and convert them into dashboards.

Resolve and enhance upon Production and UAT Tickets raised by the Business users.

Present the Dashboard to Business users and executives, via multiple visualizations and defined KPIs

Develop new and edit, preinstalled Qliksense Visualization Extensions and Widgets in Javascript, jQuery and AJAX for efficient, easy use to manipulate complex data sets and present it on Dashboards for business and executives.

Create and Schedule Weekly Qlik Sense data refresh tasks from Data Lake to QVDs into Management Console.

Implement new and edited already written Security rules for various user roles in Qlik Sense Management Console.

Implement Incremental Load for triggering data load from hive Data Lake to Qliksense on a weekly basis.

Implement Section Access for Row and Column level security in Qliksense where users have exposure to specific data based on their job positions.

Develop Data load editor scripts with multiple data connections using table modeling, Calculations and Filtering data from multiple data source.

Implement Flat files and hierarchies using multiple data lake tables for dashboard building.

Work on AWS Servers for fresh Qliksense and PostgreSQL installations with multiple consumer nodes for load balancing between developers, users, and testers.

Work extensively in Tableau and Qliksense for the business requirements and dashboard development.

Work with Data Lake team to resolve Hadoop database issues and test the database on a weekly basis.

Work extensively on Scripting for Qliksense dashboards through set analysis.

Provide Training to the new business users and help them with their testing and dashboard development in UAT to be moved to Production once signed off.

Work on New features and implement them as proof of concepts in Qliksense and Tableau

Converting data from Hive database into Qliksense specific QVDs for faster analysis and data manipulation

Optimize Dashboards and its applications for better response time and performance

Work with data analytics team to enhance and maintain Qliksense infrastructure.

Also we send every week email through Qlik NPrinting connecting through Qlik Sense.

As a Tableau Developer I develop reports using SQL Server for the RPA team where the bots run every day on live.

Involved in reviewing business requirements and analyzing data sources from Excel SQL Server for design, development, testing, and produce report and analyze projects within Tableau Developer.

Involved in creating database objects like tables, views, procedures, triggers, functions using SQL to provide definition, structure and to maintain data efficiently.

Migrated the existing oracle scripts to hive scripts using HQL in the Hadoop platform for data usage.

Creating multiple workbooks and dashboards using calculated fields, Quick table calculations, Custom hierarchies, Sets & Parameters to meet the business needs.

Created Workbooks and dashboards for analyzing statistical billing data in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Used Query Analyzer to optimize SQL Queries.

Used Action filters, Parameters and LOD calculations, Quick Table calculations, Sets, etc. for preparing dashboards and worksheets in Tableau.

Created Groups and Custom Hierarchies to meet the Business requirement in Tableau.

Effectively used data blending feature in tableau and defined best practices for Tableau report development.

Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.

Environment: Qlik Sense Desktop/Server, Qlik NPrinting Tableau Desktop (10.4 & 10.5)/Server, Oracle, SQL, Windows, MS Excel, HIVE

IMSI India Pvt Ltd, Chennai, India May 2014- May 2015

Tableau Developer / Data Analyst

The project was to implement Business Intelligence Application to study the company's performance across various metrics by designing and creating reports / dashboards on customer, supplier, sales, and operations data using Tableau Reporting Services.

Responsibilities:

Worked with Business Users from different functional Units and understand business challenges in terms of providing reporting solutions across organization.

Updated BI Manager with any Reporting challenges and worked towards creating solutions for the same.

Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.

Designed, developed and published customized interactive reports and dashboards using Tableau.

Created drill through reports in dashboard.

Involved in creating data blending in case of merging different sources.

Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.

Used Action filters, Parameters and LOD calculations, Quick Table calculations, Sets, etc. for preparing dashboards and worksheets in Tableau.

Extensively used data blending in Tableau.

Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

Involved in creating a dual-axes bar chart with multiple measures.

Analyzed relational database model according to business requirements to create Tableau associative data model.

Environment: Tableau 9.x/8.x(Desktop/server), Oracle, SQL Server, Microsoft Office Suite, Teradata, Oracle, SQL Server, SQL.

Ragh steel Industries, Chennai, India Jan 2012-April 2014

Business Analyst/ Tableau Developer

The project was to provide updated information to the management and to provide the reports

Based on the requirement of the users.

Responsibilities:

Involved in Full life cycle design and development of Business Objects Enterprise Applications.

Involved in gathering the requirements from Business Managers for reports development.

Designed and developed Universes as per report requirements of Business analysis.

Involved in bug fixing for invalid data flows, Work flows and projects, testing of Stored Procedures and Functions, Testing of Data Integrator jobs, and the Target Data Worked with Contexts and Aliases to resolve the Loops in Universes.

Identified the Metrics and sub metrics, Key performance indicators (KPI’s) for Dashboard development.

Worked on multiple data providers to develop the dashboards coming from different sources.

Completed training in tableau desktop and server.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in tableau desktop.

Actively participated in clarification meeting with the clients.

Involved in testing the SQL scripts for Tableau reports and Dashboards.

Monitoring the daily job scripts for loading the data about business transactions from source Systems to EDW

Designed Stored Procedures while generating the reports and tested them against Oracle Database

Identified critical areas of business risk and modified business processes to reduce risk by using the Risk-Management Process

Identifying & Managing risks, Resource analysis, Cost analysis, Post project analysis & coordination among cross-functional teams & follow-up with clients for settlement of project based issues

Environment: Oracle, Tableau 8.x/9.X (Desktop / Server), MySQL, Microsoft office (word, Excel, PowerPoint), windows XP, SQL Server 2005, Desktop Intelligence, Web Intelligence.

Academic Experience

Florida Institute of Technology, Melbourne, FL

Graduate Student Researcher

A health app - app which is used to improve the diet cycle based on the user's choice using android studio and integrating with SQLite Database.

Mark sheet Management System

Using Tableau desktop 10 I have created a visualization report based on the information of the student. The information is included in the report which will show the maximum and minimum range of students in the entire course.

Networking Monitoring

Monitor network performance, availability and reliability using tool like Wireshark.

Education

Florida Institute of Technology, Melbourne, FL (2015 – 2016)

Master of Science in Computer Information Systems

Anna University (2010 -2014)

Bachelor of Engineering in Electronics and Communication Engineering

Certification: MySQL 5.7 Administration

Contact this candidate