SUMMARY:

• I am a SAP HANA / BW4HANA / BW / Lumira Certified Consultant, and delivery lead with expert knowledge in deploying business warehouse solutions for analytical reporting in the areas of SD, MM, CRM, FI, PM, ICM, HR and Retail.
• Background includes 13 years of varied exposure in high level design and implementation of SAP HANA / BW / S4 / HANA Live / BW4HANA solutions for clients, an experienced HANA data modeler in creating attribute, analytical and calculation views and implementing HANA RDS.
• Well versed in working in a fast - paced technical environment with other developers, product managers, consultants, and Business Users (Customers).
• Strong technical exposure in BW 7.3 / 7.4 / 7.5 data modelling techniques, latest support packs and new features, optimization for HANA database, architecting and deploying global EDW solutions by following SAP best practices including LSA and LSA++ architecture, utilizing the standard business content, and SAP recommended landscape and platform standards.
• SAP HANA Modelling & BW Modelling in HANA studio using BWMT on aDSO, OODS, Composite Providers.
• Multi-Temperature Data Management using cold data in SAP IQ & hands on with remote data source using (SDA) Smart data access.
• Connected LUMIRA story boards with SAP HANA Live Browser. Configured and Extended HANA Live Views in browser.
• Expertise in client interactions, Business requirements gathering and client workshops and discovery.
• Optimizing BW 7.5 Data Management based on Dynamic Tiering as well as Active/Non-Active Concept
• Optimizing BW Data Management based on Near Line-Storage
• Review of Layered Scalable Architecture (LSA), From LSA to LSA++: Streamline Core Layers
• LSA++: Open Operational Data Store Layer (Open ODS Views), LSA++: Agile Data Mart & BW Workspace Layer
• Generation of HANA-Views for BW Info Providers, Mixed Scenarios, SAP HANA Live, HANA-Optimized BI Content
• SLT Replication into SAP HANA, SLT Replication into SAP BW, Operational Data Provisioning into SAP BW
• DB-Connect and Open Hub Destination
• Info Object Enhancements, Authorization Enhancements, Process Chain Monitoring, HANA-Optimized BW Search
• SAP LUMIRA Solution expert with SAP / Non-SAP Source systems
• Hands on with LUMIRA TEAMS; Installation and Administration.
• SAP Reporting Tools BOBJ / Tableau, Jasper Analytics solutions
• SAP BW 7.4 Data warehousing best practices with Open ODS & ODP, Smart Data access
• SAP domain knowledge Toll Tax Logistics / SD / MM / Retail / CRM / FI / ICM
• Business Process Reengineering as per business reporting requirements
• Hands on with Open HANA and BW on HANA implementations and expertise with HANA Live and RDS
• ODP is installed as a BW source, Implemented ODP SAP NetWeaver-based framework, retained Delta for a definable time in the ODQ (delta queue).
• Implemented integrated modelling environment in HANA studio, data flowing from BW system & HANA information views to expose data from composite provider to reporting layer.
• Converted DSO and Cubes to aDSO as part of 7.4 to 7.5 upgrade.
• Implemented Data security at HANA by Assigning Privileges and Roles to Users with SQL Analytic Privileges
• Performed Webi Data security testing for different user groups.
• Managed BOBJ user Mapping with HANA data base user for implementing data security.
• Handling project planning, execution and management in tune with the core business objectives (including risk management, effort / time / cost estimation)
• Setting-up of master data and function locations, importing the relevant data, task lists and maintenance orders of system as per functional requirement
• Developing all relevant reports per user requirements including maintenance notifications, activity and malfunction reports
• Implemented POC on Crime Analytics, Genome Sequencing on HANA.
• Expert in understanding of the complete Architecture (Data loading, Data modeling & Reporting).
• Expert in creation of Analytical and Attribute Views and complex models by using SQL script in Calculation Views.
• Created Analytical Privileges and Procedures for modeling
• Strong Exposure in Data Replication Methods such as SLT, DXC. Data Provisioning using SAP BODS. Experience using Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake Modeling, Fact & Dimensions tables.
• Good understanding of various components of SAP HANA.
• Designed and Created Universe for reporting from Information models.
• Establishing project plans within pre-set budgets and deadlines, monitoring project progress as per scheduled deadlines for various tasks, taking necessary steps to ensure completion within time, cost and effort parameters
• Planning various activities involving resources management, project expenses, etc., while analysing user requirements in order to understand the problem domain and suggesting the alternatives available
• Performing configuration of various documents, reports and configuration of different accounts as well as reviewing various alternatives available and choosing the best solution available
• Providing an appropriate business solution to clients and guiding the setup and customization of release procedures for classification of various internal & external documents, etc.
• Coordinating with the development team for development / customisation of software, while ensuring integration with other modules, integration & user acceptance testing & extending post go-live support, including support to end-users
• Supporting and monitoring for preparing help manuals for all modules to reduce queries from implementation sites and conducting internal audits to ensure on-going improvements in the quality assurance systems.
• Proactive team player with excellent interactive and interpersonal skills to communicate with team members, developers, clients and end users at all levels.

