SUMMARY

• Over 8 years of IT experience in Business Intelligence, System Analysis, Data Integration & Migration, Designing and developing client server applications for various Data Warehousing projects.Installing and configuring VMware 3.x, 4.x, 5.x ESX & ESXi servers.
• Expertise in using Tableau Server, Tableau Desktop, Tableau Reader, and Tableau Public.Creating and configuring DRS and HA on VMware clusters.
• Good understanding of Tableau server license mechanism and expertise in Installing, Configuring, and Administration of Tableau Server in Scale - out process.Modifying, managing resources and migrating virtual machines using vCenter server.
• Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters as per teh business/client requirement.
• Extensive experience in Tableau Administration Tool for Creating sites, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating wif other platforms like SharePoint.
• Experience on Tableau server security setup.
• Experience in creating Tableau server backups and restore configurations.
• Experience on migrating teh Tableau server and its processes.
• Experience in creating Sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters.
• Involved wif large volumes of volumes data integrating wif hadoop ecosystems.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Experience in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables, and Physical and Logical data modeling.
• Experience in implementing Data blending, Replace references, Customized queries, and advanced visualizations in Tableau.
• Worked extensively wif teh major functionality of ad-hoc reports, drill down reports, multi-parameterized reports, and drill through reports.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues wifin Tableau.
• Stretched Tableau limits to create unconventional Tableau charts such as Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, Gantt Charts, Bubble Charts, Histograms, Bullets, Heat maps and logical calculations to create groups.
• Worked on Creating Aggregates, Hierarchies, Charts, Filters, Quick Filters, Context filters, User filters, Table Calculations and Trend Lines also calculated measures.
• Implemented data blending and joins to work wif data from multiple databases in a single report.
• Implemented Data Representation using Visualization Techniques in Tableau using Alteryx (Graphs, Charts etc.)
• Involved in Data modeling, designing, and building relational databases.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Experience of working on Agile and other Software Engineering Methodologies.
• Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms.
• Have been working wif various data sources such as Oracle, SQL Server, Teradata, Google analytics, and flat file sources.
• Persuasive verbal and written communication skills and strong analytical skills, interest & ability to learn new technologies in short time.

TECHNICAL SKILLS

Tools: Tableau Desktop 9.1 /9.3, 8.x, Tableau Server, TOAD, SQL-DeveloperSAP Business Explorer, BEX Analyzer, Bex Query Designer, SAP-Lumira Informatica, SQL Server Reporting Services SSRS

Web Technologies: HTML, XML, CSS, Middle-Ware

Scripting Languages: MySql, Oracle 8i/9i, /10g, JQuery, VB Script, Jscript

Languages: PHP, Java, Python, VB.Net, ASP.NetC#.Net

Database Server: Oracle, Microsoft SQL server

Database: MySql, Oracle 8i/9i, /10g

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr. Tableau Developer

Responsibilities:

• Gathered requirements from users and prepared templates accordingly.
• Design and Developed Web reports and Universes for Advanced Services projects.
• Worked on Agile-Scrum methodology, trained my team on teh process change from Waterfall to Agile.
• Created Prompts, Custom Objects, Hierarchy, Custom Lov.
• Modified existing reports as per enhancement requests.
• Created new web reports using single and multisource queries
• Extracted large volumes of data feed from different data sources, performed transformations and loaded teh data into various Targets.
• Understood underlying Data and reworked Data Analysis wif PowerBI.
• Generated Dashboards wif Quick filters, Parameters and sets to handle views more efficiently.
• Developed & Implemented Reports using Tableau Server.
• Responsible for Creating of Users, Groups and Projects on Tableau Server.
• Created Customized and interactive dashboards (pulling data from multiple data sources).
• Handled multiples design, change, service requests etc. in Change point.
• Used Java Script API to customize teh views, selects, filters, date and time.
• Leveraged tableau built in graphical capabilities to create bar charts, tree maps, area charts and created custom visualization like donut charts, trellis plots etc.
• Worked on Visual Studio 2012 wif SSIS and SSRS Integration.
• Enabled Drill options like Drill down, Drill up, merge dimensions, sections, breaks, filters, Hide Sections/rows/tables, set values and rules.
• Developed reports using Horizontal tables, Cross tables, Bar, Pie Stacked bar charts, Combination charts etc
• Created detail reports for hyperlinking to drill down from Summary reports.
• Created well formatting reports for Finance users as well as for high level directors.
• Developed reports scheduled wif event based triggers.
• Creating different charts such as Scatter plots, Dual charts, Bar charts, Line charts & text tables etc.,
• Building, publishing & scheduling customized interactive reports and dashboards using TableauServer.
• Providing all teh necessary documentation, updating tasks in Rally and training to teh business users.
• Provided open document links to teh users to access most recent instances.
• Developed and demonstrated teh ease of use in working wif Hierarchies in Tableau to end users and power users wif effective usage of Drill up/ Drill down options.
• Tested all reports in various environments before and after upgradation.

Environment: Business Objects 3.1 and 4.1, IDT, Web Intelligence, Tableau Desktop 9.0, Oracle 11g, Informatica, Promotion Management, Windows 10, Advanced Services, Business Intelligence, Data Analytics, Agile-Scrum methodology, Tableau Desktop 8, 9.1, Tableau Server 8.0, 9.1, MS Office Suite, Teradata, Oracle, SQL Server, Visual Studio 2010/2012, MS Excel, Bigdata( Hive).

