SUMMARY

• Having 10 years of experience in SAP Business Warehousing (BW/BI), Business Objects (BO) and HANA with Implementation, Development and Support projects. Well versed with SAP Technologies and its Functional modules and geared to adopt new concepts, techniques, and SAP Certified Consultant in Business Objects
• Experience in all phases of the project Life cycle from Blue print, Gap analysis to customizations, Go - Live, Post Live Production support, User training documentations., i.e. one-full life-cycle of implementation using ASAP methodology.
• Strong data modeling Skills with Entity Relationship (ER), Multi-Dimensional / Star Schema and Extended Star Schema model. Experience in automating loads using process chains and use of BW monitor to supervise data loading.
• Expertise in data staging extracting data from Flat Files and ECC( SD FI, MM.PP and CRM) using standard extractors, Business Content extractors, Generic extractors
• Well-versed and Experienced in Data Modeling, Designing, Creating and maintaining custom Info Objects, DSO. Cubes, DTP, Multi Providers, Transformations, Data source, Info package, Open Hub Service and Loading (Full/Delta), Scheduling, Monitoring, Process Chains.
• Experience in writing ABAP code for Start Routine, End Routines and Expert Routines.
• Extensively involved in Analyzing and Debugging ABAP Code
• Have good experience in using BEx analyzer. Navigating in reports, Restricted Key Figures, Calculated Key figures, structures and variables, properties of Attributes and Characteristics, hierarchies, Exceptions & Conditions, Report to Report Interface (RRI) and WAD
• Experience in Enhancing the Data Source as per the user requirements
• Good exposure on Performance Tuning using the concepts of BW Accelerator, Aggregates, Compression, Indexing and RE-Partitioning.
• Excellent techno-functional skills and knowledge of FICO, SD, MM, HR and PP modules and general business process.
• Worked on BW-HANA with Optimized Cubes &DSO, Advanced DSO, Open ODS View and Composite Provider.
• Migrated the BW Info Cubes and DSOs to HANA optimized.
• Experience in writing Test Plans, Test Scripts (SIT), and Executing the Test Scripts in QC.
• Developed HANA Models like Attribute view, Analytical view and Calculation view, Worked on Analytical Privileges, Decision table.
• Worked on HANA View with Options like (Time based, Copy/derived, Joins, Input Parameters, Variables, Static Filters, Counters, Restricted columns, Calculated columns)
• Working with Different Nodes of Calculation View (Projection, Rank, Join, Union, Aggregation) and Different types of CV (Dim, Cube, Star join)
• Connected with SLT, Flat files, BODS and SAP BW- HANA Sources
• Sound Skills in developing SQL Scripts, PL/SQL Stored Procedures, Triggers, Functions and Packages.
• Expertise in BO 4.1 tool set: Crystal Reports, WEBI and Dash Boards
• Strong in WEBI report development, Advanced Analysis for office & OLAP design, and development of Universe.
• Strong hands on BO technical knowledge with Business Object suite - Universe Design Tool, Information Design Tool, WEBI and Xcelsius/dashboard design.
• Designed and Developed Web Intelligence Reports using BICS Client on BEx Queries
• Strong BO Modeling experience expert Knowledge in resolving loop related issues on the Universe, and ability to resolve the Performance Issues related to Business Object Reports
• Experience in creating, organizing, Publishing and Scheduling reports using Central Management Console Created User Prompts, Conditions, filters and charts for various reports to specify the reporting parameters.

TECHNICAL SKILLS

Data warehouse: SAP BW 3.5, 7.0 and SAP BW - HANA 7.4

Reporting Tools: SAP Bex, SAP BO4.1 WEBI Reporting, Crystal 2008 and XCelsius

SAP ERP Applications: ECC 6.0

Operation Systems: Windows 98/2003/2007/ XP

Languages: SQL, SQL Script and SAP ABAP

Databases: SQL and Oracle

PROFESSIONAL EXPERIENCE

Confidential, WARSAW, IN

SAP BW/HANA Consultant

Responsibilities:

• Understanding the functional specs and designing technical spec related to LatAM Project.
• Created the SAP BW/4HANA optimized objects like ADSO, Open ODS, and Composite provider.
• Data provisioning from SAP ECC and informatica system to HANA using SLT replication.
• Created technical specification for data mapping between data sources with ADSO, business rules for transformations.
• Experience designing and developing HANA models: Calculation view, Procedures, Table Functions
• Created Input parameters, Variables, Calculated columns, restricted columns (KPIs) according to the business requirement.
• Created Calculated Measures and Restricted Measures in Aggregation node to serve different business requirements.
• Worked on migrating the HANA objects from Development/Test environment to Production environment using Delivery Unit.
• Involved in Transportation support for moving Delivery Units (DU) from development/QA system to production system.
• Created transports and worked with cutover lead to provide sequence of objects transports.
• Created HANA optimized data providers Info cubes and DSO created in SAP BW.
• Worked on Extraction Methods to extract the data from SAP R/3&ETL to BW System
• Worked on of end-to-end design and construction of BW objects using Standard BW Content and customize if required. Depending on customer report requirement.
• Experience in Implementing the SQL scripts and Procedures.
• Design and developed SAP BO Web intelligence documents (WEBI) on HANA views.
• Worked on complex report development solutions which include WEBI
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters
• Worked on publishing the data source in tableau after the security is applied to the HANA models.
• Once the data source is published in tableau checked the data consistency for the models in HANA and Tableau.
• Experience in writing Test Plans, Test Scripts (SIT), and Executing the Test Scripts
• Experience in Supporting and Solving the issues which is raised by User after Go-Live
• Involved in Cut over activities across the system landscape.
• Good Team Player, Strong Interpersonal Communication skills combined with Self-Motivation, Initiative and Project Management Attribute

Environment: BO 4.2, ECC, HANA-BW7.5.

Confidential, St LOUIS, MO

SAP Bw/HANA Consultant

Responsibilities:

• Implementing the BW Projects using Agile methodologies.
• Worked on Advanced DSO, Open ODS View, Composite providers & Transient providers
• Worked with Hybrid Providers and Operational Data Provisioning.
• Extensively worked on Attribute Views (Standard, Time and Derived), Analytic and Calculation View
• Experience in Implementing the ABAP Routines and Enhancing existing ABAP Routines.
• Worked on Extraction Methods to extract the data from SAP R/3 to BW System
• Created Process Chains for periodic upload of master data, transactional data, and text data and scheduled and monitored the data loads with delta update and full update mechanisms
• Worked on SAP BO 4.2, designed, developed, and managed Universes in Information designing tool (IDT) which include creating data foundation, business layer based on ad-hoc requirement
• Worked on complex report development solutions which include WEBI Reports.
• Developed Web intelligence documents (WEBI) based on SAP and Non-SAP data source.
• Experience in Creating Webi Reports upon the BO Universes and able to write Sequel.
• Worked on end user training and postproduction activities to train production support team.

Environment: SAP BI 7.4 HANA, BO 4.2, SAP R/3, ECC 6.0, HR and SD.

Confidential, San ramon, CA.

SAP BW/BI Consultant

Responsibilities:

• Worked on BW - HANA related objects (Opt DSOs, Cubes, ADSO, Composite provider)
• Developed HANA Models like Attribute view, Analytical view, and Calculation view,
• Involved in Data Provisioning from SAP ECC, SAP BW and non-SAP sources via SLT,BODS
• Worked on Extraction Methods to extract the data from SAP R/3 to BW System
• Design and Develop BEx queries using Calculated Key Figures and Restricted Key Figures, Conditions and Variable
• Experience in creating user exist and Function Module to extract data into BW
• Worked on SAP BO, designed, developed and managed Universes in Information designing tool (IDT) which include creating data foundation, business layer based on ad-hoc requirement
• Worked on complex report development solutions which include WEBI and AO Reports
• Developed Web intelligence documents (WEBI) based on SAP and Non SAP data source.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters
• Experience in creating Connection and Publishing the report using CMC .

Environment: SAP BODS 4.2, BO 4.1, ECC 6.0, HANA-BW7.4.

Confidential, CA

SAP BW/BO Consultant

Responsibilities:

• Worked on of end-to-end design and construction of BW objects. And consume BW objects in BO Webi Reporting.
• Populated data to Master data Info Objects, DSOs, Info Cubes, Multi Provider with Master data and Transactional data from SAP R/3 via Data Staging area (PSA) by creating Info Packages.
• Involved in the design, development and extraction of the data from R/3 system in to BW system from FI,CRM and SD Modules
• Involved in Creating Restricted key figures, variables, Conditions and calculated key figures in queries as per user requirement
• Developed Web intelligence documents (WEBI) based on SAP and Non-SAP data source.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters
• Build Webi reports directly on BW Queries for Ad-hoc reports, detailed level reports, Interactive Analysis Reports and dashboards.
• Designed, developed and Managed Universe in Universe Design tool (UDT).
• Modified variable and existing design for Web reports as per user requirements.
• Experience in creating Connection and Publishing the report using CMC.

Environment: SAP BW 7.3, Business Objects BOBJ 4.1 (Web Intelligence) SAP ECC 6.0.

Confidential

Sr. SAP BW and bo Consultant

Responsibilities:

• Worked on Extraction Methods to extract the data from SAP R/3 to BW System
• Development with Business content as well as creating Info objects, Info providers DTP,DSOs, Hybrid Providers, info Packagers and Transformation etc.
• Created DTP, Info Packages for Real Time Data Acquisition to load data into info Providers
• Design and Develop BEx queries using Calculated Key Figures and Restricted Key Figures, Conditions and Variable
• Worked on SAP BO 4.0, designed, developed and managed Universes in Information designing tool (IDT) which include creating data foundation, business layer based on ad-hoc requirement
• Designed and Developed WebI Reports using the features like Master/Detail, Charts, variables, Functions and Formulas to analyze the data
• Experience in Creating the OLAP Connections by using CMC
• Developed Web intelligence documents (WEBI) based on BEx query using BICS Connectivity.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters
• Extensively used Calculations, Break points, Drill down, Functions and Formulas, Filters & Alerts for creating Complex reports.
• Experience in modifying the existing Crystal reports as per the user requirements.

Environment: SAP BI 7.3/7.0, BO 4.X, SAP R/3 4.7, ECC 6.0, Crystal 2008.

Confidential

Sr. SAP BW/BI Developer

Responsibilities:

• Extensively worked in Data modeling of Info objects, DSO’S, DTPs, Multiproviders, Info cubes, PSA and Transformations.
• Worked extensively in Data staging with Data Sources Enhancements for SD, MM, and CRM modules as per the user requirements.
• Performed all the steps of Logistics LO-Cockpit extraction like deleting and filling the setup tables and then the delta extractions by initialize the extractor
• Worked with Generic Extraction to extract the data from R/3 System
• Extensively worked on BW Report modifications as per the user requirements.
• Extensively worked on BW issues and resolved the issues with in time.
• Involved in Modification in the existing BW design as per the user requirements
• Worked with Reconciliation Tool to verify the data in SAP R/3 and SAP BW are same or not after the daily loads.
• Experience in Performance Tuning using Aggregates, Rollup, Multi Providers, Indexing, Partition, and Compression
• Experience in creating BO Universes upon SAP Cubes and Queries.
• Experience in Creating Webi Reports upon the BO Universes and able to write Sequel.

Environment: SAP BI 7.0, SAP BO, ECC 6.0,SAP R/3,SD, FICO,MM,CRM

Confidential

SAP BI consultant

Responsibilities:

• Involved in Full Life Cycle implementation of SAP BW; Project Planning, Business Blue Print, Realization, User Acceptance Training (UAT), Training, Go- Live and Post-Production Support
• Extensively worked in creating different types of Info objects, Data sources, Info Sources, Info packages, PSA, Info Cubes, ODS, Multi providers, Info sets and DTPs
• Extensively worked with Generic Extraction and Flat File Extraction to Extract R/3 data.
• Design and Developing BW Report using Restricted key figures, variables, Conditions and calculated key figures as per user requirement
• Involved in creating Authorization objects, Roles and assigning to the users
• Created and Maintained Process Chains for periodic upload of master data, transactional data, and text data and scheduled and monitored the data loads with delta update and full update mechanisms
• Involved in Managing Performance related issues by Compression and Maintaining Aggregates Re-Partitioning, Re-Modeling and Indexing of Info Cubes
• Extensively involved in broadcasting the BW reports.
• Worked on User Exits, Function module enhancements, start routine and end routine in transformations using ABAP as per project requirements
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains
• Worked extensively with Business Content Data Sources Enhancements as per user requirements
• Experience in Performance Tuning using Aggregates, Rollup, Multi Providers, Indexing, Partition, and Compression.

Environment: SAP BI 7.0,ECC 6.0, FI/CO, Logistics, SAP BEx Designer