Data Analyst Lead - Sap Bw/bpc Resume
SUMMARY
- Has extensively worked with Accelerated SAP Methodology implementations.
- Involved in five full life cycle implementations in SAP BI and five full life cycle implementations in SAP BPC.
- Extensively worked on different domains like sales & distribution, Material management and Finance.
- Experienced in Data Extraction from SAP ECC (SD, MM, Treasury, Travel& Expenses, GRC, HR, PS, ISU, QM, Handling Unit and FI/CO), SAP BP, SAP BS and flat files using different extraction structures.
- Experience with BW data modeling, Business Warehouse Remote Cubes, Multi - Cubes, ODS Objects, Info Cubes, Transfer Rules, ABAP, Start Routines, End Routines, Info Set Queries, Info Objects and User Exits.
- Support end-users with basic BW/BEx reporting/security inquiries and issues
- Collaborate proactively team members to gather business requirements and provide solutions for SAP BW/BPC
- Extensive working experience on SAP BPC components including development, data managers and EPM report writing.
- Ongoing support of the existing SAP BW/BPC system per the business service level agreements
- Create Queries and Workbooks using SAP BEx Analyzer and Analysis for Office
- Troubleshoot and resolve technical issues including debugging, tuning and optimizing report performance
- Responsible for knowledge transfer and technical support of SAP BW and SAP BPC Solutions and Reports
- Responsible for the development and unit testing including documenting the results
- Prepares comprehensive technical design documentation required per methodology for all technical solutions.
- Responsible for developing custom code using FOX (Formula Extension) component
- Validates the data warehouse feeds, ensuring all data is current and complete.
- Monitors queries and reports behavior to ensure performance expectations are met.
- Experience with SAP BW development using SAP R/3 data sources, non-SAP data sources, BW business content and extensions, custom content, and flat-file loading.
- Involved in creating Functional and Technical Spec design.
- Involved in End user training.
- Involved in Lean Methodology.
TECHNICAL SKILLS
Data Warehouse: SAP BI 7.0, SAP BW 7.4,SAP BW4HANA, SAP S4HANA- BPC optimized, SAP BO, SAP BPC 10.1 NW/Embedded, SAP BPC 11.0 NW/Embedded
ERP: SAP ECC 6.0, R/3 4.6C, 4.7EE
Reporting Tools: BEx Reporting Designer, Analyzer, Webi, Infoview, Universe Designer, EPM reporting, SAP Design Studio, SAP Lumira
Operating Systems: Windows 95/98/2000/XP and Windows/NT
RDBMS: MS-Access and ORACLE 8i.
PROFESSIONAL EXPERIENCE
Confidential
Data Analyst Lead - SAP BW/BPC
Environment: SAP BPC 10.1 on HANA, SAP BW 7.4, Analysis for Office, SAP BO,SAP Lumira
Responsibilities:
- Mapping Business requirements
- GAP Analysis
- Part of Technical System Specification reviews.
- Involved in EDW field Mapping.
- Involved in BW objects and Report development.
- Business blueprints and workshops
- Application design and architecture
- Delivered Cost center, Profit center planning and Sales Volume- Fuel Planning.
- Working on Headcount Planning.
- Managing team of 6 resources.
- Created functional and technical specs for BPC and BW.
- Delivering the project against the agreed Project Charter and to client satisfaction
- Managing the project risks, issues and dependencies, and corresponding action plans
- Producing the project plan, specifying resources required, and identifying proposed resources
- Motivating team members on a continuous basis
- Assessing team member’s performance against their objectives on a regular basis
- Prototyping, design and data Modeling
- Worked on Composite providers, Advanced DSO and Hana Studio.
- Ensuring overall delivery and quality of the project work
- Worked on ABAP-BADIs for BPC/BW.
- Built financial planning reports.
- Developed Bex reports.
- Worked on BOBJ Reports.
- Worked on Analysis Office Reports and SAP Lumira.
Confidential
Data Analyst Lead- SAP BW/BPC
Environment: SAP BPC 10.1 on HANA, SAP BW 7.4
Responsibilities:
- Handled the tickets of priority 1, 2 and 3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
- As IS and To-Be documents preparation and review with business
- Involving in solving Customer Issues with in SLA (Service Level Agreement).
- Incidents / Problem / Change tickets management, Management of change requests
- Managing BW support as well as minor / major enhancements (SOW Preparation)
- Managing team of 4 resources
- Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis
- Worked on CR’s.
- Worked on month end closing activities.
- Monitoring of data loads.
- Raising tickets to other resolution groups regarding performance of the system and data loads.
- Design and develop reports and input schedules, develop custom interfaces
- Build reports as per the requirement from client.
- As IS and To-Be documents preparation and review with business
- IS-Retail Business content activation, Customization, data model development
- BW lead for the development and maintenance (including 24x7 production support model)
- Requirement gathering from business users in Sales and Purchasing Functional / Technical specification preparation
- Defined work packages and technical specifications for design, development, testing and roll-out
- Prototyping, design and data Modeling
- Analyzed SAP BW data volume and system performance requirement and methods to improve the performance considering the SLA. Proposed and implemented customer service improvement plan
- Hands on development of data model for the various functional requirements by implementing queries and cubes using standard business content (e.g., BW Statistics)
- Involved in technical spec creation and review of SAP BW.
Confidential
Senior Consultant: SAP BW-BPC Lead
Environment: SAP BPC 10.1 on HANA, SAP BW 7.4, SAP BO, Remedy on Demand
Responsibilities:
- Leading the offshore BPC and BW technical team.
- Build, develop and test financial SAP BPC reports
- Handled the tickets of priority 1, 2 and 3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
- Involving in solving Customer Issues with in SLA (Service Level Agreement).
- Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis
- Worked on CR’s.
- Worked on Consolidation month end closing activities.
- Monitoring of data loads.
- Worked on BW objects.
- Raising tickets to other resolution groups regarding performance of the system and data loads.
- Build reports as per the requirement from client.
Confidential
Senior Consultant: SAP BW-BPC Lead
Environment: SAP BPC 10.1 on HANA, SAP BW 7.4
Responsibilities:
- Leading the offshore Functional and technical team and coordinating the BW and BPC team.
- Created Functional Specs for Consolidation and Planning.
- Involved in post-installation sanity check on BPC system.
- Involved in technical spec creation and review.
- Involved in solution design for BW-BPC system.
- Created Finance flow for BPC consolidation.
- Involved in post-installation sanity check on BPC system.
- Involved in Transports and peer reviews, Unit Testing.
- Created financial report for Consolidation
- Build input forms/reports based on requirements.
- Configures Consolidation related business rules such as:
