SUMMARY

• Tableau/BOBJ Consultant - Data Warehousing, Tableau, SAP BOBJ/BI 4.0 Technical and Managerial Expertise in a career spanning 10 years
• 10 years’ of experience in Information Technology, Software Engineering, Business Intelligence and Data Warehousing Life cycle - Design, implementation, testing and support.
• 4+ years of extensive Tableau Experience in Enterprise Environment, in Tableau 8.0 and 9.2 and 9.3 as a Developer and Analyst
• Extensive Tableau Experience in Enterprise Environment and Tableau Desktop
• Experience includes technical support, troubleshooting, and report design, Experience in all the Latest BI Tools: Tableau Dashboard Design.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Filters, Prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• End to end experience in designing and deploying data visualizations using Tableau, Extensive experience in Data Analysis
• Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.
• Administration of Tableau server, administration of Tableau server users, troubleshooting of client’s issues with Tableau.
• An exposure to full life cycle of the SAP Business Objects reporting Applications using BO XI Web Intelligence Desktop and deploying to Info View.
• Extensive knowledge in Enterprise deployment and maintenance of various types of reports in Crystal reports, Experienced in designing Universes to build reports using web intelligence and creating universes to build dashboards.
• Installing, configuring and administering Business Objects 4.0 environments
• Data modeling (Dimensional & Relational) concepts includingStar-schema modeling, Snowflakes modeling, fact and dimension tables.
• Customer Relationship Management: Quality Assurance on deliverables, Communication
• System Design and Development: Requirement Analysis, Effort Estimation & Scheduling, Design, Development, Testing, Product Release

TECHNICAL SKILLS

Database: Oracle 9i, SQL Server 2008, Teradata

Operating Systems: Windows XP, UNIX, Windows 7

Reporting Tools: Tableau, BO XI, SAP BI 4.0, Web Intelligence rich client, BO BI Platform, UDT/ID Desktop Intelligence, Xcelsious/Dashboards, Explorer, Crystal Reports, QAAS, Live Office

ETL Tools: BODS/ SAP Data Services 4.0

Languages: SQL, PLSQL, OLAP

PROFESSIONAL EXPERIENCE

Confidential, Farmington Hills, MI

Tableau BI Lead Consultant

Responsibilities:

• Involved in creating dashboards by extracting data from different sources
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard. Involved in dimension modeling
• Involved in creating 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-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat 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 and Microsoft Analysis Services.
• Maintained and Installed Tableau Server in all the environments.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Administered user, user groups and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects and groups in Tableau server.
• Use Tableau desktop to create dashboards that provide concise and actionable insights to client.
• Conduct optimisation and tuning on dashboards and queries to improve performance.
• Create and present POCs to prospective clients.
• Utilise different databases like Mysql, Excel, CSV files and other databases.
• Involved in setup and Configuration of the new BI 4.0 system
• As a SAP BI Consultant, Providing the SAP Business Intelligence Services like lead and own the technology engagements with customers from designing, developing and implementing complex SAP Business Objects reporting solutions
• Documented Business Processes and designed and developed centralized reporting system with universes and reports to access users from Infoview and run effectively on their month/quarter end processes and reports producing to their country regulators.
• Designed and developed universes and reports for different countries with country specific local reports which are supporting with their local language and conducted UAT on behalf of the users to validate the computations.
• Trained end users to get familiar with Business Objects functionalities to create ad-hoc reports
• Successfully handled user requests, issues, bugs and minor enhancements with the expectations in the universe design and report development and maintenance

Confidential, NJ

Tableau BI Lead Consultant

Responsibilities:

• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery. Involved in dimension modeling
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Created visualization for logistics calculation and department spend analysis.
• Generate KPI for coiled tubing treatment and monitor NPT performance.
• Maintained Test log and Wrote test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be tested in the application.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Designing universes to build web intelligence reports
• Created Reports as per user requirements using BI 4.0
• Integrating BO reports in client CRS application
• Created users and groups in Windows environment, Implemented the security at row level and user level.
• Integrated the Business Objects to SAP.
• Created Complex Reports such as linking of Two Reports, Drill Down and Drill Up.
• Conducted Training Programs to team members, Prepared the Test case and Test Scripts for Unit testing.
• Created Reports using SAP BW data as data source, Created Content plans for Security

Confidential

Tableau BI Consultant

Responsibilities:

• Using Tableau server as a front-end BI tool and Microsoft SQL Server as a back end database designed and developed workbooks, dashboards, global filter page, and complex parameters based calculations.
• Developed reports, data boards using tableau for quick reviews to be presented to business and IT users.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Provided 24/7-production support for Tableau users.
• Resolving access level issues in business objects production and closing the Incident Tickets
• Setting access restrictions on a universe managing users and logins.
• Checking the business objects production report failures and resoling on SLA basis.
• Interacting with the customer and gathering the requirements for various report templates and enhancements in Process Flow.
• Designed Report Template Design Documents.
• Created Reports as per user requirements using BO XI R2.
• Created Universe connections in CMC level and Proved to other development team.

Confidential

SAP BI Consultant

Responsibilities:

• Designing universes to build web intelligence reports, Created repot dashboards using web intelligence and designed interactive desktop intelligence reports
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL.Involved in dimension modeling
• Created corporate dashboards with analytics deploying universes, setting access restrictions on a universe managing users and logins.
• Created users, including one user, MD, who has view rights only to the dashboards and analytics in the performance management folder.
• Monitoring execution of SQL jobs & optimizing their performances.
• Checking the session’s failures and workflows and resolving it.
• Resolving, Transferring and closing the Service tickets and Incident Tickets.
• Checking daily jobs are succeeded for particular interfaces. Optimizing the reports performance & reports generation process
• Creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

Confidential

SAP BI Consultant

Responsibilities:

• Interacting with the customer and gathering the requirements for various report templates and enhancements in Process Flow.
• Development & distribution of Business Objects reports & dashboards.
• Creation of SSAS cubes, measures groups, dimensions etc. and setting various roles, permissions, hierarchies etc.
• Extensively calculations, named queries, views while developing the reports and cubes.
• Monitoring execution of SQL jobs & optimizing their performances.
• Optimizing the reports performance & reports generation process.
• Designing universe, developing and generating complex, dashboard Reports, List of values along with User Acceptance Test and data accuracy test.

Confidential

SAP BI Consultant

Responsibilities:

• Designing new universes as per the user requirements by identifying the required tables from data mart and by defining the universe connections.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of associates performance and volumes count.
• Creating user defined variables and writing formulas, Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report for the distribution to different locations.
• Created and modified the crystal reports for various financial groups using the Universe as a main data provider.
• Writing manual queries at report level to improve the performance.
• Involved in creation of Filters, @prompts and setup Hierarchies for multidimensional analysis.
• Preparing the test cases and understanding documents to users for future reference
• Directly coordinating with user to gather the new requirements and working with existing issues.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Migrated & upgraded Business Objects from 6.5 to XI r2 Universe designing and establishing BO environment.
• Involved in designing Universes to build reports using web intelligence. And creating universes to build dashboards.
• Deploying universes, setting access restrictions on a universe managing users and logins.
• Involved in creating various types of reports according to user requirements.
• Created reports using alerts by defining the conditions and formatting to highlight a report results that meets specific business criteria.
• Created the metrics used in creating analytics, and created corporate dashboards with analytics