Sap Bi - Bo Architect/ Sr.solution Consultant Resume
MI
SUMMARY:
- SAP BI - BO Architect/ Sr.Solution consultant wif 10+ years of experience in IT wif 8+ in SAP BO (releases XIR2/BOXI 3.0/4.1) and 1 year in SAP HANA and SAP BODS
- Involved in 5full life cycle project implementation include project preparation, gap analysis, business blueprint, design specification, realization, testing, production support and end user documentation
- Mapping the requirement and providing customers the best solutions involving evaluation and definition of scope of project and finalization of program / project requirements
- Experience in SAP BusinessObjects Administration, Implementation, deployment, Reporting, Maintenance, Solution Designing and Pre-Sales support
- Extensively worked on SAP Business Objects BI and EIM product suitelike SAP BO-BI, Information Steward and SAP BO DS
- Resolved and supported more than 1500+ customer related issues on BOBJ product suite
- Expertise on implementation and deployment of SAP Business Objects XIR2/XI3.1/4.0/4.1 product suite, Presales consulting, requirement gathering and providing report solutions to the presales group,Experience on other SAP Products like SAP HANA and SAP BW
- Good Understanding of in-memory computing in SAP HANA, the structure of SAP HANA Studio, creation of packages and configuration of various perspectives
- Hands-on experience on creating and displaying data for an Attribute view, Analytical view and an Calculation view and analytical privilege
- Extensive reporting knowledge on top of SAP Hana using different BO client tools
- Strong experience in SAP Business Objects BI reporting tools - such as Web Intelligence, Explorer, Exploration Views, Universes, Crystal Reports, Xcelsius Dashboards, Advance Analysis, Information Design Tool (UDT), QWAAS, Live office
- Worked on Key reporting solutions like SAP Lumira/Visual Intelligence, Design Studio, Predictive Analysis
- Implemented RDS reporting solutions for the customers in the areas of HR, Banking, FICO, TPE (Trade promotion effectiveness)
- Responsible for Integration of Mobile and iPad configurations on SAP Business Objects 4.0 servers
- Well versed in Content Migration concepts from BOE XI 3.1, BOE4.0 to BI 4.1 landscapes, extensively used migration tools like Promotion Management and Upgrade Management
- Good working knowledge on cloud systems like Amazon and Lean demo landscapes(SAP Internal cloud)
- Set up of SAP Business Objects 4.1 landscapes on SDC (SAP Demo Cloud) environments
- Strong Implementing and configuring experience of SAP Business Objects servers
- Patching up Business Objects 4.1 product to the GA release and providing the landscapes to the customers
- End to End Infrastructure and Application support to the Presales group
- Building Standard and Customer specific demo scenarios across various industries on BI Analytics, providing expert level support for demo development as well as demo infrastructure related issues
- Worked wif Sybase ASE and IQ for BO universe creation and reporting, worked wif SAP Hana for creating BO Reports, Universe’s and Info spaces, worked wif SAP BW for creating Reports, Universe’s and Dashboards
TECHNICAL SKILLS
Operating systems: MS-DOS, Windows, Unix/Linux
Databases: SQL Server 2008, SAP Hana 1.0, Oracle, Sybase IQ 16.0
Programming Languages: C, C++, Visual Basic
ETL Tools: SAP BODS, SAP BW 7.0, InformaticaPowerCenter9.x
Platform: SAP BO XI R2/R3/BI4.0/4.1, SAP Lumira/cloud
Reporting Tools: Webi Intelligence, Crystal Reports 2008/2011, Xcelsiusdashboards 2008/SAP Dashboard Designer, Explorer/Explorer Views, Information Steward, SAP Lumira,Lumira Edges server, Predictive Analysis, Design Studio, Tableau, QlikView
PROFESSIONAL EXPERIENCE
Confidential, MI
SAP BI - BO Architect/ Sr.Solution consultantResponsibilities:
- Involved in complete full life cycle implementation of SAP BI-BO, includes requirement gathering, realization, testing and go live phases.
- End to End Implementation of SAP BI 4.1/4.0 Landscapes for Solution Experience team and provide the Infrastructure to the global presales group
- Requirement analysis, Request for Change (RFC) identification, providing estimate for RFC, attending client meeting
- Configured Lean demo landscape (SAP internal cloud) wif BI / EIM product suite
- Time to time upgrade of the servers to the latest patch levels
- Maintained the demo content across SAP Demo cloud and Showrooms (Public and Private) wif BI 4.1 and EIM (Data Services / Information Steward)
- Migrated the Standard and Custom demo content from BOE XI 3.1 to BOE4.0 / BI 4.1
- Extensively worked on Upgrade Management and Life Cycle Management Tool/ Promotion management
- Upgraded the servers to the GA release
- Worked wif MS SQL Server for writing SQL queries for Universe tables and validating the reports
- Conduct meetings wif customers and sort out any technical problems, difficulties
- Coordinate wif field sales executives for demo requirements, understandings etc.,
- Coordinate wif Sales and Pre-sales Solutions Engineer to understand the complete Demo Scenarios and related business processes
- Maintain a high customer focus and manage customer expectations in a responsive manner
- Configured Mobile 6.0 Version of Mobi for iPad / IPhone devices
- Developed webi reports/dashboards for the GRC solutions like Risk Management, Access Control, Fraud Management…
- Worked on the standard content development and custom content development for the global presales
- Configured the SSO for BI wif other ERP systems
- Requirement gathering, analyzing the data to meet the Solution Management and Product management requirement.
- Analyzed the standard GRC reports on the following modules Access Control (AC), Fraud Management (FM), Audit Management, Risk Management
- Developed various Webi reports like Risk Register by Objectives, Access Risk Voilation report, Issue Monitoring status and Priorities, Multi Risk Impact etc.,
- Created Xcelcius dashboard to measure the Risk Analysis
- Modified the Bex queries to consume views in Design Studio application.
- Creating BW queries such as conditions, exceptions, hierarchies etc. on top of ODP models.
- Created SAP Lumira reports based on Standard GRC Hana Views preparing the data, visualizations and composing stories.
- Created Lumira stories and published to the Lumira server and Lumira cloud
- Publish the dashboards and the reports to Mobile devices
Environment: Business Objects 4.1, SAP Lumira 1.27, Design Studio1.5, BW, Hana Studio 1.x, Information Design Tool (Universe), GRC, ABAP Web service
Confidential, NV
Responsibilities:
- Requirement gathering and analyzing the data to meet the customer requirement.
- Loading the Excel data into HANA studio and modelling the data through views and created OLAP connection to consume views in Design Studio application.
- Creating BW queries such as conditions, exceptions, hierarchies etc. on top of cubes.
- Building SAP Lumira reports based on BW queries by creating preparing the data, visualizations and composing stories.
- Designing Design Studio application based on HANA views and publishing to BI platform
- Requirement gathering and analyzing the data to meet the customer requirement.
- Loading the Excel data into SQL Server 2008 data base.
- Designed and Developed Connection, Universe and Dashboard using OLTP data source.
- Designed the Universe wif Joins, Loops, filters, aggregate awareness functions and prompts and writing custom queries to improve the performance.
- Designed the Dashboard on top of universe using Query browser.
- Created Webi reports wif different functionalities like input controls, alters, drills, scope of analysis.
- Published the Webi reports and Dashboard to BI Platform.
- Developing Lumira reports based on HANA views by creating visualizations, Composing story, etc.
- Applied graphical representation of reports such as Bar Charts, Pie Charts as per the end user requirements.
- Publishing the composed story to BI Platform, Lumira cloud.
- Designing Design Studio application based on HANA views and publishing to HANA platform.
Environment: Business Objects 4.1, Information Design Tools, Webi, Dashboard, Lumira, Design Studio, SQL server 2008,HANA Studio 1.x
Confidential
Sr.Solution Consultant
Responsibilities:
- Involved in complete full life cycle implementation of SAP BI-BO, includes requirement gathering, realization, testing and go live phases.
- End to End Implementation of SAP BI 4.1/4.0 Landscapes for Solution Experience team and provide the Infrastructure to the global presales group
- Requirement analysis, Request for Change (RFC) identification, providing estimate for RFC, attending client meeting
- Configured Lean demo landscape (SAP internal cloud) wif BI / EIM product suite
- Time to time upgrade of the servers to the latest patch levels
- Maintained the demo content across SAP Demo cloud and Showrooms (Public and Private) wif BI 4.1 and EIM (Data Services / Information Steward)
- Migrated the Standard and Custom demo content from BOE XI 3.1 to BOE4.0 / BI 4.1
- Extensively worked on Upgrade Management and Life Cycle Management Tool/ Promotion management
- Upgraded the servers to the GA release
- Worked wif MS SQL Server for writing SQL queries for Universe tables and validating the reports
- Conduct meetings wif customers and sort out any technical problems, difficulties
- Coordinate wif field sales executives for demo requirements, understandings etc.,
- Coordinate wif Sales and Pre-sales Solutions Engineer to understand the complete Demo Scenarios and related business processes
- Maintain a high customer focus and manage customer expectations in a responsive manner
- Configured Mobile 6.0 Version of Mobi for iPad / IPhone devices
- Developed webi reports/dashboards for the GRC solutions like Risk Management, Access Control, Fraud Management…
- Worked on the standard content development and custom content development for the global presales
- Configured the SSO for BI wif other ERP systems
- Designed & Developed Universe, Webi and Dashboards using OLTP data source. (Sybase IQ 16.0)
- Requirement gathering and developed Crystal reports as per the Business requirement.
- Designed the Universe wif aggregate awareness functions, prompts and writing custom queries to improve the performance.
- Creating complex joins like outer joins, inner joins and theta joins and checked the integrity of the Universes.
- Published the created universe to BI platform in different environments.
- Designed dashboard on top of universe using Query browser.
- Designing Webi reports on top of universe wif different functionalities like Alerts, Sorting, Break, Filters, and Prompts.
- Published the created reports to BI Platform.
Environment: Business Objects 4.1, Information Design Tool, Webi, Dashboards, Crystal Reports, BW, Sybase IQ 16.0
Confidential
SAP Labs Presales group
Responsibilities:
- Migrated the Relational connection and Universe into CDA (Common Development Area) Environment.
- Configured mapping service in Arcgis online system like creating map, layers, connecting layers to map.
- Linked the universe wif mapping service using GIS joins.
- Designed Webi report on top of universe wif different functionalities like Alerts, Sorting, Break, Sections, Forms, Filters, and Prompts.
- Designed Webi report wif Galigeo Features using configuration of map document in Webi.
- Displaying map in Webi report wif different functionalities like drill down, Zoom in, Zoom out, Selections, area analysis etc.
- Published the Webi report to BI Platform
Environment: Business Objects 4.1, Information Design Tool, Webi, SQL Server 2008
Confidential
Responsibilities:
- Designed & Developed Universes, Web Intelligence Reports using OLTP and OLAP data sources.
- Designing the Universe, created Contexts and Aliases for resolving Loops in the Universes to improve performance.
- Created reports wif different functionalities like Alerts, Sorting, Break, Filters, Prompts
- Redesigning some of the structures of the universe and providing additional business concepts wif objects and conditions
- Creating and mentoring to successfully design row level restrictions in universes for users/groups
- Deploying universes, reports etc between different environments.
- Updating and maintaining Universes based on changing user requirements and data source changes
- Involved in customizing WebI Reports and its successful deployment
- Applied graphical representation of reports such as Bar Charts, Pie Charts as per the end user requirements.
- Migration of XI 3.1 reports to 4.1 landscape
- Created Technical Specification Documents based on Functional Specifications and prepared Unit test plan
- Responsible for functionality testing, regressing testing and performance testing.
- Involved in preparing the test plan and writing the test cases.
- Reported the bugs to the global team (AG).
- Involved in Data Migration, requisitions creation (Internal/External for both Hiring Manager and the Recruitment Manager), User access creation for the external channel (Agencies), Application Management and data updating on the e - recruitment tool.
- Weekly Statistics reports for the stakeholders.
- Reporting the bugs to the development team.