TECHNICAL SKILLS:

Business Intelligence: SAP (HANA / BW / BODS / BO) ERP SAP R/3, HANA Live, BW4HANA

Reporting Tools: BEX Analyzer, Query Designer, WAD, Design Studio1.6, WEBI, SAP LUMIRA 1.3, office Analysis, Bo explorer, Tableau, Jasper soft

Predictive Modelling & Data Mining: Boosting, Association Rule Mining, Clustering, Neural Networks, Regression, Support Vector Machines, Time Series Analysis, Decision Trees, Bayesian Inference.

PROFESSIONAL EXPERIENCE:

Confidential, Cypress CA

Environment: HANASP12 / BW 7.4 / Webi / Office Power BI / Office analysis / Lumira 2.0

SAP HANA / BW Consultant

Responsibilities:

• Created DB connection to extract Siebel warranty views in BW 7.4 Data sources,
• Created aDSO for Claim header, Claim detail, claim job codes, claim problem codes, claim bill-to-code, claim-extra parts, claim messages
• Created Composite provider in Integration layer as per LSA++ guideline.
• Created BEx report for PWA SHIPPED PARTS Report.
• Created LUMIRA 2.0 Story board for PWA Status v/s Warranty Claims for each product line to determine maximum claims processed product.
• Created Webi report to display count of PWA status in bucket for shipped amount on a particular date.
• PWA status bucket report shows the number of entries in each PWA status like APPROVED, APPROVAL IN PROCESS, CLARIFICATION REQUIRED, CLARIFICATION PROVIDED, HOLD FOR PARTS, REJECTED, CANCELLED.

Confidential, Cypress CA

Environment: HANASP12 / BW 7.4 / Webi / Office Power BI / Office analysis / Lumira 2.0

SAP HANA / BW Consultant

Responsibilities:

• Stage data in BW with DB connect with Sibel source system.
• Created ADSO’s in BW as per LSA++ design approach.
• Created field level ADSO’s in BW Modeling tool.
• Consumed ADSO’s in HANA Calculation views, with several joins built Query views.
• Used HANA CTS+ transport method to move objects in HANA Application Life Cycle Manager from Dev to QA & Prod.
• Applied Analytical privileges at Sales Organization level to restrict data for each Sales Organization.
• Completed testing at HANA system with different users with data security.
• Completed testing Webi reports with data security for each user.
• Conducted UAT with customers, addressed issues raised in UAT
• Completed UAT sign-off
• Completed GO Live on time.
• Post Live support

Confidential, Cypress CA

Environment: HANASP12 / BW 7.4 / Webi / Office Power BI / Office analysis / Lumira 2.0

SAP HANA / BW Consultant

Responsibilities:

• Installed SAP Note related to BW migration cockpit for HANA as per migration documents
• Performed BW HANA migration readiness check, BW object check, Sizing Overview, Essential Housekeeping tasks,
• Executed Sizing Overview on Sand box, DEV, QA, PROD and determined HANA system size.
• Performed BW system health check report, addressed red flags from the report and implemented changes.
• Reduce the foot print of unnecessary data and prepared bug free data for migration.
• Deleted PSA, DTP logs, Aggregates, secondary Indexes, unused Bex to reduce data foot print up to 300 GB.
• Extended support to BASIS team on SUM DMO SP19 activity.
• Post DMO tested on BW check list on Sand Box, Dev, QA, Prod

Confidential

