PROFESSIONAL SUMMARY:

• 7+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• 4+ years of extensive experience working with Business Intelligence data visualization tools with specialization on Tableau.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Tableau/Spotfire.
• Involved in creating Dashboards using Tableau Desktop, Tableau Server, and created reports in SAP BO.
• Created incremental refreshes for data sources on Tableau server.
• Experience in Installation, Configuration and administrationof Tableau Server in amulti - serverandmulti-tierenvironment.
• Introduced Tableau to Client’s to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user and help them make effective business decisions.
• Created Dashboard’s using multiple BI Tools with Drill-Down capabilities using Dashboard prompts, Local and Global Filters.
• Experience in Business users through online and in-class sessions.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau7.0 to 8.1.
• Worked on Scrum Methodology as well as on SDLC procedures in the implementation of Tableau/Spotfire.
• Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance and Object Oriented Design (UML). Experience in Database modeling using data modeling tool.
• Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server 2005 Reporting Services (SSRS).
• Worked on SQL BI solution integration with Microsoft share point server.
• Worked with report builder tool 3.0/2.0/1.0
• Exposure to CMMI, ISO and QA processes, change control management, source safe, version controlling etc.
• Good knowledge on Data Quality Assessment & Data Cleaner Tool, Data Model Creation. Written SQL queries and MDX queries to test the OLTP & OLAP Databases based on changes of the functionality.
• Knowledge on Google API development skills, SQL Server, SSIS, SSAS and SSRS.
• Knowledge on Hadoop and Cloud.
• Extensivelyworked on databases likeOracle, SQL Server, DB2, and Teradata. Strong programming and debugging skills inPL/SQL, SQL and UNIX shell scripting.
• Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
• Had an experience in leading a small team and Knowledge in Health domain (Health Insurance and Clinical Data concepts and terminology).
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS:

Database Tools: Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Crystal Reports 9.0 / 10

RDBMS: MS SQL Server 7.0 /, Oracle 9i, MS Access.

Programming Languages: SQL, PL/SQL, C, C#, ASP.Net, HTML, XML, XSL

ETL: Data Transformation Services (DTS), SQL Server Integration Services (SSIS),Talend

Reporting tools: Tableau, Logi XML, Spotfire, Qlikview, SAP BO

Script Languages: VBScript, HTML and XML

Web Tools: MS-Front Page, Macromedia Suite, IIS, Outlook Express

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Sr Tableau Developer

Responsibilities:

• Experience in designing and development of Tableau visualization solutions and Created Technical document on top of BRI document for the business users.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Extensively worked onTableauDesktop, by creating Sears & Kmart Complex reports & Dashboards.
• Worked inTableauenvironment to create dashboards like weekly, monthly, daily reports using tableaudesktop & publish them to server.
• Created Workbooks and dashboards for analyzing statistical billing data usingTableau8.0
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, and Data connections as a tableau administrator.
• Involved in creating dashboards and reports in Tableau 8.1 and Maintaining server activities, user activity, and customized views on Server Analysis.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Analyzed thedata using statistical features intableauto develop Trend Analysis reports.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended.
• Experience in development of MDX queries to extract and modify the data from Multi-Dimensional data sources (Cubes).

Environment: Tableau Desktop 8.1, Tableau server / Administrator, SQL server 2008/2012.

Confidential

Sr Tableau Developer

Responsibilities:

• Read business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.
• Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.
• Created pie and bar charts and combined them into dashboards to show top content viewed by customers in each category including sports and news channels allowing interaction between the two charts for drill down analysis.
• Analyzed data from various databases and formatted it into graphs using Tableau Desktop.
• Created line charts to show over time in a breakdown of daily, weekly, quarterly, and yearly parameter numbers of viewers watching a particular sports channel.
• Blended data from multiple databases such as MS Excel and SQL database by assigning primary key from each databases.
• Upgraded Workbooks and Dashboards fromTableau6 toTableau7.
• Developed geographic maps showcasing demographics broken into age, race, and income category that showed content viewed by individual customers across all content providers.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet inTableauDesktop.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Administered user, user groups, and scheduled instances for reports in Tableau Server.
• Presented, interacted, and communicated with business and user groups for explaining the dashboards that I have created with the ability to change and view the data on the fly.

