We provide IT Staff Augmentation Services!

Sr. Sap Bi Bods Solution Lead Resume

Ashtabula, OH

SUMMARY:

  • I have 11 years of IT industry experience including 10+ years of experience spanning across SAP ERP, Business Intelligence BW/BI and Business Objects solutions delivery for multi - disciplined projects.
  • Successfully Implemented 8 full life cycles of SAP BI/BW and SAP BOBJ projects from blue print, gap analysis, system landscape design, data model design and development, ETL, validation, reporting and Security, Go-Live and production support.
  • I have implemented 2 successful HANA 1.0 Projects
  • I have utilized my broad verity of SAP skill sets in various Projects but specialize in the area of BW/BI solutions (3.3, 3.5, 7.0, 7.3) BOBJ (XI R2, XI 3.0, XI 3.1, BI 4.0), BODS, Rapidmarts 3.2, 4.2 and ERP security with Specialization in BI Security, SAP Enterprise Portal Security and BI Reporting across multiple cross functional Areas like SAP ISU, CRM, HCM, FI-BI, SD, SCM, and MM.
  • I bring over 9 years of business process and systems development experience across multiple industries ISU, Health Care, Technologies, Gaming, Food, Beverages, Electronics, Pharmaceutical, Gas, logistic, Media, FMCG and more.
  • Business Objects, SAP BW/BI and Business Objects Integration
  • Elaborate and Extensive involvement in gap analysis of As Is system and to be systems. Designed and maintained InfoCubes, MulitProviders, Remote Cubes and ODS/DSO Objects in consistent with Extended Star schema and efficient Multi-dimensional data modeling techniques.
  • Experience in installing and configuring SAP BOBJ integration Kit for BI, Integrate crystal reports with SAP BW and build reports based on BEx queries, BW Cubes, Info sets(Classic/BI) and R/3 tables.
  • Develop and Configure Semantic layers (Universes (XI, 4.0/3.x)) according to the business models and report requirements.
  • Extensive Experience of End user training and POCs for SAP BW/BI and SAP BOBJ, which led to multiyear Projects for ProMorphics.
  • I have a robust technical background in using Ralph Kimball/BUS Matrix methodologies while using BI BEx reporting, Portal Integration with BI and BOBJ, Performance Tuning, Security. Decent experience on creating Xcelsius Dashboards and crystal reports with using SAP BW Query and Semantic layers(Universes(UNX/UNV) for Non-SAP Data Sources) and SAP ERP using BW MDX connectivity and publish the reports in business objects enterprise server and SAP Portal.
  • Reporting- Developed Standard, Custom, Ad-hoc, web reports of SAP BI. Extensively involved in creating Webi reports, Crystal Reports, Xcelsius dashboards, Lumira, Explorer, Design Studio entities for corporate BI environment using SAP Business Objects (BOBJ/BI) and SAP BI and Tableau 8.2.
  • Portal Integration Well versed with the integration of BW/BI Web reports and assigning to the BI portal (2004s) roles.

TECHNICAL SKILLS:

Development Software / Languages: SAP BI 7.3, 7.0, BW 3.5/3.1C/3.0B/2.1C, SAP R/3 5.0/4.6C/4.5BEnterprise Portals 6.0, ABAP/4, C, C++ SQL, HTML, XML, MS SQL Server 2000/7.0, Access, Oracle 9i/8i/8.SAP Data Services.

Reporting / Designing Tools: BI 4.1, BI 4.0, BOXI3.0,XI3.1, r2/2008,Webi, Crystal Reports, Xcelsius 2008, Advance Analysis for OLAP and Office, Business Objects Explorer, Business Explorer, Web Application Designer, Design Studio, Visual Intelligence MS Visio, 8.0/9.0/X/XI/XI, Crystal Enterprise 9.0/ 10.0, Business Objects XI R2 and SAP Business Objects Universe Design, Crystal Reports.

Data Base: HANA 1.0, My SQL, Oracle, DB2, Microsoft SQL Server and AccessExperience Details

PROFESSIONAL EXPERIENCE:

Confidential, Ashtabula, OH

Sr. SAP BI BODS Solution Lead

Responsibilities:

  • Piloted the Blue prints by working with BA and Functional consultants to gather Reporting requirement and Customization needs of the Business users.
  • Designed a Multi-source Universe using SQL Server 2012 as a back end data source to deliver Trail Balance Reports by Company Code, GL Accounts, Business Area and Fiscal Year Period Comparison which is used to show Absolute Difference and Relative Difference between the selected Fiscal Year Periods and CC.
  • Delivered 15 SAP GL Webi Reports based on SAP GL Universe (UNX) which is built using IDT.
  • Worked Extensively on SQL Server Management Studio (SSMS) to analyze the Data from ETL jobs and to resolve BOBJ Webi report issues which help to speed the development time 40%.
  • Enhanced 15 Webi report with Budget/Plan data from COSP table as Chromaflo’s budgeting/Planning is done at Cost Center level than GL account Level.
  • Enhanced the Reports with Currency Conversation based on the data from ECC-TCURR table which allowed the users to view the report in various different currencies based on the company code.
  • Delivered GL Journal Details, Journal Transaction Listing report to highlight all financial documents with in a GL account or at GL account level where credit amount is not equal the debit amount.
  • Built and Delivered Xcelsius Dashboards showing Different KPIs like GL Account Balance Trend by Period, GL Account YTD Trend Analysis, Document Amount by Profit Center, and Document Count by Document by Business Area, CC etc.. Which help the business users to understand the P&L statement by cutting down the manual analysis effort by 80%
  • Delivered Explorer facets to Explore Chromaflo’s huge SAP GL Data, by GL Account, Financial Document, Cost center and Profit Center using the SQL Server Database and Universe.
  • Worked with CFO to educate and train to on how to use Lumira for their current and upcoming mobile BI needs.
  • Piloted End user training and Product Demo Workshops and Knowledge Transfer to the support teams
  • Involved in SAP BODS ETL Design solution on to extract ECC Data (200+ Tables) from SAP using SAP ABAP Data flows
  • Involved in Modifying the SAP Standard ETL Logic to get the correct Debits and Credits for the Trial balance report.
  • Enhanced the ETL JOBs to get Budget/ Plan data from COSP table than GLP0 to deliver at least 8 reports that are based on this data this enhancement helped Chromaflo to get the Plan and Budget Reports working.
  • Actively involved in data load strategy with in Production system to make sure that the data loads are completed before business hours.
  • Monitored and fixed any data load issues by working closely with BODS team.

Environment: SAP BI 4.1, SAP BODS 4.2, SAP R/3 ECC 6.0, Windows server (Business Objects Enterprise), BusinessObjects Dashboards (Xcelsius), Lumira, Explorer, SQL Server 2012, SSMS

Confidential, Evansville, IN

Sr. SAP BI BOBJ HANA Solution Lead.

Responsibilities:

  • Designed a Multi-source Universe that would consume Oracle and Excel spread sheets as a source and deliver DOI report using Webi reports.
  • Delivered an Xcelsius Dashboard showing the KPI’s such as Stock on Hand and Damaged Qty and Values by country and year using BI services from Webi report.
  • Delivered DOI Detailed Analysis Webi Report that would help the BA to analyze Ending Stock based on a month input, in market sales, Current Month Sales. Etc...
  • Built HANA Views (SQL Procedures) that would provide Customer related Information and combined the heterogeneous sources at the Universe level or the Webi report level depending on the business scenario and technical encounters.
  • Delivered Webi report by merging Data from BW and HANA.
  • These reports helped MJN to analyze the inventory data up to 3X faster and make informed decisions which clearly improved stock replenishment with in MJN’s Inventory.
  • HANA Calculation view help MJN to Analyze the Damaged stock Quantity and the cause for the damage and they are using this data to take remediation steps to avoid further damage.
  • Extensively worked with Tableau 8.2 reporting while integrating with SAP HANA.
  • Delivered Dashboard for various Countries for Sales KPI like YTD, YOY etc..
  • Involved in Tableau 7.0 to 8.2 upgrade project.

Environment: SAP BI 4.1, SAP HANA 1.0 SP8, Oracle, SAP R/3 ECC 6.0, SAP BI 7.3, Windows server (Business Objects Enterprise), BEx Analyzer, BusinessObjects Dashboards (Xcelsius), Lumira.

Confidential, New York

Sr. BOBJ Architect

Responsibilities:

  • Piloted the deep dives with business users and analysts to precisely understand the Report requirements based on the functional specs from Crystal/Webi Reporting and BW data model integration perspective as these report
  • Improved Performance of the Webi Reports by using out of the box techniques like query stripping, and Merge dimension for huge data sets to at least 70%.
  • Improved both BW and BOBJ Query execution by customizing the reports and adjusting Web applications server settings.
  • Configured Email functionality for users to send email to the outlook mailing groups.
  • Developed and delivered Relational (UNX) universe to get scan data from Oracle data base and report it in Webi reports and Dashboards.
  • Delivered Explorer facets to the Business that helped the business to analyze artist revenue by various dimensions like cost center, profit center, profit center group etc..
  • Delivered Advance Analysis for OLAP web that enabled BEx users to build analytics with in Launchpad.
  • Performance tuned Relational Data base universes (UNX) which improved the performance of the Query execution to 60%.
  • Consolidated heterogeneous sources of data with in Crystal report and provided Single point of truth to the Business users. With the Crystal the business had improved productivity and efficiency with professional reports that give a clear picture of business performance.
  • Delivered SAP Lumira (Visual Intelligence) Facets for Business user to Analyze Artist Profitability Analysis ad Label Profitability Analysis.
  • Involved in enhancing the backend BW cube to report Artist Royalties, Costs and Allocations (WBS), Sales revenue for various business verticals like Digital, Foreign, and Physical etc.
  • Give Insight about all the BOBJ tools to the Confidential Users and help them to choose a specific tool that would suit their business requirement.
  • Configured the users and designed security to the roles so that the users can access the reports securely.
  • Led the SAP BW and BOBJ SSO integration using STS.
  • Integrated SAP BI 4.1 and SAP Portal using IView’s
  • Delivered P&L reports with in highly formatted BOBJ reports.

