Raman Gupta BO Specialist

Phone : 602-***-****

Email: ac7zrc@r.postjobfree.com

Relocation: No

Current Location: AZ

Residency Status: US Citizen

Professional Summary:

Over 10+ years of experience in SAP Business Objects reporting suite, Crystal Enterprise and Tableau reports development including building dashboards for analytics in Tableau Desktop and Tableau Reader in multiple versions.

Extensively worked on Business Objects on Information Design Tool (IDT), Universe Design Tool (UDT), Web Intelligence Rich Client, BI Launchpad, Infoview, Crystal Enterprise, Xcelsius, Live Office, Query as a Web Service (QaaWS), Central Management Server (CMS), Central Management console (CMC) on Business Objects 3.1, 4.1 and 4.2 versions.

Experienced and proficient in use of Infoburst and 360 EYES to enhance and support the Business Objects platform.

Experienced in developing semantic layers (Universe) in Business Objects based on reporting requirements and dealt with various Universe related Loops, Traps, Alias Tables, @ functions, Derived Tables, prompts, hierarchies, restrictions, LOVs and Universe Parameters.

Developed Object level and Row Level restrictions on different user groups at Universe level and implemented Index Awareness for complex reports.

Developed simple, medium and complex reports like On-demand, Ad-hoc, Canned, Slice and Dice, cross-tab and master detail, Alerter and Ranking reports using Web Intelligence tool and used combined queries, merging dimensions, complex functions at report level and applied complex filters as required.

Developed Complex Ad Hoc Reports, Summary Reports, Drill-down, Dynamic grouping, graphical and aging reports.

Used Xcelsius Visualization of dashboards to pull data from required reports to Excel sheet using Universe as data source. QAAWS & Web services, Live Office as a middle ware using Data feeding to Excel sheet and analyzed, Designed and developed dashboards.

Exported Dashboards to BOE Server and created visualization contents to various file formats (pdf, ppt, and html, flash).

Extensive Experience on SQL Server 2012, Oracle 10g and DB2, Data Warehouse concepts, Database Design/Architecture including both OLAP & OLTP data and complete lifecycle of project from design to development and implementation.

Worked with both SDLC Methodologies –Agile and Waterfall Model.

Good team player, with attention to detail and ability to handle projects independently without supervision under tight deadlines.

Experienced in Training & Supporting end-user reporting needs using Business Objects.

I am a US citizen

Education:

Bachelors in Arts, Delhi University, INDIA

Technical skills:

BI Tools

SAP BI 4.2, SAP BI 4.1, BO XI 3.1, Infoburst, 360 EYES, Tableau 9.3, Crystal Reports 6.0, Xcelsius 2008, Live Office, Query as a Web Service

Dimensional Data Modeling

Physical&Logical Data Modeling, multidimensional modeling, Snowflake Schema/ Star Schema modeling (Normalization / De-Normalization Techniques)

Functional Areas

BI project life cycle development, design and deploy complex BI solutions, excellent skills in Universe & Report Design, Excellent Client Relationship Management Skills.

Databases

Oracle 10g, SQL Server 2012, DB2 on AS400

Programming

SQL, Pl/SQL, ANSI SQL, HTML

Operating Systems

MS Windows

Others

EI, WINS, SQL Explorer, SQL, AS400, SQL Navigator, Pl/SQL Developer.

SGF Consulting Oct 2018 to Present

Business Objects Consultant

Roles/responsibilities:

Working on BI analysis for Overseas Telecom customer. Assignment over in January 2019

Meritage Homes Feb 2017 – Sep 2018

BO Specialist

Roles/responsibilities:

Single handed running of the Business Objects environment for the company.

Managed complete upgrade of BO from 4.1 to 4.2, including but not limited to Hardware, Software, Data Sources, 3rd Party Tools, Universes, Reports, Schedules and Environments

Involved End to End on project life cycle implementation (requirement gathering to post Production Maintenance).

Design, development, deployment, Maintenance and Production Support of complex universes and enhancing existing universes using Business Objects tools-Information Design Tool (IDT) and Universe Design Tool (UDT) using Relational data sources. These universes use Sales Force and JD Edwards E1 systems as data sources.

Handle all scheduling, publishing and distribution of Business Objects content using Infoburst for entire company

Use 360 Eyes tool to monitor and collect data on the usage of Business Objects content including reports, universes and objects and use that to make impact decisions regarding the BO landscape.

Used Business Objects and SQL to design an end to end process that allowed us to modify and update the financial data for the entire company and get it ready for the year end processes.

Created contexts and aliases for resolving loops in the universes @functions like @prompt @where and @select functions.

Developed simple, medium and complex reports like On-demand, Ad-hoc, Canned, Slice and Dice, cross-tab and master detail, Alerter and Ranking reports using Web Intelligence tool and used combined queries, merging dimensions, complex functions, Filters, Custom sorts and Rankings at the report level and complex filters to satisfy end user requirement.

Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.

Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL, DB2 and MS Excel.

Experienced in Training & Supporting end-user reporting needs using Business Objects.

Environment: SAP BI 4.2, SAP BI 4.1, JD Edwards E1, DB2, SQL Server 2012, MS Office 365 Suite, Infoburst, 360 EYES

Nationwide Insurance, Scottsdale, AZ 2008 – Feb, 2017

BI Specialist

Roles/responsibilities:

Involved End to End on project life cycle implementation (requirement gathering to post Production Maintenance).

Worked on design, development, deployment, Maintenance and Production Support of complex universes and enhancing existing universes using Business Objects tools-Information Design Tool (IDT) and Universe Design Tool (UDT) using Relational and OLAP data sources.

Created contexts and aliases for resolving loops in the universes @functions like @prompt @where and @select functions.

Developed Object level and Row Level restrictions on different user groups and users at Universe level and also implemented Index Awareness for complex reports.

Developed simple, medium and complex reports like On-demand, Ad-hoc, Canned, Slice and Dice, cross-tab and master detail, Alerter and Ranking reports using Web Intelligence tool and used combined queries, merging dimensions, complex functions, Filters, Custom sorts and Rankings at the report level and complex filters to satisfy end user requirement.

Controlled data in reports Using Automated document scheduling, publishing and distribution for Webi and Info view clients.

Blended data from multiple databases into one report by selecting primary keys from each database for data validation.

Developed Tableau visualizations and dashboards using Tableau Desktop

Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.

Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, DB2 and MS Excel.

Experienced in Training & Supporting end-user reporting needs using Business Objects.

Environment: SAP BI 4.1, Tableau Desktop 9.3, DB2, Oracle 10g, SQL Server 2012, MS Office Suite.

Nationwide Insurance, Scottsdale, AZ Nov2001-2008

Senior Developer

Roles/responsibilities:

Responsible for modifications in A+ Forms project using Access/Visual Basic, PCL and Crystal Reports.

Made extensive changes to table structures, queries and data in order to update and rectify form attachment criteria to meet the current business needs.

Created and modified forms using Crystal reports (6.0) and PCL.

Independently handle all changes for specific states.

Perform rigorous Unit testing on application to handle all possible scenarios before and after changes.

Respond to QA needs for instant fixes to code and query changes.

Environment: Excel, Access, Visual Basic, AS400, Crystal Reports

Contact this candidate