SUMMARY

• Over 9 years of experience in Information Technology Industry with expertise in Developing Business Intelligence and Data Warehouse Applications.
• Experience in working with major industries such as BFSI/Merchant/Asset Management,Retail business,Power &Energy,Entertainment,Marketing and Pharmaceuticals.
• 6+ Years of experience in Tableau Desktop and Tableau Server Administration in various versions of Tableau like 10.2/10/9.3...
• Experience in Tableau Dashboard Design,Developent, Tableau architecture and end user experience.
• Developed Tableau Dashboards, Business Objects Web intelligence, Crystal reports and from various Database/DWH sources like SAP BI/BW, SAP HANA, Oracle 11g/10g/9i, Teradata 8/12/13,MS SQL Server2005 &2008, DB2 and MS - Access.
• Experience in installation and configuration of Tableau Server/Desktop.Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Extensive Experience in various Tableau Desktop reporting features like Measures, Dimensions, Folder, Hierarchies, Extract, Filters, Table Calculations, Calculated fields, Sets, Groups,Actions, Parameters, Forecasting, blending and Trend Lines.
• Implemented advanced geographic mapping techniques and geo coding to build spatial visualizations of non-geographic data.
• Created various Visualizations inTableaulike Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc
• Developed Dashboards with Advanced charts like Water-fall Chart,Donut Chart,Dumbell Chart,Funnel Chart,Spark lines,Pareto Chart etc...
• Designed and publishing visually rich and intuitive Tableau dashboards for executive decision making.
• Lead, designed and oversaw complex, cross-functional, multi-platform business processes.
• Identifying and adapting industry best practices that should be adopted at Client.
• Created test scenarios for the Development, Testing and Production environments.
• Proficiently developed use-cases and project documentation (User guides, Standard report instructions, Demos)
• Highly proficient at requirements gathering(BRD/RTM/FS) and testing planning/scenario creation/test case creation - Strong analytical/problem-solving skills, with the ability to quickly gain alignment on proposed solutions.
• 8 years of Outstanding Experience in SAP Business Objects Enterprise Suite 4.2/4.1/4.0/XI 3.1/ 3.0/R2.
• Expertise in security setup among groups, categories, users and successfully implemented windows authentication, single sign on among single and multiple Domains.
• Hands on Experience in tools like informatica(ETL)and SAP BI(cubes,ods,multiproviders,Bex query) Knowledge in tools like SAP HANA &MSBI(SSIS,SSRS &SSAS)
• Experience in using SQL & PL/SQL Languages to write script as per the need of client reporting requirements.

TECHNICAL SKILLS

• Tableau (10.2/10/9/8/)
• SAP BusinessObjects 4.2(sap bobi/bobj/bo)
• QlikView/Sense
• Crystal Reports
• Xcelsius
• Lumira
• DB(Sql/Oracle/Teradata/DB2)
• SAP BI/BW /MSBI
• Looker
• Hadoop(Hive)
• Informatica

PROFESSIONAL EXPERIENCE

Confidential

Tableau Consultant

Responsibilities:

• Interacted withBusiness/Application Users andBusinessAnalysts to gather Reporting Requirements, subsequently translate it into Functional specifications for Tableau Report Development.
• Designed and Developed Reports/Dashboards like Cost/Savings, Case closure, Reach& Engage, Utilization, Authorization Activities, Customer Satisfaction and Referral &CO-Management and prepared user stories to create compelling Dashboards(Visualizations)to deliver actionable insights.
• Created various reports like Master/Detail reports, Cross Tab reports, Slice and Dice reports, and Drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created complex reports using multiple queries and involved in tuning the reports in order to increase the accessing speed.
• Worked on PowerfulBusinessobjectsfunctionality's like @functions, Variables, user response and formulae.
• Involved in creation of Reports, Formatting reports and charts as per user requirements.
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• Designed and developed Crystal Reports, which included standard reports, cross-tab reports, and summary reports according to the requirements. These reports used complex Crystal formulae and Sub Reports.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor to manage ETL.
• Worked extensively with Tableau Advance analysis of Actions, Calculations, Parameters, Maps, Trend Lines, forecast, sets, groups, Background images, bins and table calculations to develop Dashboards.
• Administrated Tableau Server Activities like User/Group/Site Creation and setting up access levels for each Dashboard. Connected Tableau server with Share-Point portal and make Dashboards available to business users and scheduling of Dashboards intervals. Published reports to Tableau Server and made them available to Appropriate Business Group as per the access levels.
• Prepared Migration Plan and Successfully MigratedBusinessObjects system from BOXI3.1 to 4.2.Design and implement BO system security including security groups and access control list to meetbusinessrequirements.Responsible for maintaining Users and User Groups in CMC, and maintaining the servers.
• Designed and developed Crystal Reports, which included standard reports, cross-tab reports, and summary reports according to the requirements. These reports used complex Crystal formulae and Sub Reports.
• Created Complex reports using Multiple Data providers and synchronized the data in Web Intelligence using Merge Dimensions functionality.
• Performed GAP Analysis and resolved the functional logic issues in BRD's with the help of Business Users.
• Prepared documents like BRD's and Test cases (Unit/SIT/UAT).Interacted with Business users for controlled validation and push the report Production and user Training.
• Developed Dashboards using Webi/Tableau Desktop and made them available to users on Mobile/I pad.
• Provided post -production support for system issues, including research and follow-up and 24x7 Production support.
• Worked on Agile-Scrum Methodology to design and develop Dashboards.

Environment: Tableau 10.2, Informatica,Teradata, Hadoop(Hive),Looker,SAP BO 4.2,Rally(Agile-Scrum),SQLGIT(DEV OPS),Toad.

Confidential, NJ

Business Intelligence Lead

Responsibilities:

• Interacted with Business Users,Business owners to know their Business requirements to Design and Develop Tableau Dashboards and Web intelligence Reports accordingly.
• Developed Tableau Dashboards/Business Objects Web intelligence and Crystal reports from various Databases like SQL Server/Oracle/SAP BI.
• Design Project implementation plan for the Update of BI Systems.
• Created Rich Dashboards using Tableau Desktop and prepared user stories to create compelling Dashboards to deliver actionable insights.
• Designed and developed various analytical reports from multiple data sources by Blending data on a single worksheet in Tableau Desktop.
• Administrated Tableau Server Actvities like User/Group/Site Creation and setting up access levels for each Dashboard.Connected Tableau server with Share-Point portal and make Dashboards available to business users and scheduling of Dashboards intervals.
• Develop Dashboards using Advanced Features in Tableau like Actions, Calculations, Parameters, Maps, Trend Lines, forecast, sets,groups,bins and table calculations.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Extensively worked on Performance turning of the Reports/Dashboards and Universes.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor to manage ETL.
• Generated Interactive Dashboards with Quick filters,Parameters and Actions to handle views more efficiently.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Used Trend Lines, Reference Lines and Annotations to describe the data.
• Designed and validated universe from multiple data sources with SAP BI Information design tool.
• Developed Webi Reports involving complex calculations with Multiple data providers/Multiple universes complex queries, Sub queries, Unions and Intersection. Involved in troubleshooting issues in reports like poor performance and bad data.
• Created Custom Hierarchies, complex objects using various @functions and aggregate aware objects in the universe.
• Involved in documentation for the mapping, technical specifications, data validations and Test cases.
• Developed Dashboards using Tableau Desktop and made them available to users on Mobile/Ipad.
• Training users and Document the process and uploading to SharePoint for future reference.

Environment: Tableau 10/9.3,SAP BI 4.1(BI Launch pad, Information Design Tool, Central Management Console, Central Configuration manger, Upgrade Management Tool and Promotion Management Tool),Informatica 10,SQL Server 2012,SAP HANA SPS 11,Teradata 13.

Confidential, NJ

Consultant (Tableau/Business objects)

Responsibilities:

• Interacted with end users to gather requirements of Core Reporting system to understand exceptional features users expecting with reporting system and also to successfully implement business logic
• Designed,Developed and maintained complex Reports/Dashboards and Universes from various business functionalities of company like SD/CRM/FICO/MM/HRM/SRM/PI and resolved Data issues by creating aliases and contexts.
• Created Dashboards with charts like Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications using Tableau Desktop.
• Extensively used analytical features inTableaulike Statistical functions and calculations, trend lines, forecasting etc. in manytableaureports.
• Utilized Tableau server to Scheduling and publish Dashboards with the business users.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Worked closely with business power users to create user-friendly reports/Dashboards using tableau desktop.
• Implemented action filters, parameters and calculated filed for end user Interactive dashboards Requirements.
• CreatedTableauscorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Effectively used Data Blending feature intableau.Define best practices forTableaureport development.
• Administer user, user groups, and scheduled instances for reports inTableau.Execute and tested required queries and reports before publishing.
• Develop parameter and dimension based reports, drill-down reports, charts, and Tabular reports usingTableauDesktop.Execute and tested required queries and reports before publishing dashboards.
• Extensively work onTableauDesktop,by creating Complex reports CreateTableauscorecards, dashboards, Heat maps using show me functionality.
• Scheduling the monthly/weekly/daily reports to run automatically.
• Interacted with all functionalities of company in terms of getting data accurately and helped Oracle DB team/SAP BI to maintain data as per the report requirements.
• Tested applications for performance, data integrity,job scheduling and alerts.

Environment: Tableau 9.1, SAP BI 4.0, SAP BI/BW 7.3,SAP HANA,, Oracle 11g,Crystal Reports 2011, LCM, Import wizard, UMT and CMC.