Environment: SAP BI 4.1, SAP HANA, SAP R/3 ECC 6.0, SAP BI 7.3, Windows server (Business Objects Enterprise), BEx Analyzer, BusinessObjects Dashboards (Xcelsius), SAP Lumira, SAP BO Design Studio, Advance

Confidential

SAP BOBJ Architect/Admin

Responsibilities:

  • Analyzed the existing MJN repository and designed an upgrade and migration strategy.
  • Extensively used Ralph Kimball/BUS Matrix methodology as project development strategy
  • Provided resource and time estimates for the Project.
  • Lead guided the off shore team for various activities.
  • Upgrade UNV universe from BOBJ XI 3.1 Environment to BI 4.0 Environment using Upgrade Management tool (UMT)
  • Upgrade the Users and roles to BI 4.0 environment.
  • Created BICS connections as part of the retrofit effort to build Webi reports
  • Showcased various different BOBJ tools to the user to help them understand the capabilities of various tool to cater their pressing business intelligence needs.
  • Effectively upgraded Tableau 7.0 to Tableau 8.0

Environment: SAP XI 3.1 Sp4 and BI 4.0 SP3, SAP R/3 ECC 6.0, SAP BI 7.0 SP7, Windows server (Business Objects Enterprise), BEx Analyzer, Upgrade Management tool.

Confidential

SAP HANA Architect

Responsibilities:

  • Piloted the business requirements for HANA use case.
  • Designed HANA models (Attribute Views, Analytic Views, Calculation views) that would meet customer reporting requirements to show yield calculations at various levels of product manufacturing for various products.
  • Built stored procedures to calculate the Yield based on the order number and period.
  • Designed the ETL strategy to load data from flat files using Data services 4.0
  • Loaded Data into HANA using BODS 4.0 utilizing various transforms available in BODS.
  • Designed the quality control specs to maintain data consistency in the SAP HANA system after loading into HANA.
  • Designed BOBJ 4.0 Universes using HANA models that are consumed in Webi reports and Xcelsius Dashboards and Explorer Views.

Environment: SAP HANA SP6, SAP BI 4.0 SP7 (Business Objects Enterprise), BusinessObjects Dashboards (Xcelsius), SAP Lumira, SAP BO Design Studio, Lumira.

Confidential

SAP HANA Architect

Responsibilities:

  • Designed HANA models (Attribute Views, Analytic Views, Calculation views) that would analyze millions of records and show the customer behavioral patterns.
  • Designed the ETL strategy to load data from flat files using Data services 4.0
  • Loaded Data into HANA using BODS 4.0 utilizing various transforms available in BODS.
  • Designed BOBJ 4.0 Universes using HANA models that are consumed in Webi reports and Xcelsius Dashboards and Explorer Views.
  • Created Lumira Documents utilizing SAP HANA data models.
  • Created Lumira Documents showing the HANA Hierarchies Capabilities.

Environment: SAP HANA SP6, SAP BI 4.0 SP7 (Business Objects Enterprise), BusinessObjects Dashboards (Xcelsius), SAP Lumira, SAP BO Design Studio, Lumira.

Confidential, Indiana

SAP BOBJ Architect

Responsibilities:

  • Successfully implemented BI 4.0 at IFN, introducing IFN business users to an intuitive reporting tool-Webi which is new to IFN users.
  • Configured the users and designed security to the roles so that the users can access the reports securely. Involved in installing and deploying BI 4.0 Servers
  • Installed and customized Ordering, Engineering and Customer Metasolv universes for out of the box reporting capabilities.
  • Trained close to 40 IFN users which gave the users flexibility to report against the transactions posted by Metasolv application to the Oracle database.
  • Demonstrated various Xcelsius Dashboards that made the IFN power users realize the true potential of SAP Business Objects.

Environment: SAP BI 4.0 SP6, Linux server (Business Objects Enterprise), BusinessObjects Dashboards (Xcelsius), Metasolv, Oracle, Crystal Report 2013.

Confidential, St Louis

SAP HANA-BOBJ Package Architect

