PROFESSIONAL SUMMARY:

• 10+ 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.
• 7+ Years of experience in Tableau Desktop and Tableau Server Administration in various versions of Tableau like 10.5/10.4/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 in Tableau like 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.5/10/9/8/)
• SAP BusinessObjects 4.2(sap bobi/bobj/bo)
• Hadoop(Hive)
• QlikView/Sense
• Crystal Reports/Power BI
• Xcelsius
• Lumira
• Alteryx /Superset
• DB(Sql/Oracle/Teradata/DB2)
• SAP BI/BW /MSBI
• Looker
• Informatica

PROFESSIONAL EXPERIENCE:

Confidential

Tableau Consultant, Houston, TX

Responsibilities:

• Interacted with Business/Application Users(CIO/VP's)and Business Analysts to gather Reporting Requirements, subsequently translate it into Functional specifications for Tableau Dashboards Development.
• Designed and Developed Reports/Dashboards like Service scorecard,Revenue Dashboard,Customer satisfaction,Order Management,Retail scorecard,Traffic Dashboard,Event log Dashboard,Inventory Management,TOP 6 Metrics,CEO Daily,and prepared user stories to create compelling Dashboards(Visualizations)to deliver actionable insights.
• Created customized Dashboards using various chart types like Bar, Pie, Tree maps, Heat maps and line charts in Tableau.
• 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.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Developed Tableau Dashboards/Story's from multiple data sources using Data Blending.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Administrated Tableau Online Activities like Users/Groups/Site Creation and setting up access levels for each Dashboard.
• Published reports to Tableau online and made them available to Appropriate Business Group as per the access levels.
• Scheduled Dashboards using Tableau bridge and made them available to users like Hourly,Daily,weekly,Monthly.
• 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 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.5/10.4/10.3 , Tableau online,Tableau Bridge Client,Hadoop(Hive),Superset,Domo,Jira(Agile-Scrum),SQL,GIT(DEV OPS).

Confidential

Consultant, Lafayette, Louisiana

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 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 Powerful Business objects functionality'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 Migrated Business Objects system from BOXI3.1 to 4.2.Design and implement BO system security including security groups and access control list to meet business requirements. 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,Toad.

Confidential

Business Intelligence Lead (Tableau/BO), Somerset, NJ

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

Consulatnt (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 in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• 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.
• Created Tableau scorecards, 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 in tableau.Define best practices for Tableau report development.
• Administer user, user groups, and scheduled instances for reports in Tableau. Execute and tested required queries and reports before publishing.
• Develop parameter and dimension based reports, drill-down reports, charts, and Tabular reports using Tableau Desktop.Execute and tested required queries and reports before publishing dashboards.
• Extensively work on Tableau Desktop,by creating Complex reports Create Tableau scorecards, 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.

Confidential

Business Intelligence Consultant

Responsibilities:

• Installation of SAP Business Objects 4.0 on Windows bit Operating system at Clustered environment.
• Migrated content from Business Objects 3.1 to SAP BI 4.0.
• Migrated Universes,BO Web intelligence and Crystal Reports from MS SQL Server to SAP HANA Database.
• Worked on Designer to change the objects, Classes, Parameters as suitable to HANA Database
• Validated Reports with Test Case scenario's and tuned reports for optimal performance.
• Documented changes in Universes& Reports during Migration phase of Project
• Scheduled reports in HANA/SQL Databases to validate performace of reports on each DB.
• Administrated Business objects environment by performing activities like user/Group creation,Setting up access levels,Scheduling and publishing reports as per the user access.
• Enabled Audit and Monitoring Alerts at Central Management Console and checked Server Health.
• Organizing meeting with the users to understand the requirements and guided and exchanged ideas for better analytical outcome.
• Conducting training sessions for better understanding of the application and how to create ?adhoc reports.
• Designing the Security for the different Business groups for report bursting through profiles.
• Creating interactive Dashboards with Tableau Desktop for Executive team.

Environment: Business Objects BI 4.0/3.1 (BI Launch pad,Central Management Console, Information Design Tool (IDT), Universe Design Tool (UDT),SIA),SAP HANA, SQL Server 2005.)

Confidential

Sr. Business Objects Consultant

Responsibilities:

• Migrated the security domain (users, groups and profiles) to XI R2 infrastructure.
• Migrated universes and all related documents from BO 6.5.1 to XI R2 file system using migration wizard.
• Configured all the scheduling jobs through XI R2 framework.
• Integrated mail component on the scheduling job server to send all refreshed documents via e-mail to respective users and groups.
• Used the load balancing by managing various services on different servers in a clustered architecture.
• Used advanced features like Cascading prompts in designer and desktop intelligence reporting.
• Worked with multiple data providers on Web Intelligence reports using synchronized dimensions.
• Gathering and implementing user requirements/ feed backing reporting applications, testing QA and delivery. Extensively worked on Dashboard creation using Application foundation 6.5.
• Created complex Webi reports using all the latest features of Webi multiple data providers, variables etc. used sections, breaks, and filters.
• Conducted Training and Knowledge transfer session with user for understanding tool and to create ad-hoc reports using Meta Topics.
• Designed workflow and dataflow to load the fact table using the source and Dimension tables.
• Used Data Integrator for extraction, transformation and loading of data mart
• Loaded the dimension tables using the staging tables as sources.
• Interacted with functional/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.

Environment: Business Objects 6.1.3/ 6.5.1 , XI R2, BCA, Admin Console,Configuration Tool, Designer, Auditor, ZABO, WebI 6.5,Teradata,Apache 2.0, Tomcat 4.1.3, Oracle 8i/9i.

Confidential

Business Objects Consultant

Responsibilities:

• Created and Maintained Users, User Profiles and Repository.
• Created Web Intelligence/Deski reports for sales management team for analysis.
• Reports were used on weekly basis for analyze the market trend.
• Call Average reports were created and analyzed the impact of the Call average Vs Sales.
• Analysis reports are used for the Focus of the products and analyze the market dynamics.
• Exported the reports to Broadcast Agent and Scheduled, Monitored the jobs.
• Developed Reports and used Slice and Dice Functionality for better user understanding.
• Involved in requirement gathering and presenting Proof of Concepts.
• Involved in Designing and Modifying the New and Existing Universes and Reports.

Environment: Business Objects 6.5,Teradata 6.0, Oracle 8/8i,Designer, Supervisor, Admin Console, Broadcast Agent,Publisher, BCA, Windows NT.

Confidential

Information System Consultant

Responsibilities:

• Created Crosstab reports, Freehand Sql Reports and used multiple data providers and contexts to generate the reports.
• Used Informatica to design, code and test data extraction from multiple databases Oracle and SQL Server and loaded it in target database Oracle.
• Involved in the development of mappings. Most of the transformations were used like Source Qualifier, Aggregators, Filters and Sequence Generator.
• Developed BO Universes using Designer and Business Objects for the reporting solution for reporting System.
• Extensively used Calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Created multi-dimensional reports and ad-hoc reports.
• Created reports in cross tab, master detail format and transformed them in 2-D, 3-D Column, Line, Area, Pie charts for graphical analysis.
• Created reports with conditions and organized data in regions using slice and dice mode and created thin client reports with Ranking, Sorting and Filter objects in Web Intelligence.
• Involved in scheduling of documents monthly, weekly and daily through Broadcast Agent Server.
• Extensively UsedTransformationslike Source Qualifier, Expression, Filter, Aggregator, joiner, lookup, Sequence Generator, Router and Sorter.
• Design, development, implementation, and maintenance of systems, reports and databases Scripts to schedule reports at proper intervals.
• Security module that restricts access to company’s data to the individuals allowed.
• Created a Whole New Infrastructure of BI Delivery mechanism for ease of use to different business groups.

Environment: Business Objects 6.5, Informatica 7.1, WebI 6.5,Crystal Reports,BCA, Oracle,Teradata,Windows-NT.