PROFILE

• SAP Business Intelligence BI/BO consultant with over 10 years of experience in IT industry with over 9 years of experience in Business Objects/Business Intelligence Business Warehouse and complete lifecycle implementation in SAP HANA with 5 complete Business Objects/BW lifecycle implementations involving data modeling, data extractions, installation, configuration, report development, administration and performance tuning.
• 10 years of Business Objects XI 4.0/3.1/3.0/XIR2/6.x/5.x experience - Central Management Console, Central Configuration Manager, Portal Infoview, Web/Desktop Reports OLTP/ OLAP Intelligence, Data Integrator, Designer, Supervisor, Application Foundation, Enterprise Performance / Information Manager, Dashboard Manager, Scorecards, Import Wizard, Report Conversion Tool, Broadcast Agent, Scheduler, Publisher and Auditor.
• Excellent understanding of the concepts of business process measurement, including the definition and specification of Key Performance Indicators and formulation of metrics
• Experience serving as lead and facilitator on BI and data management projects
• Expertise in project management over three full lifecycle implementations
• Facilitated training on Business Intelligence tools and user adoption of WebI, Dashboards, OLAP analysis
• Subject matter expert in the use of one or more BI technologies.
• Expertise in concepts of data governance and with the ability to facilitate business-driven data governance initiatives
• EXPERTISE DOMAIN SAP HANA Developer:
• Experience in HANA data modeling with HANA Studio for creation of Attribute, Analytic and Calculation Views
• Experience with HANA Data Provisioning for data extraction from SAP ECC, CRM and BW to HANA Database
• Experience with SLT and DXC data provisioning methods.
• Leverage knowledge of data warehouse and software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines.
• Work with client architecture teams to validate functional requirements and providing inputs on architecture options.
• SAP Business Objects Architect
• Analyze the reporting requirements with the business users/architects and come up with the technical Specifications for universe and BO reports. Designed and Documented Universe and Report Requirements Definition templates, Security strategies.
• Successfully installed Business Objects products on windows
• Provided the client with best practices with design and development process.
• SAP Business Objects Administration
• Experience with administration of System Management Tools - CCM Central Configuration Mgt , CMC Central Mgt Console , Data Federation Administration Tool, Upgrade Management Tool
• Coordinate DBA activities relating to export/import, giving the access rights, creating the users.
• Coordinate with database administration, setting up users, Backups House Keeping
• Created and maintained trigger events for event based scheduling for various WebI reports, dashboards
• Moved BI resources from one repository to another, managed dependencies of resources and rolled back promoted objects , in case of errors
• SAP BOBJ Development
• Experienced with creating universes and classes, objects and derived tables, store procedures
• Developed reports with OLAP Universe's against BW System and OLTP Universe against OLTP systems
• Experience with Xcelsius Dashboard development with options of Query Browser, BI Services, QaaWS, Live Office, QaaWS, XML etc., as SAP BW Cubes, BEx Queries and Oracle/MS SQL source systems.
• Expertise in BO explorer, OLAP Analysis, SAP Lumira, Design Studio, Dashboards and Crystal Reports
• Developed Web Intelligence reports, Crystal Reports and Dashboards for end users
• System Analysis / Project Management
• Interacting with clients for requirement gathering, system study analysis of all client job requests.
• Drafting functional requirements for computer hardware, software and operational procedures using models and diagrams to represent the processes and functions involved.
• Provide post-implementation, enhancement and maintenance support to client for application.
• Training Development
• Developing and delivering individual training / group coaching and instructional programs, encompassing a wide range of soft skills, operational, management in terms of skills and attitude.
• Evaluating effectiveness of training and development programs and utilizing relevant evaluation data to revise or recommend changes in instructional objectives and methods

TECHNICAL SKILLS

