We provide IT Staff Augmentation Services!

Sr. Lead Bi/bobj/bpc/bods/hana Architect Resume

SUMMARY:

  • 16+ years of SAP experience which includes over 14 years of experience in SAP BW, BOBJ, and HANA.
  • Involved in multiple full life cycle implementations involving design and development of BW objects, Transformations, Business Content configuration, and Sizing using SAP ASAP methodologies.
  • Extensive experience with HANA Modeling including creation of HANA Attribute views, Analytical views, Calculation views, design time HANA views, Tables and Table views
  • Experience with BW and BPC migration to HANA DB - Developed a detailed migration run book for the BW and BPC activities before and after the migration, and integrated it with the Basis and Security activities.
  • Performed pre and post HANA migration activities in the Dev, Staging and Production systems - Post-migration optimizations included boosting query and data load performance including info cube optimization, ABAP code optimization, BEx query settings, HANA DB parameters, column store table distribution, DB partitioning, etc.
  • Responsible for providing end to end solutions to clients, transitioning and sustaining production support activities, defining Project Standards, Development of Architecture, Review of Design, GAP Analysis, Project Schedules, and Team Management.
  • Extensively worked on data modeling - Entity Relationship (ER), Multi-Dimensional/Star Schema and Extended Star Schema models - Designing custom info objects, info providers, info cubes, DSO/ODS objects, multi providers, infosets, info sources, source systems and dimension modeling.
  • Installation, activation and enhancement of Standard Business Content for various industry verticals and horizontals like Financials, Logistics, APO, and CRM.
  • Proficient in different modes of extraction supported by SAP BI - my SAP Service API, DB Connect, XML, UDC, Flat files and extraction from 3rd party ETL tools. Proficient with generic, FI and LO Cockpit extraction as well as extraction from legacy systems using Informatica and Data Stage.
  • Experience providing support in Open Hub Services for licensed vendor RDBMS.
  • Expertise in performance tuning using Aggregates, Rollup, collapse, Partition and Compression. Used the BW Statistics cube to analyze query performance and aggregates performance.
  • BW Reporting: Reporting using BEx Analyzer, BEx Web, BEx Query Designer, BEx Broadcaster, MDX, EP Integration, and iView’s, Visual Composer, KM and Collaboration Rooms. Expertise in creating BW components like Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Sap Authorizations, Conditions, R/RI, WAD, Web Reports, and CSS style Sheets.
  • BPS/BPC5.1/NWBPC/EPM10: Experience working with of creation of Applications, Appsets, Dimensions, script logic, validations, BPC Excel, Input schedule, data manger Packages, Transformation file etc.
  • Attribute Views, Analytical views, Calculation views creation and Projection, Join and Union creation in HANA calculation views. Filters, restrictions, calculated measures, restricted measures in HANA views
  • Writing SQL Script procedures and HANA CE functions scripts
  • Creation of HANA views, tables, views as design time objects.
  • Creation of Input Parameters, Variables and mapping them with BO reports
  • Time generation in HANA studio, SQL scripts for calculating Time characteristics in HANA views
  • Schema mapping in HANA studio for Export and Import transports from different lifecycle systems. Export and Import of HANA views between different lifecycle systems through Developer mode as well as through Delivery unit
  • Worked on HANA LIVE Content, HANA LIVE View Browser, HANA Live Extension Assistant
  • Extended HANA LIVE Views using the HANA Live Extension Assistant
  • Installed and Worked on HANA LIVE Views for SAP FI-GL,SAP SCM, and HANA LIVE SAP Manufacturing
  • Created Operational (sales order query, Intercompany sales)and Benchmark reporting on HANA LIVE Views for SCM, FI GL and EWM
  • Worked on HANA LIVE View reports like (NewGLProfitCenterPlanActualVarQuery, NewGLFinancialStatementPlanActVarQuery)
  • Prepared security setup for BODS and BI 4.1 systems
  • Worked on SDI Configuration, SDI Flow graphs to bring data from HADOOP and other 3 RD party Systems.
  • Designed BODS architecture to bring data from Sales Force to HANA enterprise using BODS tool.
  • Lumina and Tableau reports and dashboards creation on top of HANA calculation views.
  • Flat file data source creation in Business Objects Data services (BODS) and also imported the SAP BI tables into BODS which serves as the BI data source including importing the HANA tables. Extensively worked in the replication technique SAP BODS for creating ABAP data flows, information modelling tool HANA Studio to build HANA models, front end BO tools - IDT, Web Intelligence and BO business explorer.
  • Expert in optimizing HANA views for best performance to reduce data latency, memory consumption and enhance report performance.
  • Expert in architecting and deploying global EDW solutions by following SAP best practices including LSA and LSA++ architecture, utilizing the standard business content, and SAP recommended landscape and platform standards.
  • Strong experience in modelling HANA views, data provisioning using SLT and BODS, user management, setting up security by assigning analytical privileges both static and dynamic, migrating HANA artefacts across the landscape.
  • Experience in the latest HANA 1.0 revisions.

TECHNICAL SKILLS:

Data Warehouse: SAP BI 7.0, BI 7.30, BW 3.5, Informatics Powermart

ERP Packages: SAP R/3 4.6, ECC5.0/6.0, CRM7.0, APO, HCM, SAP Net weaver 2004s.

ERP Integration: SAP R/3 - SD, MM, FI, CO, CRM, POS, SCM modules.

Reporting Tools: SAP BEx, Visual Composer and Web Reporting, BOBJ Tools, Congo’s and Hyperion.

BOBJ Tools: LCM, Webi, IDT, Advance Analysis, Lumira, Design Studio Dashboard Designer Tool.

Platforms: UNIX, Windows (XP, NT, 2000), VMS.

Database: SQL*Plus, PL/SQL, Oracle 10g, 9i, 8i.

Programming Language: ABAP/4, ABAP Objects, Java, and ASP.

Utilities/Tools: SourceSafe, Tidal, ARS Remedy System, Erwin, Test Director

Other: Confidential Project, Mercury Tools, JavaScript, XML, Citrix

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Lead BI/BOBJ/BPC/BODS/HANA Architect

Responsibilities:

  • Worked on implementing SAP HANA views based solution for a midsize medical devices company to report on their logistics metrics.
  • Conducted Design Thinking sessions, Lead/Architected end to end Analytics &Reporting solution for Green Field BPC10.1/BW7.5/HANA implementation.
  • Designed, architected and developed the implementation for HANA views in the clients using the SDI flow graphs and SDI Replicators.
  • Built complex reporting models in HANA for logistics using existing standard and custom ABAP reports as sources. Some examples of which are Material Classification, Document Pricing data
  • Architected Green Field BW4HANA 1.0 Solution for Strategic Analytics.
  • Designed, developed and deployed ADSOs to stage data from SAP, Open ODS for Non-SAP field mapping, and Composite providers for reporting requirements.
  • Worked on SAP and non-SAP systems to provision data using ETL tools like BODS and ODP.
  • Setup Delta Queues and monitored the delta data transfer from provider to subscriber in the Operational Delta Queue (ODQ).
  • Implemented SAP HANA CDS views that supported Embedded Analytics in FIORI apps.
  • Designed, developed and deployed complex reporting solutions in HANA modeling perspective.
  • Architected the HANA security strategy for clients.
  • Created templates for documentation and assisted clients by reviewing documentation created for Data models in HANA.
  • Built unique reporting solutions in SAP Business Objects using the HANA models leveraging the linking functionality, free hand SQL and HANA views.
  • Conducted UT and UAT sessions for clients.

Confidential

Sr. Lead BI/BOBJ/BPC/BODS/HANA Architect

Responsibilities:

  • Part of the technical migration team responsible for Downstream BW system migration from Oracle to HANA data base.
  • Responsible for the design, development and deployment of parallel operation data loads for IP, Snapshot into cubes and time dependent master data loads.
  • Lead the technical migration of the third party interfaces from the BW on Oracle environment to the BW on HANA environment.
  • Involved in the planning, design and testing 110 third party interfaces across such middleware as SSIS, BizTalk, Web Services,Hadoop and other RFC connections to BW on HANA such as APO, Business Objects and BODS.
  • Debugged and resolved issues related to migration of the BW database from Oracle to HANA.
  • Responsible for the management and timely resolution of migration issues related to parallel operations, interfaces and HANA database.
  • Resolved data load failures during migration.

Confidential

