SUMMARY:

• Over 10 years of IT experience
• Certified with BusinessObjects
• Experienced in BI 7 upgrade assessment, SOW, sales and presentation to clients
• Experience with system architectural design for SAP and legacy system integration with SAP BI
• Designed and architected BusinessObjection BI4.1 landscape design for scalability and user growth.
• Experience with Enterprise Portal, WAD and Design Studio
• Lead installation and upgrade of BOBJ 4.0 to 4.1.
• Performed migration from BOBJ 3.1 to 4.0 and performed upgrade from BOBJ 4.0 to BI 4.1
• Configured complex integration for BO 4.1 in a clustered environment with SAP BI, ECC and SQL EDW
• SAP BI 7, BW and SEM BPS. About 6 years of work experience with all aspects of BW / BI planning, designing, and implementation of analytical solutions in diverse industry sectors.
• Involved in SAP HANA migration to BW on HANA
• Extensive white paper design and use of ASAP methodology for complex BI initiatives to manage scope and budget.
• Experience with Rapid Mart Installation and configuration to client need
• Extensive work with BOBJ BI4.1 security integration with BW & HANA
• Worked with HANA Studio in a HANA Enterprise environment with SLT between ECC and HANA
• Extensively worked in the designing of performance optimization strategy for BW Data warehouses
• Experienced in G/L Accounting, Accounts Receivables and Accounts Payables, Cost Center Accounting, Internal Orders, Profitability Analysis.
• Excellent experience in Extraction (Lo - Cockpit, FI/CO, HCM, SD, CRM, MM, GTS) of Master data and transactional data and Performance tuning.
• Experience with Non-SAP source of data extraction using Universal DataConnect (UDConnect)
• Experience with Business Objects, Xcelsius Enterprise 2008 with integration with crystal report, LiveOffice and Bex
• Insight with best business practices and technology to optimally drive client business processes
• Lead and implemented BusinessObjects and BW upgrade (BW 7.3 to 7.4 & BI4.0 to BI4.1) with HANA migration
• Expertise in executing SEM BPS functionality, creating Planning Packages
• Extensive experience in system analysis and design methodologies, excellent communication skills and ability to work well in a team and manage multiple assignments at the same time.
• Extensive experience in client training in Data Warehousing and Reporting Analytics.
• Experience working with BPC 10.1 with US Elimination.
• Experience with SIX SIGMA integration with SAP implementation.
• Implemented Two (2) Full life cycle Projects involving SAP BPC . Implemented BPC for Financial Planning for Income Statement and Balance Sheet and Headcount.
• Expertise in creating BPC reports, input schedules, Data Manager packages (Including custom SSIS packages), Advanced Script Logic, security setup, Currency conversions, Intercompany Eliminations using Logic and Business rules.
• Knowledge on migration to SAP BPC 10.1(Netweaver version) from BPC 7.5(Netweaver Version)
• Involved in BPS implementation for Sales and Profit planning,, P&L Planning, Balance Sheet Planning and Cost Center Planning

PROFESSIONAL EXPERIENCE:

Confidential

Senior SAP BI, BOBJ & HANA Architect

• Designed and proposed entire enterprise architecture for BusinessObjects and SAP HANA
• Performed hardware sizing exercise for BOBJ clustered environment and HANA
• Installed HANA DB for Native HANA and BW on HANA for performance compares
• Configured HANA Live for Purchasing, Finance and Sales.
• Exposed BW infoProviders to HANA Views
• Expert in creation of Analytic views, calculation view and store procedure
• Configured BOBJ and HANA Security
• Setup Analysis for Office and OLAP to work with BOBJ and HANA for SSO
• Created Analytic, attribute and calculation views.
• Worked extensively with HANA security
• Helped created complex HANA enabled Webi, Crystal reports and AO
• Created Packages, restricted attributes and calculated attributes
• Created input parameters and variables within SAP HANA
• Loaded data into HANA using DXC
• Installed and configured BOBJ on a cluster of 16 VMware servers with separate tomcat and CMS machines.
• Lead trouble shooting efforts/issues from the migration of BOBJ 3.1 to 4.1
• Performed installation/upgrade and migration of BOBJ 3.1 to 4.1

Confidential

