We provide IT Staff Augmentation Services!

Data Analyst Lead - Sap Bw/bpc Resume

Elk Grove Village, IllinoiS

SUMMARY:

  • I am working as a Senior Consultant and I have an overall IT experience of 10 years, which includes strong SAP implementation, Post implementation, Support & Integration experience and having good technical knowledge with SAP BW - ABAP, SAP BPC, SAP HANA and SAP BO. I have a good understanding of SAP Functional Areas i.e. SD, HR, Treasury, T&E, ISU,MM, PS, QM, Handling Unit, WHM, FI, CO.
  • 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.
  • Involved in Creation of functional specs for consolidation and Planning.
  • Extensive experience in Implementation of BPC 10.1 requirement gathering, Design, Migrations, Implementation, Go-Live, UAT, SIT, Testing and Post Go-Live support
  • Implementation, Go-Live, UAT, SIT, Testing and Post Go-Live support
  • Involved in solution design for BW-BPC system.
  • Created Finance flow for BPC consolidation.
  • Involved in Transports and peer reviews, Unit Testing.
  • Created financial report for Consolidation
  • Created Drill down reports.
  • Reviewing Technical objects.
  • Reporting projects statuses and team progress to managers and leadership.
  • Involved in developments of objects related to SAP BPC
  • Created financial reports.
  • Worked on script logics.
  • Worked on security, work status, Business Process Flows.
  • Involved in full End to End consolidation cycle.
  • Proficient in creating business rules and script logics as per requirement.
  • Worked on Consolidation Business Rules & logic, such as
  • Created DM packages to integrate load from BW-BPC and Flat file-BPC.
  • Responsible for end-to-end delivery and maintenance of SAP BPC Consolidation & Planning applications
  • Translate business requirements into functional / technical specification documents
  • Design and define SAP BPC dimensions and models based on requirements
  • Transforming data from different sources like SAP ECC, Flat File to fit into financial reporting model in SAP BPC
  • Report Development, Input Schedules, Data Manager Packages, Dimension Formulas, Script and Business Rules Performance Tuning, Maintenance and Support.
  • Develop automatic process to load Data into SAP BPC using Data Manager Packages
  • Program calculation using Scripts, Business Rules and member formulas
  • Build, develop and test financial SAP BPC reports
  • Conduct Unit Testing for BPC Planning & Consolidation objects after development to ensure development as per requirement
  • Manage the defect process for designed application
  • Move tested and approved SAP BPC application to production system
  • Coordinate with the India Development Team for smooth on time delivery of Objects
  • Plan team resourcing to effectively and efficiently deliver work
  • Prioritize objects being delivered as per the plan and given timelines
  • Fixing defects as per their priority
  • Worked on AO reports.
  • Build and lead team members to build proof of concepts
  • Architect the solution for the business requirement provided
  • Track and report on project metrics as part of quality process
  • Conduct End-User training as needed
  • Worked on SAP BPC MS 10.1 on POC for Oil & Gas and won the project to implement with offshore team.
  • Working Knowledge on BPC 10.1 and 11.0 Embedded.
  • Involved in full End to End implementation cycle.
  • Created Datasource based on Function Modules, Tables and views on R/3 side.
  • Created InfoSources, Transfer Rules and Transfer routines.
  • Creation of required Info Objects.
  • Created Data Transfer Process and Info Packages.
  • Created Data Targets (Infocubes, DSO, MultiProviders).
  • Created Update rules if required.
  • Created Queries/Views/Web templates.
  • Created all the objects pertaining to requirement.
  • Created customer exit variables as per as requirements in reports.
  • Created process chains for loading the Data.
  • Worked extensively customized Info Objects, Composite Providers,ADSO, Info Sources and Info Cubes, ODS/DSO.
  • Worked on Aggregation levels, filters, Planning functions.
  • Data loads from flat files to InfoProviders as required.
  • Enhanced the Data sources as per the requirement and using the enhancement RSAP0001 to fill the data into enhanced fields.
  • Created user entry, customer exit variable, and written code in CMOD for Customer exit reporting variables in BW side.
  • Worked on BW-ABAP.
  • Worked on BI-IP projects.
  • Worked on BO report developments.
  • Worked on Infoview, WEBI and universe designer.
  • Involved in Technical spec creation and review
  • Expert in HANA views and ADSO planning DSO and Local Provider.
  • Worked on BW4HANA project.

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.

SAP EXPERIENCE:

Confidential, Elk grove village, Illinois

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, Houston

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, Houston

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:
  • Worked on Security concepts, Teams, Task Profiles, Data Access Profiles
  • Worked on Extraction of master and transactional data from BW to BPC with DM packages.
  • Worked on cost center planning, Profit center planning, Sales planning.
  • Involved in End user trainings.
  • Reviewing Technical objects.
  • Reporting projects statuses and team progress to managers.
  • Support integration testing and UAT phase.

Confidential, Houston

Senior Consultant: SAP BI-BPC Lead

Environment: SAP BPC 10.1, SAP BW 7.3

Responsibilities:

  • Created Functional Specs for Consolidation and Sales Revenue planning.
  • Part of Technical System Specification reviews.
  • Involved in EDW field Mapping.
  • Involved in Gap-Analysis
  • Involved in BW objects and Report development.
  • Involved in BI requirement Technical specification Review.
  • Created Dimensions and models as per requirement.
  • Created Financial Reports.
  • Worked on Script Logic and Business rules.
  • Worked on work status and security.
  • Configure data manager extraction from ECC and BI system for the actual data.
  • Created packages and Configured BPF.
  • Created conversion, transformation files for the data management process.
  • As IS and To-Be documents preparation and review with BRM / business
  • Hands on development of data model for the various functional requirements by implementing queries and cubes using standard business content (e.g., BW Statistics)
  • As IS and To-Be documents preparation and review with business
  • Business content activation, Customization, data model development
  • BW lead for the development and maintenance
  • 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.
  • Involved in Transports and peer reviews, Unit Testing.
  • Reviewing Technical objects.
  • Configures Consolidation related business rules and Script logics.
  • Reporting projects statuses and team progress to managers.
  • Support integration testing and UAT phase.
  • Translate business requirements into technical specification documents
  • Develop automatic process to load Data into SAP BPC using Data Manager Packages
  • Manage the defect process for designed application
  • Coordinate with the India Development Team for smooth on time delivery of Objects
  • Plan team resourcing to effectively and efficiently deliver work
  • Prioritize objects being delivered as per the plan and given timelines
  • Fixing defects as per their priority
  • Build and lead team members to build proof of concepts
  • Architect the solution for the business requirement provided
  • Track and report on project metrics as part of quality process
  • Conduct End-User training as needed

Confidential, Provo

Senior Consultant: SAP BW-BPC Analyst

Environment: SAP BPC 10.0, SAP BW 7.3

Responsibilities:

  • Created Functional Specs for Consolidation.
  • As IS and To-Be documents preparation and review with BRM / business
  • Part of Technical System Specification reviews.
  • Involved in EDW field Mapping.
  • Involved in Gap-Analysis
  • Involved in BW objects and Report development.
  • Managing team size of 8.
  • Involved in BI requirement Technical specification Review.
  • Created Dimensions and models as per requirement.
  • Created Financial and Management Reports.
  • Worked on Consolidation Script Logic and Business rules.
  • Worked on work status and security.
  • Configure data manager extraction from ECC and BI system for the actual data.
  • Created packages and Configured BPF.
  • Created conversion, transformation files for the data management process.

Confidential, Nashville

Senior Consultant - SAP BI-BPC Lead

Environment: SAP BPC 10.0, SAP BW 7.3

Responsibilities:

  • Part of Technical System Specification reviews.
  • Involved in EDW field Mapping.
  • Involved in Gap-Analysis
  • Involved in BW objects and Report development.
  • Worked on BW-HR reports.
  • Implemented CO-PA.
  • Created BI reports.
  • Worked on Routines.
  • Designed and Created Process chains.
  • Involved in creation of transformations (field Routine, Start Routine & End Routine), Info packages and Data transfer process.
  • Worked on Data Source Enhancement.
  • Transportation of BW data flow from Dev. to QA and then to Prod.
  • Created Dimensions and models as per requirement.
  • Created Reports.
  • Worked on Script Logic and Business rules.
  • Configure data manager extraction from ECC and BI system for the actual data.
  • Created packages and Configured BPF.
  • Created conversion, transformation files for the data management process.
  • Master data maintained.
  • Loading the data from SAP R/3 BI SAP BPC by using DM Packages
  • Provided technical support to client.
  • Extensively trained the client on Data manager Packages, Conversion and Transformation Files, Environments, Models, Dimensions, Dimension members, Properties, Hierarchies, Functionality of Data manager, Optimization process and BPC Front end such as BPC for Excel and BPC WEB.

Hire Now