Environment: Tableau Desktop 7, Tableau Server, SQL Server 2008, MS Excel.

Confidential, Sterling, VA

Tableau Developer

Responsibilities:

• Responsible forTableauEnvironment, Security, Architecture setup.
• Interacted with business users in gathering, analyzing and documenting the business requirements and translate them into technical specifications.
• Involved inTableauServer Installation and Configuration, creating users, groups, and projects and assigning access levels.
• Worked on Proof of Concepts to decideTableauas a BI strategy for enterprise reporting.
• Created technical specification documents related toTableaudesign and architecture.
• Created severalTableaudata extracts with prebuilt calculations, parameters and sets to enable end users to easily utilize the extracts as semantic layer to create their own workbooks.
• Created various highly interactive dashboards and data visualizations reports for Ad Sales and Program Finance departments.
• Developed multiple reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
• Created Server Monitoring workbook views and a custom workbook to see 'My activity' onTableau Server usingTableauServer Repository Database (Postgresql).
• Actively involved in creating a custom portal design hostingTableauworkbooks using JavaScript API.
• Worked with end users in creating complex dashboards in an iterative process.
• Created several automated scripts to backup, restore and auto sync Windows AD users.
• Extensively used Tabcmd and Tabadmin for variousTableauserver maintenance activities.
• Performed tuning oftableauworkbooks and extracts to make them functional with large sets of data.
• Conducted sessions forTableauPower users to use it as a Self-service BI tool

Environment: Tableau 7x, Tableau server 7x, Crystal Reports, Xcelsius 2008, Web Intelligence 4.1/4.0/3.1, MS Excel, SQL Server, HANA DB, JavaScript API.

Confidential

SQL BI Developer

Responsibilities:

• Published reports in Business Objects Enterprise XI R2 using Central Management Console and Publishing Wizard.
• Assigned Scheduling Rights as per the User Requirements
• Used multiple sub reports, pass through parameters and pass by parameter linking for generating complex reports for management
• Work with Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support.
• Work with production team to coordinate and assist in rollout of releases.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Worked with BO support in troubleshooting issues and provide logs as per request for resolving several complex issues
• Created various complex Reports and exported to Excel Spreadsheets for Analytical uses
• Provided solutions to various groups for scheduling reports using Packages and event based job scheduling.
• Co-ordinating with various groups in scheduling releases between environments.
• Deployment of Crystal Reports via various methodologies Central Management Console(CMC),
• Publishing Wizard, Infoview, Import Wizard.
• Migration of Universes and Web Intelligence documents via Import wizard to maintain relationship between objects.
• Experience on Developing Crystal Reports.
• Daily reporting to Management on status, issues, migrations, escalations and progress.
• Created various types of reports of type Standard, Cross Tab, Drill Down, Sub Reports on Audit
• Database for investigating User activity and narrowing down issues.
• Assist Team in Optimizing system architecture.
• Assist with website deployment architecture (e.g. web servers, databases etc.) and code optimization.
• Designed and implemented Adhoc Reports, Extracting Data from an SQL Server database.
• Experience managing user accounts and group accounts in Crystal enterprise environment.
• Used Clear case Explorer to Take Backup of Webi Reports and Universe.

Environment: Business Objects XIR1/XI R2 SP2, Crystal Enterprise 10, Crystal Reports XI R1/ XI R2, Windows 2k3/2k, Universe Designer, Web Intelligence. Oracle 10g, Clear case

Confidential

SQL Developer

Responsibilities:

• Used multiple sub reports, pass through parameters and pass by parameter linking for generating complex reports for management.
• Work with Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Created various complex Reports and exported to Excel Spreadsheets for Analytical uses
• Migration of Universes and Web Intelligence documents via Import wizard to maintain relationship between objects.
• Created various types of reports of type Standard, Cross Tab, Drill Down, Sub Reports on Audit
• Database for investigating User activity and narrowing down issues.
• Assist Team in Optimizing system architecture.
• Monitoring Scheduling Reports
• Designed and implemented Adhoc Reports, Extracting Data from an SQL Server database.

Environment: Business Objects 3.1, Universe Designer, Web Intelligence. Oracle 10g