SUMMARY

• Over 8 Years of experience in Analysis, Design, Coding, Testing, Migration, Production support and Implementation of Software applications like Tableau and Business Objects.
• Over 4+ years of experience in designing, developing and publishing of Tableau Applications.
• Over 4 years of experience in designing, developing and publishing of SAP Business Objects.
• Good knowledge on Qlikview.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• In - depth knowledge on Tableau Desktop, Tableau Public, Tableau Reader and Tableau Server.
• Expertise in Tableau Desktop/Server, creating highly interactive Data Visualization Reports and Hierarchical Dashboards.
• Proficient in working on SQL in Oracle 8i/9i/10g/11, SQL Server 2005/2008, DB2,Teradata 13 databases, Vertica.
• Proficient in design and development of various Dashboards, Reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, Geographic’s and other making use of actions, local and global filters, cascading filters, context filters, Quick filters, parameters according to the end user requirements.
• Proficient in all phases of the Software Development Lifecycle, including Requirements gathering, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.
• Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
• Excellent knowledge of Relational database concepts and possess strong knowledge in writing SQL queries in Oracle and MS SQL Server.
• Extensive experience in preparing dashboards using calculated fields, parameters, groups, sets and hierarchies in Tableau.
• Extensive experience in SQL and in performance tuning SQL queries.
• Experience in administering user, user groups, and scheduled instances for reports in Tableau.
• Excellent knowledge of Business Intelligence platforms and processes across Banking, IT and Financial industries.
• Experience in implementing Data blending, replace references, Customized queries and advanced visualizations in Tableau.
• Extensive working experience in Packages, Procedures, Cursors, Triggers and UNIX Scripting.
• Extensive experience in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting,) using Tableau Desktop.
• Understanding Row Level Security and providing options.
• Extensive knowledge of all phases of the Agile Scrum and the iterative Rational Unified Process (RUP).
• Deployed the reports and Scheduled Reports for the use of end users.
• Expertise in creating reports using the Business objects functionalities like Prompts, Slice and Dice, Drill Mode, Filters and Alerter.
• Expertise in creating Xcelsius interactive Dashboards.
• Experienced in linking multiple universes to meet client requirements.
• Very good understanding of Dimensional Data Modeling, Fact tables & Dimensions tables, Physical & Logical Data Modeling
• Implemented Tableau Security.
• Strong understanding of business / semantic layers
• Worked with Cross functional groups and various business users to analyze the business requirements, prepared GAP analysis sheets and designed Technical documentation based on the Business Requirements
• Good knowledge on Tableau BI Creation and server side configuration functionalities
• Technical support to the team, reviews of deliverables, communication with offshore team, track all the deliverables and to impart on job training to the team.
• Experience in user training and documenting the methodologies and requirements
• Have good communication, interpersonal and analytical skills with the ability to effectively multitasking, meet deadlines,
• Quickly adaptable to different project environments. Ability to work independently and efficiently as a team member

TECHNICAL SKILLS

Reporting Tools: Tableau 7/8,8.1,8.3, 9.0, 10.1,10.2 Tableau Desktop/Server, Business Objects XI 3.1/XI R2/6.5, UDT, BI Launch pad, Desktop Intelligence, Web Rich Client, Web Intelligence, Import Wizard, Xcelsius, Dashboard Designer, CMC, Qlikview 12, SSRS

ETL: Informatica9/8/7.1

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2008/2012, Teradata12, NetezzaLanguages SQL and PL/SQL.'

Servers: Web Logic Application Server 6.1 / 5.1, TOMCAT

Tools: TOAD and SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, IL

Tableau Analyst

Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Designed and published customized interactive dashboards.
• Used data blending, filters, parameters, sets, groups etc.
• Extensively used JIRA and Service Now data to develop Executive level dashboards.
• Found efficient ways to maintain the accuracy of the core information content that is being communicated, while Confidential the same time presenting graphs and tables visually, and aesthetically,
• Created interactive dashboards by combining views inTableauDesktop that were presented to Business Users, Engagement Managers, and End Users.
• UtilizedTableauvisual analytics and best practices like performance improvement, Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and of complex dashboards/reports.
• Developed Cross Tab, Chart, Line, and Drill down through worksheets inTableau.
• Created Complicated Calculation Based LOD (Level of detail) feature.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Worked extensively with Advance analysis, Sets to create detail level summary worksheets and dashboards using KPI's.
• Implemented Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, Groups, hierarchies.
• Generated dashboards using dual axis and blended axis for comparison.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Provided Training to different business users to develop dashboards in workspace and workspace advanced.

