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

TECHNICAL SKILLS

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

PROFESSIONAL EXPERIENCE

Confidential, NY

Tableau Developer / Administrator

Responsibilities:

• Involved and responsible whole and soul for teh data structuring that to be driven into Tableau from flat files and Microsoft Excel workbooks
• Insisted Data analysts to validate teh structure modeled for developing reports
• Involved in Business user requirements and was a part to it in enhancing teh existing Dashboards and creating new Dashboard for teh end users
• Creative Interactive scorecard with customized user access controls as per teh 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 teh axes and portrays multiple metrics in a single chart
• Created FX Conversion Rates by using data blending Technique to convert currencies to teh respective user region
• Automated all teh reports published which when refreshed teh extract updated teh whole dashboard with ease
• Performed an intensive quality check and troubleshooting for teh dashboards
• Optimized teh extracts to increase teh performance of teh dashboard
• Created complicated calculations to meet teh requirements of teh business users
• Migrated all teh Excel reports to Tableau which when created reports in Tableau was condensed into simple on one go feature
• Scheduled extract according to teh data incoming transmission of teh organization
• Involved in business analysis and presented various ideas to enhance teh 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 teh Business users, managers and end users concisely
• Evaluated database performance for investigation of issues and further resolution for efficiency of teh report
• Used basic and advanced SQL queries for editing joins such as inner and outer joins by connecting to live and static datasets increasing teh performance
• Conducted Training sessions for teh newly on boarded business users to make them familiar on Tableau reports and explained teh importance of Tableau Interactivity perform analysis and view teh reports
• Actively held meetings to get teh 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, 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 teh 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 teh 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 teh 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 teh performance
• Created story points in Tableau Desktop and deploying them to Tableau server which helps teh end users to cognize teh data over given period of time by using quick filters
• Tested dashboards to ensure data was matching as per teh business requirements and if their were any changes in underlying data
• Dashboards were tested for increasing teh performance and guarantee that teh data was efficiently used as per teh 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 teh business stake holders to understand teh 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 teh 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 teh above data sources dashboards was created
• Executed type conversion functions in Tableau connecting relational data sources
• Installed and configured teh Tableau server in cluster installation with 3-node architecture
• Created schedules for teh reports to be refreshed periodically enabling end user to track teh activity
• Worked extensively with teh 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
• Acnoledged issues regarding server and scheduling of reports and suggested solutions to troubleshoot to increase teh 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 teh 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 teh data on teh fly with teh 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 teh views and dashboards were displaying teh changed data accurately
• Tested dashboards to ensure data was matching as per teh business requirements and if their 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 teh requirements and selected teh appropriate fact tables/created fact tables
• Selected teh dimensions required based on teh analysis requirements, Created teh new dimensions, Shared dimensions, and time dimensions
• Configured SSRS 2005 with MOSS 2007 for directly deploying teh 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 teh database

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