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.
• Experience in working with other BI tools such as IBM Cognos BI, SSRS.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Successfully upgraded Tableau platforms and ensured functionality is working during upgrades.
• 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 AdHoc reporting needs.
• Expert in creating semantic layer in tableau desktop and often used data blending to connect to different databases.
• Proficient in designing techniques like Snowflake schema, Star schema, fact and dimension tables, logical and physical modeling
• Solid understand of SQL and have worked with various data source types like Oracle, SQL server, Microsoft Access databases, and Excel Spreadsheet.
• Expert in Strong understanding of dimensional data modeling, SQL optimization capabilities, Metadata Management.
• Experience in configuring reports from different data sources using data blending.
• Hands on experience with IBM Cognos 8.4 Report Studio, Query Studio, Analysis Studio, Framework Manager and Power Play Transformer.
• Experience in creating interactive dashboards and writing complex reports, involvingdrill-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.
• Experience in Software Development Life Cycle (SDLC) that includes providing documentation on design, testing and migration from development to production.

TECHNICAL SKILLS:

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

Data Warehousing / BI Tools: IBM Cognos BI 8.4 Report Studio, Framework Manager, Cognos7 Transformer, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Management Studio(SSMS)

Databases: Oracle 11g/10g/9i, MS SQL Server 2005/2008/2012, IBM DB2, MS Access 2010.

Languages: PL/SQL, SQL, HTML, Java

Environment: Windows XP/ 2000/2003/2008/2012, Unix.

PROFESSIONAL EXPERIENCE:

Confidential, Boston MA

Tableau Developer

Responsibilities:

• Involved in creating Static and Interactive dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Extensively used dashboard actions (filter, highlight and URL) to additional different granularity in the dashboard.
• Developed story telling dashboards inTableauDesktop 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 change to ensure that the views and dashboards were displaying the changed data accurately.
• Developed dashboards with the data security to restrict data to the different level of users based on their roles.
• Created calculated fields, mapping and hierarchies, groups, sets and LOD expressions.
• Created dual-axis charts with multiple measures to provide more meaningful insights to business.
• Performed end-to-end Data Analysis and ensured the data quality gaps are identified and reported to management.
• Brainstorm ideas onwhattoinclude in views/dashboards from the data sourceand document on the fly business requirements.
• Use SSIS to extract, transform and load data directly from different source systems that includes flat files, Excel, Oracle and SQL Server.
• Work on generating various dashboards using different data sources such as Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Extensively used data blending in Tableau for connecting different databases.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau server.
• Worked with user groups in creating and modifying dashboards or worksheets in desktop and server.
• Created report schedules, data connections, projects, groups in Tableau server.
• Documented solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Desktop/Server 8.1/8.4/9.1, Excel, SQL Server 2008/2012 and Oracle 10g.

Confidential, New Brunswick, NJ

Tableau Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advanced chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Trained endclient users onTableauDesktop by providing step-by-step guidancefrom basics to advanced functions in Tableauincludingworking with calculations,parameters, and date functions.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Created and modified Interactive Dashboards and guided navigation links within Interactive Dashboards.
• Published the developed dashboard, reports on the Tableau Server for end user consumption.
• Scheduled extracts on tableau server after the completion of data load into the warehouse.
• Responsible to facilitate load testing and benchmarking the developed product to meet SLA.
• Created Test Cases and documented the Test Results and shared with project team.
• Involved in validating Tableau reports, Dashboard by writing SQL against databases.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau Desktop/Server 8.0/8.2/8.4, Oracle 10g, MS SQL Server 2008, Windows Server 2012, MS Excel/Access 2007

Confidential, Miami, FL

Tableau Developer

Responsibilities:

• Designed and developed Business Intelligence end to end solutions using Tableau desktop.
• Created reports for users using Tableau Desktop by connecting to multiple data sources (Flat files, MS Excel, .CSV, SQL Server, Oracle).
• Setting-up LAN connections and users to share tableau dashboards.
• Developed an ad-hoc Tableau reports based on agile business requirements.
• Developed Dashboards using quick filters, context filters, global filters, parameters and calculated fields on Tableau reports.
• Worked on groups, sets, parameters, different calculation functions including Table calculations.
• Worked on various reports using best practices and different visualizations like Bars, Trends, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Involved in data analysis, reviewing business requirements and publishing the same to business.
• Reviewed basic SQL queries and altered for better performance inTableauDesktop.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Tableau Desktop 6.0/7.0, Excel and SQL 2008, IBM DB2

Confidential, Chicago, IL

Tableau/Cognos Developer

Responsibilities:

• Worked extensively with Business groups and developed technical specifications for tableau dashboards.
• Created different visualizations inTableauDesktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Worked on estimates of report development and provided the same to client.
• Designed Framework manager metadata for reporting and adhoc reporting.
• Implemented star schema grouping for multi Fact, Conformed dimension.
• Used advanced functionalities like parameter map, macros to create dynamic reports.
• Designed best practices for report development and also documented steps for performance running of cognos reports.
• Requirement gathering and design and review of cognos Power cube.
• Setting up oracle 11g data source and configuring oracle client for client Framework manager.
• User and presentation of Framework manager project and report studio design techniques.
• Scheduled reports using cognos connection and through cognos triggers.
• Production support activities including handling issues, troubleshooting them and report to management.

Environment: Tableau Desktop 7.1, Cognos BI 8.4 (Framework Manager, Report Studio, Cognos Analysis Studio, Cognos Power Play Transformer), IBM DB2.

Confidential

Tableau/Cognos BI Developer

Responsibilities:

• Developed List, Chart, Cross tab and bursting reports in Report Studio and included advanced report functionalities such as Detail and Summery Filters, Conditional Formatting, Master - Detail relationships, Drill up and Drill Down, Drill Through functionality and advanced calculations.
• Customized prompt parameters and used Cascading prompts and Filters to create efficient, data specific reports according to user requirements.
• Assisted the Cognos architect in building conformed dimensions and facts for dimensional modeling using star schema methodology and worked closely with information architect and database administration to ensure optimum performance of the BI reporting system
• Worked on Production Support and fixing report/package/data issues.
• Created and performed the Unit and Integrity test cases and assisted the testing team in system testing and Production move process.
• Managed performance and tuned SQL queries and fixed the slow running queries in production.
• Created User Acceptance Test Documents (UAT) for the reports and conducted user acceptance tests.
• Involved with the QA team to create and/or validate system acceptance and user acceptance test cases and test scripts to ensure error free delivery reports.
• Prepared user documentation to train users and functionality of each report.
• Created project documentation and provided support for report users and participate in on-call rotation for Cognos related issues
• Maintained documents to track the report development status for the team and attend meetings with client to update the status and communicate the issues that needs to be addressed.

Environment: Cognos BI 8.4 (Framework Manager, Report Studio), SQL Server 2008, MS Excel/Access 2007