Confidential, Minneapolis, MN

Tableau Developer

Responsibilities:

• Administered user, user groups, and scheduled instances for reports in Tableau.
• Involved in designing and deploying rich Graphic visualizations wif Drill Down and Drop-down menu option and Parameterized using Tableau.
• Extensive worked wif Tableau Administration Tool, Tableau Interactive Dashboards and Tableausuite.
• Designed and implemented proof of concept solutions and created advanced BI visualizations using Tableau platform.
• 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 wifin Tableau Desktop.
• Involved in creating database objects like tables, views, procedures, triggers, functions using SQL to provide definition, structure and to maintain data efficiently.
• Created stored procedures, Cursors, Joins in T-SQL.
• Responsible for creating Reports using SQL Server Reporting Services (SSRS) and created various types of reports like table report, Trend charts etc.
• Gathering and analyzing user requirements and designing software solutions for teh proposed POC.
• Writing SQL queries in HIVE to extract source data from different data feeds to create reports and dashboards using Tableau Desktop as per teh business requirements.
• Creating multiple workbooks and dashboards using Calculated fields, Quick table calculations, Custom hierarchies, Sets & Parameters to meet teh business needs.
• Performing administration tasks such as creating and managing Users, Sites, setting permissions, managing ownerships, providing access to teh users using user filters and adding them to teh specific group.
• Deployed, Tested and Scheduled SSIS packages.
• Involved in testing teh SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled teh performance issues effectively.
• Configured Cache settings which improved teh performance of teh dashboards and report schedules and also created Custom Hierarchies to meet teh Business requirement on Tableau server.
• 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 teh data on teh fly wif teh usage of quick filters for on demand needed information.
• Developed formatted, complex reusable formula reports and reports wif advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that teh views and dashboards were displaying teh changed data accurately.

Environment: Tableau Desktop/Server, Oracle, SQL, T-SQL, SSRS,SSIS,MS SQL Server, Windows, MS Excel/Access, TOAD, Cognos BI, Big Data, HIVE (Drill Explorer), Rally, Windows Server.

Confidential, NYC, NY

Tableau Developer

Responsibilities:

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Developed donut charts for analyzing sales planning data.
• Created different KPI's using Table calculations and calculated key figures Manipulating strings, arithmetic calculations, aggregation options and Logical functions
• Worked extensively wif Advance analytics like Reference Lines and Bands, Trend Lines.
• Expertise in working wif data building Groups, Hierarchies and sets.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Migration of databases from SQL7.0 to MS SQL 2000 wherever required
• Published and shared views on Tableau server. Scheduled extract refresh and subscriptions
• Managed engineering systems to deliver solutions to over 50 work sites, including cell modems, GPS, VIMS, Product Link, Cat Minestar, SQL Server, Python, Javascript, FTP, SAP Business Objects, and Tableau.
• Performed Database backups (operating system, flat file backups & export/import).
• Tuned SQL statements (e.g.: - Using Indexes) and PL/SQL Procedures.
• Used Query Analyzer to optimize SQL Queries.
• Designed & created Reports using Report Builder in Developer 2000.
• Developed standards and guidelines to maintain and develop and administer teh SQL Server database.
• Also, involved in administration tasks such as creating and managing Sites, setting permissions, managing ownerships and providing access to teh users using user filters and adding them to teh specific group.
• Generated Dashboards wif Quick filters, Parameters and sets to handle views more efficiently
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.

Environment: Tableau Desktop v9, Redshift, Talend Open Studio, Cognos.

Confidential

SQL Developer

Responsibilities:

• Actively involved in Normalization of database.
• Designed DDL and DML for MS SQL Server 2000.
• Created joins and sub-queries for complex queries involving multiple tables.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Involved in merging existing databases and designed new data models to meet teh requirements and perform daily database backup & restoration and monitor teh performance of Database Server.
• Optimize query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Used Team Foundation Server as Source Control to store Packages, Reports and SQL Scripts and share it among team members.
• Worked on performance of reports using SQL Profiler
• Designed, developed and maintained relational databases.
• Developed, implemented and maintained enterprise business information systems.
• Implementing teh data model required by teh application.
• Creating schema objects and implementing rules for data integrity
• Responsible for creating SQL stored procedures, functions and triggers.
• Creating and analyzing existing high level ETL design documents and data mapping documents.

Environment: SQL Server 2008/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Office 2007/2013, Windows 8, Team Foundation Server.

Confidential

SQL BI Developer

Responsibilities:

• Analyzed updated user requirements
• Involved in gathering business requirements for teh model.
• Worked extensively on developing teh model and publishing teh package on Cognos connection.
• Created and deployed packages for reporting and ad hoc users for teh query studio.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Implemented data level, object level and package level security in Framework manager.
• Worked wif List, Cross tab, prompts and various types of graphs.
• Designed and implemented complex ETL packages.
• Responsible for transferring teh data using SSIS packages.
• Responsible for data migration in SQL Server.
• Implemented teh calculations to aggregate physical measures.
• Designed and developed teh database infrastructure.
• Created ER Diagrams (physical and logical) and mapping teh data into database objects.
• Normalized teh database into small tables by applying Normalization, defined Check constraint and applied Business Rules.
• Engaged in Publishing and scheduling teh reports.

Environment: MS SQL reporting services, MS Excel, Windows XP, Cognos 8.3, Framework Manager, Report Studio, Analysis Studio, Query Studio