KISHORE MACHA

Cell: 717-***-**** email: ad1h2d@r.postjobfree.com linkedin: linkedin.com/in/kishore-macha-2814201

Summary

●Sr. SAP BW Hana Principal Lead, Reporting and Data Analytics Principal Architect with over 19 years of technical/functional experience in design, development and implementation of enterprise business applications, data base administration and end-user training services.

●18+ years of strong ETL experience in SAP Business Information Warehouse with hands-on experience in BW4H, BWoH 7.5/7.4, BW 7.3/7.0/3.5, BOBJ/Analysis for Office (A4O), BODS, SEM BPS, IP, APO, SAP R/3 and ABAP programming.

●Hands-on experience in BW (7.5) on HANA - Eclipse modeling tool, Analytics for OLAP, BOBJ – Design Studio, webi reporting. ABAP – writing complex routines, user exits, and function modules.

●Good knowledge of various processes in ASAP and SDLC (System Development Life Cycle) and proficient in star schema and multi-dimensional modeling. Involved in all categories of SAP technical development objects – RICEF.

●Involved in multiple upgrades and full life cycle implementations, including requirements gathering & analysis, data modeling, extraction, loading (full/delta upload), monitoring, InfoCubes, composite providers, DSO/ODS, multiproviders and reporting.

●Experience in native HANA and BW on HANA – building calculation views, composite providers using joins & unions, open ODS view and ADSO. BI Integrated Planning (IP) to build planning applications in SAP.

●Excellent knowledge in data modeling (multidimensional modeling), using extended star schema modeling and reporting tools like BOBJ, BEx query designer, Analyzer, Analysis for Office (A4O), web reports (WAD) and dashboard reporting.

●Worked in offshore/onshore model and efficiently managed virtual/offshore team, assigning and managing individual responsibilities – ensuring key deliverables and achieving overall productivity.

●Extensively worked on SAP R/3 Logical Information System, LO-Cockpit, CO-PA, FI-GL and different modules like FI/CO, FI-AP, FI-AR, FI-SL, SD, PM, MM, WM and PP.

●Front End Report Generation-Worked extensively in BEx analyzer creating queries, workbooks, custom queries using exit variables and created aggregates for frequently used queries, worked on jump queries, RRI, web reporting using Web Application Designer, dashboards, and involved in training and knowledge transfer to end users.

●Quick learner with an ability to rapidly achieve organizational integration, assimilate job requirements and employ new ideas, concepts, methods, and technologies. Adaptive and highly motivated in agile environments.

●Excellent communication, interpersonal, intuitive, technical, analysis and leadership skills. Thrive in both independent and collaborative work environments.

TECHNICAL SKILLS:

ERP: SAP BW4H, BW on HANA 7.5 (on HANA)/7.3/7.0 BW 3.5, 3.1, BPC, SEM BPS, IP, APO, BEx Query Designer/Analyzer, SAP ECC 6.0, ABAP/4, SAP Automation, BO DataServices 4.2

Operating Systems: Windows NT, XP, Vista, UNIX.

Languages: ABAP, SQL, ASP, HTML scripting

Databases: Oracle, SQL Server, MS Access,

Reporting Tools: Business Objects BOBJ 4.2, A4O, MSTR, Tableau, Crystal Reports

Others: WAD (Web Application Designer), ITS, Design Studio, HTML

PROFESSIONAL EXPERIENCES:

Client: HPE, Houston, TX Feb ’22 – June ‘23

Role: Sr. SAP BW4H Principal Consultant

Responsibilities:

●Responsible for the architecture, design, and development of Analytic reporting solution for HPE BW4H landscape.

●Analysis of legacy EAP application and design and rebuild the same in B4H environment to build reporting solution for non SAP applications.

●Conversion of business logic into transformations in BW, developed aDSOs for staging layer and Composite providers for reporting layer.

●Migration of S4 AO reports on CDS views into B4H for Finance and Consolidation using calculation views, table functions to store data at aggregation level for better performance during query execution.

●Worked on performance tuning for ETL data loads using transformations with complex routines and optimized performance for reporting.

●Enabled upload interface for users to upload data/files into BW and going through transformation logic for reporting.

●Managed and coordinated onsite and offshore team for development and support activities for analytics and reporting applications.

●Created HANA data models using calculation views for financial reporting – GL Balance Sheet and Consolidation reporting.

●Worked on creating calculated columns in HANA views with complex logic, currency conversion, table functions.

●Developed reports/workbooks using AO and Business Objects (BO) webi reports.

