SUMMARY

• Confidential is an SAP Native HANA and BW Architect/Developer. Recently Confidential has converted Confidential BW reporting platform to a Native HANA reporting solution.
• Prior to this project, he has Fourteen years of work experience in SAP BW development and two years of Client - Server design and development.
• Confidential has extensive experience in Native HANA Development, BW with BEX and BOBJ-Tableau reporting, with emphasis on Designing, Developing, testing, performance tuning, code debugging and analysis.
• At Confidential he had the opportunity to implement BW MM structures in a “MAM (Material, Asset and Mechanical)” implementation.
• The implementation included: Inventory, Purchasing, Invoice Verification, Open Order and Movements.
• At Confidential and Logica-CMG performed in the role of Architect and project lead for both of their BW Implementation and Upgrade projects.
• He has 18+ years in Information Technology and has a strong foundation as a systems designer/developer.
• Involved in several full life cycle implementations for different modules in SAP BW like PM, SD, MM, FI-CO, HR, PS and PP which involves all phases like Blue Printing, Requirement analysis, Gap analysis, Realization, Data extraction, Data Modeling, Data loading, Production Support, Testing, Documentation, End user training, Reporting and Go-Live(Production Cutover)
• Extensively built several BW Business Application models( Plant-To-Report, Contract-To-Cash, Acquire-To-Retire, Procure-To-Pay and Hire-To-Retire) to meet the business reporting requirements by defining several BW Objects like Cubes, DSO’s, Multi Providers, Composite Providers, Virtual Providers, Info sources, Data sources, APDs, Open Hub Services and extractors and its enhancements
• Well Experienced in Designing and Building the BW Reports using the BEX components like BEx Analyzer, Query Designer, Web Application Designer, Publishing the reports on Portal and MDX Queries for designing the queries and for creating the workbooks, calculated key figures, restricted key figures, filters, conditions, exceptions and have good knowledge on variables and its processing types
• Well Experienced in architecting the Reporting solutions to fit for the business requirements by using the BOBJ 4.x version with Universes, BI Launch Pad, SAP Business Objects Design Studio Dash boards, WEBI, Crystal Reports and Analysis for Excel
• Well Experienced in working with the BW Upgrades by handling the system migration, Testing and Go-Live(Cutover) activities
• Expert in Designing the Native Hana models to fit for the Business Requirements

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

SAP BW-BO-Hana Solution Architect

Environment: SAP BI 7.4 on HANA, BO 4.1, FI, MM, Hana Design Studio, Tableau

Responsibilities:

• Built Native HANA Tables, Views and Stored Procedures within HANA Studio.
• Designed and built the Purchasing (PUR) and Inventory (INV) Application models in Hana studio to report the Fuel, Material and Mechanical live data from Hana DB.
• Architecting, developing and delivering different complex and critical customer requirement s that includes Design Studio dashboards, reports and interfaces.
• Working on complex Analysis of office Reports and Webi BO Reporting tools connecting from OLAP and Freehand sql sources.
• Created Analytical, Attribute views and Calculation views for reporting requirement on Hana Studio to be accessed by Tableau
• Modeling Procurement Reports - Procurement Spend Analysis
• De-normalizing the Data in HANA Views to be used in multiple Ad-Hoc reports.
• Worked extensively on data extraction tools to get data from different data sources like SAP using SLT and non-SAP data using SAP BODS
• Transporting Models Using Delivery Units /Developer mode within various Environments.
• Created complex Graphical Calculation views(Using Native Hana SQL), stored procedures
• Worked with change management team to promote of Hana views from Dev to QA system
• Working on complex data model for SAP Hana Architecture utilizing calculation, analytical and attribute views. Creating information model (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Designed and Built Composite providers, virtual Providers and Open ODS Views for Fuel stocks MTD, Fuel Invoices
• Worked extensively on complex BODS data migration from SAP, Non SAP and data files.
• Working on SAP BPC integration with SAP BI by creating transformation / package and loading the data in BPC

Confidential, Fort Worth, TX

SAP BW Architect

Environment: SAP BI 7.4 and BO 4.1

Responsibilities:

• Built the BW MM Applications models to meet the business user requirements in the Material domain(Inventory management, Purchasing and Invoice Verification)
• Built several reports on Inventory Management like Fuel MTD Daily, Fuel Invoice Verification and Fuel Excise, Active Plant Report, Slow and Dead stock Report and supplier against shipment discrepancies report.
• Handled the Opening Stock and Closing Stock Scenarios
• Defined the Test cases for the Reports for the UAT Phase
• Handled the Data loading process(setup Tables, Extraction queues, and Delta Queues)
• Built several Reports on Procurement(Material Management -MM)Purchasing Warranty status Visibility Report, Locomotive warranties trigger, warranty related report for supplier scorecard and Require to trace warranty effective by a. Receipt of Material b. Installation Date c. Manufacture date d. Self-life
• Developed the BW n flows standard and customized Procurement-Material Management (MM), Inventory management and Invoice Verification Extractors and enhancement by adding new fields to fulfil the requirement.
• Well experienced with ABAP for all the BW Enhancements/Customizations by writing User Exits.
• Handled the Pre-Cutover and Post Cutover activities including the Hyper-care support

Confidential, Fort Worth, TX

SAP BW Architect

Environment: SAP BI 7.3 and BO 4.0

Responsibilities:

• Was responsible to upgrade the BW systems across the BNSF SAP BW Landscape as per SAP’s Conversion Roadmap, implemented SAP notes.
• Met with Technical Design members to execute the Upgrade and Conversion requirements
• Identified and executed all the Pre-upgrade, upgrade and post upgrade activities
• Handled all the upgrade activities right from the new version7.3 analysis (OSS Notes) the Go-Live (Cutover).
• Identified the functionalities difference between the old version and new version and Implemented and tested all the new functionalities
• Applied all the relevant OSS Notes through the SPAU AND SPDD Process
• Tested all the backend functionalities and reports to make sure that the business logic is not changed in the applications as well as in reports
• Optimized the user exits using the newer version recommended code logic

Confidential, Fort Worth, TX

Sr. SAP BW Consultant

Environment: SAP BI 7.0 and BEX Reporting

Responsibilities:

• Involved in the SAP BI Project implementation of various phases like Business Requirements gathering, Designing Data model, configuration, testing and Project Rollout as per the ASAP Methodology.
• Involved in preparing Functional and Technical Specifications of various applications Domains like FI, SD and HR(PA-OM, Payroll, and E-Recruiting)
• Involved in designing of Architectural Design.
• Configured the SAP BI System as per the Data Model with BI Objects like InfoCubes, Object Data Store, InfoSources, DataSources, InfoObjects, InfoPackages, Transformations and Data Transfer Process.
• Modified standard and created custom InfoSource/DataSource, DSO, InfoCubes and MultiCubes.
• Involved in defining the Staging Process and Tested and rolled out to production the BI objects of FICO.
• Involved in creating Expert Routine, End Routine and Start Routines using ABAP.
• Installed the Business Content Data sources to Extract Data from R/3.
• Worked on daily basis with extractors, generic extractors, LO, FI-SL, Generic DataSources, InfoSources, Transfer Rules, Update Rules, InfoPackages, Variables, calculated KeyFigures and Virtual KeyFigures.
• Met with Functional Design members to determine Technical Design requirements.
• Developed RICEF requirement document.
• Created Detailed Technical design specifications for off shore development.
• Developed detailed Unit Test Plans.
• Created CMOD ABAP code to extend multiple Standard Extractors.
• Implemented CO Standard Extractors via Business Content
• Developed Custom Extractors within CO Extensively worked with PSA in monitoring data transfer from source systems into BI
• Uploaded master and transactional data from flat files, SAP BI and SAP R/3.
• Monitoring periodic data loads from SAP R/3 to BI.
• Involved in preparing Security Authorizations.
• Involved in Project Roll-Out, Documentation and End User Training.

Confidential

SAP BW Consultant

Environment: SAP BW 3.0B and SAP R/3 4.6.

Responsibilities:

• Created InfoObjects, InfoCubes, InfoPackages, and developed Transfer Structure, Communication Structures, Update Rule, and Transfer Rule for InfoSources and ODS objects.
• Designed Aggregates for the InfoCubes for Queries Optimization with respect to performance
• Responsible for identifying business requirements and implementing ASAP methodology.
• Generated reports with replacement path, adjusted exceptions for detailed reporting and designed Exceptions, Variables, Structures, Restricted Key figures.
• Developed flexible queries using filters, Free Characteristics, Navigational attributes to facilitate data analysis in a drill down version to enable the easy access of information at various levels.
• Extracted data from SAP R/3 using LO Cockpit, generic and Business Content Extractors.
• Used Delta Update process for loading the data to BW from R/3 in specific intervals.
• Involved in creating MultiProviders, InfoSets based on requirements and reporting on them using BEx.
• Worked extensively with restricted key figures, calculated KeyFigures and variables to implement various reporting needs.
• Educated users to use standard reports and provided detailed documentation on using different features of reports.

Confidential

SAP BW Consultant

Environment: SAP BW 2.0B & SAP R/3 4.6, ABAP/4

Responsibilities:

• Involved in all phases of Project Life Cycle Implementation from the first phase to Production phase.
• Involved extensively in FICO application domain.
• Involved in designing and implementing the BW System.
• Developed analytical reports by using BEX Analyzer for Data Presentation
• Worked on Query development, Templates and Workbooks in BEx Analyzer.
• Created custom queries using variables.
• Customized reports by writing the User Exits.
• Was responsible for data loads (Daily, Weekly and monthly).
• Involved in resolving Critical Issues

Confidential

SAP BW Consultant (Production Support)

Responsibilities:

• Involved in data loading, Job monitoring and created process chains for automating the process and installed Business Content
• Worked on different update modes for uploading the data from SAP R/3 to BW
• Configured Data sources in R/3 by using LO Cockpit (LBWE), Initialized the setup tables
• Participated in the failures occurred when delta update is going on from one data target to another and Involved in rectification of Database errors and Timestamp errors
• Involved in performance tuning by creating indexes, aggregates
• Checked the consistency of Info Object in RSRV
• Involved in Load Monitoring Using RSPC, RSMO, SM37, and SM50

Confidential

SAP BW Consultant

Responsibilities:

• Data load monitoring through process chains
• Runtime optimization of process chains
• Cater to execute adhoc load requests during close time
• Data reconciliation between sap ecc and sap bw
• Enhancement of Business explorer queries and workbooks
• Involved in performance tuning by creating indexes, aggregates
• Broadcasting of Bex reports to portal and user inbox
• Improved Bex query performances by using various methods like aggregates creation
• Addressed and resolved all the data load failures
• Involved with Basis team to set up load balancing switches between day and night process

Confidential

Programmer Analyst

Responsibilities:

• Involved in from Realization Phase to Production Phase.
• Involved in Analysis and Coding of Sales Domain.
• Involved in testing of the application
• Created various costumed variables and also processed variables with different process types.
• Designing of Front-end Screens.
• Generated financial web reports using Web Wizard.