SUMMARY

• Extensive experience in 5 End to End SAP BO Implementations. BO Versions - BO XI R2, 3.0,3.1,4.0,4.1,4.2
• Very good understanding of the detail level data warehousing concepts and implemented in many assignments.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• 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.
• Good experience in Installation and configuration of business objects in multiple servers, creating and maintaining the central management console.
• Knowledge in creating and maintaining universes in Business objects universe designer.
• Good working knowledge on creating and maintaining dashboards using Xcelsius and Dashboard Designer.
• Expertise in various phases of Implementation in both SAP and NON-SAP environments.
• Well versed with business analysis and end-user requirement analysis.
• Scheduling and Troubleshooting load problems, Business report errors and Troubleshooting.
• Excellent analytical, organizational, planning skills with demonstrated abilities in leading motivated teams towards achieving organizational goals.
• Good exposure in creating and maintaining most challenging reports in web intelligence, desktop intelligence.
• Work experience in integrating BO with SAP environment and created reports.
• Developed Business Objects Universe, Business objects dashboards, Web intelligence reports.
• Experience in Configuring and development of SAP BPC.
• Excellent analytical and communication skills that are required to work effectively in the field of applications development and maintenance.

TECHNICAL SKILLS

SAP BO / Analytics / Visualizations: XIR2/XI3.0/XI3.1/4.0,4.1,4.2, Web Intelligence, Xcelsius 2008, SAP Lumira, Data Visualization, SAP BO Mobile, Dashboard Designer 4.0, Crystal reports, SAP BW, Voyager, Live Office, Polestar, Explorer, QlikView, Tableau 7, 8,9,10.5

Operating Systems: MS Windows 2010/2000/XP/NT, Mac OS, Unix and Linux.

RDBMS: Oracle 11g/10g, MS-SQL Server 2000/2005/2008 , DB2 MS Access, MySQL.

Web Technologies: HTML, XML, CSS, XSD, JavaScript and JSON

Technical Languages: Core Java, SQL, PL/SQL, C, C++

Web/App Servers: Apache Tomcat 6.0, web logic8.1/9.2

Others: Quick Test Professional 9.0 & Bugzilla.

PROFESSIONAL EXPERIENCE

Confidential

Team Lead

Responsibilities:

• Administration of servers, SAP Business Objects 4.1 Platform, Data Services ETL, Tomcat web servers, Crystal Reports, and Xcelsius Dashboards, Active Directory SSO.
• Successful roll out and upgrade of a virtualized Business Objects Platform 4.1 with FP3.
• Created reports using Web Intelligence tools with Business Objects Universe, BEX Queries and SAP HANA Studio as the Data providers.
• Configured and development in SAP BPC environment
• Developed reports using BPC datasource.
• Extensively used Web Intelligence reporting functionalities such as Filters, Ranking, Breaks, Formulas and Alerts etc.
• Created and maintained Business Objects reports in Web Intelligence Info View and BI Launchpad.
• Created Crystal reports as per Business requirement document.
• Scheduled daily, weekly and monthly company turnover reports of Web Intelligence as per the business requirements.
• Developed new reports using Business Objects functionalities like Queries, Cross Tab, and Master Detail etc.
• Developed additional Dashboards for Surgery, Radiology, Rehab Services, Child Care Dashboards using Dashboard Designer 4.0 and SAP Lumira.
• Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Extracted Data from all the Relational Databases using BODS 4.1 and loaded in different environments.
• Worked on the DI scripting & prepared a standard Incremental load template which enables the job failure/success notifications.
• 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.
• Restricted data for users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Provided 24/7-production support for Tableau users.

Environnent: Business Objects Data services 4.1, SAP Business Objects 4.1, 4.2, Web Intelligence, BO Mobile, Explorer, Information Design Tool, Dashboard Designer 4.0, Design Studio, SAP BW, BEX Queries, HANA Analytics, SAP Lumira.

Confidential, Milan, IL

Senior Consultant / Senior Developer

Responsibilities:

• Installing and Administration of entire hardware, and software products like Tomcat, and Apache (Clustered and Standalone environments).
• Installed and tested the BI4.0 application on sandbox.
• Worked with server team to provide them with list of specifications need to build the servers for BO4.0.
• Worked with Developers to consolidate the Business Objects repository before migrating to BO4.0.
• Effectively administered and supervised the Business Objects (SAP BI) environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
• Created Repositories, Users & assigned the security in the Multi-Team Environment.
• Worked on the BW open Hub tables to extract the data from the BW.
• Extracted Data from all the Relational Databases including oracle, Microsoft SQL server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.
• Worked on the DI scripting & prepared a standard Incremental load template which enables the job failure/success notifications.
• Created Global variables to read the files from the shared location from the BODS Designer Also worked on the FTP process to put & get the files on the data-exchange servers.
• Worked on all the standards & guidelines Best practices Documentation, and the functional & Technical design specification documentation.
• Migrated all the Projects of the team from DEV TO TEST TO PS TO PROD, & scheduled the jobs as part of the Administrator.
• Worked on the Data Quality, Address cleanse transformations for cleansing the data
• Provided the technical guidance & knowledge transfer of effectively using BODS4.0
• Developed SSIS Package to centralize the Data coming from different Data Sources which is used for developing new reports.
• Developed SAP reports for different modules using source as BW. BW reports have been migrated to SAP BO.
• Made enhancements to the existing Universes for Revenue, Minutes of Usage and Leased Line Voice Grid Services as per the requirements.
• Developed new reports using Business Objects functionalities like Queries, Cross Tab, and Master Detail etc.
• Developed additional Dashboards for Revenue Segment wise and Group wise.
• Developed additional Dashboards for Monthly Revenue, Yearly Revenue, Number of Lines, Bandwidth Sold, Revenue by Product and Revenue by Market Segment using Xcelsius and Dashboard Designer 4.0, SAP Lumira.
• Understand the Requirements and Functionality of the application from specifications.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Converted existing BO reports to tableau dashboards
• Created different KPI using calculated key figures and parameters
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• 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.
• Prepared and Executed Test Cases for the developed reports.

Confidential

Developer / Consultant

Responsibilities:

• Migrated various applications from 5.1 & 6.5, XI R2 to 3.1and provided support to new Environment.
• Configured servers in XI R2 for Development, Test and Production environments and created group structure
• Designed BO Report templates.
• Involved in day to day Business Objects Server maintenance.
• Implemented best practices for using Business Objects Suite.
• Provided support to resolve client technical issues.
• Expertise in BO XI R2 CMS and complete security model at BO enterprise level.
• Well versed in BOE architecture, Services process flows, content, security, scheduling and publishing.
• Conducted end user training sessions and prepared training material.
• Worked as SAP BO Consultant and Tableau Developer roles.
• Using Tableau server versions (6.0) as a front-end BI tool and Microsoft SQL Server 2012 as a back end database designed and developed workbooks, dashboards, global filter page, and complex parameters based calculations.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Developed a 360 business dashboard with multiple panels and parameters that became a favorite sales tool for most of the sales force at CE.
• Implemented Tableau mobile dashboards via Tableau mobile application.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Created Repositories, Users & assigned the security in the Multi-Team Environment.
• Worked in the BODS3.0 Environment, the entire project implementation was on 4.0
• Worked on the IDOC’S, Batch/ real time jobs to extract the data from the SAP/ECC system, and load into the staging data-base for the multiple projects.
• Worked on the BW open Hub tables to extract the data from the BW.
• Developed SAP Reports for different modules using BEX Queries and Universe Designer
• Extracted Data from all the Relational Databases including oracle, Microsoft Sql server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.
• Worked on the DI scripting & prepared a standard Incremental load template which enables the job failure/success notifications.
• Created Global variables to read the files from the shared location from the BODS Designer Also worked on the FTP process to put & get the files on the data-exchange servers.
• Worked on all the standards & guidelines Best practices Documentation, and also the functional & Technical design specification documentation.
• Migrated all the Projects of the team from DEV TO TEST TO PS TO PROD, & scheduled the jobs as part of the Administrator.
• Worked on the Data Quality, Address cleanse transformations for cleansing the data
• Provided the technical guidance & knowledge transfer of effectively using BODS 3.0
• Installation of SAP BO 3.0/3.1 on Development and Production Server.
• Installation of SQL Server 2008 for SSIS Integration
• Data Extract from existing data sources Like ARBOR, INBILL, CRM/CMS, BPM
• Data transformation using SSIS to new Database
• To execute pre-defined scripts in SSIS
• To run scripts, joins, and business logic according to TIME dotcom Business report requirement in new SSIS
• Created SSIS Package to centralize the Data coming from different Data Sources which is used for developing reports.
• Developed Universes for Revenue, Minutes of Usage and Leased Line Voice Grid Services.
• Developed reports using Business Objects functionalities like Queries, Cross Tab, and Master Detail etc.
• Developed Report enhancements by creating variables, Alerts and Grouping data.
• Developed reports using the business object functionality like Slice and Dice using Breaks, Sorts, Sections, Calculations and Filters.
• Set up Scope of Analysis for Drill Down and snapshot reporting.
• Prepared and Executed Test Cases for the developed reports.
• Creation of Dashboards for Monthly Revenue, Yearly Revenue, Number of Lines, Bandwidth Sold, Revenue by Product and Revenue by Market Segment using Xcelsius and Dashboard Designer.

