SUMMARY

• Over 7 years of IT experience with 3 years’ of experience in Tableau Desktop/Server 9/8.x/7.x/6.x
• Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms.
• Experience in configuring reports from different data sources using Data blending.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Introduced Tableau to my team to produce appealing data visualizations to clients and to help them make effective business decisions
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Experience in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Experience in gathering requirements, analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Expertise in getting the data from different data source such as MySql, T - SQL, MongoDB, Oracle SQL as well as PL/SQL.
• Extensive experience in Installation, configuration, upgrade and administration of Tableau Desktop/Server.
• Experience in creating Documents, reports and dashboards for various business environments.
• Highly proficient in the use of SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
• Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure
• Strong leadership, problem-solving and multi-tasking abilities.

TECHNICAL SKILLS

• Tableau Desktop 6/7/8/9
• Tableau Server 6/7/8/9
• Tableau Online
• Tableau Public
• Tableau Reader
• TabCmd
• MongoDB
• Microsoft SQL Server 2012/2008-R2/2008
• MS
• T-SQL
• PL-SQL
• MySQL
• Microsoft Visual Studio 2010/2008
• Cognos
• Micro strategy Desktop
• Web
• Intelligent Server Object Manager
• Microsoft Office (MS-Word/Excel/PowerPoint/Access)
• PHP
• Apache Server
• Windows
• IIS
• UNIX
• MS SQL Profiler
• Java
• Visual Basic.NET
• HTML
• JSON
• XML
• Oracle

PROFESSIONAL EXPERIENCE

Confidential, St.louis, MO

Tableau Developer

Responsibilities:

• Involve in Planning, Defining and Designing data based on business requirements and provide documentation.
• Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.
• Optimize Indexes, Views, Stored Procedures and Functions using Oracle.
• Create Schedules and extract the data into Tableau Data Engine.
• Building, publishing customized interactive reports and dashboards, report scheduling on Tableau server.
• Manage the Tableau solution architecture, administration and actively manage the performance and usability. Align/standardize team members on best practices around Tableau driven implementations.
• Implement action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
• Create 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.
• Effectively used data blending feature in tableau.
• Define best practices for Tableau report development.
• Administer user, user groups, and scheduled instances for reports in Tableau.
• Execute and tested required queries and reports before publishing.
• Develop dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Schedule 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.
• Develop parameter and dimension based reports, drill-down reports, charts, and Tabular reports using Tableau Desktop.
• Execute and tested required queries and reports before publishing dashboards.
• Provide support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Extensively work on Tableau Desktop, by creating Complex reports & Dashboards.
• Create Tableau scorecards, dashboards, Heat maps using show me functionality
• Scheduling the monthly/weekly/daily reports to run automatically.
• Develop implement and maintain various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Create procedures to ensure the quality, usability and accuracy of reports.

Environment: Tableau Desktop (Version 8.1.2 - Version 9.0.2), Tableau Server (Version 8.1.2 - Version 9.0.2), SQL Server, Microsoft Visual Studio, Microsoft Visual Basic, Oracle, SQL Server Management Studio, MS Excel, MySQL, ERWIN.

Confidential, NYC, NY

Tableau Developer

Responsibilities:

• Worked and partnered with business and IT teams in various areas of retail banking to develop or maintained reports and addressed data needs to provide reporting solutions.
• Independently worked on owning IT support tasks related to Tableau Reports on Server.
• Built and maintained many dashboards.
• Conducted Knowledge transfer session to the employees on Tableau Software.
• Created dataflow diagram and documented the whole data movement process.
• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.
• Worked on the requirement gathering of the reports
• Analyzed the database tables and created database views based on the columns needed.
• Created dashboards displaying sales, variance of sales between planned and actual values.
• Implemented calculations and parameters wherever needed.
• Published dashboards to Tableau server.
• Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing & Deleting Users and Activating their Licenses, Distributed Environments, Installing Worker Servers, Maintaining a Distributed Environment, High Availability.
• Configured numerous collections in MongoDB for all the user data from various business units.
• Impersonating with a Run as User Account, Impersonating with Embedded SQL Credentials.
• Good Knowledge and Worked on TABCMD & TABADMIN, Database Maintenance and Troubleshooting.

Environment: Tableau Desktop, Tableau Server, MySQL, Microsoft SQL Server, MongoDB, Windows, Tomcat, Microsoft Visual Studio, ERWIN

Confidential, Arnold, MO

Tableau Developer

Responsibilities:

• Created stored procedure using nodes method to load XML file data into SQL server tables.
• Wrote User defined functions, views, trigger, and indexes for various purposes based on the requirements.
• Rewrote poorly performance stored procedure, functions, triggers, views and indexes.
• Created reconsolidation reports for conversion purpose using various joins.
• Involved in reviewing business requirements and analyzing data sources form Excel/MySQL 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 using Tableau.
• Projected and forecasted future growth in terms of number of subscribers in various services by developing Area Maps to show details on which states were connected the most and publishing it on Tableau Server.
• 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 MySQL, 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.
• Rewrote various business process and tested result in MS Excel using various functions and sub query with not exists.
• Involved in updating functional requirement document after development and created documentation for deployment team.

Environment: Windows, Tableau Desktop (Version 6.0.10 - Version 6.1.11), Tableau Server (Version6.0.10 - Version6.1.11), SAS,MS Office Suite, Oracle 10g, SQL Server, MS Excel, ERWIN, MS Excel.

Confidential

SQL Developer

Responsibilities:

• Design, code, test, debug, and document complex database programs to ensure that data processing production systems meet user needs.
• Interact with internal and external clients to understand requirements, explain issues and prioritize work.
• Worked closely with end users in designing and creating the Data warehouse for management group using and Erwin.
• Implemented logical and physical database modeling using Erwin tool.
• Enhance existing programs.
• Created Queries in Oracle SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Performed tuning and optimization of queries for reports that takes longer execution time using MySQL.

Environment: MySQL, Microsoft SQL Server 2005 Enterprise Edition, Windows Server, SQL Business Intelligence Development Studio (BIDS), Oracle, Microsoft Visual Studio, IIS.

Confidential

SQL Developer

Responsibilities:

• Collected business requirements from different sources and wrote the technical specifications for building the Data model.
• Provided input to schema design, code deployment.
• Developed database structures and SQL queries for web applications.
• Supported development team efforts by aiding in creation of stored procedures/queries.
• Worked with development team to improve application performance by tuning queries.
• Assisted in the identification and repair of inconsistent or incorrect data.
• Documented all processes and activities for future development.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Developed and deployed packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.

Environment: Microsoft SQL Server 2005 Enterprise Edition, Windows Server 2003, MySQL, Oracle 10g, Microsoft Visual Studio.