●Supported BPC with SAC for consolidation process for month-end closings.

●Successfully executed UAT test scripts for business sign-off before go-live.

●Ensure smooth transports import into production for go-live and support during hyper-care of production applications.

Environment: SAP BW4 7.5, HANA 2.0 SPS12, BPC RTC, SAP S4, and Windows 10.

Client: Chevron, San Ramon, CA Feb ’21 – Jan ’22

Role: Sr. SAP BW4H Migration Lead

Responsibilities:

●Lead BW4H migration project at Chevron Corp to migrate BW landscape from 7.3 version to BW4H 2.0. Over 60,000 objects were included as part of migration.

●Our team was responsible for pre and post conversion activities and supporting SAP tool during remote conversion to migrate metadata and data into new BW4H landscape.

●Identify key milestones and plan project execution to achieve as per planned dates.

●Plan, manage and lead testing efforts, troubleshooting and debug solutions.

●Re-design and development of new data models that are not compatible with BW4H such as NOP/NO1 keyfigures, APDs, Virtual providers etc.

●Support for shell conversion of metadata for Process chains and BEX queries.

●Error analysis and resolution during conversion of BW objects.

●Enabling datasources for ODP extraction.

●Analysis of readiness_check_report and modifying objects in sender system as part of system prep.

●Validation of metadata and data between sender and target systems by executing process chains and BEX/AO reports.

Environment: SAP BW 7.3, BW4HANA 2.0 SPS4, SAP ECC 6.17, and Windows 10.

Client: Campbell Soups, Camden, NJ Dec ’19 – Feb’21

Role: Sr. SAP BWoH Tech Lead

Responsibilities:

●Solution designed and implemented BI integration project to integrate Snyder Lance data into Campbell SAP landscape.

●Worked with business and functional team to understand requirements and prepare high level technical documents (HLDs) as part of the project prep.

●Involved in technical development objects – reports, interfaces, conversions, and enhancements of BW objects.

●Designed and developed data models to integrate legacy SL data into BW landscape to enable APO planning based on actuals.

●Created outbound data models to combine actuals from BW and forecasted data from APO into reporting layer to support Campbells MTS reporting.

●Created different workflows, flat file uploads for BOM explosion logic using function module in ABAP, process chains etc.

●Co-ordinated unit testing, UAT and regression testing in multiple BW environments to ensure smooth go-live.

●Responsible for planning cutover and ensure that solution changes are transported / implemented into production environments without unintended impact on business units.

Environment: SAP BWoH 2.0 SPS4, SAP ECC 6.17, and Windows 10.

Client: Teva Pharm, North Wales, PA Oct ’18 – Oct '19

Role: Sr. SAP BW4HANA Lead

Responsibilities:

●As Enterprise BW HANA lead for Commercial and Financial reporting applications, successfully implemented BI reporting platform for US roll-out.

●Responsible for development, testing and production implementation of 60 plus BI reports for Commercial and Financial reporting.

●Develop, test, debug and implement analytic solutions for all business processes in SAP BW systems integrating with SAP and non-SAP source systems.

●Worked closely with business users to understand their requirements and create functional/technical specification documents. Enhanced some of the existing reporting functionalities from legacy reports.

●Analyzed data from Flex system which has over 90 plus tables to interpret and build complex data models and provide information on on-time and delayed Rebate payments.

●Proposed solutions to improve system efficiencies and reduce overall project costs by presenting data and conclusions to the team.

●Worked on multiple schemas and expose data from BW objects like ADSOs to create calculation views for further data analysis by merging with data from other boundary systems.

●Implemented BOBJ – webi and A4O (Analysis for Office) reporting for the Commercial business including chargeback and rebate processing which processes over 500 thousand transactions per day.

●Involved in testing, validation and post go-live support for quarter close, supporting financial reporting in the area of FI-GL/AP/AR.

●Reporting data from boundary systems using combination of SDI and flat-file loading data models.

●Created several calculated views - graphical and SQL script from boundary systems for Flex and PriceRight applications. Developed ADSOs, composite providers, BEx queries, BO - webi and Analysis for Office (A4O) reports.

●Coordinated with offshore team in development of BW objects and tracking of several processes for timely execution and meeting the deadlines for successful go-live.

Environment: SAP BWoH 7.5, SAP HANA Studio 1.0, SAP ECC 6.17, BEx, A4O, BOBJ 4.2, and Windows 10.

Client: Pfizer, Collegeville, PA Jan ’11 – Oct ‘18

Role: Sr. SAP BI/HANA Solutions Lead Architect

