SUMMARY:

Over 7 years of experience in design, development, implementation, and administration of various Business Intelligence tools and expertise in implementing various functionalities of Data Warehouse. Has expertise in using Tableau Server, Tableau Desktop, Tableau Reader and Tableau Public. Has strong experience in SQL Server development, system analysis, design, development and support of MS SQL Server 2012, 2008, 2005 and 2000. Has expertise in installing, configuring and administration of Tableau Server in Scale - out process. Has expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement. Has extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint. Experienced experience in data modeling using dimensional data modeling, Star Schema modeling, Fact and Dimensions tables, and Physical and Logical data modeling. He has experience in designing stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms.

TECHNOLOGIES:

Languages: UML, C / C++, HTML,Java, SQL, PL/SQL

SAS Technologies / Tools: Tableau (6.1 / 7.0 / 8.0 / 8.1 (2,3) / 9 / 9.3,10.0), MS BI, MS Visio

ETL: MS Project, MS Office Suite, ALTERYX, Oracle 8i/9i/11G, SQL Server 7.0 & 2000 Teradata Access 2000, MS SQL Server

DB2: My SQL Windows /MAC

EXPERIENCE:

Confidential, NYC, NY

Tableau Developer / Administrator

Responsibilities:

• Involved and responsible whole and soul for the data structuring that to be driven into Tableau from flat files and Microsoft Excel workbooks
• Insisted Data analysts to validate the structure modeled for developing reports
• Involved in Business user requirements and was a part to it in enhancing the existing Dashboards and creating new Dashboard for the end users
• Creative Interactive scorecard with customized user access controls as per the business requirements
• Created customized waterfall charts which are not conventional but a different kind of waterfall chart where it involved advanced calculations
• Created Dashboard which are time series dependent which contains Bar charts, YTD Growth Charts, Bullet Charts, dual axis and many more charts which enables synchronizing the axes and portrays multiple metrics in a single chart
• Created FX Conversion Rates by using data blending Technique to convert currencies to the respective user region
• Automated all the reports published which when refreshed the extract updated the whole dashboard with ease
• Performed an intensive quality check and troubleshooting for the dashboards
• Optimized the extracts to increase the performance of the dashboard
• Created complicated calculations to meet the requirements of the business users
• Migrated all the Excel reports to Tableau which when created reports in Tableau was condensed into simple on one go feature
• Scheduled extract according to the data incoming transmission of the organization
• Involved in business analysis and presented various ideas to enhance the existing reports
• For further data analysis, charts are converted into Crosstabs which can be used in MS Excel
• Expertise in designing best dashboards that included a perfect alignment and Color Combination
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation
• Created interactive dashboards in Tableau Desktop in multiple versions to report the Business users, managers and end users concisely
• Evaluated database performance for investigation of issues and further resolution for efficiency of the report
• Used basic and advanced SQL queries for editing joins such as inner and outer joins by connecting to live and static datasets increasing the performance
• Conducted Training sessions for the newly on boarded business users to make them familiar on Tableau reports and explained the importance of Tableau Interactivity perform analysis and view the reports
• Actively held meetings to get the updates and ideas to be projected into Tableau
• Utilized Alteryx to create workflows and generate predictive, statistical and spatial results by combining data

Environment: Tableau Desktop 8.1 & 8.2 to 9.3, Tableau Server 9.0, MS Office Suite, Microsoft SQL Server R2, MS Excel, Teradata, SAS and Alteryx 10.1

Confidential, Jersey City, NJ

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Excel, Oracle and SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop
• Efficiently used parameters, sets, groups and calculations in worksheets and dashboards
• Involved in creating a dual-axis and dual maps with multiple measures
• Automated the data extracts and subscriptions with Tab-Cmd tool
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most
• For further data analysis, charts were converted into Crosstabs which can be used in MS Excel
• To determine profit generation by using data from Oracle SQL Server, bullet graphs were used which allow people who are color blind since it restricts colors
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation
• Created interactive dashboards in Tableau Desktop to report the Business users, managers and end users concisely
• Assisted in management and database administration of Oracle database applications on Exadata platforms
• Evaluated database performance for investigation of issues and further resolution for efficiency on Exadata
• Used basic and advanced SQL queries for editing joins such as inner and outer joins by connecting to live and static datasets which increases the performance
• Created story points in Tableau Desktop and deploying them to Tableau server which helps the end users to cognize the data over given period of time by using quick filters
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
• Dashboards were tested for increasing the performance and guarantee that the data was efficiently used as per the requirement of client
• Interacted efficiently in meetings, review analysis and user group discussions and communicated well with business clients and suggested modifications for their requirements

Environment: Tableau Desktop 7.0 & 8.1 to 8.3 Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel and Oracle Exadata DBA

Confidential, PA

Tableau Developer

Responsibilities:

• Interacted with the business stake holders to understand the requirements
• Created reports and dashboards by extracting data from different sources
• Developed interactive dashboards using actions (URL, highlights, and filter) for better understanding of reports
• Created calculated fields, mapping and hierarchies and used advanced statistics for analysis of data in depth
• Developed the reports with multiple data sources by implementing data blending
• Developed a dual-axes bar chart with multiple measures
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server
• Worked on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, and MS Excel
• Worked on different databases such as Oracle, Teradata, Microsoft SQL and extracted data from MS Excel. Using the above data sources dashboards was created
• Executed type conversion functions in Tableau connecting relational data sources
• Installed and configured the Tableau server in cluster installation with 3-node architecture
• Created schedules for the reports to be refreshed periodically enabling end user to track the activity
• Worked extensively with the major functionality of ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports
• Administered user, user groups, and reports scheduling, subscriptions management in Tableau server
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards
• Created report schedules and deployed reports to server by giving permission to specific users using user filter
• Tab-admin and Tab-cmd commands were used for creating backups and restoring backups of Tableau repository
• Involved in creating stored procedures, tables, and views for applications
• Involved in creation and updates of several SQL Index, views, complex stored procedures, triggers and appropriate user defined functions
• Acknowledged issues regarding server and scheduling of reports and suggested solutions to troubleshoot to increase the performance using server architecture

Environment: Tableau V 7/8.0 (Desktop, Server, Reader), Oracle, Teradata, Java, SVN and MS Excel

Confidential, Dallas, TX

Tableau Developer

Responsibilities:

• 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
• 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
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most
• Converted charts into Crosstabs for further underlying data analysis in MS Excel
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users
• 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
• 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
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups

Environment: Tableau Desktop 6.1 & Tableau Server, MS Office Suite, Oracle SQL Server R2 and MS Excel

Confidential

SQL Server Developer/Analyst

Responsibilities:

• Analyzed the requirements and selected the appropriate fact tables/created fact tables
• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions
• Configured SSRS 2005 with MOSS 2007 for directly deploying the report in SharePoint 2007
• Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server
• Actively involved in Normalization & De-normalization of database
• Materialized views, dimensions and stored outlines for optimal performance
• Worked on Triggers and stored procedures to capture updated and deleted data from OLTP systems
• Generated different types of ad-hoc reports used SSRS Reports to write complex formulae and to query the database

Environment: SQL Server 2005 Enterprise Edition, SQL BI Suite (SSIS, SSRS), Enterprise manager, Crystal Reports, Erwin, XML, VB.NET, MS PowerPoint, MS Project