SUMMARY:

• Senior Tableau/BI Developer with 8+ years of IT experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence Reporting using various versions of Tableau 6.x/7.x/8.x/9.x/10.x and SQL Server.
• Over 6 years of Experience in Tableau Desktop and Server, creating highly interactive Data Visualization Reports and dashboards using Data Blending, Extracts, Calculation Fields, LOD, Filters, Actions, Parameters, Context Filters, Sets, Groups, Aggregate measures, Page Trails etc.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements.
• Extensive Experience using R and Python (Tabpy) to perform Predictive/Statistical Analysis.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards and Tableau suite.
• Experience in developing multiple dashboards/reports using various charts like Stacked Bar/Pie, Line/Area, Donut, Dual - axes charts, Geo-Maps, Bubble, Scatter and Heat Maps.
• End to end experience in Installation and configuration, designing and deploying rich graphic visualizations with Drill Down and Drop-down menu options using Tableau.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Experience in TABCMD & TABADMIN, Email alerts, scheduling, data backup, SAML and driver’s setup activities and Performed Load and Performance Testing using Tab Jolt.
• Hands-on experience in Trouble Shooting, Performance tuning of reports and resolving issues in Tableau Server and Reports.
• Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multitier environment.
• Experienced performing data modeling using Alteryx and Informatica.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Experience in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Experience in writing complex SQL queries and Stored Procedures involving multiple tables joins.
• Experience in working with Relational databases such as MS SQL Server 2012/2008R2/2008, Oracle 12c/11g/10g, DB2, Teradata, Salesforce, Microsoft power pivot and MS Access.
• Excellent Verbal & Written Communication skills and strong in Documentation.
• Extensive experience in Agile/ Scrum methodologies.

TECHNICAL SKILLS:

OLAP/DDS Tools: Tableau Desktop/Server, SAP Business Objects, SSRS, Crystal Reports, SAP Dashboard Designer, Spotfire, Alteryx.

RDBMS: MS Access, MYSQL, SQL Server 2005/2008/2012/2014 , Oracle 11g, 12C, IBM DB2, Teradata, Netezza.

ETL: Informatica Power Center 9.5, SISS.

Web Technologies: Java, C, HTML, PHP Commerce

Data warehousing: Data Modeling, Normal forms (OLTP), Star Schemas (OLAP), Snow Flake Schemas, and slowly changing dimensions.

Industries: Financial/Banking, Manufacturing, Healthcare, Insurance and Retail Industry Experience.

Language: PL SQL, T - SQL, ANSI 89, ANSI 92, Stored Procedure, Python, R, Free-hand SQLOthers: JIRA, SharePoint, TOAD, Data Analyzation, ALM, Microsoft Word, Power Point, Excel, Access and Outlook.

PROFESSIONAL EXPERIENCE:

Confidential - San Antonio, TX

Senior Tableau Developer

Responsibilities:

• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Responsible to Create Dashboards for compliance reports, treasury reports, Daily P&L reports for Client and internal management using Tableau Desktop and Server.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Built dashboards using techniques for guided Analytics, Interactive dashboard design and Visual best practices.
• Also, involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
• Experience in efficiently using standard Business Content, extending and enhancing according to the report requirements.
• Created dashboards using Excel and Microsoft SQL server data sources.
• Involved in trouble shooting of performance issues which were associated with Tableau Reports.
• Good understanding of business environment, excellent communication skill and ability to work proactively in a fast-paced environment.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau Desktop.
• Worked directly with business users to build reports, dashboards.
• Worked in all phases of full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training.
• Used Tableau API such as Python and Web Data Connector and Performed Predictive Analysis.

Environment: Tableau Desktop 9.1/10.5, Tableau Server, Oracle, Tab Jolt, MySQL, Hadoop, Cloud database, Salesforce, Microsoft PowerPivot, Pivotal HD, HDFS, Microsoft SQL server 2012, MS Excel/Access, Windows 8.

Confidential - Center Portsmouth, OH

Senior Tableau Developer

Responsibilities:

• Served as Tableau Developer meeting deadlines and budget requirements.
• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• 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.
• Created interactive dashboard and applied filter, highlight and URL actions to the dashboard.
• 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.
• Mentored Power users in creating and modifying worksheets and data visualization dashboards.
• Involved in license management SLA's with Tableau support.
• Provided 24/7 production support for Tableau users.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using. Key Performance Indicators (KPI) and Measures.

Environment: Tableau Desktop 8.3/9.0, Tableau Server, MS SQL Server, Oracle, Hadoop, SAP HANA, Informatica, Teradata, Salesforce, Windows 8, MS Excel/Access, SSIS, SSRS.

Confidential - Mc Lean, VA

Tableau Developer

Responsibilities:

• Involved in requirement s gathering for the development in Tableau.
• Worked with SAP BW team to understand the data extensively.
• Involved in building financial reports in Tableau to have nice look and feel.
• 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.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Designed and developed Tableau Dashboards using stack bars, bar graphs, scattered plots, Gantt charts.
• Created SQL Queries for testing the Tableau Dashboards.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau.
• Blended data from multiple databases into one report by selecting primary keys 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.

Environment: Tableau Desktop 8.3, Tableau Server, MySQL, SharePoint, Microsoft SQL Server, Windows, Microsoft Visual Studio, ERWIN, SSIS and SSRS.

Confidential - New York, N.Y

Tableau Developer

Responsibilities:

• Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Created Global Filters and applied for all the views in the dashboard.
• Created Data Source and published into the server for other users.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Developed parameter and dimension-based reports, drill-down reports, charts, and Tabular reports using Tableau Desktop.
• 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.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Extensive experience in using URL's, Hyperlinks, Filters for developing Complex dashboards.

Environment: Tableau 6.0/7.0, Tableau Server, Oracle, SQL, Share Point, Agile-Scrum, Vertica, Windows2003.

Confidential - New York, N.Y

BI Developer

Responsibilities:

• Developed Tableau Dashboards for app usage data based on login time status, usage of pay bill capability, and transfer money to get better understanding of future enhancements.
• Involved in end-to-end implementation and enhancements on Mobile Banking App data starting from requirement gathering and dashboards development in Tableau Desktop.
• Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
• Created numerous dashboards in Tableau Desktop based on the data collected from Mobile Banking
• App by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
• Created Crosstab's to display underlying data based on various graphs and charts created for further data analysis.
• Worked with the design and development of end user applications for the data presentation and analytics, including dashboards, reports and graphic presentation.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to date information.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups

Environment: MS SQL Server 2008, T-SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS Access, Windows.

Confidential - Atlanta, GA

SQL Developer

Responsibilities:

• Worked as developer of a team, responsible for the design and development of an Oracle application.
• Primary responsibilities include - system analysis, coding, debugging and deploying.
• Worked with the project manager to understand the scope of each phase & module and further understand implement the Object Model & Database design specifications, Domain Model.
• Framing the business logic plus code for accessing data stores.
• Develop validation routines for complex business rules and data handling.
• Created numerous forms and reports using Forms and Oracle Reports.
• Worked with various functional experts to implement their functional knowledge into working Procedures.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Used SQL*Loader to load data into Oracle database.
• Troubleshoot performance issues and bugs within packages.

Environment: Oracle, SQL*Plus SQL, SQL* Loader, PL/SQL, Toad, Windows NT 4.0 and 2000, ASP, JavaScript, XML, XSL, XSLT, HTML, Oracle Forms 6i, Reports 6i.