SUMMARY

• Over 14+ years of IT Experience of which 10 yrs in SAP as SAP BW/HANA/IP & Business Objects Consultant with very strong functional and technical knowledge.
• Strong understanding and hands on experience with SAP Native Hana,BWoH,IP and Business Objects solution configuration and Variance reporting.
• Involved in end to end implementation of SAP BW on HANA & Native Hana (Hybrid) and Business Objects.
• Involved in multiple full life cycle implementations of BW and BOBJ, which include requirement analysis, data modeling, technical design and development, data extraction, report generation and production support.
• Complete understanding of all phases of project from Planning, Requirements Gathering, Team Management, Blueprinting, Configuration, Development, Integration Testing and Training to Go Live.
• Worked with big four consulting.
• Experience working within both Private and Public Sectors.
• Result - oriented individual and expert in analyzing project objectives and implement suitable solution
• Training: Conducted training sessions for end-users in planning using BW & BO reporting. Also created training manuals for the super users and end-users.
• Key Strengths: Highly focused and goal oriented with dynamic leadership and team-building abilities. Energetic and creative with a special talent for troubleshooting and resolving complex technical problems and escalated issues. Exceptional organizational and analytical skills. Proven leadership attitude and Strong negotiation skills.

PROFESSIONAL EXPERIENCE

Confidential

SAP Solutions Architect

Environment: SAP BI 7.4, Business Objects 4.1 (SP6)

Responsibilities:

• Designed and implemented the Planning application using BI-IP, SAP BW and BOBJ for the Operations and Maintenance.
• Developed Integrated Planning (IP) objects like Aggregation Levels, Filters, Planning Functions, and Planning Sequence and Input Ready queries for Budgeting.
• Experience with input layouts and reporting using BEx and Business Objects Analysis tool.
• Designed and build Dashboard for the Planning application using Design Studio 1.6.
• Creating Web Intelligence 4.1 reports, Analysis for Office 4.1 on Top of BEx queries using BICS connection and deployed them through BI Launch Pad.
• Providing Technical direction to a government internal staff within the Confidential IT Group.
• Implemented security for users, groups and categories using CMC in BO 4.1.
• Experience in developing Business Objects reports using Universe and BICS.
• Worked on PoC using Sap HANA, SAP System Landscape transformation (SLT), designed and developed Attribute, Analytic and Calculation Views and Hands on Experience in HANA Studio 1.0.

Confidential, Montvale, NJ

SAP Hana Solutions Architect

Environment: SAP BI 7.4, Business Objects 4.1 (SP5)

Responsibilities:

• Established the best modeling and recommended strategies for BOBJ environment and architecture forSAP HANA.
• Developed the security model, Naming conventions, and folder structure for HANA 1.0 and BOBJ 4.1 and established the recommended SAP best practices for developing Universes, reports from HANA data sources.
• Performed datamodeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio
• Worked on identifying the gaps with Hana/BO Integration and transforming Unx & BICS to Business Objects Web Intelligence, Analysis Office and Design Studio.
• Exposure to Data Provisioning, System Landscape transformation (SLT) from CRM and ECC.
• Expertise and Knowledge of BwoH Objects like Advance data store Object (ADSO), Open ODP Views and Composite Provider.
• Installed BO 4.1 SP 5 and created Run Book for Member firms.
• Consuming SAP Hana views on IDT to deliver Hana business layer using web intelligence 4.1.
• Created BEx queries (BICS) on composite Provider and exposed to Webi and Analysis Office Reporting.
• Responsible for analyzing requirements and proactively identifying opportunities to utilize SAP Native HANA and BWoH to meetbusinessrequirements
• Established Authentication using Kerberos and network credentials
• Developed & Supported Bo Reporting for AMR region (US/CA).
• Used CTS+ as the transport method for promoting the objects from development environment to the subsequent environments. (I.e. HANA Objects (HANA lifecycle manager (HLM) & BO LCM (Promotion Management).
• Implementing security for users, groups and categories using CMC in BO 4.1 SP 5.
• Technical design documentation experience, Unit testing documentation, Test script creation experience
• Design, implement and deploy SAP Hana solutions to achieve Confidential business goals.
• Optimized the Web I reports by using Query Stripping and adjusting the Queries based on the Sap best practices.
• Designed and Developed Dashboard for CNO Team using Design Studio.
• Resolution of performance issues with respects to query performance and worked on End to End tracing by using HTTP watch Trace to identify the any performance issues.

Confidential

SAP BI/IP & Business Objects Consultant

Responsibilities:

• As a BW IP Consultant involved in design, configuration and implementation of SAP Commercial Project Management application and assist in gathering, documenting and clarifying business requirements along with Business Process Lead (BPL).
• As a Ramp-up Customer Lead cross functional business and technical teams with Sap CPM Development Team to deliver the solution.
• Developed Integrated Planning (IP) objects like Aggregation Levels, Characteristic Relationship Filters, Data Slices, Planning Functions, Planning Sequence and Input Ready queries for planning
• Developed Global Template for Monthly/ Weekly & Forecasting Workbooks for the Engagement Partners and Manager using Analysis Office for Excel (1.4 SP 9).
• Developed BEx Queries for Master Budget Cost View and Revenue View for Dashboard like Monthly and Actuals Vs Plan Comparison.
• Worked on Multiple projects leading and developing for the IBS in various applications that cover Engagement budgeting & Planning (EB&F) using a multitude of tools in CPM (IP, BW & BO).
• Worked on Integration between IBS & CPM serves as a link to related documents such as CRM opportunities.
• Developed & Supported Global BI Reporting for EMA, ASPAC and AMR regions.
• Enhanced Standard Planning function like Valuate & Calculate as per the business requirements.
• Workspace Configuration which included - Commercial View, Procurement View, Team Overview, Financial Plan, Issues and Changes, Documents.

Confidential, Voorhees, NJ

SAP BW (BWoH) & Business Objects Consultant

Environment: BI 7.3, Business Objects 4.0

Responsibilities:

• Responsible for data modeling, extraction and reporting in Enterprise Asset Management (EAM) & CIS modules.
• Work with business and functional teams to define and convert business requirements, processes and designs into comprehensive, robust, efficient, scalable and stable BI Solutions
• Working on Requirements gathering, Analysis, and Design and Develop BW data models with reference to functional and technical specifications. Understand Business process, Landscape & Architecture for BW configuration for the Enterprise Asset Management and Customer Information System.
• Worked on Standard extractors like Sales Statistics, Meter Reading, Business Partner and Plant Maintenance Order Process from R/3 (ECC 6.0) and pull data from multiple sources like Click, Power plant and Kronos and merge the data for Reporting in BOBJ Tool.
• Constructed BW Objects InfoObjects, InfoCubes, Transformation, Custom DataSources, InfoSources and Process Chains.
• Created reports for call center to support then to meet Service Level Agreement (SLA) times
• Generic Extractor based on EMMA (Enhanced Message Management Analysis) for BPEM
• Developed Webi 4.0 Critical Reports like Billed Revenue, Unbilled Revenue, KPI Time Utilization, Executive Summary Reports and Meter reading Performance.
• Developed Dashboard for CIS and EAM Management according to specifications and requirements using BoBJ4.0 Dashboards.
• Constructed Test scripts in HP Quality Center for Unit, System and Integration Testing
• Improved data load and query performance by doing Compression, Aggregates, Rollups, SPO, and Partitioning.
• Converted Non SAP reports into SAP BW/BOBJ by decommissioning old data warehouse.
• Worked on the hyper care defects post go live.

Confidential

SAP BI/IP & Business Objects Consultant.

Environment: SAP R/3 ECC 6.0, BI 7.0, EP 7.0, Business Objects 3.x

Responsibilities:

• Responsibilities includes requirements gathering, designing and implementing the Reporting structure using BW and BoBJ for the Product Costing, Inventory Management and ICP (Intercompany Profitability).
• Capability to quickly understand the client business and end user expectations with respective to the implementation of global reporting solution.
• Worked on standard Extractors like Product costing all Calculations and Analysis Itemization to calculate Cost (Standard Cost, Consolidated Cost, Supply Chain Cost, and Further Cost).
• Build and enhance BI objects such as Info Objects, Info Cubes, DSO, Aggregates, and Process Chains.
• Developed Integrated Planning (IP) objects like Aggregation Levels, Filters, Planning Functions, and Planning Sequence and Input Ready queries for Budgeting and Projection MRP Planning.
• Designed & developed planning functions (FOX formulas) to calculate cost.
• Developed Webi Reports like Cost Compare, Cost Overlay Reconciliation, Cost Component Report
• Worked on the SAP BI Integration to Business Objects XI 3.1 as a Analytical & Reporting solution
• Creating Web Intelligence reports on Top of BEx queries and deployed them through BI Portal.
• Experienced in creation of Data Transfer Process (DTP) and Creating Rules for Transformations
• Design and build Universes over existing SAP BW queries.
• Helped client to convert the existing BEx queries to BOBJ 3.x.
• Worked on LCM (Life cycle management console) for promotion workflows.
• Involved in the designing and building of Universes, Classes and Objects for Production Costing System.
• Created BEx queries with Query variables restricted / calculated key figures, Customer exits and Webi 4.0 reports using BICS.
• Created Drill-down Reports to provide users with more detailed information using (Hyperlink).
• Development Test scripts in HP Quality Center for Unit, System and Integration Testing.

Confidential

SAP BI & IP & Business Objects Consultant

Environment: SAP R/3 ECC 6.0, BI 7.0, EP 7.0, Business Objects 3.x.

Responsibilities:

• Conducted the detailed requirements gathering workshops with the end users and subject matter experts
• Developed the SAP BW Data model to support both BI - Integrated Planning and Enterprise Reporting
• Worked extensively on LO Cockpit. Loaded the data from ECC to BW
• Enhanced Sales Document Item, Sales Document Header Data did the set up tables, initialized the extraction and used Queued delta in the update mode.
• Experienced in creation of Data Transfer Process (DTP) and Creating Rules for Transformations
• Build and enhance BI objects such as Info Objects, Info Cubes, DSO, Aggregates, Process Chains and User exit variables
• Developed Integrated Planning (IP) objects like Aggregation Levels, Characteristic Relationship Filters, Data Slices, Planning Functions, Planning Sequence and Input Ready queries for planning.
• Created Planning Functions (Fox Formula) and Planning Sequence for the Distribution of Material from Summary Level to Material Level.
• Extensively used the Web Application designer (WAD) to build the web based planning application for the planning users.
• Worked on the SAP BI Integration to Business Objects XI 3.1 as a Analytical & Reporting solution.
• Developed various variance reporting using WebI and Crystal Reporting using the Universes and BEx queries as source
• Created Drill-down Reports to provide users with more detailed information and query linking.
• Created Percentage Variance reports - Actual/Planned sales for Sales Region, created RRI reports for analysis from a Sales Region level to a Sales office level.
• Conduct Testing (Unit, Functional, Integration and User Acceptance).

Confidential

SAP BI & IP & Business Objects Consultant.

Environment: SAP R/3 ECC 6.0, BI 7.0, Business Objects 3.x.

Responsibilities:

• Extensively work on developing the required aggregation levels & filters for creating the planning models with Integrated Planning
• Defined the global functions and planning sequences for running the currency conversion and versioning of the forecasting data.
• Designed the versioning and scenario strategy for the forecasting data.
• Extensively worked on performance optimization of data loads/ processing times of Process Chains/ BI Query runtimes by enhancing the performance of InfoCubes by creating aggregates, creating InfoCubes partitions and managing optimal packet size.
• Constructed Aggregates, compressed Cubes, performed roll-up, secondary indexes for improving BW query performances.
• Creating Web Intelligence reports on Top of BEx queries.
• Extensive involvement in developing the Bex Web Reports.
• Creation of BEx Web Reports, RRI reports, development of Variables, conditions, exception reporting, BEx Browser reports, formatting aspects of reporting using Excel functionality and VBA.
• Created test cases and Performed Unit testing & Integration testing for upgraded objects.

Confidential

SAP BW & Reporting Consultant

Environment: SEM-BPS, BI 7.0.

Responsibilities:

• Data modeling - Did BW data modeling, PSA maintenance, ODS object design and administration, info cube design and administration, multiprovider design, info source design, and info object design and administration.
• Created queries and web reports for Salary Analysis using new BEx Query Designer and BEx Analyzer.
• Worked on modifying the existing Update Rules and changing the Update Rules for the Monetization Data extract program to Update new Key Figures and add/exclude company codes as per the Business requirements.

Confidential

SAP BI Consultant

Responsibilities:

• Improved Enterprise Reporting.
• Building BEx Queries.