SUMMARY:

• 7 years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms
• Having 4 years of versatile working experience on Business Intelligence/Business Analytics software also experience in Infrastructure services.
• 4+ years experience in Tableau Dashboard development, Tableau Server Administration and Tableau Architecture (started with version 6)
• 4+ years experience in ETL tool Informatica.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management (Connections, Data Model, VizQL Model).
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Deployed the reports and Scheduled Reports for the use of end users.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Experience in creating ad-hoc reports using Business Objects Web Intelligence tools.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
• Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Ability to architect a custom solution. Design, development, distribution of custom client-server and WEB solutions. Integrator of relational databases like SQL Server, ORACLE, Microsoft Access and Excel spreadsheets.
• Experience in modelling, architecture, designing, coding, debugging and testing instrument driver/interface and other application in manufacturing, R&D environment across various platforms
• Excellent knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Good Independent / team working skills and experiences, excellent communication skills with very good customer handling capabilities.
• Able to handle different projects concurrently and Lead experience.
• Technical support to the team, reviews of deliverables, communication with offshore team, track all the deliverables and to impart on job training to the team.
• Experience in performing System, Functionality, User Acceptance, Integration and Regression testing.
• Excellent Interpersonal communication, Documentation skills and experience coordinating with project managers, business Analyst, Architects, DBAs and Developers.
• Experience on data warehousing concepts, ETL tool Informatica.

TECHNICAL SKILLS:

BI Tools: Tableau Desktop, MS BI, Tableau Server

ETL Tools: Microsoft SQL Server Integration Services, BO Universe Designer, BO Web intelligence, Crystal reports XI/2008Databases: Microsoft SQL Server(2005/2012), IBM BD2, MySQL

Document management: Visual Source Safe 6.0, Share point

Programming Languages: C, C++, SQL, PL/SQL, C#, ABAP, HTML, JavaScript

Data Modelling: MS VISIO

Applications: Eclipse, NetBeans, Oracle SQL Developer

Databases: Oracle 8i/9i/10g/11g, MS Access, MS SQL Server 2000/2005/2008Operating Systems: Windows XP/7/8, MS-DOS, Sun Solaris, Linux

Web/App Servers: Apache Tomcat, Web logic Server 8.1/9.2/10, MS IIS 5/6.0, JBoss

Packages / Tools: MS Office, Toad, Putty, FrontPage 2000.

PROFESSIONAL EXPERIENCE:

Confidential, CO

Tableau Developer

Responsibilities:

• Developed 12 Dashboards for Texas Health Care Organisation in Just 3 Months
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Physician spltter IP,OP, Market Share IP,OP Market Volume IP,OP Patient Origin IP,OP Sercie Line IP,OP
• Experienced in SQL Server Business intelligence tools like SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS)
• Creating dashboards in line with the analytical uniformity using the
• Provided 24/7-production support for Tableau users .
• Advanced Analysis of Tableau Desktop, and organizing Dashboard views and objects
• Extensive experience in Tableau and PL SQL Suite
• Experience in using Tableau functionalities for creating differentRequests, Filters, Charts, Interactive dashboards with Page and dashboard Prompts
• Developed inpatient and outpatient dashboards for THS
• Created dashboards for Ben taub Hospitals,memorial Hermann texas .
• 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.
• Actively Participated with 260 plus Insurance Companyies for the Reports .
• Actively Particpated with Top physicians of texas and created a dashboard
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Improved Dashboard Performance from 10Mins to 15Seconds.
• Restricted data for particular users using Row level security and User filters.

Environment: Tableau Desktop 8.0/7.0, Tableau server / Administrator, tabcmd, SQL developer, SSRS, SQL 2012,Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

Confidential, PA

Tableau Developer/Admin

Responsibilities:

• Experience with the design and development of Tableau visualization solutions.
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• 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.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau with Javascript Frameworks and Jquery.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• 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,Financial Reports 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 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 publishes 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.
• Actively participated in clarification meeting with the Clients.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau 7.x/8.x (Desktop, Server), Teradata, Teradata SQL Assistant, Teradata Administrator, SQL, PL/SQL, MS Project.

