PROFESSIONAL SUMMARY

• 9+ years of experience working in data analysis, data visualization, report design, dashboard development using BI technology and Decision Support Systems.
• Expertise in Tableau Data Visualization tool, SAP Business Objects, Crystal Reports and SAP Dashboard Design.
• Experience working in Media, Financial/ Banking, Health Care, and Manufacturing.
• Experience in attending ad - hoc requests, creating individual sites, projects and managing report-specific and user-specific access, sync users with Active
• Directory Extensively used Tableau to create complex, intuitive, and innovative dashboards and story lines.
• Used rich visualization (like Scatter Plots, Bubble Charts, Geomaps etc) within Tableau to meet business reporting needs.
• Used complex formulas, Calculations, LOD expressions, Hierarchies, Groups, Sets, Filters, Parameters to meet the needs of complex business logic.
• Involved as a SCRUM Master in all phases of SCRUM software development life cycle under agile framework.
• Extensive experience working with SAP Business Objects building universes, Web Intelligence Reports, Crystal Reports and SAP Xcelsius Dashboard Expert in writing FHSQL queries, troubleshooting/optimizing queries, writing stored procedures for data analysis and query reporting.
• Very good understanding of data base modeling techniques, ER Modeling, OLAP/OLTP Data models, Data Warehouse, Data Mart, dimensional modeling design techniques like snowflake schemas, star schema, fact and dimension tables.
• Connected to multiple data sources for reporting such as Oracle, SQL Server, DB2, Tera Data, MS Excel, Flat Files, Tableau Data Extracts (TDE). SDLC /Agile work environment experience.
• Interacted with business users/Analysts, for requirements gathering, business process analysis and business value delivery.
• Self-driven team player with excellent communication and interpersonal skills.

TECHINICAL SKILLS

Tools: Tableau Desktop/Server 10.4/9.3/9.2/9.1/9.0/8.3/8.0 , SAP Business Objects 4.2/4.1/4.0/3.1 , Crystal reports, Desktop

Intelligence, Web Intelligence Rich Client, Dashboard DesignerUniverse Designer Tool (UDT), Information Design Tool (IDT), BEX Analyzer.

RDBMS: Oracle 12G/11G/10G/9.x, DB2/400, SQL Server, MS Access 2000, Teradata, DB2.

ETL Tool: Informatica Power Center 9.5.

Operating System: MS-DOS, Windows 2008/2003/XP/NT/2000 98/95, UNIX, HP- UNIXSun

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

Others: PL SQL, T - SQL, ANSI 89, ANSI 92, Report Tuning, Data miningFree-hand SQL, Data Analyzation, ALM, Microsoft Word, Power PointExcel, Access and Outlook.

Industries: Financial/Banking, Health Care, and Manufacturing.

PROFESSIONAL EXPERIENCE

Confidential, Emeryville, CA

Sr. Tableau Developer

Responsibilities:

• Involved in gathering requirements from the Business Users and produce technical, functional specifications for the reporting system.
• Study and understand the Business Scenarios of the existing systems, understanding the data and validating the data by applying the current business rules
• Results-focused approach with regards to design and development of Tableau software applications to support reporting and Business Intelligence initiatives
• Have improved complex dashboards performance by generating performance report and working on problem areas
• Building executive, adhoc, and custom dashboards and publishing to Tableau server.
• Testing, monitoring performances, cleaning unused dashboards
• Conducting kick off meetings, status calls, walk thru sessions and trainings to business users
• Created best practices, publishing checklists and repository backups etc.,
• Created schedules, Tasks, Groups, Users, Permissions on Tableau server.
• Conducting performance tuning, applying user and data source level securities upon need
• Worked on different Tableau objects like straight tables, line charts, bar charts and pivot tables etc for dashboard design.
• Worked on set analysis and advanced aggregation functions.
• Created dynamic and cascading prompts using Business views
• Effectively used data blending, groups, combine fields, calculated fields, and aggregated fields to compare and analyze data in different perspectives.
• Experience in creating sets, joins,filters, global filters, quick filters, context filters, table calculations, calculated measures and parameters.
• Experience in creating Confidential views in Tableau by different charts such as maps, bars, lines, cross tab, donut, pie and highlight tables
• Creating projects, sites, groups, users, scheduling reports and extract refresh in Tableau as needed
• Executed and tested required queries and reports before publishing.
• Testing reports using review checklists for Quality Assurance before delivering to the end users.

Environment: Tableau 10.4.2 desktop and server, HP Vertica 8.1, Alteryx 11.8, Windows 7

Confidential

Sr. Tableau Developer

Responsibilities:

• Worked with the business on end to end process building dashboards.
• Performed data modelling with big data. Modelling data in Splunk so reports can be generated using tableau.
• Connecting to Azure DW as data source.
• Created Parameter to control reports across different data source in the dashboard.
• Worked on Performance Tuning of Tableau Reports using Extracts, Context Filters and Parameters.
• Perform administrative and support activities across a multi-environment Tableau infrastructure including sites and
• Project creation, troubleshooting and general systems maintenance.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards.
• Created Complex workbooks and Dashboards by connecting to multiple data source.
• Worked with Business Teams to gather requirements and assist them in UAT process.
• Experience writing Custom SQL queries for Complex Tableau Reporting.
• Experience with Scheduling Tableau Extracts, working with Multiple Data sources using data Joining and Data Blending.
• Published dashboard and setting up subscriptions on Tableau Server for usage with operational/Monitoring Dashboards.
• Built Complex Data Functions in Tableau Calculated Fields using Parameters and Sets.
• Built complex formulas in Tableau for Confidential business calculations and also formulas to control URL actions.
• Created Confidential SQL Queries and Views.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Applied the actions in the work sheets and dashboards.
• Execute and tested required queries and reports before publishing dashboards.
• Provide support once the dashboards were published if there were any data changes, system changes, or requirement changes.

