SUMMARY

• Around 10+ years of ERP professional experience in analysis, design, development and implementation of business applications that includes SAPHANA/BW/BI/BOBJ/BPC and strong exposure towards other ERP Systems
• Experience working on Native HANA and Experience in replication scenarios on SAP landscape transformation (SLT) Sybase Replication Server with operational reporting and data mart scenario - SAP HANA Modeling and Optimization.
• Experience working with BW on HANA Modelling.
• Worked on SAP HANA Smart Data Access
• Experience on HANA and Business Objects Data Services.
• Worked on BW7.3 upgraded and Implemented new concepts of data modelling, extraction with respect to BW7.3
• Involved in Multiple Projects Which includes Full life cycle implementations in 3.X/7.0 versions, upgrade from 3.X to 7.0 version, Enhancements and Post Production Support in the areas of SAP FICO, HR, Logistics, Inventory, SAP CRM and SAP SRM Modules.
• Experience in working multiple projects and managing them.
• Experience in Presales activities of business intelligence solutions.
• Hands on experience in developing SAP Business Objects solutions over SAP BI/BW using WEBI, Xcelsius, Universe, IDT, Crystal Enterprise, Lumira explorer, analysis office and Design studio
• Experience with Onshore-Offshore business model with managing offshore delivery as a Team Lead.
• Strong planning and organizing with demonstrated ability to master new concepts quickly, in corporate the latest technology, and develop business solutions that increase efficiency, productivity and profitability
• Interaction between end users and assisting the same
• Understanding the business process and documentation
• Proficient in data modelling using BW extended star schema model
• Proficient in Evaluating Requirements and implementing BI solution for Clients
• Extensive Experience Implementation, Developments as well as Production Support projects
• Performed extensive Logistic extractions, Finance and generic extractions
• Worked on queries using Bex Analyzer and Bex browser.
• Extensively used MultiProviders, structures, variables, exceptions, conditions, restricted and calculated Key Figures in reporting
• Experience in Performance Tuning.
• Proficient in handling support projects. Analyzed and corrected production problems as they occur in the SAP BW system.
• Experience on implementing BW 7.3/BW 7.4, Worked on Graphical Data Modelling objects such as Hybrid Infoprovide, Composite Infoprovide, Semantic providers.

• Experience working on Design Studio 1.3/1.4,1.5
• Experience on Crystal Reports
• Experience on Universe
• Experience on Webi
• Experience on Xcelsius
• Experience on SAP Business Objects 4.0
• Experience on SAP Business Objects 4.0 Dashboard Builder, Web Intelligence, OLAP Analysis, Explorer
• Experience working On BODS as ETL to extract third party systems data into BW.
• Developed reports Business Objects Dashboards/Reports for Mobile devices. (MOBI)
• Worked on Lumira Dashboards
• Extensively worked on HANA Studio
• Extensively worked on Attribute View, Analytical Views, and Calculation Views.
• Experience in replication scenarios on SAP landscape transformation (SLT) Sybase Replication Server with operational reporting
• Working Knowledge on SAP HANA Smart Data Access.
• Experience with SQL, SQL Script and Store procedures in SAP HANA
• Worked on Currency Conversions in SAP HANA
• Worked on Start and End routines in Transformations
• Experience in enhancing the Datasources
• Experience in developing user exits for reporting.

PROFESSIONAL EXPERIENCE

Confidential

Sr. SAP BW HANA Consultant

Responsibilities:

• Implemented Intermediary Production Compensation for sales person BW On HANA environment.
• Extensively worked on agile methodology for analysis, design and implementation of BI Solutions.
• Extensively created Attribute Views, Analytical Views and Calculation views. Created different types of Calculation views like Dimension, Star join, Cube and using table functions
• Have created Calculated Columns, Restricted Columns and Input Parameters for dynamic selections and leveraged stored procedures
• Extensively used Advanced DSO, Open ODS View and Composite providers.
• Data Provisioning and replicating data from source system toHANA Database using SAP Landscape Transformation(SLT)
• Used HANA Smart Data Access to reconcile data load between system like billing revenue, name address, EDM systems, ACE, SDM, PMR (Trading Commission Revenue) and for operational reporting as well.
• Worked on calculating compensation for sales person based on various business rules like draws, production period, prorate payments based on employee master data, territories hit threshold using calculation views ( SQL Script ), Store Procedures etc.
• Extracted data from DataMart’s (Sql Server) into HANA using BODS for Sub advisory data for intermediary production compensation.
• Created Data Services mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows
• Extracted Workday data like headcount, employee master through flatfile extraction and replaced existing process from SAP ECC due to decommissioning of SAP HR.
• Implemented Production compensation for institutional business for Mutual Fund & Private Equity.
• Worked on Improvising production compensation for money managers
• Worked on Sales force analytics.
• Developed dashboards to show revenue based on territories, headcount analysis & sales analysis
• Developed dashboards revenue by product & revenue by region/territory Mutual Fund, Private Equity, Hedge Fund, MAG SMA.MAG UMA, and Subadvisory etc.
• Developed Adhoc master reports for enduser for compensation analysis.
• Worked on POC’s for dashboard analytics based on Qliksense & Tableau

Environment: SAP BW 7.4, BO 4.1,BODS (Design Studio 1.5)

Confidential

Sr. SAP HANA/BW/BOBJ Consultant

Responsibilities:

• Worked on green field HANA BW 7.4 Implementation
• Created and managed schemas and packages.
• Developed HANA attributes views, analytic views, and calculation views.
• Developed constant columns and analytics privileges, functions using SQL the function editor and calculated attributes.
• Created custom schema, non ECC tables and SQL queries in SAP HANA
• Integration of Non SAP & SAP Data in BW/HANA as new EDW
• Used SAP BODS as ETL to extract data from Non-Sap sources.
• Worked with Different Transformations like Table comparisons, Date generation, Key generation, Query, Merge, Map operations, Validations.
• Experience in replication scenarios on SAP landscape transformation (SLT) Sybase Replication Server with operational reporting.
• Defined product structure incl. delivery unit and package assignment View and analyze dependencies for DUs and transports.
• Developed Dashboards in design studio to show KPI’s trade book revenues, commissions, sales rep analysis, desk rep analysis, YTD, MTD, QTD, Fiscal year.
• Used extensively java script & CSS HTML for components in Design studio to meet user requirements
• Developed dashboards to drill down to detail level of data from summarized views
• Extensively worked on backend data model to fetch sap data and non-sap data into SAP HANA tables
• Worked on components such as drop down list, buttons, cross tabs, filters, panels, radio buttons etc.
• Developed dashboards to show dynamic visibility based on user selection.
• Worked extensively on creating Attribute views, Analytical views, Calculation views, SQL.
• Worked extensively on composite providers
• Worked on Lumira Dashboard requirements

Environment: SAP BW 7.3, BO 4.0 (Design Studio 1.3)

Confidential

Sr. SAP BW/HANA/BOBJ Consultant

Responsibilities:

• Developed Dashboards in design studio to show KPI’s on HR - Personnel Administration, FI- Account Receivables (Collections), Office Management dashboard, Attorney dashboard and Billing
• Worked on dashboards to show KPI’s like top 50 collections, productivity, average productivity, realization, missing time, open time
• Developed dashboard for client management dashboard showing number of matters by designation CY & PY, Top 5 collections by matter
• Worked on extractors 0HR PA 0, 0HR PA 1

Environment: SAP BW 7.3, BO 4.0

Confidential

Sr.SAP BW/HANA/BOBJ Architect

Responsibilities:

• Involved in requirements and development of APD’s for third party systems to generate consumption information for Electricity, Gas, and Water to third party systems like Opower, Facility Dude, Water smart, OMS etc.
• Responsible for all work orders for Confidential on Business Intelligence
• Worked on fine tuning the system with respect to best practices and setting up direction in terms of processes
• Resolved production data issues on sales statistics.
• Worked on FI-CA, Confidential - CCS, CRM reports
• Worked closely with user groups to expose the capabilities of SAP BW with respect to FI, CO, MM, HR capabilities.
• Set BI Strategy, Process and best practices for better (MIS) Reporting needs.
• Involved in proposals of cross functional requirements
• Worked on Analytical tools Lumira for Utilities Department
• Developed Dashboards using Design Studio for Customer Consumption, Billing, Service KPI’s.

