SUMMARY

• 9 years of IT experience in integrated application software across various business domains such as Health care, Banking and Retail.
• Experience in the Information Technology industry in Analysis, Design, Development, Testing and Implementation of various applications using BI tools.
• Extensive experience in Tableau Desktop, Tableau Server, Tableau Public, Tableau Online in various versions of Tableau (2019, 2018, 10.x)
• Good knowledge of Kimball/Inman methodologies and experience in creating Data Models at multiple levels of detail and functionality in developing star schema and snowflake schema. Experience in data modeling concepts.
• Expertise in designing rich Interactive reports and dashboards integrating various reporting components from multiple sources.
• Experience on creating reports using Web Intelligence and Tableau according to user requirements.
• Experience in configuring reports from different data sources using data blending.
• Proficient in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps, Waterfall and Highlight tables.
• Created reporting objects like Facts, Attributes, Hierarchies, Filters, Prompts, Calculated Fields, Calculated Sets, Groups, and Parameters etc. in Tableau.
• Ability to understand Functional Requirements and Design Documents.
• Interacted with Business Users and Business Analysts to understand and document the requirements and translate these to Technical Specifications.
• Experience in interacting with end - users to gather document reporting requirements.Experience on Reports testing and data validation using SQL developer and Application.
• Experience in developing complex Stored Procedures, Tables, Views, User defined Functions, User profiles, Relational Database Models and Data Integrity, SQL joins, indexing and Query Writing.
• Experience in integrating Alteryx and tableau, publishing data extracts from Alteryx to tableau server, Pulling data from Alteryx App on server though Web data connector into tableau Desktop.
• Experience in Installing, ConfiguringandAdministrationofTableauServer
• Worked with other teams to deliver and operate large scale, distributed services in the cloud.
• Experience in Importing Data from Remote Hosts over SSH in Red Shift data base.
• Experience in interacting with end-users to gather document reporting requirements.
• Experienced in writing system specifications, translating user requirements to technical specifications.
• Effective skills in planning, coordination, and execution of system applications and engineering projects.

TECHNICAL SKILLS

• Tableau Desktop 2019, 2018, 10.x, Tableau Server, Alteryx v11.x, BOXI 3.1 (Universe Designer, Web Intelligence, Info view), BI 4.2 (IDT, BI Launch Pad),SAS, Design Studio.
• Oracle 10/11g,12c, MS SQL Server, RDB, IBM Netezza, Amazon Red Shift andSAP BW
• SQL, PLSQL
• Linux, Windows.

PROFESSIONAL EXPERIENCE

Confidential

Tableau Developer

Responsibilities:

• Collaboration with end users, project stakeholders, and support partners to identify needs, goals, metric measurements, and business models to understand interfaces and enable end users to quickly identify key themes within the data.
• Develop, validate and execute algorithms, statistical models and applications that answer applied research and business questions.
• Developing and implementing analytical data models, dashboards and reports using Tableau and SAP business objects for users to analyze data and make business decisions.
• End-to-end implementation of Business Intelligence (BI) reports & dashboards.
• Use of structured query language (SQL) to query, analyze and integrate data.
• Documenting the dashboard needs, critical success factors of the business, related KPIs and measures in the dataset, and the designs
• Generate ad hoc user reports and clarify business user queries and management reports, metric reporting and issue tracking.
• Implement process improvements in data sourcing, dashboard performance and product project life-cycle.
• Testing the reports for formatting and data correctness, and publishing the workbooks on the server for scheduled refreshes.
• Involving in Promoting reports from one environment to other environments.
• Evaluating and improving existing systems that are in place as well as collaborating with teams within the business to integrate these new systems to streamline workflow and company processes.
• Involved in optimizing the performance of web intelligence reports.
• Updated and maintained Universes based on user requirements and data source changes.
• Created complex reports by linking data from multiple data providers, using free hand SQL and Merged dimensions.
• Organized data in reports by using filters and worked extensively on hierarchies for the client specific requirement.

Environment: Tableau 2019.2, 2018.2, Tableau server/Administration, SAP Business Objects 4.2, IBMNetezza, Aginity Workbench 4.9, SAS 7.