Responsibilities:

●Designed solutions and implemented multiple projects in the area of Finance and enhancement of BI applications which helped in taking business critical decisions efficiently.

●Involved in BI on HANA (7.5) upgrade project by testing, documenting and ensuring consistency of several BW objects across landscapes.

●As part of solutions team, worked with business users and performed requirements gathering, understand, analyze, and document the requirements into functional specifications.

●Developed interfaces using SAP HANA views to pull data from SQL Server and Oracle database into SAP BI. Built calculation views, ADSOs, open ODS views and composite providers in HANA studio and reports using Design Studio for employee spending limit application.

●Built planning models using BI Integrated Planning (IP) to deliver reports for Cash Forecasting.

●Created open hubs to export data from BI into external edge systems. Created ETL jobs in BODS.

●Implemented Global Reporting project to integrate several Oracle and E1 markets providing access to global, standardized management reports.

●Support and Maintain BI system performance, integrity and reliability by performing activities including Monitoring and Tuning performance, data loads process chains, BI logs

●Executed the GRAPH project in multiple agile sprints - scheduling, coordinating, and allocating multiple tasks to various team members and ensuring the sprints are successful.

●Integrated non-SAP data (Oracle & E1) on SAP BI platform combining financial data onto a single reporting platform with new analytic capabilities to drive greater business insights.

●Designed and developed Sales Channel solution for US Sterile Injectable business as part of Hospira Integration project including chargebacks coming from third party tool (CDH) into BI.

●Worked in reporting tools – Analysis for OLAP for ad-hoc reporting and BOBJ reports using BEx queries as datasource. Delivered a suite of webi reports with standard and custom templates based on business requirements.

●Was part of implementing and executing highly prioritized Contemporaneous Data Collection application and successfully delivered complex data models to produce BI reports that segment balance sheet into separate Business Units across 300 legal entities and over 500 GL accounts.

●Enhanced Special Ledger extractor to incorporate GL accounting and customer information to deliver One Ledger reporting to the users.

●Designed, developed and implemented Parallel Trade application for intercompany sales in BI for International markets to calculate revenues based on internal trade.

●Developed and enhanced several Financial reports supporting Finance One using complex solutions like user exit variables, replacement path variable etc. Created various restricted and calculated keyfigures to implement the solution.

●Responsible for the enhancement of FI_AR application in BI, modify datasource to improve performance and bring in new data for user required fields.

●Supported in the design and development of IP applications for budget and forecast analysis.

●Deployed suite of BOBJ – WEBi reports for Finance One application using BEx queries, hierarchies, list of values (LOVs), local variables with complex filters and customized formulas.

●Supported and developed Tableau workbooks to create QTD, YTD and comparison reports for sales and revenue reporting.

●Proficient in ABAP – enhanced extractors in ECC, writing users exits and customized data model using start routine, end routine and created function modules to offer customized solutions and fulfill user requirements.

●Worked on re-design of the entire Flash Sales application to accommodate new user requests and improve the performance of the entire data model.

●Supported BI upgrade projects from 7.0 to 7.3 to 7.5, involved in testing BI objects for pre/post upgrade, log the test results and defects in HP ALM etc.

●Worked on Analysis Process Designer (APD) to extract BEx query results and write back to direct update DSO for Finance One application to enable further analysis of the data.

●Worked on the design and development of Purchase Order detail and Accrual report. Enhancement of existing PO reports to bring in new fields from ECC.

●Responsible for cycle testing and integration testing in different environments using HP ALM tool. Writing and executing test scripts and test cases, recording and fixing defects.

●Designed, and developed Volume Variance application for Finance for budgeting and adjustments analysis.

●Created design documents and functional/technical specification documents.

●Lead and managed development activities and coordinating with off-shore team.

●Worked on the development and enhancement of BI datasources in ECC.

●Designed and developed BW objects and reports. Created QC test scripts, executed in multiple environments with the users.

Environment: SAP BI 7.5/7.3/7.0, SAP ECC 6.0, BEx, BOBJ Design Studio, AO and Windows XP pro.

Client: Johnson & Johnson, Skillman, NJ Apr ’10 – Jan ’11

Role: Sr. SAP BI Lead Consultant

Responsibilities:

●Designed, developed and executed SLOB (Slow moving and Obsolete Inventory) reporting solution for multiple divisions of J&J consumer products and McNeil Pharma.

●Worked closely with Business Analyst (BUI team) to transform business requirements into functional specifications and then into technical specification documents.

●Designed the data model and created new DSOs and reporting Infocube for SLOB reports.

