Post Job Free

Resume

Sign in

Exxon Mobil Bw

Location:
Pawnee, IL
Posted:
May 31, 2022

Contact this candidate

Resume:

Raju Veludandi

SAP certified Application Associate-SAP BW and HANA Work Authorization: US Citizen

Raju Veludandi is a Post graduate engineer and a Certified SAP BIW(2.X, 3.X and 7.x) Consultant with over twenty-two years of IT experience with Twenty one years of SAP experience and twenty years in SAP BW/BI implementations. Over eight years of BOBJ and seven years of HANA experience.

An expert in SAP BW/4HANA BOBJ HANA, LSA++ Architecture, HANA Data modeling, S/4HANA Embedded Analytics, BO Data Services, SLT replication and Visualizations.

Thorough Hands-on experience with SAP HANA Information Modeling including creation of HANA Attribute views, Analytical views, Calculation views, CDS Views, data provisioning using SLT replication and BODS from SAP and non-SAP systems, BI Analytics/Bex Reporting on SAP Cloud Analytics.

An expert in design and development of Executive Dashboards using the latest tools like Visual Composer (V7.X), BOBJ Xcelsius, Dashboard Designer, Lumira and non-SAP tools like Tableau, Power BI.

And expert in performance monitoring and fine tuning the SAP HANA Data models for efficient BI Analytics

Security Specialist with a sound knowledge of standard and Analysis authorizations for design and development of BW security models.

Has a rich work experience in the areas of SAP Logistics (MM, PP, QM, PM, SD), FICO, Project Systems, SRM7.0, CRM7.0 and SPM3.0. An ABAP and SQL guru with expertise in interface application development, BAPI’s, BADI’s, user exits and transformation routine rules.

Experience in all phases of software development life cycle. Well conversant with the ASAP methodologies and Solution Manager for a systematic and strategic BI implementation. Have multiple BW upgrade project experience.

Has worked with fortune five hundred companies like Eli Lilly, MassMutual, Nike, Hewlett Packard, Verizon, Halliburton, Baker Hughes, Exxon Mobil, Raytheon .

Have Public Sector experience with both federal Government agencies like DOD(GFEBS), Defense Logistics Agency and Raytheon, also with state government project like BCM and LAUSD.

Extensive experience in project management, system analysis, design, and development. Excellent communication skills and ability to lead a team as well as work well in a team and manage multiple assignments at the same time.

EDUCATION

MS in Engineering

CERTIFICATION AND ACHIEVEMENTS

SAP certified BW Consultant (000*******).

SAP Certified C_HANAIMP HANA Application Consultant

Presented a white paper on EDW Data Models for SAP BI 7.0 implementations at SAP Teched2008.

Published a technical article on BW Security in one of the well renowned journal BW Expert Online (July/August2004) of WIS Publishers.

SAP HANA Skill Set

Design HANA system/Landscape/Configuration of Packages.

Thorough knowledge in working with the new BW/4HANA systems for creating new ADSO’s, dataflows from Eclipse based BMT tools, business content installation and implementing LSA++ Architecture

Configured the SLT replication server for Data provisioning into SAP HANA from SAP and non-SAP systems.

Worked with Smart Data access to replicate the data from external non-SAP systems

Design of Custom Calc.Views using Graphical and SQL scripts. Good experience with Analytical views, Calculation views using Star joins.

Worked on HANA LIVE Content, HANA LIVE View Browser, HANA Live Extension Assistant. Extended HANA LIVE Views using the HANA Live Extension Assistant

Expert in Performance Tuning and implementing Best Practices for HANA modeling

Installed and worked on HANA LIVE Views for SAP FI-GL, SAP SCM, and HANA LIVE SAP Manufacturing

Lumira /Tableau/WEBI reports and dashboards creation on top of HANA calculation views.

Expert in optimizing HANA views for best performance to reduce data latency, memory consumption and enhance report performance.

Experience with BI Analytics on SAP Cloud Analytics

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.

Experience in the latest HANA 2.0 SPS03 Version.

PROJECT DETAILS