Responsibilities:

  • Designed HANA models (Attribute Views, Analytic Views, Calculation views) that would meet customer reporting requirements.
  • Designed the ETL strategy to load data from flat files using Data services 4.0
  • Loaded Data into HANA using BODS 4.0 utilizing various transforms available in BODS.
  • Designed the quality control specs to maintain data consistency in the SAP HANA system after loading into HANA.
  • Designed BOBJ 4.0 Universes using HANA models that are consumed in Webi reports and Xcelsius Dashboards and Explorer Views.
  • Created Lumira Documents utilizing SAP HANA data models.
  • Created Lumira Documents showing the HANA Hierarchies Capabilities.

Environment: SAP HANA SP6, SAP BI 4.0 SP7 (Business Objects Enterprise), BusinessObjects Dashboards (Xcelsius), SAP Lumira, SAP BO Design Studio, Lumira.

Confidential, Santa Clara, CA

SAP BI BOBJ Solution Architect

Responsibilities:

  • Redesigned and delivered various dashboards using BusinessObjects Dashboards (Xcelsius) with critical KPIs for Strategic, Analytical, Operational, and Informational needs of the business.
  • Designed and delivered Logistics dashboards that would illustrate KPIs such as Entitlements, Inflow/ Outflow, Inventory Balances and Movement Type analysis for various business segments with in AMAT.
  • Adopted the use of BI services vs. using traditional live office, QaaWS or BICS.
  • Delivered complex and intuitive Webi Reports to provide reporting capabilities utilizing BW data extraction for the retired company code in SAP 4.7 which are migrated into ECC 6.0
  • Delivered Webi reports for Cost based and GL based account reporting. Only with Webi reporting such a complex reporting needs were delivered to the Business which provided the business with insight to the ECC 6.0 and 4.0 systems data with increased user confidence.
  • Delivered reports that are compatible for iPad consumption by publishing them to the BI Launchpad categories and leverage them by using the SAP BI Mobile app which gave the business users to consume information anywhere which complimented the concept of Applied Anywhere
  • Designed and Delivered Credit Management and Dispute Management reports for proactive receivables for AMAT. These reports helped the business to increase AMAT’s working capital by at least 40% for at least 300 users.
  • Designed the BEx queries to support the Webi reports and utilized merge dimensions at the Webi report level and reported the dollar amounts in corresponding local currencies like Yen, Pounds, Won, TWD etc. depending on the user executing the report with BW in corporate Security.
  • Led end-user training which involved 50 users at a time.
  • Responsible for supporting 400 reports and 30 dashboards in Production in parallel to other Development projects which reduced the cost of project implementation and support for AMAT by 50%.
  • Led an offshore team while assigning tasks to team members and monitor the system operations during the peak load schedules and other Project deliverables.
  • Designed a failover strategy in production to address any system failures which included performance tuning of the Webi reports, Dashboards, Universes (IDT) and Data federator which brought down the failures to 0.
  • Trained and guided end users to help them understand usability of dashboards, reports, exploration views.
  • Fined tuned the UNX universe and recommended and installed various Service Packs and fix packs which improved the IDT universe performance by 70% which resolved critical issues with data federator universes and reports in Production.
  • Resolved critical tickets with a maximum 24 hours resolution time with no SLCA breached tickets at AMAT.
  • Enhanced production reports as per user needs while coordinating BOBJ Improve strategy at AMAT which improved user satisfaction and gained user confidence in the Business Object suite.
  • Demonstrated SAP Lumira (SAP Visual Intelligence) to the users and delivered using Grid and Facets by merging different desperate sources.
  • Demonstrated and delivered SAP BO Design Studio integrating with SAP BW which enables application designers/Power users to create and analysis applications and dashboards for browsers and mobile devices.
  • Demonstrated and delivered Advance Analysis OLAP work spaces with BEx query for BEx users at AMAT.

Environment: SA BI 4.0 SP6, SAP HANA, SAP R/3 ECC 6.0, SAP BI 7.3, Windows server (Business Objects Enterprise), BEx Analyzer, BusinessObjects Dashboards (Xcelsius), SAP Lumira, SAP BO Design Studio, Advance Analysis OLAP.

Confidential

SAP BOBJ BI Solution Architect

