SUMMARY:

• Around 3+ 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, 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, Tableau (Desktop/ Server), SSRS, SSIS, SSAS

Databases: Oracle, MS SQL Server, MySQL, Teradata

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:

Confidential, Irving, Texas

Qlik Sense Developer

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.
• 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.
• Helped end users to design test cases and worked through multiple UAT cycles.
• 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.
• Presented the Dashboard to Business users and cross functional teams, defined KPIs (Key Performance Indicators), and identify data sources.
• Enhancement and translation of the already existing Dashboards into Qlik Sense working extensively with Set Analysis.

Environment: Qlik Sense Desktop/Server, Oracle, SQL, Windows, MS Excel, HIVE

Confidential, Plano, Texas

Qlik/Tableau Developer

Responsibilities:

• 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: Tableau Desktop/Server, Oracle, SQL, SSRS, SSIS, MS SQL Server, Windows, MS Excel/Access, HIVE, Cloudera, Hadoop, Sqoop.

Confidential

Tableau Developer / Data Analyst

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 (Word, Excel, PowerPoint), Teradata, Oracle, SQL Server, SQL.

Confidential

Business Analyst / Tableau Developer

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.