PROFESSIONAL SUMMARY:

• 11 years of IT experience in Data Analytics which includes 9+ years of experience in SAP BI / BW with 3+ years of experience in SAP BW on HANA with 4+ years of experience in SAP BOBJ and 3+ years of experience in SAP BODS.
• Developer, Consultant, Architect through projects.
• Fresh Implementation, Agile Roll - outs, Technical & Functional Upgrades, Enhancement projects, Performance & Optimization projects and Support.
• Experience in multiple domains - Automobiles, Oil & Gas, Retail, Manufacturing, Utilities, Pharmaceuticals, Media & Distributions and Insurance.
• Experience in Information Technology industry with SAP BW/BODS (BW 7.5, BW 7.4, BW 7.3, BI 7.0, BW 3.5), SAP BPC 10.1, SAP HANA SP11, SAP BOBJ (4.1, 4.0, XI3.1), BODS, SAP ECC, SAP CRM.
• Well experienced in requirement gathering, technical analysis, Estimation, design, development which includes SAP BW/BI, BO, BW on HANA, BW with Business objects.
• Hands-on experience of entire ETL process, Analytics & Visualization. Including customization beginning at Data source extractor to Dataflow in BI and views in HANA to defining Universe model and variable or variant in Reports, Webi, AAO to setting up Roles & Authorization and providing data mart for exposing data to external sources along while optimizing the data loads and improving the reporting and overall performance.
• Experience in all stages of projects from Identifying the requirement, Business Blueprint, Analyzing Requirement, Defining project plan, identifying resources, setting Project timelines and delivery schedules in accordance with business availability, Documenting the Functional & Technical Specification and setting up the Test plan and Quality controls, Getting Approvals, Development and Implementation, UAT & Regression testing, setting up authorizations, business in features & process and finally planning and deploying the releases in time.
• Expert in Requirement gathering, Workshop preparations, Developed Project plans, Support plans, cut over plans, SAP BW/BI data model design and deployment.
• Extensive experience in Data Modeling, Extraction, Cleansing, Loading, Scheduling, Monitoring, Delta Management, Reporting, troubleshoot issues.
• Experience in extracting data from ERP and non ERP systems using standard and custom extractors.
• Experienced in LO Cockpit, FI, CO and COPA extraction.
• Implemented SAP BW 7.3 and SAP BW 7.4 on HANA environment, Worked on latest Data Modeling objects such as Hybrid Infoprovider, Composite Infoprovider, Semantic providers.
• Co-ordinate with technical BI development team to resolve the issues in BI report development.
• Conduct BI reporting (Bex, BO/WEBI & Crystal) features workshop with business users.
• Interacted with business analysts, end users, functional experts, process teams, SME’s, Finance controllers, senior managers, executives and COE to identify the requirements.
• Aggressive, self-starter, ability to quickly adapt to client’s requirements and always focused on customer satisfaction.
• Involved in BW on HANA Migration Projects and worked on post migration and pre migration activities.
• Creating Virtual providers, composite providers, Transient providers, semantically Partitioned Objects (SPO), Hybrid Providers, Advanced DSO, Open ODS View in HANA.
• Good exposure on SAP HANA Studio, Data Modeling using Attribute Views, Analytic Views and Calculation Views.
• Worked on SAP HANA Data provisioning using SAP SLT and SAP Data services 4.0
• Worked with Different transformations Query transform, Case Transform, Merge, Row generation, Map operation in SAP BODS to bring the data to HANA.

TECHNICAL SKILLS:

ERP: SAP ECC 6.0, SAP HANA 1.x, SAP BW 7.4, SAP BW 7.3/7.0, BW 3.5

ETL: SAP Business Objects Data Services (BODS)

Reporting Tools: SAP Design Studio, SAP Lumira, Analysis for office, Bex, tableau

Programming language: SAP ABAP, SQL Scripts

Operating systems: Windows 8/10

Exposure to: SAP CRM, SD, FI, MM Modules.