Sr. Lead BI/BOBJ/BPC/BODS/HANA Architect

Responsibilities:

  • Used Agile Methodology for each phase of the project
  • Configuring BPC environments and models
  • Configuring BPC Security for Task/Data Access Profiles, creating Teams and assigning Users
  • Developed Security, Work Status and Interfaces to Confidential .
  • Meet all SLA for EPM KPI Metrics set by Business.
  • Developed complex interfaces to support BPC calculations.
  • Worked on MOPR /Royalties /Shared Service Functional area
  • Delivered Royalties Reports and MOPR Monthly process reports
  • Conducted worldwide workshop to gather Confidential requirements
  • Lead Design Session to integrate multiple Data sets for each region

Confidential

Sr. Lead BI/BOBJ/BPC/BODS/HANA Architect

Responsibilities:

  • Lead the migration of the PRA (Production Revenue Accounting) reporting from Oracle/SSIS based reporting to BW on HANA platform.
  • Responsible for design, development and deployment of the critical NRI (Net Revenue Interest) calculation model in HANA and BW.
  • Analyzed the existing model on Oracle. Reviewed SQL procedures and views within the database to replicate the functionality within BW on HANA environment.
  • Designed the complex NRI solution in BW on HANA environment which is used in critical month-end financial reporting solution.
  • Built an Open-hub based solution to support the as-is model within the ORACLE GIC environment.
  • Designed HANA Models using studio to eventually replace reporting using BOBJ reports.
  • Built attribute, analytical and calculation views(graphical/CE functions) within HANA environment.
  • Worked on regression testing for the built model and get the user sign-off.

Confidential

Sr. Lead BI/BOBJ/BPC/BODS/HANA Architect

Responsibilities:

  • Identified required SAP tables for reporting and enabled SLT real time replications to HANA system.
  • Developed SQL script based calculation views to support complex reporting requirements that were difficult to meet with graphical views.
  • Enable HANA Live smart financials with real-time data replication using SLT from SAP Confidential and enable BI reporting.
  • Define the project roadmap and set the right direction for the customer in adopting HANA.
  • Extend/Customize the HANA Live content by modifying the Calculation views and adding new tables and new fields.
  • Propose and implement a HANA authorizations based on the business requirements using static and dynamic analytical privileges, user roles, etc.Involved in performance tuning activities for both data flows and Bex queries.
  • Installed and Worked on HANA LIVE Views for SAP FI-GL,SAP SCM, and HANA LIVE SAP Manufacturing
  • Designed and developed HANA Views and Stored procedures to support the business analytics for Problem Properties and Permit Systems.
  • Created reporting and functional users and assigned authorization roles.
  • Exported and imported the views from Development to Production environment.
  • Demonstrated the value of HANA over the existing infrastructure.
  • Enabled the customer with necessary skills and knowledge to support the HANA platform and models in the production environment.

Confidential

Senior Lead BI/BOBJ/BPC/BODS/HANA Architect

Responsibilities:

  • Analyzed the report requirements and creation of base HANA views which are re-usable for other reports.
  • Creation of HANA Attribute views, Analytical views, Calculation views.
  • Creation of design time HANA views, Tables, Table views which are easier to transport between the different lifecycle systems.
  • Worked on projection, Join and Union in HANA calculation views.
  • Worked on filters, restrictions, calculated measures, restricted measures in HANA views.
  • Creation of input parameters, variables and mapping them to get the data filtered at lower level.
  • Creation of SQL Script based and HANA CE function based calculation views.
  • Mapping the Input parameters/variables in the SQL scripts and Mapping the Input parameters/variables to BO reports.
  • Formatting the reports in Calculation views.
  • Time generation in HANA studio and creation on SQL scripts for calculating time characteristics in HANA views.
  • Created data flows in BODS to load data from Oracle ODS to SAP BW.
  • Strong Knowledge in Creating and executing Jobs in SAP BODS to populate HANA.
  • Schema mapping in HANA studio for Export and Import transports from different lifecycle systems.
  • Creation of BO universes in IDT on top of HANA calculation views.
  • Creation of WEBI reports on top of BO universes.

Confidential

Senior Lead BI/BOBJ/BPC/BODS/HANA Architect