MOOG, NY Aug 2021- Till date

SAP BW Solutions Architect

Involved in the development of SAP BW reports for EMEA and NA regions in the areas of Supply Chain Management. Implemented the Business content for PP module and deployed the BW reports in BW/4HANA. Further delivered the custom BW reports and dashboards for the SCM Business users. The reports delivered the following KPI’s like OTD(Order to Delivery), Past Due Orders, Inventory Levels of In-house products, Output per day per Material Group and by Work centers.

Environment: BW/4HANA 2.0 SP2, BEx and BOBJ 4.2, S/4HANA, FIORI, MM, PP, QM, PM, FICO, SAP Lumira Designer 22.0.1 and Power BI.

Callaway Golf, SanDiego, CA April2021-Aug2021

SAP Embedded Analytics Consultant

Involved in the solution delivery of SCM Demand to Supply Chain Reports from S/4HANA.

Built the CDS views for building the aATP( Advanced Available to Promise) reports for Supply Chain Business Group.

Environment: S/4HANA, BEx and BOBJ, MM, PP, QM, PM, FICO, SAP Lumira Designer 22.0.1 and Tableau2019.1

Axalta Coating Services, GlenMills,PA Jan2020- March2021

SAP BW/4HANA and S/4HANA Embedded Analytics Lead Consultant

Involved in the implementation of SAP S/4HANA and BW/4HANA project for ACS in the capacity of Demand to Supply (DTS) reporting lead.

Participated in the sprint review meetings for requirement gathering and report demos.

Installed the standard out of box Fiori apps in the areas of DTS.

Created the BW/4HANA dataflows complying to LSA++ Architecture and create the desired reports.

Created the CDS views in S/4HANA and BW/4HANA and built BEX reports for consumption and published the same on to the FIORI Launchpad.

Scheduled the daily dataloads using Process Chains (Stream)

Helped the business in doing the fit-gap analysis of the ACS KPI’s with the standard out of box reports from FIORI apps and BI Content reports

Created several BEx and BOBJ reports for the business

Worked on best practice documentation and technical documentation.

Environment: BW/4HANA 2.0 SP2, BEx and BOBJ 4.2, S/4HANA, FIORI, MM, PP, QM, PM, FICO, SAP Lumira Designer 22.0.1 and Tableau2019.1

Ferrara, Chicago, IL April2019-Nov2019

SAP BW HANA Architect

Involved in the Optimization of the BI Analytics reporting and Dashboarding (SAP Lumira and Tableau), Advocating the best practices and documentation strategies, setting up the performance metrics/recordings, remodeling the HANA views for optimum performance, redefining the dashboard definitions with optimum datasources. Optimized the Tactical Production Planning Dashboard from 2min 53sec to 12 seconds. Optimized Strategic Inventory Dashboard from 50sec to 8 seconds. Captured the performance metrics of hundreds of HANA views. Used the BMT tools from Eclipse based HANA(BW/4HANA) for modeling the BW datamodels, Dataflows, Queries and Open Hubs. Worked with Web IDE for HANA modeling. Reporting Using Bex and BOBJ tools. Done ETL using ODP extractions. Worked with SLT on trouble shooting data load issues. Implemented the LSA++ Architecture for BW modeling on BW/4HANA. Worked on S/4HANA Embedded Analytics and CDS Views for FIORI Apps.

Environment: BW/4HANA 2.0 SP2, BEx and BOBJ 4.2, S/4HANA, FICO,MM SAP Lumira Designer 22.0.1, FIORI, Tableau2019.1

RAYTHEON, Dallas, TX July 2017—March2019

SAP BW HANA Lead Consultant

Managed and involved in the Architecture and implementation of LSA++ Architecture for the RMS Purchase Order Reporting, NBI Analytics, MRPA Dashboard and ILS Material Dashboard Projects. Built complex and efficient HANA models for incorporating complex reporting requirements. Optimized performance of the reports by tapering HANA models with Input parameters, appropriate filters/calculations at lower levels and advocated the best practices for HANA modeling across the organization. Designed and built efficient HANA models and IDT Universes, WEBI reports and Lumira Dashboards were built accessing the same. Prototyped the embedded Analytics (Created CDS views and Predictive Analytics) for NBI Analytics. Worked on migrating the data to SAC for BI Analytics.

