SUMMARY:

• 11 years of experience in Data warehousing and Business Intelligence with Relational & SAP data sources along with 5 years of data visualization using Tableau
• End to End experience in development and enhancement projects on various domains like Banking, Retail, Oil & Gas, Automobile, Healthcare, & Employment, Manufacturing
• Expertise in Tableau 2018.3.2, 10.x, 9.x and Business Objects 4.0, 4.1,4.2
• Hands on experience on Tableau Desktop versions 8/9/10.5/2018.3.2 , Tableau Reader and Tableau Server.
• Experience in gathering Requirements, Analysis, Design, Development, Deployment, Testing and Support of rich Interactive Dashboards and Workbooks using Tableau Desktop
• Produced attractive visuals/dashboards to convey the story inside the data using with Custom Color Palettes and custom charts.
• Experience in migrating the Tableau Desktop 10.5 to 2018.3.2 version on the server.
• Involved in trouble shooting of performance issues which were associated with Tableau reports
• Proficient in design and development of various dashboards, reports utilizing 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 Dashboard Action, Data Source and Context Filters according to the end user requirement
• Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server and also Performance tuning of dashboards from server.
• Expertise in designing and creating various analytical reports like Performance Dashboards, Score cards and Metrics to help users to identify critical KPIs and facilitate strategic planning in all functional areas including Order Management, Finance and Planning, Process Management and Sales/ Marketing
• Working extensively with Tableau Business Intelligence tool to develop various dashboards.
• Working extensively using Excel to validate the data and use as the source data files.
• Analyzing the data using Statistical features in Tableau to develop trend analysis.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishing or extracted to server
• Strong understanding of relational and in-memory databases like Oracle, Teradata, SQL Provided production support to the existing Qlikview applications and Involved in performance tuning to optimize the functionality of dashboards
• Developed Xcelsius dashboards using hyperlinked detail level drill-down Web Intelligence reports
• Extensive experience in creating reports on Query and Analysis tools like Web Intelligence, Desktop Intelligence and Rich Client using advanced features like Content Linking, Element Linking, Folding
• Experience in SAP BO server configuration, user management, folder security, user rights, promotion management, CMC audit reports, Import wizard and Publishing wizard
• Experience in creating and modifying Universes on Relational data sources and SAP sources using Designer (3.X) and IDT (4.X)
• BO Upgrade from XIR2 to XIR3 and responsible for applying service pack and fix pack to BO installation and deployed WAR files after upgrade.
• Proficient in creating Crystal reports on various data sources Oracle, legacy data and OLTP sources
• Had experience in data modelling using Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Experienced at creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.
• Good understanding of Business Requirements and Process Management added with my proficiency over DWH concepts and reporting tools, helped me translate end user needs into perfect software solutions

TECHNICAL FORTE:

Reporting Tools: Tableau 9/10/2018, SAP BOBJ XI, 4.x, Xcelsius,WebI, Rich Client, InfoView, BI Launch Pad, UDT, IDT, Explorer, CMC, SAP Lumira 1.x, Crystal Reports XI R2/ 2008, BI Widgets, CCM & CMC management, Import Wizard, LCM, DeskI, Publishing Wizard, Report Conversion tool,

Database: Oracle 8i, 9i, 10g, 11g, MS SQL Server 2008 R2, DB2, Teradata

GUI Tools: Crystal Reports, SQL Plus

PROFESSIONAL EXPERIENCE:

Confidential

Tableau Developer

Responsibilities:

• Gathering, reviewing and discussing reporting requirements with business users then prepare consumption documents.
• Creating the dashboard mock ups using the dummy data for the business to have a better understanding of the dashboards to be developed
• Created Rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights
• Built the dashboards with dynamic filters where in selection of filters change based on the dimensions selected.
• Built the dashboards with multiple action filters and reset filters and built visualisations on tool tip of the dashboards.
• As Tableau Site admin, worked on performance tuning the dashboards from server and desktop as well.
• Worked heavily on tableau extracts, excel and live DB connection for the dashboards from multiple data sources using data blending.
• Built many custom charts, custom colour palettes, imported custom shapes based on the user requirement.
• Performed data refresh on Tableau Server on weekly, monthly and quarterly basis and ensured that the views and dashboards were accurately displaying the changes in data.
• Developed Tableau workbooks to perform year over year, quarter over quarter type of analysis
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Environment : Tableau 2018.3.2, SAP HANA, Windows 10.