• BOBJ Tools: BOBJ BI 4.1, BI 4.0, Analysis for OLAP Web, Microsoft Office ,Business Objects XI 3.1, CMC, CMS, Universe Designer, Information Design Tool, WebI, Crystal reports, Xcelsius, Dashboard Design, Data Services, BOBJ Explorer, Mobile BI, QaaWS, Live Office, BIWS BICS
• SAP In-Memory Computing: SAP HANA, SAP HANA Studio, SAP HANA ONE HANA on Amazon aws
• OLAP: Informatica, MS SQL Server Reporting Services, SAP BI 7.3/7.0, SAP BW 3.5, 3.1b, 3.0, BWA 7.2
• ERP: SAP ECC 6.0/5.0, R/3, 4.7/4.6c
• Reporting Tools Crystal Reports, Mini-Tab, Oracle Crystal Ball, SAS
• ETL Tools: Data Services/Data Integrator XI 3.1/3.2, Informatica
• Operating Systems: UNIX, LINUX, Windows
• Databases: Oracle 10g/9i/8i/8.0, Sybase, SQL Server 2005, MS Access
• Languages: ABAP/4, C, C , Java, ASP.Net, VB.Net, HTML, XML, PL/SQL
• Other Tools: MS Office 2010/2007/2003 Excel, PowerPoint, Word, Outlook, Project , Visual Studio, HP Quality Center, Remedy, SharePoint, Illustrator

EXPERIENCE

Confidential

Role: SAP BI Architect

Responsibilities/Deliverables:

• Deployed 3-level BI reporting 2 Dashboards as Level 1-Aggregated information for executive management, 10 WebI reports as Level 2- BI reporting for BU managers, Analysts,5 Crystal Reports as Level 3- Operational Reporting for assessing weekly business tasks that capture vendor rationalization, procure to pay cycle time.
• Designed and Developed Multi layered dashboard for Purchase Order and Spend Analytics using connectivity with Query browser, BI Services and QaaWS.
• Conducted business workshops current processes and to document and prioritize requirements specifications, business processes and recommendations
• Evaluated As-Is Current Landscape Business Intelligence solution specific to Supply Chain Procure to pay.
• Evaluated the integration of BW with Business Objects BO platform in comparison to best practices
• Analyzed BO Statistics as a performance measure to track health of BI system and Utilization of KPIs across the organization
• Documented the system landscape and developed a AS IS high level system design document, Discovery Document, GAP analysis based on understanding of system design real expectation of the Business Users
• Evaluated Audit database, Audit Reports and universes to optimize BO system performance
• Documented the current processes and to prioritize requirements specifications, business processes and formulated a list of 35 KPIs as a Master list.
• Based on requirements gathered from the business workshops, generated High Priority KPI reports for Purchase Order and Spend Analytics from the Master list.
• Developed data connection for Invoice and POs Purchase Orders from 3 instances of ECC and Provisioned for data extraction from non- SAP system i.e. Power Advocate to Business Objects using IDT
• Experience with SLT and DXC data provisioning methods
• Developed Attribute views for all Material group, PO related data and Analytic, Calculation views for differential and inferential Analytics from the Master KPI list
• Used Upgrade Management tool to migrate Reports, Universe's from 3x environment to 4x environment.
• Created users, groups and assigned users to the respective groups as per the need.
• Developed new reports against BW Source. BICS connection , Universe .unv and .unx
• Converted existing reports which are based on Universe as the data provider to BICS connection.
• Developed universe in IDT with Multi source.
• Used LCM/Promotion Management tool for migrating reports/Groups/Universe's from one env to another env.
• Responsible for Unit testing for all developed reports and production Support with BOBJ Universe's and Reports
• Enabled Self Service BI for the business by conducting User Training on Business Object BO to enable Power users achieve full utility of BI while leveraging Supply Chain Business Analytics
• The training ranged from exploring basics of BO such as making basic reports changes to advanced reporting features like data mashing, joins and unions to create complex reports and analytics

