Sap Bw Consultant Resume
2.00/5 (Submit Your Rating)
NY
PROFESSIONAL SUMMARY:
- More than fourteen years of IT experience in Analysis, Technical Design, Development, Testing and Documentation including ten years of BI experience and more thanfour yearsof programming experiencein Application development.
- Good functional knowledge of SCM, SD, MM and FI modules.
- Having good experience as Business Analyst - Requirements gathering, Business requirements writing, Use Case development, and Analysis & Organizational skills.
- Excellent analytical and logical skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
- Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the Software Development Life cycle.
- Good communication skills, interpersonal skills, self-motivated, quick learner.
- Very good experience of SAP BW Components like Info Cubes, DSO, Multiprovider, Info Source, Info Objects, & Transformation.
- Expertise in Data Modeling, Activity Diagrams, ETL, Business Objects, Data warehousing, SQL, Extended Star Schema, Data slice, Requirements Gathering.
- Expertise in performance tuning of BW systems. Evaluated statistical performance and improved data load performance, query performance by compression of InfoCubes, creating aggregates etc.
- Undergone complete life cycle implementation of BW, which includes Data-Modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring, LO Cockpit, CO-PA and BEx Query.
- Used Delta Update process for loading the data to BW from R/3 in specific intervals.
- Experience in Report Generation in BEX Analyzer in building Queries and saving in Workbooks (Excel work sheets) and created Custom Queries using Conditions, Exceptions, Variables & Structures and created Aggregates for frequently used Queries.
- Excellent production support skills including data loads, reporting related Issues.
- Extensively involved in production support, expertise in process chains monitoring and resolving the support tickets.
- Good understanding of OLAP concepts and OLAP database environments.
- Unit, integration, performance testing and Participated in design reviews.
- Experience in connecting legacy system/Non-SAP System via DB connect, and pulling data in SAP-BI system.
- Experience in Stored procedures and writing SQL scripting in SQL server 2014.
- Experience of BOBJ tools like Crystal Report, Dashboard, Web Intelligence, Information design tool, Explorer, Design studio.
- Good understanding of creating BW on Hana database.
TECHNICAL SKILLS:
Business Intelligence: SAP BW 7.0, 7.3, 7.4 BO 4.0
ERP: SAP R/3 and SAP ECC 6.0
Reporting: BEx Report Designer, Web Application Designer (WAD), BEx Web Analyzer, BEx Analyzer, Dashboard, Crystal Report, Webi, MS Excel
Modeling tools: SAP HANA, SAP NetWeaver BW
Languages: ABAP, SQL
Database: SQL Server 2012/2014, SAP HANA
PROFESSIONAL EXPERIENCE:
Confidential, NY
SAP BW Consultant
Responsibilities:
- Monitored, troubleshoot and resolve system issues, determine root cause analysis.
- Involved in architecture level support for existing and new reports.
- Implemented SCM BW reports for Delivery Assurance, Supplier category and Material Performance.
- Created technical specification documents.
- Created financial report for the variance on GL detail and GL summary.
- Implemented new monthly Budget & Plan reports in Investment Management (IM).
- Provided support to end users after go-live.
- Written Badi methods in ABAP to move the data for newly included field in the extractor in ECC.
- Debugged, tested data models for unit and integration testing.
- Maintained all support documentation in accordance with Brion standards requirements.
- Involved in escalating high-prioritized tickets regarding extractions, performances issues and load failures.
- Interacted with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
- Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.
- Analyze and coordinate efforts in transforming business requirements into cost-effective solutions.
- Experience in creating universes using information design tool 4.0 and also connecting to multiple data sources.
- Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects.
- Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).
- Developed WEBI reports on Webi Rich client.
- Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
- Implemented on data staging process for BPC 10.0 project.
- Involved in creating architecture for GL cube.
- Implemented process chain to upload the delta to staging cube
- Worked with client to give more summarized data on the staging cube.
- Written transformations and Badi methods in ABAP.
Confidential
SAP BI Analyst
Responsibilities:
- Monitored data loads (Flat file, R/3) on daily basis and effectively handled many extraction errors during data load.
- Effectively handled Flat file and master data loading to the DSO's and Cubes.
- Handled effectively the change requests for the DSO's and Cubes and queries.
- Worked on creating transport requests and Releasing to the test and production servers.
- Resolved many issues that came in production support.
- Extensively used BEx Analyzer and Query Designer for building Queries.
- Created the process Chains and automated the load process based on the business needs.
- Review of Functional Requirements, identify gaps and recommend/suggest changes.
- Involved in developing the DSO, Cubes, Web Templates, Bex Reports and other BI objects.
- Worked on job schedules for loading data and monitoring Process Chains to run periodic loads and other processes.
- Involved in escalating high-prioritized tickets regarding extractions, performances issues and also load failures.
- Involved in fixing Delta load failure while extracting data from R/3 to BW.
- Performed periodic cleanup in PSA. Extracted and loaded data from SAP R/3 into Sales Order InfoCube using Data Sources.
Confidential
Engineer -Software Development
Responsibilities:
- Supported and monitor data warehouse batch schedule, information access, reporting and analytics service performance
- Analysis, writing Functional and Technical specification, Visio flow diagrams.
- Prepared reports, manuals and other documentations on the status, operation and maintenance of software.
- Involved in fixing data load failure while extracting data from R/3 to BW.
- Involved in ETL process, process chain.
Confidential
Programmer
Responsibilities:
- Involved in gathering the requirements and creation of functional specifications and solution design document.
- Build objects in BW Administrative Workbench adhering to the naming conventions and guide-lines set for the project.
- Worked in data extraction - enhanced COPA Data source to extract additional fields required for reporting.
- Wrote ABAP Code for transformation routines and Customer Exit variables in BI.
- Enhanced Sales analysis report with new logic for analysis on different variances. It also included data model change to populate the new fields.
- Prepared reports, manuals and other documentations on the status, operation and maintenance of software.
- Developed a new consolidated Profit & Loss report at group and country level to analyze Measure hierarchy based on reportable and non-reportable materials. It also has an impact analysis of different currencies on different levels of profitability.
- Involved in transportation of objects, data validation, User acceptance testing and documentation.
Confidential
Trainee Software Engineer
Responsibilities:
- Involved in Analysis of the functional modules.
- Involved in Data Modeling, Extraction and loading.
- Created Data modeling flow on Visio.
- Analyzed Production Support Calls.
- Development of Sales Summary Report and Inventory balances Report.
- Data Reconciliation between EIS report output.
- Prepared reports, manuals and other documentations on the status, operation and maintenance of software.