We provide IT Staff Augmentation Services!

Sap Hana Senior Consultant Resume


Seeking a career to be a Solution Consultant and grow as an SAP professional in an organization which allows me to explore, experiment and excel, thus, adding to the growth of the organization by applying the acquired knowledge, analytical, digital communication and interpersonal skills.


  • Software Professional with 8+ years of experience includes SAP HANA, SAP Business warehouse/ Business intelligence, SAP BODS, SAP BO, SQL, QLIK SENSE, BEx Analyzer, Query Designer, dashboard management, SAP BASIS application - HP Tools - Output Sever (DAZEL), UNIX, SHELL scripting, broadcasting using HP web delivery.
  • SAP BW/BI consultant, HPOS - DAZEL Administration (SAP production Control), Incident Management, Change Management, Problem management, SLA management and Vendor management, Escalation Management, Alert Monitoring and Team Handling.
  • Hands-on experience in end-to-end project management, ensuring effective management of various resources to meet project specifications with the business process analysis
  • Insightful understanding of business process, analyzing requirements, finalizing the business scenario, implementing SAP HANA/BI/BW Projects, Reports & Dashboard development and support experience through ITIL standard processes.


SAP Packages: SAP S4/HANA, SAP HANA, SAP BI 7.4, 7.0, BW 3.5, SAP NetWeaver 7.0, R/3, ECC 6.0, 4.6SAP ETL application - SAP BODS 4.2

SAP Reporting Tools: QLIK SENSE, SAP BO 4.2, BEx query analyzer, BEx query designer.

SAP supporting Applications: HPOS (DAZEL) 3.5/4.1.

Languages: Basics of ABAP C, C++, Java, UNIX, Shell scripting

Third Party Tools used:

Database: MS SQL Server 2008, MS SQL Server 2005

Software/Tool: BMC remedy, HP service manager, HP service now, TSM, Control M & TWS



SAP HANA Senior Consultant


  • Expertise in Data modeling- Attributes Views, Analytical Views, Calculation Views, Store Procedure Business rules in to Decision Tree and Analytical Privileges.
  • Created advanced modeling using restricted calculated column, variable, input parameter, currency conversion.
  • Hands on experience in SAP HANA Data provisioning using SAP BO Data Services 4.2. Gained experience with DATA Extraction Transform Loading ETL for loading data from SAP ECC System to SAP HANA System. Having good knowledge on SAP HANA Architecture. Well versed with importing Meta data, table definitions, performing initial load and replication, resuming and suspending data loads using SAP HANA studio.
  • Sound knowledge of selecting Business Object BI client base on product capabilities and Business requirement. Working knowledge in Design, Development Deployment of Business Objects solutions for corporate reporting using WEBI Crystal Reports. Experience in building reports using agile Visualization tool BO WEBI.
  • Worked on modeling of ADSO’s, composite providers, Open ODS views as per LSA++ architecture.
  • Exceptional analytical, organizational, and leadership skills, coupled with the ability to research and evaluate business and information requirements to manage, architect, and implement automated solutions which enhance business productivity and competitive advantage. A quick learner, skilled at mastering new software techniques and delivering quality software.
  • Created Technical specifications and standard modeling documents for HANA.
  • Involved in business and blueprint gathering discussion.
  • 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.
  • Created advanced modeling using restricted calculated column, variable, input parameter.
  • Developed the security model, naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports from HANA data sources.
  • Created web services for querying HANA database from external end HR user report portal using real time jobs in data services 4.0 designer.
  • Created Users, Roles, privileges, Packages, schema as part of HANA security and development.
  • Migrated HANA content from development, testing environment to Production environment using delivery units.
  • Developed WEBI reports and dashboards for different operations and different KPI'S
  • Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool.
  • Involved in developing test scripts and assisted UAT on SAP net weaver portal using Test ID's for super users, and end users.
  • Integrated BOBJ 4.2 and BODS 4.2 with SAP HANA1.0.