Responsibilities:

  • Involved in the architecture design of BI data modeling that would be optimal for Webi and Crystal reporting by utilizing the existing DLM (Device Lifecycle Management) Data model from Phase 1 data model to avoid data redundancies in BW.
  • Developed custom Infocubes, DSO and created custom Infosets and Multiproviders to get data from QASE and relevant Inspection lots from QAMV, EGERS and ZTEL ELE COMP tables that are loaded into the DSO from ECC.
  • Developed BEx queries and used APD that would appropriately resolve limitations of the Webi and Crystal reports.
  • Redesigned the EDW layer from DLM phase 1 by using DSOs to reduce the load times by 90% by using the delta loads to the DSO and then to the Infocube vs. full loads to the final InfoCube.
  • Enhanced the existing DLM BI Process chains with MPSC BI process chains which were designed to run in parallel with the DLM process chains by optimizing the load times by at least 3 hours every day.
  • Recorded the Unit testing results in HPQC and documented the highly process oriented transport documents at CMS
  • Collected the BI transports and prepared the relevant documentation to transport BI elements to the QA and Production respectively.
  • Designed the Project Plan, Resource and Project estimates for Phase 2.
  • Piloted the deep dives with business users and analysts to precisely understand the Report requirements based on the functional specs from Webi Reporting and BW data model integration perspective as these report require utmost accuracy when they are submitted by CMS to MPSC every year.
  • MPSC Webi reports were 99% accurate when compared to the Legacy reports. This initiative gave Business a deeper insight into their operational data and also facilitated CMS to save costs by eluding penalties by MPSC for the Lots that did not pass the required meter accuracy reading when tested with full load.
  • Designed, developed and delivered all the MPSC reports in a very fast paced environment and aggressive time lines. Legacy Operational/ QM reporting was replaced by BI Crustal 2008 and Webi reports which are 90% more effective for Canned reporting and Ad-hoc analysis for deeper insight into operational data.
  • Designed the architecture of all the reports from BW InfoProviders level to the Repot Publishing in the Enterprise Portal. Designed the migration strategy for Webi reports and BI data model across the landscape. Customized the @prompt and @select variables in the Universe to suite the business requirements.
  • Actively worked with security teams to In corporate BI Role based security to the folder level security in BOBJ environment for Webi reports where only Authorized Business users can generate reports in the Info view.
  • Developed and Demonstrated an Xcelsius Dashboard which brought in the dashboard initiative into the Project. Delivered Webi reports that are used as a Data source to Xcelsius Dashboards using live office connection from the Webi report. Drove the Xcelsius initiative by coordinating with off shore resource to develop the Xcelsius dashboard.
  • Documented best practices for SAP BOBJ Webi and Crystal reports and incorporated them into the reports. Effectively organized meetings with the business users when required to get more clarifications for MPSC requirements and incorporated them into the Crystal and Webi reports and Xcelsius dashboard.
  • Trained Business Analysts at CMS on SAP Webi and Universe development with SAP BI Integration.
  • Educated CMS admins and Recommended the tools required to design the reports efficiently and monitor the systems.
  • Laid out the upgrade plan from XI 3.1 to BI 4.0 and migrated XI 3.1 Webi and Crystal reports to BI 4.0 reports.

Environment: SAP XI 3.1 Sp4 and BI 4.0 SP3, SAP R/3 ECC 6.0, SAP BI 7.0 SP7, Windows server (Business Objects Enterprise), BEx Analyzer, Xcelsius 2008.

Confidential

SAP BOBJ BI (ISU) Solution Architect

Responsibilities:

  • Effectively installed 0AUD ROLE, 0AUD OBJECT, 0AUD ACTION data sources to extract Audit, Audit Question, Comments and corresponding business partner information for the Audit to Produce Audit Status, Corrective Action, and Audit Object reports.
  • Crated ZDSOs to store the operational level data by Object Number (ZOBJTNR), Class type (0CLASS TYPE), Internal Characteristic Number (0CLASS NUM) etc.
  • Created Infocube and Multiprovider to store Data from QM - QASE table for all the tested meters in the Inspection lots.
  • Integration of QM and Audit Management gave business an edge to report the Accept and Rejected lots with the reason for being accepted or rejected by each operation for each MICs in one single report. The cut down the Manual process of validating against each individual table by 100%.
  • Merged the Data from Audit Question, Audit, Classification data with QASE data using an Infoset to fetch the relevant Inspection lots and its Audit information.
  • Improved the Transport mechanism for the BI Object by grouping relevant object into one corresponding transport and transported close to 180 transports across the landscape.
  • Created Infoset to report Audit - Classification Data, Audit Action, Audit Object, Audit Roles data in the Webi and Crystal report.
  • Piloted the cutover plan with CMS and the Team for do multiple Iteration of Integration Testing in various systems across the Landscape.
  • Efficiently coordinated with Basis, Security and BOBJ team at CMS for a Successful Go-Live.
  • Supported and resolve Production issue which led to the Phase 2 of MPSC reporting at CMS.
  • Responsible for BOBJ and BI integration architecture design and also develop/design Webi reports incorporating the Best Practices for BEx Query Designer, Universe development and Webi and Crystal report development.
  • Gathered requirements for Device Management and Audit Management reporting and designed the data flow from extractors to the Infoset.
  • Eliminated the standard SAP IQ09 data output limitations, including fixed input and output structure and delayed query output by using BI, BIA and Webi and Crystal reports
  • Developed Gas Routine category and Summary report which would be used on a monthly basis by the CMS (Meter Testing Center- MTC) as an analysis tool to keep the MTC on target to adhere to the MPSC requirements for accuracy testing.
  • Developed Electric Routine Category and Summary Report which would be executed on demand to track progress towards required testing standards throughout the year for the SAMPLE Routine Exchange Program which is made compulsory by MPSC for CMS.
  • Integrated QM, Technology Assessment (Product Audit) and Vendor Evaluation (Process Audit) data by using specialized merge dimensions and query stripping techniques to produce data output to view statuses of audit assessments and inspection lots in order to validate the work yet to be completed at MTC. This report also helped CMS to report detailed status of the audits which was never possible in the past with the AVL reporting in ECC.
  • Successfully Published the CRM Webi and Crystal reports to corresponding receipt’s CMS Email inboxes using the STMP server.
  • Extensively used Universe Design Best Practices and Webi and Crystal reporting best practices to generate the reports optimally and utilizing minimal system resources. Customized the @prompt and @select variables in the Universe to suite the business requirements.
  • Successfully resolved existing development issues and guided the CMS employees in the right direction is resolving a few critical issues with the BOBJ tool set and installation.
  • Proposed work around for a lot of Webi and Crystal and Universe limitations by using Delegate search, Database delegated and other options.

