SUMMARY

• Over 5+ years experience in BI using Tableau and Tableau Server, Spotfire etc.
• Experience on Tableau Desktop, Reader and Server, Mobile, Public. (Tableau versions 7 / 8 / 9/10)
• Analyzing and acquire experiences into large data sets, create visually compelling and actionable interactive reports and dashboards.
• Professional expert in Data Visualization development using tableau to creating complex, intuitive and dashboards.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines. Groups, hierarchies, set to create a detail level summary report and Dashboard using Tableau’s Advanced Capabilities.
• Experienced in using R Programming, SAS, Python, Tableau, Spark, Active Directory and Power BI for data cleaning, data visualization, risk analysis and predictive analytics.
• Strong Knowledge and hands on experience of SDLC methodologies and Business Process Models (BPM) like Agile Modeling and Waterfall model.
• End to end experience in designing and deploying data visualizations using Tableau.
• Development of various dashboards and create reports utilizing Tableau 10.1.
• Knowledge in retrieving data from different databases like ORACLE, SQL, My SQL, MS Access, DB2 and Teradata.
• Experienced in creating Tables, Views, Indexes, Triggers, good knowledge in SQL joins, sub queries.
• Good experience in Database skills with testing complex SQL & PL/SQL queries.
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server
• Having knowledge of ETL tools like Informatica and all Informatica Designer tools
• Experienced in data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services
• Reputed for dedicated teamwork, high - energy with solid work and commitment to achieving various goals and key objectives as set forth by senior management of the company.
• Knowledge in Microsoft Office Suite, Include Microsoft Word, Excel, Access, PowerPoint, Outlook, and Project.
• Excellent Organizational, Teamwork, Presentation and Interpersonal Skills.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, SQL server 2008,Teradata

Data Visualization: Tableau 10.4, 2018.3, Spotfire 7.14

RDBMS Tools: TOAD, SQL Developer, SQL Plus, MS SQL Management Studio

Reporting Tools: Crystal Reports, Dashboard, Tableau reports, Spotfire Reports

Scripting: Python, JavaScript

Other Tools: Control - M, Autosys, TIDAL, Secure FTP(SSH), MS Excel, Notepad++, BMC(Pak 2000)

Operating Environment: Windows/Mac-OS/ UNIX

PROFESSIONAL EXPERIENCE

Confidential, San Dimas, CA

Tableau Developer

Responsibilities:

• Worked with Supply Chain Data and building Adhoc reports on the fly for upper management as and when needed.
• Co-ordinated with cross functional teams to understand user requirements, develop user stories and convert them into visualizations on tableau.
• Worked with large amount of data using live and Extract connection.
• Worked with Tableau Desktop, Tableau Reader and Tableau Server.
• Done Unit, System and User Acceptance Testing and Performed Data Validation.
• Generated dashboards from various database sources.
• Served as a primary point of contact for Production Support issue resolution.
• Extensively worked with formatting the reports according to the user requirements.
• Created MicroStrategy schema objects and Application Objects.
• Designed and developed reports through SSRS and Excel
• Involved in migrating the dashboards from Development to Production environments.
• Documented the entire effort. The documents generated during the process were User Requirements Specifications, Peer Review Log, Design Specifications, Validation Plan, Validation Summary Reports, Release statement, Production Approval Form and Project planning documents.
• Analyzed and documented process along with quick resolutions for typical issues in production and which were critical to the process.

Environment: Tableau 2018.3, Tableau Prep, Oracle 11G , Iron Python, JavaScript.

Confidential, Pleasant Hill, CA

Tableau Developer

Responsibilities:

• Gathering the requirements from business team and transmuting them into technical architecture and design documents.
• Involved in estimation, analysis and solution documents.
• Strong experience in creating sophisticated visualizations, calculated columns and custom expressions.
• Developed Map Chart, Cross table, Bar chart, Tree map and complex reports which involves calculated fields, hierarchies and parameters.
• Created Complex queries to pull the data from Oracle 10g/11g.
• Wrote SQL Queries on Oracle and DB2.
• Created the Materialized views on the aggregate functions and used that in the reports.
• Created reports using complex calculations and variables.
• Generated and implemented MicroStrategy reports by creating projects, Attributes, Hierarchies, Metrics, Filters, and Templates.
• Scheduled Tableau Extracts, working with Multiple Data sources using Data Joining and Data Blending.
• Created various complex SQL Queries, Stored Procedures, and User Defined Functions to implement the Business logic.
• Developed Dashboard reports for Project portfolios which help in better analysis for decision making using Tableau.

Environment: Tableau 10.5, Tibco Spotfire 7.14, Pipeline Pilot, Teradata , Python.

Confidential, Costa Mesa, CA

Tableau Developer

Responsibilities:

• Created Tableau dashboards using Stack Bars, Bar Graphs, Scattered Plots, Geographical maps, Gant Charts using show me functionality.
• Created Complex workbooks and Dashboards in Tableau by connecting to multiple data source (Teradata) Using data blending.
• Created worksheets and dashboards by using custom queries and multiple tables.
• Extensively used Action Filters and Extract Connections to Develop Dashboards
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Worked with extract, manipulate and built complex formulas in Tableau for various Business calculations.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard,
• Hyperlink Objects, Color-coded tabs etc. in Tableau 8.1 desktop/Server
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.

Environment: Tableau 10.2, Windows 2008 server, SQL Server 2008, SSIS.

Confidential, San Francisco, CA

Tableau Developer

Responsibilities:

• Blended Data from multiple databases into one report by selecting primary keys from each database for data validation.
• Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies etc.
• Created complex views in SQL Server 2008 to use as data sources in Tableau Reports and Dashboards.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF etc.
• Reconciled the report data with the source systems and reviewed it to find any data anomalies.
• Migrated Excel reports to Interactive Tableau Dashboards.
• Developed quarterly reports which compare the hiring activity parameters from the previous quarters in a fiscal year.
• Involved in administrative activities, doing deployment and monitoring schedules and jobs.
• Combined multiple dashboards into single story to enhance the visual appeal of the report.
• Interacted with business users and performed Gap analysis on Client requirements.
• Designed and developed various analytical reports from multiple data from different connections together on one dashboard and to filter data in multiple views at once.

Enivronment: SQL Server, SQL, Tableau Desktop 8.3, Tableau Server, MS Office Suite, Microsoft Azure, MS-Excel.

Confidential

Tableau/BI Developer

Responsibilities:

• Took responsibility in building reports in Tableau from the Scratch and data analysis as well.
• Used to connect different data sources like SQL DB (SQL Query), Web Trends to Power BI and generate reports with different visualizations.
• Reviewed business requirements and analyzed data sources from Excel/Oracle SQL Server for design, development, testing and production rollover of reporting and analysis projects within Tableau Desktop.
• Defined best practices for Tableau report development.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Distributed Tableau reports using techniques like Packaged workbooks, PDF etc.
• Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies etc.
• Created custom date time calculations and macros in reports.
• Created views in Tableau Desktop that were published to internal team and further data analysis and customization using filters and actions.

Environment: Tableau Desktop and Tableau Server, Tibco Spotfire 5.5, Windows 2008 server, SQL Server 2012