Senior BOBJ/BODS & HANA Architect/Developer

• Sizing the Servers based on the volumes of data, number of jobs that could run at the same time and number of users
• Designed Performance tuned Landscapes to avoid Network Latency and Client Connectivity issues for SAP BOBJ DataServices and SAP BOBJ Enterprise
• Experience in setting up Development, Test and Production environments and also in setting up the migration standards for SAP BusinessObjects Data Services.
• Selecting the compatible software versions for different components and installing them without any installation errors
• Huge experience in Installing Data Services 3.x and 4.x, Cleansing Packages, Address Directories, Data Quality Management for SAP ERP/CRM, RFC Servers between BODS and SAP, Data Insight, Business Objects Enterprise 3.x and BI Platform 4.x, Information Steward
• Hands on experience in Registering the repositories in the Data Services Management console, configuring RFC Services between SAP and BODS, creating the Job Servers and Assigning the local and profiler repositories and Page File configuration for BODS Cache
• Configuring SAP Authentication between SAP and BOBJ Enterprise, receiver Port configurations for Adaptive Processing Job Servers with in BOE to troubleshoot Client Connectivity for BODS 4.0 Designer and registering BODS repositories within BOBJ CMC for 4.x versions and managing the user rights
• Configuring Real-Time jobs and Web Services for SAP Data Quality Management for SAP and running the Batch and Server RFC’s for both Online and Batch processing of addresses from SAP ECC and CRM
• Configuring the Repositories(Central, Local and Profiler), configuring the Data Stores for different sources and targets with multi configurations and maintaining the Substitution Parameters configuration
• Creation of Job Servers, Job Server Groups and Access Server, configuring the Web Services for Real-Time Jobs, Batch Job Scheduling and Monitoring, monitoring of System Performance and troubleshooting the performance related issues, the Citrix/Client Connectivity issues and SAP Connectivity issues using RFCs
• Code migration using central Repositories, Repository and ATL Export across the landscape, Creation of users and assigning appropriate rights and setting up the Degree of Parallelism for data flows wherever required to tune the job execution performance
• Updating the Address Directories required for Data Quality Management jobs for address cleansing on a monthly basis
• Heavy experience in handling the SAP Basis activities required to perform for integrating SAP ERP and SAP Netweaver BW with SAP BusinessObjects Enterprise/BI Platform, SAP BusinessObjects DataServices 3.x/4.x and SAP BusinessObjects Information Steward.
• Deploying the transports(Cofiles and Data Files) related to BOBJ Enterprise and BODS into respective SAP ABAP systems using STMS
• Creation of TCP/IP RFC(registered Server Programs) connections in SM59 to provide connectivity between SAP and BODS
• Configuring the Shared drive on the SAP Servers which will be used by ABAP Data flows, creation of Source System within SAP BW for BODS to push data into SAP BW using BODS Batch jobs
• Configuring the Logical System, Partner profiles, Inbound and Outbound IDOCs
• Installing the FLDQ Add-Ons in SAP ECC and CRM for Data Quality Management using SAINT, activating the appropriate BC Sets for Global Data Quality connector and doing the SPRO configuration required to enable the Address Check and Duplicate Check for Customer, Vendor and Business partner Master Data
• Validating the syntax for the Function Modules under the function groups ZAW0 or /BODS/BODS which will be called remotely from Data Services
• Install BI 4.1 Platform on 12 servers on AIX using silent installation technique.
• Configure BI 4.1 platform
• Establish connection to external FRS on SAN
• Reconfigure Adaptive Processing Server to detailed specification
• Reconfigure settings of BI server to specification
• Installed SAP BOBJ IPS 4.1 SP2, SAP Data Services 4.2 SP1 and SAP BOBJ Information Steward on a single server with proper sizing considerations.
• Implemented EPCF Eventing Framework between SAP MDG and SAP Information Steward to send data to MDG from IS.
• Implemented the RDS Data Quality Remediation (DQR) with SAP NWBC for providing the framework for correcting the data using SAP MDG and SAP IS.
• Setup the repositories in Oracle Database for IPS, IS and DS and completed the post install configurations for both IS and DS.
• Created connections for various SAP sources within Information Steward including the connections for Data Review and Failed Data capture.
• Conducted workshops with Data Stewards and Data owners to identify Global, Local and Cross-System Data Quality validation rules and categorized the rules into different Data quality Dimensions.
• Generated the standard profiling reports using IS Data profiling features like Column, Dependency, Redundancy, Uniqueness, Address and Content Type Profiling.
• Developed Custom Profiling Rules within IS for Material Master, Customer and Vendor Master Data and captured the failed data into a database and generated the profiling reports as per the user requirement.
• Used the Match transformation in DS jobs to identify duplicates and provided the data back to IS for Business User review using the Match Review configuration. Again after the completion of Review, posted the corrected data back to the sources using DS ETL jobs.
• Developed complex Data profiling jobs for scenarios like MRP Profiling and Material Discontinue Profiling using DS and provided the discrepancy reports for user validation.
• Identified the Master Data non-matches in various sources against the client of record. And filled the gaps and corrected the data discrepancies using DS Jobs and posted the corrected data back to SAP.
• Installed and Configured the AIO Repositories to support migration of Master and Transaction data objects to new SAP ECC 6.0 system from SAP R/3 system.
• After Data Profiling and Cleansing the data, migrated the data for various transaction and Master Data Objects using SAP BP for Data Migration (AIO Packages). This includes the objects from MM, SD, FI, PP, PM and CO.
• Customized standard AIO Jobs whenever required to simplify the ETL Code as per the requirements.
• For custom object migration, generated the files for LSMW load jobs using SAP BusinessObjects Data Services ETL Jobs.
• Designed the universes on top of Failed Data Repository tables to generate pretty reports using Web Intelligence and Crystal Reporting tools.
• Designed score cards by implementing all the Global, Local and Cross-System Data Quality rules for providing dashboard view of the Data Quality metrics and trend. Also implemented the Financial Impact Analysis with the approximate Cost $’s for identifying and correcting the data.
• Trained the Data Stewards to write their own Data Profiling rules in Information Steward and how to analyze the score cards to assess the data quality on a daily basis
• Prepared training documentation for the Data Services Developers and Information Steward Users