SAP BW/BI Consultant


  • Worked closely with the Project Team members to evaluate business needs, defining and prioritizing requirements, and agreeing process flows and analytical capabilities that align wherever possible with leading practice business process.
  • Responsible for Incident management system using Remedy and Request Management Systems.
  • Provide effective engineering and support services to the global organization by demonstrating ownership and accountability for all assigned tasks and projects.
  • Participated in design reviews, spec reviews, code reviews, test plan reviews
  • Extensively worked in Business Information Warehouse Info cubes, DSO objects, Data Sources, Info objects, Transformations, DTP Extractors, Data Sources, Info packages, Data Extraction, Characteristics and Key Figures, Process Chains.
  • Data Source Enhancement according to customer requirement.
  • Worked with team for real time Info cubes for Integrated Planning.
  • Extraction of data from SAP source system like ECC, EXT and from flat files.
  • Have done initialization of corrupted with delta with and without data transfer.
  • Created process chains, master data and transaction data. And automated Process chains
  • Expertise in scheduling, monitoring process chains.
  • Checking the daily, weekly, monthly data loads using process chain and fixing the issues.
  • Analyzing and fixing the frequent failures of in Info-packages and DSO’s while monitoring batch loads.
  • Performance Tuning - Evaluated statistical performance and provided recommendations for optimization. Improved data load and query performance by doing compression and process chains, partitioning and creating batch indexes.
  • Created Aggregates and used Line item dimensions to increase the performance of the query.
  • Created cut-over plan prior to Go-Live.
  • Worked on Global and regional reports
  • Open Hub interface to transfer data from BI to Flat Files to load to an external system
  • Used remedy tool for raising CR’s and to keep a track ticket progress.
  • Designed and developed queries to generate reports in BEx Analyzer.
  • Worked extensively on query designer.
  • Created custom queries using Conditions, Exceptions, Variables, Structures, Restricted and Calculated Key Figures and created aggregates for frequently used queries.
  • Conducted Training for End-users and Project Team members. Developed different BW and SEM training documentations for different users based on their roles
  • Provided Support during and post Go-Live.
  • Performed Month end activity for business requirement to transfer data from SAP System to third party system.
  • Created training documentation and trained users.
  • Perform administrative task, application changes, executing data reloads.
  • Responsible for Incident management system using Remedy and Request management Systems.
  • Provide effective engineering and support services to the global organization by demonstrating ownership and accountability for all assigned tasks and projects.
  • Interacting with the client/business units involved in the management of changes to systems, products, services, infrastructure and SAP of various Infra applications managed by IT Change and Release Management
  • Scheduling & endorsing changes to client by application teams, operators and external vendors involved in the change management process.
  • Involvement from initial planning/design and testing phases of changes, concerned approvals, notification, sign-offs, reviews, lockdowns and execution till the closure of changes.
  • Responsible of getting the changes approved, allocating them to implementer.
  • Handling escalated tickets and providing solutions to the clients.
  • Attending project meetings with clients and responsible for implementation and daily status call.
  • Preparing technical and Monthly SLA reports and reviewing with the client.
  • Communicating with other teams and providing support to Projects.
  • Managing and resolving client problems, changes and queries in an effective and timely manner.
  • Liaising professionally and effectively with users, clients and vendors.
  • Providing appropriate inputs to the problem management process, RCA preparation Using LEAN & SIX SIGMA concepts
  • Handling conflict situations and make quick decision while driving incidents.
  • Mentoring new joiners and People management


SAP BW Developer


  • Involved in all phases of project from Blueprinting, Configuration, Development, Integration Testing, Cutover, and Training to Go Live. Meetings on status, issues, and overall progress
  • Developing flows from info-objects to Multiproviders.
  • Worked on Multiproviders, Info cubes, DSOs, transformations, DTPs in order to meet the end user reporting requirements.
  • Installing Business Content Info Cubes and DSOs and used BC Data sources.
  • Working on Data Extraction from SAP R/3 using Generic, LO Extractions, Data Loading (Full/Delta Upload).
  • Creation of Generic Data Sources from table, view.
  • Created Process Chains to automate the loading process for master data and transactional data.
  • Extracted data from SAP R/3, Flat Files and Legacy Systems
  • Created various reports using Variables, Restricted Key figures and Calculated Key Figures
  • Analyzed user requirements, finalized reporting structure, resource planning and cut over and project planning. Conducted workshops, created templates for testing and initiated user training. Identified users, roles, and formulated the realization strategy
  • Identified key reports from business content. Installed and configured the extractors, Data sources, info sources, and info providers of Service analytics
  • Enhanced the data sources as per the Business Requirements.
  • Implemented Queries on BEx using Filters, Free Characteristics, Restricted Key Figure, Calculated Key Figures, Variables, Exceptions and Conditions.
  • Involved in designing the Process Chains to extract the data for the designed dataflow.
  • Involved in creation of Process chains.
  • Involved in database optimization by Periodical deletion of data from change log and PSA tables.
  • Worked on Customized Extractors to extract the data from R/3 to BI with full update.
  • To ensure the correct loading of the necessary data from the connected operational systems in time.
  • Involved in creation of process chains and modify the process chains based on the requirement.
  • Coordination and communication with the onsite team.


SAP Product support engineer


  • Compliance activities - Biannual planning to validate authorized users in OPM and HPOS password compliance activities & Output devices harmonization across Confidential environment.
  • Handling High priority issues with Output devices and HPOS server in Production Environment & Dashboard Management
  • Responsible for SAP/Windows/Unix Print Queue Management using HPOS. HP, Zebra, Epson & Lexmark, etc. Printers & related utilities
  • To maintain the output devices like Printers, Fax, FTP, web deliver and E-Mail devices remotely by using various tools like HP web jet admin and using various Unix & networking concepts, Handling the Unicode issues.
  • Pro-active monitoring of server for file system size, processes running, paging space, core dump files, log files & errors in config files etc.
  • Installing and troubleshooting HP Web Delivery which automates the process of publishing, distributing, and managing reports and documents to the Web.
  • Tested new software products to verify delivery of the business requirements for OPM team. Defects are documented in the Web portal to follow-up bugs in future.
  • Prepared test cases to perform UAT Test Execution from End-user Regular meeting with software developers to report the bugs in product. Followed ITIL & Best Practices in daily activities.
  • Created new article & updated article in KB tool & Standard routine documents.
  • Analysis & Monitoring - System Logs, Background Jobs, ABAP/4 Dump Analysis, Work Process Overview, Lock Entries, Update Errors.
  • Daily monitoring which includes, checking all application servers, Work process overview, Background jobs overview, Checking space statistics, and Backup logs.
  • Monitoring the system and performing the Daily System checks. Resolving the issues and directing functional issues to respective teams.
  • Identifying system problems by analyzing system log, Work processes status, Work process logs and DB logs
  • Performance monitoring including alert monitor, workload analysis, database and buffer monitoring
  • Performed user administration, Created authorization profiles, Activity Groups and Users.
  • Created Authorizations and Profiles based on the Job Profiles
  • Created and Maintained User Master records
  • Creation of system message / customer notification

Hire Now