Environment: BW 7.4 on HANA SP12, BEx and BOBJ 4.2,MM,FI, AP BPC, SAP ECC 6.0, CRM7.0

KARL STORZ, El Segundo, CA May 2016-June 2017

Senior SAP BW/HANA Lead Consultant

Have managed and involved in the North America Service Management (CRM) Project as a Senior BI Analytics Consultant. Responsible for design/development of BI Datamodels/Reporting in the areas of CRM Evaluations, Service to Cash, Inventory Management. Helped in planning the deliverables and estimates. Helped the Basis in providing the sizing of the HANA servers for capacity planning, recommended the best practices for optimum performance of the server and for Analytics. Worked on SLT replication and SDA for data provisioning to SAP HANA from SAP and non-SAP systems (KRONOS). Designed and developed the HANA Views, leveraged the HANA live content and enhanced the same to meet the requirements. Worked on building reports and dashboards using the front-end tools like Tableau, Dashboard Designer and Lumira for Data Visualizations. Helped the project in Go-live and post Go-live activities. Worked on performance tuning of the reports and dashboards out of HANA views.

Environment: BW 7.4 on HANA SP11, MM, SD, FICO SLT, HANA Live, BEx and BOBJ BI4.0, WEBI, FIORI Analytics Office, Tableau, Dashboard Designer, SAP Lumira.

Defense Logistics Agency, Alexandria, VA September2014-March2016

SAP BW HANA Senior Consultant

Involved in the implementation of SAP Fusion Migration projects. Primarily responsible for delivery of Dashboards for OM and Procurement. Played a vital role as a BI HANA modeler in migrating the legacy applications from SAP and non-SAP systems to HANA Studio/BW7.4 on HANA to provide a LSA++ layer for ODBC consumption, upstream distributed applications using OpenHub and reporting using BOBJ tools like WEBI and Tableau/Design Studio. Built and fine-tuned the new and custom reports out of Side Car Implementation from the HANA views, Replicated the data from SAP and non-SAP systems (FUSION) using BODS. Involved in the design, development, testing and validations for the user sign-off.

Environment: BW 7.4 on HANA SP9,MM,SD and FICO, SLT, HANA Live, BOBJ BI4.0, WEBI and Dashboard Designer.

Exxon Mobil, Houston, TX April 2013- August 2014

SAP BW Design Lead

Lead two projects at Exxon Mobil in the capacity of BW design lead.

Involved in the requirement gathering, design and project planning, lead the realization phase and coordinated the documentation efforts to make it a complete project delivery.

Lead the team involving offshore resources in implementing BW CDMS project which deals with the integration of contractor data from non-SAP systems with Plant maintenance and procurement data of SAP.

Lead Plant maintenance and Project to Assets BW implementation for Asia pacific and Europe regions

Delivered over hundred and twenty reports in the areas of Plant maintenance and Project to assets areas.

Co-ordinated with the off-shore resources and delivered the deliverables on time.

Environment: SAP BW 7.3, Bex and Crystal Reports,SAP R/3 ECC 6.0 EHP4, SAP HANA1.0, ABAP, PM, PS, BO BI4, WEBI and Tableau.

LAUSD, LA, CA October2012-April 2013

SAP BW/HANA Architect

LAUSD, the second largest school district of US, implementing SAP to replace the legacy systems. Involved in two projects simultaneously, first one being LRP project which involves BW implementation for LAUSD reporting and the other project is for Downstream processing for different Groups.

Analyzed, identified and implemented the standard Business content in the areas of FICO, PSM and SRM.

Conducted the workshops with the business users and collected functional requirements for the FRDB (Finance Reporting Database Reports).

Designed and documented the Technical documents for the FRDB reports. And lead the BW group to deliver the FRDB reports.

Delivered 120 Standard reports and 16 FRDB reports.

