PROFESSIONAL SUMMARY:

• 7+ Years of BI experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse/ Data Marts and Business Intelligence.
• 5+ years of extensive Tableau Experience in Enterprise Environment that includes 7/8/9 versions as a developer and Administrator.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Bubble Charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts
• Designed tableau dashboards using Hierarchies, filters, calculated fields, Sets, Groups, and Parameters etc.
• Implemented Tableau security at the Data (Data security) and object (Roles and Permissions) level.
• Improved Reports performance in tableau dashboards using extracts and context filters.
• Trained business users on tableau usage and functionality for ad hoc reporting needs.
• Expert in creating semantic layer in tableau desktop and often used data blending to connect to different databases.
• Solid understand of SQL and have worked with various data source types like Oracle.
• Expert in Strong understanding of dimensional data modeling, SQL optimization capabilities, Metadata Management.
• Experience in configuring reports from different data sources using data blending.
• Experience in creating interactive dashboards and writing complex reports, involving drill-Through, cascading prompts, discontinuous cross-tabs, summary reports, burst reports and advanced customization using Report Studio.
• Experience in production support and troubleshooting reports, packages and cubes.

TECHNICAL SKILLS:

Visualization Tools: Tableau Desktop 8.2/8.1/7, Tableau Server 8.2/7,Tableau Reader

ETL: Informatica Power Center 9.x,8.x and 7.x,Talend

Tools: SQL Developer, OBIEE, TOAD, PL/SQL Developer And MS Visio, MS Word, Erwin Methodologies Waterfall, RAD, Agile Scrum

Databases: Oracle 11g/10g/9i/8i,Hive,Big Data, Teradata

Environment: Windows XP/2000/2003/NT 4.0/Vista, UNIX, Sun Solaris, Linux and MS-Dos.

WORK EXPERIENCE:

Tableau Developer

Confidential, Dearborn, MI

Responsibilities:

• Going through Report Specification Documents and Understanding the User requirements.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Created of dashboards for business groups like finance and sale.
• Designed and publishing visually rich and intuitive Tableau dashboards for decision making
• Created Sets, Groups and Data Bins as per user requirements.
• Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.
• Provided visual/graphic analysis based on data content.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Used Trend Lines, Reference Lines and Annotations to describe the data.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Created and Published Tableau Dashboards into Tableau Server.

Environment: Tableau Desktop 8.1-8.2, Tableau server / Administrator, SSIS, SSRS, SQL developer, SQL2008, Oracle 10g, PL/SQL, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007, Business objects 4.0,R programming.

Tableau Developer

Confidential, Edison, NJ

Responsibilities:

• Develop data visualizations and interacting with Business users to understand and analyze their requirements.
• Created dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculated fields.
• Involved in creating a dual-axis bar chart with multiple measures and also created bins for different measures.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Implemented data blending in order to merge data from different sources.
• Used and applied actions like filter, highlight and URL to dashboards.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, SQL Server and Oracle.
• Performed Tableau type conversion functions when connected to relational data sources.
• Experience in creating different Tableau workbooks, dashboards including Bars, Histograms, Pie charts, Maps, Scatter plots, Gantts, Bubbles and Highlight tables.
• Creating Users, User Groups and Projects through Tableau server Web and assigned roles and permissions for Tableau users.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting for future predictions.
• Reviewed basic SQL queries and edited inner, left and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

Environment: Tableau Desktop 8.0, Tableau Reader, Tableau Server 7/8, MS SQL Server 2012, TSQL,MS Excel, SQL Server Management Studio, Share Point, MS Office 2010/2013,Talend.

Tableau Developer

Confidential, Mount Laurel, NJ

Responsibilities:

• Built Strategic, Analytical and operational dashboards using Tableau.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Analyzed customers credit and transaction histories, stated preferences, and current interactions enabled tableau to identify opportunities for improved promotions, special offers, recommendations, and targeted advertising.
• Migration of Tableau reports from Dev• QA •Prod.
• Implementing best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.
• Developed Ad-hoc Business object reports according to user's requests.
• 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.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Compared the visualized the quarterly weekly sales with previous weeks and quarters. This gave a perspective on the situation using concrete numbers.
• Developed Trend Lines, Statistics, and Log Axes, Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server 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 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.
• Used the automatic forecasting as a baseline to estimate progress toward making quota.
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.

Environment: Tableau7.0/8.0, Tableau server, Crystal Reports, Talend, MS Excel, SQL Server, HANA DB.

Tableau/SQL Developer

Confidential, Hartford, CT

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical &functional specifications.
• Developed and supported the Extraction, Transformation, and load process (ETL) for data migration using Informatica power center.
• Used Trend Lines, Reference Lines and Annotations to describe the data.
• Developed, deployed and monitored SSIS Packages. Involved in creating log files for SSIS packages.
• Created and Published Tableau Dashboards into Tableau Server.
• Enabled Check points in SSIS package. Created break points in order to view the status of data, variables and over all status of SSIS package.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Oracle 9i database for creating BI layer on DW for tableau reporting.
• Extensively used Rational Clear Case and Clear Quest to version all BRSs during development, testing, and promotion to production as a part of content management process.

Environment: Oracle 9i, Tableau Desktop, Windows 2003/ XP, SQL developer, SQL 2008, Microsoft Excel 2007, Microsoft office 2007.

SQL BI Developer

Confidential

Responsibilities:

• Successfully installed and configured the MS SQL 2008.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to centralized
• SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Implemented OLAP Cubes for providing summarized and aggregate views of large sets of data using SSAS.
• Implementing Facts and dimensions for providing views of large sets of data.
• Created drill down and sub reports from SSAS cubes that can be browsed on web.
• Developed report specifications, created and modified reports using SSRS 2008.
• Scheduled reports and exported in PDF, Word and Excel format.
• Created OLAP Cubes from the integrated data and generated reports on those cubes.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports.
• Worked on the dirty source data that resulted in errors.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Wrote Parameterized Queries for generating Tabular reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2005.

Environment: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services2008, Visual Studio 2008, Agile Methodologies, Visio, Enterprise Manager, Crystal Reports 10, SQL Server Management Studio (SSMS)

SQL Server Developer

Confidential

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Designed and implemented the Logical and Physical model of the database using Visio
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Worked in SQL server agent for job scheduling and batch queries.
• Installed and maintained MS SQL Server 2005
• Written SQL queries and stored procedures to generate data for reports.
• Involved in testing the triggers and procedures to be used in the production for optimization and improving the performance.

Environment: SQL Server 2005, Management Studio, Windows XP, Oracle 10g, Excel, PL/SQL Developer 1.1.3, UNIX.