Environment: BW4HANA /Office Power BI / office analysis / Tableau / LUMIRA

SAP BW/HANA Consultant

Responsibilities:

• Worked on BWMT tool to Track sales results by collecting sales order details in ADSO’s and consolidated ADSO’s in aCreated ADSO on VBAK (Sales order header), VBAP( Sales Order Item), LIKP(Delivery Header), LIPS(Delivery Item),
• Created Sales Order Analysis story board on the “Calendar dimensions vs Sales order amount “and
• Sales Order trend Story board for current year comparisons with previous years and months.
• Created Sales Revenue story board to determine the Sales revenue by sales area / customer group / material group.
• Created Rejected Sales Orders story board to determine the Rejected amount by each sales area / rejection reasons.
• Created Story board for Accounts Receivable to highlight disputed amount by company codes and regions.

Confidential

Environment: HANASP11 / Webi / Office Power BI / office analysis / Tableau

SAP HANA Consultant

Responsibilities:

• Captured information models inventory, categorized information models and proposed a plan for re-modelling onCalculation views being implemented on multiple nodes and joins.
• Proposed remodeling practices considering HANA SP11 recommendations.
• Created new Calculation views reducing joins and redundant information views inside query modelling views.
• Implemented Harmonization across models with common attribute labels
• Followed HANA Live Modeling approach in categorization of PRIVTE, RE-USE, QUERY view concept.
• Conducted sessions with Tableau team on Prompts issues of Input parameters.
• Captured statistics of each model from PLAN VIZ.
• Implemented Data Pruning concept on SIQ and HANA models, optimized performance.

Confidential, Austin, TX

Environment: HANA Live SP11 / BW 7.5 / Lumira 1.30 / Webi / Office Power BI / office analysis

SAP HANA Solution Architect

Responsibilities:

• Participated in Business Blueprint and design sessions, review options and provided recommendations while communicating the benefits, risks, and constraints to both the business and IT stakeholders
• Implemented Hybrid approach with BW 7.5 and HANA live, hands on with BW modelling tools in HANA Studio
• Successfully imported HANA LIVE content (Tgz) file to Hana and activated virtual models in HANA studio
• Worked on Private, Reuse, Query views on HANA Live
• Extended HANA live views to meet customer requirements
• Activated Lumira/office analysis standard reports
• Customized universe and modified Webi/power Bi Dashboard as per business requirements
• Facilitate modeling sessions and design walk-through with the development team members
• Worked with business/technology teams to ensure alignment between business solution definition & technical architecture to meet project requirements on Procurement, Inventory Management and Finance, CRM, Plant & Maintenance, Sales & distribution, fixed gaps on every application to meet customer reporting requirements

Confidential, Austin TX

Environment: HANA / Oracle / BODS / Lumira / Webi /Jasper / office analysis

SAP Solution Architect

Responsibilities:

• Conducted workshop with client administrative team to scale existing Oracle system sizing and created landscape design considering DB size and yearly incremental data growth for next 5 years
• Created Users, Roles, Privileges, Packages, and Schemas as part of HANA security on HANA life cycle management in SP11 environment
• Designed and implemented SAP HANA data modelling technics using Attribute View, Analytic View, and Calculation Views
• Developed complex Calculation views, Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to maintain reconciliation between reject tolls from VDOT
• Involved in SAP HANA Security including User Management, Roles, and Privileges using Life cycle management of SP11.
• Involved in Information Design Tool Creation of Data Foundation, Universe for HANA- BI reporting
• Design end to end solution from information gathered to Post live support, which includes Blue print design and project delivery with resource plan considering the budget. Maintaining daily / weekly tracker and end client meetings on each phase sign off
• Work on DB sizing, hardware and software licenses, installation and configuration for Lumira Teams.
• Implemented solution to capture toll plaza life cycle revenue collection from Roadside portable server, Integrated and transformed data with BODS edge server and maintained separate Reporting DB to improve reporting performance, introduced LUMIRA TEAMS server for reports consumption
• Automatic vehicle identification with Tag and Non-Tag analytics to adjust Peak / off peak plan.
• Automatic vehicle classification commercial / private with revenues
• Video enforcement system records plate and Identifies the EZ pass insufficient fund/Violation accounts.
• Created operational reports on TTH (Toll Transaction Host) and reconciled with IPS (Image Processing system), BOS (Back Office system)
• Created reconciliation reports to address financial loss, incorrect / Dispute reads
• Refunds paid efficiently with Lumira report which pulls on last toll utilization date
• Built analytics on Lane utilization / Clerk efficiency
• Monthly fee statements, weekly traffic census, Revenue reports, traffic count report, discrepancy report, operator efficiency report, daily Ezee pass / plate reports, IP based reports
• AR / GL aging reports on toll revenues, created bucket reports for invoice aging
• Created users and authorizations on LUMIRA Teams with user groups
• Conducted work shop on End user on accessing Lumira stories on portal