Confidential

Tableau Developer

Responsibilities:

• Gathering, reviewing and discussing reporting requirements with business users then prepare consumption documents.
• Migrated the desktop version 10.5 to 2018.3.2 and handled the customized logo’s and sign in pages.
• Created Rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights
• Built the dashboards with multiple action filters and reset filters and built visualisations on tool tip of the dashboards.
• As Tableau Server admin, worked on performance tuning the dashboards from server and desktop as well.
• Worked heavily on tableau extracts, excel and live DB connection for the dashboards from multiple data sources using data blending.
• Built many custom charts, custom colour palettes, imported custom shapes based on the user requirement.
• Performed data refresh on Tableau Server on weekly, monthly and quarterly basis and ensured that the views and dashboards were accurately displaying the changes in data.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized using Tableau.
• Created CBSA and MSA level geographical maps though the data is at postcode level.
• Developed Tableau workbooks to perform year over year, quarter over quarter type of analysis
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Experience in creating users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks

Environment : Tableau 10.5, Power BI, Teradata, DB2, Windows 10.

Confidential, NJ

Tableau Developer

Responsibilities:

• Gathering, reviewing and discussing reporting requirements with subject matter experts and business users then prepare consumption documents.
• Created Rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights
• Performed data refresh on Tableau Server on weekly, monthly and quarterly basis and ensured that the views and dashboards were accurately displaying the changes in data.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps, Symbol Maps, Pareto charting, mapping, calculations, demographics and geographic fields according to deliverable specifications
• Developed Tableau workbooks to perform year over year, quarter over quarter type of analysis
• 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.
• Developed Tableau visualizations and dashboards using Tableau Desktop and developed Tableau workbooks from multiple data sources using Data Blending.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks

Environment : Tableau 10.x, Power BI, Business Objects, SAP Lumira, Crystal 2016, Oracle, SAS Studio, Teradata, DB2, Windows 10.

Confidential, IL

SAP BO/Tableau Developer

Responsibilities:

• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps, Symbol Maps, Pareto charting, mapping, calculations, demographics and geographic fields according to deliverable specifications using Tableau.
• Built dashboards with forecast, trend line, lines, MTD, YTD, QTD type of analysis to track
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboards
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets and created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.
• Scheduled extract refresh for weekly and monthly reports and worked on workbook Permissions, Ownerships and User filters and provided production support to Tableau users and Wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Created universe, classes, objects, complex measure objects, prompts, pre-defined conditions.
• Created Cardinalities, Contexts, Joins, and Aliases for loops and checked the Integrity of the Universes.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Created Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Developed complex reports based on discussions with user groups and created various objects using built-in @functions (like @prompt, @select, @where, and @aggregate), complex SQL queries
• Worked extensively with the major functionality of BO like Breaks, Sections, Sorts and Calculations
• Participate in maintenance, performance tune and enhancing the BO universes for individual projects to facilitate the ongoing projects.
• Involved in performing system to system migration and biar file migration of reports and content using CMC.
• Involved in sprint planning sessions and sizing the user stories in AGILE environment.
• Performed admin tasks such as security implementation at report level, folder level and user and content management across all platforms.

Environment : SAP Business Objects product suite 4.1 SP6, Teradata 14.01, DB2, Universe Design Tool, Web Intelligence, Dashboards 4.1,Crystal reports, SAP Lumira, Tableau 8/9.2.5, QlikView 11.20, Supply chain and Windows 7.

Confidential, FL

Business Objects Consultant

Responsibilities:

• Designed the BO Universe based on centralized database GDW (Global Data Warehouse) and ECDW Data Base.
• Reports are developed and migrated to SIT to UAT server for each module using Import Wizard and resolved all SIT and UAT issues.
• Universe level and Report level performance issues are resolved.
• Resolved the loops using Contexts and/or Aliases in the universe and checked the integrity of the universe.
• Created/checked Joins and detected Cardinalities.
• Created/Classified classes and different objects as per the user requirement.
• Universe is designed based on existing Data Model and tested the efficiency whether it meets requirement or not.
• Involved in full life cycle of Business Objects reporting applications.
• Created the user groups and users, set up the privileges to them according to their requirement.
• PIT reports are developed to report at any time based on user requirement.
• Default Prompt is created for PIT reports to display the current FY and Month as default value for given prompt.
• Analyse FRD provided by the user for their requirement.
• Planning of the Security Content of the Users at Object Level.
• Understanding data modelling whether it will meet the reporting requirement or not.

Environment : SAP Business objects 3.1, Import Wizard, Report Conversion Tool, Windows Enterprise Server, Xcelsius, Crystal Reports, Oracle, and SQL Server

Confidential

Business Objects Developer

Responsibilities:

• Delivered status mails to the clients and teams about the reports development issues and Data base related issues
• Performed Scheduling of the reports to the end users Inbox and E-Mails and publishing the reports into public folder
• Trained the end users in working with the Business Objects user module and provided technical expertise
• Coordinated with project manager, business analyst and team members, to analyse business requirements and proposed the outline solution
• Documented all the reports and universe which were migrated and converted to SAP BIBO 4.1
• Created analytical and operational Webi reports with multiple Data providers
• Performed troubleshooting at report and universe level for new requirements
• Performed tuning of reports and UAT reports testing at report level, ensured consistency of the reports
• Designed, Developed and Maintained Universe using designer tool
• Evaluated joins and cardinalities of the existed universe to new local universe with limited classes and objects
• Updated weekly and monthly business reports as the end users requirement
• Generated reports using reporting functionalities like Alerter, Break / Section, Drill and chart
• Designed Business Objects Universe as per the technical specifications and ad-hoc requirements from the client
• Created classes and objects as per the Business requirements, applied conditions in the where clause of measured objects
• Resolved join path problems at universe level and resolved the object level issues while designing the universe
• Designed web intelligence reports by using the functionalities in the business objects
• Managed to work with optional prompts, block filters and customized breaks at report level for specific requirements
• Developed reports using multiple queries for different end users, as per the special requirement of the project
• Exported the existing universes and related reports to the CMS repository to the specified folders

Environment : SAP Business objects, Windows Enterprise Server, Xcelsius, Crystal Reports, Oracle, SQL Server

Confidential, NL

Business Objects Developer

Responsibilities:

• Involved in Design, Development and Maintenance of the Universes
• Involved in troubleshooting and resolving join path problems like Loops, Chasm Traps and Fan traps by creating Alias, Context
• Involved in applying Row Level and Object Level Access Restrictions in the Universe for to restrict the data, classes and objects to end users in the Info View and Web Intelligence Rich Client components
• Involved in doing all the administration, configuration and monitoring tasks in Central Management Console
• Involved in Scheduling of Web Intelligence reports in Info View and Central Management Console
• Involved in monitoring the status of all the Scheduled Instances through Instance Manager in Central Management Console
• Developed and maintained a user-friendly Graphical representation of Dashboard reports like charts and trend analytics which provides an instant access to all critical information and reports on all the departmental operations for the Business users
• Involved in creation of BIAR files which includes Universes, Web Intelligence reports on Development environment
• Sending the status mails to the clients and teams about the reports development issues and data base related issues
• Involved in production support for all the customers through activities and tickets requests system
• Co-ordination with Development and production teams for moving the application into Production

Environment : Business Objects XI R2, Desktop Intelligence, Web Intelligence, Oracle 8.1.6, Informatica