SUMMARY

• Have 11+ years of experience in SAP BW on database as HANA, DB2, Oracle DB, BW4HANA, Native HANA Modeling, SAP Business Objects (Webi, and Design Studio for Visualization), SAP SLT and SAP Solution Manager.
• Experience in implementing projects with SDLC like water fall, spider and agile method models.
• Hands on experience in implementing Lean Six Sigma to improve the performance in existing solutions.
• Partner certification in SAP BW 7.4, User authorization, SAP SolMan and IBM internal certification on Block Chain.
• Performed various roles as Senior Consultant in handling projects and leading the team by coordinating with offshore on deliverables
• Self - motivated and proactive in new opportunities to develop personally and professionally.
• Positive attitude and very open-minded in sharing and transferring the technical as well as the business knowledge to peers and other project members.
• Hands on experience in requirement gathering from end user and enhancing the reports.
• Experience in creating Technical designs (both backend and Frontend) based on Functional specs.
• Experience in handling ODQ Mon data source for delta into BW4HANA.
• Involved in migration from ECC to S/4 HANA and exposed into BW4HANA.
• Experience in migrating BW to BW4HANA next era data warehousing for effecting predictive analysis.
• Hands on experience in developing Information models as Attribute, Analytic and Calculation Views in HANA Modeling.
• Extensively worked on Variables, Input parameters, Calculated columns and Filter expressions
• Hands on experience in creation of Procedures, Table Functions, Functions and Hana SQL
• Experience in creating filters, calculated and restricted columns in HANA views for custom Calculations as per the business needs.
• Enhanced performance using various pruning technic, SQL hints and Plan visualizer
• HANA optimization by using Input Parameters and filter expressions at table projection level to push the filters to DB level and conversion of variables to Input Parameters manually
• Hands on experience in analysis, designing existing BW objects into BW4HANA compatibility objects with LSA++ like ADSO’s, Composite Provider and exposing the objects into HANA Views.
• Hands on experience in replicating the data from ECC system and external system to HANA and BW systems with SLT process.
• SDA/SDI-supporting data replication, extraction, federation, and streaming to replicate SAP and non-SAP data in near real-time. Replicated data using Oracle Golden Gate from iSeries DB2 to SAP HANA
• 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.
• Experience in publishing the reports through information broadcasting to E-mail, Portal.
• Hand of experience in creating the DTP routine, start routine, end routine, filed routine in transformations with ABAP.
• Enhanced the data source in ECC with ABAP to meet the calculation for business requirement.
• Hands on experience in extracting the data from application tables of SD, MM, PP & FICO in to BW as per business requirements.
• Worked extensively in Generic extraction and LO cockpit extraction based on the requirement.
• Worked on installing the Business content standard objects based on requirements.
• Performed data monitoring, PC scheduling and fixed data load errors in a production environment.
• Involved in BW application upgrade and worked on functional testing on Info Objects, DSO, Cubes.
• Had experience in pulling and pushing the data from multiple sources like SAP CRM, GTS, APO planning book and SMO in to BW.
• Handled the tickets of priority 1, 2, 3 and 4 by following Standard Operating Procedures (SOP), and worked upon the Service Level Agreement (SLA)
• Monitored the Process chains in a daily basis, weekly basis and Monthly basis.
• Analyzed the errors which were occurring in process chains on daily basis and provided the permanent solution.
• Manually triggered the process chains based on the task for different source applications.
• Worked in Open Hub destinations to push the files into AL11 directory and 3rd party systems.
• Designed BO WEBI reports on top of existing universe upon ad-hoc requests from end users.
• Experience in transporting the objects from Dev system to Quality system and then to Prod system with SolMan.
• Have minimal experience in Power BI Visualization on top of HANA View.
• Provided training sessions to new joiners and gave boot camp training to cross-trained people.
• Worked on POC creating CDS views in S/4 HANA
• Knowledge in SAP IBP(Supply Chain).

TECHNICAL SKILLS

ERP Packages: SAP S/4, ECC 6.0, 3rd party systems.

Data warehouse tools: SAP BW 3.5, BI 7.0 - 7.5, BW4HANA, HANA Studio.

Reporting tools: BEx Query Designer, BEx Analyzer, BObj, PBI & Tableau.

Languages: ABAP, SQL.

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

PROFESSIONAL EXPERIENCE

Confidential, Issaquah, WA

BW4HANA & Native HANA Consultant

Responsibilities:

• Hands on experience in developing Information model Calculation Views in HANA Modeling.
• Extensively worked on Variables, Input parameters, Calculated columns and Filter expressions
• Hands on experience in creation of Procedures, Table Functions, Functions and Hana SQL
• Experience in creating filters, calculated and restricted columns in HANA views for custom Calculations as per the business needs.
• Enhanced performance using various pruning technic, SQL hints and Plan visualizer
• Experience in replicating data with SDA/SDI and SLT process.
• Expose model views to HANA XSJS and OData Services.
• Hands on experience in analysis, designing existing BW objects into BW4HANA compatibility objects with LSA++ architecture like ADSO’s, Composite Provider and exposing the objects into HANA Views.
• Experience in functional applications like CRM, HR, EWM, Logistics and FI to develop the BW4HANA solutions.
• Experience in handling ODQ Mon data source for delta into BW4HANA.
• Involved in migration from ECC to S/4 HANA and exposed into BW4HANA.
• Experience in migrating BW to BW4HANA next era data warehousing for effecting predictive analysis.
• Hands on experience in providing solutions to automate the process in reducing the manual effort.
• Hands on Design and develop BEx reports for business analysis by using Calculated Key figures, Restricted Key figures, selection, formula, conditions and exceptions.
• Scheduling the process chains to load the data on daily, weekly and monthly basis by using UC4 automation tool.

Confidential, Mounds view, MN

BW and Native HANA Developer

Responsibilities:

• Worked as onshore and offshore lead in gathering the requirements from client and delivered the objects with in timelines.
• Involved in creating the technical documents based on functional Spec’s.
• Created HANA information models like Attribute, Analytic and Calculation view.
• Creation of calculated attributes, measures, restricted measures, calculated columns, filters, variables, in-put parameters to satisfy reporting requirements using SAP HANA studio.
• Exposed HANA Views to design the visualizations reports based on the Power BI & Tableau.
• Worked on Pull and Push approach to get BW models into HANA content.
• Worked on triggers to update custom tables in HANA data base.
• Worked on creating stored procedures in native HANA
• Hands on experience in creating advances objects like ADSO’s, Composite provider, exposing BW objects into as HANA Views.
• Created Info Object, DSO’s, Cube and Multi provider, Transformation, DTP’s, APDs as per the 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 the results in different sheets.
• Hands on experiencing in creating the field, start and end routines.
• Transporting the Objects from development to Quality to Production with SolMan.
• Created the ad-hoc Business Objects WEBI reports on top of existing Universe.
• Hands on experience in replicating the data from ECC system to BW system with SLT process and SDI (smart data integration), BOBJ services in to HANA.
• Replicating the table from different source from SLT landscape.
• Creating the filters at table level in SLT system to replicate data based on the business requirement.
• Hands on experience on replicating the table full load or ongoing delta in SLT system.
• Experience in monitoring the replication in SLT and coordinate with respective team on fix the issues.
• Involved in creating the documents for the objects moved to production system and the same shared with production support team.
• Had experience in pulling and pushing the data from multiple sources like SAP CRM, GTS, APO planning book and SMO in to BW.
• Had good exposure on Logistics applications (SD, MM etc.) and financial application (GL, AP, AR) in extracting the data from ECC to BW.
• Hand of experience in creating the DTP routine, start routine, end routine, filed routine in transformations with ABAP.
• Enhanced the data source in ECC with ABAP to meet the calculation for business requirement.
• Good experience in production support activities and resolving the Priority 1, 2, 3 and 4 incidents.
• Worked with Cut-over team on schedule out ages and doing the ramp-up/down activities and application checkouts.
• Involved in Pre and Post activities of BW application up-gradation happened in the production systems and performing the testing scenario’s in development and quality systems which provided by data architect.
• Experience in handling the 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 the reasons for frequent failures of jobs.
• Worked on Lean Sigma project to improve the quality of business deliveries.

Confidential

SAP BI Consultant

Responsibilities:

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

Confidential

SAP BI Consultant

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 the given logic.
• Created Info packages for Flat file loads and file names will be recognized based on routine.
• Maintaining reconciliation to verify the data in SAP R/3 and SAP BI.
• Enhanced the master data, data source and populated the data to the new fields.
• Loaded Data into the ODS Object before updating to the Info Cube.
• Developed process chains for the current data loads and for the Historical loads.
• Maintained technical design documents for the 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 the developed objects and transported to the Quality and production boxes.
• 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.
• Worked extensively in BI 7.0 Functional upgrade and tested the objects functionally.
• Worked on monitoring the data loads on daily, weekly and monthly basis in SAP BW.
• Generated Test scripts on Functional, Post and Prescripts Test Plan by using HPQC tool (Mercury tool).
• Preparing test scripts inHPQC test plan and executed the test scripts in test labs.
• Executed test scripts in HPQC tool by using CITRIX server.
• Worked on the defects which we are related to Implementation phase.
• Worked on Web Portal to execute the reports.
• Provided Knowledge transfer sessions to all the new joiners in the project about the System landscape and functionality of HPQC tool and other BI related issues.
• Daily status updates to the client.