PROFESSIONAL SUMMARY:

• 8+ years of experience as Data Analyst and Tableau Developer in Software Design, Development, Integration, Implementation and Maintenance of Data Warehousing and Database applications in Banking,Finance and Wholesale and Semi - conductor industries.
• 4+ years of extensive Tableau Experience using Tableau 10.x/9.x/8.x/7.xas a Developer and Analyst.
• In-depth knowledge on Tableau Desktop, Reader, Server, Online &Tableau Public.
• Highly proficient in Agile , Test Driven , Iterative , Scrum and Waterfall Software Development Life Cycle (SDLC).
• Organized numerous Joint Application developments (JAD), Joint Requirement Planning sessions (JRP), Interviews, workshops and Requirement Elicitation sessions with end-user/clients/stake holders, Subject Matter Experts and the technology group.
• Good experience in publishing of various kinds of interactive dashboards, and workbooks from Tableau Desktop to Tableau Servers.
• Highly proficient in design and development of prototype reports/ dashboards in Tableau during the requirement gathering phase to visualize the reports and clarify requirements.
• Experienced in creating filters, quick filters, data source filters global filters, context filters, user filters, actionsand creating Dashboards for key performance indicators.
• Expertise in developing Reports / Dashboards with different Analytics Views (Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Column Sector) using Presentation services.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights into the available data.
• Excellence in data mapping at Excel Macro’s, participated in various trainings which helped me to work on Excel Macro’s.
• Actively published the dashboards and controlled the data security at Tableau server level.
• Assigned to maintain the Tableau product license keys.
• Created different order tracking dashboards based on dynamic requirement.
• Created the Architecture for over lay and data migrate from Excel data source to BOARD database.
• Provided Knowledge transfer (KT’s) to the team back in Offshore and client service managers.
• Excelled in performance at different client locations with the interactive dashboards presentations.
• Experienced in creating Quick Table Calculations, Static and Dynamic sets, Parameters and Level of Detail using advanced logical and statistical functions in Tableau Desktop.
• Experienced in URL Actions, passing parameters from Tableau to web applications.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases and client/server applications.
• Extensive experience in using Tableau (Desktop/ Server), Teradata, Java Script API, SQL Server, Oracle11g.
• Good Knowledge in writing SQL, for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
• Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS:

BI Tools: Tableau (Desktop/Server/Mobile/Public) 10.0/9.x/8.x/7.0,Qlik View, SSRS

Databases: SQLServer,Oracle,DB2,Teradata,Greenplum, BOARD

Operating Systems: Windows Server 2008,Windows NT, Unix, Linux.

Programming Skills: Javascript, HTML, C++, PL/SQL

ETL Tools: Alteryx, Informatica, SSIS

Data Modeling: Erwin, ERStudio, Visio.

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Tableau Developer/Data Analyst

Responsibilities:

• Gathered Business Requirements, Interacted with the Users.
• Worked with business partners and Server Side BI engineers to rigorously define, implement and further develop metrics and key performance indicators.
• Have extensively worked in AGILE environment by participating in daily stand up meetings, and Sprint planning at the end of every Sprint.
• Wrote custom SQL queries to optimize the extracts, and heavily relied on data blending as the end workbooks ultimately required multiple fields from different data sources.
• Developed dashboards analyzing call handing forecasting, call rate, call waiting time, and call forward, average call time using Tableau BI.
• Generated data extracts in Tableau by connecting to the view using Tableau MySQL connector.
• Configured data extraction and scheduled refreshes both incremental and complete refresh depending on the data to improve performance of Tableau reports.
• Built dashboards with floating objects and capitalizing the various dashboard actions features like URL, images, web integrations.
• Structured the dashboard with a consistent layout with visuals chart at the top and corresponding crosstab data and the bottom.
• Customized the tooltips and labels, to user understandable format, the numerical measure was changed to its appropriate formats.
• Involved in major integration with web applications using JavaScript API, REST API.
• Designed functionality to Consolidates structures into a single tree hierarchy filter.
• Developed filter Functionality which allows Users to apply filter selections at one time.
• Provided work flow process which exports dashboards in a ready to present format.
• Created Tableau Server landing page to give user quick access to their most recently accessed reports.
• Connected to Tableau Postgre SQL database to create customized interface for Tableau workbooks to provide native style navigation.
• Implemented Tableau out of Box (OOB) feature functionalities for the web frame work.
• Created Warm Caching for the Tableau Dashboards after the integration done to web application.
• Worked on the new concepts like Churn Mechanism and formatted commentary on a Tableau dashboard.

Environment Tableau 9.1/8.3(Desktop/Server), Oracle, MySQL, Toad, SQL Developer, JIRA, Asp.Net, JavaScript.

