SUMMARY

• Over 8 years of IT experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Over 5 Years of experience working on Tableau (Desktop, Server), creating various Reports and Dashboards using heat maps, treemaps, circle views, bar charts, lines, pie charts, area charts, box and whisker, Gantts, bubbles and highlight tables, symbol and filled maps according to deliverable specifications.
• Experience in Performance Tuning Tableau reports.
• Developed business critical Interactive dashboards.
• Worked closely with UX and Business teams to deliver the desired functionalities for the reports.
• Experience in Tableau server installation, configuration and enforcing security in Tableau.
• Involved in the deployment activities supporting the software backup and providing extract failure alerts to support teams.
• Integrated the dashboards onto portal by working closely with the UI team.
• Good understanding of Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Teradata, Netezza, AWS Redshift, Hive and DB2.
• Highly Proficient in Agile, Waterfall and Scrum software development life cycle.
• Experience in ETL design, development and maintenance using SQL, PL/SQL, SQL Loader.
• Well versed in query optimization for performance tuning and monitoring of processes.
• Experience working as a BI Consultant with specialization in Business Objects 6.5/ XI3.1 and Web Intelligence.
• Knowledge in building/maintaining Repository, Universes and creating adhoc reports.
• Experience in resolving universe issues like Loops and Traps using Alias and context.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.

TECHNICAL SKILLS

Programming Languages: Confidential -SQL, PL/SQL, XML, HTML, C++.

Business Intelligence tools: Tableau, SSAS, SSIS, SSRS, BO 6.5/XI3.1, Web Intelligence, OBIEE.

Database: SQL Server 2005/2008/2008 R2, Oracle 11g/10g/9i, AWS Redshift, Netezza, TrackWise, Teradata, MySQL, DB2.

ETL Tools: Informatica, Alteryx 9.5/10.

Operating Systems: Mac OS X, Windows XP, Windows NT / 2000, Windows 7, Unix.

PROFESSIONAL EXPERIENCE

Confidential, San Rafael, CA

Tableau Developer/ Administrator

Responsibilities:

• Interact with the business users in gathering and analyzing the requirements.
• Writing custom SQL Queries to develop the reports.
• Created calculated fields, parameters, Context filters and action filters for building dashboards and worksheets in tableau.
• Building Tableau dashboards using stack bars, lines, Pie charts, horizontal bars according to deliverable specifications.
• Building, publishing interactive reports and dashboards, scheduling reports using server.
• Developing and implementing different strategies to improve dashboard performance.
• Defined best practices for Tableau report development.
• Performing Tableau Server Installation, maintenance and upgrades when necessary.
• Involved in the deployment activities supporting the software backup and providing extract failure alerts to support teams.
• Working closely with UX and Business team to deliver the desired functionalities for the reports.
• Integrating the dashboards onto Confidential portal by working closely with the UI team.
• Scheduling ETL jobs using Hive via EMR clusters, spinning and maintain EC2 instances.
• Working on data sources such as Redshift and Hive.
• Scheduled Full refreshes of dashboards depending on the business requirements for data sources on Tableau Server.

Environment: Tableau 9.2/9.3/10/10.1/10.2, Redshift, Hive, Aginity Workbench, AWS, JIRA, Microsoft office 2016, Windows 7 Enterprise.

Confidential, Menlo Park, CA

Tableau BI Engineer

Responsibilities:

• Interact with business subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business needs.
• Built and published interactive reports and dashboards.
• Created calculated fields, parameters and action filters for building dashboards and worksheets in tableau.
• Building Tableau dashboards using stack bars, lines, dual combination, heat maps, tree maps, symbol maps, filled maps, horizontal bars according to deliverable specifications.
• Designed and developed graphic rich visualizations with Drill Down and Drop Down menu option.
• Developed adhoc reports for users.
• Developed dashboards with multiple data by data blending.
• Defined best practices for Tableau report development.
• Involved in automation of jobs in Tableau.
• Worked on data sources such as Oracle and Hive.
• Worked with end users in creating complex dashboards in an iterative process.
• Hands-on experience assisting users in creating and modifying worksheets and data visualization dashboards.
• Scheduled Full/Incremental refreshes of dashboards depending on the business requirements for data sources on Tableau Server.
• Configuring the analysis for scheduling auto emails from Tableau automation.

Environment: Tableau 9.2/9.3, Oracle, Oracle SQL Developer, Hive, OBIEE, Microsoft office 2016, Mac OS X.

Confidential, Bethpage, NY

Tableau/Alteryx Developer

Responsibilities:

• Interact directly with the business team in gathering the requirements.
• Analysis of BRD, design, documentation, estimations and technical specifications.
• Created Tableau dashboards using heat maps, stack bars, lines, area charts, scattered plots, geographical maps using show me functionality.
• Created Groups, Hierarchies, Sets for detail level summary reports and dashboards using KPI’s.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Trend Lines and Reference Lines.
• Effectively used data blending.
• Worked on Motion chart and Drill down analysis.
• Developed Interactive (Dynamic) dashboards, adhoc reports for users.
• Involved in the migration of OBIEE reports to Tableau.
• Involved in the migration of Oracle Discoverer reports to Alteryx Apps.
• Worked on various data sources such as Netezza and Oracle.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Scheduled Full/Incremental refreshes of dashboards depending on the business requirements for data sources on Tableau Server.