Environment: Tableau 10.0,10.2 Jira, Service Now, MS Share point

Confidential, Cincinnati, Ohio

Tableau Lead

Responsibilities:

• Worked on 5 full lifecycle projects starting from gathering Requirements to publishing it to Production.
• Involved in creating dashboards, Storyboards and visualization inTableau. Created report schedules onTableau server.
• Created out of the box Dashboards which includes extensive use of Actions and filters
• Created Parameters, Actions etc. for detail visualization to meet end user needs.
• Created Executive level KPI dashboards with interactive visualizations
• Resolved loops by creating contexts for each fact table and also by adding aliases.
• Extensively worked with Best practices in tableau for best performances of the dashboards when it comes to huge data set like creating extracts, Data blending uploading the data source to server for better performances.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
• Trained Business users for usage of dashboards and tableau tool for their basic needs.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Pie Chart, Gantt Chart, Histograms, Water Fall charts, Donut graph etc to assist business users in solving complex problems.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Huge Experience in with SQL Server and Vertica Databases.
• Good Experience in Data Modeling and Data analytics.
• Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Extensively used Date based calculations for all the project. Specially YOY and MOM Calculations.
• Huge Experience in converting sales force and Cognos reports in to rich Tableau Dashboards.
• Experience in creating dashboards using Tableau and D3.js (Data Driven Document).
• Worked on Developing Website (Portal) for Board Members which includes embedding tableau dashboards in the website which takes tableau to a whole new level.
• Provided effective Tableau Solutions for creating dashboards for various devices like Desktop, Laptop, I pad, Mini I Pad, Mobile phones (I phone, Samsung galaxy).

Environment: Tableau 9.0, Oracle, Netezza, Jira, MS Share point, Windows 2008/Windows 7

Confidential, Dallas, Texas

BI Tableau Consultant

Responsibilities:

• Met with the Business Users, Analyst and project owners to gather the requirements and document the reporting development work to meet business objectives. Understanding functional requirement specifications and create detail level documentation
• Involved in creating dashboards and reports inTableau. Created report schedules onTableau server.
• Created Dashboards with combination of charts, graphs, filters and more to help Users to analyze and understand the data and by navigating through the reports for detail analysis.
• With help of tableau server and a supported browser and controlled users interactions and combine functionality.
• Coded single control that filters a group of marks, selects some of those marks, and presents their data for download.
• Created Parameters, Actions etc. for detail visualization to meet end user needs.
• Created Executive level KPI dashboards with interactive visualizations
• Resolved loops by creating contexts for each fact table and also by adding aliases.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
• Mentored business users to create reports/dashboards using tableau desktop.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Good experience in administration, configuration, and maintenance upgrade setting up Tableau Server.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Pie Chart, Gantt Chart, Histograms, Water Fall charts, funnel chartsetc to assist business users in solving complex problems.
• Huge Experience in OLAP, OLTP.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Conducted Training sessions for Tableau users and created the documents for end-user support.
• Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Interacted with the users and troubleshooting the problems involved with the reports, dashboards and problems related to the privileges.

Environment: Tableau 7/8,Oracle, Teradata, MS Share point, Windows 2008/Windows 7

Confidential, Middletown, NJ

Tableau Developer

Responsibilities:

• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Worked on Universe enhancements updating the tables, adding new tables, Joins, detecting loops. Created additional contexts, new dimension and measure objects in the Universe
• Develop canned / Ad-Hoc reports and complex dashboards in Tableau
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards with forecast and reference lines.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Generated Tableau dashboards with combination charts for clear understanding.
• Designed dash boards for actionable, non-actionable complaints from Multidimensional database.
• Generated dashboards using dual axis for comparison.
• Generated Dashboards by joining multiple complex tables.
• Involved in creating and visualizing dashboards using Tableau Desktop.
• Generated Tableau combination charts using Tableau visualization software.

Environment: Tableau 7.0,Windows 2008, SQL server 2008/2012, SSRS, SSIS, SSAS.

Confidential, Cincinnati, Ohio

SAP Business Objects Developer

Responsibilities:

• Worked closely with Business Analyst, Business Users and Managers for gathering, analyzing, documenting Business Requirements, Functional Requirements and technical Specifications for Business Objects universes and reports
• Prepared the (BRS) Business requirement specifications and functional requirement documents (FRD)
• Worked on planning, designing, developing, distributing and maintaining Universes with relational databases (IBM DB2) as the data sources
• Used BO Universe Designer for semantic layer, Business Objects Info View, Web I for reporting
• Designed the universes on top of IBM DB2 databases from scratch and exported them to the repository
• Designed, developed and maintained universes for supporting ad-hoc and canned reports
• Defined cardinalities, created joins, performed check integrity, resolved loops by creating aliases and contexts to remove the cyclic dependencies
• Created cascading List of Values (LOVs) for better understanding of prompts by the end users
• Created complex reports using cascading prompts to restrict data fetch and ease data load
• Created filter objects, formatted objects and measures within the universe for faster report generation
• Created different types of reports, like Tabular, Master/Detail, cross Tab using multiple queries
• Used filters, conditions, Prompts, Drill Down, Functions etc
• Extensively used breaks for white spaces and sections for better navigation
• Created Web I Reports using Drill down functionality creating custom hierarchies
• Created detail and summary reports to fold/Unfold sections corresponding to breaks in current blocks
• Extensively used Web Intelligence Info view for querying, reporting and analysis tasks
• Created reports like Quarterly reports, Demographic reports and Metric exception Reports
• Created complex Web I reports by linking objects from different data providers and using Merge Dimension Option
• Created Web I Reports using Drill down functionality within different hierarchies
• Worked extensively with the Performance Management tool involving the creation of dashboards
• Gained experience in loading data into Oracle from an existing data source, modeling the data in Information Design Tool to facilitate data analysis and using Business Intelligence Tool
• Worked on POC (Proof of Concept) system which lead to clear understanding of requirements, assess design decisions early in process and reduces overall risk of projects failure.
• Involved in Unit Testing, Integration Testing and Performance Testing of reports and Universes
• Migrated the universes from DEV to Acceptance and PROD Environments
• Trained the users on the Ad Hoc reporting and on navigating the Business Objects tool
• Gained knowledge about Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse

Environment: Business Objects Enterprise XI 3.1 & SAP BO 4.0, Designer, Web I, Info View, BI Launch Pad, Dashboards Designer, Import Wizard, Information Design Tool, Business Objects Data Services XI 3.1, IBM DB2 V8, Windows XP/2003

Confidential

SAP Business objects/Xcelsius Dashboard Developer

Responsibilities:

• Performed system study, interaction with users & management, performance of analysis, designing, coding, and testing & implementation of the system.
• Demonstrated various samples of reports before sign off -obtaining from the users.
• Created Desk I reports with conditions and prompts.
• Created web I reports with report level prompts and critical functions.
• Conducted meetings with management and user community to understand the business requirements and convert them into technical specifications.
• Created different types of reports, such as, Master/Detail, Cross Tab and Chart (for trend analysis). Used filters, conditions, Formulas, calculations.
• Tested the universes periodically by running Check Integrity Tool.
• Created several Classes, Objects, Conditions, and Measure objects.
• Used Analyzer and Explorer to view reports from different prospect (Slice and Dice and Drill down).
• Extensively used linked and unlinked Sub Reports.
• Created Static and Dynamic Parameters in the Reports.
• Created Dashboards using Xcelsius and Live Office
• Extensively involved in writing SQL Queries and testing the data
• Created reports like Reports by Period, Demographic reports and Comparative Reports.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Trained the user community in making use of universe to create and publish reports.

Environment: SAP Business objects R3, Xcelsius, TOAD, Oracle 9i, SQL and Windows 2003.

Confidential

BO Developer/Data warehouse Developer

Responsibilities:

• Understand the technical requirements, developed simple reports to satisfy the user requirements
• Worked on DeskI and WebI reports in BO 3.1
• Worked on Universe Designer and designed simple Universe by defining Joins, resolving loops and cardinalities
• Resolved Loops in Universe by creating Aliases, Contexts.
• Export the universe into the repository. Initiated migrating universe and reports between environments.
• Created several Classes, Dimension Objects, Measure objects and Conditions.
• Created Web I reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc. Developed hierarchies to support drill down reports.
• Features such as breaks, alerter and hide blocks are used in developing reports.
• Exported Business Objects reports to Web Intelligence to be published on the Intranet and created thin client reports through Info View.
• Developed universes and DeskI reports from the Oracle 9i database.
• Written queries to retrieve data from Oracle database for multi-dimensional analysis using slice & Dice and Drill up/down functionality.
• Generated various standard reports and queries based on the existing classes/objects.
• Responsible for Creating Complex and Multi-Dimensional reports using Master/Detail, Cross Tab, Slice and Dice and Sub Queries.
• Developed On - Demand Sub Reports, Parameter Reports and Drilldown Sub Reports.
• Created numerous Alerts that are executed based upon certain conditions.

Environment: Business Objects 3.1, Desktop Intelligence, Web Intelligence, Xcelsius Dashboard, Oracle 9i, SQL TOAD, Windows NT/2005