Environment: SAP XI 3.1 Sp4 and BI 4.0 SP3, SAP R/3 ECC 6.0, SAP BI 7.0 SP7, Windows server (Business Objects Enterprise), BEx Analyzer, Xcelsius 2008.

Confidential, Reno, NV

BI-BOBJ Architect SAP BI/BO

Responsibilities:

  • Review existing SAP BI data model and design the data flow from BEX queries to Webi and Crystal reports and use XWIS (Xcelsius plugin) to develop the Xcelsius dashboards.
  • Coordinated the Implementation strategy with Clients and documented all the required specs for XWIS.
  • Developed Universe and Webi and Crystal reports that would Consolidate Revenue, Gross Profit, Gross Margin, Operating Income and Operating expenses from BPS Cubes/Queries that can be used by XWIS to develop the Xcelsius Dashboards.
  • Analyze the Implications of XWIS server installation and help clients to understand the benefits of using XWIS for Xcelsius dashboards.
  • Redesign the BEx Queries that are optimal for XWIS consumption.
  • Designed the system Landscape and Migration strategy for SAP BW and BOBJ elements across the dashboard.
  • Developed strategy to schedule the Webi and Crystal reports that would use the Events triggered by successful execution of BI Process chain.
  • Documented the Technical Specs relevant for the Universe, Webi and Crystal, and Xcelsius design.
  • Involved in QA testing and Pre go live activities like optimizing the Webi and Crystal queries and Universes to enhance the execution time for Webi reports.
  • Developed strategy to schedule the Webi reports that would use the Events triggered by successful execution of BI Process chain.

Environment: SAP Bi 4.0, SAP R/3 ECC 6.0, SAP BI 7.0 SP7, Windows server (Business Objects Enterprise), BEx Analyzer, Xcelsius 2008, XWIS.

Confidential, Provo, UT

SAP BIBO Architect

Responsibilities:

  • Review their existing BI data Model and select BI source that are optimal for BI 4.0
  • Develop Interactive Analysis Reports (Webi report) from their existing BEx Queries by using direct connectivity which is BICS.
  • Developed BI 4.0 Universe using Information Design tool that from a BI Infocube to demonstrate the BAPI connectivity to the Universe.
  • Developed Xcelsius dashboard using BI 4.0 designer.
  • Developed Interactive analysis for OLAP web version to demonstrate the capabilities of BI 4.0 integration to the BI cube.
  • Developed Business Explorer Information Spaces to demonstrate the BI 4.0 Explorer capabilities to crunch through millions of records.
  • The initiative turned out to be a success which brought up the long term project for Promorphics.

Environment: SAP BI 4.0 SP2, SAP R/3 ECC 6.0, SAP BI 7.0 SP7, Windows server (Business Objects Enterprise), BEx Analyzer, Dashboard Design, Business Objects Explorer 4.0, Interactive Analysis4.0.Informatioin design Tool.

Confidential, Santa Clara, CA

BI-BOBJ Architect SAP BI/BO

Responsibilities:

  • Validate the installation done by SAP and Provide insight about the technology to the clients.
  • Designed the system landscape for the upcoming SAP BOBJ Implementation Project.
  • Designed the Security model to integrate SAP security to the SAP BOBJ Security model.
  • Developed Webi reports from an existing BEx Query to demonstrate the reusability of existing Investments.
  • Developed Crystal reports to demonstrate that Crystal Reports can leverage the R/3 tables and Infosets directly and they can be deployed in the Business Objects Info view.
  • Documented the Best practices for Universe development, Xcelsius Dashboards, Crystal report.
  • Documented the step by step procedure to crate Webi, Crystal and Xcelsius elements.
  • Guided the BASIS team in resolving system critical issues.
  • Presented the developed POC to the Client that fortified the client’s confidence in implementing the project which led to a multiyear project.