Responsibilities:

  • SAP HANA/BI/BOBJ architect for the BW and BPC migration to HANA DB.
  • Responsible for developing a detailed migration run book for the BW and BPC activities before and after the migration, and integrate it with the basis and security activities.
  • Responsible for developing a test plan to check pre-migration system readiness and post-migration system validation.
  • Led the activities to perform the pre and post migration activities in the Dev, Staging and Production systems.
  • Responsible for post-migration optimizations to boost query and data load performance including info cube optimization, ABAP code optimization, BEx query settings, HANA DB parameters, column store table distribution, DB partitioning, etc.
  • Optimize BPC BADIs for faster execution of packages and consolidation calculations.
  • Presented detailed pre and post statistics to compare HANA performance over SQL DB for frontend queries and backend data flows for the steering committee which was the key driver for the Go No-Go decision.
  • Conducted and led regular meetings to SAP to review the status of critical issues and very high priority OSS messages.
  • Conducted and led daily meeting with the internal team and weekly meeting with the core team to review the status of the open defects and discuss the project timelines.
  • Involved in the HA and DR testing to ensure the HANA system availability during node and system crashes.
  • Developed a project roadmap by analyzing the current BW and BPC data flows and identified opportunities of optimization to get the ROI for HANA migration.
  • Point of contact for the business during UAT to record, review and close the defects in HP ALM (QC).

Confidential

Senior Lead BI/BOBJ/BODS/HANA Architect

Responsibilities:

  • By using information modeler, created Universe on top of SAP HANA database to created WBI report and Dashboards as per the business requirements.
  • Created reports on Analytical views and attribute views by using information design tool.
  • Exposed BI Info providers on HANA and created HANA Models.
  • Part of TED 2.0 implementation project which is based on HANA.
  • Guided and supported the customer with benchmarking, testing, performance tuning, HANA optimization of the backend data flows and front end reports.
  • Led the cutover activities during technical go-live.
  • Designed the strategy for loading huge volumes of historical retail transaction data from the existing production system to the new production system on HANA.

Confidential

Senior Lead BI/BOBJ/BPC Architect

Responsibilities:

  • Configured the application for financial consolidation and planning such as balance sheet planning, gross margin planning.
  • Extracted and integrated Confidential periodical BW data load for transaction data, master data, and exchange rate maintenance.
  • Created and maintained consolidation appset, application such as legal consolidation, rate, ownership, planning.
  • Created planning, forecast category and loaded the data through input schedules, flat files.
  • Managed and loaded transaction data to BPC using the data transformation, conversion logic.
  • Validated the data loaded to BPC Dimensions.
  • Responsible for routine maintenance of dimension members (Master data), hierarchies and member’s properties for account, entity, product, etc.
  • Implemented the write back preprocess Badi for disaggregation which helped the business to plan at Node level.
  • Developed the Multiplication BADI which is the core of the all the calculations. The usage of this BADI has increased the performance manifolds and reduced the build efforts for other calculations using this BADI to a great extent.
  • Worked on BPC application architecture, performance enhancement using optimization.
  • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and reports (Webi, Crystal reporting), and Using Visual Composer for Dashboards on Portal.
  • Created Bex web application templates as I views and integrated with Enterprise Portal.
  • Scheduled SCORECARD Webi doc. in PDF version to Weekly distribution via email based on a mailing list that will be maintained by the business.
  • Worked on write back and custom logic badi's for writing back data to input put forms.
  • Worked on fixing COPA allocations rules for ASIA COM project which includes tank, warehouse, duty, freight costs.
  • Successfully converted the Non-Cumulative Info cubes to SAP HANA optimized Info Cube’s.
  • Worked on Retraction BADI and pulled planning data back to BI from BPC.
  • Extensively worked on documentation, training users and supported the BPC system.
  • Involved in creating the BOBJ Dashboards for COM customer sales reports.
  • Created data flows in BODS 4.0.

Confidential

Senior BI/HANA Architect

