We provide IT Staff Augmentation Services!

Sr. Sap Bw Consultant Resume

Harrisburg, PA

SUMMARY

Over 14 years experience in the IT industry, with over 12 years diversified experience in SAP BI/BW with an emphasis on analysis, design and development of business applications in SAP environment.

  • Played a key role in Business Requirement Gathering & Analysis, Design, Application Integration, Development and Testing. Successfully customized modules based on business needs and requirements
  • Actively participated in Joint Application Development and significantly contributed to user interaction among the technical and business management teams
  • Expertise in Business Warehouse Components Extractors, InfoObjects, InfoSources, ODS/DSO Objects, InfoCubes, Update Rules, Transfer Rules Transformation, DTP and InfoPackages
  • Expertise working with SAP BW Administrator Workbench and SAP BI Data Warehousing Workbench.
  • Technical - Functional consultant, proficient in customization and implementation of SAP BI/BW in versions (3.1C / 3.5 / 7.3 / NetWeaver 2004/2004s, R/3 (4.6C), and ECC 5.0/6.0
  • Proficient in Installing and activating Business Contents
  • Worked as BI/BW Contractor and as a Consultant, Functional Analyst and a Module Leader.
  • Conceptually very strong in Data Warehouse, Database, ERP (Enterprise Resource Planning)
  • Effective in executing multiple tasks and assignments ahead of schedule and under budget
  • Experience in Design and Development of Reports and Queries using BEx Analyzer and BEx Explorer.
  • Proficient in creating stored procedures, triggers, functions and packages in Oracle and SQL and PL/SQL
  • Excellent Communication Skills and Coordinated Training for End-Users and handled On Call Support to solve day-to-day BI related issues and reporting requirements.
  • Very skillful in handling of Data Modeling, Customizing, Data Loading, Data Extraction, Scheduling and Monitoring of BI components
  • Team management skills, both offshore and onshore
  • Worked in a team lead in a Global Production Support environment
  • Team player with good communication skills.
  • Very skillful in Finance Modules (FI/CO) and Logistics Modules of SAP.
  • Played a vital key role in Business Objects (Spend Performance Management) installation and customization.
  • BOBJ - Webi / Dashboard / Crystal Reports
  • BOBJ - Analysis Edition for MS Office
  • BOBJ - Data Services 4.0
  • BPC - Netweaver 7.5 and 10.0 training.
  • SAP HANA Certified

PROFESSIONAL EXPERIENCE:

Confidential, HARRISBURG, PA

Sr. SAP BW Consultant

Roles and Responsibilities:

Confidential of PA adopted a new SAP accounting code to be implemented to denote Appropriation Fiscal Year. Project involve enhancement to introduce a new SAP field known as Budget Period, and will be a unique data element in the Confidential ’s SAP Enterprise, Resource, and Planning system. The new budget period field will be automatically populated in all SAP finance transactions, including transactions posting to SAP funds.

  • Worked closely with the end users and BA to collect requirements
  • Performed data Mapping from source to all Finance data targets to include the new field
  • Made changes to existing Start and Field Routines codes to accommodate the new field
  • Performed data load to test for Budget Period
  • Wrote test cases and test scripts
  • Performed unit, integration and user acceptance testing
  • Transported all affected BW objects across system landscape

Confidential, ATLANTA, GA

Sr. Consultant

Roles and Responsibilities:

Responsible for SAP Business Analytics projects, overseeing the initiatives of new SAP BI/BW implementations. Engaging both the onsite and the offshore resources by leading the efforts in the area of documentation, design and implementation of Enterprise wide BI reporting solutions.

Documented, designed and implementation of Enterprise wide BI reporting solutions. Worked closely with business analysts in refining requirements from the end users and helping with the Fit-Gap Analysis. Coordinated efforts of onsite resources

  • Worked closely with the Business Analysts in refining the Functional Specifications Documents
  • Wrote Functional Specification Documents (FSD)
  • Wrote Modular Design Document (MDD) for financial reports
  • Wrote Modular Design Document (MDD) for Procurement reports
  • Provided all the logics needed for data enhancements and data transformation from SAP ECC to SAP BW
  • Mapped data from Oracle legacy system to SAP target system
  • Participate in identifying gaps from source system to the target system
  • Coordinated test and development team activities with respect to defect resolution management
  • Participated in installation of Business Object (Spend Performance Management 3.0)
  • Configured Business Object (SPM 3.0)
  • Team Lead - IBM AMS Global BW Production Support
  • Supported production data loads
  • Monitored Process Chain on a daily basis
  • Supported user’s workbooks through tickets raised by the help desk
  • On call rotation supporting Global BW users
  • Manage offshore BW team on a global BW support

Confidential, ATLANTA, GA

Principal Consultant

Roles and Responsibilities:

Project involves developing financial consolidated reports by integrating SAP BI queries with Excel. Different reports are used by the senior level management and sales associates in the field for analysis purpose. There is an active interaction with the offshore consultants on activities relating to the BI project.

  • Supported workbook users with different issues
  • Built workbooks, MD Reports containing five consolidated reports
  • Used V-Lookups and Index to refine reports connected to BW server
  • Wrote user manual for running consolidated reports
  • Coordinated meetings between offshore and onsite teams on a weekly basis.

Confidential, ATLANTA, GA

Principal Consultant

Roles and Responsibilities:

Projects involved analysis and development of business processes and using the strategic consulting to help clients transform their business. Major role was leading the efforts of SAP BI/BW implementations by engaging both off shore and onsite resources on different projects.

  • Design of both functional and technical specifications
  • Development of Cockpit objects for query analysis
  • Wrote and execute UAT
  • Data Mapping of legacy reports with SAP report
  • Created queries in Query Designer and deployed to the Portal.
  • Create CKF and RKF as needed
  • Maintain and administer Business Intelligence Accelerator (BIA)
  • Maintain Admin Cockpit for better performance of the cubes and queries
  • Adopt performance on all queries.
  • Day to day interaction with the end users collecting information and to further discuss any issues relating to the query performance
  • Designed user’s manual for training.
  • Designed a Xcelsius dashboard using corporate excel data and SAP BI query
  • Wrote ABAP USER EXITS for enhancement of datasource in ECC
  • Wrote START ROUTINES and STANDARD for data manipulation
  • Analysis of Hyperion reports
  • Data Mapping of legacy reports with SAP report
  • Created BeX queries to match Hyperion reports as close a possible
  • Create CKF and RKF as needed
  • Maintenance of Hierarchies Structures
  • Improve performance on all queries on a regular basis.
  • Used Query Designer to re-design queries as needed
  • Used V-Lookup and Cell Reference for Data Validation in Workbooks
  • Conducted Business Fit Gap Analysis on a new NetWeaver 2004s (BI 7.0) implementation.
  • Performed migration of the clients Reports from Legacy System to SAP BI.
  • Active interactions with the end user on day to day basis to better understand the client’s need and issues.
  • Performed Data Mapping from source to target of the replicated Datasource in BI using Transformation.
  • Created Queries using the BEx Analyzer and publishing the queries to the user’s role.
  • Created Process Chain for BI objects for periodic loads.
  • Created InfoCube for replicated DataSource from R/3 and ECC systems
  • Experience in SAP related ERP/OLTP and ETL/OLAP systems
  • Built Multi-Providers for InfoCubes and a Master Data for the Reporting Analysis.
  • Performed Unit and Integrated Testing.
  • Validated ECCS Reports - FI, PS, HCM and PM data against BI Master Data and InfoProviders
  • Validated PS Budget Planning - Actuals
  • In dept Data Validation with the functional consultant and end users.
  • Wrote User/Training Manual for the client to use in support of the POST GO-LIFE SUPPORT.
  • Created and scheduled InfoPackages for Delta Initialization and Delta Load into InfoCubes via PSA and DSO objects
  • Developed custom BEx Queries against InfoCube and ODS objects using BEx Analyzer
  • Executed all the required Post Installation steps after completion of Upgrade.
  • Developed new BEx Queries, workbooks based on the different InfoProviders
  • Organized meetings and sessions for Knowledge Transfer (KT) to the end users

Environment: SAP BW 3.5 / 7.0, ECC 6.0 - R/3 4.7, FI, WAD, BEx Analyzer, Query Designer, BOE XI 3.1, Xcelsius Enterprise 2008

Confidential, ELMHURST, IL

Senior SAP BW ETL & Query Developer

Roles and Responsibilities:

  • Analyzed business requirements and translated them into Multi-Dimensional Data Models using star schema
  • Involved in the full cycle of development and implementation of SAP BI/BW
  • Activated Business Content InfoSources, InfoCubes, Roles, Queries, InfoObjects and customized Business Content to meet business requirements
  • Created Multi-Providers for specific queries
  • Incorporated transfer rules for InfoCubes and customized update rules
  • Extended standard Business Contents based on client requirements
  • Created GL and Vendor Transactional InfoCubes for planning purposes
  • Worked extensively with Business Content for modified existing Sales and Financial InfoCubes to meet the End-User requirements
  • Involved in creation of Datasource, InfoSources, PSA for Data extraction, transformation and loading from SAP R/3 system to SAP BI/BW
  • Designed a Multi-Providers from the existing basic GL and Vendor cubes for reporting purposes

Environment: SAP BW 3.1, SAP R/3 4.6C, ECC 5.0, BEx Analyzer, Query Designer

Confidential, HOUSTON TX

SAP BW Techno Functional Consultant

Roles and Responsibilities:

  • Conducted Business Fit Gap analysis and Documented business requirement and technical analysis
  • Extensively involved in customizing and creating new queries in SAP BW environment on existing INFOCUBES.
  • Customization involved adding new Restricted Key Figures (RKF), Calculated Key Figures (CKF) and creating Structures in the Query Designer
  • Enhanced the existing BW InfoCubes
  • Scheduled InfoPackages to load data into the BW InfoCube via PSA, and also worked with the InfoCube Maintenance functions like Reconstructing Requests
  • Wrote Transfer Rules and Update Rules
  • Used BW Content Extractors to extract data from SAP R/3 to BW. Also used Generic Extractor in R/3 Data Extraction
  • Created and modified InfoSources for Master Data (Attribute and Text) and Transaction Data
  • Created, modified and activated Transfer Rules and maintained Communication Structures
  • Created and scheduled InfoPackages for Delta Initialization and Delta Load into InfoCubes via PSA and ODS objects
  • Set up Update Rules for InfoCube and uploaded data into the Infocube
  • Developed ODS objects to load Transaction Data from Infosource and defined Update Rules
  • Loaded Transaction Data into PSA and updated data from PSA to ODS and activated ODS for reporting
  • Schedule Infopackages to load regularly and also automatically triggering the Attribute Change Run
  • Developed Reports in BEX Analyzer and publishing it on the Web using BW Templates
  • Developed custom BEx Queries against InfoCube and ODS objects using BEx Analyzer
  • Created Drill-Down Reports through queries from summarized InfoCube report to detail ODS data

Environment: SAP BW 3.0B, SAP R/3 4.6C, BEx Analyzer, Query Designer

Confidential, ATLANTA, GA

SAP BW Consultant

Roles and Responsibilities:

  • Developed ODS object to load transaction data from Infosource and defined update rules.
  • Loaded transactional data into PSA and updated data from PSA to ODS and activated ODS for reporting.
  • Created Info Package to load regularly and also automatically triggering the attribute change run.
  • Developed around 40 custom BEx Queries against the InfoCubes and ODS objects using BEx Analyzer.
  • Extensively used calculated and restricted Key Figures. Created variables for the queries.
  • Created Drill through Queries from summarized InfoCube report to detail ODS data.
  • Publish reports on the Web using BW Templates.

Environment: SAP BW 3.0B, SAP R/3 4.6C, BEx Analyzer, Query Designer

Confidential, ATLANTA, GA

SAP BW Analyst/Developer

Roles and Responsibilities:

  • Functional Study of SD, FICO areas and did analysis for the reporting and analysis requirements.
  • Data Extraction, design and development of Infocubes, ODS objects with respect to the business requirements for SD and FICO areas
  • Day to Day Management of Info Providers
  • Resolved and implement BW Query issues (Day to Day) and change requests.
  • Scheduled and performance monitor periodic data loads from SAP R/3 to BW. Advise delta loading and ODS Loading process.
  • BEx reporting (Structures, Reports, Adhoc, Advising query writers in performance issues, Quality approaches, enhancements).
  • Data modeling in BW (InfoSources, InfoObjects, ODS, Cubes, Transfer/Update rules, process chains).
  • Create variables for BW Queries.

Environment: SAP BW 3.0B, SAP R/3 4.6C, BEx Analyzer, Query Designer

Hire Now