PROFESSIONAL SUMMARY:

• Qualified professional with extensive IT experience in System Analysis & Design, Development, testing and implementation of Data Warehousing and Business Intelligence applications in various domain such as Utility, Insurance and Banking industries.
• Expert in Tableau Desktop, Tableau Reader and Tableau Server and Experience including analysis, modeling, design, and development of Tableau reports and dashboards for analytics
• Experience in Data Analysis, Data Visualization and Business Intelligence in DWH in Client Server Technologies, Web - based Applications and Databases.
• Detailed working experience in gathering and writing detailed business requirement and translating them into technical specifications/ System Requirement Specifications (SRS) and design identifying interface and business process specifications.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS)
• Outstanding experience working with different databases such as Oracle, SQL Server, MySQL IBM DB2 wrote complex SQL queries, Stored Procedures, database tuning, query optimization and resolving key performance issues.
• Extensive experience in using Tableau functionalities for creating different Reports, Interactive Dashboards with page and dashboard Prompts.
• Strong experience in creating Logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data.
• Expertise in creating Dashboards, stories and developing different charts styles including Bar Charts, Line Charts, Tree Maps, Gantts, Circle views, Scatter Plots, Bullet Graphs, Histograms, Heat Maps, Geo Maps, Text Graphs.
• Expertise in creating different types reports such as Tabular, Matrix, Drill-Down, Drill through, Ad hoc, Cascaded parameterized, Chart report, Sub reports, Cross Tab Reports and Distributed Reports in multiple formats using Tableau, SQL Server Reporting Services (SSRS), Power BI
• Developed reports using Advance Analytics like Lines, Bands, Trend Lines, Box plots and Custom Geocoding.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies

TECHNICAL SKILLS:

Tableau Desktop 8 /9/10, Tableau Server, Tableau Online, Tableau Public, Tableau Reader, Power BI, Microsoft SQL Server 2012/2008-R2/2008, MS, T-SQL, PL-SQL, MySQL, Microsoft Visual Studio 2010/2008, Microsoft Access,, Microsoft Office (MS-Word/Excel/PowerPoint), MS Access, Windows, IIS, UNIX, MS SQL Profiler, Visual Basic 6.0, HTML

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Tableau Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Utilized advance features of Tableau software to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Used Web Data Connector to handle huge databases stored in Web APIs.
• Involved in new KPI generation for Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• Identify new metrics and enhance the existing KPI's.
• Dashboard Visualization through Tableau BI application.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, data blending, Hierarchies, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports to tableau reports.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Scheduled frequency and time to refresh data for the when sources are published or extracted to server.

Environment: Tableau (Desktop, Server)9.x,10.x, Microsoft SQL Server 2010, Power BI, SharePoint, Windows, ETL, SQL, PL/SQL, MS Project, MS Office Suite (Word, Excel, PowerPoint)

Confidential

Tableau Developer

Responsibilities:

• Understanding business requirements documents and developing design documents.
• Defined data source and data source views for each report as per client requirement.
• Created Tableau scorecards, dashboards using stack bars, bar graphs and geographical maps
• Created Bar Charts which is complied with data sets and added lines and forecasting.
• Created Crosstab reports to display underlying data based on various graphs and charts created for further data analysis.
• Created context filters to limit data sourced into tableau engine.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server,
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Prepared dashboards using calculated fields for different logics for trends, p arameters, calculations, groups, sets and hierarchies in Tableau.
• Ensured the user security for the views using User filters and shared with business users.
• Published the developed dashboards into production and refreshed the scheduled extract, tuned the performance of the dashboard and created tableau functional design document.
• 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 9.0 & 9.3, Server), IBM DB2 9.7, Power BI, SQL server 2012, SQL, PL/SQL, MS Office Suite (Word, Excel, PowerPoint), MS Access.

Confidential, Belleville, IL

Tableau Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Involved in new KPI generation for Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• Identify new metrics and enhance the existing KPI's.
• Dashboard Visualization through Tableau BI application.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, data blending, Hierarchies, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Analyzed various reports, dashboards, scorecards in MicroStrategy and created the same using Tableau desktop server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports to tableau reports.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are published or extracted to server.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in Ipads, iPhones, and other smart mobile phones.

Environment: Tableau (Desktop, Server), Teradata, Sharepoint, Windows, ETL, SQL, PL/SQL, MS Project, MS Office Suite (Word, Excel, PowerPoint)

Confidential, Bridgewater, NJ

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.
• Data blending implemented on EMPI databases and generated interactive dashboards.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Involved Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Creating users, groups, projects, Data connections, settings as a tableau administrator
• Analyzed the source data and handled efficiently by modifying the data types.
• 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.
• Generated tableau dashboards for sales with forecast and lines.
• Generated tableau dashboards with combination charts for clear understanding.
• Administrate Tableau Server, data content and report distribution

Environment: Tableau (Desktop, Server), SQL Server 2012, MS Office

Confidential

SQL Server SSRS Developer

Responsibilities:

• Performed Report Testing and Verification as per Internal Reporting system requirements.
• Created calculated member for complex calculation in reports using Business Intelligence.
• Created matrix reports and table formatted reports.
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drill down Reports.
• Experience in writing custom code expressions in SSRS.
• Used conditional formatting to change the behavior of the report depending upon the requirement.
• Work closely with management and end-users to create and evaluate business requirements.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level
• Managed off shore team in Report migration project.
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids.
• Involved in deploying the changes to QA, Staging and Prod environments.
• Involved in Product Releases and support calls.
• Created Report Models for Business Users to create their own reports.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
• Monitoring nightly ETL process from various highly different source systems. Sources included SQL based databases and Excel Files. Also ensured that nightly backup jobs or other ETL jobs didn’t interfere with each other.

Environment: SQL Server 2005/2008, Windows, T-SQL, SSRS, Share Point 2010, BIDS