PROFESSIONAL SUMMARY:

• 18+ years of IT experience in Analysis, Design, Development and Implementation of Relational Database (OLTP) and Data Warehousing Systems (OLAP).
• 14+ years of experience in SAP Business Objects suite BOBJ 4.X / 3.X / XIr2/6.x/5.x (CMC, UDT, IDT, LCM, DeskI, WEBI, WRC, Crystal Reports 2008/2011/2013 , Crystal Enterprise, Xcelsius/Business Objects Dashboard, Live Office, QaaWS, BI Services, Version Manager, Explorer, Analysis for OLAP/Office, and BEx Analyzer, BEx Query Designer, Web Analyzer and SAP BW.
• 7+ years of hands on experience in administration, development and deployment of Reports and Dashboards in Tableau Desktop and Tableau Server suite 7.X/8.X/9.X/10.X/2018.1
• Experienced in developing Device Specific Dashboards (DSD) for iPad and mobile devices like iPhones and android using tableau V10.5.2.
• Experienced in creating aggregates, hierarchies, charts, filters, quick filters, table calculations, trend lines, calculated measures in Tableau Desktop.
• Used several objects - Vertical, Horizontal, Blank, Tiled, Floating, Text, Web-page, Image in order to create efficient dashboard using Tableau Desktop.
• Experienced in both Live and Extract connection to access data.
• Experienced in creating Users, Groups and Projects and their administration on Tableau Server.
• Working knowledge on Data Migration applications such as Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Experienced in deployment of Business Objects and Tableau from various sources like Oracle, Teradata, MS SQL Server, DB2, Access and OLAP sources such as SAP BW.
• Industry expert in BOBJ-BW and BOBJ-HANA integration.
• Strong working knowledge on InfoCube, MultiProvider, DSO, BEx Query designing etc.
• Clear understanding of Conceptual, Logical and Physical Data Modeling.
• Expert level knowledge of Star Schema, Extended Star Schema and Snow Flake Schema.
• Well versed with SAP HANA.

TECHNICAL SKILLS:

Databases: SQL Server 2005, ORACLE 8i/9i/10g/11g, DB2, MS Access, Teradata v2R3

BI Tools: Business Objects 4.X/3.X/XIr2/6.x/5.x, WEBI 6.x/2.x, CMC, UDT, IDT, DeskI, WEBI, WRC, LCM, Report Conversion Tool, Crystal Reports 2008/2011/2013 , Crystal Enterprise, Xcelsius/Business Objects Dashboard, Live Office, QaaWS, BI Services, Version Manager, SAP BW, BEx Analyzer, BEx Query Designer, Business Objects Design Studio, Analysis for OLAP/Office, SAP Lumira, Tibco Spotfire, Tableau 7.X/8.X/9.X/10.X/2018.1

ETL Tools: Informatica 8.1, SAP BI/BW

Languages: SQL, SQL Plus, SQL Loader, PL/SQL C, C++

SDLC Methodology: Scrum Agile and Waterfall

Modeling Tools: ERwin 4.0/3.x

Operating Systems: Windows 10/8/7/XP/2000/NT/98/95/3.1,UNIX

WORK EXPERIENCE:

Confidential, Detroit, MI

Technical Lead / Architect

Responsibilities:

• Built and led Tableau COE for this project.
• Defined the design standards, naming conventions and best practices. Created the templates from the scratch for Technical Specifications, Unit Test, SIT and UAT.
• Worked with Business Analysts and Business users to understand the user requirement, layout, and look and feel of the application to be developed.
• Led and guided the team providing Tableau technical solutions for reports and dashboards.
• Provided effective solutions for self-service reporting for a new user group.
• Created materials and provided Tableau to the end users.
• Guided the Atscale developer to create robust semantic layer so that data is properly modelled for Tableau reports / visualizations.
• Managed server level security for different users’ groups.
• Conducted code reviews to ensure compliance with design specifications and with technical standards.
• Accountable and responsible for full life cycle delivery.

Environment: Tableau 18.1, Cloudera, Hive, Impala, Hue, Atscale

Confidential, Princeton, NJ

Vice President - Tableau Lead / Architect

Responsibilities:

• Introduced Tableau visualization tool and its capabilities to the entire department.
• Defined BI Roadmap and strategy for short term, mid term and long-term goals.
• Developed, executed, and communicated project / deliverable timeline.
• Managed project scope and change request.
• Led, managed and guided a team of technical, functional and business resources for requirement gathering, report / visualization development, documentation, testing and production support.
• Worked with Business and Technology teams to propose solutions, prioritize on-going BI demands and provide strategic direction.
• Created developer guide and best practice document for Tableau Implementation.
• Developed some complex, crisp and user-friendly industry standard dashboards.
• Helped the investment team from visualization and data analysis perspective to make more than $300M investments.

Environment: Tableau 10.5.2, Sybase

Confidential, Pennington, NJ

Senior Tableau Consultant

Responsibilities:

• Gathered and documented business requirement and prepared functional design document.
• Translated business requirement into technology solutions and prepared technical design document.
• Developed and created Tableau reports and dashboards and cooperated with the Business Lead for delivery and acceptance.
• Created test scripts and led unit tests and QA tests, and cooperated in UAT.
• Helped and guided the admin team for migration and security.

Environment: Tableau 10.0, SQL Server, Oracle

Confidential, Houston, TX

Senior Tableau Consultant

Responsibilities:

• Gathered requirement and developed visualization for Europe and Asia groups.
• Created multiple dashboards based on live connection on HANA data source.
• Created Bubble chart, Box & Whisker plot, Whale Curve as per the client requirement.
• Provided useful inputs to HANA developers to create views for Tableau development.

Environment: Tableau 10.0, SAP HANA

Confidential, Warsaw, Indiana

Senior Tableau Consultant

Responsibilities:

• Worked as a site administrator and implemented users and groups level security.

Environment: Tableau 9.3

Confidential, Seattle, WA

Managing Consultant

Responsibilities:

• Developed multiple reports and dashboards, analyzed the trends and forecast using Tableau on SAP HANA data source
• Developed highly polished executive level dashboard for the Operations Research group which provides BI for different Airlines to implement their decision support systems for developing competitive fares, low fare schedules, optimizing the code share data between partner airlines, etc.
• Created multiple dual axis and blended axis charts.
• Developed operational reports using BOBJ 4.1

Environment: SAP HANA, Tableau 9.0, Business Objects 4.1

Confidential, Brookfield, WI

Tableau Developer / Admin Technical Architect

Responsibilities:

• Created users and groups in Tableau Server and managed their roles, responsibilities and privileges based on their usage levels. Scheduled instances.
• Managed access to user groups to their respective projects and dashboards.
• Designed and developed the most suitable User Interface such as Dashboards, multiple chart types, Trends, custom requests for Excel Export and objects for Management Dashboard reporting.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Created quick filter to narrow down individual states and cities along with revenue being generated in individual state or city.
• Created side by side bar chart comparison of Confidential SmartPost customers who were domestic vs. international along with providing profit revenue generated.
• Performed data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.

Environment: Oracle 11g, Teradata 14.10, Tableau 9.0, Ab Initio

Confidential, Saint Cloud, MN

Tableau Developer / Admin

Responsibilities:

• Created new projects and provided access to user groups to their respective projects
• Managed and Controlled the user groups that have access to sites
• Scheduled data extract refresh
• Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Trend Lines, Statistics, and Groups, Hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Restricted data for particular users using Row level security and User filters.
• Extensively used data blending, embed functionalities in Tableau.
• Provided 24/7 production support for Tableau users and conducted s to users on interact, filter, sort and customize views on existing visualizations generated thru Tableau Desktop.

Environment: Oracle 11g, Tableau 8.2

Confidential, Lake Forest, IL / Mason, MI

BOBJ Lead with Tableau Independent Consultant

Responsibilities:

• Developed reports and dashboards in Tableau Desktop and deployed, organized, managed and maintained them in Tableau Server.
• Created users, groups and projects, maintained their roles and responsibilities in Tableau Server.
• Created Data Source and published in the server based on users’ need.
• Assigned and managed tasks to the BOBJ and Tableau team members, reviewed weekly status reports.
• Served as a liaison between business and IT department by conducting weekly calls / meetings with stakeholders, developers, QA Team, UAT Team to document any changes and apply them to Tableau/BOBJ reports/dashboards as needed.
• Created ‘Best Practice Document for Implementing BOBJ on SAP HANA’.
• Involved to create best practice guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.
• Worked with the end users to make sure that our BOBJ/Tableau reports/dashboards are users’ friendly, easily understandable, meet their expectation and easily accessible.
• Led the team to make sure all the tickets are properly resolved and the users are fully satisfied.
• Worked with client manager to build the team and interviewed interns, BOBJ, Tableau and HANA resources as part of hiring policy for Dart.
• Helped the client manager to define strategy, vision, short term, mid-term and long-term goals.
• Advised client manager about ROI and cost-benefit analysis as part of long-term plan.

Environment: Microsoft Project 2013, Business Objects 4.0 (WEBI, IDT, CMC), Business Objects Dashboard, Business Objects Analysis for OLAP/Office, Crystal Reports Enterprise, SAP BW 7.3, BEx Analyzer, Query Designer, SAP HANA, HPQC, Solution Manager, Tableau 8.2, Oracle 10g

Confidential, East Peoria, IL

SAP Business Objects Lead

Responsibilities:

• Helped the client to prepare the initial phase of Business Blueprint
• Helped the client to define the BI Roadmap, Resource Allocation, Project Planning, Complexity Analysis, Dependency Analysis, Gap Analysis and Risk Analysis.
• Involved in detail requirement analysis and helped the management to make the proper decision whether to use existing data warehouse or to create BEx queries using existing Info Providers.
• Developed and guided both onsite and offshore team to develop reports and dashboards on both SAP BW-BO and Data Warehouse environment.
• Created all the necessary documentation templates as this is a new project.
• Resolved and also assigned tickets to the team for any issues mentioned in the ticket. Managed the change requests.
• Created meaningful BPPs (Business Process Procedure) using UPK and published them for end users.
• Created weekly and monthly demand and shipment report in excel using SE 16 extraction.
• Resolved and guided SAP BW-BO integration issues.
• Helped the BW/BEx developers about the best practices of BW-BO integration.
• Introduced SAP HANA and Tableau as per future roadmap.
• Created the prototype and developed POC worksheets and dashboards in Tableau as per future plan.
• Developed and enhanced universe in relational environment.

Environment: BOBJ 4.0/3.1 (IDT/Designer, WEBI, Explorer), Business Objects Dashboard, Crystal Reports 2011, SAP BI 7.2, BEx Analyzer, Query Designer, HPQC, UPK, Teradata, SAP HANA, Tableau 7.1

Confidential, Morgantown,WV

SAP Business Objects (/ SAP BW Integration) Lead Consultant Solutions Architect

Responsibilities:

• Helped the SAP BW lead for initial analysis of all the existing Crystal Reports.
• Decoded the Crystal Reports codes and prepared the initial document for further analysis.
• Being the only expert in SAP BW-BO integration in the team, I was coordinating and guiding the back end developers to map the ECC fields and to develop the appropriate BEx queries.
• Helped the BW/BEx developers about the best practices of BW-BO integration.
• Led and educated the offshore BO resources about BEx Query Designer, BEx Analyzer, BW-BO Integration and WEBI reports.
• Responsible to monitor, mentor, develop and manage every aspect of Business Objects and BW-BO integration.
• Responsible for all the universes’ and reports’ designing, development and change request.
• Would have been responsible for test script creation, reviewing and approving the test, documentation and new template/document creation.
• Accountable for any delivery related issues.

Environment: Business Objects XI 3.1 (Designer, WEBI), SAP BI 7.2, Business Objects Integration Kit for SAP, BEx Analyzer, Query Designer, HPQC, SAP BOBJ 4.0.

Confidential, Pittsburg, PA

SAP Business Objects (/ SAP BW (BI) Integration) Lead Consultant Manager

Responsibilities:

• Prepared SOW/SLA for Confidential . Led six (6) Business Objects resources from Confidential .
• Was accountable for project planning, timelines, development and delivery from Confidential side.
• Designed, Developed and Managed OLAP universes and WEBI reports for PS, MFG, SCM, FI and HCM functional area which will be used more than 50 countries around the world.
• Coordinated and guided the backend BW developers to develop the BEx Query to meet the reporting requirement.
• Helped the client to resolve their BOBJ-BW integration issues.
• Guided the client BOBJ Lead and the project Lead to standardize the WEBI reports, universe designing decisions, promotion procedures from DEV->QA->Prod and ad-hoc reporting.
• Helped the client project lead to create the test script and performed unit test in QA using HPQC.
• Recommended some best practices for project planning, reporting standard, documentation, Pre Go-Live, Post-Go-Live support, supporting users and knowledge transfer.

Environment: Business Objects XI 3.2 (Designer, WEBI), SAP BI 7.2, Business Objects Integration Kit for SAP, BEx Analyzer, Query Designer, HPQC, SolMan.

Confidential, Wilmington, DE

Senior SAP Business Objects (/ SAP BW (BI) Integration) Consultant

Responsibilities:

• Created technical specification templates for universes and reports.
• Created naming convention document for universes, reports (WEBI & Crystal) and dashboards.
• Created best practices documents for ‘Implementing SAP Business Objects on SAP Netweaver Business Warehouse’.
• Developed reports in Crystal Reports, WEBI and WRC for MM, HR, FI-CO, PP and SD data.
• Created unit test template to perform unit test for the reports.
• Performed unit test for the reports. Compared the WEBI result with the BEX Analyzer result.
• Created product test template and performed the product tests for the reports in QA environment.
• Developed universes and reports from both relational and OLAP data sources.
• Led the offshore resources to develop universes and reports.

Environment: Business Objects XI 3.1 (Designer, WEBI, WRC), Crystal Reports 2008, SAP BI 7.2, Business Objects Integration Kit for SAP, BEx Analyzer, Query Designer, Oracle 10g.

Confidential, Scottsdale, AZ

Senior Business Objects Consultant

Responsibilities:

• Conducted internal and external customer meetings to produce business requirements for reporting, including detailed design requirements and prototypes.
• Coordinated requirements review sessions, incorporated feedback, and obtained needed approvals.
• Worked extensively with the major functionalities of BO like Breaks, Alerters, Filters, Sorts, Query Prompts, Combined Query, Sub-Query, Drill-up, Drill-Down and Drill-By.
• Created complex reports by linking objects from different data providers (universes on different databases) using Merge Dimension Option.
• Created custom hierarchies, conditions, prompts, derived tables and used short-cut joins, outer joins and @aggregate aware.
• Used Version Manager for version controlling and publishing reports and universes based on the SDLC Process (Dev Test PROD).
• Assigned categories and properties for all new daily, weekly and monthly reports.
• Helped in production support for all call center reports.
• Created various corporate dashboards for presentation purposes using Crystal Xcelsius 2008.

Environment: Business Objects XIr3/XI3.1(Designer, DeskI, WEBI, WRC), Oracle 10g, SQL, TOAD 9.5.0.31, Crystal X-Celsius 2008, Version Manager V12.1.0.2.

Confidential, Simi Valley, CA

Senior Business Objects & Crystal Reports Consultant

Responsibilities:

• Involved in updating and managing of Universes, Classes and Objects.
• Designed and developed the Functional Analysis and Technical Design like Joins, Shortcut Joins, Contexts, and Cardinalities of the tables and structures of the Universe.
• Incorporated functions such as @Aggregate Aware, @Select, @Where and @Prompt in Universes.
• Generated complex reports using Crystal Reports functionalities such as parameters, formula workshop, and alerts.
• Used the advantages of Experts in Crystal Reports for Grouping, Sections, Selection and Sorting.
• Included in reports advance features such as sub-reports, cross-tabs, charts, and hierarchical structures.
• Set up groups and users for Business Objects deployment and managed user profiles.
• Generated various numbers of reports on a daily, weekly and monthly basis.

Environment: Business Objects XIr2 (Designer, WEB Intelligence), Crystal Reports 2008, IBM DB2 V.8, SQL Server 2005, SQL, TOAD 9.0, Windows XP, and Lotus Notes 6.5.