Confidential

Senior BW/BOBJ &BODS Architect & Lead

• Installed and Upgraded BusinessObjects from BI 4.0 version to BI 4.1 systems.
• Proposed multiple clustered BOBJ environment and deployed them all.
• Setup Single Sign-On (SSO) Windows AD and SAP BW integration with BOBJ 4.1
• Optimized BOBJ performance for SAP BW data source
• Developed multiple webi, crystal and Xcelsius reports.
• Used Query As Web Service to source data for xcelsius dashboard development
• Created multi tab webi reports and scheduled them to a dynamic recipient list
• Performed SAP HANA POC for future deployment of BW on HANA
• Captured all the statistics for ETL processing in customer designed log tables for future analysis and customized error handling process.
• Carried out performance tuning for Business Objects Data Services.
• Deployed appropriate version of the ETL builds to various environments.
• Designed metadata driven ETL Framework in Business Objects Data Services. Carried out architecture/design, content management, change management, data analysis, data quality and data migration tasks
• Set up and configured BI 4.1 Mobile environment
• Worked with Multiple data providers including Personal Data files, Stored Procedures and Freehand SQL to create reports.
• Configured Local, Central and profile repositories and repositories are associated to the Job server.
• Access server is configured for Real time jobs. Scheduling jobs to run daily.
• Created Users in Data services management console and assigned roles based on the requirement.
• Used the Match transformation in DS jobs to identify duplicates and provided the data back to IS for Business User review using the Match Review configuration. Again after the completion of Review, posted the corrected data back to the sources using DS ETL jobs.
• Developed complex Data profiling jobs for scenarios like MRP Profiling and Material Discontinue Profiling using DS and provided the discrepancy reports for user validation.
• Identified the Master Data non-matches in various sources against the client of record. And filled the gaps and corrected the data discrepancies using DS Jobs and posted the corrected data back to SAP.
• Installed and Configured the AIO Repositories to support migration of Master and Transaction data objects to new SAP ECC 6.0 system from SAP R/3 system.
• After Data Profiling and Cleansing the data, migrated the data for various transaction and Master Data Objects using SAP BP for Data Migration (AIO Packages). This includes the objects from MM, SD, FI, PP, PM and CO.
• Customized standard AIO Jobs whenever required to simplify the ETL Code as per the requirements.
• For custom object migration, generated the files for LSMW load jobs using SAP BusinessObjects Data Services ETL Jobs.
• Designed the universes on top of Failed Data Repository tables to generate pretty reports using Web Intelligence and Crystal Reporting tools.
• Designed score cards by implementing all the Global, Local and Cross-System Data Quality rules for providing dashboard view of the Data Quality metrics and trend. Also implemented the Financial Impact Analysis with the approximate Cost $’s for identifying and correcting the data.
• Trained the Data Stewards to write their own Data Profiling rules in Information Steward and how to analyze the score cards to assess the data quality on a daily basis
• Prepared training documentation for the Data Services Developers and Information Steward Users

