Sap Bi Lead Consultant Resume
Tampa, FloridA
PROFILE:
- Having around 11 years of experience in SAP BW, BOBJ and HANA, been part of several successful end to end implementations and support projects.
- Well versed with the SAP technologies, its functional module like FI, SCM, EWM, SD, MM, IS - U (Utilities), TM and geared to adopt new concepts and technologies.
- Expertise in Data Modeling, Reporting (BEx Reporting, Web Intelligence, Crystal reports, Dashboards (Xcelsius)), Lumira and Data Extraction (SAP and non-SAP sources).
- Actively involved in communicating with the clients and the business to understand the Business process and business requirements at the time of design and development and provided solutions for HANA / BW / BI platforms.
- Expertise in creating TS (Technical specs), SDD (Software Design Documents) based on FS (functional specs) provided from business.
- In depth understanding of SAP In-memory Computing and its Architecture
- Expertise in HANA Modelling Concepts like Attribute Views, Analytical Views and Calculated views and exporting and importing concepts
- Worked on Data Provisioning using SLT Replication and Smart Data Access
- Expertise in Reporting on HANA Models using SAP BI Reporting Tool
- Worked on SAP Live Content
- Worked on User management and Data Level Security
- In depth understanding of SAP Business Warehousing and BW on HANA and its Architecture
- Expertise in the design, development of BW models using (InfoObjects, ADSO, Classic DSO’s, ODS Views, Cubes, CompositeProviders, MultiProviders, Hierarchies, InfoSources, Transformations, Transfer-rules, Custom DataSources, DTP, InfoPackages) as part of BW 3.5, BW 7.0 - 7.5
- Worked on SAP BW 3.x data flow Migration to 7.0 and higher
- Extensively Involved in Setting up the procedures for LO Cockpit, Involving Activating the Business Content Data Sources, Maintaining the Extract Structure, Generating the Data Source, Activating the Data Source, Enhancing the Data Source
- Involved in Data Loading (Full/Delta Up-Load), Scheduling, Monitoring, working with Master Data, Transaction Data and Cube Compression as part of BW 3.5, 7.0 - 7.5
- Involved in creating Generic Extractors using Tables/View
- As part of Data Provider Layer, migrated data from ECC Systems using LO, CO-PA, CRM and Business Content Extractors
- Expertise in data load management using Process Chains (Creating process chains & Mata chains by using advanced process types like Decision between multiple alternatives using options like Execute InfoPackages, Data Transfer Process, Delete Overlapping Requests from InfoCubes, Delete Index, Generate Index, Roll Up of Filled Aggregates/BIA Indexes, Attribute Change Run, Adjustment of Time-Dependent Aggregates, Deletion of Requests from PSA,)
- As part of Information Consumer Layer designed BEx Reports providing insight of Business Intelligence for Business Analyst for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure, Conditions, Exceptions and Used Variables with User Entry/Default Value, Replacement Path and Customer Exit.
- In-depth knowledge in SAP BOBJ XI 3.1, BI 4.0,4.1 and SAP BW, HANA integration and Extensive experience in BI Report tools Web Intelligence (WebI), Analysis for Office, Lumira, Crystal Reports, Xcelsius (Dashboards) Etc…
- Extensively worked on reports development on different sources like BEx, HANA and non-SAP sources as part of reports development used wide range of options which are available as part of BI reporting tools like filters, Prompts, Tables, Charts, Breakpoints, Count Functions (SUM, AVG Etc..), Alerts, Ranking, Smart filters, Drill function on Hierarchy and Variables, Etc…
- Developed formatted Dashboards on different sources like Universe, Hana Views and BEx for Corporate users, as part of dashboards development used wide range of options like charts (Column Chats, Pie charts, Bar charts Etc...).
TECHNICAL SKILLS SUMMARY:
Data warehousing: SAP BW 3.5, SAP BW 7. 0 - 7.5
Data Base: SAP HANA 1.0 - 2.0 SPS 03
Reporting: SAP Business Objects XI 3.1,4.0,4.1 SAP BEx Reporting
Programming: ABAP, SQL
Functional Areas: FI, SCM, IS-U, TM, SD
PROFESSIONAL EXPERIENCE:
Confidential, Tampa, Florida
SAP BI Lead Consultant
Tools: worked on: SAPBW/ HANA / BI 4.0,4.1
Responsibilities:
- Scoping for the new proposals
- Solution design/review of HANA, BI projects for Finance (FI) and IS-U (Utilities),
- Meeting with the stakeholders for identifying the business requirements
- Identify the business reporting requirements and preparation of Reporting requirement documents and blueprint documentation for the ETL flow
- Extensively Worked on FI and IS-U modules for data modelling and business reporting
- As part of the ETL Process created InfoObjects, DSO, ADSO’s, ODS Views, CompostProviders, Cubes, Multiprovider, used start routine, end routines in the transformations and extracted data from different sources in to BW.
- Worked on Data provisioning in HANA using LT replication
- Worked on HANA Modelling created Master Data Attribute Vies, Analytical view and Complex Calculated Views
- Worked on SAP HANA Live content
- Worked on BI Reporting tools like Webi, Analysis for office, Lumira and Design Studio to develop the reports
- Developed user training guide documents
- Reviewing the development work done by the team
- Checking the quality standards of the reports
Confidential
SAP HANA Lead Developer
Tools: worked on: SAP HANA / BI 4.0,4.1
Responsibilities:
- Scoping for the new proposals
- Solution design/review of HANA, BI projects for EWM and TM reporting
- Meeting with the stakeholders for identifying the business requirements
- Identify the business reporting requirements and preparation of Reporting requirement documents and blueprint documentation for the ETL flow
- Extensively Worked on EWM and TM modules for data modelling in HANA
- Worked on Data provisioning in HANA using SLT replication
- Worked on HANA Modelling created Master Data Attribute Vies, Analytical view and Complex Calculated Views
- Worked on SAP HANA Live content
- Worked on BI Reporting tools like Webi, Analysis for office to develop the reports
- Develop user training guide documents
- Reviewing the development work done by the team
- Checking the quality standards of the reports
Confidential
SAP BW Lead
Tools: worked on: SAP BW 7.3,7.4/ BI 4.0,4.1
Responsibilities:
- Scoping for the new proposals
- Solution design/review of the BW and BI projects for EWM reporting
- Meeting with the stakeholders for identifying the business requirements
- Identify the business reporting requirements and preparation of Reporting requirement documents and blueprint documentation for the ETL flow
- As part of the ETL Process created InfoObjects, DSO, Cubes, Multiproviders and used start routine and end routines in the transformations
- As part of Reporting requirements developed serval Webi, Analysis for Office reports
- Supported BW Productions system like data load monitoring, process chain enhancements
- Worked on performance optimization of BW data loads and Reports
- Team Management (Use to manage a team of 5)
Confidential
SAP BI Lead Developer
Tools: worked on: SAP BW 7.3/ BI 4.0 /BODS / SAP HANA
Responsibilities:
- Meeting with the stakeholders for identifying the business requirements
- Identify the business reporting requirements and preparation of Reporting requirement documents and blueprint documentation for the ETL flow
- As part of the ETL Process created InfoObjects, DSO, Cubes, Multiproviders and used start routine and end routines in the transformations
- Worked on data extraction from SAP IS-U and BODS (from various relational databases)
- Worked on process chains to automated the data load process in daily and weekly bases
- Worked on performance optimization of reports and data loading
- Worked on BEx Reports
- Perform System Testing and System Integration testation
- Develop user training guide documents
- Reviewing the development of the Reports developed by the team
- Checking the quality standards of the reports
Confidential
Tools: SAP HANA / BI 4.0 SP 2 /BODS
BI Lead developer
Responsibilities:
- Setting up the connectivity to BI (Business Objects with SAP BW, SAP HANA and SQL Database
- BI 4.0 Security framework design and development based on Confidential requirements
- Provding Standards, Best Practices and Guidelines for BI 4.0
- Produced standard report templates for Web Intelligence, Crystal Reports and Dashboards based on Confidential requirements
- Developed BI Reports on BI toolset on top of SAP BW, SAP HANA, SQL Database
- Extensively worked on User management and Data Level Security
- SAP HANA POC
- Worked on Data provisioning in HANA
- Worked and In-depth understating of HANA Modelling
- Setting up the connectivity to BODS 4.0 with SAP BW
- Performed ETL process using BODS in SAP BW as part of POC
- Providing the solution for development of BI Reports using tools like (Webi and Dashboards)
- Took up new initiative for enabling BW data to Business Analyst through BI Explorer
- Setting up New BW Analysis Authorizations security specific to the BI Explorer
- Seething up best practices and standards for BI Explorer
Confidential
SAP BW/BO Developer
Tools: worked on: SAP BW 7.0 / BO 3.1
Responsibilities:
- Involved in several meetings with the business to understand the current process.
- Involved in preparing functional spec DFDs and Technical Specs.
- Involved in installing business content objects and migrating the Update Rules and Transfer Rules to form the Transformations.
- Created InfoCubes, Data store objects Transformations, Data transfer process (DTP),
- Involved in writing Start & End routines at transformation as part loading data based on the business logics provided
- Created Multiproviders to design reports from Multiple InfoProviders.
- Involved in Data-Modelling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring and Reporting for the SD COPA modules.
- Extensively Involved in Setting up the procedures for LO Cockpit for SD Involving Activating the Business Content Data Sources, Maintaining the Extract Structure, Generating the Data Source, Activating the Data Source, Enhancing the Data Source and Using the Enhancement RSAP0001 to fill the data into the enhanced Fields.
- Creating process chains & Mata chains for the automation of the data load on daily and weekly
- Worked on Transports according to Systems Landscape.
- Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to required level of information.
- Worked on Information Broadcasting to publish the formatted Reports on to Enterprise Portal.
- Worked on Designer Created Universe on SAP Cubes, BW Queries,
- Created reports using Web Intelligence using some of the advance functions like Breakpoints, Alerts, Ranking and Smart filters
- Working on Xcelsius Created Dashboards by extracting data in to embedded excel sheets from different sources like SAP NetWeaver, Webi Reports.
Confidential, West Chester, Pennsylvania
SAP BW Developer
Tools: worked on: BW 3.5 & BI 7.0
Responsibilities:
- Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads and Process Chains monitoring for Sales, Inventory, Fiancé
- Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
- Involved in editing the error records in the ERROR STACK and uploaded these records by using error DTP.
- Involved in identifying lad failures at DTP Level using ABAP Debugger.
- Involved in identifying the load failure errors based on short dump (ST22)
- Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis.
- Involved in improving the performance of the reports by modifying and creating new aggregates and pre-calculating the reports using information broadcaster.
- Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
- Maintaining the Development & Quality servers without any load failures
- Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to required level of information
- Involved in writing Customer exits (ABAP, Function Module) based on the user requirements for the reports
- Worked on report designer for formatting the reports using workbooks BEx reports
- Worked on information broadcasting for publishing the reports on to KM folders and email the reports to the end-user in Excel and PDF Formats
- Created RRI reports based on the business requirements
- Involved in creating new reports for Sales and Pricing and for BPS based the clients SRS (Software Requirement Specification)
- Created DSO, Cubes & Master data for the new Pricing Reports
- Created transformation for newly created Cubes, DSO
- Created DTP for newly built DSO, Cubes
- Involved in Creating Multiproviders to design reports from Multiple InfoProviders.
- Involved in creating process chains for the new master data loads.