PROFESSIONAL SUMMARY:

• Having 9+ years of experience in Analysis, Design, Development and Implementation of Business Intelligence Projects and 6+ years with Tableau .
• Experience in working with Tableau Desktop, Tableau Server, Tableau Online, and Tableau Reader in various versions of Tableau 10.4/10.3 /10.2/10.0/9.3/9.1/8.2/8.0.
• Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets , create visually compelling and actionable interactive reports and dashboards.
• Deep experience with design and development of complex Tableau visualization solutions .
• Mastered the ability to design and deploy rich graphic visualizations with Drill Down and Drop - down menu option and Parameterized using Tableau .
• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visualization techniques.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Published Tableau dashboards on Tableau Server and Tableau Online, embedded them into portal.
• Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real-time systems all in one dashboard.
• Created Operational Dashboards to track information throughout the course of daily operations, understanding the status of production, machine utilizations, web traffic, or other critical systems.
• Setup trusted authentication in Tableau server and pass requests from Web server.
• Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, LODs, dynamic interaction, flexible ad-hoc capability in various functional areas like Health & life science, finance.
• Experience working on Agile Methodologies.
• Good understanding in AWS solutions like EC2, S3, RDS, EBS, Elastic Load Balancer, Auto scaling groups.
• Worked on AWS EC2 Instances Provisioning, VPC setup, Auto Scaling for availability of EC2 Instances and availability of applications.
• Managed and reviewed huge Hadoop log files.
• Created data model for tableau.
• Power BI experience in designing Interactive Reports and Data Visualization using Power BI Desktop.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Designed and setup user security for the entire landscape to facilitate Windows AD login and used Tableau CMD for various Dashboard migrations from one environment to another.
• Expert in installing, configuring tableau server and using Tableau Command line utility for administrative tasks like creating users, groups, projects and permissions.
• Good understanding of Enterprise Data Warehouse Power insight data.
• Optimize the VizQL server processes to handle loading and rendering views for Tableau Server.
• Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
• Experienced in writing queries, stored procedures and functions using.
• DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Expertise in data preparation with experience in blending multiple data connections, and creating multiple joins across it and various data sources.
• Proficient in discussing and defining project, Gap Analysis with the clients from both a business and technical perspective.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Skilled in translating business requirements into technical designs and specifications.
• Able to communicate across both technical and business oriented professionals.
• Excellent interpersonal communication, problem solving, documentation, good understanding of business process management and business analytical skills with an ability to adapt modern technology quickly and a strong team player.

TECHNICAL SKILLS:

• Tableau Desktop 10.3/10.2/10.0/9.3/9.2/9.1/8.2/8.1/8.0
• Tableau Cloud
• Tableau Reader
• Tableau Public
• Tableau Mobile
• C
• C+ +
• Visual Basic
• R
• Python
• ASP.NET
• SQL
• PL/SQ.
• XIR 2/10.0/9.0/8.0
• Universe Designer
• Xcelsius 2008/4.5
• UNIX
• Win
• LINUX
• Web Sphere
• Apache/Tomcat
• Oracle
• MS SQL Server
• Access
• DB2
• Teradata
• Cassandra
• Alteryx.
• Oracle 9i/ 8i/7.3
• MS SQL Server 2000/7.0/6.5
• Access
• MongoDB
• DB2
• Teradata
• Hive
• Redshift
• AWS

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr. Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop (10.4/10.3/10.2/10.1/9.3/9.2 ).
• Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Involved as a technical expert providing input to application design regarding production tuning and administration requirements.
• Involve in ETL applications, data feeding, cleansing, archiving and re-modeling.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps .
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Creating New Schedule's and checking the task's daily on the server.
• Worked extensively with Advance Analysis Actions, LODs (FIXED, INCLUDE, EXCLUDE) Calculations, Parameters, Background images, Maps.
• Evaluated bug fixes and identified the changes from 10.3 to 10.4 and digested the customer accordingly.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Desktop/Server Reports.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in iPad, iPhone, and other smart mobile phones.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Built several dashboards using Global Marketing Data to support week based reporting efforts for C Level and Senior Audiences. Key marketing initiative dashboards had very high visibility and received CEO Acclaim.
• Connected to the AWS Redshift directly from Tableau to access cloud data warehouse and quickly perform visual analysis.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Plan and implement the overall analytics and business intelligence strategy
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Executed and tested required queries and data before publishing Dashboard.
• Partner with the Technology teams to deliver a stable and highly available reporting platform.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.

