SUMMARY

• Over 12 years of experience in Information Technology with strong work experience as SAP Business Objects and Tableau Developer.
• Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.
• Expertise in documenting the requirement like creating Business specifications, Unit test cases, Unit Test Scripts, Code review and Design & Configuration specifications.
• Experience in multiple versions of Business Objects ranging from BO 6.5 to XIR2/R3/3.1 and 4.1/4.2 suites.
• Exposure to all phases of Business Objects projects - broadly including Development, Testing, Production, Support, Migration, Installation and Configurations to newer versions.
• Extensively worked on WEBI/Xcelsius, Crystal Reports, Information Design Tool (IDT) (UDT), Central Management Console (CMC), Native SQL of Oracle and Sql Server.
• 2 Years of experience in developing dashboards using Tableau Desktop.
• In-depth understanding of Business Intelligence Tools, BI Platform Architecture, User Management, Folder Security, Scheduling /Distribution strategies, Performance Tuning and creating Relational/OLAP connections to SAP/Non-SAP data sources.
• Strong database experience in using Oracle 10g/9i/8i, MS SQL Server 2008/2005.
• Good Communication and Interpersonal skills. Ability to learn and adapt to new technologies quickly that keeps business value intact.

TECHNICAL SKILLS

Reporting Tools: Business Objects 6.5/XI/3.1/4.1/4.2, UDT, IDT, Web Intelligence, Crystal Reports 2013/2016

ETL Tools: Informatica Power Center 8.1.1/8.6/9.1

Databases: ORACLE, SQL Server

Dashboard Tools: Crystal Xcelsius, Tableau 9/10

Operating System: Windows

PROFESSIONAL EXPERIENCE

Confidential

SAP BO Consultant

Responsibilities:

• Analysing the existing CVS Environment and EPIC platform and proposing a reporting Solution.
• Scheduling meeting with End Users to document the requirements.
• Created Business Requirement specifications and Design Documents and getting them approved by AAA Teams.
• Conducted Business requirement walk throughs to get approval from Business users.
• Worked closely with EPIC Architect to understand the mapping between EPIC and Clarity and created SQL’s as a logic which feeds as a source to Informatica and Crystal Report Command.
• Worked with Informatica team to create tables from different databases by providing logics from Clarity.
• Created Epic accordant universe and generated various weekly, Monthly, Quarterly Web Intelligence reports.
• Created Free Command reports using Crystal Reports 2016 for daily reports.
• Created User acceptance testing cases.
• Working on Test scripts.
• Working with EPC Cogito/BO administrator to deploy the reports to BO Environment.

Confidnential

SAP BO Consultant

Responsibilities:

• Analysing the existing Cognos report and defining BO Report specification documents.
• Interacted with Business Users, Business owners to know their Business requirements in developing and modifying Universes and Reports accordingly.
• Developed Core Universes for Confirmed and Shared reference tables.
• Developed linked universe for Engineering Dashboard, Superview, Spotlight and Underwriting derived from the core.
• Development of new universes with multi facts and created different views for each context.
• Designed and maintained complex Universes, resolved loops by creating aliases and contexts.
• Used advanced universe functionalities like, Index Awareness, custom LOVs.
• Created custom hierarchies to aid in Drill-Through analysis of WebI documents and built cascading prompts.
• Security implementation for Business layer views for different group of power users.
• Managing universe changes on updates from the backend.
• Developed complex Web Intelligence reports by grouping data different levels from detail, Report linking, Hierarchical reports which has multi-level of drilling features, Input Controls, graphically showing the data in Charts.
• Extensively used reporting functionalities such as Master Detailed, Drill, Filters, Ranking, Sections, Graphs and Breaks.
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, User Objects in the creation of reports.
• Standardized Web Intelligence reports by adding Parameters tab to each report showing the documentation of the report.
• Peer reviewing the reports developed by offshore before sending it to UAT.
• Unit tested the reports against Warehouse source data.
• Created Dashboards for Underwriting, Spotlight using Tableau Desktop and published them to the Tableau Server.
• Fixing issues raised in UAT and help end users in getting through the UAT.
• Server Installation on Web & Application servers for DEV Environments.
• Configuring APS, SSO, TOMCAT, CMC, AUDIT, WEB DEPLOYMENT SPLIT & BRANDING.
• Client tools installation.
• Content migration using the new Promotion Management Wizard.
• Testing the new environment.

Confidential

BO Developer

Responsibilities:

• Requirement gathering from the Oracle and functional teams.
• Individually Designed Complex Universe for 6 Business Processes, which constitute of 400+ tables and 5000+ Objects.
• Implemented Row level security for BOTOX/NONBOTOX groups based on Division.
• Created 120+ Standard Web Intelligence reports for Universe Data Testing and Compared the Web Intelligence report data with Source GTW system data using Microsoft Power Query.
• Created User Prompts, Conditions and Filters to improve the quality of report generation.
• Extensively worked with variables and calculation contexts in designing reports.
• Preparation of Design/Configuration Specification document, which documents the entire universe (Tables, Joins, Objects, Conditions and Structures) .
• Prepared Unit Test Scripts and Unit Test Sets for Universe and Report testing.
• Prepared Code Review document and assisted in Execution of Code Review and Unit testing which will be done by Client-Side IT Team.
• Developed Shipment Tracking Analysis dashboard using Tableau.

Confidential

BO - Lead Consultant

Responsibilities:

• Prepare, Analyse, Plan, Implement, Deployment and Maintenance of Universes.
• Enhancements to the Existing Universes for new Report requirements.
• Development of new universes with multi facts and created different views for each context.
• Converted 3.1. unv format Universe to 4.1 .unx format.
• Created complex reports using Crystal Reports and Web Intelligence.
• Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and Formulae’s etc.
• Applied drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Created Web Intelligence Reports on top of BW BEX Queries using BICS Connectivity.
• Created Dashboards using Crystal Xcelsius using QWAAS, Web Intelligence.
• Deployment of universe, Connections and Reports to Production.
• Maintaining Versioning through Version Management.
• Administrating Users, Groups and Content through CMC.
• DR Planning and Implementation. Conducting Quarterly DR tests