SUMMARY:

• 9+ 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.
• 6 years of extensive Tableau Experience in Enterprise Environment that includes 8/9/10 versions as a developer and Administrator
• Generating Ad - hoc visualizations reports as per management requests from live environment for on spot validations.
• Experience creating Tableau dashboards with relational and multi-dimensional databases including SQL and MS Access.
• Expertise in analysis, design and implementation of data warehousing applications using Teradata, Informatica, UNIX, DB2, Oracle and SQL Server technologies.
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Extensive Tableau Experience in Enterprise Environment and Tableau Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Experience Interacting with power user community to understand and document requirements.
• Experience in configuration and administration of Tableau Server in a multi-server and multi-tier environment.
• Expertise in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth.
• 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.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Experience in configuring reports from different data sources using data blending.
• Strong database experience in using Oracle 10g/Sql Server.
• Experience with Optimization of Queries using Indexes and joins.
• Strong experience in SQL and PL/SQL stored procedures and functions.
• Experience in Data Conversion and Data Migration using SSIS across different databases like Oracle, MS access and flat files.
• 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.
• Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Developed dash boards with rich Graphic visualizations, Drill Down and Drop downmenu options, parameterized using Tableau.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters,Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies,
• Installed, configured, maintained Tableau Environments; DEV, QA, and Production.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Involvement in end-to-end activity of dashboard development from requirements gathering to deployment phase.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.

TECHNICAL SKILLS:

Visualization Tools: Tableau Desktop 9.3/10.3.x/10.4 Tableau Server 9.3.2/10.5, Tableau Reader, Power BI.

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

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,Redshift,Hyperion

Languages: SQL, PL/SQL, HTML,C,R

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

WORK EXPERIENCE:

Confidential

Software Engineer/Tableau Developer

Responsibilities:

• Gathered requirements from Traders, PM’s and implemented them in a way to help them in the investment process.
• Served as a technical resource for Tableau on the project team to drive key projects to completion.
• Responsible for accessing disparate sources of production data and integrated these sources of information into common and interactive platform through Tableau.
• Designed dashboard visualization tailored to customer needs and ensuring flawless integration within the reporting framework.
• Performed analysis to build Tableau extract data sources leveraging existing data mart.
• Used live connection with Netezza and Oracle database schemas to provide near real-time data.
• Migrated Tableau Dashboard from version 9.3 to 10.3.2 and adding users to the AD group.
• Technical expertise in identification of solutions meeting complex business needs that facilitates automation and drives self-service.
• Created Interactive Dashboards with Context filters, Quick filters, Parameters and Actions to handle views more efficiently.
• Provided drill down mechanism with in a dashboard to clearly understand the performance of a portfolio and its KPIs.
• Provided navigation between different dashboards and making the selection criteria as the context.
• Used different table calculations and date calculations in the dashboard.
• Created a dashboard which helps the portfolio manager know which portfolios are under invested and which are over invested.
• Created Heat maps which show how the portfolios are on par with the models and their difference.
• Created Dual axis charts, Stacked bar, Histograms and Line charts for time series.
• Used Box plot to show the distribution of outliers which aren’t performing well.
• Did Data validation with backend database once the dashboard is created.

Environment: Tableau Desktop 9.3.x/10.3.x,10.4 Tableau Reader 10.3.x, Rapid SQL, PL/SQL, Redshift, Microsoft Excel 2010, Microsoft office 2010.

Sr. Tableau Developer

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.
• 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.

Sr.Tableau Developer

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.
• Maintaining and repairing database linkages to ensure interactive dashboards are regularly updating.
• 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, Hyperion, MS Office 2010/2013, Talend.

Tableau Developer

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 and upgrading based on user requests.
• 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.
• Maintaining and repairing dashboards.
• 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.
• Developing customized data views.
• 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

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 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.
• Updating dashboard linkages to Drive train Data Hub.
• 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

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

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.