Responsibilities:

  • Led the Service Upgrade effort for upgrading LG&E and KU BI landscape from BI 7.0 EHP1 to 7.31 SP04 and performed regression testing to identify side effects/issues.
  • Downloaded Side effect notes and did the analysis before upgrading the systems
  • Fixed all the issues relevant to backend data flows and front end issues.
  • Worked with ASU/Tool kit and did all the activities relevant to post and pre upgrade.
  • Implemented preparatory OSS notes for HANA implementation.
  • Worked on ISU extractors and extracted information from CRM Marketing and CRM Contract Management.
  • Implemented the BWA failover strategy and configured and tested the backup blade along with basis.
  • Fixed SPAU/SPDD adjustments and included this transport as part of the Cut over plan.
  • Created the test scripts for before, post upgrade validations in the Quality Center (HPQC).
  • Worked with SAP through OSS messages for troubleshooting system issues and program bugs. Implemented the recommended SAP notes for solving the issues.
  • Created Test plan, Test cases in HPQC.
  • Involved in regular maintenance of BIA through RSDDBIAMON2 and troubleshooting issues due to inconsistencies in BIA indices.
  • Worked on BOBJ Queries (Webi and Crystal Reports) and published in Portal.
  • Prepared the cut over plan and participated in go - live activities.

Confidential

Senior BI/HANA Architect

Responsibilities:

  • Activated Data sources for 0RT PA TRAN CONTROL, 0RT PA TRAN TOTALS for POS Module.
  • Involved in creation of the POS sales DSO’S (YSLSDD01, YSLSDD02) in data warehouse layer.
  • Created POS Sales cubes (YSLSTDC1B, YSLSTDC2B, YSLSTDC2C, and YSLSTDC2D etc.) by year wise and included these cubes in the BIA for reporting purpose.
  • Involved in the blueprinting for the MAP (Merchandising Assortment Planning) module.
  • Created reports like (Promotional Analysis, Sales audit Dashboard, POS Transaction detail, POS Transaction Summary, etc.), COM sales, PO History for different stores.
  • Published BI reports in Portal using I views.
  • Scheduled Information broadcasting jobs for distributing BI reports to the user community.
  • Involved in the Knowledge transfer, Demo, Problem solving and prepared the BW Technical documentation.
  • Implemented BI Admin cockpit and automated this process as part of process chains.
  • Worked with MS Visio and Confidential Project for the arch diagrams.
  • Worked with Business and functional teams and gathered requirements for Loyalty Management.
  • Integrated CRM and POS data in BI and delivered reports for Business.
  • Worked with CRM team and provided data for CRM Segmentation.
  • Activated business content for CRM interactive reporting.
  • Enhanced interactive reports with custom fields and published in Webui.
  • PCA Conversion/New GL implementation.
  • Replaced existing 0EC PCA1 and 0EC PCA 3 extractors with 0FI GL 10 and 0FI GL 14.
  • Reconciled Data between Confidential and BW for New GL by running Report in GR55 and standard Bex report on BW.
  • Used Standard Data Source, DSO and Info Cube to Calculate the Financial Statement Analysis and Flux Analysis (0FI GL 10, 0FLGL O10, 0FLGL C10).
  • Used Standard Data Source 0FI GL 14 to develop financial reports (Weekly Cash Summary report, Weekly Investment report).
  • Provided ISBS Accounts from new FI GL Extractor for BPC Team for planning on Revenue Memberships, Revenue Supplement and other Accounts.
  • Provided Actual data for Employee Head Count, Income Statement balance sheet information to BPC for Planning.
  • Led the Support Pack Upgrade effort for upgrading Home Depot BI landscape from SPS12 to EHP1 and EHP1 to 7.30 SP05 and performed regression testing to identify side effects/issues.
  • Created Attribute Views, Analytic Views, and Calculation Views, Functions and Analytical Privileges using In-Memory Computing Studio.
  • Created delivery units for data models.
  • In-Memory Replication process (Meta data transfer, Data provisioning & Monitoring)
  • Created Data Services Job to populate the data into HANA.
  • Worked on HANA SLT and Data provisioning process.
  • Created a new Data Store for HANA in SAP Data Services.
  • Worked on the Enhancement pack upgrade project from BI side along with other BWA Revision upgrade, BWA firmware upgrade, and zOS upgrade.
  • Used SUM Tool as part of DB Migration.
  • Prepared Technical Specification documents, Architecture design documents and IRB documentation as required by THD.
  • Performed environment test at different stages; from Development to QA, QA to system test, system test to Production including all BOBJ 4.0 toolset usability standpoint.
  • Developed and loaded flat file data sources for BOBJ Score card reporting.
  • Generated a Webi SCORECARD report by using BEx BW queries as datasource.
  • Served as an SME for all BOBJ 4.0 tools (IDT, IAD, Crystal Reports for Enterprise XI 4.0, Dashboard Designer, Analysis for Confidential Excel, Explorer, Data Federation Administration Tool), and Teradata connectivity using relational connection.
  • Maintained multiple connections at CMC (Central Management Console) to manage different systems as source.
  • Extensive experience creating OSS messages needed to resolve product errors/issues and works with SAP AGS team and product team on solution to the issues.
  • Migrated all development objects from Dev/QA/System test/Prod using LCM (Lifecycle management console).
  • Enabled Version management process.
  • Scheduled Canada Retail SCORECARD Webi doc. in PDF version to Weekly distribution via email based on a mailing list that will be maintained by the business.
  • Created few data flows in BODS.
  • Enabled/rolled Sales, EDW and EFI data to Business Objects Explorer - Accelerated Version.
  • Created POC using BO explorer and Dashboard designer tools.
  • Monitored the daily load process chains and worked with BASIS and DBA teams to resolve the issues that arise in daily data extractions
  • Improved performance of existing SAP BW Queries and reports by creating Aggregates, Compression and Partition etc. Monitored BW Statistics and tuned BW Info Cubes, aggregates, OLAP cache and query performance. Created indexes, database statistics, aggregates, efficient queries, modified the data transfer parameters, etc.