Confidential, Dallas, TX

Tableau developer

Responsibilities:

• Responsible for gathering business requirements, worked directly with business units to define requirements and support
• Confidential business initiatives and projects as it relates to analytics and reporting.
• Created Dashboard for Direct TV media campaign based on clicks & conversions from different APIs.
• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Analyzed requirements for Confidential reports, dashboards and created the same using Tableau 10.0/9.2.
• Designed and set up the architecture for Tableau.
• Created multiples sites DEV/QA/PROD and projects within each site for content management
• Tableau user security enablement through windows Active Directory and user groups
• Data blending, preparation using Alteryx for tableau consumption, publishing to Tableau server
• Calculation of member LTV, associating it with Confidential demographic attributes.
• Developed interactive dashboards using table calculations, Pareto, Waterfall, Bar charts, scatter plots and other Tableau features.
• Overseen the performance of Design to develop technical solutions from Analysis documents.
• Provided post implementation production support.

Environment: Tableau (Desktop, Server) 10.0/9.2, SQL Server 2012/2008, Oracle 12g, Windows 7, Informatica, Business Objects 4.1/3.1.

Confidential, Boston, MA

Lead Business Intelligence developer / Tableau developer

Responsibilities:

• Developed dashboards, work books and data views depending upon the business requirements and published in Tableau Server.
• Created actions in worksheets and dashboards for interactivity and to compare data against different views.
• Customized geocoding, created calculated fields and applied filters extensively used data blending, embed functionalities in Tableau.
• Reviewed and evaluated KPI's, e.g. MTD, YTD, WTD, and Rolling 12 Yearly and Monthly Experience in performance tuning of reports in Tableau.
• Wrote SQL queries in IBM Data Studio for unit testing Conducted quantitative and qualitative analysis and developed Strategic,
• Critical to Quality (CTQ) metrics for Senior Leadership for the No. 1 health care insurer in Boston Area.
• Devised an approach to analyze, summarize, and graphically display complex data for senior managers to quickly grasp the key inferences from the data to support strategy and policy decisions.
• Work was recognized by project management and the operational management chain as a major contributor to the achievement of Maximum ROI by $43 million for the evaluation period.

Environment: Tableau Desktop 8.1/8.2/9, Tableau server / Administrator, PL/SQL developer, Oracle 11g, Microsoft Excel 2010, Windows 2007 server, UNIX.

Confidential, NY

Business Intelligence /Tableau developer

Responsibilities:

• Reviewed business user requirements, analyzed data, and designed software solutions in Tableau Desktop in order to show the loan application data.
• Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.
• Created pie and bar charts and combined them into Tableau dashboards to show top content viewed by customers in each loan category, loan purpose.
• Allowing interaction between the two charts for drill down analysis to show yearly performance of the customers and regions based on loan amount, interest income.
• Analyzed data from Confidential databases and formatted it into graphs using Tableau Desktop.
• Created line charts to show over time in a breakdown of daily, weekly, quarterly, and yearly parameter numbers.
• Created sheet selector by using parameters and calculated fields in the dashboards.
• Developing actions (filter actions and URL actions and highlight actions) in dashboard in multiple work sheets.
• Displaying the measures dynamically by using quick filters in Tableau desktop.
• Blended data from multiple databases such as MS Excel and Oracle SQL database by assigning primary key from each databases.
• Displaying the different dimensions for different users as per the client requirement.
• Developing Top N Filters by using Parameters and Quick table calculations and Key Processing Indicators (KPI) for specific views in the Work sheet.
• Migrate Tableau reports from DEV environments to SIT/UAT/PROD by downloading workbooks in dev environment and check in to SVN tool for Release Management team.
• Setup IBM Netezza database connection in Tableau.
• Query Netezza database using NZSQL, Aginity tools to retrieve data from database for troubleshooting data issues in Tableau reports.
• Good experience in Netezza database like creating tables, sequences, synonyms, joins, functions and operators.
• Regression testing of Tableau reports/dashboards for Netezza database upgrade.

Environment: Business Objects 6.X/ 3.1, Business Objects, Designer, Oracle 9i/8i.

Confidential, Richmond VA

Tableau Lead Consultant

Responsibilities:

• Liaison between stakeholders and software development team to gather requirements.
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and then documented them.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server 8.1 in Dev, QA, UAT and Prod environments.
• Upgraded Tableau 8.1 environment to Tableau 8.2 Administered user, user groups, and scheduled instances for reports in Tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• Access dashboards from any browser, tablets or ipad. Created incremental refreshes for data sources on Tableau server.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Converted existing Crystal Reports and Xcelsius into Tableau Dashboards Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Composed documentation related to visualization dashboards and performed end user training.
• Exported the universes and Crystal Reports to the Repository to make resources available for the migration from UAT to Production.
• Making the user resources more flexible as per the business requirement by exporting Universe and Crystal Reports.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau Desktop/ Server 8.1/8.2, SAP Business Objects 4.1/4.0, Crystal Reports, SQL developer, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server.