SUMMARY:

• 7+ years of extensive IT experience in Software Development, Integration, Implementation and Maintenance of Business Intelligence applications.
• Extensive experience working with Tableau Software as a dashboard developer and SME.
• Extensive experience creating canned and ad - hoc reports in Tableau Desktop.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user's requirement.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Tested dashboards to ensure data quality as per the business requirements.
• Published Workbooks and Dashboards to the Tableau server.
• Hands on experience on Tableau 9.0/8.0/7.0.
• Worked extensively on joining tables, multiple data connections using blending, worked on Data Extracts and managing queries.
• Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
• Extensive Tableau Experience in Enterprise Environment and Tableau Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollover.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the assigned groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
• Good Independent / team working skills and experiences, excellent communication skills with very good customer handling capabilities.
• Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.
• Expert in Developing, Designing and supporting interactive Tableau Dashboard reports.

WORK EXPERIENCE:

Tableau Developer

Confidential - Chicago, IL

Responsibilities:

• Motorola customer repair service data was handled which includes Advance Exchange, Return Exchange, AFX models with US BULK and Non BULK data.
• Large datasets were handled in Google BigQuery to manage the data.
• Coordinated Client to understand and analyze business requirements.
• Created KPIs across channel presence, digital media reach and engagement into a single Digital IQ scorecard. Evaluated the score for each member, zone, region and nationally to gauge system performance using the Tableau.
• Created dashboards to enable a fast read on claims and key business drivers and to direct attention to key area.
• Mastered the ability to design and deploy rich visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created Complex calculated fields in getting Turn Around Time and Aging of the devices as per business requirement for the given time frame.
• Created side by side bars, Scatter Plots, Stacked Bars, Filled Maps and Symbol Maps according to deliverable specifications.
• Extensively use tableau Parameters, Data blending, Action filters, joins and Drilldowns
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Created Expression, Lookup, Filter, Router, Aggregator Transformations were implemented to load the data from source to Target using Designer.
• Developed Custom SQL scripts to view required claim data in developed dashboards
• Optimized SQL scripts to improve the efficiency on the database.
• Involved in performance tuning for tableau Dashboards.
• Developed transformation logic and designed various Complex Mappings using the Designer
• Extensively used SQL to analyze the data.
• Experienced in handling large volumes of data.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's

Environment: Tableau Desktop 8/9, Tableau server / Administrator, Informatica Power center 9.1, SQL, Unix Shell Scripting, Windows/UNIX, Google BigQuery

Tableau Developer

Confidential - Phoenix, AZ

Responsibilities:

• Involved in gathering requirements from business users and stake holders.
• Actively participated in Business Analyze sessions conducted by Stake holders to understand the business and answer business questions about capabilities of Tableau.
• Convinced business to use Tableau by exposing the capabilities of Tableau reporting.
• Built Tableau dashboards for showing insights of different portfolios dashboards and customer level detailed reports for relational managers, Directors and VP.
• Built connections to Kognitio using ODBC connections for analyzing Big data
• Expertise in setting up Tableau project from scratch.
• Mocked up sample data in excel based on user requirements parallel to pulling data into Kognitio from Big data to save time and migrated the tableau dashboards developed on mocked up excel data into real connections with less efforts and help business achieve the targeted deadlines.

Environment: Tableau 8, MS Excel, Cornerstone 2.0, Kognitio, Hadoop.

Tableau Administrator/Developer

Confidential - Indianapolis, IN

Responsibilities:

• Served as Tableau subject matter expert to assist the BI team in learning Tableau, addressing development roadblocks, and migrating reports from existing server to new Tableau enterprise server.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau Development life cycle.
• Administer and support a multi-tier Tableau Infrastructure include upgrade analysis and planning, security administration, release management, troubleshooting, performance tuning, and general system maintenance.
• Assist business users with certification trainings for self -service BI, which allows them to leverage the benefits of the tool and explore data themselves.
• Help the BI team plan/implement a Tableau community of practice by providing ideas/insights and best practices.
• Assist users with Tableau development, suggested enhancements to developed reports, and publishing reports to the server with security settings.
• Assist with Tableau server administration, security configuration including setting up AD user groups, permissions, security roles.
• Creating active directory groups, importing them to Tableau server, syncing the groups on daily basis.
• Publishing the reports on server, scheduling workbooks, data sources on server.
• Embedding reports on BI Marketplace which is a common platform to share reports to end users.

Environment: Tableau Desktop & Server 7/8, MS SQL Server, Oracle.

Tableau Developer

Confidential - Detroit, MI

Responsibilities:

• Created dashboard views from NetMining, Dealer.com and UPTRACKS.
• Woked on Inventory, Sales and Service, Advertising, Social, Website, Leads, Webiste Metrics to create the viualisation dashboards for the Dealers.
• Created KPIs across channel presence, digital media reach and engagement into a single Digital IQ scorecard. Evaluated the score for each dealer, zone, region and nationally to gauge system performance using the Tableau.
• Created Rich Graphic visualization/dashboards to enable a fast read on sales and key business drivers and to direct attention to key area
• Incorporated a regional and national comparative / benchmark metrics to give context to individual performance
• Online and offline KPIs are included for sales and inventory data through Paid Search and CRM
• Created a proof of concept for the optimal data integration process.
• Designed high-level view of the current state of dealer operation, leads, and website activity using Tableau
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's
• Created workbooks and Dashboards using calculated metrics for different visualization requirements
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.

Environment: Tableau Desktop 7, Tableau server / Administrator, tabcmd, Hadoop, HDFS, Map Reduce, Hive, Sqoop, UNIX.

ETL Developer

Confidential

Responsibilities:

• Understanding existing business model and customer's new requirements.
• Prepare ETL Design Documentation & Conducted Design walk-through sessions
• ETL performance optimization.
• Code development, UTC, testing different scenarios and documenting the result, working on defect fixes from System Testing & User Testing.
• Tested ETL code in Dev, SIT & UAT environments to ensure defect free code.
• Provided Development support for System Testing/User acceptance testing.
• Migration workbook creation and tracking the code versions Environment: Informatica, SQL, Oracle, Windows/UNIX

SQL Developer

Confidential

Responsibilities:

• Collected business requirements from different sources and wrote the technical specifications for building the Data model.
• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Transformed the Business Requirements into Functional and Non Functional Requirements and interface between the client and the development team.
• Interact with internal and external clients to understand requirements, explain issues and prioritize work.
• Created functions, stored procedures, triggers and constraints using T-SQL.
• Developed database structures and SQL queries for web applications.
• Worked with development team to improve application performance by tuning queries.
• Analyzed poorly performing SQL queries to improve application performance.
• Connected to different types of sources to extract data and destinations to load the data using Connection manager.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

Environment: SQL Server 2005/2008, SQL Developer, Windows XP, MS Access, MS Excel

TECHNICAL SKILLS

BI Tools: Tableau Desktop, Tableau Server, Tableau Public, Tableau Reader,Tableau Online, Informatica Power Centre

Database: SQL Server, Oracle 11i/11g, MS Access, Lotus notes, Kognitio

ETL Tools: Tableau Desktop, SSIS

Other Tools and packages: SQL Server Management Studio, Microsoft Visual Studio, Microsoft Office, MS Visio, SQL Developer

Languages: SQL, T-SQL, C, C++, Java, HTML, XML, Java Script,J2EE

Reporting Tools: Tableau, SSRS

OLAP Tools: SSAS

Operating Systems: Windows 2000/2003,2008 Server, Windows 95/98/2000/XP/7/8/10