Confidential

Senior BW/BOBJ/BPC Architect & Lead

• Installed and configured BPC, BusinessObjects BusinessIntelligence and BusinessObjects Data Service and clustered all three system to use a single repository.
• Upgraded BusinessObjects from BI 4.0 version to BI 4.1 systems.
• Migrated BI 4.0 version of reports to BI 4.1
• Troubleshoot and fixed all migration related issues with reports and schedules
• Created and configured Central and Profiler repositories and connected to BOE CMC
• Connected BOBJ Enterprise to MS SQL Analysis service
• Created relational universes on top of SQL Enterprise data warehouse (EDW)
• Worked on integrating Dataservices with BW 7.3 for right optimized DSO
• Sizing the Servers based on the volumes of data, number of Profiling jobs that could run at the same time and number of users
• Designed Performance tuned Landscapes to avoid Network Latency and Client Connectivity issues for SAP BOBJ Information Steward, SAP BOBJ DataServices and SAP BOBJ BI Platform/SAP BOBJ Platform Services
• Created CRM account management, leads and opportunity reports for marketing managers.

Confidential

Senior BW Architect & Lead

• Involved in new development of BW Data Flow for the application Business area FI, CO, HCM IS-U Billing, FI-CA, Device Management and CRM Interactive Center Reporting. Gathered requirements from End users and prepared the Functional and Technical Specifications for the BW Reporting Requirements.
• Involved in gathering the reporting requirements for FI, AM, MM, HCM, IS-U Billing, FI-CA, Device Management and CRM Interactive Center by conducting workshops.
• Identified the Standard content for the BW Reports and activated them from the BW Business Content.
• Created the Report catalogue after identifying the Standard, Modified and Custom report requirements.
• Involved in IT discussions to guide them on the Server Sizing for setting up the SAP BOBJ landscape.
• Trained the Client technical Resources on SAP BW and SAP BOBJ Tools to bring them up to speed for the Realization phase.
• Involved in creating the Functional and technical specification documents and developed the objects as per the design.
• Involved in Code development in ECC and BW as and when required as per the customization requirements.
• Involved in handling the complete BI Security at the BEx level and used BEx queries as the Basic layer for the Crystal Reports.
• Worked with Basis to guide them in setting up the BOBJ landscape and integrated with SAP BW landscape.
• Involved in doing the entire configuration required for SAP BW and SAP BOBJ integration.
• Established the SSO between SAP BW and SAP BOBJ tools.
• Involved in creation of Master BEx Queries for Crystal Reports.
• Used SAP BW Publisher Service to publish the Crystal Reports from Crystal Tool to SAP BW and SAP BO Enterprise.
• Created various Dashboards for the purpose of Managers and C-level employees of the organization using SAP BusinessObjects Xcelsius Dashboard tool
• Designed the strategy for BO enterprise security on the top of SAP BW Security for Folder level access to different end users.
• Installed and configured DQM Solution for SAP ECC and CRM WEB IC Client to cleanse the Address information for Customer and Vendor master data.
• Installed SAP BOBJ DataServices, Person & Firm Directories and USPS Address Directories.
• Configured Real-time Jobs and Corresponding Web services required for online cleansing Solution
• Installed and Configured RFC server between SAP ECC and SAP BOBJ DataServices for Communication through Web Services.
• Involved in completing the SPRO configuration required for DQM Address verification.
• Involved in Technical and Functional Upgrade of SAP BW 7.01 to SAP BW 7.3
• Involved in Technical and functional upgrade of SAP BOBJ Enterprise 3.x to SAP BOBJ BI 4.x.
• Worked on converting the .UNV universes to .UNX universes and migrated the BOBJ 3.x code to BI 4.x environment.
• Created Analysis workbooks on top of SAP BW BEx Queries and Multiprovider.
• Created Interactive Analysis Reports (Formerly known as Web Intelligence) by taking BEx queries as source.
• Created and setup Analysis authorization for BW security and integrated with bobj
• Developed BW data model for optimum performance
• Worked with BW 7.3 upgrade team to install and upgrade BW
• Setup SAP BW and ECC with BusinessObjects dataservice & DQM
• Installed and configured SAP HANA
• Configured SAP HANA with BW and BusinessObjects
• Modeled Analytic Views into Calculation views
• Created attributes for master data withing Hana to utilize for Analytic views
• Created JDBC connection to consume HANA information through Explorer, crystal report and excelsius
• Created ODBO connection for consume some finance reports through excel and to gain HANA performance benefit
• Worked to evaluate HANA performance thresholds using Hana Studio and HDBSQL to determine the amount of time required by HANA server to process each query after runtime.
• Utilized SLT to pull in sales tables to create analytic view in HANA
• Worked on CRB Billing reports
• Created reporting solution for CRB interaction records coming from CRM and merging with existing order from ERP

