SUMMARY:

• More than 7years of experience in field of Data Analytics and market research Industry with skills in reporting, and business intelligence tools (Tableau 7.0/8.1/8.2/9.2/10 ) and competitive intelligence.
• Extensive experience in Tableau/BI Developer with, Business Intelligence and Data Warehousing applications in Retail, Financial, Health Care, Pharmacy and Manufacturing industries.
• Good understanding of Tableau Desktop architecture for designing and developing dashboards.
• 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, Dimensional maps, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
• Extensive knowledge in Dimensional data modeling, Star Schema, Snow-Flake Schema, Normalization, Physical and Logical modeling.
• Built and expanded reports available for both internal support and external customer/carrier reports, which included increasing the scope of data extracted and utilized for reporting purposes
• Created numerous ad-hoc analysis, dashboards, reports, graphs, and charts
• Experience with analysis, data, databases, and business intelligence
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables
• Excellent in applying Actions and Quick Filters
• Wrote SQL scripts and queries to extract data from various data sources into the BI tool, Visualization tool, and Excel reports
• Extracted data from SQL Server 2008 into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL.
• Publishing and presenting dashboards on web and desktop platforms.
• Creating dashboards using calculations, groups, sets, parameters, calculated fields and hierarchies.
• Experience working in Agile Environment.
• In depth knowledge of Software Development Life Cycle (SDLC) and experience in management of requirements throughout SDLC.
• SQL Server and Oracle Database development experience using tables, triggers, views, packages and stored procedures in PL/SQL & T-SQL. Strong RDBMS fundamentals.
• Worked extensively with Business Objects Data Integrator to create complex Data Flows using Query, Table comparison, lookups and all transformations.
• Ability to handle multiple tasks and work independently as well as in a team.

TECHNICAL PROFICIENCIES:

ETL/BI Reporting Tools: Tableau Suite of Tools 10, 9.2, 8.1, 8.0. 7, 6, 5.1 which includes Desktop, Server, online and Public and Administration of Tableau Server and SAP Business Objects XI R2, XIR3.Qlikview. SAS 9.

Databases: MS SQL Server 2000/2005/2008/2008 R2/2012, MS Access 2000, Oracle 11g/10g/9i/8i/8.0., Teradata, Netezza, MongoDB

Programming Languages: SQL, TSQL,PL/SQL, Java, C and C++

Operating Systems: UNIX, Linux, Ubuntu and Windows

Testing Tools: Quality Center, Toad, IBM RQM ( Rational Quality Manager) Jira, Bugzilla

Web Services & XML: SOAP, WSDL, XML, and XSLT

Scripting Language: JavaScript, JQuery, R programming, Python

WORK EXPERIENCE:

Confidential, ATLANTA, GA

TABLEAU DEVELOPER/ADMIN

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.
• Optimized Indexes, Views, Stored Procedures and Functions using T-SQL.
• Created Schedules and Extracted the data into Tableau Data Engine.
• Building, publishing customized interactive reports and dashboards, report scheduling on Tableau server.
• Implemented action filters, parameters, calculated filed and set 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.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Developed 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.
• 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.
• Developed parameter and dimension based reports, drill-down reports, charts, and Tabular reports using Tableau Desktop.
• Experience with formatting styles including Annotations, Layout Containers, Mark Labels, Rich Text Formatting, and Shared Encoding.
• 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.
• Extensively worked on Tableau Desktop, by creating Complex reports & Dashboards.
• Created 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.
• Created procedures to ensure the quality, usability and accuracy of reports.
• Create Packages to group logically related column types and to transfer data.
• Design both logical and physical data models in Erwin.
• Used Jira for assigning and raising an application bugs

ENVIRONMENT:: MS SQL Server 2012, Tableau Desktop, Tableau Server, Microsoft Visual Studio, Oracle 11g, SQL Server Management Studio 2010, MS Excel, T-SQL, ERWIN.

Confidential, ST.LOUIS, MO

TABLEAU DEVELOPER/ADMIN

RESPONSIBILITIES :

• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Implement info graphics and Dash boarding for data visualization.
• Interact professionally with a diverse group of professionals in the organization, including managers and executives.
• Designed and developed Netezza data structures.
• Experience in standardizing Tableau for shared service deployment.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development, assisting users in creating and modifying worksheets and data visualization dashboards.
• Involved in license management SLA’s with Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Experience in converting OBIEE content into Tableau BI content.
• Experience in providing Tableau server and tableau desktop training.
• Experience with Teradata.
• Experienced with trouble shoot of Teradata connection.
• Tested reports and uploaded tableau dashboards onto server and provided production support for tableau users.

ENVIRONMENT: S: Tableau server/Administrator, Tableau Desktop v6/v7, Windows Server Standard R2, Oracle 11i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL.

Confidential, NEWYORK

TABLEAU DEVELOPER/ADMIN

RESPONSIBILITIES:

• Worked as a Tableau admin/developer, in charge of the report development and maintenance
• Independently worked on owning IT support tasks related to Tableau Reports on Server.
• Built and maintained many dashboards.
• Training classes to the employees on Tableau Software.
• Creating dataflow diagram and documenting 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.
• Created Backup scripts to take periodic backups for the content on Tableau server .
• 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.
• Developed SQL Server Impersonation for Impersonation Requirements, How Impersonation Works,
• 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 (Version 5.2.4 - Version 6.0.9), Tableau Server (Version 5.2.4 - Version 6.0.9), Microsoft SQL Server 2008R2 Enterprise Edition, Windows 2003 Server, Tomcat, Microsoft Visual Studio, ERWI

Confidential

TABLEAU DEVELOPER

RESPONSIBILITIES:

• Worked directly with Business Lines in Customer Care, Loans, Management Information Systems, Card Management to gather dashboard requirements for development.
• Experience with creating Worksheets and Dashboard.
• Experience with Tableau for Data Acquisition and data visualizations.
• Hands-on development assisting power users in creating and modifying worksheets and data visualization dashboards for departmental consumption.
• Upgraded Tableau 7.0 environment to Tableau 8.0.
• Worked on Bar charts, line Charts, combo charts, heat maps and incorporated them into dashboards.
• Experience with Sorting, Building Groups and using in visualizations.
• Documented a whole process of working with Tableau Desktop, installing Tableau Server, evaluating Business Requirements and proposing System Requirements.
• Worked extensively with Date, String and Logical Functions.
• Created Inventory trends, sales integration and forecast accuracy related dashboards
• Worked closely with ETL team for various Data sources issues
• 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.
• Used ETL efficiently for complex joins of various scenarios
• Provided User training for the various dashboards.
• Worked with ETL team for performance improvement using custom SQLs.

ENVIRONMENT:: Tableau Server 8.0.3/7.1/6.0, Tableau Desktop 8, MYSQL Server, MS SQL Server 2008, TSQL, UNIX, Linux RHEL 5.4.Tableau 7.0, Informatica 9.1, Hyperion (Oracle), SQL, Oracle 10g, Teradata’s.

Confidential

SQL DEVELOPER

RESPONSIBILITIES:

• Created T-SQL scripts to generate all the tables and relationships based on the finalized ER-Diagram.
• Created Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by a front end application.
• Utilized the Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Created database documentation for table and column dictionaries and other reference material.
• Implemented indexes on tables and views for optimum performance tuning.
• Involved in dimensional data modeling and story boarding ETL processes.
• Designed the ETL process using SQL Server 2000 DTS Packages as well as SQL Server 2005 crystal Packages which the data sources include Flat files, Access, Excel.
• Responsible for identifying sources, creating staging database, data warehouse dimensional modeling (Facts and Dimensions).
• Involved in the creation of scheduled jobs for Extracting, transforming and loading operations and database maintenance tasks like de-fragmentation, re-indexing, and recompiling.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Optimized the existing queries to improve performance with the use of Profiler and Execution Plans.

ENVIRONMENT:: MS SQL Server 2008 R2/ 2005, SQL Server Management Studio, Crystal Reports 2008 XI.