SUMMARY

• Over 18 years of Data Warehousing experience with the diversified roles in design, development and implementation of business applications for 12 years in SAP BW, 7 years in SAP BOBJ, 5 plus years in SAP HANA, 3 years in BO Data Services, Tableau and Oracle Database for various businesses.
• SAP certified consultant in BW and BOBJ plus HANA experience. Worked in SAP BI/BW versions 2.0B to 7.4, SAP BOBJ versions 3.1 to 4.1, and SAP HANA 1.0 and contributed in multiple SAP full life cycle and upgrade implementations.
• Proven experience playing different roles, including, but not limited to, Team Lead, Solution Architect, Integration Lead, Lead Consultant, Subject Matter Expert, etc.
• Robust Administration, Architect, Modeling and Development experience in BW on HANA, Native HANA, S/4 HANA and Suite on HANA and for both on - premise and cloud landscapes. Full insight in SAP HANA advanced features such as Dynamic Tiering, SDI / SDQ, SDS, and SLT.
• Built complex HANA dimensional models around Analytical/Attribute/Calculation Views and merge into BW data models using Composite Providers or using Workspaces to integrate SAP, non-SAP/Legacy/Business oriented heterogeneous data into one stop reporting layer. Experienced in building Script based Calculation Views using CE Functions, Procedures, and SQLScript.
• Strong experience in Integration of various Business modules of SAP CRM, R/3 (FI, SD, MM), SCM-APO with BI/BW. Includes modules CRM-IPM, Finance - FI-AP/AR, FI-CO and FI-GL (Accounts Payable/Receivable, Controlling and General Ledger); Materials Management - MM (Purchasing, Inventory), Sales and Distribution - SD; and SCM-APO (Demand Planning, Supply Network Planning) using business content extractors with customization and generic extractors.
• Hands-on experience in Upgrade project from BI 7.0 to BW 7.3, and familiar with new data model offerings namely Semantic Partitioned Objects (SPOs), Transient Providers, Composite Providers and HANA capabilities namely HANA Optimized InfoCubes and DSOs, and Layered Scalable Architecture plus plus (LSA++).
• Proficient enough in Warehouse Management activities include modeling/monitoring of InfoObjects, InfoCubes, Data Store Objects (DSOs), InfoSets, MultiProviders, InfoPackages, Transfer/Update Rules, Transformations and Data Transfer Process (DTPs), Aggregates, Process Chains, DataSources, InfoSpokes, etc
• Full insight on design and development of Reporting objects include Queries, Views, Planning Applications, Web Templates, Workbooks using Business Explorer Suite (BEx, WAD) and publishing in MS Office, Web or Portal using iViews etc.
• Developed vast number of reports to address formatting, printing and analytical needs with BEx Analyzer, Crystal Reports and Web Intelligence. Well versed with new SAP BOBJ reporting toolset: Analysis for Office/OLAP, Dashboards (Xcelsius), Design Studio, Explorer, and Lumira (Visual Intelligence) via IDT (Universe), BICS, QAAWS in BO 4.0/4.1 platforms.
• Extended knowledge on Business Objects capabilities and integrate with BI Reporting using the MDX statements, BICS connection features and Analysis Process Designer facilities.
• Enriched experience in BIA/BWA (BI/BW Accelerator) to ensure better performance for reports and planning applications. And, tuning performance using OLAP Cache, Aggregates, BIA Indexes and compression. Also, familiar with BW partitioning fundamentals and archiving strategies, NLS, etc.
• In the role as Center of Expertise in BI with SAP, engaged in delivering the SAP MaxAttention and Safeguarding services to various SAP clients.
• Engaged in CoE engagements with SAP handling several De-escalation Activities at client location or via War Room Reporting and perform Route Cause Analysis on business impact during escalations.

TECHNICAL SKILLS

Database Related: AllFusion ERWin Data Modeler, Embarcadero ER Studio, Oracle 8/8i/9i Databases, Oracle9i Application Server, Oracle9i Advanced Replication, Oracle Developer, Oracle Warehouse Builder, SAP HANA, HANA Dynamic Tiering, HANA SDI/SDQ, HANA SLT, and SAP Power Designer

Development Tools: Microsoft Office, Excel Visual Basic for Applications (VBA), Project, Visio, and Visual Studio; SAP Analytics Cloud, SAP BOBJ Analysis for Office/OLAP, Crystal Reports, Dashboards (Xcelsius), Design Studio, Explorer, Information Design Tool, Lumira (Visual Intelligence), and Web Intelligence; SAP Business Explorer Suite (BEx/WAD), SAP Fiori, Tableau, OData, and SAP UI5.

ERP Related: SAP Basis 4.x, SAP BODS 4.2, SAP BW 2.x/3.x/7.3/7.4, SAP ECC 5.0/6.0, SAP NetWeaver 7.0 (BI 7.0 and EP 7.0), SAP CRM 7.0, and SAP SCM 5.0

Languages: ABAP, C, C++, HTML, Java, Java Script, Perl, PL/SQL, Python, Shell Script, SQL, and XML