PROFESSIONAL EXPERIENCE:

Confidential

SAP BODS HANA Lead

Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
• Delivery & Accountability of projects with Onsite-Offshore based model, coordinating with multiple Business units in a collaborative environment with good understanding of business priorities, & handling multi-location teams.
• Created SOW, Project Proposals, Project Plan & Estimates, Project Strategy and Execution. Work with client stakeholders, management and business partners to get buy-in and propagate thought leadership.
• Involved in SAP HANA Data provisioning using SAP SLT and SAP Data services 4.0.
• Converting cubes to HANA Optimized cubes.
• Extracted data from ECC, CRM & BW systems and migrate to HANA using BODS.
• Creating Virtual providers, composite providers, Transient providers, semantically Partitioned Objects (SPO), Hybrid Providers.
• Created Advanced DSO and Open ODS Views.
• Created Calculated Views in Hana Modelling for reporting purpose.
• Extracted REX Parts Inventory, Promotions, Shipping, Parts Special Pricing, Inventory Snapshot, Parts Order to HANA.
• Extracted Contracts Campaign, Contract Refunds Data from CRM to HANA.
• Extract data NON SAP systems like Rex and migrate it to HANA using BODS.
• Created Jobs, Work Flows, Data Flows to load the data to target using BODS.
• Worked with Different transformations Query transform, Case Transform, Merge, Row generation, Map operation, Table Comparison in SAP BODS to bring the data to HANA.
• Expertise in HANA Optimized Info cubes, DSO and Publishing SAP HANA models into BW and From BW to HANA for BEX, BO Reporting.
• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Migrated HANA content from development, testing environment to Production environment using delivery units.

Environment: SAP BI 7.4 on HANA, SAP HANA 1.x, SAP BO 4.1, BODS 4.2, SAP ECC & SAP CRM

Confidential

SAP BI HANA Lead

Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
• Involved in SAP HANA Data provisioning using SAP SLT and SAP Data services 4.0.
• Creating Virtual providers, composite providers, Transient providers, semantically Partitioned Objects (SPO), Hybrid Providers.
• Extract data from ECC & legacy systems and migrate to SQL Server using BODS.
• Created Jobs, Work Flows, Data Flows to load the data to target using BODS.
• Worked with Different transformations Query transform, Case Transform, Merge, Row generation, Map operation in SAP BODS to bring the data to SQL Server.
• Created Advanced DSO and Open ODS Views.
• Publishing Infocubes to HANA studio and analyzing the fact and dimension tables for direct reporting purpose.
• Worked on SAP HANA Data Modeling using Attribute Views, Analytic Views and Calculation Views (both Graphical & SQL script based).
• SAP BW HANA: Developed & designed Attribute views, Analytic views, and Calculation views
• Perform the Daily monitoring of the process chains and fix the errors.
• Perform the Inventory balancing as a part of Month end Activities.
• Worked with SAP Business Objects Analysis for office for creating the reports.
• Performed the Month end Activities which includes Inventory loads, Finance loads, ZOFT loads, TTC Freight and TD fright loads.
• Developed Historical Inventory cubes for BBS projects.
• Developed the Bex Queries for Inventory Daily, All SIS reports.

Environment: SAP BI 7.4 on HANA, SAP BO 4.1, BODS 4.2, SAP Analysis for Office, SAP ECC & SAP CRM

Confidential

SAP BI BO HANA Lead

Responsibilities:

• Interacted with senior management and business leaders to elicit business and technical information in order to produce high quality decision making solutions.
• Involved in Requirements gathering, Development, Testing, and Reporting, Go-live and Post Go-live support.
• Translates user requirements into a modeling design in SAP BW and SAP Hana.
• Worked closely with SME’s, functional specialists and process owners to gather detailed business requirements and translated the requirements into robust reporting solutions.
• Developed BI approach and strategy document.
• Conduct BI reporting (Bex, BO/WEBI & Crystal) features workshop with business users.
• Developed reporting requirements framework.
• Extracted the Data from ECC, CRM into SAP HANA using SLT and BODS.
• Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.
• Migrated BW info cubes into SAP HANA information models.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Worked on Creating Privileges and transporting in SAP HANA.
• Created Technical specifications and standard modeling documents for HANA.
• Created Bex queries and customer exit variables to support the reports.
• Created Queries with BEX Web Application Designer for analysis and reporting and to display the Report in Web.