Confidential, TX

Tableau Developer/Admin

Responsibilities:

• Created and assisted users in Tableau dashboard development
• Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for the Individualized Education Program
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• 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 the Tableau Server so that the end users having access to the server can view the data.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Designed and developed reports such as Drill down, Drill through using Microsoft Reporting Services.
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Used Stored Procedures to pull the data from the Production server and scheduled jobs to run the Stored Procedures.
• Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi-team environment.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio

Environment: Tableau Server, Tableau Desktop, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS)/DBA, Oracle 11g, Toad, MS Office, Team Foundation Server, Visual Studio 2010, WCF web service

Confidential, San Fransisco, CA

Tableau Developer/ Data Analyst

Responsibilities:

• Analyzing the Customer Data and interaction with business analysts/users for requirement gathering
• Involved in reviewing business requirements and analyzing data sources and building custom SQL queries to prepare the required data from different data sources such as Excel and IBM DB2
• Created Data Extracts using Filters and Custom SQL queries and Edit the Data source filters as required to extract the data
• Design and Developed Worksheets/views that involve different charts bar graph, scatter plot, Map reports and Detail reports using Tableau Desktop
• Created interactive Dashboards by creating Filter Actions and URL actions using Field and Filter Values in URL actions
• Installed Tableau Server 7.0 in Dev, QA, UAT and Prod environments.
• Installed patches on the server and documented upgrade plan from tableau 8.0 to 8.1
• Created SSIS packages in SQL Server 2008 for sources database for Tableau dashboards.
• Utilized Advance features of Tableau like Calculation fields, Parameters, Reference lines, Understanding the data fields by changing Data types and Field properties
• Building the Data viz. by creating Groups, Sets, Filters, Quick Filters, Compare multiple measures using Blended and Dual axes, Organize the Data Window by creating Hierarchies and Folders.
• Create Dynamic Sorting of Measures in the Viz. by creating Calculated fields and Parameters using Integer and Logical Functions
• Created Table of Contents (TOC), a common navigation page which had all the links to various reports and Dashboard.
• Formatting the Dashboard by following Best Practices for Designing Views and Dashboards using Color legends, Custom tooltips, Highlighting.
• Developed story telling dashboards in Tableau Desktop and Published Dashboard, Worksheets onto Tableau Server which allowed end users access the data views
• Create a "Test" project on Server site to upload dashboards from development and have end users test.

Environment: Tableau 8.2, Microsoft SQL Server, MS Excel, Windows 7, SQL, UNIX, Linux RHEL 5.4

Confidential

BO Developer/Data warehouse Developer

Responsibilities:

• Understand the technical requirements, developed simple reports to satisfy the user requirements
• Worked on DeskI and WebI reports in BO 6.5
• Worked on Universe Designer and designed simple Universe by defining Joins, resolving loops and cardinalities
• Resolved Loops in Universe by creating Aliases, Contexts.
• Export the universe into the repository. Initiated migrating universe and reports between environments.
• Created several Classes, Dimension Objects, Measure objects and Conditions.
• Created Web I reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc. Developed hierarchies to support drill down reports.
• Features such as breaks, alerter and hide blocks are used in developing reports.
• Exported Business Objects reports to Web Intelligence to be published on the Intranet and created thin client reports through Info View.
• Developed universes and DeskI reports from the Oracle 9i database.
• Written queries to retrieve data from Oracle database for multi-dimensional analysis using slice & Dice and Drill up/down functionality.
• Generated various standard reports and queries based on the existing classes/objects.
• Responsible for Creating Complex and Multi Dimensional reports using Master/Detail, Cross Tab, Slice and Dice and Sub Queries.
• Developed On - Demand Sub Reports, Parameter Reports and Drilldown Sub Reports.
• Created numerous Alerts that are executed based upon certain conditions.

Environment: Business Objects 6.5.1, Desktop Intelligence, Web Intelligence, Crystal reports 9, Oracle 9i, SQL TOAD, Windows NT/2003