SUMMARY:

• Tableau /SAP Business Objects Solution Consultant with 8+ years of professional experience in Business Intelligence, Software Design, Modeling, Development and Implementation in Information technology with skills in all phases of Data Warehouse lifecycle development, using Tableau Desktop, Server 7.2/8.1/8.2/9.0/9.3/10.1 and SAP Business Objects suite BI 4.0/3.1 XI, Xcelsius 2008,Dashboards 4.0, Crystal Reports, IDT,Designer,WEBI, SQL Server, Oracle,TeraData, SAP BW,SAP HANA
• Proficient in managing all phases of data warehouse life cycle, including requirements gathering, analysis, preparing Business specifications, designing technical specifications, use cases, system implementation, designing and developing reports, performance tuning, testing, migrating to production and production support
• Involved in 3 - 4 full project lifecycle of SDLC and coordinated with all project teams.
• Involved in understanding Business and data needs and analyze multiple data sources and document data mapping to meet those needs.
• Expertise in recommending visualization features/designs most appropriate to data and analysis needs for business users.
• Expereince in working with business to deliver dashboards, as well as to train and evangelize the use of visualization within the client business areas.
• Proficient in design and development of various worksheets and data visualization dashboards, reports utilizing Tableau Visualizations like Bars, Lines and Pies, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in designing and creating various Data Visualization Dashboards, Scorecards and analytical reports to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Created various actions like Filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Defined best practices for Tableau report development.
• Administered and created Users, User groups according to the projects they belong to in Tableau Server
• Created Row-level (Data), Object-level (Roles an Permissions) and Access-level (Authentication) security and report schedules on Tableau server
• Actively involved in testing new/upgraded features like for the new version and promptly take decision on upgrade.
• Technical hands-on experience using Tableau components like Tableau Desktop/Server, Tableau Reader, Tableau Online
• Extensive experience in Tableau Administration Tools for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views and administration of Tableau Server in a multi-server and multi-tier environment.
• Prepared different highly formatted financial reports such as consolidated income statements and balance sheets using Crystal Report and Ad-hoc reports using Web Intelligence
• Worked on diffirent databases like RDBMS (SQL Server, Oracle, Teradata ), OLAP cubes, InMemory and Bid Data databases for reporting in Tableau Desktop
• Good understanding of Data Modeling techniques employing Normalization and Data Warehouse concepts using Star schema and Snow flake schema modeling, Fact and Dimensions tables, Physical and Logical Data Modeling.
• Good Understanding of Big Data Technoliges like Cloudera Hadoop, Hive and its architecture
• Experience in all phases of Testing (Unit Testing, Functional testing, Integration Testing & UAT)
• Excellent leadership skills in managing onsite and offshore resource.
• Excellent team player at all levels with ability to perform independently with exceptional communication, analytical, presentation and problem solving skills.

TECHNICAL SKILLS:

Data Visualization Tools: Tableau Desktop/ Server 7.2,/ 8.1/8.2/9.1/9.3/10.1 Tableau Reader/Public,Tableau Online, Tableau Mobile, Tabadmin,Tabcmd, Dashboard Desinger 4.0, XCelsius 2008Reporting Tools: Business Objects BI 4.0/ XI 3.1/R2 BO 4.0 (Information Design Tool(IDT), Universe Designer, Desktop, Web Intelligence/ Info view, LCM, Crystal Enterprise 4.0,2011

ETL Tools: Datastage7.5/8.0,Informatica 8.x/9.x, BODS 4.0

Data Modeling: Star-Schema and Snowflakes Modeling, FACT and Dimension Tables

Database: Teradata 14.0/13.0, Oracle 11g10g/9i, Microsoft SQL Server 2012/2008, Postgress, Pentaho,MySql, IBM DB2,SAP HANA, BW 7.1/7.2, Cassandra,Hive,Amazon Red ShiftAgile Tools: Atlassian JIRA, VersionOne

OS: Sun Solaris UNIX, Windows XP, Windows Vista, Windows 7

Servers: WebLogic Application Server 6.1/5.1/4.5, WebSphere 4.02/3.02

Tools: ERWIN 4.1/4.0, TOAD 6.5/9.5

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Tableau Analytics and Reporting Lead Consultant

Environment: Tableau (Desktop, Server (AWS)) 8.3/9.1/9.3/10.1, Tableau Online, Tableau Mobile, Salesforce, Cassandra,Amazon Redshift, Splunk 6.3,Interworks 1.18, Teradata and VersionOne.

Responsibilities:

• Interacted with business and Client subject matter experts to understand the purpose of the reports and based on the requirement,identified the data and performed gap analysis to see if all the relevant data fields are mapped per the business needs.
• Performed data analysis on a sample dataset and created/merged multiple tables to form a final underlying table which holds the required dataset.
• Designed various charts depending on the data and provided insights to the business and operational teams on the charts.
• Created initial draft version and performed weekly improvements after consulting with the business to make sure we are meeting better tableau development and timelines.
• Connected to Cassandra database using ODBC connection and Amazon Redshift with its native connector.
• Developed various dashboards using filters, parameters and calculated sets to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis on Sales reports.
• Published customized interactive reports and dashboards, report scheduling using Tableau server.
• Published Tableau files to Tableau Server on AWS, created Users and User groups and granted access permissions accordingly.
• Embedded Tableau dashborads into Salesforce portal after interacting with Salesforce team
• Actively led UAT meetings with the Senior leadership team to get the necessary sign offs, followed by Unit and SIT testing.
• Co-ordinated with the Production deployment team to deploy the reports into Production and assigned refresh schedules to pull the data on a daily basis to meet the business SLA.
• Successfully implemented 25 reports within a span of 10 months and met the deliverables on time. Handled many database, infrastructure hurdles and worked with cross functional teams to deliver the reports on promised time.
• Created a deck for the Senior Leadership Team to help them understand each report and the need its catering for the betterment of the business and provided user manuals to understand the Tableau features and navigate the dashboard for better analysis and to serve operational purposes.
• Performed upgrades to in corporate enhanced Tableau features and overcome limitations in previous versions since the new versions have better performance and quick rending time for the dashboard.
• After deploying the reports in Production, provided support to solve any issues and incorporated some of the enhancements after Production.

Confidential, Plano, TX

Tableau Solution Lead Consultant

Environment: Tableau (Desktop, Server) 8.2/9.0,Tableau Mobile, Teradata 14.10,SQL Server 2012, SQL Assistant,Hadoop, Hive and Atlassian JIRA .

Responsibilities:

• Involved in business requirement gathering to analze and design the data visualization using Tableau.
• Provided guidance insight on data visualization and Tableau dashboard design best practices
• Created Dashboards, automated reports and report template using advanced Tableau functions.
• Converted Tabler format reports into Data Visualization Dashboards using available Tableau features.
• Analazed the Data from diffirent sources and identified the common field to perform Data Blending and utilized those data sources in creating a Dashboard.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Performed Dashboards migration from lower to higher environment on server
• Sucessfully Deployed Dashboards to production and validated the dashboards in production environment.
• Enhanced and Refined the technical architecture to keep pace with changing business demands and new Tableau software releases.
• Took backup of the Tableau server on regular basis by using Tabcmd, Tabadmin commands also developed restoration procedures to restore the server during system failures.
• Design and development of various reports and dashboards that can be easily accessible through Tableau Mobile App in Ipads, iPhones, and other smart mobile phones.
• Used SQL tools like Toad to run SQL queries and validate the data in the warehouse and marts.
• Increased the performance of dashboards by optimizing the data sources and minimizing the data blending .
• Analyzed, Troubleshoot and tune product performance or deployment issues
• Strong understanding of business / semantic layers
• Ability to multitask and focus on numerous initiatives and tasks and Experienced working in a fast paced project with tight deadlines
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Confidential, Washington, DC

Sr.Tableau Consultant

Environment: Tableau (Desktop, Server) 8.1/8.2,/8.2.3,Oracle 11g,Toad 9.5, SQL Server 2012,Remedy, Windows AD Client, Informatica 9.1,and Microsoft Office Excel, Outlook.

Responsibilities:

• Responsible for gathering business requirements from cross-functional teams, worked directly with business units to define requirements and support various business initiatives and projects as it relates to analytics and reporting
• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Performed extensive GAP analysis in the project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
• Actively participated in Business Intelligence standardization to create database layers with user friendly views in SQL Server that can be used for development of various Tableau reports/ dashboards.
• Analyzed requirements for various reports, dashboards, scorecards and created the same using Tableau desktop server.
• Designed and developed a business intelligence data visualization dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Developed of key indicators and the appropriate tracking reports with graphical and written summations to assist in the quality improvement initiatives.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Installation and configuration of Tableau Server Cluster(Primary, Worker, Backup Primary) and its processes (SQL Server, Application Server, Data Server, Data Engine, Background Tasks, and Repository). Configured SMTP, SSL and Windows AD
• Worked on building Tableau suitable solutions integrated with SAP HANA
• Created and modified Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Created Table of Contents (TOC), a common navigation page which had all the links to various reports.
• Make use of filters and making them local and global accordingly.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.

Confidential, Irvine, CA

Tableau Consultant

Environment: Tableau (Desktop, Server) 8.1/8.2, SAP HANA 1.0, ECC 6.0, Teradata 13.10, SQL Assistant,Microssoft TFS,Remedy, Microsoft Office (Word, Access, Excel, Outlook).

Responsibilities:

• Interacted with Business users to understand their requirements and designed Tableau Dashboards according to the business needs.
• Used Agile/Scrum methodologies for gathering requirements and facilitating user stories workshop.
• Designed various mappings for extracting data from various sources involving flat files, XML files and relational tables
• Worked with Inforamtica SMEs on developing the business rules for cleansing using Informatica Data Quality (IDQ) tool.
• Ensured the data quality through partnering with the data steward in identification of Key Performance Indicators.
• Utilized advance features of Tableau software to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Custom Hierarchies to meet the Business requirements in Tableau.
• Developed custom formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Created dashboards for weekly, monthly, daily reports using tableau desktop & published them to server.
• Built, published customized interactive reports and dashboards, report scheduling using Tableau server.
• Imported data using extracts from different data sources and effectively used data blending feature in tableau.
• Connected to Teradata Database from tableau using teradata server details, port and user credentials.
• Administered user, user groups, and scheduled instances for dashboards in Tableau.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Increased the performance of dashboards by optimizing the data sources and minimizing the data blending.
• Analyzed, Troubleshoot and fine-tune performance and Production issues.
• Converted SAP BOBJ WEBI & Crystal Reports to Tableau Dashboards for Advanced Visualizations.
• Played an important role in coordination with the entire team and managing the time estimates for the entire project.
• Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Provided post implementation production support.

Confidential, Houston, Tx

Tableau Consultant

Environment: Tableau (Desktop/Server) 8.1, SAP BW 7.1/7.2, Oracle 11g, Share Point, Agile-Scrum, Informatica, Zena, MS VISIO, Microsoft Office Suite.

Responsibilities:

• Worked with the report development Manager and other team members on report requirements based on exiting reports/dashboards in Excel, timelines, testing, and technical delivery.
• Responsible for creating Metrics, Filters, Calculated fields, Parameters using Tableau Desktop.
• Developed customized calculations when required.
• Worked on drill through reports by creating HTML references
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Developed various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Actively involved in Setting up Tableau Environment.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Experienced in creating SAP BW connection in Tableau using ODBC driver
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Created user groups, projects folder structure and granted access accordingly
• Converted Xcelsisus Dashboards to Tableau Dashboards for Advanced Visualizations.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Confidential, Raleigh, NC

SAP Business Objects Solution Consultant

Environment: SQLQueries, .tdsx, .tde and .tds files, Tableau Desktop 7.2, Tableau Server, Business Objects BI4.0 Crystal Enterprise, BI 4.0 ( Web Intelligence, Infoview),SQL Server 2008/2012, Oracle 11g,MS office Suite

Responsibilities:

• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports on Tableau Desktop .
• Created dashboards on end client's sales data. Generated dashboards to compare the expected weekly sales vs projected sales used dual axis for comparison.
• Worked on Proof of Concepts (POC) presentation and reviewed with project and BI lead along with developing Tableau Dashboards.
• Adjusted dashboards after initial POC presentation to BI Director.
• Produced powerful dashboards telling story behind the data in an easy to understand format such as pie, bar, maps, and line charts that are viewed daily by CEO and CFO.
• Cleansed and normalized data in MS Excel by combining data from various data sources.
• Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.
• Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.
• Prepared Business requirement documents (BRDs), Functional designs (FDs), DFDs, Technical design and specifications, Data validation, Testing Procedures
• Worked on complex reports that require running totals, graphs, sub-totals, sub-reports, and conditional display of groups, fields and messages.
• Applied formatting for reports and developed reports with necessary Formula fields, Parameters fields, Group and Record Selections.
• Created standard report, sub-reports and drill-down reports using Crystal Report
• Extensively involved in using of formulas fields, parameter fields, Group selection, record selection and Crystal syntax in Crystal reports
• Strong experience in working with advanced features like incorporating a parameter into a formula, parameter with multiple prompting etc.
• Created linked sub reports (regular and On-demand) as well as unlinked Sub-Reports along with the primary reports.
• Used Business View Manager to create Business Elements, Business Views to use data in different sources and generated reports using Crystal Reports.
• Developed SAP Dashboard 4.0 using the BICS connections and BW BEx Query as datasources tasks for our Project, Which Included Creating Folders, creating users/ Groups giving Appropriate Access levels
• Experienced in creating scheduled reports and develop and execute test cases to verify integrity of reports
• Involved in production support
• Used SAP BW 7.3 objects (Info cubes, BEx Query) for reporting in Crystal and Web Intelligence reports
• Using BW query builder designed and formatted Crystal Reports based on SAP Business Information warehouse
• Experienced with creation of Publications to merge and schedule multiple reports in BI Launch Pad and to output to Email and File Systems

Confidential, Peoria, Il

Sr. SAP Business Objects Consultant

Environment: Business Objects 3.1(Universe Designer,infoview), XCelcius 2008, SQL Server 2008 R2, SAP BW 7.1

Responsibilities:

• Gathered user requirements and Involved in developing use cases with users and technical team.
• Involved in weekly meeting with users on BOXI new enhancement requests & Issues.
• Created Universe development Spec’s and Data Elements Sheet required for universe development.
• Developed the Universe (Including database & server connection setup)
• Responsible for complete development, testing and production phase of the project.
• Worked with Joins, Alerts, Custom SQL, Cardinalities, Loops, Aliases, Views, Aggregate etc.
• Created Stored Procedures, Views, and Functions using PL/SQL to be used in the reports.
• Created Business Views to implement the feature of List of Values (LOV’s) and dynamic cascading Parameters for reports
• Experienced in creating Dashboards in XCelsius by using QAAWS, Live Office and BI service.
• Worked on concepts like Triggers, Dynamic Visibility and Flash varibles
• Developed dashboards using different chart, selector, and connectivity components and interlinked to each other so that the user can navigate from one dashboard to the other.
• Designed and developed various Metrics, Analytics like speedometer, Interactive Charts, Alerters and Goals for creating Dashboards using Dashboard Manager. Tuned the reports for better performance using SQL.
• Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc in Data flows.
• Created mockup dashboards and presented to the higher level end users to have them a look and feel of the dashboards.
• Managed Addons in the Xcelsius and worked on google maps and Antivia addons to develop dashboards with the drill down capability.
• Suggested different options to modify the dashboards which had performance issues and prepared a Gap analysis to explain the client on the standards.
• Analyzed different data connecvities that can be used in connection to BOBJ Enterprise like QAAWS, Live Office, BI Web Services, and BEx Queries/Business Intelligence Connection Services and presented the Mockups explaining the Pros and Cons each data connectivity has.
• Monitored, communicated and troubleshooted issues with data integrity, data design, and functional and technical software issues.

Confidential

Software Developer

Environment: Business Objects XI2/3.1 (Universe Designer), XCelcius 2008, Infoview, Designer, Oracle 8i, Crystal Reports, PL/SQL

Responsibilities:

• Worked with Onsite Core Team to understand the requirement.
• Documented new reports requirement and develop the reports
• Involved in Business Objects reports query optimization
• Interacted with Business Users and to know their Business views in developing and modifying Universes and Reports accordingly.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Involved in the designing and Building of Universes, Classes and objects.
• Developed Business objects reports using Xcelcius.
• Worked on linking of universes,created and tested classes and objects to organize the universe.
• Designed and Developed Business Objects Universes, which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
• Exported the universes to the Repository to make resources available to the users.
• Created reports for various Portfolios using the data Providers like Free Hand SQL.
• Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc.
• Created reports using XCelcius Dashboards, Crystal Reports for distribution to users.