Environment: SAP BW 7.3, BO 4.0

Confidential

Sr.SAP HANA/BW/BOBJ Architect

Responsibilities:

• Evaluated SAP HANA Architecture for implementation scenarios and involved in BI strategy for Confidential .
• Involved in requirements gathering, analysing, understanding business requirements of Confidential Business Intelligence requirements on Grants Management, Funds Management, Treasury Cash Management, Historical Financial data of legacy systems, Financial accounting.
• Worked closely on requirements with users and functional team.
• Responsible for BW requirements on Grants Management, Funds Management evaluated requirements.
• Suggested appropriate business object tools for adhoc reporting, formatted reports, dashboards using Webi, analysis office, crystal reports and dashboard designer.
• Worked on Functional Design Specifications and Technical specifications of GM.FM, SRM.
• Suggested translation tool for implementation of Business objects report headers in Spanish Language.
• Configured data model related to Cash Management, SRM, FI-GL
• Suggest appropriate best practices in configuring and implementing business intelligence solution.
• Developed Dashboards using Dashboard designer to show Financial KPI’s

Environment: SAP BW 7.3, BO 4.0

Confidential

SAP BW/BOBJ Lead

Responsibilities:

• Involved in gathering, analysing, business requirements and functional requirements of MOA Business Intelligence requirement.
• Responsible for BW Development on Grants Management, Funds Management, Account Payables, GL etc.
• Extensively worked on data modelling and data extractions.
• Developed reports in SRM- Purchasing -Shopping Cart, Bid System.
• Developed Balance Sheet Reports for FERC Requirements for Electric, gas and water business areas of MOA.
• Worked on WAD Reporting Extensively.
• Extensively worked on Business Objects Reporting Solutions Webi, Analysis office, Visual Intelligence, Xcelsius for MOA MIS reporting needs.

Environment: SAP BW 7.3, BPC, BOBJ 4.0

Confidential

SAP BW/BOBJ Architect

Responsibilities:

• Involved in gathering, analysing, business requirements and functional requirements of CAD third party application data into BW7.3 and BO 4.0
• Responsible for architecture design, Implementation of CAD (Resource Management System) into BW7.3 and Business Objects 4.0.
• Worked on integration of CAD System Data with SAP CCS data for reporting requirements C level users and Business users.
• Used BODS as ETL to extract data from CAD CAD (Resource Management System) into BW.
• Worked on CCS Confidential -Utility Data extractions on Sales Statistics, Plant Maintenance.
• Worked on cross function requirements of CAD data with CCS, PM, CRM.
• Worked on FI-CA - Open items and Cleared Items reporting requirements.
• Worked on FI-CA extractors 0FC OP 01, 0FC BP ITEMS, 0FC CI 01
• Worked on Extractors 0FI AA 11,0FI AA 20 and reports on Assets and Depreciation.
• Implemented BI Repots in Web intelligence, OLAP Analysis.
• Implemented Business Objects Explorer for users to explore data in enterprise which is not readily available and get insights of data available in enterprise.
• Developed proof of concepts for Design Studio Dashboard requirements

Environment: SAP BW 7.3, BPC, BOBJ,4.0

Confidential

SAP HANA/BW/BOBJ Consultant

Responsibilities:

• BW on HANA Migration project
• Performance tuning of HANA models, fine tuning stored procedures and SQL scripts.
• Configured a standalone SLT. Replication of FI tables to HANA.
• Involved in pre/post migration HANA/BW activities for BWoH migration.
• Exposing HANA models into SAP Visual Intelligence/Lumira.
• In-memory optimization of SAP BW objects.
• Hands on migrating BW on HANA using SAP DMO tools.
• Extensive HANA modelling for FI, PP, QM
• Designed & Implemented Data model to fetch data from multiple SAP & NON-SAP Sources to Business Planning and Consolidation System (BPC).
• Developed Dashboards using Business Objects 4.0 Dashboard builder for Financial Statements.
• Developed Adhoc Reports using Web Intelligence 4.0
• Worked on Custom Structures and Custom hierarchies Leveraging Bex Structures from BW backend.
• Developed
• Developed Xcelsius Dashboards displaying KPI’s from FI, PP. QM to end-users and senior management

Environment: SAP BW/BI

Confidential

SAP BW/BOBJ Architect.

Responsibilities:

• Implemented BI Solution for Confidential integrating North America data and Europe data into BW for CCA and COPA.
• Implemented Cost Centre Accounting (CCA) and Profitability Analysis (COPA) in BW for legacy data through flat file extractions from Application Servers for SDMO Project.
• Worked on Data model for sales and finance for Demand Planning (DP) SAP APO.
• Developed Dashboards for Purchasing/MM in Bex Workbooks

Environment: SAP BW 7.1, BOBJ, Xcelsius 2008

Confidential

SAP BW/BOBJ Lead

Responsibilities:

• Worked on Blueprint on ERP and Business Intelligence for Confidential .
• Involved In presales of Business Intelligence Solutions.
• Proposed solution and implemented it for Business Objects Architecture.
• Developed Proof of Concepts on Business Analytics and Business Intelligence for Confidential
• Worked on Functional Specification for Business Intelligence on all areas of ERP.
• Worked on MM, PM, FI data extractors and reporting requirements.
• Worked on FI - AR, AP, GL, AA Extractor.
• Developed Dashboards Prototypes for C Level and Business Users.
• Used BICS Connection for Xcelsius dashboards.

Environment: SAP BW 7.1, BOBJ 3.x, Xcelsius

Confidential

SAP BI/BW/BOBJ Lead.

Responsibilities:

• Developing Dashboards for senior management.
• Developing Dashboards for HMS, HPC departments.
• Extracting data using DB connect to BW and developed required data models for HMS and HPC dashboards.
• Developed Dashboards for HR Department with BW development.
• Used BICS Connection for Xcelsius dashboards.
• Configured BI Admin Cockpit and developed custom Queries to monitor performance of the BI Applications
• Developing BW backend for OFS department and corresponding dashboards.
• Developed custom WAD templates for BI Statistics.
• Involved in prototyping & solution proposals for Business objects
• Worked on Project Systems - Reporting Requirements of grants, budget, plan of different departments of University.
• Designed and implemented StarRez (Hostel Management System) Application in SAP Business intelligence which caters needs of hostel management for effective functioning and planning for student needs.

Environment: SAP BW 7.0/ BOBJ - ECC5.0

Confidential

SAP BI/BW/BOBJ Lead.

Responsibilities:

• Promis replacement Current functionality in PROMIS regarding Project Delivery Reporting to be transferred to SAP PLM- (Project Systems)
• Promis replacement is an extension of the current PLM- (Project Systems) and will in corporate other functions of the Upstream, Downstream and Projects &Technology organization that are collecting and reporting similar forward looking data from projects, assets, OUs (Operating Unit) and JVs (Joint Venture).
• Integration business processes Business Planning, Portfolio Management and Project Delivery Reporting
• Developed Crystal reports like Maintain Top grouping, Top70, All projects report, emerging top 70.
• Developed Ad-hoc reports on Webi for project delivery reporting
• Developed Project Dashboard, Portfolio Dashboard
• Created Adhoc reports using Web Intelligence related to PDR Project.

Environment: SAP BW 7.01 EHP/ BOBJ - ECC5.0, CRM 5.0

Confidential

SAP BI/BW/BOBJ Consultant (Team Lead)

Responsibilities:

• Played a vital role in the modeling of JCB DBMS sales and service reporting BI platform.
• Defining business requirements after discussion with JCB Business Core Team, preparation of functional designs, technical designs and test scripts.
• Development of reports for stock, machine sales, order closure time, ITR, availability report for parts, market share and win-loss analysis.
• Development of vendor receivables aging report for vendor warranty process for JCB DBMS.
• Used standard extraction from SAP ECC 6.0 using standard SAPI and CRM using the SAP CRM BWA. Custom generic extractors using tables, views, function modules to extract data.
• Extraction of sales and distribution data from SAP ECC using LO data sources and SBO systems.
• Developed interface for extracting SAP SBO 8.8 data using SAP Process Integration 7.1 ABAP proxy.
• Implemented SD, MM, Services, CRM Service, Complaint Management & Warranty Analytics, Finance FI-AR, FI-AP.
• Worked on CRM (Customer information Systems) Sales, Analytics, Services
• Implemented analytics across the organization and used tabs on company performance via flexible management dashboards and scorecards and implemented index awareness.
• Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe.
• Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC.
• Worked on Hierarchy Levels and Developed hierarchies to support drill down reports.
• Extensive experience in creating reports with Charts (bar chart, Pie chart…etc.), Cross-tabs and Sub reports

Environment: SAP BW/BOBJ, ECC 5.0, ABAP/4

Confidential

SAP BI/BW/BOBJ Consultant

Responsibilities:

• Played a vital role in the Modeling of Confidential ’s BI platform.
• Developed Custom Generic Extractors using tables, views, Function modules to extract data.
• Developed reports using Bex Analyzer and Workbooks using free characteristics, Restricted Key Figures, Calculated Key Figures, Variables, Replacement Variables and Exceptions.
• Developed start routines, end routines and field routines for data modeling.
• Developed Crystal Reports using multiple sub reports and drilldown features and using conditional suppression. Designed Complex reports with Charts, Cross tabs and OLAP Cubes.
• Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC.
• Created (Master/Detail, Cross tab, Chart templates) reports using Crystal Reports.
• Extensive experience in creating reports with Charts (bar chart, Pie chart…etc.), Cross-tabs and Sub reports
• Performed unit testing, system integration testing, and user acceptance testing of Crystal Reports at various levels.

Environment: SAP BW, SAP R/3 4.7, ABAP/4

SAP BW consultant.

Confidential

Responsibilities:

• Developed Capital Spending Report using Generic Extraction which is used to track the costs incurred on each Internal Project for the organization.
• Worked Extensively on LO extractions and Generic Extractions.
• Worked on CRM - Sales, Marketing reports
• Extensively worked on in performance tuning by using Indexes, DB statistics, compression of Info Cube and maintaining and rolling up the Aggregates.
• Performed Health Check-ups for the List of Aggregates available in the BI-Production System before QEC & YEC through Consistency Check Program.
• Worked Extensively on Reporting using Bex Analyzer such as free characteristics, Restricted Key Figures, Calculated Key Figures, Variables, Structures, Exceptions, Filters, Conditions, Report to Report Interface
• Worked on Enhancing the Customer Exits for newly added Query variables and newly added R/3 fields.
• Experience in BI Analysis Authorization.
• Proficient in using standard security administration tools such as Profile Generator for Authorization Profiles/Roles Administration and User Administration.

Environment: SAP BW, ABAP/4

SAP BW consultant.

Confidential

Responsibilities:

• Worked on Business Blueprint and Technical Specification for the area of SD Modules which included identifying the Standard Queries for SD, Modules. Delivered Live-Demo’s to BI Process Responsible heads using WebEx Client.
• Worked on FI-AR, FI-AP, FI-GL extractions and reports.
• Worked extensively on standard LO extractors, used LO extract structures and data sources
• Involved in creation of generic extractors using View/Tables, Function modules to extract data from R3 into BW systems
• Worked on HR extractors 0HR PA 0, 0HR PA 1.
• Created flexible reports using Calculated and Restricted Key Figures, Filters, Variables, Structures, Exceptions & Conditions, Conducted EUT for BI Process Responsible Users of Confidential Norway
• Created reports using Crystal reports related to sales and Finance.