Confidential, Santa Clara CA

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Creating and modifying Business Intelligence analytical reports using Tableau.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Core development on tracking the manufactured semi-conductor from ship date to customer CAR Closed date.
• Developed OTC Vision, Performance of Front-End and Back End (OP10 to RCTD). OTC Cycle Time and different other dashboards.
• Excellence in creating the macros on the updates received for data and tracking the data.
• Developed many successful prototypes on Order to Cash (OTC) Forecasting and executed to several customers.
• Created and worked on securing the Order Management Dashboards on the Tableau server security level (100+ Dashboards).
• Created New POC’s on the Tableau global filters and Excel Macro’s.
• Created the Performance and Manufacturing dashboards which helped the customers to track the entire OP Milestones in a single interactive dashboard.
• Created Excel Macro’s to dynamically control the updated data flow.
• Extensive use of Rally software tool to manage agile development, creation of user stories, estimates and updates. Viewing the burn down charts and other reports, updating the team in meetings.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Worked on Business Intelligence standardization to create database layers with user-friendly views in Oracle that can be used for development of various Tableau reports/ dashboards.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Effectively used data blending feature in Tableau to connect different databases like Oracle, MS SQL Server.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc.
• Worked on Performance tuning of report using concurrent query execution for better performance of report.

Environment: Tableau (Desktop/Server) 10.0/9.3,8.2, Oracle 11g, ERwin, SQL Server, Toad, SQL Developer, Agile-Scrum, Rally, JavaScript, Confluence.

Confidential, Raleigh, NC

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Creating and modifying Business Intelligence analytical reports using Tableau.
• Major integration with web applications using JavaScript API, Asp.Net and IIS Server.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Core member for integration of Tableau Reports with Asp.Net web application and usage of JavaScript API for performance improvement.
• Extensive use of Rally software tool to manage agile development, creation of user stories, estimates and updates. Viewing the burn down charts and other reports, updating the team in meetings.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Worked on Business Intelligence standardization to create database layers with user-friendly views in Oracle that can be used for development of various Tableau reports/ dashboards.
• Analyzed dimensional and fact tables in a campaign data mart that details Inclusion, exclusion and Segmentation criteria, Offer assignment and campaign response by campaign.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Effectively used data blending feature in tableau to connect different databases like Oracle, MS SQL Server.
• Worked on drill through reports by creating HTML references.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends at various geographic locations.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Usage of Context, SQL filters to improve performance and different date filters to show the details for different quarters and years.
• Actively tracking schedule, clear and crisp communications with key resources, stakeholders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau 8.2/8.1/7.0, Tableau Server 7.0/8.0, ERwin, Oracle 10g, SQL Developer, Agile-Scrum, JavaScript, SVN

Confidential, San Francisco, CA

Tableau Developer / Data Analyst

Responsibilities:

• Identifying and gathering user requirements and business requirements from different groups, end users for developing reports
• Designed and developed Tableau Dashboards for critical Projects, i.e. CEO Scorecard & OBIEE to Tableau Reports Conversion. Particularly CEO scorecard, for which the scope of Workbook included 10+ dashboards.
• Performing yearly analysis and business risks using different line charts.
• Analyzing the future trends and provide business ideas to manage wealth, investments.
• Designed Ad-Hoc reports across various verticals as per the Business Users requirements. e.g.: Bookings, Sales, Quoting, Cases, and Opportunities.
• Creation of ER diagrams and database design for the project.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Creation of tableau users and testing with different security levels for web authorization and authentication.
• Exploring tableau 8.0 features for web editing and authoring, filters and server monitoring.
• Generated tableau dashboards for sales with forecast and reference lines.
• Build and publish Tableau reports utilizing Data Blending, multi-level hierarchy, Table Calculations, Parameters, Graphs and Actions.
• Tableau advanced charts using geo maps, Gantt charts, Pareto charts, scattered plots for providing multidimensional views.
• Key integration with web applications and resolving ticketing server issues with IIS.
• Smoke testing for all the business scenarios in Dev and Pre Production servers.
• Integration of tableau reports with web application and viewing reports online.
• Created a POC project to decide Tableau or QlikView for given requirement. Good working knowledge on QlikView 10 Desktop.

Environment: Tableau Desktop 7, Tableau Server 7, Tableau Server 8,QlikView 10, Oracle 10g, SQL, Clear Quest (CQ), Kiln, Asp. Net, IIS ServerQuest (CQ), Kiln, Asp. Net, IIS Server

Confidential, New York City, NY

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Prepared BI Interactive Dashboards using calculations, parameters in Tableau.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Deep experience with the design and development of Tableau visualization solutions.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server
• Configured different data sources using Tableau Desktop
• Created best visualizations reports as per the business requirements using Tableau desktop professional edition.
• Blended data using multiple data sources (primary and secondary).
• Expertise in Tableau Actions used to navigate between sheets or URLs, highlight or filter.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Extensive experience on creating trend reports including forecast and trend lines.
• Configured incremental data refresh for the data sources.
• Good working knowledge on Tableau administration for creating users, groups, sites and access control.
• Configured AD security using tableau server.
• Responsible for authorizing the users based on their privileges.
• Involved in migration activities related to Tableau across the environments.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.
• Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environment: Tableau Desktop/Tableau server, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft Office.