Working with BW 7.3 and HANA 1.0 to define function specifications to architect with tech specs and create history reporting from Funds Management (SAP ECC) and Bonds data from ORACLE (non-ECC).

Configured HANA SAP Landscape Transformation Server and HANA Studio to extract the data from non-SAP systems.

Configured/created ODBO connections and JDBC connections for accessing the information models from SAP HANA for reporting purpose.

Deployed SLT & DXC data provisioning services in replicating data from ECC to HANA.

Involved in setting up SAP BW/HANA Security, created HANA Analytical privileges to restrict access to the specific HANA views.

Environment: SAP NW2004s BW 7.3(SP5), BEx, SAP R/3 ECC 6.0 EHP4, SAP HANA1.0 SP2,ABAP, FI-GL(New),CO, PS, AP,AR SPM 3.0 and SRM7.0,

GFEBS, Department of Defense, Alexandria, VA March2012-October2012

SAP BI Lead Consultant

Involved in the GFEBS BI implementation for Budget Execution of Funds management module for EFD.

Involved in the requirements gathering, built, testing and deployment of the interface and layouts for EFD BI project implementation.

Built the BI data models needed for the delivery of the outbound interfaces for reconciliation of EFD and GFEBS Budget data.

Developed the ABAP function module for the derivation of the EFD line of accounting fields for re-using in multiple transformations.

Developed complex transformations for deriving the results as per the EFD logic.

Created the IP layouts for PBG layouts and AFP CRA layouts.

Involved in the documentation of the Functional and Technical specification documents, Component test plan documents and Test models.

Environment: SAP NW2004s BI 7.03, BOBJ XI 3.1, BOBJ BI 4.0, SAP R/3 ECC 6.0 EHP3, ABAP and FM.

Baker Hughes, Houston, TX October2011-April 2012

SAP BW/HANA Architect

Involved in the implementation of SAP BI/BOBJ project for building an Enterprise Wide Data Warehouse in the areas of Supply chain Management, Order Fulfillment, FI-GL, AP and AR.

Involved in the Assembly Maintenance and Overhaul project for SCM.

Designed the data model for building AMO Dashboard application for various user sites.

Extracted the data from heterogeneous source systems using Data services to build the BW data models.

Built the complex WEBI reports and Xcelsius dashboards for display on TV screens in multiple sites. Established the security to secure the reports by region.

Created a dashboard to display BI Reports Usage metrics to users and managers. Used BOBJ Data Services to extract BOBJ reports statistics from InfoView and Portal.

Worked on the Shipment Costs Details report by building a complex data model extracting the data from different datasets of Shipments, Purchasing and Invoices

Worked on prototyping the HANA solution provide the HFM data integrated with BW Finance data for executive dashboards.

Environment: SAP NW2004s BI 7.02(SP3), BOBJ XI 3.2, BOBJ BI 4.0, Bex and Crystal Reports, Data Services 2.0, SAP R/3 ECC 6.0 EHP3, SAP HANA1.0, ABAP, MM,SPM3.0, PP, QM, PM, PS, HR, SD FI-GL, AP, and AR.

EMC2, Boston, MA October 2010-September2011

SAP BI Lead Consultant

Leading the P2P and R2R groups of Propel-BI team in the global implementation of SAP BI/BOBJ project for building an Enterprise-Wide Data Warehouse.

Involved in the Design and Development phases of the project. Created the project plan based on resources and tasks to have a clear-cut road map to achieve the deliverables on time.

Involved in requirement gathering, preparation of the functional and technical specification documents for the BI reporting in the areas of R2R and P2P.

Leading the efforts of evaluation and estimation of the SPM project implementation, building POC’s and demos.

Conducted the workshops for the business groups, built the prototypes to demonstrate BI/SRM/SPM scenarios.

Worked on the preparation of the enterprise wide BW/BOBJ Security Strategy model.

Advocated the best practices for the BI project implementation.

Helped in the installation and validation of the BI, SRM, and ECC dev systems by applying the appropriate corrections and OSS notes.

Managing and mentoring the onsite and off-shore resources to co-ordinate accomplish the design/development tasks.