Environment: SAP BI 7.4 on HANA, HANA 1.0, SAP BO 4.1, BODS 4.0, SAP Analysis for Office, SAP ECC

Confidential

SAP BI BOBJ Lead Consultant

Responsibilities:

• Involved in Requirement gathering and created the Functional and technical specifications based on the requirement.
• Involved in SAP HANA Data provisioning using SAP SLT and SAP Data services 4.0.
• Extracted the Data from ECC into SAP HANA using SLT and BODS.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content
• Experience in creating Attribute views, analytical view and calculated views.
• Converted BW info cubes into SAP HANA information models.
• Worked with Different transformations Query transform, Case Transform, Merge, Row generation, Map operation in SAP BODS to bring the data to HANA.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Developed Multiproviders, Cubes, Aggregates, DSO objects, Custom Info Object Catalogues, Characteristics and Key figures info objects, Transformations, routines(start, end, expert) to extract data from flat file and R/3 systems Creating Info Packages, DTP’s, Process chains.
• Worked in security for Creating users, Assigning Roles and created Analytic Privileges for the views and assigned to the particular roles.
• Developed Crystal reports using SAP Crystal Reports for Enterprise 14.0.7.
• Developed Crystal reports, web intelligence reports for SAP FI-Accounts Receivable and General Ledger Functional Areas using BICS connection BI 4.0
• Developed Aging Reports, Detail Aging Reports using crystal reports with 0FI AR 4 AR Line item source.
• Developed Bad Debt allowance, Bad debt % as AR, Daily Sales Outstanding (DSO), Past Due DSO, Invoice Volume, Credit release performance, Write OFF reports using the WebI and Crystal reports with BICS.
• Developed DSO, Infocubes, and Multiproviders for General Ledger (GL) Balances using data sources 0FI GL 12, 0FI GL 14 in SAP BI 7.3
• Worked extensively with Sales Order, Billing, Delivery/Schedule line and Document condition objects. Enhanced the data sources 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 11 VASCL, 2LIS 11 VDITM and 2LIS 11 VAHDR.
• Worked extensively with Inventory Management using standard data source 2LIS 03 BF, 2LIS 03 UM and 2LIS 03 BX.
• Created Semantic partitioning objects (SPO) for info cubes.
• Developed SAP Mobile applications for IPad and Iphone integration with Business Objects 4.0.
• Created Bex queries and customer exit variables to support the reports.
• Worked on performance tuning like creating aggregates & indices, collapsing the data targets, implementing archiving procedures and logical partitioning.
• Developed the ABAP code in CMOD for master data and transaction data sources.

Confidential

SAP BI BOBJ Lead Consultant

Responsibilities:

• Worked as a SAP BI Techno Functional expert to design Reporting and Dashboard solutions.
• Developed Multiproviders, Infosets, Cubes, Aggregates DSO objects, Custom InfoObject Catalogues, Characteristics and Key figures info objects, info sources, Transformations, routines(start, end expert) to extract data from flat file and R/3 systems Creating Info Packages, DTP’s, Process chains.
• Involved in up gradation from SAP BI 7.0 to SAPBI 7.3.
• Involved in up gradation of BOE XI 3.1 to BO 4.0
• Developed SAP Mobile applications for IPad and Iphone integration with Business Objects 4.0.
• Developed Dashboard for Actual Vs Budget Expenses which includes What-if? Analysis.
• Extracted data from SD, MM, FI, modules of SAP R/3 into SAP BW system through LO Cockpit and Business Content Data sources.
• Migrated Existing BW 3.5 objects to 7.x objects which include Queries building and infoproviders.
• Extracted data using CO-PA (KEB0) (cost or account based) for analyzing the data on various criteria partitions like cost centers, companies, controlling area, regions to compare cost of sales or overhead costs, product costs, Profitability Analysis.
• Designed and activated process chain at various levels with varied processes which involves scheduling data in Info Packages, Reading data from PSA and updating corresponding data targets, Activating DSO data from data load, Deleting / Generating Indexes, Deleting requests.
• Enhanced the standard CO-PA (1 CO PA AC GP) for Government pricing Application.
• Used COPA Extraction and developed COPA cube using multiple characteristics and key figures for Profitability Analysis.
• Worked with Business content cube 0FIAR C03 (Financials) Extracted data from the R/3 source system using the Info Source 0FI AR 04 for reporting purpose.
• Managed and monitored data loads with full update and delta mechanism. Automated data loading using process chains.
• Created planning sequence in BPS for Cost center forecasting, forecast planning, Time management.
• Extracted data from SAP R/3 using LO and Generic extractors. Apart from that extracted data from flat files using flat file source system.
• Involved actively in supporting the various issues addressed by the Users from the client side and providing them with required solutions.
• Developed Global info cubes, Multi cubes, Transactional Info cubes, DSO objects and extracted Master data and Transaction Based Data in QM, MM, and FI Info areas.
• Created Queries with BEX Web Application Designer for analysis and reporting and to display the Report in Web.
• Designed, developed Bex queries, Universes and WebI Reports, Xcelsius Dashboards.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Troubleshooting and rectifying Universe, WebI & Live Office errors.

Confidential

SAP BI BOBJ Lead Consultant

Responsibilities:

• Conduct requirements gathering workshops and playback sessions.
• Author Strategy Document, Functional Design Document, Technical Design Document.
• Developed Multiproviders, Cubes, Aggregates DSO objects, Custom Info Object Catalogues, Characteristics and Key figures info objects, Transformations, routines(start, end, expert) to extract data from flat file and R/3 systems Creating Info Packages, DTP’s, Process chains.
• Collaborate with On-Site and Offshore teams of Technical experts and Analyst
• Worked with Bex Analyzer to generate Queries and embedding them into Workbooks.
• Monitoring the Process chains for daily and monthly loads for different applications.
• Monitor daily load, rectify the problems for data load and provide solutions for repetitive problem.
• Involved in Delta issues, process chain failures and table space issues.
• Provide solutions for Production Trouble Reports.
• Configured Bex Queries for Free Characteristics, Calculated and Restricted Key figures, Filters, Variables and Exceptions.
• Crystal/WebI report generation with Hierarchical based BW reports
• Crystal Report development with Hyperlink based On-Demand type report
• Extensive use of Process Chains (RSPC) to automate loading of all master and transaction data.
• Excellent working knowledge in debugging ABAP Code in Start routine, Update routine & User exits.
• Involved in Production support and resolved the errors during the transition period.

Confidential

SAP BI BOBJ Consultant

Responsibilities:

• Involved in complete life cycle implementation of SAP BW in SD, MM, PS and FI modules.
• Developed Multiproviders, Info sets, Cubes, Aggregates DSO objects, Custom Info Object Catalogues, Characteristics and Key figures info objects, info sources, Transformations, routines(start, end expert) to extract data from flat file and R/3 systems Creating Info Packages, DTP’s, Process chains.
• Data extraction from R/3 and Flat files, Creating Info Packages, DTP’s, and Process chains Scheduled loads.
• Enhanced Standard BI Content Master Data Extractors by RSA6 Transaction.
• Uploaded Master data From Flat file (source system) to Info Objects (Master data table).
• Uploaded sales order data from SAP R/3 to BI using generic Data sources.
• Created Financial Reports like Balance sheet, Income Statement, Income Statement Trend, Actual vs. Budget Report using WEBI.
• Implemented LO extraction (LBWE) for the Business Content data sources.
• Worked with Crystal reports for developing several reports.
• Worked with several users, and interacted with them to gather requirements and transformed them into a data model with the concept of extended star schema.
• Worked extensively on Business Content and installed the necessary objects.
• Tuning the queries to improve the performance of the report refresh time.
• Created customized Web Intelligence reports from various different sources of data.
• Created and Maintained source system interface configuration for BW and R/3.
• Design of Data Entry Screen for Plan, Target, Forecast and Budget values
• Created Process Chains, Info Groups, Info Packages and event triggers for job scheduling.
• Actively involved in improving the performance by regularly tuning the data model, creating aggregates & indices, collapsing the data targets, implementing archiving procedures and logical partitioning.
• Designed and developed queries in Bex and scheduled exception reports using reporting agent.