Environment: SAP BO XI 3.1 SP3, SAP R/3 ECC 6.0, SAP BI 7.0 SP7, Windows server (Business Objects Enterprise), BEx Analyzer, Xcelsius 2008, Crystal Reports 2008.

Confidential

BI-BOBJ Architect

Responsibilities:

  • Enhanced the Existing the Info cubes (FIMARGINB, FIMARGIN, and SD T01) and DSO (FMARGINO) which are required to support the Service Analytics Reporting needs.
  • Built Geography Hierarchies and Product Hierarchy based on 0PROFIT CTR and 0COSTCENTER respectively which are used in Webi report to group the result set for Product based reports and Performance based reports.
  • Designed BEx Queries over the SALES, CRM and Finance Multiproviders and the underlying Multiproviders Infocubes while incorporating all the best practices for BEx Query design with respect to BOBJ Universe.
  • Built aggregates to improve the BEx Query Performance which retrieve huge volumes of Data for the reports which show Invoices by Territory based one the Service type.
  • Designed BEx Queries incorporating all the best practices with respect to Business Object reporting.
  • Created Z Multi providers that combine the Finance cube and the sales cube that would give both the Budget and the revenue generated for the particular Month.
  • Enhance existing Multiproviders SD M02 and SD M03 to meeting the Reporting needs.
  • Monitored the data load from CRM System while addressing any load issues.
  • Coordinated the Transport Strategy for BW side to comprehend the Migration strategy on the Business Objects side.
  • Finished the Project a Week before the Expected thus by reducing the Implementation cost by 10%.
  • Involved in function and technical requirement gathering for the current project while suggesting the right software ware requirements like Service pack and fix pack that certainly improved the design and run time of the reports by at least 30%. Downloaded and installed the required Client as Webi, Crystal reports 2008, Xcelsius 2008 on all the Client Machines that would be used in the current and future project implementations.
  • Demonstrated all the abilities of the tool set and suggested the optimal approach while consuming the reports which in turn helped the clients to understand what would be outcome of the project.
  • Designed the data flow between SAP BW/BI and BOE while utilizing the best practices for Universe development and Webi report Creation and consumption standpoint.
  • Designed the Webi Report Templates that would be used across the business reports and also changed the existing report templates that would be appealing to the report users from Performance and Usability standpoint.
  • Developed Product based Webi reports that would help in the analysis the revenue generated from different regions of the Country. Also developed Performance based Webi reports for the Mangers that would help them to award incentives to the sales representative based on the point system that is calculated internally within the organization.
  • Enhanced the Existing Reports that would help the users to analysis the data optimally and make well informed decisions.
  • Built Webi reports that can handle high volumes of data which is a challenge for majority of the clients with respect to retrieving the huge volumes of data from the BW by Optimizing the Universe and Webi report Design.
  • Involved in Security design for the users to grant access on how the users can view the reports depending on the LDAP user groups they belong to using Central Management Console-CMC.
  • Created BIAR files using Import wizard and migrated the Universes, Webi Reports, Folders and Subfolders across the landscape i.e. from Development to Quality to Production
  • Supported and resolved significant amount of live office issues for existing Xcelsius Dashboards which are consumed through Share point.
  • Developed the Webi reports so that they would work optimally even if there is an Upgrade of BOE from XI 3.1 to BI 4.0
  • Extensively used transactions RSTT to capture the traces and used MDXTEST to test the generated MDX statements in BW to analyze the MDX statements so that report can be optimized.
  • Extensively used CMC and CMS XI 3.1 for configuring authenticating users and groups, and keeping track of the availability of the other Business Objects Enterprise services like system database connections.
  • Designed End-user training schedule and trained the Business user while helping them understand the Advantages and Limitation of Business objects reporting which improved the Business User confidence by at least 55 to 60%.
  • Trained in SAP BI 4.0 while familiarizing with new concepts like Information Design tool, Interactive Analysis, BI Launch pad, Advanced Analysis, Upgrade Management Tool.
  • Developed a POC that demonstrates the seamless up gradation of Existing BO XI 3.1 Universes, Webi Reports and Crystal reports to BI 4.0 version.
  • Comprehended how the existing BOE investment can be seamlessly migrated to BI 4.0 environment.

Environment: SAP BO XI 3.1 SP3, SAP R/3 ECC 6.0, SAP BI 7.0 SP7, Windows server (Business Objects Enterprise), BEx Analyzer, ABAP/4.

Confidential, Chicago, IL

Sr.BI-BOBJ Architect

