SUMMARY

• Over 7+ years of experience in IT industry as BI Developer, Tools including Tableau, with strong background in Databases and Data warehousing concepts.
• Involved in SDLC of Reporting Projects, includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollover experience. Hands on experience in Microsoft SQL Server 2000/2005/2008/2012 .
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Experience in Installation, Configuration and administrationof Tableau Server in amulti - serverandmulti-tierenvironment.
• Expertise in Business Intelligence Solutions like ETL & Reporting using, SSRS, SSIS, SSMS and T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Experience with creating the Tableau dashboards with relational and multi-dimensional databases including SQL, MS Access at gathering and manipulating data from various sources.
• Hands on experience with concepts like Blending, Groups, Hierarchies, Sets, Filters, Actions, Bins, Parameters, Calculated Field, Dual Axis.
• Introduced Tableau to Client’s to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user and help them make effective business decisions.
• Created Dashboard’s using multiple BI Tools with Drill-Down capabilities using Dashboard prompts, Local and Global Filters. Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications
• Proficient in creating Calculations (Table Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Excellent understanding of concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Teradata, MS Access and client/server applications.
• Having 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.
• Experience in Insurance, Educational, Banking and Financial Service Domains and ability to analyze big data.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS. Expertise in Error Handling and Debugging issues and troubleshoot production environment issues Event Handler, and Custom Logging in SSRS Packages.
• Good knowledge on Data Quality Assessment & Data Cleaner Tool, Data Model Creation. Written SQL queries to test the OLTP & OLAP Databases based on changes of functionality.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production. Improved Reports performance in tableau using extracts and context filters
• Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
• Experience in working with Talend Open Studio for Big Data which helps in simplifying the Loading, Extraction and Transformation of data.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.

TECHNICAL SKILLS

Reporting Tools: SSRS,SSIS, Crystal Reports 2008/XI, Tableau Desktop v6.x/v7.x/v8.x, Tableau Server v6.x/v7.x/v8.x

Database: Teradata, MS SQL Server 2000/2005/2008/2012, Oracle, DB2, TERADATA V12, MS ACCESS

ETL tools: Talend, Microsoft SQL Server Integrated Services.

Data Modeling Tools: Star Schema, Snowflake Schema, OLAP, OLTP.

Tools: TOAD, WinSQL, MS Office (Word, Excel, PowerPoint, Visio, Project), Rational Rose.

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle.

PROFESSIONAL EXPERIENCE

Confidential, Mooresville, NC

Senior Tableau Developer

Responsibilities:

• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Gathered reports requirement and collaborated with users, asking users exactly what they are looking for and communicated with technical and non-technical users.
• Worked with Data cleansing for Analysis and Visualization since we are getting lots of data we need to work on it and get what we need, worked with different Data cleansing tools.
• Created POC Dashboard and generated some interactive Dashboards. ConfiguredInteractive Dashboardwithdrill-downcapabilities usingglobalandlocal Filters.
• Created histograms, pie charts, box plots, scatter plots for inventory management, background maps illustrating the total value change with respect to several weeks ago data.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online. Generated tableau dashboards with combination charts for clear understanding.
• Creating data blending in case of merging two different datasets using tableau.
• Developed automated dashboard with Trend Lines, Reference Lines and statistical techniques to describe the data, created calculations like string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements andquick table calculations.
• Validated the created Dashboard with comparing of data in Dashboard with the data what we have. Making then Dashboard more interactive for users with good look and feel environment.
• Migrated from tableau 8.2 to 8.3 and explained the new features and advantages to the team members, and stared working on latest version.
• Published Workbooks by creating user filters so that only appropriate teams could view it.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Created SSRS reports such as tablix reports, sub reports drilldown reports and parameterized reports based on business requirements.
• Designed various packages using various task e.g. For Each Loop, File System Task, Execute SQL task, Execute Process Task, Execute Package Task, Send Mail Task in control flow.
• Trained end users on working with tableau how to pass the values in parameters, How tableau can be used for effective visualization of data.

Environment: MS SQL Server 2012/2008/2005, T-SQL, SSRS, SSIS Packages, ETL, ODBC, Excel, OLAP, OLTP, Access, Windows 2003 Server, Tableau desktop (8,8.1 and 8.3), Tableau server, Tableau reader.

Confidential, NJ

Tableau BI Developer

Responsibilities:

• Understanding the functional and technical specification, collected the requirements from the users and preparing the specifications and developing the Dashboard as per the functional requirements.
• Experience in designing and development of Tableau visualization solutions and regular involving in calls with customer and discussing about status and newrequirements of the project.
• Experience on working with Tableau Server and done with live connection of data.
• Created Blending of data form two different tables and Grouping of tables inside tableau.
• Created Hierarchies (Natural hierarchies and Un-natural), Sets (Computed, Static, Combined) and worked on the custom date time calculations and macros in the reports.
• Experience inTableau Desktop for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Deep experience with the design and development of Tableauvisualizationsolutions, Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards, Defined best practices for Tableau report development.
• Experience in usingTableau functionalitiesfor creating different Requests, Filters, Charts, Interactive dashboards with Page and dashboard Prompts.
• Experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Worked with Talend which involves in Data Integration like Big data, where we can do all the data extraction, cleansing, transformation and we can load the required data in to the tableau and we can visualize data.
• CreatedSQL Queries, Dynamic-queries, sub-queries and complex joinsfor generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Environment: Tableau Desktop 7.0, 8.0, 8.1, Tableauserver / Administrator, SQL developer, SQL 2008, SQL, PL/SQL, T-SQL, MS Access, Windows 2007 server, Teradata, MS Office 2007, Business Objects 4.0.

Confidential, Detroit MI

Tableau Developer

Responsibilities:

• Interacted with business users for gathering requirements for creating end user Dashboards, Participated in client calls and team meetings, explaining the users what tableau can do with data and what are the limitations with it.
• Regularly be in touch with the end users through emails and phones, monitoring the database side where we are getting data to be visualized whether the data which we are getting is clean or not.
• Upgraded tableau 7.0 to tableau 8.0. And understood what the new features are and explained to the users how those features will helpful in creating a dashboard.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for Amazon.
• Involved in created stored procedures, views, and custom SQL. Queries to import data from SQL server to tableau.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Analyzed data using MS Excel, pivot tables, charts and VBA.
• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
• Ability to work quickly and under tight delivery deadlines with focus on details.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
• Having experience in SME (Subject Matter Expert) in all BI tools.

Environment: Tableau Desktop 8.0/7.0, Tableau server / Administrator, SQL developer, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007, Business objects, SQL, PL/SQL, T-SQL.

Confidential, San Francisco, CA

SQL/BI DEVELOPER

Responsibilities:

• Extracted the data from various data sources such as databases, CSV files, and Excel documents transforming the data into standard format and load the data so that it is available for analyzing and creating reports.
• Interaction with clients forBusiness Requirementsduring design & implementation phases.
• Migrated databases fromSQL Server 2005& various other sources into SQL Server 2008.
• All data were migrated to the staging server and then that data were later populated to the OLAP (Online Analytical Processing) Server.
• Designed Schema using dimensions, fact, logical, physical, alias and extension tables.
• Performed data analysis after conversion using procedures or functions in PL/SQL.
• Design, develop & test theETLprocesses according to industries best practices usingSSIS.
• Used SQL Developer for developing and managing PL/SQL scripts.
• Designed user interface and prepared layouts for the system using SQL.
• Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Involved in the developing of star schema and snow flex schema dimensional data model.
• Used SQL profiler for performance tuning & debugging issue whenever necessary.
• Involved in Database design, creation and maintenance of Databases, Created tables and views.

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

Confidential, Bloomington, IL

Business Analyst / SQL Server

Responsibilities:

• Conducted meetings with SMEs, Portfolio Managers and Client Relationship Executives to lay a chart for requirements.
• Designed, developed, modified and enhanced the database structures and database objects.
• Perform Source system data analysis in order to manage source to target data mapping. Perform migration and testing of static data and transaction data from one core system to another.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved in SQL ServerConfiguration, Administration, ImplementationandTrouble-shootingfor Business work.
• Involved inInstallation, Configuration and DeploymentofSSRSReports using differenttopologies.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Performed Regular Database Maintenance process, checking the diskDefragprocedures in different environments.
• UsedSQL Profilerfor Performance monitor to resolveDead Locksand long running queries by checking appropriate changes to Transaction Isolation levels.
• Database Performance of Index tuning with usingDatabase Engine Tuning Advisorto resolve Performance issues.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Planned, Configured, Installed, Maintained SQL Server in environment ofMulti-node ClusterwithMulch-instances, Configured and MonitoredDatabase Mirroringfor Application Development environment.

Environment: MS SQL Server 2008/2005, Windows XP Server,MS Access, MS SQL Server Integration Services 2005, Windows 2003 server.

Confidential

DATA ANALYST

Responsibilities:

• Used PL/SQL for creating database objects, running the command scripts for inserting the configuration data items.
• Designed Web-based Internet applications linked to firm-wide SQL databases.
• Creating and debugging of packages and procedures and functions and troubleshoot jobs using the debugging tool.
• Designed tables, indexes and constraints to maintain data integrity and also ensured efficiency in data retrieval/manipulation.
• Worked on migration of SQL Server 2005 instances to SQL Server 2008, installed all software upgrades for SQL Server 2008.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS.
• Planned the complete back-up of various databases for disaster recovery scenarios, Working with Multiple data Connections
• Built complex multi-sectional reports with charts and drill-down capabilities, Scheduled cube processing from staging database tables using SQL Server Agent.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.

Environment: PL/SQL, SQL* Loader, MS Excel, MS SQL Server 2005/2008,T-SQL, Windows 97/2000/XP, Toad.