Ashwin Kaliga

331-***-****

Senior SAP BI / HANA Consultant

acvw3y@r.postjobfree.com SAP BI7.0 Certified Consultant

PROFESSIONAL SUMMARY

Around 10 years of IT experience in which 9.6 years are in SAP BW/HANA/ABAP/BOBJ with 3 implementations, support and upgrade projects.

Having hands on experience on BW 7.4 with HANA 1.0 and 2.6 years of experience in SAP HANA.

Excellent Skills in all aspects of SAP BI tools which includes Extraction from SAP ECC, SAP BW Data modelling to Universe creation using IDT and UDT including report creation using SAP Business Objects3.1/4.0/4.1 versions.

Worked on the BW7.4 objects with HANA like Composite providers, Transient providers, Analytic indexes and ODS views.

Excellent knowledge on SAP HANA on Data Modeling and Data Provisioning using BODS and SLT.

Good knowledge in creating Attribute View, Analytic view, Calculation View, Decision tables, Variables and input parameters.

Hands-on experience in creating ADSOs, DSOs, Infocubes, Virtual, Multiproviders and Infosets as per LSA Architecture.

Multiple Complete life Cycle SAP BW implementations.

Having experience in User administration activities like Creation, Deletion, Modification of user master record, creation/deletion of user groups, Locking/Unlocking, Validity date, password reset.

Excellent experience in designing Infocubes, DSOs by using data extracted from R/3 modules SD, Purchasing, MM, FI-CO, FI AR/AP/GL, CO-PA, HR as well as legacy systems.

Involved in upgrade projects like BW7.0, BW7.3 to BW7.4, and also in patch upgrades.

Expertise in working with BEx Query Designer in building Queries. Extensively created Calculated

Key Figures, Restricted Key Figures, Formula Variables, Conditions, Exceptions, Aggregations, Cell

editors, Customer Exit Variables and Structures for developing custom reports.

Experience in implementing security in BW including infoobject level security by maintaining them as authorization-relevant and using them in Analysis Authorization.

Created roles and restricting them in Queries, Infocube, Infoarea levels.

Strong ABAP programming and debugging skills. ABAP in Data dictionary, datasource

enhancements & user exits in R/3 & BW, Routines in Transformation, Transfer and Update rules,

User Exits for custom variables.

Excellent Client facing skills in understanding requirements and thoroughly documenting it.

Technical Skills

BI Tools: SAP BW Netweaver 7.0/7.3/7.4, Bex Queries, and SAP Business Objects 3.x/4.1/4.0.

Database: HANA1.0, Oracle 10g/9i/8i/7.3, SQL Server 2000/2005, DB2, MS-Access.

O/S: Windows8, 2000/2007 and XP.

Professional Experience with Clients (onshore and offshore model)

CINTAS, Ohio Nov 2015 – Till date

Sr. SAP BW/ HANA /ABAP/WEBI - Implementation

Created of SAP ADSOs, Composite providers for the dataflow related to CRM, EM, FIAR, Vistex, SD, MM, COPA and ECC loads.

Created Attribute Views, Analytical Views, and Calculation Views.

Created and managed Delivery Units to move across different environments.

Created Variables and Input parameters in the HANA Views.

Implemented data flow related to vistex like sales incentive line, sales incentive header and condition datasources.

Extraction of data from event handler data and events from EM systems.

Created WEBI reports on BEX query using BICS connection including Cross Tabs, Charts and linked reports using OpenDocument for Summary and Detail reports.

Appended datasources using BADIs.

Created BEX customer exits for the client requirement specific reports.

Created customized datasources using tables/view.

Involved in transporting objects between BW system environments and also corresponding SAP R/3 environment.

Created process chains for all the dataflows like masterdata, transaction data including functional areas like CRM, FIAR, FIGL, SD, MM and Vistex.

Created APDs and Open hub for sending data to MDG and CRM systems.

Scheduled WEBI reports on the basis of daily, weekly and monthly wise.

Environment: SAP BW 7.4 SP10, ECC 6.0, SAP Business Objects 4.1and HANA 1.0 (SP11).

Church & Dwight, Trenton, NJ Jan 2015 – Aug 2015

Sr. SAP BW/ABAP/BO Consultant/HANA- Implementation/support Projects

Replicated data from ECC to HANA using SLT based table Data Provisioning and also performed operations like, Load, Replicate, Stop, Suspend and Resume as part of Data Provisioning.

Created Packages, Attribute Views, Analytical Views, and Calculation Views.

Performed data loading into SAP HANA by using SAP BODS.

Involved in migrating existing standard InfoCubes, DSO's and SPO's to HANA-Optimized InfoCubes, DSO's and SPO's respectively.

Created and managed Delivery Units to move across different environments.

Created Variables and Input parameters in the HANA.

Created custom specific DSOs, infocubes, Datasources, calculated /restricted key figures and BEX reports.

Created WEBI reports on BEX query using BICS connection including Cross Tabs, Charts and linked reports using OpenDocument for Summary and Detail reports.

Migrated WEBI reports from BO3.1 to 4.1 using Upgrade Management tool.

Scheduled delta loads, monitoring data loads, PSA maintenance and de-bugging/rectification of data load errors.

Created BEX customer exits for the client requirement specific reports.

Involved in transporting objects between BW system environments and also corresponding SAP R/3 environment.

Reconciliation of data related to FI and COPA between WEBI and ECC.

Created process chains using APD step.

Scheduled WEBI reports on the basis of daily, weekly and monthly wise.

