We provide IT Staff Augmentation Services!

Sap Hana / Bw Consultant Resume

Cypress, CA

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 Confidential, 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 Confidential 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.

KEY RESULT AREAS:

  • 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 training 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.
  • Implemented HANA Live, Extended HANA Live and customised standard content with business requirements
  • Implemented Toll Tax Reporting solution on Lumira Teams , extensively worked on LUMIRA 1.10 - 1.30 versions , hands-on with chart extensions of LUMRIA and implemented Integration of WEBI to Lumira.
  • Implemented BI Adoption RDS for Confidential on Confidential Project. CID-5179911
  • Implemented new SAP Retail tool SAP CAR (Customer Activity Repository) on HANA and LUMIRA Dashboards
  • Implemented SAP HANA / Lumira for Confidential TV show
  • Implemented BW on HANA for Confidential & Confidential
  • Delivered SAP HANA - CRM integration project for SAP Global Delivery, Bangalore.
  • Managed 3 Implementations in a single year in Confidential .

IT 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 Confidential 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 Confidential ’s in BW as per LSA++ design approach.
  • Created field level Confidential ’s in BW Modeling tool.
  • Consumed Confidential ’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, Checks for BEx query.
  • 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 Confidential tool to Track sales results by collecting sales order details in Confidential ’s and consolidated Confidential ’s in a Composite provider, exposed views to LUMIRA for story board creation.
  • 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, Bartlesville, OK

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 on Calculation 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 training 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 technical objectives 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 a differentiated 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, training 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 trainings on Business Intelligence, Business Objects Reporting tools, SAP HANA

Hire Now