Confidential

Senior BOBJ Lead/Architect

• Installed and configured BusinessObject system
• Worked on installing and setting up BOBJ clustered environment
• Helped designed Bobj security
• Performed knowledge transfer with client technical system
• Installed and configured BusinessObjects XI 3.1 SP3 on servers running on Windows 2008 64bit
• Performed report migration from XIR2 to 3.1
• Worked to troubleshoot Webi and Crystal reports migration issues
• Installed BOBJ Integration Kit for integration with BW and configured parameters for BW Publisher
• Setup security for BOBJ system with access levels and authorization for different users
• Created Universes, Webi Reports, and Crystal Reports as
• Documented all stored procedures and did thorough knowledge transfer

Confidential

SAP BI & BOBJ Architect & Lead

• Performed BOBJ 4.0 to over 600 user for BusinessObjects WebIntelligence, Crystal Reports, Xcelsius and Advanced Analysis.
• Configured BusinessObjects integration with sharepoint
• Configured Bex web with BusinessObjects BI launch Pad
• Participated in the workshops with the power users, business analysts and team members to analyze business requirements.
• Installed and configured BusinessObject 4.0
• Conducted several proof of concept for BOBJ front end tools to the power users and the BW technical/functional team members.
• Created OLAP and Relational connections to create webi reports and Xcelsius dashboards
• Created complex webi reports
• Installed BusinessObjects 4.0
• Verified Server configuration for Data Services and ensure Job Server is running
• Configured and associate Job Server with Rapid Marts Repository
• Checked BIAR imports to be sure WebI and Universes are intact
• Setup and checked contingency for Sales Rapid Marts
• Installed server components
• Installed and configure Web Tier components (Tomcat)
• Installed Client Tools (WebI, Xcelsius, Crystal, Import Wizard and Data Services)
• Create Enterprise user accounts
• Setup security for created user accounts with custom access levels
• Configure servers and Server Intelligence Agent for processing tier
• Test logon to InfoView, CMC and WebI with SAP Authentication
• Created Crystal report with BEX Query and save/publish to BW using MDX connectivity
• Created Crystal report with ECC tables using Open SQL Connectivity
• Setup assess usage to determine 32Bit or 64Bit installation

Confidential

SAP BI & BOBJ Lead/Architect

• Created several Bex queries for businessobjects universe
• Created OLAP universe for webi reports
• Created user exits for bex query for webi reports
• Created complex webi reports
• Worked with BusinessObjects 4.0
• Setup OLAP analysis for Advanced Analysis web client
• Worked with advanced Analysis
• Redesigned Corporate dashboards with Live Office integration to enhance performance
• Proposed recommendations to enhance performance of Xcelsius dashboards.

Confidential

SAP BI & BOBJ Security Architect

