OBJECTIVE:

• Self - motivated, results-oriented professional with 7+ years of experience in designing and developing reports and dashboards using Tableau seeking to associate myself with an organization that offers progressive and challenging career and provides opportunities to apply my technical & management skills for the constant development of the organization

SUMMARY

• Over 7+ years of experience in Data Organization, Analysis, Data Visualization, Database Design and Management while working as a Tableau/BI developer.
• Proficient in creating effective and visually aesthetic visualizations based on the user requirements using Tableau (Desktop, Public, Server)
• Tableau Server Administrator-Experience in installations, upgrades, general admin/maintenance activities, add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.
• Experience in Metadata management, Data Quality validation, and Data profiling, Data blending, Data extraction, Data integration, Data modeling and Data rendering in Tableau.
• Proficient in the design and development of dashboards, reports using various Tableau visualizations like dual axis, multiple dual axis, bar graphs, bar in bar graphs, scatter plots, pie charts, heat maps, bubble charts, tree maps, funnel charts, box plots, waterfall charts, lollipop charts, geographical visualization and others making use of actions, calculated fields, local and global filters as per the users’ requirements
• Extensive experience in creating navigation links within interactive dashboards
• Experience in creating aggregates, sets, joins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, parameters, and dashboard formatting (Mark labels, mark card changes, annotations, layout containers, rich text formatting, shared encoding groups)
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, Groups, Hierarchies and Sets to create detail level summary reports.
• Good in creating Reports that include Filters, Charts, Scorecards, Drilldown and Drill Through
• Report performance optimization in tableau using extracts and context filters.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Experience in analyzing client requirements, resource planning, coding, debugging, testing, deployment, support and maintenance of business applications using SQL Server 2008/2005/2000 , SSIS, SSAS, and SSRS.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), OLAP SAP BW, MS Excel, MS Access, Teradata and DB2.
• Prepared backups using Tabadmin and Tabcmd commands.
• Expertise in SQL Server, SSIS, SSAS, SSRS, Linux, Microsoft Office suite, and relational databases including Oracle 9i/10g, MS SQL Server, Teradata, DB2, Mongo DB, Influx DB and PostgreSQL
• Proficient in PL/SQL programming - Stored procedures, functions, packages, SQL tuning and creation of objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms etc.
• Excellent Knowledge in Data Warehouse Concepts, Data Modeling, OLTP & OLAP in all environment which includes development (DEV), test (QA) and production (PROD).
• Proficient in SSIS creating Crystal reports for extracting, cleaning, transforming and loading data into data warehouse and SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, Merge, Merge Join, SQL task, Script Task and Send Mail Task to generate various Crystal Reports.
• Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse. Created ETL mapping documents to outline date flow from source to target system.
• Experience in Performance tuning of Targets, Sources, Mappings and Sessions.

TECHNICAL SKILLS

Operating Systems: Windows XP/7/8.1/10, Linux, iOS

Programming Languages: SQL, T/SQL, PL/SQL, Python Programming, R Programming, SAS

Markup Languages: HTML, XML, JSON

Data Visualization and Reporting Tools: Power BI, Tableau Desktop 10.4/10.1/9.1 , Tableau Server /10.18.2, SSIS, Crystal Reports

Data Warehousing ETL Tools: Informatica Power Center 9.1/9.5/9.6, SSIS, Business Objects Data services, Business Objects Administration

RDBMS: Oracle 9i/10g/11g, SQL Server 2000/05/08, MS SQL Server, Teradata, PL/SQL, Toad, Sybase12.x/11.x, IBM DB2, MS Access, Mongo DB

Related Skills: MS Visio, Postman API, Power Designer, Excel, version control, SQL Navigator, ER Diagrams, Conceptual, Logical & physical modeling, Healthcare Claims data handling

Soft Skills: Problem-solving, time-management, excellent written and verbal communication skills, results-oriented, self-starter, quick learner, good interpersonal and organizational skills

PROFESSIONAL EXPERIENCE

Confidential - Evansville, Indiana

Tableau Developer

Responsibilities:

• Analyzed and understood the process flow to provide solution for the proposed requirement change.
• Provided fix for a dataflow which was successfully implemented and accepted by the business
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development.
• Designed standardized DataMart with aggregated data, calculated metrics to suffice the source data need for various Tableau Reports and worked with ETL developers, DBAs, Data Modelers to implement the same in Development, Test and Production environment.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server, creating new schedules and checking the tasks daily on the server.
• Developed few sample dashboards using Tableau to present the data with excellent visualization and got the approval from users.
• Used Tableau to create visual interactive dashboards using calculations, parameters and workbooks for decision making to identify critical KPI's and helped them in finding the insights
• Expert in creating a dual-axis bar chart with multiple measures.
• Extensively involved in creating graphs and charts by using measures and dimensions data from various databases by using joins and blending.
• Writing various queries to pull the data required to verify the Metrics calculations form backend.
• Expertized with use of action filters, user filters, advanced navigation techniques, Level-of-Detail (LOD) expressions
• Performed rigorous unit testing for the code change in development and stage environments.
• Created Relationships, actions, calculated fields, sorting, groupings, live connections, in-memory in both tableau and Excel.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports by coordinating with senior managers in emergency.
• Given training/demos to users on Tableau Desktop for development.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization and analyzed in a given schema file.
• Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards and have experience in installation and maintenance of Tableau Server.
• Granting Permission to User’s and maintaining the User List and updated Server Architecture for scheduling Tasks.
• Analyzed and resolved key performance and server-based issues on regular basis.
• Documented interactive dashboards by combination of views and reports and created crosstabs, conditional, drill down, summery, sub reports, parameterized.
• Conducted data analysis using interactive Excel features.
• Implemented table partitioning to maintain performance levels to speed up loading and archiving.
• Evaluated database performance issues and executed database optimization.
• Experience on working with portal 11g. Create, edit, configure and manage portal pages.
• Developed SQL scripts to create database objects like Tables, Views and Sequences and created PL/SQL Procedures, Functions and Packages.

Environment: Tableau Desktop 10.1/10.4, Tableau Server 10.1/10.4, Windows 8.1/10, MS Office Suite (Word, Excel, PowerPoint), Oracle 11g Ex

Confidential - St. Louis, MO

Tableau Developer

Responsibilities:

• Served as Business Systems Analyst meeting deadlines and budget requirements.
• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Preparing Dashboards using calculations, parameters in Tableau and Developing Tableau reports that provide clear visualizations of various industry specific KPIs.
• Access and change extremely large datasets through filtering, grouping, aggregation, joining, blending and statistical calculation.
• Understood and implemented Tableau features like joins, R-integration, data blending, python integration and dashboard actions
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Used geographic view which clearly gives the performance of a state.
• Developed customized calculations when required.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau desktop/Server.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report and leaving no room for performance degradation.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks and assessed data for accuracy and other statistically unique values.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau Server, Tableau Desktop 9.1/10.0, SQL, MS VISIO, Microsoft Office Suite (Word, PowerPoint, Excel), MySQL Server, R-studio, Python

Confidential - Indianapolis, Indiana

Tableau Developer

Responsibilities:

• Involved in gathering requirements from the Business Users and produce technical, functional specifications for the reporting system. Study and understand the Business Scenarios of the existing systems, understanding the data and validating the data by applying the current business rules
• Analyzed data sources form Excel/Oracle SQL Server for Design, Development, Testing, and Production rollover of reporting and analysis projects within Tableau Desktop.
• Responsible for security configuration including Group setup, Permissions, Security roles and configuration of trusted ticket authentication.
• Worked on administration tasks like adding workbook Permissions, Ownerships and User filters.
• Effectively used data blending feature in Tableau to connect different databases like Oracle, MS SQL Server, SQL and Excel.
• Built functionalities by writing condition to incorporate with various metrics and hands on experience in Level-of-Detail (LOD) expressions such as daily profit Key Performance Indicators (KPI), Percent of total, Yearly trending analysis and Root cause behavior.
• Created Relationships, Actions, Data Blending, Filters, Parameters, Hierarchies, Calculated fields, Sorting, Grouping, Live connections and in-memory in both Tableau and Excel.
• Used Tabadmin and Tabcmd commands in creating and restoring backups of Tableau repository.
• Developed story telling dashboards 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 live connection with Oracle database schemas to provide near real-time data.
• Used Tableau Desktop to create various analysis worksheets, including customer analysis and equipment analysis.
• Extracted data from different data sources like SQL Server, MySQL and Tableau Server and created queries based on the requirement to provide data visually.
• Written Custom SQL to support Business requirements.
• Experience in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Executed and tested required queries and reports before publishing.

Environment: Tableau Desktop 9.1, Tableau Reader, MS SQL Server, MS Access 2016, Oracle11g, MY SQL, Teradata, SQL Server Management Studio, Microsoft Office Suite (Word, Excel, PowerPoint, Visio).

Confidential

Tableau Developer

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Played critical role in establishing Best practices for tableau Reporting by conduct meeting with the clients for gathering reporting requirements; identify the KPI's and developing POC Dashboards.
• Developed Complex dashboards and used advance chart visualizations in Tableau like Pareto Chart, Dual Axis, Waterfall charts, Bullet Graphs, Bubble Charts, etc. to assist business users in solving complex problems
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to created summary level and detailed Reports.
• Conducted Load and Performance Testing using TabJolt and resolved performance related issues on affected Tableau Reports.
• Connected Tableau server with SharePoint portal and setup auto refresh.
• Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports
• Managed Users on Unix/Linux and Windows systems.
• Develop reports using formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Strong experience with MS Excel, PowerPoint, Word and Visio.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.

Environment: Tableau 8/9, SQL Server 2008/2008 R2, T-SQL, SQL Server Management Studio, UNIX, Business Objects 3.1, Microsoft Excel.