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.
• Working Experience with big four ( Confidential, E&Y, IBM and Accenture)
• 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 Analytics Consultant

Environment: SAP BI 7.3, Business Objects 4.2

Responsibilities:

• Analyzed, designed, Implemented and support SAP Business warehouse Reporting solutions for multiple business units.
• Capability to quickly understand the client business and end user expectations with respective to the implementation of reporting solution.
• Expertise in Data Preparation from different data sources as per the requirement.
• Developed BEx queries (BICS) and exposed to Webi and Analysis Office Reporting.
• Worked on End to End BI Security Testing experience for BW/BO objects (BEx Query changes to incorporate new BW security changes, Executing BEx Queries, Testing MS Office Advance Analysis reports and BO Webi reports) to make sure that there are NO impacts to existing reports.
• Collaboratively worked with respective Functional, and technical teams to support application. Lead onsite Confidential Team and offshore (IBM team).
• Designs and develops BW and Design Studio objects including completing technical design specifications, BW design and testing of custom objects based on Functional Design Specifications.
• Expertise in connectingSapBW BEx queries and Universe (IDT) toLumiraand Build Adhoc Story boards on Fly.
• Responsible for the SAP BOBJ Design Studio Data Visualization development lifecycle from design through implementation and production support.
• Created Authorizations and User Groups for users.
• Worked on the hyper care defects for Production system.
• Provided training to the Business Objects End users on BOBI 4.2 new features and other new tools in BOBI 4.2 suite.

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.
• Worked on Sap HANA, SAP System Landscape transformation (SLT), designed and developed Attribute, Analytic and Calculation Views and Hands on Experience in HANA Studio 1.0.
• 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.
• Designed and build Dashboard for the Planning application using Design Studio 1.5.
• 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.
• Created BEx queries with Query variables restricted / calculated key figures, Customer exits and Webi 4.0 reports using BICS.
• Converted Non SAP reports into SAP BW/BOBJ by decommissioning old data warehouse.
• Experience in developing Business Objects reports using Universe and BICS.

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.
• 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:

• 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 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.