Environment: Tableau Desktop 8.3/9.0/9.1, Alteryx 9.5/10, Oracle, Netezza, Toad, OBIEE, Microsoft office 2010, Windows 7.

Confidential, Kalamazoo, MI

Tableau Developer

Responsibilities:

• Interacted with business users in gathering, analyzing and documenting the business requirements and translate them into technical specifications.
• Development of new dashboards from the existing cubes.
• Responsible for recreating reports and dashboards.
• Creating reports for Metrics.
• Prepare dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Developed multiple reports/dashboards using Dual Axis charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
• Creating and modifying worksheets and data visualization dashboards.
• Export of Data from TrackWise.
• Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.
• Develop Scripts to load data into tableau and work with multiple data by data blending.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generate context filters and use performance actions while handling huge volume of data.
• Create complex reports using multiple queries and sub queries.
• Co-ordinated Tableau workbook files till UAT/Production environments.
• Provided tableau desktop training for end users.
• Configuring scheduled updates (Automatic and User notified) for optimal performance.

Environment: Tableau Desktop 8.2/8.3/9.0, TrackWise 8.4.11, SSAS, SQL 2008R2, Informatica, Microsoft office 2010, Windows 7 enterprise.

Confidential, Spartanburg, SC

Tableau Report Developer

Responsibilities:

• Gathering requirements from functional team.
• Review the solution documents, design and technical specifications.
• Prepared dashboards using calculated fields, parameters, groups, sets and hierarchies in Tableau.
• Created, customized & shared interactive dashboards.
• Developed dashboards by data blending, if the data is from multiple data sources.
• Migrated existing Cognos Reports into Tableau Dashboards.
• Worked on various data sources such as Teradata and Oracle.
• Used JavaScript API to create filters and customize the views.
• Defined best practices for Tableau report development.
• Provided tableau desktop training for the business team and end users.
• Helped in designing Data-warehouses/ETL workflows required for the reporting applications.
• Administered user and user groups for reports in Tableau.
• Created incremental refreshes for data sources on Tableau server.
• Access dashboards from any browser or tablet.
• Scheduled auto emails from tableau automation to end users, once the dashboard gets refreshed.

Environment: Tableau 8.1/8.2, Oracle 11g, Teradata, Cognos, JavaScript, Microsoft office 2010, Windows 2007.

Confidential, Dallas, TX

Tableau Developer

Responsibilities:

• Involved in requirement gathering from the on-site team leads.
• Analysis, design, development, testing and production rollover of reports and dashboards.
• Created joins, filters for fetching data into Tableau as per the business needs.
• Generated dashboards to compare the expected weekly sales vs projected sales used dual axis for comparison.
• Generated tableau dashboards for sales with forecast and reference lines.
• Built complex formulas in Tableau for various business calculations.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Published the dynamic dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Scheduled the updating of dashboards from Tableau Server on daily/weekly/monthly basis.
• Sending the dashboards to users by emails with the help of admin team with subscriptions.
• Given training/demos to users on Tableau Desktop for interacting and viewing the published dashboards and development of new dashboards.
• Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.
• Administered user, user groups and scheduled instances for reports in Tableau.

Environment: Tableau 7.0/8.0, MySQL Server, Oracle 10g, DB2, Microsoft Office 2010, Windows XP, Visual Studio 2010.

Confidential, San Francisco, CA

BI Consultant

Responsibilities:

• Interacted with business users for gathering requirements and look and feel of the applications to be developed.
• Developed various dashboards using hierarchies, groups, calculated fields and parameters.
• Used excel sheet, flat files, CSV files to generate reports.
• Generated Dashboards by joining multiple complex tables.
• Generated dashboard for Finance team, provided security by using user filters.
• Created adhoc reports to users.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Analyzed the source data and handled efficiently by modifying the data types.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Worked on performance tuning of various OBIEE Reports / Dashboard.
• Performed queries to fetch new data and create reports in Business Objects XI3.1 by connecting to Oracle Data Sources.
• Created various reports like Master/Detail reports, Cross Tab reports, Slice and Dice reports.
• Created and maintained Business Objects & Web Intelligence reports.

Environment: SAP Business Objects XI3.1, Oracle 10g, Tableau, SQL Server 2008, XML, MS Office 2007, Windows XP.

Confidential

Business Objects Developer

Responsibilities:

• Designed and developed Universes by defining joins, cardinalities between tables, linked the existing Universes using Business Objects.
• Created Aliases, Multiple contexts for catering different functional areas in a single user query.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Customized LOVs in Universes for quicker performance of reports.
• Interacted with the Business Users to analyze the business process and gathered the requirements, made necessary changes to schema objects to fulfill their reporting and business needs.
• Experience in universe migration across repositories.
• Performed queries to fetch new data, and create reports in Business Objects by connecting to Oracle Data Sources.
• Created various reports like Master/Detail reports, Cross Tab reports, Slice and Dice reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Used calculations, variables, breaks, sorting, filters, alerts and prompts while developing and creating reports.
• Involved in migrating reports and universes from 5.x to 6.5 and Web Intelligence reports using the report migration utility.
• Created and maintained Business Objects & Web Intelligence reports.
• Published existing reports to corporate intranet through Web Intelligence.

Environment: Business Objects 6.5.1, Web Intelligence 6.X, Oracle 9i, Microsoft Excel, HTML, Windows XP.