Environment: SAP R/3 ECCS 6.0, SD/MM/FICO, CRM, SAP BI 7.0, BI 7.30POS SAP NetWeaver 2004s, SAP BEx WAD, ABAP/4 Objects, APD, Query Designer, Webi JavaScript, HTML, BOBJ 4.0, BODS, Webi, Xcelsius, LCM, HP Quality Center.

Confidential

Senior BI/CRM Lead Consultant

Responsibilities:

  • Responsible for requirements gathering and developed the Functional & Technical Specification documents.
  • Activated the business content data sources for the CRM master data like Business partner, CRM product, Marketing attributes and Transactional data sources for CRM opportunities, CRM activities, CRM quotes.
  • Activated the Info cubes, DSO’S, Info objects, Multiproviders for the CRM Implementation.
  • Created opportunities win loss report, quotation tracking, opportunities pipe line analysis report using QAD, WAD and published in CRM WEB UI.
  • Designed Authorization objects for all the CRM and COPA reports based on Territory path id using Analysis Authorizations in BI.7.0.
  • Created COPA costing based data source on operating concern.
  • Created DTP’s and transformations and worked in ABAP objects in Start Routine and End routines.
  • Created Test plans for the UAT and Cutover.
  • Extensively worked with BEX Reporting for reports like Order History, Assortment Analysis with Query Designer, Web Application Designer and Variables etc.
  • Worked with the Defects, Validation and providing Knowledge Transfer to users on various aspects.
  • Prepared BW Technical documentation.
  • Worked with the transports extensively and collection of BI objects for transports.
  • Worked with MS Visio and Confidential Project for the arch diagrams.

Environment: SAP R/3 Confidential 6.0, CRM7, SAP BI 7.0, SAP NetWeaver 2004s, SAP BEx WAD, CRM WebUI, ABAP/4 Objects, APD, Query Designer, JavaScript, HTML, HP Quality Center.

Confidential

Senior BI/APO Lead Consultant

Responsibilities:

  • Conducted and presented best practices, logistics extraction and performance tuning.
  • Performed extensive analysis about the Source systems like Confidential & Asset history and Historical data.
  • Worked with the Data Model design for FI, SD, MM, APO SNP, APO DP. Worked extensively with Data Warehouse Workbench for Modeling, Monitoring, scheduling DTP/Info package and Process chains.
  • Activated the Business Content and Data Sources into 7.x/3.x version and also performed the Data Source Migrations, Mappings and Transformations with both the Confidential & Historical data needs.
  • Worked with the Customization of the Info Cubes, DSO objects, MultiProviders and Info Sets as per requirements.
  • Created the custom code using the HTML and Java Scripting in web the template for the table reporting.
  • Created CVC, shipment history, CMIR data in BI and published in APO system for APO DP planning.
  • Extracted the SNP Master Data like Location, Tlane, Product and PDS Information into BI.
  • Pulled planning parameters like Yield, Cycle time, Consumption into BI from APO SNP.
  • Created plan vs. actual planning parameters reports in SAP BI.
  • Worked with the Transports extensively and Collection of BI objects for transports.
  • Designed and updated the process chains for the daily loads and tuned for optimum load performance.
  • As part of performance improvement redesigned most of the cubes in production and removed unused dimension and reloaded the cubes
  • Continued to work with the users to improve enterprise wide data sharing through EDW solutions.
  • Continued to monitor BW performance and take actions to meet the SLA.
  • Worked on the authorizations objects and gave users the authorizations based on the Sold to party info object.
  • Created Test plans for the UAT and Cutover.

