SUMMARY

• Having 9+ years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing /Decision support systems and Business Intelligence.
• To have a challenging career in the field of Tableau, QlikSense,BigData, Qlikview,, SSRS,SQL Server, Nprinting and SAP BI/BO to get an opportunity to utilize my conceptual, analytical skills and in the process to add value to myself and to the organization with which, I am associated.
• Proficient with the Tableau suite of products such as Tableau Desktop, Tableau Data Prep, Tableau online, Tableau Server.
• Having experience as Tableau lead and managing the Offshore/Onsite teams.
• Proven experience in building Dashboards, Storyboards, Reports and Data Visualizations using Tableau with multiple data sources files (SQL, Excel, Flat files) and databases.
• Implemented complex calculation in Tableau using LOD, Table Calculations, Conditional Formatting.
• Hands - on experience in building, publishing customized interactive reports and dashboards, report scheduling using tableau server.
• Experienced working with various files such as CSV, Excel and JSON (structured and semi structured data).
• Strong SQL skills, including use of subqueries, group by, unions, multi-table joins, scalar functions, aggregate functions.
• Proficiency in creation of complex SQL queries to deliver reports to customers and internal stakeholders.
• Knowledge and experience in data analysis, data preparation using SQL, and Python (pandas).
• Expertise in using databases such as Oracle,Impala,Hive,Kudu, DB2, My SQL and Teradata.
• Having experience in AWS tools like S3 & Redshift database.
• Good understanding of the data protection or privacy rules associated with handling sensitive information in the credit card domain.
• Experience in designing, developing and implementing innovative analytical solutions.
• Responsible for understanding transformation and ETL that correspond with existing data structures and data models.
• Excellent knowledge of data warehousing and dimensional modeling concepts.
• Experience in building reports utilizing Star and Snowflake schemas.
• Familiarity with Agile development process (Scrum) and technologies (JIRA).
• 4 years of experience in complete life cycle of QlikView/Qliksense application such as requirement analysis, High & Low Level Design, Development of reports/dashboards, Testing, User Acceptance Testing, Go-Live, Support
• Having Qlikview Developer Certification on 11.1 version
• Having experience in Qlikview Nprinting version 16.
• Use of heterogeneous sources to collect data such as SQL Server, Oracle, Teradata, flat files and excel files and effectively using the Data Blending feature.
• Experienced in creating filters, quick filters, data source filters global filters, context filters, user filters, actionsand creating Dashboards for key performance indicators.
• Experience in developing multiple dashboards/reports using various charts like Bar, Stacked Bar, Line, Dual-axes charts, Geo-Maps, Bubble, Histograms and Heat Maps in Tableau.
• Expert in Strong understanding of dimensional data modelling, Strong SQL optimization capabilities, Metadata Management i.e., Connections, Data Model and VizQL Model.
• Extensively used various QlikView Scripting and UI functions such as aggr, rank, range,sum, firstsortedvalue, applymap, match, concat, numeric and date functions etc.
• Implemented Section Access on various QlikView Applications so that the Data in the Dashboard will be filtered based on the User’s Access privilege.
• Extracting the data from various datasources and integrated with websites by using Workbench in the Qlikview server.
• Having experience on Integration of SAP BW with Qlikview.
• Expertise in Developing QlikView Applications using different data sources like Vertica,Oracle, SQL Server, Text files, Excel documents and generated different Dashboards as per the user requirement.
• Having domain knowledge on HealthCare, Pharma,Safety&Medical Devices environment
• Having experience on Qlikview NPrinting tool to generate reports and scheduling to the end users.

TECHNICAL SKILLS

BI Tools: Tableau 9.0,10.3,10.5,19.3 Tableau Desktop, Tableau Online, Tableau Server, Qlikense, QlikView 11/10/9, BO, Web Intelligence Tool, Bex Analyzer,Nprinting 16

ETL Tools: Informatica Power Center, Spark, Sqoop,S treamsets

Databases: Impala,Hive,KuduVertica DB, SQL Server, Oracle PL/SQL 10g, 11g,, MS Access

Packages: MS-Office (MS-Access, MS-Word, MS- FrontPage and MS-Excel)

Languages: SQL, PL/SQL,Python

PROFESSIONAL EXPERIENCE

Confidential

Tableau Lead/Developer

Responsibilities:

• Gathering the requirements from Business users and analyzing it and creating design document before going for development.
• Developing dashboards for workflow qualified cases and submitting the reports to Health authority.
• Gathering Adverse events information from all the hospitals and creating dashboards for HealthCare.
• Review the business specifications to understand user visualization requirements.
• Working closely with Data Management MDM programmers for data quality accuracy checks.
• Strong experience in creating sophisticated visualizations, calculated columns and custom expressions.
• Developed Line Chart, Map Chart, Cross table, Bar chart, Tree map and complex reports which involves Calculated Columns, Parameters and Table level Calculations.
• Expert in writing SQL Queries on MySQL and Impala.
• Combined various data connections like SQL and excel to create a data model in Tableau desktop.
• Enhancements to the Dashboard to improve performance.
• Build, customize and publish interactive reports, visualizations and dashboards using Tableau.
• Used parameterswith calculated fields, actions, measure-swaps, changing views, and auto-updates.
• Efficiently manage time for timely project deadlines as well as ad hoc requests.
• Modified the existing Tableau reports and improved the performance of the dashboards.
• Perform data analysis to understand data marts using data warehousing concepts like Snowflake and Star Schemas.
• Promotion of tableau reports to development, testing and production environments.
• Perform functional and performance testing, participated in end-to-end reporting support activities.
• Perform peer review of code and testing in order to detect and minimize application problems.
• Develop and provide training to team members and other business staff on basic utilization and advanced proficiencies
• Perform data analysis to understand data marts using data warehousing concepts like Snowflake and Star Schemas.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Involved in using complex multiple data sources such as SQL, Flat Files, Excel and Access, Oracle, SQL Server, Impala,Hive,Kudu for designing and modeling of Tableau application.
• Data loads into the HDFS by using Spark.
• Developing ETL jobs for extracting data from SharePoint application using REST API’s
• Developing scripts and deployed them to pre-process the data before moving to HDFS.
• Maximize optimization within source or target databases and Maximize parallelism techniques.
• Performed unit testing and integration testing after the development and got the code reviewed.
• Used Dual Axes, Reference lines, Trend lines to show their sales growth.
• Created calculated fields using functions available in order to different metrics as per the requirements.
• Protected sensitive information such as Personally Identifiable Information (PII) by enabling at-rest data encryption for tableau extracts, roles and permissions at report level in Tableau server.
• Analyzed and understood sensitive information while working on data preparation and visualizations reports and also the data protection or privacy rules associated with sensitive information in the Pharma domain.

Environment: Tableau, SQL Server, Impala, Hive, Kudu, Sharepoint, Cloudera.

Confidential, Houston, TX

Tableau Developer

Responsibilities:

• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data in Tableau.
• Leveraged Tableau built in graphical capabilities to create Bar charts, Treemaps, Geomaps, Area charts.
• Used Tableau to create visual interactive dashboards, workbooks and stories for better decision making.
• Implemented the various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop.
• Effectively used data blending feature in Tableau to connect different databases like Oracle, MS SQL Server.
• Maintaining permissions of Tableau Views and Dashboards.
• Extensively worked on parameters, Pareto charting, mapping, calculations, demographics and geographic fields.
• Worked with string functions, date calculations and swapping dimensions with parameters.
• Responsible for generating dashboards in Tableau Server using different data sources including Excel, Oracle and Microsoft SQL Server.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Used excel sheet, flat files, CSV files to generate Tableau Adhoc reports.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Impala) using data blending.
• Published Tableau dashboards on to server, administered user groups and provided production support for tableau users.
• Build, customize and publish interactive reports, visualizations and dashboards using Tableau.
• Implemented complex calculation in Tableau using filters, actions, parameters, LOD, and Table Calculations.
• Used parameterswith calculated fields, actions, measure-swaps, changing views, and auto-updates.
• Efficiently manage time for timely project deadlines as well as ad hoc requests.
• Modified the existing Tableau reports and improved the performance of the dashboards.
• Perform data analysis to understand data marts using data warehousing concepts like Snowflake and Star Schemas.
• Promotion of tableau reports to development, testing and production environments.

Environment: Tableau, Vertica, SQL Server

Confidential

Qlikview /Qliksense Developer

Responsibilities:

• DesignedQVWsto generateQVDs for faster and efficient data reloads.
• Gathering the requirements from Business users and analyzing it and creating design document before going for development.
• Responsible for End to End Qliksense development, Testing and Deploying in Server.
• Volume analysis to dashboards and doing some preventive steps to increase the performance.
• Data is loading into Kudu and generating reports over it.
• Change Data Capture method is implementing by using Informatica Power Center.
• Integrating Qliksense with Cloudera system by using Impala ODBC drivers.
• Trained users on the functionality of the software and support them in using the application.
• Actively participated in clarification meeting with the Clients.
• Created dashboards by extracting data from multiple databases, write load scripts, and develop UI according to user requirements.
• QlikView best practices were used in implementation of scripting, set analysis and usage of variables.
• Designed and Developed QlikView reports, dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, and Calendar & Date Island meeting the business requirements.
• Implemented security using QlikView section access that dynamically hides selected areas of the dashboard depending upon user privileges
• Data was extracted from the Infocubes and created reports for BW Data.
• Created reports by using Bex Analyzer and developed dashboards for the same data by using Qlikview.
• Deployed the QlikView applications in the server. Created Publisher Tasks in QMC for the QlikView Application to Reload and Distribute the QlikView Application on to the Access Point.
• Scheduled the Publisher Tasks Daily/ Weekly/ Monthly on various Dashboards based on the Database updates.
• Monitoring all the Qlikview Tidal jobs and fixing the issues in case of any Dataload failures.
• Provided End User and production support after deploying the application into the production environment, also provided extensive support for the users on application usage and trained users in the functionality of the software
• Collected Data and images from the QVW files and generating reports by using Qlikview NPrinting tool.
• Created and Scheduled the reports to the end users by QLikview NPrinting tool.
• Pixel perfect,Excel,Pdf and Word reports are generated by using Nprinting tool.
• Cyclic reports are generated in Nprinting.
• Recipients are importing from Qlikview entity object and Excel files and sending reports to the end users by providing the related data in Nprinting.
• Recipients are dynamically updated in the Nprinting tasks by Creating groups while importing from excel,Qlikview entity etc.

Environment: Qlikview 11.1, Vertica,SQL Sever, QLiksense, Nprinting.