Sap Bw/bi​ Resume
PROFILE SUMMARY:
- 10 Years of experience in SAP BW/BI,BO,HANA & TABLEAU with strong SAP project management, delivery and consulting experience, which includes:
- 6 implementations in BI/BW and multiple support engagement experiences.
- 1 SAP BO Implementations - 4.x.
- 1 SAP BW/HANA engagement - Implement/Enhance/Support/Migration Exp.
- 1 SAP BW-IPAK (HANA) Migration from IP.
- Worked at different prospects from a Developer/Architect/Project/Delivery /Solution Architect, Requirement gathering meetings, Functional to Tech spec conversion.
- Strong ABAP experience in BI Routines, customer exits and function modules.
- Expertise in Change management(SOLMAN) / BW Incident Management(REMEDY).
- SAP Design Studio/Lumira Development Deployment/Training/Support experience.
- 1 engagement with SAP in BPC/EPM 10.
- Knowledge in Qliksense/Qlikview
- ECC/R3Techno Functional experience include ABAP developments in
TECHNICAL SKILLS
Data Warehousing: BW 7.4, BW 7.3, BI 7.0, BW 3.5, SAP HANA SPS 10,13 and SAP BPC,SAP Net weaver.
ERP: SAP R/34.6 C,4.7, ECC 6.0
Functional Modules: SD, MM, QM,HR, FI, IP,CRM
Data Replication, ETL: SAP BODS 4.x and SLT.
Reporting Tools: Tableau, Web Intelligence (Webi),Dashboard (Xcelsius),BEx Query Designer,BEx Analyzer, SAP Lumira, Analysis Office
Programming: ABAP, C,C++, PL/SQL, HANA SQL,JAVA,VB,FOX
Databases: SAP HANA, Oracle 10g/9i/8iOperating Systems Windows NT/2000/XP/7, Windows Server 2008, Unix, Linux
Project Methodologies: ASAP, Agile/Scrum
PROFESSIONAL EXPERIENCE
Confidential
SAP BW/BIEnvironment: SAP ECC 6.0, SAP-BI 7.4. BOBJ(Webi,Xcelsius,Crystal Reports)Role: Package Solution Consultant SAP BW/ABAP.
Responsibilities:
- Gathering detailed requirements, understanding business process by scheduling meetings with users.
- Managed, and monitored several Process Chains, captured the errors, and corrected bugs by applying several OSS notes.
- Developed and enhanced many BW applications includes Info cube design, DSO developments (write optimized),Lookups, data sources, MD enhancement..etc.
- Handled the weekly client calls and updating the business about the status of the issues.
- Always provided first time right solutions to the client by performing extensive testing for newly developed objects.
- Involved in the process of migration of the queries from 3X to 7X
- Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
- Analysis of system requirements/applications for HANA upgrade.
- Maintain Work History for all the tickets until it is closed down.
- Designed new Bex reports YTD,MTD (variables/customer exits, CKF,RKFs) based on business requirements.
- Implementation of BPC reports, transferring BPC functional requirements into technical and schedule data loads fro BPC.
Confidential
Environment: SAP ECC 6.0, SAP-BI 7.4, HANA. BOBJ(Webi,Xcelsius,Crystal Reports)Role: Sr SAP BW/HANA/BO Consultant.
Responsibilities:
- Handling the escalations from the client.
- Preparing an action plan for data recovery in various data flows.
- To ensure that the deliverables are within SLA and broadcasting the same through dashboards for management
- Tested all enterprise applications using HP Quality Center tool during SAP HANA Migration.
- Performance analysis by comparing pre and post migration runs time and presented to management.
- expertise in SAP Lumira and Tableau developments.
- HANA Data Modeling - Analytic, Attribute and Calculation Views, Decision tables .HANA Design Studio, Joins, SQL Scripting,
- Delivery Units, Data Provisioning Direct Extractor Connection, SAP LT,BODSSAP BW on HANA platform
- Managed System Landscape preparation with Basis team.
- Followed SAP BW on HANA RDS for migration activities step by step - SAP recommended.
- System Copy - BW on HANA migration project planning.
- Created data models using Calculation views and using SQL Scripts to replace ABAP programs.
- Interacting with Functional and Business users to understand business requirements and good in translation of Functional Business requirements into very clear Technical specifications and then delivering solutions back to the Business.
- Prepare technical specifications and assign them to development coordinators to get the development done from offshore.
- SAP BW-IPAK to HANA migration.
- Responsible for Design, Development, Construction and Testing of a reporting solutions.
- Liaison with onshore and offshore team in assessing the pros-cons while developing the BW designs.
Confidential
Environment: SAP ECC 6.0, SAP-BI 7.4. BOBJ(Webi,Xcelsius,Crystal Reports) Sr SAP BW/HANA/BO Consultant.
Responsibilities:
- As part of technical upgrade, Supported BASIS team during the Post Refresh and pre-upgrade activities of the Development, Quality and Production Environments
- Manually Migrated BW applications. data flows from 3.x to 7.0.
- BW developments, enhancements, MD enhancements, transformations,Infocube design and Multiprovder .
- Worked on WAD 7.4 for creation of Dashboards with web items like tabs, charts, tables etc.,
- As part of technical upgrade, Supported BASIS team during the Post & Pre Refresh .
- Involved in activities like deleting temporary tables, ensuring up to date DB statistics, checking for the inactive objects and re-scheduling loads/process chains
- Post upgrade activities like activation of source systems, checking the Info Sources, activating transfer structures, re-scheduling loads and process chains and addressing issues in log file
- Involved in preparing Test Plans, Test Cases, and Upgrade cutover plan
- Strong experience in data flow migration from BW 3.5 to 7.0
- Design and developed Dashboards (Xcelsius) with HTML5 front end integration which will be browser friendly.
- Extracted Data from 3rd Party system using DB Connect.
- Created Custom Cubes, ODS Objects, APDs and Broadcast jobs verified the same for the data consistency.
- Participated in Qilk View /qilk sense implementation.
- Developed Start routines, Field routines and End Routines using ABAP to incorporate Business logic and perform data manipulation.
- Activity: Receiving and analyzing trouble tickets and change requests related to BW developments /Enhancements.
- Preparing test plans and performing informal and formal testing.
- Implementing the BW solutions and documentation.
- Finalizing appropriate solutions and documenting test plan/results.
- BW Transport management/change management.
- Interaction with responsible persons for development and approval including preparation of Functional Specifications.
Confidential
Environment: ECC 6.0, SAP BI (7.0)
SAP BW/ABAP Consultant.
Responsibilities:
- Process chain monitoring, receiving and resolving support issues incidents.
- Responsible for all support related activities/year end activities/changes/fix issues.
- Analyzing and converting issues into developments if required enhancements.
- Involved in full life-cycle implementation for Techno-functional activities.
- Master Data upload and related activities.
- Data extraction from legacy systems (Master& Transactional).
- Defining Source systems for data integration and consulting with relevant functional areas.
- Database Administration & Back-ups.
- Monitoring daily, weekly and Monthly loads.
- Responsible for data load failures/ incidents/cut over activities.
- Reconciliation of monthly data loads after period end closures.
- Handling the user related tickets (P2/P3/P4).
- Set up procedure for extracting R/3 data for Customers, Sales Order, Delivery, Shipping, Billing Document in Sales and Distribution using LO-Cockpit.
- Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