Environment: SAP NW2004s BI 7.02(SP3), BW Cont7.05, XT7.05, BOBJ XI R3.1 (SP3), Bex and Crystal Reports,SAP R/3 ECC 6.0, ABAP, SRM 7.0, SPM 2.1, new EHP3 FI-GL, AP, MM, PP, QM, PM,PS, SD.

Baker Hughes, Houston, TX May2010-September2010

SAP BI/BOBJ Lead Architect

Involved in the implementation of SAP BI/BOBJ project for building an Enterprise Wide Data Warehouse in the areas of Supply chain Management, Order Fulfillment, FI-GL, AP and AR.

Involved in the BW Upgrade, requirement gathering, analyzed and installed the needed Business Content, built prototypes for to demonstrate the BI solutions.

Worked on the preparation of the enterprise wide BW/BOBJ Security Strategy model.

Helped in the installation and validation of the BI, SRM, and ECC dev systems by applying the appropriate corrections and OSS notes.

Designed data models to accommodate the ODS layer, PI layer and ADM layers for implementing the EDW datamodels to meet the unknown requirements and to avoid redundancy in different Silos.

Advocated the best practices for the BI project implementation

Customized the data models with several enhancements and modifications to meet the user reporting requirements.

Resolved several data inconsistency issues, fixed profit and loss report, transactional reports by fixing the data model issues.

Improved the reporting performance by feeding the InfoProviders to BI accelerator.

Created new InfoSpaces from BO explorer by feeding the InfoProviders onto BIA using polestar via RSDDV.

Created the OLAP Universes, WEBI reports and Xcelsius Dashboard reports

Improved the WEBI query definitions and worked on advanced analytics to deliver the BOBJ reports.

Stabilized the daily data loads with post go live support, resolving the issues with quick fixes. Optimized the slow/late running daily process chains and automated with email messaging in the event of errors

Conducted the workshops for requirement gathering and for power user training.

Managed and mentoring the onsite and off-shore resources to co-ordinate accomplish the design/development tasks.

Environment: SAP NW2004s BI 7.02(SP3), BOBJ XI 3.2, BOBJ BI 4.0, Bex and Crystal Reports,SAP R/3 ECC 6.0 EHP3, ABAP, MM, PP, QM, PM, CS, SD FI-GL, AP, AR and HR-OM, PA.

Baylor College Of Medicine, Houston, TX Jan2009-April2010

SAP NW 2004s BI and Visualization Architect

Involved in the implementation of BI project for building an Enterprise wide Data Warehouse in the areas of SRM, FI-GL, AP, SPL and HR-OM, PA.

Role:

Responsible for complete implementation of BI project involving Requirement Analysis, Blueprint, Design, Development, Testing, Go-live and post Go-live support.

Enhanced the master data DataSource and transactional datasources to meet the user specific requirements.

Built the generic extractors using function modules and views for extracting the data with complex selection criteria.

Installed and activated the relevant business content that includes complete datamodels, queries and web templates.

Built the process chains and automated data load schedules on daily and weekly basis.

Built the data models for FI-GL, AP, SPL and HR-PA and OM modules. Involved in the customization of the data models to incorporate the reporting requirements.

Designed and developed the Executive dashboards using Visual composer7.0 and Xcelsius 2008.

Designed and developed the BI security model for back-end and front-end access for various levels of the users

Environment: SAP NW2004s BI 7.0(SP17), Bex and Crystal Reports, SAP SRM 5.0, SAP R/3 ECC 6.0, ABAP, FI-GL, AP, SPL and HR-OM, PA.

Honeywell Aerospace, Tempe, AZ Sept07-Dec2008

SAP NW 2004s BI/VC Architect

Involved in the Honeywell BI project implementation to remodel and improve the processes to achieve the excellence of enterprise wide information factory.

Role:

Revamped the data models to comply with EDW, in order to achieve overall system performance, controlled data redundancy, flexibility and scalability.