Environment: SAP R/3 Confidential 6.0, SCM6.0 CRM 5.0 SAP BI 7.0, EHP1, SAP NetWeaver 2004s, EP 7.0,VC SAP BEx WAD, Solution Manager, ABAP/4,Query Designer, JavaScript, HTML, Windows NT, HP Quality Center.

Confidential

Senior BI/BW APO Lead Consultant

Responsibilities:

  • Managed the offshore team and coordinated the Development activities.
  • Worked with the Data Model design for the APO, IB (Installed Base) and APO demand Planning, SNP and Install base Implementations. Worked extensively with Data Warehouse Workbench.
  • Worked with the Transports extensively and Collection of BI objects for transports.
  • Designed and updated the process chains for the daily loads and tuned for optimum load performance.
  • Designed auto scheduling of all process chains through event triggering with limited manual intervention.
  • Created custom ABAP programs to calculate queries in the backend and combined multiple query results to produce single consolidated result.
  • Provided expertise in pioneering feasibility research for integration of products like Crystal Reports, Data Integrator, Data Federator etc. with BI, including Enterprise Portal publication through I Views, emphasized due to Business Objects acquisition by SAP.
  • Created showcase / demo reports in Business Object’s Reporter through Data integrator into finally printable Crystal reports. After successful response of these reports, we incorporated them into the production environment.
  • Created universe objects like Dimensions, Details and Measures, Conditional Objects and Prompts Functions to meet the requirements.
  • Created charts to display summary of the data.
  • Worked with formatted reporting using Visual Composer. Created interactive iviews and published them to portals.

Environment: SAP R/3 Confidential 6.0 SAP BI 7.0,SCM5.0 SAP NetWeaver 2004s, EP 7.0,VC SAP BEx WAD, RADAR, BO, Xcelsius, ABAP/4,Query Designer, JavaScript, HTML, Windows NT

Confidential

Senior BI/BW Lead Consultant (IS-Retail)

Responsibilities:

  • Worked on Production Support Kintannas and fixed those Kintannas as per requirements.
  • Involved in Transportation of all Objects like: Info objects, Query’s and DS objects etc into BI production system after validation and testing the same in development system.
  • Used DSO to stage the data before transferring the DSO contents to the Info Cube
  • Modified start routines, update rules and user exits as per the production Kintannas.
  • Managed & monitored several data loadings and optimized the performance by adjusting Packet Size and data selections.
  • Redesigned the info cubes by using that ABAP program SAP ALL INFOCUBE ANALYSE.Spilt the dimensions into smaller where ever dim data exists more than 10% of fact table. / proposed line item dimension.
  • Created Info spoke based on DSO and pulled into the flat table and DB tables.
  • Worked with end users to gather requirements to design and build the BW application.
  • Prepared the technical specification from functional specification.
  • Wrote ABAP report program with native SQLs to load 13 TODS partitions.
  • Created 8 InfoCubes in Analytical layer to load sales Schedule line data from 13 TODS objects in Integration layer for US, AMER, EMEA, Asia Pacific regions.
  • Wrote transfer routines, start routines and User Exit to lookup master/transaction data and populate key figures and Characteristics.
  • Created Multiprovider upon 8 sales info cube partitions to enable reporting across all regions.
  • Extended the extract structures by adding new fields and populating them with the User Exits.
  • Worked on filing set up table for PO data and then loading into staging server and from there into Integration layer throughout the landscape.
  • Worked on Oracle TOAD to prepare the native SQL and test the performance.

Hire Now