• Worked with SSO for Open Document and Live Office
• Configured BusinessObjects Explorer and Explorer security
• Work with network team to setup ROAMBI
• Configure BusinessObject InfoView integration with Sharepoint
• Created order status and sales analysis dashboards using Xcelsius to publish to EP using opendoc link
• Designed Xcelsius dashboards and work on performance tweaks for Live Office connection to Xcelsius
• Redesigned Corporate dashboards with Live Office integration to enhance performance
• Proposed recommendations to enhance performance of Xcelsius dashboards.

Confidential

SAP BI & BOBJ Security Architect

• Created multiple composite SAP BW roles to be imported to BOBJ
• Created complex webi reports for sales and financial reporting
• Created and validated SNC between SAP BW and SAP BOBJ
• Created complex Xcelsius dashboards
• Created custom access levels for BOBJ security integrating with BW and LDAP users
• Made performance recommendations to overcome MDX API performance issues
• Worked with setting up SSO integration between SAP BW, Enterprise Portal, BOBJ and LDAP group
• Worked with SSO for Open Document and Live Office
• Configured BusinessObjects Explorer and Explorer security
• Work with network team to setup ROAMBI
• Created order status and sales analysis dashboards using Xcelsius to publish to EP using opendoc link
• Designed Xcelsius dashboards and work on performance tweaks for Live Office connection to Xcelsius
• Redesigned Corporate dashboards with Live Office integration to enhance performance
• Proposed recommendations to enhance performance of Xcelsius dashboards.

Confidential

SAP BI & BusinessObjects Consultant

• Created programs in SE38 to be used in Bex user exits for Bex reporting and BOBJ
• Performance tuning for Bex reports and also to be applied to BOBJ reporting
• Turned on MDX tracing and webintelligence tracing to compare performance between BOBJ and BW API
• Applied both manual and automatic MDX function modules and program corrections for performance improvement (Reports that use to run for about 20 minutes improved to 45seconds)
• Performed evaluation and recommendation for performance when using MDX API
• Created multiple date variables in BW utilizing customer exit variables to be utilized in Bex and Webi
• Created MDX statements in BW to be utilized for BOBJ reporting
• Created multiple BW OLAP universes
• Worked with report developers to resolved multiple BOBJ

Confidential

SAP BI & BusinessObjects Solution Architect

• Setup SAP user authentication for BusinessObjects users
• Setup transports on SAP server side for Crystal publishing to SAP BW
• Defined OLAP connection between SAP BI and BusinessObjects to generate OLAP Universe
• Generated, saved and Exported OLAP universe to the CMS
• Accessed OLAP universe through Webi to create Webi reports
• Setup SSO between portal and BusinessObjects
• Configured Secure Network Communication (SNC) both on BOBJ server side and SAP BI side for SSO
• Involved in requirements gathering and KPI’S from Business users and prepared Functional and technical specification documents
• Created and edited OLAP universes based on BW queries
• Responsible for migrating SAP BO Universes, reports to quality and production environments.
• Worked with SAP Portal team to publish BOBJ reports
• Worked with Basis to upgrade Bi system to EHP1 and SP5 to maximize tight integration between SAP BI and BOBJ
• Developed various reports based on SAP CRM Leads, Opportunities, Service Contracts queries using Web Intelligence, Crystal Reports and also Bex Analyser..
• Developed different kind of dashboards using Xcelsius by configuring QAWS and Live Office.
• Installed SAP Integration Kit and Service Pack 2 also Fix Packs to resolve integration issues.
• Also worked with Basis to upgrade SPAM level
• Setup user Authentication between SAP BW and BusinessObjects
• Perform system server sizing for BusinessObjects Dev, QA and Prod
• Configured LDAP authentication in BusinessObjects for User SSO
• Performed user security landscape for enterprise wide single sign-on (SSO) with the use of LDAP, IDM and Access Manager.
• Set multiple hierarchy node in Bex Query for consumption in BOBJ universe
• Performed system performance evaluation for SAP BW and BusinessObjects for performance and system landscape
• Developed SAP BI custom InfoCube according to client specification and then exposed master queries to BOBJ universe

Confidential

Lead Sr. SAP BI & SAP BPC Consultant