Confidential, CA

Environment: SAP HANASP 9 / BW 7.4 / Lumira / Design Studio / Webi

SAP HANA BW Architect

Responsibilities:

• Implemented BPS add-on at BW 7.4, successfully imported RDS(Tgz) file to Hana and worked on BOBJ BIAR file to map connection to BW system
• Participated in Business Blueprint and design sessions, review options and provide recommendations while communicating the benefits, risks, and constraints to both the business and IT stakeholders
• Instrumental in standardizing the Implementation process in data modeling in sap HANA from ERP, Integration with CRM-ICM to generate settlements and remuneration Liability reports
• Customized universe and modified webi, Dashboard as per business requirements
• Facilitate modeling sessions and design walk-through with the development team members
• Work across business/technology teams to ensure alignment between business solution, definition & technical architecture to meet project requirements on Procurement, Inventory Management and Finance, CRM, Plant & Maintenance, Sales & distribution, fixed gaps on every application to meet customer reporting requirements.

Confidential, SFO, CA

Environment: SAPCAR/ SAP HANA / Lumira

Technical Architect

Responsibilities:

• Accountable for successful delivery of functional and technical components of Business Intelligence (BI) reporting solutions using SAP HANA
• Participated in blueprint and design sessions, review options and provided recommendations while communicating the benefits, risks, and constraints to both the business and IT stakeholders
• Instrumental in standardizing the Implementation process in data modeling in SAP HANA from ERP and POSDM systems using HANA-LIVE and SAP CAR RDS, extracted data into HANA using SLT and BODS work flows and re-design the universes that support Webi and Dashboard reports
• Facilitate modeling sessions and design walk-through with the development team members
• Worked with business/technology teams to ensure alignment between business solution definition & technical architecture to meet project requirements
• Benefitting with the knowledge of various aspects of HANA modeling including creating schemas and importing source system metadata, creating attributes, measures, hierarchies and developing Information Models with Attribute Views, Analytical Views and Calculation Views.
• Communicated with customers and partners to help understand, document and align the business and technicalobjectives of key programs
• Provided SAP HANA subject matter expertise with the understanding of the latest architectures, technologies,external forces and market trends, as well as competitive offerings to proactively build, sustain and manage adifferentiated solutions roadmap
• Involved in handling the design of BOBJ / LUMIRA reports on multi channel sales analytics, inventory visibility, Point of sales data management

Confidential

Environment: SAP HANA / Lumira

Solutions Architect

Responsibilities:

• Led development of conceptual and architectural solution blueprint for assigned projects to meet business requirements while ensuring compliance with established architectural principles, standards, and processes
• Provided deep SAP technical/architecture guidance to project teams in areas of BI and Analytics
• Involved in the identification of assets and services that were re-used by the project teams to drive consistency, cost reduction, and increased speed to market within assigned architecture and functional domains
• Participated on architectural governance team and processes to guide and sanction critical architectural decisions
• Advocated the communication of and adherence to defined application architecture strategy
• Proactively monitored strategic direction of SAP Vendors, technology and market trends, and determined their potential impact and value to the enterprise
• Researched and led the development of prototypes to assess and build new capabilities in the enterprise.

Confidential, SFO, CA

Environment: SAP HANA / Micro Strategy

Solutions Architect

Responsibilities:

• Led SAP BW/HANA related activities which includes technology innovation, enablement, demand fulfillment in related technologies, CoE members career progression & talent management
• Researched, developed and documented SAP BW/HANA solution alternatives, approaches and recommendations that address approved project scope and business requirements, align with IT’s Target State Architecture and Technology Roadmap, and leverage IT investments across the enterprise
• Brought technology leadership in HANA including BW on HANA
• Conducted Risk Assessments (risk identification, risk analysis, mitigation strategy) to assist the business in selecting the most appropriate solutions
• Presented to senior management and the Architecture Review Board to gain buy-in and acceptance of solution approaches, and to ensure that decisions are made with the interest of the enterprise vision in mind (e.g. align with strategic business and IT direction).
• Led and defined project designs like Infrastructure Designs, High Level Designs, and Detailed Designs, Test Definitions and Implementation Strategies, and involvement throughout project life cycle to ensure projects deliver according to the approved designs
• Involved in offering advice to onsite SAP HANA consultants and customers and resolve solution design issues throughout the project lifecycle

Confidential

Environment: SAP HANA / SAP BO

Solutions Architect

Responsibilities:

• Gathered Business requirements and proposed solutions in business intelligence
• Proposed Visual Intelligence solutions and Business executive’s dashboard and midlevel dashboards, analyst level data presentation
• Responsible for designing ETL (extraction, transform, load) of data, building queries on data, scheduling data loads on daily, monthly, weekly decision making reports
• Built SAP Business Intelligence competency for Persistent Systems
• Conducted interviews, identified suitable candidates in different levels of experience
• Consulted Business users on requirements, suggested business analytics solutions in SAP HANA, and defined the Business In-memory data base model where terabytes of data can be loaded in the memory and queries can be retrieved from in-memory rather disk, allowing reports to be run in milliseconds
• Conducted s on Business Intelligence, Business Objects Reporting tools, SAP HANA

Confidential

Environment: SAP HANA, SAP BI 7.3, and SAP BO & SAP BODS

SAP HANA & BI Consultant

Responsibilities:

• Streamlining reuse & enhancement of existing data sources for Service ticket related data and conceptualized Data Source for Knowledge Articles
• Enhancing T- and D-Layer DSOs for Campaign, Activity, Services, Partner,
• Conceptualizing consolidated DSO & Cube for campaigns, activities, leads during loading of data
• Creating multi-providers on the cubes, necessary BEx queries for the requested reports, PIC Authorization concept by leveraging the existing PRM Reporting concept
• Developing BOBJ Universes for the requested reports on top of BW queries, WebI Reports, Analysis Authorization Profile for the End Users
• Diligently preparing reports for:
• Campaigns Interaction Summary, PSA Team's Partner Assignments and Interactions Summary,
• My Partner List Interaction Summary, Open Activities, My Planned Interactions, Global and My Local Campaigns
• PSA’s Market Unit's Action Plan Status, Summary of Closed Tasks, My Interactions Summary, Interactions Reports
• Campaign Progress per Month Week, Global Local Campaigns List, Campaigns Closure Report per Market Unit, PSA’s Progress Report on Campaigns

Confidential

Environment: SAP BI 7.0, CRM, ECC

Senior SAP BI Associate Project Manager

Responsibilities:

• Assessed Business Requirements from CRM Functional Team, analyzed reporting requirements and building SAP BW Data Model, while interacting with CRM Functional Team on Reporting requirements and developed a SAP BW Data Model
• Customized data sources, created Generic data sources in CRM System and extracted data from ECC and CRM Systems
• Developed evaluation criteria and test plans, Creation of Info Objects, Transformations, DSO, Cube, and MultiProvider
• Verified Content Activation Result, Data Loads in development system and reconcile data with CRM, along CRM Team
• Worked on Transports from Dev to Q-system, Data loads in Q-System-System,
• Created plant level authorization
• Prepared Reports on Total Sales-Services, Sales-Products, Operating Profit % to Net Sales, Turnover Service % from Total, Invoice Analysis, Brand-wise Analysis, Utilization Report, Employee-wise Profitability

Confidential

Environment: SAP BI 7.0, ECC, Hire Craft

Senior SAP BI Consultant

Responsibilities:

• Handled tasks encompassing end-to-end implementation and understanding of business requirements from Talent Acquisition Team
• Diligently Analyzed the requirement and developed a blueprint of data model for the requirement in SAP BW
• Finalized a list of Custom Data Target, Info Objects, Queries and Roles and developed Evaluation Criteria and Test Plan
• Assessed database parameter setup for performance and prepared end-user modules
• Created Info Objects, Transformations, DSO, Cube, MultiProvider and verified content activation result
• Prepared reports on:
• TA Metrics, Offer Trend, Offer Break-up by Practice/IG & Offer Break-up by Competency Wise
• Offer Break-up by BU (People - Owner), Selection Data & Summary - NHR VS
• Offer - Business - People Owner Wise and Decline Analysis Reports

Confidential

Environment: SAP BI 7.0

BI Consultant

Responsibilities:

• Interacted with customers and Developed a high-level implementation plan, selected project team, plan
• Determined Landscape and Transport Strategy along Basis team, Acquire, Install and Test the Technical Environment (hardware, software, database, desk top and connectivity - Basis)
• Finalized a list of pre-delivered business contents to be activated by functional components, data sources, Info Cubes, Info Objects, Queries, and roles
• Assigned responsibility for each component Agreed upon the instrument (template) to record the test results and additional requirements, developed evaluation criteria and test plan, checked database parameter setup for performance Prepare end user material
• Spearheaded Business Contents Activation, Populate SAP delivered business contents with customer data, Verify the content activation Result, Conduct End User
• Conducted System Tests with End User Feedback, Conduct Volume Test, System Performance Tuning
• Coordinated and Implement Production Scheduling, develop a BW Operations Guide
• Enhanced Operations Guide, Monitoring and addressing production issues, if any. End user support, Project Go-live

Confidential

Environment: SAP BI 7.0

SAP BW Consultant

Responsibilities:

• Responsible for the Production Support Activities performed at Offshore
• Monitored the Loads of master data and transactional data through process chains
• Scheduled the process chains on daily, weekly and monthly basis to load the data into respective targets
• Monitored Process Chains and Meta Chains, worked to fix errors; Sid issues, duplicate data records, Activation of DSO errors, memory issues and Timestamp errors, etc. with respective corrections
• Performed Data Extraction and Data Staging using LO Cockpit (LBWE), loaded the data from ECC6.0 to BI7.0 used Initialization with Delta Update methods
• Involved in planning of Data reloads activities
• Worked on Broadcasting and pre-calculation servers, Created Broadcast setting for queries and workbooks to publish the reports to the users via E-Mail
• Performed test data loads in mirror systems before transporting changes to production server
• Involved in solving tickets regarding extractions, Performance Issues and load failures
• Worked on BI stabilization project where the teams from SAP and service teams are involved to stabilize the system and improve the data load SLA’s

Confidential

Environment: SAP BI 3.5

SAP BW Consultant

Responsibilities:

• Worked on LO-Cockpit Extraction for the Inventory Management, Sales and Distribution
• Developed queries based on the user requirement using Calculated Key Figure, Restricted Key Figure, Formulas, Exceptions, Conditions, different variables and Used RRI feature
• Completed automation of all BW daily, weekly and monthly loads to load master data and transactional data
• Maintained Daily data load error spreadsheet for each BW system ticket. Purpose is to record failed data loads to ensure visibility of issues and its correction
• Performed Data Extraction and Data Staging using LO Cockpit (LBWE) and extended the Structures using enhancements to support the business needs
• Replicating the data sources in BW side and activating the inactive transfer structures using ABAP Program and ensured performance tuning of Queries by maintaining Aggregates. Worked on Info cube Compression and rollup of aggregates

Confidential

Environment: SAP BI 3.0

SAP BW Associate Consultant

Responsibilities:

• Monitoring Data load activities and recovered failures in Dev., Quality system as a part of unit testing
• Preparing the process documents for each and every enhancement
• Involved in solving high-prioritized tickets regarding extractions, performance issues and data load failures
• Workedon process chains to automate the Deleting indexesin Info cubes, Process of info packages, creating indexes, ODS activation,further updating, PSA request deletion and Attribute change run so on
• Used open hub to export data from BI to External systems (flat file, table, 3rd party tool)
• Involved in Unit testing, Integration testing, Regression testing and User acceptance tests
• Enhanced the existing reports as per the new requirement
• Monitored the daily loads to various data targets in the system
• Monitored the process chains on the basis of daily, weekly & monthly
• Manual loading and rolling up the data into data targets
• Maintained the logs for each manual load
• Created aggregates to improve the query response