Confidential

SAP BI Consultant

Responsibilities:

• Involved in all phases of ASAP methodologies, project planning, Business Blue printing, Realization, Final Preparations, Go-Live and Support.
• Created Technical and Functional specifications and was Responsible for building customizing Info Cubes for SD Customer, Deliveries and Sales after the Gap analysis.
• Worked on Material Stocks / Movements 0IC C03 cube and extracted data from the data sources. Stock Initialization for inventory Management 2LIS 03 BX, Material Movements from Inventory Management, and 2LIS 03 BF Revaluations in Inventory Management 2LIS 03 UM.
• Developed Aged Inventory Report for calculating age of the Finished product with Drill down for Plant, Storage Location, Material and material Type
• Worked with Open Hub and info spokes in pulling the data from global Data store.
• Building and activating Info Sources for master data and transaction data for SD applications.
• Responsible for creating Info Set combining ODS and Info Objects for Sales Item level Information.
• Transporting the objects from Development Server to QA Server.
• Designed/Optimized the queries (top customers, monthly incoming orders and revenues, product analysis, returns) and analyzed the data using Bex analyzer/browser.
• Created query variables and enhanced the query functionality with the use of Customer-Exits.
• Designed SAP Web Application-based Dashboards.
• Customer Interaction, ticket resolution and Involved in preparing end user documentation.

Confidential

SAP BW Consultant

Responsibilities:

• Extracted data from SD modules and uploaded the data into the procurement cubes via 2LIS 11 VAHDR, 2LIS 11 VAITM, and 2LIS 11 VASCL.
• Developed ODS object to load SD Sales Order, Delivery note, Billing document Data from Business Content delivered Info sources, defined the update rules and worked on 0IC CO3, 0IC MC01 cubes.
• Responsible for the activation of SAP pre-delivered content and Info Cubes in the area of Vendor Evaluation
• Developed custom extractors on the R/3 OLTP systems and defined the extract structures on the source and target systems.
• Coded ABAP Routines for transfer rules, update rules, conversion routines in BW system.
• Improved data load and query performance by doing compression, aggregates, partitioning.
• Worked on system tools for tuning like RSRV, ST05.
• Created transfer structures, transfer rules, update rules including necessary routines wherever required for ODS and Info Cube level.
• Involved in creating reports for Plant Maintenance area, Sales and distribution area, Inventory Management and ware house management.
• Created Generic Data sources according to business requirements with views and info set query.
• Developed Aggregates for Query optimization. And monitor data loading into the Info Cubes.
• Automated Data Loads through Process Chains.
• Scheduled monthly loads according to the business needs.
• Resolved data issues and Query issues of the end users of the BW system.
• Developed ABAP reports, queries and interactive reports
• Created Queries with BEX Web Application Designer for analysis and reporting and to display the Report in Web.
• Created and Maintained source system interface configuration for BW and R/3. Responsible for maintaining Logical system, RFC Destination and the communication User ALEREMOTE.
• Create and Maintain BW Authorizations on hierarchies (RSSM).
• Customized and maintained interface with Flat file and successfully extracted data into the SAP BW system