●Developed some of the complex reports with high performance which includes numerous key figures for reporting which gives total inventory, expired & short dated inventory, inventory greater than forecast, slow moving inventory, SLOB quantity and SLOB $ value - enabling the users to estimate the total SLOB value and reserve their stock levels for appropriate planning.

●Different pieces of information was put together in single report to display actual inventory, restricted & unrestricted inventory, and apply against forecast which will enable the financial analysts to make decisions in appropriate bookings and forecast.

●Created numerous calculated and restricted key figures to calculate the $$ values in the query for various quantity key figures.

Environment: SAP BI 7.01, SAP ECC 6.0, BEx Query Designer, APO and Windows Vista Pro.

Client: Infineum Chemicals, Linden, NJ Jun ’05 – Apr’ 10

Role: Sr. SAP BI Solutions Architect

Responsibilities:

●Worked and implemented multiple end to end projects to measure various metrics like Global Supply Chain, Plant Maintenance, PRISM, Finance, Sales & Marketing, Forecasting, Purchasing, etc.

●Worked on front end technical design and development for multiple projects using BEx query designer and Web Application Designer. Worked on the dashboard design and development for measuring various metrics in Business Warehouse. Implemented the traffic lights for the dashboards to measure the metrics at a single glance.

●Involved in the design, development and delivery of the vast Global Supply Chain dashboard and reporting which included measuring various metrics involving Sales & Distribution, Procurement, Inventory and Finance.

●Worked on the implementation of Plant Maintenance (PM) dashboard in BW which includes designing the data model, creating custom extractors using generic extraction, configuring SAP standard business content extractors using CMOD, creating reports using BEx and web reports.

●Created datasources to extract data from Oracle database for non SAP plants and merging SAP data in BW for reporting.

●Created and delivered maintenance cost, maintenance operations and preventive maintenance analytic reports and dashboard reports in plant maintenance.

●Designed and implemented the procurement dashboard with traffic lights display. Delivered different metrics in procurement like purchase requisitions, purchase orders, good receipt & invoicing and planning & inventory.

●Worked on creating the Finance Corporate Performance Dashboard including reports in Accounts Payables, Accounts Receivables and General Ledger. Developed dashboards using BOBJ xcelsius and widgets to be displayed on the Finance portal.

●Worked on the development of Pricing and evaluation tool – PRISM, to properly appraise the product value. End reports were delivered using Visual Composer.

●Enhanced the reporting capabilities using Business Objects reports for dashboard and analytic reporting.

●Used Business Objects Developer Suite (Publisher View, CMC, Universe Designer, and InfoView) to perform various tasks specific to a component.

●Created standard BOBJ universe and WebI reports.

●Involved in extensive UAT testing in QA environment and provided post go-live and support for various applications in production environment.

●Sound knowledge of BI upgrade and support packs (3.x/7.0). Responsible for conducting pre and post upgrade checks and confirming changes and validating authorizations during BW upgrade from 3.x to 7.0. Troubleshot issues port upgrade, activating objects/transformations.

●Worked on SEM BPS to create various planning applications for finance dashboard. Created planning areas, planning levels & functions and web interface with multiple tabs for the BPS layout.

●Worked on archiving the historical finance data by partitioning the cube for better performance of the finance and fixed cost cubes.

●Worked on the Capacity Utilization and Material Balance Cube for SNP, created data source from live cache and created BW lite objects. Extracted the data from APO into BW and reporting using BEx and WAD. Created various SNP and DP reports like Percent Plant Utilization, Forecast Accuracy Vs Actual Sales etc.

●Extensively worked on creating web templates for web reporting using Web Application Designer, and created complex queries in BEx query designer and views.

●Created dashboards with traffic lights for various applications to analyze different metrics in BW.

●Created Customer exit variables for BEx reporting to automize the reports through reporting agent and download scheduler, personalized variables.

●Created different Variable Processing Types like Manual Entry / Default Value, Replacement Path, Customer Exits, SAP Exit, Authorization. Created different types of variables using the variable wizard for defining more flexible reports.

●Created global structures, local structures and cell definition.

●Worked on the BW DQA modeling and reporting and BW statistics

●Done Heavy Performance tuning by creating aggregates, repairing indexes, compression and re-model the design etc.

Environment: SAP BI 7.0/BW 3.5/3.1C, SAP ECC 6.0, BEx Query Designer/Analyzer, WAD, BPS, CRM, APO and Windows XP Pro.

EDUCATION:

●BS in Computer Science Engineering Year 2000.

Contact this candidate