Environnent: Business Objects Data services 3.1, SAP Business Objects 3.1, Web Intelligence, BO Mobile, Explorer, Universe Designer, Xcelsius 2008, SAP BW, BEX Queries, ECC 6

Confidential

SAP BO Consultant

Responsibilities:

• Developed Xcelsius interactive Dashboards using Radio Button, Ticker and Pie Chart to show relation between States, Category in different Regions.
• Created Xcelsius dashboards using Query as a web service & Live Office.
• Conducting Case / System / Process Study for project planning.
• Supporting the implementation of project plans within deadlines.
• Creation of customized queries.
• Developed SAP reports for different modules. As a production company most of the reports developed for SAP FICO, SAP SD and SAP MM
• Communicating with users and analysts to interpret requirements, resolve problems within the warehouse.
• Developing loaders, data processing modules etc.
• Managing dependencies and workflow management with scheduling functions.
• Designing the Backup and Recovery Strategy with disaster recovery & troubleshooting.
• Design & Development
• Interaction with team members and gathering information for analysis.

Environment: Business Objects X I 3.0, Xcelsius 2008, SAP BW.

Confidential

SAP BW Trainee

Responsibilities:

• Design & Development
• Worked as a BW Trainee as a part of Development Support team, which is responsible for monitoring, scheduling and troubleshooting load problems, business report errors and troubleshooting.
• Analyze the errors in the data loads, Bex reports, and source systems like R/3, CRM, SEM, and APO.
• Manage the data targets.
• Checking data in Extractor checker RSA3, PSA, ODS, Cube and Bex.
• Creation of customized queries.

Confidential

Software Test Engineer

Responsibilities:

• Responsible for entire activities related to test management, server administration, escalation process & tool management.
• Handling a gamut of tasks pertaining to:
• Creating & executing the Test cases.
• Conducting Functionality testing, GUI testing, Manual & Automation testing process to ensure the quality of the software.
• Retesting for various modules.
• Execution of Test Cases and Test Scripts (automated testing, validating).
• Handling entire responsibility of implementation and management of test case tool for Test Case Development. Preparing, reviewing and Executing Test Cases based on the Functional Specification/Requirement Analysis document provided for the project and writing test cases by evaluating the application under test.
• Handling entire responsibility of implementation and management of Bug Tracking tool, Defect Logging and Reporting using Bugzilla.
• Involved in a gamut of testing phases including requirement study, test case / scenario development, test scenario and test cases review, bug review, work and effort estimation.