• Clarify integration of SAP BPC with SAP BI in the Netweaver platform and setup client demo
• Set up Application Set for prove of concept
• Gathered business requirement for financial budgeting and consolidation
• Defined dimensions and process dimension members in BPC
• Verified and tested Netweaver integration of BI 7.0 and BPC to make sure data was automatically loaded into BI during dimension processing in BPC.
• Involved in Business Blue Print to post production support of financial consolidations
• Responsible in Finance Application Development, enhancements and periodic data loads
• Developed multiple BPC reports and input schedules using EVDRE function.
• Assisted in the periodic data reconciliation efforts between BPC, BI and ECC systems.
• Responsible in validating and fixing issues regarding alternate hierarchies in BPC.
• Installed, configured and deployed Business Objects Enterprise integration with SAP.
• Performed Single Sign On (SSO) between BOE infoview and SAP Enterprise Portal.
• Developed and deployed Xcelsius dashboards using BPC Cost Center developed reports.
• Involved in training Finance team and assisting with Post production Support.
• Develop SSIS packages to support the extraction of data from SAP BI into text files, transform and load data into SAP BPC fact tables.
• Used Xcelsius to develop forecast dashboards to also perform “what if analysis”
• Leveraged Rapid Marts for direct ECC Reporting
• Created universes for customer reporting needs
• Trained business users on how to use BusinessObjects Web Intelligence to create reports
• Utilized Crystal Reports to create detailed financial reporting using sub-reports and parameter based reports.

Confidential

Lead SAP BI & BOBJ Consultant

• Created custom InfoCubes, DSOs, and Master data InfoObjects.
• Wrote ABAP routine lookup for CRM and ECC data merging to satisfy BI reporting requirement.
• Created functional Spec. sheet to gather Business requirement for BI reporting.
• Discussed CRM functionality with business to map out CRM integration of CRM, ECC and BI
• Created web templates using Web Application Designer (WAD) to integrate with CRM UI
• Performed migration of SAP BW 3.5 objects to BI 7.0
• Setup Logistic Cockpit (LO-Cockpit) for sales data extraction.
• Designed integration of Business partner from CRM and ECC to BI
• Designed BI data architectural to suite client business requirement
• Configured SSO between CRM 2007 and BI
• Setup trusted RFC destination for report integration between RCM and BW
• Configured CRM 2007 UI report access to BI using transaction BD97
• Designed data architecture to integrate ECC and CRM data for sales pipeline analysis
• Worked with Basis to upgrade BI system to EHP1 and SP4 to maximize tight integration and performance.
• Created web templates and included queries in them as data providers
• Configured CRM 3007 UI frame via SPRO for BI reporting in CRM; this allowed users to run BI reports in CRM 2007 UI
• Defined BI authorization requirement using partner determination via Business partner hierarchy
• Configured infoset in SQ02 with table joins and assigned infoSet to CRM MKTTGGRP for CRM Customer Segmentation
• Created CRM datasource in CRMD MKTDS and assigned datasource to CRM attribute list for segment builder.
• Setup CRM customer segmentation through segment builder for marketing target groups
• Designed various reports for CRM Accounts, Leads, Activity and opportunity management

Environment: SAP Netweaver 2004s, CRM 2007, ECC 6.0, EP 6.0

Sr. BW Consultant

• Team Lead for BI project
• Implemented multiple projects involving all aspects of Backend development s. This included HR Payroll and Time Management implementation (0PT C01). This is included setting assignment of payroll data in R3 via SBIW and using 0HR PY 1 (payroll transactions datasource) for query developments to analyze periodic overview and comparison of wage types (0PY C02), auditing information (0PY PP C1) and general payroll data. Implementation also involved analysis needs of time and labor data (0PT C01) and comparison of personnel time management and payroll data based of 0PY MC02 Multiprovider.
• Dashboard queries: complex BEx queries built on R/3 data such as for turn-around time of service orders,
• Created custom queries and Web templates, enabling graphs, Restricting authorizations based on territory hierarchy.
• Adapted the CRM territory hierarchy to non CRM infoproviders, requiring a deep understanding of the CRM territory hierarchy design and creating update rules in custom infoproviders to be able to assign non-CRM transactions into the appropriate territory node. Another custom product hierarchy was also built from scratch.
• Project required extensive integration with the CRM and Portal teams as BI was receiving data from CRM and presenting the CRM analytics queries via the Portal. Project went live on-time and on-budget.