Environment: SAP HANA, SLT, SAP BODS, SAP BI 4.1, SAP BW 7.3,SAP HANA Business Explorer BeX , Query Designer, Dashboard Design, WebI, Info view, Analysis for OLAP, Lumira, Web Intelligence, BI Launchpad, BOBJ Explorer, Business Area: MM,PUR,FI

Confidential

Role: SAP BI Architect

Responsibilities/Deliverables:

• Gathered Requirements for Enterprise Marketing Management EMM Reports provided all the Budget and Forecast Finance information for Marketing activities at Kraft Foods
• Conducted business workshops to understand the various BUs at Kraft and captured requirements during Story boarding for report development, Blue Printed the requirements for the EMM source reports as a team lead
• Developed attribute views for all BU Master Data and Analytic views to understand ROI Return on Investments for all marketing related activities using HANA Studio
• Experience with SAP HANA Data Provisioning and using SAP LT Replication Server SLT .
• Extracted data using SAP Landscape Transformation SLT as data provisioning to HANA Data Base.
• Involved in replication of data from the database to SAP HANA using SAP Business Objects Data Services.
• Involved in creation of calculation views using SQL Scripting.
• Created a Multilayer EMM Dashboard mockup which was used to create a dashboard for Kraft CTO and Brand Managers to get a snapshot of all the investment on the Marketing related activities at Kraft Foods
• Involved in Data Modeling the complete solution for EMM from generating files from External Teradata database and JD Edwards database to build OLTP universes in BO using IDT
• Created EMM Planning and Spend BeX Reports used as Source reports for BO
• Created Spend BeX report for WebI report for Business Unit/Category/Brand Managers for all the product lines at Kraft Foods with respect to Finance information for all Marketing activities
• Created 22 WebI reports, 2 Level 2 Reports based on Analysis for OLAP
• Created a EMM dashboard in Dashboard Design by adding a Spend and Planning EMM BeX Query using the Query browser and mapped certain components on the dashboard
• Created a subset of WebI report blocks and used Live Office to fetch data for dashboard
• Developed complex dashboards to enable multi-level What-if analysis and used Dynamic Visibility
• Documented User Acceptance test cases and validated test results during user acceptance testing
• Involved in End User-Training documentation, conducted Usability and Interaction sessions with power users
• Prepared weekly reports for the project manager showing progress against outstanding milestones, status, resource requirements, issues, risks and dependencies
• Experience with administration of System Management Tools - CCM Central Configuration Mgt , CMC Central Mgt Console , Data Federation Administration Tool, Upgrade Management Tool
• Used LCM/Promotion Management tool for migrating reports/Groups/Universe's from one environment to another environment

Environment: SAP HANA, SAP BODS< SAP SLT,SAP BO 4.1 SP5, SAP BW 7.3, Business Explorer BeX , Query Designer, Dashboard Design 6.0, Live Office, Information design tool, CMC, Web Intelligence, BI Launchpad, QaaWS, BICS,DataServices, BOBJ Explorer, Analysis for OLAP, Mobile BI, Analysis - Edition for Microsoft Office

Business Area: SD, FI

Confidential

Role: SAP BW/BI Lead Consultant

Responsibilities/Deliverables:

• Assessed client needs utilizing a structured requirements process gathering, analyzing, documenting and managing changes to assist in identifying business priorities and advised on options
• Worked with business partners to align technology solutions with business strategies
• Established liaison relationship with business partners by assessing timelines and critical paths in project management
• Responsible for documenting functional requirements including data flows and high-level source to target data mappings as part of creating advanced self-service BI OLAP and Data warehouse environments
• Modeled the complete solution for internal supplier, service level and back order using ETL to pull data from staging layer using Sales Order, Purchasing and Delivery extractors
• Designed and developed report in SAP BW for Service Level and Back Orders Report and used the Bex report as the connection to develop a Multilayer Sales Overview Dashboard in BO 4.1
• Created universe and OLTP connections to map generic data sources in ECC for Sales document category and DSO days
• Created Order fulfillment report for Sales/Customer Service Managers across all plants with respect to requested delivery data and confirmed delivery date on Sales Orders
• Configured Auditing data store tables and Monitoring dashboard, relevant universes
• Utilized Promotion Management tool to move BI resources from one repository to another, managed dependencies of resources and rolled back promoted objects , in case of errors
• Created backup and Restored Folders/objects from Repository
• Documented User Acceptance test plans
• Documented user test cases and validated test results during user acceptance testing
• Involved in End User-Training documentation, conducted Usability and Interaction sessions with power users
• Provided the security access management by creating users/groups and folders
• Created and maintained trigger events for event based scheduling
• Broadcasted WebI reports to individual recipients using BI LaunchPad scheduling functionality
• Worked extensively on data extraction of SAP BI standard data sources and created generic data sources and data modeling by creating custom Info Cubes, ODS Objects, Info sources, Info objects, Transformations, Extractors, Info sources, Info packages, Info objects Catalogs, Data sources, Data Extraction, Business Content, Data Marts, Process Chains

Environment: SAP HANA studio, SAP BW 7.3, ECC 6.0, Business Explorer BeX , Oracle 10g, Business Explorer BeX , Business Objects 4.0/4.1, Information design tool, Enterprise Portal, Web Intelligence, Dashboard Design, BI LaunchPad, QaaWS, Live Office, BICS, Information Design Tool, Data Services, BOBJ Explorer, Mobile BI, Analysis - Edition for Microsoft Office Business Area: SD, MM, HR, SCM

Confidential

Role: SAP BI Senior Consultant

Responsibilities/Deliverables:

• Designed a complex Dashboard for inventory categorization deployed in all plants across Europe and Asia to be used in materials management using QaaWS, Live Office, BI services to source data from SAP and Non-Sap source systems
• Involved in requirement gathering, data modeling, scheduling data extraction from source systems
• Developed several WebI reports for Inventory Categorization based on Stock Consumption and Material Consumption
• Created OLAP Universes on SAP data Info Cubes / BeX queries using Universe Designer and IDT
• Created OTLP Universes and classes, stored procedures. Resolved loops using aliases and contexts. Created complex joins like outer joins and equi-join theta joins and checked the integrity of the Universes.
• Created detailed reports with Drill-down capability using Web Intelligence in BI Launchpad / Info View, worked on Ad hoc Query, Reporting, and Analysis
• Built universes using Universe Designer from SAP and Non-SAP source systems
• Created reports with Multi-Level Scope of Analysis using drill down, drill across, drill up in Web Intelligence and Desktop Intelligence.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, inserted calculations, Filters, Sorts, and Query Prompts.
• Created WebI reports from multiple data providers and synchronized data with merged dimensions
• Developed new reports against BW Source. BICS connection , Universe .unv and .unx
• Used Promotion Management tool for migrating reports/Groups/Universe's from one env to another
• Developed work books using Analysis edition for office.
• Developed several Dashboard in Xcelsius using BI Services connection.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Provided the security access management by creating users/groups and folders.
• Involved in installation and configuration of BO and BW using SAP BI/ BOBJ Integration Kit.
• Created linked WEBI reports and Xcelsius dashboards using Open Document OpenDoc functionality
• Used Life Cycle Management LCM to transport WebI reports, Web services and dashboards from Development to Test to Production systems

Environment: SAP BW 7.3/7.0, ECC 6.0, Business Explorer BeX , Business Objects 4.0/XI 3.1, Crystal Reports 2011, Universe Designer, Enterprise Portal, Web Intelligence, Xcelsius, BI Launchpad, QaaWS, Live Office, BICS, Information Design Tool, Data Services, BOBJ Explorer, Mobile BI Business Area: FI-AR, AP, QM, SD, MM