SUMMARY

• 8+ years of extensive experience in Data warehousing and Business Intelligence technologies across various domain using Tableau Desktop, Tableau Server, Talend and Business Objects reporting suite.
• Experience in interacting with Business Users in analyzing the Business Process requirements and transforming them into documenting, designing, and rolling out the deliverables.
• Strong Dashboard design experience and passionate practitioner of effective data visualization.
• Mastered the ability to design and deploy rich Graphic visualizations Parameters using Tableau.
• Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
• Responsible for Client Delivery and Solution Design.
• Monitored, reviewed and suggested corrections for the reports developed by team.
• Expertise in data cleansing for analysis, perform data quality testing.
• Created solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Also used various versions (8, 9) of Tableau Reader, Tableau Public, and Tableau Server along with Tableau Desktop.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Hands on experience in installing, configuring, managing, upgrading, monitoring Talend.
• User access management using TAC (Talend administration center) in Talend.
• Have been working with various data sources such asOracle, SQL Server, Teradata, ODBCand flat file sources.
• Involved inTroubleshooting, Performance tuning of reportsand resolving issues within Tableau Server andReports.
• CreatedTableauData Extracts for making visualizations perform better.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server
• Mastered using Filters, sorts, groups and Sets, reference lines in different kinds of charts.
• In depth knowledge in Tableau advance analysis features like Actions, Calculations, Parameters and Trend lines.
• Designed and deployed reports with advanced features such as drill down, drill up and drop down menu options and parameters.
• Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and keen to learn.
• Capability to tell a story through dashboards using various sets of data.
• Strong analytical, logical, communication and problem solving skills and abilityto quickly adapt to new technologies by self - learning.
• Practical understanding of the Agile Methodology, Data modeling (Dimensional & Relational) concepts like Star, Snowflake Schema Modeling, Fact and Dimension tables.
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirements
• Knowledge on AWS (Amazon Web Services).
• Involved in Gathering/ analysis, Design, Development, Testing and Production rollover.

TECHNICAL SKILLS

Operating System: Windows 98 / 2000, Windows XP

BI/Visualization Tools: Tableau Desktop 8.x/9.x, Tableau Public 8.1/9.x, Tableau Reader 8.x/9.x, Tableau Server 8.x/9.x, Qlikview 11, Talend 5.5

Programming Languages: TABLEAU, SQL, PL/SQL

Databases: Oracle, MS Access

Application Software: MS Excel, MS Word, MS Power Point, Microsoft Visual Studio

PROFESSIONAL EXPERIENCE

Tableau Architect

Confidential

Responsibilities:

• Been the SPOC (Single Point of Contact) to customers in the Business Intelligence (BI) and Data Warehousing (DWH) space on SRS, Report development.
• Gathered the requirements and made list of reports client needs going forward
• Architecting and building Analytics Rapid Deployment Solutions.
• Responsible for Client Delivery and Solution Design.
• Involved in creating dashboards by extracting data from different sources.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Installation and configuration of Talend.
• Interact with Talend support to resolve product specific issues.
• Used ETL especially Talend 5.5 process to Extract, Transform and Load the data into data warehouse.
• Used TAC (Talend Administration Center) for admin activities in Talend.
• Used Talend to extract data from various sources.
• Created dashboard using parameters, sets, groups and calculations in Tableau.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Created calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axes bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server
• Extensively used data blending in Tableau.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Created report schedules, data connections, projects, groups in Tableau server.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: s: Tableau Server v8/v9, Tableau Desktop v9/v8, Talend 5.5, Oracle

Tableau Lead

Confidential, Edison, NJ

Responsibilities:

• Requirement Analysis and data-extraction from heterogeneous data sources.
• , development of Metadata modeling reports and dashboards using Tableau 8.3
• Integrating the web-based application with Tableau 8.3 server
• Created Tableau extract files for improving the performance.
• Providing insights on the Dashboards.
• Participation in Quarterly Business Reviews.
• Development of Sales, Marketing, Finance, Operations and Infrastructure Reports in Qlikview11.0.
• Propose workflows and data structures& Design mock-ups and templates.
• Evaluate customer needs effectively and evidence of using good judgment.
• Worked with a dynamic and demanding environment where expectations for performance and productivity are high.
• Integrating trusted authentication services to enable single sign-on using LDAP credentials.
• Load testing using Qlikview Scalability and Tableau Server Testing Environment.
• Used different Mark types and Mark properties in views to provide better insights into datasets.
• Created various types of charts to provide better visualization.
• 5 weeks of hyper-care sustain post production release.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Using Tableau Desktop created interactive reporting dashboards by combining multiple views.
• Published views and dashboards in Tableau Server for auditor review.
• Documenting Technical and Functional specifications.
• Completion and certification of modules from Compliancewire.

