SUMMARY

• SAP BI 7.0 and HANA Certified consultant has over 11 years of experience in SAP experience in Implementation, Support, Upgradation and SAP application development, ETL process, data modeling, reports, web application development and Dash board designing.
• Experienced in two Full life cycle Implementations, Support and Upgrading BW 7.0 to BW 7.3 and HANA Implementation, BO and ABAP.
• Highly motivated, energetic, individual and a team player with good communication and interpersonal skills
• Excellent communication skills, systematic approach and ability to work effectively in fast paced environments Interpersonal, managerial skills and self - motivated to work independently and as well as in a team. Good Understanding of both business processes and technical development.
• Experienced in BI7 implementations and Integrated planning (IP), WAD and knowledge on BIA,BO/BOXI and BPC.
• Knowledge on Lumera.
• Experienced in BW 7.30 on HANA with Analysis Office 1.3

TECHNICAL SKILLS

HANA Skills: Working experience on HANA modeling studio, Publishing BW models into HANA studio, set up ETL process and data loading to HANA tables, table creation, Importing flat files data to HANA, experience in creating attribute view, Analytical view and Calculation view, Calculation measures, transporting, Knowledge on HANA SQL scripting, procedures, schema creation, SLT configuration, data services and DXC.

SAP BW Skills: DSO, Cube, Info object creation, Transformation and Data loading into BI system (Flat file &R/3), Master data loading from Flat File, Transaction Data Loading from Flat File to Info cube and DSO Configuration, Business content Extractors, Logistics Extraction, Generic Extraction, Enhancing Standard Data Sources, Open Hub Destination, Reporting Performances, Line-Item dimension, High cordiality dimension, Process chain monitoring, data transfer processes, Query Design: Defining Exceptions, Conditions, Restricted and Calculated Key Figures, various types Variables, query Properties, Converting Cube and DSO to In memory optimized, Semantic partitions, composite provider.

BODS Skills: Repository creation, flat files, configuring data store, data flow, Query transform various transforms, debugging and data base loading, transformations, scripting, delta handling (source, time stamp and target based CDC), various recovery mechanisms, implemented push down operations and performance optimization.

PROFESSIONAL EXPERIENCE

Confidential

Consultant

Responsibilities:

• Requirement gathering & requirement analysis.
• Manual Testing of interfaces between SAP ECC, POS - POSDTA, E2E & Regression testing with other downstream and upstream applications
• Responsible for Test plan creation and Test design analyzing the requirements
• Test execution based on the Test plan devised
• Preparation of QA summary for Go/No Go meetings
• Preparation of daily/weekly status reports to onshore coordinator and client Sponsor
• Creating and updating defects status in JIRA
• Resolved Critical and High priority defects during the Integration Test while UAT.
• Extencevely worked on FERC module.
• Preparation of Technical Design Specification documentation.
• Modeling & development of BW objects like info objects, DSO’s, Infocube’s & Multiprovider.
• BEx Query designing using Query designer which involved creation of Structures, Calculated key figures, restricted key figures, Variables, customer exits etc.
• Development of UDT universes on top of SAP BW BEx queries.
• Development of BO4.0 WEB Intelligence reports which included creation of various types of reports like vertical/Cross-tabs, different types of graphs, Query prompts, Query filters, report filters, input controls, Sections, scheduling, publications, complex formulas, merging different types of source like universes/BEx etc.
• Development of BO4.0 Dashboards on top of webi using BIWS.
• Involved in Unit testing, integration testing, performance tuning of reports & User Acceptance testing.
• Working with TCoE team and Assisted in Performance testing.
• Involved in bug fixes during UAT & Post production stabilization.
• Created User Training materials on BO4.0 webi.
• Working on Data loads optimization and improve the load performance.
• Trained around 80+ Business users on BO4.0 webi like thought them on using webi tool & customization of reports & developing ad-hoc reporting.
• Co-ordination with various teams like Basis, Security, BO Admins, IT team etc.
• Working with Onsite-Offshore team and measure to deliver the things on time.
• Key member in Production support team and handling with Incidents/Work orders /FINANCE On call.

Confidential

Consultant

Responsibilities:

• Leading the offshore BI team of members and responsible for the deliverables in BI.
• Played as Key technical resource in BI and resolved the major technical issues while build, defects and transports.
• Data Modeling: Creation of Info Areas, Info Object Catalogs, Info Objects - Characteristics and Key Figures, ODS, Info Cubes, Multi Providers.
• Transformation and Loading (ETL): Creation of Data Flow, i.e., Transformations andData Transfer Processes, Data sources, Info Sources, Info Packages, Creation ofProcess Chains, Analysis and Resolution of errors arising due to data loads, etc.Management of Data Targets, Maintenance of Process Chains.
• Involved in resolving performance tuning & memory management issues.
• Project Documentation: Project related Documentation such as TechnicalSpecifications, End User Training Documents, cut over plans, etc.
• Monitor the data loads from various source systems like R/3, CRM, and SEM APOby means of process chains.
• Monitoring process chains and scheduling jobs.
• Incident Handling.
• Extensively Worked on SAP BW HANA views.
• Involved in SAP HANA upgrade Testing.

