SUMMARY

• Over 8 years of experience in full life cycle of Business Intelligence from Design to implementation to support for Banking/Finance and Sales/Retail business sectors.
• Comprehensive experience in Tableau Desktop (4+ years) and Tableau Server on various versions of Tableau 8,9.
• Involved in Requirements gathering, analysis, Design, Development, Testing and Production rollover of various Reporting and Analysis projects
• Good Knowledge on tableau Aggregation, Hierarchies, Sorting, Data Blending, Dual Axis and Grouping in Tableau.
• Experience in creation of various type of charts like Network graphs, Lollipop charts, Pareto charts, Gantt charts, Bullet charts, Heat map, Tree map, Box and whisker plot, Scatter plot, Pie chart, Donut chart, Word cloud and building dashboards using Tableau
• Good knowledge on working with Table calculations and Statistical Calculations in Tableau.
• Sound Knowledge on Filters, Creating Map’s and custom Geocoding in Tableau.
• Develop custom interactive reports with Tableau Scripting using Various functions and calculated Fields .
• Experience in Installation, Configuration and administrationof Tableau Server in amulti - server environment.
• Well versed with Tableau Administration Tool for Configuration, managing users and groups, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Involved in upgrading Tableauplatforms and performing content upgrades.
• Experience on Database Modelling and Design of the RDMS (Relational Databases) Systems.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Import Data from multiple RDMS systems such as Teradata, Oracle, Netteza,SQL to Tableau Extracts.
• /Proficient in designing Data Mart and Data Warehouse using Erwin Star and Snowflake Schemas.
• Sound experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Strong Experience in creating Ad Hoc parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS.
• Well versed in using multi-dimensional expression (MDX) queries, mathematical formulas, and user-defined functions for developing reports from Multi-Dimensional OLAP Cubes.
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
• Working knowledge on reporting using QlikView
• Thorough Knowledge on Windows Server 2008 R2/2012/ -- Cluster Management, Active Directory and Network Management across these boxes .

TECHNICAL SKILLS

Specialties: Data Visualization/preparation/Framework, Interactive dashboard development, Simplified data Analysis, Business Intelligence (BI), Software Management and SDLC, ETL, Data Extraction, Data Collection, Database design and modeling, Master Data Management, Data Mart.

Data Visualization: Tableau 9,8.3,8.1,7,Qlikview, PowerPivot, Business Objects XI/4.0,Excel, SSAS,SSRS, Visual Analytics, Crystal reports XI/2008.

Relational Databases: MS SQL Server 2005/2008/2012 , Oracle 8i/9i/10g/11g, MS Access, Teradata, Netezza.

Tools: and Packages: SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio, Crystal Reports

Languages: SQL, Tableau Scripting, PL/SQL, C, C#, Macro,ASP.Net, HTML, XML, XSL

Operating Systems: Windows 2008, Windows 2000/2003 Server, Data center, Windows NT, Windows 95/98/2000 XP, UNIX, LINUX.

Configuration Management Tools: Team Foundation Server, Visual Source Safe, Clear Case

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

Sr.Tableau Developer

Responsibilities:

• Developed dashboards, reports as per the requirements with appropriate guided navigation connecting to the newly developed data warehouse .
• Worked on design and development of Tableau visualization solution.
• Created very complex Dashboards in Tableau 9.3 using the drill down, drill across for business Steering committee.
• Comparison of YOY, MOM, Actual/Planned Budgets for production data and as well as Maintenance Data .
• Developed a Pareto Analysis to Compare the % Sales by % Customers .
• Target Visualization solutions such as Pareto Chart, Bar, Pie, Plot etc were developed .
• Use of Advanced calculated fields for Conditional Filtering of data through Parameters .
• Extensive use of functions and Calculated fields to achieve the target visualizations .
• Involved in requirements gathering, analysis, design, development of the New Database Structure for the data mart.
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Developed E-R diagrams (logical and physical using Erwin) mapping the data into database objects.
• Performed Tableau admin duties that comprised configuration,adding users,groups,managing licenses and data connections,scheduling tasks embedding views in the tableau server.
• 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 dashboard reports.
• Worked on SQL tuning and Optimization of reports.
• Created Unit test cases and documented the Unit test results.

Environment: Tableau Desktop, Tableau Server 9, SQL Server 2012/2008R2/2008, Server Integration Services 2012, SQL Server Management Studio, T-SQL, ERWIN 7.2, .NET

Confidential, Rocklin,CA

Sr. Tableau Developer

Responsibilities:

• Involved in plan and design of data based on business requirement and provided documentation for further reference.
• Developed interactive data visualizations and built automated processes for updating content used in standardized dashboards.
• Worked on creating workbooks by extracting data from different sources and created dashboard using parameters, sets, groups and calculations in Tableau Desktop
• Applied actions at the Dashboard to Connect to URLs via Visualizations and As well target the actions within the visualizations.
• Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
• Implemented data blending to blend related data from two different data sources.
• Implemented Dual Axis Funnel Visualizations and Pareto Charts .
• Performed Tableau type conversion functions when connected to relational data sources.
• Involved in installation and configuration of Tableau Server.
• Implemented incremental refreshes for data sources on Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau
• Generated insights out of voluminous and complex datasets and built story lines.
• Used Tabcmd and Tabadmin commands in creating backups and restoring backups of Tableau repository
• Configured Cache settings, which improved the performance of the reports and Dashboards.
• Involved in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Developed story telling dashboards and published them on toTableauServer, which allowed end users to understand the data on the fly with the usage of quick filters for on demand, needed information.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Involved in reviewing business requirements andanalyzingdata sources from Excel/Oracle /SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views to publish to internal team for review and further data analysisand customization using filters and actions.
• Blendeddata frommultiple databases into one report by selecting primary keysfrom each databasefor data validation.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.

Environment: Tableau Desktop, Tableau Server 8/7 SQL Server 2012/2008R2/2008, Server Integration Services 2008, SQL server Reporting Service 2008, SQL Server Management Studio, T-SQL, ERWIN 7.2, .NET

Confidential, Raliegh NC

Tableau Developer

Responsibilities:

• Design and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Performed trouble shooting and performance tuning of reports and resolving issues within tableau server and reports.
• Developed Tableau dashboards deploying various kinds of visualizations such as bar graphs, stack bars, bar graphs, scattered plots, geographical maps, Gantt charts.
• Worked extensively with Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes, Group, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Participated in weekly meetings reviews and user group meetings as well as communicating with stakeholders and business groups.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

Environment: Tableau Desktop 8.1,7 SQL Server 2008/2005, Server Integration Services 2008, SQL server Reporting Service 2008/2005, SQL Server Management Studio, Oracle 10g/11g, Exadata, z-LINUX, Toad.

Confidential, NYC,NY

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Involved in all phases of SDLC, and gathered business requirements from business people.
• Design/develop database using SQL SERVER 2000/2005.
• Created SSIS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files and Oracle databases.
• Designed and Developed Complex SSIS packages for auditing Interfaces using SQL SERVER 2005 Integration Services.
• Developed SSIS Packages using xml, ADO.NET, OLEDB, file system, Active X script, Look up tasks.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Developed custom Reports, Ad-hoc reports by using SQL Server Reporting Services (SSRS).
• Developed Tabular, Drill Down, Parameterized, Cascaded and sub-reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements using SSRS 2005.
• Created Parameterized Reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Deployed SSRS Reports in SharePoint Environment.
• Created OLAP Cubes and Dimensions using SSAS in data warehouse environment.
• Creating complex T-SQL Stored Procedures, Functions, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.
• Scheduled Complex Stored Procedures using SQL Server Agent.
• Monitored and modified Performance using execution plans and Index tuning.
• Optimized Database Performance and Performed Maintenance duties such as tuning, backup and restoration.

Environment: MS SQL Server Management Studio 2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS),MS SQL Server Reporting Services (SSRS),SQL Server Analysis Services (SSAS), SharePoint Moss 2007, Windows XP

Confidential, SFO, CA

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Involved in gathering user requirements, application design, and analysis of Software/hardware requirements to meet business needs.
• Developed stored procedures, triggers, functions, views and creating constraints to maintain referential integrity, unique constraints and check constraints as per applications requirements.
• Altering\performance tuning TSQL code, stored procedures to implement the complex business needs for generating new customer number, updating user profiles, transaction processing, generating messages with code encryption.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Migrated DTS packages to SSIS packages and modified the packages with new features of SQL 2005 SSIS.
• Analyzing and optimizing T-SQL code for SQL Server Applications by checking execution plans, query metrics and SQL Profiler.
• Data modeling, normalization/de-normalization and physical database design for database server applications.
• Provided production support for the ETL jobs and also to the code deployment into the production environment.
• Developed and deployed web based reports, tabular reports, ad-hoc reports, parameterized reports, Custom Reporting using SSRS for daily reports to the client and senior management.
• Scheduled SSIS packages and SQL tasks for daily\weekly\monthly run using SQL Server Agent.
• Configured snapshot\transactional replication to replicate data from production server to reporting server.

Environment: SQL Server 2000/2005/2008 R2, T-SQL, SSIS, SSRS, SQL Profiler, SSMS, Performance Monitor, Replication, SQL AGENT.

Confidential

SQL Server Developer

Responsibilities:

• Developed physical data models and created DDL scripts to create database schema and database objects
• Designed data models using Erwin.
• Wrote user requirement documents based on functional specification.
• Experienced with source to target specifications for Data Transformation Services.
• Developed functions, views and triggers for automation
• Wrote stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, Constraints and rules on database objects for optimization.

Environment: MS SQL Server 2000, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer, Oracle Hyperion EssBase