Confidential

TableauDeveloper/Admin

Responsibilities:

• Involved in gathering requirements from the Business Users and produce technical, functional specifications for the dashboard development.
• Good Knowledge working on Reason codes, Diagnosis codes and Procedure Codes in different Lines of Business.
• Created various Provider KPI scorecards to show early indicators on how many claims are going to come from that provider and members that are assigned for that provider in that area/region to see how member health is getting better.
• Extensively used LOD expressions, calculated fields, Table Calculations and Sets to visualize user’s critical requirements.
• Implemented Row level security for Dashboards by creating user filters in Tableau and published dashboards in live connection.
• Experience in installation and administration of Tableau server and the functionalities of publishing the workbooks, setting the priority for the dashboards to refresh, creating data extracts refreshes.
• 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.
• Created and managing schedules of the Tableau Extract setting the priority of the extracts etc.
• Experience in creating Tableau Repository, adding Users and Groups, assigning password security and assigning privileges in Tableau Server.
• Involved in different administration tasks on Alteryx Server such as creating Subscriptions and adding users, data connections, creating credentials and assigning different access rights to the Users.
• Integrated Alteryx With Tableau to load Alteryx workflow output into tableau Server based on which the real time dashboard data has been populated.
• Scheduled the published dashboards from Tableau Server on weekly basis.
• Restricted data for particular users using Row level security and User filters.
• Created Database objects including Tables, Triggers and Views, Query tuning and optimization through T-SQL
• Developed and Optimized Stored Procedures and Functions using T-SQL
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction

Environment: Tableau 2018.2, Tableau server/Administration, Microsoft SQL Server Management Studio 2014, Oracle, UNIX, Amazon Redshift, Postgre SQL.

Confidential

BIDeveloper/Admin

Responsibilities:

• Interacted with business stake holders, gathering requirements and managing the delivery, covering the entire development lifecycle
• Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.
• Performed data analysis and various data models to validate the future state of trending for various business departments related to different line of Business.
• Developed interactive dashboards using quick filters, cascading filters, context filters, and parameters.
• Participated in gathering the user requirements and involved in writing technical design documents.
• Used Sub queries, joins, CTE's and Analytical functions for data retrieval.
• Created jobs for automatically running stored procedures for day to day operations using SQLServer agent such as index rebuild, data loads and summary reports
• Created Hierarchies, which helps the report users to drill down to lower levels.
• Experience in testing and fixing any problems in Reports.
• Resolved issues like loops by creating contexts to remove the cyclic dependencies.
• Interacted with Business Users and Business Analysts to understand and document the requirements and translate these to Technical Specifications for Universes and Business Object Reports.
• Used business objects functionalities like breaks, sorts, alerters, filters and conditions.
• Analyzed reports by using Drill down and Master Detail.

Environment: Tableau Desktop 10.1, SAP BOXI 3.1, BI 4.2,Microsoft SQL Server Management Studio 2012, Oracle 10g.

Confidential

Jr. BI Developer

Responsibilities:

• Designed and assessed engineering functions across multiple platforms.
• Involved in understanding Business Process and coordinated with Business Analysts to get specific user requirements to build the Data Marts.
• Understanding the user Requirement and involved in Universe Creation.
• Designed and Maintained Universes by defining joins, cardinalities between tables and by using contexts and alias tables to remove cyclic dependencies.
• Created Objects using different Business Objects functionalities like @ prompt, @Aggregate Awareness, @select in the process of designing the universes.
• Updated and maintained Universes based on changing user requirements.
• Worked closely with SAP team to integrate SAP with BO.
• Worked extensively on hierarchies for the client specific requirement.
• Developed SAP Universe, Created Classes with Dimension, Detail & Measure Objects and specified the hierarchies.
• Created Web Intelligence Reports and organized data in reports by using filters, sorting, ranking and highlighted data with Alerter.
• Created the reports using BO functionalities like combined Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and formula.
• Experience on Reports testing and data validation using SQL developer and Application.

Environment: BOXI 3.1, Universe Design Tool, Web Intelligence, SQL