Tableau Administrator/ Developer

Confidential, Eden Prairie, Minnesota

Responsibilities:

• Worked in the agile methodology -using Scrum , which has its primary focus on the management part of the software development in small iterations of four weeks sprint.
• Interface with all areas of US Pharmaceuticals Sales Operations, Field Sales Support, Commercial Analysis and Data Management.
• Created dashboards to compare gene sequence from multiple patients which helped management to analyze latest trends, and take suitable decisions on trials.
• Support Critical/Supportive Care, Oncology & Managed Markets business units.
• Design, analyze and present incentive compensation plans to motivate selling efforts of 500+ senior account managers and their supervisors.
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Published Tableau dashboard on Tableau Server and embedded them into portal.
• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Understand the Requirements and Functionality of the application from specifications.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Experience in Tableau Server Installation, Configuration, Maintenance, Security, creating users, groups, projects, assigning access levels. Production support for monitoring server health.
• Connected to the AWS Redshift directly from Tableau to access cloud data warehouse and quickly perform visual analysis.
• Provide ad-hoc analysis of compensation outcomes, investigate data discrepancies, and respond to field support calls concerning incentive compensation data.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created business driven dashboards using different chart types like Crosstab's, Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Gantt charts, Bubble charts, Scatter Plots, Trend lines, Bullets, Bullet Graphs, Highlight tables and Histograms in Tableau Desktop.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, AdHoc, business views along with user acceptance test and data accuracy test.
• Converted existing Cognos Reports into Tableau Dashboards.
• Handled user licenses for projects
• Developed multiple dashboards with Power BI depicting differing KPIs for business analyses.
• Involved in creating database objects like tables, views, procedures triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Plan and implement the overall analytics and BI strategy.
• Importing tables using Warehouse catalog and Creating Logical Tables.

Tableau Administrator / Developer

Confidential, Buffalo, NY

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Setup and configuration of Tableau server 9.1 in various environments and used Tableau CMD and Tableau admin tools to configure the server per best practices.
• 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.
• Created views in Tableau Desktop that was published to internal team for review and further data analysis and customization using filters and actions.
• Setup trusted authentication in Tableau server and pass requests from Web server.
• Gathered Business Requirements by interacting with Business Users, Project Manager and SMEs.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Word clouds, Bubble Charts, Pareto Charts, Waterfall Charts, Bump Charts, Funnel Charts, Bollinger Charts) based on client’s need.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Converted existing Cognos Reports into Tableau Dashboards.
• Connected to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Extensively worked on micro strategy administration that includes intelligence server administration, configuration of memory settings and performance monitoring.
• Setup trusted authentication in Tableau server and pass requests from Web server
• Setup user security for the entire landscape to facilitate Windows AD login.
• Worked heavily using Tab-admin tools and Tableau Cmd for setting up security profiles for various User groups and Users.
• Used Tableau with AWS cloud connecting to AWS EMR and AWS redshift.
• Worked on Setting up Tableau Server on AWS.
• Actively involved in the Server migration and the Tableau Server Installation process.
• Implemented pivot/un-pivot, transpose features of Power BI to load data into excel Power Pivot.
• Used Elastic Load Balancing to distribute requests across multiple gateways in a Tableau Server cluster.
• Creating users, groups, projects, Data Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Worked in the conversion of SQL server functions into the Teradata Store procedure for confirming the data.

BI/Tableau Developer