Responsibilities:

  • Involved in requirement gathering and technical design of the SAP BW/BI data model that would be optimal for BW-BOBJ reporting.
  • Participated in client meetings and Designed the Cubes, DSO’s and Info objects that would suite the Business Objects reporting.
  • Extensively used 0Emplioyee attr and enhanced it to meet the business requirements, also created Custom data source for Info types PA10015, PA0209, HRP1001,HRP9001, PA9002 and enhanced the 0Employee using these info types.
  • Incorporated all the best practices such as turning on the Navigational attribute while designing the data model so that the prompts in Webi reports can be created using the navigational attributes.
  • Recommended the best practices while using the BEx analyzer such as turning on the use of Structural elements using transaction RSRT.
  • Involved in initial migration of the objects with in BW i.e. from development to Quality to Production using Transport connection and Transport organizer (SE09)
  • Worked on extracting and loading 0Orgunit Hierarchy and activating the 0Orgunit Hierarchy in BEx query so that the 0Orgunit hierarchy can be utilized in the Webi and Crystal reports.
  • Involved in the initial set up of all the systems on the BW side and carrying out the systems tests.
  • Identified the required BW info objects to be authorization relevant and involved in security configuration of roles and importing those roles to CMS where the configured security model can be replicated into Business Objects repository.
  • Conducted a lot of User and Developer training workshops to develop Ad-hoc BEx queries and Universe for the power users to develop Ad-hoc reports.
  • Involved in Pre-go live and Post - go live activities in BW and Business Objects side of implementation.
  • Involved in function and technical requirement gathering while redesigning some of the reports which might hamper the performance while executing the reports using SAP Business Objects reporting tools.
  • Designed the data flow between SAP BW-BI and BOBJ while recommending the right tool set for different type of reporting needs and also deciding if the reports can be executed using refresh on demand or if the reports can be scheduled reports.
  • Installed the entire Client tool such as Webi, Crystal reports 2008, Xcelsius 2008 on all the Client Machines.
  • Documented the different connectivity types that each tool can use as this is the first implementation at Confidential for SAP BW/BI and SAP Business Objects while educating the developers and user and incorporating the best practices while developing the Universes, Webi reports and Xcelsius dashboards.
  • Suggested the required Hardware and Software resources e.g. Service packs, Fix-packs which improved the performance my 65% and user satisfaction by 80%.and also coordinated with SAP to get LA fixes for specific performance issue.
  • Developed a lot of POCs for Hierarchies from BW and Crystal Integration with BW while integrating Info view with SAP Portal.
  • Designed the migration strategy for BOBJ reports across the landscape i.e. from Development to Quality to Production using Import wizard also used Software Inventory tool to detect the tools and the versions across the landscape.
  • Extensively use @prompt and @select function in universe design for the creation of prompts.
  • Used standard BW CTS to transport Crystal and Xcelsius Dashboards across the landscape.
  • Designed the BEx Query while incorporating the best practices so that the Universe can perform optimally while executing the Webi reports, also used XML coding to customize and create the Universe prompts to cater user needs.
  • Developed Xcelsius Dash boards using Xcelsius Engage Server while consuming the data from SAP BEx Query, for instance the head count of employee in an Org unit for a Particular Fiscal year period.
  • Proposed the Naming standards that would help the developers to distinguish the BEx queries that are built specifically to build the Universe and Webi reports.
  • Responsible for developing the Technical Design Documents starting form BW/BI Data Source to Webi reports, Crystal or Xcelsius Dash-boards.
  • Extensively used Query Stripping feature which improved the query performance by 50% while retrieving the data from the OLAP engine.
  • Designed the Webi reports to in corporate the requirements while suggesting if the reports need to be executed in parallel or /Hyperlink (Jump to Reports), also used Webi Rich client to develop the reports and export it to the Info view.
  • Extensively used transactions RSTT to capture the traces and used MDXTEST to test the generated MDX statements in BW.
  • Designed and Developed Crystal Reports using Crystal Report 2008 while using the concept of Sub-reports where the reports required to merge the data coming in from different data source at report level.
  • Involved in Security design for the whole implementation while working with security team to configure the security and importing the roles to CMC so that the intended security can be implemented over the designed BW/BI Data ware house Model.
  • Extensively used CMC and CMS XI 3.1 for configuring authenticating users and groups, and keeping track of the availability of the other Business Objects Enterprise services like system database connections, session tracking etc.
  • Implemented Folder Security in CMC to reflect in the Info view where only authorized user can View, Modify, Schedule, Refresh, copy to Favorites or even to export to different formats.
  • Conducted a lot of User and Developer Training work shop to educate the Users and Developers to execute the reports while educating the users with the limitation and advantages of the tool.
  • Responsible for Pre Go-live activities and user acceptance testing and successful Go-live at PepsiCo.

Environment: SAP BO XI 3.1 SP3, SAP R/3 ECC 6.0, SAP BI 7.0 SP7, AIX server (Business Objects Enterprise), BEx Analyzer, ABAP/4.

Hire Now