SUMMARY

• He is an Enterprise Application Consultant in the SAP Services Practice. He has more than 24 years of experience in leveraging the power of Analytics and Business Intelligence to help clients maximize their current technology investments.
• He is adept in implementing and managing large data warehousing, business intelligence and analytics projects.
• He has been enabling large scale technology enabled business transformation projects using state of the art in - memory, predictive and big data technology which includes HANA, Hadoop, SAP ECC, SAP BW, SAP BPC, SAP SEM, Business Objects, SQL Server, Oracle and DB2.
• Logesh has also managed several SAP Implementations, transitions, rollouts, support and maintenance, upgrades and testing programs with End-to-End Delivery accountability, including SLA-based managed services.
• Also managed from small to large size project team which includes on-site and offshore.
• Logesh has Embedded Analytics in S/4 HANA on 1610 environment, strong analytical skills with experience in finance and manufacturing. Experienced in Virtual Data Model (VDM) development in Core Data Services (CDS), Smart data Access.
• He has been a solution architect in conceptualizing and building solutions end to end that would provide extraordinary insights to various aspects of the business and to facilitate executive decision making for business acquisition, decommissioning and divestures.
• As part of the SAP IT practice within Performance Improvement, Logesh brings a broad understanding of Business Performance Management, Project Management, Change Management, Predictive Modelling, Financial Planning and Budgeting related to SAP and different implementation methodologies. He has proven global experience working in North America, Europe and Asia delivering complex BI projects from cradle to grave.

TECHNICAL SKILLS

SAP Systems: SAP R/3 ECC 6.0, GRC 10.0, Solman and CRM 6.0.

Data Warehousing: BW 7.5 to BW 3.0, BPS 7.0, BW/IP, BPC 10.1 Embeded, BODS 4.2, BW4HANA, Native HANA, S4 Hana and Hadoop.

Reporting Tools: BEx, Business Objects (BOBJ 4.x), Universe, WEBI, SAP Lumira, Fiori, Analytics Office and Crystal Reports 8.0.

Database: HANA 2.0. Oracle 10g/9i/8i/8.0/7.x, DB2, SQL Server 9.0 and Sybase

PROFESSIONAL EXPERIENCE

Confidential, IL

Sr. BW/S4-HANA Technical Lead / BW 7.5, S4 HANA

Responsibilities:

• Involved in requirement gathering of the green field SAP HANA implementation
• Provided solution for various dataflow scenarios
• Followed LSA++ Architecture system
• Data Extracted from multiple sources via PO, S4 HANA and DB Connect
• QAD ERP and SQL based DW system moved to SAP S4 HANA and SAP BW system
• Created HANA Views, CDS views, ADSO and Composite Providers for Information modeling
• Installed business content, data sources and created transport request
• BEx, Analysis for Office, Power BI and Qlikview tools used for reporting

Confidential, Warsaw, IN

Sr. BW/HANA Consultant / BW 7.4, ECC 6.0 HANA 1.0

Responsibilities:

• Participate in requirement gathering sessions to analyze business requirements and discuss with the cross functional/technical teams to gain access to the data and develop the objects/reports.
• Harmonize the data from Non - SAP sources and Develop new tables, Calculation Views, ADSO’s and create the transformations, do the ETL process and report the data in Business Objects/Tableau.
• Creating the schemas and tables in HANA database and load the data from JDE/Manufacturing ECC systems to HANA systems.
• Develop/Enhance the new/existing objects (Calculation Views/ADSO's/Composite Providers) for ETL (Extract, transform & loading) process and automate the ETL process in order to suffice the daily needs.
• Generate HANA views from the BW objects and create hybrid models to report the data in Analysis Office/Business Objects/Tableau.
• Migrating the existing BW (Business Warehouse) objects to HANA models like ADSO/Composite Providers/Calculation Views/re-developing the BW objects/data flows in HANA as per the requirements.
• SLT (System Landscape Transfer) Replication from SAP ECC sources like Manufacturing/ERP systems to Hana database and schedule the jobs to replicate the deltas on daily basis.
• Develop Dashboards/Reports for Sales, Inventory & Finance in Microsoft Analysis Office/ Business Objects Web Intelligence and setup the schedules to broadcast the reports to respective user groups on daily basis.

Confidential, Rockford, MI

Sr. BW/IP Architect / BW 7.4, ECC 6.0, Oracle 12.1

Responsibilities:

• Worked with cross functional team, BW team and basis team for smooth development life cycle process
• Involved in writing functional, technical design specifications and test scripts documents.
• Worked on BW and Integrated Planning (IP) data model design for actual/plan reporting
• Modules supported for Finance, SD, MM, Inventory and 3rd party application such as Logility, PLM etc.
• All the reports were created in BEx and further used in Analysis of Office for reporting
• Interacted with many business users for broadcasting settings, workbook issues which involves lot of VBA
• Worked with basis and change management team for transport and system performance related issues
• Given end user training to run the reports, workbook and to create ad-hoc reports.

Confidential, Torrance, CA

Sr. BW/BPC Consultant / BW 7.5, BPC 10.1, ECC 6.0, BOBJ 4.0, Oracle 12.1

Responsibilities:

• Re-design of SAP New General Ledger data source and customizing the settings
• More than 60 fields were enhanced using a remote Function Module call from BW side
• Create BW data model for reporting and BPC planning using SAP BPC 10.1 Embedded with BW 7.5
• BPC model modified for CAPEX, REVENUE and Financial Planning.
• Analysis of Office extensively used for reporting and planning purposes.
• Expert in loading Master/transaction data to BPC and automate through process chain
• Involved in Sizing estimation, transport and different level of testing using HPQC tool

Confidential, IL

Sr. BW/BPC Consultant / BW 7.4, BPC 10.1, S4 HANA Analytics, ECC 6.0, BOBJ 4.0

Responsibilities:

• Data modeling and enhancement for OTC, Inventory and Finance
• Business support for BPC modeling Capital, Cost Center, Finance and HR Planning
• Experience in BPC configuration of Model, Analysis of Office tool, Work status and Security
• Created Real time cube, Aggregation level, filters, fox formula and planning function.
• Extensive use of APD for pushing data between BW and BPC Model
• Created Audit report for all the critical ECC data source models
• Proficient in HANA modeling using Attribute View, Analytic View, Calculation View using SQL Scripting.
• Responsible for writing functional and technical design specifications.
• Proficient in developing Composite Providers, advanced DSO and using Query in Analysis Office tool.
• Experience in using tools such as Charm, ALM for incident management and transport.
• Experienced in trouble shooting, debugging, Performance tuning and coordination with business users

Confidential, IL

BW/HANA Architect / BW 7.4, IBP, HANA 1.0, BODS 4.2

Responsibilities:

• Involved in BW upgrade from 7.3 to 7.4, BODS upgrade from 4.1 to 4.2 and ECC SP upgrade
• Involved in BW on HANA Cloud migration
• Production support activities for data load monitoring through job controlling tool called TIDAL
• Resolving business user issues, colleting new requirement and developing enhancement projects
• Bringing non-SAP data to BW via BODS and building HANA Views for reporting
• BW Modeling using Open ODS, ADSO and Composite Providers.
• IBP tool used for developing General Ledger, Cost Center and Profit Center accounting.
• Office Analysis tool was used for business user reporting purpose
• Involved in HANA Architecture during cloud migration and worked closely with infra-structure team.
• Managing system performance across different HANA nodes, monitor system resource utilization, identify and tune expensive SQL statement. Troubleshoot system performance issues.
• Experienced in End user training, trouble shooting, debugging, Performance tuning and coordination between business users and development team

Confidential, CA

BW/IP/HANA Architect / BW 7.3, S4 HANA Analytics, BOBJ 4.1 and SAP GRC 10.0

Responsibilities:

• Managed SCE data warehousing project such as ECMS, BAM-CCM and Teradata Hadoop migration.
• Involved in requirement gathering workshop session for moving the data from Teradata to HANA and Hadoop environment
• Used ITSM remedy tool for access order creation, software request and ticket handling for support activities
• Interaction with business stakeholder for new projects initiatives, requirement gathering, estimation, architecture design and enhancements of existing projects.
• Designed and developed Cost Center, Capital Expense and GL Planning using RSPLAN - Integrated Planning
• Developed copy function for multiple versioning based on planning cycle, data slice used for locking the data.
• Planning application was accessed via Analysis Office tool
• Worked with security team to create multiple HANA privileges roles.
• Developed Information Model for Calculation views, Analytic views using Stored Procedure in HANA.
• Manage transports of objects in HANA using Export/Import, delivery units.
• Involved in unit/integration and user acceptance testing, coordinated with change management and release management team for production go-live and support.

Confidential, CA

HANA Architect / BW 7.3, HANA 1.0, BOBJ 4.1 and SAP ECC 6.0,

Responsibilities:

• Gathered and analyzed the requirement to replicate the ECC content in HANA studio using data provisioning.
• Created Technical specifications and standard modeling documents for Native HANA.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in Native HANA.
• Data Provisioning using SLT for information models of COPA, Material Movement and Logistics tables.
• Customer and Material Hierarchy created to view the reports. Also Input parameter, calculated columns and restricted columns created to view the data.
• Involved in BW HANA migration for Pre-Activity, Pre-Validation and Post-Activity.
• SAP Architect activities including sizing, configuration, HANA administration, technical consulting and team leadership activities
• Created user, roles and security privileges model with proper naming convention in HANA.
• Established the recommended SAP best practices for developing Universes, reports from HANA data sources.
• Developed Webi reports for different COPA, Inventory KPI's on top of HANA model
• SAP Lumira reports created using Geo Graphic, Column Chart, Pie Chart and published in cloud.

Confidential, MD

Sr. BW/TPM Architect / CRM 7.0, SAP ECC 6.0, BI 7.3, BOBJ 4.0

Responsibilities:

• Working as BI/BPS architect for Data Model design, Layout design.
• Worked on Head Quarter Planning for Target Rate and Target Volume Planning
• Demand Planning and List Price value where read from other sources.
• Integration with CRM-TPM system for planning and master data extraction
• Created Functional Spec document and Detailed Design document
• BPS objects involved Planning Area, Characteristic relationship, Planning layouts, functions, planning profiles.
• Logic implemented to handle 4 decimal issues for expense types.
• Worked on Dispute Case, Fund Posting, Claim and Work Flow data model
• Created write-optimized DSO, real time Infocube, basic cube and multi providers
• BEx and WEBI reports created for Promotion Summary, Checkbook, Balance and Payment report
• Created transport request, end user training, Production support and KT document.

Confidential, NJ

Sr. BW/TPM Architect / CRM 7.0, SAP ECC 6.0, BI 7.3, BPC 10.0, BOBJ 4.0

Responsibilities:

• Working as BI/BPS/BPC architect for Data Model design, Layout design for multiple regions
• Integration with CRM-TPM system for planning and master data extraction
• Created Functional Spec document and Detailed Design document
• BPS objects involved Planning Area, Characteristic relationship, Planning layouts, functions, planning profiles.
• Sales Planning, Budget Planning and Trade Volume planning was done through BPC 10.0.
• BPC Budget plan data was fed into CRM-TPM for budget allocation by fund ID level.
• Worked on Dispute Case, Fund Posting, Claim and Work Flow data model
• Created write-optimized DSO, real time Infocube, basic cube and multi providers
• Created Universe, Webi reports for Sales Vs. Plan, COPA-Revenue and Accrual Balance.
• Created Process chain and transport, also installed BI content, data sources.

Confidential

Sr. BI Architect / SAP ECC 6.0, BI 7.3, IP.

Responsibilities:

• BI Production support for Finance, Logistics, MM, Inventory modules
• Daily data load activities, User interaction, Function release and Regression testing every quarter,
• Handling enhancement and small to medium size projects.
• Job Load was monitored by Control-M tool.
• Handling tools such as Remedy, Qlik View, Quality Center
• Support activities for finance reports such as Account Payable, Receivable, Balance sheet, Profit & Loss.
• Procure to Pay, Order to cash, Inventory and Goods Movement were handled
• Supporting Integrated Planning application for sales planning and revenue planning data.
• Divestiture process adopted in BW system by removing data model and data because of few unites were separated.

Confidential, CA

Sr. SAP BW Lead Consultant / SAP ECC 6.0, BI 7.0, Oracle 10.2.

Responsibilities:

• Worked in the Financial Planning Production support environment for more than 100 users.
• Support and Development activities in BW for Finance, SD - Order to Cash and PP- Procure to Pay.
• Finance related development for COPA, Journal Entry, Cash Plan, Internal Order and Consolidation.
• Involved logistics development for Sales Order, Invoice, Shipping, Billing and Delivery.
• Process Chain monitoring for By Title, Ultimate, AR/AP, Product costing, Collection management, Information broadcasting, period end closing, month end closing etc.
• Involved in New Enhancement, Production support, Delta load related issue and BEx issues.
• Planning for Profit/Loss, Balance Sheet and Cash item was done thro flat file upload using ABAP.
• Journal Entry, Budget Costing, Actual Costing and custom extraction was performed.
• Worked on Business Consolidation (ECCS).
• Experience in bundling the job, Currency Translation, Validation, Inter Company Elimination and extract ECCS data to BW for reporting purpose.
• ITSM and Quality Center tool was used to tract the defect and solving the issue.
• Charm application (Solution manager) was used for transport management system
• Involved in Unit testing, regression testing, integration testing and UAT.

Confidential, IL

Sr. SAP BW/BPS/TPM Consultant / SAP ECC 6.0, BI 7.0, CRM 6.0, Oracle 10.2.

Responsibilities:

• Involved in BW design for data modeling, Cube design for AOP and TFM.
• Worked on Release 6 AOP (Annual Operation Plan) project, which feeds baseline data to TPM.
• Worked in multiple sub-plans covering TPM, TFM and TCM.
• Worked on TPM module for various planning, which include basic layout, extended layout, planning profile.
• Created AOP Planning, Trade Promotion, IFR and Live Rate for the Trade Promotion Management system.
• Web Interface builder was used for user interaction to access BPS Layout and Function.
• Extensive use of BW-BPS features covering Variables, Multi-planning Areas, Data Slices, Planning Folders, Global Planning Sequences, User Exits, Functional Modules, ABAP, FOX formulas.
• Development of Planning functions, Parameter Groups (formula, Copy and exit function).
• Function Modules was created for deriving Change Log, Year Calculation, reading data from cubes using Characteristics Relationship.
• Extensively worked on extended layouts, Calculated KF, Function etc.
• PMDC, List Price testing, Configuration Rationale for various functionality were developed.
• Excel upload was done thro BPS using ABAP and BSP application.

Confidential, CO

Sr. SAP BI-IP Consultant / SAP ECC/HR 5.0, BI 7.0, MS-SQL 9.0.

Responsibilities:

• Payroll and Benefit data were extracted from R3 using BI Content and Generic Datasource.
• IMS database data was extracted from MVS operating system which was running on IBM machine and loaded to Oracle database which was using SAP system.
• ETL job was done for master and Transaction data extraction from ECC
• Built complex logics in Transfer rule and Update rule for validation purpose.
• Data model was designed using extended star-schema design for Dental, Health, Life, ST Disability, Medicare and PERA benefits using different cubes for better performance.
• WBS and Work Order master data was enhanced in R3 to have the status and employee home cost center was assigned if the status was closed during Payroll data loading.
• Used BI-IP (Integrated Planning features covering Aggregation level, filters, packages, functions, input template, sequences. Carried out allocations, distribution, copy, reposting, delete in Benefit Allocation Planning
• Created Web Planning Layouts in BI-IP using Input Ready Query and Web Application
• Created Input queries, Reports, complex FOX Formulas, and various Planning Objects.
• Function Modules was created for deriving G/L Accounts, Last Changed on, Last Changed by using Characteristics Relationship.
• All the BI-IP Functionality was executed thro Process Chain with Bundle Execute steps.
• Created Process Chains and Meta Chain for Selective deletion from Transaction Cube.
• All the final version data were retracted back to R3 using custom retraction program.
• BEx reports and web reports were created for different types of end users.
• Coordinated with basis team for Transport, Sizing estimation and performance related issues.
• Involved in various testing, end user training, production support and documentation.

Confidential, NJ.

Sr. SAP BW Consultant / SAP ECC 6.0, BPS 3.2/BI 7.0, Oracle 10g and UNIX

Responsibilities:

• Application Evolve 4 developed for Medical Devices and Diagnostics related companies called DePuy - J&J.
• Involved in the Business Process Requirement, Business Reporting Requirement and OASIS (Organized Approach for Supporting Information Systems) methodology was followed to implement the project.
• Cost Center, Capital, Revenue, COGS, OI&E, Management Adjustment &Balance sheet Planning were created.
• Contractor, Headcount Planning were created for difference cost center and cost element level.
• Created Cost center, internal order and Profit center Retraction and comparing plan / actual data in R3.
• Foreground and background copies for round to round, versions to final and version-to-version functions were created and it was called thro Function Module for various benefits.
• Data slice, Variables, Attributes and Hierarchies were extensively used.
• Planning data was copied to different versions for rolling plan and it was actualized for specific months based on the rolling plan period.
• Z tables maintained for currency rate, types to execute currency conversion for Ex-US companies.
• Reports, Workbooks created on Actual versus Plan and Plan versus Plan comparison for Cost Center, Balance Sheet, Recon reports for CCA, PCA & COPA.
• Dashboard Headcount and Contractor reports for version-to-version, round to round comparison were created.
• Involved in Production support for maintaining variables, copying data and fixing specific issues for many companies worldwide. Created BW/BPS transport using solution manager.
• Involved in assisting security team for creating roles and authorization and test used ID’s were tested.
• Users were given options to execute planning functions in foreground mode.
• Unit and Integration testing was done by using test script developed by team.

Confidential

Sr. SAP BW/TPM Consultant / SAP R/3 4.6c, CRM 5.0, BW/BPS 3.5, BI 7.0, Oracle 9i.

Responsibilities:

• Multiple sub-plans covering Trade Promotion, Commercial, Financial, Pricing and Costs.
• Created Account Planning, Trade Promotion, Target Group and Baseline Volume Planning for the Trade Promotion Management system.
• IMG Settings for Key Figure and Profile configuration in CRM system to access the BPS layouts.
• Extensive use of BW-BPS features covering Variables, Multi-planning Areas, Data Slices, Planning Folders, Global Planning Sequences, User Exits, Functional Modules, ABAP, FOX formulas.
• Development of Planning functions, Parameter Groups (formula, Copy, Distribution, and Forecast etc).
• Extensively worked on extended layouts, Calculated KF, Function etc.
• BW design covered data modeling, Cube design and development of characteristics and key figures
• ETL task, Data Loading, Monitoring, Solving Init & Delta issues for R3 and CRM extraction.
• Price List, Master data and Hierarchy data sources are extracted from different CRM sources.
• Created Process Chains, Meta Chain, Transports, Master Data management, R3 Extraction and Enhancement.
• Aggregates, Cube Compression were done to improve the performance.
• Involved in upgrade from BW 3.5 to BI 7.0 and OSS notes were applied for so many issues.
• Performed all the pre/post upgrade technical tasks when upgrading from BW 3.5 to BI 7.0