Environment: Tableau Desktop, Tableau Server, Oracle SQL Server, MS Excel, MS Access, Windows Server 2008 R2

Confidential, Bellevue, Washington

Responsibilities:

• Development of Sales, Marketing, Finance, Operations and Infrastructure Reports in Qlikview11 and Tableau 8.2
• Metadata modeling. Development of Reports and Dashboards using Tableau 8.2
• Tableau 8.0 to implement advanced forecasting and analytics.
• Coordinating with client COE team in data validation and understanding feasibility of Tableau in the business
• Validating data and used case scenarios
• Integrating the web-based application with Tableau 8.0 server
• Load testing Tableau Server Testing Environment
• Google Analytics integration for fetching online sales reports and analytics
• Documenting technical specifications

Environment: Tableau Desktop, SAP BO, Tableau Server, Talend, Qlikview11, Windows Server 2008 R

Confidential

Responsibilities:

• Tableau Workbook design
• Preparing Dashboards using calculations, parameters in Tableau
• End to end data modeling, dashboard designing and deploying data visualizations using Tableau.
• Tableau Server-side and row-level security.
• Developing proof of concepts and architecting solutions with focus on security, high availability, trade-offs etc.
• Tableau Administration, capacity planning, failover recovery.
• Tableau Server upgrade.
• Used TAC for Talend admin specific tasks.
• Scheduled jobs in Talend.
• Managed user access in TAC.
• Design, plan, installation, configuration, and administration of the Talend for Big Data Platform
• Troubleshooting, debugging & fixing Talend specific issues.
• Interact with Talend support to resolve product specific issues Capacity planning of the Talend complex working on Technical/Functional enhancements if required.
• Apply fixes, patches and Service Packs to keep the Talend environment up-to-date. Troubleshooting, debugging & fixing Talend specific issues.

Environment: Tableau Desktop, Tableau Server, Talend

System Analyst

Confidential

Responsibilities:

• Involved in requirement analysis by interacting with analysts for the creation of Data marts.
• Involved in Administration tasks like creating users, assigning privileges, caching and Report optimization.
• Played an important role in coordination with the entire team and managing the time estimates for the entire project.
• Back up of metadata and restoration of metadata.
• Resolved many Production support issues
• Used Transformations to perform time series analysis over various phases and also to calculate the variance and the growth percentage trends.
• Involved in architecting Facts columns and development of hierarchies with related attributes required for reporting.
• Extensively worked in developing Metrics and compound metrics, filters for complex reports.
• Implemented security for different users to view reports for their regions using security filters.
• Thorough research was done for required components, generated status reports to discuss issues related to Warehouse tables, Metadata platform, missing columns and naming conventions etc.
• Performed System testing, Unit testing
• Used Quality Center to track of incidents and defects that are assigned and created.

Environment: Tableau Desktop, SAP BO, Tableau Server, Talend, Qlikview11, Windows Server 2008 R

Confidential

Responsibilities:

• Interacted with the Business Users and Supervisors to gather business requirements.
• Converted the User Requirements into Business Requirements Document, Functional andTechnical Requirements Documents
• Created Business Process Models from the requirement specifications.
• Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server 2005, and MS Access databases
• Involved in Partitioning tables that have bulk inserts, deletes and updates to improve the performance.
• Installed and managed MS SQL Server 2005.
• Extracted data from xml and flat files using SSIS
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS.
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing
• Designed, programmed, deployed and tested the requested Reports.
• Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application database Tables, along with checkpoints for testing verification.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Analyzed long running queries and tuned the complex queries to optimize application and system performance.
• Developed user test cases and validated test results during user acceptance testing.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.

Environment: MS SQL Server 2005, SQL Server Integration Services (SSIS), SSRS Import & Export Data, SQL Reporting Services,XML.