SUMMARY

• Around 8 years of experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Extensive experience inTableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6, Tableau 7 and Tableau 8.
• Involved in Requirements gathering and analysis,Design, Development, TestingandProduction, rollover of Reporting and Analysis of projects.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Expertise in creating different visualizations using Bars, Lines, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables. Extensive experience on building dashboards using Tableau.
• Skilled in Tableau Desktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot table, scatter plots, pie charts and packed bubbles and also use multiple measures for comparison such as Individual Axes, Blended Axes, and Dual Axes
• Skilled and experienced in using appropriate calculations, parameters, report types, dynamic attributes, sets, cubes, filters etc within Tableau
• Proficient in developing Entity - Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• Proficient Star Schema dimensional modeling, which includes understanding business, processes, modeling dimensions, hierarchies and facts.

TECHNICAL SKILLS

BI Tools: Tableau Desktop 8.x/9.x,Tableau Server 8.x/9.x, SSRS

ETL Tools: Informatica

Web server: IIS Web Server, Tomcat

Operating system: Windows 7/XP, UNIX

Databases: Oracle 8i/9i/10g/11g, Teradata, MS SQL Server 2005/2008/2012 and DB2

Tools: MS Excel, MS Word, MS PowerPoint, MS project, MS Front MS Expressions Web, TOAD, Sql Developer, Sql Star Plus.

Programming Languages: Microsoft . NET (ASP.NET, C#.NET and VB.NET), Tsql, SQL

WEB Technologies: HTML, CSS.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Tableau Developer

Responsibilities:

• Involved in SDLC which includes gathering of business requirements, design document and planning development and publish tableau dashboards.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, etc., to assist business users in solving complex problems.
• Develop prioritization scorecard to provide transparency around how to prioritize Request For Proposals (RFPs) to better support revenue goals and the chances of winning.
• Prepare RFP prioritization dashboards and the win rate on prioritized RFPs vs de-prioritized RFPs.
• Created calculated fields to calculate the no. of RFPs, win percentage, prioritization and client breakdown ratio.
• Develop a marketing framework, strategy and process that support the firm’s strategic plan and revenue goals.
• Concentrate on the focus products and support and develop dashboards for the effective release of the products.
• Upgrade collateral around specific investment management products through deep understanding of data visualization using Tableau.
• Provide tableau visualizations to monitor the timing of launches to meet client expectations for product offerings.
• Used filters to filter mandate amount based on region globally
• Used Excel sheets and csv files to generate tableau reports.
• Blended data from multiple databases into one reports from selecting primary keys from each database for data validation.
• Involved in analysis of key performance indicators (KPI) for winning percentage to better understand the bussiness.
• Extensively used trend lines and reference lines.
• Handled Tableau admin activities creating projects, users and synchronizing.
• Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
• Working knowledge in SQL query rewriting and optimization using Oracle, SQL Server databases.
• Worked in agile team setting and knowledge of other BI tools Micro strategy and OBIEE.

Environment: Tableau Server 8.3, Tableau Desktop 8.3, SQL Server 2008/2012, Oracle, MS Office, Windows 7.

Confidential, Indianapolis, IN

Tableau Developer

Responsibilities:

• Worked with business analyst and business users to understand Wireless Device Expense Policy for corporate expenses and per user expenses across enterprise.
• Performed Data blending implemented on SQL Server Database to generate interactive dashboards.
• Created Expense Tracker reports to show historic data and plot future trends and identify potential opportunities for lines of business to manage costs.
• Created Tableau visualizations using line charts, bar charts, dual axis charts.
• Generated dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Created ad-hoc reports to users in Tableau by connecting to various data sources to show expenses by devices and charge category.
• Published workbooks by creating user security and row level security.
• Created advanced charts like Waterfall chart and Pareto Chart.
• Handled Tableau admin activities generating access, managing extracts and installations.
• Performed troubleshooting to address connectivity issues.
• Experience on server administrative functions, Meta data model development, Performance tuning techniques and customization.
• Working knowledge of dimensional modelling, ETL, SQL query rewriting and optimization using Oracle, SQL Server databases.
• Worked in agile, iterative team setting and experience with other BI tools like SSAS/SSRS and OBIEE.

Environment: Tableau Server v8.1/8.2, Tableau Desktop 8.1/8.2, SQL Server 2008/2012, Oracle

Confidential, NYC, NY

Tableau Developer

Responsibilities:

• Involved in the gathering of business requirements and translating them to the report specifications for the conversion of Actuate Reports to Tableau platform.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• 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.
• Extensively used advance 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.
• 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.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on theTableauServer 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 publishes or extracted to server.
• Responsible for designing of the Imports and Exports module for the sales and purchase orders of the products and was also involved in deployment of the whole project.
• Requirements gathering and analysis from Business users.
• Reports built with extensive use of Set Analysis to have multi facet analysis of data.
• Process follow ups and sanity checks on deliverables for production deployment.
• Overridden various methods like On Read, Fetch, Start, Obtain Select and On Rowto get the right functionality.
• Used Multiple Input Filters, Memory data sorter, Nested Reports, Sequential / Parallel Section, Use of Actuate Foundation Classes, Sub classing and customizing Frames and Data Controls
• Created configuration files to include the libraries ROL in the Actuate reports.
• Converting existing MS Access/ Spreadsheet Reports to Actuate e. Reports

Environment: TableauDesktop 7.1,TableauServer,MS Office Suite,Oracle SQL ServerR2, MS Excel, SERVLETS, HTML, JSP, ACTUATE ERDPRO, ESPREADSHEET

Confidential

Tableau Developer

Responsibilities:

• Worked on Proof of Concepts (POC) presentation and review with project and IT lead along with developing Tableau Dashboards.
• Worked on technical strategy, provided hardware and software configuration, understood client-wide BI implementation project, design and develop visualizations as per requested by CEO and CFO.
• Adjust views/dashboards after initial POC presentation to CEO and CFO.
• Create views and dashboards on end client's sales data. Produce powerful dashboards using pie, bar, geo, and line charts that are viewed daily by CEO and CFO.
• Cleanse and normalize data in MS Excel by combining from various data sources.
• Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.
• Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.

Environment: Tableau Desktop 6/7, Tableau Server 6/7, MS Excel, MS SQL Server 2008/12 R2, Win Server 2008 R2, Active Directory

Confidential

BI Developer

Responsibilities:

• Worked on Full life cycle development (SDLC) involved in all stages of development, Created different types of reports in SSRS such as parameterized and cascaded parameterized reports.
• 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.
• Worked on different types of reports in SSRS like Drill Down and Drill Through.
• Wrote complex queries, CTE’s (Common table expressions), stored procedures, functions and views to ensure data integrity, data consistency and to meet the business rules.
• Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
• 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.
• 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.
• Designed reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports.

Environment: MS SQL Server 2008, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS Access, TOAD, Windows.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables (using both UTL and SQL Loader - for different cases)
• Explain Plan, TKPROF was used for checking the performance of queries
• Modified and updated existing custom forms to adapt to new database schema
• Created SQL scripts for conversion of legacy data (including validations) and then load it into the tables
• Developed SQL*Loader programs & PL/SQL scripts to load legacy data into Oracle Apps.
• Developed PL/SQL programs for various modules to validate data while importing into oracle system.
• Participated in database development like creating PL/SQL triggers, packages, procedures function.
• Handling errors using Exceptions.
• Extensively worked on UTL FILE Packages in Reading data from data files and put them in database tables.
• Knowledge of Normalization, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.
• Performed exception handling for data that did not conform to the required format.
• Responsible for making the merged data in turn available to other clients.
• Wrote UNIX scripts to automate loading files into database using error handling and notification.
• Involved in implementing the data integrity validation checks through constraints and triggers.

Environment: Oracle Database, PL/SQL, SQL Loader, SQL.