Testing Tools: HP Quality Center, Load Runner, and Load Testing Web

PROFESSIONAL EXPERIENCE

Confidential

SAP HANA Reporting Architect/Modeler/Developer

Responsibilities:

• Lead the complete end-to-end Professional Services Automation project in shifting existing SURF based modeling and dashboards to OpenAir application, a new product for complete business transformation.
• Worked in dual development approach in redesigning various master data and transaction data Models and merged historical and current data sets using Unions with Constant Values methodology in HANA.
• Redesigned HANA models to fulfill the functional needs related to Utilization, Billings, Backlog in PS.
• Implemented a complex solution for PS Employee Utilization dashboard for life to date calculations by Week, Month, Quarter and Year, particularly including department transfers and the caveat is this is not live dashboard, and HANA models are designed specially to handle quarter close timesheets intact.
• Converted several SQLScript models and Custom SQL code into Table Functions and Graphical Models.
• Involved in performance tuning and improvements of various HANA models using Explain Plan and Plan Visualizer to optimize the joins and unions used real-time and snapshot data set
• Worked with admin team in setting up the HANA Lifecycle Management (HALM) to enable change management approach in place of tedious Import & Export procedures followed for release cycles.
• This go-live happened to be one of the cleanest deployments and well received by BI release manager.
• Engaged with Finance team in setting up SAP Landscape and Transformation (SLT) for ECC tables to HANA including the customizations for business needs.
• Used HANA Live models as base reference and delivered various analytical models for ad-hoc analysis around FI-GL and COPA tables to support both business and reporting requirements in FI and Revenue.

Environment: Confidential SURF, Oracle NetSuite OpenAir, SAP ECC, SAP Data Services 4.2, SAP HANA 1.0, SQL, PL/SQL, SQLScript and Tableau 10.

Confidential

SAP HANA Reporting Architect/Modeler/Developer

Responsibilities:

• Responsible in architecture, modeling, development and reporting around Enterprise’s Annual Recurring Revenue (ARR), Renewals Book Of Business (RBOB), Left To Go (LTG) models designed around Sales and Opportunities data in Salesforce and Finance, Revenue and Subscriptions data in SAP ECC systems.
• Engaged as core BI representative for SalesOps requirements gathering and responsible in scheduling the supporting sprints for SFDC changes and intermittent SAND project needs.
• Engaged as a data architect in reviewing the coding standards, converting design documents into ER diagrams, ensuring team following the best practices in modeling, and performance guidelines.
• Designed and Developed Calculation Views in both Graphical and SQLScript to deal complex scenarios.
• Developed Slowly Changing Dimensions (SCDs) for master data attributes related to Sales Document Header and Line Item, Opportunity, Bill Plan, Deal Registration, Subscriptions, etc.
• Built Weekly, Monthly, Quarterly, and Yearly snapshots around ARR, which are reported to the street. Snapshots are captured at regular intervals, with the help of complex SQL procedures and ETL DS jobs.
• Enabled end users to do manual adjustments for snapshot data via Data Manager tool, as a web interface.
• Worked with Business System Analysts in design discussions, requirements gathering and building dashboards in Tableau and MS PowerBI.
• Engaged in HANA upgrade to SPS12 and worked on regression analysis, performance evaluations, security roles impact analysis, and migration preparations for HANA 2.0.

Environment: Salesforce, SAP ECC, SAP Data Services 4.2, SAP HANA 1.0, SQL, PL/SQL, SQLScript, Tableau 10, and MS Power BI.

Confidential

SAP HANA Reporting Architect/Modeler/Developer

Responsibilities:

• Responsible in architecture, modeling, development and reporting around SFDC, RemoteFE and ECC/CRM data fetched to HANA, and fine tuning existing HANA models to meet SAP methodologies.
• Built complex Information Models (both Graphical and SQLScript) in HANA to meet functional requirements around Procedures, Quota, Opportunities, RunRate, IDN Hierarchy, Training Utilization and SFDC Security with SQL Analytic Privileges, stored procedures including nested SQL queries, etc.
• Handled complex reporting requirements for Training Utilization and Opportunity Forecast metrics using materialized aggregates, star joins, dynamic/hash joins, unions, sets, variables and input parameters.
• Involved setting up persistence layer in HANA for SFDC models specific to reporting. Also, resolved the anticipated need to schedule the stored procedures with required dependencies for production use.
• Engaged in converting enterprise wide attribute/analytic views into calculation views as part of upgrade. Also, transitioned SQL Script based views into Graphical views upon architectural change reviews.
• Worked with Finance end users in building various HANA models specific to FI-GL and FI-CO space. Combined ECC Revenue data with Salesforce data for COPA Revenue model in Native HANA.
• Worked on enabling HANA Live Virtual Data Models and repurposed ECC based Query/Reuse/Private Views to build various supporting Information Models meeting end user requirements.
• Trained end users on Reuse Views around Sales Order and Billing Documents in Sales and Distribution. Also, customized standard models to support Month to Date, Quarter to Date and Year to Date scenarios.
• Configured SLT for both ECC to HANA and HANA to HANA environments with customized setup for Date and Time fields and built an Ideation Environment for super users, which is similar to Production.
• Worked on Data Services in building Jobs, Work Flows and Data Flows to bring Salesforce data into HANA. Setup Change Data Capture (CDC) mechanism between Source and Target for effective ETL.
• Implemented HANA Application Lifecycle Management (HALM) to handle transports management for individual HANA projects, setup Delivery Units and Transport Routes for DEV/QA/PRD environments.
• Evaluated existing setup and delivered comprehensive HANA Security model for overall Enterprise using SQL Analytic Privileges. Redesigned the Roles for End Users, Power Users and Developers, etc.
• Performed code reviews for projects and ensured standards and performance measures are taken care of.
• Engaged in Performance improvements for both HANA models and Reports built in Web Intelligence and Tableau. Extensively used Plan Visualizer and Explain Plan features to tune queries performance.
• Involved in building various dashboards for Training and Procedures, in Business Objects Web Intelligence, Analysis Office and Tableau supporting the reporting needs based on Sales Hierarchy.
• Built XS Applications for AWS team using OData Service for existing Salesforce information models. Also, integrated paging controls to boost performance of the record sets transferred to OData queries.
• Worked on Power Designer to reengineer the schema design and fields validation between HANA and source Database objects for Salesforce, SQL Server, and Oracle databases.
• Worked with end users in requirements gathering and ensuring the enablement of both analytical models and supporting dashboards for periodic results analysis and reporting, i.e. monthly, quarterly, etc.
• Occasionally supported DevOps requests, memory analysis issues, basis co-ordination activities, etc.
• Utilized HANA Workload and Replay feature for performance evaluation during HANA upgrade cycles.
• Enabled Smart Data Interface (SDI) setup for HANA for fetching business specific data from MS SQL Server and Excel based using standard adapters and facilitated real-time reporting for the end users.
• Showcased how Data Lifecycle Manager can be used to maintain Hot/Warm/Cold Data profiles for Dynamic Tiering to manage the Extended Storage and enable memory optimization for SAP HANA.

Environment: SAP BOBJ 4.1, Information Design Tool, Lumira and Web Intelligence, Python, Power Designer, Salesforce, Data Services 4.2, SAP HANA 1.0, OData, SQL, PL/SQL, SQLScript and Tableau 9.2.

Confidential

SAP HANA Reporting Architect/Modeler/Developer

Responsibilities:

• Responsible for both Architectural and Modeling activities for HealthCare Analytics team in the Epic-Clarity Reporting redesign in HANA, for the HANA box being used for Native HANA modeling only.
• Supervised architecture and data modeling around Hospital Billing modules namely, Revenue, Charge Reconciliation, Coding and Abstracting, Denials and Work Q Management.
• Built Demo Content from existing Hospital Billing models and reports and presented to other Hospitals.
• Involved in end to end architecture with other modeling teams and put forward design reviews, modeling standards, naming conventions, etc. Helped various reporting teams in HANA modeling concepts, universe design, reporting structures, data validations and naming standards.
• Redesigned and built HANA Information Models for existing Epic-Clarity cubes/tables in Oracle Database, Cogito DW models into HANA based Attribute, Analytic and Calculation Views. Also, had hands-on in complex models using SQLScript and CE Functions.
• Responsible for reviewing Data Flows (ERDs) and HANA Models and offering performance and tuning recommendations around modeling aspects. Also, reviewing Security design and analytical privileges.
• Assisted administration team in defining the schemas, delivery units reviewing the database sizing and partition requirements along with security setup for HANA and BO reporting needs.
• Created Universes/InfoSpaces in BO Platform using IDT and enabled HANA Information Models for further development of Reports, Dashboards and Story Boards in Design Studio, Lumira and WebI.
• Converted over 40 Epic Database centric Crystal Reports into BO Reports in Design Studio and WebI.
• Also, trained various users on how to use HANA Information Models in self-service reporting by building BO Explorer Views or InfoSpaces or direct access in Lumira via BO Platform.
• Worked with Compliance team in finalizing the documentation around Hospital Billing models and security setup for end users based on Facilities, Locations, and Cost Centres.
• Built HANA based geospatial solution using both Nokia HERE maps and ESRI ArcGIS maps to support compliance report that helps to see distance and maps between patient and provider/physician addresses.
• Hands-on in setting up Data Services Jobs and scheduling in batches for both full loads and incremental loads from Clarity Database. Also, documented best practices in managing jobs in central repository.
• Worked in SAP Data Services (BODS) for setting up Batch Jobs, building Work Flows, Data Flows, and Transformations, maintaining Data Sources and Functions for the daily extracts from Oracle to HANA.
• Also, set up Virtual Tables in HANA with the Smart Data Access provisioning option to enable direct access to Source Tables in Oracle on need basis to support various data modeling scenarios.

Environment: SAP BOBJ 4.0/4.1, Design Studio, Information Design Tool, Lumira and Web Intelligence, SAP BO Data Services 4.2, Oracle 11i, SAP HANA 1.0, SQL, SQLScript and PL/SQL