Confidential, ILLINOIS

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Designed, developed and tested various Tableau visualizations for dashboard and ad-hoc reporting solutions.
• Redesigned the data source having data from various sources into one SQL Server and to Tableau.
• Worked closely with data architects to improve data's performance by reducing the number of calculated fields and thus optimizing performance.
• Created Heat Map showing current store location by color that were broken into regions allowing business user to understand where we have most customer vs. least customer.
• Conducted meetings with business stakeholders, clients and director level members for requirement gatherings and presented various solutions using best practices.
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Expertise in data preparation with experience in blending multiple data connections, and creating multiple joins across it and various data sources.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Performed End to end testing using SQL Queries in Oracle.

BI/ Tableau Developer

Confidential, Jersey City, NJ

Responsibilities:

• Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
• Converting high-level design specifications to detailed functional and technical specifications.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
• Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Developed and modified Business Intelligence analytical reports/ dashboards dealing with Origination, Portfolio Risk, Consumer Credit, FP&A and Marketing using Tableau desktop.
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created very complex Dashboards using Tableau using the drill down, drill across, actions for business steering committee.
• Designed, developed and implemented Tableau Business Intelligence reports.
• Worked on creating Universes using the Business Objects and connected to the database using ODBC.
• Upgraded Business Objects Universes, User groups, and reports from Version 5x to 6x.
• Maintaining and updating database models, generating or modifying the database schemas Data Mapping and DWH loading Use case analysis. Database coding and implementation.
• Using SSRS , Generated matrix reports, drill down, drill through , sub reports, chart reports, multi parameterized reports, Cross-Tabbed Reports.
• Involved in created stored procedures, views, and custom SQL queries to import data from sql server to tableau/ SSRS.
• Created Dashboard’s using the Interactive Metric Trends (IMT) and the Speedometer.
• Generated Business Objects XI 3.1 (Web Intelligence), dynamic report, which allows business users to select multiple dates, or range of dates.

BI Consultant

Confidential, Jersey City, NJ

Responsibilities:

• Worked on creating Universes using the Business Objects and connected to the database using ODBC.
• Designed and implemented data model for the database to support live data collection for systems sending variable number of measures using Index Organized tables and Oracle PL/SQL.
• Actively played the role of 'Innovation champion' and led the BI team to achieve 100% innovation index, which was recognized by the leadership team.
• Validating the data flow from source to target system to ensure correctness of the implementation.
• Designed universes and created Web Intelligence documents for queries developed on the commission data.
• Worked on SAP Business objects including Universe Design, Web Intelligence, Crystal Reports and Xcelsius.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Built dashboards with forecast, trend line, reference lines, YoY growth, MTD, YTD, QTD type of analysis to track GEM events.
• Upgraded Business Objects Universes, User groups, and reports from Version 5x to 6x.
• Designed, tuned and optimized the Star Schema to implement core database.
• Developed various Mappings & Mapplets to load data from various sources using different Transformations.

SQL Developer

Confidential

Responsibilities:

• Used SDLC approach to create multi-dimensional data warehouse which included snowflake schema, data marts, fact tables and dimension tables.
• Designed SSIS Packages to extract data from various data sources such as Oracle, SQL Server, Access database, Excel spreadsheet, xml files and flat files into SQL Server 2008 for further Data Analysis and Reporting.
• Wrote SQL queries using DML, DDL, Table joins, Group functions, Grouping functions, Analytical functions, Partition by clause towards Reports and Application development.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Utilized oracle functions like rank/dense rank, connect by clause, pivot, and case and decode for performing complex logical operations
• Create stored procedures, functions, packages, triggers using PL/SQL Developer.
• Extract the data from the different servers using SSIS
• Retrieved data from data warehouse and generated a series of meaningful business reports using SSRS.
• Involved in project planning meeting with Project Manager, Business Analyst and Team members to analyze the business requirements and outlined the proposed solutions.
• Involved in using Team Foundation Server (TFS) to check in and check out SSRS reports and SSIS packages.
• Involved in developing data conversion programs using SQL *Loader, PL/SQL, and UNIX shell scripts.