Avoided the redundant transformations and deployed re-usable objects to reduce the overheads on the CPU. Implemented the BI statistics to facilitate the BI administration cockpit for central monitoring of all the BI processes. Developed the Dashboard applications using Visual Composer to capture the BI metrics.

Interacted with the business users for requirement gathering, collected the business specs and transformed into technical specs. Developed the documentation strategy for an efficient recording of issues/modifications or development of any object in the system environment. Lead the BI development team in the design and development of the reports.

Trained and mentored the support and user groups.

Environment: SAP NW2004s BI 7.0(SP14), SAP R/3 ECC5.0, Enterprise Portals and Visual Composer, ABAP, SD, MM, FICO, EC-PCA and ORACLE 10.2.0.2.0, HP-UX.

SC Johnson & Sons, Racine, WI March07-August2007

SAP NW 2004s BI/VC Lead Consultant

Involved in the implementation of SAP xRPM dashboard Applications using Visual Composer.

Designed and developed the xRPM BI model for the extraction of Portfolio Item Management, Item Capacity and Item Financial Management data into BI.

Role:

Implemented the xRPM Dashboard applications using Visual Composer.

Installed the Business content on xRPM and BW systems and extracted the data from xRPM system to BI 7.0 systems.

Installed the business content xRPM reports and created some custom reports in order to meet the reporting requirements.

Developed the complex dash board applications with various functionalities like eventing, Tab strips, and various other functionalities using the Visual composer.

Implemented the Portfolio Item Management, Item Financial Management and Item Capacity management modules of the xRPM.

Environment: SAP NW2004s BI 7.0(SP11), SAP R/3 ECC5.0, Enterprise Portals and Visual Composer, ABAP, PLM, xRPM and ORACLE 10.2.0.2.0, HP-UX.

Halliburton ESG, Houston, TX June’06-Feb07

SAP NW 2004s BW/BI Senior Consultant

Helped the Energy Supply Group of Halliburton in the capacity of senior BI consultant in the implementation of SAP NW 2004s BI 7 project constituting of supply chain management (SCM) and Suppliers relationship management (SRM).

Role:

Involved in the BW upgrade from BW 3.5 to BI 7.0 in preparation, validation phases.

Analyzed the Business processes and involved in the requirement gathering for meeting the reporting requirements of the SCM and SRM Business.

Identified the necessary Business Content, mapped the business process requirements with the available Business content. Installed and activated the relevant Business content for Master data and transactional data.

Implemented the Purchasing, Inventory management and SD using the LO-cockpit extractions.

Implemented the data extraction process on BI 7.0 that includes installation of the Business content, creating source systems, replicating the datasources and creating data transfer processes(DTP) using the graphical UI provided by new BI 7.0 features.

Developed the web reports (Dashboard) reports for Supply chain management and SRM modules like Turn rates details report, Net Inventory reports, Open Invoices reports, Purchase order history reports and consignment stock reports and aging reports.

Developed complex query definitions involving variables with replacement type and custom exits, CKF’s, RKF’s using the query designer. Created the RRI reports by setting up the sender/receiver parameters in RSBBS.

Developed the workbooks with various templates using the report designer. Created the web templates using the Web application designer and published the reports on the Enterprise portals and Information broadcaster for emailing the reports as PDF files.

Implemented organizational level BI security for accessing reports by appropriate users using the new security concepts of NW2004s BI7 features.

Environment: SAP NW2004s BI 7.0, SAP R/3 Enterprise edition, ABAP, SCM, SRM5.0 MM, SD and ORACLE 10.2.0.2.0, SunOS.

/B/S/H Home Appliances Corporation, Huntington Beach, CA January06-May’06

Senior SAP BW Consultant

Involved in the implementation of SAP BW project in the areas of FI/CO, SD, MM, PM modules. Worked on performance analysis and tuning on the existing system.

Role:

Worked on the design and development of the InfoProviders needed for meeting the reporting requirements in the areas of FICO, SD, MM and PM.

Installed and activated the business content as needed on R/3 and BW systems.

Developed the InfoProviders for Sales orders, Billing, Deliveries, Plant maintenance orders, COPA, Purchasing, Plant maintenance orders and Budget data for plant maintenance.

Enhanced the master data and transaction data standard extractors using user exits and created generic data sources using function modules and views.

Created MultiProviders. Modified and enhanced the current reports to meet the reporting requirements.

Created reports like advanced product availability report, Daily sales report by territory, Vendor confirmations report, Maintenance order report and Plan data by month reports.

Used variables with replacement process, customer exits and calculated key figures and characteristics to handle complex calculations to meet the reporting requirements.

Used Reporting agent to schedule the report execution and deliver the results to the users by email.

Carried out the performance monitoring by using the system tools like ST03N, RSRT and RSRV. Created suitable aggregates and adjusted the OLAP CACHE parameters for a better query performance.

Improved the back-end load performance by refining the data models, running the DB stats, setting the number range buffering’s and by adopting the parallelization techniques.

Environment: SAP NW2004 BI (V3.5), SAP R/3 Enterprise edition, ABAP, FICO, MM, SD and PM, ORACLE 10.2.0.2.0, SunOS.

Verizon Communications Inc., Dallas, TX May’05-Dec’05

Senior SAP BW Lead Consultant

As a team lead of Supply chain solutions (SCS) of Verizon Communications Inc., involved in the implementation of SAP BW for SD, SRM, MM, and FICO modules.

Role:

Primarily responsible for the BW architecture, design and development of the datamodels for extraction of data from legacy systems to BW.

Responsible for requirement gathering, system analysis, hardware sizing, design, development and testing.

Analyzed the requirements and identified the suitable business content for SD, MM, FI/CO and SRM, and had the standard InfoCubes, ODS’s, MultiCubes and various other relevant objects installed and activated.

Implemented the Enterprise data warehouse (EDW) model to achieve flexibility, reliability and to support the corporate strategy.

Customized the standard extractor’s and created additional InfoCubes, ODS’s and MultiProviders in-order to meet the end user reporting requirements.

Carried several manual dataloadings from R/3 to BW for the data integration testing.

Built the Master and transactional process chains and scheduled accordingly to upload the data into InfoProviders with appropriate dependencies.

Developed an efficient error handling mechanisms to alert the failures on time.

Keeping the performance in view partitioned and compressed relevant InfoCubes.

Planning the Go-live with a minimum down time of the OLTP systems.

Developed standard document templates and standard practices for every object that is developed. Mentored the users and support groups on the design, data model and the maintenance of the objects.

Designed and developed the BW security model on the basis of functional area level.

Developed over 150 single roles for R/3 users, over 40 single roles for SRM users and 50 single roles for the BW users using the profile generator (PFCG).

Created composite rules and assigned the roles to users by doing mass user assignments by running CATT scripts.

Designed the R/3 security model on the basis of the classification of the jobs

BW security model is developed on the basis of functional area level, Data sensitivity and the user group levels.

Environment: SAP BW (V3.5), SAP R/3 Enterprise edition, ABAP, DB6, AIX.

Hewlett-Packard, Houston TX Nov’02- April 2005

Senior BW Consultant

As a member of Integrated Global Supply Operations (iGSO) team of HP Services involved in the implementation of SAP BW for EMEA, North America and Latin America.

Role:

Primarily involved in the Business Blue print, realization, Go-live and post Go-live support phases of the project.

Implemented the LO-cockpit extractions for Purchasing, Inventory Management, Sales orders, Billing and Deliveries. Made enhancements to the several transactional and master data datasources using the user exits. Installed the business content for master data and transactional datasources. Enhanced the extractors in the areas of Logistics, FI-AP, AR and G/L. Created several generic datasources (using tables/views and Function modules) for extracting the R/3 data from different tables.

Developed the Master data process chains, Transactional data process chains and Open hub process chains, automated the triggering and monitoring of the same on daily, weekly and monthly basis. Developed an automation program for a third party tool called MAESTRO to trigger and monitor all the process chains and to intimate the failures of any sub processes to the concerned developer via pager.

Developed several BW reports like Vendor information report, Cost saving report, Spend on contract report, lead time performance report, Contract expire



Contact this candidate