Abhi Yalamanchili

Abhi Yalamanchili
C: 647-873-4482|E: abhi.y0402@gmail.com

Profile Summary:
CertifiedSAP HANAApplication Associate.
With over 5 years of experience in working with stake holders and cross functional teams to assist with gathering and evaluating detailed project requirements.
Expertise in BW Powered by HANA, HANA-Optimized Cubes, Advanced DSOs (ADSO) and Composite providers.
Worked on BODS (Data Services) to extract the data from Non-Legacy Systems like Oracle server in to HANA system using Data harmonization.
Designed the HANA modeling views for the financial internal and external cost tracking to analyze on Profitability Analysis and Inventory management.
Experienced in using joins and difference types of joins and functionalities.
Experience in Configuring and Consuming SAPBW objects and HANA models/views clients such as BO (Dashboards & WEBI), SAP Lumira for Visualization &Predictive Analysis and AO- Analysis Office.
Good understanding on Star Schema and Extended Star Schema.
Worked on BO (UDT, IDT, and WEBI) more on visualization
HANA admin activities: User / role management, HANA security, expensive statement analysis, performance/memory issues.
Participated in design reviews, spec reviews, code reviews, test plan reviews.
Excellent universe design skills using Universe Design Tool (UDT) and Information Design Tool(IDT) involving various data sources.
Knowledge of SAP Business Objects Data Services (BO-DS) architecture.
SAP Lumira – Deploy the standard graphing techniques of visualization in SAP Lumira for bar charts, line charts, histograms, pie charts and scatter plots
Solution HANA optimization and performance tuning expertise
Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

Work Experience:

NTT DATA                                                                                                                                  April 2016 – Present
Position: SAP BW/HANA Consultant

Responsibilities:

Analyzing and Performance tuning on Analytic data models and data flows.
Working with stakeholders to collect, analyze, define, and document requirements for reports, dashboards, scorecards, and analytics.
BI Design – HANA optimized Info Cubes design, Composite Providers, Advanced DSO, ODS Objects, Proficient in Data modeling using MDM and BW extended star schema models.
Development of Advance DSOs in HANA Studio using Eclipse tool and mapping the transformations to Advance DSO’s, reloading data from standard DSOs and HANA cubes to Advance DSO’s.
Creating composite provider in order to replace Info sets.
Replacing the Standard DSO’s and HANA Optimized Cubes with Advance DSO’s and Multi-providers and Info-sets by Composite Providers.
Testing the BEX queries on Composite provider and noticed performance improvement.
Migration of HANA views to BW and import of BW Info providers to HANA and providing the best modeling solution.
Importing HANA optimized cubes into HANA studio/modeler as Analytical Views and union of different Analytical Views into another Calculation View and then creating the composite provider on calculation view and then creating BEX reports on it.
Currency translation in semantics in calculation views, creating Input parameters for dynamic filtering of data.
Transporting all BW on HANA objects using normal BW transport method and HANA views using Life cycle management.
Extensively involved in Logistics extraction and create a custom generate data source using Functional Module.
Experience in Logistics (SD,PM,PP), Finance control (FI-CO & COPA) to extract the data from Source system (SAP/Non SAP).
Extensive experience with SAP BW administration using the BW Administrator Workbench, installing Standard Business Content objects, customizing the Business Content objects, custom data warehouse development, managing ETL jobs, troubleshooting failed processes.
BI Reporting – Experience in Design and Development of Queries, Reports, Business Explorer Analyzer, Query Builder, Info Set Query, Web Reporting,
Worked on all the technical data modeling artifacts of SAP HANA like creation of Attribute Views, Analytic Views, and Calculation Views (graphical and scripted (SQL).
Extensively worked on SAP HANA SQL scripting in the development of scripted based calculation view models. Determined business owners’ needs, wrote designs, and worked with technical group.
Provided support and transition of the BW system from development to production support.
Played a pivotal role in transportation of objects from Dev to Quality systems and to Production.
Coordinate and centralize responsibility and accountability for the design, development, release, and maintenance of the BW system.
Handled most of the front-end issues, short dumps and worked in liaison with SAP on critical issues such as metadata repository and Standard BADI issues.
Created a track for all the UAT issues, resolved them and updated the tracker on a regular basis to the manager and the client, to keep in sync.
Provided support for high-priority tickets post go-live.
Documented all the test cases from end-to-end testing and updated it on a regular basis to the Client.

Dilanko Solutions                                                                                                            Nov 2014 – March 2016
Position:SAP BW Consultant

Worked with Info Packages and Info Package Groups and Scheduled them to Load Master Data and Transactional data from SAP R/3 as well as Flat File Source Systems into BW.
Worked with PSA in Monitoring the Data Transfer from Source System into BW.
Involved in Performance Issues like Creation of aggregates and Compressed the InfoCube to improve the query response.
Involved in solving the tickets regarding extractions, Performance Issues and load failures.
Experience in troubleshooting, investigates, analyses, and solves software problems and maps client business requirements, processes and objectives; develops necessary product modifications to satisfy clients’ needs.
Monitoring of Infopackages and analyzing the reasons for frequent failures of Infopackages
Assist resolving issues during Transport Webi Reports and BW Objects from Development to QA.
Involved in Cut over activities during go live.
Worked closely with End user after go live support to resolve their issues and bugs.
Assist with technical documentation and procedures.
Maintaining Work History for all the tickets until it is closed.
To inform the onsite people if there any deadlocks.
Resolved Customer reported tickets through email and phone.

Siri IT Innovations                                                                                                                Jan 2011– Dec 2011
Position:Analytics Application Developer

Responsibilities:

·     Performed maintenance and enhancement for existing BW system in the SCM &CRM areas.
·     Reload of BW Inventory cube, due to IT Operations errors during loads. Prior to re-load, converted infrastructure to 7.0, created additional EDW layer, enhanced Process chain and created additional reconciliation queries.
·     Added many Navigational Attribute to various cubes for use in queries.
·     Modified existing queries to utilize the above mentioned Navigational Attributes
·      Added additional InfoObjects to SD & Purchasing Cubes, including required Datasource, Transformation and DSO enhancements.
Provided support and transition of the BW system from development to production support.
Played a pivotal role in transportation of objects from Dev to Quality systems and to Production.
Coordinate and centralize responsibility and accountability for the design, development, release, and maintenance of the BW system.
Handled most of the front-end issues, short dumps and worked in liaison with SAP on critical issues such as metadata repository and Standard BADI issues.
Created a track for all the UAT issues, resolved them and updated the tracker on a regular basis to the manager and the client, to keep in sync.

Technical skills:

SAP Skills:ECC 6.0, SAP BW/BI
Reporting tools: Web Intelligence
Dashboard tools: Business Objects Design Studio, SAP HANA Studio
Analytics tools: SAP Lumira, Business Explorer, BeX queries
Data Modeling: SAP HANA Modeling
ETL: BO Data Services
Database Appliances: SAP HANA, SQL Server

Academic Credentials:
Masters of Engineeringfrom Dalhousie University, Canada.
Bachelor of Technology inComputer Science and Engineering from JNTU, India.