PROFILE SUMMARY

• Have 10+ years of experience in SAP BW on HANA and HANA modeling and performed various roles as Senior Consultant.
• Experience in leading on - shore and offshore teams. Co-ordinate with them in weekly meetings and delivering teh objects with in time frame.
• Hands on experience in gathering requirement from end user and enhancing teh reports.
• Experience in creating Technical designs (both backend and Frontend) based on Functional specs.
• Experience in BW application functionality such as creating and loading data into InfoObject, Infocubes, DSO’s, Multiproviders, Composite Provider, Infosets etc.
• Worked extensively in Front-end Functionality, with BEx analyzer, query designer and workbooks for developing reports and worked on queries using conditions, exceptions, variables, and created aggregates to improve performance.
• Hands on experience in replicating teh data from ECC system to BW system with SLT process and SDI (smart data integration), BOBJ services in to HANA.
• Worked on creating replication task using HANA SDI sources.
• Worked on creating SDI flow graphs and scheduling them using XS jobs in HANA.
• Experience in publishing teh reports through information broadcasting to E-mail, Portal.
• Involved in HANA modeling on creating information models like attribute, Analytic and Calculation Views.
• Worked on Pull and Push approach to get BW models into HANA content.
• Worked on performance optimization of calculation views that is using visualization and explain plan in HANA.
• Provided teh Analytical privileges upon business requirement on HANA views.
• Designed BO WEBI reports on top of existing universe upon ad-hoc requests from end users.
• Worked extensively in Generic extraction and LO cockpit extraction based on teh requirement.
• Worked on installing teh Business content standard objects based on requirements.
• Performed data monitoring, PC scheduling and fixed data load errors in a production environment.
• Handled teh tickets of priority 1, 2, 3 and 4 by following Standard Operating Procedures (SOP), and worked upon teh Service Level Agreement (SLA)
• Monitored teh Process chains in a daily basis, weekly basis and Monthly basis.
• Analyzed teh errors which were occurring in process chains on daily basis and provided teh permanent solution.
• Manually triggered teh process chains based on teh task for different source applications.
• Worked in Open Hub destinations to push teh files into AL11 directory and 3rd party systems.
• Involved in System Integration Activity (SIT) to loads teh data from different sources to BI.
• Experience in transporting teh objects from Dev system to Quality system and then to Prod system with SolMan.
• Involved in BW application upgrade and worked on functional testing on Info Objects, DSO, Cubes.
• Provided Knowledge transfer sessions to new joiners and gave boot camp training to cross-trained people.
• Cross trained on creating teh reports with Design Studio on to of BW objects.
• Worked on core data services (CDS) views and consumed in information models in HANA.
• Worked on triggers to update custom tables in HANA data base.
• Worked on creating stored procedures in native HANA.
• Good knowledge on Xcelsius dashboard and Crystal Reports.
• Have knowledge on HANA admin concepts.
• Worked on Lean Sigma project to improve teh quality of business deliveries.
• Involved in POC by creating teh CDS views in S/4 HANA

TECHNICAL SKILLS

ERP Packages: SAP ECC 6.0.

Data warehouse tools: SAP BW 3.5, BI 7.0, BI 7.4 and HANA Studio.

Reporting tools: BEx Query Designer, BEx Analyzer, and SAP BO WEBI.

Languages: ABAP, SQL.

Operating Systems: Win 98/NT/XP/Vista/Win7.

PROJECTS EXPERIENCE

Confidential, Mounds view, MN

SAP BW, HANA Consultant

Role and Responsibilities:

• Worked as onsite co-ordinate and gathering teh requirements from client and delivered teh objects with in timelines.
• Involved in creating teh technical documents based on functional Spec’s.
• Created Info Object, DSO’s, Cube and Multi provider, Composite provider, Transformation, DTP’s as per teh business requirement.
• Designed BEx reports for business analysis by using Calculated Key figures, Restricted Key figures, selection, formula, conditions and exceptions.
• Created workbooks by using multiple BEx queries to display teh results in different sheets.
• Involved in creating teh HANA information models like Attribute, Analytic and Calculation view.
• Worked on Pull and Push approach to get BW models into HANA content.
• Worked on core data services (CDS) views and consumed in information models in HANA.
• Worked on triggers to update custom tables in HANA data base.
• Worked on creating stored procedures in native HANA
• Hands on experiencing in creating teh field, start and end routines.
• Transporting teh Objects from development to Quality to Production with SolMan.
• Created teh ad-hoc Business Objects WEBI reports on top of existing Universe.
• Hands on experience in replicating teh data from ECC system to BW system with SLT process and SDI (smart data integration), BOBJ services in to HANA.
• Worked on creating replication task using HANA SDI sources.
• Worked on creating SDI flow graphs and scheduling them using XS jobs in HANA.
• Involved in creating teh documents for teh objects moved to production system and teh same shared with production support team.
• Had good exposure on Logistics applications (SD, MM etc.) and financial application (GL, AP, AR).
• Good experience in production support activities and resolving teh Priority 1, 2, 3 and 4 incidents.
• Worked with Cut-over team on schedule out ages and doing teh ramp-up/down activities and application checkouts.
• Involved in Pre and Post activities of BW application up-gradation happened in teh production systems and performing teh testing scenario’s in development and quality systems which provided by data architect.
• Experience in handling teh issues with GRC and Service Now tool.
• Published BW reports through information broadcasting to end users via E-mail, Portal.
• Created House-keeping process chains on Compression, PSA deletion, Change log deletions.
• Participated in daily data load monitoring and analyzing teh reasons for frequent failures of jobs.
• Worked on Lean Sigma project to improve teh quality of business deliveries.

Confidential

SAP BI Consultant Project

Role and Responsibilities:

• Involved in System integration activities (SIT) in Quality, Special environment and Production systems across teh landscape.
• Worked as a stream lead for all teh SIT activities and worked on Fixed Assets reports.
• Created teh technical designs based on functional specs for Fixed Assets reports.
• Developed teh reports on Fixed Assets (syndication) files
• Worked on teh tasks which will assign by teh control room based on teh priority.
• Monitored teh process chains and analyzing teh issues occurred in teh chains.
• Provided resolutions on teh tickets from HPQC tool.
• Worked on teh performance issues with teh help of OSS notes.
• Worked on teh defects and provided teh resolutions which will assign from Mercury tool.
• Transported all teh developed enhanced objects across teh landscape.
• Had good exposure in handling teh onsite calls and providing teh KT sessions to our peers.
• Provided teh knowledge transfer sessions to Deloitte team in SIT activities.

Confidential

Application Developer

Role & Responsibilities:

• Modeling and creating BI objects like info objects, DSOs, info cubes, and multi providers.
• Creating and managing data flow using DTPs, transformations and info packages.
• Involved in writing start routines and field level routines as per teh given logic.
• Created Info packages for Flat file loads and file names will be recognized based on routine.
• Maintaining reconciliation to verify teh data in SAP R/3 and SAP BI.
• Enhanced teh master data, data source and populated teh data to teh new fields.
• Loaded Data into teh ODS Object before updating to teh Info Cube.
• Developed process chains for teh current data loads and for teh Historical loads.
• Maintained technical design documents for teh Developed objects.
• Installed Business Content as and when required.
• Implemented data extraction and data staging using LO cockpit modules.
• Created various reports using variables, filters, restricted key figures, calculated key figures and free characteristics as per user requirement.
• Collected teh developed objects and transported to teh Quality and production boxes.

Confidential

Application up-gradation and testing

Role & Responsibilities:

• Worked extensively in BI 7.0 Functional upgrade.
• Generated Test scripts on Functional, Post and Prescripts Test Plan by using HPQC tool (Mercury tool).
• Preparing test scripts inHPQC test plan and executed teh test scripts in test labs.
• Executed test scripts in HPQC tool by using CITRIX server.
• Worked on teh defects which we are related to Implementation phase.
• Handled many complex issues.
• Worked on Web Portal to execute teh reports.
• Provided Knowledge transfer sessions to all teh new joiners in teh project about teh System landscape and functionality of HPQC tool and other Bi related issues.
• Daily status updates to teh client.