Environment: SAP BW/Netweaver 2004s, CRM 5.0,HR, R/3, EP 6.0

SAP BW Consultant

• Interacted with management and users to identify business requirements
• Performed analysis and created reports on General Controlling, Cost and Revenue Element Accounting, Activity based Costing, Profitability Analysis, Product Cost Controlling, General Ledger Accounting, Accounts Receivable and Payable, Funds Management and Travel Management to identify the standard Business Content and map SAP fields to BW
• As lead consulting, handled all aspects of BW and APO-BW modules - coordinated, trained, mentored and led BW team
• Started from Business content installation of all BW objects to modifying transfer and communication structures, updated rules, ODS, Infocubes, infosets, writing start routines, authorizations, etc.
• Worked with multiple source systems (CRM, R/3, eWM, APO, flat files) and multiple layer ODS and Infocubes architecture
• Modified/assigned roles for security including using replacement path authorization
• Worked closely with SAP Walldorf development team to debug errors in the new module
• With multi layer ODS, the data load integrity between two connected data-providers had to be efficiently managed in cases of data load errors; new ODS were added to the existing landscape, initialized and brought in sequence with the other deltas
• Created several queries and web templates as all reporting was web based

SAP BW Consultant

• Source system SCM, Inbound Monitor: Various BW reports were configured to measure and compare timeliness of inbound processes such as time between 4 stages of inbound goods movement: Shipped from supplier, enters the Yard, Received on Dock and Processed for sale.
• Source system SCM, Service Fill/loss: When a sales order is received the Service Fill/Loss program is executed in SCM and a determination is made whether the order can be fulfilled or not based on the complex BOD structure and the business rules such as supersession. If it’s not fulfilled, a loss reason is assigned (Referral, redirected, etc.). BW is the platform which produces the final reports on these results.
• Worked with RRI (Report to Report interface) between ODS object and InfoCube.
• Created Queries by defining rows, columns and free characteristics providing drill down functionality in reporting. Assigned queries to different User Catalog on client specification.
• Developed queries and executed using Business Explorer Analyzer.
• Worked with business people to establish analysis requirements and functional specialists to locate data sources.
• Responsible for training customers in both the configuration and utilities provided by the Business Information Warehouse.
• Extensively worked with flat file (text, excel) loading for transaction data, attributes, texts and hierarchies.

Environment: SAP BW 3.0, SAP R/3, Logistic cockpit, CO PA, HR, BE x Analyzer, Web application designer

SAP BW Consultant

Responsibilities:

• Defined specifications for cross-module views and query functional areas to act as data sources in SAP for BW InfoCubes for more granular analysis of R/3 data in Business Explorer Browser.
• Coordinated integration testing with process teams to validate data in LIS and BW structures and seek end user acceptance. Worked with system admin teams to define specifications for frequency and mode of data transfers and setup batch jobs for InfoPackages.
• Gathered user requirements and designed custom InfoCube by enhancing Info Sources and InfoObjects. After the R/3 upgrade to 4.6C, all the Data Sources are replicated and activated in BW. Scheduled the InfoPackages and solved errors involved.
• Created Accounts Payable (AP) and Accounts Receivable (AR) Cubes based on the reporting requirements.
• More than 200 Manual Loads were done for all the application area. Created ODS Objects and did the load monitoring (RSMO) while scheduling the data uploads. Created Transfer Rules, Update Rules and Update Routines.
• Did the Data Extraction and Data Staging using LO Cockpit (LBWE) and extended the structures using user exits to support the business needs. Performed Data Integration test in both Development and Quality boxes and moved the Cubes into Production.
• Worked extensively on BEx Analyzer (RRMX) and Browser for building queries and Workbooks. Created custom queries using variables and structures. Worked on RRI Jump queries and worked on Web Reporting and Web Publishing.
• Developed reports for the sub modules of MM like Purchasing, Invoice verification and Inventory management. Developed interactive reports like Vendor report for Additional information, Duplicate Invoice report, Register for Manual payments report, Variance report for subcontracting, Property tax statistical information report