Confidential

Consultant

Responsibilities:

• Played as Key technical resource in BI and resolved the major technical issues while build, defects and transports.
• Involved in Cutover activities and issues fixing during go-live.
• Good Understanding of various components of SAP HANA.
• Performed regression testing and issue fixing during UAT.
• Executing post migration programs related HANA Database.
• Loading data from flat file to HANA system.
• Publishing BW models into HANA modeling studio.
• Designed TDs for the RFCs’ and do peer review of the Objects done by others within the team.
• Attending the high level business meeting for understanding the third party systems like FiT, VOLT etc.
• Identify the non-sap reports for automation.
• Involved in deep drive sessions for requirement gathering with business users.
• Prepared and approved BRDs from Mondelz team.

Confidential

Consultant

Responsibilities:

• Played as Key technical resource in BI and resolved the major technical issues while build, defects and transports
• Generated BO Web Intelligence reports using BI Launch pad. Involved in testing Universes and Reports.
• Designed Dashboards on top of Web Intelligence reports
• Resolved Critical and High priority defects during the Integration Test while SIT
• Created and used Local selections and Local formulas, Structures in the query build.
• Involved in the business meetings and getting the requirements for legacy systems like CMIS, AGRIES, JDE World, KAW, Sprit wood etc.
• Worked on FTM, Vistex,E-source and Tax Reports.
• Performed regression testing and issue fixing during UAT.
• Extensively worked on Production cutover.

Confidential

Consultant

Responsibilities:

• Leading the offshore BI team of 8 team members and responsible for the deliverables in BI.
• Developed Analytical Report using SAP BO AO (Office 2010-Excel) for A/P Inquiry data by inserting multiple crosstabs in a workbook with data from different sources. combining local Excel data with corporate data
• Conversion: Converting BEx workbooks to AO
• BW Integration: Activating/deactivating BEx conditions
• Modeling Planning Applications using SAP BI Integrated Planning (IP). Created Web Planning Layouts in BI-IP using Input Ready Query and Web Application Designer.
• Experience in the planning and simulation modules (SEM) PS and IP such as Sales Planning, Cost Center Planning, and Forecasting and Balance Scorecard with integration of SEM with BW Resolution of BW problems relating to data load and mismatch of data.
• Developed real time Info cubes for IP Planning.
• Configured and involved in troubleshooting custom IP applications using the BEx toolset including BEx Query Designer, BEx Analyzer, and BEx Web Application Designer.
• Environment: SAP R/3 5.0, BI 7.0 and Integrated Planning (IP), Fox Formulas, Sql Server, BEx Query Designer, WAD and BEx Analyzer.
• Implemented FI, SD, and HR modules with HR Structural authorizations in BI 7.0.
• Designed TDs for the RFCs’ and do peer review of the Objects done by others within the team.
• Played as Key technical resource in BI and resolved the major technical issues while build, defects and transports.
• Resolved Critical and High priority defects during the Integration Test while UAT.
• Performed housekeeping activities to improve the Data load and Reporting performance.
• Generated BO Web Intelligence reports using BI Launch pad. Involved in testing Universes and Reports.
• Designed Dashboards on top of Web Intelligence reports
• Involved in Management activities like, capacity planning, time sheet management, Metrics - prepared management metrics reports.
• Continuously communicated with client team via Call/Mail/ Lync for better deliverables on time.
• Good Understanding of various components of SAP HANA.
• Performed regression testing and issue fixing during UAT.
• Executing post migration programs related HANA Database.
• Loading data from flat file to HANA system.
• Publishing BW models into HANA modeling studio.
• Involved in Cutover activities and issues fixing during go-live.
• Designed DS objects to load the data from SQL data base to HANA system
• Worked on SLT schema configuration to set up data loading.
• Migrated HANA content from development, testing environment to Production environment using delivery units.

Confidential

Consultant

Responsibilities:

• Participated in requirement Gathering meetings.
• Hands-on configuration experience with SAP IS Retail - MM and SD modules
• Given several presentations to the client about the clarifications and possibilities of BW reports.
• Creation of detailed functional specifications.
• Extensively worked on report and analysis design, BEx Query development, validation and reconciliation activities.
• Created Fit-Gap analysis based on the existing queries and proposed queries to be merged with the help of different tools available in GE.
• As part of consolidation, Identifying queries to be Merged and sending the detailed analysis to the user for the approval.
• Created web-templates to integrate IP functions and sequences.
• Created webdynpro application to use IP file upload functionality
• Extensively involved in developing BEx Queries in different areas.
• Have involved in reconciliation of the queries using advanced excel.
• Created RKF's and CKF's according to the LSA guidelines.
• Created and used different types of variables with different options as required.
• Created formula variables whenever required.
• Involved in developing the code for the Customer exit variables with the help of ABAP consultant.
• Created and used Local selections and Local formulas, Structures in the query build.
• Used Cell definitions, Exceptions and Conditions in the query build.
• Involved in screening activities of the queries.
• Preparing the test plan to execute the queries.
• Preparing a detailed document with of the query screening.
• Completely involved in Unit testing.