Designed technical solutions and created technical documentation for all the enhancements.

Estimate the efforts required for developing required objects.

Maintained Work History and communicated the status with the clients.

Guided support team for resolving data load issues and upgrade issues.

Created Universe using BEX queries in BOBJ 3.1.

Environment: SAP BI7.0, SAP BW7.3, SAP BW 7.4, ECC 6.0 and SAP Business Objects 4.1/4.0/3.1, SAP BODS and HANA SPS5

ColeHaan, Greenland, NH June 2014 – Dec 2014

Sr. SAP BW/ABAP Consultant-Development Project

Enhanced existing Reports based on BRS and FRS given by Users.

Worked on functional areas related to COPA, MM, SD and Inventory functional areas.

Developed info Cubes, Info Source, Info Objects, ODS objects, Update rules and Transfer rules, Delta management, Transformation, BEX queries and installation of Business content objects.

Took Initiative for requirement gathering from APO Consultants and Functional Consultants.

Designed technical solutions and created technical documentation for all the enhancements.

Estimate the efforts required for developing required objects.

Wrote ABAP Routines in SAP APO Objects.

Environment: SAP BW 3.5, BI7.0, BI 7.3, SAP APO and ECC 6.0.

Deloitte Member Firms, Glenmills, PA Nov 2010 – May 2014

Sr. SAP BW/ABAP/BO/HANA Consultant-Implementation/Support projects

Developed the SAP BI objects from extraction to reporting as per user requirements in the areas related to FI, CCA, GL and SD.

Enhanced datasources by using ABAP exits in the ECC.

Solved the security incidents reported by end users experiencing problems in viewing the WEBI reports.

Created WEBI reports from Bex queries and presented users the various functionalities of WEBI reports like Query Stripping, Hierarchies, creating Cross tabs reports and Linked reports.

Created WEBI reports on HANA System as a Proof of Concept for Performance improvements.

Created new SAP BW Objects like Transient and Composite info provider.

Created Attribute, Analytical, Calculated views, Analytic authorizations and Decision tables in SAP HANA.

Extraction of data by using SAP BODS.

Created Bex query based on the Transient provider.

Tested the reports by creating the copy roles of the user’s profile.

Created necessary roles as required and assigned them to the proper users.

Troubleshooting user issues and authorization issues using SU53 code.

Given estimates of new development tasks and billing of it to the clients.

Checked the dependency of objects for transports and granted the permission to move it to QA or PRD.

Worked on the scripts and XHTML coding in the WAD.

Scheduled and Monitoring the Data loads by means of Process Chains.

Documented all the training material needed for the team members to create more access levels as and when needed.

Involved in SAP BI training for the campus hires.

Environment: SAP BW 3.5, BI7.0, and BI 7.3, BW 7.4, ABAP, SAP BODS, ECC 6.0 and SAP Business Objects 4.0 and HANA.

Ericsson, Stockholm, Sweden Aug 2009 – Jul 2010

SAP BW Consultant-Support Project

Scheduled and Monitoring the Data loads by means of Process Chains.

Involved in reconciliation activities from different areas like COPA, CCA, PCA etc.,

Prepared dashboard reports on weekly basis.

Adhoc activities like Selective deletions, filling up of setup tables and scheduling of jobs.

Involved in both the Activities monitoring and Production Support.

Involved in Validated data consistency with Data Target against PSA after loading them

to data targets.

Solved Data Mismatch tickets and analysis of Performance of the system.

Creation of process chains like time based & event based.

Involved in maintaining lot of documentation for all the Support Activities.

Re-initialization of business area in case of inconsistency in data targets.

Monitoring of Info packages and analyzing the reasons for frequent failures of Info

Packages BIA & adding of infocubes to the BIA

Involved in submitting the Ticket Status (Open/Close) report.

Environment: SAP BW 3.5 and BI7.0, ECC 6.0 and Windows 7 Professional.

Nestle, Vevey, Switzerland Jul 2006 – Jul 2009

SAP BW consultant- Development /Support Project

Roles & Responsibilities:

Scheduled and Monitoring the Data loads by means of Process Chains.

Analyzed the reasons for failures of Info packages.

Maintained Work History for all the tickets until it is closed down.

Adhoc activities like Selective deletions, filling up of setup tables and scheduling of jobs, Activating and filling the Aggregates.

Involved in Production Support like upgrade and outage activities.

Involved in Validated data consistency with Data Target against PSA after loading them

to data targets.

Solved Data Mismatch tickets and analysis of Performance of the system.

Involved in maintaining lot of documentation for all the Support Activities.

Maintained the reports about the status, updating the documents for the markets if there is any delay in reports availability.

Re-initialization of business area in case of inconsistency in data targets.

Involved in training Shadow resources and other team members

Involved in submitting the Ticket Status (Open/Close) report.

Environment: BW 3.5, and BI7.0, ECC 6.0 and Windows 7 Professional.

Cigna, Bloomfield, CT Feb 2006 – May 2006

System Analyst-Support Project

Roles & Responsibilities:

Analysis of the specifications corresponding to the given functionalities.

Made the code changes as per the DDD and see for any peculiar cases which are

deviating from the regular process if any.

Preparation of Unit test plans and Unit test results.

Overseen the Quality procedures related to the project.

Supported in User Acceptance Testing.

Involved in submitting the Ticket Status (Open/Close) report.

Environment: COBOL, JCL, DB2 and CICS.

Education: Bachelor of Engineering 2005.

References will be provided upon request.

Contact this candidate