SAP on Native HANA Senior Consultant, SAP BW/BI Consultant, Developer

* HPOS server/client installation, Outage activities & Administration. Handling business impact
issues regarding SAP output device & HPOS Server.
* 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

Client - HCL Technologies
Worked as an SAP on Native HANA Senior Consultant

* Created many proofs of concepts to help understand the requirement with the business and to
analyze the performance issues in the design.
* Regular interaction with the functional team and end users to understand their reporting
requirements and creating related information document.
* Got customer requirements, designed initial Business Warehouse solution, Business Objects
dashboard, did final R/3 to BOBJ dashboard data validation.
* Set standards for design, naming conventions, and made final decisions considering the
alternatives.
* Led weekly team meeting with customer and client.
* Tracked, managed implementation schedule with customers.
* Discussed design standards and procedures with the directors of design and architecture.
* Designing and remodeling the solution as per Business requirement.
* Conducted a two-day workshop with the Senior Executives of Cost Analysis & HR Analysis
Dashboards and its functionalities
* Created stories and dashboard on SAP analytics cloud using HANA Views.
* Expertise in Data modeling- Attributes Views, Analytical Views, Calculation Views, Store
Procedure Business rules in to Decision TABLE 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.
* Worked SAP HANA Core data services (CDS) to create tables and views
* 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 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.
* Prepared scripts to ensure proper data access, manipulation, and reporting functions with R
programming languages.
* Created Technical specifications and standard modeling documents.
* 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 and BOBJ 4.2 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 SAP BODS.
* 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.

Client - Axalta Coating System - Formally Dupont
Working as an 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.
* 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